Operations

Why MRO Shops Still Use Spreadsheets (And What It Costs)

Ops Log

After two decades of MRO software investment, a 28-aircraft regional operator can still have its planning coordinator rebuild the weekly schedule in Excel every Monday morning. AMOS, Ramco, Trax, and other platforms offer deep functions for work orders, inventory, compliance tracking, and finance. The spreadsheet persists not simply from inertia. Calling it change resistance misses the operational problem.

Why enterprise platforms missed small operators

Large maintenance organizations adopted the leading MRO platforms, including airline maintenance divisions and major independent MRO facilities. Their features reflect that history. A full AMOS implementation handles work orders, component tracking, financial integration, procurement, quality assurance, and regulatory reporting across multiple bases and hundreds of aircraft. Proper implementation takes 6 to 18 months, with dedicated IT support for setup and continuing administration.

For an operator with 25 aircraft and a three-person planning team, that timeline does not fit operational reality. A full enterprise MRO platform often costs well above $50,000 annually before implementation services, making the price hard to defend against fleet value. These systems were not made for this segment, and neither were their pricing or implementation models. The segment went without.

Excel filled the gap. It is already licensed, familiar to the planning coordinator, and adaptable to the operator's needs without vendor help. When the data for a 25-aircraft fleet fits in a few hundred rows, a well-built spreadsheet handles core scheduling adequately.

What spreadsheet-based maintenance planning looks like

A typical spreadsheet setup uses several linked files: a master sheet listing each aircraft, current hours and cycles, and upcoming task due dates; a monthly schedule rebuilt or edited each week; a parts sheet for open purchase orders and expected delivery dates; and sometimes a separate AD file maintained by the compliance officer.

These files do the job. Experienced planners know what to update after each flight day, where to check upcoming due dates, and how to turn the master data into a weekly schedule. The system works because the user knows the fleet well enough to spot errors and anomalies the spreadsheet cannot flag.

That last point is the weakness. The person, not the tool, makes the system work.

Where the costs appear

Spreadsheet planning costs are real, but spread across activities rather than one visible line item. The clearest cost is planner time. Rebuilding the monthly schedule, checking interval dates against projected utilization, and confirming AD compliance windows are safe typically takes a senior planner two to three full days each month. Cutting that work to a few review hours saves several weeks of staff time per year, which matters at planning coordinator salary levels.

The second cost is error rate. Spreadsheet formulas will not flag an interval changed by an engineering order amendment, or an AD due date that needs recalculation after utilization exceeds projections. The planner must catch and revise these manually. Unexpected utilization spikes and busy periods make missed updates more likely. A check intended for six weeks out may be scheduled four weeks out after a late recalculation, causing an unnecessarily early visit or a last-minute search for hangar time.

The third cost is coordination overhead. If the schedule sits in one person's spreadsheet, everyone else must request the information. Flight operations needs aircraft unavailability dates, procurement needs parts and timing, and engineering needs approaching AD compliance windows. Email and manual exports handle these requests. The planner spends time providing information a shared planning system would supply automatically.

Spreadsheets are not the villain

We are not saying spreadsheets are always wrong for maintenance planning. For a small charter operator flying eight aircraft on a stable schedule with a mature maintenance program, a well-designed file managed by someone familiar with the fleet can be reasonable. The constraint volume stays manageable, exceptions are infrequent, and coordination remains light enough for a shared file.

The issue is not the tool alone, but the tool at a given scale. Past 15-20 aircraft, with irregular utilization, a dense AD compliance calendar, and several people needing current schedule data at once, a spreadsheet begins creating the costs above often enough to warrant alternatives.

What the right tool should look like

Tools for small and mid-size operators need a different profile from enterprise platforms. Implementation should take days or weeks, not months. Pricing should be transparent and tied to fleet size, rather than seat licenses or enterprise agreements. Imports should accept the operator's existing format. Asking a 28-aircraft regional to change its records systems for a planning tool solves the wrong problem. Outputs should give the planning coordinator a usable schedule that maintenance can read and flight operations can use.

This is the segment Tailsight serves. We are not trying to replace enterprise MRO platforms in large operations. We built a purpose-made option for operators planning in Excel, sized to their operation and useful without an 18-month implementation.