{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Measure","Bill 1","Bill 2","Bill 3","Bill 4","Bill 5","Summary"],"not_rendered":{"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Measure","index":0,"n_rows":79,"n_cols":48,"rows_kept":79,"hidden":true,"merged":[[0,1,0,10],[0,11,0,20],[0,21,0,31],[0,32,0,40],[13,16,13,21],[13,22,13,23],[13,34,13,38]]}
[null,"SWA Cable",{"$nulls":9},"Terminations",{"$nulls":9},"BCEW",{"$nulls":10},"BCEW Terminations "]
[null,"150mm2, 4 core","70mm2, 3 core ","50mm2, 4 core","35mm2, 4 core ","16mm2, 4 core ","10mm2, 4 core ","6mm2, 4 core ","4mm2, 4 core","4mm2, 3 core ","2,5mm2, 3 core ","150mm2, 4 core","70mm2, 3 core ","50mm2, 4 core","35mm2, 4 core ","16mm2, 4 core ","10mm2, 4 core ","6mm2, 4 core ","4mm2, 4core","4mm2, 3 core","2,5mm2, 3 core ","70mm2","50mm2",null,null,"35mm","25mm2","16mm2","10mm2","6mm2","4mm2","2,5mm2","70mm2","50mm2","35mm","25mm2","16mm2","10mm2","6mm2","4mm2","2,5mm2"]
{"$rows_empty":9}
["Total ",{"$f":"SUM(B3:B11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(Z3:Z11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":16},"House wire",{"$nulls":5},"Surfex",{"$nulls":11},"Isolators"]
[null,"1 way","2 way","3 way","4 way","2x4 ","4x4","WP SSO",null,null,"16A SSO","Light Switch","Industrial LS ","20mm Conduit","25mm Conduit","5A Unswitched","1.5mm2","2.5mm2",null,null,"4mm2","6mm2","2.5mm2, 4 core ","4mm2, 2 core","4mm2, 4 core","Type A","Type B","Type C","Type D","Type E","Type F",null,"Type L2","Type L","35A TP","20A TP","35A DP","63A TP","20A DP","Daylight switch",null,"Movement sensor 1 Chanel","Movement sensor 2 Chanel ","Trunking","16A SSO for trunking","16A DED. SSO for trunk. ","16A Dedicated SSO","3Ph SSO"]
["Area A "]
["DB-D"]
["EL8",null,1,2,null,3,{"$nulls":5},3,null,22,null,3,null,{"$f":"N18*4.5","v":99},{"$nulls":9},3]
["EL17",null,null,4,null,1,{"$nulls":5},1,null,15,{"$nulls":3},{"$f":"N19*4.5","v":67.5},{"$nulls":12},90,"m"]
["EL18",null,15,null,null,1,{"$nulls":5},1,null,60,null,15,null,{"$f":"N20*4.5","v":270}]
["P2",{"$nulls":5},4,{"$nulls":3},4,null,null,10,{"$nulls":6},{"$f":"N21*3.5","v":35}]
["Fire detection",null,8,2,{"$nulls":10},{"$f":"45*2","v":90}]
["TV Conduits",{"$nulls":13},20]
["Data Outlets",{"$nulls":5},5,{"$nulls":7},50]
[]
["Area B "]
["DB-DH"]
["EL9",null,8,null,null,1,{"$nulls":5},1,null,43,null,8,null,{"$f":"N28*4.5","v":193.5},{"$nulls":7},8]
["P4",{"$nulls":5},4,{"$nulls":3},4,null,null,48,{"$nulls":6},{"$f":"N29*3.5","v":168}]
["DB-D"]
["EL9",null,3,{"$nulls":10},25,null,3,null,{"$f":"N31*4.5","v":112.5},{"$nulls":10},3]
["Fire detection",null,5,{"$nulls":11},60]
["TV Conduits"]
["Data Outlets",{"$nulls":5},4,{"$nulls":7},{"$f":"4*55","v":220}]
[]
["Area C"]
["DB-D"]
["EL5",null,4,{"$nulls":10},40,null,1,null,{"$f":"N38*4.5","v":180},{"$nulls":10},4]
["P",{"$nulls":5},2,{"$nulls":3},2,null,null,20,{"$nulls":6},{"$f":"N39*3.5","v":70}]
["I11 to I13",null,3,{"$nulls":3},3,{"$nulls":6},{"$f":"30*3","v":90},{"$nulls":6},{"$f":"N40*3.5","v":315},{"$nulls":17},3]
["Fire detection"]
["TV Conduits"]
["Data Outlets",{"$nulls":5},5,{"$nulls":7},{"$f":"55*5","v":275}]
[]
["Area D"]
["DB-D"]
["P4",{"$nulls":5},8,{"$nulls":6},60,{"$nulls":3},{"$f":"N47*3.5","v":210},{"$nulls":28},8]
["L",null,null,4,{"$nulls":9},20,null,3,{"$f":"N48*4.5","v":90}]
[]
["Area D1"]
["DB-R10"]
["L1",null,9,null,null,1,{"$nulls":5},1,null,30,null,9,{"$f":"N52*4.5","v":135},{"$nulls":9},9]
["P1",{"$nulls":16},{"$f":"17*3.5","v":59.5},{"$nulls":25},17,4,2]
["AC1",{"$nulls":12},10,{"$nulls":3},{"$f":"N54*3.5","v":35},{"$nulls":20},1]
["AC2",{"$nulls":12},15,{"$nulls":3},{"$f":"N55*3.5","v":52.5},{"$nulls":20},1]
["DB-NW"]
["L1",null,2,null,null,1,{"$nulls":5},1,null,15,null,2,{"$f":"N57*4.5","v":67.5},{"$nulls":8},2]
["P1",{"$nulls":16},{"$f":"19*3.5","v":66.5},{"$nulls":25},19,3,6]
["AC1",{"$nulls":12},10,{"$nulls":3},{"$f":"N59*3.5","v":35},{"$nulls":20},1]
["DB-R11"]
["L1",null,2,null,null,1,{"$nulls":5},1,null,15,null,2,{"$f":"N61*4.5","v":67.5},{"$nulls":8},2]
["P1",{"$nulls":16},{"$f":"19*3.5","v":66.5},{"$nulls":25},19,3,6]
["AC1",{"$nulls":12},10,{"$nulls":3},{"$f":"N63*3.5","v":35},{"$nulls":20},1]
["Fire detection",null,4,{"$nulls":11},30]
["Data Outlets",{"$nulls":13},20]
[]
["Area E"]
["DB-CB"]
["L1",null,6,null,null,1,{"$nulls":5},1,null,18,null,6,{"$f":"N69*4.5","v":81},{"$nulls":9},9,null,null,6]
["P1",{"$nulls":5},2,{"$nulls":3},2,null,null,10,{"$nulls":3},{"$f":"N70*3.5","v":35}]
["P1",{"$nulls":5},2,{"$nulls":3},2,null,null,10,{"$nulls":3},{"$f":"N71*3.5","v":35}]
["DB"]
["L",null,46,null,null,1,{"$nulls":5},1,null,200,null,2,{"$f":"N73*4.5","v":900},{"$nulls":8},27,19]
["P",{"$nulls":16},{"$f":"19*3.5","v":66.5}]
["I",{"$nulls":5},4,{"$nulls":6},80,{"$nulls":3},{"$f":"N75*3.5","v":280}]
["Fire detection",null,6,{"$nulls":11},60]
["Data Outlets",{"$nulls":5},11,{"$nulls":7},{"$f":"11*45","v":495}]
[]
["TOTAL",{"$f":"SUM(B16:B78)","v":0},{"$f":"SUM(C18:C78)","v":122},{"$f":"SUM(D16:D78)","v":12},0,11,54,0,0,0,14,11,0,876,1320,54,1341,{"$f":"SUM(R17:R78)","v":1899},null,null,{"$f":"SUM(U16:U78)","v":588},0,0,0,0,39,37,3,7,6,90,null,{"$f":"SUM(AG16:AG78)","v":0},{"$f":"SUM(AH16:AH78)","v":0},{"$f":"SUM(AI16:AI78)","v":0},{"$f":"SUM(AJ16:AJ78)","v":0},{"$f":"SUM(AK16:AK78)","v":0},{"$f":"SUM(AL17:AL78)","v":0},{"$f":"SUM(AM16:AM78)","v":7},{"$f":"SUM(AN16:AN78)","v":0},null,{"$f":"SUM(AP16:AP78)","v":0},0,55,10,14,8,{"$f":"SUM(AV18:AV24)","v":0}]

{"sheet":"Bill 1","index":1,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[0,0,0,5]]}
["BILL NO. 1: PRELIMINARY AND GENERAL ITEMS "]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
[1.1,"Preliminary and General Items, pertaining specifically to the Electrical Installation."]
[]
["1.1.1.","Nett price for site establishment and compliance with the conditions of contract, including storage, insurance and other overheads.","Sum",1,0,{"$f":"D7*E7","v":0}]
[]
["1.1.2","Insurance and Guarantee","Sum",1,0,{"$f":"D9*E9","v":0}]
[]
["1.1.3","Nett price to comply with all the requirements of the Health & Safety specifications.","Sum",1,0,0]
[]
["1.1.4","Site supervision and reporting according to the Health and Safety Specifications.","Sum",1,0,0]
[]
["1.1.5","Nett price for provision of \"As Built\" drawings and            O & M Manuals, as per specification.","Sum",1,0,0]
[null," "," "," "]
["1.1.6","Supplying or hiring, erection & dismantling of complete mobile cranes, scissor jacks and cherry pickers, including access ladders, warning and safety signs as required for the installation for the duration of the contract. ","Sum",1,0,{"$f":"D17*E17","v":0}]
{"$rows_empty":28}
[null," TOTAL FOR BILL NO. 1:  PRELIMINARY AND GENERAL ITEMS",{"$nulls":3},{"$f":"SUM(F4:F45)","v":0}]
[null,"(CARRIED TO FINAL SUMMARY)"]

