{"text_format":"3","workbook":"xlsx","n_sheets":19,"sheets":["1200","1300","1400","1500","1700","2100","2200","2300","3300","3400","3500","4100","4200","5400","5700","5900","8100","SUMMARY OF SCHEDULES","Detailed Summary "],"not_rendered":{"defined_names":118},"read":"whole","date_system":"1900"}

{"sheet":"1200","index":0,"n_rows":80,"n_cols":7,"rows_kept":80}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[1200,"EXISTING SERVICES",null,0,null,null,{"$f":"E4*$D4","v":{"v":0,"d":"0.00"}}]
[]
["12.02","Reinstate existing services","Sum",1]
{"$rows_empty":73}
[1300,"\nTOTAL CARRIED TO SUMMARY\n",null,0,null,null,{"$f":"SUM(G3:G79)","v":{"v":0,"d":"0.00"}}]

{"sheet":"1300","index":1,"n_rows":72,"n_cols":7,"rows_kept":72}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS",null,0,null,null,{"$f":"E4*$D4","v":{"v":0,"d":"0.00"}}]
[]
["B13.01","Contractor's general obligations",null,0,null,null,{"$f":"E6*$D6","v":{"v":0,"d":"0.00"}}]
[]
[null,"(a) Fixed obligations","sum",1,{"v":360000,"d":"360,000.00"}]
[]
[null,"(c) Time-related obligations","Month",6,{"v":360000,"d":"360,000.00"}]
[]
[]
["B13.04","Supply, transport to site and erect contract signboards","No",1]
[]
["B13.05","(a) Fixed obligations for the preparation of risk assessments, safe work procedures, the project H & S file, the H & S plan and any other H & S matters that the contractor deems necessary.","Sum",1]
[]
[null,"(b) Fixed obligations for completing and checking the Project H & S file and handing over to the Client on completion of the works.","Sum",1]
[]
[null,"(c) Fixed obligation for supplying and installing signage, and equipment in line with the COVID-19 requirements.","Sum",1]
[]
[null,"(d) Time related obligations for updating and amending the risk assessments, safe work procedures, the project H & S file, the H & S plan and full compliance with all H & S matters during the construction of the works under the contract.","month",6]
[]
[null,"(e) Time related obligations for maintening all COVID equipment and apparatus on site.","month",6]
{"$rows_empty":48}
[1300,"\nTOTAL CARRIED TO SUMMARY\n",null,0,null,null,{"$f":"SUM(G8:G71)","v":{"v":0,"d":"0.00"}}]

