Contents
At 6 a.m., a shift lead opens the workbook that sets the order of work. Red rows mark urgent jobs. The lead moves two on the list because a machine is down. An hour later, sales opens a copy to give customers delivery dates. Replacing the workbook starts with learning what people do between those updates.
Watch a day with the people who maintain the workbook
Ask the lead to show how they prepare the workday, change a priority and hand over to the next shift. Identify what people type, what comes from a formula and who can correct a record. Colours, comments or hidden columns may represent rules nobody has documented.
Talk to someone who reads the workbook without editing it as well. They can explain which figures they need and when. The first version can retain a familiar view while controlling status changes. If the ERP already holds sales and production orders, use the workbook to find information added on the shop floor and decide where it belongs.
Test imports with a sample that includes awkward records
Work from a copy and choose some open orders, historical rows and entries that disagree. Have the team approve how each workbook column maps to the new fields. Establish how a row links to the right order. A repeated reference may represent two separate operations.
On the first import, check quantities, dates, states and duplicate records. If rows were rejected, someone should be able to trace them back to the source and fix the issue. Import the same sample again to verify that a retry does not create additional records. Unresolved exceptions should remain visible until someone acts on them.
Rehearse the change on a small part of the shop floor
Pick a workstation, one order family or a shift for the pilot. For a short period, keep one scheduling source authoritative and use the second view to compare results. Record discrepancies at handover. When a date or quantity changes in only one view, the person in charge should be able to explain the difference and locate the correction.
TableChecks for an Excel production workbook cutover · shareable block
| What the shop verifies | Decision when a check fails | |
|---|---|---|
| Before import | Open jobs and their identifiers agree. | Review the mapping before importing the batch. |
| On the second import | No additional records are created. | Fix the identifier rule and retry with the test copy. |
| During the pilot | A priority change appears in the authoritative view. | Assign and resolve the discrepancy before expanding the pilot. |
| First shift after cutover | The shift lead can locate every job in progress. | Use the agreed fallback if open jobs are still missing. |
Before cutover, agree on the time, who makes the decision and who verifies the first shift. Keep a dated copy of the data. Identify the condition that would stop the switch, such as missing open orders or a failure to resume data entry. If you return to the spreadsheet, record changes made in the new tool so the next shift starts from accurate figures.
Scope the build around work you observed
Time the beginning of a shift and a few order changes. Count the copies in circulation and the discrepancies that need fixing. This shows which features are due on day one and which can follow later.
A production process map can help identify the decisions and information that leave the workbook during handover.
Daillac can review an anonymized workbook, document the rules it contains and help prepare a cutover plan. A first conversation can focus on a single file and the two or three things your shop needs to do with it every day.
Frequently asked questions
Do we have to migrate all the history?+
Separate active jobs, records needed for reconciliation and occasional historical lookups. A read-only archive may meet the team’s needs.
How can we find rules hidden in Excel?+
Ask the people who maintain the workbook to demonstrate a normal day and an urgent change. Record the steps, formulas, colours and copies they rely on.
Which source should people use during the pilot?+
Designate one source for production decisions. Use the second view to compare results and record differences at handover.
When can the team leave the workbook?+
When a shift can take over, handle the agreed cases and find open orders without urgent corrections. Confirm that a fallback is available during cutover.
Review my production workbook
D
Written by
Daillac