{"sheet":"Bill 2","index":2,"n_rows":54,"n_cols":6,"rows_kept":54}
["BILL NO. 2 : SITEWORKS AND SUPERVISION"]
[]
["Item","Description ","Unit","Qty","Rate","   Amount"]
[]
["1."," Liaison with Main Contractor and for attendance for"]
[null," the checking of Builders' and Subcontractors' work"]
[null," pertaining to the Electrical Installation","Sum",1,0,{"$f":"D7*E7","v":0}]
[]
[2," Galvanised draw-wire in all sleeves"]
[]
["2.1"," Supply","m",0,0,{"$f":"D11*E11","v":0}]
[]
["2.2"," Install","m",{"$f":"D11","v":0},0,{"$f":"D13*E13","v":0}]
[]
["3."," Cable Sleeves P.V.C."]
[null," "]
["3.1"," Supply (by others)"]
[null," "]
[null," 50 mm diameter","m",0,0,{"$f":"D19*E19","v":0}]
[]
[null," 50 mm diameter slow bends","No",0,0,{"$f":"D21*E21","v":0}]
[]
["3.2"," Install"]
[null," "]
[null," 50 mm diameter ","No",{"$f":"D19","v":0},0,{"$f":"D25*E25","v":0}]
[]
[null," 50 mm diameter slow bends","No",{"$f":"D21","v":0},0,{"$f":"D27*E27","v":0}]
[]
["4.","Stripping out of existing electrical installation and handing over of equipment to the Client.","Sum",1,0,{"$f":"D29*E29","v":0}]
{"$rows_empty":22}
[null," TOTAL FOR BILL NO. 2 : SITEWORKS AND SUPERVISION"]
[null,"(CARRIED FORWARD TO FINAL SUMMARY)",{"$nulls":3},{"$f":"SUM(F4:F51)","v":0}]
[null," ",{"$nulls":3}," "]

