Monthly Archives: October 2011

Tom DeVito 10.6.2011

Start: 9:00am

  • Finished wiring all the components together.
  • Grouped up and routed the wires so it is more obvious where wires go if they get disconnected as well as reduce clutter.
  • Not sure if the i2c bus will work as I currently have it.  most examples ave all the circuits in series wit a pull up resistor after each one.  I currently have them in parallel so we will see.
  • Added in the other 4 fingers to the executive sketch as well as added functions using the commgr class, for sending data to the PC so I can ave a console tat sows all the fingers data.

End: 6:00pm

Dong Shin 10.06.11

  • Meeting with Tangie at Fort and some enhancements requested
    • make fonts bigger
    • distinguishable header info in Financial Status Data. It should be each row of the project’s budget data and selectable/changeable
    • PM Actual Outlays link to the Financial Data
    • Possible meetings on Mon/Thu mornings
  • Continue working on PPM Widgets
    • basic monthly display is done
    • working on query to get whole financial data at one year at a time…Goals and data, $ and %, – all calculated.
      1. Obligations Goals %
      2. Obligations Goals $ – calculated from budget amount
      3. Obligation % and $ from Financial Data…. multiple data
      4. Outlay Goals %
      5. Outlay Goals $ – calculated from budget amount
      6. Outlay % and $ from Financial Data… multiple data
    • Goals Data query….for project uid 100
      • SELECT * FROM (
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Obligation %:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        CONCAT (g.obligation_month_1, ‘%’) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Obligation $:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        (a.amount * g.obligation_month_1 / 100) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        o.type as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        o.month_1 as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Obligated%’
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        REPLACE (o.type, ‘$:’, ‘%:’) as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        (o.month_1 / a.amount) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Obligated%’
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Outlay %:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        CONCAT (g.outlay_month_1, ‘%’) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        null as o_uid,
        ‘Outlay $:’ as o_type,
        (p.begin_year + a.year – 1) as o_year,
        a.year as o_year_count,
        null as o_project_id,
        null as o_funding_id,
        (a.amount * g.outlay_month_1 / 100) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        o.type as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        o.month_1 as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Outlay%’
        UNION
        SELECT
        p.uid as p_uid,
        c.uid as c_uid,
        a.uid as a_uid,
        a.amount as a_amount,
        o.uid as o_uid,
        REPLACE (o.type, ‘$:’, ‘%:’) as o_type,
        o.year as o_year,
        o.year_count as o_year_count,
        o.project_id as o_project_id,
        o.funding_id as o_funding_id,
        (o.month_1 / a.amount) as o_month_1
        FROM `projects` p,
        budget_centers c,
        budget_amounts a,
        obligations_outlays o,
        obligations_outlays_goals g
        WHERE p.uid = c.project_id
        AND c.uid = a.budget_center_id
        AND o.funding_id = c.uid
        AND a.year = o.year_count
        AND c.appropriation = g.appropriation
        AND a.year = g.year
        AND o.type LIKE ‘%Outlay%’
        ) AS X
        WHERE p_uid = 100 AND o_year=2011 AND o_year_count=1

Phil 10.6.11

8:30 – 4:30 VISIBILITY

  • Talked to Bill D, mostly about not freaking out Stark.
  • Dong met with Tanji. Meetings will be either Monday or Thursday, with donuts. Since Monday is a holiday, first donuts meeting will be Thursday.
  • Got admin privileges. Mike thinks he’ll have some code to test tomorrow or so.
  • Going through Mike’s code to see how he’s talking to Google.

Tom DeVito 10.5.2011

Start: 9:00

  • Lengthened the wires for the sensor circuits and attached a connector to them
  • I think I might have found the problem in my code.   I made some changes but will have to get at least one finger wired up completely before I can test it.
  • Noticed that I didn’t wire one of the rheostats to the proper address.  Issue was resolved.

End: 5:00

Phil 10.5.11

8:00 – 4:00 VISIBILITY

  • Spent the morning doing paperwork and helping Mike get permissions to use our servers
  • Went over the wizard basics with Dong. He thinks he’ll have something by the end of the week.

