Cost item templates
Reusable line definitions (item + quantity / value / cost rules) you can drop into any quotation.
| Item | Quantity | Value | Cost | Actions |
|---|---|---|---|---|
| Edging Not Chosen | Formula: Main edging required | 0 | Formula: (this row) Quantity × cost of "Edging Not Chosen" | |
| Form field: Job type | 13 | 0 | Formula: (this row) Quantity × (this row) Value | |
| Form field: Job type | 200 | 0 | Formula: (this row) Quantity × (this row) Value | |
| Form field: Surface 2 stone 1 | Form field: Total m² | 0 | Formula: (this row) Quantity × 12 | |
| Plum 1-3mm | Formula: cost of "Plum 1-3mm" | 0 | Formula: (this row) Quantity × cost of "Plum 1-3mm" | |
| test 0 | Formula: CEILING(2.2 ÷ 0, 1) | 0 | Formula: (this row) Quantity × (this row) Value | |
| test 3 | Formula: Total m² | 0 | Formula: (this row) Quantity × cost of "DTP1 Hardcore" | |
| testing purpose | Formula: Total m² − 02 × 03 + cost of "Steel edge 2.5m" | 0 | Formula: (this row) Quantity × (this row) Value | |
| Top soil | Pricing cost: Top soil | 0 | Formula: (this row) Quantity × 2 | |
| Digger and driver hire (days) | Form field: Digger days | 0 | Formula: (this row) Quantity × cost of "Digger/Driver hire" | |
| 8 wheel grabs (12 cubic metres per grab) | Formula: ROUNDUP(spec Muckaway per sq.m × Main colour m² ÷ 12 + spec Muckaway per sq.m × Second colour m² ÷ 12) | 0 | Formula: (this row) Quantity × cost of "Grab (8 wheel)" | |
| DTP1 (Tonnes) | Formula: spec Sub-base tonnes per sq.m × Main colour m² + spec Sub-base tonnes per sq.m × Second colour m² | 0 | Formula: (this row) Quantity × cost of "DTP1 Hardcore" | |
| Geotextile membrane (in rolls of 450 sq.m) | Formula: ROUNDUP(Main colour m² ÷ 450 + Second colour m² ÷ 450) | 0 | Formula: Main colour m² ÷ 450 × cost of "Geotextile membrane 450sqm" + Second colour m² ÷ 450 × cost of "Geotextile membrane 450sqm" | |
| Ground reinforcement grid (in rolls of 200 sq.m | Formula: ROUNDUP(Main colour m² ÷ 200 + Second colour m² ÷ 200) | 0 | Formula: Main colour m² ÷ 200 × cost of "Ground reinforcement" + Second colour m² ÷ 200 × cost of "Ground reinforcement" | |
| Autumn Rumbled 140 x 100 | Form field: Main edging required | 0 | Formula: (this row) Quantity × Main edging unit £ | |
| Steel edge 2.5m | Form field: Second edging required | 0 | Formula: (this row) Quantity × Second edging unit £ | |
| Ballast bulk bags (for edgings) | Formula: CEILING(Main edging linear m × 13.71 ÷ 800 + Second edging linear m × 13.71 ÷ 800, 1) | Formula: 13.71 × Main edging linear m + 13.71 × Second edging linear m | Formula: (this row) Quantity × cost of "Ballast" | |
| 25kg Cement bags (for above) | Formula: CEILING(Main edging linear m × 3.09 ÷ 25 + Second edging linear m × 3.09 ÷ 25, 1) | Formula: 3.09 × Main edging linear m + 3.09 × Second edging linear m | Formula: (this row) Quantity × cost of "Cement" | |
| Aco Channel 1m | Form field: Other drainage 1 m | 0 | Formula: (this row) Quantity × Other drainage 1 unit £ | |
| Drain hopper single | Form field: Other drainage 2 m | 0 | Formula: (this row) Quantity × Other drainage 2 unit £ | |
| Standard base 6-10mm (25kg bags) | Form field: Std base 6-10mm units | 0 | Formula: (this row) Quantity × cost of "STD base gravel (10mm)" | |
| Filler aggregate 1-3mm or 2-5mm (25kg bags) | Form field: Filler aggregate units | 0 | Formula: (this row) Quantity × cost of "Red 1-3mm" | |
| STD Base mesh Sq.metres (130 Sq.m rolls) | Formula: ROUNDUP(2 × Main colour m² ÷ 130 + 2 × Second colour m² ÷ 130) | 0 | Formula: (this row) Quantity × cost of "SRM Mesh" | |
| Non UV Standard Base Resin (5kg kits) | Form field: Non-UV base resin units | 0 | Formula: (this row) Quantity × cost of "Standard base binder" | |
| ECO Base rubber (25kg bags) | Form field: ECO base rubber units | 0 | Formula: (this row) Quantity × cost of "4-7mm Rubber granulate" | |
| ECO Base stone 1-3mm (25kg bags) | Form field: ECO base stone 1-3mm units | 0 | Formula: (this row) Quantity × cost of "Red 1-3mm" | |
| ECO Base stone 2-5mm (25kg bags) | Form field: ECO base stone 2-5mm units | 0 | Formula: (this row) Quantity × cost of "Red 2-5mm" | |
| ECO Base binder (20kg kegs) | Form field: ECO base binder units | 0 | Formula: (this row) Quantity × cost of "Rubber binder" | |
| Autumn Quartz 2-5mm | Form field: Surface 1 stone 1 units | Pricing cost: Autumn Quartz 2-5mm | Formula: (this row) Quantity × (this row) Value | |
| Golden Quartz 2-5mm | Form field: Surface 1 stone 2 units | Pricing cost: Golden Quartz 2-5mm | Formula: (this row) Quantity × (this row) Value | |
| Silver 1-3mm | Form field: Surface 1 stone 3 units | Pricing cost: Silver 1-3mm | Formula: (this row) Quantity × (this row) Value | |
| Pearl Quartz 2-5mm | Form field: Surface 2 stone 1 units | Pricing cost: Pearl Quartz 2-5mm | Formula: (this row) Quantity × (this row) Value | |
| Pearl Quartz 1-3mm | Form field: Surface 2 stone 2 units | Pricing cost: Pearl Quartz 1-3mm | Formula: (this row) Quantity × (this row) Value | |
| Not required | Form field: Surface 2 stone 3 units | Pricing cost: Not required | Formula: (this row) Quantity × (this row) Value | |
| Binding quartz (4kg) 1 bag per mix | Formula: Surface 1 mixes + Surface 2 mixes | 0 | Formula: (this row) Quantity × cost of "Binding quartz" | |
| Crushed glass Anti slip addative (1 bag = 200 Sq.m) | 1 | 0 | Formula: (this row) Quantity × cost of "Crushed Glass" | |
| UV Stable resin kits (7.5kg) | Formula: Surface 1 mixes + Surface 2 mixes | Formula: Total m² ÷ 3.2 | Formula: (this row) Quantity × cost of "Resin kits" |