{"sheet":"1400","index":2,"n_rows":78,"n_cols":7,"rows_kept":78}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[1400,"HOUSING, OFFICES AND LABORATORY FOR THE ENGINEER'S SITE PERSONNEL"]
[]
[14.03,"(b) Prime-cost items and items paid for in a lump sum:"]
[null," (i) Provision of telephone service, including the cost of calls in connection with contract administration and telephone rental","PC Sum",1]
[null," (ii) Handling costs and profit in respect of sub item 14.03(b)(i) above"," %",{"$f":"F7","v":{"v":0,"d":"0.00"}}]
[]
[]
[14.07,"Rental, hotel and other accommodation"]
[null,"(a) Provisional sum for providing rented housing, hotel or other accommodation as described in subsubclause 14.03(c)(ii)","Prov Sum",1]
[]
[null,"(b) Handling cost and profit in respect of sub item 14.07(a)","%",{"$f":"F12","v":{"v":0,"d":"0.00"}}]
[]
[14.08,"Services"]
[null,"The provision of water, electricity, sewerage ,sewage and rubbish removal, cleaning services, maintenance and repairs, all as specified in clause 1404, including the construction and maintenance of the access roads, footpaths, etc."]
[]
[null,"(a) Services at offices"]
[]
[null,"(i) Fixed Costs","Sum",1]
[]
[null,"(ii) Running Costs","month",6]
[]
[null,"(c) Services for rented houses","month",6]
{"$rows_empty":40}
[{"$nulls":6},{"$f":"IF(E66=\" \",\" \",D66*E66)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":11}
[1500,"\nTOTAL CARRIED TO SUMMARY\n",null,0,null,null,{"$f":"SUM(G5:G77)","v":{"v":0,"d":"0.00"}}]

{"sheet":"1500","index":3,"n_rows":84,"n_cols":7,"rows_kept":84}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[1500,"ACCOMMODATION OF TRAFFIC"]
[]
["B15.01","Accommodating traffic and maintaining temporary deviations ",{"$nulls":4},{"$f":"E6*D6","v":{"v":0,"d":"0.00"}}]
[]
[null,"(c) On the existing municipal roads","km",1.2,{"v":156250,"d":"156,250.00"}]
[]
["B15.16","Provision of traffic safety"]
[]
[null,"(a) Traffic safety officer","month",6,{"v":46625,"d":"46,625.00"}]
[]
[null,"(a) Traffic safety vehicle","month",6,{"v":30000,"d":"30,000.00"}]
{"$rows_empty":53}
[{"$nulls":6},{"$f":"IF(E68=\" \",\" \",D68*E68)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":15}
[1500,"\nTOTAL CARRIED TO SUMMARY\n",null,0,null,null,{"$f":"SUM(G5:G83)","v":{"v":0,"d":"0.00"}}]

{"sheet":"1700","index":4,"n_rows":85,"n_cols":7,"rows_kept":85}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[1700,"CLEARING AND GRUBBING",null,null,{"v":0,"d":"0.00"}]
[]
["17.01","Clearing and grubbing"," ha",0.7,{"v":7500,"d":"7,500.00"}]
[]
[{"$nulls":6},{"$f":"IF(E8=\" \",\" \",D8*E8)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[{"$nulls":6},{"$f":"IF(E12=\" \",\" \",D12*E12)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":6},{"$f":"IF(E14=\" \",\" \",D14*E14)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":70}
[1700,"\nTOTAL CARRIED TO SUMMARY\n",null,0,{"v":0,"d":"0.00"},null,{"$f":"SUM(G3:G84)","v":{"v":0,"d":"0.00"}}]

{"sheet":"2100","index":5,"n_rows":81,"n_cols":7,"rows_kept":81}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[2100,"DRAINS",null,0,{"v":0,"d":"0.00"}]
[]
[21.01,"Excavation for Open Drains",{"$nulls":4},{"$f":"IF(E6=\" \",\" \",D6*E6)","v":{"v":0,"d":"0.00"}}]
[]
[null,"(a) Excavating soft material situated within the following depth ranges below the surface level:"]
[]
[null,"(i) 0m up to 1,5m"," m³",980,{"v":65,"d":"65.00"}]
[]
["21.03","Excavation for subsoil drainage systems"]
[]
[null,"(a) Excavating soft material situated within the following depth ranges below the surface level:"]
[]
[null,"(i) 0m up to 1,5m"," m³",980,{"v":960,"d":"960.00"}]
[]
["B21.06","Natural permeable material in subsoil drainage systems (washed crushed stone)"]
[]
[null,"(b) Crushed stone obtained from commercial sources"]
[]
[null,"(i) 13,2mm nominal size aggregate"," m³",950,{"v":441,"d":"441.00"}]
[]
["21.08","Pipes in subsoil drainage systems:"]
[]
[null,"(a) Unplasticized PVC pipes and fittings complete with couplings:"]
[]
[null,"(i) 110 mm internal dia, perforated","m",650,{"v":48,"d":"48.00"}]
[]
["21.10","Synthetic fibre filter fabric:"]
[]
[null,"(a) Non woven needle punched grade 2"," m²",{"v":2000,"d":"2,000"},{"v":14,"d":"14.00"}]
[]
["B21.12  ","Concrete outlet structures, manhole boxes, junction boxes and cleaning eyes for subsoil drainage systems:"]
[]
[null,"(a) Outlet Structures ( Headwalls)","No",2,{"v":2500,"d":"2,500.00"}]
[null,"(b) Grid Inlets","No",2,{"v":5000,"d":"5,000.00"}]
[]
[]
["21.17","Test flushing of pipes in subsoil drainage systems","No",3,{"v":795,"d":"795.00"}]
{"$rows_empty":40}
[2100,"\nTOTAL CARRIED TO SUMMARY\n",null,0,{"v":0,"d":"0.00"}]

{"sheet":"2200","index":6,"n_rows":78,"n_cols":7,"rows_kept":78}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[2200,"PREFABRICATED CULVERTS"]
[]
["B22.01","Excavation:"]
[]
[null,"(a) Excavating soft material situated within the following depth ranges below the surface level:",null,null,{"v":0,"d":"0.00"}]
[]
[null,"(i) 0m up to 1.5m"," m³",30,456.25]
[]
[null,"(b) Extra over subitem 22.01(a) for excavation in hard material, irrespective of depth","m³",30,{"v":100,"d":"100.00"}]
[]
[null,"(c) Extra over subitem 22.01(a) for excavation by hand","m³",30,{"v":100,"d":"100.00"}]
[]
["22.02","Backfilling:"]
[]
[null,"(a) Using the excavated material","m³",30,{"v":90,"d":"90.00"}]
[]
[null,"(b) Using imported selected material","m³",20]
[]
[null,"(c) Extra over subitems 22.02(a) and (b) for soil cement backfilling (5% cement)","m³",10,{"v":250,"d":"250.00"}]
[]
["22.03","Concrete pipe culverts:"]
[]
[null,"(b) On Class B bedding:"]
[]
[null,"(i) 600mm dia Class 50D with \"ogee\" joints","m",30,{"v":1781.25,"d":"1,781.25"}]
[]
["22.07","Cast in situ concrete and formwork:"]
[]
[null,"(c) In inlet and outlet structures, skewed ends, catchpits, manholes, thrust and anchor blocks, excluding formwork but including class U2 surface finish (Class 30/19):"]
[]
[null,"(d) Formwork of concrete under subitem 22.07(c) above:"]
[]
[null,"(i) To walls (Class F1 surface finish)","m²",10,331.25]
[]
["PSS01","Service duct"]
[]
[null,"(a) Excavation, backfilling , compacting, and disposing of surplus material."]
[]
[null,"(i) Intermediate excavation ","m³",198]
[]
[null,"(b) Excavate unsuitable material from trench bottom and dispose of it (provisional) ","m³",40]
[]
[null,"(c) Supply, lay, bed, and prove duct ","m",880]
[]
[null,"(d) Draw pits/manholes ","no",18]
[]
[null,"(e) Cable markers"]
[]
[null,"(i) Cable warning tape","m",880]
[]
[null,"(ii) Cable warning tile ","m",880]
{"$rows_empty":22}
[{"$nulls":4},{"v":0,"d":"0.00"}]
[2200,"\nTOTAL CARRIED TO SUMMARY\n",null,0,{"v":0,"d":"0.00"}]

{"sheet":"2300","index":7,"n_rows":81,"n_cols":7,"rows_kept":81}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[2300,"CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES AND CONCRETE LININGS FOR OPEN DRAINS"]
[]
[23.02,"Concrete kerbing-channelling combination (Class of Concrete indicated for cast in situ concrete)"]
[]
[null,"(a) Straight precast figure 6 barrier kerb & fillet/channel:","m",300,{"v":265,"d":"265.00"}]
[null,"(i) 300mm channel / fillet"]
[]
[null,"(b) Curved precast figure 6 barrier kerb & fillet/channel:","m",60,{"v":665,"d":"665.00"}]
[null,"(i) 300mm channel / fillet"]
[]
[]
[23.07,"Trimming of excavations for concrete-lined open drains:"]
[null,"(a) In soft material","m²",{"v":1200,"d":"1,200"},{"v":10,"d":"10.00"}]
[null,"(b) In hard material","m²",400,{"v":400,"d":"400.00"}]
[]
[23.08,"Concrete lining for open drains:"]
[null,"(a) Cast-In-situ Concrete Lining to Open Drains (Class 20/19 for vee drains )","m³",170,{"v":1000,"d":"1,000.00"}]
[]
[23.09,"Formwork to cast in situ concrete limimgs for open drains"]
[null,"a) To sides with formwork on the internal face only ","m²",10,{"v":650,"d":"650.00"}]
[null,"b) To sides with formwork on both internal and external faces ","m²",10]
[null,"c) To ends of slabs","m²",10]
[]
[{"v":23.1,"d":"23.10"},"Sealed Joints in Concrete Lining of Open Drains ","m",15,{"v":25,"d":"25.00"}]
[]
[23.13,"Polyethylene Sheeting (0.15mm thick) for Concrete-Lined Open","m²",{"v":1600,"d":"1,600"},{"v":20,"d":"20.00"}]
{"$rows_empty":51}
[3300,"\nTOTAL CARRIED TO SUMMARY\n",null,null,{"v":0,"d":"0.00"},null,{"$f":"SUM(G3:G80)","v":{"v":0,"d":"0.00"}}]

{"sheet":"3300","index":8,"n_rows":84,"n_cols":7,"rows_kept":84}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[3300,"MASS EARTHWORKS"]
[]
["B33.01","Cut and borrow to fill, including free-haul up to 1,0 km"]
[]
[null,"(e) Pioneer layer","m3",560]
[]
["B33.04","Cut to spoil, including free-haul up to 1,0 km. Material obtained from:"]
[]
[null,"(a) Soft excavation","m³",{"v":1520,"d":"1,520"},{"v":116,"d":"116.00"}]
[]
["B33.07","Removal of unsuitable material (including free haul up to 1,0km)"]
[]
[null,"(a) In layer thicknesses of 200mm and less:"]
[]
[null,"(ii) Unstable material","m³",120,{"v":120,"d":"120.00"}]
[]
[{"v":33.1,"d":"33.10"},"Roadbed preparation and compaction of material:"]
[]
[null,"(b) Compaction of 93% of modified AASHTO density","m³",610,{"v":150,"d":"150.00"}]
[]
["33/B16.02","Overhaul on material hauled in excess of 1,0 km (ordinary overhaul)","m³km",{"v":9000,"d":"9,000"},{"v":14.5,"d":"14.50"}]
{"$rows_empty":59}
[3300,"\nTOTAL CARRIED TO SUMMARY\n",null,null,{"v":0,"d":"0.00"},null,{"$f":"SUM(G3:G83)","v":{"v":0,"d":"0.00"}}]

{"sheet":"3400","index":9,"n_rows":79,"n_cols":7,"rows_kept":79}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[3400,"PAVEMENT LAYERS OF GRAVEL MATERIAL"]
[]
["B34.01","Pavement layers constructed from gravel taken from commercial sources."]
[]
[null,"(a) Gravel selected layers compacted to:"]
[]
[null,"(i) 93% of modified AASHTO density"]
[]
[null,"(1) G7 material 150mm thick ","m3",670,{"v":300,"d":"300.00"}]
[]
[null,"(ii) 95% of modified AASHTO density"]
[]
[null,"(1) G9 material 150mm thick ","m3",730,{"v":260,"d":"260.00"}]
[]
[null,"(d) Gravel subbase (chemically stabilized material) compacted to: "]
[]
[null,"(ii) 96%of modified AASHTO density (300mm thick)","m3",{"v":1320,"d":"1,320"},{"v":450,"d":"450.00"}]
[]
["B34.04","Insitu reconstruction of existing pavement layers as:"]
[]
[null,"(e)  Gravel subbase (chemically stabilized material) compacted to 95% of modified AASHTO density using:"]
[]
[null,"(iii) Mixture of insitu asphalt, existing gravel pavement material(both cemented and non cemented) and imported G5 gravel material to 300mm total layer thickness to produce C3 quality material compacted to 97% Maximum Dry Density.","m3",{"v":1920,"d":"1,920"},{"v":450,"d":"450.00"}]
[]
["B34.06","Extra over item 34.04 for adding extra material as specified in subsubclause 3207(b)(iii):"]
[]
[null,"(b) Gravel subbase","m3",960,{"v":450,"d":"450.00"}]
[]
["B34.14","Removal of excess material from pavement layers in reconstructed areas","m3",1500,{"v":25,"d":"25.00"}]
{"$rows_empty":46}
[3400,"\nTOTAL CARRIED TO SUMMARY\n",null,null,{"v":0,"d":"0.00"}]

{"sheet":"3500","index":10,"n_rows":86,"n_cols":7,"rows_kept":86}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[3500,"STABILIZATION"]
[]
["35.01","Chemical stabilization extra over unstabilized compacted layers :"]
[]
[null,"(a) Subbase:"]
[]
[null,"(ii) to roadway for insitu stabilisation"," m³",{"v":3600,"d":"3,600"},{"v":10,"d":"10.00"}]
[]
["B35.02","Chemical stabilizing agent:"]
[]
[null,"(a) Cement CEM II A-V 32.5 (3%)","t",60,{"v":1650,"d":"1,650.00"}]
[]
["35.13","Extra over items 35.01 and 35.07 for trial sections"," m³",20,{"v":35,"d":"35.00"}]
{"$rows_empty":69}
[3500,"\nTOTAL CARRIED TO SUMMARY\n"]

{"sheet":"4100","index":11,"n_rows":85,"n_cols":7,"rows_kept":85}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[4100,"PRIME COAT",null,0,{"v":0,"d":"0.00"}]
[]
[41.01,"Prime coat:"]
[]
[null,"(c) MC-30 Cut-back bitumen or bitumen emulsion MSP1 type ( 0.7 l/m²)","litre",{"v":6600,"d":"6,600"},{"v":20,"d":"20.00"}]
{"$rows_empty":76}
[4100,"\nTOTAL CARRIED TO SUMMARY\n",null,0,{"v":0,"d":"0.00"},null,{"$f":"SUM(G3:G84)","v":{"v":0,"d":"0.00"}}]

{"sheet":"4200","index":12,"n_rows":80,"n_cols":7,"rows_kept":80}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[4200,"ASPHALT BASE AND SURFACING"]
[]
["42.01","Asphalt base using AP1 or AE2 Modified Binder (80mm thick, maximum aggregate size 26mm)"]
[]
[null,"(a) Continuously graded","m2",{"v":9300,"d":"9,300.00"},{"v":280,"d":"280.00"}]
[]
["42.02","Asphalt surfacing "]
[]
[null,"(a) Continuously graded "]
[]
[null,"(1) Using AP1 or AE2 Modified Binder (40mm thick, medium grade)","m2",{"v":9300,"d":"9,300.00"},{"v":155,"d":"155.00"}]
[]
[null,"(2) Using 50/70 pen bitumen (20mm thick, medium grade) to temporary widenings/bypasses","m2",{"v":9300,"d":"9,300.00"},{"v":100,"d":"100.00"}]
[]
["42.04","Tack coat of 30% stable-grade emulsion ( 0.5 l/m²)","l",{"v":4700,"d":"4,700.00"},{"v":10,"d":"10.00"}]
[]
["42.05","Binder variations using an:"]
[]
[null,"(a) 30/50 pen bitumen binder","t","rate only"]
[]
["42.06","Variation in active filler "]
[]
[null,"(b) Lime","t","rate only"]
[]
["B42.08","Cores in asphalt paving                         "]
[]
[null,"(a) 100 mm dia                                  ","No",{"v":3,"d":"3.00"},{"v":215,"d":"215.00"}]
[]
[null,"(b) 150 mm dia                                  ","No",{"v":2,"d":"2.00"},{"v":285,"d":"285.00"}]
[]
["B42.21","Aggregate variations","t","rate only"]
{"$rows_empty":45}
[4200,"\nTOTAL CARRIED TO SUMMARY\n"]

{"sheet":"5400","index":13,"n_rows":84,"n_cols":7,"rows_kept":84}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[5400,"GUARDRAILS"]
[]
["54.01","Guardrails on timber posts:"]
[]
[null,"(a) Galvanised","m",580]
[]
[54.02,"Guardrails on steel posts:"]
[]
[null,"(a) Galvanised","m",580]
[]
["54.04","End treatments:"]
[]
[null,"(a) End wings","No",2]
[]
[54.05,"Additional guardrail posts:"]
[]
[null,"(a) Timber","No",58]
[]
["B54.14","Nailing of gang nail plates on top of timber guardrail posts","No",58]
{"$rows_empty":61}
[5400,"\nTOTAL CARRIED TO SUMMARY\n",null,0]

{"sheet":"5700","index":14,"n_rows":81,"n_cols":7,"rows_kept":81}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[5700,"ROAD MARKINGS",null,0]
[]
["57.02","Retro-reflective road marking paint : (water based paint)",null,0,null,null,{"$f":"$D6*E6","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"$D7*E7","v":{"v":0,"d":"0.00"}}]
[null,"(a) White lines (broken or unbroken):",{"$nulls":4},{"$f":"$D8*E8","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"$D9*E9","v":{"v":0,"d":"0.00"}}]
[null,"(i) 100 mm wide"," km",1.4,{"v":3000,"d":"3,000.00"}]
[]
[null,"(ii) 200 mm wide"," km",0.5,{"v":5000,"d":"5,000.00"}]
[]
[null,"(b) Yellow lines (broken or unbroken):"]
[]
[null,"(ii) 150 mm wide"," km",2.2,{"v":4500,"d":"4,500.00"}]
[]
[null,"(f) Transverse lines, painted island and arrestor bed markings","m²",50,{"v":65,"d":"65.00"}]
[]
["57.04","Variations in rate of application:",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"(a) White paint"," l","rate only"]
[]
[null,"(b) Yellow paint"," l","rate only"]
[]
[null,"(d) Retro-reflective beads"," kg",175]
[]
[57.05,"Roadstuds "]
[]
[null,"(a) Bi-directional, galvanised steel /aluminum with fitted shank and 43/43 element reflectors (tenderer to specify..............................)","No",123,{"v":115,"d":"115.00"}]
[]
[57.06,"Setting out and premarking the lines (excluding traffic-island markings, lettering and symbols)"," km",2.2,{"v":612,"d":"612.00"}]
[]
["57.07","Re-establishing the painting unit at the end of the maintenance period","L/sum",1,{"v":10000,"d":"10,000.00"}]
[]
["57.08","Removal of existing, temporary or permanent road markings by:"]
[]
[null,"(a) Sand-blasting","m²",50,{"v":100,"d":"100.00"}]
[]
[null,"(b) Overpainting as temporary measure","m²",50,{"v":70,"d":"70.00"}]
[]
["57.09","Removal of existing roadstuds","No",10,{"v":8,"d":"8.00"}]
{"$rows_empty":38}
[5700,"\nTOTAL CARRIED TO SUMMARY\n",null,0,{"v":0,"d":"0.00"}]

{"sheet":"5900","index":15,"n_rows":87,"n_cols":7,"rows_kept":87}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[5900,"FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS",null,0]
[]
[59.01,"Finishing road and road reserve:",null,0]
[]
[null,"(b) Single carriageway road"]
[]
[null,"(i) Ramps","km",1.2,{"v":30000,"d":"30,000.00"}]
[]
[59.02,"Treatment of old roads and temporary deviations","km",0.5,{"v":14000,"d":"14,000.00"}]
{"$rows_empty":74}
[5800,"\nTOTAL CARRIED TO SUMMARY\n",null,0,null,null,{"$f":"SUM(G11:G86)","v":{"v":0,"d":"0.00"}}]

{"sheet":"8100","index":16,"n_rows":86,"n_cols":7,"rows_kept":86}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","RATE","AMOUNT"]
["NO"]
[]
[8100,"TESTING MATERIALS AND WORKMANSHIP"]
[]
["81.02","Other special tests requested by the engineer","Prov Sum",1,{"v":100000,"d":"100,000.00"}]
{"$rows_empty":79}
[8100,"\nTOTAL CARRIED TO SUMMARY\n",{"$nulls":4},{"$f":"SUM(G3:G85)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SUMMARY OF SCHEDULES","index":17,"n_rows":48,"n_cols":3,"rows_kept":48,"merged":[[47,0,47,1]]}
["SUMMARY OF SCHEDULE OF QUANTITIES"]
["SECTION","DESCRIPTION","AMOUNT "]
["SCHEDULE A ","ROADWORKS"]
[1200,"EXISTING SERVICES",{"$f":"'1200'!G80","v":0}]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS",{"$f":"'1300'!G72","v":0}]
[1400,"HOUSING, OFFICES AND LABORATORY FOR THE ENGINEER'S SITE PERSONNEL",{"$f":"'1400'!G78","v":0}]
[1500,"ACCOMMODATION OF TRAFFIC",{"$f":"'1500'!G84","v":0}]
[1700,"CLEARING AND GRUBBING",{"$f":"'1700'!G85","v":0}]
[2100,"DRAINS",{"$f":"'2100'!G81","v":0}]
[2200,"PREFABRICATED CULVERTS",{"$f":"'2200'!G78","v":0}]
[2300,"CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES AND CONCRETE LININGS FOR OPEN DRAINS",{"$f":"'2300'!G81","v":0}]
[3300,"MASS EARTHWORKS",{"$f":"'3300'!G84","v":0}]
[3400,"PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$f":"'3400'!G79","v":0}]
[3500," STABILIZATION",{"$f":"'3500'!G86","v":0}]
[4100,"PRIME COAT",{"$f":"'4100'!G85","v":0}]
[4200,"ASPHALT AND SURFACING",{"$f":"'4200'!G80","v":0}]
[5400,"GUARDRAILS",{"$f":"'5400'!G84","v":0}]
[5700,"ROAD MARKINGS",{"$f":"'5700'!G81","v":0}]
[5900,"FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS",{"$f":"'5900'!G87","v":0}]
[8100,"TESTING MATERIALS AND WORKMANSHIP",{"$f":"'8100'!G86","v":0}]
{"$rows_empty":27}
["TOTAL SCHEDULE A ROADWORKS",null,{"$f":"SUM(C4:C20)","v":0}]

{"sheet":"Detailed Summary ","index":18,"n_rows":25,"n_cols":3,"rows_kept":25,"merged":[[21,0,21,1],[23,0,23,1]]}
["SUMMARY OF SCHEDULE OF QUANTITIES"]
["SECTION","DESCRIPTION","AMOUNT "]
["SCHEDULE A ","ROADWORKS"]
[1200,"EXISTING SERVICES",{"$f":"'1200'!G80","v":0}]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS",{"$f":"'1300'!G72","v":0}]
[1400,"HOUSING, OFFICES AND LABORATORY FOR THE ENGINEER'S SITE PERSONNEL",{"$f":"'1400'!G78","v":0}]
[1500,"ACCOMMODATION OF TRAFFIC",{"$f":"'1500'!G84","v":0}]
[1700,"CLEARING AND GRUBBING",{"$f":"'1700'!G85","v":0}]
[2100,"DRAINS",{"$f":"'2100'!G81","v":0}]
[2200,"PREFABRICATED CULVERTS",{"$f":"'2200'!G78","v":0}]
[2300,"CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES AND CONCRETE LININGS FOR OPEN DRAINS",{"$f":"'2300'!G81","v":0}]
[3300,"MASS EARTHWORKS",{"$f":"'3300'!G84","v":0}]
[3400,"PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$f":"'3400'!G79","v":0}]
[3500," STABILIZATION",{"$f":"'3500'!G86","v":0}]
[4100,"PRIME COAT",{"$f":"'4100'!G85","v":0}]
[4200,"ASPHALT AND SURFACING",{"$f":"'4200'!G80","v":0}]
[5400,"GUARDRAILS",{"$f":"'5400'!G84","v":0}]
[5700,"ROAD MARKINGS",{"$f":"'5700'!G81","v":0}]
[5900,"FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS",{"$f":"'5900'!G87","v":0}]
[8100,"TESTING MATERIALS AND WORKMANSHIP",{"$f":"'8100'!G86","v":0}]
[]
["TOTAL SCHEDULE A: ROADWORKS",null,{"$f":"SUM(C4:C20)","v":0}]
["CONTINGENCIES: 10% of Subtotal A",null,{"$f":"C22*0.1","v":0}]
["SUB TOTAL B",null,{"$f":"C22+C23","v":0}]
["TOTAL CARRIED TO C.1.1.1 : FORM OF OFFER \n",null,{"$f":"SUM(C24:C24)","v":0}]