{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cost Breakdown"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Cost Breakdown","index":0,"n_rows":46,"n_cols":11,"rows_kept":46,"merged":[[5,8,11,8],[5,9,11,9],[5,10,11,10],[26,1,26,6],[27,1,27,6],[28,1,28,6],[35,2,35,6]]}
[]
[null,"Commercial  Bid Breakdown Pricing and bill of quantities "]
[]
[]
[null,"Item No ","Manpower","QTY","Unit ","Rate /Hired Equipment (24 Hours) ","Normal of days per Year","Total Per line items ","Total Cost - Compressor Hire Services -  Year One","Total Cost - Compressor Hire Services  -  Year Two","Total Cost - Compressor Hire Services  -  Year Three"]
[]
[null,1,"Compressors"]
[]
[null,"1.1","D260 CFM",5,"Rate/Hired Equipment",null,{"$f":"20*12","v":240},{"$f":"(+F9*G9*D9)","v":{"v":0,"d":"R0.00"}}]
[null,"1.2","D400 CFM",2,"Rate/Hired Equipment",null,200,{"$f":"(+F10*G10*D10)","v":{"v":0,"d":"R0.00"}}]
[null,"1.3","D800 CFM",3,"Rate/Hired Equipment",null,50,{"v":0,"d":"R0.00"}]
[null,"1.4","LMT (Large Moisture Trap )  over 400 CFM to 1200CFM",3,"Rate/Hired Equipment",null,200,{"v":0,"d":"R0.00"}]
[null,"1.5","OIM( Oil injcted manifold -3/4 x6 puls 2 x 2 Outlet",1,"Rate/Hired Equipment",null,{"$f":"20*12","v":240},{"v":0,"d":"R0.00"}]
[null,"1.6","H952 CFM/25 Bar (Oil Injected Compressor -Diesel - H952 cfm/25 Bar High Pressure",1,"Rate/Hired Equipment",null,100,{"v":0,"d":"R0.00"}]
[null,"1.7","XH 2 Inch /LF (Hoses - 2 Inc Oroflex X 15 m Layflat Hose",1,"Rate/Hired Equipment",null,100,{"v":0,"d":"R0.00"}]
[null,"1.8","OFH 2 Inch (Oil free Hoses - 2Inch x 5m HhIGH Press Layflat Hose",6,"Rate/Hired Equipment",null,100,{"v":0,"d":"R0.00"}]
[null,null,"Total on Compressor Hire ",{"$nulls":4},{"$f":"SUM(H9:H16)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,2,"Mobilisation & Demolisation of equipment   - Return Trip"]
[null,"2.1","Truck ( 0 -16 km) per load",1,"Per Load",null,200,{"$f":"+G21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"2.2","Truck (17km and over ) per load per kilometer",1,"Per Load",null,500,{"v":0,"d":"R0.00"}]
[null,"2.3","Bakkie ( 0 -16 km) per load",1,"Per Load",null,200,{"v":0,"d":"R0.00"}]
[null,"2.4","Bakkie (17km and over ) per load per kilometer",1,"Per Load",null,500,{"v":0,"d":"R0.00"}]
[null,null,"Mobilisation & Demolisation of equipment   - Return Trip",{"$nulls":4},{"$f":"SUM(H21:H24)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"SUBTOTAL ",{"$nulls":5},{"$f":"H25+H17","v":{"v":0,"d":"R0.00"}}]
[null,"VAT ",{"$nulls":5},{"$f":"+H27*0.15","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL CONTRACT AMOUNT INCL VAT  ",{"$nulls":5},{"$f":"+H27+H28","v":{"v":0,"d":"R0.00"}},{"$f":"H29","v":{"v":0,"d":"R0.00"}},{"$f":"I29*1.06","v":{"v":0,"d":"R0.00"}},{"$f":"J29*1.06","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,null,"NOTE: The calculation of this contract value is for internal "]
[null,null,"contract mangement purposes only. This amount is not a "]
[null,null,"guarantee of allocated work and is by no means to be "]
[null,null,"considered an actual and definite value of the service."]
[null,null,"SANPC Refinery accepts no liability for the accuracy of the quantities and will not entertain any claims in this regard."]
{"$rows_empty":9}
[null,null,{"$error":"#VALUE!"}]