{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BOQ","Sheet1"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"BOQ","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"merged":[[0,1,0,5],[26,0,26,1]]}
[null,"INSTALLATION OF A BACKUP POWER SYSTEM FOR HAARTEBEESHOEK AND WILDERBEESFONTEIN DOSING STATIONS WHICH ARE BEING AFFECTED BY LOADSHEDDING"]
[]
[]
["ITEM NO.","ITEM DESCRIPTION","UNIT","QTY","RATE (R) ","AMOUNT(R) "]
[]
[1,"SUPPLY 5KW SMART  INVERTER","EA",4]
[{"$f":"A6+1","v":2},"SUPPLY 5.2KW LITHIUM BATTERY","EA",6]
[{"$f":"A7+1","v":3},"SUPPLY 555W MONO SOLAR PANELS","EA",10]
[4,"SUPPLY GROCOL CABLE PACK","EA",8]
[5,"SUPPLY PV MOUNTING STRUCTURE-SECURED","EA",2]
[6,"SUPPLY 25MM BATTERY CABLE","EA",6]
[7,"SUPPLY 160A BATTERY FUSE HOLDER","EA",6]
[8,"SUPPLY 160A FUSES","EA",20]
[9,"SUPPLY 25X8MM LUGS","EA",8]
[10,"6MM PV WIRE-RED","EA",40]
[11,"6MM PV WIRE-BLACK","EA",40]
[12,"SUPPLY 10MM EARTH WIRE","EA",20]
[13,"SUPPLY 4MM TWIN AND EARTH CABLE","EA",40]
[14,"SUPPLY TRUNKING AND ACCESSORIES ","EA",2]
[15,"SUPPLY COMBINER BOX","EA",6]
[16,"SUPPLY AC BOARD C/W CHANGEOVER SWITCH AND SURGE PROTECTION","EA",6]
[17,"SUPPLY MC4 CONNECTORS","EA",8]
[18,"SUPPLY AND CONFIGURE FLEXY EWON 205","EA",2]
[19,"INSTALLATION","EA",2]
[20,"COC","EA",2]
[]
["TOTAL AMOUNT, Excluding 15% VAT"]
[]
[]
[null,"SUMMARY OF SCHEDULES"]
[]
[null,"ITEM DESCRIPTION",null,null,"Amount"]
[null,"TOTAL, Excl. VAT",null,null,"R "]
[null,"VAT (15%)",null,null,"R "]
[null,"TOTAL, Incl. VAT",null,null,"R"]

{"sheet":"Sheet1","index":1,"n_rows":73,"n_cols":7,"rows_kept":73,"merged":[[30,0,30,5],[47,0,47,4],[60,0,60,4]]}
[]
[null,null,"SUPPLY AND INSTALL LIGHTING SYSTEM FOR BWD RESERVOIR GUARD HOUSES"]
[]
[]
[]
[null,"SCHEDULE  1: PRELIMINARY AND GENERAL","SUPPLY AND INSTALL LIGHTING SYSTEM FOR BWD RESERVOIR GUARD HOUSES"]
[]
["ITEM NO.","PAYMENT REF.","ITEM DESCRIPTION","UNIT","QTY","RATE (R) ","AMOUNT(R) "]
[1,null,"SUPPLY AND INSTALL LIGHTING SYSTEM FOR BWD RESERVOIR GUARD HOUSES"]
[]
[1.1,null,"SUPPLY 5KW SMART  INVERTER","EA",7]
[1.2,null,"SUPPLY 5.2KW LITHIUM BATTERY","EA",7]
[1.3,null,"SUPPLY 555W MONO SOLAR PANELS","EA",35]
[1.4,null,"SUPPLY GROCOL CABLE PACK","EA",7]
[1.5,null,"SUPPLY PV MOUNTING STRUCTURE-SECURED","EA",7]
[1.6,null,"SUPPLY 25MM BATTERY CABLE","EA",14]
[1.7,null,"SUPPLY 160A BATTERY FUSE HOLDER","EA",7]
["1.8",null,"SUPPLY 160A FUSES","EA",14]
[1.9,null,"SUPPLY 25X8MM LUGS","EA",28]
[1.1,null,"6MM PV WIRE-RED","EA",105]
[1.11,null,"6MM PV WIRE-BLACK","EA",105]
[1.12,null,"SUPPLY 10MM EARTH WIRE","EA",70]
[1.13,null,"SUPPLY 4MM TWIN AND EARTH CABLE","EA",70]
[1.14,null,"SUPPLY TRUNKING AND ACCESSORIES ","EA",7]
[1.15,null,"SUPPLY COMBINER BOX","EA",7]
[1.16,null,"SUPPLY AC BOARD C/W CHANGEOVER SWITCH AND SURGE PROTECTION","EA",7]
[1.17,null,"SUPPLY MC4 CONNECTORS","EA",7]
[1.18,null,"SUPPLY PANEL HEATERS","EA",7]
[null,null,"INSTALLATION","EA",7]
[1.18,null,"COC","EA",7]
["TOTAL AMOUNT, Excluding 15% VAT"]
[]
[]
[{"$f":"A34:J42","v":0}]
["                                               "]
["ITEM NO.","PAYMENT REF.","ITEM DESCRIPTION","UNIT","QTY","RATE (R) ","AMOUNT(R) "]
[2.1]
[2.2]
[2.3]
[2.4]
[2.5]
[2.6]
[2.7]
[2.8]
[]
[]
[]
["TOTAL, Excluding 15% VAT"]
[]
[]
[]
["ITEM NO.","PAYMENT REF.","ITEM DESCRIPTION","UNIT","QTY","RATE (R) ","AMOUNT(R) "]
[]
[3.1]
[3.2]
[3.3]
[3.4]
[]
[3.5]
[]
["TOTAL, Excluding 15% VAT"]
[]
["                             "]
[]
[]
[]
[null,null,"SUMMARY OF SCHEDULES"]
[]
[null,null,"ITEM DESCRIPTION",null,null,"Amount"]
[null,null,"Schedule 1",null,null,"R "]
[null,null,"TOTAL, Excl. VAT",null,null,"R "]
[null,null,"VAT (15%)",null,null,"R "]
[null,null,"TOTAL, Incl. VAT",null,null,"R"]