{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Summary","Tank Stairs","Tanks","Tank Bases","Mechanical","Instrumentation","Electrical","Civils"],"not_rendered":{"comments":10},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":11,"n_cols":3,"rows_kept":11}
[]
[null,"Summary"]
[null,"Discipline","Value"]
[null,"Electrical",{"$f":"Electrical!I58","v":{"v":4124000,"d":"R4,124,000.00"}}]
[null,"Instrumentation",{"$f":"Instrumentation!I41","v":{"v":1369000,"d":"R1,369,000.00"}}]
[null,"Mechanical",{"$f":"Mechanical!I124","v":{"v":14534059.15,"d":"R14,534,059.15"}}]
[null,"Tank Stairs",{"$f":"'Tank Stairs'!I11","v":{"v":1163000,"d":"R1,163,000.00"}}]
[null,"Tanks",{"$f":"Tanks!I20","v":{"v":36386000,"d":"R36,386,000.00"}}]
[null,"TOTAL (ROUNDED)",{"$f":"SUM(C4:C8)","v":{"v":57576059.15,"d":"R57,576,059.15"}}]
[]
[null,"Civils + Tank Bases ( Immovable)",{"$f":"'Tank Bases'!I13+Civils!I26","v":{"v":8490000,"d":"R8,490,000.00"}}]

