{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["COVER","PRELIMINARIES","AIR CONDITIONING","ESKOM AIR-CON SCHEDULE","FINAL SUMMARY","NEC3 CONTRACT"],"not_rendered":{"images":40,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"COVER","index":0,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[2,8,2,11],[18,1,18,11],[27,8,27,9],[40,8,40,10]]}
[]
[]
[{"$nulls":8},"TRANSMISSION FACILITIES"]
{"$rows_empty":15}
[null,"*Where the word \"Bill Of Quantities\" is used it shall mean Price Schedule"]
[]
[]
[null,"CONTRACT NUMBER",{"$nulls":5},": "]
[]
[]
[null,"CONTRACTOR",{"$nulls":5},":"]
[]
[]
[null,"CONTRACT AMOUNT ",{"$nulls":5},":","Not applicable"]
[null,"(Excluding VAT)",{"$nulls":6},"(Contract is rates based)"]
[]
[]
[null,"AUTHORISED SIGNATORY NAME",{"$nulls":5},":"]
[]
[]
[null,"DESIGNATION",{"$nulls":5},":","SERVICE MANAGER"]
[]
[]
[null,"AUTHORISED SIGNATURE",{"$nulls":5},":"]
[]
[]
[null,"DATE",{"$nulls":5},":"]

