Samuel Soh & Mariano AmoedoDigital ConsultantsConsultant
Mott MacDonald logo

Mott MacDonald

Samuel Soh and Mariano Amoedo were staring down 10,000 deliverables on a major subway extension when they realised Excel wasn’t going to survive the next design phase — so they built something that could.

Executive summary

Mott MacDonald, a leading global engineering, management, and development consultancy, needed a scalable solution to manage complex information delivery plans across large infrastructure projects. By transitioning from Excel to Morta on a major subway extension project, the team automated TIDP management for 10,000+ deliverables across 30 design disciplines, integrating with Aconex, SharePoint, and Power BI to deliver real-time tracking and reporting for over 500 team members.

Why MortaA good compromise between Excel and a custom-built database solution — more powerful than spreadsheets, more flexible than the bespoke system they built for HS2 that couldn’t transfer to other projects.
Team sizeSamuel Soh and Mariano Amoedo as the core implementation team
Time to valueMIDP setup reduced from months to weeks on the pilot; future rollouts expected in days via template duplication
SectorInfrastructure
10,000+Deliverables tracked
Months → weeksSetup time
FullAudit trail
DailyCDE status updates
500+Team members

With more than 10,000 tasks to manage, our workflows had outgrown Excel, and we needed a solution that could scale with our projects. Morta provided that path forward.

Mariano Amoedo, Digital Consultant @ Mott MacDonald

The results

The Power BI dashboard embedded within Morta became a daily resource for over 500 team members across more than 30 design disciplines, providing real-time visibility into deliverable status that previously required chasing updates through email and spreadsheets. What used to take months to set up for a new project — configuring an MIDP, training teams, establishing tracking — was reduced to weeks on the pilot. The team believes future rollouts can be done in days using template duplication.

Automating the IDP process eliminated the manual errors that plagued Excel. The Aconex integration refreshes daily, showing reservation status without anyone needing to update Morta manually. The SharePoint integration tracks whether working files exist for each deliverable. Both sit alongside deliverables in a single view, giving teams instant visibility without switching systems.

The audit trail proved its value almost immediately. When a user reported a deliverable had been altered beyond recognition, the team filtered by user in Power BI, saw every action taken on that row, and explained the full history in minutes rather than the hours it would have taken to untangle in Excel. And by combining usage metrics with project data, the team could measure not just who logged in, but who was actively creating, updating, or archiving deliverables — giving direct insight into whether training was translating into real behaviour change.

During the early design phases, Excel was our ally in task management. But as we moved into new design phases, deliverables were expected to skyrocket. Think about it, over 10,000 tasks to track with Excel. We needed a solution scalable enough for what lay ahead.

Samuel Soh, Digital Consultant @ Mott MacDonald

The challenge

During the early design phases of a subway extension project, Excel worked fine. But as the project moved into new design phases, deliverables were expected to skyrocket past 10,000 — and Excel simply couldn’t handle the volume. Files became slow, error-prone, and difficult to maintain.

The openness that made Excel familiar also made it dangerous. Too many people could go in and change things — adding columns unnecessarily, modifying data without anyone knowing. The information management team would have to go back in, lock it down, and undo changes, burning significant time on cleanup rather than delivery. There was no audit trail, so if a deliverable was altered beyond recognition, tracking down what happened was a manual investigation with no guaranteed answer.

Mott MacDonald had tried building a bespoke solution before. On High Speed 2, the team created a custom database with a web app that worked well for that project — but it was built specifically for HS2 and proved impractical to transfer anywhere else. They needed something configurable enough to reuse across projects without rebuilding from scratch each time. Meanwhile, design teams across 30 disciplines relied on disconnected tools for task management and tracking, with no single source of truth connecting the MIDP to the CDE, the programme schedule, or reporting.

Without reducing this whole exercise of reviewing, we don’t want to make things that easy and simple.

Mariano Amoedo, Digital Consultant @ Mott MacDonald

The solution