{"sheet":"Bill 3","index":3,"n_rows":150,"n_cols":6,"rows_kept":150}
["BILL NO.  3:  LV RETICULATION "]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[1,"Supply and install in position the following normal distribution boards, complete with trays, labels and conduit terminations as required by the number and type of circuits (minimum one conduit per circuit) along with at least six spare "]
[null,"Distribution Board DB - R10. Refer to drawing P8081E01-005"]
[null," "]
["1.1","Supply","Sum",1,0,{"$f":"D7*E7","v":0}]
[]
["1.2","Install","Sum",1,0,{"$f":"D9*E9","v":0}]
[]
[null,"Distribution Board DB - R11. Refer to drawing P8081E01-005"]
[null," "]
["1.3","Supply","Sum",1,0,{"$f":"D13*E13","v":0}]
[]
["1.4","Install","Sum",1,0,{"$f":"D15*E15","v":0}]
[]
[null,"Distribution Board DB - NW. Refer to drawing P8081E01-005"]
[null," "]
["1.3","Supply","Sum",1,0,{"$f":"D19*E19","v":0}]
[]
["1.4","Install","Sum",1,0,{"$f":"D21*E21","v":0}]
[]
[null,"Distribution Board DB - CB. Refer to drawing P8081E01-006"]
[null," "]
["1.5","Supply","Sum",1,0,{"$f":"D25*E25","v":0}]
[]
["1.6","Install","Sum",1,0,{"$f":"D27*E27","v":0}]
[]
[null,"Distribution Board DB - HVAC"]
[null," "]
["1.7","Supply","Sum",1,0,{"$f":"D31*E31","v":0}]
[]
["1.8","Install","Sum",1,0,{"$f":"D33*E33","v":0}]
[]
["1.9","Provisional sum for changes required on exising DB's (Add indicated value in amount column)","sum",1,{"v":10000,"d":"10,000.00"}]
[]
["1.10","Profit and attendance on Item 1.9 (Indicate percentage and value in amount column)","%"]
{"$rows_empty":8}
[" ","AMOUNT CARRIED FORWARD"," ",null,null,{"$f":"SUM(F4:F45)","v":0}]
[]
[2,"Cables",null," "]
[null,"Supply, deliver, install, connect and commission the following 600/1 000V copper cables as specified:"]
[null," "]
[null,"Type PVC/SWA/PVC:"]
[]
[null,"150mm², 4-core ECC"]
[]
["2.1","Supply","m",43,0,{"$f":"D55*E55","v":0}]
[]
["2.2","Install","m",{"$f":"D55","v":43},0,{"$f":"D57*E57","v":0}]
[]
[null,"120mm², 4-core ECC"]
[]
["2.3","Supply","m",40,0,{"$f":"D61*E61","v":0}]
[]
["2.4","Install","m",{"$f":"D61","v":40},0,{"$f":"D63*E63","v":0}]
[]
[null,"25mm², 4-core ECC"]
[]
["2.5","Supply","m",{"$f":"4*15","v":60},0,{"$f":"D67*E67","v":0}]
[]
["2.6","Install","m",{"$f":"D67","v":60},0,{"$f":"D69*E69","v":0}]
[]
[null,"10mm², 4-core ECC"]
[]
["2.7","Supply","m",30,0,{"$f":"D73*E73","v":0}]
[]
["2.8","Install","m",{"$f":"D73","v":30},0,{"$f":"D75*E75","v":0}]
[]
[null,"150mm², 4-core ECC"]
[]
["2.9","Relocation of exisitng cable","m",21,0,{"$f":"D79*E79","v":0}]
[]
[3,"Cable terminations and Joints"]
[]
[null,"For PVC/SWA/PVC cables, including armour glands, shrouds, lugs, connections, insulation tape, cadmium plated bolts, nuts, spring-washers, etc."]
[]
[null,"Terminations "]
["2.9","Rolacation of exisitng cable","m"]
[null,"150mm², 4-core:"]
[]
["3.1","Supply","No",null,0,{"$f":"D89*E89","v":0}]
[]
["3.2","Install","No",{"$f":"D89","v":0},0,{"$f":"D91*E91","v":0}]
[]
[]
[]
[" ","AMOUNT CARRIED FORWARD"," ",null,null,{"$f":"SUM(F47:F94)","v":0}]
[]
[null,"120mm², 4-core:"]
[]
["3.3","Supply","No",2,0,{"$f":"D99*E99","v":0}]
[]
["3.4","Install","No",{"$f":"D99","v":2},0,{"$f":"D101*E101","v":0}]
[]
[null,"25mm², 4-core: "]
[]
["3.5","Supply","No",{"$f":"4*2","v":8},0,{"$f":"D105*E105","v":0}]
[]
["3.6","Install","No",{"$f":"D105","v":8},0,{"$f":"D107*E107","v":0}]
[]
[null,"10mm², 4-core:"]
[]
["3.7","Supply","No",2,0,{"$f":"D111*E111","v":0}]
[]
["3.8","Install","No",{"$f":"D111","v":2},0,{"$f":"D113*E113","v":0}]
[]
[null,"Joints"]
[]
[null,"150mm², 4-core:"]
[]
["3.9","Supply","No",2,0,{"$f":"D119*E119","v":0}]
[]
["3.10","Install","No",{"$f":"D119","v":2},0,{"$f":"D121*E121","v":0}]
[]
[4,"Earthing installation"]
[]
[",4.1","Bonding of taps and hand wash basins","Sum",1,0,{"$f":"D125*E125","v":0}]
[" "," "," "," "]
["4.2","Bonding of gutters and down pipes","Sum",1,0,0]
[]
["4.3","Earthing continuity tests","Sum",1,0,0]
[]
[null,"TOTAL PAGE  3",{"$nulls":3},{"$f":"SUM(F96:F130)","v":0}]
[]
[null," SUMMARY FOR BILL NO.  3"]
[]
[null," PAGE"]
[null," "]
[null,1,{"$nulls":3},{"$f":"F46","v":0}]
[]
[null,2,{"$nulls":3},{"$f":"F95","v":0}]
[]
[null,3,{"$nulls":3},{"$f":"F131","v":0}]
{"$rows_empty":7}
[null,"TOTAL FOR BILL NO. 3: LV RETICULATION",{"$nulls":3},{"$f":"SUM(F134:F148)","v":0}]
[" ","(CARRIED FORWARD TO FINAL SUMMARY)"]

