{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Cash Outflow %","Earned Value Date","EVM Chart"],"not_rendered":{"charts":1,"images":1,"external_links":70,"defined_names":2853},"read":"whole","date_system":"1900"}

{"sheet":"Cash Outflow %","index":0,"n_rows":48,"n_cols":21,"rows_kept":48,"hidden":true,"merged":[[0,0,1,20],[2,0,3,0],[2,1,3,1],[2,2,2,5],[2,6,2,17],[2,18,2,20],[26,0,27,20],[28,0,29,0],[28,1,29,1],[28,2,28,5],[28,6,28,17],[28,18,28,20]]}
["CASH OUTFLOW- DISTRICT ONE HOUSING SHEIKHUPURA"]
[]
["Task","Estimated Cost + 5% Con.",2022,{"$nulls":3},2023,{"$nulls":11},2024]
[null,null,"September","October","November","December","January","February","March","April","May","June","July","August","September","October","November","December","January","February","March"]
["Road Cut & Fill",{"v":65949999,"d":"65.95M"},{"v":0.1,"d":"10%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
["Entrance Gate",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":3},{"v":0.3,"d":"30%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"}]
["Sewerage",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"v":0.35,"d":"35%"},{"v":0.3,"d":"30%"},{"v":0.25,"d":"25%"},{"v":0.1,"d":"10%"}]
["Street Lights",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},{"v":0.85,"d":"85%"},{"v":0.15,"d":"15%"}]
["Disposal Station",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},{"v":0.3,"d":"30%"},{"v":0.25,"d":"25%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.05,"d":"5%"}]
["Water Supply Network",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0.35,"d":"35%"},{"v":0.3,"d":"30%"},{"v":0.2,"d":"20%"},{"v":0.15,"d":"15%"}]
["OHWT + Tubewell",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":5},{"v":0.2,"d":"20%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.15,"d":"15%"},{"v":0.05,"d":"5%"}]
["Road Formation (Structure) + Parking Areas",{"v":43359875,"d":"43.36 M"},{"$nulls":6},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.25,"d":"25%"},{"v":0.15,"d":"15%"}]
["External Electrification ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":10},{"v":0.25,"d":"25%"},{"v":0.4,"d":"40%"},{"v":0.2,"d":"20%"},{"v":0.15,"d":"15%"}]
["Gas Supply Network",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":10},{"v":0.35,"d":"35%"},{"v":0.25,"d":"25%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"}]
["Footpath (Both sides of road)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":11},{"v":0.35,"d":"35%"},{"v":0.35,"d":"35%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"}]
["Road Pavement (Asphalt & Marking)",{"v":65880000,"d":"65.88 M"},{"$nulls":14},{"v":0.9,"d":"90%"},{"v":0.1,"d":"10%"}]
["Horticulture",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":8},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"}]
["Mosque",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":9},{"v":0.2,"d":"20%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.15,"d":"15%"},{"v":0.05,"d":"5%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"}]
["Society Office ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":10},{"v":0.2,"d":"20%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"}]
["Misc. + Project Closing",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":15},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"}]
["Overheads ",{"v":72000000,"d":"72.00 M"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.0525,"d":"5.25%"},{"v":0.055,"d":"5.50%"}]
["Total Amount ",{"$f":"SUM(B5:B21)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
["CASH OUTFLOW- DISTRICT ONE HOUSING SHEIKHUPURA"]
[]
["Task",{"$f":"B3","v":"Estimated Cost + 5% Con."},2022,{"$nulls":3},2023,{"$nulls":11},2024]
[null,null,"September","October","November","December","January","February","March","April","May","June","July","August","September","October","November","December","January","February","March"]
["Road Cut & Fill",{"$f":"B5","v":{"v":65949999,"d":"65.95M"}},{"$f":"B5*C5","v":{"v":6594999.9,"d":"6.59M"}},{"$f":"B5*D5","v":{"v":19784999.7,"d":"19.78M"}},{"$f":"B5*E5","v":{"v":19784999.7,"d":"19.78M"}},{"$f":"B5*F5","v":{"v":19784999.7,"d":"19.78M"}}]
["Entrance Gate",{"$error":"#REF!"},{"$nulls":3},{"$f":"B6*F6","v":{"$error":"#REF!"}},{"$f":"B6*G6","v":{"$error":"#REF!"}},{"$f":"B6*H6","v":{"$error":"#REF!"}},{"$f":"B6*I6","v":{"$error":"#REF!"}},{"$f":"B6*J6","v":{"$error":"#REF!"}},{"$f":"B6*K6","v":{"$error":"#REF!"}},{"$f":"B6*L6","v":{"$error":"#REF!"}}]
["Sewerage",{"$error":"#REF!"},null,{"$f":"B7*D7","v":{"$error":"#REF!"}},{"$f":"B7*E7","v":{"$error":"#REF!"}},{"$f":"B7*F7","v":{"$error":"#REF!"}},{"$f":"B7*G7","v":{"$error":"#REF!"}}]
["Street Lights",{"$error":"#REF!"},{"$nulls":4},{"$f":"B8*G8","v":{"$error":"#REF!"}},{"$f":"B8*H8","v":{"$error":"#REF!"}}]
["Disposal Station",{"$error":"#REF!"},{"$nulls":4},{"$f":"B9*G9","v":{"$error":"#REF!"}},{"$f":"B9*H9","v":{"$error":"#REF!"}},{"$f":"B9*I9","v":{"$error":"#REF!"}},{"$f":"B9*J9","v":{"$error":"#REF!"}},{"$f":"B9*K9","v":{"$error":"#REF!"}},{"$f":"B9*L9","v":{"$error":"#REF!"}}]
["Water Supply Network",{"$error":"#REF!"},null,null,{"$f":"B10*E10","v":{"$error":"#REF!"}},{"$f":"B10*F10","v":{"$error":"#REF!"}},{"$f":"B10*G10","v":{"$error":"#REF!"}},{"$f":"B10*H10","v":{"$error":"#REF!"}}]
["OHWT + Tubewell",{"$error":"#REF!"},{"$nulls":5},{"$f":"B11*H11","v":{"$error":"#REF!"}},{"$f":"B11*I11","v":{"$error":"#REF!"}},{"$f":"B11*J11","v":{"$error":"#REF!"}},{"$f":"B11*K11","v":{"$error":"#REF!"}},{"$f":"B11*L11","v":{"$error":"#REF!"}},{"$f":"B11*M11","v":{"$error":"#REF!"}},{"$f":"B11*N11","v":{"$error":"#REF!"}},{"$f":"B11*O11","v":{"$error":"#REF!"}}]
["Road Formation (Structure) + Parking Areas",{"v":43359875,"d":"43.36M"},{"$nulls":6},{"$f":"B12*I12","v":{"v":13007962.5,"d":"13.01M"}},{"$f":"B12*J12","v":{"v":13007962.5,"d":"13.01M"}},{"$f":"B12*K12","v":{"v":10839968.75,"d":"10.84M"}},{"$f":"B12*L12","v":{"v":6503981.25,"d":"6.50M"}}]
["External Electrification ",{"$error":"#REF!"},{"$nulls":10},{"$f":"B13*M13","v":{"$error":"#REF!"}},{"$f":"B13*N13","v":{"$error":"#REF!"}},{"$f":"B13*O13","v":{"$error":"#REF!"}},{"$f":"B13*P13","v":{"$error":"#REF!"}}]
["Gas Supply Network",{"$error":"#REF!"},{"$nulls":10},{"$f":"B14*M14","v":{"$error":"#REF!"}},{"$f":"B14*N14","v":{"$error":"#REF!"}},{"$f":"B14*O14","v":{"$error":"#REF!"}},{"$f":"B14*P14","v":{"$error":"#REF!"}}]
["Footpath (Both sides of road)",{"$error":"#REF!"},{"$nulls":11},{"$f":"B15*N15","v":{"$error":"#REF!"}},{"$f":"B15*O15","v":{"$error":"#REF!"}},{"$f":"B15*P15","v":{"$error":"#REF!"}},{"$f":"B15*Q15","v":{"$error":"#REF!"}}]
["Road Pavement (Asphalt & Marking)",{"v":65880000,"d":"65.88M"},{"$nulls":14},{"$f":"B16*Q16","v":{"v":59292000,"d":"59.29M"}},{"$f":"B16*R16","v":{"v":6588000,"d":"6.59M"}}]
["Horticulture",{"$error":"#REF!"},{"$nulls":8},{"$f":"B17*K17","v":{"$error":"#REF!"}},{"$f":"B17*L17","v":{"$error":"#REF!"}},{"$f":"B17*M17","v":{"$error":"#REF!"}},{"$f":"B17*N17","v":{"$error":"#REF!"}},{"$f":"B17*O17","v":{"$error":"#REF!"}},{"$f":"B17*P17","v":{"$error":"#REF!"}},{"$f":"B17*Q17","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Mosque",{"$error":"#REF!"},{"$nulls":9},{"$f":"B18*L18","v":{"$error":"#REF!"}},{"$f":"B18*M18","v":{"$error":"#REF!"}},{"$f":"B18*N18","v":{"$error":"#REF!"}},{"$f":"B18*O18","v":{"$error":"#REF!"}},{"$f":"B18*P18","v":{"$error":"#REF!"}},{"$f":"B18*Q18","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"B18*S18","v":{"$error":"#REF!"}},{"$f":"B18*T18","v":{"$error":"#REF!"}}]
["Society Office ",{"$error":"#REF!"},{"$nulls":10},{"$f":"B19*M19","v":{"$error":"#REF!"}},{"$f":"B19*N19","v":{"$error":"#REF!"}},{"$f":"B19*O19","v":{"$error":"#REF!"}},{"$f":"B19*P19","v":{"$error":"#REF!"}},{"$f":"B19*Q19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"B19*S19","v":{"$error":"#REF!"}}]
["Misc. + Project Closing",{"$error":"#REF!"},{"$nulls":15},{"$error":"#REF!"},{"$f":"B20*S20","v":{"$error":"#REF!"}},{"$f":"B20*T20","v":{"$error":"#REF!"}},{"$f":"B20*U20","v":{"$error":"#REF!"}}]
["Overheads ",{"v":72000000,"d":"72.00M"},{"$f":"B21*C21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*D21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*E21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*F21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*G21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*H21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*I21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*J21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*K21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*L21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*M21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*N21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*O21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*P21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*Q21","v":{"v":3780000,"d":"3.78M"}},{"v":3780000,"d":"3.78M"},{"$f":"B21*S21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*T21","v":{"v":3780000,"d":"3.78M"}},{"$f":"B21*U21","v":{"v":3960000,"d":"3.96M"}}]
["Total Amount ",{"$f":"SUM(B31:B47)","v":{"$error":"#REF!"}},{"$f":"SUM(C31:C47)","v":{"v":10374999.9,"d":"10.37M"}},{"$f":"SUM(D31:D47)","v":{"$error":"#REF!"}},{"$f":"SUM(E31:E47)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(U31:U47)","v":{"$error":"#REF!"}}]

{"sheet":"Earned Value Date","index":1,"n_rows":36,"n_cols":13,"rows_kept":36,"merged":[[0,0,1,12],[2,0,3,0],[2,1,2,7],[2,8,2,9],[2,10,3,10],[2,11,3,11],[2,12,3,12]]}
["EARNED VALUE MANAGEMENT - PROJECT NAME"]
[]
["Task",2020,{"$nulls":6},2021,null,"PV","% Complete ","EV                                                    (PV X %Complete)"]
[null,"Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb"]
["Task-1",null,{"v":6846922.51,"d":"6.85M$"},{"v":211760.49,"d":"0.21M$"},{"$nulls":6},{"$f":"SUM(B5:J5)","v":{"v":7058683,"d":"7.06M$"}},{"v":1,"d":"100%"},{"$f":"PRODUCT(K5:L5)","v":{"v":7058683,"d":"7.06M$"}}]
["Task-2",{"v":710136.78,"d":"0.71M$"},{"v":747512.4,"d":"0.75M$"},{"v":336380.58,"d":"0.34M$"},{"v":74751.24,"d":"0.07M$"},{"$nulls":5},{"$f":"SUM(B6:J6)","v":{"v":1868781.0000000002,"d":"1.87M$"}},{"v":0.9,"d":"90%"},{"$f":"PRODUCT(K6:L6)","v":{"v":1681902.9000000001,"d":"1.68M$"}}]
["Task-3",null,null,{"v":4401372.8,"d":"4.40M$"},{"v":2475772.1999999997,"d":"2.48M$"},{"$nulls":5},{"$f":"SUM(B7:J7)","v":{"v":6877145,"d":"6.88M$"}},{"v":0.85,"d":"85%"},{"$f":"PRODUCT(K7:L7)","v":{"v":5845573.25,"d":"5.85M$"}}]
["Task-4",null,{"v":18668663.16,"d":"18.67M$"},{"v":37337326.32,"d":"37.34M$"},{"v":56005989.48,"d":"56.01M$"},{"v":74674652.64,"d":"74.67M$"},{"v":68451764.92,"d":"68.45M$"},{"v":37337326.32,"d":"37.34M$"},{"v":15557219.3,"d":"15.56M$"},{"v":3111443.86,"d":"3.11M$"},{"$f":"SUM(B8:J8)","v":{"v":311144386.00000006,"d":"311.14M$"}},{"v":0.6,"d":"60%"},{"v":186686631.60000002,"d":"186.69M$"}]
["Task-5",null,null,{"v":2274208.65,"d":"2.27M$"},{"v":7277467.68,"d":"7.28M$"},{"v":5609714.67,"d":"5.61M$"},{"$nulls":4},{"$f":"SUM(B9:J9)","v":{"v":15161391,"d":"15.16M$"}},{"v":0.8,"d":"80%"},{"v":12129112.8,"d":"12.13M$"}]
["Task-6",null,{"v":756255.14,"d":"0.76M$"},{"v":6428168.69,"d":"6.43M$"},{"v":6428168.69,"d":"6.43M$"},{"v":6428168.69,"d":"6.43M$"},{"v":6428168.69,"d":"6.43M$"},{"v":6428168.69,"d":"6.43M$"},{"v":4915658.41,"d":"4.92M$"},null,{"$f":"SUM(B10:J10)","v":{"v":37812757,"d":"37.81M$"}},{"v":0.75,"d":"75%"},{"v":28359567.75,"d":"28.36M$"}]
["Task-7",{"$nulls":3},{"v":7888439.24,"d":"7.89M$"},{"v":18645401.84,"d":"18.65M$"},{"v":17928271,"d":"17.93M$"},{"v":16494009.32,"d":"16.49M$"},{"v":10756962.6,"d":"10.76M$"},null,{"$f":"SUM(B11:J11)","v":{"v":71713084,"d":"71.71M$"}}]
["Task-8",{"$nulls":3},{"v":2110334.5,"d":"2.11M$"},{"v":5064802.8,"d":"5.06M$"},{"v":4642735.9,"d":"4.64M$"},{"v":4853769.350000001,"d":"4.85M$"},{"v":4431702.45,"d":"4.43M$"},null,{"v":21103345,"d":"21.10M$"}]
["Task-9",{"$nulls":3},{"v":631736.18,"d":"0.63M$"},{"v":7580834.16,"d":"7.58M$"},{"v":6949097.98,"d":"6.95M$"},{"v":7580834.16,"d":"7.58M$"},{"v":7264966.07,"d":"7.26M$"},{"v":1579340.4500000002,"d":"1.58M$"},{"v":31586809,"d":"31.59M$"}]
["Task-10",{"$nulls":4},{"v":6067187.36,"d":"6.07M$"},{"v":9100781.04,"d":"9.10M$"},{"v":9100781.04,"d":"9.10M$"},{"v":9859179.46,"d":"9.86M$"},{"v":3791992.1,"d":"3.79M$"},{"v":37919921,"d":"37.92M$"}]
["Task-11",{"v":3652982.4,"d":"3.65M$"},{"v":7305964.8,"d":"7.31M$"},{"v":7305964.8,"d":"7.31M$"},{"v":7305964.8,"d":"7.31M$"},{"v":7305964.8,"d":"7.31M$"},{"v":7305964.8,"d":"7.31M$"},{"v":7305964.8,"d":"7.31M$"},{"v":7305964.8,"d":"7.31M$"},{"v":6088304,"d":"6.09M$"},{"v":60883039.99999999,"d":"60.88M$"}]
[{"$nulls":10},{"$f":"SUM(K5:K15)","v":{"v":603129342,"d":"603.13M$"}}]
["Monthly Planned Value (PV)",{"$f":"SUM(B5:B16)","v":{"v":4363119.18,"d":"4.36M$"}},{"$f":"SUM(C5:C16)","v":{"v":34325318.01,"d":"34.33M$"}},{"$f":"SUM(D5:D16)","v":{"v":58295182.32999999,"d":"58.30M$"}},{"$f":"SUM(E5:E16)","v":{"v":90198624.00999999,"d":"90.20M$"}},{"v":131376726.96,"d":"131.38M$"},{"$f":"SUM(G5:G16)","v":{"v":120806784.33,"d":"120.81M$"}},{"$f":"SUM(H5:H16)","v":{"v":89100853.67999999,"d":"89.10M$"}},{"$f":"SUM(I5:I15)","v":{"v":60091653.09,"d":"60.09M$"}},{"$f":"SUM(J5:J15)","v":{"v":14571080.41,"d":"14.57M$"}}]
["Cumulative Planned Value (PV)",{"$f":"+B17","v":{"v":4363119.18,"d":"4.36M$"}},{"$f":"+B18+C17","v":{"v":38688437.19,"d":"38.69M$"}},{"v":96983619.51999998,"d":"96.98M$"},{"v":187182243.52999997,"d":"187.18M$"},{"v":318558970.48999995,"d":"318.56M$"},{"$f":"+F18+G17","v":{"v":439365754.81999993,"d":"439.37M$"}},{"v":528466608.49999994,"d":"528.47M$"},{"v":588558261.5899999,"d":"588.56M$"},{"v":603129341.9999999,"d":"603.13M$"}]
[]
["Monthly Actual Cost (AC)",{"v":6360000,"d":"6.36M$"},{"v":48562930,"d":"48.56M$"},{"v":76562930,"d":"76.56M$"},{"v":106562930,"d":"106.56M$"},{"v":165562930,"d":"165.56M$"},{"v":118562930,"d":"118.56M$"}]
["Cumulative Actual Cost (AC)",{"$f":"+B20","v":{"v":6360000,"d":"6.36M$"}},{"$f":"+B21+C20","v":{"v":54922930,"d":"54.92M$"}},{"v":131485860,"d":"131.49M$"},{"v":238048790,"d":"238.05M$"},{"v":403611720,"d":"403.61M$"},{"v":522174650,"d":"522.17M$"}]
[]
["Monthly Earned Value (EV)",{"$f":"+B17*L5","v":{"v":4363119.18,"d":"4.36M$"}},{"$f":"+C17*L6","v":{"v":30892786.209,"d":"30.89M$"}},{"$f":"D17*L7","v":{"v":49550904.98049999,"d":"49.55M$"}},{"$f":"+E17*L8","v":{"v":54119174.405999996,"d":"54.12M$"}},{"$f":"F17*L9","v":{"v":105101381.568,"d":"105.10M$"}},{"$f":"+G17*L10","v":{"v":90605088.2475,"d":"90.61M$"}}]
["Cumulative Earned Value (EV)",{"$f":"+B23","v":{"v":4363119.18,"d":"4.36M$"}},{"$f":"+C23+B24","v":{"v":35255905.389,"d":"35.26M$"}},{"$f":"+D23+C24","v":{"v":84806810.36949998,"d":"84.81M$"}},{"$f":"+E23+D24","v":{"v":138925984.77549997,"d":"138.93M$"}},{"$f":"+F23+E24","v":{"v":244027366.34349996,"d":"244.03M$"}},{"$f":"+G23+F24","v":{"v":334632454.59099996,"d":"334.63M$"}}]
["Find Till November 30, 2020"]
["Project EV as of November 30",{"$f":"+G24","v":{"v":334632454.59099996,"d":"334.63M$"}}]
["Project PV as of November 30",{"$f":"+G18","v":{"v":439365754.81999993,"d":"439.37M$"}}]
["Project AC as of November 30",{"$f":"+G21","v":{"v":522174650,"d":"522.17M$"}}]
[]
["To Find"]
["Cost Variance CV = EV-AC",{"$f":"B26-B28","v":{"v":-187542195.40900004,"d":"-187.54M$"}},null,"Over Budget"]
["SV = EV-PV",{"$f":"B26-B27","v":{"v":-104733300.22899997,"d":"-104.73M$"}},null,"Behind Schedule "]
["CPI = EV/AC",{"$f":"B26/B28","v":{"v":0.64084392949945,"d":"0.64"}},null,"Over Budget"]
["SPI = EV/PV",{"$f":"B26/B27","v":{"v":0.7616261643515952,"d":"0.76"}},null,"Behind Schedule"]
["Estimate at  Completion Cost ($)  EAC Original Plan (Total Cost) / CPI =",{"$f":"+K16/B33","v":{"v":941148560.8845384,"d":"941.15M$"}},null," Cost Require to Complete Work"]
["Estimate Time To Complete (ETC) =Original Plan / SPI  Duration of Month ",{"$f":"9/B34","v":{"v":11.816820930334087,"d":"12"}},null,"2 Month More Require to complete Work"]

{"sheet":"EVM Chart","index":2,"n_rows":13,"n_cols":10,"rows_kept":13}
[]
[]
[]
["Month","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01"]
["Panned Value (PV)",{"$f":"+'Earned Value Date'!B17","v":{"v":4363119.18,"d":"4.36M$"}},{"$f":"+'Earned Value Date'!C17","v":{"v":34325318.01,"d":"34.33M$"}},{"$f":"+'Earned Value Date'!D17","v":{"v":58295182.32999999,"d":"58.30M$"}},{"$f":"+'Earned Value Date'!E17","v":{"v":90198624.00999999,"d":"90.20M$"}},{"$f":"+'Earned Value Date'!F17","v":{"v":131376726.96,"d":"131.38M$"}},{"$f":"+'Earned Value Date'!G17","v":{"v":120806784.33,"d":"120.81M$"}},{"$f":"+'Earned Value Date'!H17","v":{"v":89100853.67999999,"d":"89.10M$"}},{"$f":"+'Earned Value Date'!I17","v":{"v":60091653.09,"d":"60.09M$"}},{"$f":"+'Earned Value Date'!J17","v":{"v":14571080.41,"d":"14.57M$"}}]
["Actual Cost (AC)",{"$f":"+'Earned Value Date'!B20","v":{"v":6360000,"d":"6.36M$"}},{"$f":"+'Earned Value Date'!C20","v":{"v":48562930,"d":"48.56M$"}},{"$f":"+'Earned Value Date'!D20","v":{"v":76562930,"d":"76.56M$"}},{"$f":"+'Earned Value Date'!E20","v":{"v":106562930,"d":"106.56M$"}},{"$f":"+'Earned Value Date'!F20","v":{"v":165562930,"d":"165.56M$"}},{"$f":"+'Earned Value Date'!G20","v":{"v":118562930,"d":"118.56M$"}},{"$f":"+'Earned Value Date'!H20","v":0},{"$f":"+'Earned Value Date'!I20","v":0},{"$f":"+'Earned Value Date'!J20","v":0}]
["Earned Value (EV)",{"$f":"+'Earned Value Date'!B23","v":{"v":4363119.18,"d":"4.36M$"}},{"$f":"+'Earned Value Date'!C23","v":{"v":30892786.209,"d":"30.89M$"}},{"$f":"+'Earned Value Date'!D23","v":{"v":49550904.98049999,"d":"49.55M$"}},{"$f":"+'Earned Value Date'!E23","v":{"v":54119174.405999996,"d":"54.12M$"}},{"$f":"+'Earned Value Date'!F23","v":{"v":105101381.568,"d":"105.10M$"}},{"$f":"+'Earned Value Date'!G23","v":{"v":90605088.2475,"d":"90.61M$"}},{"$f":"+'Earned Value Date'!H23","v":0},{"$f":"+'Earned Value Date'!I23","v":0},{"$f":"+'Earned Value Date'!J23","v":0}]
["  Planned Value Cost %",{"$f":"B5/SUM($B$5:$J$5)","v":{"v":0.007234135161674825,"d":"0.72%"}},{"$f":"C5/SUM($B$5:$J$5)","v":{"v":0.05691203464944341,"d":"5.69%"}},{"$f":"D5/SUM($B$5:$J$5)","v":{"v":0.0966545287561221,"d":"9.67%"}},{"v":0.1495510460673293,"d":"14.96%"},{"v":0.21782512938990792,"d":"21.78%"},{"v":0.20029996207679118,"d":"20.03%"},{"v":0.14773092183599984,"d":"14.77%"},{"v":0.09963311168170627,"d":"9.96%"},{"v":0.024159130381025306,"d":"2.42%"}]
[" Cum Planned Value Cost %",{"$f":"+B8","v":{"v":0.007234135161674825,"d":"0.72%"}},{"$f":"+C8+B9","v":{"v":0.06414616981111823,"d":"6.41%"}},{"$f":"+D8+C9","v":{"v":0.16080069856724033,"d":"16.08%"}},{"$f":"+E8+D9","v":{"v":0.3103517446345696,"d":"31.04%"}},{"v":0.5281768740244775,"d":"52.82%"},{"v":0.7284768361012688,"d":"72.85%"},{"v":0.8762077579372687,"d":"87.62%"},{"v":0.975840869618975,"d":"97.58%"},{"v":1.0000000000000002,"d":"100.00%"}]
["Actual Cost %",{"$f":"B6/SUM($B$5:$J$5)","v":{"v":0.01054500180493623,"d":"1.05%"}},{"$f":"C6/SUM($B$5:$J$5)","v":{"v":0.08051826800361507,"d":"8.05%"}},{"$f":"D6/SUM($B$5:$J$5)","v":{"v":0.126942804251762,"d":"12.69%"}},{"v":0.176683378803348,"d":"17.67%"},{"v":0.2745065087548004,"d":"27.45%"},{"v":0.19657960862398238,"d":"19.66%"}]
["Cum Actual Cost %",{"$f":"+B10","v":{"v":0.01054500180493623,"d":"1.05%"}},{"$f":"+C10+B11","v":{"v":0.0910632698085513,"d":"9.11%"}},{"$f":"+D10+C11","v":{"v":0.2180060740603133,"d":"21.80%"}},{"$f":"+E10+D11","v":{"v":0.3946894528636613,"d":"39.47%"}},{"$f":"+F10+E11","v":{"v":0.6691959616184617,"d":"66.92%"}},{"$f":"+G10+F11","v":{"v":0.8657755702424441,"d":"86.58%"}}]
["Earned Value %",{"$f":"B7/SUM($B$5:$J$5)","v":{"v":0.007234135161674825,"d":"0.72%"}},{"$f":"C7/SUM($B$5:$J$5)","v":{"v":0.05122083118449907,"d":"5.12%"}},{"$f":"D7/SUM($B$5:$J$5)","v":{"v":0.08215634944270378,"d":"8.22%"}},{"v":0.08973062764039758,"d":"8.97%"},{"v":0.17426010351192633,"d":"17.43%"},{"v":0.1502249715575934,"d":"15.02%"}]
["Cum Earned Value %",{"$f":"+B12","v":{"v":0.007234135161674825,"d":"0.72%"}},{"$f":"+C12+B13","v":{"v":0.05845496634617389,"d":"5.85%"}},{"$f":"+D12+C13","v":{"v":0.14061131578887767,"d":"14.06%"}},{"$f":"+E12+D13","v":{"v":0.23034194342927525,"d":"23.03%"}},{"v":0.4046020469412016,"d":"40.46%"},{"$f":"+G12+F13","v":{"v":0.554827018498795,"d":"55.48%"}}]