{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["001","002","101","105","108","202","402","403","406","505","801","801.12","903","1003","Summary"],"not_rendered":{"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"001","index":0,"n_rows":26,"n_cols":7,"rows_kept":26}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 0 : GENERAL "]
[null,null,"SECTION 001 : GENERAL REQUIREMENTS AND CHARGES"]
["00 1.01",null,"Preliminary and General charges:"]
["001.01.01",null,"Fixed charges","Sum",1]
["001.01.02",null,"Time-related charges","Month",12]
["001.04",null,"Compliance with the Occupational Health and Safety Act and applicable regulations"]
["001.04.01",null,"Compilation of a Health and Safety Plan","Sum",1]
["001.04.02",null,"Provision of a Health and Safety file","Sum",1]
["001.04.03",null,"Provision of construction supervisors","Month",12]
["001.04.04",null,"Provision of a full-time Safety Officer","Month",12]
["001.04.05",null,"Health and Safety Training","Sum",1]
["B001.05",null,"Community Liaison Officer (Refer to Section C3.4: Construction (Specification) Clause C3.4.7.4)","Month",12,{"v":16905,"d":"R16,905.00"},{"$f":"E14*F14","v":{"v":202860,"d":"R202,860.00"}}]
[]
["B001.05.01",null,"Contractor's mark up on item B001.05 (limit to maximum of 10%)","%",null,{"v":169050,"d":"R169,050.00"}]
[]
["B001.06",null,"Targeted labourers                                   ","Prov Sum",1,{"v":200000,"d":"200,000.00"},{"$f":"SUM(E18*F18)","v":{"v":200000,"d":"200,000.00"}}]
[]
[]
[]
[]
[]
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"002","index":1,"n_rows":27,"n_cols":7,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 0 : GENERAL "]
["002",null,"SECTION 002 : ENGINEERS'S ACCOMMODATION"]
["002.01",null,"Services:"]
["002.01.01",null,"Services for offices and laboratories","Sum",1]
["002.01.02",null,"Services for cooking and ablution facilities on Site for the Engineer's Site staff","Sum",1]
["002.02","LI","Treatment and maintenance of areas surrounding offices and laboratories","Sum",1]
["002.03",null,"Office and laboratory accommodation","Sum",1]
["002.04",null,"Provision of survey equipment and assistants","Sum",1]
["002.05",null,"Project name boards (see detail attached)","No",1]
{"$rows_empty":13}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"101","index":2,"n_rows":28,"n_cols":7,"rows_kept":28}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 1 : ANCILLARY WORK"]
[101,null,"SECTION 101 : SITE CLEARING AND GRUBBING"]
[101.01,null,"Clearing and grubbing:"]
["101.01.01","SC","Areas (Reservoir site)","m²",60]
["101.01.02","SC","Strips (4 m wide on pipeline route north of reservoir)","m",36]
[101.04,null,"Re-clearing areas (only on the written instructions of the Engineer)"]
["101.04.01 ","SC","Strips (4 m wide on pipeline route)","m",60]
["101.04.02 ","SC","Areas not classified as strips ( roads and parking )","m²",30]
[101.05,null,"Removal and disposal of specific elements"]
["101.05.01","SC","Concrete kerbing / kerbing combination","m",5]
["101.05.02","SC","Concrete or brick elements (reinforced or unreinforced)","m³",12]
["101.05.02.01","SC","Foundations and floor slabs of building / valve boxes","m³",10]
["101.05.02.02 ","SC","Walls of building / valve boxes","m³",10]
[null,null,{"$f":"'002'!C12","v":0}]
{"$rows_empty":9}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"105","index":3,"n_rows":27,"n_cols":7,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 1 : ANCILLARY WORK"]
[105,null,"SECTION 105 : FENCING"]
[105.01,"SC","Supply and erection of new fencing material "]
["105.01.09",null,"Fencing to match existing( See drawing No.2410141-CV-004)","m",145]
["105.01.10",null,"Remove existing sections and replace with new sections to match, sections are not continuous","m",12]
[105.02,"SC","New gates"]
["105.02.02.01",null,"Sliding  gate, 6 metres wide, to suit existing fence, gms gate with corrosion protection of steel work (See drawing No.2410141-CV-004)","No",1]
[105.05,"SC","The drilling and blasting of holes for posts and anchors","No",50]
{"$rows_empty":14}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"108","index":4,"n_rows":27,"n_cols":7,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["B108",null,"SECTION 108 : REMOVAL OF VANDALISED ITEMS "]
["B108.01",null,"Vandalized 600mm Bulk Meter","no.",{"v":1,"d":"1.00"}]
["B108.02",null,"Vandalized 400mm diameter Butterfly Valve ","no.",{"v":2,"d":"2.00"}]
["B108.03",null,"Vandalized 600mm diameter Butterfly Valve ","no.",{"v":1,"d":"1.00"}]
["B108.04",null,"Damaged Concrete Cover slabs","no.",{"v":8,"d":"8.00"}]
{"$rows_empty":17}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"202","index":5,"n_rows":27,"n_cols":7,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 2 : EARTHWORKS"]
[202,null,"SECTION 202 : TRENCHING"]
[202.01,null,"Trench excavations"]
["202.01.02",null,"Over 1,0 m and up to 2,0 m wide"]
["202.01.02.01",null,"Up to 2,0 m deep","m³",{"$f":"40*1*2","v":80}]
[202.02,null,"Extra over item 202.01 for excavating in"]
["202.02.01",null,"Intermediate material","m³",20]
["202.02.02",null,"Hard material","m³",60]
[202.03,null,"Excavations outside the normal trench profile","m³",30]
[202.04,"LI","Hand excavation (extra over item 202.01)","m³",10]
[202.06,"LI","The backfilling of trenches (excluding selected backfill around /and the pipe barrel) with material obtained from excavations","m³",50]
[202.07,null,"Extra over items 202.06 for using backfill material obtained"]
["202.07.02",null,"From sources provided by Contractor","m³",100]
{"$rows_empty":9}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"402","index":6,"n_rows":60,"n_cols":7,"rows_kept":60,"merged":[[19,0,19,5],[21,0,21,4],[21,5,21,6],[22,0,22,4],[22,5,22,6],[25,0,25,5]]}
["ITEM","LI / SC","DESCRIPTION","UNIT"," QUANTITY "," RATE "," AMOUNT "]
[]
[null,null,"SERIES 4 : WATER RETICULATION AND WATER MAINS"]
[402,null,"SECTION 402 : CONSTRUCTION"]
["402.01",null,"Supplying, laying and jointing of water pipes irrespective of depth"]
["402.01.01",null,"Submerged arc  fillet welded mild steel pipe to SANS 719 from Grade X42/300 WA steel with bell-end to BS 534, fusion bonded medium density polyethylene  external coating to Table 1 of AS 4321-1995 with liquid epoxy  internal lining."]
["402.01.01.01",null,"150 mm Nom.(154 mm Act.) diameter x 4,5mm wall thickness 16 bar working pressure","m",6]
["402.01.01.02",null,"200 mm Nom.(204 mm Act.) diameter x 4,5mm wall thickness 16 bar working pressure","m",6]
["402.01.01.03",null,"400 mm Nom.(406,4 mm Act.) diameter x 4,5mm wall thickness, 16 bar working pressure with flange both side to match the existing flange on site.","m",36]
["402.01.02",null,"Submerged arc spiral welded mild steel pipe butt welded to SANS 719 from Grade X42/300 WA steel with bevelled-end to BS 534, fusion bonded medium density polyethylene  external coating to Table 1 of AS 4321-1995 and liquid epoxy  internal lining. All welding of joints to be wrapped"]
["402.01.02.01",null,"600 mm Nom(609,6 mm Act.) diameter x 6,0mm wall thickness 16 bar working pressure","m",6]
[402.02,null,"Extra over item 402.01 for providing and installing fittings, valves and specials:"]
["402.02.01",null,"Chamfer cutting of pipe ends in items 402.01.01.01, 402.01.01.02, 402.01.02.01 & 402.01.02.02 to alter direction (form bends) on site including the reinstating of internal linings (liquid epoxy ) and external coatings (fusion bonded medium density polyethylene ). All welding of joints to be  wrapped, "]
["402.02.01.01",null,"200 mm diameter up to 11,25º","No",1]
["402.02.01.02",null,"400 mm diameter up to 11,25º","No",1]
["402.02.01.03",null,"600mm diameter up to 11,25º","No",1]
["402.02.02",null,"Long radius pressure bends circular welded mild steel pipe from Grade 300 WA steel to SANS 1431, fusion bonded medium density polyethylene  external coating to Table 1 of AS 4321-1995 and liquid epoxy. All welding of joints to be  wrapped"]
["402.02.02.01",null,"200 mm diameter, 45º ","No",2]
["402.02.02.02",null,"400 mm diameter, 45º","No",4]
["TOTAL CARRIED FORWARD"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":4},"Date"]
[]
["ITEM","LI / SC","DESCRIPTION","UNIT"," QUANTITY "," RATE "," AMOUNT "]
[]
["TOTAL BROUGHT FORWARD"]
["402.02.03.03",null,"400 mm diameter class 16 drilled to T1600/3 (F - F = 222 mm)","No",1]
["402.02.03.04",null,"600 mm diameter class 16 drilled to T1600/3 (F - F = 229 mm)","No",1]
["402.02.06",null,"SCOUR VALVES Resilient seal, SANS 664 specification, ductile iron body & gate, stainless steel non-rising spindle, anti-clockwise closing, handwheel operated, double flanged and drilled to SANS 1123. Manufacturers standard epoxy paint to of 250 microns."]
["402.02.06.01",null,"200mm diameter Class 16 Drilled to T1600/3 (F - F = 254mm)","No",1]
["402.02.07",null,"AIR RELEASE & VACUUM BREAK VALVES : Valves shall comply with specifications"]
["402.02.07.01",null,"100 mm diameter Class 16 Drilled to T1600/3 (Flange to Top of Cap = 369mm)","No",1]
["402.02.11",null,"BULK WATER METER : Sensus in-line through flow, mechanical turbine flanged Water Meter, 16 bar rated, cast iron body, double flanged and drilled to SANS 1123 T1600/3. Manufacturer's standard epoxy coating. 40º C.  See Performance Specification."]
["402.02.11.03",null,"500 mm diameter Class 16 Drilled to T1600/3 ","No",1]
["402.02.12",null,"STRAINER : Strainer to comply to drawing 2410141 - cv - 007 item C"]
["402.02.12.02",null,"400 mm diameter class 16 drilled to T 1600/3","No",1]
["402.02.15",null,"SPECIALS & FITTINGS : Grade 304L Stainless Steel Pipe and Fittings "]
["402.02.15.01",null,"Inlet pipe, 400 mm diameter","No",1]
["402.02.15.02",null,"Outlet pipe, 600 mm diameter","No",1]
["402.02.15.03",null,"Scour pipe, 200 mm diameter","No",1]
["402.02.15.04",null,"Overflow pipe, 450 mm diameter","No",1]
[402.03,null,"Encasement of pipes with:"]
["402.03.01",null,"Class 15/19 concrete","m³",30]
["402.03.02",null,"Soilcrete","m³",10]
[402.04,"LI","Providing thrust blocks using class 15MPa/19 mm concrete","m³",11]
[402.05,null,"Supplying and placing unscreened selected backfill material under, alongside and up to 200 mm above pipe barrel using:"]
["402.05.01 ","LI","Excavated material","m³",40]
["402.05.02","LI","Imported material from sources provided by the Contractor","m³",80]
[402.06,"LI","Extra over item 402.05 for screening excavated material for selected backfill","m³",30]
[402.07,null,"Valve chambers"]
["402.07.01",null,"40 mm x 40 mm mentis grating  covers to valve chambers, cut to suit various chambers, as per detail drawing","m²",20]
["402.07.02","SC","Construction of valve chambers slab, using pre-cast concrete slab"]
["402.07.02.02",null,"Slab for Valve chamberof  isolating valves, 2,5 m x 2,5 m, , mentis grating (Chamber has been constructed and floor slab are on site without lead cover) price must be for installation and supply of lead as per drawing no.7515-VC223","No",8]
[402.1,null,"Sterilizing of pipelines:"]
["402.10.01",null,"200 mm diameter steel pipe","m",85]
["402.10.02",null,"400 mm diameter steel pipe","m",120]
["402.10.03",null,"600 mm diameter steel pipe","m",60]
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"403","index":7,"n_rows":27,"n_cols":7,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 4 : WATER RETICULATION AND WATER MAINS"]
[403,null,"SECTION 403 : TESTING"]
[403.01,null,"Hydraulic field-testing of pipelines:"]
["403.01.01",null,"200 mm diameter","m",80]
["403.01.02",null,"300 mm diameter","m",105]
["403.01.03",null,"400 mm diameter","m",120]
["403.01.04",null,"600 mm diameter","m",110]
[403.13,null,"Sterilisation of  pipeline"]
["403.13.01",null,"200 mm diameter","m",80]
["403.13.02",null,"300 mm diameter","m",105]
["403.13.03",null,"400 mm diameter","m",120]
["403.13.04",null,"600 mm diameter","m",110]
{"$rows_empty":10}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"406","index":8,"n_rows":27,"n_cols":9,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT"," QUANTITY "," RATE "," AMOUNT "]
[]
[null,null,{"$f":"'402'!C3","v":"SERIES 4 : WATER RETICULATION AND WATER MAINS"}]
[406,null,"SECTION 406 : VALVES AND HYDRANTS: COMPLETION OF ALL OUTSTANDING COMPONENTS AND MODIFICATIONS ON THE 400MM SINGER ALTITUDE CONTROL VALVES – MAIN LINE VALVES IN THE VALVE CHAMBER HOUSE ((Refer to Part C3_Scope of Work - Engineering Specifications Section E)"]
["B406.01",null,"Supply, Modify and install Singer model #S106-A-Type-2-RF-SC-AC comb. altitude, rate of flow, solenoid shut off & Anti-Cavitation valve, complete auxiliary control pilot system, to be installed onto existing control valve on-site.  ","Sum",1,{"$nulls":3},85022]
["B406.02",null,"Supply, Modify and installation Singer Model #X156 Linear inductive valve position indicator to be installed onto existing control valve on-site.","Sum",1,{"$nulls":3},82354]
["B406.03",null,"Supply, Modify and install Singer Model #SPI single point insertion meter complete with 5meters of cabling and convertor box to be installed onto existing control valve on-site ","Sum",1,{"$nulls":3},35952]
["B406,04",null,"Supply, Modify and install Singer model #S106-A-Type-2-RF-SC-AC comb. altitude, rate of flow, solenoid shut off & Anti-Cavitation valve, complete auxiliary control pilot system, to be installed onto existing control valve on-site.","Sum",1,{"$nulls":3},31980]
["B406.05",null,"Supply, Modify and installation of all outstanding Components - Singer Model #X156 Linear inductive valve position indicator to be installed onto existing control valve on-site. ","Sum",1,{"$nulls":3},192815]
["B406.06",null,"Supply, Modify and install - Singer Model #SPI single point insertion meter complete with 5meters of cabling and convertor box to be installed onto existing control valve on-site.","Sum",1,{"$nulls":3},183507]
{"$rows_empty":14}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"505","index":9,"n_rows":27,"n_cols":7,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 5 : DRAINAGE AND EROSION PROTECTION"]
[505,null,"SECTION 505 : EROSION PROTECTION"]
[505.01,null,"Foundation trench excavation and backfilling:"]
["505.01.02",null,"In all other classes of material","m³",58]
[505.02,"SC","Surface preparation for the bedding of gabions","m²",60]
[505.03,"SC","Gabions"]
["505.03.01",null,"Gabion boxes (4x 2 x 1m box from 80 x 100 x 2,7mm Class A galvanized wire mesh )","m³",{"$f":"64*2*1","v":128}]
["505.03.02",null,"Gabion mattresses (4 x 1 x 1m mattresses, 80 x 100 2,5mm Class A galvanized wire) ","m³",{"$f":"65*1*1","v":65}]
["505.03.03",null,"Gabion mattresses (4 x 1 x ,5m mattresses, 80 x 100 2,5mm Class A galvanized wire) ","m132",{"$f":"65*1*0.5","v":32.5}]
[505.05,"SC","Filter fabric for precast retaining wall blocks, gabions and riprap (U24 geotextile or similar)","m²",{"v":1120,"d":"1,120.00"}]
[505.06,"SC","Stone pitching"]
["505.06.01",null,"Plain pitching"]
["505.06.01.01 ",null,"Method 1","m²",35]
["505.06.02 ",null,"Grouted pitching","m²",{"$f":"E15*0.15","v":{"v":5.25,"d":"5"}}]
["505.06.03 ",null,"Wired and grouted pitching","m²",{"$f":"E16","v":{"v":5.25,"d":"5"}}]
[505.09,null,"Concrete pitching"]
["505.09.01",null,"Cast in situ concrete pitching (20 MPa of concrete and 150 mm thickness of pitching )","m²",45]
[]
[]
[]
[]
[]
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"801","index":10,"n_rows":32,"n_cols":7,"rows_kept":32}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 8 : SPECIFIC WORKS"]
[801,null,"SECTION 801 : CONCRETE RESERVOIRS"]
[801.01,null,"Crushed stone on reservoir roof, 26,5 mm aggregate  ( archaic granite – Muldersdrift or similar )","m³",10]
[801.02,null,"Lightning protection  (Tenderer to supply detail)","Sum",1]
[801.03,null,"Miscellaneous Items "]
["801.03.01",null,"Measured by Number "]
["801.03.01.01",null,"Access Ladder "]
["801.03.01.01.01",null,"Internal ladder as per detail on Drawing 2410141-CV-008","No",1]
["801.03.01.01.02",null,"External ladder as per detail on Drawing 2410141-CV-008","No",1]
["801.03.02",null,"Measured by linear meter"]
["801.03.02.01",null,"Hand Railing"]
["801.03.02.01.01",null,"Standard Industrial type hot-dipped galvanised Ball Type Hand Railing to stairs and landing including, degreasing priming and twice painting with enamel paint (Black and Yellow)","m",20]
[801.04,null,"Sterilization of reservoir","sum",1]
[801.05,null,"Testing the reservoir for water tightness ","sum",1]
["B801.03.06",null,"Supply and install level indicators- maintenance free, durable, indicator to be fixed to wall of reservoir, tenderer to submit proposals for the following:"]
["B801.03.06.01",null,"a)  5 Ml reservoir, existing ","No",1]
["B801.03.06.02",null,"b)  1,2 Ml reservoir, existing ","No",1]
["B801.03.06.03",null,"c)  10 Ml reservoir, new","No",1]
{"$rows_empty":9}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"801.12","index":11,"n_rows":21,"n_cols":7,"rows_kept":21}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 8 : SPECIFIC WORKS"]
["B801.12",null,"SECTION 801 : CONCRETE RESERVOIRS  - SEALING"]
["B801.12.01",null,"The City of Tshwane reserves the rights to reduce this scope of work (Items below) based on the outcomes of physical conditional assessment of reservoir existing seal and after water tightness done test results. The Concrete reservoir Sealing to be done by suitable accredited specialists approved by the engineer."]
["B801.12.01.01",null," Site establishment, HIRA and safety file compliance","Sum",1]
["B801.12.01.02",null,"Cleaning of substrate - mechanical and chemical as required","Sum",1]
["B801.12.01.03",null,"Application of base coat to total inside of reservoir - floor, wall and roof","m2",{"v":3585,"d":"3,585"}]
["B801.12.01.04",null," Installation of  waterproofing system on floor and inside wall of reservoir","m2",2485]
["B801.12.01.05",null,"Application of  fibre with flex for positive seal (250mm vertical and horizontal overlap) from floor to wall","Sum",1]
["B801.12.01.06",null,"Application of fibre with flex for positive seal (250mm vertical and horizontal overlap) from roof to wall","Sum",1]
["B801.12.01.07",null,"Application of Seal protective coat over Base system on floor and inside wall of reservoir","m2",2485]
["B801.12.01.08",null," Application of Dampend final coat over floor, wall and roof of reservoir (Block brush finish)","m2",2486]
["B801.12.01.09",null,"Application of fibre (500mm overlap roof & wall) on outside of reservoir over construction joint between roof and wall","Sum",1]
["B801.12.01.10",null,"Application of final UV stable Seal  layer (2 coats) over Fibre (500mm overlap) on outside of reservoir","Sum",1]
["B801.12.01.11",null," Site clearing and de-establishment","Sum",1]
["B801.12.01.12",null,"Emptying of reservoir and testing of the relined reservoir for water tightness ","Sum",1]
[]
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"903","index":12,"n_rows":27,"n_cols":7,"rows_kept":27}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SERIES 9 : QUALITY CONTROL"]
[903,null,"SECTION 903 : TESTING"]
[903.04,null,"Special tests on welded  \n specimens "]
["903.04.01",null,"Specimen welded connection - 400mm diameter steel pipe\n ","No ",5]
["903.04.02",null,"Specimen welded connection - 200mm diameter steel pipe\n ","No ",2]
{"$rows_empty":17}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"1003","index":13,"n_rows":24,"n_cols":7,"rows_kept":24}
["ITEM","LI / SC","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 1003 : ENERGISING,PRE COMMISSIONING AND HAND-OVER"]
["B1003.1",null,"Supply, install and commissioning Electrical Distribution Board(Power requirement minimum 24V DC) in the Valve Chamber Building","Sum",1]
["B1003.2",null,"Supply, install and commissioning, Energising of CP TRU530 ","Sum",1]
["B1003.3",null,"Set-Up and Pre-Commissioning of TRU","Sum",1]
["B1003.4",null,"Commissioning - Data Logging","Sum",1]
["B1003.5",null,"Manufacturers Operating and Maintenance Manuals - Electrical","Sum",1]
["B1003.6",null,"Electrical C.O.C CP System","No",1]
{"$rows_empty":12}
["TOTAL CARRIED TO SUMMARY"]
[]
["Signature of person authorised to sign the tender:",{"$nulls":3},"Date:"]