{"sheet":"Bill 4","index":4,"n_rows":542,"n_cols":7,"rows_kept":542}
[" BILL NO.  4  :  GENERAL ELECTRICAL "]
[{"$nulls":4}," "]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
["1.","Conduit and accessories."]
[null," Conduit applied and installed, including"]
[null," couplings, cutting, reaming, bending,"]
[null," fixing, etc. as per specification."]
[]
[null,"Type PVC "]
[null," Supply only :"]
[]
["1.1"," 20 mm diameter","m",{"$f":"Measure!N79*1.1","v":{"v":963.6,"d":"964"}},0,null,{"$f":"D13*E13","v":0}]
[]
["1.2"," 25 mm diameter","m",{"$f":"Measure!O79*1.1","v":{"v":1452.0000000000002,"d":"1452"}},0,null,{"$f":"D15*E15","v":0}]
[]
["1.3"," 32 mm diameter","m",25,0,null,{"$f":"D17*E17","v":0}]
[]
[]
[null," Install :"]
[]
["1.4"," 20 mm diameter","m",{"$f":"D13","v":{"v":963.6,"d":"964"}},0,null,0]
[]
["1.5"," 25 mm diameter","m",{"$f":"D15","v":{"v":1452.0000000000002,"d":"1452"}},0,null,{"$f":"D24*E24","v":0}]
[]
["1.6"," 32 mm diameter","m",{"$f":"D17","v":25},0,null,0]
[]
[null,"Type Galvanized"]
[null," Supply only :"]
[]
["1.7"," 20 mm diameter","m",30,0,null,0]
[]
["1.8"," 25 mm diameter","m",30,0,null,{"$f":"D33*E33","v":0}]
[]
[null," Install on surface (e.g. roof space) :"]
[]
["1.9"," 20 mm diameter","m",{"$f":"D31","v":30},0,null,0]
[]
["1.10"," 25 mm diameter","m",{"$f":"D33","v":30},0,null,{"$f":"D39*E39","v":0}]
[]
["2."," Conduit boxes"]
[]
[null," Outlet boxes complete with covers, include"]
[null," for conduit ends with 2 locknuts and female"]
[null," bush or coupling and male bush."]
{"$rows_empty":10}
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G4:G55)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
[null,"Type PVC"]
[null," Supply only"]
[]
["2.1"," 65 mm diameter x 25 mm deep ( 1-way )","No.",5,0,null,{"$f":"D65*E65","v":0}]
[]
["2.2"," 65 mm diameter x 25 mm deep ( 2-way )","No.",{"$f":"Measure!C79","v":122},0,null,{"$f":"D67*E67","v":0}]
[]
["2.3"," 65 mm diameter x 25 mm deep ( 3-way )","No.",5,0,null,0]
[]
["2.4"," 65 mm diameter x 25 mm deep ( 4-way )","No.",5,0,null,0]
[]
["2.5"," 65 mm diameter x 50 mm deep ( 1-way )","No.",5,0,null,0]
[]
["2.6"," 65 mm diameter x 50 mm deep ( 2-way )","No.",5,0,null,0]
[]
["2.7"," 65 mm diameter x 50 mm deep ( 3-way )","No.",5,0,null,0]
[]
["2.8"," 65 mm diameter x 50 mm deep ( 4-way )","No.",5,0,null,0]
[]
["2.9"," 100 x 50 x 50","No.",{"$f":"Measure!F79","v":11},0,null,0]
[]
["2.10"," 100 x 100 x 50","No.",{"$f":"Measure!G79","v":54},0,null,0]
[]
[null," Install on surface (i.e. roof space)"]
[]
["2.11"," 65 mm diameter x 25 mm deep ( 1-way )","No.",{"$f":"D65","v":5},0,null,{"$f":"D87*E87","v":0}]
[]
["2.12"," 65 mm diameter x 25 mm deep ( 2-way )","No.",{"$f":"D67","v":122},0,null,0]
[]
["2.13"," 65 mm diameter x 25 mm deep ( 3-way )","No.",{"$f":"D69","v":5},0,null,0]
[]
["2.14"," 65 mm diameter x 25 mm deep ( 4-way )","No.",{"$f":"D71","v":5},0,null,0]
[]
["2.15"," 65 mm diameter x 50 mm deep ( 1-way )","No.",{"$f":"D73","v":5},0,null,0]
[]
["2.16"," 65 mm diameter x 50 mm deep ( 2-way )","No.",{"$f":"D75","v":5},0,null,0]
[]
["2.17"," 65 mm diameter x 50 mm deep ( 3-way )","No.",{"$f":"D77","v":5},0,null,0]
[]
["2.18"," 65 mm diameter x 50 mm deep ( 4-way )","No.",{"$f":"D79","v":5},0,null,0]
[]
["2.19"," 100 x 50 x 50","No.",{"$f":"D81","v":11},0,null,{"$f":"D103*E103","v":0}]
[]
["2.20"," 100 x 100 x 50","No.",{"$f":"D83","v":54},0,null,{"$f":"D105*E105","v":0}]
{"$rows_empty":8}
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G61:G112)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
[null,"Type Galvanized"]
[null," Supply only"]
[]
["2.21"," 65 mm diameter x 25 mm deep ( 1-way )","No.",5,0,null,0]
[]
["2.22"," 65 mm diameter x 25 mm deep ( 2-way )","No.",5,0,null,0]
[]
["2.23"," 65 mm diameter x 25 mm deep ( 3-way )","No.",5,0,null,0]
[]
["2.24"," 65 mm diameter x 25 mm deep ( 4-way )","No.",5,0,null,{"$f":"D129*E129","v":0}]
[]
[null," Install on surface (i.e. roof space)"]
[]
["2.25"," 65 mm diameter x 25 mm deep ( 1-way )","No.",{"$f":"D123","v":5},0,null,0]
[]
["2.26"," 65 mm diameter x 25 mm deep ( 2-way )","No.",{"$f":"D125","v":5},0,null,0]
[]
["2.27"," 65 mm diameter x 25 mm deep ( 3-way )","No.",{"$f":"D127","v":5},0,null,0]
[]
["2.28"," 65 mm diameter x 25 mm deep ( 4-way )","No.",{"$f":"D129","v":5},0,null,{"$f":"D139*E139","v":0}]
[]
["3."," Blank cover plate  (as per specification)"]
[]
[null," Supply"]
[]
["3.1","65 mm diameter - PVC","No.",{"$f":"SUM(D65:D79)","v":157},0,null,0]
[]
["3.2"," 65 mm diameter - Galvanized","No.",{"$f":"SUM(D133:D139)","v":20},0,null,0]
[]
[null," Install"]
[]
["3.3",{"$f":"B145","v":"65 mm diameter - PVC"},"No.",{"$f":"D145","v":157},0,null,{"$f":"D151*E151","v":0}]
[]
["3.4",{"$f":"B147","v":" 65 mm diameter - Galvanized"},"No.",{"$f":"D147","v":20},0,null,{"$f":"D153*E153","v":0}]
[]
["4."," Switched socket outlets"]
[null," Supply, install and connect surface weatherproof industrial, 16 A, 3-pin switched socket outlet (shuttered type) complete with stainless steel mounting bracket."]
[]
["4.1"," Supply (Duo Combo)","No.",{"$f":"Measure!K79","v":14},0,null,0]
[]
["4.2"," Install (Duo Combo)","No.",{"$f":"D158","v":14},0,null,0]
[]
["4.3"," Supply (Double Dedicated)","No.",1,0,null,0]
[]
["4.4"," Install (Double Dedicated)","No.",{"$f":"D162","v":1},0,null,0]
[]
[]
[]
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G119:G167)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[null," Supply, install and connect surface weatherproof industrial, 32 A, 5-pin switched socket outlet (shuttered type) complete."]
[]
["4.5"," Supply (Single)","No.",0,0,null,{"$f":"D175*E175","v":0}]
[]
["4.6"," Install (Single)","No.",{"$f":"D175","v":0},0,null,{"$f":"D177*E177","v":0}]
[]
[5,"Heavy Duty Cable Ladder and Tray"," "]
[null," "]
[null,"Cable Tray"]
[]
[null,"300mm Wide"]
[]
["5.1"," Supply ","m",{"$f":"15+10+10+10","v":45},0,null,0]
[]
["5.2","Install","m",{"$f":"D185","v":45},0,null,0]
[]
[null,"300mm Wide - Horizontal Bend"]
[]
["5.3"," Supply ","No",1,0,null,{"$f":"D191*E191","v":0}]
[]
["5.4","Install","No",{"$f":"D191","v":1},0,null,{"$f":"D193*E193","v":0}]
[]
[null,"300mm Wide - Tee"]
[]
["5.5"," Supply ","No",0,0,null,{"$f":"D197*E197","v":0}]
[]
["5.6","Install","No",{"$f":"D197","v":0},0,null,{"$f":"D199*E199","v":0}]
[]
[null,"300mm Wide - Riser/Dropper"]
[]
["5.7"," Supply ","No",1,0,null,{"$f":"D203*E203","v":0}]
[]
["5.8","Install","No",{"$f":"D203","v":1},0,null,{"$f":"D205*E205","v":0}]
[]
[6," Light switches"]
[]
[null," Supply, install and connect industrial, weatherproof type complete with stainless steel mounting bracket."]
[null," "]
[null," Supply"]
[]
["6.1"," 16 A , 1-lever , 1-way ","No.",{"$f":"Measure!L79","v":11},0,null,0]
[]
["6.2","16 A , 1-lever , 2-way ","No.",1,0,null,0]
[]
["6.3","Movement Sensor (1 Chanel)","No.",3,0,null,0]
[]
["6.4"," Photocell","No.",0,0,null,0]
[]
[]
[]
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G173:G221)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
["6.5","Key activated light switch","No.",0,0,null,{"$f":"D228*E228","v":0}]
[]
[null," Install"]
[6.6,{"$f":"B213","v":" 16 A , 1-lever , 1-way "},"No.",{"$f":"D213","v":11},0,null,0]
[]
[6.7,{"$f":"B215","v":"16 A , 1-lever , 2-way "},"No.",{"$f":"D215","v":1},0,null,0]
[]
[6.8,{"$f":"B217","v":"Movement Sensor (1 Chanel)"},"No.",{"$f":"D217","v":3},0,null,0]
[]
[6.9," Photocell","No.",{"$f":"D219","v":0},0,null,0]
[]
[7," Luminaires"]
[null," Supply, install and connect the following luminaires as specified in the Project specification including 5A plug tops & bases to outlet points as required."]
[null," Supply"]
["7.1"," Type A","No.",{"$f":"Measure!Z79+3-9","v":33},0,null,{"$f":"D242*E242","v":0}]
[]
["7.2","Type B","No.",{"$f":"Measure!AA79","v":37},0,null,{"$f":"D244*E244","v":0}]
[]
["7.3","Type C","No.",{"$f":"Measure!AB79","v":3},0,null,0]
[]
["7.4","Type D","No,",{"$f":"Measure!AC79+1+6","v":14},0,null,{"$f":"D248*E248","v":0}]
[]
["7.5","Type E","No.",{"$f":"Measure!AD79","v":6},0,null,{"$f":"D250*E250","v":0}]
[]
["7.6","Type F","m",{"$f":"Measure!AE79+7","v":97},0,null,{"$f":"D252*E252","v":0}]
[]
["7.7","Type F - Elbows","No",24,0,null,{"$f":"D254*E254","v":0}]
[]
["7.8","Type G ","m",{"$f":"16+20","v":36},0,null,{"$f":"D256*E256","v":0}]
[]
["7.9","Match exisitng check in counter luminaires","No.",3,0,null,{"$f":"D258*E258","v":0}]
[]
[null,"Install"]
["7.10"," Type A","No.",{"$f":"D242","v":33},0,null,0]
[]
["7.11","Type B","No.",{"$f":"D244","v":37},0,null,0]
[]
["7.12","Type C","No.",{"$f":"D246","v":3},0,null,0]
[]
["7.13","Type D ","No.",{"$f":"10","v":10},0,null,{"$f":"D267*E267","v":0}]
[]
["7.14","Type E","No.",{"$f":"D250","v":6},0,null,{"$f":"D269*E269","v":0}]
[]
["7.15","Type F","m",{"$f":"D252","v":97},0,null,{"$f":"D271*E271","v":0}]
[]
["7.16","Type F - Elbows","No.",21,0,null,{"$f":"D273*E273","v":0}]
[]
["7.17","Type G ","m",{"$f":"D256","v":36},0,null,{"$f":"D275*E275","v":0}]
[]
["7.18","Check in counter luminaires","No.",{"$f":"D258","v":3},0,null,{"$f":"D277*E277","v":0}]
[]
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G228:G277)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[8," Conductors"]
[null," "]
[null," PVC insulated 600/1 000 V copper conductors,"]
[null," including earth, drawn into conduit."]
[]
[null," Supply"]
[]
["8.1"," 1.5 mm²","m",{"$f":"Measure!Q79","v":1341},0,null,{"$f":"D291*E291","v":0}]
[]
["8.2"," 2.5 mm²","m",{"$f":"Measure!R79","v":1899},0,null,{"$f":"D293*E293","v":0}]
[]
["8.3"," 4.0 mm²","m",{"$f":"Measure!U79","v":588},0,null,0]
[" "]
["8.4"," 6.0 mm²","m",{"$f":"Measure!V79","v":0},0,null,{"$f":"D297*E297","v":0}]
[]
[null," Install"]
[" "," "]
["8.5"," 1.5 mm²","m",{"$f":"D291","v":1341},0,null,0]
[]
["8.6"," 2.4 mm²","m",{"$f":"D293","v":1899},0,null,0]
[]
["8.7"," 4.0 mm²","m",{"$f":"D295","v":588},0,null,0]
[]
["8.8"," 4.0 mm²","m",{"$f":"D297","v":0},0,null,{"$f":"D307*E307","v":0}]
[]
[null,"Surfix Cable"]
[]
[null," Supply"]
[]
["8.9"," 2.5 mm² - 4 core","m",0,0,null,{"$f":"D313*E313","v":0}]
[]
["8.10"," 4.0 mm² - 4 core","m",0,0,null,{"$f":"D315*E315","v":0}]
[]
["8.11"," 6.0 mm² - 4 core","m",0,0,null,{"$f":"D317*E317","v":0}]
[" "]
[null," Install"]
[" "," "]
["8.12"," 2.5 mm² - 4 core","m",{"$f":"D313","v":0},0,null,{"$f":"D321*E321","v":0}]
[]
["8.13"," 4.0 mm² - 4 core","m",{"$f":"D315","v":0},0,null,{"$f":"D323*E323","v":0}]
[]
["8.14"," 6.0 mm² - 4 core","m",{"$f":"D317","v":0},0,null,{"$f":"D325*E325","v":0}]
[]
[9," Galvanised draw wire drawn into conduit for Data"]
[null," telephone, intercom and electrical installation"]
[]
["9.1"," Supply","m",{"$f":"D15","v":1452.0000000000002},0,null,0]
[]
["9.2"," Install","m",{"$f":"D330","v":1452.0000000000002},0,null,0]
[]
[]
[]
[]
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G284:G335)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
[10,"Galvanised Wiring Ducts complete with covers, splices and hanger brackets."]
[]
[null,"P9000"]
[]
["10.1"," Supply","m",20,0,null,0]
[]
["10.2"," Install","m",{"$f":"D347","v":20},0,null,0]
[]
[null,"P9000 - Elbow"]
[]
["10.3"," Supply","m",1,0,null,{"$f":"D353*E353","v":0}]
[]
["10.4"," Install","m",{"$f":"D353","v":1},0,null,{"$f":"D355*E355","v":0}]
[]
[null,"P9000 - Distribution outlet"]
[]
["10.5"," Supply","m",1,0,null,{"$f":"D359*E359","v":0}]
[]
["10.6"," Install","m",{"$f":"D359","v":1},0,null,{"$f":"D361*E361","v":0}]
[]
[null,"P9000 - Tee"]
[]
["10.7"," Supply","m",0,0,null,{"$f":"D365*E365","v":0}]
[]
["10.8"," Install","m",{"$f":"D365","v":0},0,null,{"$f":"D367*E367","v":0}]
[]
[null,"P9000 - Distribution End Cap"]
[]
["10.9"," Supply","m",1,0,null,{"$f":"D371*E371","v":0}]
[]
["10.10"," Install","m",{"$f":"D371","v":1},0,null,{"$f":"D373*E373","v":0}]
[]
[null,"P8000"]
[]
["10.11"," Supply","m",20,0,null,{"$f":"D377*E377","v":0}]
[]
["10.12"," Install","m",{"$f":"D377","v":20},0,null,{"$f":"D379*E379","v":0}]
[]
[null,"P8000 - Elbow"]
[]
["10.13"," Supply","m",1,0,null,{"$f":"D383*E383","v":0}]
[]
["10.14"," Install","m",{"$f":"D383","v":1},0,null,{"$f":"D385*E385","v":0}]
[]
[null,"P8000 - Distribution outlet"]
[]
["10.15"," Supply","m",1,0,null,{"$f":"D389*E389","v":0}]
[]
["10.16"," Install","m",{"$f":"D389","v":1},0,null,{"$f":"D391*E391","v":0}]
[]
[]
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G342:G392)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
[]
[null,"P8000 - Tee"]
[]
["10.17"," Supply","m",0,0,null,{"$f":"D403*E403","v":0}]
[]
["10.18"," Install","m",{"$f":"D403","v":0},0,null,{"$f":"D405*E405","v":0}]
[]
[null,"P8000 - Distribution End Cap"]
[]
["10.19"," Supply","m",2,0,null,{"$f":"D409*E409","v":0}]
[]
["10.20"," Install","m",{"$f":"D409","v":2},0,null,{"$f":"D411*E411","v":0}]
[]
[11,"Carry out the electrical connections to the following"]
[null,"items after they have been installed by others."]
[]
["11.1","Single Phase AC Unit ","No",4,0,null,{"$f":"D416*E416","v":0}]
[]
["11.2","Three Phase Water Pump","No",1,0,null,0]
[]
["11.3","Three Phase Fan","No",1,0,null,0]
[]
["11.4","Three Phase AHU's","No",4,0,null,0]
[]
[12,"5 Amp, three pin unswitched socket outlet to be installed on round inspection boxes for lighting outlets. Complete with round box."]
[]
["12.1"," Supply","No.",{"$f":"D242+D244+D246+D248+D250+D252+D258","v":193},0,null,{"$f":"D426*E426","v":0}]
[]
["12.2"," Install","No.",{"$f":"D426","v":193},0,null,0]
[]
[13,"Special socket outlet for emergency light"]
[]
["13.1"," Supply","No.",0,0,null,{"$f":"D432*E432","v":0}]
[]
["13.2"," Install","No.",{"$f":"D432","v":0},0,null,{"$f":"D434*E434","v":0}]
[]
[14," Isolators"]
[]
[null,"Supply and Install"]
[]
["14.1","Weather Proof, Surface 32A triple pole isolator complete. ","No.",1,0,null,{"$f":"D440*E440","v":0}]
[]
["14.2","Weather Proof, Surface 25A double pole isolator complete. ","No.",4,0,null,{"$f":"D442*E442","v":0}]
[]
["14.3","Flush 32A triple pole isolator complete. ","No.",0,0,null,{"$f":"D444*E444","v":0}]
[]
["14.4","Flush 25A double pole isolator complete. ","No.",0,0,null,{"$f":"D446*E446","v":0}]
[]
[]
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G399:G447)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
[15,"Power Skirting"]
[null,"Power skirting, OBO, white, 2 tier, complete with covers, end caps and all accessories.\nOnesto outlets"]
[]
[null,"Supply and Install"]
[]
["15.1","2 tier Power Skirting, Execuduct MKII, Grey, complete with covers, splices etc.","m",{"$f":"Measure!AR79","v":55},0,null,{"$f":"D460*E460","v":0}]
[]
["15.2","16A SSO, 164-1, skirting type complete with covers and cradles (Normal)","No",{"$f":"Measure!AS79","v":10},0,null,{"$f":"D462*E462","v":0}]
[]
["15.3","16A, SSO, 164-4 skirting type complete with covers and cradles (Dedicated, Red, Top shaved)","No.",{"$f":"Measure!AT79","v":14},0,null,0]
[]
["15.4","16A, SSO, (Euro) 164-2 with switch skirting type complete with, switch, covers and cradles (Normal)","No.",{"$f":"D462","v":10},0,null,0]
[]
["15.5","Data/Telephone outlets, 1 x RJ45 complete with cradle & covers, skirting type ","No.",{"$f":"7","v":7},0,null,0]
[]
["15.6","Internal Corners for Power Skirting - 2 Tier","No.",5,0,null,0]
[]
["15.7","External Corners for Power Skirting - 2 Tier","No.",1,0,null,0]
[]
["15.8","End caps for Power Skirting - 2 Tier","No",6,0,null,0]
[]
[16,"GENERAL"]
[]
["16.1","Provisional sum for design refinement (Add indicated value in amount column)","sum",1,{"v":10000,"d":"10,000.00"}]
[]
["16.2","Profit and attendance on Item 15.1 (Indicate percentage and value in amount column)","%"]
[]
[17,"DAYWORKS"]
[]
["17.1","Foreman"]
[null,"Normal Time","man hours",20,0,null,{"$f":"D485*E485","v":0}]
[null,"Over Time","man hours",5,0,null,0]
[null,"Sunday Time","man hours",5,0,null,0]
[]
[]
[]
[]
[]
[null,"                     AMOUNT  CARRIED  FORWARD",{"$nulls":4},{"$f":"SUM(G454:G491)","v":0}]
[]
["BILL NO. 4 : GENERAL ELECTRICAL"]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
["17.2","Qualified Artisan"]
[null,"Normal Time","man hours",20,0,null,{"$f":"D500*E500","v":0}]
[null,"Over Time","man hours",5,0,null,{"$f":"D501*E501","v":0}]
[null,"Sunday Time","man hours",5,0,null,0]
["17.3","Labourer"]
[null,"Normal Time","man hours",20,0,null,0]
[null,"Over Time","man hours",5,0,null,0]
[null,"Sunday Time","man hours",5,0,null,0]
["17.4","Transport"]
[null,"Up to 5t","km",100,0,null,0]
[null,"Bakkie 1t","km",200,0,null,0]
[null,"Car","km",200,0,null,0]
[]
[null,"Note: Dayworks rates will only be considered for additional work instructed by the Engineer not related to any aspect of the Specified Scope of Works"]
[]
[null,"TOTAL PAGE 10",{"$nulls":4},{"$f":"SUM(G498:G513)","v":0}]
[]
[null," SUMMARY FOR BILL NO.  4"]
[]
[null," PAGE"]
[null," "]
[]
[null,1,{"$nulls":4},{"$f":"G56","v":0}]
[]
[null,2,{"$nulls":4},{"$f":"G114","v":0}]
[]
[null,3,{"$nulls":4},{"$f":"G279","v":0}]
[]
[null,4,{"$nulls":4},{"$f":"G223","v":0}]
[]
[null,5,{"$nulls":4},{"$f":"G279","v":0}]
[]
[null,6,{"$nulls":4},{"$f":"G337","v":0}]
[]
[null,7,{"$nulls":4},{"$f":"G394","v":0}]
[]
[null,8,{"$nulls":4},{"$f":"G449","v":0}]
[]
[null,9,{"$nulls":4},{"$f":"G493","v":0}]
[]
[null,10,{"$nulls":4},{"$f":"G514","v":0}]
[]
[null," TOTAL FOR BILL NO. 4 :GENERAL ELECTRICAL"]
[null,"(CARRIED FORWARD TO FINAL SUMMARY)",{"$nulls":4},{"$f":"SUM(G520:G539)","v":0}]

