Skip to content
Resources

When a spreadsheet stops working and you need a custom dashboard

The five signs a business has outgrown its spreadsheets, what custom software costs, and how to avoid spending $9,500 on something you did not need.

Ravion Moyers · September 23, 2026

You have outgrown your spreadsheet when more than one person needs to change it at the same time, when somebody has to rebuild a report by hand every week, or when the person who understands it becoming unavailable would genuinely hurt the business. Those three cover most cases.

If none of those are true, keep the spreadsheet. It is free, everyone knows how to use it, and I would rather tell you that than sell you something starting at $9,500 which you did not need.

The five signs

More than one person needs it at once. Shared sheets technically allow it, but you know what actually happens: two versions, one overwrites the other, and somebody's morning disappears. The moment concurrent editing matters, you need something with a real notion of who changed what.

Somebody rebuilds a report by hand. If a person spends Monday morning copying numbers into a summary, you are paying a salary for work a database does instantly. This one is easy to cost. Take the hours, multiply by the year.

One person is the single point of failure. There is a spreadsheet that only Dave really understands. Dave is fine, but the business is carrying a risk it has not priced. When the knowledge lives in formulas nobody else can read, that is not a tools problem yet, but it is about to be.

The data is right but nobody trusts it. Once people start keeping their own side copies "just to be sure", the central version has already failed. Side copies are the clearest symptom of a system people have stopped believing.

It has to work away from a desk. Spreadsheets on a phone are miserable. If the people with the real information are in a truck, on a site, or in a kitchen, they will not update it, and you will get the information late and secondhand.

What this looked like in practice

Tex's Technical Services is the clearest example on this site. Industrial services companies run on spreadsheets, whiteboards, and paper tickets. The schedule lives in one place, equipment history in another, and certification expirations usually live in somebody's memory until the day a crew shows up out of compliance.

What replaced it was one console: jobs, dispatch, crews, equipment, time entries, certifications, and inspections, with role-based access so the field and the office each see what they should. The part that matters is not the dashboard. It is that an expiring certification now surfaces before a crew is dispatched instead of on the day somebody is turned away from a site.

The kitchen app is the small version of the same idea: two people, two phones, shared state that has to stay in sync without anyone managing it. Same problem, different scale.

What it costs

Custom applications and dashboards start at $9,500. Mobile applications start at $7,500. Both assume a tightly scoped first version, and both are always quoted after discovery rather than from a price list, because scoping is the whole job.

Hosting and ongoing support are a separate monthly agreement rather than baked in, so continuing with me stays a choice you keep making.

Enterprise integrations with existing ERP or accounting systems are scoped separately. Data migration from a legacy system is quoted by volume and condition, and "condition" is doing a lot of work in that sentence. Migrating fifteen years of inconsistent spreadsheet data is frequently a larger job than building the thing it is going into.

How to not waste that money

Automate the process you have, not the one you wish you had. The most expensive projects I have seen are ones where a business decided to redesign how it operates and build software for the new version simultaneously. Pick one. Build for what people actually do, then improve it once it is running.

Scope version one brutally. The instinct is to list everything. The result is a project that takes a year and gets abandoned. What you want is the smallest thing that removes the worst pain, in people's hands quickly, then extended based on what they actually complain about.

Check whether something off the shelf does it. I will tell you if it does. There is an enormous amount of good software available for a monthly fee, and custom is only worth it when your operation genuinely does something the shelf fights you on. If you are stacking four subscriptions and three workarounds to approximate one workflow, that is when custom starts paying.

Work out what the spreadsheet actually costs. Hours spent rebuilding reports, the cost of one compliance miss, the delay between something happening and anyone knowing. Sometimes that number makes the decision obvious in either direction. Do the arithmetic before you decide.

What to have ready

If you decide to have the conversation, three things make it dramatically more useful.

A copy of the spreadsheet, however embarrassing. Genuinely. The mess is the requirements document, and the workarounds people have invented tell me more than any description would.

A list of who touches it and what each person needs to see. Role-based access is usually the first real design decision, and it is much easier when you already know the roles.

One sentence on what would make it worth the money. "Stop rebuilding the Monday report." "Know which certifications expire next month." "Let the field update jobs from a phone." A clear answer makes scoping honest, and it is the thing you measure the result against afterward.

The short version

Spreadsheets are not the enemy. They are free, flexible, and universally understood, and plenty of businesses should stay on them indefinitely.

But there is a point where the spreadsheet stops being a tool and becomes a liability held together by one person's memory. The five signs above are how you notice you have passed it.

If you think you might have, the apps and dashboards page covers how that work runs, and everything is priced on the pricing page. If you describe your situation and off-the-shelf software would solve it, I will say so.