{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["BOq","maintenace","summary"],"read":"whole","date_system":"1900"}

{"sheet":"BOq","index":0,"n_rows":102,"n_cols":6,"rows_kept":102,"merged":[[2,4,58,4],[2,5,58,5],[4,1,5,1],[4,2,5,2],[4,3,5,3],[6,0,7,0],[8,2,9,2],[8,3,9,3],[10,0,11,0],[10,2,11,2],[10,3,11,3],[15,2,16,2],[15,3,16,3],[17,0,18,0],[17,2,18,2],[17,3,18,3],[20,0,21,0],[20,2,21,2],[20,3,21,3],[22,0,23,0],[22,2,23,2],[22,3,23,3],[26,0,27,0],[26,2,27,2],[26,3,27,3],[28,0,29,0],[28,2,29,2],[28,3,29,3],[31,0,32,0],[31,2,32,2],[31,3,32,3],[33,0,34,0],[33,2,34,2],[33,3,34,3],[36,0,37,0],[36,2,37,2],[36,3,37,3],[38,0,39,0],[38,2,39,2],[38,3,39,3],[42,0,43,0],[42,2,43,2],[42,3,43,3],[44,0,45,0],[44,2,45,2],[44,3,45,3],[48,0,49,0],[48,2,49,2],[48,3,49,3],[50,0,51,0],[50,2,51,2],[50,3,51,3],[53,0,54,0],[53,2,54,2],[53,3,54,3],[55,0,56,0],[55,2,56,2],[55,3,56,3],[59,0,59,4]]}
[]
["Item","Description","Unit","Qty","Rate","Cost"]
[1,"Bill No. 1"]
[null,"Compliance for electrical installation"]
[null,"NOMINATED/SELECTED CONTRACT AGREEMENT"]
[1.1]
[]
[null,"Compliance with Nominated/Selected Subcontract Agreement, GCC","Sum",1]
[]
[1.2,"COMPLIANCE WITH CONDITIONS OF CONTRACT INCLUDING"]
[]
[null,"Nett price for compliance with the Conditions of Contract, the"]
[null,"Nett price for compliance with the Conditions of Contract, the"]
[null,"Special Conditions of Contract, and various specifications, which"]
[null,"costs are not specifically covered elsewhere or by unit rates","Sum",1]
[]
[1.3,"SURETY/ INSURANCE"]
[]
[null,"Allow for the provision of a performance guarantee for the contract"]
[null,"value - refer to the main contract preliminaries attached","Sum",1]
[1.4]
[null,"SITE ESTABLISHMENT"]
[]
[null,"Allow for the electrical site establishment, all associated services"]
[null,"and for storage of plant, materials and equipment including protection"]
[null,"thereof","Sum",1]
[1.5]
[null,"TRANSPORT"]
[]
[null,"Provide and arrange for transport and off loading of all electrical"]
[null,"material and equipment to site as well as workmen and staff","Sum",1]
[1.6]
[null,"COMMISSIONING AND TESTING"]
[]
[null,"Supply all test equipment and labour for testing, commissioning and"]
[null,"and adjustment for all the sections of the installation.","Sum",1]
[1.7]
[null,"EXTRACTS FROM THE PRINCIPAL CONTRACTOR\\including the safety"]
[]
[null,"Allowance for any costs associated with the requirements of the"]
[null,"Principal Contract preliminaries which may affect the selected sub"]
[null,"contract.","Sum",1]
[{"v":1.8,"d":"1.80"}]
[null,"MAINTENANCE"]
[]
[null,"Allow for a maintenance period for 36 months for defects in equipment,"]
[null,"material and workmanship but wear and tear and normal maintenance"]
[null,"included. This will commence on the day of practical completion","Sum",1]
[1.9]
[null,"GUARANTEE PERIOD"]
[]
[null,"Allow for a guarantee period of 36 Months for all the installed equipment"]
[null,"This will commence on the day of practical completion","Sum",1]
[{"v":1.1,"d":"1.10"}]
[null,"SAFETY EQUIPMENT FOR WORKING AT HEIGHT INCLUDING STEEL SELF LOCK (@30m high)"]
[]
[null,"All other equipemts required for replacement of reeds lights at 30m high"]
[null,"Working at heigh procedures to be followed"]
[null,null,"Sum",1]
["TOTAL CARRIED FORWARD TO SUMMARY"]
[]
[]
[2,"Bill No 2"]
[]
[null,"Document No:"]
["Item No.","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"REPAIRS"]
[]
[2.1,"Replacement of damaged Electrical wires per reed light, connecting the light.","No.",197]
[]
[2.2,"Supply, delivery and install 2.5mm2 3core power cable from distribution board to the pole light.","m",300]
[]
[2.3,"Supply, delivery and install 2.5mm2 twin and earth cable","m",300]
[]
[2.4,"Replacement of faulty isolators/switches  and connectors in each light.","No.",197]
[]
[2.5,"Repair and maintenance of the main Electrical Distribution Board. ","No.",2]
[]
[2.6,"Supply and install new timer","No.",20]
[]
[2.7,"Install  missing steel cover plates ","No.",10]
[]
[{"v":2.8,"d":"2.80"},"Replace faulty earth leakages","No.",2]
[]
[{"v":2.9,"d":"2.90"},"Installation of custom Led reed light","No.",197]
[]
[null,"Provisional Sum"]
[]
[{"v":2.1,"d":"2.10"},"Supply, delivery of Custom made LED for reed light","Sum",1,800000,{"$f":"E89*D89","v":{"v":800000,"d":"R800,000.00"}}]
[]
[2.11,"Allow for profit and attendance","%"]
[]
[2.12,"Allow for crane/Cherry picker to provide access including establishement and de-establishement.","Sum",1,150000,{"$f":"E93*D93","v":{"v":150000,"d":"R150,000.00"}}]
[]
[2.13,"Allow for profit and attendance","%"]
[]
[null,"SUB-TOTAL FOR MATERIALS AND LABOUR COSTS",{"$nulls":3},"R"]
[]
[null,"Value Added Tax"]
[2.14,"Value added Tax @ 15%","%"]
[]
[null,"TOTAL AMOUNT INCLUSIVE OF VAT",{"$nulls":3},"R"]

{"sheet":"maintenace","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[15,0,15,4]]}
[]
["3.","MATERIAL AND SERVICE COSTS"," "," ",null," "]
[" "," "," "," ",null," "]
["A","All local produced materials should be SABS approved."," "," ",null," "]
["A1.","Contigencies","Sum",1,{"v":150000,"d":"R150,000.00"},{"v":150000,"d":"R150,000.00"}]
["A2.","Major service cost","Item",3,"R ","R "]
["A3","Minor service costs","monthly",36,"R ","R "]
[]
[" ","LABOUR COSTS (as when required)"," "," "]
["B ","Artisans ","p/h "," ","R ","R "]
["C ","Labourers ","p/h "," ","R ","R "]
[" ","Call Rate:  Working hours ","p/c",1,"R ","R "]
[" ","Call Rate:  After hours Total (including Saturday and Sunday)","p/c",1,"R ","R "]
[]
[null,"*please indicate the total labours and artisans on the quantity column for \" as when required\""]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":4},"R"]

{"sheet":"summary","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[11,0,12,0],[13,0,14,0]]}
[]
[null,"Bill Of Quantities - Summary Page"]
["Bill No.","Description","Total Amount"]
[]
[1,"Compliance for electrical installation","R"]
[]
[2,"Repairs","R"]
[]
[3,"Maintenace"]
[]
[null,"Sub-Total","R"]
[]
[null,"Add 15% V.A.T","R"]
[]
[null,"TOTAL","R"]