Morta occupied a sweet spot the team had been searching for: more powerful than Excel, more flexible than a custom-built database. It gave them the familiarity of spreadsheets with the control of a structured system.

Work package managers and discipline leads populate deliverables directly into Morta. Document numbers are auto-generated as users fill in columns — originator, document type, discipline, work package — eliminating manual number assignment and enforcing data quality at the point of entry. The team set up a two-view workflow: one editable view for populating deliverables, and a second read-only view filtering those not yet reserved in Aconex. Users export from the second view and send directly to document control.

Aconex integration was a one-click setup. Document metadata flows into Morta and refreshes daily, automatically showing reservation status alongside each deliverable without document control needing to update anything manually. A separate Power Automate flow scans the SharePoint design library, captures file metadata, and populates a linked table in Morta — creating a column that shows whether each deliverable’s working file exists in SharePoint. Power BI dashboards pull data directly from Morta and are embedded within the platform, so 500-plus team members across 30 design disciplines can check progress without leaving Morta. And the audit trail data, piped into Power BI, lets the team track exactly who changed what and when — something that was simply impossible in Excel.

What used to have taken months to develop in the past with regards to setting up an MIDP, we were able to set that up within weeks. And in the future, we believe that we can do this within days.

Samuel Soh, Digital Consultant @ Mott MacDonald

The implementation

Moving from Excel to a new system was a real shift, and the team was honest about that. Early on, teams were still leaning on spreadsheets and sending files to the IM team to input into Morta. The goal was to get them inputting directly. Weekly training sessions provided hands-on guidance, discussing updates and new features while making people comfortable with the new processes.

The team deliberately kept the document control reservation step manual rather than fully automating the Morta-to-Aconex flow. Not everything added to Morta is ready to be reserved — there’s a review exercise first, and automating too early would have removed an important quality gate. With the pilot refined, the plan is to duplicate the workspace for other projects, iron out inefficiencies, and create a standard template that rolls out across the division and the company. Samuel and Mariano’s advice is direct: always bring the people, speak to them, understand their concerns, and respond to their feedback. Don’t just set the tool up and hope for the best — while Morta can provide the technology and set up a process, the people bit is still important to remember.

Before & after

Before

Months to set up an MIDP

After

Weeks on the pilot, days for future projects

Before

No audit trail — changes untraceable in Excel

After

Full audit trail showing who changed what and when

Before

Disconnected tools across 30 disciplines

After

Single source of truth for 500+ team members

About Mott MacDonald

Mott MacDonald is a global engineering, management, and development consultancy with over 20,000 employees across 150 countries.

What's next

Duplicate the workspace for other projects, refine the solution, and produce a standard template for rollout across the entire division and company.

Want to see how this could work for your projects?

Frequently asked questions.

Common questions about this template and how it works.

Can Morta handle 10,000+ deliverables on a single project?

Yes. Mott MacDonald manages over 10,000 deliverables on their subway extension project using Morta, with 500+ team members across 30+ design disciplines accessing the platform daily. The database architecture handles large datasets that would be impractical in Excel.

How long does it take to set up an MIDP on Morta?

Mott MacDonald reduced their MIDP setup time from months to weeks on their pilot project. With template duplication, future projects can be set up in days — duplicating the workspace, adjusting for project-specific needs, and going live.

Does Morta integrate with Aconex for document control?

Yes. Morta has a native one-click integration with Aconex. Mott MacDonald connected their Aconex account directly from Morta's integration section. Document metadata flows into Morta tables and refreshes daily, automatically showing each deliverable's reservation status without manual updates.

Can Morta connect to SharePoint for working file tracking?

Mott MacDonald set up a Power Automate flow that scans their SharePoint design library, captures file metadata including document numbers, and populates a table in Morta. This is then linked to the information delivery plans table, creating a column that shows whether each deliverable's working file exists in SharePoint.

How does Morta help with ISO 19650 compliance?

