Digital transition · 7 min read · 2026-04-20

Why Excel is not enough for FMG scheduling.

An average 30-user FMG spends about 30 hours a month on its schedule in Excel, close to $15,800 CAD a year in hidden costs. Excel served faithfully, but in 2026, with Law 25 and growing team complexity, its limits turn into real risks. Here is the detailed math, the 5 structural problems, and the right moment to switch.

By Félix DeBlois-Beaucage

Co-founder · development

At a glance

An average 30-user FMG spends about 30 hours of management time per month in Excel, or $10,800 CAD a year in planning time.
The 5 structural problems: no optimization, fragile to errors, knowledge silo, no calculated fairness, no decision trail.
A dedicated tool brings planning down to about one hour a month. Observed net gain: about $6,840 CAD and 29 hours a month.
The typical triggers for switching: FMG growth, the manager leaving, or a fairness conflict.

Why it is worse in an FMG than elsewhere

Excel serves a team where everyone does the same job at the same hours perfectly well. An FMG is not that team. It has to cover at least 68 hours of service a week spread over seven days, weight on-call shifts whose value changes with when they fall, and seat more professionals than it has offices. The five problems below exist anywhere scheduling happens in a spreadsheet. An FMG's complexity amplifies them.

The 5 Excel problems in an FMG

1. No automatic optimization

A typical FMG manages 30 physicians, 50 slots per week, 12 constraints per physician. The number of possible combinations exceeds manual calculation capacity. Excel forces you into "good enough", which generates conflicts and unfairness.

2. Fragile to errors

A mis-pasted cell, a broken formula, a forgotten filter, and the whole schedule is wrong. Errors get caught when a physician shows up and realizes they're supposed to be in two offices at once.

3. Knowledge silo

Every FMG we interview has the same problem: "The master Excel file, only the manager can edit it. If she's sick, we improvise." A tool essential to the FMG's survival should not depend on one person.

4. No calculated fairness

"Everyone has 5 on-calls" isn't enough. A Friday evening on-call is worth more than a Wednesday morning one. Excel doesn't weight. Fairness arguments are endless because they lack numbers.

5. No decision trail

When a physician says "you promised me Wednesday off", you have no record. Excel has no log, no structured comments, no reliable version history.

The ROI calculation of a switch

Excel's hidden cost: average FMG scenario (30 users)

Manager time on planning: about 7.5 h/week × 4 weeks = 30 h/month.
Loaded hourly cost: ~$30/h (salary + benefits).
Monthly cost of planning time lost: $900/month, or $10,800/year.
Cost of scheduling errors (fix time, frustrated physicians, rescheduled appointments): conservatively $5,000/year.

Conservative total: $15,800/year in hidden costs.

Cost of a dedicated tool: Synchro

Subscription: $10 × 30 users = $300/month = $3,600/year.
Manager time: about 1 h/month = $30/month loaded.
Total: $330/month = $3,960/year.

Net gain

$10,800 − $3,960 = ~$6,840 of productivity recovered per year, before even counting the errors avoided. That's 29 hours a month given back to management, the figure observed in our pilot FMG. Plus the manager's peace of mind: they can finally take vacation.

And that calculation counts the manager alone. Each physician went from more than 12 hours a year to about ten minutes to enter their schedule.

The right moment to switch

The FMGs we work with switched from Excel in one of these situations:

The manager threatened to resign (and nobody understood her file).
The FMG grew (new physician, new site) and Excel broke.
A team conflict erupted over fairness and numbers were needed to prove it.
The manager went on vacation and the FMG was paralyzed.

What to look for in the replacement

Smart automatic assignment (not just a shared calendar).
Shared-office assignment (problem ignored by U.S. and generic tools).
Quebec French interface.
Baseline security (encryption, logging, backups).
Transparent pricing: if you have to negotiate to learn the price, walk away.
No-commitment trial.

Conclusion

Excel isn't bad, it's simply obsolete for the complexity of a 2026 FMG. The switch to a dedicated tool is no longer a luxury; it's an operational imperative.