← Back to Field Notes

July 28, 2025 · The Bloomfield Team

9 Spreadsheets Every Manufacturer Keeps (And Shouldn't)

Spreadsheets are the unofficial operating system of American manufacturing. Every shop has them. The ERP handles transactions. The spreadsheets handle everything else: the workarounds, the trackers, the reference data, the scheduling overrides, the pricing notes that do not fit into any system field.

The problem is not that spreadsheets exist. The problem is that they contain critical operational data maintained by one person, stored on one machine, with no version control, no access control, and no backup strategy beyond the IT department's general file server policy. Here are the nine you almost certainly have.

1. The Quoting Spreadsheet

Your estimator builds quotes in Excel. Material calculations, cycle time estimates, overhead rates, margin targets, customer-specific pricing adjustments. This spreadsheet is the most financially important document in your operation and it lives on one person's laptop. If the formulas break, if a cell reference shifts, if someone accidentally overwrites a rate table, the next 10 quotes go out with incorrect pricing.

2. The Material Pricing Tracker

Your purchasing manager maintains a spreadsheet of current material prices from your top suppliers. Updated weekly, sometimes monthly, sometimes whenever they remember. The ERP's material pricing data was accurate at some point during the last system migration. It has not been updated since. This spreadsheet is the only source of current pricing in the building.

3. The Shadow Schedule

Your production planner or shop foreman keeps a scheduling spreadsheet that operates alongside the ERP schedule. The ERP says Machine 4 is available Tuesday. The spreadsheet says Machine 4 is down for preventive maintenance Tuesday morning and running a rush job Tuesday afternoon. The spreadsheet is right. The ERP is wrong. Everyone knows which one to trust. For a deeper look at this problem, see our guide to production visibility in manufacturing.

4. The Customer Requirements Log

Your quality manager maintains a spreadsheet of customer-specific inspection and documentation requirements that go beyond what the drawing specifies. Customer A requires certs with every shipment in a specific format. Customer B wants photos of the parts before shipping. Customer C has a surface finish requirement that they communicate verbally and never put on the print. This spreadsheet is the difference between a clean shipment and a rejected order.

5. The Vendor Scorecard

Someone, usually in purchasing, tracks vendor performance in a spreadsheet. On-time delivery rates. Quality issues. Pricing trends. Lead time reliability. The ERP captures PO data but does not score vendors against each other or flag when a supplier's lead times have drifted from their quoted standards. The spreadsheet fills that gap.

6. The Quote Tracking Log

Your sales team or estimating department tracks outstanding quotes in a spreadsheet. Which RFQs are open, when they were sent, which ones need follow-up, which ones were won or lost. The ERP might have a quoting module. If it does, it probably does not capture win/loss reasons, competitor intelligence, or the informal notes about customer conversations that determine pricing strategy.

7. The Tooling and Fixture Reference

A machinist or programming lead maintains a spreadsheet of tooling and fixture assignments. Which fixtures are dedicated to which parts. Which tool numbers correspond to which inserts. Which holders have been modified and cannot be returned to standard. The tool crib has its own system, but the operational knowledge about what tools work best for which applications lives in this spreadsheet.

8. The OTD Tracker

On-time delivery is tracked in a spreadsheet because the ERP's delivery tracking either uses the wrong date fields, counts rescheduled dates as the original promise, or does not account for partial shipments correctly. Someone manually reconciles shipment dates against customer PO dates to produce the real OTD number. The spreadsheet version rarely matches the ERP version. The spreadsheet is closer to the truth.

9. The Training Matrix

Your HR or quality department maintains a spreadsheet showing which operators are certified on which machines, which training has been completed, and which certifications are expiring. This spreadsheet determines who can be assigned to which jobs. If it is out of date, an uncertified operator gets assigned to a job that requires certification, and the parts are rejected at final inspection.

The Pattern

Each of these nine spreadsheets exists because a system gap forced someone to build a workaround. The person who built it is the person who maintains it. If they leave, the spreadsheet either dies with them or gets inherited by someone who does not fully understand its logic, formulas, or update cadence.

The combined data in these nine spreadsheets, material pricing, customer requirements, scheduling reality, vendor performance, quoting history, tooling knowledge, delivery tracking, training records, represents the operational intelligence layer of your business. It is the layer between the ERP's transactional data and the decisions your team makes every day. And it sits in files that crash, get overwritten, fall out of date, and walk out the door when people leave.

The goal is to move that intelligence into a system that maintains itself, connects to the data sources that feed it, and makes the information available to everyone who needs it, at the moment they need it, without depending on one person remembering to update a file every Monday morning.

That system exists now. Building it starts with identifying which of these nine spreadsheets carry the highest risk and the highest value in your specific operation. For most shops, the answer is the quoting spreadsheet, the shadow schedule, and the customer requirements log. Those three, connected and structured, change how your front office and shop floor operate together.