Spreadsheet: 738101d1624840246-use-of-inside-of-array-formulas-book3
Sheet: Tips

Pay Item | Description of Work | Amount
G2-C2 – GENERAL REQUIREMENTS (MAJOR CONTRACTS) Ed 5/Rev 17
G2-C2P1 | Primary Testing. Subcontract (Provisional Sum)  (if designated in Annexure G2/A) | 50000
[NAME] | WAE Drawings | 50000
 |  | 100000
G4 – PRINCIPAL'S PROJECT ACCOMMODATION Ed 2/Rev 0
G4P1 | Establishment of Principal's Project Accommodation | 46880
G4P2 | Maintenance of Principal’s Project Accommodation until Completion | 48560
[NAME] | Maintenance of Principal’s Project Accommodation after Completion (Item with provisional quantity) | 7614
G4P4 | Removal of Principal's Project Accommodation | 4451
 |  | 107505
G7 – UTILITY ADJUSTMENT Ed 1/Rev 2
G7P1 | Coordination and Management of Utility Adjustment Work | 54000
G7P5 | Electricity Mains
G7P5.1 | Adjustment to Existing Electrical Mains | 174400
G7P7 | Engagement of Water Servicing Coordinator | 54000
G7P8 | Water Mains
G7P8.1 | Adjust Water Mains | 376700
G7P9 | Sewer Mains
G7P9.1 | Adjust Sewer Mains | 91130
G7P10 | Telecommunications
G7P10.1 | Adjust Telecommunications | 51420
 |  | 801650
G10 – TRAFFIC MANAGEMENT Ed 6/Rev 0
G10P1 | Traffic Management | 297000
G10P2 | Maintenance of Traffic Control Measures | 224700
G10P3 | Routine maintenance of Existing Roadways | 44670
G10P4 | [NAME] of New Roadways Opened to Traffic | 2471
 |  | 568841
G36 – ENVIRONMENTAL [NAME] 4/Rev 5
G36P1 | Building Condition Inspections
G36P1.1 | Residential | 18225
G36P1.2 | Commercial | 2025
[NAME] | Site Environmental Monitoring
G36P2.1 | Air Quality | 37740
G36P2.2 | Noise | 51950
G36P2.3 | Ground Vibration | 32280
G36P3 | Land condition assessments reports for [NAME] nominated area(s) used for Contractor’s facilities
G36P3.1 | Pre-construction land condition assessment reports | 8100
G36P3.2 | Post-construction land condition assessment reports | 16200
 |  | 166520
G38 – SOIL AND WATER MANAGEMENT Ed 2/Rev 2
G38P1 | Soil and Water Management Control Measures
G38P1.1 | Establishment of Soil and Water Management Control Measures | 103700
G38P1.2 | [NAME] Water Management Control Measures | 25230
G38P2 | Site Water Quality Monitoring | 38220
G38P3 | Operational basins | 54040
 |  | 221190
G40 – CLEARING AND GRUBBING Ed 1/Rev 1
G40P1 | Clearing and Grubbing | 55550
G40P2 | Production and Stockpiling of Mulch | 18594
G40P3 | Demolition
G40P3.1 | Saw cutting & removal of existing pavement | 81725.76000000001
 |  | 155869.76
R11 – STORMWATER DRAINAGE Ed 5/Rev 2
R11P1 | Open Drains
R11P1.1 | Excavation for Open Drains | 22552.5
R11P2 | Excavation for Stormwater Drainage Structures
[NAME]) | Excavation for Pipe Culverts | 102352.5
R11P2.(b) | Excavation for Box Culverts | 8688.7
R11P2.(c) | Excavation for Other Drainage Structures | 4139.2
R11P3 | Inadequate Foundation Material under Drainage Structures and [NAME] (Item with provisional quantity) | 5496.000000000001
R11P5 | Precast Concrete and Fibre-reinforced Concrete Pipes
R11P5.1 | 375 Diameter - Class 4 - Rubber Ring Joint | 186992.4
R11P5.3 | 450 Diameter - Class 4 - Rubber Ring Joint | 121031.1
R11P5.5 | 600 Diameter - Class 4 - Rubber Ring Joint | 12409.95
R11P6 | Precast Concrete Box Culvert Structures (Excluding Inlet and [NAME])
R11P6.1 | 1 / 3000mm x 900mm x 14m | 59420
[NAME] | 1 / 2400mm x 1200 ([NAME]) x 14 (m) | 48580
R11P6.3 | 1 / 1200mm x 300 (mm) x 14 (m) | 54060
R11P6.4 | 1 / 600mm x 300 (mm) x 14 (m) | 12460
R11P6.5 | 1 / 600mm x 300 (mm) x 36 (m) | 30050
R11P7 | [NAME] Other Than Pipes and Box Culverts
R11P7.1 | Single Headwall - 375mm | 2754
R11P7.2 | Single Headwall - 450mm | 6835
[NAME] | Single Headwall - 600mm | 3208
[NAME] | Headwall to Suit 1 cell x 3000mm x 900mm RCBC | 21000
R11P7.6 | Headwall to Suit 1 cell x 2400mm x 1200mm RCBC | 27740
[NAME] | Headwall to Suit 3 cell x 1200mm x 300mm  RCBC | 15160
R11P7.8 | Headwall to Suit 1 cell x 600mm x 300mm RCBC | 15512
R11P7.18 | Standard Gully Pit Type SA1 | 46356
R11P7.19 | Standard Gully Pit Type RT | 99107
R11P8 | [NAME]
R11P8.1 | D50 - 230mm Thick | 4644.42
R11P9 | Removal of Redundant Stormwater Drainage
R11P9.1 | Remove Redundant Stormwater Pipes =< 750mm diameter | 2936.9
R11P9.3 | [NAME] =< 750mm dia | 861.88
R11P9.5 | Remove redundant stormwater pits | 2188.16
 |  | 916535.7100000002
