{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Sch 1 P & G's","Sch 2 Day Works","Sch 3 Earthworks","Sch 4 Subbase","Sch 5 Base","Sch 6 Paving","Sch 7 Concrete Works","Sch 8 Kerbing & Channelling","Sch 9 Ancillary Road Work","Summary"],"not_rendered":{"images":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Sch 1 P & G's","index":0,"n_rows":98,"n_cols":10,"rows_kept":98,"merged":[[0,0,0,7],[1,0,1,7],[37,2,37,4],[38,2,38,4],[39,2,39,4],[55,0,55,8],[61,0,61,8],[81,2,81,4],[83,2,83,4],[85,2,85,4],[87,2,87,4],[97,0,97,8]]}
[{"$nulls":9},"Schedule 1"]
["SCHEDULE 1 : PRELIMINARY & GENERAL",{"$nulls":8},"Preliminary & General"]
["Item","Payment",null,null,"Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Ref.",{"$nulls":6},"( R )","( R )"]
[1,"SANS"]
[null,"1200A","PRELIMINARY & GENERAL"]
[]
["A1.1","8.3","FIXED-CHARGE ITEMS"]
[]
["A1.1.1","8.3.1","Contractual Requirements",null,null,"Sum",null,1,null,{"$f":"IF(I10=\"\",\"\",ROUND(I10*H10,2))","v":""}]
[]
["A1.1.2","8.3.2","Establish Facilities on Site"]
[]
[null,"8.3.2.1","i)","Facilities for Engineer"]
[]
[null,"PS7.2",null,"a)","Office Equipment for Engineer as and when required","Prov Sum",null,1,{"v":50000,"d":"50,000.00"},{"$f":"IF(I16=\"\",\"\",ROUND(I16*H16,2))","v":{"v":50000,"d":"50,000.00"}}]
[]
[null,"PSAB1",null,"b)","Nameboards ","no.",null,2,null,{"$f":"IF(I18=\"\",\"\",ROUND(I18*H18,2))","v":""}]
[]
["A1.3","8.3.2.3","ii)","Facilities for Contractor"]
[null,"PS6"]
["A1.3.1",null,null,"a)","Offices and storage sheds ","Sum",null,1,null,{"$f":"IF(I22=\"\",\"\",ROUND(I22*H22,2))","v":""}]
["A1.3.2",null,null,"b)","Workshops","Sum",null,1,null,""]
["A1.3.3",null,null,"c)","Laboratories","Sum",null,1,null,""]
["A1.3.4",null,null,"d)","Living accommodation","Sum",null,1,null,""]
["A1.3.5",null,null,"e)","Ablution and latrine facilities ","Sum",null,1,null,""]
["A1.3.6",null,null,"f)","Tools and equipment","Sum",null,1,null,""]
["A1.3.7",null,null,"g)","Water supplies, electric power and communications","Sum",null,1,null,""]
["A1.3.8",null,null,"h)","Dealing with water (Subclause 5.5)","Sum",null,1,null,""]
["A1.3.9",null,null,"i)","Access (Subclause 5.8)","Sum",null,1,null,""]
["A1.3.10",null,null,"j)","Plant","Sum",null,1,null,""]
["A1.4","8.3.3","Other fixed-charge obligations",null,null,"Sum",null,1,null,{"$f":"IF(I32=\"\",\"\",ROUND(I32*H32,2))","v":""}]
[]
["A1.5","8.3.4","Removeof site establishment on completion",null,null,"Sum",null,1,null,{"$f":"IF(I34=\"\",\"\",ROUND(I34*H34,2))","v":""}]
[]
["A1.6","SPEC AO","Health and safety"]
[]
["A1.6.1","8.2.1","General safety obligations",null,null,"Sum",null,1,null,{"$f":"H38*I38","v":0}]
["A1.6.2","8.2.2","Risk assessment",null,null,"Sum",null,1,null,{"$f":"H39*I39","v":0}]
["A1.6.3","8.2.3","Health and safety plan",null,null,"Sum",null,1,null,0]
["A1.6.4","8.2.5","Training",null,null,"Sum",null,1,null,0]
["A1.6.5","8.2.6","Medical assessment of employees",null,null,"Prov Sum",null,1,{"$f":"500*45","v":{"v":22500,"d":"22,500.00"}},{"v":22500,"d":"22,500.00"}]
[]
["A2","8.4","TIME-RELATED ITEMS"]
[]
["A2.1","8.4.1","Contractual requirements",null,null,"Sum",null,1,null,{"$f":"IF(I46=\"\",\"\",ROUND(I46*H46,2))","v":""}]
[]
[null,null,"Operate and maintain facilities on the site:"]
[]
["A1.2","8.3.2.3","i)","Facilities for Engineer"]
[]
[{"$nulls":9},{"$f":"IF(I52=\"\",\"\",ROUND(I52*H52,2))","v":""}]
[{"$nulls":3},"a)","Operate and maintain facilities on site for the Engineer ","Prov Sum",null,1,{"v":25000,"d":"25,000.00"},{"v":25000,"d":"25,000.00"}]
[{"$nulls":4},"and the Contractor"]
[null,"PSA8.2","Testing Layerworks, bedding, blanket and backfilling",null,null,"Prov Sum",null,1,{"v":180000,"d":"180,000.00"},{"$f":"IF(I55=\"\",\"\",ROUND(I55*H55,2))","v":{"v":180000,"d":"180,000.00"}}]
["Carried Forward"]
[]
[]
[]
[]
[]
["Brought Forward",{"$nulls":8},{"$f":"J56","v":0}]
["A1.3","8.3.2.3","Facilities for Contractor"]
[]
["A1.3.1",null,"a)","Offices and storage sheds ",null,"Sum",null,1,null,{"$f":"IF(I65=\"\",\"\",ROUND(I65*H65,2))","v":""}]
["A1.3.2",null,"b)","Workshops",null,"Sum",null,1,null,""]
["A1.3.3",null,"c)","Laboratories",null,"Sum",null,1,null,""]
["A1.3.4",null,"d)","Living accommodation",null,"Sum",null,1,null,""]
["A1.3.5",null,"e)","Ablution and latrine facilities ",null,"Sum",null,1,null,""]
["A1.3.6",null,"f)","Tools and equipment",null,"Sum",null,1,null,""]
["A1.3.7",null,"g)","Water supplies, electric power and communications",null,"Sum",null,1,null,""]
["A1.3.8",null,"h)","Dealing with water (Subclause 5.5)",null,"Sum",null,1,null,""]
["A1.3.9",null,"i)","Access (Subclause 5.8)",null,"Sum",null,1,null,""]
["A1.3.10",null,"j)","Plant",null,"Sum",null,1,null,""]
[]
["A2.4","8.4.3","Supervision for duration of the construction",null,null,"Sum",null,1,null,{"$f":"IF(I76=\"\",\"\",ROUND(I76*H76,2))","v":""}]
[]
["A2.5","8.4.4","Company and head office overhead costs",null,null,"Sum",null,1,null,{"$f":"IF(I78=\"\",\"\",ROUND(I78*H78,2))","v":""}]
[]
["A2.6","8.4.5","Other time related obligations",null,null,"Sum",null,1,null,{"$f":"IF(I80=\"\",\"\",ROUND(I80*H80,2))","v":""}]
[]
["A2.7","SPEC AO","Health and safety:"]
[]
["A2.7.1","8.2.1","General safety obligations",null,null,"Sum",null,1,null,{"$f":"I84*H84","v":0}]
[]
["A2.7.2","8.2.3","Health and safety plan",null,null,"Sum",null,1,null,{"$f":"I86*H86","v":0}]
[]
["A2.7.3","8.2.4","Construction Safety Officer and other appointments"]
[null,null,"a)","Community Laison Officer (CLO) Salary",null,"Prov ",null,1,{"$f":"5500*6","v":{"v":33000,"d":"33,000.00"}},{"$f":"H89*I89","v":{"v":33000,"d":"33,000.00"}}]
[]
[null,null,"b)","Community involvement, PSC payment",null,"Prov Sum",null,1,{"$f":"1000*4*6","v":{"v":24000,"d":"24,000.00"}},{"$f":"I91","v":{"v":24000,"d":"24,000.00"}}]
[]
[null,null,"c)","Charges and profit on item 1.3.7 (a) and (b)",null,"%",null,null,{"$f":"J89+J91","v":{"v":57000,"d":"57,000.00"}}]
[]
[]
[]
[]
["Carried Forward to Summary"]

{"sheet":"Sch 2 Day Works","index":1,"n_rows":149,"n_cols":10,"rows_kept":149,"merged":[[0,0,0,7],[2,0,2,9],[5,0,6,0],[32,2,32,4],[48,0,48,8],[54,0,54,8],[97,0,97,8],[103,0,103,8],[148,0,148,8]]}
[{"$nulls":9},"Schedule 2"]
["SCHEDULE 2 : DAY WORKS"]
[]
["Item","Payment",null,null,"Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Ref.",{"$nulls":6},"( R )","( R )"]
[2,"SANS"]
[null,"1200A","DAY WORKS"]
[]
[2.1,8.7,"LABOUR"]
[]
["2.1.1",null,"a)  Unskilled Labourers",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.2",null,"b)  Semi Skilled Labourers",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.3",null,"c)   Skilled Labourers",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.4",null,"d)  Carpenter",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.5",null,"e)  Clerk",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.6",null,"f)  Artisans",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.7",null,"g)  Foreman",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.8",null,"h)  Steel fixer",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.9",null,"i)  Bricklayer or Plasterer",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.1.10",null,"j)  Welder",null,null,"hrs",null,1,null,"Rate Only"]
[]
[2.2,null,"PLANT"]
[]
[null,null,"Tenderers to insert the hire rate at which each item will be charged, which is to cover all relevant costs of plant hire, including operating crew, bringing to site and removal"]
[]
["2.2.1",null,"Bulldozer (D6 or similar equivalent):"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.2.2",null,"Grader (120G or similar equivalent)"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
[]
[]
["Carried Forward"]
[]
[]
[]
[]
[{"$nulls":9},"C2.2.4"]
["Brought Forward",{"$nulls":8},{"$f":"J49","v":{"v":0,"d":"0.00"}}]
[]
["2.2.3",null,"TLB"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.2.4",null,"Trucks (6m³ tipper)"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.2.5",null,"Soil compactors (D72Y or similar equivalent)"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.2.6",null,"Concrete mixer (250 litre)"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.2.7",null,"Concrete vibrators (Drive unit plus accessories)"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
[]
["2.2.8",null,"Excavators "]
[{"$nulls":5},"hrs",null,1,null,"Rate Only"]
[null,null,"a)  Working"]
[{"$nulls":5},"hrs",null,1,null,"Rate Only"]
[null,null,"b)  Standing"]
[]
[]
[]
[]
[]
["Carried Forward"]
[]
[]
[]
[]
[{"$nulls":9},"C2.2.5"]
["Brought Forward",{"$nulls":8},{"$f":"J98","v":{"v":0,"d":"0.00"}}]
[]
["2.2.9",null,"Water tanker (10 000 l)"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.2.10",null,"LDV"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
[]
["2.2.11",null,"Dumper (1.4m³)"]
[]
[null,null,"a)  Working",null,null,"hrs",null,1,null,"Rate Only"]
[]
[null,null,"b)  Standing",null,null,"hrs",null,1,null,"Rate Only"]
{"$rows_empty":26}
["TOTAL SCHEDULE 2 CARRIED FORWARD TO SUMMARY"]

{"sheet":"Sch 3 Earthworks","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"merged":[[0,3,0,7],[1,0,1,2],[1,3,1,7],[57,0,57,6]]}
[{"$nulls":3},"Schedule 3"]
["SCHEDULE 3 :  EARTHWORKS (ROADS, SUBGRADE)"]
[]
["Item","Payment","Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Reference",{"$nulls":5},"(R)"]
[]
[null,"SANS","SECTION DM: EARTHWORKS (ROADS, SUBGRADE)"]
[null,"1200DM"]
[null,"8.3.1","SITE CLEARANCE"]
[]
["DM1",null,"Clear vegetation, rubble and trees up to 1 m of girth and other obstructions pointed ","m2",null,{"$f":"1600*5","v":8000},null,{"$f":"IF(G11=\"\",\"\",ROUND(G11*F11,2))","v":""}]
[null,null,"out by the Engineer's representative in the site book to a width of 5 m on either"]
[]
[null,null,"Treatment of road-bed"]
[]
["DM2","8.3.3","Road-bed preparation and compaction of material"]
[]
["DM2.2",null,"Compact to 93 % of Mod. AASHTO max. density","m3",null,{"$f":"1500*7*0.15*1.65","v":2598.75}]
[]
["DM4.2",null,"Rockfill, process and compact","m3",null,{"$f":"300*0.15*7*0.5","v":157.5}]
[]
["DM5","8.3.4","Borrow to fill"]
[]
["DM5.1",null,"Compact to 93% of Mod. AASHTO max. density","m3",null,{"$f":"300*0.2*0.7*1.5","v":63}]
[]
["DM8","8.3.7","Cut to spoil or stockpile from"]
[]
["DM8.1",null,"Soft excavation","m3",null,{"$f":"1200*7*0.5","v":4200}]
[]
["DM8.2",null,"Intermediate excavation (Milling to stockpile)","m3",null,{"$f":"1200*7*0.15*0.5","v":630}]
[]
["DM9","8.3.8","Removal of oversize material","m3",null,1,null,"Rate Only"]
[]
["DM11","SDDM...","Variations in compactive effort:"]
[]
["DM11.1",null,"Vibratory roller","m2/ pass",null,{"$f":"1600*7","v":11200}]
[]
["DM11.2",null,"Impact roller","m2/ pass",null,1,null,"Rate Only"]
[null,null,"Sundries"]
[]
["DM12","8.3.10","Materials bladed to windrow","m3"]
[]
["DM13","8.3.11","Extra-over Items DM1.2, DM4, DM5 or DM6 for temporary stockpiling of material","m3",null,{"$f":"F30+F28","v":4830}]
[]
["DM14","8.3.12","Overhaul:"]
[]
["DM14.1",null,"Extra-over Items DM 5.1. for hauling material: "]
[]
["DM14.1.1",null,"in excess of the freehaul of 0,5 km but not more than 1,0 km","m3",null,{"$f":"F24","v":63}]
[]
["DM14.1.2",null,"in excess of the haul of 1,0 km","m3.km",null,{"$f":"F49*10","v":630}]
[]
[null,"8.3.13","Surface finishes"]
[]
["DM15",null,"Topsoiling","m2",null,{"$f":"1600*5","v":8000},null,"Rate Only"]
[]
["DM19","8.3.15","Mitre banks and channels","m3",null,{"$f":"(300/50+6+1200/50)*0.5*0.5","v":9},null,"Rate Only"]
["Carried to Summary"]

{"sheet":"Sch 4 Subbase","index":3,"n_rows":55,"n_cols":8,"rows_kept":55,"merged":[[0,3,0,7],[1,0,1,2],[1,3,1,7],[54,0,54,6]]}
[{"$nulls":3},"Schedule 4"]
["SCHEDULE 4 :  SUBBASE"]
[]
["Item","Payment","Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Reference",{"$nulls":5},"(R)"]
[]
[null,"SANS"]
[null,"1200ME","SUBBASE"]
[]
["ME","8.3.1","Construct the subbase course/shoulders/gravel wearing course with material","m3",null,1,null,"Rate Only"]
[null,null," excavated  in materials from borrow pit (95% Mod AASHTO , 150mm Thickness)"]
[]
["ME","8.3.2","Construct the subbase course/shoulders/gravel wearing course with material","m3",null,1,null,"Rate Only"]
[null,null," excavated  in materials from desiginated excavations (95% Mod AASHTO,"]
[null,null," 150mm Thickness)"]
["ME","8.3.3","Construct the subbase course/shoulders/gravel wearing course with material ","m3",null,{"$f":"1500*7.6*0.15*1.5","v":2565},null,{"$f":"F16*G16","v":0}]
[null,null,"excavated in materials from Commercial Sources ( 95% Mod AASHTO, "]
[null,null,"150mm Thickness)"]
[]
[null,"8.3.4","Extra over for Item 8.3.1 for class of excavation"]
[]
[null,null,"a) Intermediate excavation","m3",null,1,null,"Rate Only"]
[null,null,"b) Hard rock excavation","m3",null,1,null,"Rate Only"]
[]
[null,"8.3.5","Process subbase material by the following processes"]
[null,null,"a) Screening","m3",null,1,null,"Rate Only"]
[null,null,"b)Heavy grid rolling","m3",null,{"$f":"1500*7.6*0.15*1.5","v":2565},null,{"$f":"F27*G27","v":0}]
[]
[null,"8.3.9","Overhaul (haul exceeding 2 km) (provisional)","m3.km",null,{"$f":"1500*7.6*0.15*1.5*5","v":12825},null,{"$f":"F29*G29","v":0}]
[]
[null,"8.3.10","Overburden","m3",null,1,null,"Rate Only"]
{"$rows_empty":23}
["Carried to Summary"]

{"sheet":"Sch 5 Base","index":4,"n_rows":57,"n_cols":8,"rows_kept":57,"merged":[[0,3,0,7],[1,0,1,2],[1,3,1,7],[56,0,56,6]]}
[{"$nulls":3},"Schedule 5"]
["SCHEDULE 5 :  BASE"]
[]
["Item","Payment","Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Reference",{"$nulls":5},"(R)"]
[]
[]
[null,"SANS"]
[null,"1200MF","BASE"]
[]
["MF","8.3.1","Construct base with gravel material from borrow pits","m3",null,{"$f":"1500*7.3*0.15*1.5","v":2463.75},null,"Rate Only"]
[null,null,"in materials from borrow pit ( 97% Mod AASHTO Max Density, 150mm Thickness)"]
[]
["MF","8.3.2","Construct base with material from designated excavations"]
[null,null,"a) Excavate from designated excavations, select , and stockpile for base","m3",null,{"$f":"1500*7.3*0.15*1.5","v":2463.75},null,"Rate Only"]
[null,null,"b) Construct the base with material from the stockpile and compact to modified ","m3",null,{"$f":"1500*7.3*0.15*1.5","v":2463.75},null,"Rate Only"]
[]
["MF","8.3.3","Construct base with material from commercial sources"]
[null,null,"Compact material  to 97% Mod AASHTO Max Density, 150mm Thickness)"]
[]
[null,null,"a) Gravel material","m3",null,{"$f":"1500*7.3*0.15*1.5","v":2463.75},null,{"$f":"F21*G21","v":0}]
[null,null,"b) Graded crushed stone","m3",null,{"$f":"1500*7.3*0.15*1.5","v":2463.75},null,"Rate Only"]
[null,null,"c) Graded crushed stone and soil fines","m3",null,2463.75]
[]
[null,"8.3.4","Extra over for Item 8.3.1 for class of excavation"]
[]
[null,null,"a) Intermediate excavation","m3",null,{"$f":"F21*0.7","v":1724.625},null,"Rate Only"]
[null,null,"b) Hard rock excavation","m3",null,{"$f":"F21*0.3","v":739.125},null,"Rate Only"]
[]
[null,"8.3.5","Process base material by the following processes ( applicable to 8.3.1 or 8.3.2 /both)"]
[null,null,"a) Screening","m3",null,1,null,"Rate Only"]
[null,null,"b)Heavy grid rolling","m3",null,1,null,"Rate Only"]
[]
[null,"8.3.8","Stabilizing agent"]
[null,null,"b) Portland cement","t",null,{"$f":"F22*2300*0.03/1000","v":{"v":169.99875,"d":"170"}},null,{"$f":"F35*G35","v":0}]
[]
[null,"8.3.9","Overhaul (haul exceeding 2 km) (provisional)","m3.km",null,{"$f":"F21*5","v":12318.75},null,{"$f":"F37*G37","v":0}]
[]
[null,"8.3.10","Borrow Pits"]
[null,null,"a) Opening up","sum",{"$nulls":3},"Rate Only"]
[null,null,"b) Rehabilitation","sum",{"$nulls":3},"Rate Only"]
{"$rows_empty":15}
["Carried to Summary"]

{"sheet":"Sch 6 Paving","index":5,"n_rows":54,"n_cols":8,"rows_kept":54,"merged":[[0,3,0,7],[1,0,1,2],[1,3,1,7],[53,0,53,6]]}
[{"$nulls":3},"Schedule 6"]
["SCHEDULE 6 :  SEGMENTED PAVING"]
[]
["Item","Payment","Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Reference",{"$nulls":5},"(R)"]
[]
[null,"SANS"]
[null,"1200MJ"," SEGMENTED PAVING"]
[]
[null,"8.2.1","Provision of Edge Restraints ( 200mmx 100mm Edge Beam)","m","LIC",50]
[]
[null,"8.2.2","Construction of Paving Complete ( 80mm Interlocking paving Blocks, on 20mm bedding Sand","m2","LIC",{"$f":"1600*7*1.15","v":12879.999999999998}]
[]
[null,"8.2.3","Cutting Units to Fit Edge Restraints","m","LIC",{"$f":"F10","v":50}]
[]
[null,"8.2.4","Rolling to Locked-up Condition","m2","LIC",{"$f":"F12","v":12879.999999999998}]
{"$rows_empty":37}
["Carried to Summary"]

{"sheet":"Sch 7 Concrete Works","index":6,"n_rows":53,"n_cols":8,"rows_kept":53,"merged":[[0,3,0,7],[1,0,1,2],[1,3,1,7],[52,0,52,6]]}
[{"$nulls":3},"Schedule 5"]
["SCHEDULE 7 : CONCRETE (SMALL WORKS)"]
[]
["Item","Payment","Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Reference",{"$nulls":5},"(R)"]
[]
[null,"SANS"]
[null,"1200 GA","SECTION GA: CONCRETE (SMALL WORKS)"]
[]
["GA1",8.2,"Formwork"]
[]
["GA1.1","8.2.1","Rough","m2",null,{"$f":"(7+7+10+10)*0.2","v":6.800000000000001}]
[]
["GA1.3","8.2.3","Vertical narrow widths (up to 1150mm wide)","m",null,1,null,"Rate Only"]
[]
["GA2","8.1.2","Reinforcement"]
[]
["GA2.2.9","8.3.2","High-tensile welded mesh of mass 6.17 kg/m2","m2",null,{"$f":"15*7","v":105}]
[]
["GA3",8.4,"Concrete"]
[]
["GA3.2","8.4.2","Blinding layer(15 Mpa/10 Concrete)","m2","LIC",{"$f":"7*15","v":105}]
[]
["GA3.3","8.4.3","Strength concrete, Grade 25 Mpa/10","m3",null,70]
[" ",{"$nulls":3},"LIC"]
["GA3.4","8.4.4","Unformed surface finishes"]
[]
["GA3.4.1",null,"Wood-floated ","m2",null,{"$f":"F22","v":105}]
[]
["GA3.5",8.5,"Joints"]
[]
["GA3.5.1",null,"Type A","m",null,3]
[]
["GA3.5.2",null,"Type B ","m",null,3,null,"Rate Only"]
[]
["GA3.7",8.7,"Grouting","m3",null,1]
{"$rows_empty":16}
["Carried to Summary"]

{"sheet":"Sch 8 Kerbing & Channelling","index":7,"n_rows":56,"n_cols":8,"rows_kept":56,"merged":[[0,3,0,7],[1,0,1,2],[1,3,1,7],[55,0,55,6]]}
[{"$nulls":3},"Schedule 8"]
["SCHEDULE 8 :  Kerbing & channeling"]
[]
["Item","Payment","Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Reference",{"$nulls":5},"(R)"]
[]
[null,"SANS"]
[null,"1200MK","KERBING AND CHANNELLING"]
[]
[null,"8.2.1","Concrete Kerbing ( Figure 8)","m","LIC",{"$f":"1200*3+300*2-F12","v":4000}]
[]
[null,"8.2.4","Depressed Kerbs","m","LIC",{"$f":"10*20","v":200}]
[]
[null,"8.2.7","Trimming of Excavations for Concrete-Lined Open Drains in"]
[null,null,"a) Soft material","m2","LIC",{"$f":"300*2.5","v":750},null,{"$f":"F15*G15","v":0}]
[null,null,"b) Intermediate material","m2","LIC",{"$f":"1500*2.5","v":3750},null,"Rate  Only"]
[]
[null,"8.2.8","Cast-In-situ Concrete Lining to Open Drains (25MPa/10)","m3","LIC",{"$f":"(5*0.5*0.2)*1500/50","v":15}]
[]
[null,"8.2.9","Formwork to Cast-In-Situ Concrete Lining of Open Drains ( Smooth finish)"]
[null,null,"a) To sides with formwork on the internal face only","m2","LIC",{"$f":"(2*5*0.2)*1500/50","v":60}]
[null,null,"c) To ends of slabs","m2","LIC",{"$f":"(1500/50)*0.2","v":6}]
[]
[null,"8.2.10","Sealed Joints in Concrete Lining of Open Drains ","No.","LIC",{"$f":"(1500/50)*5/5.5","v":{"v":27.272727272727273,"d":"27"}}]
[]
[null,"8.2.12","Steel Reinforcement (Mesh Ref 617)","t","LIC",{"$f":"F21*6.17/1000","v":0.3702}]
{"$rows_empty":29}
["Carried to Summary",{"$nulls":6},{"$f":"SUM(H5:H54)","v":0}]

{"sheet":"Sch 9 Ancillary Road Work","index":8,"n_rows":61,"n_cols":8,"rows_kept":61,"merged":[[1,6,1,7],[60,0,60,6]]}
[]
["SCHEDULE 5: ANCILLARY ROAD WORK",{"$nulls":5},"Ancillary Road Work"]
[]
["Item","Payment","Description","Unit","LIC","Qty","Rate","Amount"]
["No.","Reference",{"$nulls":5},"(R)"]
[]
[]
[null,"SANS"]
[null,"1200MM ","Ancillary roadworks"]
[]
[null,"8.2.5","Reflector Plates (Danger Plate)","No.",null,{"$f":"4","v":{"v":4,"d":"4.00"}},null,"Rate Only"]
[]
[null,"8.3.3","Sign supports"]
[null,null,"a) structural steel","t",null,0.1,null,"Rate Only"]
[null,null,"b) Steel Tubing ( Galvanised)","t","LIC ",0.2]
[null,null,"c) Timber (50mm Diamter, gampole)","m","LIC ",{"$f":"F18*3","v":12}]
[]
[null,"8.3.6","Statutory Signs ( Stop Sign)","No.",null,4]
[]
[null,8.4,"Road Markings (Stop Sign)","No.",null,4]
[]
[null,"8.4.1","Non-reflectorized Paint Applied at Nominal Rate of 0.42 l/m2"]
[]
[null,null,"a) White lines (broken or unbroken) (100mm thick)","km",null,1.5]
[null,null,"b) Yellow lines (broken or unbroken) (150mm thick)","km",{"$nulls":3},"Rate Only"]
[null,null,"c) White characters and symbols","m2",{"$nulls":3},"Rate Only"]
[null,null,"d) Yellow characters and symbols","m2",{"$nulls":3},"Rate Only"]
[]
[null,"8.4.4","Setting out and Premarking"]
[null,null,"a) Lines","km",null,1.5]
[null,null,"b Special Markings","No.",null,2,null,"Rate Only"]
[]
[null,"8.5","Brickwork (FBX 14Mpa, 230mm)","m2",null,15]
{"$rows_empty":27}
["Carried to Summary"]

{"sheet":"Summary","index":9,"n_rows":48,"n_cols":3,"rows_kept":48,"merged":[[7,0,7,2],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1]]}
[]
[]
[]
[null,"BILL OF QUANTITIES"]
[]
[null,"Summary"]
[]
[]
[]
["Schedule No.","Description","Amount ( R )"]
[1,"Preliminary and General"]
[2,"Day Works"]
[3,"Earthworks (Subgrade)"]
[4,"Subbase"]
[5,"Base "]
[6,"Segmented Paving"]
[7,"Concrete (Small Works)"]
[8,"Kerbing & Channelling"]
[9,"Ancillary Road Work"]
["SUB-TOTAL A"]
["5% CONTIGENCIES (ON SUB-TOTAL A)"]
["SUB TOTAL B (SUB-TOTAL A + 5% CONTIGENCIES)"]
["SUB TOTAL C (SUBTOTAL B)"]
["15% VAT (ON SUB-TOTAL B)"]
["TOTAL"]
{"$rows_empty":22}
[null,null,"C2.2.15"]