Morta supports ISO 19650 workflows by structuring information delivery plans (MIDPs and TIDPs) as database tables with enforced column types, automated document numbering, and integration with CDEs. This ensures deliverables are planned, tracked, and reported in line with the standard.

What is the difference between using Morta and building a custom database solution?

Mott MacDonald previously built a custom database solution on HS2, which worked well but was hard to transfer to other projects. Morta provides the same database power but is easily configurable and reusable across projects — what Samuel described as "a good compromise between Excel and a custom-built database solution."

Full community session transcript

Hi everyone. Thanks to everyone who’s already joined us. Really looking forward to today’s session with Samuel and Mariano from Mott MacDonald, who are going to be talking us through information delivery planning and how they’ve been using Morta for that.

So looking forward to this showcase. Hi everyone again, thanks for everyone who’s joined us so far. This is Mo, I’m one of the co-founders of the company and as many of you know the point of these showcases and the community sessions is for us to share knowledge within the community. We think a lot of people are working on really really cool things and we can all learn from each other. We’ve certainly learned from the people that we bring on board to these sessions. And they’ve usually opened our eyes to something. And that’s why we bring them on to share their knowledge with all of you. And that’s really the goal of these sessions. It’s for us to be sharing knowledge with each other.

What we’ll do today is I’ll quickly start with a bit of a recap around what we’re trying to achieve and just contextualize the session. And then handing over to Samuel and Mariano, who will be talking through their learnings and the work that they’ve done. So thanks for joining, let’s get started.

So just to recap quickly, our goal is to help you increase your productivity by replacing spreadsheets with connected information hubs. The way we see it is the future of the industry looks really exciting. On the ground, what’s happening is we have many projects that rely on hundreds of disconnected solutions for planning and tracking. These could be point solutions, but right in the middle, we predominantly have Excel and Word. And that’s the case regardless of who I am in the context of a project. If I’m a design manager, if I’m a BIM manager, if I’m a sustainability manager, or if I’m a commercial manager, or a quality control manager. And that causes all kinds of challenges, which is exactly why we’ve created Morta.

The way we see it is we provide hubs that allow you to connect information, point solutions and teams together so that everyone is working with the same data and they’re reusing data and they’re collaborating and we’re breaking silos and we’re just ensuring higher data quality. And what happens is we provide a tool that has the familiarity and the flexibility of spreadsheets with the power of a database. And what that means is I can define column types, I can define what columns I’m expecting, I can define that I want text within these columns, I can define that I want dates, I can define that I want drop down lists from other data sets and so on and so forth. And that helps us improve the data quality of the data that’s going into these tables.

Then one of the key things is there is a lot of data that’s already available in other systems. And we see that many people currently spend a lot of time manually collecting this data from one system and putting it into Morta. And we want to make that as easy as possible through one click integration so that you can all reuse the data day to day. And we’re starting to introduce some new beta features that will enable you to make your information accessible with things like AI and with visual reporting so that questions are answered very quickly. And so that we help you increase your productivity.

As mentioned, my name is Sam. I’m joined with my colleague Mariano today to share our experience of how we’ve used Morta to manage our information delivery plan on one of the largest infrastructure projects within Morta at the moment. So before we get into the fun stuff, some background on who we are. As I said, my name is Sam. I’m a digital consultant within Mott McDonald and I’m the CDE technical lead for my division. I’ve been in the industry for more than six years now, where I’ve worked on lots of major infrastructure projects, such as HS2, where I’ve led the information management activities, configured CDE systems, and overall just ensuring compliance with ISO 19650.

Hi, everyone. I’m Mariano, a digital consultant within McDonald’s information management team. And I’ve been in the industry for over 4 years now, mostly involved in the digital delivery of major infrastructure project, for example, High Speed 2, just like Sam. And my focus has been on BI development and the optimization of CDE systems. And I’m looking forward to take you through our journey with Morta and the impact it’s had on our work.

