{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Definitions","Source Data","Trend Analysis"],"not_rendered":{"charts":4,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Definitions","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[0,0,0,3],[1,0,1,3]],"flags":["formulas_cached_only"]}
["Project Earned Value Analysis"]
["Project Earned Value Analysis measures the health of a project by looking at cost information and schedule information concurrently. It tells you whether the project is on schedule and on budget, as well as whether the project is on budget for the amount of work done so far. "]
[]
["Metric","Abbrev.","Description","Formula/Value"]
["Budget at Completion","BAC","Baseline cost for 100% of project.","N/A"]
["Actual Cost","AC","Total costs actually incurred so far.","N/A"]
["Earned Value","EV","Amount of budget earned so far based on physical work accomplished, without reference to actual costs. ","N/A"]
["Planned Value","PV","The budget for the physical work scheduled to be completed by the end of the time period.","N/A"]
["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.00 means that the costs so far are exactly the same as the budget for work actually done so far.","Earned Value/\nActual 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.","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"]
["Variance at Completion","VAC","Estimated cost overrun at the end of project.","Budget at Completion–Estimate at Completion\nBAC–EAC"]
["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 budget",">0.85"]
[null,null,"RED = Needs immediate attention",">0.65"]
[null,null,"BLACK = Killed or Restore","<0.65"]

{"sheet":"Source Data","index":1,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[1,0,1,10],[2,0,2,10]],"flags":["formulas_cached_only"]}
[]
["Project Earned Value Analysis"]
["<ProjectNameHere>"]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct"]
["Budget at Completion (BAC)",{"v":1230,"d":"$1,230"},{"v":1230,"d":"$1,230"},{"v":1230,"d":"$1,230"},{"v":1230,"d":"$1,230"},{"v":1400,"d":"$1,400"},{"v":1400,"d":"$1,400"},{"v":1400,"d":"$1,400"},{"v":1400,"d":"$1,400"},{"v":1400,"d":"$1,400"},{"v":1400,"d":"$1,400"}]
["Earned Value (EV)",{"v":100,"d":"$100"},{"v":200,"d":"$200"},{"v":300,"d":"$300"},{"v":450,"d":"$450"},{"v":750,"d":"$750"},{"v":800,"d":"$800"},{"v":1125,"d":"$1,125"},{"v":1200,"d":"$1,200"},{"v":1400,"d":"$1,400"},{"v":1400,"d":"$1,400"}]
["Actual Cost (AC)",{"v":100,"d":"$100"},{"v":205,"d":"$205"},{"v":315,"d":"$315"},{"v":600,"d":"$600"},{"v":800,"d":"$800"},{"v":1000,"d":"$1,000"},{"v":1200,"d":"$1,200"},{"v":1350,"d":"$1,350"},{"v":1475,"d":"$1,475"},{"v":1525,"d":"$1,525"}]
["Planned Value (PV)",{"v":100,"d":"$100"},{"v":220,"d":"$220"},{"v":325,"d":"$325"},{"v":550,"d":"$550"},{"v":725,"d":"$725"},{"v":925,"d":"$925"},{"v":1175,"d":"$1,175"},{"v":1275,"d":"$1,275"},{"v":1450,"d":"$1,450"},{"v":1500,"d":"$1,500"}]
["Cost Variance (CV)",{"v":0,"d":"$0"},{"v":-5,"d":"($5)"},{"v":-15,"d":"($15)"},{"v":-150,"d":"($150)"},{"v":-50,"d":"($50)"},{"v":-200,"d":"($200)"},{"v":-75,"d":"($75)"},{"v":-150,"d":"($150)"},{"v":-75,"d":"($75)"},{"v":-125,"d":"($125)"}]
["Schedule Variance (SV)",{"v":0,"d":"$0"},{"v":-20,"d":"($20)"},{"v":-25,"d":"($25)"},{"v":-100,"d":"($100)"},{"v":25,"d":"$25"},{"v":-125,"d":"($125)"},{"v":-50,"d":"($50)"},{"v":-75,"d":"($75)"},{"v":-50,"d":"($50)"},{"v":-100,"d":"($100)"}]
["Cost Performance Index (CPI)",{"v":1,"d":"1.00"},{"v":0.975609756097561,"d":"0.98"},{"v":0.9523809523809523,"d":"0.95"},0.75,{"v":0.9375,"d":"0.94"},{"v":0.8,"d":"0.80"},{"v":0.9375,"d":"0.94"},{"v":0.8888888888888888,"d":"0.89"},{"v":0.9491525423728814,"d":"0.95"},{"v":0.9180327868852459,"d":"0.92"}]
["Schedule Performance Index (SPI)",{"v":1,"d":"1.00"},{"v":0.9090909090909091,"d":"0.91"},{"v":0.9230769230769231,"d":"0.92"},{"v":0.8181818181818182,"d":"0.82"},{"v":1.0344827586206897,"d":"1.03"},{"v":0.8648648648648649,"d":"0.86"},{"v":0.9574468085106383,"d":"0.96"},{"v":0.9411764705882353,"d":"0.94"},{"v":0.9655172413793104,"d":"0.97"},{"v":0.9333333333333333,"d":"0.93"}]
["Estimate to Completion (ETC)",{"v":1130,"d":"$1,130"},{"v":1055.75,"d":"$1,056"},{"v":976.5,"d":"$977"},{"v":1040,"d":"$1,040"},{"v":693.3333333333333,"d":"$693"},{"v":750,"d":"$750"},{"v":293.33333333333326,"d":"$293"},{"v":225,"d":"$225"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Estimate at Completion (EAC)",{"v":1230,"d":"$1,230"},{"v":1260.75,"d":"$1,261"},{"v":1291.5,"d":"$1,292"},{"v":1640,"d":"$1,640"},{"v":1493.3333333333333,"d":"$1,493"},{"v":1750,"d":"$1,750"},{"v":1493.3333333333333,"d":"$1,493"},{"v":1575,"d":"$1,575"},{"v":1475,"d":"$1,475"},{"v":1525,"d":"$1,525"}]
["Variance at Completion (VAC)",{"v":0,"d":"$0"},{"v":-30.75,"d":"($31)"},{"v":-61.5,"d":"($62)"},{"v":-410,"d":"($410)"},{"v":-93.33333333333326,"d":"($93)"},{"v":-350,"d":"($350)"},{"v":-93.33333333333326,"d":"($93)"},{"v":-175,"d":"($175)"},{"v":-75,"d":"($75)"},{"v":-125,"d":"($125)"}]
["Average Index",{"v":1,"d":"1.00"},{"v":0.9423503325942351,"d":"0.94"},{"v":0.9377289377289377,"d":"0.94"},{"v":0.7840909090909092,"d":"0.78"},{"v":0.9859913793103449,"d":"0.99"},{"v":0.8324324324324325,"d":"0.83"},{"v":0.9474734042553192,"d":"0.95"},{"v":0.9150326797385621,"d":"0.92"},{"v":0.9573348918760959,"d":"0.96"},{"v":0.9256830601092896,"d":"0.93"}]
["Status based on Average Performance Index","GREEN","YELLOW","YELLOW","RED","YELLOW","RED","YELLOW","YELLOW","YELLOW","YELLOW"]
["Comments",{"$nulls":4},"New baseline set"]

{"sheet":"Trend Analysis","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}