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.

Mike 4.12.2011

  • Finished the conversation / comment UI which is based primarily on the discussion UI in google docs.
  • Tied it in to the reporting tool in a fairly basic way.  Users can now comment / discuss on ReportNodes for now.  Commenting on images, tables, sections of text and other things will come later as the basic functionality is in.
  • Commented on a few sections in a report, successfully saved it off and loaded it back up.

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.

Mike 4.7.2011

Working on the commenting system

  • Have conversations (string of comments relating to a single thing) and comments storing in the database
  • Opening a report pulls the corresponding comments from the database
  • working on the GUI for creating, viewing and editing comments within a report
  • Helped buy and install 2 TVs

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

Tom.DeVito 4.5.2011

Arduino Audio Controller:

  • Realized that some of my methods would cause strange behavior on collisions as currently designed.
  • Combined volume up and volume down function so that you only need to send a positive or negative value for the second byte.
  • Realized that sending two bytes is bad and it may be better to change the way its sent so that it reflects address/data in one byte.
  • Amplifier is not working at the moment.  Might have missed something when changing it over to work with the Arduino.

MISC:

  • Deployed new version of PPM to fgmdev.com
  • Deployed website and webapps for visibilty.fgm.com
  • Packaged webapp zip files with windows installer
  • Got server running.  Need to use sudo su to activate and deactivate tomcat.  It would probably have been better to install tomcat with aptitude but I wanted this server to reflect fgmdev.