As mentioned, we’ll be talking a lot about information delivery plans today. The information delivery plan is an ISO-19650 artifact. It’s essentially a list of deliverables that needs to be completed during a project. It’s used by production teams to plan their work and also by the PMs and client teams to monitor progress and plan for the receipt of information. Basically it’s identifying what information will be produced, by who, for how long, and when they will be delivered.

In line with ISO 9650, we typically have different task information delivery plans, or TIDPs, for the different task teams or the different discipline teams. And they all get amalgamated into a single master information delivery plan, otherwise known as an MIDP.

So here in McDonald, we see the MIDP as one of the key cogs in our overarching systems architecture, where we use this to monitor delivery progress by connecting it to all the different data sources. We have the MIDP where each row is a deliverable with its key information. Historically, we’ve been using Excel typically for MIDPs, and Mariano will explain later how we’ve moved from Excel in our case study. We’ve connected the MIDP to the program or schedule via the program ID, and this then gives us the expected delivery dates for the deliverables. We’ve also connected our MIDPs to common data environment systems like ProjectWise, ACC.

We use the document number as the key identifier between those two systems. We use this to track the progress of the deliverables using the suitability codes, i.e. whether the document is ready for approval. And as long as we have achieved common coding across all the different systems, we are then able to connect all the dots to form Power BI dashboards that show the bigger cohesive picture, which the project team can then use to plan their work.

So taking what we’ve learned about our use of master information delivery plans, we turn to our case study set within a subway extension project. So during the early design phases, Excel was our ally in task management, keeping our workflows organized and on point. But as we moved into new design phases, deliverables were expected to skyrocket. So think about it, over 10,000 tasks to track with Excel. We needed a solution scalable enough for what lay ahead without losing our grip on the project’s complexity. So the answer was to evolve with our much expanding project demands. And that’s where Morta steps in.

With Morta, we found our solution. So this tool wasn’t just another option. It was a clear path forward to manage our project’s growing needs. It’s simple to integrate yet powerful enough to handle the complexity of thousands of tasks. And it’s about making our day-to-day work smoother and preparing us for the scale of work yet to come.

The next step was making the actual switch to Morta. So despite agreeing with our project teams on the need for change, moving from the familiarity of Excel to a new system was a real shift for everyone. So it’s one thing to get everyone on the same page and receive support in theory. And it’s another to get a wide range of design teams to change their daily habits. At the beginning, we noticed teams were still leaning on Excel and sending us files to input into Morta. Our goal was to have them input directly into the new system.

Working with Morta’s team helped us meet this challenge head on. They were quick to respond, integrating the features our teams identified as game changers. And honestly, it was as if they were there right with us, tuning Morta to fit our project needs and rhythm. During our weekly sessions with our project teams, we not only discussed the updates and features, but also provided hands-on guidance to make everyone comfortable with the new processes.

For tracking progress, we went beyond seeing who was registering and logging into Morta. We actually carefully looked at how Morta was being used, focusing on the practical impact of the tool on our daily work. And this insight was really vital as it helped us understand the effectiveness of the adoption and ensured that the move on to Morta was translating into real tangible benefits for the team.

This is our TIDP change tracker dashboard. So we’ve been able to create it thanks to Morta’s capability to collect usage metrics data, which we’ve been able to leverage by also using Morta’s ability to integrate with reporting tools like Power BI. This dashboard has been crucial, not only for managing Morta activity broadly, but specifically for tracking user adoption. So as we introduced new features and continued our training, we could clearly see the user engagement rising, giving us a direct insight into the effectiveness of our initiatives and the collaboration with Morta’s support team.

Our approach is straightforward: work package managers, discipline leads and IM coordinators populate deliverables in Morta. Next we have IM coordinators and other responsibles for deliverables reviewing them either directly in Morta or through our CREP dashboard. Following this review, selected deliverables are manually exported and sent to document control for document preservation in Aconex system. While this is currently a manual step, integration between Aconex and Morta then automates the update back into Morta, showing us the reservation status next to each deliverable that is populated in Morta.

