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

{"sheet":"Definitions","index":0,"n_rows":19,"n_cols":5,"rows_kept":19,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["Project Performance Metric Definitions"]
["S#","Metric","Abbrev.","Description","Formula/Value"]
[1,"Budget at Completion","BAC","Baseline project cost"]
[2,"Actual Cost","AC","Total costs incurred in completing work during a given period"]
[3,"Earned Value","EV","Physical work completed during a given period"]
[4,"Planned Value","PV","Physical work scheduled for completion during a given period"]
[5,"Cost Variance","CV","Cost overrun during a given period","EV-AC"]
[6,"Cost Performance Index","CPI","Cost efficiency ratio","EV/AC"]
[7,"Schedule Variance","SV","Schedule slipped during a given period","EV-PV"]
[8,"Schedule Performance Index","SPI","Schedule efficiency ratio","EV/PV"]
[9,"Estimate to Completion","ETC","Expected additional cost needed","EAC-AC"]
[10,"Estimate at Completion","EAC","Expected total cost","BAC/CPI"]
[11,"Variance at Completion","VAC","Estimated cost overrun at end of project","BAC-EAC"]
[12,"Status","n/a","Average of CPI and SPI","(CPI+SPI)/2"]
[{"$nulls":3},"Status color key:"]
[{"$nulls":3},"GREEN = On track","³1.0"]
[{"$nulls":3},"YELLOW = Slightly behind schedule/budget","³0.85 but <1.0"]
[{"$nulls":3},"RED = Needs immediate attention","³0.65 but <0.85"]
[{"$nulls":3},"BLACK = Needs to be killed or restored","<0.65"]

{"sheet":"Data","index":1,"n_rows":21,"n_cols":18,"rows_kept":21,"merged":[[0,0,0,17],[1,0,1,1],[1,2,1,3],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,15]],"flags":["formulas_cached_only"]}
["Project Performance Report"]
[null,null,"Budget",null,"Earned","Actual","Cost",null,"Schedule",null,"Performance Index",null,"Forecast"]
["S#","Item Description","Overall\nBAC ($)","PV ($)","EV ($)","AC ($)","CV ($)","CV (%)","SV ($)","SV (%)","CPI","SPI","ETC","EAC","VAC (%)","VAC ($)","Average Index","Status"]
["A","<Program A>",489,254,225,266,{"v":-41,"d":"(41)"},{"v":-0.16141732283464566,"d":"-16%"},{"v":-29,"d":"(29)"},{"v":-0.1141732283464567,"d":"-11%"},{"v":0.8458646616541353,"d":"0.85"},{"v":0.8858267716535433,"d":"0.89"},{"v":312.1066666666667,"d":"312"},{"v":578.1066666666667,"d":"578"},{"v":-0.18222222222222226,"d":"-18%"},{"v":-89.10666666666668,"d":"(89)"},{"v":0.8658457166538394,"d":"0.87"},"YELLOW"]
["A.1","<Project 1>",186,93,90,100,{"v":-10,"d":"(10)"},{"v":-0.10752688172043011,"d":"-11%"},{"v":-3,"d":"(3)"},{"v":-0.03225806451612903,"d":"-3%"},{"v":0.9,"d":"0.90"},{"v":0.967741935483871,"d":"0.97"},{"v":106.66666666666666,"d":"107"},{"v":206.66666666666666,"d":"207"},{"v":-0.11111111111111106,"d":"-11%"},{"v":-20.666666666666657,"d":"(21)"},{"v":0.9338709677419355,"d":"0.93"},"YELLOW"]
["A.1.1","<Deliverable 1>",100,55,50,60,{"v":-10,"d":"(10)"},{"v":-0.18181818181818182,"d":"-18%"},{"v":-5,"d":"(5)"},{"v":-0.09090909090909091,"d":"-9%"},{"v":0.8333333333333334,"d":"0.83"},{"v":0.9090909090909091,"d":"0.91"},60,120,{"v":-0.2,"d":"-20%"},{"v":-20,"d":"(20)"},{"v":0.8712121212121212,"d":"0.87"},"YELLOW"]
["A.1.2","<Deliverable 2>",28,13,14,18,{"v":-4,"d":"(4)"},{"v":-0.3076923076923077,"d":"-31%"},1,{"v":0.07692307692307693,"d":"8%"},{"v":0.7777777777777778,"d":"0.78"},{"v":1.0769230769230769,"d":"1.08"},18,36,{"v":-0.2857142857142857,"d":"-29%"},{"v":-8,"d":"(8)"},{"v":0.9273504273504274,"d":"0.93"},"YELLOW"]
["A.1.n","<Deliverable n>",58,25,26,22,4,{"v":0.16,"d":"16%"},1,{"v":0.04,"d":"4%"},{"v":1.1818181818181819,"d":"1.18"},1.04,{"v":27.076923076923073,"d":"27"},{"v":49.07692307692307,"d":"49"},{"v":0.1538461538461539,"d":"15%"},{"v":8.923076923076927,"d":"9"},{"v":1.1109090909090908,"d":"1.11"},"GREEN"]
["A.2","<Project 2>",303,161,135,166,{"v":-31,"d":"(31)"},{"v":-0.19254658385093168,"d":"-19%"},{"v":-26,"d":"(26)"},{"v":-0.16149068322981366,"d":"-16%"},{"v":0.8132530120481928,"d":"0.81"},{"v":0.8385093167701864,"d":"0.84"},{"v":206.57777777777778,"d":"207"},{"v":372.5777777777778,"d":"373"},{"v":-0.22962962962962966,"d":"-23%"},{"v":-69.57777777777778,"d":"(70)"},{"v":0.8258811644091896,"d":"0.83"},"RED"]
["A.2.1","<Deliverable 1>",180,92,80,100,{"v":-20,"d":"(20)"},{"v":-0.21739130434782608,"d":"-22%"},{"v":-12,"d":"(12)"},{"v":-0.13043478260869565,"d":"-13%"},{"v":0.8,"d":"0.80"},{"v":0.8695652173913043,"d":"0.87"},125,225,{"v":-0.25,"d":"-25%"},{"v":-45,"d":"(45)"},{"v":0.8347826086956522,"d":"0.83"},"RED"]
["A.2.2","<Deliverable 2>",45,35,20,30,{"v":-10,"d":"(10)"},{"v":-0.2857142857142857,"d":"-29%"},{"v":-15,"d":"(15)"},{"v":-0.42857142857142855,"d":"-43%"},{"v":0.6666666666666666,"d":"0.67"},{"v":0.5714285714285714,"d":"0.57"},{"v":37.5,"d":"38"},{"v":67.5,"d":"68"},{"v":-0.5,"d":"-50%"},{"v":-22.5,"d":"(23)"},{"v":0.6190476190476191,"d":"0.62"},"BLACK"]
["A.2.n","<Deliverable n>",78,34,35,36,{"v":-1,"d":"(1)"},{"v":-0.029411764705882353,"d":"-3%"},1,{"v":0.029411764705882353,"d":"3%"},{"v":0.9722222222222222,"d":"0.97"},{"v":1.0294117647058822,"d":"1.03"},{"v":44.22857142857143,"d":"44"},{"v":80.22857142857143,"d":"80"},{"v":-0.02857142857142856,"d":"-3%"},{"v":-2.2285714285714278,"d":"(2)"},{"v":1.0008169934640523,"d":"1.00"},"GREEN"]
["B","<Program B>",705,363,405,430,{"v":-25,"d":"(25)"},{"v":-0.06887052341597796,"d":"-7%"},42,{"v":0.11570247933884298,"d":"12%"},{"v":0.9418604651162791,"d":"0.94"},{"v":1.115702479338843,"d":"1.12"},{"v":318.5185185185185,"d":"319"},{"v":748.5185185185185,"d":"749"},{"v":-0.061728395061728336,"d":"-6%"},{"v":-43.518518518518476,"d":"(44)"},{"v":1.028781472227561,"d":"1.03"},"GREEN"]
["B.1","<Project X>",375,148,210,225,{"v":-15,"d":"(15)"},{"v":-0.10135135135135136,"d":"-10%"},62,{"v":0.4189189189189189,"d":"42%"},{"v":0.9333333333333333,"d":"0.93"},{"v":1.4189189189189189,"d":"1.42"},{"v":176.78571428571428,"d":"177"},{"v":401.7857142857143,"d":"402"},{"v":-0.07142857142857141,"d":"-7%"},{"v":-26.785714285714278,"d":"(27)"},{"v":1.176126126126126,"d":"1.18"},"GREEN"]
["B.1.1","<Deliverable 1>",250,55,125,150,{"v":-25,"d":"(25)"},{"v":-0.45454545454545453,"d":"-45%"},70,{"v":1.2727272727272727,"d":"127%"},{"v":0.8333333333333334,"d":"0.83"},{"v":2.272727272727273,"d":"2.27"},150,300,{"v":-0.2,"d":"-20%"},{"v":-50,"d":"(50)"},{"v":1.5530303030303032,"d":"1.55"},"GREEN"]
["B.1.2","<Deliverable 2>",100,82,70,65,5,{"v":0.06097560975609756,"d":"6%"},{"v":-12,"d":"(12)"},{"v":-0.14634146341463414,"d":"-15%"},{"v":1.0769230769230769,"d":"1.08"},{"v":0.8536585365853658,"d":"0.85"},{"v":27.85714285714286,"d":"28"},{"v":92.85714285714286,"d":"93"},{"v":0.07142857142857138,"d":"7%"},{"v":7.142857142857139,"d":"7"},{"v":0.9652908067542214,"d":"0.97"},"YELLOW"]
["B.1.n","<Deliverable n>",25,11,15,10,5,{"v":0.45454545454545453,"d":"45%"},4,{"v":0.36363636363636365,"d":"36%"},{"v":1.5,"d":"1.50"},{"v":1.3636363636363635,"d":"1.36"},{"v":6.666666666666668,"d":"7"},{"v":16.666666666666668,"d":"17"},{"v":0.33333333333333326,"d":"33%"},{"v":8.333333333333332,"d":"8"},{"v":1.4318181818181817,"d":"1.43"},"GREEN"]
["B.2","<Project Y>",330,215,195,205,{"v":-10,"d":"(10)"},{"v":-0.046511627906976744,"d":"-5%"},{"v":-20,"d":"(20)"},{"v":-0.09302325581395349,"d":"-9%"},{"v":0.9512195121951219,"d":"0.95"},{"v":0.9069767441860465,"d":"0.91"},{"v":141.92307692307696,"d":"142"},{"v":346.92307692307696,"d":"347"},{"v":-0.0512820512820514,"d":"-5%"},{"v":-16.923076923076962,"d":"(17)"},{"v":0.9290981281905841,"d":"0.93"},"YELLOW"]
["B.2.1","<Deliverable 1>",90,55,60,50,10,{"v":0.18181818181818182,"d":"18%"},5,{"v":0.09090909090909091,"d":"9%"},{"v":1.2,"d":"1.20"},{"v":1.0909090909090908,"d":"1.09"},25,75,{"v":0.16666666666666666,"d":"17%"},15,{"v":1.1454545454545455,"d":"1.15"},"GREEN"]
["B.2.2","<Deliverable 2>",90,60,50,45,5,{"v":0.08333333333333333,"d":"8%"},{"v":-10,"d":"(10)"},{"v":-0.16666666666666666,"d":"-17%"},{"v":1.1111111111111112,"d":"1.11"},{"v":0.8333333333333334,"d":"0.83"},36,81,{"v":0.1,"d":"10%"},9,{"v":0.9722222222222223,"d":"0.97"},"YELLOW"]
["B.2.n","<Deliverable n>",150,100,85,110,{"v":-25,"d":"(25)"},{"v":-0.25,"d":"-25%"},{"v":-15,"d":"(15)"},{"v":-0.15,"d":"-15%"},{"v":0.7727272727272727,"d":"0.77"},0.85,{"v":84.11764705882354,"d":"84"},{"v":194.11764705882354,"d":"194"},{"v":-0.2941176470588236,"d":"-29%"},{"v":-44.117647058823536,"d":"(44)"},{"v":0.8113636363636363,"d":"0.81"},"RED"]