{"sheet":"Summary","index":14,"n_rows":29,"n_cols":3,"rows_kept":29,"merged":[[0,2,0,3],[15,0,15,1],[17,0,17,1],[19,0,19,1],[21,0,21,1]]}
["Section","Description","Amount"]
["001","GENERAL REQUIREMENTS AND CHARGES","R"]
["002","ENGINEER’S ACCOMMODATION","R"]
[101,"SITE CLEARING AND GRUBBING","R"]
[105,"FENCING","R"]
[108,"REMOVAL OF VANDALISED ITEMS & DELIVER THEM TO CITY OF TSHWANE METROPOLITAN DEPOT","R"]
[202,"TRENCHING","R"]
[402,"CONSTRUCTION","R"]
[403,"TESTING","R"]
[406,"VALVES AND HYDRANTS: COMPLETION OF ALL OUTSTANDING COMPONENTS AND MODIFICATIONS ON THE 400MM SINGER MODEL ELECTRONIC ALTITUDE CONTROL VALVES IN THE VALVE CHAMBER HOUSE","R"]
[505,"EROSION PROTECTION","R"]
[801,"CONCRETE RESERVOIRS","R"]
["801.12",{"$f":"'801.12'!C4","v":"SECTION 801 : CONCRETE RESERVOIRS  - SEALING"}]
[903,"TESTING","R"]
[1003,"ENERGISING,  PRE COMMISSIONING AND HAND-OVER","R"]
["SUBTOTAL A",null,"R"]
[null,"CONTRACT SKILLS DEVELOPMENT PROGRAMME (CSDP)"]
["                    CSDP Amount calculated at 0.25% of SUBTOTAL A",null,"R"]
[null,"SUBTOTAL B (SUBTOTAL A + CSDP Amount)","R"]
["Add  Estimated 5% CPA",null,"R"]
[null,"SUBTOTAL C (SUBTOTAL B + CPA)","R"]
["Add 10% for contingencies on Subtotal C"]
[null,"SUBTOTAL D (SUBTOTAL C + Contingencies)"]
[null,null,"R"]
[null,"Add 15% VAT on Subtotal D","R"]
[null,"CONTRACT PRICE CARRIED FORWARD TO FORM OF OFFER","R"]
[]
[]
["Signature of person authorised to sign the tender:",null,"Date:"]