{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Definitions","Forecasting Report"],"not_rendered":{"external_links":1,"defined_names":17},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Definitions","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[0,0,0,3]],"flags":["formulas_cached_only"]}
["Definitions"]
[]
["Metric","Abbrev.","Description","Formula/Value"]
["Budget at Completion","BAC","Baseline cost for 100% of project."]
["Actual Cost","AC","Total costs actually incurred so far."]
["Earned Value","EV","Amount of budget earned so far based on physical work accomplished, without reference to actual costs."]
["Planned Value","PV","The budget for the physical work scheduled to be completed by the end of the time period."]
["Cost Variance","CV","Measure of cost overrun. The difference between the budget for the work actually done so far and the actual costs so far.","Earned Value–Actual Cost\nEV–AC"]
["Cost Performance Index","CPI","Cost efficiency ratio. A CPI of 1.0 means that the costs so far are exactly the same as the budget for work actually done so far.","Earned Value/Actual Cost\nEV/AC"]
["Schedule Variance","SV","Measure of schedule slippage. The difference between the budget for the work actually done so far and the budgeted cost of work scheduled.","Earned Value–Planned Value\nEV–PV"]
["Schedule Performance Index","SPI","The schedule efficiency ratio. An SPI of 1.0 means that the project is exactly on schedule.","Earned Value/Planned Value\nEV/PV"]
["Estimate to Completion","ETC","The expected additional cost to complete the project.","Estimate at Completion–Actual Cost\nEAC–AC"]
["Estimate at Completion","EAC","Expected total cost based on the current cost efficiency ratio.","Budget at Completion/Cost Performance Index\nBAC/CPI"]
["Status",null,"Average of CPI & SPI","(Cost Performance Index+Schedule Performance Index)/2\n(CPI+SPI)/2"]
[null,null,"GREEN = On track",">1.0"]
[null,null,"YELLOW = Slightly behind schedule or over budget",">0.85"]
[null,null,"RED = Needs immediate attention",">0.65"]
[null,null,"BLACK = Killed or Restore","<0.65"]

{"sheet":"Forecasting Report","index":1,"n_rows":60,"n_cols":6,"rows_kept":60,"merged":[[0,0,0,5],[5,0,5,5],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,0,13,5],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,5],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,0,26,5],[29,0,29,5],[32,0,32,5],[38,0,38,5],[41,0,41,5],[46,0,46,5],[47,0,47,5],[48,0,48,5],[49,0,49,5],[50,0,50,5],[51,0,51,5],[52,0,52,5],[53,0,53,5],[54,0,54,5],[55,0,55,5],[56,0,56,5],[57,0,57,5]],"flags":["formulas_cached_only"]}
["Forecasting Report"]
["Project Name:"]
["Department:"]
["Project Manager:"]
["Project Completion Date:"]
["Schedule and Cost"]
["Budget at Completion (BAC)",null,null,"Estimate to Completion (ETC)",null,""]
["Earned Value (EV)",null,null,"Estimate at Completion (EAC)",null,""]
["Actual Cost to Date (AC) ",null,null,"Cost Variance (CV)",null,""]
["Planned Value (PV)",null,null,"Schedule Variance (SV)",null,""]
[{"$nulls":3},"Cost Performance Index (CPI)",null,""]
[{"$nulls":3},"Schedule Performance Index (SPI)",null,""]
[{"$nulls":3},"Status (Average of CPI + SPI)",null,""]
["Milestones"]
["Milestones",null,"Planned Finish Date","Actual Finish Date","Variance (Days)","Status (G/Y/R)"]
["Milestone A: Charter sign-off",{"$nulls":3},""]
["Milestone B: Business requirement sign-off",{"$nulls":3},""]
["Milestone C: Functional spec. sign-off",{"$nulls":3},""]
["Milestone D: Phase gate review",{"$nulls":3},""]
["Scope"]
["Phase Number","Description",null,null,"Changes at Phase End","Increase or Decrease"]
["Phase 1","[Defined]"]
["Phase 2","[Designed]",{"$nulls":3},""]
["Phase 3","[Developed]",{"$nulls":3},""]
["Phase 4","[Tested]",{"$nulls":3},""]
["Phase 5","[Delivered]",{"$nulls":3},""]
["Resources"]
[null,"Effort Required","Effort Expended","Percent of Effort Expended","Estimated Effort to Complete","Variance"]
["Total effort required (hours)",null,null,"",null,""]
["Issues"]
[null,"Currently Open","Open Last Week","Increase or Decrease","Closed","Past Due"]
["Number of issues",null,null,0]
["Scope Changes"]
["Changes Due to","Requested","Approved","Deferred","Rejected","Under Investigation"]
["Business Requirements"]
["Functional Requirements"]
["Technical Requirements"]
["Total changes",0,0,0,0,0]
["Changes Due to Approved Scope Changes (Estimate)"]
[{"$nulls":3},"Cost ","Effort (hours)","Schedule (days)"]
["Effect of changes (increase or decrease)"]
["Risks"]
["Risks Identified",null,null,"Contingency Reserve"]
["Mitigation Plans Developed",null,null,"Last Reviewed"]
["Contingency Plans Developed",null,null,"Overall Risk (G,Y,R)"]
["Cost of Mitigations"]
["Top 3 Risks"]
["Risk 1: "]
["Risk 2: "]
["Risk 3: "]
["Top 3 Issues"]
["Issue 1: "]
["Issue 2: "]
["Issue 3: "]
["Comments"]
[]
[]
[]
[]
["Submitted by:",null,"Date:"]