Services Case Studies Expertise Insights About Book a call
Case Studies / Project and Budget Planner
Custom Applications

A project planner that accounts for real working days and real costs

The business had tried ClickUp and Monday. Both struggled with their resources and asset structure. They fell back to spreadsheets, but maintaining a macro-heavy file across a team is its own problem. They needed something flexible, accurate, and owned outright.

Service Custom Applications
Replaces ClickUp, Monday, Excel macros
Licensing One-time, unlimited users
Use case Programme and project management
Live demo: animated project planner

Use the Replay and Guided Tour controls inside the planner to see it build live.

The situation

The team managed multiple projects at once and needed to know two things clearly: when will each project actually finish, and are we within budget. Neither question had a reliable answer.

They had tried ClickUp and Monday.com. The problem was not the tools themselves but the fit. Their resource and asset structure did not map cleanly into those platforms. Getting accurate timelines out meant manual workarounds, and the subscription cost was a recurring conversation that was never quite justified.

Spreadsheets filled the gap, but a macro-heavy planner owned by one person is fragile. When that person is not available, or when the file picks up conflicting edits, the numbers stop being trustworthy. And neither macros nor subscription tools knew about bank holidays, company closure days, or the fact that a contractor only works three days a week.

What we built

A no-macro Excel planner built around how the business actually works. Holidays and bank holidays are configured once and the planner uses them throughout. Every timeline and finish date is calculated on real working days, not calendar days, so a task that spans a bank holiday weekend does not pretend that weekend was productive time.

The planner draws a Gantt chart and a timeline view automatically as tasks are entered. A separate calendar view shows the schedule in a format the team can review without needing to interpret bars on a chart.

Accurate Finish dates account for holidays, bank holidays, and part-time resources. No more calendar-day estimates that ignore real working patterns.
Visible Over-allocation flagged by role in two places. The team sees clashes before they become delivery problems.
Tracked Real costs versus budget on every project. No separate finance sheet to reconcile.

Why it matters

Resource over-allocation is one of the most common reasons projects slip. A person or a role gets committed to two things at once and neither gets what it needs. The planner surfaces this by role, not just by individual, so the problem is visible whether it is a named person or a category of work.

Budget tracking sits inside the same file. Actuals go in as costs are confirmed and the planner shows variance immediately. There is no separate spreadsheet to reconcile and no risk of the two getting out of step.

Because there are no macros, any member of the team can open, edit, and share the file without needing to know how it works inside. Configuring it for a sprint-based approach or a longer programme takes a few setting changes rather than a rebuild. The business owns it outright: one payment, no seats, no renewal.

Is your planning tool working against you?

If your timelines ignore how your team actually works, or your budget lives in a separate file, we can build you something that fixes both.