{"sheet":"Bill 5","index":5,"n_rows":41,"n_cols":6,"rows_kept":41,"hidden":true,"merged":[[0,0,0,5]]}
["BILL NO. 5: PROVISIONAL AMOUNTS "]
[]
["Item","Description","Unit","Qty","Rate","Amount"]
[]
[1,"Allow for the following Provisional Amounts"]
[]
["1.1","Provide 75\" Ultra HD OLED TV screens for FIDS and CCTV display of Security/Queing progress. (Add indicated value in amount column)","Sum",null,{"v":40000,"d":"40,000.00"}]
[]
["1.2","Profit on item 1.1 above  (Indicate percentage and value in amount column)","%"]
[]
["1.3","Allowance for changes to Fire Detection and Voice Evacuation System. (Add indicated value in amount column)","Sum",null,{"v":30000,"d":"30,000.00"}]
[]
[null,"Profit on item 1.3 above  (Indicate percentage and value in amount column)","%"]
[]
["1.4","Allowance for provision of security equipmnet. (Add indicated value in amount column)","Sum",null,{"v":3000000,"d":"3,000,000.00"}]
[]
[null,"Profit on item 1.4 above  (Indicate percentage and value in amount column)","%"]
[]
["1.5","Allowance for changes to CCTV System. (Add indicated value in amount column)","Sum",null,{"v":180000,"d":"180,000.00"}]
[]
[null,"Profit on item 1.5 above  (Indicate percentage and value in amount column)","%"]
[]
["1.6","Allowance for changes to Data and Telephone cabeling including network equipment. (Add indicated value in amount column)","Sum",null,{"v":180000,"d":"180,000.00"}]
[]
[null,"Profit on item 1.6 above  (Indicate percentage and value in amount column)","%"]
[]
["1.7","Allowance for checkin counter equipment. (Add indicated value in amount column)","Sum",null,{"v":300000,"d":"300,000.00"}]
[]
[null,"Profit on item 1.7 above  (Indicate percentage and value in amount column)","%"]
{"$rows_empty":10}
[null," TOTAL FOR BILL NO. 5:  PROVISIONAL AMOUNTS",{"$nulls":3},{"$f":"SUM(F4:F39)","v":0}]
[null,"(CARRIED TO FINAL SUMMARY)"]

