Replacing the shared Excel workbook for resource tracking
Updated on · Capalane
In short. A shared Excel workbook works while one or two people maintain it. Once everyone logs their time in it, it becomes fragile: competing versions, overwritten formulas, capacity recalculated by hand, reminders by email. To move off it, choose a tool that keeps spreadsheet habits, import the history, check totals on a reference data set and switch at the start of a month.
The time tracking workbook almost always starts well: one tab per month, one row per person, formulas that add up. Then the team grows, projects multiply, and the file becomes the weak point of project management.
Signs the workbook has reached its limits
- Copies to merge: everyone fills in their own version and someone consolidates them every week.
- Broken formulas after an inserted row, an overwritten cell or a renamed tab, and wrong totals nobody notices.
- Capacity recalculated by hand: public holidays, leave, part time and assignment changes updated by a single person.
- Reminders by email to collect late entries, without knowing exactly who is missing.
- No history: no way to tell who changed an entry that was already billed, or when.
- Rights that are too broad: anyone who can log time can also see daily rates and edit other people's rows.
Two or three of these signs are enough: the time spent maintaining the file then exceeds the time it saves.
Criteria for choosing a tool
| Criterion | Why it matters |
|---|---|
| Entry as fast as a spreadsheet | Keyboard, copy-paste, instant recalculation: otherwise teams go back to the file. |
| Capacity calculated automatically | Public holidays (France and Tunisia), leave, part time and allocation rates, with no manual upkeep. |
| Remaining time and targeted reminders | Only people whose week is incomplete are reminded. |
| Roles and permissions | Team members log their time; amounts stay with managers. |
| Audit log | Every change is dated and attributed, including after close. |
| Export at any time | Financial control keeps its own analyses. |
| Hosting and GDPR | Personal working-time data: hosting in the European Union and a data processing agreement. |
A five-step switchover
- Inventory the workbook: tabs, lists of resources and projects, activity types, the formulas that really matter (capacity, remaining time, amounts).
- Clean up reference data: one record per person (rate, daily rate, country), one project per code, activity types reduced to the essentials.
- Import the useful history, usually the current year.
- Check on a reference data set: for a few projects and months, the tool's totals must match the workbook's to a tenth of a day. Every gap is explained (wrong formula in the workbook, duplicated row) before going further.
- Switch at the start of a month, after two to three weeks of double entry limited to a pilot project. The workbook then becomes read-only and serves as an archive.
The reference data set check is the step that gives teams and financial control confidence: without it, the slightest difference in a total reopens the "Excel or the tool" debate.
After the switchover
The benefits show from the first month: complete weeks without general reminders, correct capacity without recalculation, a shorter close and reports available without copy-paste. The guides on time tracking and capacity planning detail the calculations to carry over.
Capalane takes over the structure of the time tracking workbook (resources, types, weeks, PIs) and its calculations, checked on a reference data set, with a grid that types like Excel, autosave and a log of every change.
Frequently asked questions
At what team size does an Excel workbook stop being enough?
There is no fixed threshold, but problems often appear between 15 and 30 people or as soon as several projects run in parallel: copies to merge, broken formulas, capacity recalculated by hand. The number of contributors matters more than the number of rows.
Can we keep the workbook's history?
Yes, if its structure is regular: resources, projects, weeks and activity types. The import is validated by comparing, on a reference data set, the workbook's totals with the tool's, project by project and month by month.
How long does a switchover take?
For a team of a few dozen people, two to four weeks: one week of preparation and import, then two to three weeks of double entry limited to a pilot project, before the full switch at the start of a month.
What happens to exports for financial control?
A good tool exports raw time entries at any time (one line per person, project, period and type): financial control keeps its pivot tables, fed with complete, up-to-date data instead of a copied file.
Track your projects and resources in one place
Capalane calculates capacity with public holidays and leave, collects time in a grid that types like Excel and produces reports by project, by PI and by person.
Discover Capalane