{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Earned Value Management","Actual Cost Worksheet","Earned Value Worksheet"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Earned Value Management","index":0,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[32,1,32,2],[3,1,3,5],[39,2,39,14],[28,1,28,2],[2,2,2,5],[30,1,30,2],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,15],[2,11,2,12],[2,14,2,15],[2,7,2,9]]}
[null,"EARNED VALUE MANAGEMENT TEMPLATE"]
[]
[null,"PROJECT TITLE","Project Title Here",null,null,null,"PREPARED BY","Name of PM or Other Preparer",null,null,"DATE OF REPORT","00/00/0000",null,"TIME PERIOD",4]
[null,"PLANNED VALUE – WBS IDs and Task Titles listed here will automatically populate on worksheet tabs."]
[null,"WORK BRKDWN STRUCTURE","TASK TITLE","TOTAL \nBUDGETED \nCOST","PERIOD"]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,1.1000000000000001,"Task 1.1",{"$f":"SUM(E7:P7)","v":1258},300,500,400,50,1,1,1,1,1,1,1,1]
[null,1.2,"Task 1.2",{"$f":"SUM(E8:P8)","v":350},200,80,30,40,0,0,0,0,0,0,0,0]
[null,1.3,"Task 1.3",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,1.4,"Task 1.4",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2.1,"Task 2.1",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2.2000000000000002,"Task 2.2",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2.2999999999999998,"Task 2.3",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2.4,"Task 2.4",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,2.5,"Task 2.5",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3.1,"Task 3.1",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3.2,"Task 3.2",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3.3,"Task 3.3",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3.4,"Task 3.4",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3.5,"Task 3.5",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3.6,"Task 3.6",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3.7,"Task 3.7",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4.0999999999999996,"Task 4.1",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4.2,"Task 4.2",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4.3,"Task 4.3",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4.4000000000000004,"Task 4.4",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TBC","TOTAL BUDGETED COST",{"$f":"SUM(D7:D26)","v":1608},{"$f":"SUM(E7:E26)","v":500},{"$f":"SUM(F7:F26)","v":580},430,90,1,1,1,1,1,1,1,1]
[null,"PV","CUMLATIVE PLANNED VALUE",null,{"$f":"E27","v":500},{"$f":"E28+F27","v":1080},{"$f":"F28+G27","v":1510},1600,1601,1602,1603,1604,1605,1606,1607,{"$f":"O28+P27","v":1608}]
[null,"ACTUAL COST "]
[null,"AC","CUMULATIVE ACTUAL COST",null,{"$f":"'Actual Cost Worksheet'!E28","v":900},{"$f":"'Actual Cost Worksheet'!F28","v":1220},{"$f":"'Actual Cost Worksheet'!G28","v":1480},{"$f":"'Actual Cost Worksheet'!H28","v":1620},{"$f":"'Actual Cost Worksheet'!I28","v":1621},{"$f":"'Actual Cost Worksheet'!J28","v":1622},{"$f":"'Actual Cost Worksheet'!K28","v":1623},{"$f":"'Actual Cost Worksheet'!L28","v":1624},{"$f":"'Actual Cost Worksheet'!M28","v":1625},{"$f":"'Actual Cost Worksheet'!N28","v":1626},{"$f":"'Actual Cost Worksheet'!O28","v":1627},{"$f":"'Actual Cost Worksheet'!P28","v":1628}]
[null,"EARNED VALUE"]
[null,"EV","CUMULATIVE EARNED VALUE",null,{"$f":"'Earned Value Worksheet'!E27","v":1356.4},{"$f":"'Earned Value Worksheet'!F27","v":1230.5999999999999},{"$f":"'Earned Value Worksheet'!G27","v":1363},{"$f":"'Earned Value Worksheet'!H27","v":520.70000000000005},{"$f":"'Earned Value Worksheet'!I27","v":125.80000000000001},{"$f":"'Earned Value Worksheet'!J27","v":125.80000000000001},{"$f":"'Earned Value Worksheet'!K27","v":125.80000000000001},{"$f":"'Earned Value Worksheet'!L27","v":125.80000000000001},{"$f":"'Earned Value Worksheet'!M27","v":125.80000000000001},{"$f":"'Earned Value Worksheet'!N27","v":125.80000000000001},{"$f":"'Earned Value Worksheet'!O27","v":125.80000000000001},{"$f":"'Earned Value Worksheet'!P27","v":125.80000000000001}]
[null,"PROJECT PERFORMANCE METRICS"]
[null,"CV","COST VARIANCE","( EV – AC )",{"$f":"E32-E30","v":456.40000000000009},{"$f":"F32-F30","v":10.599999999999909},-117,-1099.3,-1495.2,-1496.2,-1497.2,-1498.2,-1499.2,-1500.2,-1501.2,-1502.2]
[null,"SV","SCHEDULE VARIANCE","( EV – PV )",{"$f":"E32-E28","v":856.40000000000009},{"$f":"F32-F28","v":150.59999999999991},-147,-1079.3,-1475.2,-1476.2,-1477.2,-1478.2,-1479.2,-1480.2,-1481.2,-1482.2]
[null,"CPI","COST PERFORMANCE INDEX","( EV / AC )",{"$f":"E32/E30","v":1.5071111111111113},{"$f":"F32/F30","v":1.0086885245901638},0.92094594594594592,0.32141975308641979,7.7606415792720554E-2,7.7558569667077693E-2,7.7510782501540365E-2,7.7463054187192126E-2,7.7415384615384622E-2,7.7367773677736784E-2,7.7320221266133998E-2,7.7272727272727285E-2]
[null,"SPI","SCHEDULE PERFORMANCE INDEX","( EV / PV )",{"$f":"E32/E28","v":2.7128000000000001},{"$f":"F32/F28","v":1.1394444444444443},0.90264900662251657,0.32543750000000005,7.8575890068707063E-2,7.8526841448189763E-2,7.8477854023705565E-2,7.8428927680798011E-2,7.8380062305295956E-2,7.8331257783312583E-2,7.8282514001244557E-2,7.8233830845771152E-2]
[null,"EAC","ESTIMATED COST AT COMPLETION",null,{"$f":"D27/E36","v":1066.94190504276},{"$f":"D27/F36","v":1594.1491955143836},{"$f":"D27/G36","v":1746.0308143800441},{"$f":"D27/H36","v":5002.8039178029567},{"$f":"D27/I36","v":20719.936406995228},{"$f":"D27/J36","v":20732.718600953893},{"$f":"D27/K36","v":20745.500794912557},{"$f":"D27/L36","v":20758.282988871222},{"$f":"D27/M36","v":20771.065182829887},{"$f":"D27/N36","v":20783.847376788552},{"$f":"D27/O36","v":20796.629570747216},{"$f":"D27/P36","v":20809.411764705877}]
[]
[null,null,"CLICK HERE TO CREATE EARNED VALUE MANAGEMENT TEMPLATES IN SMARTSHEET"]

{"sheet":"Actual Cost Worksheet","index":1,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,5],[2,7,2,9],[2,11,2,12],[2,14,2,15],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,15],[3,1,3,5]]}
[null,"EARNED VALUE MANAGEMENT TEMPLATE"]
[]
[null,"PROJECT TITLE",{"$f":"'Earned Value Management'!C3:F3","v":"Project Title Here"},null,null,null,"PREPARED BY",{"$f":"'Earned Value Management'!H3:J3","v":"Name of PM or Other Preparer"},null,null,"DATE OF REPORT",{"$f":"'Earned Value Management'!L3:M3","v":"00/00/0000"},null,"TIME PERIOD",{"$f":"'Earned Value Management'!O3:P3","v":4}]
[null,"ACTUAL COST – Enter amount of actual costs incurred for each task per period."]
[null,"WORK BRKDWN STRUCTURE","TASK TITLE","TOTAL \nBUDGETED \nCOST","PERIOD"]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,{"$f":"'Earned Value Management'!B7","v":1.1000000000000001},{"$f":"'Earned Value Management'!C7","v":"Task 1.1"},{"$f":"'Earned Value Management'!D7","v":1258},100,300,200,100,1,1,1,1,1,1,1,1]
[null,{"$f":"'Earned Value Management'!B8","v":1.2},{"$f":"'Earned Value Management'!C8","v":"Task 1.2"},{"$f":"'Earned Value Management'!D8","v":350},800,20,60,40,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B9","v":1.3},{"$f":"'Earned Value Management'!C9","v":"Task 1.3"},{"$f":"'Earned Value Management'!D9","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B10","v":1.4},{"$f":"'Earned Value Management'!C10","v":"Task 1.4"},{"$f":"'Earned Value Management'!D10","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B11","v":2.1},{"$f":"'Earned Value Management'!C11","v":"Task 2.1"},{"$f":"'Earned Value Management'!D11","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B12","v":2.2000000000000002},{"$f":"'Earned Value Management'!C12","v":"Task 2.2"},{"$f":"'Earned Value Management'!D12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B13","v":2.2999999999999998},{"$f":"'Earned Value Management'!C13","v":"Task 2.3"},{"$f":"'Earned Value Management'!D13","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B14","v":2.4},{"$f":"'Earned Value Management'!C14","v":"Task 2.4"},{"$f":"'Earned Value Management'!D14","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B15","v":2.5},{"$f":"'Earned Value Management'!C15","v":"Task 2.5"},{"$f":"'Earned Value Management'!D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B16","v":3.1},{"$f":"'Earned Value Management'!C16","v":"Task 3.1"},{"$f":"'Earned Value Management'!D16","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B17","v":3.2},{"$f":"'Earned Value Management'!C17","v":"Task 3.2"},{"$f":"'Earned Value Management'!D17","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B18","v":3.3},{"$f":"'Earned Value Management'!C18","v":"Task 3.3"},{"$f":"'Earned Value Management'!D18","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B19","v":3.4},{"$f":"'Earned Value Management'!C19","v":"Task 3.4"},{"$f":"'Earned Value Management'!D19","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B20","v":3.5},{"$f":"'Earned Value Management'!C20","v":"Task 3.5"},{"$f":"'Earned Value Management'!D20","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B21","v":3.6},{"$f":"'Earned Value Management'!C21","v":"Task 3.6"},{"$f":"'Earned Value Management'!D21","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B22","v":3.7},{"$f":"'Earned Value Management'!C22","v":"Task 3.7"},{"$f":"'Earned Value Management'!D22","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B23","v":4.0999999999999996},{"$f":"'Earned Value Management'!C23","v":"Task 4.1"},{"$f":"'Earned Value Management'!D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B24","v":4.2},{"$f":"'Earned Value Management'!C24","v":"Task 4.2"},{"$f":"'Earned Value Management'!D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B25","v":4.3},{"$f":"'Earned Value Management'!C25","v":"Task 4.3"},{"$f":"'Earned Value Management'!D25","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B26","v":4.4000000000000004},{"$f":"'Earned Value Management'!C26","v":"Task 4.4"},{"$f":"'Earned Value Management'!D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"AC","ACTUAL COST",null,{"$f":"SUM(E7:E26)","v":900},{"$f":"SUM(F7:F26)","v":320},260,140,1,1,1,1,1,1,1,1]
[null,null,"CUMULATIVE ACTUAL COST",null,{"$f":"E27","v":900},{"$f":"E28+F27","v":1220},{"$f":"F28+G27","v":1480},1620,1621,1622,1623,1624,1625,1626,1627,1628]

