Spreadsheet: 124225d1318259427-excel-2007-forumating-from-drop-down-boxes-domestic-quote-generator-master-rev-qq
Sheet: Project Summary

MECHANICAL PRICE GENERATOR (DOMESTIC PLUMBING/HEATING PROJECT SUMMARY)
Externals | Target | QTY | Total |  | Client
External Guttering High Level (per house side) | 0 | 0 |  |  | Job/Project
External Guttering Low Level (per  canopy) | 0 | 0 |  |  | Area/Type
RWP Drops 3 Story (per drop) | 0 | 0 |  |  | Prices Last Updated
RWP Drops 2 Story (per drop) | 0 | 0
RWP Drops 1 Story/canopy (per drop) | 0 | 0 |  |  | Set Labour Rate | 0
1st Fix Preparation | Target | QTY | Total
[NAME] | 0 | 0 |  |  | Materials
Builders Work | 0 | 0 |  |  | First Fix Materials |  | 0
Core Drilling (Flue/Soil) | 0 | 0 |  |  | Second Fix Materials |  | 0
Core Drilling (Wastes) | 0 | 0 |  |  | Third Fix Materials |  | 0
Joist Drilling TJI Knock Out Type | 0 | 0 |  |  | Consumables |  | 0
Joist Drilling Traditional Type | 0 | 0 |  |  |  | Sub Total | 0
1st Fix Domestic H & C | Target | QTY | Total |  |  | Mark up @ | 0.15
Domestic H & C (Kitchen) | 0 | 0
Domestic H & C (Bathroom) | 0 | 0
Domestic H & C (WC) | 0 | 0 |  |  | Direct Costs / Expenses / Preliminaries
Domestic H & C (En Suite) | 0 | 0 |  |  | Plant |  |  | 0 | qty@ | 0
Domestic H & C (Utility) | 0 | 0 |  |  | Skips |  |  | 0 | qty@ | 0
External Tap Supply | 0 | 0 |  |  | Storage |  |  | 0 | qty@ | 0
Shower Supply (Mixer) | 0 | 0 |  |  | Direct Supervision |  |  | 0 | hrs@ | 0
Shower Supply (Electric) | 0 | 0 |  |  | Van |  |  | 0 | qty@ | 0
Shower Tray | 0 | 0 |  |  | Diesel/Travel Exp. |  |  | 0 | qty@ | 0
Pressure Test & Complete Test Sheet | 0 | 0 |  |  | Travel Time |  |  | 0 | qty@ | 0
1st Fix Wastes | Target | QTY | Total |  | Building Control Notifi. |  |  | 0 | qty@ | 0
[NAME] (Per Stack) | 0 | 0 |  |  | Other - Specify |  |  |  |  |  | 0
[NAME] (Per Stack) | 0 | 0
Wastes Routed to Stack (Kitchen) | 0 | 0
Wastes Routed to Stack (Bathroom) | 0 | 0 |  |  | Labour
Wastes Routed to Stack (WC) | 0 | 0 |  |  | Externals
Wastes Routed to Stack (En Suite) | 0 | 0 |  |  | 1st Fix
Wastes Routed to Stack (Utility) | 0 | 0 |  |  | 2nd Fix
Drain Testing | 0 | 0 |  |  | 3rd & Final Fix
Drain Testing (witnessed) | 0 | 0 |  |  | General
1st Fix Heating | Target | QTY | Total |  |  | Sub Total
Gas [NAME] to [NAME] | 0 | 0 |  |  |  | Overheads @ | 0.1
Gas Supply to Livingroom | 0 | 0 |  |  |  | Total Labour
Gas Supply to Hob | 0 | 0
Radiator F & R (Per Radiator) | 0 | 0 |  |  | Summary
Pressure Test & Complete Test Sheet | 0 | 0 |  |  | Total Materials
2nd Fix Heating | Target | QTY | Total |  | Total Costs
Combination Boiler complete & Flue | 0 | 0 |  |  | Total Labour
System Boiler complete  & Flue | 0 | 0 |  |  |  | Total All
[NAME] complete with associated controls | 0 | 0 |  |  |  | Profit @ | 0.085
Vented Cylinder complete | 0 | 0 |  |  |  | Total Profit
Heat Pump | 0 | 0
Heat Pump Cylinder | 0 | 0 |  |  |  | Total
Radiator [NAME] (per radiator) | 0 | 0
Radiator TRV’s, [NAME] (per radiator) | 0 | 0
[NAME] | 0 | 0 |  |  | Labour Targets Summary
Fill Up, Test for leaks & Complete Test Sheet | 0 | 0 |  |  | Externals
Safely Load into position Bulk Materials | 0 | 0 |  |  | 1st Fix
2nd Fix Domestic & Sanitaryware | Target | QTY | Total |  | 2nd Fix
Bathroom Sanitaryware (Fixed into position) | 0 | 0 |  |  | 3rd & Final Fix
Bathroom Sanitaryware (Final connections) | 0 | 0 |  |  | General
En Suite Sanitaryware exc. Shower & tray (Fixed into position) | 0 | 0 |  |  | Total Hours
En Suite Sanitaryware exc. Shower & tray  (Final connections) | 0 | 0
Shower Connection (Mixer or Electric) | 0 | 0
WC Cloaks Sanitaryware (Fixed into position) | 0 | 0
WC Cloaks Sanitaryware (Final connections) | 0 | 0
Stop Tap & Mains Connection | 0 | 0
External Bib Tap | 0 | 0
Fill Up, Test for leaks & Complete Test Sheet | 0 | 0
Safely Load into position Bulk Materials | 0 | 0
3rd & Final Fix | Target | QTY | Total
Gas Test, Boiler Commissioning & Benchmark | 0 | 0
Shower Door | 0 | 0
Kitchen Sink Connections inc. Waste | 0 | 0
Appliance Connection | 0 | 0
Kitchen Gas Hob Connection | 0 | 0
Utility Sink Connections inc. Waste | 0 | 0
Toilet Seats, Plugs & Chains | 0 | 0
General | Target | QTY | Total
Collect, Clear Materials & Tidy | 0 | 0
Snagging | 0 | 0
Other - Specify | 0 | 0