Spreadsheet-to-System Planning for Metals Manufacturers
- Ruth Kearney
- Blog , Learning
- March 6, 2026
- Updated:
Table of Contents
Your production planning spreadsheet is not a system. It is a liability.
Every time two people open it simultaneously, someone is looking at stale data. Every time someone leaves the business, a chunk of institutional knowledge walks out the door with their colour-coded tabs. Every time a job changes — and jobs always change — someone is manually updating rows that should be updating themselves.
Metals manufacturers have been running production on spreadsheets for decades. Not because spreadsheets are good at this. Because nothing better existed that was not also outrageously expensive and impossible to implement without a six-month project.
GoSmarter exists because that is no longer true.
What “Spreadsheet-Based Planning” Actually Costs You
The direct costs are obvious: the hours your production manager spends every week maintaining the spreadsheet instead of managing production.
The hidden costs are worse.
Version conflicts and stale data
When your cut list lives in a spreadsheet, everyone working from it is potentially working from a different version. The most recently saved version wins. The person who saved it last might not be the person who knew the most current state of the job.
In metals manufacturing, this means:
- Wrong cuts — the wrong lengths go to the saw because someone was working from yesterday’s version
- Stock discrepancies — inventory counts are wrong because the spreadsheet was not updated when material moved
- Missed jobs — orders get forgotten because they were added to the sheet after it was exported and handed to the floor
The key-person dependency
Every manufacturing business has one. The person who built the spreadsheet, knows all the formulas, and is the only one who can fix it when it breaks. When that person is ill, on holiday, or leaves, planning grinds to a halt.
The compliance gap
When production data lives in a spreadsheet, there is no audit trail. Who made that change? When? Why? If a quality issue arises and you need to trace what material went into which job on which day, a spreadsheet gives you nothing. You are left reconstructing the sequence of events from memory, delivery notes, and luck.
The scaling ceiling
Spreadsheet-based planning works — just about — when you are running 20 jobs a week. At 50 jobs, it starts to crack. At 100, it collapses. Adding people to manage the spreadsheet is not a solution; it is more hands on a problem that should not exist.
What GoSmarter Replaces Your Spreadsheet With
GoSmarter is not a general-purpose project management tool wearing a metals costume. It was built specifically for the production workflows that happen in steel service centres, rebar manufacturers, and metals fabricators.
Live cutting plans instead of static cut lists
GoSmarter’s Cutting Optimiser generates cutting plans dynamically, based on your live orders and your actual inventory. When an order changes, the plan updates. When stock comes in, the available lengths update. The plan you hand to the floor is always the current plan — not the plan from this morning before the job was revised.
In real-world trials at Midland Steel, the Cutting Optimiser reduced scrap rates by 50%. That is not a planning efficiency gain. That is a direct materials cost reduction.
Inventory linked to orders, in real time
GoSmarter’s Inventory Management replaces the stock tab in your spreadsheet with a live system that knows:
- What you have and where it is
- What it is certified to (linked to the mill certificate from when it arrived)
- What is already allocated to an open order
- What is available to allocate to a new order
When a salesperson asks “can we deliver 10 tonnes of S355J2 next Tuesday?”, the answer comes from live data — not from calling the warehouse and hoping the spreadsheet is up to date.
Order and job tracking that does not require a dedicated admin
In a spreadsheet world, someone has to maintain the master job list. In GoSmarter, orders are tracked as they move through production. Jobs progress through stages. The system knows what is planned, what is in progress, and what is complete — without anyone updating a row manually.
The Common Scenario: What Moving Off Spreadsheets Looks Like
Before GoSmarter
A production manager arrives each morning and opens the master spreadsheet. They check the job list, cross-reference with the stock sheet, manually calculate what lengths need to be cut, and write a cut list on paper or in a separate document to hand to the floor.
This takes one to two hours every morning — assuming nothing has changed overnight and the spreadsheet is clean.
When something changes (it always does), they update the spreadsheet, recalculate, and reissue the cut list. This happens two or three times a day.
At end of day, they update stock quantities based on what was consumed. This relies on someone on the floor writing down what they used.
At month end, they reconcile the spreadsheet stock against a physical count and find discrepancies. They investigate. They usually cannot find the source of the error. They write off the difference.
After GoSmarter
The production manager opens GoSmarter. The system shows live orders with their required lengths and grades. The Cutting Optimiser generates a cut plan in minutes. They review it, make any overrides they want, and export to PDF for the floor.
When something changes, they update the order in GoSmarter and replanning takes seconds.
Stock updates happen as material is allocated to jobs and consumed. The system maintains the current picture without manual updates.
Month-end reconciliation is a report, not a days-long investigation.
Specific Workflows GoSmarter Handles
Cut list generation for long products
For rebar, sections, beams, tube, pipe, and bar stock, GoSmarter generates optimised cut lists that minimise offcut waste. The algorithm considers:
- All open orders and their required lengths and quantities
- Available stock lengths (from your live inventory)
- Material grades and specifications (matched to cert data)
- Any existing production constraints (minimum offcut lengths, reserved stock, priority allocations, or machine-specific length limits)
The result is a cut plan that tells you exactly which bars to use, in what order, to produce what is needed with the minimum waste.
Goods-in and certificate processing
When material arrives, GoSmarter handles the goods-in process alongside the certificate processing. You record the delivery, upload the mill certificates (the AI reads them automatically via MillCert Reader), and the stock and cert data are linked from day one. No separate filing. No separate data entry.
Despatch and certificate-with-delivery
When you despatch an order, GoSmarter identifies which material is going and makes the relevant certificates available for the delivery documentation. Your customer gets the right cert with the right delivery — automatically.
Reporting without the pivot table
GoSmarter surfaces the information you actually need without requiring you to build a pivot table every time you want to see it:
- Live stock by grade, size, and specification
- Open orders by due date and status
- Scrap generated vs. target
- Certificates received vs. pending
Is GoSmarter for My Size of Business?
GoSmarter is specifically designed for metals businesses that:
- Operate without an IT department
- Cannot afford a six-month ERP implementation
- Need something that works for their team as it is, not as it might be after retraining
- Are running 10 to 500 jobs per week
If you are a very large enterprise with a full IT team, a bespoke MES, and months to spend on a rollout, GoSmarter is probably not your answer. But if you are a service centre, a rebar manufacturer, a stockholder, or a fabricator with a production team that spends too much time fighting spreadsheets, GoSmarter is built for you.
How Long Does It Take to Move Off Spreadsheets?
Most customers are using GoSmarter within a week of signing up. There is no implementation project. No data migration consultant. No weeks of training.
The practical sequence:
- Day 1 — sign up, upload your first batch of mill certificates, let GoSmarter read them
- Day 2 — upload your current stock list (a spreadsheet is fine as a starting point)
- Day 3 — enter or import your open orders
- Day 4 — run your first cut plan from GoSmarter instead of building it manually
- Week 2 — your production team is using the system as their primary source of truth
Your spreadsheet does not disappear immediately. Most customers run both in parallel for the first two weeks, cross-checking that GoSmarter is reflecting reality correctly. After that, the spreadsheet usually stops getting updated.
Frequently Asked Questions
Do we need to import all our historical data to get started?
What happens to our existing spreadsheets?
How many people can use GoSmarter at once?
Does GoSmarter integrate with our ERP?
What if our cutting requirements change mid-job?
We already have an MES. Do we still need GoSmarter?
Is the data secure?
Related Resources
- Production Planning Solutions — GoSmarter’s production planning and cutting optimisation capabilities
- Operations Management Solutions — streamlining workflows across production, quality, and logistics
- GoSmarter for Metals Operations — the full toolkit overview
- No-Code Workflows for Metals SMEs — how GoSmarter works without IT involvement
- Scrap, Waste & Yield Optimisation — how the Cutting Optimiser reduces material waste
- Mill Certificate Automation — automating the cert side of your goods-in process
- Midland Steel Manufacturing Case Study — from spreadsheet planning to live connected systems
- Cutting Optimiser product page — features, pricing, and free trial
- Inventory Management product page — live stock tracking with certificate traceability
- Complete Guide to Streamlining Metal Fabrication Operations — broader workflow optimisation for fabricators
GoSmarter is made by Nightingale HQ, a UK-based AI company building practical tools for metals manufacturers since 2018.
