Project Management Software Vs. Excel Checklists

June 30, 2014
How simple, familiar tools like Excel—when used correctly and shared with everyone—can be used to very effectively support continuous improvement.

Engineering and manufacturing companies manage projects that are often complex. When dealing with the physical complexity of such projects, project management software can become more of an added burden than a benefit. Even very large companies have resorted to using printed copies of Excel spreadsheets to track a project rather than deal with equally complex project management software. 

For years, our organization (RedViking) used a popular project management software package. It was expensive, cumbersome, and complex. An administrative person was devoted half time to managing the application. It required extensive training, and the users found it frustrating and time consuming. As a result, several managers stopped using it and different versions of project management spreadsheets began to spring up around the company.

At the same time, the company was growing fast and we needed a more transparent, shareable quality process. We needed to easily communicate project information between newer and more experienced engineers, between project managers and designers, and between program managers and clients. The tool needed to be simple but comprehensive, as well as cloud-based with minimal administrative management. We had seen that even some of our largest clients used printed Excel checklists, and we simply wanted to implement virtual versions.

Virtual checklists, using Excel and Visual Basic, combine the simplicity and familiarity of spreadsheets with the online accessibility of project management software. By creating enhanced functionality with Visual Basic and hosting the checklists on a shared server, we have added a consistent level of quality to our projects in a simple format that requires almost no training. Using these familair formats, knowledge is more effectively captured and transferred. An integrated flow chart serves as the process guide for using the checklist. 

Process steps and review levels are easily tracked by automatically adding each user’s initials to their interactions. Percent complete is immediately visible by using simple Excel charts to create a Scoreboard, thereby improving  transparency for all users. Plus, since the reports are easily viewable on any device, project information is much more accessible to everyone on the project.

We have seen significant improvements over our former project management application. Some of the benefits we’ve realized include:

  • Greater efficiencies in the design process through ready access to similar projects;
  • Improved time use, with more time spent on the project and less on administration;
  • Greater engineering confidence based on better information through a familiar tool; and
  • Better visibility of budget and timeline.

By taking simple, familiar tools like Excel and beefing it up with Visual Basic and hosting it on a shared server, we have the project management approach that supports our continuous improvement focus on a project and organizational level.

George Husted is the director of software and controls engineering for RedViking, a member of the Control System Integrators Association

Sponsored Recommendations

Meet our experts - Reduce complexity of a DCS Migration

Sign up for a complementary onsite assessment.

Revolutionizing Germany’s energy landscape: The Wilhelmshaven floating LNG terminal

The German LNG terminal lays the groundwork for future sustainable energy initiatives. Here's how Schneider Electric helped make it happen.

Navigating Distributed Control Systems Migration

Navigating Distributed Control System (DCS) migrations doesn't have to be as complex as it seems. Whether you are planning a migration or seeking to enhance ...

Revolutionize process safety with Tricon CX V12

The most versatile TÜV certified safety instrumented system. One system with a choice of architectures and form factors delivering a lifetime of safe, resili...