Category Archives: VISIBILITY

Phil 9.12.13

8:00 – 11:30 SR

  • Backups
  • Deployed new RA
    • Need to add a dialog that shows the amount of time estimated for the query (average? Min/max?)
    • Need to be able to get budgets with respect to Capability, Reqs or Projects depending on the context
    • Need to be able to click on a query result line and go to the project. If multiple projects fit the criteria, all are listed in a dialog and the desired can be selected from that
    • Add tooltip to save/load query datagrid
    • Queries by individual capability – underfunded
    • Queries by individual appropriation – underfunded
    • Add the name of the query to the QueryBuilder titlebar
    • Incorrect total for committed. May be from COGNOS
    • Add a Requisition Amount column
    • Adding a column (Appropriation?) breaks the query
    • Incorrect Obligation Outlay goal (Runs on the budget center total rather than the Req total)

11:30 – 6:00 FP

  • Started to run analysis on the Phantom and Headset results. The Phantom results are promising, but not significant. I need to get more data and/or figure out a way of pulling off confounding data.
  • The headset data is somewhat more straightforward, if not a little dull. It turns out that in the pilot study, the ability to determine location of voice or tone with a 4-speaker headset is not that accurate, and degrades pretty linearly as the number of source go up. Not exactly an earth-shattering result.
  • Need to get the spaces out from the csv output. THe space causes the Open Office Calc to read in the data as a string and not a number.
  • Need to cause the headset app and the Phantom app to exit after writing out the file. Restarting ensures that the recorded data will be clean. There was a bug where old data was being kept between sessions on the headset code that subsequently had to be filtered out by hand.
  • Ran Dimitri through the Phantom for his second pass. Looking at how he handled the system makes me thing that there is an “expert” level of training that most of the other test subjects haven’t attained. I wonder if that makes the results more clean? Need to examine further.

Dong Shin 09.11.2013

  • bugs from Carla for RA
    • Date DFAS Paid for the invoice changes the month (adding by one)
    • add “Edit” Invoice
  • reworked FA for meeting tomorrow
    • fixed some bugs not parsing queries correctly
    • reworked the queries for Chris
      • not sure if TST and non-TST’s should be separated for the overdue queries
    • added appropriation
  • working on Obligation/Outlay update script in VSS

Phil 9.11.13

8:00 – 10:00 SR

  • Backups
  • One of Carla’s users thinks that they have found a bug in RA. They would also like an “Edit” button in addition to the “Remove” button
  • Pat is having some bugs with query builder where redundant information appears to be getting returned. She also ran into the missing where clause bug.
  • The “Create Req” panel needs tooltips and searchable comboboxes.

10:00 – 5:00 FP

  • gathering results

Dong Shin 09.09.2013

  • working on Query Builder
  • working on importing Obligations/Outlays from COGNOS
    • set up VisibilityScriptingServer
      • change project_portfolio to project_portfolio_enh in visibility.properties
      • updated pom.xml to generate VisibilityScriptingServer-1.0.jar
      • rebuilt with the latest code
    • created sample xlsx data for Obligated and Outlay data
    • saved following queries in VSS – get_cognos_outlays and get_cognos_obligations
    • query to get monthly outlay data – 59958230400 is for 1900-01-01 dates which should be ignored
      • SELECT sub_budget_center, requisition_id,
        MONTH(committed_date), YEAR(committed_date)
        committed_date, SUM(committed_amount)
        FROM `contracts_cognos`
        WHERE to_seconds(committed_date) > 59958230400
        GROUP BY sub_budget_center, requisition_id, MONTH(committed_date), YEAR(committed_date)
        ORDER BY sub_budget_center, requisition_id, YEAR(committed_date), MONTH(committed_date)
    • query to get monthly obligation data
      • SELECT sub_budget_center, requisition_id,
        MONTH(obligation_date), YEAR(obligation_date)
        committed_date, SUM(obligated_amount)
        FROM `contracts_cognos`
        WHERE to_seconds(obligation_date) > 59958230400
        GROUP BY sub_budget_center, requisition_id, MONTH(obligation_date), YEAR(obligation_date)
        ORDER BY sub_budget_center, requisition_id, YEAR(obligation_date), MONTH(obligation_date)