{"sheet":"Earned Value Worksheet","index":2,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,2,2,5],[2,7,2,9],[2,11,2,12],[2,14,2,15],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,15],[3,1,3,5]]}
[null,"EARNED VALUE MANAGEMENT TEMPLATE"]
[]
[null,"PROJECT TITLE",{"$f":"'Earned Value Management'!C3:F3","v":"Project Title Here"},null,null,null,"PREPARED BY",{"$f":"'Earned Value Management'!H3:J3","v":"Name of PM or Other Preparer"},null,null,"DATE OF REPORT",{"$f":"'Earned Value Management'!L3:M3","v":"00/00/0000"},null,"TIME PERIOD",{"$f":"'Earned Value Management'!O3:P3","v":4}]
[null,"CUMULATIVE EARNED VALUE – For each Task per Period, enter the Percentage Complete."]
[null,"WORK BRKDWN STRUCTURE","TASK TITLE","TOTAL \nBUDGETED \nCOST","PERIOD"]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,{"$f":"'Earned Value Management'!B7","v":1.1000000000000001},{"$f":"'Earned Value Management'!C7","v":"Task 1.1"},{"$f":"'Earned Value Management'!D7","v":1258},0.8,0.7,1,0.4,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,{"$f":"'Earned Value Management'!B8","v":1.2},{"$f":"'Earned Value Management'!C8","v":"Task 1.2"},{"$f":"'Earned Value Management'!D8","v":350},1,1,0.3,0.05,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B9","v":1.3},{"$f":"'Earned Value Management'!C9","v":"Task 1.3"},{"$f":"'Earned Value Management'!D9","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B10","v":1.4},{"$f":"'Earned Value Management'!C10","v":"Task 1.4"},{"$f":"'Earned Value Management'!D10","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B11","v":2.1},{"$f":"'Earned Value Management'!C11","v":"Task 2.1"},{"$f":"'Earned Value Management'!D11","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B12","v":2.2000000000000002},{"$f":"'Earned Value Management'!C12","v":"Task 2.2"},{"$f":"'Earned Value Management'!D12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B13","v":2.2999999999999998},{"$f":"'Earned Value Management'!C13","v":"Task 2.3"},{"$f":"'Earned Value Management'!D13","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B14","v":2.4},{"$f":"'Earned Value Management'!C14","v":"Task 2.4"},{"$f":"'Earned Value Management'!D14","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B15","v":2.5},{"$f":"'Earned Value Management'!C15","v":"Task 2.5"},{"$f":"'Earned Value Management'!D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B16","v":3.1},{"$f":"'Earned Value Management'!C16","v":"Task 3.1"},{"$f":"'Earned Value Management'!D16","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B17","v":3.2},{"$f":"'Earned Value Management'!C17","v":"Task 3.2"},{"$f":"'Earned Value Management'!D17","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B18","v":3.3},{"$f":"'Earned Value Management'!C18","v":"Task 3.3"},{"$f":"'Earned Value Management'!D18","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B19","v":3.4},{"$f":"'Earned Value Management'!C19","v":"Task 3.4"},{"$f":"'Earned Value Management'!D19","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B20","v":3.5},{"$f":"'Earned Value Management'!C20","v":"Task 3.5"},{"$f":"'Earned Value Management'!D20","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B21","v":3.6},{"$f":"'Earned Value Management'!C21","v":"Task 3.6"},{"$f":"'Earned Value Management'!D21","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B22","v":3.7},{"$f":"'Earned Value Management'!C22","v":"Task 3.7"},{"$f":"'Earned Value Management'!D22","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B23","v":4.0999999999999996},{"$f":"'Earned Value Management'!C23","v":"Task 4.1"},{"$f":"'Earned Value Management'!D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B24","v":4.2},{"$f":"'Earned Value Management'!C24","v":"Task 4.2"},{"$f":"'Earned Value Management'!D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B25","v":4.3},{"$f":"'Earned Value Management'!C25","v":"Task 4.3"},{"$f":"'Earned Value Management'!D25","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Earned Value Management'!B26","v":4.4000000000000004},{"$f":"'Earned Value Management'!C26","v":"Task 4.4"},{"$f":"'Earned Value Management'!D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EV","CUMULATIVE EARNED VALUE",null,{"$f":"SUMPRODUCT(E7:E26,$D$7:$D$26)","v":1356.4},1230.5999999999999,1363,520.70000000000005,125.80000000000001,125.80000000000001,{"$f":"SUMPRODUCT(K7:K26,$D$7:$D$26)","v":125.80000000000001},125.80000000000001,125.80000000000001,125.80000000000001,125.80000000000001,125.80000000000001]