{"sheet":"Summary","index":6,"n_rows":54,"n_cols":7,"rows_kept":54,"merged":[[0,0,0,8],[2,0,2,4],[4,0,4,4],[6,0,6,3],[8,0,8,3],[17,0,17,4],[24,0,24,8],[30,5,30,7],[32,0,32,2],[41,0,41,2],[43,0,43,2],[45,0,45,2],[47,0,47,2]]}
["SUMMARY"]
[]
["Bill no 1:  Preliminary and General ",{"$nulls":4},"R",{"$f":"'Bill 1'!F46","v":0}]
[]
["Bill no 2:  Siteworks and Supervision ",{"$nulls":4},"R",{"$f":"'Bill 2'!F53","v":0}]
[]
["Bill no 3:  L.V Reticulation ",{"$nulls":4},"R",{"$f":"'Bill 3'!F150","v":0}]
[]
["Bill no 4: General Electrical",{"$nulls":4},"R",{"$f":"'Bill 4'!G542","v":0}]
[]
[]
["Sub-Total A - VAT excluded",{"$nulls":4},"R",{"$f":"G3+G5+G7+G9","v":0}]
[]
["Contingency (5%)",{"$nulls":4},"R",{"$f":"G12*0.05","v":0}]
[]
["Sub-Total B - VAT excluded ",{"$nulls":4},"R",{"$f":"G12+G14","v":0}]
[]
["Add 15% VAT here",{"$nulls":5},{"$f":"G16*0.15","v":0}]
[]
["Total  VAT included carry to tender form",{"$nulls":4},"R",{"$f":"G16+G18","v":0}]
[]
[]
["COMPLIANCE"]
[]
["I/We tender for the execution of the service as described herein and in accordance with the Conditions in documents specially mentioned therein, the contents of all of which I/we acknowledge myself/ourselves to be fully acquainted."]
[]
[]
[]
[]
["_______________________________",{"$nulls":4}," "]
["SIGNATURE OF TENDERER",{"$nulls":4},"DATE"]
[]
["TENDERER'S ADDRESS"]
{"$rows_empty":8}
["CONTACT PERSON"]
[]
["TELEPHONE NUMBER"]
[]
["FAX NUMBER                      : "]
[]
["E-MAIL"]
[]
[]
[]
["THREE PHASE WIREMANS LICENCE No:"]
[]
["ELECTRICAL CONTRACTORS NAME & REGISTRATION No:"]