This is the information delivery plans table view in Morta. This is where our project members have been populating their deliverables. What’s particularly useful here is the Aconex status column you see next to each deliverable. It automatically updates to indicate whether a deliverable has been reserved within the Aconex system. And as you can see, there’s also a column for SharePoint status, which shows the working file for a deliverable is currently in SharePoint, which is also very useful.

The document number is automatically generated as users populate their columns. For example, originator, document type, discipline, work package. That’s what composes our document numbers. So once a document number is generated, these columns here start telling you if it’s in SharePoint, if it’s in Aconex. Then for those which are not in Aconex, it means they have to be sent to document control for reservation in the system.

In the next few slides, we’ll see how Morta’s versatility has been a game changer for us. So thanks to its interoperability with other key systems in our project. So we’ve successfully integrated Morta with SharePoint, which has been crucial for tracking our working files. And additionally, we’ve brought Power BI into the mix, which has been key for TIDP reporting and gaining clearer insights into our project’s progress. And for integration with Aconex, this has streamlined our document management processes. So Morta really has been an effective hub, allowing us to strengthen our project infrastructure and making our workflow more cohesive and efficient.

The first example of integration with other systems is our TIDP dashboard in Power BI. This is embedded right within Morta. This means our design teams can access these insights without ever having to leave Morta. The dashboard is pulling data from our information delivery plans in Morta to provide key insights. And it’s become a daily go-to resource for 500+ viewers and across more than 30 design disciplines, helping them review progress and the status of deliverables at different stages.

To connect SharePoint with Morta, we’ve set up a Power Automate flow that sifts through the SharePoint design library, capturing metadata of each file including the document numbers, and then populates these into a table in Morta. The SharePoint table is then linked to our information delivery plans table. And as a result, we’ve created a column that indicates us whether the deliverable is present in SharePoint or not, using the document number as a key for this cross-referencing. So this really enhances our visibility over project deliverables.

For the Aconex integration, we didn’t need to set up any flows like we did with SharePoint. Morta has a built-in feature for integration with Aconex. We simply logged into our Aconex account from the integration section in Morta. And just like that, we started putting Aconex data into Morta tables. This data gets refreshed daily automatically, ensuring we always have the latest updates. Once it’s in Morta, we link it to our information delivery plans table, just like we did with our SharePoint one. And this gives us a column showing us not only if a deliverable is in Aconex, but also the current status that it holds in that system.

With all the good work that Mariano has done on this project, what are the next steps into rolling this out on other projects? We’ve discussed this with the Morta team, and what they’ve recommended is to now that we have got this foundation that Mariano has done, we can easily duplicate this workspace for all the other projects. And what we will do here is to further refine the solution on all of these other projects, ironing out any inefficiencies, and tweaking it to fit all the different projects. And once we have a clear idea of how this whole MIDP solution should look like, we can then produce a template, which we can then easily roll out across the entire division, the company, ensuring that we have a consistent high quality approach to managing the MIDP within the company.

So essentially, what used to have taken months to develop in the past with regards to setting up an MIDP, what Mariano has done here, we were able to set that up within weeks. And in the future, we believe that we can do this within days. So really powerful stuff right here.

In summary, our experience with Morta have been very positive. It’s quick and easy to deploy on projects. We are able to easily extract data from Morta to gain insights on the usage analytics. But having said that, while it is a simple and powerful tool, it is still a new tool, not necessarily for people who are very much used to Excel solutions already. So our advice for anyone deploying Morta is to always bring the people, speak to them, understand their concerns and always respond to their feedback as you roll out Morta on your projects. So in essence, don’t just set the tool up and hope for the best because while Morta can provide the technology and set up a process, that people bit is still important to remember.

We think that Morta is a good compromise between Excel and a custom-built database solution. It’s a good database solution, but it’s also easily configurable for many projects.

Ready to connect your controls?

Get in touch with our team to see how Morta can drive delivery performance across your projects.