8:00 – 4:00 ESSO

• Meeting with Jessica and Dong
• Desired tables for Data Navigator:
  • Status
    • Project Name
    • Portfolio Manager
    • Service
    • Current (i.e. FY12) budget
    • Percent under (10%, 20%, etc)
    • Weeks late since last report
    • Number of late reports
    • Appropriation
    • Budget Center
  • Financial Mitigation Plans
    • Project Name
    • Capability
    • Mitigation Plan(s)
    • Outlay Rate (current year)
    • Outlay Goal (current year)
    • Obligation Rate (current year)
    • Obligation Goal (current year)
    • Outlay Rate (previous year)
    • Outlay Goal (previous year)
    • Obligation Rate (previous year)
    • Obligation Goal (previous year)
    • Current outlay (goal – rate)
    • Current obligation (goal – rate)
    • Appropriation
    • Budget Center
    • Current year budget
    • Previous year budget
  • Tool Usage
    • User
    • Time using tool by week
    • Role
  • Appropriation Charts by Project
    • Goals are plotted for the entire appropriation schedule (i.e. Procurement = 3 yrs, RDTE = 2yrs, etc)
    • Obligations, outlays, committed, and PM Actuals are plotted to the current date
  • Summed Appropriations over time
    • Current Year
    • Previous Year
    • All projects in a particular appropriation are summed
    • All goals are summed, etc.
• Printed out Mike’s Giant Query for Dong to take a look at
• Making a version of Jessica’s cognos(?)  spreadsheet. About halfway through.