Category Archives: Projects

Phil 4.18.11

7:30 – 5:30 VISIBILITY

  • Going to try the Kestrel today – see if the knee is up to it.
  • Testing new PPM
  • Add Brian’s comments to whitepaper
  • Demo of Visibility to Mike F.
  • Figuring out Repeated Measures math.

Phil 4.15.11

7:30 – 5:30 VISIBILITY

  • Afternoon semi-scheduled meeting with Brian, Bill D., and Denise P.
  • General clean up and bug fixing. Need to revisit the Power Wizard. There is a problem when calculating group size. Also, I really need to parse the result
  • Mike F. Would like a demo of visibility.fgm.com. Had to fix my role permissions, but now everything seems to be working OK. Meeting is now scheduled for Monday at 1:30
  • Showed Mike how to kickstart his bike

Phil4.14.11

8:00 – 4:30 VISIBILITY

  • Xray and ultrasound at 1:45
  • Talked to Dong about the Scripting engine a bit. He’s going to take a look at a Jython tutorial. Also, showed him how to disable the “import” censor
  • Finishing up MANOVA – done. Not much in the way of graphics…. Need to poke around the web
  • Cleaning up makeTable()
  • Pinged Trish, who is still busy. She asked me to stop until she sends an email stating that she’s looked at the printout.
  • Got approval for getting an admin account. Next step? Also had a nice chat with Denise Price.
  • Walked though desktop manager stuff with Mike

Dong Shin 04.13.2011

  • working on SQL queries to retrieve the financial data via scripting interface… This query will retrieve all financial data with calculated goals value and checks if data is less than the goals
    • SELECT p.uid as 'Project ID', p.project_number, b.uid as 'Budget Center ID', b.center_number,
