{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Schedule","Rate Estimator"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Schedule","index":0,"n_rows":1034,"n_cols":7,"rows_kept":1034}
["Rate=F","CSIR - ROSEBANK:  DATA CENTER"]
["<NewDataSet>·  <xs:schema id=\"NewDataSet\" xmlns=\"\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:msdata=\"urn:schemas-microsoft-com:xml-msdata\">·    <xs:element name=\"NewDataSet\" msdata:IsDataSet=\"true\" msdata:MainDataTable=\"SummaryItems\" msdata:UseCurrentLocale=\"true\">·      <xs:complexType>·        <xs:choice minOccurs=\"0\" maxOccurs=\"unbounded\">·          <xs:element name=\"SummaryItems\">·            <xs:complexType>·              <xs:sequence>·                <xs:element name=\"ContractNo\" type=\"xs:short\" minOccurs=\"0\" />·                <xs:element name=\"ScheduleNo\" type=\"xs:short\" minOccurs=\"0\" />·                <xs:element name=\"SortNo\" type=\"xs:short\" minOccurs=\"0\" />·                <xs:element name=\"Item\" type=\"xs:string\" minOccurs=\"0\" />·                <xs:element name=\"SubTotalText\" type=\"xs:string\" minOccurs=\"0\" />·                <xs:element name=\"Description\" type=\"xs:string\" minOccurs=\"0\" />·                <xs:element name=\"CalcType\" type=\"xs:string\" minOccurs=\"0\" />·                <xs:element name=\"CalcValue\" type=\"xs:double\" minOccurs=\"0\" />·                <xs:element name=\"UseFirstSubTotal\" type=\"xs:boolean\" minOccurs=\"0\" />·                <xs:element name=\"ExclFromWorks\" type=\"xs:boolean\" minOccurs=\"0\" />·                <xs:element name=\"ExclFromProjected\" type=\"xs:boolean\" minOccurs=\"0\" />·              </xs:sequence>·            </xs:complexType>·          </xs:element>·        </xs:choice>·      </xs:complexType>·    </xs:element>·  </xs:schema>·  <SummaryItems>·    <ContractNo>1</ContractNo>·    <ScheduleNo>0</ScheduleNo>·    <SortNo>1</SortNo>·    <Item>1</Item>·    <Description>PLUS 10% CONTINGENCIES</Description>·    <CalcType>%</CalcType>·    <CalcValue>10</CalcValue>·    <UseFirstSubTotal>false</UseFirstSubTotal>·    <ExclFromWorks>false</ExclFromWorks>·    <ExclFromProjected>false</ExclFromProjected>·  </SummaryItems>·  <SummaryItems>·    <ContractNo>1</ContractNo>·    <ScheduleNo>0</ScheduleNo>·    <SortNo>2</SortNo>·    <Item>2</Item>·    <Description>PLUS 15% VAT </Description>·    <CalcType>%</CalcType>·    <CalcValue>15</CalcValue>·    <UseFirstSubTotal>false</UseFirstSubTotal>·    <ExclFromWorks>false</ExclFromWorks>·    <ExclFromProjected>false</ExclFromProjected>·  </SummaryItems>·</NewDataSet>","CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION A:  PRELIMINARY AND GENERAL:  TIME, FIXED CHARGE, VALUE"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[199,"A","TIME RELATED"]
[]
[200,"A1.1","Allow for all TIME related items of the Principal Building Agreement as well as any special requirements relating to this sub-contract"]
[]
[201,null,"List all TIME related items as required - specify"]
[]
[202,"A1.1.1","(a) ","Sum",1,0,{"$f":"IF(D13 = CHAR(37), E13*F13/100,E13*F13)","v":0}]
[]
[203,"A1.1.2","(b) ","Sum",1,0,{"$f":"IF(D15 = CHAR(37), E15*F15/100,E15*F15)","v":0}]
[]
[204,"A1.1.3","(c) ","Sum",1,0,{"$f":"IF(D17 = CHAR(37), E17*F17/100,E17*F17)","v":0}]
[]
[205,"A1.1.4","(d)","Sum",1,0,{"$f":"IF(D19 = CHAR(37), E19*F19/100,E19*F19)","v":0}]
[]
[206,"A1.2","Fixed Charge Related"]
[]
[207,null,"Allow for all FIXED charge related items in terms of the Principal Building Agreement as well as any special requirements relating to this sub-contract"]
[]
[208,null,"List all FIXED charge related items as required - specify"]
[]
[209,"A1.2.1","(a)","Sum",1,0,{"$f":"IF(D27 = CHAR(37), E27*F27/100,E27*F27)","v":0}]
[]
[210,"A1.2.2","(b)","Sum",1,0,{"$f":"IF(D29 = CHAR(37), E29*F29/100,E29*F29)","v":0}]
[]
[211,"A1.2.3","(c)","Sum",1,0,{"$f":"IF(D31 = CHAR(37), E31*F31/100,E31*F31)","v":0}]
[]
[212,"A1.2.4","(d)","Sum",1,0,{"$f":"IF(D33 = CHAR(37), E33*F33/100,E33*F33)","v":0}]
[]
[213,"A1.3","Value Related"]
[]
[214,null,"Allow for all VALUE related items in terms of the Principal Building Agreement as well as any special requirements relating to this sub-contract"]
[]
[215,null,"List all VALUE related items as required - specify"]
[]
[216,"A1.3.1","(a)","Sum",1,0,{"$f":"IF(D41 = CHAR(37), E41*F41/100,E41*F41)","v":0}]
[]
[217,"A1.3.2","(b)","Sum",1,0,{"$f":"IF(D43 = CHAR(37), E43*F43/100,E43*F43)","v":0}]
[]
[218,"A1.3.3","(c)","Sum",1,0,{"$f":"IF(D45 = CHAR(37), E45*F45/100,E45*F45)","v":0}]
[]
[219,"A1.3.4","(d)","Sum",1,0,{"$f":"IF(D47 = CHAR(37), E47*F47/100,E47*F47)","v":0}]
{"$rows_empty":17}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G7:G64)","v":0}]
[{"$nulls":3},"1"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B1:  DISTRIBUTION BOARDS"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[220,"B1","DISTRIBUTION BOARDS"]
[]
[221,"B1.1","Supply, install, connect and commission the new distribution board in position as indicated on drawings. Complete with internal equipment, switchgear, wiring, trays, panels, labels, architraves, busbars and conductor connections. Equipment type to be ABB, Schneider, Häger or Eaton.  DIN rail mounted.  All control equipment, components, contactors and circuit breakers to be SANS approved.  Installation is to comply to latest wiring code SANS 10142-1."]
[]
[222,null,"Quote for supply and installation of the distribution board for Room 27 DB-1: Essential complete with frame architrave, panels, 30% spare capacity, internal busbars, wiring and switching equipment as per the single line diagram drawings. "]
[]
[223,"B1.1.1","Supply","No",1,0,{"$f":"IF(D79 = CHAR(37), E79*F79/100,E79*F79)","v":0}]
[]
[224,"B1.1.2","Install","No",1,0,{"$f":"IF(D81 = CHAR(37), E81*F81/100,E81*F81)","v":0}]
[]
[884,null,"Quote for supply and installation of the distribution board for Room 27 DB-1:UPSA, complete with frame architrave, panels, 30% spare capacity, internal busbars, wiring and switching equipment as per the single line diagram drawings. "]
[]
[885,"B1.1.3","Supply","No",1,0,{"$f":"IF(D85 = CHAR(37), E85*F85/100,E85*F85)","v":0}]
[]
[886,"B1.1.4","Install","No",1,0,{"$f":"IF(D87 = CHAR(37), E87*F87/100,E87*F87)","v":0}]
[]
[1277,null,"Quote for supply and installation of the distribution board for Room 27 DB-1: UPS B, complete with frame architrave, panels, 30% capacity, internal busbards, woring and switching equipment as per the singe line diagram drawings. "]
[]
[1278,"B1.1.5","Supply","No",1,0,{"$f":"IF(D91 = CHAR(37), E91*F91/100,E91*F91)","v":0}]
[]
[1279,"B1.1.6","Install","No",1,0,{"$f":"IF(D93 = CHAR(37), E93*F93/100,E93*F93)","v":0}]
[]
[1522,null,"Quote for supply and instllation of the distributuion board for Room 27 DB-2:  UPS A, complete with frame architrave, panels, 30% spare capacity, internal bubars, wiring and switching equipment as pe the singe lne diagram drawings. "]
[]
[1523,"B1.1.7","Supply","No",1,0,{"$f":"IF(D97 = CHAR(37), E97*F97/100,E97*F97)","v":0}]
[]
[1524,"B1.1.8","Install","No",1,0,{"$f":"IF(D99 = CHAR(37), E99*F99/100,E99*F99)","v":0}]
[]
[1525,null,"Quote for supply and installation of the distribution boards for Room 27 - DB - 2: UPS B, complete with frame architrave, panels, 30% spare capacity, internal busbars, wiring and switching equipment as per the singel line diangram drawings. "]
[]
[1526,"B1.1.9","Supply","No",1,0,{"$f":"IF(D103 = CHAR(37), E103*F103/100,E103*F103)","v":0}]
[]
[1527,"B1.1.10","Install","No",1,0,{"$f":"IF(D105 = CHAR(37), E105*F105/100,E105*F105)","v":0}]
[]
[1528,null,"Quote for supply and installation of the distribution board for Room 31  DB-1: Essential, complete with frame architrave, panels, 30% spare capacity, internal busbards, wiring and switching equipment as per the singe line diagram drawings."]
[null," Total Carried Forward",{"$nulls":4},{"$f":"SUM(G73:G107)","v":0}]
[{"$nulls":3},"2"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B1:  DISTRIBUTION BOARDS"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[null," Brought Forward",{"$nulls":4},{"$f":"G108","v":0}]
[1529,"B1.1.11","Supply","No",1,0,{"$f":"IF(D117 = CHAR(37), E117*F117/100,E117*F117)","v":0}]
[]
[1530,"B1.1.12","Install","No",1,0,{"$f":"IF(D119 = CHAR(37), E119*F119/100,E119*F119)","v":0}]
[]
[1531,null," Quote for supply and installation of the distribution board for Room 31  DB-1: UPSA, complete with frame architrave, panels, 30% spare capacity, internal busbards, wiring and switching equipment as per the singe line diagram drawings.\t"]
[]
[1926,"B1.1.13","Supply","No",1,0,{"$f":"IF(D123 = CHAR(37), E123*F123/100,E123*F123)","v":0}]
[]
[1928,"B1.1.14","Install","No",1,0,{"$f":"IF(D125 = CHAR(37), E125*F125/100,E125*F125)","v":0}]
[]
[1927,null,"Quote for supply and installation of the distribution board for Room 31 DB 1 UPS B, complete with frame architrave, panels, 30% spare capacity, internal busbars, woring and switching equipment as per the singe line diagram drawings."]
[]
[1929,"B1.1.15","Supply","No",1,0,{"$f":"IF(D129 = CHAR(37), E129*F129/100,E129*F129)","v":0}]
[]
[1930,"B1.1.16","Install","No",1,0,{"$f":"IF(D131 = CHAR(37), E131*F131/100,E131*F131)","v":0}]
[]
[1931,null,"Quote for upgrade of the existing distribution board for existing DB-A as per the singe line diagram drawings."]
[]
[1532,"B1.1.17","Supply","No",1,0,{"$f":"IF(D135 = CHAR(37), E135*F135/100,E135*F135)","v":0}]
[]
[1533,"B1.1.18","Install","No",1,0,{"$f":"IF(D137 = CHAR(37), E137*F137/100,E137*F137)","v":0}]
[]
[1534,null,"Quote for upgrade of the existing distribution board for existing DB-B as per the singe line diagram drawings."]
[]
[1535,"B1.1.19","Supply","No",1,0,{"$f":"IF(D141 = CHAR(37), E141*F141/100,E141*F141)","v":0}]
[]
[1536,"B1.1.20","Install","No",1,0,{"$f":"IF(D143 = CHAR(37), E143*F143/100,E143*F143)","v":0}]
{"$rows_empty":27}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G116:G170)","v":0}]
[{"$nulls":3},"3"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B2:  WIREWAYS, CONDUIT & ACCESSORIES"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[227,"B2","CONDUIT AND ACCESSORIES"]
[]
[228,"B2.1","Conduit"]
[]
[229,null,"Supply and install, including bends, saddles, wastes and all accessories"]
[]
[230,null,"Galvanised type:"]
[]
[234,null,"25mm diameter conduit"]
[]
[235,"B2.1.1","Supply","m",100,0,{"$f":"IF(D189 = CHAR(37), E189*F189/100,E189*F189)","v":0}]
[]
[236,"B2.1.2","Install","m",100,0,{"$f":"IF(D191 = CHAR(37), E191*F191/100,E191*F191)","v":0}]
[]
[237,null,"20 mm diameter conduit"]
[]
[238,"B2.1.3","Supply","m",1,0,"Rate Only"]
[]
[239,"B2.1.4","Install","m",1,0,"Rate Only"]
[]
[240,null,"PVC type"]
[]
[244,null,"25 mm diameter conduit"]
[]
[245,"B2.1.5","Supply","m",100,0,{"$f":"IF(D203 = CHAR(37), E203*F203/100,E203*F203)","v":0}]
[]
[246,"B2.1.6","Install","m",100,0,{"$f":"IF(D205 = CHAR(37), E205*F205/100,E205*F205)","v":0}]
[]
[247,null,"20 mm diameter conduit"]
[]
[248,"B2.1.7","Supply","m",100,0,{"$f":"IF(D209 = CHAR(37), E209*F209/100,E209*F209)","v":0}]
[]
[249,"B2.1.8","Install","m",100,0,{"$f":"IF(D211 = CHAR(37), E211*F211/100,E211*F211)","v":0}]
[]
[250,"B2.2","Draw Boxes"]
[]
[251,null,"Supply and install the following conduit boxes, complete with conduit connected."]
[]
[252,null,"Rectangular Galvanised type:"]
[]
[253,null,"100 mm x 100 mm x 50 mm"]
[]
[254,"B2.2.1","Supply","No",1,0,"Rate Only"]
[]
[255,"B2.2.2","Install","No",1,0,"Rate Only"]
[]
[256,null,"100 mm x 50 mm x 50 mm"]
[]
[257,"B2.2.3","Supply","No",50,0,{"$f":"IF(D227 = CHAR(37), E227*F227/100,E227*F227)","v":0}]
[]
[258,"B2.2.4","Install","No",50,0,{"$f":"IF(D229 = CHAR(37), E229*F229/100,E229*F229)","v":0}]
{"$rows_empty":11}
[null," Total Carried Forward",{"$nulls":4},{"$f":"SUM(G179:G240)","v":0}]
[{"$nulls":3},"4"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B2:  WIREWAYS, CONDUIT & ACCESSORIES"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[null," Brought Forward",{"$nulls":4},{"$f":"G241","v":0}]
[901,null,"Ø50 mm Round x 50 mm deep round galvanised box"]
[]
[902,"B2.2.5","Supply","No",50,0,{"$f":"IF(D252 = CHAR(37), E252*F252/100,E252*F252)","v":0}]
[]
[903,"B2.2.6","Install","No",50,0,{"$f":"IF(D254 = CHAR(37), E254*F254/100,E254*F254)","v":0}]
[]
[259,null,"Retangular PVC type:"]
[]
[260,null,"100 mm x 100 mm x 50 mm"]
[]
[261,"B2.2.7","Supply","No",10,0,{"$f":"IF(D260 = CHAR(37), E260*F260/100,E260*F260)","v":0}]
[]
[262,"B2.2.8","Install","No",10,0,{"$f":"IF(D262 = CHAR(37), E262*F262/100,E262*F262)","v":0}]
[]
[263,null,"100 mm x 50 mm x 50 mm"]
[]
[264,"B2.2.9","Supply","No",20,0,{"$f":"IF(D266 = CHAR(37), E266*F266/100,E266*F266)","v":0}]
[]
[265,"B2.2.10","Install","No",20,0,{"$f":"IF(D268 = CHAR(37), E268*F268/100,E268*F268)","v":0}]
[]
[904,null,"Ø50 mm Round x 50 mm deep round box"]
[]
[905,"B2.2.11","Supply","No",40,0,{"$f":"IF(D272 = CHAR(37), E272*F272/100,E272*F272)","v":0}]
[]
[906,"B2.2.12","Install","No",40,0,{"$f":"IF(D274 = CHAR(37), E274*F274/100,E274*F274)","v":0}]
[]
[266,"B2.3","Cable Ladder"]
[]
[267,null,"Galvanised heavy duty metal cable ladder complete with all accessories. To be O-line, Cabstrut or similar approved. Running length shall include component of horizontal elbows, internal elbows, external elbows, end caps and T-junctions.  Suspended fixing with 10mm threaded bars and horizontal channel to be included at maximum distance of 1500mm."]
[]
[268,null,"300 mm wide cable ladder "]
[]
[269,"B2.3.1","Supply","m",40,0,{"$f":"IF(D282 = CHAR(37), E282*F282/100,E282*F282)","v":0}]
[]
[270,"B2.3.2","Installed inside trenching","m",40,0,{"$f":"IF(D284 = CHAR(37), E284*F284/100,E284*F284)","v":0}]
[]
[274,"B2.4","Cable Tray"]
[]
[275,null,"Galvanised perforated medium duty metal cable tray complete with all accessories. To be O-line, Cabstrut or similar approved. Running length shall include component of horizontal, internal, external bends and T-junctions. Suspended fixing with 10mm threaded bars and horizontal channel to be included at maximum distance of 1500mm."]
{"$rows_empty":13}
[null," Total Carried Forward",{"$nulls":4},{"$f":"SUM(G249:G301)","v":0}]
[{"$nulls":3},"5"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B2:  WIREWAYS, CONDUIT & ACCESSORIES"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[null," Brought Forward",{"$nulls":4},{"$f":"G302","v":0}]
[1361,null,"100 mm wide medium duty cable tray with suspension brackets."]
[]
[1362,"B2.4.1","Supply","m",40,0,{"$f":"IF(D313 = CHAR(37), E313*F313/100,E313*F313)","v":0}]
[]
[1363,"B2.4.2","Install","m",40,0,{"$f":"IF(D315 = CHAR(37), E315*F315/100,E315*F315)","v":0}]
[]
[276,null,"300 mm wide medium duty cable tray with suspension brackets."]
[]
[277,"B2.4.3","Supply","m",40,0,{"$f":"IF(D319 = CHAR(37), E319*F319/100,E319*F319)","v":0}]
[]
[278,"B2.4.4","Install","m",40,0,{"$f":"IF(D321 = CHAR(37), E321*F321/100,E321*F321)","v":0}]
[]
[285,null,"300 mm wide medium duty perforated cable tray installed in floor "]
[]
[286,"B2.4.5","Supply","m",220,0,{"$f":"IF(D325 = CHAR(37), E325*F325/100,E325*F325)","v":0}]
[]
[287,"B2.4.6","Install","m",220,0,{"$f":"IF(D327 = CHAR(37), E327*F327/100,E327*F327)","v":0}]
[]
[295,"B2.5","Cable Ducting"]
[]
[296,null,"Galvanised wiring ducting complete with all joints and accessories. To be O-line, Cabstrut or similar approved. Running length shall include component of horizontal elbows, internal elbows, external elbows, end caps and T-junctions.  No sharp bends shall be accepted-all elbows shall have sufficient bending radi for wiring.  Installation shall include suspension items including 10mm threaded rod, horizontal channel and all accessories."]
[]
[1065,null,"76 mm x 76 mm (OL8000/P8000) wiring ducting with covers."]
[]
[1066,"B2.5.1","Supply","m",1,0,"Rate Only"]
[]
[1067,"B2.5.2","Install","m",1,0,"Rate Only"]
{"$rows_empty":26}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G310:G363)","v":0}]
[{"$nulls":3},"6"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B3:  LIGHTING, INSTALLATION AND LIGHT FITTINGS"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[312,"B3","LIGHT FITTINGS"]
[]
[313,"B3.1","Supply and install, including all switchgear, starters, ballasts etc.  All fittings are to bare the SANS Mark or SANS Mark of Compliance."]
[]
[314,null,"Type F1:  Vapour proof enclosed light fitting with 27W LED.  Beka Vapourline; 4000K; IP66 rated.  As per Beka Vapourline JBLS 1200 or better approved."]
[]
[315,"B3.1.1","Supply","No",10,0,{"$f":"IF(D378 = CHAR(37), E378*F378/100,E378*F378)","v":0}]
[]
[316,"B3.1.2","Install","No",10,0,{"$f":"IF(D380 = CHAR(37), E380*F380/100,E380*F380)","v":0}]
[]
[1280,"B3.2","Light Switches and Accessories"]
[]
[1281,null,"Supply and install light switches complete with cover plates connecting to wiring and fitted in switch box. Each light switch installation shall be conduited "]
[]
[1282,null,"16A one lever one way switch inside 100mm x 50mm x 50mm PVC box"]
[]
[1287,"B3.2.1","Supply","No",2,0,{"$f":"IF(D388 = CHAR(37), E388*F388/100,E388*F388)","v":0}]
[]
[1288,"B3.2.2","Install","No",2,0,{"$f":"IF(D390 = CHAR(37), E390*F390/100,E390*F390)","v":0}]
{"$rows_empty":38}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G372:G428)","v":0}]
[{"$nulls":3},"7"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B4:  POWER OUTLET POINTS"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[347,"B4","POWER POINT OUTLETS"]
[]
[348,"B4.1","Supply and install switched socket outlets complete with cover plates connecting to wiring and installed in boxes. Switches, socket outlets and coverplates to be Crabtree Diamond Range."]
[]
[355,null,"Double \"Combination\" 16A 3-pin switched socket outlets installed in 4x4 box. (SANS 164-1 and 1x SANS 164.2)."]
[]
[356,"B4.1.1","Supply","No",4,0,{"$f":"IF(D443 = CHAR(37), E443*F443/100,E443*F443)","v":0}]
[]
[357,"B4.1.2","Install","No",4,0,{"$f":"IF(D445 = CHAR(37), E445*F445/100,E445*F445)","v":0}]
{"$rows_empty":51}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G437:G496)","v":0}]
[{"$nulls":3},"8"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B5:  ISOLATORS AND POWER SUPPLY"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[371,"B5","ISOLATORS"]
[]
[372,null,"Supply and install weather proof surface mount isolators as amended in the SANS 10142 specification for maintenance purposes of mechanical and other equipment"]
[]
[376,null,"60A, 5 Wire (3P+N+E)"]
[]
[377,"B5.1","Supply","No",38,0,{"$f":"IF(D511 = CHAR(37), E511*F511/100,E511*F511)","v":0}]
[]
[378,"B5.2","Install","No",38,0,{"$f":"IF(D513 = CHAR(37), E513*F513/100,E513*F513)","v":0}]
[]
[379,null,"32A, 5 Wire (3P+N+E)\r\n"]
[]
[380,"B5.3","Supply","No",20,0,{"$f":"IF(D517 = CHAR(37), E517*F517/100,E517*F517)","v":0}]
[]
[381,"B5.4","Install","No",20,0,{"$f":"IF(D519 = CHAR(37), E519*F519/100,E519*F519)","v":0}]
[]
[382,null,"32A Triple pole"]
[]
[383,"B5.5","Supply","No",4,0,{"$f":"IF(D523 = CHAR(37), E523*F523/100,E523*F523)","v":0}]
[]
[384,"B5.6","Install","No",4,0,{"$f":"IF(D525 = CHAR(37), E525*F525/100,E525*F525)","v":0}]
[]
[385,null,"Supply and install surface mounted isolators as amended in the SANS 10142 specification for maintenance purposes of mechanical and other equipment"]
[]
[389,null,"60A triple pole"]
[]
[390,"B5.7","Supply","No",4,0,{"$f":"IF(D531 = CHAR(37), E531*F531/100,E531*F531)","v":0}]
[]
[391,"B5.8","Install","No",4,0,{"$f":"IF(D533 = CHAR(37), E533*F533/100,E533*F533)","v":0}]
[]
[392,null,"60A double pole"]
[]
[393,"B5.9","Supply","No",1,0,"Rate Only"]
[]
[394,"B5.10","Install","No",1,0,"Rate Only"]
{"$rows_empty":24}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G505:G563)","v":0}]
[{"$nulls":3},"9"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B6:  CABLES, WIRING AND EARTHWIRE"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[429,"B6","CABLES, WIRING AND EARTHWIRE"]
[]
[430,"B6.1","Supply and install the following armoured PVC sheathed copper LT cables including glands, shroud, lugs, clamping, supports and accessories.\r\nNOTE: For ordering of cables, measurement shall NOT be taken from this bill. Actual cable lengths shall be measured on site for ordering and installation purposes."]
[]
[458,null,"95 mm² x 4 core cable"]
[]
[459,"B6.1.2","Supply","m",1800,0,{"$f":"IF(D578 = CHAR(37), E578*F578/100,E578*F578)","v":0}]
[]
[460,"B6.1.3","Install","m",1800,0,{"$f":"IF(D580 = CHAR(37), E580*F580/100,E580*F580)","v":0}]
[]
[1210,null,"70 mm² x 4 core cable"]
[]
[1211,"B6.1.4","Supply","m",1,0,"Rate Only"]
[]
[1212,"B6.1.5","Install","m",1,0,"Rate Only"]
[]
[1300,null,"16 mm² x 4 core cable"]
[]
[1301,"B6.1.6","Supply","m",1400,0,{"$f":"IF(D590 = CHAR(37), E590*F590/100,E590*F590)","v":0}]
[]
[1302,"B6.1.7","Install","m",1400,0,{"$f":"IF(D592 = CHAR(37), E592*F592/100,E592*F592)","v":0}]
[]
[1303,null,"10 mm² x 4 core cable"]
[]
[1304,"B6.1.8","Supply","m",1,0,"Rate Only"]
[]
[1305,"B6.1.9","Install","m",1,0,"Rate Only"]
[]
[1207,null,"6 mm² x 4 core cable"]
[]
[1208,"B6.1.10","Supply","m",1000,0,{"$f":"IF(D602 = CHAR(37), E602*F602/100,E602*F602)","v":0}]
[]
[1209,"B6.1.11","Install","m",1000,0,{"$f":"IF(D604 = CHAR(37), E604*F604/100,E604*F604)","v":0}]
[]
[461,null,"4 mm² x 4 core cable"]
[]
[462,"B6.1.12","Supply","m",1,0,"Rate Only"]
[]
[463,"B6.1.13","Install","m",1,0,"Rate Only"]
[]
[999,"B6.2","Cable Terminations"]
[]
[1003,null,"Cable terminations on both sides from supply to load for various cable ranges.  Each termination point is measured seperately."]
[]
[1000,"B6.2.1","Cable Range:  50 mm² ≤ χ ≤ 95 mm²","No",38,0,{"$f":"IF(D616 = CHAR(37), E616*F616/100,E616*F616)","v":0}]
[]
[1025,"B6.2.2","Cable Range:  16 mm² ≤ χ ≤ 35 mm²","No",100,0,{"$f":"IF(D618 = CHAR(37), E618*F618/100,E618*F618)","v":0}]
{"$rows_empty":10}
[null," Total Carried Forward",{"$nulls":4},{"$f":"SUM(G572:G628)","v":0}]
[{"$nulls":3},"10"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B6:  CABLES, WIRING AND EARTHWIRE"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[null," Brought Forward",{"$nulls":4},{"$f":"G629","v":0}]
[474,"B6.3","Wiring and Earth Wiring"]
[]
[475,null,"Supply and install conductors in wire ways (including off-cuts and wastes)."]
[]
[476,null,"PVC insulated conductors installed in conduits or wire trunking."]
[]
[483,null,"70 mm²"]
[]
[1228,"B6.3.1","Supply","m",1800,0,{"$f":"IF(D646 = CHAR(37), E646*F646/100,E646*F646)","v":0}]
[]
[1229,"B6.3.2","Install","m",1800,0,{"$f":"IF(D648 = CHAR(37), E648*F648/100,E648*F648)","v":0}]
[]
[486,null,"50 mm² "]
[]
[1226,"B6.3.3","Supply","m",1,0,"Rate Only"]
[]
[1227,"B6.3.4","Install","m",1,0,"Rate Only"]
[]
[489,null,"16 mm² "]
[]
[490,"B6.3.5","Supply","m",1,0,"Rate Only"]
[]
[491,"B6.3.6","Install","m",1,0,"Rate Only"]
[]
[492,null,"10 mm² "]
[]
[1230,"B6.3.7","Supply","m",1400,0,{"$f":"IF(D664 = CHAR(37), E664*F664/100,E664*F664)","v":0}]
[]
[1231,"B6.3.8","Install","m",1400,0,{"$f":"IF(D666 = CHAR(37), E666*F666/100,E666*F666)","v":0}]
[]
[495,null,"6 mm² "]
[]
[496,"B6.3.9","Supply","m",1,0,"Rate Only"]
[]
[497,"B6.3.10","Install","m",1,0,"Rate Only"]
[]
[498,null,"4 mm² "]
[]
[499,"B6.3.11","Supply","m",1000,0,{"$f":"IF(D676 = CHAR(37), E676*F676/100,E676*F676)","v":0}]
[]
[500,"B6.3.12","Install","m",1000,0,{"$f":"IF(D678 = CHAR(37), E678*F678/100,E678*F678)","v":0}]
[]
[501,null,"2.5 mm² "]
[]
[502,"B6.3.13","Supply","m",200,0,{"$f":"IF(D682 = CHAR(37), E682*F682/100,E682*F682)","v":0}]
[]
[503,"B6.3.14","Install","m",200,0,{"$f":"IF(D684 = CHAR(37), E684*F684/100,E684*F684)","v":0}]
[]
[504,null,"1.5 mm² "]
[]
[505,"B6.3.15","Supply","m",200,0,{"$f":"IF(D688 = CHAR(37), E688*F688/100,E688*F688)","v":0}]
[]
[506,"B6.3.16","Install","m",200,0,{"$f":"IF(D690 = CHAR(37), E690*F690/100,E690*F690)","v":0}]
{"$rows_empty":8}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G637:G698)","v":0}]
[{"$nulls":3},"11"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"ADDITIONAL SERVICES"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[1622,"B7","ADDITIONAL SERVICES"]
[]
[1623,null,"EARTH MAT"]
[]
[1624,null,"Supply and install a Earth Mat system located beneath the raised access floor, including: Grid: 70mm² bare copper conductor laid in a 400 x 400mm grid pattern.  Connections:  All grid intersections to be exothermically welded (e.g CAD-weld) or joined via high compression \"cross-connect\" clamps.  Bonding:  Provision and installation of 16mm² flexible copper braids to bond every (4th) floor pedestal to the grid. Terminations:  Supply of 35mm² green/yellow insulated \"tail-outs\" (2m length) for connection to server racks/PDUs, including heavy-duty compression lugs.  Integration:  Conection of the grid to the main Data Cnetre Earth Bar and/*or building structural steel using 95mm² copper conductors.  Compliance:  Testing and commissioning to ensure Earth Loop Impedance is <1ohm, including the provision of certified test results and As-Built drawings."]
[]
[1625,"B7.1","Earth Mat for Room 27","m²",30,0,{"$f":"IF(D713 = CHAR(37), E713*F713/100,E713*F713)","v":0}]
[]
[1626,"B7.2","Earth Mat for Room 31","m²",40,0,{"$f":"IF(D715 = CHAR(37), E715*F715/100,E715*F715)","v":0}]
[]
[1942,"B7.3","Earth Mat for Data Center","m²",130,0,{"$f":"IF(D717 = CHAR(37), E717*F717/100,E717*F717)","v":0}]
{"$rows_empty":38}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G707:G755)","v":0}]
[{"$nulls":3},"12"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B8:  ADDITIONAL ELECTRICAL SERVICES  "]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[516,"B8","ADDITIONAL"]
[]
[532,"B8.1","Sub-Distribution Board Equipment"]
[]
[533,null,"Quote for supply and installation of the following distribution board equipment as specified below."]
[]
[534,null,"Note:  Rates are applicable to switchboard manufacturers and changes by the electrician on site."]
[]
[1249,null,"400A TP 15kA MCCB"]
[]
[1250,"B8.1.1","Supply","No",1,0,"Rate Only"]
[]
[1251,"B8.1.2","Install","No",1,0,"Rate Only"]
[]
[559,null,"60A TP 5kA CB"]
[]
[560,"B8.1.3","Supply","No",1,"","Rate Only"]
[]
[561,"B8.1.4","Install","No",1,"","Rate Only"]
[]
[562,null,"40A TP 5kA CB"]
[]
[563,"B8.1.5","Supply","No",1,"","Rate Only"]
[]
[564,"B8.1.6","Install","No",1,"","Rate Only"]
[]
[565,null,"20A TP 5kA CB"]
[]
[566,"B8.1.7","Supply","No",1,"","Rate Only"]
[]
[567,"B8.1.8","Install","No",1,"","Rate Only"]
[]
[568,null,"60A SP 5kA CB"]
[]
[569,"B8.1.9","Supply","No",1,"","Rate Only"]
[]
[570,"B8.1.10","Install","No",1,"","Rate Only"]
[]
[571,null,"40A SP 5kA CB"]
[]
[572,"B8.1.11","Supply","No",1,"","Rate Only"]
[]
[573,"B8.1.12","Install","No",1,"","Rate Only"]
[]
[574,null,"30A SP 5kA CB"]
[]
[575,"B8.1.13","Supply","No",1,"","Rate Only"]
[]
[576,"B8.1.14","Install","No",1,"","Rate Only"]
[]
[577,null,"20A SP 5kA CB"]
[]
[578,"B8.1.15","Supply","No",1,"","Rate Only"]
[]
[579,"B8.1.16","Install","No",1,"","Rate Only"]
{"$rows_empty":7}
[null," Total Carried Forward",{"$nulls":4},{"$f":"SUM(G764:G825)","v":0}]
[{"$nulls":3},"13"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B8:  ADDITIONAL ELECTRICAL SERVICES  "]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[null," Brought Forward",{"$nulls":4},{"$f":"G826","v":0}]
[580,null,"16A SP 5kA CB"]
[]
[581,"B8.1.17","Supply","No",1,"","Rate Only"]
[]
[582,"B8.1.18","Install","No",1,"","Rate Only"]
[]
[583,null,"63A earth leakage protection device 1+N"]
[]
[584,"B8.1.19","Supply","No",1,"","Rate Only"]
[]
[585,"B8.1.20","Install","No",1,"","Rate Only"]
{"$rows_empty":52}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G834:G897)","v":0}]
[{"$nulls":3},"14"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":6},"SECTION B9:  ELECTRICAL SERVICES - COMPLETION"]
[null,"Item\nNo","Description","Unit","Qty","Rate","Amount R"]
[586,"B9","ELECTRICAL SERVICES - COMPLETION"]
[]
[587,null,"Test and Commission"]
[]
[588,"B9.1","Test and commission entire electrical installation as required by SANS: 10142 requirements and issue the COC's.  Issue COC's for entire electrical installation under this contract.","Sum",1,0,{"$f":"IF(D910 = CHAR(37), E910*F910/100,E910*F910)","v":0}]
[]
[589,null,"Maintenance"]
[]
[590,"B9.2","Provision of full maintenance of all electrical equipment and installation for the full period of 12 months/1 year of the maintenance period. The maintenance period starts on the practical completion. ","Sum",1,0,{"$f":"IF(D914 = CHAR(37), E914*F914/100,E914*F914)","v":0}]
[]
[1267,"B9.3","Any training to client and staff as stipulated.","Sum",1,0,{"$f":"IF(D916 = CHAR(37), E916*F916/100,E916*F916)","v":0}]
[]
[591,"B9.4","Update and prepare \"As Built\" drawings","Item",1,0,{"$f":"IF(D918 = CHAR(37), E918*F918/100,E918*F918)","v":0}]
[]
[592,"B11.5","Supply complete operating manuals of entire electrical installation","Item",4,0,{"$f":"IF(D920 = CHAR(37), E920*F920/100,E920*F920)","v":0}]
{"$rows_empty":43}
[null," Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(G906:G963)","v":0}]
[{"$nulls":3},"15"]
[null,"CSIR - ROSEBANK:  DATA CENTER"]
[null,"CONTRACT NO. 32874.00E-2026-01\u000f"]
[null,""]
[null,"BILL OF QUANTITIES"]
[{"$nulls":3},"SUMMARY OF SECTIONS"]
[null,"SECTION","DESCRIPTION",{"$nulls":3},"Amount R"]
[null,"A1","SECTION A:  PRELIMINARY AND GENERAL:  TIME, FIXED CHARGE, VALUE",{"$nulls":3},{"$f":"G65","v":0}]
[]
[null,"B1","SECTION B1:  DISTRIBUTION BOARDS",{"$nulls":3},{"$f":"G171","v":0}]
[]
[null,"B2","SECTION B2:  WIREWAYS, CONDUIT & ACCESSORIES",{"$nulls":3},{"$f":"G364","v":0}]
[]
[null,"B3","SECTION B3:  LIGHTING, INSTALLATION AND LIGHT FITTINGS",{"$nulls":3},{"$f":"G429","v":0}]
[]
[null,"B4","SECTION B4:  POWER OUTLET POINTS",{"$nulls":3},{"$f":"G497","v":0}]
[]
[null,"B5","SECTION B5:  ISOLATORS AND POWER SUPPLY",{"$nulls":3},{"$f":"G564","v":0}]
[]
[null,"B6","SECTION B6:  CABLES, WIRING AND EARTHWIRE",{"$nulls":3},{"$f":"G699","v":0}]
[]
[null,"8","SECTION B7:  ADDITIONAL SERVICES",{"$nulls":3},{"$f":"G756","v":0}]
[]
[null,"B10","SECTION B8:  ADDITIONAL ELECTRICAL SERVICES ",{"$nulls":3},{"$f":"G898","v":0}]
[]
[null,"B11","SECTION B9:  ELECTRICAL SERVICES - COMPLETION",{"$nulls":3},{"$f":"G964","v":0}]
[]
[null," Total Carried Forward To Summary Of Schedules",{"$nulls":4},{"$f":"SUM(G972:G991)","v":0}]
{"$rows_empty":41}
[{"$nulls":3},"16"]

{"sheet":"Rate Estimator","index":1,"n_rows":17,"n_cols":3,"rows_kept":17}
[]
[null,null,"To use a free rate estimator program with this Excel file"]
[]
[null,"1)","Download and install the program by clicking the link below and following instructions"]
[null,null,"Bill Project (demo mode)"]
[null,"2)","In MS Windows run the program using 'Start > Programs > Civilsoft > Bill Project'"]
[null,"3)","Once Bill Project is running use 'File > Open Excel Tender' and select this file, eg"]
[null,null,{"$f":"MID(CELL(\"filename\"),1,FIND(\"]\",CELL(\"filename\")))","v":{"$error":"#VALUE!"}}]
[null,"4)","Item rates can now be calculated by adding project resources to items"]
[null,"5)","For more information in Bill Project use 'Tools > Guide' and click on 'Rate Estimator'"]
[]
[null,null,"Note:"]
[null,null,"Although Bill Project will be set to demo mode, the rate estimator will have full functionality"]
[null,null,"Once rates have been calculated in Bill Project they can be exported using 'File > Export > Rate'"]
[]
[null,null,"If you need help with any of the above, click the link below or phone +27 (0)42 294 1777"]
[null,null,"Bill Project support"]