Category Archives: Phil

Phil 3.25.15

8:00 – 5:00 SR

  • Set up Mark’s accounts
  • Set up an admin account for our tester. Not sure if that’s actually needed?
  • Brought over the latest and greatest for Bill to scan. Should be ready for testing tomorrow.
  • Finish integrating Chartinfo class into testbed. Done, but more of an adventure than I was expecting. First, my development box began acting weird (fan noises, flickering graphics, slow performance). Then it BSOD’d. When I finally got it back up, the debugger kept on getting confused about comments. Once that was sorted, I couldn’t get picking to work on area charts, even though it worked fine for everything else. That traced back to a null value for the component name, which is an explicit test I run to manage tooltips. So once the name from the ChartInfo item was loaded into the glComponent, everything began working correctly. Sheesh.
  • Tried to get my laptop again and also a replacement workstation, since this one is now suspect.
  • Running CC

Phil 3.24.15

8:00 – 4:30 SR

  • Lenny’s out for the week. Going to coordinate with Don and Mike(?) for the time being.
  • Need to set up cluster and stacked barcharts. I think it’s mostly a size and offset issue, so there need to be multiple arrays. Since area charts and bar charts pretty much use the same raw data, I think I’ll make a data object that contains the needed data. That can be set by a server call and passed in regardless of the chart type. Cluster bar charts are just offset by the index times the width. The width in turn is the spacing divided by the number of columns and clusters.
  • It strikes me that if we have enough problems having hardware rendering, that we can use raytracing. Either in the server (povray), or using the threejs raytracer. There is no THREE.RaytracingRenderer in definitelyTyped though.
  • Found a bug while making sure that the software rendering looks ok (it does). Fixed. The OrbitControls were resetting the camera origin. I just needed to not set OrbitControls if the scene is not dynamic.
  • Added ChartInfo class that stores all the numbers for a bar chart or area chart. Compiles, will test tomorrow.
  • Burned a disk containing the newest threejs for Bill.

Phil 3.23.15

8:00 – 10:00, 12:00- 5:00 SR

  • Snow flurries are predicted for tomorrow. Some start to spring, huh?
  • Deployed new FR. All seems to be working.
  • Pinged our potential new servers. They respond in half the time and are farther away. I mean like Georgia, I think.
  • Adding bar charts. Once that works, I’ll try to figure out where all the code should go. I also need to talk to Dong about hooking up to a data source.
  • Bar charts are in and working. Need to set them up for ortho2 rendering.

Phil 3.20.15

7:00 – 4:00 SR

  • Still working on the lab problem. I’m using the roll of a six-sided dice to represent labs. Here’s the issue.
    • For an even distribution over a set of options, the probability of an event converges nicely: EvenDistribution
    • A random distribution converges, but not so nicely: RandomDistribution
    • Loaded dice also converge, but in a different way: LoadedDice
    • The question is, how do I tell that the difference between 1 and 2 is acceptable, but that the difference between 2 and 3 isn’t? Also very important is how many “rolls” do you need before you can say that the dice is loaded one way or another? I was looking at Chi Squares, but that doesn’t seem to be right. Currently looking at Binomial Distributions.
    • Ok, it looks like Binomial Distributions are what we want. Here’s what it looks like:BinomialTail
    • In the chart, probabilities accumulate for the first 100 rolls, and then a cumulative binomial distribution is calculated where at least one success happens in the next ten trials. The excel function that does this is:
      • =1-BINOM.DIST(<successes-1>,<trial number starting at 2>, <calculated probability>, TRUE)
    • Note that the probability of a future even sums to more than 100%. This is because the probability of one face coming up at least once in the next ten trials is pretty independent of the other faces, so they get added together. That being said, the differences between the likelihoods remains consistent until they go asymptotic at 100%. This is a pretty good indicator of how far out in the future a prediction can be made. In this case, it looks like 5-15 trials in the future before the high values converge. Note though that the very low values (F5 and F6,which were near zero) still do not have a significant impact on the outcome in this time horizon. So the ability to project into the future is strongly dependent on how spread out the initial probabilities are when the binomial calculations are invoked.

Phil 3.19.15

8:00 – 4:30 SR

  • Worked out a way to calculate the liklihood that a lab will be able to spend it’s money based on past performance. I think it can also be primed with an arbitrary distribution. Need to think about that.
  • Area Charts
    • Added an option to render fastest, which may be needed for Canvas Rendering. Transparency works in SW, which is nice.
    • Adding a method to add to or set the z offset.
    • Added gridlines. Getting close to tying all the pieces together.

nurb-ish

Phil 3.18.15

8:00 – 4:00 SR

  • No problems with the new FR. Testing to begin Friday?
  • Need to look into JIT manufacturing process control as possible way of managing labs
  • The current goal is to see how trustworthy labs are WRT spending their funds to target. It turns out, I have an equation for that 🙂
  • Added behavior callback to CanvasClasses and ComponentClasses. It also seems to have fixed my weird ts error in Webstorm.
    • Tested and working.
  • Adding tooltip data points to track the top line of the chart, including when the chart is animating. – done

