{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["version control","Estimate Summary Sheet","Escalation Calc","Fees & AT costs scale"],"not_rendered":{"charts":1,"images":1,"external_links":1,"defined_names":6,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"version control","index":0,"n_rows":4,"n_cols":4,"rows_kept":4}
[]
[null,"Version Control"]
[null,"Version #","Date updated and published","Description of Update"]
[null,{"v":1,"d":"1.0"},"2023-02-24","Released as Appendix A in the AT Guide to Cost Estimation."]

{"sheet":"Estimate Summary Sheet","index":1,"n_rows":91,"n_cols":22,"rows_kept":91,"merged":[[1,13,6,13],[2,14,4,14],[3,3,3,5],[3,16,4,16],[5,14,6,14],[5,16,6,16]]}
[]
[null,null,"AT COST ESTIMATE CALCULATION AND SUMMARY SHEET",null,null,"v:",{"v":1,"d":"1.0"},{"$nulls":6},"AT only provides estimates at these phase activities incl for costs for all following phases.","Project PHASE","Activity(new term)","AT EPMF Stage-gate","Activity(old term)","Estimate Type","P50 range","P95 range","Comments"]
[null,null,"Based on NZTA SM014 August 2021 template",{"$nulls":11},"Project Development","Programme Business Case",1,"Project Feasibility Report","PBE","40 - 60%","70 - 150%"]
[null,null,"Estimate Type(select drop down adjacent):","Programme Business Case",{"$nulls":3},{"$f":"VLOOKUP(D4,P3:S7,4,FALSE)","v":"PBE"},{"$nulls":7},"Indicative Business Case",2,"Investigation & Reporting","IBE","30 - 50%","50 - 70%"]
[null,null,"Scheme Name:","Typical % ranges:",null,{"$f":"VLOOKUP($H$4,$S$3:$U$7,2,FALSE)","v":"40 - 60%"},null,{"$f":"VLOOKUP($H$4,$S$3:$U$7,3,FALSE)","v":"70 - 150%"},{"$nulls":7},"Detailed Business Case",null,"Investigation & Reporting","DBE","30 - 50%","50 - 70%","Project Development Estimates are set to NIL as these are now sunk costs"]
[null,"ITEM","PHASE","Base Estimate",null,"Contingency P50",{"v":0.5,"d":"50%"},"Funding Risk Contingency P95",{"v":0.7,"d":"70%"},{"$nulls":5},"Pre-Implementation","Pre-Implementation 1",3,"Design & Project Documentation","PE1","20 - 40%","40 - 60%","Project Development Estimates are set to NIL as these are now sunk costs"]
[null,"A","Net Project property Cost",0,null,0,null,0,{"$nulls":7},"Pre-Implementation 2",null,"Engineer's Estimate(EE)","PE2(EE)","15 - 20%","20 - 30%","Project Development & Pre-Implementation Phase Estimate 1 are set to NIL as these are now sunk costs"]
[null,"B","Project Development Phase",null,"as % of physical wks D.2 excl escal",{"$nulls":9},"Implementation","Implementation (Tender awarded)","-","Construction, MSQA","IE",{"v":0.15,"d":"15%"},"15-20%","Winning tender prices known for build and MSQA suppliers, only construction variation risks to allow for. AT does not do IE's."]
[null,null,"Consultancy Fees",{"$f":"(D$57-D$55)*E9","v":0},null,{"$f":"D9*G9","v":0},{"$f":"G$6","v":{"v":0.5,"d":"50%"}},{"$f":"D9*I9","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}},{"$nulls":6},"Notes:",null,"1. Lower end P95 cannot be lower than the high end of the P50 when applied to the Base Estimate."]
[null,null,"AT managed costs",{"$f":"(D$57-D$55)*E10","v":0},null,{"$f":"D10*G10","v":0},{"$f":"G$6","v":{"v":0.5,"d":"50%"}},{"$f":"D10*I10","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}},{"$nulls":8},"2. The P50 and P95 adopted must be separated by at least 10%"]
[null,null,"Waka Kotahi managed costs",0,{"v":0.01,"d":"1.0%"},{"$f":"D11*G11","v":0},{"$f":"G$6","v":{"v":0.5,"d":"50%"}},{"$f":"D11*I11","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}},{"$nulls":8},"3. P50 and P95 are added to the escalated base estimate cost."]
[null,null,"Kiwirail managed costs",0,{"v":0.01,"d":"1.0%"},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"},{"$nulls":8},"4. The Funding Risk Contingency is the difference between the two."]
[null,null,"Project Development Phase Escalation",0,{"$f":"IF(D14=0,\"0%\",D13/SUM(D9:D12))","v":"0%"},{"$f":"D13*G13","v":0},{"$f":"G$6","v":{"v":0.5,"d":"50%"}},{"$f":"D13*I13","v":0},{"v":0.19999999999999996,"d":"20%"}]
[null,"B","Total Project Development:",{"$f":"SUM(D9:D13)","v":0},{"$f":"SUM(E9:E13)","v":{"v":0.02,"d":"2.0%"}},{"$f":"SUM(F9:F13)","v":0},null,{"$f":"SUM(H9:H13)","v":0}]
[]
[null,"C","Pre-Implementation Phase",null,"as % of physical wks D.2 excl escal"]
[null,null,"Consultancy Fees",{"$f":"(D$57-D$55)*E17","v":0},null,{"$f":"D17*G17","v":0},{"$f":"G$6","v":{"v":0.5,"d":"50%"}},{"$f":"D17*I17","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}}]
[null,null,"AT managed costs(incl consent fees)",{"$f":"(D$57-D$55)*E18","v":0},null,0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,null,"Waka Kotahi managed costs",{"$f":"(D$57-D$55)*E19","v":0},{"v":0.02,"d":"2.0%"},{"$f":"D19*G19","v":0},{"v":0.5,"d":"50%"},{"$f":"D19*I19","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}}]
[null,null,"Kiwirail managed costs",0,{"v":0.02,"d":"2.0%"},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,null,"Pre-Implementation Phase Escalation",0,{"$f":"IF(D22=0,\"0%\",D21/SUM(D17:D20))","v":"0%"},{"$f":"D21*G21","v":0},{"v":0.5,"d":"50%"},{"$f":"D21*I21","v":0},{"v":0.19999999999999996,"d":"20%"}]
[null,"C","Total Pre-Implementation:",{"$f":"SUM(D17:D21)","v":0},{"$f":"SUM(E17:E21)","v":{"v":0.04,"d":"4.0%"}},{"$f":"SUM(F17:F21)","v":0},null,{"$f":"SUM(H17:H21)","v":0}]
[]
[null,"D","Implementation Phase"]
[null,"D.1","Implementation Fees (MSQA);",null,"as % of physical wks D.2 excl escal"]
[null,null,"Consultancy Fees",{"$f":"(D$57-D$55)*E26","v":0},null,{"$f":"D26*G26","v":0},{"$f":"G$6","v":{"v":0.5,"d":"50%"}},{"$f":"D26*I26","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}}]
[null,null,"AT managed costs",0,null,0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,null,"Waka Kotahi managed costs",{"$f":"(D$57-D$55)*E28","v":0},{"v":0.015,"d":"1.5%"},{"$f":"D28*G28","v":0},{"v":0.5,"d":"50%"},{"$f":"D28*I28","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}}]
[null,null,"Kiwirail costs(BOL related, safety personnel, permits etc)",0,{"v":0.015,"d":"1.5%"},{"$f":"D29*G29","v":0},{"v":0.5,"d":"50%"},{"$f":"D29*I29","v":0},{"v":0.19999999999999996,"d":"20%"}]
[null,null,"Consent monitoring fees",0,{"v":0.01,"d":"1.0%"},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,null,"Implementation Phase Fees Escalation",0,{"$f":"IF(D32=0,\"0%\",D31/SUM(D26:D30))","v":"0%"},{"$f":"D31*G31","v":0},{"v":0.5,"d":"50%"},{"$f":"D31*I31","v":0},{"v":0.19999999999999996,"d":"20%"}]
[null,null,"D.1 Subtotal Base Implementation Fees:",{"$f":"SUM(D26:D31)","v":0},{"$f":"SUM(E26:E31)","v":{"v":0.04,"d":"4.0%"}},{"$f":"SUM(F26:F31)","v":0},null,{"$f":"SUM(H26:H31)","v":0}]
[null,"D.2","Physical Works (costs incl offsite OH and profit)"]
[null,1,{"$nulls":3},{"$f":"D34*G34","v":0},{"$f":"G$6","v":{"v":0.5,"d":"50%"}},{"$f":"D34*I34","v":0},{"$f":"I$6-G$6","v":{"v":0.19999999999999996,"d":"20%"}}]
[null,2,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,3,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,4,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,5,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,6,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,7,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,8,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,9,{"$nulls":3},{"$f":"D42*G42","v":0},{"v":0.5,"d":"50%"},{"$f":"D42*I42","v":0},{"v":0.19999999999999996,"d":"20%"}]
[null,10,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,11,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,12,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,13,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,14,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,15,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,16,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,17,{"$nulls":3},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,18,"Environmental Management as % of above 1-17",{"$f":"SUM(D34:D50)*E51","v":0},{"v":0.025,"d":"2.5%"},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,19,"Traffic Management as % of above 1-18",{"$f":"SUM(D34:D51)*E52","v":0},{"v":0.2,"d":"20.0%"},{"$f":"D52*G52","v":0},{"v":0.5,"d":"50%"},{"$f":"D52*I52","v":0},{"v":0.19999999999999996,"d":"20%"}]
[null,20,"Onsite overheads - fixed and variable as % of above 1-19",{"$f":"SUM(D34:D52)*E53","v":0},{"v":0.175,"d":"17.5%"},0,{"v":0.5,"d":"50%"},0,{"v":0.19999999999999996,"d":"20%"}]
[null,21,"Risk Register treatment",null,null,{"$f":"D54*G54","v":0},{"v":0.5,"d":"50%"},{"$f":"D54*I54","v":0},{"v":0.19999999999999996,"d":"20%"}]
[null,22,"Physical works escalation",0,{"$f":"IF(D57=0,\"0%\",D55/SUM(D34:D54))","v":"0%"},{"$f":"D55*G55","v":0},{"v":0.5,"d":"50%"},{"$f":"D55*I55","v":0},{"v":0.19999999999999996,"d":"20%"}]
[]
[null,null,"D.2 Subtotal Base Physical Works",{"$f":"SUM(D34:D56)","v":0},null,{"$f":"SUM(F34:F56)","v":0},null,{"$f":"SUM(H34:H56)","v":0}]
[null,"D","TOTAL IMPLEMENTATION",{"$f":"D32+D57","v":0},null,{"$f":"F32+F57","v":0},null,{"$f":"H32+H57","v":0}]
[null,"E","BASE ESTIMATE                            (A+B+C+D)",{"$f":"D7+D14+D22+D58","v":0}]
[]
[null,"F","Contingency (Assessed/Analysed)        (A+B+C+D)",null,null,{"$f":"F7+F14+F22+F58","v":0}]
[null,"G","Expected Estimate","(E+F)",null,{"$f":"D59+F61","v":0}]
[null,null,"AT Admin Fee       (G*5.7%)",{"v":0.057,"d":"5.7%"},null,{"$f":"F62*D63","v":0}]
[null,"G1","Expected Estimate incl AT Admin Fee",null,null,{"$f":"F62+F63","v":0}]
[{"$nulls":3},"Net of AT Admin fee",null,"Incl AT Admin Fee"]
[null,"Property Cost expected estimate",null,{"$f":"D7+F7","v":0},null,{"$f":"(D7+F7)*(1+D63)","v":0}]
[null,"Project Development expected estimate",null,{"$f":"D14+F14","v":0},null,{"$f":"(D14+F14)*(1+D63)","v":0}]
[null,"Pre-Implementation expected estimate",null,{"$f":"D22+F22","v":0},null,{"$f":"(D22+F22)*(1+D63)","v":0}]
[null,"Implementation expected estimate",null,{"$f":"D58+F58","v":0},null,{"$f":"(D58+F58)*(1+D63)","v":0}]
[]
[null,"H","Funding Risk (Assessed/Analysed)",{"$nulls":4},{"$f":"H7+H14+H22+H58","v":0}]
[null,"I","95th Percentile Project Estimate",null,null,"              (G+H)",null,{"$f":"F62+H71","v":0}]
[null,null,"AT Admin Fee       (I*5.7%)",null,null,{"v":0.057,"d":"5.7%"},null,{"$f":"H72*F73","v":0}]
[null,null,"95th Percentile Project Estimate incl AT Admin Fee",{"$nulls":4},{"$f":"H72+H73","v":0}]
[{"$nulls":5},"Net of AT Admin fee",null,"Incl AT Admin Fee"]
[null,"Property Cost 95th percentile estimate",{"$nulls":3},{"$f":"D7+H7","v":0},null,{"$f":"(D7+H7)*(1+F73)","v":0}]
[null,"Project Development 95th percentile estimate",{"$nulls":3},{"$f":"D14+H14","v":0},null,{"$f":"(D14+H14)*(1+F73)","v":0}]
[null,"Pre-Implementation 95th percentile estimate",{"$nulls":3},{"$f":"D22+H22","v":0},null,{"$f":"(D22+H22)*(1+F73)","v":0}]
[null,"Implementation 95th percentile estimate",{"$nulls":3},{"$f":"D58+H58","v":0},null,{"$f":"(D58+H58)*(1+F73)","v":0}]
[]
[null,null,"Date of estimate:",{"$nulls":3},"Cost index (Qtr/Year)"]
[null,null,"Estimate prepared by"]
[null,null,"Estimate internal peer review by"]
[null,null,"Estimate external peer review by"]
[null,null,"Estimate accepted by WK"]
[]
[]
[null,1,"This estimate excludes GST"]
[null,2,"The D.2 base estimate section may be added to as necessary, noting point 3 below."]
[null,3,"It is the responsibility of the estimator/user of this spreadsheet, to ensure that formulae are correct and providing the expected outputs.  "]
[null,4,"The estimator is to provide all supporting detailed estimate calculation spreadsheets as an added tab or tabs to this summary and suitably linked."]

{"sheet":"Escalation Calc","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"merged":[[0,5,0,13],[4,0,4,4],[6,5,6,13],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[24,5,24,13],[28,0,28,4],[30,5,30,13],[32,0,32,1],[33,0,33,1],[34,0,34,1]]}
[{"$f":"'Estimate Summary Sheet'!C5","v":"Scheme Name:"},{"$nulls":4},"Projected costflow based on assumed construction completion year."]
[]
[null,null,"Current date of estimate;"]
["PHYSICAL WORKS",null,{"$f":"NOW()","v":"2023-05-16T18:22:29.920"},null,null,{"$f":"DATE(YEAR(C4)+1,MONTH(C4),DAY(C4))","v":"2024-05-16"},{"$f":"DATE(YEAR(F4)+1,MONTH(F4),DAY(F4))","v":"2025-05-16"},{"$f":"DATE(YEAR(G4)+1,MONTH(G4),DAY(G4))","v":"2026-05-16"},{"$f":"DATE(YEAR(H4)+1,MONTH(H4),DAY(H4))","v":"2027-05-16"},"2028-05-16","2029-05-16","2030-05-16","2031-05-16","2032-05-16"]
["Estimator to enter assumed annual fluctuation profile:\n(% shown in template are for example only)",{"$nulls":4},{"v":-0.01,"d":"-1%"},{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"}]
[]
["Name",null,"Base Estimate D.2 based on current year \"0\" rates.","Row ID","Year # constructed or completed;","YEAR PROFILE",{"$nulls":8},"Escalated Base Estimate","Escalation"]
[null,null,0,null,null,1,2,3,4,5,6,7,8,9]
[null,null,{"v":1000000,"d":"$1,000,000"},2,5,{"$f":"IF(F$8<=$E9,C9*(1+F$5),\"\")","v":{"v":990000,"d":"$990,000"}},{"$f":"IF(G$8<=$E9,F9*(1+G$5),\"\")","v":{"v":990000,"d":"$990,000"}},{"$f":"IF(H$8<=$E9,G9*(1+H$5),\"\")","v":{"v":999900,"d":"$999,900"}},{"v":1019898,"d":"$1,019,898"},{"v":1050494.94,"d":"$1,050,495"},"","","","",{"$f":"HLOOKUP(E9,$F$8:$N$22,D9,FALSE)","v":{"v":1050494.94,"d":"$1,050,495"}},{"$f":"O9-C9","v":{"v":50494.939999999944,"d":"$50,495"}}]
[{"$nulls":3},3,1,{"$f":"IF(F$8<=$D10,C10*(1+F$5),\"\")","v":0},{"$f":"IF(G$8<=$E10,F10*(1+G$5),\"\")","v":""},"","","","","","","",0,{"$f":"O10-C10","v":0}]
[{"$nulls":3},4,1,0,"","","","","","","","",0,0]
[{"$nulls":3},5,1,0,"","","","","","","","",0,0]
[{"$nulls":3},6,1,0,"","","","","","","","",0,0]
[{"$nulls":3},7,1,0,"","","","","","","","",0,0]
[{"$nulls":3},8,1,{"$f":"IF(F$8<=$E15,C15*(1+F$5),\"\")","v":0},{"$f":"IF(G$8<=$E15,F15*(1+G$5),\"\")","v":""},"","","","","","","",0,0]
[{"$nulls":3},9,1,0,{"$f":"IF(G$8<=$E16,F16*(1+G$5),\"\")","v":""},"","","","","","","",0,0]
[{"$nulls":3},10,1,0,"","","","","","","","",0,0]
[{"$nulls":3},11,1,0,"","","","","","","","",0,0]
[{"$nulls":3},12,1,0,"","","","","","","","",0,0]
[{"$nulls":3},13,1,0,"","","","","","","","",0,0]
[{"$nulls":3},14,1,0,{"$f":"IF(G$8<=$E21,F21*(1+G$5),\"\")","v":""},"","","","","","","",0,0]
[{"$nulls":3},15,1,0,{"$f":"IF(G$8<=$E22,F22*(1+G$5),\"\")","v":""},"","","","","","","",0,0]
[null,"TOTAL",{"$f":"SUM(C9:C22)","v":{"v":1000000,"d":"$1,000,000"}},{"$nulls":11},{"$f":"SUM(O9:O22)","v":{"v":1050494.94,"d":"$1,050,495"}},{"$f":"SUM(P9:P22)","v":{"v":50494.939999999944,"d":"$50,495"}}]
[]
[{"$nulls":5},"Projected costflow based on assumed construction completion year."]
[]
[null,null,"Current date of estimate;"]
["PROFESSIONAL SERVICES",null,{"$f":"NOW()","v":"2023-05-16T18:22:29.920"},null,null,{"$f":"DATE(YEAR(C28)+1,MONTH(C28),DAY(C28))","v":"2024-05-16"},{"$f":"DATE(YEAR(F28)+1,MONTH(F28),DAY(F28))","v":"2025-05-16"},{"$f":"DATE(YEAR(G28)+1,MONTH(G28),DAY(G28))","v":"2026-05-16"},{"$f":"DATE(YEAR(H28)+1,MONTH(H28),DAY(H28))","v":"2027-05-16"},"2028-05-16","2029-05-16","2030-05-16","2031-05-16","2032-05-16"]
["Estimator to enter assumed annual fluctuation profile:\n(% shown in template are for example only)",{"$nulls":4},{"v":0.01,"d":"1.00%"},{"v":0.01,"d":"1.00%"},{"v":0.02,"d":"2.00%"},{"v":0.02,"d":"2.00%"},{"v":0.02,"d":"2.00%"},{"v":0.02,"d":"2.00%"},{"v":0.02,"d":"2.00%"},{"v":0.02,"d":"2.00%"},{"v":0.02,"d":"2.00%"}]
[]
["Name","Average Cost Per Km","Base Estimate based on current year \"0\" rates","Row ID","Year # constructed or completed;","YEAR PROFILE",{"$nulls":8},"Escalated Base Estimate","Escalation"]
[null,null,0,null,null,1,2,3,4,5,6,7,8,9]
["Project Development Fees & Costs",null,{"v":100000,"d":"$100,000"},2,1,{"$f":"IF(F$32<=$E33,C33*(1+F$29),\"\")","v":{"v":101000,"d":"$101,000"}},{"$f":"IF(G$8<=$E33,F33*(1+G$29),\"\")","v":""},"","","","","","","",{"$f":"HLOOKUP(E33,$F$32:$N$46,D33,FALSE)","v":{"v":101000,"d":"$101,000"}},{"$f":"O33-C33","v":{"v":1000,"d":"$1,000"}}]
["Pre-Implementation Fees and Costs",null,{"v":200000,"d":"$200,000"},3,3,{"$f":"IF(F$32<=$E34,C34*(1+F$29),\"\")","v":{"v":202000,"d":"$202,000"}},{"v":204020,"d":"$204,020"},{"v":208100.4,"d":"$208,100"},"","","","","","",{"$f":"HLOOKUP(E34,$F$32:$N$46,D34,FALSE)","v":{"v":208100.4,"d":"$208,100"}},{"$f":"O34-C34","v":{"v":8100.399999999994,"d":"$8,100"}}]
["Implementation Fees & Costs(MSQA)",null,{"v":300000,"d":"$300,000"},4,5,{"v":303000,"d":"$303,000"},{"v":306030,"d":"$306,030"},{"v":312150.6,"d":"$312,151"},{"v":318393.61199999996,"d":"$318,394"},{"v":324761.48423999996,"d":"$324,761"},"","","","",{"v":324761.48423999996,"d":"$324,761"},{"v":24761.48423999996,"d":"$24,761"}]
[{"$nulls":3},5,1,0,"","","","","","","","",0,0]
[{"$nulls":3},6,1,0,"","","","","","","","",0,0]
[{"$nulls":3},7,1,0,"","","","","","","","",0,0]
[{"$nulls":3},8,1,0,"","","","","","","","",0,0]
[{"$nulls":3},9,1,0,"","","","","","","","",0,0]
[{"$nulls":3},10,1,0,"","","","","","","","",0,0]
[{"$nulls":3},11,1,0,"","","","","","","","",0,0]
[{"$nulls":3},12,1,0,"","","","","","","","",0,0]
[{"$nulls":3},13,1,0,"","","","","","","","",0,0]
[{"$nulls":3},14,1,0,"","","","","","","","",0,0]
[{"$nulls":3},15,1,0,"","","","","","","","",0,0]
[null,"TOTAL",{"$f":"SUM(C33:C46)","v":{"v":600000,"d":"$600,000"}},{"$nulls":11},{"$f":"SUM(O33:O46)","v":{"v":633861.88424,"d":"$633,862"}},{"$f":"SUM(P33:P46)","v":{"v":33861.884239999956,"d":"$33,862"}}]

{"sheet":"Fees & AT costs scale","index":3,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[2,0,4,0],[5,0,7,0],[8,0,10,0],[11,0,12,0]]}
[null,"Cost ratios spanning 3 phases: Project development(PBE,IBE,DBE); Pre-implementation(PE1); Implementation(PE2)."]
["PHASE","D.2 Physical Works cost($m):","< $5",{"v":20,"d":"$20"},{"v":50,"d":"$50"},{"v":100,"d":"$100"},{"v":250,"d":"$250"},{"v":500,"d":"$500"}]
["DEVELOPMENT","AT Managed Costs - Development",{"v":0.06,"d":"6.0%"},{"v":0.045,"d":"4.5%"},{"v":0.033,"d":"3.3%"},{"v":0.024,"d":"2.4%"},{"v":0.017,"d":"1.7%"},{"v":0.0125,"d":"1.3%"}]
[null,"Consultancy Fees - Development",{"v":0.12,"d":"12.0%"},{"v":0.098,"d":"9.8%"},{"v":0.078,"d":"7.8%"},{"v":0.06,"d":"6.0%"},{"v":0.05,"d":"5.0%"},{"v":0.045,"d":"4.5%"}]
[null,"DEVELOPMENT SUBTOTAL:",{"$f":"C3+C4","v":{"v":0.18,"d":"18.0%"}},{"$f":"D3+D4","v":{"v":0.14300000000000002,"d":"14.3%"}},{"v":0.111,"d":"11.1%"},{"v":0.08399999999999999,"d":"8.4%"},{"v":0.067,"d":"6.7%"},{"v":0.057499999999999996,"d":"5.8%"}]
["PRE-IMPLEMENTATION","AT Managed Costs - Pre-Implementation",{"v":0.06,"d":"6.0%"},{"v":0.047,"d":"4.7%"},{"v":0.037,"d":"3.7%"},{"v":0.028,"d":"2.8%"},{"v":0.02,"d":"2.0%"},{"v":0.015,"d":"1.5%"}]
[null,"Consultancy Fees - Pre-Implementation",{"v":0.1,"d":"10.0%"},{"v":0.083,"d":"8.3%"},{"v":0.07,"d":"7.0%"},{"v":0.06,"d":"6.0%"},{"v":0.052,"d":"5.2%"},{"v":0.045,"d":"4.5%"}]
[null,"PRE-IMPLEMENTATION SUBTOTAL:",{"$f":"C6+C7","v":{"v":0.16,"d":"16.0%"}},{"$f":"D6+D7","v":{"v":0.13,"d":"13.0%"}},{"v":0.10700000000000001,"d":"10.7%"},{"v":0.088,"d":"8.8%"},{"v":0.072,"d":"7.2%"},{"v":0.06,"d":"6.0%"}]
["IMPLEMENTATION","AT Managed Costs - Implementation",{"v":0.03,"d":"3.0%"},{"v":0.025,"d":"2.5%"},{"v":0.022,"d":"2.2%"},{"v":0.019,"d":"1.9%"},{"v":0.017,"d":"1.7%"},{"v":0.015,"d":"1.5%"}]
[null,"Consultancy Fees - Implementation",{"v":0.07,"d":"7.0%"},{"v":0.06,"d":"6.0%"},{"v":0.052,"d":"5.2%"},{"v":0.045,"d":"4.5%"},{"v":0.039,"d":"3.9%"},{"v":0.035,"d":"3.5%"}]
[null,"IMPLEMENTATION SUBTOTAL:",{"$f":"C9+C10","v":{"v":0.1,"d":"10.0%"}},{"$f":"D9+D10","v":{"v":0.08499999999999999,"d":"8.5%"}},{"v":0.074,"d":"7.4%"},{"v":0.064,"d":"6.4%"},{"v":0.056,"d":"5.6%"},{"v":0.05,"d":"5.0%"}]
["ENTITY SUBTOTALS - ALL PHASES","AT Managed Costs - Total",{"$f":"C3+C6+C9","v":{"v":0.15,"d":"15.0%"}},{"v":0.11699999999999999,"d":"11.7%"},{"v":0.092,"d":"9.2%"},{"v":0.07100000000000001,"d":"7.1%"},{"v":0.054000000000000006,"d":"5.4%"},{"v":0.042499999999999996,"d":"4.3%"}]
[null,"Consultancy Fees - Total",{"v":0.29000000000000004,"d":"29.0%"},{"v":0.241,"d":"24.1%"},{"v":0.2,"d":"20.0%"},{"v":0.16499999999999998,"d":"16.5%"},{"v":0.14100000000000001,"d":"14.1%"},{"v":0.125,"d":"12.5%"}]
[null,"GRAND TOTAL - ALL PHASES:",{"$f":"C12+C13","v":{"v":0.44000000000000006,"d":"44.0%"}},{"$f":"D12+D13","v":{"v":0.358,"d":"35.8%"}},{"v":0.29200000000000004,"d":"29.2%"},{"v":0.236,"d":"23.6%"},{"v":0.195,"d":"19.5%"},{"v":0.16749999999999998,"d":"16.8%"}]
[]
[]
[]
[]
[null,"Fees Sunk / Not-Sunk vs phase"]
[null,null,"PBE","IBE","DBE","PE1","PE2(EE)"]
[null,"Project Development Consultancy Fees","Not sunk","Not sunk","Sunk","Sunk","Sunk"]
[null,"Project Development AT costs","Not sunk","Not sunk","Sunk","Sunk","Sunk"]
[null,"Pre-Implementation Consultancy Fees","Not sunk","Not sunk","Not sunk","Not sunk","Sunk"]
[null,"Pre-Implementation AT costs","Not sunk","Not sunk","Not sunk","Not sunk","Sunk"]
[null,"Implementation Consultancy Fees","Not sunk","Not sunk","Not sunk","Not sunk","Not sunk"]
[null,"Implementation AT costs","Not sunk","Not sunk","Not sunk","Not sunk","Not sunk"]