5 Steps to Turn Your Excel Production Schedule Into a GPS for Your Floor

An Excel schedule is a map: it shows where you want to go, not where you are. Here is how to turn it into a GPS for your floor, without taking Excel away from your planner.

Gamil TadrossFounder · 25+ years as a production supervisor
Published
Updated
7 min
read
A production planner on the phone at a desk with a spreadsheet, looking out at the shop floor
On this page

Key takeaways

  • Keep Excel as the planner's tool. Build the live view on top of the schedule, not instead of it.
  • Give every work order one clean row with the same five things: work order number, part, quantity, due date and machine.
  • Connect the file instead of retyping it, so the floor sees every change the planner saves.
  • Let the floor talk back: every start, finish and stop goes back to the schedule right away.

On almost every floor I have run, the production schedule lived in Excel. The planner builds it, sends it out, and the floor prints it. By noon, that printout is already out of date.

A machine went down at nine. A rush order came in at ten. A job finished early. None of that is on the paper. So the supervisors do what I did for years: walk the floor and ask, "Where is this job? Is that machine running? Will we ship today?"

Here is how I see it now. An Excel schedule is a map. It shows where you want to go, but it cannot tell you where you are. What a production floor really needs is a GPS: one that knows the destination, shows you live where you are on the route, and warns you while there is still time to change it.

Why plants won't pay to replace Excel

I have watched many vendors try to take Excel away from the planner. Almost every time, it failed. And honestly, the plants were right.

The planner trusts Excel. They are fast in it, and they can change the whole week in ten minutes when a customer calls. Then a vendor arrives and asks for thousands of dollars, plus months of work, to show the same schedule on a different screen. Most plants look at that and say no. They cannot see the value of paying that much just for a new way to look at the same list.

I agree with them. A prettier copy of the schedule is still a map. It still cannot tell you where you are.

The value is not in seeing the schedule. The value is in getting to the destination. That is the difference between a map and a GPS:

  • The destination is what must ship, and when.
  • The route is real time production tracking: your production against your schedule, on one page, as it happens.
  • The alerts are the late job and the down machine, shown while you can still change the route.

5 steps to turn your Excel schedule into a GPS

1. Keep Excel as the planner's tool

Do not fight the planner. The schedule stays in Excel, and the planner keeps working the way they always have. The GPS is built on top of the map, not instead of it.

2. Give every work order one clean row

A GPS needs a clear address. For a schedule, that means one row per work order with the same five things every time: the work order number, the part, the quantity, the due date, and the machine. Extra columns are fine. Missing ones are where the trouble starts.

3. Connect the file, don't retype it

The moment someone copies the schedule into another system by hand, you have two schedules, and one of them is wrong. Load the Excel file as it is, or better, let it sync by itself from where it already lives, like Google Drive or SharePoint. When the planner saves a change, the floor sees it.

4. Show the route live on the floor

The schedule should not live in the office. Operators should see their next job on the screen at their station. The whole team should see it on the TV on the floor: what is running, what is next, what is late. That is the moment the map becomes a GPS.

5. Let the floor talk back

A GPS is only as good as its signal. When an operator starts a job, finishes it, or stops because the machine is down, that signal goes back to the schedule right away. Now the planner, the supervisor and the manager all see the same truth, and nobody needs to walk the floor to ask.

Three traps that break the GPS

I have seen each of these send a whole floor in the wrong direction:

  • Many copies of the file. "Schedule final", "schedule final 2", "schedule Monday NEW". When there is more than one schedule, there is no schedule. Pick one file, in one place.
  • Rows that disappear. A planner deletes a finished job to clean up the sheet, and with it goes the history of what happened. The GPS should keep the trip record, even when the planner clears the map.
  • Machine names that don't match. The planner writes "Press 3", the floor calls it "P3", and the system knows it as "Hydraulic Press 03". The job lands nowhere. Agree on one name for every machine, or use a system that tells you which names it does not recognize.

What If Your Schedule Worked Like a GPS?

One of the best moments of my career was watching my team celebrate as they crumpled up the paper schedule we had used on the floor for years. No more handwritten notes in the margins. No more hours lost checking and rechecking what someone wrote. That moment is what DOVAmfg is built for. DOVAmfg is a Full Floor Management System, or FFMS: one system that runs your whole production floor, instead of a separate tool for every job. It has three parts: the schedule, real time production tracking, and the maintenance and compliance hub. And the schedule is where it all starts.

That is the core of it. In DOVAmfg, you see your production against your schedule, on the same page, updated in real time. Whatever happens on the floor, a job started, a machine stopped, a part rejected, DOVAmfg shows it on your screen or on your phone, wherever you are. You don't walk the floor to find out where you are. The GPS tells you.

By now, you are probably asking the same question every plant manager asks me at this point: a system that does all of this must cost a fortune. Can we even afford it?

Here is the honest answer. DOVAmfg has one flat price per location, with every feature included: $240 a month for up to 12 machines. Operators and office users are free, as many as you need. There is no setup fee, and every plan starts with a 30 day free trial. Right now, our first five Founding Partners also get 50% off for their first 24 months.

Then think about what one late order costs you, or one machine that sat stopped for an hour before anyone noticed. That is the real comparison.

Here is what that means for your Excel schedule:

  • Your planner keeps Excel. DOVAmfg reads the file as it is, remembers your columns, and can sync it from Google Drive or SharePoint.
  • DOVAmfg never deletes your rows. Finished jobs keep their history, and rows typed by hand in DOVAmfg are protected from the next import.
  • If the file names a machine DOVAmfg does not know, it tells you, so no job lands nowhere.
  • Operators see their next job at their station, and the floor TV shows the whole route live.
  • Every start, finish and stop goes back to the schedule right away, so late jobs and down machines show up while you can still act.

And because there is nothing big to pay up front, nobody is locked in by money already spent. You stay with DOVAmfg only if it gets your floor to the destination.

So here is my invitation: book a 30 minute demo with me. Bring your own Excel schedule, and I will show you your floor's GPS.

Written by Gamil Tadross, production supervisor for 25+ years.

Gamil Tadross

Founder of DOVAmfg. 25+ years as a production supervisor, 8 of them in aerospace.

Keep reading

See your own floor on DOVAmfgBook a 30 min demo