{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Cost Sheet","QS REPORT","calc. sheet","Rebar","Plates","Sheet3","Read Me FIRST","5.1 Tender Cover Sheet","5.1.1 Preambe","5.1.2 Price Schedule","Sheet4"],"not_rendered":{"images":1,"external_links":9,"defined_names":167,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Cost Sheet","index":0,"n_rows":57,"n_cols":7,"rows_kept":57,"hidden":true}
[]
[null,{"$f":"[8]QSRep!B7","v":"Package 04 - "}]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Description","Unit","Quantity","Rate","Contractor's ","Employer's"]
[{"$nulls":5},"Value","Value"]
[]
[null,"EARTHWORKS"]
[1,"Restricted excavation in all material","m³",{"v":1.9599999999999997,"d":"1.96"},{"v":244.64,"d":"R 244.64"},null,{"v":479.4943999999999,"d":"R 479.49"}]
[]
[]
[2,"Backfill insitu material to excavations","m³",{"v":0.9599999999999999,"d":"0.96"},{"v":284.76,"d":"R 284.76"},null,{"v":273.36959999999993,"d":"R 273.37"}]
[]
[]
[null,"UN-REINFORCED CONCRETE"]
[]
[3,"50mm blinding to bases cast against excavations","m²",{"v":1.9599999999999997,"d":"1.96"},{"v":168.27,"d":"R 168.27"},null,{"v":329.8092,"d":"R 329.81"}]
[]
[null,"REINFORCED CONCRETE"]
[]
[4,"35MPa /19mm  stone concrete to bases","m³",{"v":0.7839999999999999,"d":"0.78"},{"v":2426.92,"d":"R 2,426.92"},null,{"v":1902.70528,"d":"R 1,902.71"}]
[5,"35MPa /19mm  stone concrete to plinths","m³",0.54,{"v":2426.92,"d":"R 2,426.92"},null,{"v":1310.5368,"d":"R 1,310.54"}]
[]
[null,"SURFACE FINISHES"]
[]
[6,"Wood float finish","m²",{"v":1.9599999999999997,"d":"1.96"},{"v":63,"d":"R 63.00"},null,{"v":123.47999999999999,"d":"R 123.48"}]
[]
[]
[null,"FORMWORK"]
[7,"Formwork to sides of concrete plinth and bases","m²",5.84,{"v":394.78,"d":"R 394.78"},null,{"v":2305.5152,"d":"R 2,305.52"}]
[]
[null,"REINFORCEMENT"]
[]
[8,"All bars","ton",{"v":0.181,"d":"0.18"},{"v":18768.17,"d":"R 18,768.17"},null,{"$f":"E35*D35","v":{"v":3397.0387699999997,"d":"R 3,397.04"}}]
{"$rows_empty":11}
[null,"Sub Total",{"$nulls":3},{"$f":"SUM(F8:F46)","v":0},{"$f":"SUM(G8:G46)","v":{"v":10121.949249999998,"d":"R 10,121.95"}}]
[null,"Overhead 10%",{"$nulls":3},{"$f":"F47*0.1","v":0},{"$f":"G47*0.1","v":{"v":1012.1949249999998,"d":"R 1,012.19"}}]
[null,"Sub Total",{"$nulls":3},{"$f":"SUM(F47:F48)","v":0},{"$f":"SUM(G47:G48)","v":{"v":11134.144174999998,"d":"R 11,134.14"}}]
[null,"Contigencies 15%",{"$nulls":3},{"$f":"F49*0.15","v":0},{"$f":"G49*0.15","v":{"v":1670.1216262499995,"d":"R 1,670.12"}}]
[null,"Sub Total",{"$nulls":3},{"$f":"SUM(F49:F50)","v":0},{"$f":"SUM(G49:G50)","v":{"v":12804.265801249998,"d":"R 12,804.27"}}]
[null,"Profit 15%",{"$nulls":3},{"$f":"F51*0.15","v":0},{"$f":"G51*0.15","v":{"v":1920.6398701874996,"d":"R 1,920.64"}}]
[{"$nulls":5},{"$f":"SUM(F51:F52)","v":0},{"$f":"SUM(G51:G52)","v":{"v":14724.905671437496,"d":"R 14,724.91"}}]
[]
[null,"TOTAL ASSESSED COST  (EXCLUDING VAT)",{"$nulls":3},{"$f":"F53","v":0},{"$f":"G53","v":{"v":14724.905671437496,"d":"R 14,724.91"}}]
[]
[{"$nulls":5},"Page 2 of 2"]

