Comparison Tracker · Free · No account
Compare builders’ and tradespeople’s quotes in Excel.
The quotes setup is for work done once. Each row is a Quote, with price, one-off extras, a total and three must-haves: Insured, Can start this month and Guarantee on the work. Received and Valid until dates mark a quote as ending soon or expired.
- Excel 2016 and later
- Calculations checked in LibreOffice and Google Sheets
- Name each rowType what each row is called, such as Quote, Provider or Place. It becomes the first column heading and the sheet name.
- Write your must-havesList up to six, one per line. Each becomes a column answered Yes, Partly or No. Choose the currency and how many months to compare costs over.
- Download and add optionsDownload the workbook, open the sheet and add each quote as it arrives. The total, the gap from the cheapest and the Summary update automatically.
Build your workbook
Preview: Contractor quote comparison. Change the selected dates, categories or layout to update the preview.
JavaScript is required to use the builder. The workbook is made in your browser.
What you get
What is different in this setup
Homeowners collecting quotes for a roof, a kitchen or an extension who need to see which are still valid and what each leaves unanswered.
- Received and Valid until dates, with quotes marked ◐ as they near expiry and ● once past.
- Contact and Phone or email columns for each tradesperson.
- No monthly cost, because the job is paid once.
Sheets included (5)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- QuotesEach quote once, with its costs and must-haves.
- SummaryWhat is still in the running, by total cost, and what is still to find out.
- ListsEdit the white lists to change dropdown choices. Shaded lists are fixed because formulas use those names.
- SettingsValues used by the workbook, such as reminder windows. Change them here.
File details
- Made for
- Excel 2016 and laterThe download is an .xlsx workbook.
- LibreOffice
- No calculation errors in our testLibreOffice recalculated every formula in the workbook with no error values, such as #VALUE! or #N/A.
- Google Sheets
- Calculations matched Excel in our testGoogle Sheets removes sheet protection and repeated print headings.
- Apple Numbers
- Some calculations do not workMany calculations on the Quotes sheet and the Summary sheet do not work in Apple Numbers. Numbers converts list-based dropdowns to plain cells and removes colour markers, sheet protection, frozen headings and number and date validation. Use Excel for these calculations and features.
- Calculations
- The Start Here sheet lists the calculations used in this workbook. Results update from the entries you add.
- Builder privacy
- The builder runs in your browser. The entries used to make the workbook stay on your device. How the utilities work
Questions
Are my builder entries sent to Due Form?
No. The builder uses them in your browser to make the workbook on your device.
Information is sent to Due Form when you submit a form or use another service described on the How it works page.
How soon is a quote marked as ending?
A quote is marked ◐ when it is valid for 7 more days or fewer. The 7 is a number on the Settings sheet, which you can change to suit.
What if one builder leaves out something another includes?
Put the difference in One-off extras or in Doubts. The total then shows the extra cost, and the Doubts column records what to ask before you decide.
Related Due Form edition
The Decision File
Compare viable options, record the reasoning and set a review date.
For weighing the options once the facts are in
Request a tool or send feedback
Request a tool or report a problem
Tell us what you would like to add, change or fix in the Comparison Tracker builder.