{"sheet":"PRELIMINARIES","index":1,"n_rows":125,"n_cols":6,"rows_kept":125}
["ITEM NO","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[]
[null,"SECTION NO. 1 "]
[null,"BILL NO. 1"]
[]
[null,"PRELIMINARIES AND GENERAL"]
[]
[null,"The following items should be priced under preliminaries and generals"]
[]
[]
["1.","Protective Clothing"]
[null,"Protective clothing for the duration of the a year. (issued once a year)"]
[]
[1.1,"Supply of PPE requirements.","Sum",1,null,{"$f":"D15*E15","v":{"v":0,"d":"0.00"}}]
[]
["2.","Medical tests for employees for the duration of the contract."]
[]
[2.1,"Entrance medical test.","Per person",1,null,{"$f":"D19*E19","v":{"v":0,"d":"0.00"}}]
[2.2,"periodic medical test","Per person",1,null,{"$f":"D20*E20","v":{"v":0,"d":"0.00"}}]
[2.3,"Exit medical test.","Per person",1,null,{"$f":"D21*E21","v":{"v":0,"d":"0.00"}}]
[]
["3.","Project requirements and Contractual obligation."]
[]
[3.1,"Compiling , submission and management and maintenance of safety file.","Sum",1,null,{"$f":"D25*E25","v":{"v":0,"d":"0.00"}}]
[3.2,"Eskom to allow provisional sum for equipments and plant ( e.g Scaffolding, Cherry picker and etc. ) Provide  SCC sheet with a list of all plant and their estimated costs.","Sum",1,0,{"$f":"D26*E26","v":{"v":0,"d":"0.00"}}]
[]
[null,"Total carried to Summary",{"$nulls":3},{"$f":"SUM(F15:F26)","v":{"v":0,"d":"0.00"}}]
[]
["Do not price for item 3.2."]
{"$rows_empty":94}
[{"$nulls":4},"R"]

{"sheet":"AIR CONDITIONING","index":2,"n_rows":49,"n_cols":6,"rows_kept":49}
["Item",null,"Unit","Quantity","Rate ","Amount"]
[null,"SECTION NO: 2 AIR CONDITIONING"]
[null,"BILL NO 2"]
[]
[1,"Work to be done from Monday to Friday between 7:30am and 4pm:"]
[]
[1.1,"Project coordinator/ Senior supervisor","Hr",1,null,{"$f":"D7*E7","v":0}]
[]
[1.2,"Mechanical Artisan","Hr",1,null,{"$f":"D9*E9","v":0}]
[]
[1.3,"Semi-skilled worker","Hr",1,null,{"$f":"D11*E11","v":0}]
[]
[2,"Work to be done from Monday to Friday after 4pm:"]
[]
[2.1,"Project coordinator/ Senior supervisor","Hr",1,null,{"$f":"D15*E15","v":0}]
[]
[2.2,"Mechanical Artisan","Hr",1,null,{"$f":"D17*E17","v":0}]
[]
[2.3,"Semi-skilled worker","Hr",1,null,{"$f":"D19*E19","v":0}]
[]
["3","Work to be done on Saturdays between 7:30am and 4pm:"]
[]
[3.1,"Project coordinator/ Senior supervisor","Hr",1,null,{"$f":"D23*E23","v":0}]
[]
[3.2,"Mechanical Artisan","Hr",1,null,{"$f":"D25*E25","v":0}]
[]
[3.3,"Semi-skilled worker","Hr",1,null,{"$f":"E27*D27","v":0}]
[]
["4","Work to be done on Sunday and public holidays between 7:30am and 4pm:"]
[]
[4.1,"Project coordinator/ Senior supervisor","Hr",1,null,{"$f":"D31*E31","v":0}]
[]
[4.2,"Mechanical Artisan","Hr",1,null,{"$f":"D33*E33","v":0}]
[]
[4.3,"Semi-skilled worker","Hr",1,null,{"$f":"D35*E35","v":0}]
[]
["5","Materials"]
["5.1","Eskom to allow the Provisional Sum  for the supply of required material according to PM's instruction  of compressors, pc boards, fan motors, filters, contactors, overloads, circuit breakers, isolators, relays, copper piping, insulation, pump couplings, oil (compressors or pumps), fan belts, bearings, fuses, controllers, timers, PLC, plumbing fittings, humidifiers bottles, drain pumps and refrigerants and etc.","Sum",1,null,{"$f":"D38*E38","v":0}]
[]
["5.2","Mark up fee percentage ","%",{"v":1,"d":"1.00"}]
[]
["6","Transport"]
[]
[null,"Payment for transport/traveling will be paid in excess of a 50Km from site (Simmerpan)."]
[]
["6.1","Cost of transport/ travelling ","km",1,null,{"$f":"D46*E46","v":0}]
[]
[null,"Total carried to Summary",{"$nulls":3},{"$f":"SUM(F7:F46)","v":0}]
["Do not price item 5.1"]

{"sheet":"ESKOM AIR-CON SCHEDULE","index":3,"n_rows":571,"n_cols":9,"rows_kept":571,"hidden":true}
{"$rows_empty":51}
[{"$nulls":8},1]
{"$rows_empty":51}
[{"$nulls":8},2]
{"$rows_empty":51}
[{"$nulls":8},3]
{"$rows_empty":51}
[{"$nulls":8},4]
{"$rows_empty":51}
[{"$nulls":8},5]
{"$rows_empty":51}
[{"$nulls":8},6]
{"$rows_empty":51}
[{"$nulls":8},7]
{"$rows_empty":51}
[{"$nulls":8},8]
{"$rows_empty":51}
[{"$nulls":8},9]
{"$rows_empty":51}
[{"$nulls":8},10]
{"$rows_empty":50}
[{"$nulls":8},11]

{"sheet":"FINAL SUMMARY","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"merged":[[1,0,1,6],[2,0,2,6],[3,0,3,6],[5,0,5,6],[15,2,17,3],[26,0,27,6]]}
[]
["ESKOM HOLDINGS SOC LIMITED"]
["PRICING SCHEDULE FOR THE HVAC MAINTENANCE OF SIMMERPAN COMPLEX INCLUDING SURROUNDING AREAS"]
[]
[]
["FINAL SUMMARY"]
[]
[]
[null,"Bill No.",null,null,"Page",null,"Amount"]
[]
[null,1,"PRELIMINARIES AND GENERALS",null,"1: 1","R",{"$f":"PRELIMINARIES!F28","v":{"v":0,"d":"0.00"}}]
[]
[null,2,"HVAC",null,"2: 1-2","R",{"$f":"'AIR CONDITIONING'!F48","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Sub-Total",null,null,"R",{"$f":"SUM(G10:G14)","v":{"v":0,"d":"0.00"}}]
[null,null,"Allow 5% Contingencies on the above total to be used at the discretion of the Contracts Manager and deducted in part if so required."]
[{"$nulls":5},"R",{"$f":"G15*0.05","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Sub-Total",null,null,"R",{"$f":"+G15+G17","v":{"v":0,"d":"0.00"}}]
[null,null,"ADD:"]
[null,null,"14% VAT",null,null,"R",{"$f":"G19*0.14","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"TOTAL CARRIED TO FORM OF OFFER ",null,null,"R",{"$f":"+G19+G21","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["This schedule provides a summary of the total value of all the sections and remains the responsibility of the contractor to ensure the accuracy of the amount carried to the summary."]

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