{"sheet":"QS REPORT","index":1,"n_rows":56,"n_cols":8,"rows_kept":56,"hidden":true,"merged":[[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[7,0,7,1]]}
["MEDUPI POWER STATION PROJECT"]
["P06 - WTP TANK FARM PIPE RACK"]
["PROJECT CHANGE REQUEST: P06 - PCR ???????????"]
["CONTRACT NO:"]
["ORIGINATOR: N. Mashangu"]
["DESCRIPTION: Plinth Point 49"]
[]
["Request:"]
[]
[]
["Item No.","Description","Unit","Quantity","Contractor's Rate","Contractor's Quotation","Engr's rep assessed rates","Engr's rep estimated amounts"]
[]
[null,"EARTHWORKS"]
[1,"Restricted excavation in all material","m³",{"$f":"'calc. sheet'!G20","v":{"v":1.9599999999999997,"d":"1.96"}},null,null,{"v":244.64,"d":"R 244.64"},{"$f":"G14*D14","v":{"v":479.4943999999999,"d":"R 479.49"}}]
[]
[]
[2,"Backfill insitu material to excavations","m³",{"$f":"'calc. sheet'!R20","v":{"v":0.9599999999999999,"d":"0.96"}},null,null,{"v":284.76,"d":"R 284.76"},{"$f":"G17*D17","v":{"v":273.36959999999993,"d":"R 273.37"}}]
[]
[]
[null,"UN-REINFORCED CONCRETE"]
[]
[3,"50mm blinding to bases cast against excavations","m²",{"$f":"'calc. sheet'!L20","v":{"v":1.9599999999999997,"d":"1.96"}},null,null,{"v":168.27,"d":"R 168.27"},{"$f":"G22*D22","v":{"v":329.8092,"d":"R 329.81"}}]
[]
[null,"REINFORCED CONCRETE"]
[]
[4,"35MPa /19mm  stone concrete to bases","m³",{"$f":"'calc. sheet'!J20","v":{"v":0.7839999999999999,"d":"0.78"}},null,null,{"v":2426.92,"d":"R 2,426.92"},{"$f":"G26*D26","v":{"v":1902.70528,"d":"R 1,902.71"}}]
[5,"35MPa /19mm  stone concrete to plinths","m³",{"$f":"'calc. sheet'!G36","v":0.54},null,null,{"v":2426.92,"d":"R 2,426.92"},{"$f":"G27*D27","v":{"v":1310.5368,"d":"R 1,310.54"}}]
[]
[null,"SURFACE FINISHES"]
[]
[6,"Wood float finish","m²",{"$f":"D22","v":{"v":1.9599999999999997,"d":"1.96"}},null,null,{"v":63,"d":"R 63.00"},{"$f":"G31*D31","v":{"v":123.47999999999999,"d":"R 123.48"}}]
[]
[]
[null,"FORMWORK"]
[7,"Formwork to sides of concrete plinth and bases","m²",{"$f":"'calc. sheet'!I36+'calc. sheet'!N6","v":5.84},null,null,{"v":394.78,"d":"R 394.78"},{"$f":"G35*D35","v":{"v":2305.5152,"d":"R 2,305.52"}}]
[]
[null,"REINFORCEMENT"]
[]
[8,"All bars","ton",{"$f":"SUM(D26:D27)*0.1","v":{"v":0.1324,"d":"0.13"}},null,null,{"v":18768.17,"d":"R 18,768.17"},{"$f":"G39*D39","v":{"v":2484.905708,"d":"R 2,484.91"}}]
[]
[null,"STEEL WORK"]
[]
[9,"200 x 12mm cast in plate galvanised with 100 x 50 x 5mm fishtail lugs","kg",{"$nulls":3},{"v":50.2,"d":"50.20"},{"$f":"G43*D43","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[10,"100 x 12mm cast in plate galvanised with 100 x 50 x 5mm fishtail lugs","kg",{"$nulls":3},{"v":50.2,"d":"50.20"},{"$f":"G46*D46","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,"Sub Total",{"$nulls":3},{"$f":"SUM(F14:F39)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"SUM(H14:H48)","v":{"v":9209.816187999999,"d":"R 9,209.82"}}]
[]
[null,null,"Item"]
[]
[null,"TOTAL ESTIMATED COST (EXCL VAT)",null,"R",null,{"$f":"F49","v":{"v":0,"d":"R 0.00"}},null,{"$f":"SUM(H49:H51)","v":{"v":9209.816187999999,"d":"R 9,209.82"}}]
[]
[]
["Note:","Base date for the rates used is Aug 2008 for Medupi LP Services"]

{"sheet":"calc. sheet","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"hidden":true,"merged":[[3,15,3,16]]}
["BASES"]
[{"$nulls":5},"Excv. For bases",null,null,"Conc. To bases",null,null,"Blinding ",null,"Fmwk to bases",null,"Backfill"]
[]
["Item","Ref","no.","L","B","H","m3",null,"thk","m3",null,"m2",null,"m2",null,"Plinths",null,"m3"]
[]
[1,1,1,1.4,1.4,1,{"$f":"F6*E6*D6","v":1.9599999999999997},null,0.4,{"$f":"D6*E6*I6","v":0.7839999999999999},null,{"$f":"D6*E6","v":1.9599999999999997},null,{"$f":"D6*4*0.4","v":2.2399999999999998},null,{"$f":"D28*E28*0.6","v":0.216},null,{"$f":"G6-P6-J6","v":0.9599999999999999}]
{"$rows_empty":13}
[{"$nulls":5},"TOTAL",{"$f":"SUM(G6:G18)","v":1.9599999999999997},null,null,{"$f":"SUM(J6:J18)","v":0.7839999999999999},null,{"$f":"SUM(L6:L18)","v":1.9599999999999997},null,{"$f":"SUM(N6:N18)","v":2.2399999999999998},{"$nulls":3},{"$f":"SUM(R6:R18)","v":0.9599999999999999}]
[]
[]
[]
["PLINTHS"]
[{"$nulls":5},"Conc. To Plinths",null,null,"Fmwk to Plinths"]
[]
["Item","Ref","no.","L","B","H","m3",null,"m2"]
[null,null,1,0.6,0.6,1.5,{"$f":"C28*D28*E28*F28","v":0.54},null,{"$f":"(D28*2+E28*2)*F28*C28","v":3.5999999999999996}]
[{"$nulls":6},{"$f":"C29*D29*E29*F29","v":0},null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G28:G35)","v":0.54},null,{"$f":"SUM(I28:I35)","v":3.5999999999999996}]

{"sheet":"Rebar","index":3,"n_rows":241,"n_cols":22,"rows_kept":241,"hidden":true}
["DWG","REV","TYPE","LENGTH","NO.","  FACTOR","RESULT","REMARKS","DIN NO","D/NOTE","NO.","D/NOTE","NO.","D/NOTE","NO.","D/NOTE","NO.","TOTAL","LENGTH","  FACTOR","RESULT","VAR. "]
[{"$nulls":5},{"$f":"IF(C2=\"R8\",0.000395)+IF(C2=\"R10\",0.000617)+IF(C2=\"R12\",0.000888)+IF(C2=\"Y10\",0.000617)+IF(C2=\"Y12\",0.000888)+IF(C2=\"Y16\",0.00158)+IF(C2=\"Y20\",0.00247)+IF(C2=\"Y25\",0.00385)+IF(C2=\"Y32\",0.00631)+IF(C2=\"Y40\",0.00986)","v":0},{"$f":"ROUND(D2*E2*T2,3)","v":0},"BM 01",1390,"GER09-41",144,{"$nulls":6},{"$f":"SUM(K2,M2,O2,Q2)","v":144},{"$f":"D2","v":{"v":0,"d":"0.000"}},{"$f":"IF(C2=\"R8\",0.000395)+IF(C2=\"R10\",0.000617)+IF(C2=\"R12\",0.000888)+IF(C2=\"Y10\",0.000617)+IF(C2=\"Y12\",0.000888)+IF(C2=\"Y16\",0.00158)+IF(C2=\"Y20\",0.00247)+IF(C2=\"Y25\",0.00385)+IF(C2=\"Y32\",0.00631)+IF(C2=\"Y40\",0.00986)","v":0},{"$f":"ROUND(R2*S2*T2,3)","v":0},{"$f":"G2-U2","v":0}]
[null,null,"Y16",{"v":2.2,"d":"2.200"},8,1.58E-3,0.028,"BM 02",1390,"GER09-41",69,{"$nulls":6},69,{"v":2.2,"d":"2.200"},1.58E-3,0.24,-0.212]
[null,null,"Y16",{"v":1.55,"d":"1.550"},16,1.58E-3,0.039,"BM 03",1390,"GER09-41",147,{"$nulls":6},147,{"v":1.55,"d":"1.550"},1.58E-3,0.36,-0.321]
[null,null,"Y16",{"v":2.1,"d":"2.100"},8,1.58E-3,0.027,"BM 04",1390,"GER09-41",15,{"$nulls":6},15,{"v":2.1,"d":"2.100"},1.58E-3,0.05,-0.023000000000000003]
[null,null,"r8",{"v":1.3,"d":"1.300"},2,0.000395,1E-3,"BM 05",1390,"GER09-41",15,{"$nulls":6},15,{"v":1.3,"d":"1.300"},0.000395,0.008,-0.007]
[null,null,"Y16",{"v":2,"d":"2.000"},16,1.58E-3,0.051,"BM 06",1390,"GER09-41",15,{"$nulls":6},15,{"v":2,"d":"2.000"},1.58E-3,0.047,0.003999999999999997]
[null,null,"r8",{"v":2.2,"d":"2.200"},10,0.000395,0.009,"BM 07",1390,"GER09-41",6,{"$nulls":6},6,{"v":2.2,"d":"2.200"},0.000395,0.005,0.003999999999999999]
[null,null,"r8",{"v":1.15,"d":"1.150"},20,0.000395,0.009,"BM 09",1390,"GER09-41",10,{"$nulls":6},10,{"v":1.15,"d":"1.150"},0.000395,0.005,0.003999999999999999]
[null,null,"Y16",{"v":1.1,"d":"1.100"},10,1.58E-3,0.017,"BM 12",1390,"GER09-41",3,{"$nulls":6},3,{"v":1.1,"d":"1.100"},1.58E-3,0.005,0.012]
[{"$nulls":5},0,0,"BM 13",1390,"GER09-41",11,{"$nulls":6},11,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 14",1390,"GER09-41",16,{"$nulls":6},16,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 15",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 16",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 17",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 18",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 19",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 20",1390,"GER09-41",2,{"$nulls":6},2,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 21",1390,"GER09-41",14,{"$nulls":6},14,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 22",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 23",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 24",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 25",1390,"GER09-41",8,{"$nulls":6},8,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 30",1390,"GER09-41",6,{"$nulls":6},6,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 31",1390,"GER09-41",6,{"$nulls":6},6,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 32",1390,"GER09-41",12,{"$nulls":6},12,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,"BM 33",1390,"GER09-41",{"$nulls":7},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},{"$f":"IF(C66=\"R8\",0.000395)+IF(C66=\"R10\",0.000617)+IF(C66=\"R12\",0.000888)+IF(C66=\"Y10\",0.000617)+IF(C66=\"Y12\",0.000888)+IF(C66=\"Y16\",0.00158)+IF(C66=\"Y20\",0.00247)+IF(C66=\"Y25\",0.00385)+IF(C66=\"Y32\",0.00631)+IF(C66=\"Y40\",0.00986)","v":0},{"$f":"ROUND(D66*E66*T66,3)","v":0},{"$nulls":10},{"$f":"SUM(K66,M66,O66,Q66)","v":0},{"$f":"D66","v":{"v":0,"d":"0.000"}},{"$f":"IF(C66=\"R8\",0.000395)+IF(C66=\"R10\",0.000617)+IF(C66=\"R12\",0.000888)+IF(C66=\"Y10\",0.000617)+IF(C66=\"Y12\",0.000888)+IF(C66=\"Y16\",0.00158)+IF(C66=\"Y20\",0.00247)+IF(C66=\"Y25\",0.00385)+IF(C66=\"Y32\",0.00631)+IF(C66=\"Y40\",0.00986)","v":0},{"$f":"ROUND(R66*S66*T66,3)","v":0},{"$f":"G66-U66","v":0}]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":5},0,0,{"$nulls":10},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},{"$f":"SUM(K130,M130,O130,Q130)","v":0},{"$f":"D130","v":{"v":0,"d":"0.000"}},{"$f":"IF(C130=\"R8\",0.000395)+IF(C130=\"R10\",0.000617)+IF(C130=\"R12\",0.000888)+IF(C130=\"Y10\",0.000617)+IF(C130=\"Y12\",0.000888)+IF(C130=\"Y16\",0.00158)+IF(C130=\"Y20\",0.00247)+IF(C130=\"Y25\",0.00385)+IF(C130=\"Y32\",0.00631)+IF(C130=\"Y40\",0.00986)","v":0},{"$f":"ROUND(R130*S130*T130,3)","v":0},{"$f":"G130-U130","v":0}]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},{"$f":"SUM(K194,M194,O194,Q194)","v":0},{"$f":"D194","v":{"v":0,"d":"0.000"}},{"$f":"IF(C194=\"R8\",0.000395)+IF(C194=\"R10\",0.000617)+IF(C194=\"R12\",0.000888)+IF(C194=\"Y10\",0.000617)+IF(C194=\"Y12\",0.000888)+IF(C194=\"Y16\",0.00158)+IF(C194=\"Y20\",0.00247)+IF(C194=\"Y25\",0.00385)+IF(C194=\"Y32\",0.00631)+IF(C194=\"Y40\",0.00986)","v":0},{"$f":"ROUND(R194*S194*T194,3)","v":0},{"$f":"G194-U194","v":0}]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]
[{"$nulls":17},0,{"v":0,"d":"0.000"},0,0,0]

{"sheet":"Plates","index":4,"n_rows":161,"n_cols":35,"rows_kept":161,"hidden":true,"merged":[[0,2,0,6],[0,7,0,10],[0,11,0,15]]}
["REV","REF","PLATES",{"$nulls":4},"LUGS",{"$nulls":3},"ANCHOR PLATES",{"$nulls":4},"RESULT","D/NOTE","NO.","D/NOTE","NO.","D/NOTE","NO.","D/NOTE","NO.","TOTAL","VAR. ",null,"invoice",{"$nulls":3},"SI","MEMO","CVI"]
[null,null,"NO","DIM A","DIM B","DIM C","FACTOR","NO","TYPE","LENGTH","  FACTOR","NO","DIM A","DIM B","DIM C","FACTOR"]
[{"$nulls":6},7850,{"$nulls":3},{"$f":"IF($I3=\"M10\",0.617,0)+IF($I3=\"M16\",1.579,0)+IF($I3=\"M20\",2.467,0)+IF($I3=\"M24\",3.553,0)+IF($I3=\"M30\",5.551,0)+IF($I3=\"M36\",7.994,0)+IF($I3=\"M42\",10.88,0)","v":0},{"$nulls":4},7850,{"$f":"ROUND(C3*D3*E3*F3*G3+C3*H3*J3*K3+L3*M3*N3*O3*P3,3)","v":0},{"$nulls":8},{"$f":"S3+U3+W3+Y3","v":0},{"$f":"Q3-Z3","v":0}]
[null,"P 1 & P2- DET G1",2,0.73,0.1,0.01,7850,{"$nulls":3},0,{"$f":"5*2","v":10},0.15,0.05,0.005,7850,{"$f":"ROUND(C4*D4*E4*F4*G4+C4*H4*J4*K4+L4*M4*N4*O4*P4,3)","v":14.405}]
[null,"P3, 4 & 5-DET G2",{"$f":"1*3","v":3},0.73,0.1,0.01,7850,{"$nulls":3},0,{"$f":"5*3","v":15},0.15,0.05,0.005,7850,{"$f":"ROUND(C5*D5*E5*F5*G5+C5*H5*J5*K5+L5*M5*N5*O5*P5,3)","v":21.607}]
[{"$nulls":16},{"$f":"SUM(Q3:Q5)","v":36.012}]
[]
[]
[null,"P3, 4 & 5-DET G2",{"$f":"2*3","v":6},0.73,0.2,0.012,7850,{"$nulls":3},0,{"$f":"5*6","v":30},0.15,0.05,0.005,7850,{"$f":"ROUND(C9*D9*E9*F9*G9+C9*H9*J9*K9+L9*M9*N9*O9*P9,3)","v":91.35},{"$nulls":8},0,91.35]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C10*D10*E10*F10*G10+C10*H10*J10*K10+L10*M10*N10*O10*P10,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C36*D36*E36*F36*G36+C36*H36*J36*K36+L36*M36*N36*O36*P36,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C37*D37*E37*F37*G37+C37*L37*M37*N37*O37*P37,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C38*D38*E38*F38*G38+C38*H38*J38*K38+L38*M38*N38*O38*P38,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C39*D39*E39*F39*G39+C39*H39*J39*K39+L39*M39*N39*O39*P39,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C40*D40*E40*F40*G40+C40*H40*J40*K40+L40*M40*N40*O40*P40,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C41*D41*E41*F41*G41+C41*L41*M41*N41*O41*P41,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C42*D42*E42*F42*G42+C42*H42*J42*K42+L42*M42*N42*O42*P42,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C43*D43*E43*F43*G43+C43*H43*J43*K43+L43*M43*N43*O43*P43,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C44*D44*E44*F44*G44+C44*H44*J44*K44+L44*M44*N44*O44*P44,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C45*D45*E45*F45*G45+C45*L45*M45*N45*O45*P45,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C46*D46*E46*F46*G46+C46*H46*J46*K46+L46*M46*N46*O46*P46,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C47*D47*E47*F47*G47+C47*H47*J47*K47+L47*M47*N47*O47*P47,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C48*D48*E48*F48*G48+C48*H48*J48*K48+L48*M48*N48*O48*P48,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C49*D49*E49*F49*G49+C49*L49*M49*N49*O49*P49,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C50*D50*E50*F50*G50+C50*H50*J50*K50+L50*M50*N50*O50*P50,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C51*D51*E51*F51*G51+C51*H51*J51*K51+L51*M51*N51*O51*P51,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C52*D52*E52*F52*G52+C52*H52*J52*K52+L52*M52*N52*O52*P52,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C53*D53*E53*F53*G53+C53*L53*M53*N53*O53*P53,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C54*D54*E54*F54*G54+C54*H54*J54*K54+L54*M54*N54*O54*P54,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C55*D55*E55*F55*G55+C55*H55*J55*K55+L55*M55*N55*O55*P55,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C56*D56*E56*F56*G56+C56*H56*J56*K56,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},{"$f":"IF($I67=\"M10\",0.617,0)+IF($I67=\"M16\",1.579,0)+IF($I67=\"M20\",2.467,0)+IF($I67=\"M24\",3.553,0)+IF($I67=\"M30\",5.551,0)+IF($I67=\"M36\",7.994,0)+IF($I67=\"M42\",10.88,0)","v":0},{"$nulls":4},7850,0,{"$nulls":8},{"$f":"S67+U67+W67+Y67","v":0},{"$f":"Q67-Z67","v":0}]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},{"$f":"IF($I107=\"M10\",0.617,0)+IF($I107=\"M12\",0.888,0)+IF($I107=\"M16\",1.579,0)+IF($I107=\"M20\",2.467,0)+IF($I107=\"M24\",3.553,0)+IF($I107=\"M30\",5.551,0)+IF($I107=\"M36\",7.994,0)+IF($I107=\"M42\",10.88,0)","v":0},{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,{"$f":"ROUND(C120*D120*E120*F120*G120+C120*H120*J120*K120,3)","v":0},{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},{"$f":"S131+U131+W131+Y131","v":0},{"$f":"Q131-Z131","v":0}]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},0,{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":6},7850,{"$nulls":3},{"$f":"IF($I147=\"M16\",1.579,0)+IF($I147=\"M20\",2.467,0)+IF($I147=\"M24\",3.553,0)+IF($I147=\"M30\",5.551,0)+IF($I147=\"M36\",7.994,0)+IF($I147=\"M42\",10.88,0)","v":0},{"$nulls":4},7850,0,{"$nulls":8},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":17},"                   ",{"$nulls":7},0,0]
[{"$nulls":9},"                                                                                ",{"$nulls":15},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]

{"sheet":"Sheet3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Read Me FIRST","index":6,"n_rows":27,"n_cols":3,"rows_kept":27,"merged":[[8,1,8,2],[10,1,10,2],[12,1,12,2],[24,1,24,2]]}
["Project:",null,"KUSILE POWER STATION PROJECT"]
["Enquiry No.",null,0]
["Package Name:",null,{"$f":"'[9]5.1Tender Cover Sheet'!C21","v":"Procurement/Servicing of the Nitrogen plant spares and equipment "}]
["Tenderer's Name:"]
[]
[]
["READ ME"]
[]
[null,"Read these notes BEFORE you commence input or make any changes to this workbook"]
[]
[null,"The Tenderer must provide a clear indication on the Cover Sheet as to whether the offer is \"main\" or \"alternative\" (and if there are several alternatives, to number them). There must be a separate Excel file for each offer if applicable"]
[]
[null,"NOTE:  ALL CALCULATIONS ARE THE RESPONSIBILITY OF THE TENDERER, AND MUST BE CHECKED THOROUGHLY.  ANY DISCREPANCY FOUND IN THE CALCULATIONS IN THIS WORKBOOK MUST BE BROUGHT TO THE ATTENTION OF ESKOM, THROUGH THE DEIGNATED BUYER!"]
[]
[]
[1,"This workbook contains the following sheets:"]
[null,"Read Me","This sheet provides an overview to the Tenderer of the content and role of the sheets making up the Price Schedules.  It will not form part of the tender or contract."]
[null,"5.1 Tender Cover Sheet","This is the cover sheet for Section 5.1 and provides the total tender price.  It is also the source of the package name, tenderer name etc for the other sheets."]
[null,"5.1.1 Preamble","This sheet provides general guidelines for this section."]
[null,"5.1.2 Price Schedule","This is where the total amounts of all the trades are shown"]
[]
[]
[]
[2,"Conventions used in this workbook"]
[null,"The following conventions have been used in this workbook to facilitate its accurate use:"]
[null,"Red","This GREEN shading is used for cells where DATA ENTRY is required from the Tenderer.  The Tenderer must complete the information in these GREEN shaded cells."]
[null,null,"PLEASE REFRAIN from tampering with ANY other cells contained in this workbook as it may affect Eskom's standard formulae and lead to data integrity issues."]

{"sheet":"5.1 Tender Cover Sheet","index":7,"n_rows":49,"n_cols":4,"rows_kept":49,"merged":[[1,1,1,2]]}
[]
[null,"KUSILE POWER STATION PROJECT"]
{"$rows_empty":12}
[null,"PRICING INFORMATION"]
[]
[null,"TENDER INFORMATION"]
[]
[null,"ENQUIRY No."]
[]
[null,"NAME OF PACKAGE:","Procurement/Servicing of the Nitrogen plant spares and equipment "]
[]
[null,"TENDERER’S NAME:  "]
[]
[]
[null,"Annexure IT 5.1 Price Schedules "]
[]
[]
[null,"THE PRICE:  IN ZAR",{"$f":"'5.1.2 Price Schedule'!G33","v":{"v":0,"d":"  0  RAND"}}]
[null,"(excluding VAT)"]
[null,"RAND VALUE IN WORDS"]
[]
[]
[]
[]
[null,"DATE :"]
[]
[]
[]
[null,"FULL NAMES OF SIGNATORY:"]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"]
[]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":"5.1.1 Preambe","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
["Project:",null,"KUSILE POWER STATION PROJECT"]
["Enquiry No.",null,0]
["Package Name:",null,{"$f":"'[9]5.1Tender Cover Sheet'!C21","v":"Procurement/Servicing of the Nitrogen plant spares and equipment "}]
["Tenderer's Name:"]
[]
["5.1.1.1 PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The Provisional Price Schedule provides the basis of valuation of all the work activities and inputs and information for general contract progress monitoring. "]
[2,"The amount due at each application for payment date is based on activities and/or milestones completed as indicated on the Price Schedule/Bills of Quantities. The Tenderer must provide all necessary information which is required to determine amounts due in respect of each application for payment relative to the activities."]
[3,"The total of the prices must include for all direct and indirect costs, overheads, profits, on costs, risks, liabilities, obligations, etc. relative to the contract."]
[4,"Pricing by the Contractor  to be done in conjunction with the scope of work document, specification, etc."]

{"sheet":"5.1.2 Price Schedule","index":9,"n_rows":46,"n_cols":9,"rows_kept":46,"merged":[[0,1,0,6]]}
[]
[]
[null,"Item",null,"Unit of Measure ","Number Off","Cost Per Item","Amount"]
[]
[null,1,"Calibration/refurbishment i.e. removal, installation, commissioning and calibration of Dew Point probe","Each",1,null,{"$f":"E5*F5","v":0},null," "]
[null,2,"Supply install, commission and calibrate of PANAMETRICS GAS OX-5 STD PPM SENSOR, 0 TO 100 AND 1000 PPM","Each",2,null,{"$f":"E6*F6","v":0}]
[null,3,"Supply, install, commission and calibrate of Panametrics Gas XMTC-62-22-11-XMTC-CAL-A-1 (H2 In N2, 98-100%) in HyStat B","Each",1,null,0]
[null,4,"Supply , install, commission and calibrate of new MICHEL TRANSMET I.S. Dew point probe","Each",2,null,0]
[null,5,"Calibration/verification of XMTC required for HyStat A and metering panel","Each",2,null,0]
[null,6,"Supply of  8m ½” stainless steel braided flexible hoses with cable reinforcing across the two ends, fitted with nitrogen regulators from rated 1,5 time max nitrogen MCP operating pressure and quick connector coupling to cennect to nitrogen panel.","Each",2,null,0]
[null,7,"Supply of  8m ½” stainless steel braided flexible hoses with cable reinforcing across the two ends, fitted with hydrogen regulators from 20MPa hydrogen supply pressure with ¼” valve and quick connector for nitrogen purging.  Flexible hose end to be fitted with quick connector nipple to connect to Hydrogen MCP panel. Pressure rating 30MPa","Each",2,null,0]
[null,8,"Supply, install, commission chiller 3-way valve actuator Siemens SAX61.03","Each",1,null,0]
[null,9,"Supply H3 Data Books ","Sum",1,null,0]
[null,10,"Supply CF Memory Cards to download and Back up Siemens Program SIMATIC S7, Micro Memory Card 2MB(6ES7953-8LL31-0AA0)   TRANSCEND CF180 4 GB, Industrial Grade ","Each",2,null,0]
[null,11,"Supply and install hydrogen vent stainless steel tube on the safety valve vent, venting 2m above the roof","Sum",1,null,0]
[null,12,"Supply, install and commission (leakage check) receiver flexible connections (inlet and outlet) with stainless steel braided reinforced flexible hoses rated 4,5MPa, 3/4\".","Sum",8,null,0]
[null,13,"Supply, upload and commission of Hystst A program update: 1. to cater for a 4-20mA signal from the metering PLC to meet the receiver filling philosophy. 2. include XMTC H2 in Air settings on the HMI. Hystat A and B","Sum",1,null,0]
[null,14,"Supply, install and commission:\n1.Three (3) DP-DP Couplers in each Hydrostat and Metering Station Panels to allow the communication between the three PLCs and the Employer’s Distributed Control System (ABB 800xA)\n2.Profibus cabling between the Hydrostat PLCs and the Metering panel PLC.\n3.The Contractor shall update the PLC software program in each of the Panels and the Virtual Signal List to be free issued to the Employers C&I Contractor for configuration and mapping of signals transfer between the Hydrogen Plant PLCs to the DCS.","Sum",1,null,{"$f":"E18*F18","v":0}]
[null,15,"Supply, Install and commission of a permanent potable water 10.0m x 25NB Threaded galvanised SANS62-1 piping to the chiller cooling water system together with an isolation valve and water pressure regulator set at 220kPa","Sum",1,null,0]
[null,16,"Supply, install and commission of KROHNE variable area flowmeter for Hystat B ","Sum",1,null,0]
[null,17,"Removal and installation and commissioning of hydrogen leak detector, to be relocated inside the hystat for effective leak detection functionality. ","Sum",2,null,0]
[null,18,"Commissioning of metering panel i.e. leakage test and full functionality test including receiver filling.","Sum",1,null,0]
[null,19,"Perform leakage test on entire plant, HySTAT A &B, 4 x bulk storage and piping.","Sum",1,null,0]
[null,20,"Hydrogen connection repair","Each",25,null,{"$f":"E24*F24","v":0}]
[null,21,"Bulk storage hydrogen vessel 24Nm3 purge (Labour) ","Each",4,null,0]
[null,22,"Nitrogen supply for bulk storage purge, pressurisation to 2,7MPa and 12 hour pressure decay test <0.5%, and vessel isolated at 510kPa. Nitrogen pressure.","Each",4,null,0]
[null,23,"Nitrogen supply for hydrogen production plant commissioning","Each",1,null,0]
[null,24,"Labour - technician","Day",3,null,0]
[null,25,"Labour - artisans","Day",3,null,0]
[null,26,"Travelling","Day",3,null,0]
[null,27,"Remove, calibrate (with gaseous meduim) and reinstall safety valve","Each",20,null,0," "]
[]
[{"$nulls":6},{"$f":"SUM(G5:G31)","v":0}]
[]
[]
[]
[{"$nulls":6}," "]
[null,null," "]
[]
[{"$nulls":6}," "]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"Sheet4","index":10,"n_rows":164,"n_cols":6,"rows_kept":164,"hidden":true}
["Ovivo Aqua Africa - Schedule of Costs"]
["Sub Clause 13.3 - Request for Variation Proposal"]
["2016-11-30"]
["Supply of Water Treatment Plant Membranes"]
["Reference: PBP-AQE-P06-2148"]
["Rev 0"]
["Item","Description","Number","Rate Per","Rand Cost","6% Overhead"]
[]
[]
[]
[]
[]
["Sub Total"]
["% Profit"]
["Total Sell"]
["Total"]
["Hours"]
["Hour"]
["Overhead"]
["Cost"]
["Profit"]
[1]
["Engineering Costs"]
[1.1]
["Mechanical/Structural Engineer"]
["Mechanical Engineering Costs"]
[{"v":570,"d":"R 570.00"}]
[0]
[0]
[0]
[{"v":0.15,"d":"15%"}]
[0]
[0]
[1.2]
["Project Management"]
[4]
[{"v":675,"d":"R 675.00"}]
[{"v":2700,"d":"2,700.00"}]
[162]
[{"v":2862,"d":"2,862.00"}]
[{"v":0.15,"d":"15%"}]
[{"v":3291.3,"d":"3,291.30"}]
[429.3]
[1.3]
["Purchasing and Finance"]
["Procurement"]
[4]
[{"v":275,"d":"R 275.00"}]
[{"v":1100,"d":"1,100.00"}]
[66]
[{"v":1166,"d":"1,166.00"}]
[{"v":0.15,"d":"15%"}]
[{"v":1340.9,"d":"1,340.90"}]
[174.9]
["Project Finance"]
[2]
[{"v":355,"d":"R 355.00"}]
[710]
[42.6]
[752.6]
[{"v":0.15,"d":"15%"}]
[865.49]
[112.89]
[1.4]
["Drawing Office"]
[{"v":475,"d":"R 475.00"}]
[0]
[0]
[0]
[{"v":0.15,"d":"15%"}]
[0]
[0]
[1.5]
["QA/QC"]
["Site"]
[8]
[{"v":575,"d":"R 575.00"}]
[{"v":4600,"d":"4,600.00"}]
[276]
[{"v":4876,"d":"4,876.00"}]
[{"v":0.15,"d":"15%"}]
[{"v":5607.4,"d":"5,607.40"}]
[731.4]
["Total Section 1"]
[{"v":9656.6,"d":"9,656.60"}]
[{"v":11105.09,"d":"11,105.09"}]
[{"v":1448.49,"d":"1,448.49"}]
["Item"]
["Description"]
["Number"]
["Cost Per"]
["Rand Cost"]
[{"v":0.06,"d":"6%"}]
["Total Cost"]
["% Profit"]
["Total Sell"]
["Total"]
["Off"]
["Item"]
["Overhead"]
["Profit"]
[2]
["Material and Labour"]
[2.1]
["Supply"]
["2.1.1"]
["UF Membranes (ROCH Pentair Xiga 40)"]
[240]
[{"v":23000,"d":"R 23,000.00"}]
[{"v":5520000,"d":"5,520,000.00"}]
[{"v":331200,"d":"331,200.00"}]
[{"v":5851200,"d":"5,851,200.00"}]
[{"v":0.15,"d":"15%"}]
[{"v":6728880,"d":"6,728,880.00"}]
[{"v":877680,"d":"877,680.00"}]
["2.1.2"]
["RO Membranes ( DOW BW30XFR-400/34 i)"]
[826]
[{"v":6956,"d":"R 6,956.00"}]
[{"v":5745656,"d":"5,745,656.00"}]
[{"v":344739.36,"d":"344,739.36"}]
[{"v":6090395.36,"d":"6,090,395.36"}]
[{"v":0.15,"d":"15%"}]
[{"v":7003954.66,"d":"7,003,954.66"}]
[{"v":913559.3,"d":"913,559.30"}]
["2.1.3"]
["GTM Membranes (Memcon 14 x 28\" Liqui-Cel)"]
[15]
[{"v":189148,"d":"R 189,148.00"}]
[{"v":2837220,"d":"2,837,220.00"}]
[{"v":170233.2,"d":"170,233.20"}]
[{"v":3007453.2,"d":"3,007,453.20"}]
[{"v":0.15,"d":"15%"}]
[{"v":3458571.18,"d":"3,458,571.18"}]
[{"v":451117.98,"d":"451,117.98"}]
["2.1.4"]
["CEDI Module (Evoqua IP-VNX55E-2)"]
[8]
[{"v":233280,"d":"R 233,280.00"}]
[{"v":1866240,"d":"1,866,240.00"}]
[{"v":111974.4,"d":"111,974.40"}]
[{"v":1978214.4,"d":"1,978,214.40"}]
[{"v":0.15,"d":"15%"}]
[{"v":2274946.56,"d":"2,274,946.56"}]
[{"v":296732.16,"d":"296,732.16"}]
[2.2]
["Freight"]
["Estimate Only"]
[1]
[{"v":360000,"d":"R 360,000.00"}]
[{"v":360000,"d":"360,000.00"}]
[{"v":21600,"d":"21,600.00"}]
[{"v":381600,"d":"381,600.00"}]
[{"v":0.15,"d":"15%"}]
[{"v":438840,"d":"438,840.00"}]
[{"v":57240,"d":"57,240.00"}]
["Total Section 2"]
[{"v":17308862.96,"d":"17,308,862.96"}]
[{"v":19905192.4,"d":"19,905,192.40"}]
[{"v":2596329.44,"d":"2,596,329.44"}]
["Total"]
[{"v":17318520,"d":"17,318,520"}]
[{"v":19916297,"d":"19,916,297"}]
[{"v":2597778,"d":"2,597,778"}]