Caught Between Excel And Primavera P6? Practical Planning Lessons From Our Latest Webinar

For many SME contractors, project planning evolves in stages. It often starts with Excel, where programmes are easy to create and familiar to manage. As projects become larger and more complex, however, many teams begin to encounter the limitations of spreadsheets.

At the same time, enterprise platforms such as Primavera P6 can feel more complex than some teams need, leaving growing contractors looking for a more accessible way to strengthen planning.

This challenge became a recurring theme during our recent webinar, Build Programmes You Can Deliver: Practical Planning Fundamentals with Asta Powerproject. While the session focused on planning fundamentals rather than software comparisons, many of the questions raised by attendees centred on a common issue: how do growing contractors improve planning maturity without making planning more complicated?

The answer lies not in creating bigger programmes, but in creating programmes that help teams make better decisions.

Planning Is Really About Managing Change

One of the biggest misconceptions in construction planning is that the programme is the end goal. However, construction projects rarely go exactly as planned. Labour availability changes, material deliveries slip, site conditions evolve and client requirements can shift throughout delivery.

Rather than simply recording what has happened, effective planning and the ability to run what-if scenarios allows teams to:

• Test alternative scenarios
• Understand the consequences of decisions
• Review resource constraints
• Identify risks earlier
• Respond with greater confidence

For SME contractors, this ability to model and evaluate different options can be just as valuable as the programme itself. Contractors often think that using risk analysis (such as QSRA) during project is complicated as they might need specialists tools – but that’s where construction project management software like Asta Powerproject is different. It has a risk analysis modelling included in every licence, making it accessible to anyone who would like to really test their programme to gain confidence in their schedule.

Why Communication (And Visualisation) Matters As Much As Planning

Surprisingly little attention in discussions about project planning is communication, be it progress or programme changes to and between clients, stakeholders or site teams.

During the webinar, several examples demonstrated how visualisation of programme information can be used to improve communication across a project.

Particularly useful can be the comparison between baseline programmes and current programmes.

A baseline captures the original plan. The live programme reflects the project’s current position. Comparing the two allows project teams to identify delays, understand where changes have occurred and provide stakeholders with a clear explanation of what has happened.

This can be far more effective to drive decisions than relying on static reports or lengthy programme reviews. Based on the information, the team can decide what’s the best next step – what needs resequencing, what’s the impact on procurement, if more resources are needed to get back on the original schedule.

Another way is to link programme activities with BIM models to create visual construction sequences and project simulations. Instead of reviewing rows of tasks on a Gantt chart, project teams and stakeholders can see how a project is expected to be built over time.

For many contractors, these visual outputs can help bridge the gap between planners, project managers, site teams and clients. They can make programmes easier to understand and encourage more productive discussions around delivery, risk and progress.

Building Programmes And Schedules That Reflect Reality

Programmes also need to reflect how work will be delivered. Many project schedules begin as a collection of activities and dates, but without clear visibility of dependencies, logic and sequencing, they can quickly become difficult to manage.

The session demonstrated how understanding predecessor and successor relationships within a programme helps teams identify the knock-on effects of change. When project teams can clearly see how activities are connected, it becomes much easier to understand risk, prioritise decisions and maintain confidence in the schedule.

To view all Asta Powerproject Trial Lessons, please visit our Youtube channel.

This practical visibility is often what growing contractors are looking for when searching for alternatives to Excel or evaluating options alongside Primavera P6.

Finding the Right Fit Between Excel and Primavera P6

Many growing contractors find themselves caught between two extremes. Sub-contractors might be pushed by contractors to large enterprise systems when collaborating on construction projects – just because a more formal plan is needed.

Microsoft Excel is accessible and inexpensive but often limited when managing larger projects. Many contractors opt for using Microsoft Project – which brings its own challenges we discussed previously.

Primavera P6 is a powerful enterprise scheduling solution widely used on major projects but often perceived as complex and resource-intensive for smaller organisations.

For many SME contractors, the challenge is finding a solution that provides professional planning capability without introducing unnecessary complexity.

The goal is not necessarily to adopt the most sophisticated planning platform available. It is to adopt a planning approach that helps project teams build credible programmes, respond to change and communicate progress effectively.

That practical middle ground generated considerable interest during the session and reflects the reality faced by many growing construction businesses today.

Whether you’re evaluating Excel vs Asta Powerproject, considering an alternative to Primavera P6, or simply looking for better construction planning software for SME contractors, the most important takeaway remains the same: The value of planning comes from its ability to help teams understand change, explore options, communicate progress and make better decisions throughout the life of a project.