The spreadsheet only one person understands: how to tell when it's time to replace it

There's a file on the shared drive called something like PRICING_FINAL_v7_USE_THIS_ONE.xlsx. It has 14 tabs. Some columns are hidden. One cell is coloured yellow and has a comment that says "don't change". Every quote, order or job price in the business runs through it.

And one person understands it. When they're on leave, quotes wait. When they leave for good, you find out what it really did.

This isn't a criticism of spreadsheets. Spreadsheets are how most good tools start. Someone smart worked out the maths, put it in Excel, and it worked. The trouble starts when the business grows around it and the file never grows up.

A ten-minute risk test

Open the file and answer these honestly. Give yourself one point for each "yes".

1. Only one or two people can use it without breaking something.
2. Someone has to copy numbers in from somewhere else: a supplier price list, an exchange rate, last month's rates.
3. Copies of it exist. On desktops, in email attachments, on someone's laptop "just in case".
4. You've found a wrong number in it in the past year, and you're not sure how long it was wrong.
5. The answer gets retyped into a quote, an invoice or an email once it's worked out.
6. Customers or staff wait for it. "I'll get back to you with a price" is said most days.
7. Nobody can tell you who changed what, or what the price was for a job six months ago.

0 to 2: It's working. Leave it alone, and maybe write down how it works.

3 to 4: It's carrying more weight than it should. Worth a look in the next quarter.

5 or more: The business depends on a file that could break, go stale or walk out the door. That's the point to replace it.

What replacing it actually means

Replacing a spreadsheet doesn't mean buying a big system. Usually it means turning the calculation into a small web tool that anyone on the team can use from a browser or a phone. That's what our business calculators and estimators are.

The maths stays the same. We take your actual formulas, the yellow cell included, and rebuild them. Then we check the tool against real past jobs or orders until it gives the same answers as the spreadsheet. If the spreadsheet had a mistake, this is where it shows up, and you decide what the right answer is.

Inputs come in, answers come out. Staff fill in a short form: product, quantity, distance, whatever your calculation needs. The tool does the rest. No hidden tabs, nothing to accidentally overwrite.

Live numbers update themselves. Exchange rates, rate tables and supplier prices can be pulled in or updated in one place, instead of pasted in by hand.

Every result is saved. Who ran it, when, with what inputs. "What did we quote that customer in March?" becomes a search.

Rates can change without breaking history. When your prices go up, old quotes still show the old numbers. That's hard to do in a spreadsheet and simple in a proper tool.

The answer goes somewhere useful. A PDF for the customer, a quote ready to send, or numbers into a dashboard so you can see what's being priced and what's being won.

A real example

We did this for a Sydney seafood wholesaler. Pricing imported stock depended on supplier price, currency, freight, duty, insurance and wastage, and the maths lived in a 14-tab spreadsheet only one person understood. We rebuilt the formulas as a clean web calculator, checked them against past shipments, then added invoicing and statements on the same data so nothing gets typed twice. The team now quotes customers in the same phone call.

That last part matters. Once the calculation is out of the spreadsheet, the next step (the quote, the invoice, the report) can use it directly. If the retyping is what's hurting, our five-minute invoicing calculation puts a number on it.

What stays the same

Your pricing logic stays yours. The person who built the spreadsheet is usually the most important person in the project, because they know why the yellow cell matters. We work from what they know, not around them.

Your accounting system stays where it is. Xero or MYOB still gets the invoices. The tool sits beside it, not instead of it.

And you can still export to Excel. Plenty of people like a spreadsheet for looking at numbers. The difference is that the spreadsheet becomes a report, not the engine.

When it isn't worth it

• The file is simple and stable. If it's a few formulas that rarely change and two people can use it, protect the sheet, back it up and move on.
• An off-the-shelf tool already does it. Freight calculators, loan calculators and some industry quoting tools exist and are fine. Our piece on off-the-shelf software or custom-built covers how to decide.
• The maths changes every week because the business is still working out how to price. Let it settle first. A tool built around a moving target will need rebuilding.
• Nobody can explain the formula. If the person who built it has gone and no one can say why it works, start by working that out. We can help, but the answer has to come from your business.
• The real problem is somewhere else. If quotes are slow because jobs aren't recorded properly, a calculator won't fix that.

How long it takes

A focused calculator is usually built in under a week. Larger ones with live data, saved scenarios and PDF output take longer, and we'll tell you which yours is before we start. If cost is the next question, our pricing page has the ranges.

What working with us looks like

We start with a 30-minute call. Bring the spreadsheet, and ideally the person who understands it. You get a written scope and a fixed price. Then we build a working prototype of the core calculation, free, and run it against a handful of your real past jobs so you can compare the answers side by side. If it doesn't do what we agreed, you walk away. You see it working before you pay.

Send us the spreadsheet everyone's afraid of and we'll show you what it looks like as a tool.