Automated field scheduling for wind turbine O&M operations
How we built a single Excel Gantt chart that coordinates vehicles, cranes, and crews across an offshore wind operation, and flags scheduling conflicts before they reach the field.
×
Taichung Offshore Partner (TOP) is a Taichung-based, independent project management consulting company focused on supporting development and maintenance of offshore wind facilities. Their core work is ensuring project steps are well defined and tracked to prevent cost over runs that can run in the hundreds of thousands of Euros per day.
As TOP's operations expanded, their existing setup had a hard time keeping up. Field schedules, technician assignments, and vehicle dispatching were tracked across several disconnected Excel workbooks that had no way of referencing each other. We built a single automated Gantt chart system in Excel to centralize their scheduling and eliminate the manual cross-checking that was slowing them down.
Data spread across files that couldn't connect
TOP had all the information they needed to plan a project, but it lived in separate Excel files that couldn't reference each other. That created three specific problems:
Resource blind spots
The team had no reliable way to see when high-risk operations, like a Suspended Load movement, were scheduled at the same time as nearby groundwork. That's a safety risk that a connected schedule would have caught automatically.
Vehicle double-booking
Vehicles were booked manually per task, with nothing to catch a conflict. A heavy transport vehicle could be assigned to a BT/MT Transport job (Bottom to Mid Tower) and a 1st batch Blade load-in on the same day, and no one would know until it caused a delay in the field.
Manual rework
A single weather delay, for example on a Nacelle load-in, meant a project manager had to manually recalculate every downstream task by hand across multiple files. During a critical project phase, that kind of delay compounds fast.
One master Gantt, built in Excel
We built a customized, automated Gantt chart directly in Excel, structured around three pieces:
Dimension tables
Reference tables for the fixed rules and assets that don't change often: vehicle inventory, crane availability, technician certifications, and national holidays.
A centralized fact table
One master table linking every task to its duration, start and end date, required vehicle, and assigned crew. This is what lets dependent tasks sequence themselves, for example making sure a 2nd batch Blade load-in and Blade stacking line up correctly with the Blades load-out schedule, while keeping each task matched to a certified crew and the equipment it needs.
Automation
XLOOKUP and conditional formatting connect the fact table to the Gantt view. Task durations calculate automatically, and the system flags scheduling conflicts as soon as they occur, rather than after they've already caused a delay.
Conflicts get caught while it's still on the sheet
Simplified excerpt of the live schedule for mobile. The full chart on desktop covers 18 days across four vehicles.
On a live installation, dozens of tasks compete for the same cranes and transporters at once. The moment two tasks reach for the same vehicle on the same day, conditional formatting turns that day red down the whole chart, so a manager resolves it on the sheet instead of discovering it on site.
Illustrative example of the conflict-detection behaviour, not real project data. Sundays are excluded automatically as the company's off-day.
Why Excel, and not a dedicated platform?
TOP's work moves fast, and schedules shift constantly with weather and field conditions. Excel gave their project managers a way to make instant changes themselves, without waiting on a vendor or learning a new platform. For a team that needs to move a date the moment a delay hits, that flexibility mattered more than the extra features a SaaS tool would have offered.
A schedule that catches its own conflicts
The system changed how the team plans and dispatches, day to day:
Automated scheduling logic. Task durations calculate on their own, accounting for national holidays and skipping Sundays, the company's designated day off.
Conflict detection. The system flags the moment a vehicle or crane is scheduled for two tasks at once, for example catching an MT-TT Pre Installation conflict before it's delayed by equipment still tied up in Blade unstacking.
Full pipeline visibility. Management now has a single, top-down view of every task in progress, from Nacelle load-out through to final handover, with the crew and equipment assigned to each, instead of piecing it together across files.
Real-time progress chart. As tasks update, the system tracks project management progress in real time, so management can see where each job stands without waiting on a status report.
Fewer surprises in the field. Catching resource conflicts on the sheet, before a vehicle or crew is dispatched, means fewer last-minute scrambles and less risk on-site.
We got their data to talk to each other
We delivered a working Excel system built on dimension tables for vehicles, cranes, and holidays, a single linked fact table, and XLOOKUP-driven automation that renders directly onto the Gantt view. The result replaced several disconnected workbooks with one file that calculates task durations, sequences dependent work, and flags vehicle conflicts automatically. TOP's project managers can now update a schedule in minutes instead of cross-referencing multiple sheets by hand, and safety-relevant conflicts, like overlapping high-risk operations, surface before they reach the field rather than after.
Running crews and equipment across scattered spreadsheets?
We build scheduling tools that fit your existing operation and grow with it.
