The macro one guy built in Excel now runs your scale house, and only he can fix it
Replacing the spreadsheets and disconnected tools that hold your yard together with proper internal software runs $30,000 to $90,000 over 2 to 5 months. Retool and Airtable get you a fast prototype, but a feedlot scale-house tool that has to reconcile loads, weights, and pen moves under real conditions usually outgrows them within a year.
Somewhere in your operation, a single Excel workbook with a tangle of macros is the system of record for the scale house, and exactly one person understands it. When he is sick, intake slows. When he leaves, you are terrified. Around it sit a half-dozen Airtable bases and shared sheets that the office, the yard, and the trucking desk each maintain separately, and none of them agree.
These tools were never designed, they accreted. They have no audit trail, no validation, and no way to stop a load from being entered twice. For a Panhandle operation moving thousands of head a week, that fragility is a daily operational risk, not a someday problem.
The problems nobody warns you about
- One person owns the scale-house spreadsheet and the whole yard stalls when he is out
- Office, yard, and trucking each keep their own sheet, and the numbers never match
- No validation means a 14,200 lb load gets typed as 142,000 and nobody catches it until settlement
- Retool or Airtable stopgaps hit row limits and break when two people edit at once
The case for owning your internal tools
The work these tools do is core to your operation, which is exactly the work you should not run on a fragile spreadsheet. A custom internal tool puts validation, audit trails, roles, and reliability around the scale house and yard so the knowledge lives in software, not one person's head. It is the cheapest high-impact build most Amarillo operations can make.
Budgeting a internal tools build in Amarillo
| Project scope | Typical cost | Timeline |
|---|---|---|
| Single critical tool (e.g. scale house) | $30k to $50k | 2 to 3 months |
| Connected suite of yard and office tools | $50k to $90k | 3 to 5 months |
| Tools plus ERP and inventory integration | $80k+ | 4 to 6 months |
What your build should include
What we build under internal tools in Amarillo
Everything a internal tools build here can cover:
Exactly what you get
The fragile scale-house workbook becomes a real application with validation, roles, and an audit trail, and the conflicting departmental sheets collapse into one source of truth. It feeds your ERP software and inventory management software directly, so the load entered at the chute is the load the office and accounting see, no re-typing.
How to choose a developer in Amarillo
Find a team that treats internal tools as serious software, not a quick Retool screen. They should interview the person who owns the spreadsheet, document the hidden rules, and build in validation and audit from the start. The goal is a tool that survives that person leaving.
- !They want to rebuild the spreadsheet one-for-one; ask which broken rules they will fix
- !No validation plan; ask how they stop a duplicate or impossible entry
- !No audit trail; ask how you trace who changed a number
- !They assume perfect connectivity; ask about weak signal in the yard
- !No integration to your ERP; ask how the data avoids re-export
Most Amarillo teams pricing internal tools end up comparing notes on custom software, wordpress, accounting too; the systems share one data spine.
Rohan advises mid-market and enterprise teams on ERP, CRM and custom software, and has led delivery on dozens of business-software builds.
Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.
Frequently asked questions
Why not just keep using Airtable or Retool?
They are great for prototypes, but a financially load-bearing tool that thousands of head pass through needs validation, audit, and concurrency those platforms strain to provide once you scale.
Is this worth it for one spreadsheet?
If that spreadsheet runs your scale house and only one person understands it, yes. The risk it removes usually justifies the build on its own.
How do we capture the rules in the old sheet?
A discovery phase reverse-engineers the macros and interviews the owner so the undocumented logic is written down and rebuilt deliberately, fixing the broken parts.