b.appropriation, a.uid, a.year, a.amount, o.uid, o.year_count, o.month_1, o.year, o.type,
IF (o.type like '%Outlay%', (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100) as goal_month_1,
IF (o.month_1 < IF (o.type like '%Outlay%', (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100), 'FLAG', 'OK') as flag_month_1,

IF (o.type like '%Outlay%', (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100) as goal_month_2,
IF (o.month_2 < IF (o.type like '%Outlay%', (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100), 'FLAG', 'OK') as flag_month_21,

IF (o.type like '%Outlay%', (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100) as goal_month_3,
IF (o.month_3 < IF (o.type like '%Outlay%', (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100), 'FLAG', 'OK') as flag_month_3,

IF (o.type like '%Outlay%', (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100) as goal_month_4,
IF (o.month_4 < IF (o.type like '%Outlay%', (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100), 'FLAG', 'OK') as flag_month_4,

IF (o.type like '%Outlay%', (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100) as goal_month_5,
IF (o.month_5 < IF (o.type like '%Outlay%', (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100), 'FLAG', 'OK') as flag_month_5,

IF (o.type like '%Outlay%', (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100) as goal_month_6,
IF (o.month_6 < IF (o.type like '%Outlay%', (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100), 'FLAG', 'OK') as flag_month_6,

IF (o.type like '%Outlay%', (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100) as goal_month_7,
IF (o.month_7 < IF (o.type like '%Outlay%', (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100), 'FLAG', 'OK') as flag_month_7,

IF (o.type like '%Outlay%', (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100) as goal_month_8,
IF (o.month_8 < IF (o.type like '%Outlay%', (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100), 'FLAG', 'OK') as flag_month_8,

IF (o.type like '%Outlay%', (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100) as goal_month_9,
IF (o.month_9 < IF (o.type like '%Outlay%', (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100), 'FLAG', 'OK') as flag_month_9,

IF (o.type like '%Outlay%', (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100) as goal_month_10,
IF (o.month_10 < IF (o.type like '%Outlay%', (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100), 'FLAG', 'OK') as flag_month_10,

IF (o.type like '%Outlay%', (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100) as goal_month_11,
IF (o.month_11 < IF (o.type like '%Outlay%', (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100), 'FLAG', 'OK') as flag_month_11,

IF (o.type like '%Outlay%', (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100) as goal_month_12,
IF (o.month_12 < IF (o.type like '%Outlay%', (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100), 'FLAG', 'OK') as flag_month_12

FROM projects p, budget_centers b, budget_amounts a, obligations_outlays o, obligations_outlays_goals g
WHERE p.uid = b.project_id AND b.uid = a.budget_center_id AND b.uid = o.funding_id
AND b.appropriation = g.appropriation AND g.year = year_count AND a.year = g.year
ORDER BY b.uid, a.year, o.year

Phil 4.13.11

7:30 – 6:00 VISIBILITY

  • Still sick, but better.
  • Restructuring type I and type II marginal means to behave more like contrasts. Not sure if this will work or not. It didn’t.
  • Building the MANOVA widget
  • Added some one-click test data
  • Meeting with Trish. Put off for another day
  • Got pinged about my admin account request. Responded that I was still waiting.
  • Talked to Jeff about getting on his servers.

Tom.DeVito 4.12.2011

Arduino Sound Controller:

  • Amplifier working with SOMO as audio source
  • For some reason, volume down wasn’t always working.  In the sandbox it only worked when I made it and else if.  When I moved things over to the SOMO sandbox, it only worked as a standard if statement.  There may be something else that I didn’t realize I changed in the transition.
  • Using Anvil Studios to produce tones.  Experimented with the controls a bit.

MISC:

  • Moved phone to Phil’s office.
  • Connected Walter ‘s phone.
  • Took down insulation on windows.

Phil 4.12.11

7:30 – 3:30 VISIBILITY

  • Still got this cold. But now it’s out of my lungs and in my head. Wheee!
  • Meeting with (who?) at S33P to talk about email system(?)
    • Trish didn’t have the time or focus to look at the spreadshjeet in detail, but she said that she would look at it tomorrow and reply with comments in an email.
  • Interview with Terry

Phil 4.11.11

7:30 – 3:30 VISIBILITY

  • Playing phone tag with John P. About admin accounts. He also called about some data that they added to the VISIBILITY data stream that may not be showing up. Since there’s no contract there any more, I couldn’t help much.
  • Finished up the power and effect size calculations in the Power Wizard
  • Lunch for Sophia, who started today. She might also be helping Dong with report-building queries.

Dong Shin 04.11.2011

  • Demo’ed and went over high-level architectures of Visibility and PPM with Sophia
  • PPM
    • bugs found when I was going over PPM with Sophia
      • exceptions thrown at Create Financial Data Request – fixed
      • Project Delete stuck in endless loop – fixed
    • Exporting contract to XLS files – working! more testing needed

Phil 4.8.11

7:30 – 4:30 VISIBILITY

  • Got a cold. Ick.
  • Working on a way to get exact p out of the qf function in R
  • Done! Below is my first function in R
function(calcF, dfNum, dfDenom, limit = 0.001, iter=100){

 alpha = 1;
 oldAlpha = 1;
 step = 0.5;

 for(i in 1:iter){
 newCritF = qf(alpha, dfNum, dfDenom, lower.tail = F);    
 #show(c(alpha, newCritF, calcF-newCritF, step));

 newDiff = calcF - newCritF;
 if(abs(newDiff) < limit){
 return (alpha);
 }
 if(newCritF > calcF){
 alpha = oldAlpha;
 step = step * 0.5;
 }

 oldAlpha = alpha;
 alpha = alpha-step;
 }

 return(alpha);
}

Tom.DeVito 4.7.2011

Arduino Sound Controller:

  • Got the amplifier working.  There were a couple wiring problems, need to look at the diagram better next time.
  • Used oscillator chip to test the amplifier.  Speakers seem to peak out much lower then advertised.  Oscillator frequencies may not work as well as actual sounds since this is a speaker as opposed to a buzzer.
  • HIGH_SIGNAL(high resistance) may be out of range.  Does not seem to be consistent when I decrease the Volume.
  • Step speed is good.  It should not be a problem to send it varying step commands quickly during collisions.
  • Will try it with the SOMO tomorrow.

Phil 4.7.11

7:30 – 7:00 VISIBILITY

  • Meeting with Trish and Christie. Trish wants the following:
    • All rows from the Financial Entry tables, including the obligation and outlay goals, and percentages
    • Contract information
    • Trish asked if the online version would be available in 30 days. I said that it was likely that we would be on the test platform in 30, but probably not on the production server
    • Trish has more requests, but they are waiting until these actions are finished and approved
    • We missed this mailing. The next will be the first of May.
  • Went over the new requests with Dong, who will now “not be bored”
  • Finishing up white paper – done
  • Requested more space on fgmdev