{"sheet":"Tank Stairs","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8]]}
[]
[null,"Description","Size","Unit","Qty","Rate","Value","Depreciation","Value"]
[null,"Inter-tank Bridge 40mm thick, 30 degree slope, “vastrap” hot dipped galv. ",24,"m²",1,{"v":3750,"d":"R3,750.00"},{"v":89250,"d":"R89,250.00"},{"v":0.5,"d":"50.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"Tank Access Stair T1533helical “vastrap” stair incl.",null,null,1,{"v":168000,"d":"R168,000.00"},{"v":168000,"d":"R168,000.00"},{"v":0.5,"d":"50.00%"},{"v":84000,"d":"R84,000.00"}]
[null,"handrail 4 x 1.5'' NB pipe (Galv.)"]
[null,"Tank Access Stair T1435helical “vastrap” stair incl. handrail hot dipped galv.",null,null,1,{"v":168000,"d":"R168,000.00"},{"v":168000,"d":"R168,000.00"},{"v":0.5,"d":"50.00%"},{"v":84000,"d":"R84,000.00"}]
[null,"Tank Access Stair ",null,null,1,{"v":1900000,"d":"R1,900,000.00"},{"$f":"F7*E7","v":{"v":1900000,"d":"R1,900,000.00"}},{"v":0.5,"d":"50.00%"},{"$f":"G7*H7","v":{"v":950000,"d":"R950,000.00"}}]
[null,"T1436&T1437- helical “vastrap” stair incl. handrail hot dipped galv."]
[null,"TOTAL"]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I3:I8)","v":{"v":1163000,"d":"R1,163,000.00"}}]

{"sheet":"Tanks","index":2,"n_rows":20,"n_cols":9,"rows_kept":20,"merged":[[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8]]}
[]
[null,"Tanks"]
[null,"Description","Size","Unit","Qty","Rate","Value","Depreciation","Value"]
[null,"Tank, Condensate Return",null,"m3",1,{"v":100000,"d":"R100,000.00"},{"v":100000,"d":"R100,000.00"},{"v":0.6,"d":"60.00%"},{"v":40000,"d":"R40,000.00"}]
[null,"Tank, Condensate return, max cap 2000l",2,"m3",1,{"v":100000,"d":"R100,000.00"},{"v":100000,"d":"R100,000.00"},{"v":0.6,"d":"60.00%"},{"v":40000,"d":"R40,000.00"}]
[null,"Tank, slops, horizontal D2.4xL5,5m",25,"m3",1,{"v":8000,"d":"R8,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Tank, power paraffin, horizontal, ",1,"m3",1,{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"BTF"]
[null,"Tank, foam compound, 1000l",1,"m3",5,{"v":13500,"d":"R13,500.00"},{"v":67500,"d":"R67,500.00"},{"v":0.6,"d":"60.00%"},{"v":27000,"d":"R27,000.00"}]
[null,"Tank, Boiler fuel, 25mm outlet",null,"m3",1,{"v":5000,"d":"R5,000.00"},{"v":5000,"d":"R5,000.00"},{"v":0.6,"d":"60.00%"},{"v":2000,"d":"R2,000.00"}]
[null,"Underground Tank, max cap. 4200l",4,"m3",1,{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":0.6,"d":"60.00%"},{"v":20000,"d":"R20,000.00"}]
[null,"Tank 1533, Vertical, diam 20.4 height 12m, storing MGO",{"v":4963,"d":"4,963.00"},"m3",1,{"v":12000000,"d":"R12,000,000.00"},{"v":12000000,"d":"R12,000,000.00"},{"v":0.6,"d":"60.00%"},{"v":4800000,"d":"R4,800,000.00"}]
[null,"Tank 1435, Vertical, diam 24.5 height 12m, storing LMFO",{"v":11041,"d":"11,041.00"},"m3",1,{"v":16000000,"d":"R16,000,000.00"},{"v":16000000,"d":"R16,000,000.00"},{"v":0.6,"d":"60.00%"},{"v":6400000,"d":"R6,400,000.00"}]
[null,"Tank 1436 & 1437, Vertical, diam 33.4 height 12m, storing ",{"v":16890,"d":"16,890.00"},"m3",2,{"v":30000000,"d":"R30,000,000.00"},{"v":60000000,"d":"R60,000,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000000,"d":"R24,000,000.00"}]
[null,"LMFO"]
[null,"Tank 1532 & 1434, Vertical, diam 5.7 height 6m, storing ADO",155,"m3",2,{"v":1200000,"d":"R1,200,000.00"},{"v":2400000,"d":"R2,400,000.00"},{"v":0.6,"d":"60.00%"},{"v":960000,"d":"R960,000.00"}]
[null,"Horizontal, dia. 2.7m, decommissioned",72,"m3",2,{"v":50000,"d":"R50,000.00"},{"v":100000,"d":"R100,000.00"},{"v":0.89,"d":"89.00%"},{"v":11000,"d":"R11,000.00"}]
[]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I4:I17)","v":{"v":36386000,"d":"R36,386,000.00"}}]

{"sheet":"Tank Bases","index":3,"n_rows":13,"n_cols":9,"rows_kept":13}
[]
[null,"Tank Bases"]
[null,"Description","Size","Unit","Qty","Rate","Value","Depreciation","Value"]
[null,"Tank 1533 plinth",null,null,1,{"v":500000,"d":"R500,000.00"},{"v":500000,"d":"R500,000.00"},{"v":0.5,"d":"50.00%"},{"v":250000,"d":"R250,000.00"}]
[null,"Tank 1435 plinth",null,null,1,{"v":600000,"d":"R600,000.00"},{"v":600000,"d":"R600,000.00"},{"v":0.5,"d":"50.00%"},{"v":300000,"d":"R300,000.00"}]
[null,"Tank 1436 plinth ",null,null,1,{"v":810000,"d":"R810,000.00"},{"v":810000,"d":"R810,000.00"},{"v":0.5,"d":"50.00%"},{"v":405000,"d":"R405,000.00"}]
[null,"Tank 1437 plinth",null,null,1,{"v":810000,"d":"R810,000.00"},{"v":810000,"d":"R810,000.00"},{"v":0.5,"d":"50.00%"},{"v":405000,"d":"R405,000.00"}]
[null,"Tank 1532 plinth",null,null,1,{"v":140000,"d":"R140,000.00"},{"v":140000,"d":"R140,000.00"},{"v":0.5,"d":"50.00%"},{"v":70000,"d":"R70,000.00"}]
[null,"Tank 1434 plinth",null,null,1,{"v":140000,"d":"R140,000.00"},{"v":140000,"d":"R140,000.00"},{"v":0.5,"d":"50.00%"},{"v":70000,"d":"R70,000.00"}]
[null,"Horizontal Tank plinths",4,"m3",2,{"v":300000,"d":"R300,000.00"},{"v":600000,"d":"R600,000.00"},{"v":0.5,"d":"50.00%"},{"v":300000,"d":"R300,000.00"}]
[]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I4:I10)","v":{"v":1800000,"d":"R1,800,000.00"}}]

{"sheet":"Mechanical","index":4,"n_rows":124,"n_cols":9,"rows_kept":124,"merged":[[1,1,1,8],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[33,7,34,7],[33,8,34,8],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,7],[35,8,36,8],[38,2,39,2],[38,3,39,3],[38,4,39,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[41,7,42,7],[41,8,42,8],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[102,2,103,2],[102,3,103,3],[102,4,103,4],[102,5,103,5],[102,6,103,6],[102,7,103,7],[102,8,103,8]]}
[]
[null,"Mechanical"]
[null,"Description","Size","Unit","Qty","Rate","Value","Depreciation","Value"]
[null,"Valve, ball, 300mm, V3",300,"mm",1,{"v":310000,"d":"R310,000.00"},{"v":310000,"d":"R310,000.00"},{"v":0.6,"d":"60.00%"},{"v":124000,"d":"R124,000.00"}]
[null,"Pump, Condensate Return",null,"no.",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Valve, ball, 500mm, V2",500,"mm",1,{"v":450000,"d":"R450,000.00"},{"v":450000,"d":"R450,000.00"},{"v":0.6,"d":"60.00%"},{"v":180000,"d":"R180,000.00"}]
[null,"Valve, butterfly, 300mm, V5",300,"mm",1,{"v":43000,"d":"R43,000.00"},{"v":43000,"d":"R43,000.00"},{"v":0.6,"d":"60.00%"},{"v":18000,"d":"R18,000.00"}]
[null,"Valve, butterfly, 300mm, V4",300,"mm",1,{"v":43000,"d":"R43,000.00"},{"v":43000,"d":"R43,000.00"},{"v":0.6,"d":"60.00%"},{"v":18000,"d":"R18,000.00"}]
[null,"Valve, gate, 350mm",350,"mm",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Compensator, 300mm",300,"mm",1,{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":0.6,"d":"60.00%"},{"v":20000,"d":"R20,000.00"}]
[null,"Valve, gate, 200mm, V22",200,"mm",1,{"v":29000,"d":"R29,000.00"},{"v":29000,"d":"R29,000.00"},{"v":0.6,"d":"60.00%"},{"v":12000,"d":"R12,000.00"}]
[null,"Pump Positive Displacement",null,"no.",1,{"v":20000,"d":"R20,000.00"},{"v":20000,"d":"R20,000.00"},{"v":0.6,"d":"60.00%"},{"v":8000,"d":"R8,000.00"}]
[null,"Pump Positive Displacement",null,"no.",1,{"v":20000,"d":"R20,000.00"},{"v":20000,"d":"R20,000.00"},{"v":0.6,"d":"60.00%"},{"v":8000,"d":"R8,000.00"}]
[null,"Pump, centrifugal, ADO, 120m3/hr, 5.25m",null,"no.",1,{"v":120000,"d":"R120,000.00"},{"v":120000,"d":"R120,000.00"},{"v":0.6,"d":"60.00%"},{"v":48000,"d":"R48,000.00"}]
[null,"Pump, centrifugal, ADO, horizontal split, P6",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"4'' Basket Strainer",4,"inch",1,{"v":112000,"d":"R112,000.00"},{"v":112000,"d":"R112,000.00"},{"v":0.6,"d":"60.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"4'' Steam Trap",4,"inch",1,{"v":105000,"d":"R105,000.00"},{"v":105000,"d":"R105,000.00"},{"v":0.6,"d":"60.00%"},{"v":42000,"d":"R42,000.00"}]
[null,"Valve, butterfly, 100mm",100,"mm",1,{"v":13000,"d":"R13,000.00"},{"v":13000,"d":"R13,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"4'' Basket Strainer",4,"inch",1,{"v":112000,"d":"R112,000.00"},{"v":112000,"d":"R112,000.00"},{"v":0.6,"d":"60.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"4'' Steam Trap",4,"inch",1,{"v":105000,"d":"R105,000.00"},{"v":105000,"d":"R105,000.00"},{"v":0.6,"d":"60.00%"},{"v":42000,"d":"R42,000.00"}]
[null,"Pump, centrifugal, split horizontal, MGO, P4",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"4'' Basket Strainer",4,"inch",1,{"v":112000,"d":"R112,000.00"},{"v":112000,"d":"R112,000.00"},{"v":0.6,"d":"60.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"4'' Steam Trap",4,"inch",1,{"v":105000,"d":"R105,000.00"},{"v":105000,"d":"R105,000.00"},{"v":0.6,"d":"60.00%"},{"v":42000,"d":"R42,000.00"}]
[null,"Air Eliminator, 1000kPa, max cap 6.3m3",null,"no.",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.6,"d":"60.00%"},{"v":160000,"d":"R160,000.00"}]
[null,"Valve, gate, 150mm, V27",150,"mm",1,{"v":14000,"d":"R14,000.00"},{"v":14000,"d":"R14,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Pump, screw, HFO, size W225 x 135, P1",null,"no.",1,{"v":845000,"d":"R845,000.00"},{"$f":"E26*F26","v":{"v":845000,"d":"R845,000.00"}},{"v":0.6,"d":"60.00%"},{"$f":"G26*(1-H26)","v":{"v":338000,"d":"R338,000.00"}}]
[null,"Air eliminator, 1000kPa, max cap 6.3m3",null,"no.",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.6,"d":"60.00%"},{"v":160000,"d":"R160,000.00"}]
[null,"Pump, HFO, size W225 x 135, P2",null,"no.",1,{"v":260000,"d":"R260,000.00"},{"v":260000,"d":"R260,000.00"},{"v":0.6,"d":"60.00%"},{"v":104000,"d":"R104,000.00"}]
[null,"Pump, screw, HFO, size W225 x 135, P3",null,"no.",1,{"v":845000,"d":"R845,000.00"},{"$f":"E29*F29","v":{"v":845000,"d":"R845,000.00"}},{"v":0.6,"d":"60.00%"},{"$f":"G29*(1-H29)","v":{"v":338000,"d":"R338,000.00"}}]
[null,"Piping, insulated carbon steel, ",null,"m",83,{"v":2555,"d":"R2,555.00"},{"v":212065,"d":"R212,065.00"},{"v":0.6,"d":"60.00%"},{"v":85000,"d":"R85,000.00"}]
[null,"400mm diam"]
[null,"Piping, insulated carbon steel, ",null,"m",180,{"v":1916,"d":"R1,916.00"},{"v":344880,"d":"R344,880.00"},{"v":0.6,"d":"60.00%"},{"v":138000,"d":"R138,000.00"}]
[null,"300mm diam"]
[null,"Piping, insulated carbon steel, ",null,"m",396,{"v":380,"d":"R380.00"},{"v":150480,"d":"R150,480.00"},{"v":0.6,"d":"60.00%"},{"v":61000,"d":"R61,000.00"}]
[null,"50mm diam"]
[null,"Piping, insulated carbon steel, ",null,"m",63,{"v":511,"d":"R511.00"},{"v":32193,"d":"R32,193.00"},{"v":0.6,"d":"60.00%"},{"v":13000,"d":"R13,000.00"}]
[null,"80mm diam"]
[null,"Piping, carbon steel, 100mm diam",null,"m",3,{"v":7500,"d":"R7,500.00"},{"v":22500,"d":"R22,500.00"},{"v":0.6,"d":"60.00%"},{"v":9000,"d":"R9,000.00"}]
[null,"Piping, insulated carbon steel, ",null,"m",74,{"v":640,"d":"R640.00"},{"v":47360,"d":"R47,360.00"},{"v":0.6,"d":"60.00%"},{"v":19000,"d":"R19,000.00"}]
[null,"100mm diam"]
[null,"Piping, insulated carbon steel, 65mm diam",null,"m",51,{"v":415,"d":"R415.00"},{"v":21165,"d":"R21,165.00"},{"v":0.6,"d":"60.00%"},{"v":9000,"d":"R9,000.00"}]
[null,"Piping, insulated carbon steel, ",null,"m",10,{"v":958,"d":"R958.00"},{"v":9580,"d":"R9,580.00"},{"v":0.6,"d":"60.00%"},{"v":4000,"d":"R4,000.00"}]
[null,"150mm diam"]
[null,"Piping, insulated carbon steel, 250mm diam",null,"m",45,{"v":1600,"d":"R1,600.00"},{"v":72000,"d":"R72,000.00"},{"v":0.6,"d":"60.00%"},{"v":29000,"d":"R29,000.00"}]
[null,"Piping, insulated carbon steel, ",null,"m",22,{"v":640,"d":"R640.00"},{"v":14080,"d":"R14,080.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"100mm diam"]
[null,"Piping, insulated carbon steel, 50mm diam",null,"m",6,{"v":380,"d":"R380.00"},{"v":2280,"d":"R2,280.00"},{"v":0.6,"d":"60.00%"},{"v":1000,"d":"R1,000.00"}]
[null,"Piping, stainless steel, 65mm diam",null,"m",92,{"v":4500,"d":"R4,500.00"},{"v":414000,"d":"R414,000.00"},{"v":0.6,"d":"60.00%"},{"v":166000,"d":"R166,000.00"}]
[null,"Compensator",null,"no.",18,{"v":50000,"d":"R50,000.00"},{"v":900000,"d":"R900,000.00"},{"v":0.6,"d":"60.00%"},{"v":360000,"d":"R360,000.00"}]
[null,"Valve, gate, 200mm",200,"mm",1,{"v":29000,"d":"R29,000.00"},{"v":29000,"d":"R29,000.00"},{"v":0.6,"d":"60.00%"},{"v":12000,"d":"R12,000.00"}]
[null,"Valve, gate, 300mm Diam.",300,"mm",1,{"v":55000,"d":"R55,000.00"},{"v":55000,"d":"R55,000.00"},{"v":0.6,"d":"60.00%"},{"v":22000,"d":"R22,000.00"}]
[null,"Valve, ball, 300mm",300,"mm",1,{"v":310000,"d":"R310,000.00"},{"v":310000,"d":"R310,000.00"},{"v":0.6,"d":"60.00%"},{"v":124000,"d":"R124,000.00"}]
[null,"Valve, butterfly, 200mm",200,"mm",1,{"v":23000,"d":"R23,000.00"},{"v":23000,"d":"R23,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Valve, butterfly, 160mm",160,"mm",1,{"v":21000,"d":"R21,000.00"},{"v":21000,"d":"R21,000.00"},{"v":0.6,"d":"60.00%"},{"v":9000,"d":"R9,000.00"}]
[null,"Valve, ball, 400mm",400,"mm",1,{"v":450000,"d":"R450,000.00"},{"v":450000,"d":"R450,000.00"},{"v":0.6,"d":"60.00%"},{"v":180000,"d":"R180,000.00"}]
[null,"Valve, gate, 600mm",600,"mm",1,{"v":160000,"d":"R160,000.00"},{"v":160000,"d":"R160,000.00"},{"v":0.6,"d":"60.00%"},{"v":64000,"d":"R64,000.00"}]
[null,"Valve, butterfly, 100mm",100,"mm",1,{"v":13000,"d":"R13,000.00"},{"v":13000,"d":"R13,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Valve, ball, 500mm",500,"mm",1,{"v":120000,"d":"R120,000.00"},{"v":120000,"d":"R120,000.00"},{"v":0.6,"d":"60.00%"},{"v":48000,"d":"R48,000.00"}]
[null,"Valve, butterfly, 100mm",100,"mm",1,{"v":13000,"d":"R13,000.00"},{"v":13000,"d":"R13,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Valve, butterfly, 100mm",100,"mm",1,{"v":13000,"d":"R13,000.00"},{"v":13000,"d":"R13,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Valve, gate, Dia. 250mm",250,"mm",1,{"v":37000,"d":"R37,000.00"},{"v":37000,"d":"R37,000.00"},{"v":0.6,"d":"60.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"Valve, butterfly, 250mm",250,"mm",1,{"v":32000,"d":"R32,000.00"},{"v":32000,"d":"R32,000.00"},{"v":0.6,"d":"60.00%"},{"v":13000,"d":"R13,000.00"}]
[null,"Valve, gate, 250mm",250,"mm",1,{"v":37000,"d":"R37,000.00"},{"v":37000,"d":"R37,000.00"},{"v":0.6,"d":"60.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"Valve, ball, 100mm",100,"mm",1,{"v":41000,"d":"R41,000.00"},{"v":41000,"d":"R41,000.00"},{"v":0.6,"d":"60.00%"},{"v":17000,"d":"R17,000.00"}]
[null,"Valve, ball, 150mm",150,"mm",1,{"v":78000,"d":"R78,000.00"},{"v":78000,"d":"R78,000.00"},{"v":0.6,"d":"60.00%"},{"v":32000,"d":"R32,000.00"}]
[null,"Valve, ball, 200mm",200,"mm",3,{"v":104000,"d":"R104,000.00"},{"v":312000,"d":"R312,000.00"},{"v":0.6,"d":"60.00%"},{"v":125000,"d":"R125,000.00"}]
[null,"Valve, ball, 300mm",300,"mm",1,{"v":310000,"d":"R310,000.00"},{"v":310000,"d":"R310,000.00"},{"v":0.6,"d":"60.00%"},{"v":124000,"d":"R124,000.00"}]
[null,"Valve, ball, 400mm",400,"mm",1,{"v":450000,"d":"R450,000.00"},{"v":450000,"d":"R450,000.00"},{"v":0.6,"d":"60.00%"},{"v":180000,"d":"R180,000.00"}]
[null,"Valve, ball, 500mm",500,"mm",1,{"v":650000,"d":"R650,000.00"},{"v":650000,"d":"R650,000.00"},{"v":0.6,"d":"60.00%"},{"v":260000,"d":"R260,000.00"}]
[null,"Valve, ball, 80mm",80,"mm",1,{"v":33000,"d":"R33,000.00"},{"v":33000,"d":"R33,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Valve, butterfly, 50mm",50,"mm",1,{"v":12000,"d":"R12,000.00"},{"v":12000,"d":"R12,000.00"},{"v":0.6,"d":"60.00%"},{"v":5000,"d":"R5,000.00"}]
[null,"Valve, butterfly, 100mm",100,"mm",6,{"v":13000,"d":"R13,000.00"},{"v":78000,"d":"R78,000.00"},{"v":0.6,"d":"60.00%"},{"v":32000,"d":"R32,000.00"}]
[null,"Valve, butterfly, 100mm",100,"mm",2,{"v":13000,"d":"R13,000.00"},{"v":26000,"d":"R26,000.00"},{"v":0.6,"d":"60.00%"},{"v":11000,"d":"R11,000.00"}]
[null,"Valve, butterfly, 150mm",150,"mm",3,{"v":20000,"d":"R20,000.00"},{"v":60000,"d":"R60,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve, butterfly, 200mm",200,"mm",3,{"v":23000,"d":"R23,000.00"},{"v":69000,"d":"R69,000.00"},{"v":0.6,"d":"60.00%"},{"v":28000,"d":"R28,000.00"}]
[null,"Valve, butterfly, 250mm",250,"mm",3,{"v":32000,"d":"R32,000.00"},{"v":96000,"d":"R96,000.00"},{"v":0.6,"d":"60.00%"},{"v":39000,"d":"R39,000.00"}]
[null,"Valve, butterfly, 250mm",250,"mm",2,{"v":32000,"d":"R32,000.00"},{"v":64000,"d":"R64,000.00"},{"v":0.6,"d":"60.00%"},{"v":26000,"d":"R26,000.00"}]
[null,"Valve, butterfly, 400mm",400,"mm",1,{"v":74000,"d":"R74,000.00"},{"v":74000,"d":"R74,000.00"},{"v":0.6,"d":"60.00%"},{"v":30000,"d":"R30,000.00"}]
[null,"Valve, butterfly, 600mm",600,"mm",1,{"v":168000,"d":"R168,000.00"},{"v":168000,"d":"R168,000.00"},{"v":0.6,"d":"60.00%"},{"v":68000,"d":"R68,000.00"}]
[null,"Valve, gate, 100mm",100,"mm",5,{"v":9000,"d":"R9,000.00"},{"v":45000,"d":"R45,000.00"},{"v":0.6,"d":"60.00%"},{"v":18000,"d":"R18,000.00"}]
[null,"Valve, gate, 150mm",150,"mm",1,{"v":14000,"d":"R14,000.00"},{"v":14000,"d":"R14,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Valve, gate, 150mm",150,"mm",8,{"v":14000,"d":"R14,000.00"},{"v":112000,"d":"R112,000.00"},{"v":0.6,"d":"60.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"Valve, gate, 200mm",200,"mm",2,{"v":29000,"d":"R29,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve, gate, 220mm",220,"mm",3,{"v":33000,"d":"R33,000.00"},{"v":99000,"d":"R99,000.00"},{"v":0.6,"d":"60.00%"},{"v":40000,"d":"R40,000.00"}]
[null,"Valve, gate, 250mm",250,"mm",1,{"v":37000,"d":"R37,000.00"},{"v":37000,"d":"R37,000.00"},{"v":0.6,"d":"60.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"Valve, gate, 280mm",280,"mm",1,{"v":41000,"d":"R41,000.00"},{"v":41000,"d":"R41,000.00"},{"v":0.6,"d":"60.00%"},{"v":17000,"d":"R17,000.00"}]
[null,"Valve, gate, 300mm",300,"mm",2,{"v":55000,"d":"R55,000.00"},{"v":110000,"d":"R110,000.00"},{"v":0.6,"d":"60.00%"},{"v":44000,"d":"R44,000.00"}]
[null,"Valve, gate, 350mm",350,"mm",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve, gate, 400mm",400,"mm",2,{"v":72000,"d":"R72,000.00"},{"v":144000,"d":"R144,000.00"},{"v":0.6,"d":"60.00%"},{"v":58000,"d":"R58,000.00"}]
[null,"Valve, gate, 500mm",500,"mm",1,{"v":120000,"d":"R120,000.00"},{"v":120000,"d":"R120,000.00"},{"v":0.6,"d":"60.00%"},{"v":48000,"d":"R48,000.00"}]
[null,"Engine, Diesel",null,"no.",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.6,"d":"60.00%"},{"v":160000,"d":"R160,000.00"}]
[null,"Pump, centrifugal",null,"no.",1,{"v":350000,"d":"R350,000.00"},{"v":350000,"d":"R350,000.00"},{"v":0.6,"d":"60.00%"},{"v":140000,"d":"R140,000.00"}]
[null,"New Fire pump",null,null,1,{"v":6697843.5,"d":"R6,697,843.50"},{"$f":"F93*E93","v":{"v":6697843.5,"d":"R6,697,843.50"}},{"v":0.1,"d":"10.00%"},{"$f":"G93*(1-H93)","v":{"v":6028059.15,"d":"R6,028,059.15"}}]
[null,"Valve, Control, outlet Dia.150mm",150,"mm",1,{"v":80000,"d":"R80,000.00"},{"v":80000,"d":"R80,000.00"},{"v":0.6,"d":"60.00%"},{"v":32000,"d":"R32,000.00"}]
[null,"4'' Basket Strainer",4,"inch",1,{"v":112000,"d":"R112,000.00"},{"v":112000,"d":"R112,000.00"},{"v":0.6,"d":"60.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"Valve, butterfly, Diam 150mm",150,"mm",1,{"v":20000,"d":"R20,000.00"},{"v":20000,"d":"R20,000.00"},{"v":0.6,"d":"60.00%"},{"v":8000,"d":"R8,000.00"}]
[null,"Valve, butterfly, Dia.200mm",200,"mm",1,{"v":23000,"d":"R23,000.00"},{"v":23000,"d":"R23,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Foam stock, 25l drums",{"v":2375,"d":"2,375.00"},"lt",95,{"v":100,"d":"R100.00"},{"v":237500,"d":"R237,500.00"},{"v":0.6,"d":"60.00%"},{"v":95000,"d":"R95,000.00"}]
[null,"Fire extinguishers, dry powder",null,"no.",21,{"v":880,"d":"R880.00"},{"v":18480,"d":"R18,480.00"},{"v":0.6,"d":"60.00%"},{"v":8000,"d":"R8,000.00"}]
[null,"Fire hoses, 65mm diam (30m)",65,"mm",20,{"v":37000,"d":"R37,000.00"},{"v":740000,"d":"R740,000.00"},{"v":0.6,"d":"60.00%"},{"v":296000,"d":"R296,000.00"}]
[null,"Fire hoses, 45mm diam (30m)",45,"mm",2,{"v":25000,"d":"R25,000.00"},{"v":50000,"d":"R50,000.00"},{"v":0.6,"d":"60.00%"},{"v":20000,"d":"R20,000.00"}]
[null,"Foam / water cannon, inlet 150mm",150,"mm",1,{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Foam branch, AF 900, nozzle",65,"mm",1,{"v":18000,"d":"R18,000.00"},{"v":18000,"d":"R18,000.00"},{"v":0.6,"d":"60.00%"},{"v":8000,"d":"R8,000.00"}]
[null,"65mm"]
[null,"Hydrants, 65mm outlet",65,"mm",16,{"v":4000,"d":"R4,000.00"},{"v":64000,"d":"R64,000.00"},{"v":0.6,"d":"60.00%"},{"v":26000,"d":"R26,000.00"}]
[null,"Level Control Valve",null,"no.",1,{"v":60000,"d":"R60,000.00"},{"v":60000,"d":"R60,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Boiler Feedwater Treatment Dosing Unit",null,"no.",1,{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"},{"v":0.6,"d":"60.00%"},{"v":4000,"d":"R4,000.00"}]
[null,"Valve, pressure reducing, kus 63m3/h, outlet 250mm",250,"mm",1,{"v":60000,"d":"R60,000.00"},{"v":60000,"d":"R60,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve, gate, 90mm",90,"mm",1,{"v":7500,"d":"R7,500.00"},{"v":7500,"d":"R7,500.00"},{"v":0.6,"d":"60.00%"},{"v":3000,"d":"R3,000.00"}]
[null,"Ball Valve, 3\"",3,"inch",1,{"v":33000,"d":"R33,000.00"},{"v":33000,"d":"R33,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Pump",null,"no.",1,{"v":20000,"d":"R20,000.00"},{"v":20000,"d":"R20,000.00"},{"v":0.6,"d":"60.00%"},{"v":8000,"d":"R8,000.00"}]
[null,"Burner Unit, Motor & Blower",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Boiler, 2500kg/hr, 1035kPa",null,"no.",1,{"v":3000000,"d":"R3,000,000.00"},{"v":3000000,"d":"R3,000,000.00"},{"v":0.6,"d":"60.00%"},{"v":1200000,"d":"R1,200,000.00"}]
[null,"4'' Basket Strainer",4,"inch",1,{"v":112000,"d":"R112,000.00"},{"v":112000,"d":"R112,000.00"},{"v":0.6,"d":"60.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"4'' Steam Trap",4,"inch",1,{"v":105000,"d":"R105,000.00"},{"v":105000,"d":"R105,000.00"},{"v":0.6,"d":"60.00%"},{"v":42000,"d":"R42,000.00"}]
[null,"Burner Unit, Motor & Blower",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Boiler, 2500kg/hr, 1035kPa",null,"no.",1,{"v":3000000,"d":"R3,000,000.00"},{"v":3000000,"d":"R3,000,000.00"},{"v":0.6,"d":"60.00%"},{"v":1200000,"d":"R1,200,000.00"}]
[null,"4'' Basket Strainer",4,"inch",1,{"v":112000,"d":"R112,000.00"},{"v":112000,"d":"R112,000.00"},{"v":0.6,"d":"60.00%"},{"v":45000,"d":"R45,000.00"}]
[null,"4'' Steam Trap",4,"inch",1,{"v":105000,"d":"R105,000.00"},{"v":105000,"d":"R105,000.00"},{"v":0.6,"d":"60.00%"},{"v":42000,"d":"R42,000.00"}]
[null,"Curb side Diesel Pump",null,"no.",1,{"v":65000,"d":"R65,000.00"},{"v":65000,"d":"R65,000.00"},{"v":0.6,"d":"60.00%"},{"v":26000,"d":"R26,000.00"}]
[null,"2 x Containment Equipment ",null,null,2,{"v":25000,"d":"R25,000.00"},{"v":50000,"d":"R50,000.00"},{"v":0.6,"d":"60.00%"},{"v":20000,"d":"R20,000.00"}]
[null,"TOTAL"]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I4:I121)","v":{"v":14534059.15,"d":"R14,534,059.15"}}]

{"sheet":"Instrumentation","index":5,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[1,1,1,8],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[19,8,20,8]]}
[]
[null,"Instrumentation"]
[null,"Description","Size","Unit","Qty","Rate","Value","Depreciation","Value"]
[null,"Valve, Actuator & Gearbox, V3",null,"no.",1,{"v":73000,"d":"R73,000.00"},{"v":73000,"d":"R73,000.00"},{"v":0.6,"d":"60.00%"},{"v":30000,"d":"R30,000.00"}]
[null,"Motor, Condensate Return, 2,2kW",null,"no.",1,{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Valve Actuator & Gearbox, V2",null,"no.",1,{"v":106000,"d":"R106,000.00"},{"v":106000,"d":"R106,000.00"},{"v":0.6,"d":"60.00%"},{"v":43000,"d":"R43,000.00"}]
[null,"Valve, Actuator & Gearbox, V5",null,"no.",1,{"v":73000,"d":"R73,000.00"},{"v":73000,"d":"R73,000.00"},{"v":0.6,"d":"60.00%"},{"v":30000,"d":"R30,000.00"}]
[null,"Valve Actuator & Gearbox, V4",null,"no.",1,{"v":73000,"d":"R73,000.00"},{"v":73000,"d":"R73,000.00"},{"v":0.6,"d":"60.00%"},{"v":30000,"d":"R30,000.00"}]
[null,"Valve actuator, V22",null,"no.",1,{"v":90000,"d":"R90,000.00"},{"v":90000,"d":"R90,000.00"},{"v":0.6,"d":"60.00%"},{"v":36000,"d":"R36,000.00"}]
[null,"Motor",null,"no.",1,{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Motor, 700rpm, 5.5Hp",null,"no.",1,{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Motor, 2970rpm, 75kW, P6",null,"no.",1,{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":0.6,"d":"60.00%"},{"v":6000,"d":"R6,000.00"}]
[null,"Valve actuator",null,"no.",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Motor, 1485rpm, 110kW, Exn, IP65, P4",null,"no.",1,{"v":30000,"d":"R30,000.00"},{"v":30000,"d":"R30,000.00"},{"v":0.6,"d":"60.00%"},{"v":12000,"d":"R12,000.00"}]
[null,"Valve Actuator & Gearbox, V27",null,"no.",1,{"v":76000,"d":"R76,000.00"},{"v":76000,"d":"R76,000.00"},{"v":0.6,"d":"60.00%"},{"v":31000,"d":"R31,000.00"}]
[null,"Motor, 1480rpm, 90kW, Exn, P1",null,"no.",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Motor, 1485rpm, 90kW, Exn, P2",null,"no.",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Motor, 1480rpm, 90kW, Exn, P3",null,"no.",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Motor, 1480rpm, 90kW, Exn",null,"no.",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Main Switchboard (Pump ",null,"no.",1,{"v":1200000,"d":"R1,200,000.00"},{"v":1200000,"d":"R1,200,000.00"},{"v":0.6,"d":"60.00%"},{"v":480000,"d":"R480,000.00"}]
[null,"starters, circuit breakers etc)"]
[null,"Lighting Transformer",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Valve actuator",null,"no.",1,{"v":90000,"d":"R90,000.00"},{"v":90000,"d":"R90,000.00"},{"v":0.6,"d":"60.00%"},{"v":36000,"d":"R36,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":107000,"d":"R107,000.00"},{"v":107000,"d":"R107,000.00"},{"v":0.6,"d":"60.00%"},{"v":43000,"d":"R43,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":73000,"d":"R73,000.00"},{"v":73000,"d":"R73,000.00"},{"v":0.6,"d":"60.00%"},{"v":30000,"d":"R30,000.00"}]
[null,"Valve, Actuator & Gearbox ",null,"no.",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":100000,"d":"R100,000.00"},{"v":100000,"d":"R100,000.00"},{"v":0.6,"d":"60.00%"},{"v":40000,"d":"R40,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":190000,"d":"R190,000.00"},{"v":190000,"d":"R190,000.00"},{"v":0.6,"d":"60.00%"},{"v":76000,"d":"R76,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":106000,"d":"R106,000.00"},{"v":106000,"d":"R106,000.00"},{"v":0.6,"d":"60.00%"},{"v":43000,"d":"R43,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":58000,"d":"R58,000.00"},{"v":58000,"d":"R58,000.00"},{"v":0.6,"d":"60.00%"},{"v":24000,"d":"R24,000.00"}]
[null,"Valve Actuator & Gearbox",null,"no.",1,{"v":91000,"d":"R91,000.00"},{"v":91000,"d":"R91,000.00"},{"v":0.6,"d":"60.00%"},{"v":37000,"d":"R37,000.00"}]
[null,"Valve Actuator",null,"no.",1,{"v":106000,"d":"R106,000.00"},{"v":106000,"d":"R106,000.00"},{"v":0.6,"d":"60.00%"},{"v":43000,"d":"R43,000.00"}]
[null,"Valve, Actuator & Gearbox ",null,"no.",1,{"v":91000,"d":"R91,000.00"},{"v":91000,"d":"R91,000.00"},{"v":0.6,"d":"60.00%"},{"v":37000,"d":"R37,000.00"}]
[null,"Motor & Fan",null,"no.",1,{"v":5000,"d":"R5,000.00"},{"v":5000,"d":"R5,000.00"},{"v":0.6,"d":"60.00%"},{"v":2000,"d":"R2,000.00"}]
[null,"Motor & Fan",null,"no.",1,{"v":5000,"d":"R5,000.00"},{"v":5000,"d":"R5,000.00"},{"v":0.6,"d":"60.00%"},{"v":2000,"d":"R2,000.00"}]
[]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I4:I38)","v":{"v":1369000,"d":"R1,369,000.00"}}]

{"sheet":"Electrical","index":6,"n_rows":58,"n_cols":9,"rows_kept":58}
[]
[null,"Electrical"]
[null,"Description","Size","Unit","Qty","Rate","Replacement Cost","Depreciation","Value"]
[null,"Lighting, Tank farm",null,"no.",19,{"v":13000,"d":"R13,000.00"},{"v":247000,"d":"R247,000.00"},{"v":0.5,"d":"50.00%"},{"v":124000,"d":"R124,000.00"}]
[null,"Level switch, Tank 1434",null,"no.",1,{"v":31000,"d":"R31,000.00"},{"v":31000,"d":"R31,000.00"},{"v":0.6,"d":"60.00%"},{"v":13000,"d":"R13,000.00"}]
[null,"Radar Gauge, Tank 1435, Exe",null,"no.",1,{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},{"v":0.6,"d":"60.00%"},{"v":100000,"d":"R100,000.00"}]
[null,"DP Cell, Tank 1435",null,"no.",1,{"v":36000,"d":"R36,000.00"},{"v":36000,"d":"R36,000.00"},{"v":0.6,"d":"60.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"Water Bottom/Temperature Sensor, Tank 1435",null,"no.",1,{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":0.6,"d":"60.00%"},{"v":20000,"d":"R20,000.00"}]
[null,"Data Acquisition Unit, Tank 1435",null,"no.",1,{"v":110000,"d":"R110,000.00"},{"v":110000,"d":"R110,000.00"},{"v":0.6,"d":"60.00%"},{"v":44000,"d":"R44,000.00"}]
[null,"Transmitter, temperature, TR2",null,"no.",1,{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Radar Gauge, Tank 1436, Exe",null,"no.",1,{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},{"v":0.6,"d":"60.00%"},{"v":100000,"d":"R100,000.00"}]
[null,"DP Cell, Tank 1436",null,"no.",1,{"v":36000,"d":"R36,000.00"},{"v":36000,"d":"R36,000.00"},{"v":0.6,"d":"60.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"Water Bottom/Temperature Sensor, Tank 1436",null,"no.",1,{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Data Acquisition Unit, Tank 1436",null,"no.",1,{"v":110000,"d":"R110,000.00"},{"v":110000,"d":"R110,000.00"},{"v":0.6,"d":"60.00%"},{"v":44000,"d":"R44,000.00"}]
[null,"Transmitter, temperature, T1",null,"no.",1,{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Radar Gauge, Tank 1437, Exe",null,"no.",1,{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},{"v":0.6,"d":"60.00%"},{"v":100000,"d":"R100,000.00"}]
[null,"DP Cell, Tank 1437",null,"no.",1,{"v":36000,"d":"R36,000.00"},{"v":36000,"d":"R36,000.00"},{"v":0.6,"d":"60.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"Water Bottom/Temperature Sensor, Tank 1437",null,"no.",1,{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Data Acquisition Unit, Tank 1437",null,"no.",1,{"v":110000,"d":"R110,000.00"},{"v":110000,"d":"R110,000.00"},{"v":0.6,"d":"60.00%"},{"v":44000,"d":"R44,000.00"}]
[null,"Level switch, Tank 1532",null,"no.",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0.6,"d":"60.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Radar Gauge, Tank 1533, Exe",null,"no.",1,{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"},{"v":0.6,"d":"60.00%"},{"v":100000,"d":"R100,000.00"}]
[null,"DP Cell, Tank 1533",null,"no.",1,{"v":36000,"d":"R36,000.00"},{"v":36000,"d":"R36,000.00"},{"v":0.6,"d":"60.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"Water Bottom/Temperature Sensor, Tank 1533",null,"no.",1,{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Data Acquisition Unit",null,"no.",1,{"v":110000,"d":"R110,000.00"},{"v":110000,"d":"R110,000.00"},{"v":0.6,"d":"60.00%"},{"v":44000,"d":"R44,000.00"}]
[null,"Motor, 2950rpm, 11kW, IP 55",null,"no.",1,{"v":20000,"d":"R20,000.00"},{"v":20000,"d":"R20,000.00"},{"v":0.6,"d":"60.00%"},{"v":8000,"d":"R8,000.00"}]
[null,"Transmitter, pressure, PT7",null,"no.",1,{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Meter, ADO, M6/ Register, electronic, M6 ",null,"no.",1,{"v":65000,"d":"R65,000.00"},{"v":65000,"d":"R65,000.00"},{"v":0.6,"d":"60.00%"},{"v":26000,"d":"R26,000.00"}]
[null,"Meter,6\", MGO, M5, 600m3/H Mass Flow Meter",6,"inch",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.6,"d":"60.00%"},{"v":160000,"d":"R160,000.00"}]
[null,"Switch, HL",null,"no.",1,{"v":34000,"d":"R34,000.00"},{"v":34000,"d":"R34,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Switch, LL",null,"no.",1,{"v":34000,"d":"R34,000.00"},{"v":34000,"d":"R34,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Switch Low",null,"no.",1,{"v":34000,"d":"R34,000.00"},{"v":34000,"d":"R34,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Switch, HL",null,"no.",1,{"v":34000,"d":"R34,000.00"},{"v":34000,"d":"R34,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Switch, LL",null,"no.",1,{"v":34000,"d":"R34,000.00"},{"v":34000,"d":"R34,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Switch Low",null,"no.",1,{"v":34000,"d":"R34,000.00"},{"v":34000,"d":"R34,000.00"},{"v":0.6,"d":"60.00%"},{"v":14000,"d":"R14,000.00"}]
[null,"Meter, 6\", HFO, M1, 500m3/H, Mass Flow Meter",6,"inch",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.6,"d":"60.00%"},{"v":160000,"d":"R160,000.00"}]
[null,"Meter, 6\", HFO, M2, 500m3/H, Mass Flow Meter",6,"inch",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.6,"d":"60.00%"},{"v":160000,"d":"R160,000.00"}]
[null,"Emergency stop button",null,"no.",11,{"v":4000,"d":"R4,000.00"},{"v":44000,"d":"R44,000.00"},{"v":0.6,"d":"60.00%"},{"v":18000,"d":"R18,000.00"}]
[null,"Emergency Genset, 27.5kVa, 380V, IP22",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Meter",null,"no.",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.3,"d":"30.00%"},{"$f":"G39*(1-H39)","v":{"v":280000,"d":"R280,000.00"}}]
[null,"Meter",null,"no.",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.3,"d":"30.00%"},{"$f":"G40*(1-H40)","v":{"v":280000,"d":"R280,000.00"}}]
[null,"Meter",null,"no.",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.3,"d":"30.00%"},{"v":280000,"d":"R280,000.00"}]
[null,"Meter",null,"no.",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"},{"v":0.3,"d":"30.00%"},{"v":280000,"d":"R280,000.00"}]
[null,"PLC",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Transmitter, pressure",null,"no.",15,{"v":35000,"d":"R35,000.00"},{"v":525000,"d":"R525,000.00"},{"v":0.6,"d":"60.00%"},{"v":210000,"d":"R210,000.00"}]
[null,"Transmitter, temperature",null,"no.",15,{"v":35000,"d":"R35,000.00"},{"v":525000,"d":"R525,000.00"},{"v":0.6,"d":"60.00%"},{"v":210000,"d":"R210,000.00"}]
[null,"Fence, electric",null,"m",780,{"v":192.82,"d":"R192.82"},{"v":150399.6,"d":"R150,399.60"},{"v":0.7,"d":"70.00%"},{"v":46000,"d":"R46,000.00"}]
[null,"Lighting, Security",null,"no.",20,{"v":2000,"d":"R2,000.00"},{"v":40000,"d":"R40,000.00"},{"v":0.5,"d":"50.00%"},{"v":20000,"d":"R20,000.00"}]
[null,"Alarm, High Level",null,"no.",1,{"v":20000,"d":"R20,000.00"},{"v":20000,"d":"R20,000.00"},{"v":0.5,"d":"50.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Alarm, Low Level",null,"no.",1,{"v":20000,"d":"R20,000.00"},{"v":20000,"d":"R20,000.00"},{"v":0.5,"d":"50.00%"},{"v":10000,"d":"R10,000.00"}]
[null,"Control Panel, Boiler",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Control Panel, Boiler",null,"no.",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Transformer, 11kV, oil cap. 232l",null,"no.",2,{"v":450000,"d":"R450,000.00"},{"v":900000,"d":"R900,000.00"},{"v":0.6,"d":"60.00%"},{"v":360000,"d":"R360,000.00"}]
[null,"PC, CPU Screen Keyboard & Mouse/ Printer",null,"no.",1,{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":0.7,"d":"70.00%"},{"v":15000,"d":"R15,000.00"}]
[null,"RMU",null,"no.",1,{"v":500000,"d":"R500,000.00"},{"v":500000,"d":"R500,000.00"},{"v":0.7,"d":"70.00%"},{"v":150000,"d":"R150,000.00"}]
[null,"MCC",null,"no.",1,{"v":500000,"d":"R500,000.00"},{"v":500000,"d":"R500,000.00"},{"v":0.7,"d":"70.00%"},{"v":150000,"d":"R150,000.00"}]
[]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I4:I55)","v":{"v":4124000,"d":"R4,124,000.00"}}]

{"sheet":"Civils","index":7,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8]]}
[]
[null,"Civils"]
[null,"Description","Size","Unit","Qty","Rate","Replacement Cost","Depreciation","Value"]
[null,"Bund wall, earth, 358m2",179,"m",1,{"v":2340,"d":"R2,340.00"},{"v":418860,"d":"R418,860.00"},{"v":0.5,"d":"50.00%"},{"v":210000,"d":"R210,000.00"}]
[null,"Bund, brick, 50.4m2",458,"m",1,{"v":92.4,"d":"R92.40"},{"v":42336,"d":"R42,336.00"},{"v":0.5,"d":"50.00%"},{"v":22000,"d":"R22,000.00"}]
[null,"Drainage channel, brick, 170m",170,"m",1,{"v":1293.6,"d":"R1,293.60"},{"v":219912,"d":"R219,912.00"},{"v":0.5,"d":"50.00%"},{"v":110000,"d":"R110,000.00"}]
[null,"Pump slab, Concrete, 386m2",386,"m²",1,{"v":750,"d":"R750.00"},{"v":289500,"d":"R289,500.00"},{"v":0.5,"d":"50.00%"},{"v":145000,"d":"R145,000.00"}]
[null,"Roadway, concrete, 689m2",689,"m²",1,{"v":1000,"d":"R1,000.00"},{"v":689000,"d":"R689,000.00"},{"v":0.5,"d":"50.00%"},{"v":345000,"d":"R345,000.00"}]
[null,"Roadway, paved, 800m2",800,"m²",1,{"v":720,"d":"R720.00"},{"v":576000,"d":"R576,000.00"},{"v":0.5,"d":"50.00%"},{"v":288000,"d":"R288,000.00"}]
[null,"Hardstanding, paved, 436m2",436,"m²",1,{"v":720,"d":"R720.00"},{"v":313920,"d":"R313,920.00"},{"v":0.5,"d":"50.00%"},{"v":157000,"d":"R157,000.00"}]
[null,"Hardstanding, concrete, ",83,"m²",1,{"v":720,"d":"R720.00"},{"v":59760,"d":"R59,760.00"},{"v":0.5,"d":"50.00%"},{"v":30000,"d":"R30,000.00"}]
[null,"82.49m2"]
[null,"Stormwater Drainage",195,"m",1,{"v":1050,"d":"R1,050.00"},{"v":204750,"d":"R204,750.00"},{"v":0.7,"d":"70.00%"},{"v":62000,"d":"R62,000.00"}]
[null,"Fence, barbed wire",780,"m",780,{"v":650,"d":"R650.00"},{"v":507000,"d":"R507,000.00"},{"v":0.7,"d":"70.00%"},{"v":153000,"d":"R153,000.00"}]
[null,"Fence, wire",780,"m",780,{"v":600,"d":"R600.00"},{"v":468000,"d":"R468,000.00"},{"v":0.7,"d":"70.00%"},{"v":141000,"d":"R141,000.00"}]
[null,"Separator, 3x6x2m deep",36,"m3",2,{"v":3500,"d":"R3,500.00"},{"v":252000,"d":"R252,000.00"},{"v":0.7,"d":"70.00%"},{"v":76000,"d":"R76,000.00"}]
[null,"Bund floor (Earth bund wall with concrete cap- 5m x 285m) ",{"v":5923,"d":"5,923.00"},"m²",1,{"v":400,"d":"R400.00"},{"v":2369200,"d":"R2,369,200.00"},{"v":0.5,"d":"50.00%"},{"v":1185000,"d":"R1,185,000.00"}]
[null,"Miscellaneous Pipe Supports ",12,"m3",1,null,{"v":200000,"d":"R200,000.00"},{"v":0.6,"d":"60.00%"},{"v":80000,"d":"R80,000.00"}]
[null,"Bund floor (Earth bund wall with concrete cap- 6m x 354m)",{"v":4329,"d":"4,329.00"},"m²",1,{"v":400,"d":"R400.00"},{"v":1731600,"d":"R1,731,600.00"},{"v":0.5,"d":"50.00%"},{"v":866000,"d":"R866,000.00"}]
[null,"Separator ",8,"m²",1,{"v":650000,"d":"R650,000.00"},{"v":650000,"d":"R650,000.00"},{"v":0.6,"d":"60.00%"},{"v":260000,"d":"R260,000.00"}]
[null,"Treatment Plant ",58,"m²",1,{"v":850000,"d":"R850,000.00"},{"v":850000,"d":"R850,000.00"},{"v":0.6,"d":"60.00%"},{"v":340000,"d":"R340,000.00"}]
[null,"Fire Water Reservoir",{"v":1000,"d":"1,000.00"},"m3",1,{"v":1500,"d":"R1,500.00"},{"v":1500000,"d":"R1,500,000.00"},{"v":0.5,"d":"50.00%"},{"v":750000,"d":"R750,000.00"}]
[null,"Bund interconnection",null,null,1,{"v":2100000,"d":"R2,100,000.00"},{"$f":"E23*F23","v":{"v":2100000,"d":"R2,100,000.00"}},{"v":0.3,"d":"30.00%"},{"$f":"G23*(1-H23)","v":{"v":1470000,"d":"R1,470,000.00"}}]
[]
[]
[{"$nulls":7},"Total",{"$f":"SUM(I4:I23)","v":{"v":6690000,"d":"R6,690,000.00"}}]