R15 – KERBS AND CHANNELS (GUTTERS) Ed 5/Rev 0
R15P1 | Kerbs and Channels
R15P1.1 | Type SA | 63869.19
R15P1.2 | Type RT | 156523
R15P6 | No Fines Concrete Pad (Beneath Kerb and Channel)
R15P6.1 | No Fines Concrete | 96630.3
R15P6.2 | Geotextile | 22673.6
 |  | 339696.09
R33 – TRENCH [NAME] 4/Rev 2
R33P1 | Excavation | 72837.6
R33P2 | Drainage Pipe
R33P2.1 | 100 mm dia Corrugated Perforated Plastic Drainage Pipe | 53613.42
R33P2.2 | 100 mm dia Corrugated Non-perforated Plastic Drainage Pipe | 273.5
R33P3 | Filter Material
R33P3.1 | Aggregate Filter Material | 166966.8
R33P4 | Supply and Installation of Geotextile | 58943.7
 |  | 352635.02
R44 – EARTHWORKS Ed 5/Rev 0
R44P1 | Topsoil
R44P1.1 | Removal and Stockpiling of Non-Contaminated Topsoil | 42453.2
[NAME] | Removal and Disposal Off-Site of Topsoil (Bank Volumn) | 365277.9
R44P2 | General [NAME] (Cut/Fill) | 24381.4
R44P3 | Imported or Borrowed Material (other than Selected Material, Verge Material and Foundation Treatment Material) | 234904.4
R44P4 | Unsuitable Material (Item with provisional quantity) | 92933.40000000001
R44P5 | Selected Material in the Selected Material Zone and Verge Material
R44P5.2 | Selected Material Zone - Imported Material | 72865.2
R44P5.4 | Verge – Imported Material | 52304
R44P7 | Foundation Treatments
R44P7.1 | Treatment Type E1 - Loosen and Recompact | 57876
R44P7.2 | Treatment Type C1 - Loosen and Recompact | 5044
R44P8 | Identification, Treatment and Disposal Off Site of Contaminated Material
R44P8.2 | Other Contaminated Material | 50000
 |  | 998039.5
R50 – STABILISATION OF EARTHWORKS Ed 4/Rev 0
R50P1 | Supply of Binder | 0
[NAME] | Quicklime  (Item with provisional quantity) | 98658
R50P2 | Stabilisation of Earthworks by [NAME] | 0
R50P2.1 | Quicklime  (Item with provisional quantity) | 100749
 |  | 199407
R71 – UNBOUND AND MODIFIED PAVEMENT COURSE Ed 4/Rev 2
R71P1 | Supply and Place Subbase | 112814.75
 |  | 112814.75
R73 – CONSTRUCTION OF PLANT MIXED HEAVILY BOUND PAVEMENT COURSE Ed 3/Rev 1
R73P1 | Bound Pavement Course
[NAME] | 240mm Thick | 933788
 |  | 933788
R101 – COLD MILLING OF ROAD PAVEMENT MATERIALS Ed 3/Rev 1
R101P1 | Milling to Specified Depth of Cut | 0
R101P1.1 | 0 mm to 50 mm Deep (Item with a provisional quantity) | 22787.4
 |  | 22787.4
R107 – SPRAYED BITUMINOUS SURFACING (WITH POLYMER MODIFIED BITUMEN) Ed 3/Rev 1
R107P1 | Supply and [NAME] (including Adhesion Agent where required and Preparation of Surface) | 94125.20000000001
R107P2 | Supply, Incorporate and Spray Cutter Oil in Binder | 7334.84
R107P4 | Supply, Precoat, Apply and Incorporate Aggregate | 0
R107P4.2 | 7 mm Aggregate (Precoated) | 40532.71000000001
 |  | 141992.75
R116 – HEAVY DUTY DENSE GRADED ASPHALT Ed 8/Rev 4
R116P1 | Supply and Application of Tack Coat (Including Preparation of Surface) | 27602
[NAME] | Heavy Duty Dense Asphalt in Corrective Courses | 0
R116P2.4 | 14 mm [NAME], varying thickness (AR450  Binder) | 368640
R116P3 | Heavy Duty Dense Asphalt in Intermediate Courses
R116P3.3 | 20 mm [NAME]
R116P3.3.1 | 220 mm thick AC20 ([NAME]) | 714420
R116P4 | Heavy Duty Dense Asphalt In Wearing Course
R116P4.4 | 14 mm [NAME]
[NAME] | 50 mm thick (A15E Binder) | 195652.8
R116P4.4.2 | 70 mm thick ([NAME]) | 1040236.6
R116P8 | Miscellaneous Items
R116P8.1 | [NAME] if specified in Annexure R116/A (rate for each nominated mix) | 6750
R116P8.2 | Wheel Tracking Test if specified in Annexure R116/A (rate for each nominated mix) | 6750
 |  | 2360051.4