Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We See Which Engineers Are Free Next Month Without Rebuilding the Resource Spreadsheet Every Week?
Problems We Solve

How Do We See Which Engineers Are Free Next Month Without Rebuilding the Resource Spreadsheet Every Week?

Engineering consultancy resource planning lives in a spreadsheet nobody trusts. We build a planner fed by stage dates, fees and leave that shows gaps early.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Resource spreadsheets go stale because project dates move every week and nobody updates the sheet to match. We build a resource planner that reads stage dates and fee budgets from your projects, holidays from your leave system, and actual time from timesheets, so directors can see who is overloaded and who has capacity for the next job without rebuilding anything by hand.

The Monday resource meeting that runs on guesswork

Every Monday the directors meet to talk about who is working on what. The resource spreadsheet has a row for each engineer and a column for each week, coloured by project. Half of it is wrong. A stage 3 slipped because the architect is late with layouts, so the two engineers booked on it are actually waiting. Meanwhile a tender package for a warehouse came forward and needs three people now.

The meeting becomes a conversation about what everyone thinks is happening. Decisions are made, the spreadsheet is partly updated, and by Wednesday it has drifted again.

Why the resource sheet never stays right

  • Project programmes are owned by architects and clients, and they change without telling you.
  • The sheet is disconnected from fee budgets, so nobody knows if the hours planned fit the fee.
  • Leave, training and site visits are recorded elsewhere and not reflected.
  • Actual time booked is never compared with what was planned.
  • Only one person maintains it, and they have their own work to do.

An engineering practice's workload is lumpy. Stages start late, pause for planning, then need doing at once. A static grid cannot show that without constant manual effort.

Engineering adds its own wrinkle: skills are not interchangeable. The engineer free next week may be a drainage specialist when the job needs someone who can do a steel frame. A resource sheet that shows hours without skills tells directors who is idle, not who can actually pick up the work.

What poor resource planning costs

SymptomResult
Engineers overloaded on one projectLate issues and rushed checking
Engineers under-used while waitingNon-chargeable time, no plan for it
New work accepted without capacityExisting clients get slower service
Senior people doing junior workFees consumed faster than planned
No view beyond next few weeksHiring decisions made too late or too early

How we build a resource planner

  1. We import live projects with their stages, dates and fee budgets from your project or accounts system.
  2. For each stage, a director or project lead allocates people by grade and rough weekly hours, starting from a suggestion based on the fee budget.
  3. Leave and training come in from your HR or leave system, such as BrightHR or Microsoft 365 calendars, so availability is real.
  4. When a stage date changes, the allocation moves with it, and any clash it creates is flagged.
  5. Actual time from timesheets sits against planned time, so directors see where plans were optimistic.
  6. Pipeline jobs from your fee proposals appear as tentative work, weighted by how likely they are to land.
  7. A weekly view shows each engineer's load, and a longer view shows capacity by grade months ahead.

We keep it editable by the people who plan, drag and drop where it helps, rather than locking it behind a rules engine. The value is in the connections, not in automating the directors' judgement.

Each engineer's profile records their main disciplines and the software they are comfortable with, so when a director looks for capacity the planner can show who is free and suitable, not just who is free. That is usually the question the Monday meeting is really trying to answer.

The resource meeting afterwards

The Monday meeting starts from a view that already reflects moved stage dates, leave and actual hours. The discussion shifts from 'what is happening' to 'what do we do about it': who picks up the warehouse tender, whether the graduate can take on the drainage design, whether to bring in a freelance engineer next quarter.

Because pipeline work is visible, decisions about new hires or turning down work can be made on something firmer than a feeling of being busy.

Is your resourcing like this?

  • The resource spreadsheet is rebuilt or heavily edited every week.
  • Moved stage dates are discovered when engineers are found waiting.
  • Leave is not visible in the resource plan.
  • Nobody compares planned hours with actual hours.
  • You accept new work without knowing who will do it.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Do we need to replace our project management system?

No. We read projects, stages and time from what you have. If you have no project system, the planner can hold the project list itself.

Can engineers see their own allocation?

Yes, each engineer can see what they are planned on, which helps them flag conflicts early.

How does it handle part-time staff?

Each person's working pattern is set once, and availability is calculated from it along with leave.

What affects the cost?

The systems we connect to, the number of people and projects, and whether you want pipeline weighting and longer-range capacity views.

Keep reading

More on Problems We Solve

Start here

Tell us where your engineering practice loses time

Describe the process, the software your engineers and office team already use, and where it stalls. We will tell you what we would build and what we would leave alone, and if a smaller change would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →