How We Replaced Spreadsheet-Based Workforce Planning for a Scaffolding Contractor

Many businesses begin their workforce planning journey using spreadsheets. They are familiar, flexible and require little investment to get started. For smaller teams and straightforward operations, spreadsheets can often be sufficient.

However, as a business grows, spreadsheets frequently become one of the biggest operational bottlenecks. Information becomes fragmented across multiple files, planning becomes increasingly manual and managers spend more time maintaining spreadsheets than actually managing operations.

Recently we worked with a scaffolding contractor to replace a spreadsheet-based workforce planning process with a bespoke planning system designed specifically around how the business operates.

The challenges of spreadsheet-based planning

The company operated multiple scaffold teams, vehicles and contracts across a wide geographical area. Daily planning involved deciding:

• Which scaffolders would work together as a team
• Which vehicle each team would use
• Which jobs each team would attend
• Whether work involved installations, strikes or repairs
• Expected labour hours for each activity
• Special requirements such as training, absence or temporary resources

Historically this information was maintained in spreadsheets and manually updated throughout the day. While workable, the process introduced several challenges:

• No single source of truth for planning information
• Difficulty identifying unallocated staff and vehicles
• Time-consuming updates when jobs changed at short notice
• Limited visibility of team workload and capacity
• Manual transfer of operational data into payroll processes
• Increased risk of errors when multiple changes occurred during the day

As operational complexity increased, it became clear that a more structured solution was needed.

Designing a planning system around real-world operations

Rather than attempting to force the business into generic scheduling software, we developed a bespoke workforce planning module tailored specifically to scaffold operations.

The objective was simple: make planning faster, easier and more visible while reducing duplication of effort.

The resulting system allows operations managers to plan an entire working day from a single screen.

Drag-and-drop workforce allocation

One of the most significant improvements was the introduction of drag-and-drop workforce allocation.

Staff can be assigned to vehicles simply by dragging them from the list of available scaffolders onto the selected vehicle plan.

• Quick assignment of scaffolders to teams
• Visual identification of unallocated staff
• Support for training days and unpaid leave tracking
• Automatic identification of team leaders
• Instant updates when resources are moved between teams

Operations managers no longer need to manually update multiple spreadsheet cells every time plans change.

Vehicle and job planning from a single screen

Each vehicle plan can contain multiple jobs for the day, including scaffold installations, strikes and repair work.

Managers can allocate work based on expected labour requirements and quickly see whether a vehicle is under-utilised, fully allocated or potentially overbooked.

• Allocate multiple jobs to a single vehicle
• Record expected labour hours per job
• Track installation, strike and repair activities separately
• Maintain custom job notes for site teams
• Override addresses for multi-site contracts when required
• Adjust work order throughout the day using drag-and-drop sorting

This provides a far more realistic view of operational workload than traditional spreadsheet planning.

Managing temporary resources and changing requirements

Construction and scaffolding operations rarely remain static. Additional vehicles may be required, teams may need to be reconfigured and jobs frequently move between resources.

The planning system was therefore designed to accommodate operational changes quickly.

• Create temporary vehicles for specific dates
• Move jobs between vehicles
• Reassign scaffolders between teams
• Change vehicle allocations without losing planning information
• Copy plans between dates to reduce repetitive administration

These features significantly reduce the time required to react to changing site conditions and customer requirements.

Generating daily work packs automatically

Once planning is complete, the system can generate printable daily work packs for site teams.

These packs contain the information teams need to carry out their work safely and efficiently.

• Vehicle allocations
• Team member details
• Job addresses and postcodes
• Work descriptions and notes
• Loading requirements
• Contract manager contact information

Instead of manually preparing paperwork, operations managers can generate planning packs in seconds.

Supporting payroll and operational reporting

One of the biggest advantages of replacing spreadsheets is that operational data can be reused throughout the business.

Because workforce allocation is recorded centrally, the same information can be used to support payroll preparation, labour analysis and management reporting.

• Reduced duplicate data entry
• Improved labour cost visibility
• More accurate operational reporting
• Better understanding of workforce utilisation
• Improved profitability analysis

This transforms planning data from a temporary scheduling exercise into a valuable source of operational intelligence.

The results

Replacing spreadsheets with a bespoke workforce planning system delivered significant operational benefits.

• Faster daily planning
• Reduced administrative effort
• Improved workforce visibility
• Better utilisation of staff and vehicles
• More accurate labour reporting
• Improved operational flexibility
• Reduced risk of planning errors

Most importantly, management gained a real-time view of operations rather than relying on static spreadsheets that quickly became out of date.

Could bespoke workforce planning software help your business?

If your organisation still relies heavily on spreadsheets to allocate staff, vehicles, projects or resources, there may be significant opportunities to improve efficiency through automation and workflow redesign.

At New Media Aid, we develop bespoke operational software tailored around the way businesses actually work. Whether you need workforce planning, inspection management, reporting automation or a complete operational platform, we can help design software that supports your processes rather than forcing you to adapt to generic systems.

Contact us to discuss your workforce planning and operational software requirements.