Progress for today:

nurb-ish

Phil 3.16.15

8:00 – 5:00 SR

  • deployed new FR. Still tweaking.
  • Continuing with charts. My end triangles are not drawing properly yet. D’oh! Stepping by 1 rather than 2 for a triangle strip. And the backface is backward. Both fixed.
  • Adding a cylindrical z component to the chart. Want to compare this to a bevel
    • Spent too much time on this – projection of a cylinder onto a plane is y = sqrt(r*r – x*x)
  • Will probably go for a spherical projection with bevels (z = sqrt(r*r – x*x -y*y)). Working on procedural generation of arbitrary meshes. Done!

nurb-ish

Phil 3.13.15

8:30 – 4:00 SR

  • Create Capability by appropriation chart for testing
  • Adding Apache POI to the JavaUtils project. Boy, that turned out odd. The JarFileContainer project hadn’t been checked into SVN yet, so after adding POI11 to the jar file, I did. It uploaded correctly, but when trying to sunchronize the directory, SVN decided that JarFileContainer needed THE ENTIRE Java_Folders DIRECTORY. Which is completely insane. Wound up uploading manually. Seems to be working now.
  • Built a fake data generator and populated the spending_test table for charting.
  • Starting on building the area chart component. Got a simple mesh built. Good start.

Phil 3.12.15

8:00 – 6:00

  • Deployed new FR and worked with the DB
  • Added SW rendering as a selectable option
  • Added highlighting and selecting to Canvas and Components
  • Discovered how to cast in TypeScript. Note that this is only for compile phase: 
    var m:THREE.MeshPhongMaterial = <THREE.MeshPhongMaterial>obj3d.material;
  • Tested highlighting in 2d and 3D. Discovered a few use cases where the selected model can get set to null while manipulating the eyepoint and had to fix those.
  • Was going to deploy to my server for testing, but I realized this app needs a database. Started the process, but now it’s got to cook for a while.
  • Lenny wants spreadsheet export, possibly with formulas.
    • Added capability to DbTypedTable to work with multiple sheets.

Phil 3.11.15

8:00 – 4:00 SR

  • Having a bunch of issues with the on site Firefox. WebGl was working but the browser would black out other screens. Now that’s fixed, and WebGL won’t run.
  • Added xcopy . \xampp\htdocs\experiments\WglCharts1 /s /d /y /exclude:excludeFile to the Makefile as the deploy: task. Now all new files are uploaded to the apache directory for testing as part of the build.
  • Need to implement software rendering fallback – done. Had to add common methods/vars (setClearColor(), autoClear)
  • Need to get 2D running – done
  • Got Lenny’s initial chart. It’s capability by appropriation, with the PMAs and FACTS as bars with Outlay goals and Planned outlays as shaded areas. Probably a rolling six month window.

Phil 3.10.15

8:00 – 4:00 SR

  • Wound up passing a callback function from the glController into the queryController so that the data array that’s used to create shapes is called at the end of the retrieval process. Communication with the queryController should be able to go through bound variables?
  • And in case that doesn’t work. Here’s a good source for communication between Angular components.

Phil 3.9.15

8:00 – 4:00 SR

  • Deployed the new FR. Progress, but still not there yet.
  • FF still broken
  • Still no keys for Webstorm
  • Copying over work from home.
  • Started to integrate the graphics and query apps under the assumption that multiple controllers can work and play well together.
  • Wound up passing a callback function from the glController into the queryController so that the data array that’s used to create shapes is called at the end of the retrieval process. Communication with the queryController should be able to go through bound variables?
  • And in case that doesn’t work. Here’s a good source for communication between Angular components.

Phil 3.6.15

7:30 – 3:30 SR

  • Surprisingly, the 10″ of snow that fell yesterday is still there.
  • Setting up the charting project. I’m going to leave AngularThreeTS untouched and just copy it over. I’m expecting the WebGL classes to still change while I work on these components. Once done though, it will go into the libraries with the WebGL directive? Not sure about that yet…
  • A really nice explanation of SQL joins.\
  • Working on the classes to return typed data from queries to the charts. Can’t do trending without knowing what’s a date. Updated FileUtils DbTypedTable with toString() and toExcel()
  • Copied over the AngularThreeTS directory. Now I need to pull in the query parts from iRevdb.
  • Verified that CanvasBase.removeModel still works.
  • Added a minimum set of query capability. Right now, it’s in a separate htmls page, but I should be able to integrate pretty soon.

Phil 3.5.15

7:30 – 4:30 SR

  • Create data to chart!
  • Reply to Chris’ email for recording twitter data – done
  • Create chart db – done.
  • Create statement table with rank and count. Save as insert into text, fix formatting in file before loading
  • make sure that textures, lines, reflections and skybox works (WebGLModuleTest)
    • There were a few things missing and some issues with how lines get handled, but everything pretty much patched in correctly. Running code is here (for now…)
  • Create new project with db access. Basically blinddb with WebGL div. Call it WebGlCharting1