Dong Shin 10.05.11

  • I know I shouldn’t have, but went ahead and updated to the Flash Player 11.0. It kept crashing in Firefox. Not just the our software, but Adobe’s as well. Chrome uses the version 11.0 and it looks ok. Well, going back to the version 10.
  • The problem I have had with ADL (Adobe Air Debug Launcher) for the mobile apps turned out to be related to the FlashFireBug plugin. mm.cfg file in my home directory is set to pre-load the plugin swf on start up. Somehow it messes up the ADL…. Set the PreloadSWF field to empty, and now it runs. I had to remove the plugin completely because it tries to fill the field again and when it did, it messed up the ADL again.
  • working on retrieving obligations/outlays data
    • created view for financial data – this allows to retrieve the data in one-shot.
    • CREATE
      ALGORITHM = UNDEFINED
      VIEW `project_obligations_outlays`
      AS       SELECT
      p.uid as p_uid,
      p.project_number as p_project_number,
      p.title as p_title,
      p.exec_summary as p_exec_summary,
      p.description as p_description,
      p.location as p_location,
      p.begin_year as p_begin_year,
      p.end_year as p_end_year,
      p.total_budget as p_total_budget,
      p.proj_mgr_login as p_proj_mgr_login,
      p.proj_admin_login as p_proj_admin_login,
      p.portfolio_mgr_login as p_portfolio_mgr_login,
      p.portfolio_admin_login as p_portfolio_admin_login,
      p.priority as p_priority,
      p.services as p_services,
      p.TRL_start as p_TRL_start,
      p.TRL_current as p_TRL_current,
      p.TRL_end as p_TRL_end,
      p.TCL_start as p_TCL_start,
      p.TCL_current as p_TCL_current,
      p.TCL_end as p_TCL_end,
      p.TP_start as p_TP_start,
      p.TP_current as p_TP_current,
      p.TP_end as p_TP_end,
      p.lock_id as p_lock_id,
      p.lock_time as p_lock_time,
      c.uid as c_uid,
      c.project_id as c_project_id,
      c.center_number as c_center_number,
      c.center_name as c_center_name,
      c.funding_transaction_name as c_funding_transaction_name,
      c.funding_transaction_number as c_funding_transaction_number,
      c.funding_transaction_type as c_funding_transaction_type,
      c.capability as c_capability,
      c.expenditure_center as c_expenditure_center,
      c.investment_portfolio as c_investment_portfolio,
      c.appropriation as c_appropriation,
      c.total_budget as c_total_budget,
      c.type as c_type,
      c.program_element as c_program_element,
      c.facts_pe as c_facts_pe,
      a.uid as a_uid,
      a.year as a_year,
      a.amount as a_amount,
      a.status_amount as a_status_amount,
      a.budget_center_id as a_budget_center_id,
      a.last_updated as a_last_updated,
      o.uid as o_uid,
      o.type as o_type,
      o.description as o_description,
      o.year as o_year,
      o.year_count as o_year_count,
      o.project_id as o_project_id,
      o.funding_id as o_funding_id,
      o.month_1 as o_month_1,
      o.month_1 as o_month_2,
      o.month_1 as o_month_3,
      o.month_1 as o_month_4,
      o.month_1 as o_month_5,
      o.month_1 as o_month_6,
      o.month_1 as o_month_7,
      o.month_1 as o_month_8,
      o.month_1 as o_month_9,
      o.month_1 as o_month_10,
      o.month_1 as o_month_11,
      o.month_1 as o_month_12

      FROM `projects` p,
      budget_centers c,
      budget_amounts a,
      obligations_outlays o
      WHERE p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND o.funding_id = c.uid
      AND a.year = o.year_count
      ORDER BY o.uid

Tom DeVito 10.4.2011

Start: 8:45

  • Went to the hardware store to get wood screws and a cheap power drill
  • Also bought more heat shrink and wiring harnesses
  • Attached all the components to the wooden board.  Most of the wires were long enough that they won’t need to be changed but a few will need to be replaced.
  • Soldered the connectors for the hands sensors and both sides of the speaker wire.  I haven’t done the voltage divider connector yet because some of these wires need to be lengthened.
  • Cleaned up the lab

