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

{"sheet":"Schedule 1.1","index":0,"n_rows":524,"n_cols":8,"rows_kept":524}
["Rate=G","CONTRACT NO. VCWB316/UPSHRMP/23"]
["<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>1</ScheduleNo>·    <SortNo>1</SortNo>·    <Description>Add 15% VAT</Description>·    <CalcType>%</CalcType>·    <CalcValue>15</CalcValue>·    <UseFirstSubTotal>false</UseFirstSubTotal>·    <ExclFromWorks>false</ExclFromWorks>·    <ExclFromProjected>false</ExclFromProjected>·  </SummaryItems>·</NewDataSet>","BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[199,"A","SANS 1200 A","SECTION A: PRELIMINARY AND GENERAL"]
[]
[413,"A1","8.3","Scheduled Fixed-Charge Items and Value-Related Items"]
[]
[414,"A1.1","8.3.1","Contractual Requirements","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E8 = CHAR(37), F8*G8/100,F8*G8)","v":{"v":0,"d":"R0.00"}}]
[]
[415,"A1.2",null,"Insurance on Pipes and Material","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E10 = CHAR(37), F10*G10/100,F10*G10)","v":{"v":0,"d":"R0.00"}}]
[]
[419,"A1.3","8.3.3","Other fixed-charge obligations"]
[]
[531,"a)",null,"Other (specify)","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E14 = CHAR(37), F14*G14/100,F14*G14)","v":{"v":0,"d":"R0.00"}}]
[]
[420,"A2","8.4","Scheduled Time-Related Items"]
[]
[421,"A2.1","8.4.1","Contractual Requirements","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E18 = CHAR(37), F18*G18/100,F18*G18)","v":{"v":0,"d":"R0.00"}}]
[]
[423,"A2.2",null,"Insurance: Main Coverage","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E20 = CHAR(37), F20*G20/100,F20*G20)","v":{"v":0,"d":"R0.00"}}]
[]
[424,"A2.3",null,"Supervision with off-loading","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E22 = CHAR(37), F22*G22/100,F22*G22)","v":{"v":0,"d":"R0.00"}}]
[]
[427,"A2.4","8.4.4","Company and head office overhead costs","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E24 = CHAR(37), F24*G24/100,F24*G24)","v":{"v":0,"d":"R0.00"}}]
[]
[428,"A2.6","8.4.5","Other time-related obligations"]
[]
[431,"a)",null,"Other (specify)","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E28 = CHAR(37), F28*G28/100,F28*G28)","v":{"v":0,"d":"R0.00"}}]
[]
[532,"A3",null,"Special Contract Items"]
[]
[432,"A3.1","B3.3","Training of Contractors Personnel","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E32 = CHAR(37), F32*G32/100,F32*G32)","v":{"v":0,"d":"R0.00"}}]
[]
[433,"A3.2","B3.3","Supervision for Testing of Pipelines and Issuing of Certificate for the GRP pipes","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E34 = CHAR(37), F34*G34/100,F34*G34)","v":{"v":0,"d":"R0.00"}}]
[]
[435,"A3.3","B3.3","Issuing of Certificate for Approval of Installation by the Contractor for the GRP pipes","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E36 = CHAR(37), F36*G36/100,F36*G36)","v":{"v":0,"d":"R0.00"}}]
[]
[439,"A3.4",null,"Attend Site Meetings arranged by the Engineer","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E38 = CHAR(37), F38*G38/100,F38*G38)","v":{"v":0,"d":"R0.00"}}]
[]
[440,"A3.5",null,"Site Visits for Inspection and Meetings: Traveling","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E40 = CHAR(37), F40*G40/100,F40*G40)","v":{"v":0,"d":"R0.00"}}]
[]
[448,"A3.6",null,"Accommodation during Site Visits","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E42 = CHAR(37), F42*G42/100,F42*G42)","v":{"v":0,"d":"R0.00"}}]
[]
[453,"A3.7","B3.4","Issue Certificates for Factory Inspections by Third Party Inspectors on all materials","Sum",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E44 = CHAR(37), F44*G44/100,F44*G44)","v":{"v":0,"d":"R0.00"}}]
[]
[590,"A3.8",null,"Quality control inspections by Third Party Inspector on all steel pipes, fittings and valves as approved by the Engineer","PC Sum",{"v":1,"d":"1.00"},{"v":150000,"d":"R150,000.00"},{"v":150000,"d":"R150,000.00"}]
[]
[591,"A3.9",null,"Mark-up on item A3.8","%",{"v":150000,"d":"150000.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E48 = CHAR(37), F48*G48/100,F48*G48)","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":16}
[null," Total Carried Forward To Summary",{"$nulls":5},{"$f":"SUM(H4:H64)","v":{"v":150000,"d":"R150,000.00"}}]
[{"$nulls":3},"1"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[533,"B",null,"SECTION B: PIPES, VALVES AND FITTINGS"]
[]
[534,null,null,"Supply, delivery and off loading of the following pipes, valves and fittings to site"]
[]
[559,"B1",null,"GRP PIPES AND FITTINGS"]
[]
[560,"B1.1",null,"GRP SN5000 pipe plain ended 6m/12m"]
[]
[561,"B1.1.1","31942.01S-141-01&02","600mm ND PN6 GRP SN5000 pipe plain ended 12m","No.",{"v":125,"d":"125.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E78 = CHAR(37), F78*G78/100,F78*G78)","v":{"v":0,"d":"R0.00"}}]
[]
[706,"B1.1.2","31942.01S-141-01&02","600mm ND PN6 GRP SN5000 pipe plain ended 6m","No.",{"v":250,"d":"250.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E80 = CHAR(37), F80*G80/100,F80*G80)","v":{"v":0,"d":"R0.00"}}]
[]
[562,"B1.1.3","31942.01S-141-03","800mm ND PN6 GRP SN5000 pipe plain ended 12m","No.",{"v":25,"d":"25.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E82 = CHAR(37), F82*G82/100,F82*G82)","v":{"v":0,"d":"R0.00"}}]
[]
[707,"B1.1.4","31942.01S-141-03","800mm ND PN6 GRP SN5000 pipe plain ended 6m","No.",{"v":50,"d":"50.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E84 = CHAR(37), F84*G84/100,F84*G84)","v":{"v":0,"d":"R0.00"}}]
[]
[563,"B1.2",null,"GRP double bell couplings"]
[]
[564,"B1.2.1",null,"600mm ND PN6 pressure coupling","No.",{"v":400,"d":"400.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E88 = CHAR(37), F88*G88/100,F88*G88)","v":{"v":0,"d":"R0.00"}}]
[]
[565,"B1.2.2",null,"600mm ND PN6 angled coupling","No.",{"v":20,"d":"20.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E90 = CHAR(37), F90*G90/100,F90*G90)","v":{"v":0,"d":"R0.00"}}]
[]
[566,"B1.2.3",null,"800mm ND PN6 sewer coupling","No.",{"v":65,"d":"65.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E92 = CHAR(37), F92*G92/100,F92*G92)","v":{"v":0,"d":"R0.00"}}]
[]
[567,"B1.3",null,"GRP Tees"]
[]
[568,"B1.3.1",null,"600mm ND PN6 plain ended Tee with 300mm ND flanged branch","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E96 = CHAR(37), F96*G96/100,F96*G96)","v":{"v":0,"d":"R0.00"}}]
[]
[569,"B1.3.2",null,"600mm ND PN6 plain ended Tee with 150mm ND flanged branch","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E98 = CHAR(37), F98*G98/100,F98*G98)","v":{"v":0,"d":"R0.00"}}]
[]
[585,"B1.3.3",null,"800mm ND PN6 plain ended Tee with 800mm ND access branch 1000mm high","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E100 = CHAR(37), F100*G100/100,F100*G100)","v":{"v":0,"d":"R0.00"}}]
[]
[570,"B1.4",null,"GRP Bends"]
[]
[571,"B1.4.1",null,"600mm ND 11.25° plain ended bend","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E104 = CHAR(37), F104*G104/100,F104*G104)","v":{"v":0,"d":"R0.00"}}]
[]
[572,"B1.4.2",null,"600mm ND 22.5° plain ended bend","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E106 = CHAR(37), F106*G106/100,F106*G106)","v":{"v":0,"d":"R0.00"}}]
[]
[586,"B1.4.3","31942.01S-143-03","800mm ND 90° plain ended bend with 800mm ND access branch 1000mm high","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E108 = CHAR(37), F108*G108/100,F108*G108)","v":{"v":0,"d":"R0.00"}}]
[]
[587,"B1.4.4","31942.01S-143-03","800mm ND 45° plain ended bend with 800mm ND access branch 1000mm high","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E110 = CHAR(37), F110*G110/100,F110*G110)","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":17}
[null," Total Carried Forward",{"$nulls":5},{"$f":"SUM(H70:H127)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"2"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[null," Brought Forward",{"$nulls":5},{"$f":"H128","v":{"v":0,"d":"R0.00"}}]
[573,"B2",null,"STEEL PIPES, VALVES AND FITTINGS"]
[]
[574,"B2.1","31942.01S-143-01","Scour Valve Chamber A1 Pipework, 2 pack carboguard epoxy system, minimum DFT of 350 microns according to SANS 1217 on all steel pipework. Flange drilling as per SANS 1123: 2015 Table 3 and Nominal Pressure Rating of 25 Bar."]
[]
[592,"B2.1.1",null,"600mm ND pipe section double flanged with puddle flange 600mm from flange, overall length 1200mm (item 1)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E138 = CHAR(37), F138*G138/100,F138*G138)","v":{"v":0,"d":"R0.00"}}]
[]
[593,"B2.1.2",null,"600mm ND one end flanged pipe section, overall length 1000mm (item 2)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E140 = CHAR(37), F140*G140/100,F140*G140)","v":{"v":0,"d":"R0.00"}}]
[]
[594,"B2.1.3",null,"600mm ND flanged ranger coupler (item 3)","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E142 = CHAR(37), F142*G142/100,F142*G142)","v":{"v":0,"d":"R0.00"}}]
[]
[595,"B2.1.4",null,"600mm ND flanged gate valve (item 4)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E144 = CHAR(37), F144*G144/100,F144*G144)","v":{"v":0,"d":"R0.00"}}]
[]
[596,"B2.1.5",null,"600 - 150mm ND all ends flanged t-piece, overall length 1000mm (item 5)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E146 = CHAR(37), F146*G146/100,F146*G146)","v":{"v":0,"d":"R0.00"}}]
[]
[597,"B2.1.6",null,"150mm ND pipe section with t-piece (item 6)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E148 = CHAR(37), F148*G148/100,F148*G148)","v":{"v":0,"d":"R0.00"}}]
[]
[598,"B2.1.7",null,"150mm ND all ends flanged pipe section with puddle flange 300mm from flange, overall length 600mm (item 7)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E150 = CHAR(37), F150*G150/100,F150*G150)","v":{"v":0,"d":"R0.00"}}]
[]
[599,"B2.1.8",null,"DN150mm, 100mm long pipe section, flanged one end, DN150mm ANSI B16.9 45° bend with bell mouth with diffuser vanes as per detail on drawing (item 8)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E152 = CHAR(37), F152*G152/100,F152*G152)","v":{"v":0,"d":"R0.00"}}]
[]
[600,"B2.1.9",null,"150mm ND flanged 90° segmented bend (item 9)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E154 = CHAR(37), F154*G154/100,F154*G154)","v":{"v":0,"d":"R0.00"}}]
[]
[601,"B2.1.10",null,"150mm ND flanged gate valve (item 10)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E156 = CHAR(37), F156*G156/100,F156*G156)","v":{"v":0,"d":"R0.00"}}]
[]
[602,"B2.1.11",null,"600mm ND pipe section all ends flanged with puddle flange 600mm from flange, other puddle flange 2000mm from flange, overall length 4000mm (item 11)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E158 = CHAR(37), F158*G158/100,F158*G158)","v":{"v":0,"d":"R0.00"}}]
[]
[603,"B2.1.12",null,"600mm ND long barrel flanged ranger coupler (item 12)","No.",{"v":8,"d":"8.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E160 = CHAR(37), F160*G160/100,F160*G160)","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":21}
[null," Total Carried Forward",{"$nulls":5},{"$f":"SUM(H133:H181)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"3"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[null," Brought Forward",{"$nulls":5},{"$f":"H182","v":{"v":0,"d":"R0.00"}}]
[588,"B2.2","31942.01S-143-02","Scour Valve Chamber A2 Pipework, 2 pack carboguard epoxy system, minimum DFT of 350 microns according to SANS 1217 on all steel pipework. Flange drilling as per SANS 1123: 2015 Table 3 and Nominal Pressure Rating of 40 Bar. "]
[]
[645,"B2.2.1",null,"600mm ND pipe section double flanged with puddle flange 600mm from flange, overall length 1200mm (item 1)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E190 = CHAR(37), F190*G190/100,F190*G190)","v":{"v":0,"d":"R0.00"}}]
[]
[646,"B2.2.2",null,"600 -250mm ND one end flanged unequal t-piece, refer to detail on drawing (item 2)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E192 = CHAR(37), F192*G192/100,F192*G192)","v":{"v":0,"d":"R0.00"}}]
[]
[647,"B2.2.3",null,"600mm ND flanged ranger coupler (item 3)","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E194 = CHAR(37), F194*G194/100,F194*G194)","v":{"v":0,"d":"R0.00"}}]
[]
[648,"B2.2.4",null,"600mm ND flanged gate valve (item 4)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E196 = CHAR(37), F196*G196/100,F196*G196)","v":{"v":0,"d":"R0.00"}}]
[]
[649,"B2.2.5",null,"600mm ND flanged nozzle check valve (item 5)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E198 = CHAR(37), F198*G198/100,F198*G198)","v":{"v":0,"d":"R0.00"}}]
[]
[650,"B2.2.6",null,"600 -250mm ND all ends flanged unequal t-piece, refer to detail on drawing (item 6)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E200 = CHAR(37), F200*G200/100,F200*G200)","v":{"v":0,"d":"R0.00"}}]
[]
[651,"B2.2.7",null,"600 - 150mm ND all ends flanged t-piece, overall length 1000mm (item 7)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E202 = CHAR(37), F202*G202/100,F202*G202)","v":{"v":0,"d":"R0.00"}}]
[]
[652,"B2.2.8",null,"250mm ND all ends flanged 90° short segmented bend (item 8)","No.",{"v":4,"d":"4.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E204 = CHAR(37), F204*G204/100,F204*G204)","v":{"v":0,"d":"R0.00"}}]
[]
[653,"B2.2.9",null,"250mm ND flange with orifice, 35mm thick (item 9)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E206 = CHAR(37), F206*G206/100,F206*G206)","v":{"v":0,"d":"R0.00"}}]
[]
[654,"B2.2.10",null,"250mm ND all ends flanged pipe section, overall length 435mm (item 10)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E208 = CHAR(37), F208*G208/100,F208*G208)","v":{"v":0,"d":"R0.00"}}]
[]
[655,"B2.2.11",null,"250mm flanged gate valve (item 11)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E210 = CHAR(37), F210*G210/100,F210*G210)","v":{"v":0,"d":"R0.00"}}]
[]
[656,"B2.2.12",null,"250mm ND all ends flanged pipe section with 90° short segmented bend, refer to detail on drawing (item 12)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E212 = CHAR(37), F212*G212/100,F212*G212)","v":{"v":0,"d":"R0.00"}}]
[]
[657,"B2.2.13",null,"150mm ND pipe section with t-piece (item 13)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E214 = CHAR(37), F214*G214/100,F214*G214)","v":{"v":0,"d":"R0.00"}}]
[]
[658,"B2.2.14",null,"150mm ND all ends flanged pipe section with puddle flange 300mm from flange, overall length 600mm (item 14)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E216 = CHAR(37), F216*G216/100,F216*G216)","v":{"v":0,"d":"R0.00"}}]
[]
[659,"B2.2.15",null,"DN150mm, 100mm long pipe section, flanged one end, DN150mm ANSI B16.9 45° bend with bell mouth with diffuser vanes as per detail on drawing (item 15)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E218 = CHAR(37), F218*G218/100,F218*G218)","v":{"v":0,"d":"R0.00"}}]
[]
[660,"B2.2.16",null,"150mm ND flanged 90° segmented bend (item 16)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E220 = CHAR(37), F220*G220/100,F220*G220)","v":{"v":0,"d":"R0.00"}}]
[]
[661,"B2.2.17",null,"150mm ND flanged gate valve (item 17)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E222 = CHAR(37), F222*G222/100,F222*G222)","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":10}
[null," Total Carried Forward",{"$nulls":5},{"$f":"SUM(H187:H232)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"4"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[null," Brought Forward",{"$nulls":5},{"$f":"H233","v":{"v":0,"d":"R0.00"}}]
[662,"B2.2.18",null,"600mm ND pipe section, all ends flanged with puddle flange 600mm from flange, other puddle flange 2000mm from flange, overall length 4000mm (item 18)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E239 = CHAR(37), F239*G239/100,F239*G239)","v":{"v":0,"d":"R0.00"}}]
[]
[663,"B2.2.19",null,"600mm ND long barrel flanged ranger coupler (item 19)","No.",{"v":6,"d":"6.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E241 = CHAR(37), F241*G241/100,F241*G241)","v":{"v":0,"d":"R0.00"}}]
[]
[584,"B2.3","31942.01S-158-01","3ML Reservoir Pipework, 2 pack carboguard epoxy system, minimum DFT of 350 microns according to SANS 1217 on all steel pipework. Flange drilling as per SANS 1123: 2015 Table 3 and Nominal Pressure Rating of 16 Bar."]
[]
[708,"B2.3.1",null,"600mm ND one ended flanged 90° segmented bend, c.t.f 610mm (item A01.2)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E245 = CHAR(37), F245*G245/100,F245*G245)","v":{"v":0,"d":"R0.00"}}]
[]
[709,"B2.3.2",null,"600mm ND ranger coupler (item A02)","No.",{"v":4,"d":"4.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E247 = CHAR(37), F247*G247/100,F247*G247)","v":{"v":0,"d":"R0.00"}}]
[]
[664,"B2.3.3",null,"600mm ND resilient seal gate valve (item A05)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E249 = CHAR(37), F249*G249/100,F249*G249)","v":{"v":0,"d":"R0.00"}}]
[]
[665,"B2.3.4",null,"600mm ND pipe with one end flanged, actual length to be determined on site, 1690mm (item A06)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E251 = CHAR(37), F251*G251/100,F251*G251)","v":{"v":0,"d":"R0.00"}}]
[]
[666,"B2.3.5",null,"600mm ND one end flanged 22.5° bend with one end pipe section welded onto bend, length to be determined on site (item A07)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E253 = CHAR(37), F253*G253/100,F253*G253)","v":{"v":0,"d":"R0.00"}}]
[]
[667,"B2.3.6",null,"600 - 300mm ND all ends flanged unequal t-piece, overall length 1520mm (item A08)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E255 = CHAR(37), F255*G255/100,F255*G255)","v":{"v":0,"d":"R0.00"}}]
[]
[668,"B2.3.7",null,"300 - 150mm ND standard flanged concentric reducer, overall length 230mm (item A09)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E257 = CHAR(37), F257*G257/100,F257*G257)","v":{"v":0,"d":"R0.00"}}]
[]
[669,"B2.3.8",null,"150mm ND resilient seal gate valve (item A10)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E259 = CHAR(37), F259*G259/100,F259*G259)","v":{"v":0,"d":"R0.00"}}]
[]
[670,"B2.3.9",null,"150mm ND flanged double-action air valve (Vent-O-Mat: Type RBX or similar approved) with closing valve (item A11)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E261 = CHAR(37), F261*G261/100,F261*G261)","v":{"v":0,"d":"R0.00"}}]
[]
[671,"B2.3.10",null,"600mm ND long barrel ranger coupler (item A12)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E263 = CHAR(37), F263*G263/100,F263*G263)","v":{"v":0,"d":"R0.00"}}]
[]
[672,"B2.3.11",null,"600mm ND bellmouth with other end flanged, overall length 5680mm (item B01)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E265 = CHAR(37), F265*G265/100,F265*G265)","v":{"v":0,"d":"R0.00"}}]
[]
[710,"B2.3.12",null,"600mm ND ranger coupler (item B03)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E267 = CHAR(37), F267*G267/100,F267*G267)","v":{"v":0,"d":"R0.00"}}]
[]
[711,"B2.3.13",null,"200mm ND ranger coupler (item C02)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E269 = CHAR(37), F269*G269/100,F269*G269)","v":{"v":0,"d":"R0.00"}}]
[]
[712,"B2.3.14",null,"200mm ND resilient seal gate valve (item C05)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E271 = CHAR(37), F271*G271/100,F271*G271)","v":{"v":0,"d":"R0.00"}}]
[]
[673,"B2.3.15",null,"600mm ND pipe section double flanged with puddle flange 600mm from flange, overall length 1200mm (item D01)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E273 = CHAR(37), F273*G273/100,F273*G273)","v":{"v":0,"d":"R0.00"}}]
[]
[674,"B2.3.16",null,"600 - 250mm ND one end flanged t-piece, overall length 1000mm (item D02)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E275 = CHAR(37), F275*G275/100,F275*G275)","v":{"v":0,"d":"R0.00"}}]
[]
[675,"B2.3.17",null,"600mm ND flanged ranger coupler (item D03)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E277 = CHAR(37), F277*G277/100,F277*G277)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
[]
[]
[]
[null," Total Carried Forward",{"$nulls":5},{"$f":"SUM(H238:H283)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"5"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[null," Brought Forward",{"$nulls":5},{"$f":"H284","v":{"v":0,"d":"R0.00"}}]
[676,"B2.3.18",null,"600mm ND flanged gate valve (item D04)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E290 = CHAR(37), F290*G290/100,F290*G290)","v":{"v":0,"d":"R0.00"}}]
[]
[677,"B2.3.19",null,"600mm ND flanged nozzle check valve (item D05)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E292 = CHAR(37), F292*G292/100,F292*G292)","v":{"v":0,"d":"R0.00"}}]
[]
[678,"B2.3.20",null,"600 - 150mm ND all ends flanged t-piece, overall length 1000mm (item D06)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E294 = CHAR(37), F294*G294/100,F294*G294)","v":{"v":0,"d":"R0.00"}}]
[]
[713,"B2.3.21",null,"150mm ND all ends flanged pipe section, with P/F 300mm from flange, o.a. 600mm (item D07)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E296 = CHAR(37), F296*G296/100,F296*G296)","v":{"v":0,"d":"R0.00"}}]
[]
[679,"B2.3.22",null,"150mm ND all ends flanged pipe section with puddle flange 300mm from flange, overall length 600mm (item D08)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E298 = CHAR(37), F298*G298/100,F298*G298)","v":{"v":0,"d":"R0.00"}}]
[]
[680,"B2.3.23",null,"150mm ND resilient seal flanged gate valve (item D09)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E300 = CHAR(37), F300*G300/100,F300*G300)","v":{"v":0,"d":"R0.00"}}]
[]
[681,"B2.3.24",null,"250 - 100mm ND standard flanged concentric reducer, overall length 205mm (item D13)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E302 = CHAR(37), F302*G302/100,F302*G302)","v":{"v":0,"d":"R0.00"}}]
[]
[682,"B2.3.25",null,"100mm ND flanged double-action air valve (Vent-O-Mat: Type RBX or similar approved) with closing valve (item D14)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E304 = CHAR(37), F304*G304/100,F304*G304)","v":{"v":0,"d":"R0.00"}}]
[]
[683,"B2.3.26",null,"100mm ND resilient seal flanged gate valve (item D15)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E306 = CHAR(37), F306*G306/100,F306*G306)","v":{"v":0,"d":"R0.00"}}]
[]
[684,"B2.3.27",null,"150mm ND flanged all ends 90° segmented bend, centre to face 350mm (item D17)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E308 = CHAR(37), F308*G308/100,F308*G308)","v":{"v":0,"d":"R0.00"}}]
[]
[685,"B2.3.28",null,"600mm ND long barrel flanged coupler (item D18)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E310 = CHAR(37), F310*G310/100,F310*G310)","v":{"v":0,"d":"R0.00"}}]
[]
[686,"B2.3.29",null,"600mm ND pipe section flanged all ends, puddle flange 500mm from flange, overall length 1110mm (item E01)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E312 = CHAR(37), F312*G312/100,F312*G312)","v":{"v":0,"d":"R0.00"}}]
[]
[687,"B2.3.30",null,"600mm ND standard magnetic flow meter, flanged all ends (item E02)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E314 = CHAR(37), F314*G314/100,F314*G314)","v":{"v":0,"d":"R0.00"}}]
[]
[702,"B2.4","31942.01S-158-02","Suction Pipework, 2 pack carboguard epoxy system, minimum DFT of 350 microns according to SANS 1217 on all steel pipework. Flange drilling as per SANS 1123: 2015 Table 3 and Nominal Pressure Rating of 16 Bar."]
[]
[688,"B2.4.1",null,"600mm ND one end flanged unequal t-piece, overall length 2020mm (item F01)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E318 = CHAR(37), F318*G318/100,F318*G318)","v":{"v":0,"d":"R0.00"}}]
[]
[689,"B2.4.2",null,"600mm ND flanged all ends pipe section, overall length 6000mm (item F02)","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E320 = CHAR(37), F320*G320/100,F320*G320)","v":{"v":0,"d":"R0.00"}}]
[]
[690,"B2.4.3",null,"600mm ND flanged all ends pipe section, overall length 1280mm (item F03)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E322 = CHAR(37), F322*G322/100,F322*G322)","v":{"v":0,"d":"R0.00"}}]
[]
[691,"B2.4.4",null,"600mm ND flanged all ends 45° segmented bend, centre to face 305mm (item F04)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E324 = CHAR(37), F324*G324/100,F324*G324)","v":{"v":0,"d":"R0.00"}}]
[]
[692,"B2.4.5",null,"600mm ND flanged all ends pipe section, overall length 1580mm (item F05)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E326 = CHAR(37), F326*G326/100,F326*G326)","v":{"v":0,"d":"R0.00"}}]
[]
[734,"B2.4.6",null,"600mm ND Standard Ranger coupler PN25 (Item F06)","No.",{"v":2,"d":"2.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E328 = CHAR(37), F328*G328/100,F328*G328)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null," Total Carried Forward",{"$nulls":5},{"$f":"SUM(H289:H330)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"6"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[null," Brought Forward",{"$nulls":5},{"$f":"H331","v":{"v":0,"d":"R0.00"}}]
[703,"B2.5","31942.01S-143-04","Henkriesmond - Sump & Butterfly Valve Chamber Pipework, 2 pack carboguard epoxy system, minimum DFT of 350 microns according to SANS 1217 on all steel pipework. Flange drilling as per SANS 1123: 2015 Table 3 and Nominal Pressure Rating of 16 Bar."]
[]
[694,"B2.5.1",null,"600mm ND bellmouth with other end flanged, overall length 1150mm (item A01)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E339 = CHAR(37), F339*G339/100,F339*G339)","v":{"v":0,"d":"R0.00"}}]
[]
[695,"B2.5.2",null,"600mm ND flanged butterfly valve (item A02)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E341 = CHAR(37), F341*G341/100,F341*G341)","v":{"v":0,"d":"R0.00"}}]
[]
[696,"B2.5.3",null,"600mm ND Vicking Johnson dismantling valve (item A03)","No.",{"v":3,"d":"3.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E343 = CHAR(37), F343*G343/100,F343*G343)","v":{"v":0,"d":"R0.00"}}]
[]
[697,"B2.5.4",null,"600mm ND pipe section one end flanged, actual size to be determined on site, 1200mm (item A04)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E345 = CHAR(37), F345*G345/100,F345*G345)","v":{"v":0,"d":"R0.00"}}]
[]
[698,"B2.5.5",null,"600mm ND pipe section all ends flanged, puddle flange 600mm from flange, overall length 1200mm (item A05)","No.",{"v":1,"d":"1.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E347 = CHAR(37), F347*G347/100,F347*G347)","v":{"v":0,"d":"R0.00"}}]
[]
[704,"B2.6",null,"Gate Valves"]
[]
[705,"B2.6.1",null,"150mm ND medium pressure 40 Bar flanged gate valve","No.",{"v":20,"d":"20.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E351 = CHAR(37), F351*G351/100,F351*G351)","v":{"v":0,"d":"R0.00"}}]
[]
[714,"B2.6.2",null,"250mm Butterfly valves at Sand filters","No.",{"v":24,"d":"24.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E353 = CHAR(37), F353*G353/100,F353*G353)","v":{"v":0,"d":"R0.00"}}]
[]
[715,"B2.6.3",null,"250mm Gate valves at Sand filters","No.",{"v":24,"d":"24.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E355 = CHAR(37), F355*G355/100,F355*G355)","v":{"v":0,"d":"R0.00"}}]
[]
[716,"B2.7",null,"Air Valves"]
[]
[717,"B2.7.1",null,"50mm ND Vent-O-Mat (or similar approved), 40 Bar","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E359 = CHAR(37), F359*G359/100,F359*G359)","v":{"v":0,"d":"R0.00"}}]
[]
[718,"B2.7.2",null,"100mm ND Vent-O-Mat (or similar approved), 40 Bar","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E361 = CHAR(37), F361*G361/100,F361*G361)","v":{"v":0,"d":"R0.00"}}]
[]
[719,"B2.7.3",null,"150mm ND Vent-O-Mat (or similar approved), 40 Bar","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E363 = CHAR(37), F363*G363/100,F363*G363)","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":24}
[null," Total Carried Forward",{"$nulls":5},{"$f":"SUM(H336:H387)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"7"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[null,"ITEM\nNO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT R"]
[null," Brought Forward",{"$nulls":5},{"$f":"H388","v":{"v":0,"d":"R0.00"}}]
[575,"B3",null,"uPVC PIPES AND FITTINGS"]
[]
[535,"B3.1",null,"Perforated uPVC Drainage Pipe"]
[]
[537,"B3.1.1",null,"160mm ND uPVC pipe","m",{"v":6200,"d":"6200.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E398 = CHAR(37), F398*G398/100,F398*G398)","v":{"v":0,"d":"R0.00"}}]
[]
[589,"B4",null,"VALVES FOR 600mm ND PN6 GRP SN5000 PIPELINE"]
[]
[578,"B4.1",null,"Air Valves"]
[]
[579,"B4.1.1","31942.01S-143-04","Air valve on 600mm ND PN6 GRP SN5000 pipeline complete with gate valve, standpipe, gaskets, bolts and nuts as per drawing","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E404 = CHAR(37), F404*G404/100,F404*G404)","v":{"v":0,"d":"R0.00"}}]
[]
[580,"B4.2",null,"Scour Valves"]
[]
[581,"B4.2.1","31942.01S-143-05","Scour valve on 600mm ND PN6 GRP SN5000 pipeline complete with pipes, gate valves, gaskets, bolts and nuts as per drawing","No.",{"v":5,"d":"5.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E408 = CHAR(37), F408*G408/100,F408*G408)","v":{"v":0,"d":"R0.00"}}]
[]
[724,"B5",null,"650mm STEEL RISING MAIN PIPELINE, 8mm WALL THICKNESS"]
[]
[725,"B5.1",null,"650mm ND PN40 plain ended equal tee with 500mm flanged branch","No.",{"v":10,"d":"10.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E412 = CHAR(37), F412*G412/100,F412*G412)","v":{"v":0,"d":"R0.00"}}]
[]
[726,"B5.2",null,"12m x 650mm ND mild steel, 8mm wall thickness, cement mortar on inside, sintakote, PN40 pipe","No.",{"v":85,"d":"85.00"},{"v":0,"d":"R0.00"},{"$f":"IF(E414 = CHAR(37), F414*G414/100,F414*G414)","v":{"v":0,"d":"R0.00"}}]
{"$rows_empty":36}
[null," Total Carried Forward To Summary",{"$nulls":5},{"$f":"SUM(H393:H450)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"8"]
[null,"CONTRACT NO. VCWB316/UPSHRMP/23"]
[null,"BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS"]
[{"$nulls":3},"SUMMARY OF SECTIONS"]
[null," ","SECTION","DESCRIPTION",{"$nulls":3},"AMOUNT R"]
[null,null,"A","SECTION A: PRELIMINARY AND GENERAL",{"$nulls":3},{"$f":"H65","v":{"v":150000,"d":"R150,000.00"}}]
[]
[null,null,"2","SECTION B: PIPES, VALVES AND FITTINGS",{"$nulls":3},{"$f":"H451","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":3},"   SUBTOTAL",{"$nulls":3},{"$f":"SUM(H457:H460)","v":{"v":150000,"d":"R150,000.00"}}]
[]
[{"$nulls":3},"Add 15% VAT",{"$nulls":3},{"$f":"H461*15/100","v":{"v":22500,"d":"R22,500.00"}}]
[null,null," Total Carried Forward To Summary Of Schedules"," Total Carried Forward To Summary Of Schedules",{"$nulls":3},{"$f":"SUM(H461:H463)","v":{"v":172500,"d":"R172,500.00"}}]
{"$rows_empty":59}
[{"$nulls":3},"9"]

{"sheet":"Summary Of Schedules 1","index":1,"n_rows":71,"n_cols":8,"rows_kept":71}
["Rate=G","CONTRACT NO. SW-SDPVF4-201922"]
[{"$nulls":3},"SUMMARY OF SCHEDULES"]
[null," ","SCHEDULE","DESCRIPTION",{"$nulls":3},"AMOUNT R"]
[null,null,"1","BILL OF QUANTITIES: SUPPLY AND DELIVERY OF PIPES, VALVES AND FITTINGS",{"$nulls":3},{"$f":"'Schedule 1.1'!H464","v":172500}]
[]
[null,null," Total Carried Forward To Summary Of Contracts"," Total Carried Forward To Summary Of Contracts",{"$nulls":3},{"$f":"SUM(H4:H5)","v":172500}]
{"$rows_empty":64}
[{"$nulls":3},"10"]

{"sheet":"Rate Estimator","index":2,"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"]