LineSight vs Spreadsheets: When Does an Experienced Scheduler Need Planning Software?

What the spreadsheet and the scheduler do well

A spreadsheet asks nothing of the operation: no integration project, no license, no meeting with IT. When a customer changes a width at three in the afternoon, the scheduler changes a cell. When the older slitter needs a different trim on heavy gauge, the sheet already has a column for it, because the scheduler built it.

The scheduler is the bigger asset. A good one knows which customer will take a coil at the low edge of tolerance because their buyer agreed to it years ago, which due dates are real, and which coils the owner wants gone this quarter. None of that is in the ERP, and it is why, as we wrote in what slitting software means for the planner, the plan a person approves beats the plan any software proposes on its own.

For some shops the spreadsheet is the right answer. Our own buyer's guide says that with one line, one planner and a disciplined spreadsheet habit, it may still be the best use of your attention this year.

What a spreadsheet cannot search

A spreadsheet stores a plan. It does not look for one. The scheduler does the looking, and can compare a handful of coils per order before the shift starts. On a full day's order book the feasible combinations of orders, coils and knife setups run into the millions, and the gap between what gets checked and what exists is where scrap sits. That is arithmetic, not a knock on schedulers.

On one coil, from our guide to reducing slitting scrap: a 60-inch master with a quarter inch trimmed from each side leaves 59.5 usable inches. Four 12.25-inch strips use 49 and leave 10.5 inches in the bin, an 18.3 percent loss once trim is counted. Add a 9.5-inch strip from another order and scrap falls to 2.5 percent. The strip that closes the drop is rarely on the same order, and often not on the same tab.

Three other things slip through a spreadsheet:

• Tolerance. Planning to the nominal gauge or width throws away coils the customer would have taken. A 0.058-inch coil fits a 0.055 to 0.062 order.
• Coil choice. Two coils of the same grade and gauge can differ by several points of yield on the same orders. Opening whichever is nearest the door has a price.
• Continuity. The method leaves with the person. Fast-Square, which sells a coil optimizer, describes cutting-pattern planning as a job usually owned by one very experienced planner in each company, which leaves the business dependent on a single expert.

How LineSight works differently

LineSight connects to the ERP the shop already runs and pulls open orders and coil inventory in real time, so nobody builds a morning export. The planner picks the orders to fill, and LineSight's optimization engine works across the whole order book and inventory at once, respecting gauge, width, grade, PIW, coil weight, knife setups, min and max mults and lead times. What comes back is a complete slitting or cut-to-length plan.

Every plan shows what is cut from which coil and why, and a person approves it before anything goes to the ERP or the floor. When a planner overrides a width or a pattern, later plans respect it, so rules that lived in one head start to collect where the next person can use them.

After approval, work orders, PDF plans and ERP updates go out in one click. LineSight is live with PS Data, INVEX and Enmark. For other systems, LineSight says each customer gets a dedicated integration built during onboarding.

Two ordinary days, planned both ways

A rush order lands at noon

On a spreadsheet, re-planning by hand costs the rest of the shift, so the scheduler usually wedges the order in where it fits. LineSight re-runs the plan against current orders and inventory, and the scheduler decides whether the new scrap and due-date trade is worth it.

The week the scheduler is on vacation

Cover on a spreadsheet means a second person working from the first person's tabs, and plan quality moves with them. With LineSight the standing rules and past overrides are already in the engine, and whoever covers still approves every plan.

What each approach costs

The spreadsheet's software cost is zero. Its real cost is planner hours plus the scrap in the combinations nobody checked. The scrap cost calculator prices that from your tonnage: at 50,000 tons, a 4 percent scrap rate and $1,000 a ton, scrap costs $2,000,000 a year and one point is worth $500,000.

For scale, Elite Steel cut its scrap rate 2.9 points and added about $850K in annualized revenue after going live with LineSight. That is one operation with one product mix, so put your own last 90 days through a pilot before trusting anyone's case study, ours included.

Can you keep the spreadsheet?

Yes, and many planners do for a while. A sensible first month runs both: the scheduler builds the morning plan as usual, LineSight builds one from the same orders and coils, and the scheduler writes down every reason the LineSight plan would not run. Those reasons become overrides. If the next plan does not respect them, that is a fair reason to say no.

The bottom line

A spreadsheet and a good scheduler are a real planning system, and the scheduler's judgment is the part worth keeping. What the spreadsheet cannot do is search. Once the order book is bigger than one person can hold, or the person holding it is planning their retirement, the search is where the money is. LineSight takes the search and the re-keying; the scheduler keeps the decision. For standalone optimizers, see LineSight vs Fast-Square and LineSight vs CoilTrim.