Category Archives: VISIBILITY

Phil 4.26.2011

7:30 – 4:30 VISIBILITY

  • When I went in for my meeting with Trish and Christie, I found that Trish had called in sick. We will have to reschedule. Did talk to Christie a bit.
  • Somehow managed to blow away my firefox cache and spent a while trying to put that together again.
  • Tried logging in again with PuTTY – no luck. Tried to contact Alan Neff, but he was not in yet. Will have to pick this up again later today.
  • Tested Dong’s PPM code and promptly broke it. It’s a knack 🙂
  • Went back to the customer, but was unable to connect with Allan N.

Dong Shin 04.25.2011

  • PPM Changes
    • trouble-shooting search on Contracts Window
      • throws exception at very same place every time
      • Error: Error #2006: The supplied index is out of bounds.
      • description about N66001-03-D-7002
      • added try catch, still throws exceptions, but behaves better……
    • removed Amount in Contracts sections in Excel export – keep Contract Amount
    • added SOW Window to view and edit long SOW’s for Funding Request

Phil 4.25.11

7:30 – 4:30 VISIBILITY

  • Multi-factor, within subject widget today – done
  • Adding roles to whitepaper – done
  • Tried to log into the new server. No luck. Brian did too, and couldn’t get in. It may have been that our accounts had not been activated?

Dong Shin 04.22.2011

  • Went over the bugs list in the blog, updated status of fixed ones
  • More memory on FGMDEV!
  • PPM Changes
    • Period of Performance Dates and Obligation Date Deadline not required
    • DateFields can be cleared by Control-Click on the same date
    • added columns to search on Contracts window
    • added toolTips to Contracts Window
    • set the ContractsDataGrid’s max rowCount to 20
    • added AmountTextInput for Contract Amount

Phil 4.22.11

7:30 – 4:30 VISIBILITY

  • Happy Earth Day!
  • Here’s the list of additional items from Christie
    • On the Financial Data Request (the Monthly Status Report), under the Contract information — “Amount” can be removed – it is the same thing as “Contract Amount”. One will suffice.
    • Where is the “pilot data” you used for the example of the Update Financial Data Request (The Monthly Status Report)? We just want to be sure that the request form is pulling the correct data.
  • Added new items to the PPM list and the Bug Tracker. Also, fixed the statuses of the bugs that I submitted on Wednesday from ‘closed’ to ‘new’
  • I have a server account and password!
  • Talked to Trish. She, Christie and I will meet Tuesday at 8:00

Dong Shin 04.21.2011

  • PPM Changes
    • added FY, Description, Appropriation, Funding Type to Funding Request Select window
    • removed contract checking on Direct Cites so that contracts are not required and can be added/changed later
    • fixed a bug Outlay Amount not showing up correctly in Direct Cites
    • Project Information (Project Number, Title, Budget) added to Funding Request

Phil 4.21.11

8:00 – 5:00 VISIBILITY

  • Dong’s back! Going over Christie’s list
  • Got a few more items yesterday that I’ll have to add later. Also, I tried doing the same thing that caused the remote object error and everything worked fine. Curious.
  • Can no longer reach the enclave drives from the Edge server. Asked the new admin if that could re-enabled. It’s not a show stopper, since I can move zipped backup files to a web directory and pull them down to my local machine that way.
  • Built the digital picture fame holder for Brian.
  • List of data visualization tools: http://www.computerworld.com/s/article/9214755/Image_gallery_22_free_tools_for_data_visualization_and_analysis
  • Finished up multiple measures one-way ANOVA and added contrasts
  • Went over how to add editing to Mike’s app. Decided that the best combination of simplicity and usability would be to have popup editors for sections.

Phil 4.20.11

7:30 – 3:00 VISIBILITY

  • Here’s Christie’s list from yesterday
    • Had a remote object fault where a send failed – Channel.Connect.Failed error – this happens when trying to “Create a Funding Request”. So that error has re-occurred.
    • When changes are made in the “Financial Status” data (i.e. Enter and save comments in a line). The updated entries do not save. For instance, I save the comments, return to the line and the comments I saved are no longer there.
    • When modifying a “Funding Request” and selecting a funding request to modify, we should be able to select a funding request based on the FY, Description, Appropriation and Funding Request Type. (i.e. MIPR, FAD, EA) – we don’t need to know the creator or mailing address
    • When entering information in Tab 3 (Finance Data), we should not be forced to add contract information as we often times do not receive this information until later. We should have the ability to enter what we can.
    • On Tab 2 (Funding Request Details) we should not be forced to enter the Period of Performance or the Obligation Deadline date. We should have the flexibility to fill this information in at a later date as well. In other words, all dates should have the ability to be left blank – we should not be forced to enter something just for the sake of entering something. It is much easier to go back and update when you see a blank space, than when you just put in any date
    • The “Search” feature under Tab 3 (Finance Data) for the purpose of selecting a contract is not working and all of the contracts are not available to select. The contract options run to the end of the screen and you cannot scroll down to view the other contracts.
    • Many of the SOWs are very lengthy. Not sure what, if anything can be done about that.
    • When creating a Funding Request, you must select the project. However, once you are actually in the Funding request, it does not state anywhere, which project you have selected. Suggest displaying the name of the project and the FY
    • Has the classification tool been discussed? Much of the exec summary is marked (S) and normally any funding information in marked (TS).

Phil 4.19.11

7:30 – 4:30VISIBILITY

  • More repeated measures math confusion for today!
  • Updated variance object to store strings without choking
  • Showed Jared how to use MavenAssist
  • Got repeated measures working, after futzing with a lot of parsing issues
  • Try to upload some data to the server today? Nope, but did get in and talk to Bill. Brian also worked with Denise a bit to get me my admin account. In addition, Christie sent a list of bugs for PPM that I need to enter.

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.