Phil 9.9.13

8:00 – 11:00 SR

  • Backups
  • Fixed the workforce db issue
  • Pat wants an appropriations column for Query Builder
  • Tangie and Carla are going to give demos to some customers later this week and need a walkthrough of Req Asst.

11:00 – 4:00 FP

  • Brought in my Mac Mini. Going to try for Boot Camp and win7.
  • Time to experiment on Dong.

Dong Shin 09.06.2013

  • new FA4 deployed, more bugs
    • fixed Financial Data not showing for multiple Req’s
    • removed chart from Summary Data
    • wrap components in FinancialDataPanel with <s:Scroller /> to get all the components
    • resize datagrid to eliminate vertical scrollers
  • working on Query Builder
    • reworked __view_project_totals so that it includes all total_budgets from budget_centers table
    • created view __view_sub_budget_center_totals for TST
    • fixed WHERE and GROUP BY not parsed properly in Query Builder

Phil 9.6.13

8:00 – 12:00 SR

  • Backups
  • Deployed new FA4
    • Add “Close” to query save panel
    • Rows in req panel are too tall
    • Need search inside req panel
    • Sum the Req allocation by sub-budget center. GROUP BY dispersal after running, but is saved in the description?
    • Status should be “Due” between now and the 10th.
    • Obligation and outlay uploads still need to be enabled
  • Paperwork. Particularly need to fix the workforce location DB entries.

Dong Shin 09.05.2013

  • deployed new FA4, some bugs
  • fixed total_budget as Currency – TOTAL regex added
  • removed the charts from Financial Data Viewer – performance should be lot better
  • created ServerLogPanel and LocalLogPanel that are draggable and resizable and moved out of main canvas
  • changed references to budget_center.total_budget to t.total_budget in the Query Builder queries to correct obligations and outlays
  • added support for column names with spaces in Query Builder – wrap it with a single quote ‘

Phil 9.5.13

8:00 – 10:30SR

  • Backups
  • Meeting with Lenny
  • Deployed FA4 for testing. Bugs follow:
    • total_budget in query builder needs to be formatted as currency
    • Expand columns in total grid to accommodate $999,999,000.00
    • System hangs when loading financial data viewer
    • Can’t move the server log panel or local log panel
    • budget_center.total_budget -> t.total_budget

10:30 – 4:00 FP

  • Downloaded several wav files of sinewave tones, ranging from 100hz to 1,000hz. The files are created using this generator, and are 0.5 sec in length.
  • Glued the tactor actuators in place, since they kept on coming loose during the testing
  • Fixed the file output
    • Each test result is now ordered
    • Fixed a bug where the number of targets and the number of goals were not being recorded
    • Added a listing of the audio files used in the experiment.
  • Got some initial results based on my self-testing today: firstResults

 

Dong Shin 09.04.2013

  • deployed new FA (Flex 4.5!), found some bugs
    • fixed logout not clearing panels
    • fixed Total Allocated not showing
    • change the name of the Flex App – FinancialAssistant4
  • continue working on Query Builder
    • created a view to pre-set the project totals for the queries – __view_project_totals
    • fixed group by errors when loading saved queries…

Phil 9.4.13

8:30 – 11:30 SR

  • Backups
  • Deployed new FA
  • Clear login info
  • combobox left edge is not showing in columns
  • Column width should be smarter
  • Total budget in FA is orders of magnitude too high in the new query
  • Project allocated on the project page is zero.

11:30 – 4:30 FP

  • Got the electronics boxed up last night: IMG_2192
  • Need to add “practice mode that lets the user try a setup with a srand(date) and the ability to choose the feedback mode – done
  • Fixed my buggy  sensor