Skip to content

Replace your Excel-based planning

Excel planning looks free, yet you pay for it every week. A model builds the plan from your rules, and you check it.

  • Free 30-minute call
  • No commitment
  • You own the code
Common starting point
Most teams we talk to started here
First step
A free 30-minute call
Our answer
If new software isn’t the fix, we’ll say so

In short: Replacing Excel planning means you no longer build schedules by hand in spreadsheets. An optimisation model builds each plan from your rules and checks every rule before release. The model builds the plan from your rules and checks every rule before release. You review the result.

What the problem looks like.

You rebuild the same schedule in Excel every week. Your planning outgrew the spreadsheet a while ago. You pay for it in hours, in errors and in the risk that planning stops when one person is away.

A week in the planning spreadsheet

On Monday morning, next week’s plan is due. You open last week’s file, save a copy called “v7 final” and start again. You check the shift rules from memory and patch a broken formula along the way. By Wednesday the plan works. Nobody can say whether a better plan existed. And nobody knows which errors are still in it.

Signs your planning is too complex for Excel

Every what-if question means rebuilding the plan, so people have stopped asking. Two colleagues keep two versions of the file, and neither is sure which one counts. The rules live in one person’s head, and nothing checks them. When that person is off sick, planning stops. None of this is your fault. A spreadsheet stores numbers and runs formulas, and nothing in it checks a plan or looks for a better one.

What each problem costs you

  • Formula errors spread silently through the plan.

    You act on wrong numbers and find out only after they’ve cost you money.

  • Every what-if question means rebuilding the whole plan.

    You stop testing options and settle for the first plan that works.

  • Shared files drift into version chaos.

    Two people plan with two different versions of the file. Comparing the two versions takes hours.

  • One person holds the whole process together.

    When that person is ill or leaves, planning stops.

  • No rule is ever checked automatically.

    Plans that can’t be carried out reach your teams. Overtime, penalties and last-minute fixes follow.

What changes

Today, you spend two days building next week’s plan, cell by cell. Our model proposes the plan from your rules, and you review it. A what-if question takes one more run, and nobody rebuilds the file. When you’re off sick, a colleague runs the model, because your rules are stored in it.

Every rule is checked before the plan goes out, so impossible plans don’t reach your teams. Everyone works from one model, which ends the version chaos. And you can test options again: another shift pattern, one more vehicle, a new customer. You spend the saved hours on decisions that need a person.

The model is a program that searches for the best plan that keeps your rules. We write those rules into the model: rest times between shifts, vehicle capacities, certifications and shift patterns. You check every plan, adjust it and sign it off.

Why Excel Solver can’t handle your plan

Excel comes with an add-in called Solver. An add-in is a small extra program. Solver searches for the best values for a few cells. Its maker documents a hard limit: Solver may change 200 cells at most. These cells are called decision variables. If your plan needs more, you have two options. You fill in some cells yourself, so Solver no longer decides them. Or you buy the paid upgrade.

Take a small team. Fifteen people, seven days and three shifts make 315 yes-or-no choices: does this person work this shift? That’s past the limit before you’ve written a single rule. A rota with skills, rest times and holidays needs far more, and that’s ordinary work for a planning model.

Start with a free call

How a project runs.

Each of the three phases ends with something you can check before we go any further.

  1. Understand

    We start with your operation. What do you plan, where does it go wrong, and what would a better week look like? Then we tell you straight whether optimisation can help, and sometimes the answer is no.

    • A written assessment
    • A clear go or no-go
  2. Model

    We write your decisions, goals and rules into a mathematical model, which is just a precise description of how your operation works. Then we run it on your own data. You see side by side what each plan costs and what it delivers, and pick the one that fits your priorities.

    • A documented model
    • Results on your own data
  3. Implement

    We test with your data and go through the results with your team. Once they trust it, we connect the model to your systems, so it runs every day without anyone stepping in by hand.

    • Source code and documentation
    • Training for your team

What people ask first.

Something else? Ask us directly.

For a small problem, yes. The standard Excel Solver handles at most 200 decision variables, the cells it may change, according to its maker. Fifteen people over seven days and three shifts already need 315 yes-or-no choices. Past that point you hold cells fixed by hand, buy a bigger solver, or move the planning into a proper model.

Watch what happens when something changes. If a sick day or a new order means hours of rework, the spreadsheet can’t handle your planning any more. Other signs are a second version of the file and nobody asking what-if questions any more. If a plan takes an hour and anyone on the team can check it, keep Excel.

No, and we wouldn’t push you to. Many teams keep Excel for what it does well: entering data, sharing a plan, quick reports. The model reads the same sheets, builds the plan and writes it back. What leaves the spreadsheet is the planning itself, the part where rules get checked and options compared.

Complexity is what optimisation is for. Every rule you add makes manual planning harder. For a model, it’s one more rule to keep. The more complex your process, the more work the model takes off your hands.

You keep every decision. The model proposes a plan. You review it, change it and approve it. Nothing goes out without your sign-off.

You don’t switch everything on one day. The model reads your existing spreadsheets. It runs alongside them until you trust the output. Only then do you switch.

Tell us what you’re planning.

In a free 30-minute call with a specialist, you find out whether optimisation can help.

  • Free, no commitment
  • You talk to a specialist directly
  • A clear go or no-go