Comparison Tracker · Free · No account
Compare broadband, energy or service contracts in Excel.
The service setup names each row a Provider and adds an Each month column. The total is the price plus one-off fees plus the monthly cost over 24 months. Must-haves are No exit fee after the term and Support by phone, and quote dates show when an offer ends.
- 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: Service provider 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
Anyone choosing a contract with a monthly charge, such as broadband, an energy tariff or software, where a low start price hides a dearer term.
- An Each month column, counted over 24 months in the total.
- The length of the comparison is 24 months instead of 12, changeable on Settings.
- Quote dates are on, so an offer’s end date is marked.
Sheets included (5)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- ProvidersEach provider 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.
Does the total include the monthly cost?
Yes. Each month is multiplied by the number of months on the Settings sheet and added to the price and one-off fees, so two contracts are compared over the same period.
Can I compare contracts of different lengths?
No. The total uses one period for every row. Choose the length you expect to stay, and add a Doubts note for a provider whose minimum term is longer.
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.