{"text_format":"3","workbook":"xlsx","n_sheets":22,"sheets":["Summary","Prelims","Designing & Fees","Civils","Structures","Mechanical","Electrical","TESTING, COMMISIONING MAINTENAN","SUMMARY (2)","Exchange Rate& Inflation","STAGE BREAKDOWN","Monthly Cashflow-Summary","CASHFLOW-CONSTRUCTION CONS","BREAKDOWN","PM","ARCH","QS","STRUC","CIVIL","MECH","ELEC","FIRE"],"not_rendered":{"charts":3,"external_links":141,"defined_names":16787,"comments":13},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":56,"n_cols":6,"rows_kept":56,"merged":[[6,3,8,3],[6,4,8,4],[6,5,8,5]]}
["Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"]
["Revision  Rev 0"]
["Summary"]
[]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[null,"SUMMARY"]
[]
[{"v":1,"d":"1.00"},{"$f":"+Prelims!A3","v":"Section 01 - Preliminaries & General"},"Sum",{"v":1,"d":"1.00"},{"$f":"+Prelims!F27","v":0},{"$f":"+D13*E13","v":0}]
[]
[{"v":2,"d":"2.00"},{"$f":"+'Designing & Fees'!A3","v":"Section 02 -Designing & Professional Fees"},"Sum",{"v":1,"d":"1.00"},{"$f":"+'Designing & Fees'!F25","v":0},{"$f":"+D15*E15","v":0}]
[]
[{"v":3,"d":"3.00"},{"$f":"+Civils!A3","v":"Section 03 - Civil Works"},"Sum",{"v":1,"d":"1.00"},{"$f":"+Civils!F42","v":0},{"$f":"+D17*E17","v":0}]
[]
[{"v":4,"d":"4.00"},{"$f":"+Structures!A3","v":"Section 04 - Structures"},"Sum",{"v":1,"d":"1.00"},{"$f":"+Structures!F43","v":0},{"$f":"+D19*E19","v":0}]
[]
[{"v":5,"d":"5.00"},{"$f":"+Mechanical!A3","v":"Section 05 - Mechanical & Fire"},"Sum",{"v":1,"d":"1.00"},{"$f":"+Mechanical!F63","v":0},{"$f":"+D21*E21","v":0}]
[]
[{"v":6,"d":"6.00"},{"$f":"+Electrical!A3","v":"Section 06 - Electrical Installations"},"Sum",{"v":1,"d":"1.00"},{"$f":"+Electrical!F55","v":0},{"$f":"+D23*E23","v":0}]
[]
[{"v":7,"d":"7.00"},{"$f":"+'TESTING, COMMISIONING MAINTENAN'!A3","v":"Section 07 - Testing, Comminitioning and Technical Support"},"Sum",{"v":1,"d":"1.00"},{"$f":"+'TESTING, COMMISIONING MAINTENAN'!F50","v":0},{"$f":"+D25*E25","v":0}]
[]
[]
[null,"TOTAL CONTRACT VALUE EXCL CONTIGENCY",{"$nulls":3},{"$f":"SUM(F13:F27)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[null,"TOTAL CONTRACT VALUE EXCL VAT",{"$nulls":3},{"$f":"SUM(F28:F31)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":23}
["TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":4},{"$f":"+F32","v":{"v":0,"d":"0.00"}}]

{"sheet":"Prelims","index":1,"n_rows":27,"n_cols":6,"rows_kept":27,"merged":[[5,3,7,3],[5,4,7,4],[5,5,7,5]]}
[{"$f":"+Summary!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+Summary!A2","v":"Revision  Rev 0"}]
["Section 01 - Preliminaries & General"]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[1,"PRELIMINARIES AND GENERAL"]
[]
["1.1","FIXED CHARGE ITEMS "]
[]
[{"$nulls":5},{"$f":"D14*E14","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":5},{"$f":"D16*E16","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":5},{"$f":"D18*E18","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":8}
[null,"TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":3},{"$f":"+SUM(F12:F26)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Designing & Fees","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[5,3,7,3],[5,4,7,4],[5,5,7,5]]}
[{"$f":"+Prelims!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+Prelims!A2","v":"Revision  Rev 0"}]
["Section 02 -Designing & Professional Fees"]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[2,"PROFFESIONAL FEES"]
[]
[2.1]
[]
[{"$nulls":5},{"$f":"+D14*E14","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":5},{"$f":"+D16*E16","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
[{"$nulls":5},{"$f":"+D20*E20","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":5},{"$f":"+D22*E22","v":{"v":0,"d":"R0.00"}}]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":4},{"$f":"+SUM(F13:F23)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Civils","index":3,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[6,3,8,3],[6,4,8,4],[6,5,8,5]]}
[{"$f":"+'Designing & Fees'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'Designing & Fees'!A2","v":"Revision  Rev 0"}]
["Section 03 - Civil Works"]
[]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[3,"CIVIL WORKS"]
[]
[3.1]
[]
[{"$nulls":5},{"$f":"+D15*E15","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":5},{"$f":"+D17*E17","v":{"v":0,"d":"R0.00"}}]
[3.2]
[]
[{"$nulls":5},{"$f":"+D20*E20","v":{"v":0,"d":"R0.00"}}]
[]
[3.3]
[]
[{"$nulls":5},{"$f":"+D24*E24","v":{"v":0,"d":"R0.00"}}]
[]
[3.4]
[]
[{"$nulls":5},{"$f":"+D28*E28","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":5},{"v":0,"d":"R0.00"}]
[3.5]
[]
[{"$nulls":5},{"$f":"E33*D33","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":5},{"$f":"E35","v":{"v":0,"d":"R0.00"}}]
[]
[3.6]
[]
[{"$nulls":5},{"$f":"E39","v":{"v":0,"d":"R0.00"}}]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":4},{"$f":"+SUM(F12:F40)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Structures","index":4,"n_rows":43,"n_cols":6,"rows_kept":43,"merged":[[6,3,8,3],[6,4,8,4],[6,5,8,5]]}
[{"$f":"+'Designing & Fees'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'Designing & Fees'!A2","v":"Revision  Rev 0"}]
["Section 04 - Structures"]
[]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[4,"Structures"]
[]
[4.1]
[]
[]
[]
["4.1.1",{"$nulls":4},{"$f":"+D17*E17","v":{"v":0,"d":"R0.00"}}]
[]
["4.1.2",{"$nulls":4},{"$f":"+D19*E19","v":{"v":0,"d":"R0.00"}}]
[]
["4.1.3",{"$nulls":4},{"$f":"+D21*E21","v":{"v":0,"d":"R0.00"}}]
[]
[4.2]
[]
["4.2.1",{"$nulls":4},{"$f":"+D25*E25","v":{"v":0,"d":"R0.00"}}]
[]
["4.2.2"]
[]
["4.2.3",{"$nulls":4},{"$f":"+D29*E29","v":{"v":0,"d":"R0.00"}}]
[]
[4.3]
[]
["4.3.1",{"$nulls":4},{"$f":"+D33*E33","v":{"v":0,"d":"R0.00"}}]
[]
[4.4]
[]
["4.4.1",{"$nulls":4},{"$f":"+D37*E37","v":{"v":0,"d":"R0.00"}}]
[]
["4.4.2",{"$nulls":4},{"$f":"+D39*E39","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":4},{"$f":"+SUM(F11:F40)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Mechanical","index":5,"n_rows":63,"n_cols":6,"rows_kept":63,"merged":[[6,3,8,3],[6,4,8,4],[6,5,8,5]]}
[{"$f":"+'Designing & Fees'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'Designing & Fees'!A2","v":"Revision  Rev 0"}]
["Section 05 - Mechanical & Fire"]
[]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[5,"Mechanical"]
[]
[5.1]
[]
["5.1.1",null,"Sum",null,null,{"$f":"+D15*E15","v":{"v":0,"d":"R0.00"}}]
[]
["5.1.2",null,"Sum",null,null,{"$f":"+D17*E17","v":{"v":0,"d":"R0.00"}}]
[]
["5.1.3",null,"Sum",null,null,{"$f":"+D19*E19","v":{"v":0,"d":"R0.00"}}]
[]
["5.1.4",null,"Sum",null,null,{"$f":"+D21*E21","v":{"v":0,"d":"R0.00"}}]
[]
[5.2]
[]
["5.2.1",null,"Sum",null,null,{"$f":"+D25*E25","v":{"v":0,"d":"R0.00"}}]
[]
[5.3]
[]
["5.3.1",null,"Sum",null,null,{"$f":"+D29*E29","v":{"v":0,"d":"R0.00"}}]
[]
[5.4]
[]
["5.4.1",null,"Sum",null,null,{"$f":"+D33*E33","v":{"v":0,"d":"R0.00"}}]
[]
[5.5]
[]
["5.5.1",null,"m2",null,null,{"$f":"+D37*E37","v":{"v":0,"d":"R0.00"}}]
[]
[5.6]
[]
["5.6.1",null,"m2",null,null,{"$f":"+D41*E41","v":{"v":0,"d":"R0.00"}}]
[]
[5.7]
[]
["5.7.1",null,"m2",null,null,{"$f":"+D45*E45","v":{"v":0,"d":"R0.00"}}]
[]
[5.8]
[]
["5.8.1",null,"Sum",null,null,{"$f":"+D49*E49","v":{"v":0,"d":"R0.00"}}]
[]
[5.9]
[]
["5.9.1",null,"m",null,null,{"$f":"+D53*E53","v":{"v":0,"d":"R0.00"}}]
[]
[{"v":5.1,"d":"5.10"}]
[]
["5.10.1",null,"Sum",null,null,{"$f":"E57*D57","v":{"v":0,"d":"R0.00"}}]
[]
["5.10.2",null,"Sum",null,null,{"$f":"E59*D59","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":4},{"$f":"+SUM(F11:F60)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Electrical","index":6,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[6,3,8,3],[6,4,8,4],[6,5,8,5]]}
[{"$f":"+'Designing & Fees'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'Designing & Fees'!A2","v":"Revision  Rev 0"}]
["Section 06 - Electrical Installations"]
[]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[6,"Electrical and C&I  Installations"]
[]
[6.1]
[]
["6.1.1",null,"no",null,null,{"$f":"+D15*E15","v":{"v":0,"d":"R0.00"}}]
[]
["6.1.2",null,"no",null,null,{"$f":"+D17*E17","v":{"v":0,"d":"R0.00"}}]
[]
["6.1.3",null,"Sum",null,null,{"$f":"+D19*E19","v":{"v":0,"d":"R0.00"}}]
[]
[6.2]
[]
["6.2.1",null,"Sum",null,null,{"$f":"+D23*E23","v":{"v":0,"d":"R0.00"}}]
[]
["6.2.2",null,"no",null,null,{"$f":"+D25*E25","v":{"v":0,"d":"R0.00"}}]
[]
[6.3]
[]
["6.3.1",null,"Sum",null,null,{"$f":"E29","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":25}
["TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":4},{"$f":"+SUM(F11:F52)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"TESTING, COMMISIONING MAINTENAN","index":7,"n_rows":50,"n_cols":6,"rows_kept":50,"merged":[[6,3,8,3],[6,4,8,4],[6,5,8,5]]}
[{"$f":"+'Designing & Fees'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'Designing & Fees'!A2","v":"Revision  Rev 0"}]
["Section 07 - Testing, Comminitioning and Technical Support"]
[]
[]
[]
[{"$nulls":3},"Quantity","Rate","Total Amount"]
["Item No.","Description","Unit"]
[]
[]
[6,"TESTING, COMMISIONING AND TRAINING"]
[]
[null,"Testing, Commissioning & Hand-over","Sum",null,null,{"$f":"+D13*E13","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Training of Eskom Staff","Sum",null,null,{"$f":"+D15*E15","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Allow for the maintenance and technical support.( as and when required)-- Technician","R/hr",{"v":120,"d":"120.00"},null,{"$f":"+D17*E17","v":{"v":0,"d":"R0.00"}}]
[null,"Allow for the maintenance and technical support.( as and when required)-- Engineer","R/hr",{"v":120,"d":"120.00"},null,{"$f":"+D18*E18","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":31}
["TOTAL CARRIED FORWARD TO SUMMARY OF SCHEDULE OF QUANTITIES",{"$nulls":4},{"$f":"+SUM(F10:F47)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"SUMMARY (2)","index":8,"n_rows":41,"n_cols":46,"rows_kept":41,"hidden":true,"merged":[[3,0,3,3],[7,7,7,23],[7,25,7,43],[9,7,11,7],[9,9,11,9],[9,11,11,11],[9,13,11,13],[9,15,11,15],[9,17,11,17],[9,19,11,19],[9,21,11,21],[9,23,11,23],[9,25,11,25],[9,27,11,27],[9,29,11,29],[9,31,11,31],[9,33,11,33],[9,35,11,35],[9,37,11,37],[9,39,11,39],[9,41,11,41],[9,43,11,43],[27,1,27,2],[27,3,27,4],[32,3,32,4]]}
[{"$f":"+'TESTING, COMMISIONING MAINTENAN'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'TESTING, COMMISIONING MAINTENAN'!A2","v":"Revision  Rev 0"}]
[]
[]
[]
[]
[]
[{"$nulls":7},"CORE CONSULTANTS",{"$nulls":17},"ADVISORY CONSULTANTS"]
[]
[{"$nulls":7},"Project Manager",null,{"$f":"BREAKDOWN!J19","v":"Architect"},null,{"$f":"BREAKDOWN!M19","v":"Quantity Surveyor"},null,{"$f":"BREAKDOWN!P19","v":"Structural Engineer"},null,{"$f":"BREAKDOWN!S19","v":"Civil Engineer"},null,{"$f":"BREAKDOWN!V19","v":"Mechanical Engineer"},null,{"$f":"BREAKDOWN!Y19","v":"Electrical Engineer"},null,{"$f":"BREAKDOWN!AE19","v":"Fire Engineer"},null,{"$f":"BREAKDOWN!AH19","v":"Wet Services"},null,"Project Manager",null,{"$f":"BREAKDOWN!AB19","v":"Rational Fire Engineer"},null,{"$f":"BREAKDOWN!AK19","v":"Landscape Architect"},null,"Safety Consultant",null,"Façade Engineer",null,"Green Consultant",null,"Lift Consultant",null,"Acoustic Consultant",null,"Services Co-ordination ",null,"Tenant Co-ordinator"]
[]
[]
[]
[null,"Fee As per Calculation",null,null,{"$f":"F14/D28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H14:AR14)","v":{"$error":"#DIV/0!"}},null,{"$f":"PM!D36","v":{"$error":"#DIV/0!"}},null,{"$f":"ARCH!D49","v":{"$error":"#DIV/0!"}},null,{"$f":"QS!D114","v":{"$error":"#DIV/0!"}},null,{"$f":"STRUC!D97","v":{"$error":"#DIV/0!"}},null,{"$f":"CIVIL!D97","v":{"$error":"#DIV/0!"}},null,{"$f":"MECH!D70","v":{"$error":"#DIV/0!"}},null,{"$f":"ELEC!D68","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!D68","v":{"$error":"#DIV/0!"}},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"Total Project Discount",null,null,{"$f":"+F16/F14*-1","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H16:AR16)","v":{"$error":"#DIV/0!"}},null,{"$f":"PM!D38","v":{"$error":"#DIV/0!"}},null,{"$f":"ARCH!D51","v":{"$error":"#DIV/0!"}},null,{"$f":"QS!D116","v":{"$error":"#DIV/0!"}},null,{"$f":"STRUC!D98","v":{"$error":"#DIV/0!"}},null,{"$f":"CIVIL!D98","v":{"$error":"#DIV/0!"}},null,{"$f":"MECH!D71","v":{"$error":"#DIV/0!"}},null,{"$f":"ELEC!D69","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!D69","v":{"$error":"#DIV/0!"}},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"+AB20+AD20+AF20+AJ20","v":0}]
[]
[null,"Total Project Disbursements",null,null,{"v":0,"d":"0.0%"},{"$f":"SUM(H18:AJ18)","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(H14:H16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(J14:J16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(L14:L16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(N14:N16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(P14:P16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(R14:R16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(T14:T16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(V14:V16)*$E$18","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(X14:X16)*$E$18","v":0},null,{"$f":"+SUM(Z14:Z16)*$E$18","v":0},null,{"$f":"+SUM(AB14:AB16)*$E$18","v":0},null,{"$f":"+SUM(AD14:AD16)*$E$18","v":0},null,{"$f":"+SUM(AF14:AF16)*$E$18","v":0},null,{"$f":"+SUM(AH14:AH16)*$E$18","v":0},null,{"$f":"+SUM(AJ14:AJ16)*$E$18","v":0},null,{"$f":"+SUM(AL14:AL16)*$E$18","v":0},null,{"$f":"+SUM(AN14:AN16)*$E$18","v":0},null,{"$f":"+SUM(AP14:AP16)*$E$18","v":0},null,{"$f":"+SUM(AR14:AR16)*$E$18","v":0}]
[]
[null,"Adjusted fee",{"$nulls":3},{"$f":"SUM(H20:AR20)","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(H14:H19))","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(J14:J19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(L14:L19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(N14:N19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(P14:P19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(R14:R19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(T14:T19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(V14:V19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(X14:X19)","v":0},null,{"$f":"SUM(Z14:Z19)","v":0},null,{"$f":"SUM(AB14:AB19)","v":0},null,{"$f":"SUM(AD14:AD19)","v":0},null,{"$f":"SUM(AF14:AF19)","v":0},null,{"$f":"SUM(AH14:AH19)","v":0},null,{"$f":"SUM(AJ14:AJ19)","v":0},null,{"$f":"SUM(AL14:AL19)","v":0},null,{"$f":"SUM(AN14:AN19)","v":0},null,{"$f":"SUM(AP14:AP19)","v":0},null,{"$f":"SUM(AR14:AR19)","v":0}]
[]
[null,"Total Project Disbursements",null,null,{"v":0.02,"d":"2.0%"},{"$f":"SUM(H22:AJ22)","v":{"$error":"#DIV/0!"}},null,{"$f":"+H20*E22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(J20)*$E$22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(L20)*$E$22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(N20)*$E$22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(P20)*$E$22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(R20)*$E$22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(T20)*$E$22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(V20)*$E$22","v":{"$error":"#DIV/0!"}},null,{"$f":"+SUM(X20)*$E$22","v":0},null,{"$f":"+SUM(Z18:Z20)*$E$18","v":0},null,{"$f":"+SUM(AB20)*$E$22","v":0},null,{"$f":"+SUM(AD20)*$E$22","v":0},null,{"$f":"+SUM(AF20)*$E$22","v":0},null,{"$f":"+SUM(AH20)*$E$22","v":0},null,{"$f":"+SUM(AJ20)*$E$22","v":0},null,{"$f":"+SUM(AL20)*$E$22","v":0},null,{"$f":"+SUM(AN20)*$E$22","v":0},null,{"$f":"+SUM(AP20)*$E$22","v":0},null,{"$f":"+SUM(AR20)*$E$22","v":0}]
[]
[null,"Adjusted fee (Including Disbursements)",{"$nulls":3},{"$f":"SUM(H24:AR24)","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(H20:H23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(J20:J23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(L20:L23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(N20:N23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(P20:P23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(R20:R23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(T20:T23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(V20:V23))","v":{"$error":"#DIV/0!"}},null,{"$f":"(SUM(X20:X23))","v":0},null,{"$f":"SUM(Z18:Z23)","v":0},null,{"$f":"(SUM(AB20:AB23))","v":0},null,{"$f":"(SUM(AD20:AD23))","v":0},null,{"$f":"(SUM(AF20:AF23))","v":0},null,{"$f":"(SUM(AH20:AH23))","v":0},null,{"$f":"(SUM(AJ20:AJ23))","v":0},null,{"$f":"(SUM(AL20:AL23))","v":0},null,{"$f":"(SUM(AN20:AN23))","v":0},null,{"$f":"(SUM(AP20:AP23))","v":0},null,{"$f":"(SUM(AR20:AR23))","v":0}]
[]
[null,"% on Fees",{"$nulls":3},{"$f":"SUM(H26:AJ26)","v":{"$error":"#DIV/0!"}},null,{"$f":"H20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"J20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"L20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"N20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"P20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"R20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"T20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"V20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"X20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"Z20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AB20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AD20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AF20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AH20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AJ20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AL20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AN20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AP20/$F$20","v":{"$error":"#DIV/0!"}},null,{"$f":"AR20/$F$20","v":{"$error":"#DIV/0!"}}]
[]
[null,"% on Construction Value Core Consultants ",null,{"$f":"BREAKDOWN!F71","v":{"v":1888189.4375,"d":"R 1,888,189"}},null,{"$f":"SUM(H28:Y28)","v":{"$error":"#DIV/0!"}},null,{"$f":"H20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"J20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"L20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"N20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"P20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"R20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"T20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"V20/$D$28","v":{"$error":"#DIV/0!"}},null,{"$f":"X20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"Z20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AB20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AD20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AF20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AH20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AJ20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AL20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AN20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AP20/$D$28","v":{"v":0,"d":"0.00%"}},null,{"$f":"AR20/$D$28","v":{"v":0,"d":"0.00%"}}]
[]
[]
[]
[{"$nulls":5},"ALL CHECKS TO BE = 0"]
[{"$nulls":5},{"$f":"SUM(F14:F18)","v":{"$error":"#DIV/0!"}},null,{"$f":"'STAGE BREAKDOWN'!H23","v":{"$error":"#DIV/0!"}},null,{"$f":"ARCH!D56","v":{"$error":"#DIV/0!"}},null,{"$f":"QS!D121","v":{"$error":"#DIV/0!"}},null,{"$f":"'STAGE BREAKDOWN'!N23","v":{"$error":"#DIV/0!"}},null,{"$f":"CIVIL!D103","v":{"$error":"#DIV/0!"}},null,{"$f":"MECH!D76","v":{"$error":"#DIV/0!"}},null,{"$f":"ELEC!D74","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E86","v":{"$error":"#DIV/0!"}},0,0,"Excl Vat",{"$f":"PM!D43","v":{"$error":"#DIV/0!"}},null,{"$f":"'SUMMARY (2)'!AB24","v":0},0,{"$f":"'STAGE BREAKDOWN'!AD23","v":0},0,{"$f":"AF24","v":0},0,{"$f":"AH20","v":0},0,{"$f":"AJ20","v":0},0,{"$f":"AL20","v":0},0,{"$f":"AN20","v":0},0,{"$f":"AP20","v":0},0,{"$f":"AR20","v":0}]
[{"$nulls":5},{"$f":"F20-F33","v":{"$error":"#DIV/0!"}},null,{"$f":"H33-SUM(H20:H22)","v":{"$error":"#DIV/0!"}},{"$f":"I33-SUM(I20:I22)","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK","CHECK","CHECK","CHECK","CHECK",null,"CHECK","CHECK","CHECK"]
[]
[{"$nulls":5},{"$f":"+F24-'STAGE BREAKDOWN'!D23","v":{"$error":"#DIV/0!"}},{"$nulls":9},{"$f":"IF(AND(Z34=0,J34=0,L34=0,N34=0,P34=0,R34=0,T34=0,AB34=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[{"$nulls":23},"Should be ZERO"]

{"sheet":"Exchange Rate& Inflation","index":9,"n_rows":725,"n_cols":9,"rows_kept":725,"hidden":true,"merged":[[1,7,1,10],[5,2,5,3]]}
[]
[{"$nulls":5},{"$f":"++#REF!","v":{"$error":"#REF!"}}]
[]
["PROJECT DESCRIPTION :",null,{"$f":"+'TESTING, COMMISIONING MAINTENAN'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Mechanical"]
[]
[null,null,"Eectrolysers"]
[]
[null,null,"AEM Flex 120 - 25 Nm³/h (Purity of 99.95%) 50 AEM stack modules, control system, power supplies, safety system, electrolyte circuit, hydrogen chiller/heating, assembled and pre-tested, KOH and Glycol containment; Skid-mounted. Set of consumables for commissioning included",1,{"$f":"+Mechanical!E15","v":{"v":0,"d":"R 0.00"}},{"$f":"+D12*E12","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Dryer (Increase purity to 99.999%)",1,{"$f":"+Mechanical!E17","v":{"v":0,"d":"R 0.00"}},{"$f":"+D14*E14","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Water Purification System for the Flex 120",1,{"$f":"+Mechanical!E19","v":{"v":0,"d":"R 0.00"}},{"$f":"+D16*E16","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Containerization, integration and BOP (20ft high cube container",1,{"$f":"+Mechanical!E21","v":{"v":0,"d":"R 0.00"}},{"$f":"+D18*E18","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Bulk Storage Vesels"]
[]
[null,null,"Manufacture,Inspection, Testing and ex-works delivery of 3 x 316L & 3 x P355 x 24000L  Hydrogen Storage Vessels. Pressure Vessels",1,{"$f":"+Mechanical!E25","v":{"v":0,"d":"R 0.00"}},{"$f":"+D22*E22","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Pressure Reduction and Metering Station"]
[]
[null,null,"Manufacture and assembly metering station",1,{"$f":"+Mechanical!E29","v":{"v":0,"d":"R 0.00"}},{"$f":"+D26*E26","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Sub Total",null,null,{"$f":"+SUM(F12:F26)","v":0}]
[]
[]
[]
[]
[{"$nulls":4},"Sub Total",{"$f":"+F28","v":{"v":0,"d":"0.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 EUR = R19.88 (02/05/2024)",{"$nulls":3},{"$f":"F33","v":{"v":0,"d":"0.00"}}]
[null,"Exchange adjustment to 09/05/2024 (EUR = R19.98)",{"$nulls":3},{"$f":"F35*19.98/19.98-F35","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"F35+F36","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Overseas inflation  per annum: March 2025 - January 2026",null,{"$f":"0.0425","v":{"v":0.0425,"d":"4.25%"}},"Current US Inflation Rates: 2000-2025 (usinflationcalculator.com)"]
[null,null,"2025-03-01",{"$f":"F37","v":{"v":0,"d":"0.00"}}]
[null,null,"2026-01-30",{"$f":"D40*1.425","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"D40*(1+E39)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D42-D40","v":{"v":0,"d":"0.00"}},{"$f":"E44","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F44+F28","v":{"v":0,"d":"R 0.00"}}]
[null,null,"Cost of cover ",{"$f":"+F724","v":{"v":0.055656369929097047,"d":"0.056"}},null,{"$f":"+F46*D47","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F47+F46","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Supply PC and Software ",1,{"v":210000,"d":"R 210,000.00"},{"$f":"E55*D55","v":{"v":210000,"d":"210,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F55:F56)","v":{"v":210000,"d":"210,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F57","v":{"v":210000,"d":"210,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F59*10.586/10.1229-F59","v":{"v":9607.029606140539,"d":"9,607.03"}}]
[{"$nulls":5},{"$f":"F59+F60","v":{"v":219607.02960614054,"d":"219,607.03"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F61","v":{"v":219607.02960614054,"d":"219,607.03"}}]
[null,null,{"$f":"+C64+16","v":"2009-02-27"},{"$f":"D64*1.03","v":{"v":226195.24049432477,"d":"226,195.24"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D64*(1+E65)","v":{"v":234979.5216785704,"d":"234,979.52"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D66-D64","v":{"v":15372.492072429857,"d":"15,372.49"}},{"$f":"E68","v":{"v":15372.492072429857,"d":"R 15,372.49"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F68+F61","v":{"v":234979.5216785704,"d":"R 234,979.52"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F70*0.1","v":{"v":23497.95216785704,"d":"R 23,497.95"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F71+F70","v":{"v":258477.47384642743,"d":"258,477.47"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Control Panels ",1,{"v":1800000,"d":"R 1,800,000.00"},{"$f":"E79*D79","v":{"v":1800000,"d":"1,800,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F79:F80)","v":{"v":1800000,"d":"1,800,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F81","v":{"v":1800000,"d":"1,800,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F83*10.586/10.1229-F83","v":{"v":82345.9680526331,"d":"82,345.97"}}]
[{"$nulls":5},{"$f":"F83+F84","v":{"v":1882345.968052633,"d":"1,882,345.97"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F85","v":{"v":1882345.968052633,"d":"1,882,345.97"}}]
[null,null,{"$f":"+C88+16","v":"2009-02-27"},{"$f":"D88*1.03","v":{"v":1938816.3470942122,"d":"1,938,816.35"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D88*(1+E89)","v":{"v":2014110.1858163176,"d":"2,014,110.19"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D90-D88","v":{"v":131764.21776368446,"d":"131,764.22"}},{"$f":"E92","v":{"v":131764.21776368446,"d":"R 131,764.22"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F92+F85","v":{"v":2014110.1858163176,"d":"R 2,014,110.19"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F94*0.1","v":{"v":201411.01858163177,"d":"R 201,411.02"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F95+F94","v":{"v":2215521.2043979494,"d":"2,215,521.20"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Routers ",1,{"v":190000,"d":"R 190,000.00"},{"$f":"E103*D103","v":{"v":190000,"d":"190,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F103:F104)","v":{"v":190000,"d":"190,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F105","v":{"v":190000,"d":"190,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F107*10.586/10.1229-F107","v":{"v":8692.07440555573,"d":"8,692.07"}}]
[{"$nulls":5},{"$f":"F107+F108","v":{"v":198692.07440555573,"d":"198,692.07"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F109","v":{"v":198692.07440555573,"d":"198,692.07"}}]
[null,null,{"$f":"+C112+16","v":"2009-02-27"},{"$f":"D112*1.03","v":{"v":204652.83663772242,"d":"204,652.84"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D112*(1+E113)","v":{"v":212600.51961394463,"d":"212,600.52"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D114-D112","v":{"v":13908.445208388905,"d":"13,908.45"}},{"$f":"E116","v":{"v":13908.445208388905,"d":"R 13,908.45"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F116+F109","v":{"v":212600.51961394463,"d":"R 212,600.52"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F118*0.1","v":{"v":21260.051961394463,"d":"R 21,260.05"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F119+F118","v":{"v":233860.5715753391,"d":"233,860.57"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Outstations",1,{"v":1400000,"d":"R 1,400,000.00"},{"$f":"E127*D127","v":{"v":1400000,"d":"1,400,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F127:F128)","v":{"v":1400000,"d":"1,400,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F129","v":{"v":1400000,"d":"1,400,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F131*10.586/10.1229-F131","v":{"v":64046.86404093704,"d":"64,046.86"}}]
[{"$nulls":5},{"$f":"F131+F132","v":{"v":1464046.864040937,"d":"1,464,046.86"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F133","v":{"v":1464046.864040937,"d":"1,464,046.86"}}]
[null,null,{"$f":"+C136+16","v":"2009-02-27"},{"$f":"D136*1.03","v":{"v":1507968.2699621653,"d":"1,507,968.27"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D136*(1+E137)","v":{"v":1566530.1445238027,"d":"1,566,530.14"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D138-D136","v":{"v":102483.28048286564,"d":"102,483.28"}},{"$f":"E140","v":{"v":102483.28048286564,"d":"R 102,483.28"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F140+F133","v":{"v":1566530.1445238027,"d":"R 1,566,530.14"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F142*0.1","v":{"v":156653.01445238027,"d":"R 156,653.01"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F143+F142","v":{"v":1723183.158976183,"d":"1,723,183.16"}}]
[]
[]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Control Panel ",1,{"v":1200000,"d":"R 1,200,000.00"},{"$f":"E153*D153","v":{"v":1200000,"d":"1,200,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F153:F154)","v":{"v":1200000,"d":"1,200,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F155","v":{"v":1200000,"d":"1,200,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F157*10.586/10.1229-F157","v":{"v":54897.31203508889,"d":"R 54,897.31"}}]
[{"$nulls":5},{"$f":"F157+F158","v":{"v":1254897.312035089,"d":"R 1,254,897.31"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2007-05-25",{"$f":"F159","v":{"v":1254897.312035089,"d":"1,254,897.31"}}]
[null,null,{"$f":"+C162+31+30+31+30+31+30+31+30+31+30+31+30+31+8","v":"2008-07-03"},{"$f":"D162*1.03","v":{"v":1292544.2313961417,"d":"1,292,544.23"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D162*(1+E163)","v":{"v":1342740.1238775451,"d":"1,342,740.12"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D164-D162","v":{"v":87842.81184245623,"d":"87,842.81"}},{"$f":"E166","v":{"v":87842.81184245623,"d":"R 87,842.81"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F166+F159","v":{"v":1342740.1238775451,"d":"R 1,342,740.12"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate) ",null,null,{"$f":"F168*0.1","v":{"v":134274.0123877545,"d":"R 134,274.01"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F169+F168","v":{"v":1477014.1362652997,"d":"1,477,014.14"}}]
{"$rows_empty":151}
["Labour"]
["21/07/2010","21/05/2013"]
[13859,16239.3,{"$f":"B325/A325","v":1.1717512086009092}]
["Revised "]
["21/07/2010","19/06/2017",null,"SEIFSA Table C-3 All hourly Labour"]
[{"$f":"13859/162.393","v":85.34234850024323},137.8,{"$f":"B328/A328","v":1.614673165452053}]
[]
["Revised "]
["21/07/2010","19/06/2017",null,"SEIFSA Table G-Electrical Material "]
[{"$f":"1253.9/13.38730672","v":93.66335038299624},116.6,{"$f":"B332/A332","v":1.244883932970731}]
[]
[{"$nulls":5},{"$f":"+F46*0.05","v":0}]
[]
[]
[{"$nulls":8},"ESTIMATE"]
["Item No.","Description","Quantity"," Unit Price"," Amount","ROE( EUR=R14.3955) (19/01/2014)","Inflation ","Cost of cover"," Amount"]
[1,{"$f":"+C4","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"},1,{"$f":"E8","v":{"v":0,"d":"0.00"}},{"$f":"+C339*D339","v":{"v":0,"d":"0.00"}},{"$f":"F37","v":{"v":0,"d":"0.00"}},{"$f":"E44","v":{"v":0,"d":"0.00"}},{"$f":"F47","v":{"v":0,"d":"0.00"}},{"$f":"F339+G339+H339","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":8},{"$f":"+I339-F49","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},3146839.87]
[]
[{"$nulls":8},{"v":1.0948221919021877,"d":"1.09"}]
[{"$nulls":8},{"$f":"+I339/I345","v":0}]
[null,"PROJECT MANAGEMENT",{"$nulls":6},{"$f":"+I346-I343","v":{"v":-3146839.87,"d":"-3,146,839.87"}}]
[]
[]
[{"$nulls":4},"Sub Total",{"v":112546.8,"d":"112,546.80"}]
[]
[null,"Based on Foreign exchange rate of 1 EUR = R14.3955(19/01/2014)",{"$nulls":3},{"$f":"F350","v":{"v":112546.8,"d":"112,546.80"}}]
[null,"Exchange adjustment to 25/02/2022 (EUR = R17.0261)",{"$nulls":3},{"$f":"F352*17.0261/14.3955-F352","v":{"v":20566.53899343543,"d":"20,566.54"}}]
[{"$nulls":5},{"$f":"F352+F353","v":{"v":133113.33899343543,"d":"133,113.34"}}]
[]
[null,null,"Overseas inflation  per annum:",null,null,{"$f":"5.1/1.9","v":{"v":2.6842105263157894,"d":"R 2.68"}}]
[null,null,"2014-01-14",{"$f":"F354","v":{"v":133113.33899343543,"d":"133,113.34"}},null,null,{"$f":"9*12","v":108}]
[null,null,"2022-02-25",{"$f":"D357*1.459","v":{"v":194212.36159142232,"d":"194,212.36"}},{"$f":"0.051/12*108","v":{"v":0.45899999999999996,"d":"0.459"}}]
[{"$nulls":3},{"$f":"D357*(1+E358)","v":{"v":194212.36159142232,"d":"194,212.36"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D359-D357","v":{"v":61099.022597986885,"d":"61,099.02"}},{"$f":"E361","v":{"v":61099.022597986885,"d":"R 61,099.02"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F361+F354","v":{"v":194212.36159142232,"d":"R 194,212.36"}}]
[null,null,"Cost of cover to be borne by supplier (6% interest rate )",null,null,{"$f":"F363*0.06","v":{"v":11652.741695485338,"d":"R 11,652.74"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F364+F363","v":{"v":205865.10328690766,"d":"205,865.10"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Supply PC and Software ",1,{"v":210000,"d":"R 210,000.00"},{"$f":"E372*D372","v":{"v":210000,"d":"210,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F372:F373)","v":{"v":210000,"d":"210,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F374","v":{"v":210000,"d":"210,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F376*10.586/10.1229-F376","v":{"v":9607.029606140539,"d":"9,607.03"}}]
[{"$nulls":5},{"$f":"F376+F377","v":{"v":219607.02960614054,"d":"219,607.03"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F378","v":{"v":219607.02960614054,"d":"219,607.03"}}]
[null,null,{"$f":"+C381+16","v":"2009-02-27"},{"$f":"D381*1.03","v":{"v":226195.24049432477,"d":"226,195.24"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D381*(1+E382)","v":{"v":234979.5216785704,"d":"234,979.52"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D383-D381","v":{"v":15372.492072429857,"d":"15,372.49"}},{"$f":"E385","v":{"v":15372.492072429857,"d":"R 15,372.49"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F385+F378","v":{"v":234979.5216785704,"d":"R 234,979.52"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F387*0.1","v":{"v":23497.95216785704,"d":"R 23,497.95"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F388+F387","v":{"v":258477.47384642743,"d":"258,477.47"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Control Panels ",1,{"v":1800000,"d":"R 1,800,000.00"},{"$f":"E396*D396","v":{"v":1800000,"d":"1,800,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F396:F397)","v":{"v":1800000,"d":"1,800,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F398","v":{"v":1800000,"d":"1,800,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F400*10.586/10.1229-F400","v":{"v":82345.9680526331,"d":"82,345.97"}}]
[{"$nulls":5},{"$f":"F400+F401","v":{"v":1882345.968052633,"d":"1,882,345.97"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F402","v":{"v":1882345.968052633,"d":"1,882,345.97"}}]
[null,null,{"$f":"+C405+16","v":"2009-02-27"},{"$f":"D405*1.03","v":{"v":1938816.3470942122,"d":"1,938,816.35"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D405*(1+E406)","v":{"v":2014110.1858163176,"d":"2,014,110.19"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D407-D405","v":{"v":131764.21776368446,"d":"131,764.22"}},{"$f":"E409","v":{"v":131764.21776368446,"d":"R 131,764.22"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F409+F402","v":{"v":2014110.1858163176,"d":"R 2,014,110.19"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F411*0.1","v":{"v":201411.01858163177,"d":"R 201,411.02"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F412+F411","v":{"v":2215521.2043979494,"d":"2,215,521.20"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Routers ",1,{"v":190000,"d":"R 190,000.00"},{"$f":"E420*D420","v":{"v":190000,"d":"190,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F420:F421)","v":{"v":190000,"d":"190,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F422","v":{"v":190000,"d":"190,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F424*10.586/10.1229-F424","v":{"v":8692.07440555573,"d":"8,692.07"}}]
[{"$nulls":5},{"$f":"F424+F425","v":{"v":198692.07440555573,"d":"198,692.07"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F426","v":{"v":198692.07440555573,"d":"198,692.07"}}]
[null,null,{"$f":"+C429+16","v":"2009-02-27"},{"$f":"D429*1.03","v":{"v":204652.83663772242,"d":"204,652.84"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D429*(1+E430)","v":{"v":212600.51961394463,"d":"212,600.52"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D431-D429","v":{"v":13908.445208388905,"d":"13,908.45"}},{"$f":"E433","v":{"v":13908.445208388905,"d":"R 13,908.45"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F433+F426","v":{"v":212600.51961394463,"d":"R 212,600.52"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F435*0.1","v":{"v":21260.051961394463,"d":"R 21,260.05"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F436+F435","v":{"v":233860.5715753391,"d":"233,860.57"}}]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Outstations",1,{"v":1400000,"d":"R 1,400,000.00"},{"$f":"E444*D444","v":{"v":1400000,"d":"1,400,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F444:F445)","v":{"v":1400000,"d":"1,400,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F446","v":{"v":1400000,"d":"1,400,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F448*10.586/10.1229-F448","v":{"v":64046.86404093704,"d":"64,046.86"}}]
[{"$nulls":5},{"$f":"F448+F449","v":{"v":1464046.864040937,"d":"1,464,046.86"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2009-02-11",{"$f":"F450","v":{"v":1464046.864040937,"d":"1,464,046.86"}}]
[null,null,{"$f":"+C453+16","v":"2009-02-27"},{"$f":"D453*1.03","v":{"v":1507968.2699621653,"d":"1,507,968.27"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D453*(1+E454)","v":{"v":1566530.1445238027,"d":"1,566,530.14"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D455-D453","v":{"v":102483.28048286564,"d":"102,483.28"}},{"$f":"E457","v":{"v":102483.28048286564,"d":"R 102,483.28"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F457+F450","v":{"v":1566530.1445238027,"d":"R 1,566,530.14"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate )",null,null,{"$f":"F459*0.1","v":{"v":156653.01445238027,"d":"R 156,653.01"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F460+F459","v":{"v":1723183.158976183,"d":"1,723,183.16"}}]
[]
[]
[]
[]
[]
[]
[null,"Stock No.","Description","Quantity","Rate ","Amount "]
[null,null,"Control Panel ",1,{"v":1200000,"d":"R 1,200,000.00"},{"$f":"E470*D470","v":{"v":1200000,"d":"1,200,000.00"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"SUM(F470:F471)","v":{"v":1200000,"d":"1,200,000.00"}}]
[]
[null,"Based on Foreign exchange rate of 1 USD = R10.1229(27/02/2009)",{"$nulls":3},{"$f":"F472","v":{"v":1200000,"d":"1,200,000.00"}}]
[null,"Exchange adjustment to 09/03/2009 (USD = R10.586)",{"$nulls":3},{"$f":"F474*10.586/10.1229-F474","v":{"v":54897.31203508889,"d":"R 54,897.31"}}]
[{"$nulls":5},{"$f":"F474+F475","v":{"v":1254897.312035089,"d":"R 1,254,897.31"}}]
[]
[null,null,"Overseas inflation  per annum:"]
[null,null,"2007-05-25",{"$f":"F476","v":{"v":1254897.312035089,"d":"1,254,897.31"}}]
[null,null,{"$f":"+C479+31+30+31+30+31+30+31+30+31+30+31+30+31+8","v":"2008-07-03"},{"$f":"D479*1.03","v":{"v":1292544.2313961417,"d":"1,292,544.23"}},{"$f":"0.07/12*12","v":{"v":0.07,"d":"0.070"}}]
[{"$nulls":3},{"$f":"D479*(1+E480)","v":{"v":1342740.1238775451,"d":"1,342,740.12"}}]
[]
[null,null,"Overseas inflation over the above period",null,{"$f":"D481-D479","v":{"v":87842.81184245623,"d":"87,842.81"}},{"$f":"E483","v":{"v":87842.81184245623,"d":"R 87,842.81"}}]
[]
[{"$nulls":4},"Sub Total",{"$f":"F483+F476","v":{"v":1342740.1238775451,"d":"R 1,342,740.12"}}]
[null,null,"Cost of cover to be borne by supplier (10% interest rate) ",null,null,{"$f":"F485*0.1","v":{"v":134274.0123877545,"d":"R 134,274.01"}}]
[]
[{"$nulls":4},"Total ",{"$f":"F486+F485","v":{"v":1477014.1362652997,"d":"1,477,014.14"}}]
{"$rows_empty":151}
["Labour"]
["21/07/2010","21/05/2013"]
[13859,16239.3,{"$f":"B642/A642","v":1.1717512086009092}]
["Revised "]
["21/07/2010","19/06/2017",null,"SEIFSA Table C-3 All hourly Labour"]
[{"$f":"13859/162.393","v":85.34234850024323},137.8,{"$f":"B645/A645","v":1.614673165452053}]
[]
["Revised "]
["21/07/2010","19/06/2017",null,"SEIFSA Table G-Electrical Material "]
[{"$f":"1253.9/13.38730672","v":93.66335038299624},116.6,{"$f":"B649/A649","v":1.244883932970731}]
[]
[]
[]
[]
[{"$nulls":8},"ESTIMATE"]
["Item No.","Description","Quantity"," Unit Price"," Amount","ROE( EUR=R14.3955) (19/01/2014)","Inflation ","Cost of cover"," Amount"]
[1,{"$f":"+C284","v":0},1,{"$f":"E288","v":{"v":0,"d":"0.00"}},{"$f":"+C656*D656","v":{"v":0,"d":"0.00"}},{"$f":"F354","v":{"v":133113.33899343543,"d":"133,113.34"}},{"$f":"E361","v":{"v":61099.022597986885,"d":"61,099.02"}},{"$f":"F364","v":{"v":11652.741695485338,"d":"11,652.74"}},{"$f":"F656+G656+H656","v":{"v":205865.10328690766,"d":"205,865.10"}}]
{"$rows_empty":66}
[{"$nulls":5},{"$f":"1/18.42","v":0.054288816503800214}]
[{"$nulls":5},{"$f":"+F723*(1+5.6%*(31*8/360)/(1+5.5%)*(31*8/360))","v":0.055656369929097047}]
[{"$nulls":5},{"$f":"+F46*F724","v":0}]

{"sheet":"STAGE BREAKDOWN","index":10,"n_rows":70,"n_cols":47,"rows_kept":70,"hidden":true,"merged":[[3,0,3,2],[8,7,8,23],[8,25,8,42],[10,3,12,3],[10,5,12,5],[10,7,12,7],[10,9,12,9],[10,11,12,11],[10,13,12,13],[10,15,12,15],[10,17,12,17],[10,19,12,19],[10,21,12,21],[10,23,12,23],[10,25,12,25],[10,27,12,27],[10,29,12,29],[10,31,12,31],[10,33,12,33],[10,35,12,35],[10,36,12,36],[10,38,12,38],[10,40,12,40],[10,42,12,42],[60,3,60,5]]}
[{"$f":"+'SUMMARY (2)'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'SUMMARY (2)'!A2","v":"Revision  Rev 0"}]
[]
[]
[]
[]
["PROFESSIONAL FEES BREAKDOWN"]
[]
[{"$nulls":7},"CORE CONSULTANTS",{"$nulls":17},"ADVISORY CONSULTANTS",{"$nulls":19},{"$f":"5310/4","v":1327.5}]
[]
[{"$nulls":3},"TOTAL",null,"CUMULATIVE TOTAL",null,{"$f":"+BREAKDOWN!G19","v":"Project Manager"},null,{"$f":"BREAKDOWN!J19","v":"Architect"},null,{"$f":"BREAKDOWN!M19","v":"Quantity Surveyor"},null,{"$f":"BREAKDOWN!P19","v":"Structural Engineer"},null,{"$f":"BREAKDOWN!S19","v":"Civil Engineer"},null,{"$f":"BREAKDOWN!V19","v":"Mechanical Engineer"},null,{"$f":"BREAKDOWN!Y19","v":"Electrical Engineer"},null,{"$f":"BREAKDOWN!AE19","v":"Fire Engineer"},null,{"$f":"BREAKDOWN!AH19","v":"Wet Services"},null,{"$f":"+'SUMMARY (2)'!Z10","v":"Project Manager"},null,{"$f":"BREAKDOWN!AB19","v":"Rational Fire Engineer"},null,{"$f":"BREAKDOWN!AK19","v":"Landscape Architect"},null,{"$f":"+'SUMMARY (2)'!AF10","v":"Safety Consultant"},null,"Façade Engineer",null,{"$f":"+'SUMMARY (2)'!AJ10","v":"Green Consultant"},{"$f":"'SUMMARY (2)'!AL10","v":"Lift Consultant"},null,{"$f":"'SUMMARY (2)'!AN10","v":"Acoustic Consultant"},null,{"$f":"'SUMMARY (2)'!AP10","v":"Services Co-ordination "},null,{"$f":"'SUMMARY (2)'!AR10","v":"Tenant Co-ordinator"}]
[]
[]
[]
["Professional Fees with 33% Discount"]
[]
[null,"Stage 1","Inception",{"$f":"SUM(H17:AQ17)","v":{"$error":"#DIV/0!"}},null,{"$f":"D17","v":{"$error":"#DIV/0!"}},null,{"$f":"+PM!E49","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(ARCH!E61,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(QS!E151,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(STRUC!E118,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CIVIL!E118,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"MECH!E82","v":{"$error":"#DIV/0!"}},null,{"$f":"ELEC!E80","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E80","v":{"$error":"#DIV/0!"}},null,0,null,{"$f":"+'SUMMARY (2)'!$Z$20*10%","v":0},null,{"$f":"+AT17*5%","v":0},null,0,null,0,null,0,null,0,{"$f":"+BC17*5%","v":0},null,0,null,0,null,0,null,null,{"$f":"+'SUMMARY (2)'!AB24","v":0}]
[null,"Stage 2","Concept and viability",{"$f":"SUM(H18:AQ18)","v":{"$error":"#DIV/0!"}},null,{"$f":"F17+D18","v":{"$error":"#DIV/0!"}},null,{"$f":"+PM!E50","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(ARCH!E62,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(QS!E152,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(STRUC!E119,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"CIVIL!E119","v":{"$error":"#DIV/0!"}},null,{"$f":"MECH!E83","v":{"$error":"#DIV/0!"}},null,{"$f":"ELEC!E81","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E81","v":{"$error":"#DIV/0!"}},null,0,null,{"$f":"+'SUMMARY (2)'!$Z$20*10%","v":0},null,{"$f":"+AT17*15%","v":0},null,0,null,0,null,{"$f":"+'SUMMARY (2)'!AH20*40%","v":0},null,0,{"$f":"'SUMMARY (2)'!AL14*40%","v":0},null,{"$f":"'SUMMARY (2)'!AN20*50%","v":0},null,{"$f":"'SUMMARY (2)'!AP20*50%","v":0},null,{"$f":"'SUMMARY (2)'!AR20*50%","v":0}]
[null,"Stage 3","Design development",{"$error":"#DIV/0!"},null,{"$f":"F18+D19","v":{"$error":"#DIV/0!"}},null,{"$f":"+PM!E51","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(ARCH!E63,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(QS!E153,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(STRUC!E120,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CIVIL!E120,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(MECH!E84,2)*50%","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(ELEC!E82,2)*50%","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E82*50%","v":{"$error":"#DIV/0!"}},null,0,null,{"$f":"+'SUMMARY (2)'!$Z$20*25%","v":0},null,{"$f":"+AT17*40%","v":0},null,0,null,0,null,{"$f":"+'SUMMARY (2)'!AH20*40%","v":0},null,{"$f":"'SUMMARY (2)'!AJ20","v":0},{"$f":"'SUMMARY (2)'!AL14*40%","v":0},null,{"$f":"'SUMMARY (2)'!AN20*50%","v":0},null,{"$f":"'SUMMARY (2)'!AP20*50%","v":0},null,{"$f":"'SUMMARY (2)'!AR20*50%","v":0},null,{"$f":"35+40","v":75}]
[null,"Stage 4","Documentation and procurement ",{"$error":"#DIV/0!"},null,{"$f":"F19+D20","v":{"$error":"#DIV/0!"}},null,{"$f":"+PM!E52","v":{"$error":"#DIV/0!"}},null,{"$f":"+ROUND(ARCH!E64+ARCH!E65,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(QS!E154,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(STRUC!E121,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CIVIL!E121,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"+MECH!E84*50%","v":{"$error":"#DIV/0!"}},null,{"$f":"+ELEC!E82*50%","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E82*50%","v":{"$error":"#DIV/0!"}},null,0,null,{"$f":"+'SUMMARY (2)'!$Z$20*10%","v":0},null,{"$f":"+AT17*0%","v":0},null,0,null,0,null,0,null,0,{"$f":"+BC17*0%","v":0},null,0,null,0,null,0]
[null,"Stage 5","Construction",{"$error":"#DIV/0!"},null,{"$f":"F20+D21","v":{"$error":"#DIV/0!"}},null,{"$f":"+PM!E53","v":{"$error":"#DIV/0!"}},null,{"$f":"+ROUND(ARCH!E66,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(QS!E155,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(STRUC!E122,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CIVIL!E122,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(MECH!E86,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(ELEC!E84,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E84","v":{"$error":"#DIV/0!"}},null,0,null,{"$f":"+'SUMMARY (2)'!$Z$20*40%","v":0},null,{"$f":"+AT17*35%","v":0},null,{"$f":"+'SUMMARY (2)'!AD24*95%","v":0},null,{"$f":"+'SUMMARY (2)'!AF24*95%","v":0},null,{"$f":"'SUMMARY (2)'!AH14*20%","v":0},null,0,{"$f":"'SUMMARY (2)'!AL14*20%","v":0},null,{"$f":"+'SUMMARY (2)'!AM14*95%","v":0},null,{"$f":"+'SUMMARY (2)'!AO14*95%","v":0},null,{"$f":"'SUMMARY (2)'!AQ14*20%","v":0}]
[null,"Stage 6","Project close out",{"$error":"#DIV/0!"},null,{"$f":"F21+D22","v":{"$error":"#DIV/0!"}},null,{"$f":"+PM!E54","v":{"$error":"#DIV/0!"}},null,{"$f":"+ROUND(ARCH!E67,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(QS!E156,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(STRUC!E123,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CIVIL!E123,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(MECH!E87,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(ELEC!E85,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E85","v":{"$error":"#DIV/0!"}},null,0,null,{"$f":"+'SUMMARY (2)'!$Z$20*5%","v":0},null,{"$f":"+AT17*5%","v":0},null,{"$f":"+'SUMMARY (2)'!AD24*5%","v":0},null,{"$f":"+'SUMMARY (2)'!AF24*5%","v":0},null,0,null,0,{"$f":"+BC17*5%","v":0},null,{"$f":"+'SUMMARY (2)'!AM14*5%","v":0},null,{"$f":"+'SUMMARY (2)'!AO14*5%","v":0},null,0]
[{"$nulls":3},{"$f":"SUM(D17:D22)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(F22=D23,\" \",\"ERROR\")","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H17:H22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(J17:J22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(L17:L22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(N17:N22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(P17:P22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(R17:R22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(T17:T22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(V17:V22)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(X17:X22)","v":0},null,{"$f":"SUM(Z17:Z22)","v":0},null,{"$f":"SUM(AB17:AB22)","v":0},null,{"$f":"SUM(AD17:AD22)","v":0},null,{"$f":"SUM(AF17:AF22)","v":0},null,{"$f":"SUM(AH17:AH22)","v":0},null,{"$f":"SUM(AJ17:AJ22)","v":0},{"$f":"SUM(AK17:AK22)","v":0},null,{"$f":"SUM(AM17:AM22)","v":0},null,{"$f":"SUM(AO17:AO22)","v":0},null,{"$f":"SUM(AQ17:AQ22)","v":0},null,null,{"$f":"+D23-'SUMMARY (2)'!F24","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[{"$nulls":45},{"$f":"+SUM(H23:AJ23)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[{"$nulls":45},{"$f":"+AT27-D23","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[{"$nulls":46},0]
{"$rows_empty":17}
[null,"ALL CHECKS TO BE = 0",null,{"$f":"SUM(G17:AQ22)","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"PM!E55","v":{"$error":"#DIV/0!"}},null,{"$f":"ARCH!E68","v":{"$error":"#DIV/0!"}},null,{"$f":"QS!E157","v":{"$error":"#DIV/0!"}},null,{"$f":"STRUC!E124","v":{"$error":"#DIV/0!"}},null,{"$f":"CIVIL!E124","v":{"$error":"#DIV/0!"}},null,{"$f":"MECH!E88","v":{"$error":"#DIV/0!"}},null,{"$f":"ELEC!E86","v":{"$error":"#DIV/0!"}},null,{"$f":"+FIRE!E86","v":{"$error":"#DIV/0!"}},null,0,null,{"$f":"+'SUMMARY (2)'!Z20","v":0},null,{"$f":"+'SUMMARY (2)'!AB20","v":0},null,{"$f":"+'SUMMARY (2)'!AD20","v":0},{"$f":"+'SUMMARY (2)'!AE20","v":0},{"$f":"+'SUMMARY (2)'!AF20","v":0},{"$f":"+'SUMMARY (2)'!AG20","v":0},{"$f":"'SUMMARY (2)'!AH20","v":0},{"$f":"+'SUMMARY (2)'!AI20","v":0},{"$f":"'SUMMARY (2)'!AJ20","v":0},{"$f":"'SUMMARY (2)'!AL20","v":0},null,{"$f":"'SUMMARY (2)'!AN20","v":0},{"$f":"+'SUMMARY (2)'!AN20","v":0},{"$f":"'SUMMARY (2)'!AP20","v":0},{"$f":"+'SUMMARY (2)'!AP20","v":0},{"$f":"'SUMMARY (2)'!AR20","v":0},{"$f":"+'SUMMARY (2)'!AR20","v":0}]
[{"$nulls":3},{"$f":"D55-D23","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"H55-H23","v":{"$error":"#DIV/0!"}},null,{"$f":"J55-J23","v":{"$error":"#DIV/0!"}},null,{"$f":"L55-L23","v":{"$error":"#DIV/0!"}},null,{"$f":"N55-N23","v":{"$error":"#DIV/0!"}},null,{"$f":"P55-P23","v":{"$error":"#DIV/0!"}},null,{"$f":"R55-R23","v":{"$error":"#DIV/0!"}},null,{"$f":"T55-T23","v":{"$error":"#DIV/0!"}},null,{"$f":"V55-V23","v":{"$error":"#DIV/0!"}},{"$f":"W55-W23","v":0},{"$f":"X55-X23","v":0},{"$f":"Y55-Y23","v":0},{"$f":"Z55-Z23","v":0},null,{"$f":"AB55-AB23","v":0},null,{"$f":"AD55-AD23","v":0},0,0,0,{"$f":"AH55-AH23","v":0},0,0,{"$f":"AK55-AK23","v":0},null,{"$f":"AM55-AM23","v":0},0,0,0,0,0]
[{"$nulls":3},"CHECK",{"$nulls":3},"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK",null,"CHECK","CHECK","CHECK","CHECK","CHECK",null,"CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK","CHECK"]
[]
[{"$nulls":3},{"$f":"'SUMMARY (2)'!F20","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":3},{"v":8061000,"d":"R 8,061,000.00"}]
{"$rows_empty":8}
[{"$nulls":11},"must be zero"]

{"sheet":"Monthly Cashflow-Summary","index":11,"n_rows":193,"n_cols":37,"rows_kept":193,"hidden":true,"merged":[[6,0,6,1],[12,17,12,31],[13,2,14,2],[13,17,13,31],[14,17,14,29],[16,17,16,29],[18,17,18,19],[18,20,18,21],[18,22,18,29],[18,30,18,31]]}
["Renewable Hydrogen Facility (RHF) "]
[]
[]
[]
["PROJECT CASHFLOW "]
[]
[{"$f":"+TODAY()","v":"2026-08-04"}]
[]
[]
[null,"PROJECT CASHFLOW"]
[]
[]
[]
[null,null,"TOTAL",null,"SUBMITTED","CPAP","SUBMITTED","TENDERER","TENDERER","CONSULTANTS","TOTAL","VARIANCE","VARIANCE","VARIANCE",{"$nulls":19},{"v":4526599.19,"d":"4,526,599.19"}]
["NO","DESCRIPTION",null,"TENDERER","TENDER","ESCALATION","TENDER","ADJUSTMENT","ADJUSTED","ADJUSTMENT","ADJUSTED","TO","TO","TO"]
[{"$nulls":5},"3500*50"]
[{"$nulls":4},"A","B","A + B = C","D","C + D = E","F","E + F ",{"$nulls":6}," PROJECTED CASHFLOW PER MONTH"]
[{"$nulls":17},"2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01"]
[null,null,"BUDGET",{"$nulls":12},"ESTIMATED FINAL BUDGET",null,"Detailed Designs",null,null,"Design Review and Finalization",null,"Procurement and Construction",{"$nulls":7},"Commissioning and testing"]
[]
[]
[{"$nulls":32},{"$f":"+SUM(R22:AF22)","v":{"v":0,"d":"0%"}},"Checks"]
[]
[1,"Procurement and Construction Work ",{"$f":"+Summary!F13+Summary!F17+Summary!F19+Summary!F21+Summary!F23","v":0},{"$nulls":12},{"v":153868110.63030022,"d":"153,868,110.63"},{"$nulls":6},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G42","v":0},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G43","v":0},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G44","v":0},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G45","v":0},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G46","v":0},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G47","v":0},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G48","v":0},{"$f":"+'CASHFLOW-CONSTRUCTION CONS'!G49","v":0},null,null,{"$f":"SUM(R24:AF24)","v":0},{"$f":"+AG24-C24","v":0}]
[{"$nulls":32},{"$f":"SUM(R25:AF25)","v":0},{"$f":"+AG25-C25","v":0}]
[null,"Section 01 - Preliminaries & General",{"$nulls":30},0,0]
[null,"Section 03 - Civil Works",{"$nulls":30},0,0]
[null,"Section 04 - Structures",{"$nulls":30},0,0]
[null,"Section 05 - Mechanical & Fire",{"$nulls":30},0,0]
[null,"Section 06 - Electrical Installations",{"$nulls":30},0,0]
[{"$nulls":32},0,0]
[2,"Designing Fees",{"$nulls":10},{"v":1752192.62,"d":"1,752,192.62"},{"$nulls":19},0,0]
[2.1,"Geotechnical Studies",{"$f":"+'Designing & Fees'!F14","v":0},{"$nulls":9},{"v":2295882.89,"d":"2,295,882.89"},null,null,{"v":6400188,"d":"6,400,188.00"},null,{"$f":"+C33/2","v":0},{"$f":"R33","v":0},{"$nulls":13},0,0,null,null,{"$f":"V33/16","v":0}]
[2.2,"Traffic Study",{"$f":"+'Designing & Fees'!F16","v":0},{"$nulls":9},{"v":2984399.71,"d":"2,984,399.71"},null,null,{"v":4107883,"d":"4,107,883.00"},null,{"$f":"+C34/2","v":0},{"$f":"R34","v":0},{"$nulls":13},0,0]
[{"$nulls":32},0,0]
[3,"Professional Fees",{"$nulls":30},0,0]
[3.1,"Civil Engineering",{"$f":"+'Designing & Fees'!F20","v":0},{"$nulls":12},{"v":249998.73,"d":"249,998.73"},null,{"$f":"+'STAGE BREAKDOWN'!P17","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!P18","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!P19","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!P20/2","v":{"$error":"#DIV/0!"}},{"$f":"+U37","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!P21/8","v":{"$error":"#DIV/0!"}},{"$f":"+W37","v":{"$error":"#DIV/0!"}},{"$f":"+X37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+'STAGE BREAKDOWN'!P22/2","v":{"$error":"#DIV/0!"}},{"$f":"+AE37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3.2,"Architect",{"$f":"+'Designing & Fees'!F22","v":0},{"$nulls":14},{"$f":"+'STAGE BREAKDOWN'!J17","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!J18","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!J19","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!J20/2","v":{"$error":"#DIV/0!"}},{"$f":"+U38","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!J21/8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+X38","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+'STAGE BREAKDOWN'!J22/2","v":{"$error":"#DIV/0!"}},{"$f":"+AE38","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3.3,"Mechanical Engineering (HVAC, Fire and Wet Services)",{"$f":"+'Designing & Fees'!#REF!","v":{"$error":"#REF!"}},{"$nulls":12},{"v":12240,"d":"12,240.00"},null,{"$f":"+'STAGE BREAKDOWN'!R17","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!R18","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!R19","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!R20/2","v":{"$error":"#DIV/0!"}},{"$f":"+U39","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!R21/8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+X39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+'STAGE BREAKDOWN'!R22/2","v":{"$error":"#DIV/0!"}},{"$f":"+AE39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3.4,"Occupational Health and Safety agent",{"$f":"+'Designing & Fees'!#REF!","v":{"$error":"#REF!"}},{"$nulls":19},{"$f":"+C40/8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+X40","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[3.5,"Electrical Engineering",{"$f":"+'Designing & Fees'!#REF!","v":{"$error":"#REF!"}},{"$nulls":12},{"v":127499.98980000002,"d":"127,499.99"},null,{"$f":"+'STAGE BREAKDOWN'!T17","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!T18","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!T19","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!T20/2","v":{"$error":"#DIV/0!"}},{"$f":"+U41","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!T21/8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+'STAGE BREAKDOWN'!T22/2","v":{"$error":"#DIV/0!"}},{"$f":"+AE41","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3.6,"Quantity Surveyor",{"$f":"+'Designing & Fees'!#REF!","v":{"$error":"#REF!"}},{"$nulls":14},{"$f":"+'STAGE BREAKDOWN'!L17","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!L18","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!L19","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!L20/2","v":{"$error":"#DIV/0!"}},{"$f":"+U42","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!L21/8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+'STAGE BREAKDOWN'!L22/2","v":{"$error":"#DIV/0!"}},{"$f":"+AE42","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3.7,"Project Manager",{"$f":"+'Designing & Fees'!#REF!","v":{"$error":"#REF!"}},{"$nulls":14},{"$f":"+'STAGE BREAKDOWN'!H17","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!H18","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!H19","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!H20/2","v":{"$error":"#DIV/0!"}},{"$f":"+U43","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!H21/8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+'STAGE BREAKDOWN'!H22/2","v":{"$error":"#DIV/0!"}},{"$f":"+AE43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3.8,"Fire Engineer",{"$f":"+'Designing & Fees'!#REF!","v":{"$error":"#REF!"}},{"$nulls":14},{"$f":"+'STAGE BREAKDOWN'!V17","v":{"$error":"#DIV/0!"}},{"$f":"++'STAGE BREAKDOWN'!V18","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!V19","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!V20/2","v":{"$error":"#DIV/0!"}},{"$f":"+U44","v":{"$error":"#DIV/0!"}},{"$f":"+'STAGE BREAKDOWN'!V21/8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+'STAGE BREAKDOWN'!V22/2","v":{"$error":"#DIV/0!"}},{"$f":"+AE44","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":32},0,0]
[4.1,"Testing, Commissioning & Hand-over",{"$f":"+'TESTING, COMMISIONING MAINTENAN'!F13","v":0},{"$nulls":27},{"$f":"+C46*0.6","v":0},{"$f":"+C46*0.4","v":0},0,0]
[4.2,"Training of Eskom Staff",{"$f":"+'TESTING, COMMISIONING MAINTENAN'!F15","v":0},{"$nulls":27},{"$f":"+C47*0.6","v":0},{"$f":"+C47*0.4","v":0},0,0]
[4.3,"Allow for the maintenance and operation of the new plant, including manuals",{"$f":"+'TESTING, COMMISIONING MAINTENAN'!F17","v":0},{"$nulls":28},{"$f":"+C48","v":0},0,0]
[{"$nulls":32},0,0]
[{"$nulls":32},0,0]
[5,"CONTIGENCY",{"$nulls":30},0,0]
[5.1,"Project Contingency ",{"$f":"+Summary!F30","v":0},{"$nulls":12},{"v":2014755.8994913045,"d":"2,014,755.90"},null,{"$f":"+C52/10","v":0},{"$f":"R52","v":0},{"$f":"S52","v":0},0,0,0,0,0,0,0,{"$nulls":5},0,0]
[{"$nulls":32},0,0]
[null,"TOTAL COST PER MONTH (EXCL VAT)",{"$f":"SUM(C23:C53)","v":{"$error":"#REF!"}},{"$nulls":12},{"$f":"SUM(P23:P53)-#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(R23:R53)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"CUMMULATIVE COST PER MONTH ",{"$f":"+C54","v":{"$error":"#REF!"}},{"$nulls":12},{"$f":"+C56-P54","v":{"$error":"#REF!"}},null,{"$f":"R54","v":{"$error":"#DIV/0!"}},{"$f":"+R56+S54","v":{"$error":"#DIV/0!"}},{"$f":"+S56+T54","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,"NOTES",{"$nulls":29},{"$f":"+AF56-C56","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Stage 1 - Stage 5.11 Budget"]
[]
[null,null,"Amount Paid to Date"]
[]
[null,"a)","Balance outstanding "]
[]
[null,"b)","1st - Six Months of Stage 5"]
[]
[null,"c)","Assessments Rates for May & June 19"]
[]
[null,null,"TOTAL ( a + b )"]
[{"$nulls":17},"Total (excl. VAT)"]
[{"$nulls":17},"VAT @15%",{"$nulls":14},{"$f":"+AF56-C56","v":{"$error":"#DIV/0!"}}]
[{"$nulls":17},"Total (incl. VAT)"]
[]
[{"$nulls":17},"Advance 1 Drawn - Unutilized (Balance per Adowa Bank)"]
[]
[{"$nulls":17},"Diff"]
[]
[{"$nulls":17},"Reconciling items (incl. VAT)"]
[{"$nulls":17},"(Items utilized through change of use of funds)"]
[{"$nulls":17},"SDP/S7-6 Plan Approval Fee"]
[{"$nulls":17},"Fire Plan Approval Fee"]
[{"$nulls":17},"NHBRC Submission Fee"]
[{"$nulls":17},"Green building council - Project Certification "]
[]
[]
[{"$nulls":17},"Net Diff"]
[{"$nulls":17},"%Diff"]
[]
[{"$nulls":32},{"$f":"+AF56-AG54","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":17},{"v":-193183823.22366273,"d":"-193,183,823"}]
[]
[]
[]
[null,null,{"$f":"+C56-Summary!F32","v":{"$error":"#REF!"}}]
{"$rows_empty":26}
[{"$f":"+A122+1","v":1}]
[1]
[2]
[2]
[3]
[3]
[4]
[4]
[5]
[5]
[6]
[6]
[7]
[7]
[8]
[8]
[9]
[9]
[10]
[10]
[11]
[11]
[12]
[12]
[13]
[13]
[14]
[14]
[15]
[15]
[16]
[16]
[17]
[17]
[18]
[18]
[19]
[19]
[20]
[20]
[21]
[21]
[22]
[22]
[]
[]
[{"$nulls":17},{"$f":"+R33+R34+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+R37+#REF!+R39+#REF!+#REF!+R41+#REF!","v":{"$error":"#REF!"}}]
[]
[null,"VAT ",{"$f":"+C54*14%","v":{"$error":"#REF!"}},0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#REF!"},null,{"$f":"+R54*14%","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"+W54*14%","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":3},{"$f":"+AH54*14%","v":0}]
[null,null,{"$f":"SUM(C54:C172)","v":{"$error":"#REF!"}},0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#REF!"},null,{"$f":"SUM(R54:R172)","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"SUM(V54:V172)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(W54:W172)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":3},{"$f":"+AH172+AH54","v":0}]
[]
[]
[]
[null,"Budget",{"$nulls":15},18820814.245590076]
[{"$nulls":17},8233847.639999999]
[{"$nulls":17},{"$f":"+R177+R178","v":{"v":27054661.885590076,"d":"R27,054,661.89"}}]
[]
[{"$nulls":17},{"$f":"+R170-R179","v":{"$error":"#REF!"}}]
[null,{"$f":"+C54","v":{"$error":"#REF!"}},"BUDGET"]
[]
[null,{"v":229452276.01000002,"d":"229,452,276.01"},"No.5 Rev 8"]
[]
[null,{"$f":"+B182-B184","v":{"$error":"#REF!"}},"Should be zero - dm fee updated"]
[]
[]
[null,null,101623035.40604901,{"$nulls":14},"PPS NO18 REV0 PAID TO DATE"]
[{"$nulls":17},"land"]
[]
[]
[null,null,{"$f":"+C189-R54","v":{"$error":"#DIV/0!"}},{"$nulls":14},"Should be zero"]

{"sheet":"CASHFLOW-CONSTRUCTION CONS","index":12,"n_rows":109,"n_cols":16,"rows_kept":109,"hidden":true,"merged":[[5,1,5,2]]}
[]
[null,{"$f":"+'TESTING, COMMISIONING MAINTENAN'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"},{"$nulls":10},7]
[]
[null,"CONSTRUCTION CASHFLOW "]
[]
[null,{"$f":"+TODAY()","v":"2026-08-04"}]
[]
[null,"PRINCIPAL CONTRACTOR",{"$nulls":5},"tbc"]
[null,"CONTRACT COMMENCEMENT DATE ",{"$nulls":3},"A",":","2025-08-01"]
[null,"COMPLETION DATE",{"$nulls":3},"B",":","2026-02-01"]
[null,"FINAL COMPLETION",{"$nulls":5},{"$f":"H10+60","v":"2026-04-02"}]
[null,"LAST PRINCIPAL CONTRACT VALUATION DATE",{"$nulls":3},"C",":",{"$f":"H11+5","v":"2026-04-07"}]
[null,"CURRENT ESTIMATED CONSTRUCTION COST (BUILDERS WORK ONLY)",{"$nulls":3},"D",":",{"$f":"+'Monthly Cashflow-Summary'!C24","v":{"v":0,"d":"R 0.00"}}]
[null,"PAYMENT PERIOD - Days",{"$nulls":3},"E",":",{"$f":"H12-H9","v":249}]
[null,"PAYMENT PERIOD - Months",{"$nulls":3},"F",null,{"$f":"ROUND(H14/30.5,0)","v":8}]
[]
[{"$nulls":4},"NORMAL","UPPER LIMIT","LOWER LIMIT"]
[{"$nulls":3},"Alpha",1.86336,1.96259,1.75345]
[{"$nulls":3},"Beta",2.27944,1.77421,2.58507]
[]
[null,"1.0 PROGRESSIVE CERTIFICATE VALUE (CUMULATIVE)"]
[null,"PAYMENT NO","VALUATION DATES","PAYMENT DATES","PAYMENT PERIOD EXPIRED (DAYS)","CONSTRUCTION NORMAL","CONSTRUCTION UPPER LIMIT","CONSTRUCTION LOWER LIMIT","HIGH CAPITAL VALUE ITEMS","\"NORMAL\" PROJECTED CONSTRUCTION CASHFLOW INCLUDING HIGH CAPITAL VALUE ITEMS","ACTUAL AMOUNT","PRINICIPAL CONTRACTOR PROPOSED CASHFLOW"]
[null,null,"G","H","I = G - A",{"$nulls":3},"Y","Z = X + Y"]
[null,0,null,0,0,0,0,0,{"$nulls":3},0]
[null,1,{"$f":"+H9+14","v":"2025-08-15"},{"$f":"+C25+15","v":"2025-08-30"},{"$f":"C25-$H$9","v":14},{"$f":"(1-((1-(E25/$H$14))^$E$18))^$E$19*$H$13","v":{"v":0,"d":"R 0.00"}},{"$f":"(1-((1-(E25/$H$14))^$F$18))^$F$19*$H$13","v":{"v":0,"d":"R 0.00"}},{"$f":"(1-((1-(E25/$H$14))^$G$18))^$G$19*$H$13","v":{"v":0,"d":"R 0.00"}},{"v":0,"d":"R 0.00"},{"$f":"I25+F25","v":{"v":0,"d":"R 0.00"}},null,null,{"v":14279345.565,"d":"R14,279,345.57"},170057.74,636077.9895881847,{"v":869473.2036804818,"d":"R 869,473.20"}]
[null,2,{"$f":"C25+31","v":"2025-09-15"},{"$f":"+C26+16","v":"2025-10-01"},45,{"v":0,"d":"R 0.00"},{"$f":"(1-((1-(E26/$H$14))^$F$18))^$F$19*$H$13","v":{"v":0,"d":"R 0.00"}},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,null,{"v":1795811.31,"d":"R1,795,811.31"},114405.22]
[null,3,{"$f":"C26+31","v":"2025-10-16"},{"$f":"C27+15","v":"2025-10-31"},76,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"v":413742.85,"d":"R413,742.85"},76467.75]
[null,4,{"$f":"C27+30","v":"2025-11-15"},{"$f":"C28+16","v":"2025-12-01"},106,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"v":3632668.44,"d":"R3,632,668.44"}]
[null,5,{"$f":"C28+31","v":"2025-12-16"},{"$f":"C29+15","v":"2025-12-31"},137,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"v":84947.49347826082,"d":"R84,947.49"}]
[null,6,{"$f":"C29+30","v":"2026-01-15"},{"$f":"C30+10","v":"2026-01-25"},167,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"v":1752192.62,"d":"1,752,192.62"}]
[null,7,{"$f":"C30+31","v":"2026-02-15"},{"$f":"C31+16","v":"2026-03-03"},198,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"v":2295882.89,"d":"2,295,882.89"},{"$f":"+G30","v":{"v":0,"d":"R0.00"}}]
[null,8,{"$f":"+C31+51","v":"2026-04-07"},{"$f":"C32+14","v":"2026-04-21"},249,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,null,{"v":2984399.71,"d":"2,984,399.71"}]
[]
[]
[]
[{"$nulls":12},{"$f":"+F32-H13","v":{"v":0,"d":"0.0000000000"}}]
[]
[null,"2.0 NETT CERTIFICATE VALUES (MONTHLY)"]
[null,"PAYMENT NO","VALUATION DATES","PAYMENT DATES","CONTRACT PERIOD EXPIRED (DAYS)","NORMAL CONSTRUCTION NET PAYMENTS",{"$f":"G22","v":"CONSTRUCTION UPPER LIMIT"},{"$f":"H22","v":"CONSTRUCTION LOWER LIMIT"},"HIGH CAPITAL VALUE ITEMS","\"NORMAL\" PROJECTED CONSTRUCTION CASHFLOW INCLUDING HIGH CAPITAL VALUE ITEMS","ACTUAL","PRINICIPAL CONTRACTOR PROPOSED CASHFLOW"]
[null,null,"G","H","I = G - A",{"$nulls":3},"Y","Z = X + Y"]
[null,{"$f":"+B24","v":0},null,null,0,0,0,0,{"$nulls":3},0]
[null,1,{"$f":"+C25","v":"2025-08-15"},"2025-08-30",{"$f":"C42-$H$9","v":14},{"$f":"+F25","v":{"v":0,"d":"R 0.00"}},{"$f":"+G25-G24","v":{"v":0,"d":"R 0.00"}},{"$f":"+H25","v":{"v":0,"d":"R 0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F42+I42","v":{"$error":"#REF!"}}]
[null,2,"2025-09-15","2025-10-01",45,{"$f":"+F26-F25","v":{"v":0,"d":"R 0.00"}},{"v":0,"d":"R 0.00"},{"$f":"+H26-H25","v":{"v":0,"d":"R 0.00"}},{"$f":"I25-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,3,"2025-10-16","2025-10-31",76,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$f":"I26-I25","v":{"v":0,"d":"R 0.00"}},{"v":0,"d":"R 0.00"},{"$f":"+K27","v":{"v":0,"d":"R 0.00"}}]
[null,4,"2025-11-15","2025-12-01",106,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$f":"I26-I23","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"+K28-K27","v":{"v":0,"d":"R 0.00"}}]
[null,5,"2025-12-16","2025-12-31",137,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$f":"I25-#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+K29-K28","v":{"v":0,"d":"R 0.00"}}]
[null,6,"2026-01-15","2026-01-25",167,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$f":"I26-I25","v":{"v":0,"d":"R 0.00"}},{"v":0,"d":"R 0.00"},{"$f":"+K30-K29","v":{"v":0,"d":"R 0.00"}}]
[null,7,"2026-02-15","2026-03-03",198,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$f":"I27-I26","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+K31-K30","v":{"v":0,"d":"R 0.00"}}]
[null,8,"2026-04-07","2026-04-21",249,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$f":"I28-I27","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"+K32-K31","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$nulls":3},"TOTAL",null,{"$f":"SUM(F42:F50)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(G42:G50)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(H42:H50)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I42:I49)","v":{"$error":"#REF!"}},{"$f":"SUM(J42:J49)","v":{"$error":"#REF!"}},{"$f":"SUM(K42:K50)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(L42:L49)","v":{"v":0,"d":"R 0.00"}},{"$f":"G51-H13","v":{"v":0,"d":"0.0000000"}}]
[]
[]
[null,"3.0 ESTIMATED CONSTRUCTION CASHFLOW CHART"]
{"$rows_empty":32}
[null,"NOTES:"]
[]
[null,"Payment 1 - 3 ","Demolitions"]
[null,"Payment 4 - 21","Bulk Earthworks, Piling  and Builderswork"]
[null,"Month 3","Piling"]
[null,"Month 4 - 19","Builderswork "]
[]
[null,"Total Anticipated Expenditure for the first - six montths",{"$f":"+G30","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[]
[]
[null,"4.0 Basis of cashflow and assumptions"]
[]
[null,"* All payments are based on 24 calendar days from date of interim payment certificate issue "]
[null,"* Payment certificate issued by the 7th and payment due 24 calendar days thereafter"]
[null,"* Excludes VAT"]
[null,"* This does include/reflect other financial commitments of the Principal contractor (e.g.,Construction guarantees,Forward Cover taken out or Letters of Credit to suppliers)"]
[null,"* Includes Contractors December holidays"]
[null,"* Based on Principal Contractor apointment value, including no variations orders approved "]
[null,"* Exclude any other capital costs i.e. cost of capital, land cost, professional fees & disbursements, general costs, contingencies etc. "]
[null,"* Prinicpal Contractor proposed cashflow based on information provided by the Principal Contractor"]

{"sheet":"BREAKDOWN","index":13,"n_rows":92,"n_cols":47,"rows_kept":92,"hidden":true,"merged":[[3,0,3,3],[18,6,20,7],[18,8,20,8],[18,9,20,10],[18,11,20,11],[18,12,20,13],[18,14,20,14],[18,15,20,16],[18,17,20,17],[18,18,20,19],[18,20,20,20],[18,21,20,22],[18,23,20,23],[18,24,20,25],[18,26,20,26],[18,27,20,28],[18,29,20,29],[18,30,20,31],[18,32,20,32],[18,33,20,34],[18,35,20,35],[18,36,20,37],[18,38,20,38],[18,39,20,40],[21,6,22,6],[21,7,22,7],[21,9,22,9],[21,10,22,10],[21,12,22,12],[21,13,22,13],[21,15,22,15],[21,16,22,16],[21,18,22,18],[21,19,22,19],[21,21,22,21],[21,22,22,22],[21,24,22,24],[21,25,22,25],[21,27,22,27],[21,28,22,28],[21,30,22,30],[21,31,22,31],[21,33,22,33],[21,34,22,34],[21,36,22,36],[21,37,22,37],[21,39,22,39],[21,40,22,40],[23,42,23,46],[31,3,31,4],[62,42,62,46],[63,45,63,46],[64,45,64,46],[65,1,65,4],[65,45,65,46],[66,45,66,46],[67,45,67,46],[68,45,68,46],[69,45,69,46],[70,45,70,46],[71,45,71,46],[74,42,74,46],[75,45,75,46]]}
[{"$f":"+'STAGE BREAKDOWN'!A1","v":"Engineer, Procure, Construct and Commission a 50 to 100 kW thermal Waste-to-Energy Test Facility at Eskom Research, Testing and Innovation Centre"}]
[{"$f":"+'STAGE BREAKDOWN'!A2","v":"Revision  Rev 0"}]
{"$rows_empty":16}
[{"$nulls":6},"Project Manager",null,null,"Architect",null,null,"Quantity Surveyor",null,null,"Structural Engineer",null,null,"Civil Engineer",null,null,"Mechanical Engineer",null,null,"Electrical Engineer",null,null,"Rational Fire Engineer",null,null,"Fire Engineer",null,null,"Wet Services",null,null,"Landscape Architect",null,null,"Sundry Fees Allowance"]
["No.","Element",{"$nulls":3},"Total",{"$nulls":6},"Quantity Surveyor"]
[]
[{"$nulls":6},"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes",null,"%","Value for fee purposes"]
[]
[{"$nulls":42},"DO NOT DELETE"]
[{"v":1,"d":"1.0"},"BUILDING WORKS & FINISHES ETC.,",{"$nulls":42},"ARCH as Principal Agent",false,{"$f":"((AT25*1))","v":{"v":0,"d":"0.00"}}]
[{"$f":"A25+0.01","v":1.01},"Civil Works",{"$nulls":3},{"$f":"+Summary!F17","v":{"v":0,"d":"R0"}},{"v":0.5,"d":"50%"},{"$f":"$F$26*G26","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$26*J26","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$26*M26","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$26*P26","v":{"v":0,"d":"R0"}},null,{"v":1,"d":"100%"},{"$f":"$F$26*S26","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$26*V26","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$26*Y26","v":{"v":0,"d":"R0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$26*AB26","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$26*AE26","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$26*AH26","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$26*AK26","v":{"v":0,"d":"R0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$26*AN26","v":{"v":0,"d":"R0"}}]
[{"$f":"A26+0.01","v":1.02},"Structures",{"$nulls":3},{"$f":"+Summary!F19","v":{"v":0,"d":"R0"}},{"v":0.5,"d":"50%"},{"$f":"$F$27*G27","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$27*J27","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$27*M27","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$27*P27","v":{"v":0,"d":"R0"}},null,{"v":1,"d":"100%"},{"$f":"$F$27*S27","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$27*V27","v":{"v":0,"d":"R0"}},null,{"v":1,"d":"100%"},{"$f":"$F$27*Y27","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$27*AB27","v":{"v":0,"d":"R0"}},null,{"v":1,"d":"100%"},{"$f":"$F$27*AE27","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$27*AH27","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$27*AK27","v":{"v":0,"d":"R0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$27*AN27","v":{"v":0,"d":"R0"}},{"$nulls":3},"Alterations project",true,{"$f":"((AT27*1))","v":{"v":1,"d":"1.00"}}]
[{"$f":"A27+0.01","v":1.03},"Hydrogen Plant",{"$nulls":3},{"$f":"+Summary!F21","v":{"v":0,"d":"R0"}},{"v":0.25,"d":"25%"},{"$f":"$F$28*G28","v":{"v":0,"d":"R0"}},null,{"v":0.25,"d":"25%"},{"$f":"$F$28*J28","v":{"v":0,"d":"R0"}},null,{"v":0.3,"d":"30%"},{"$f":"$F$28*M28","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$28*P28","v":{"v":0,"d":"R0"}},null,{"v":0.25,"d":"25%"},{"$f":"$F$28*S28","v":{"v":0,"d":"R0"}},null,{"v":1,"d":"100%"},{"$f":"$F$28*V28","v":{"v":0,"d":"R0"}},null,{"v":0.25,"d":"25%"},{"$f":"$F$28*Y28","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$28*AB28","v":{"v":0,"d":"R0"}},null,{"v":0.25,"d":"25%"},{"$f":"$F$28*AE28","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$28*AH28","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$28*AK28","v":{"v":0,"d":"R0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$28*AN28","v":{"v":0,"d":"R0"}},{"$nulls":3},"Restoration project",false,{"v":0,"d":"0.00"}]
[{"$f":"A28+0.01","v":1.04},"Electrical Installations",{"$nulls":3},{"$f":"+Summary!F23","v":{"v":0,"d":"R0"}},{"v":1,"d":"100%"},{"$f":"$F$29*G29","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$29*J29","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$29*M29","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$29*P29","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$29*S29","v":{"v":0,"d":"R0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$29*V29","v":{"v":0,"d":"R0"}},null,{"v":1,"d":"100%"},{"$f":"$F$29*Y29","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$29*AB29","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$29*AE29","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$29*AH29","v":{"v":0,"d":"R0"}},null,{"v":0,"d":"0%"},{"$f":"$F$29*AK29","v":{"v":0,"d":"R0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$29*AN29","v":{"v":0,"d":"R0"}},{"$nulls":3},"Redecoration fee",false,{"v":0,"d":"0.00"}]
[]
[]
[{"v":2,"d":"2.0"},"Main Preliminaries ",{"$f":"+D32/F32","v":{"$error":"#DIV/0!"}},{"$f":"+Summary!F13","v":0},null,{"$f":"+SUM(F26:F29)","v":{"v":0,"d":"R 0"}},{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(H26:H29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(K26:K29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(N26:N29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(Q26:Q29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(T26:T29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(W26:W29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(Z26:Z29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(AC26:AC29))","v":{"$error":"#DIV/0!"}},null,{"$f":"+Y32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(AF26:AF29))","v":{"$error":"#DIV/0!"}},null,{"v":0,"d":"0.0%"},{"$f":"$C$32*(SUM(AI26:AI29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(AL26:AL29))","v":{"$error":"#DIV/0!"}},null,{"$f":"$C$32","v":{"$error":"#DIV/0!"}},{"$f":"$C$32*(SUM(AO26:AO29))","v":{"$error":"#DIV/0!"}},{"v":17667657.145385478,"d":"17,667,657 "}]
[]
[{"$f":"+A32+0.01","v":2.01},"Contingencies ",{"$nulls":3},{"v":1888189.4375,"d":"R 1,888,189"},{"v":0.5,"d":"50%"},{"$f":"$F$34*G34","v":{"v":944094.71875,"d":"R 944,095"}},null,{"$f":"+G34","v":{"v":0.5,"d":"50%"}},{"$f":"$F$34*J34","v":{"v":944094.71875,"d":"R 944,095"}},null,{"$f":"+J34","v":{"v":0.5,"d":"50%"}},{"$f":"$F$34*M34","v":{"v":944094.71875,"d":"R 944,095"}},null,{"v":0,"d":"0%"},{"$f":"$F$34*P34","v":{"v":0,"d":"R 0"}},null,{"$f":"+P34","v":{"v":0,"d":"0%"}},{"$f":"$F$34*S34","v":{"v":0,"d":"R 0"}},null,{"$f":"+S34","v":{"v":0,"d":"0%"}},{"$f":"$F$34*V34","v":{"v":0,"d":"R 0"}},null,{"$f":"+V34","v":{"v":0,"d":"0%"}},{"$f":"$F$34*Y34","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$34*AB34","v":{"v":0,"d":"R 0"}},null,{"$f":"+Y34","v":{"v":0,"d":"0%"}},{"$f":"$F$34*AE34","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$34*AH34","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$34*AK34","v":{"v":1888189.4375,"d":"R 1,888,189"}},null,{"v":1,"d":"100%"},{"$f":"$F$34*AN34","v":{"v":1888189.4375,"d":"R 1,888,189"}}]
[]
["ALTERATIONS"]
[]
[5,"Alterations",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$38*G38","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$38*J38","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$38*M38","v":{"v":0,"d":"R 0"}},null,{"v":0.4,"d":"40%"},{"$f":"$F$38*P38","v":{"v":0,"d":"R 0"}},null,{"v":0.1,"d":"10%"},{"$f":"$F$38*S38","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$38*V38","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$38*Y38","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$38*AB38","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$38*AE38","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$38*AH38","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$38*AK38","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$38*AN38","v":{"v":0,"d":"R 0"}}]
[]
["EXTERNAL WORKS AND SERVICES"]
[]
[{"$f":"A38+1","v":6},"Bulk Earthworks",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$42*G42","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$42*J42","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$42*M42","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$42*P42","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$42*S42","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$42*V42","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$42*Y42","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$42*AB42","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$42*AE42","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$42*AH42","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$42*AK42","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$42*AN42","v":{"v":0,"d":"R 0"}}]
[{"$f":"A42+1","v":7},"Soil Drainage",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$43*G43","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$43*J43","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$43*M43","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$43*P43","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$43*S43","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$43*V43","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$43*Y43","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$43*AB43","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$43*AE43","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$43*AH43","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$43*AK43","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$43*AN43","v":{"v":0,"d":"R 0"}}]
[{"$f":"A43+1","v":8},"Demolitions",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$44*G44","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$44*J44","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$44*M44","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$44*P44","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$44*S44","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$44*V44","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$44*Y44","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$44*AB44","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$44*AE44","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$44*AH44","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$44*AK44","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$44*AN44","v":{"v":0,"d":"R 0"}}]
[{"$f":"A44+1","v":9},"Podium, Roads, Parking & Paving",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$45*G45","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$45*J45","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$45*M45","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$45*P45","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$45*S45","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$45*V45","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$45*Y45","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$45*AB45","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$45*AE45","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$45*AH45","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$45*AK45","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$45*AN45","v":{"v":0,"d":"R 0"}}]
[10,"Civil Services",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$46*G46","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$46*J46","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$46*M46","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$46*P46","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$46*S46","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$46*V46","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$46*Y46","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$46*AB46","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$46*AE46","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$46*AH46","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$46*AK46","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$46*AN46","v":{"v":0,"d":"R 0"}}]
[11,"Perimeter walling, fencing",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$47*G47","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$47*J47","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$47*M47","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$47*P47","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$47*S47","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$47*V47","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$47*Y47","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$47*AB47","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$47*AE47","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$47*AH47","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$47*AK47","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$47*AN47","v":{"v":0,"d":"R 0"}}]
[12,"Landscaping",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$48*G48","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$48*J48","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$48*M48","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$48*P48","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$48*S48","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$48*V48","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$48*Y48","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$48*AB48","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$48*AE48","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$48*AH48","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$48*AK48","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$48*AN48","v":{"v":0,"d":"R 0"}}]
[13,"External Electrical",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$49*G49","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$49*J49","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$49*M49","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$49*P49","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$49*S49","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$49*V49","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$49*Y49","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$49*AB49","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$49*AE49","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$49*AH49","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$49*AK49","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$49*AN49","v":{"v":0,"d":"R 0"}}]
[14,"External Fire",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$50*G50","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$50*J50","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$50*M50","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$50*P50","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$50*S50","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$50*V50","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$50*Y50","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$50*AB50","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$50*AE50","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$50*AH50","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$50*AK50","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$50*AN50","v":{"v":0,"d":"R 0"}}]
[15,"Ancilliary structures",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$51*G51","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$51*J51","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$51*M51","v":{"v":0,"d":"R 0"}},null,{"v":0.5,"d":"50%"},{"$f":"$F$51*P51","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$51*S51","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$51*V51","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$51*Y51","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$51*AB51","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$51*AE51","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$51*AH51","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$51*AK51","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$51*AN51","v":{"v":0,"d":"R 0"}}]
[16,"Signage",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$52*G52","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$52*J52","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$52*M52","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$52*P52","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$52*S52","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$52*V52","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$52*Y52","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$52*AB52","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$52*AE52","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$52*AH52","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$52*AK52","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$52*AN52","v":{"v":0,"d":"R 0"}}]
[17,"Provisional Sums - All allowances",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$53*G53","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$53*J53","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$53*M53","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$53*P53","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$53*S53","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$53*V53","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$53*Y53","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$53*AB53","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$53*AE53","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$53*AH53","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$53*AK53","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$53*AN53","v":{"v":0,"d":"R 0"}}]
[18,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$54*G54","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$54*J54","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$54*M54","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$54*P54","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$54*S54","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$54*V54","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"Y54*F54","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$54*AB54","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$54*AE54","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$54*AH54","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$54*AK54","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$54*AN54","v":{"v":0,"d":"R 0"}}]
[19,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$55*G55","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$55*J55","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$55*M55","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$55*P55","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$55*S55","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$55*V55","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$55*Y55","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$55*AB55","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$55*AE55","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$55*AH55","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$55*AK55","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$55*AN55","v":{"v":0,"d":"R 0"}}]
[20,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$56*G56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*J56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*M56","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$56*P56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*S56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*V56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*Y56","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$56*AB56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*AE56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*AH56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*AK56","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$56*AN56","v":{"v":0,"d":"R 0"}}]
[21,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$57*G57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*J57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*M57","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$57*P57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*S57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*V57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*Y57","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$57*AB57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*AE57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*AH57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*AK57","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$57*AN57","v":{"v":0,"d":"R 0"}}]
[22,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$58*G58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*J58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*M58","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$58*P58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*S58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*V58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*Y58","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$58*AB58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*AE58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*AH58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*AK58","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$58*AN58","v":{"v":0,"d":"R 0"}}]
[23,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$59*G59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*J59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*M59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*P59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*S59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*V59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*Y59","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$59*AB59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*AE59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*AH59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*AK59","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$59*AN59","v":{"v":0,"d":"R 0"}}]
[24,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$60*G60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*J60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*M60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*P60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*S60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*V60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*Y60","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$60*AB60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*AE60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*AH60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*AK60","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$60*AN60","v":{"v":0,"d":"R 0"}}]
[25,{"$nulls":4},{"v":0,"d":"R 0"},{"v":0,"d":"0%"},{"$f":"$F$61*G61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*J61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*M61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*P61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*S61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*V61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*Y61","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$61*AB61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*AE61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*AH61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*AK61","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$61*AN61","v":{"v":0,"d":"R 0"}}]
[18,"Mark-up & Attendance",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$62*G62","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$62*J62","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$62*M62","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"8%*SUM(Q43:Q61)","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"8%*SUM(T43:T61)","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"8%*SUM(W42:W61)","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"8%*SUM(Z42:Z61)","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$62*AB62","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$62*AE62","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$62*AH62","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$62*AK62","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$62*AN62","v":{"v":0,"d":"R 0"}}]
[{"$nulls":6},{"v":1,"d":"100%"},{"$nulls":35},"DO NOT DELETE"]
[{"$f":"A62+1","v":19},"Main Preliminaries ",{"$nulls":3},{"v":0,"d":"R 0"},{"v":1,"d":"100%"},{"$f":"$F$64*G64","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$64*J64","v":{"v":0,"d":"R 0"}},null,{"v":1,"d":"100%"},{"$f":"$F$64*M64","v":{"v":0,"d":"R 0"}},null,{"v":0.1,"d":"10%"},{"$f":"$F$64*P64","v":{"v":0,"d":"R 0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$64*S64","v":{"v":0,"d":"R 0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$64*V64","v":{"v":0,"d":"R 0"}},null,{"v":0.05,"d":"5%"},{"$f":"$F$64*Y64","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$64*AB64","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$64*AE64","v":{"v":0,"d":"R 0"}},null,{"v":0,"d":"0%"},{"$f":"$F$64*AH64","v":{"v":0,"d":"R 0"}},null,{"$f":"AS71","v":{"$error":"#DIV/0!"}},{"$f":"$F$64*AK64","v":{"$error":"#DIV/0!"}},null,{"v":0,"d":"0%"},{"$f":"$F$64*AN64","v":{"v":0,"d":"R 0"}},null,{"$f":"P19","v":"Structural Engineer"},null,{"$f":"(AT64/$AT$72)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q24:Q62)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":42},{"$f":"S19","v":"Civil Engineer"},null,{"$f":"(AT65/$AT$72)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(T24:T62)","v":{"$error":"#DIV/0!"}}]
[{"v":7,"d":"7.0"},"Sub Total (Excl. Contingency, Escalation, Fees & VAT)",{"$nulls":3},{"$f":"+F32+F34","v":{"v":1888189.4375,"d":"R 1,888,189"}},null,{"$f":"SUM(H24:H65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(K26:K65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N26:N65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(Q26:Q65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T25:T65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(W25:W65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(Z26:Z65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AC25:AC65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AF25:AF65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AI26:AI65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AL25:AL65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AO25:AO65)","v":{"$error":"#DIV/0!"}},null,{"$f":"V19","v":"Mechanical Engineer"},null,{"$error":"#DIV/0!"},{"$f":"SUM(W24:W62)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":42},{"$f":"Y19","v":"Electrical Engineer"},null,{"$error":"#DIV/0!"},{"$f":"SUM((Z24:Z62))","v":{"$error":"#DIV/0!"}}]
[{"$f":"A66+1","v":8},"Pre-Contract Escalation",null,0,{"v":0,"d":"0.00%"},{"v":0,"d":"R 0"},{"$f":"+E68","v":{"v":0,"d":"0.00%"}},{"$f":"H66*G68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+G68","v":{"v":0,"d":"0.00%"}},{"$f":"K66*J68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$J$68","v":{"v":0,"d":"0.00%"}},{"$f":"N66*M68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$M$68","v":{"v":0,"d":"0.00%"}},{"$f":"Q66*P68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$P$68","v":{"v":0,"d":"0.00%"}},{"$f":"T66*S68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$S$68","v":{"v":0,"d":"0.00%"}},{"$f":"W66*V68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$V$68","v":{"v":0,"d":"0.00%"}},{"$f":"Z66*Y68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$Y$68","v":{"v":0,"d":"0.00%"}},{"$f":"AC66*AB68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AB$68","v":{"v":0,"d":"0.00%"}},{"$f":"AF66*AE68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AE$68","v":{"v":0,"d":"0.00%"}},{"$f":"AI66*AH68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AH$68","v":{"v":0,"d":"0.00%"}},{"$f":"AL66*AK68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AK$68","v":{"v":0,"d":"0.00%"}},{"$f":"AO66*AN68*$D$68","v":{"$error":"#DIV/0!"}},null,{"$f":"AB19","v":"Rational Fire Engineer"},null,{"$error":"#DIV/0!"},{"$f":"SUM((AC24:AC62))","v":{"$error":"#DIV/0!"}}]
[{"$f":"A68+1","v":9},"Contract Escalation",null,0,{"v":0,"d":"0.00%"},{"v":0,"d":"R 0"},{"$f":"+E69","v":{"v":0,"d":"0.00%"}},{"$f":"H66*G69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+G69","v":{"v":0,"d":"0.00%"}},{"$f":"K66*J69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$J$69","v":{"v":0,"d":"0.00%"}},{"$f":"N66*M69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$M$69","v":{"v":0,"d":"0.00%"}},{"$f":"Q66*P69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+P69","v":{"v":0,"d":"0.00%"}},{"$f":"T66*S69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$S$69","v":{"v":0,"d":"0.00%"}},{"$f":"W66*V69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$V$69","v":{"v":0,"d":"0.00%"}},{"$f":"Z66*Y69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$Y$69","v":{"v":0,"d":"0.00%"}},{"$f":"AC66*AB69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AB$69","v":{"v":0,"d":"0.00%"}},{"$f":"AF66*AE69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AE$69","v":{"v":0,"d":"0.00%"}},{"$f":"AI66*AH69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AH$69","v":{"v":0,"d":"0.00%"}},{"$f":"AL66*AK69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"+$AK$69","v":{"v":0,"d":"0.00%"}},{"$f":"AO66*AN69*$D$69*0.4","v":{"$error":"#DIV/0!"}},null,{"$f":"AE19","v":"Fire Engineer"},null,{"$error":"#DIV/0!"},{"$f":"SUM((AF24:AF62))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":42},{"$f":"AH19","v":"Wet Services"},null,{"$error":"#DIV/0!"},{"$f":"SUM(AI24:AI62)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A69+1","v":10},"Value for fee purpose",{"$nulls":3},{"$f":"SUM(F66:F70)","v":{"v":1888189.4375,"d":"R 1,888,189"}},null,{"$f":"SUM(H66:H70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(K66:K70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N66:N70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(Q66:Q70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T66:T70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(W66:W70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(Z66:Z70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AC66:AC70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AF66:AF70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AI66:AI70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AL66:AL70)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AO66:AO70)","v":{"$error":"#DIV/0!"}},null,{"$f":"AK19","v":"Landscape Architect"},null,{"$error":"#DIV/0!"},{"$f":"SUM((AL24:AL62))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":42},"TOTAL",null,{"$f":"SUM(AS64:AS71)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AT64:AU71)","v":{"$error":"#DIV/0!"}}]
[null,"Discount","%",{"$nulls":4},{"v":0.45,"d":"45.00%"},null,null,{"$f":"+H73","v":{"v":0.45,"d":"45.00%"}},null,null,{"$f":"+K73","v":{"v":0.45,"d":"45.00%"}},null,null,{"$f":"+N73","v":{"v":0.45,"d":"45.00%"}},null,null,{"$f":"+Q73","v":{"v":0.45,"d":"45.00%"}},null,null,{"$f":"+T73","v":{"v":0.45,"d":"45.00%"}},null,null,{"$f":"+W73","v":{"v":0.45,"d":"45.00%"}},null,null,{"v":0.2289800718584781,"d":"22.90%"},null,null,{"$f":"+Z73","v":{"v":0.45,"d":"45.00%"}},null,null,{"$f":"+AF73","v":{"v":0.45,"d":"45.00%"}},null,null,{"v":0.3,"d":"30%"},null,null,{"$f":"+AI73","v":{"v":0.45,"d":"45.0%"}}]
[]
[null,"Disbursements",null,"OR",{"$nulls":3},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"DO NOT DELETE"]
[]
[{"$nulls":42},false,{"$f":"AQ77*1","v":0}]
[null,"STANDARD BASIS OF CALCULATIONS",{"$nulls":40},false,{"$f":"AQ78*1","v":0}]
["-","Includes Escalation"]
["-","Excludes Contingencies"]
["-","Pro-rata of Main Contractors Preliminaries on Value of Engineering works"]
["-","QS: Includes Profit and Attendance on Specialist Works",{"$nulls":5},{"$f":"+'STAGE BREAKDOWN'!D23/BREAKDOWN!F71","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[{"$nulls":5},{"v":35462858.16115,"d":"R 35,462,858"}]
[]
[{"$nulls":5},{"$f":"+F71-F87","v":{"v":-33574668.72365,"d":"-33,574,669"}}]
[]
[]
[{"$nulls":8},"should be zero"]

{"sheet":"PM","index":14,"n_rows":65,"n_cols":17,"rows_kept":65,"hidden":true,"merged":[[15,1,15,4],[15,10,15,12],[16,1,16,2],[16,5,16,8],[51,2,51,3]]}
[]
[null,{"$f":"UPPER(BREAKDOWN!G19)","v":"PROJECT MANAGER"},{"$nulls":7},{"$f":"IF(AND($P$36=0,$P$55=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},null,null,"Act No. 48 of 2000"]
[{"$nulls":12},"SACPCMP Guideline Tariff of Fees - Effective January 2012"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"+BREAKDOWN!H71","v":{"$error":"#DIV/0!"}}]
[]
["•","Discount %",null,{"$f":"+BREAKDOWN!H73","v":{"v":0.45,"d":"45%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!H75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D10>0,F10,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$78=1,BREAKDOWN!H75,0)","v":0},null,1,null,null,{"$f":"IF(D12>0,F12,0)","v":0}]
[]
[]
[]
[null,"Based on latest Tariff of Fees",{"$nulls":8},"Fee Calculations"]
[null,"Value for fee purposes",null,"Primary","Secondary","Grouping",{"$nulls":4},"Primary","Secondary","Total"]
[]
[null,0,{"v":10000001,"d":"10,000,001"},{"v":10000,"d":"10,000"},{"v":0.0635,"d":"6.35%"},1,{"$f":"IF($D$6>B19,F19,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$6<C19,F19,0)","v":{"$error":"#DIV/0!"}},{"$f":"H19*G19","v":{"$error":"#DIV/0!"}},null,{"$f":"I19*D19","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(($D$6-B19)*E19*I19,0)","v":{"$error":"#DIV/0!"}},{"$f":"L19+K19","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"C19+0.01","v":{"v":10000001.01,"d":"10,000,001"}},{"v":20000000.99,"d":"20,000,001"},{"v":645000,"d":"645,000"},{"v":0.0572,"d":"5.72%"},1,{"$f":"IF($D$6>B20,F20,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"ROUND(($D$6-B20)*E20*I20,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"v":20000001,"d":"20,000,001"},{"v":40000000.99,"d":"40,000,001"},{"v":1217000,"d":"1,217,000"},{"v":0.0514,"d":"5.14%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"ROUND(($D$6-B21)*E21*I21,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"v":40000001,"d":"40,000,001"},{"v":80000000.99,"d":"80,000,001"},{"v":2245000,"d":"2,245,000"},{"v":0.0463,"d":"4.63%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":80000001,"d":"80,000,001"},{"v":160000000.99,"d":"160,000,001"},{"v":4097000,"d":"4,097,000"},{"v":0.0407,"d":"4.07%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":160000001,"d":"160,000,001"},{"v":320000000.99,"d":"320,000,001"},{"v":7353000,"d":"7,353,000"},{"v":0.0358,"d":"3.58%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":320000001,"d":"320,000,001"},{"v":640000000.99,"d":"640,000,001"},{"v":13081000,"d":"13,081,000"},{"v":0.0308,"d":"3.08%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":640000001,"d":"640,000,001"},{"v":1280000000.99,"d":"1,280,000,001"},{"v":22937000,"d":"22,937,000"},{"v":0.0265,"d":"2.65%"},1,{"$f":"IF($D$6>B26,F26,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$6<C26,F26,0)","v":{"$error":"#DIV/0!"}},{"$f":"H26*G26","v":{"$error":"#DIV/0!"}},null,{"$f":"I26*D26","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"L26+K26","v":{"$error":"#DIV/0!"}}]
[null,{"v":1280000001,"d":"1,280,000,001"},{"v":2560000000.99,"d":"2,560,000,001"},{"v":39897000,"d":"39,897,000"},{"v":0.0228,"d":"2.28%"},1,{"$f":"IF($D$6>B27,F27,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$6<C27,F27,0)","v":{"$error":"#DIV/0!"}},{"$f":"H27*G27","v":{"$error":"#DIV/0!"}},null,{"$f":"I27*D27","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"L27+K27","v":{"$error":"#DIV/0!"}}]
[null,{"v":2560000001,"d":"2,560,000,001"},"and above",{"v":69081000,"d":"69,081,000"},{"v":0.0196,"d":"1.96%"},1,{"$f":"IF($D$6>B28,F28,0)","v":{"$error":"#DIV/0!"}},1,{"$f":"H28*G28","v":{"$error":"#DIV/0!"}},null,{"$f":"D28*I28","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"L28+K28","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":9},"R",{"$f":"SUM(K18:K29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L18:L29)","v":{"$error":"#DIV/0!"}},{"$f":"L30+K30","v":{"$error":"#DIV/0!"}}]
[]
[null,"Fee Calculation"]
[]
[null,"Primary Fee",null,{"$f":"K30","v":{"$error":"#DIV/0!"}}]
[null,"% Fee on full value",null,{"$f":"L30","v":{"$error":"#DIV/0!"}},{"$nulls":11},"ALL CHECKS TO BE = 0"]
[null,"Sub-total",null,{"$f":"SUM(D34:D35)","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"D36-M30","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[null,"Discount",null,{"$f":"ROUND(-$D$36*($D$8),0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D36:D38)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!H22","v":{"$error":"#DIV/0!"}},{"$nulls":12},{"v":3091487.02,"d":"3,091,487"}]
[]
[null,"Total PM Fee",null,{"$f":"ROUND(SUM(D39:D41),0)","v":{"$error":"#DIV/0!"}},"Excl Vat"]
[]
[{"$nulls":12},"                   "]
[]
[null,"Fee Stages"]
[]
[null,"Stage 1","Inception",null,{"$f":"ROUND($D$43*K49%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},10,"%"]
[null,"Stage 2","Concept and viability",null,{"$error":"#DIV/0!"},{"$nulls":5},10,"%"]
[null,"Stage 3","Design development",null,{"$error":"#DIV/0!"},{"$nulls":5},25,"%"]
[null,"Stage 4","Documentation and procurement ",null,{"$error":"#DIV/0!"},{"$nulls":5},10,"%"]
[null,"Stage 5","Construction",null,{"$error":"#DIV/0!"},{"$nulls":5},40,"%"]
[null,"Stage 6","Project close out",null,{"$error":"#DIV/0!"},{"$nulls":5},5,"%"]
[{"$nulls":4},{"$f":"SUM(E49:E54)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K49:K54)","v":100},"%",{"$nulls":3},{"$f":"D43-E55","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[]
[null,"Notes - See latest fee scales"]
["*","Standard services are identified in the latest fee publication, refer 3"]
["*","Additional services which attract additional fee shall be included if agreed to by the client and the Project construction manager"]
["*","Commission termination, refer 5"]
["*","Fees for additional/supplementary services, refer 9"]
["*","Time base fees, refer 10"]
["*","Expenses and costs, refer 11"]
[null,"                                       "]

{"sheet":"ARCH","index":15,"n_rows":83,"n_cols":17,"rows_kept":83,"hidden":true,"merged":[[5,4,5,10],[16,1,16,4],[16,10,16,12],[17,1,17,2],[17,5,17,8],[63,2,63,3],[64,2,64,3],[73,1,73,12],[74,1,74,12],[76,1,76,12]]}
[{"$nulls":10},"`"]
[null,{"$f":"UPPER(BREAKDOWN!J19)","v":"ARCHITECT"},null,null,{"$f":"IF(AND($P$39=0,$P$68=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},{"$nulls":7},"Board Notice 73 of 2015"]
[{"$nulls":12},"SACAP Professional Fees Guideline - Effective March 2015"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"BREAKDOWN!K71","v":{"$error":"#DIV/0!"}},"Including alteration value"]
[]
["•","Alteration value",null,{"$f":"BREAKDOWN!K38","v":0}]
[]
["•","Discount %",null,{"$f":"+BREAKDOWN!K73","v":{"v":0.45,"d":"45%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!K75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D12>0,F12,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$78=1,BREAKDOWN!K75,0)","v":0},null,1,{"$f":"SUM(I12,I14)","v":{"v":0,"d":"0 "}},null,{"$f":"IF(D14>0,F14,0)","v":0}]
[]
[]
[null,"Based on latest Tarrif of Fees",{"$nulls":8},"Fee Calculations"]
[null,"Value for fee purposes",null,"Base","% Fee","Grouping",{"$nulls":4},"Base","% Fee","Total"]
[]
[null,{"v":1,"d":"1 "},{"v":200000,"d":"200,000 "},{"v":18000,"d":"18,000 "},{"v":0.14,"d":"14.00%"},1,{"$f":"IF($D$6>B20,F20,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$6<C20,F20,0)","v":{"$error":"#DIV/0!"}},{"$f":"H20*G20","v":{"$error":"#DIV/0!"}},null,{"$f":"I20*D20","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(($D$6-B20)*E20*I20,0)","v":{"$error":"#DIV/0!"}},{"$f":"L20+K20","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"C20+B20","v":{"v":200001,"d":"200,001 "}},{"v":650000,"d":"650,000 "},{"v":46000,"d":"46,000 "},{"v":0.135,"d":"13.50%"},1,{"$f":"IF($D$6>B21,F21,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I21*D21","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(($D$6-B21)*E21*I21,0)","v":{"$error":"#DIV/0!"}},{"$f":"L21+K21","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"C21+$B$20","v":{"v":650001,"d":"650,001 "}},{"v":2000000,"d":"2,000,000 "},{"v":106750,"d":"106,750 "},{"v":0.12,"d":"12.00%"},1,{"$f":"IF($D$6>B22,F22,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":2000001,"d":"2,000,001 "},{"v":4000000,"d":"4,000,000 "},{"v":268750,"d":"268,750 "},{"v":0.105,"d":"10.50%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":4000001,"d":"4,000,001 "},{"v":6500000,"d":"6,500,000 "},{"v":478750,"d":"478,750 "},{"v":0.1,"d":"10.00%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":6500001,"d":"6,500,001 "},{"v":13000000,"d":"13,000,000 "},{"v":728749,"d":"728,749 "},{"v":0.095,"d":"9.50%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":13000001,"d":"13,000,001 "},{"v":40000000,"d":"40,000,000 "},{"v":1346249,"d":"1,346,249 "},{"v":0.09,"d":"9.00%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":40000001,"d":"40,000,001 "},{"v":130000000,"d":"130,000,000 "},{"v":3776249,"d":"3,776,249 "},{"v":0.085,"d":"8.50%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":130000001,"d":"130,000,001 "},{"v":260000000,"d":"260,000,000 "},{"v":11426249,"d":"11,426,249 "},{"v":0.0825,"d":"8.25%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":260000001,"d":"260,000,001 "},{"v":520000000,"d":"520,000,000 "},{"v":22151249,"d":"22,151,249 "},{"v":0.08,"d":"8.00%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":520000001,"d":"520,000,001 "},{"v":1040000000,"d":"1,040,000,000 "},{"v":42951249,"d":"42,951,249 "},{"v":0.0775,"d":"7.75%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":1040000001,"d":"1,040,000,001 "},{"v":0,"d":"0 "},{"v":83251249,"d":"83,251,249 "},{"v":0.075,"d":"7.50%"},1,{"$f":"IF($D$6>B31,F31,0)","v":{"$error":"#DIV/0!"}},1,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$nulls":9},"R",{"$f":"SUM(K19:K32)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L19:L32)","v":{"$error":"#DIV/0!"}},{"$f":"L33+K33","v":{"$error":"#DIV/0!"}}]
[]
[null,"Fee Calculation"]
[]
[null,"Basic Fee",null,{"$f":"K33","v":{"$error":"#DIV/0!"}}]
[null,"% Fee on full value",null,{"$f":"L33","v":{"$error":"#DIV/0!"}},{"$nulls":11},"ALL CHECKS TO BE = 0"]
[null,"Sub-total",null,{"$f":"SUM(D37:D38)","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"D39-M33","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[null,"Alteration fee",null,{"$f":"ROUND(+IF(BREAKDOWN!AU27=1,(($D$39/$D$6*$D$8)*$K$41),($D$39/$D$6*$D$8*$K$41)),0)","v":{"$error":"#DIV/0!"}},"Ref 1.3.7 ",{"$nulls":5},{"v":0.3,"d":"30%"},"Factor"]
[null,"Sub-total",null,{"$f":"SUM(D39:D41)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Restoration fee",null,{"$f":"IF(BREAKDOWN!AU28=1,((D39/1.15))*0.4,0)","v":0},"Ref 1.3.8"]
[null,"Sub-total",null,{"$f":"SUM(D42:D44)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Less: Principal Agency Fee",null,{"$f":"ROUND(-($D$45*(stage5to6)/100*0.1)*BREAKDOWN!AU25,0)","v":{"$error":"#DIV/0!"}},"Ref 1.3.3"]
[null,"Less: Principal Consultant Fee",null,0,"Ref 1.3.3"]
[null,"Sub-total",null,{"$f":"ROUND(SUM(D45:D48),-2)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Discount",null,{"$f":"ROUND(-$D$49*$D$10,0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D49:D51)","v":{"$error":"#DIV/0!"}},{"$nulls":12},{"$f":"D51/D49","v":{"$error":"#DIV/0!"}}]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!J22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Architectural Fee",null,{"$f":"SUM(D52:D54)","v":{"$error":"#DIV/0!"}},"Excl Vat"]
[]
[]
[null,"Fee Stages"]
[]
[null,"Stage 1","Inception ",null,{"$f":"ROUND(K61*$D$56%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[null,"Stage 2","Concept and viability",null,{"$error":"#DIV/0!"},{"$nulls":5},15,"%"]
[null,"Stage 3","Design Development",null,{"$error":"#DIV/0!"},{"$nulls":5},20,"%"]
[null,"Stage 4.1","Documentation and procurement ",null,{"$error":"#DIV/0!"},{"$nulls":5},20,"%"]
[null,"Stage 4.2","Documentation and procurement ",null,{"$error":"#DIV/0!"},{"$nulls":5},10,"%"]
[null,"Stage 5","Construction",null,{"$error":"#DIV/0!"},{"$nulls":5},27,"%"]
[null,"Stage 6","Close Out ",null,{"$error":"#DIV/0!"},{"$nulls":5},3,"%"]
[{"$nulls":4},{"$f":"SUM(E61:E67)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K61:K67)","v":100},"%",{"$nulls":3},{"$f":"D56-E68","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[]
[null,"Notes -See latest fee scales"]
["*","For time based fees refer to Table 2 of the Professional Fees Guideline of the latest fee publication"]
["*","Standard services are identified in the latest fee publication, refer 1.1"]
["*","Additional services which attract additional fee shall be included if agreed to by the client and the architectural professional"]
["*","For a partial service, assuming the fee is a project cost based fee, the percentage of the fee for each work stage to be performed is agreed between client and architectural professional (Ref 1.3.2)"]
["*","Fees for buildings repeated under separate building contracts refer 1.3.10"]
["*","Fees for an appointment where the architectural professional takes over incomplete work of another practitioner, refer 1.3.11"]
["*","Fees for deployment of employees, refer 1.3.13"]
["*","Fees for extended initial contractual contract period, refer 1.3.14"]
["*","Adjustment of guideline fees and disbursements, refer 1.3.15"]
["*","Travelling time, refer 1.3.16"]
["*","Guideline for fees on termination by client, refer 1.3.17"]
["*","Re-imbursement of expenses, refer 1.3.20"]

{"sheet":"QS","index":16,"n_rows":167,"n_cols":21,"rows_kept":167,"hidden":true,"merged":[[1,9,1,10],[5,4,5,10],[9,4,9,10],[18,1,18,4],[18,10,18,12],[19,1,19,2],[19,5,19,8],[41,1,42,1],[41,2,41,12],[42,5,42,9],[43,5,43,9],[44,5,44,9],[45,5,45,9],[46,5,46,9],[47,5,47,9],[57,1,58,1],[57,2,57,10],[68,2,68,4],[69,2,69,4],[74,1,75,1],[74,2,74,3],[84,1,84,2],[84,3,84,4],[85,1,85,2],[85,3,85,4],[86,3,86,4],[87,1,87,2],[87,3,87,4],[88,1,88,2],[88,3,88,4],[89,3,89,4],[90,1,90,2],[90,3,90,4],[91,3,91,4],[92,1,92,2],[92,3,92,4],[93,1,93,2],[93,3,93,4],[94,1,94,2],[94,3,94,4],[109,4,109,11],[112,4,112,11],[125,1,127,1],[125,2,125,12]]}
[]
[null,{"$f":"UPPER(BREAKDOWN!M19)","v":"QUANTITY SURVEYOR"},{"$nulls":7},{"$f":"IF(AND($P$99=0,$P$121=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},null,null,"Act 49 of 2000"]
[{"$nulls":12},"SACQSP 2015 Tariff of Professional Fees Schedule - Effective August  2015"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"+BREAKDOWN!N71","v":{"$error":"#DIV/0!"}},"Including alteration value"]
[]
["•","Alteration value",null,{"$f":"BREAKDOWN!N38","v":0}]
[]
["•","Redecoration works value",null,0,"Input value"]
[]
["•","Discount %",null,{"$f":"+BREAKDOWN!N73","v":{"v":0.45,"d":"45.0%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!N75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D14>0,F14,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$78=1,BREAKDOWN!N75,0)","v":0},null,1,null,null,{"$f":"IF(D16>0,F16,0)","v":0}]
[]
[]
[null,"Based on latest Tarrif of Fees",{"$nulls":8},"Fee Calculations"]
[null,"Value for fee purposes",null,"Primary","Marginal ","Grouping",{"$nulls":4},"Primary","Marginal","Total"]
[]
[null,{"v":0,"d":"0 "},{"v":1000000,"d":"1,000,000 "},{"v":19000,"d":"19,000 "},{"v":0.08,"d":"8.00%"},1,{"$f":"IF($D$6>B22,F22,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$6<C22,F22,0)","v":{"$error":"#DIV/0!"}},{"$f":"H22*G22","v":{"$error":"#DIV/0!"}},null,{"$f":"I22*D22","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(($D$6-B22)*E22*I22,0)","v":{"$error":"#DIV/0!"}},{"$f":"L22+K22","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"C22","v":{"v":1000000,"d":"1,000,000 "}},{"$f":"C22*2","v":{"v":2000000,"d":"2,000,000 "}},{"v":99000,"d":"99,000 "},{"v":0.08,"d":"8.00%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I23*D23","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(($D$6-B23)*E23*I23,0)","v":{"$error":"#DIV/0!"}},{"$f":"L23+K23","v":{"$error":"#DIV/0!"}}]
[null,{"v":2000000,"d":"2,000,000 "},{"v":4000000,"d":"4,000,000 "},{"v":179000,"d":"179,000 "},{"v":0.0795,"d":"7.95%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I24*D24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"L24+K24","v":{"$error":"#DIV/0!"}}]
[null,{"v":4000000,"d":"4,000,000 "},{"v":8000000,"d":"8,000,000 "},{"v":338000,"d":"338,000 "},{"v":0.0715,"d":"7.15%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I25*D25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"L25+K25","v":{"$error":"#DIV/0!"}}]
[null,{"v":8000000,"d":"8,000,000 "},{"v":16000000,"d":"16,000,000 "},{"v":624000,"d":"624,000 "},{"v":0.067,"d":"6.70%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I26*D26","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(($D$6-B26)*E26*I26,0)","v":{"$error":"#DIV/0!"}},{"$f":"L26+K26","v":{"$error":"#DIV/0!"}}]
[null,{"v":16000000,"d":"16,000,000 "},{"v":32000000,"d":"32,000,000 "},{"v":1160000,"d":"1,160,000 "},{"v":0.059,"d":"5.90%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I27*D27","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"L27+K27","v":{"$error":"#DIV/0!"}}]
[null,{"v":32000000,"d":"32,000,000 "},{"v":64000000,"d":"64,000,000 "},{"v":2104000,"d":"2,104,000 "},{"v":0.0527,"d":"5.27%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":64000000,"d":"64,000,000 "},{"v":128000000,"d":"128,000,000 "},{"v":3790400,"d":"3,790,400 "},{"v":0.0515,"d":"5.15%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I29*D29","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(($D$6-B29)*E29*I29,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"v":128000000,"d":"128,000,000 "},{"v":256000000,"d":"256,000,000 "},{"v":7086400,"d":"7,086,400 "},{"v":0.041,"d":"4.10%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"I30*D30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":256000000,"d":"256,000,000 "},{"v":500000000,"d":"500,000,000 "},{"v":12334400,"d":"12,334,400 "},{"v":0.0396,"d":"3.96%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":500000000,"d":"500,000,000 "},{"v":1500000000,"d":"1,500,000,000 "},{"v":21996800,"d":"21,996,800 "},{"v":0.035,"d":"3.50%"},1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":1500000000,"d":"1,500,000,000 "},{"v":3000000000,"d":"3,000,000,000 "},{"v":56969800,"d":"56,969,800 "},{"v":0.0312,"d":"3.12%"},1,{"$f":"IF($D$6>B33,F33,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$6<C33,F33,0)","v":{"$error":"#DIV/0!"}},{"$f":"H33*G33","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"v":3000000000,"d":"3,000,000,000 "},null,{"v":103769800,"d":"103,769,800 "},{"v":0.0244,"d":"2.44%"},1,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$nulls":9},"R",{"$f":"SUM(K21:K35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L21:L35)","v":{"$error":"#DIV/0!"}},{"$f":"L36+K36","v":{"$error":"#DIV/0!"}}]
[]
[null,"Fee Calculation"]
[]
[null,"Appropriate percentage for building work"]
[]
[null,"Category","Appropriate percentage"]
[null,null,"* Contracts with boq","* Contracts with simplified boq","Contracts without boq",{"$nulls":5},"Builder's quantities","Payment valuations","Cost-plus contracts"]
[null,{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"$nulls":5},{"v":5,"d":"5 "},{"v":6,"d":"6 "},{"v":7,"d":"7 "}]
[null,"Alterations",{"v":125,"d":"125 "},{"v":100,"d":"100 "},{"v":75,"d":"75 "},{"$nulls":5},{"v":20,"d":"20 "},{"v":15,"d":"15 "},{"v":70,"d":"70 "}]
[null,"Building works",{"v":100,"d":"100 "},{"v":75,"d":"75 "},{"v":75,"d":"75 "},{"$nulls":5},{"v":25,"d":"25 "},{"v":15,"d":"15 "},{"v":70,"d":"70 "}]
[null,"Redecoration",{"v":160,"d":"160 "},{"v":150,"d":"150 "},{"v":75,"d":"75 "},{"$nulls":5},{"v":50,"d":"50 "},{"v":15,"d":"15 "},{"v":70,"d":"70 "}]
[null,"Replication:"]
[null,"Prototypes","Apply applicable appropriate percentage",{"$nulls":9},"n/a"]
[null,"Replication of prototype","60% of applicable appropriate percentage",{"$nulls":9},"n/a"]
[null,"Multiple procurement:"]
[null,"Principal contractor appointed","Increase fee by ",{"v":0.1,"d":"10%"},{"$nulls":8},"n/a"]
[null,"No principal contractor appointed","Increase fee by ",{"v":0.2,"d":"20%"},{"$nulls":7},{"v":0.2,"d":"20%"},"n/a"]
[null,"* Includes contracts with bills of provisional quantities or schedule of rates"]
[]
[null,"Appropriate percentage for engineering works"]
[]
[null,"Category","Appropriate percentage"]
[null,null,"* Contracts with engineering boq","Contracts without engineering boq","Payment valuations",{"$nulls":5},"Cost-plus contracts"]
[null,{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"$nulls":5},{"v":5,"d":"5 "}]
[null,"Civil eng: Category 1",{"v":55,"d":"55 "},{"v":45,"d":"45 "},{"v":15,"d":"15 "},{"$nulls":5},{"v":55,"d":"55 "}]
[null,"Civil eng: Category 11",{"v":70,"d":"70 "},{"v":45,"d":"45 "},{"v":15,"d":"15 "},{"$nulls":5},{"v":55,"d":"55 "}]
[null,"Elect eng",{"v":65,"d":"65 "},{"v":45,"d":"45 "},{"v":15,"d":"15 "},{"$nulls":5},{"v":55,"d":"55 "}]
[null,"Mech eng",{"v":65,"d":"65 "},{"v":45,"d":"45 "},{"v":15,"d":"15 "},{"$nulls":5},{"v":55,"d":"55 "}]
[null,"Process eng:"]
[null,"Utilising detail isometric drawings",{"v":55,"d":"55 "},{"v":45,"d":"45 "},{"v":15,"d":"15 "},{"$nulls":5},{"v":55,"d":"55 "}]
[null,"Utilising general arrangement drawings",{"v":100,"d":"100 "},{"v":45,"d":"45 "},{"v":15,"d":"15 "},{"$nulls":5},{"v":55,"d":"55 "}]
[null,"Replication:"]
[null,"Prototypes","Applicable appropriate percentage",{"$nulls":7},"n/a"]
[null,"Replication of prototype","60% of applicable appropriate percentage",{"$nulls":7},"n/a"]
[null,"* Includes contracts with bills of provisional quantities or schedule of rates"]
[]
[null,"Appropriate percentage for management services"]
[]
[null,"Category","Appropriate percentage"]
[null,null,"Building works","Engineering works"]
[null,{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "}]
[null,"Principal agency",{"v":45,"d":"45 "},42.5]
[null,"Principal consultancy",{"v":30,"d":"30 "},27.5]
[null,"Project monitoring",{"v":25,"d":"25 "},22.5]
[null,"Quality inspection",{"v":15,"d":"15 "},{"v":15,"d":"15 "}]
[]
[null,"Appropriate percentage for supplementary services"]
[]
[null,"Category",null,"Appropriate percentage"]
[null,{"v":1,"d":"1 "},null,{"v":2,"d":"2 "}]
[null,"Cost norms",null,{"v":7,"d":"7 "}]
[null,"Location bills of quantities",null,"Negotiated"]
[null,"Schedule of materials for building works for which the QS has not prepared BoQ",null,"120 (calculated on the total value of such materials)"]
[null,"Targeted procurement",null,{"v":7,"d":"7 "}]
[null,"Valuations for assessment of taxation, fire insurance, expropriation, rental return and similar purposes based upon:",null,"A time charge where value is less than R10 000 000"]
[null,"Rate/area method with suitable drawings",null,{"v":1,"d":"1 "}]
[null,"Rate/area method with measurements on site",null,1.75]
[null,"Elemental method with suitable drawings",null,{"v":2,"d":"2 "}]
[null,"Elemental method with measurements on site",null,3.5]
[]
[null,"Primary Fee",null,{"$f":"K36","v":{"$error":"#DIV/0!"}}]
[null,"Marginal Fee",null,{"$f":"L36","v":{"$error":"#DIV/0!"}},{"$nulls":11},"ALL CHECKS TO BE = 0"]
[null,"Sub-total",null,{"$f":"SUM(D97:D98)","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"M36-D99","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[null,"Alteration fee",null,{"$f":"ROUND((D99/D6*D8)*K101,0)","v":{"$error":"#DIV/0!"}},{"$nulls":6},{"v":0.25,"d":"25%"},"Factor"]
[null,"Sub-total",null,{"$f":"SUM(D99:D101)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Re-decoration fee",null,{"$f":"ROUND(IF(BREAKDOWN!AU29=1,((D99/D6)*D10),(D99/D6*D10)*K104),0)","v":{"$error":"#DIV/0!"}},{"$nulls":6},{"v":0.6,"d":"60%"},"Factor"]
[null,"Sub-total",null,{"$f":"SUM(D102:D104)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Multi procurement fee",null,0]
[null,"Sub-total",null,{"$f":"SUM(D105:D107)","v":{"$error":"#DIV/0!"}},{"$nulls":11},"DO NOT DELETE"]
[]
[null,"Management Service",null,null,"Input value - Refer Fee Scale for calculation ",{"$nulls":10},{"$f":"IF(BREAKDOWN!#REF!=1,QS!D99*QS!C78/100,0)*0","v":{"$error":"#REF!"}}]
[null,"Sub-total",null,{"$f":"SUM(D108:D110)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Supplementary Service",null,null,"Input value - Refer Fee Scale for calculation ",{"$nulls":10},{"$f":"IF(BREAKDOWN!#REF!=1,QS!D99*QS!D87/100,0)*0","v":{"$error":"#REF!"}}]
[null,"Sub-total",null,{"$f":"SUM(D111:D113)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Discount",null,{"$f":"ROUND(-D114*D12,0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D114:D116)","v":{"$error":"#DIV/0!"}},{"$nulls":15},{"$f":"D116/D114","v":{"$error":"#DIV/0!"}},"check "]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!L22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Quantity Surveyors Fee",null,{"$f":"SUM(D117:D119)","v":{"$error":"#DIV/0!"}},"Excl Vat",{"$nulls":10},{"$f":"D121-E157","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[]
[null,"Fee Stages"]
[{"$nulls":15},"Provisional BoQ"]
[null,"Category ","Percentage fee"]
[null,null,"Stage 1","Stage 2","Stage 3",{"$nulls":5},"Stage 4","Stage 5","Stage 6"]
[null,null,"Inception","Concept and viability","Design development",{"$nulls":5},"Documentation and Procurement","Construction","Close-out"]
[null,{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"$nulls":5},{"v":5,"d":"5 "},{"v":6,"d":"6 "},{"v":7,"d":"7 "}]
[null,"BoQ & eng Boq:"]
[null,"Provisional BoQ",2.5,{"v":5,"d":"5 "},7.5,{"$nulls":5},17.5,62.5,{"v":5,"d":"5 "}]
[null,"BoQ ",2.5,{"v":5,"d":"5 "},7.5,{"$nulls":5},{"v":35,"d":"35 "},{"v":45,"d":"45 "},{"v":5,"d":"5 "}]
[null,"Schedule of rates",2.5,{"v":5,"d":"5 "},7.5,{"$nulls":5},12.5,67.5,{"v":5,"d":"5 "}]
[null,"Builders's quants","n/a","n/a","n/a",{"$nulls":5},{"v":100,"d":"100 "},"n/a","n/a"]
[null,"Contracts without BoQ",2.5,7.5,{"v":10,"d":"10 "},{"$nulls":5},{"v":20,"d":"20 "},52.5,7.5]
[null,"Cost norms",{"v":15,"d":"15 "},{"v":15,"d":"15 "},{"v":15,"d":"15 "},{"$nulls":5},{"v":20,"d":"20 "},{"v":25,"d":"25 "},{"v":10,"d":"10 "}]
[null,"Cost-plus contract",{"v":2.5,"d":"3 "},7.5,{"v":10,"d":"10 "},{"$nulls":5},{"v":0.15,"d":"0 "},57.5,7.5]
[null,"Payment valuation","n/a","n/a","n/a",{"$nulls":5},"n/a",92.5,7.5]
[null,"Principal agency","n/a","n/a",7.5,{"$nulls":5},7.5,{"v":70,"d":"70 "},{"v":15,"d":"15 "}]
[null,"Principal consultancy",{"v":25,"d":"25 "},{"v":25,"d":"25 "},{"v":25,"d":"25 "},{"$nulls":5},{"v":25,"d":"25 "},"n/a","n/a"]
[null,"Project monitoring",2.5,{"v":5,"d":"5 "},{"v":10,"d":"10 "},{"$nulls":5},17.5,{"v":50,"d":"50 "},{"v":15,"d":"15 "}]
[null,"Quality inspection","n/a","n/a","n/a",{"$nulls":5},"n/a",{"v":85,"d":"85 "},{"v":15,"d":"15 "}]
[null,"Replication of prototype",2.5,{"v":5,"d":"5 "},{"v":5,"d":"5 "},{"$nulls":5},17.5,62.5,7.5]
[null,"Schedule of materials","n/a","n/a","n/a",{"$nulls":5},"n/a",{"v":100,"d":"100 "},"n/a"]
[null,"Simplified BoQ contracts:"]
[null,"Provisional BoQ",2.5,7.5,{"v":10,"d":"10 "},{"$nulls":5},17.5,{"v":55,"d":"55 "},7.5]
[null,"BoQ",2.5,7.5,{"v":10,"d":"10 "},{"$nulls":5},{"v":35,"d":"35 "},37.5,7.5]
[null,"Schedule of rates",2.5,7.5,{"v":10,"d":"10 "},{"$nulls":5},12.5,{"v":60,"d":"60 "},7.5]
[null,"Targeted procurement","n/a","n/a","n/a",{"$nulls":5},20,60,20]
[]
[null,"Stage 1","Inception",null,{"$f":"ROUND($D$121*K151%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},2.5,"%",{"$nulls":3},2.5,"%"]
[null,"Stage 2","Concept & Viability",null,{"$error":"#DIV/0!"},{"$nulls":5},12.5,"%",{"$nulls":3},5,"%"]
[null,"Stage 3","Design Development",null,{"$error":"#DIV/0!"},{"$nulls":5},{"v":10,"d":"10.0"},"%",{"$nulls":3},7.5,"%"]
[null,"Stage 4","Documentation & Procurement",null,{"$error":"#DIV/0!"},{"$nulls":5},{"v":15,"d":"15.0"},"%",{"$nulls":3},17.5,"%"]
[null,"Stage 5","Construction",null,{"$error":"#DIV/0!"},{"$nulls":5},{"v":55,"d":"55.0"},"%",{"$nulls":3},{"v":62.5,"d":"62.50"},"%"]
[null,"Stage 6","Close Out",null,{"$error":"#DIV/0!"},{"$nulls":5},5,"%",{"$nulls":3},5,"%"]
[{"$nulls":4},{"$f":"SUM(E151:E156)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K151:K156)","v":100},"%"]
[]
[]
[null,"Notes - See latest fee scales"]
["*","Services at risk, refer 3"]
["*","Excessive variations, refer 4"]
["*","Commissions terminated, refer 5"]
["*","Extraordinary contract provisions, refer 6"]
["*","Time charge, refer 7"]
["*","Disbursements, refer 8"]
["*","Payment, refer 9"]

{"sheet":"STRUC","index":17,"n_rows":133,"n_cols":20,"rows_kept":133,"hidden":true,"merged":[[0,0,0,13],[1,9,1,10],[5,4,5,11],[7,4,7,12],[22,1,22,10],[22,11,22,12],[23,1,23,10],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[63,11,63,12],[64,11,64,12],[65,11,65,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[71,15,71,20],[76,1,76,2],[86,9,86,10],[87,9,87,10],[88,9,88,10],[89,9,89,10],[89,15,89,16],[90,9,90,10],[90,15,90,16],[91,9,91,10],[91,15,91,16],[92,9,92,10],[92,15,92,16],[93,9,93,10],[94,9,94,10],[94,15,94,16],[95,15,95,16],[96,15,96,16],[97,15,97,16],[107,1,107,3],[107,9,107,11],[108,1,108,2],[108,9,108,10]]}
[]
[null,{"$f":"UPPER(BREAKDOWN!P19)","v":"STRUCTURAL ENGINEER"},{"$nulls":7},{"$f":"IF(AND($P$12=0,$P$124=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},null,null,"Act 46 of 2000"]
[{"$nulls":12},"ECSA Guideline for Services and Process for estimating fees"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"+BREAKDOWN!Q71","v":{"$error":"#DIV/0!"}},"Excluding Preliminaries and Escalation"]
[]
["•","Main Contractor Preliminaries",null,{"$f":"BREAKDOWN!Q64","v":0},"Pro-rata of Main Contractors Preliminaries on Value of Engineering works"]
[]
["•","Escalation",null,0,{"$nulls":11},"ALL CHECKS TO BE = 0"]
[]
["•","Total value for fee purposes",null,{"$f":"D6+D8+D10","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"(D6+D8+D10)-D12","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
["•","Discount %",null,{"$f":"+BREAKDOWN!Q73","v":{"v":0.45,"d":"45.00%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!Q75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D16>0,F16,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!Q75/100),0)","v":0},null,{"v":1,"d":"1 "},null,null,{"$f":"IF(D18>0,F18,0)","v":{"v":0,"d":"0 "}}]
[]
[]
[null,"Fee Category",null,{"$f":"IF(R84<2,\"\",\"ONLY SELECT ONE FEE CATEGORY\")","v":""}]
[]
[null,"Project Type",{"$nulls":9},"Fee Category"]
[null,"General Agriculture Engineering",{"$nulls":9},"D"]
[null,"Pipelines"]
[null,"Water",{"$nulls":9},"A"]
[null,"Hazardous substances, submarine pipelines",{"$nulls":9},"D"]
[null,"Transport Infrastructure"]
[null,"Airport Runways, taxiways and Aprons",{"$nulls":9},"A"]
[null,"New and improved unpaved roads",{"$nulls":9},"C"]
[null,"New and improved Urban Roads",{"$nulls":9},"C"]
[null,"New Paved Rural Roads",{"$nulls":9},"A"]
[null,"New Rural Freeways",{"$nulls":9},"B"]
[null,"New Urban Freeways",{"$nulls":9},"D"]
[null,"Railway Trackwork",{"$nulls":9},"A"]
[null,"Railways (Excluding cost of track)",{"$nulls":9},"A"]
[null,"Road Rehabilitation",{"$nulls":9},"A"]
[null,"Rural Road Expansion",{"$nulls":9},"B"]
[null,"Water"]
[null,"Large Earth Dams",{"$nulls":9},"B"]
[null,"Large Concrete Dams",{"$nulls":9},"C"]
[null,"Small Dams",{"$nulls":9},"D"]
[null,"Stormwater Pipes (Pre-cast Units)",{"$nulls":9},"A"]
[null,"Irrigation - Centre Pivot, lateral move and similar",{"$nulls":9},"B"]
[null,"Irrigation - Sprinklers and similar",{"$nulls":9},"C"]
[null,"Irrigation - micro, drip and similar",{"$nulls":9},"D"]
[null,"River intakes, Pumpstations",{"$nulls":9},"E"]
[null,"Municipal and Building Civils"]
[null,"Building Civils",{"$nulls":9},"C"]
[null,"Municipal Services",{"$nulls":9},"C"]
[null,"Parking lots",{"$nulls":9},"A"]
[null,"Water and Sewage Treatment Works",{"$nulls":9},"F"]
[null,"Geotechnical"]
[null,"Underground Structures and Dredging",{"$nulls":9},"A"]
[null,"Reinforced Concrete and Structural Steel"]
[null,"Complex Load Bearing Structures, Quay Walls and Jetties ",{"$nulls":9},"F"]
[null,"Minor structures",{"$nulls":9},"C"]
[null,"Overpasses and Freeway Bridges",{"$nulls":9},"E"]
[null,"Powerstation Civil and Building",{"$nulls":9},"C"]
[null,"River Bridges",{"$nulls":9},"F"]
[null,"Stormwater structures, Breakwaters and canals (Designed)",{"$nulls":9},"C"]
[null,"Unique structures",{"$nulls":9},"E"]
[null,"Water Retaining Structures",{"$nulls":9},"D"]
[null,"Water Towers",{"$nulls":9},"E"]
[null,"Building Structural"]
[null,"Iconic and Unique Buildings and Structural Alterations",{"$nulls":9},"G"]
[null,"Hospitals, Hotels, Airports, Stadia, Exhibition Halls and Retail Shopping Centres",{"$nulls":9},"F"]
[null,"Residential, Offices, Educational and Industrial",{"$nulls":9},"E"]
[null,"Warehouses",{"$nulls":9},"D"]
[]
[]
[{"$nulls":15},"DO NOT DELETE"]
[]
[{"$nulls":16},false,{"$f":"-(Q74*-1)","v":0},{"$f":"IF(R74=1,1,0)","v":0}]
[{"$nulls":16},false,0,{"$f":"IF(R75=1,2,0)","v":0}]
[{"$nulls":16},true,1,{"$f":"IF(R76=1,3,0)","v":3}]
[null,"Fee range for project categories",null,{"$f":"IF(R88<2,\"\",\"ONLY SELECT ONE FEE RANGE\")","v":""},{"$nulls":12},false,0,{"$f":"IF(R77=1,4,0)","v":0}]
[{"$nulls":16},false,0,{"$f":"IF(R78=1,5,0)","v":0}]
[{"$nulls":16},false,0,{"$f":"IF(R79=1,6,0)","v":0}]
[{"$nulls":16},false,0,{"$f":"IF(R80=1,7,0)","v":0}]
[{"$nulls":18},{"$f":"SUM(S74:S80)","v":3}]
[null,"Fee Calculation"]
[]
[null,"% at R10 mil value",{"$f":"IF(AND(R84<=1,R88<=1),INDEX(C89:E95,S81,S88),\"ERROR\")","v":{"v":0.09,"d":"9.00%"}},{"$nulls":14},{"$f":"SUM(R74:R80)","v":1}]
[null,"% applicable to project",{"$f":"SUM(T90:T93)","v":{"$error":"#DIV/0!"}},{"$nulls":13},false,{"$f":"-(Q85*-1)","v":0},{"$f":"IF(R85=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q86*-1)","v":0},{"$f":"IF(R86=1,2,0)","v":0}]
[null,"Fee Category","Lower Limit","Upper Limit","Average",{"$nulls":4},"Values",{"$nulls":6},true,{"$f":"-(Q87*-1)","v":1},{"$f":"IF(R87=1,3,0)","v":3}]
[{"$nulls":9},"1 000 001 < 10 000 000",{"$nulls":7},{"$f":"SUM(R85:R87)","v":1},{"$f":"SUM(S85:S87)","v":3}]
[null,"A",{"v":0.06,"d":"6%"},{"v":0.08,"d":"8%"},{"$f":"AVERAGE(C89:D89)","v":{"v":0.07,"d":"7.00%"}},{"$nulls":4},{"v":0.06,"d":"6.00%"}]
[null,"B",{"v":0.07,"d":"7%"},{"v":0.09,"d":"9%"},{"v":0.08,"d":"8.00%"},{"$nulls":4},{"v":0.07,"d":"7.00%"},{"$nulls":5},"0 < 1 000 000",null,{"$f":"AND(0<$D$12,$D$12<=1000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R90*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S90=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"C",{"v":0.08,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.09,"d":"9.00%"},{"$nulls":4},{"v":0.08,"d":"8.00%"},{"$nulls":5},"1 000 001 < 10 000 000",null,{"$f":"AND(1000001<=$D$12,$D$12<=10000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R91*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S91=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"D",{"v":0.09,"d":"9%"},{"v":0.11,"d":"11%"},{"v":0.1,"d":"10.00%"},{"$nulls":4},{"v":0.09,"d":"9.00%"},{"$nulls":5},"10 000 001 < 100 000 000",null,{"$f":"AND(10000001<=$D$12,$D$12<=100000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R92*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S92=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"E",{"v":0.1,"d":"10%"},{"v":0.13,"d":"13%"},{"$f":"AVERAGE(C93:D93)","v":{"v":0.115,"d":"11.50%"}},{"$nulls":4},{"v":0.1,"d":"10.00%"},{"$nulls":5},"100 000 001 < 1 000 000 000",null,{"$f":"AND(100000001<=$D$12,$D$12<=1000000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R93*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S93=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"F",{"v":0.11,"d":"11%"},{"v":0.14,"d":"14%"},{"v":0.125,"d":"12.50%"},{"$nulls":4},{"v":0.11,"d":"11.00%"}]
[null,"G",{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.135,"d":"13.50%"},{"$nulls":4},{"v":0.12,"d":"12.00%"},{"$nulls":5},{"$f":"SUM(T90:T93)-C85","v":{"$error":"#DIV/0!"}}]
[{"$nulls":15},"CHECK"]
[null,"Fee",null,{"$f":"ROUND(D12*C85,0)","v":{"$error":"#DIV/0!"}}]
[null,"Discount",null,{"$f":"ROUND(-$D$97*$D$14,0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D97:D98)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!N22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Structural Engineer Fee",null,{"$f":"SUM(D99:D101)","v":{"$error":"#DIV/0!"}},"Excl Vat"]
[]
[]
[null,"Fee Stages "]
[]
[null,"Engineering Projects",{"$nulls":7},"Building Projects"]
[null,"Stage of Service",null,"Percentage",{"$nulls":5},"Stage of Service",null,"Percentage"]
[null,"Inception",null,{"v":0.05,"d":"5%"},{"$nulls":5},"Inception",null,{"v":0.05,"d":"5%"}]
[null,"Concept and Viability",null,{"v":0.25,"d":"25%"},{"$nulls":5},"Concept and Viability",null,{"v":0.2,"d":"20%"}]
[null,"Design Development",null,{"v":0.3,"d":"30%"},{"$nulls":5},"Design Development",null,{"v":0.3,"d":"30%"}]
[null,"Documentation and Procurement",null,{"v":0.1,"d":"10%"},{"$nulls":5},"Documentation and Procurement",null,{"v":0.15,"d":"15%"}]
[null,"Contract admin and Inception",null,{"v":0.25,"d":"25%"},{"$nulls":5},"Contract admin and Inception",null,{"v":0.25,"d":"25%"}]
[null,"Close-out",null,{"v":0.05,"d":"5%"},{"$nulls":5},"Close-out",null,{"v":0.05,"d":"5%"}]
[]
[]
[null,"Stage 1","Inception",null,{"$f":"ROUND($D$103*K118%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[null,"Stage 2","Concept & Viability",null,{"$f":"ROUND($D$103*K119%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},20,"%"]
[null,"Stage 3","Design Development",null,{"$error":"#DIV/0!"},{"$nulls":5},30,"%"]
[null,"Stage 4","Documentation & Procurement",null,{"$error":"#DIV/0!"},{"$nulls":5},15,"%"]
[null,"Stage 5","Construction",null,{"$error":"#DIV/0!"},{"$nulls":5},25,"%"]
[null,"Stage 6","Close Out",null,{"$error":"#DIV/0!"},{"$nulls":5},5,"%"]
[{"$nulls":4},{"$f":"SUM(E118:E123)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K118:K123)","v":100},"%",{"$nulls":3},{"$f":"D103-E124","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[]
[null,"Notes - See latest fee scales"]
["*","Guideline and scope of service, refer 3"]
["*","Processes for estimating fees, refer 4.1"]
["*","Time based fees, refer 4.2"]
["*","Fees for additional service, refer 4.4"]
["*","Value based fees, refer 4.5"]
["*","Expenses and Costs. Refer 4.6"]

{"sheet":"CIVIL","index":18,"n_rows":133,"n_cols":20,"rows_kept":133,"hidden":true,"merged":[[0,0,0,13],[1,9,1,10],[5,4,5,11],[22,1,22,10],[22,11,22,12],[23,1,23,10],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[63,11,63,12],[64,11,64,12],[65,11,65,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[71,15,71,20],[76,1,76,2],[86,9,86,10],[86,11,86,12],[87,9,87,10],[87,11,87,12],[88,9,88,10],[88,11,88,12],[89,9,89,10],[89,11,89,12],[89,15,89,16],[90,9,90,10],[90,11,90,12],[90,15,90,16],[91,9,91,10],[91,11,91,12],[91,15,91,16],[92,9,92,10],[92,11,92,12],[92,15,92,16],[93,9,93,10],[93,11,93,12],[94,9,94,10],[94,11,94,12],[107,1,107,3],[107,9,107,11],[108,1,108,2],[108,9,108,10]]}
[]
[null,{"$f":"UPPER(BREAKDOWN!S19)","v":"CIVIL ENGINEER"},{"$nulls":7},{"$f":"IF(AND($P$12=0,$P$124=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},null,null,"Act 46 of 2000"]
[{"$nulls":12},"ECSA Guideline for Services and Process for estimating fees"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"+BREAKDOWN!T71","v":{"$error":"#DIV/0!"}},"Excluding Preliminaries and Escalation"]
[]
["•","Main Contractor Preliminaries",null,{"$f":"BREAKDOWN!T64","v":0},"Pro-rata of Main Contractors Preliminaries on Value of Engineering works"]
[]
["•","Escalation",null,0,{"$nulls":11},"ALL CHECKS TO BE = 0"]
[]
["•","Total value for fee purposes",null,{"$f":"D6+D8+D10","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"(D6+D8+D10)-D12","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
["•","Discount %",null,{"$f":"+BREAKDOWN!W73","v":{"v":0.45,"d":"45%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!T75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D16>0,F16,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!T75/100),0)","v":0},null,{"v":1,"d":"1 "},null,null,{"$f":"IF(D18>0,F18,0)","v":{"v":0,"d":"0 "}}]
[]
[]
[null,"Fee Category",null,{"$f":"IF(R84<2,\"\",\"ONLY SELECT ONE FEE CATEGORY\")","v":""}]
[]
[null,"Project Type",{"$nulls":9},"Fee Category"]
[null,"General Agriculture Engineering",{"$nulls":9},"D"]
[null,"Pipelines"]
[null,"Water",{"$nulls":9},"A"]
[null,"Hazardous substances, submarine pipelines",{"$nulls":9},"D"]
[null,"Transport Infrastructure"]
[null,"Airport Runways, taxiways and Aprons",{"$nulls":9},"A"]
[null,"New and improved unpaved roads",{"$nulls":9},"C"]
[null,"New and improved Urban Roads",{"$nulls":9},"C"]
[null,"New Paved Rural Roads",{"$nulls":9},"A"]
[null,"New Rural Freeways",{"$nulls":9},"B"]
[null,"New Urban Freeways",{"$nulls":9},"D"]
[null,"Railway Trackwork",{"$nulls":9},"A"]
[null,"Railways (Excluding cost of track)",{"$nulls":9},"A"]
[null,"Road Rehabilitation",{"$nulls":9},"A"]
[null,"Rural Road Expansion",{"$nulls":9},"B"]
[null,"Water"]
[null,"Large Earth Dams",{"$nulls":9},"B"]
[null,"Large Concrete Dams",{"$nulls":9},"C"]
[null,"Small Dams",{"$nulls":9},"D"]
[null,"Stormwater Pipes (Pre-cast Units)",{"$nulls":9},"A"]
[null,"Irrigation - Centre Pivot, lateral move and similar",{"$nulls":9},"B"]
[null,"Irrigation - Sprinklers and similar",{"$nulls":9},"C"]
[null,"Irrigation - micro, drip and similar",{"$nulls":9},"D"]
[null,"River intakes, Pumpstations",{"$nulls":9},"E"]
[null,"Municipal and Building Civils"]
[null,"Building Civils",{"$nulls":9},"C"]
[null,"Municipal Services",{"$nulls":9},"C"]
[null,"Parking lots",{"$nulls":9},"A"]
[null,"Water and Sewage Treatment Works",{"$nulls":9},"F"]
[null,"Geotechnical"]
[null,"Underground Structures and Dredging",{"$nulls":9},"A"]
[null,"Reinforced Concrete and Structural Steel"]
[null,"Complex Load Bearing Structures, Quay Walls and Jetties ",{"$nulls":9},"F"]
[null,"Minor structures",{"$nulls":9},"C"]
[null,"Overpasses and Freeway Bridges",{"$nulls":9},"E"]
[null,"Powerstation Civil and Building",{"$nulls":9},"C"]
[null,"River Bridges",{"$nulls":9},"F"]
[null,"Stormwater structures, Breakwaters and canals (Designed)",{"$nulls":9},"C"]
[null,"Unique structures",{"$nulls":9},"E"]
[null,"Water Retaining Structures",{"$nulls":9},"D"]
[null,"Water Towers",{"$nulls":9},"E"]
[null,"Building Structural"]
[null,"Iconic and Unique Buildings and Structural Alterations",{"$nulls":9},"G"]
[null,"Hospitals, Hotels, Airports, Stadia, Exhibition Halls and Retail Shopping Centres",{"$nulls":9},"F"]
[null,"Residential, Offices, Educational and Industrial",{"$nulls":9},"E"]
[null,"Warehouses",{"$nulls":9},"D"]
[]
[]
[{"$nulls":15},"DO NOT DELETE"]
[]
[{"$nulls":16},false,{"$f":"-(Q74*-1)","v":0},{"$f":"IF(R74=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q75*-1)","v":0},{"$f":"IF(R75=1,2,0)","v":0}]
[{"$nulls":16},true,1,{"$f":"IF(R76=1,3,0)","v":3}]
[null,"Fee range for project categories",null,{"$f":"IF(R88<2,\"\",\"ONLY SELECT ONE FEE RANGE\")","v":""},{"$nulls":12},false,{"$f":"-(Q77*-1)","v":0},{"$f":"IF(R77=1,4,0)","v":0}]
[{"$nulls":16},false,0,{"$f":"IF(R78=1,5,0)","v":0}]
[{"$nulls":16},false,0,{"$f":"IF(R79=1,6,0)","v":0}]
[{"$nulls":16},false,0,{"$f":"IF(R80=1,7,0)","v":0}]
[{"$nulls":18},{"$f":"SUM(S74:S80)","v":3}]
[null,"Fee Calculation"]
[]
[null,"% at R10 mil value",{"$f":"IF(AND(R84<=1,R88<=1),INDEX(C89:E95,S81,S88),\"ERROR\")","v":{"v":0.09,"d":"9%"}},{"$nulls":14},{"$f":"SUM(R74:R80)","v":1}]
[null,"% applicable to project",{"$f":"SUM(T90:T93)","v":{"$error":"#DIV/0!"}},{"$nulls":13},false,{"$f":"-(Q85*-1)","v":0},{"$f":"IF(R85=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q86*-1)","v":0},{"$f":"IF(R86=1,2,0)","v":0}]
[null,"Fee Category","Lower Limit","Upper Limit","Average",{"$nulls":4},"Values",{"$nulls":6},true,{"$f":"-(Q87*-1)","v":1},{"$f":"IF(R87=1,3,0)","v":3}]
[{"$nulls":9},"1 000 001 < 10 000 000",{"$nulls":7},{"$f":"SUM(R85:R87)","v":1},{"$f":"SUM(S85:S87)","v":3}]
[null,"A",{"v":0.06,"d":"6%"},{"v":0.08,"d":"8%"},{"$f":"AVERAGE(C89:D89)","v":{"v":0.07,"d":"7%"}},{"$nulls":4},{"v":0.06,"d":"6%"}]
[null,"B",{"v":0.07,"d":"7%"},{"v":0.09,"d":"9%"},{"v":0.08,"d":"8%"},{"$nulls":4},{"v":0.07,"d":"7%"},{"$nulls":5},"0 < 1 000 000",null,{"$f":"AND(0<$D$12,$D$12<=1000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R90*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S90=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"C",{"v":0.08,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.09,"d":"9%"},{"$nulls":4},{"v":0.08,"d":"8%"},{"$nulls":5},"1 000 001 < 10 000 000",null,{"$f":"AND(1000001<=$D$12,$D$12<=10000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R91*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S91=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"D",{"v":0.09,"d":"9%"},{"v":0.11,"d":"11%"},{"v":0.1,"d":"10%"},{"$nulls":4},{"v":0.09,"d":"9%"},{"$nulls":5},"10 000 001 < 100 000 000",null,{"$f":"AND(10000001<=$D$12,$D$12<=100000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R92*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S92=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"E",{"v":0.1,"d":"10%"},{"v":0.13,"d":"13%"},{"v":0.115,"d":"12%"},{"$nulls":4},{"v":0.1,"d":"10%"},{"$nulls":5},"100 000 001 < 1 000 000 000",null,{"$f":"AND(100000001<=$D$12,$D$12<=1000000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R93*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S93=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$84),0)","v":{"$error":"#DIV/0!"}}]
[null,"F",{"v":0.11,"d":"11%"},{"v":0.14,"d":"14%"},{"v":0.125,"d":"13%"},{"$nulls":4},{"v":0.11,"d":"11%"}]
[null,"G",{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.135,"d":"14%"},{"$nulls":4},{"v":0.12,"d":"12%"},{"$nulls":5},{"$f":"SUM(T90:T93)-C85","v":{"$error":"#DIV/0!"}}]
[{"$nulls":15},"CHECK"]
[null,"Fee",null,{"$f":"ROUND(D12*C85,0)","v":{"$error":"#DIV/0!"}}]
[null,"Discount",null,{"$f":"ROUND(-$D$97*($D$14),0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D97:D98)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!P22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Civil Engineer Fee",null,{"$f":"SUM(D99:D101)","v":{"$error":"#DIV/0!"}},"Excl Vat"]
[]
[]
[null,"Fee Stages "]
[]
[null,"Engineering Projects",{"$nulls":7},"Building Projects"]
[null,"Stage of Service",null,"Percentage",{"$nulls":5},"Stage of Service",null,"Percentage"]
[null,"Inception",null,{"v":0.05,"d":"5%"},{"$nulls":5},"Inception",null,{"v":0.05,"d":"5%"}]
[null,"Concept and Viability",null,{"v":0.25,"d":"25%"},{"$nulls":5},"Concept and Viability",null,{"v":0.25,"d":"25%"}]
[null,"Design Development",null,{"v":0.25,"d":"25%"},{"$nulls":5},"Design Development",null,{"v":0.25,"d":"25%"}]
[null,"Documentation and Procurement",null,{"v":0.15,"d":"15%"},{"$nulls":5},"Documentation and Procurement",null,{"v":0.15,"d":"15%"}]
[null,"Contract admin and Inception",null,{"v":0.25,"d":"25%"},{"$nulls":5},"Contract admin and Inception",null,{"v":0.25,"d":"25%"}]
[null,"Close-out",null,{"v":0.05,"d":"5%"},{"$nulls":5},"Close-out",null,{"v":0.05,"d":"5%"}]
[]
[]
[null,"Stage 1","Inception",null,{"$f":"ROUND($D$103*K118%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[null,"Stage 2","Concept & Viability",null,{"$f":"ROUND($D$103*K119%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},25,"%"]
[null,"Stage 3","Design Development",null,{"$error":"#DIV/0!"},{"$nulls":5},25,"%"]
[null,"Stage 4","Documentation & Procurement",null,{"$error":"#DIV/0!"},{"$nulls":5},15,"%"]
[null,"Stage 5","Construction",null,{"$error":"#DIV/0!"},{"$nulls":5},25,"%"]
[null,"Stage 6","Close Out",null,{"$error":"#DIV/0!"},{"$nulls":5},5,"%"]
[{"$nulls":4},{"$f":"SUM(E118:E123)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K118:K123)","v":100},"%",{"$nulls":3},{"$f":"D103-E124","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[]
[null,"Notes - See latest fee scales"]
["*","Guideline and scope of service, refer 3"]
["*","Processes for estimating fees, refer 4.1"]
["*","Time based fees, refer 4.2"]
["*","Fees for additional service, refer 4.4"]
["*","Value based fees, refer 4.5"]
["*","Expenses and Costs. Refer 4.6"]

{"sheet":"MECH","index":19,"n_rows":97,"n_cols":20,"rows_kept":97,"hidden":true,"merged":[[0,0,0,13],[1,9,1,10],[5,4,5,11],[22,1,22,10],[22,11,22,12],[23,1,23,10],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[44,15,44,20],[49,1,49,2],[59,9,59,10],[59,11,59,12],[60,9,60,10],[60,11,60,12],[61,9,61,10],[61,11,61,12],[62,9,62,10],[62,11,62,12],[62,15,62,16],[63,9,63,10],[63,11,63,12],[63,15,63,16],[64,9,64,10],[64,11,64,12],[64,15,64,16],[65,9,65,10],[65,11,65,12],[65,15,65,16],[66,9,66,10],[66,11,66,12],[67,9,67,10],[67,11,67,12]]}
[]
[null,{"$f":"UPPER(BREAKDOWN!V19)","v":"MECHANICAL ENGINEER"},{"$nulls":7},{"$f":"IF(AND($P$12=0,$P$88=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},null,null,"Act 46 of 2000"]
[{"$nulls":12},"ECSA Guideline for Services and Process for estimating fees"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"+BREAKDOWN!W71","v":{"$error":"#DIV/0!"}}]
[]
["•","Main Contractor Preliminaries",null,{"$f":"BREAKDOWN!W64","v":0}]
[]
["•","Escalation",null,{"$f":"BREAKDOWN!W68+BREAKDOWN!W69","v":{"$error":"#DIV/0!"}},{"$nulls":11},"ALL CHECKS TO BE = 0"]
[]
["•","Total value for fee purposes",null,{"$f":"D6+D8+D10","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"(D6+D8+D10)-D12","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
["•","Discount %",null,{"$f":"+BREAKDOWN!W73","v":{"v":0.45,"d":"45%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!W75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D16>0,F16,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!W75/100),0)","v":0},null,{"v":1,"d":"1 "},null,null,{"$f":"IF(D18>0,F18,0)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":15},{"$f":"+MECH!E88*50","v":{"$error":"#DIV/0!"}}]
[null,"Fee Category",null,{"$f":"IF(R57<2,\"\",\"ONLY SELECT ONE FEE CATEGORY\")","v":""}]
[]
[null,"Project Type",{"$nulls":9},"Fee Category"]
[null,"Engineering Services"]
[null,"Green building design and energy management",{"$nulls":9},"F"]
[null,"Specialised fire protection systems such as gas, foam, extinguishing, etc.",{"$nulls":9},"D"]
[null,"Hazardous material systems",{"$nulls":9},"F"]
[null,"HVAC systems",{"$nulls":9},"D"]
[null,"Industrial process, piping and instrumentation",{"$nulls":9},"E"]
[null,"Mechanical plant and equipment",{"$nulls":9},"C"]
[null,"Pressure vessel design",{"$nulls":9},"F"]
[null,"Pumping and pipeline systems",{"$nulls":9},"D"]
[null,"Refrigeration and cold storage",{"$nulls":9},"C"]
[null,"Vertical transportation systems and material handling",{"$nulls":9},"D"]
[null,"Building Services"]
[null,"Industrial building services and utilities",{"$nulls":9},"E"]
[null,"General - Commercial, retail, offices, schools, hostels, clinics, hotels and resorts",{"$nulls":9},"E"]
[null,"Specialised - Airport buildings, museums, theaters, libraries, public entertainment, hospitals, research facilities, universities.",{"$nulls":9},"F"]
[null,"laboratories, conference facilities, institutional buildings and facilities"]
[null,"Residential - Individual luxury housing units and apartment buildings",{"$nulls":9},"F"]
[null,"Residential - Multiple (>50) standard housing units",{"$nulls":9},"C"]
[null,"Wet Services",{"$nulls":9},"G"]
[]
[]
[{"$nulls":15},"DO NOT DELETE"]
[]
[{"$nulls":16},false,{"$f":"-(Q47*-1)","v":0},{"$f":"IF(R47=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q48*-1)","v":0},{"$f":"IF(R48=1,2,0)","v":0}]
[{"$nulls":16},true,{"$f":"-(Q49*-1)","v":1},{"$f":"IF(R49=1,3,0)","v":3}]
[null,"Fee range for project categories",null,{"$f":"IF(R61<2,\"\",\"ONLY SELECT ONE FEE RANGE\")","v":""},{"$nulls":12},false,{"$f":"-(Q50*-1)","v":0},{"$f":"IF(R50=1,4,0)","v":0}]
[]
[]
[]
[{"$nulls":18},{"$f":"SUM(S47:S53)","v":3}]
[null,"Fee Calculation"]
[]
[null,"% at R10 mil value",{"v":0.12,"d":"12.00%"},{"$nulls":14},{"$f":"SUM(R47:R53)","v":1}]
[null,"% applicable to project",{"$f":"SUM(T63:T66)","v":{"$error":"#DIV/0!"}},{"$nulls":13},false,{"$f":"-(Q58*-1)","v":0},{"$f":"IF(R58=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q59*-1)","v":0},{"$f":"IF(R59=1,2,0)","v":0}]
[null,"Fee Category","Lower Limit","Upper Limit","Average",{"$nulls":4},"Values",{"$nulls":6},true,{"$f":"-(Q60*-1)","v":1},{"$f":"IF(R60=1,3,0)","v":3}]
[{"$nulls":9},"1 000 001 < 10 000 000",{"$nulls":7},{"$f":"SUM(R58:R60)","v":1},{"$f":"SUM(S58:S60)","v":3}]
[null,"A",{"v":0.06,"d":"6%"},{"v":0.08,"d":"8%"},{"$f":"AVERAGE(C62:D62)","v":{"v":0.07,"d":"7%"}},{"$nulls":4},{"v":0.06,"d":"6%"}]
[null,"B",{"v":0.07,"d":"7%"},{"v":0.09,"d":"9%"},{"v":0.08,"d":"8%"},{"$nulls":4},{"v":0.07,"d":"7%"},{"$nulls":5},"0 < 1 000 000",null,{"$f":"AND(0<$D$12,$D$12<=1000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R63*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S63=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$57),0)","v":{"$error":"#DIV/0!"}}]
[null,"C",{"v":0.08,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.09,"d":"9%"},{"$nulls":4},{"v":0.08,"d":"8%"},{"$nulls":5},"1 000 001 < 10 000 000",null,{"$f":"AND(1000001<=$D$12,$D$12<=10000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R64*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S64=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$57),0)","v":{"$error":"#DIV/0!"}}]
[null,"D",{"v":0.09,"d":"9%"},{"v":0.11,"d":"11%"},{"v":0.1,"d":"10%"},{"$nulls":4},{"v":0.09,"d":"9%"},{"$nulls":5},"10 000 001 < 100 000 000",null,{"$f":"AND(10000001<=$D$12,$D$12<=100000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R65*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S65=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$57),0)","v":{"$error":"#DIV/0!"}}]
[null,"E",{"v":0.1,"d":"10%"},{"v":0.13,"d":"13%"},{"v":0.115,"d":"12%"},{"$nulls":4},{"v":0.1,"d":"10%"},{"$nulls":5},"100 000 001 < 1 000 000 000",null,{"$f":"AND(100000001<=$D$12,$D$12<=1000000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R66*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S66=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$57),0)","v":{"$error":"#DIV/0!"}}]
[null,"F",{"v":0.11,"d":"11%"},{"v":0.14,"d":"14%"},{"v":0.125,"d":"13%"},{"$nulls":4},{"v":0.11,"d":"11%"}]
[null,"G",{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.135,"d":"14%"},{"$nulls":4},{"v":0.12,"d":"12%"},{"$nulls":5},{"$f":"SUM(T63:T66)-C58","v":{"$error":"#DIV/0!"}}]
[{"$nulls":15},"CHECK"]
[null,"Fee",null,{"$f":"ROUND(D12*C58,0)","v":{"$error":"#DIV/0!"}}]
[null,"Discount",null,{"$f":"ROUND(-$D$70*($D$14),0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D70:D71)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!R22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Mechanical Engineer Fee",null,{"$f":"SUM(D72:D74)","v":{"$error":"#DIV/0!"}},"Excl Vat"]
[]
[]
[null,"Fee Stages "]
[]
[]
[null,"Stage 1","Inception",null,{"$f":"ROUND($D$76*K82%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[null,"Stage 2","Concept & Viability",null,{"$f":"ROUND($D$76*K83%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},15,"%"]
[null,"Stage 3","Design Development and",null,{"$f":"ROUND($D$76*K84%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},40,"%"]
[null,null,"Documentation & Procurement"]
[null,"Stage 4","Construction",null,{"$f":"ROUND($D$76*K86%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},35,"%"]
[null,"Stage 5","Close Out",null,{"$f":"ROUND($D$76*K87%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[{"$nulls":4},{"$f":"SUM(E82:E87)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K82:K87)","v":100},"%",{"$nulls":3},{"$f":"D76-E88","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[]
[null,"Notes - See latest fee scales"]
["*","Guideline and scope of service, refer 3"]
["*","Processes for estimating fees, refer 4.1"]
["*","Time based fees, refer 4.2"]
["*","Fees for additional service, refer 4.4"]
["*","Value based fees, refer 4.5"]
["*","Expenses and Costs. Refer 4.6"]

{"sheet":"ELEC","index":20,"n_rows":95,"n_cols":20,"rows_kept":95,"hidden":true,"merged":[[0,0,0,13],[1,9,1,10],[5,4,5,11],[22,1,22,10],[22,11,22,12],[23,1,23,10],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[42,15,42,20],[47,1,47,2],[57,9,57,10],[57,11,57,12],[58,9,58,10],[58,11,58,12],[59,9,59,10],[59,11,59,12],[60,9,60,10],[60,11,60,12],[60,15,60,16],[61,9,61,10],[61,11,61,12],[61,15,61,16],[62,9,62,10],[62,11,62,12],[62,15,62,16],[63,9,63,10],[63,11,63,12],[63,15,63,16],[64,9,64,10],[64,11,64,12],[65,9,65,10],[65,11,65,12],[105,2,108,8]]}
[]
[null,{"$f":"UPPER(BREAKDOWN!Y19)","v":"ELECTRICAL ENGINEER"},{"$nulls":7},{"$f":"IF(AND($P$12=0,$P$87=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},null,null,"Act 46 of 2000"]
[{"$nulls":12},"ECSA Guideline for Services and Process for estimating fees"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"+BREAKDOWN!Z71","v":{"$error":"#DIV/0!"}}]
[]
["•","Main Contractor Preliminaries",null,{"$f":"BREAKDOWN!Z64","v":0}]
[]
["•","Escalation",null,{"$f":"BREAKDOWN!Z68+BREAKDOWN!Z69","v":{"$error":"#DIV/0!"}},{"$nulls":11},"ALL CHECKS TO BE = 0"]
[]
["•","Total value for fee purposes",null,{"$f":"D6+D8+D10","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"(D6+D8+D10)-D12","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
["•","Discount %",null,{"$f":"BREAKDOWN!Z73","v":{"v":0.45,"d":"45%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!Z75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D16>0,F16,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!Z75/100),0)","v":0},null,{"v":1,"d":"1 "},null,null,{"$f":"IF(D18>0,F18,0)","v":{"v":0,"d":"0 "}}]
[]
[]
[null,"Fee Category",null,{"$f":"IF(R55<2,\"\",\"ONLY SELECT ONE FEE CATEGORY\")","v":""}]
[]
[null,"Project Type",{"$nulls":9},"Fee Category"]
[null,"Engineering Services"]
[null,"Green building design and energy management",{"$nulls":9},"F"]
[null,"Communications, data and IT cabling systems",{"$nulls":9},"E"]
[null,"Energy generation and transmission",{"$nulls":9},"D"]
[null,"Fire protection, security and access control",null,null,"Use next tab",{"$nulls":6},"E"]
[null,"Industrial process, wiring and instrumentation",{"$nulls":9},"E"]
[null,"Mining",{"$nulls":9},"D"]
[null,"Motor control and electrical installations for machinery and equipment",{"$nulls":9},"E"]
[null,"MV and LV Distribution",{"$nulls":9},"C"]
[null,"Street, area and sportsfield lighting",{"$nulls":9},"D"]
[null,"Building Services"]
[null,"Industrial building services and utilities",{"$nulls":9},"E"]
[null,"General - Commercial, retail, offices, schools, hostels, clinics, hotels and resorts",{"$nulls":9},"E"]
[null,"Specialised - Airport buildings, museums, theaters, libraries, public entertainment, hospitals, research facilities, universities.",{"$nulls":9},"F"]
[null,"laboratories, conference facilities, institutional buildings and facilities"]
[null,"Residential - Individual luxury housing units and apartment buildings",{"$nulls":9},"F"]
[null,"Residential - Multiple (>50) standard housing units",{"$nulls":9},"C"]
[]
[]
[{"$nulls":15},"DO NOT DELETE"]
[]
[{"$nulls":16},false,{"$f":"-(Q45*-1)","v":0},{"$f":"IF(R45=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q46*-1)","v":0},{"$f":"IF(R46=1,2,0)","v":0}]
[{"$nulls":16},true,{"$f":"-(Q47*-1)","v":1},{"$f":"IF(R47=1,3,0)","v":3}]
[null,"Fee range for project categories",null,{"$f":"IF(R59<2,\"\",\"ONLY SELECT ONE FEE RANGE\")","v":""},{"$nulls":12},false,{"$f":"-(Q48*-1)","v":0},{"$f":"IF(R48=1,4,0)","v":0}]
[]
[]
[]
[{"$nulls":18},{"$f":"SUM(S45:S51)","v":3}]
[null,"Fee Calculation"]
[]
[null,"% at R10 mil value",{"v":0.12,"d":"12%"},{"$nulls":14},{"$f":"SUM(R45:R51)","v":1}]
[null,"% applicable to project",{"$f":"SUM(T61:T64)","v":{"$error":"#DIV/0!"}},{"$nulls":13},false,{"$f":"-(Q56*-1)","v":0},{"$f":"IF(R56=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q57*-1)","v":0},{"$f":"IF(R57=1,2,0)","v":0}]
[null,"Fee Category","Lower Limit","Upper Limit","Average",{"$nulls":4},"Values",{"$nulls":6},true,{"$f":"-(Q58*-1)","v":1},{"$f":"IF(R58=1,3,0)","v":3}]
[{"$nulls":9},"1 000 001 < 10 000 000",{"$nulls":7},{"$f":"SUM(R56:R58)","v":1},{"$f":"SUM(S56:S58)","v":3}]
[null,"A",{"v":0.06,"d":"6%"},{"v":0.08,"d":"8%"},{"$f":"AVERAGE(C60:D60)","v":{"v":0.07,"d":"7%"}},{"$nulls":4},{"v":0.06,"d":"6%"}]
[null,"B",{"v":0.07,"d":"7%"},{"v":0.09,"d":"9%"},{"v":0.08,"d":"8%"},{"$nulls":4},{"v":0.07,"d":"7%"},{"$nulls":5},"0 < 1 000 000",null,{"$f":"AND(0<$D$12,$D$12<=1000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R61*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S61=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"C",{"v":0.08,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.09,"d":"9%"},{"$nulls":4},{"v":0.08,"d":"8%"},{"$nulls":5},"1 000 001 < 10 000 000",null,{"$f":"AND(1000001<=$D$12,$D$12<=10000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R62*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S62=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"D",{"v":0.09,"d":"9%"},{"v":0.11,"d":"11%"},{"v":0.1,"d":"10%"},{"$nulls":4},{"v":0.09,"d":"9%"},{"$nulls":5},"10 000 001 < 100 000 000",null,{"$f":"AND(10000001<=$D$12,$D$12<=100000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R63*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S63=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"E",{"v":0.1,"d":"10%"},{"v":0.13,"d":"13%"},{"v":0.115,"d":"12%"},{"$nulls":4},{"v":0.1,"d":"10%"},{"$nulls":5},"100 000 001 < 1 000 000 000",null,{"$f":"AND(100000001<=$D$12,$D$12<=1000000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R64*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S64=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"F",{"v":0.11,"d":"11%"},{"v":0.14,"d":"14%"},{"v":0.125,"d":"13%"},{"$nulls":4},{"v":0.11,"d":"11%"}]
[null,"G",{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.135,"d":"14%"},{"$nulls":4},{"v":0.12,"d":"12%"}]
[]
[null,"Fee",null,{"$f":"ROUND(D12*C56,0)","v":{"$error":"#DIV/0!"}}]
[null,"Discount",null,{"$f":"ROUND(-$D$68*($D$14),0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D68:D69)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!T22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Electrical Engineer Fee",null,{"$f":"SUM(D70:D72)","v":{"$error":"#DIV/0!"}},"Excl Vat"]
[]
[]
[null,"Fee Stages "]
[]
[]
[null,"Stage 1","Inception",null,{"$f":"ROUND($D$74*K80%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[null,"Stage 2","Concept & Viability",null,{"$f":"ROUND($D$74*K81%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},15,"%"]
[null,"Stage 3","Design Development and",null,{"$f":"ROUND($D$74*K82%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},40,"%"]
[null,null,"Documentation & Procurement"]
[null,"Stage 4","Construction",null,{"$f":"ROUND($D$74*K84%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},35,"%"]
[null,"Stage 5","Close Out",null,{"$f":"ROUND($D$74*K85%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[{"$nulls":4},{"$f":"SUM(E80:E85)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K80:K85)","v":100},"%"]
[{"$nulls":15},{"$f":"+D74-E86","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[null,"Notes - See latest fee scales"]
["*","Guideline and scope of service, refer 3"]
["*","Processes for estimating fees, refer 4.1"]
["*","Time based fees, refer 4.2"]
["*","Fees for additional service, refer 4.4"]
["*","Value based fees, refer 4.5"]
["*","Expenses and Costs. Refer 4.6"]

{"sheet":"FIRE","index":21,"n_rows":95,"n_cols":20,"rows_kept":95,"hidden":true,"merged":[[0,0,0,13],[1,9,1,10],[5,4,5,11],[22,1,22,10],[22,11,22,12],[23,1,23,10],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[42,15,42,20],[47,1,47,2],[57,9,57,10],[57,11,57,12],[58,9,58,10],[58,11,58,12],[59,9,59,10],[59,11,59,12],[60,9,60,10],[60,11,60,12],[60,15,60,16],[61,9,61,10],[61,11,61,12],[61,15,61,16],[62,9,62,10],[62,11,62,12],[62,15,62,16],[63,9,63,10],[63,11,63,12],[63,15,63,16],[64,9,64,10],[64,11,64,12],[65,9,65,10],[65,11,65,12],[105,2,108,8]]}
[]
[null,{"$f":"+BREAKDOWN!AE19","v":"Fire Engineer"},{"$nulls":7},{"$f":"IF(AND($P$12=0,$P$87=0),\"\",\"ERROR ON SHEET\")","v":{"$error":"#DIV/0!"}},null,null,"Act 46 of 2000"]
[{"$nulls":12},"ECSA Guideline for Services and Process for estimating fees"]
[null,"Variables"]
[]
["•","Value for fee purposes",null,{"$f":"+BREAKDOWN!AF66","v":{"$error":"#DIV/0!"}}]
[]
["•","Main Contractor Preliminaries",null,{"$f":"BREAKDOWN!Z64","v":0}]
[]
["•","Escalation",null,{"$f":"BREAKDOWN!Z68+BREAKDOWN!Z69","v":{"$error":"#DIV/0!"}},{"$nulls":11},"ALL CHECKS TO BE = 0"]
[]
["•","Total value for fee purposes",null,{"$f":"D6+D8+D10","v":{"$error":"#DIV/0!"}},{"$nulls":11},{"$f":"(D6+D8+D10)-D12","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
["•","Discount %",null,{"$f":"BREAKDOWN!Z73","v":{"v":0.45,"d":"45%"}}]
[]
["•","Disbursement %",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!Z75/100),0)","v":{"v":0,"d":"0%"}},null,1,null,null,{"$f":"IF(D16>0,F16,0)","v":0}]
[null,null,"OR"]
["•","Disbursement value",null,{"$f":"IF(BREAKDOWN!$AR$77=1,(BREAKDOWN!Z75/100),0)","v":0},null,{"v":1,"d":"1 "},null,null,{"$f":"IF(D18>0,F18,0)","v":{"v":0,"d":"0 "}}]
[]
[]
[null,"Fee Category",null,{"$f":"IF(R55<2,\"\",\"ONLY SELECT ONE FEE CATEGORY\")","v":""}]
[]
[null,"Project Type",{"$nulls":9},"Fee Category"]
[null,"Engineering Services"]
[null,"Green building design and energy management",{"$nulls":9},"F"]
[null,"Communications, data and IT cabling systems",{"$nulls":9},"E"]
[null,"Energy generation and transmission",{"$nulls":9},"D"]
[null,"Fire protection, security and access control",null,null,"Use next tab",{"$nulls":6},"E"]
[null,"Industrial process, wiring and instrumentation",{"$nulls":9},"E"]
[null,"Mining",{"$nulls":9},"D"]
[null,"Motor control and electrical installations for machinery and equipment",{"$nulls":9},"E"]
[null,"MV and LV Distribution",{"$nulls":9},"C"]
[null,"Street, area and sportsfield lighting",{"$nulls":9},"D"]
[null,"Building Services"]
[null,"Industrial building services and utilities",{"$nulls":9},"E"]
[null,"General - Commercial, retail, offices, schools, hostels, clinics, hotels and resorts",{"$nulls":9},"E"]
[null,"Specialised - Airport buildings, museums, theaters, libraries, public entertainment, hospitals, research facilities, universities.",{"$nulls":9},"F"]
[null,"laboratories, conference facilities, institutional buildings and facilities"]
[null,"Residential - Individual luxury housing units and apartment buildings",{"$nulls":9},"F"]
[null,"Residential - Multiple (>50) standard housing units",{"$nulls":9},"C"]
[]
[]
[{"$nulls":15},"DO NOT DELETE"]
[]
[{"$nulls":16},false,{"$f":"-(Q45*-1)","v":0},{"$f":"IF(R45=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q46*-1)","v":0},{"$f":"IF(R46=1,2,0)","v":0}]
[{"$nulls":16},true,{"$f":"-(Q47*-1)","v":1},{"$f":"IF(R47=1,3,0)","v":3}]
[null,"Fee range for project categories",null,{"$f":"IF(R59<2,\"\",\"ONLY SELECT ONE FEE RANGE\")","v":""},{"$nulls":12},false,{"$f":"-(Q48*-1)","v":0},{"$f":"IF(R48=1,4,0)","v":0}]
[]
[]
[]
[{"$nulls":18},{"$f":"SUM(S45:S51)","v":3}]
[null,"Fee Calculation"]
[]
[null,"% at R10 mil value",{"v":0.12,"d":"12%"},{"$nulls":14},{"$f":"SUM(R45:R51)","v":1}]
[null,"% applicable to project",{"$f":"SUM(T61:T64)","v":{"$error":"#DIV/0!"}},{"$nulls":13},false,{"$f":"-(Q56*-1)","v":0},{"$f":"IF(R56=1,1,0)","v":0}]
[{"$nulls":16},false,{"$f":"-(Q57*-1)","v":0},{"$f":"IF(R57=1,2,0)","v":0}]
[null,"Fee Category","Lower Limit","Upper Limit","Average",{"$nulls":4},"Values",{"$nulls":6},true,{"$f":"-(Q58*-1)","v":1},{"$f":"IF(R58=1,3,0)","v":3}]
[{"$nulls":9},"1 000 001 < 10 000 000",{"$nulls":7},{"$f":"SUM(R56:R58)","v":1},{"$f":"SUM(S56:S58)","v":3}]
[null,"A",{"v":0.06,"d":"6%"},{"v":0.08,"d":"8%"},{"$f":"AVERAGE(C60:D60)","v":{"v":0.07,"d":"7%"}},{"$nulls":4},{"v":0.06,"d":"6%"}]
[null,"B",{"v":0.07,"d":"7%"},{"v":0.09,"d":"9%"},{"v":0.08,"d":"8%"},{"$nulls":4},{"v":0.07,"d":"7%"},{"$nulls":5},"0 < 1 000 000",null,{"$f":"AND(0<$D$12,$D$12<=1000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R61*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S61=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"C",{"v":0.08,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.09,"d":"9%"},{"$nulls":4},{"v":0.08,"d":"8%"},{"$nulls":5},"1 000 001 < 10 000 000",null,{"$f":"AND(1000001<=$D$12,$D$12<=10000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R62*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S62=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"D",{"v":0.09,"d":"9%"},{"v":0.11,"d":"11%"},{"v":0.1,"d":"10%"},{"$nulls":4},{"v":0.09,"d":"9%"},{"$nulls":5},"10 000 001 < 100 000 000",null,{"$f":"AND(10000001<=$D$12,$D$12<=100000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R63*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S63=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"E",{"v":0.1,"d":"10%"},{"v":0.13,"d":"13%"},{"v":0.115,"d":"12%"},{"$nulls":4},{"v":0.1,"d":"10%"},{"$nulls":5},"100 000 001 < 1 000 000 000",null,{"$f":"AND(100000001<=$D$12,$D$12<=1000000000)","v":{"$error":"#DIV/0!"}},{"$f":"-(R64*-1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(S64=1,MAX(0.04,-0.01*LN($D$12/1000000)+0.023+$C$55),0)","v":{"$error":"#DIV/0!"}}]
[null,"F",{"v":0.11,"d":"11%"},{"v":0.14,"d":"14%"},{"v":0.125,"d":"13%"},{"$nulls":4},{"v":0.11,"d":"11%"}]
[null,"G",{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.135,"d":"14%"},{"$nulls":4},{"v":0.12,"d":"12%"}]
[]
[null,"Fee",null,{"$f":"ROUND(D12*C56,0)","v":{"$error":"#DIV/0!"}}]
[null,"Discount",null,{"$f":"ROUND(-$D$68*($D$14),0)","v":{"$error":"#DIV/0!"}}]
[null,"Sub-total",null,{"$f":"SUM(D68:D69)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Disbursements",null,{"$f":"+'SUMMARY (2)'!V22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Electrical Engineer Fee",null,{"$f":"SUM(D70:D72)","v":{"$error":"#DIV/0!"}},"Excl Vat"]
[]
[]
[null,"Fee Stages "]
[]
[]
[null,"Stage 1","Inception",null,{"$f":"ROUND($D$74*K80%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[null,"Stage 2","Concept & Viability",null,{"$f":"ROUND($D$74*K81%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},15,"%"]
[null,"Stage 3","Design Development and",null,{"$f":"ROUND($D$74*K82%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},40,"%"]
[null,null,"Documentation & Procurement"]
[null,"Stage 4","Construction",null,{"$f":"ROUND($D$74*K84%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},35,"%"]
[null,"Stage 5","Close Out",null,{"$f":"ROUND($D$74*K85%,2)","v":{"$error":"#DIV/0!"}},{"$nulls":5},5,"%"]
[{"$nulls":4},{"$f":"SUM(E80:E85)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"SUM(K80:K85)","v":100},"%"]
[{"$nulls":15},{"$f":"+D74-E86","v":{"$error":"#DIV/0!"}},"CHECK"]
[]
[null,"Notes - See latest fee scales"]
["*","Guideline and scope of service, refer 3",{"$nulls":8},{"$f":"D74-E86","v":{"$error":"#DIV/0!"}}]
["*","Processes for estimating fees, refer 4.1"]
["*","Time based fees, refer 4.2"]
["*","Fees for additional service, refer 4.4"]
["*","Value based fees, refer 4.5"]
["*","Expenses and Costs. Refer 4.6"]