End: 2:45

Dong Shin 10.04.11

  • Working on PPM Wizard
    • created ProjectSelectGroup to display list of projects
    • added ColumnsSelectTitleWindow to ProjectSelectGroup. This allows selection of columns to view in the list of projects
    • added  FinancialDataNavigator
    • added FinancialDataDataGrid
      • FinancialDataItemRenderer to display the data in CurrencyFormat
      • FinancialDataItemEditor to restrict numbers input using NumberTextInput
    • added getDefaultVariables method to return list of pre-selected fields/columns to display from RowDataBase class
    • added parseData to parse database results to RowDataBase object dynamically
  • Flash Player 11 is here!

Phil 10.4.11

8:00 – 4:30 VISIBILITY

  • Talked to Bill yesterday, and he wants the desks occupied as much as possible, so I’ll be logging here less.
  • Port 443 on the integration box is open! And is visible to both networks!

Thomas DeVito 10.4.2011

Start: 10:20

  • Finished wiring and adding the capacitors and resisters for the low-powered amp circuits
  • Wired the midi controllers.  Added longer wires to the one that was wired so it can be mounted
  • Everything is ready to connect to each other but I decided to stop there til I mounted everything.
  • Didn’t see anything glaringly wrong with the simulation code.  It is almost an exact copy of the one that works minus the names of objects and the fact its instanced.  It might have something to do with the pan function.

End: 6:30

Dong Shin 10.03.11

  • Cleaning up and mapping database tables to ActionScript classes
    • Tables not needed? Contacts, Cofundings, Financials, Forms_Query, Project_Alerts
      • TRUNCATE TABLE `contacts`
    • done – left out relation tables…
  • working on Project Managers Wizard

Phil 10.3.11

8:30 – 4:30 VISIBILITY

  • Well, I’m back. Fin  vacation. pix are at http://www.flickr.com/photos/21701734@N04/sets/72157627607863835/ if you’re interested.
  • Went over what Dong has been working on. We’re going to see if his form work can be used as the basis for the Project Manager’s wizard
  • Tried loading up Mike’s code, and discovered that there was a POM file, which did could not find the parent POM.  Waiting for M2 to update indices. Works with the command line/mvnAssist
    • Looks like I was pointing at the default m2 settings.xml file. Re-indexing.
    • Working now
  • Mike came over to check in the Java side of the code and help me build it. We installed on Google. About to try it on the phone proper.
  • Yay! Success!
  • Going over to check on our new desks and talk to Bill

Tom DeVito 9.17.2011-9.28.2011

  • The arduino side of the programming has one major error but seems to be working otherwise.   The object instantiates properly and most functions are working.  The simulation registers the contact event, but mutes the amplifier right after it starts playing.  This is probably something simple so I decided to build the hardware before looking into it further.
  • While trying to get the classes to work right I found that you need to make objects of other classes public.  I think this has to do with how the IDE links everything together because all dependent classes have to be included in the main sketch.
  • The debugger is not as bad as I thought in the arduino ide.  It will report errors in the included classes, not just the sketch.  It still doesn’t help with run time errors or things that you might want to step through.
  • The prototype is about 60% wired and assembled.  I positioned the speakers closer to the finger tip pressure sensors to increase the difference from when the speaker is playing verse resonance of another speaker playing.
  • I was able to use our Wheatstone bridge PCBs as a voltage divider circuit for the pressure sensors.  This made assembly much easier.
  • Wired all the high powered amplifiers as well as attached leads to be connected to the low-powered amplifiers once the electronics are ready.
  • Soldered three more amplifiers and one more rheostat to the break out boards.  Was reminded how much flux helps when doing this.
  • The midi boards still need to be wired, the 3 low-powered amps as well as the 2 rheostats need their circuits completed, all the loose leads need to be connected to their proper places and it will be done.
  • Assembly should be complete by the time I leave Monday.