Spreadsheets stink for project management

Spreadsheets stink for project management

Part I

The larger a project, the more documents project teams need to manage. It’s plain fact. With a growing number of large projects, keeping track of documents becomes quite a chore. This chore becomes a burden for growing organizations, forcing many to implement a third party system. Evidence of this phenomenon is the flood of organizations turning to Google Docs, Share Point, base camp or thousands of others. With so many document management systems (DMS) available, I found myself asking: Why are so many growing organizations using excel spreadsheets to manage documents?

When I started marketing ProjecTools Documents, our DMS system, it seemed like a no-brainer. Who wouldn’t use a third party system instead of a spreadsheet to keep track of documents so integral to organizational functions? Especially engineering and construction firms where information accuracy could make or break a project. After some time, I found four common objections:

  1. Our spreadsheets have always worked for us in the past.
  2. We don’t trust a third party with our proprietary information.
  3. We don’t want to pay for something we already have.
  4. Our organization won’t change.

I’ll address these objections as we do with clients in the order listed above.

Objection #1 – Our spreadsheets have always worked in the past  Ok, document tracking spreadsheets worked in the past. That may be a true statement, but it may not be a valid objection. The reason it may not be a valid objection is that it worked in the past. The key here being past. To test the validity of this objection, I ask: Is it working now? To hash this out, I present a series of True or False statements to determine if the system meets simple DMS standards.

  • I know latest official review for each document.
  • I know who has checked out each document
  • I know the recipient of each document routing
  • There are zero duplicate documents in my system
  • There are zero ambiguously named documents
  • No documents have been lost or misplaced within my system
  • Employees are not permitted to delete files
  • My system holds my clients accountable

If an organization answers False to any of these statements, it renders the objection invalid because the system is not controlling documents, it is simply archiving them. Proponents of spreadsheets who answer False for the above statements about their spreadsheet document control may counter this claim by maintaining that all systems have shortfalls. Even though no DMS is flawless, any good document management system allows a document controller to answer ‘True’ to the above statements.

Part II

Last week, I posted the first part of this article about how spreadsheets stink for project management. In that entry I mainly addressed the common argument that document management spreadsheets have worked in the past. In that  post, I argues that spreadsheets may have worked, but they probably don’t work very well. Here are my responses to the next three objections.

Objection #2 – We don’t trust a third party with our proprietary information.

Fine, don’t trust a third party with proprietary information. Don’t route documents through external email servers.  Don’t allow employees to bring jump drives to work, and make sure the IT budget covers the cost of infrastructure and redundancies that third party providers employ. Moreover, make sure your IT team has the time and resources to test and secure the network to a standard that specialized DMS can. Please keep in mind that the DMS provider has to keep the client happy. DMS providers don’t retain clients by putting client’s information in harm’s way. Other things spreadsheeters should think about are: Which team members have read/write permissions to the organizational spreadsheets. Are any permissions assigned? What if a mistake is made? How would that be tracked? What if the spreadsheet is deleted? Is there a backup plan? What if the server crashes? Is everything backed up? How much downtime will a crashed server cause? These questions deserve answers.  If an IT department can’t give straight answers,  look elsewhere. Similarly, if a third party document management system seems shaky, has ill repute, or offers a vague security license agreement – find another provider.

Objection #3 – We don’t want to pay for something we already have.

You get what you pay for. If an organization keeps document management in house and manages its documents with spreadsheets, they pay for it. They pay in unachieved efficiency, duplication of efforts, excess IT infrastructure, labor, and/or lost opportunity for growth. The value of DMS boils down to doing more with less: more productivity with less infrastructure, less duplication of effort, revision control, and fewer mistakes. In short, using spreadsheets for document control may cost less up front, but spreadsheets cannot enforce workflow or hold team members accountable, which will save an organization time, money, and credibility (in the end).  The question becomes: What will not implementing a good DMS system cost you?

Objection #4 – Our organization won’t change.

An organization that refuses change for the better clearly is not looking toward the future for growth and scalable opportunities. A good DMS that will enforce workflow, increase accountability, and increase efficiency should be welcomed and championed. As sophisticated DMS becomes the norm, organizations employing the old spreadsheet method may be overlooked by clients, resulting in fewer awarded bids.

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

ProjecTools Videos, Demos, and Webinars

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.

Emerging Floating Production Storage Offloading FPSO Takeaways

The Emerging FPSO Forum was excellent. Our team enjoyed connecting with all the folks on the cutting edge of FPSO technology and methodology including client representatives from

Emerging FPSO Takeaways

The Emerging FPSO Forum was excellent. Our team enjoyed connecting with all the folks on the cutting edge of FPSO technology and methodology including client representatives from Audubon Engineering and WATER STANDARD .  Our team attended interesting sessions touching on technical developments in topsides, hull structures, mooring design, engineering trends, project challenges, market forecasts and so much more. If you are in the FPSO industry, we hope to see you next year because it won’t disappoint!

While all sessions at the forum were very informative and interesting, David Rosenberg‘s presentation really resonated with our team. David, a Senior Project Analyst from Independent Project Analysis (IPA), emphasized the importance of project execution and outlined the challenges and shortfalls that have lead to a 20% project success rate! David articulated some helpful strategies for the other 80% of projects that are coming over budget and past schedule.  He suggested applying a well-defined project control strategy from project initiation, integrating asset teams, strict control standards complete with standard reporting at fixed intervals and utilizing a modestly aggressive schedule to avoid over-runs and unnecessary delays. David’s research  found that these are the primary factors contributing to the only 20% success rate among FPSO concepts.

David also presented case studies of FPSO projects that were managed very differently. The first project started with high level plans, missing key team members, insufficient project control planning, and an aggressive schedule. This project ended up 100% over budget, more than one year past schedule and the asset itself suffered from recurring operation problems. The second FPSO case started with minor planning gaps, integrated teams and contractors, complete project control and monitoring plans and a modest schedule. The second project (also the first FPSO for that contractor) ended up 5% over budget and 5% past schedule.*

ProjecTools has spent over 15 years crafting a tool that helps project teams achieve successful projects. Moreover, we understand how important integrating teams and utilizing a well-defined project execution strategy can make or a break project. To mitigate these common project challenges, ProjecTools integrates asset stakeholders by centralizing project information, providing online access to project information, providing standardized reporting, enforcing workflows, and providing invaluable communication tools.

ProjecTools also promotes the standardization and execution prescribed by David. ProjecTools provides standardization and ensures proper execution allowing managers and owners to effectively plan for projects, enforce proper project execution and provide a project template for future projects.

*Rosenberg, D. & Walker, J. (2012). Project management needs for FPSO projects. Independent Project Analysis Inc. Unpublished paper presented at the Emerging FPSO Forum, Galveston, TX.

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

ProjecTools Videos, Demos, and Webinars

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.

Project Management Software Overload

Great strategies for separating the wheat from the chaff and moving past Project Management Software Overload.

Project Management Software Overload

Ever been tasked to find the right Project Management Software? If so, you probably realize how ridiculously broad the category is. Project Management Software could mean anything from Basecamp to AtTask, or Microsoft Project to ProjecTools. This is Project Management Software Overload. To illustrate my point; on Wikipedia there are ~150 entries under “Comparison of project management software.” Which leads us to the subject of this post – how does one separate the wheat from the chaff? My answer – by correctly defining the words “project”, “management”, and “software” for your organization.
So let’s begin:

  1. We need to define “project.” If the project is simple, a simple application getting everyone on the same page and tracking input/change will be enough (think Asana, Basecamp, Trello). What about IT Project Management though? Totally different. Complex capital construction or EPC (Engineering, Procurement, Construction) project? Once again, there’s an entirely different set of criteria that should be considered. These complex construction project solutions require significantly more powerful software to manage all of the moving parts. Even after defining the project though (for this post: EPC projects), one is left with a staggering array of software options. Which leads us to the second criteria – defining “manage.”
  2. too many project management software optionsWe need to define “manage.” What part of the project is most important to you? Simple projects have fewer moving parts and stakeholders – they’re relatively simple to manage and you may be able to manage many aspects of the project with relative ease. But if we’re talking EPC projects you must be much more deliberate; there is Scheduling, Document Management and Collaboration, Cost Control, Procurement, Engineering and Commissioning, and often there are multiple projects going on simultaneously (PPM). Of course these aspects are all important and different organizations place emphasis on different parts of project management – complicating the issue even further. Luckily there are tools that manage multiple pieces of these complex projects, but even the most comprehensive tools can’t tackle everything coherently. For instance, ProjecTools is arguably the most comprehensive Project Management Software tool (for EPC and Oil and Gas projects) covering Document Management and Collaboration, Cost Control, Procurement, and Engineering and Commissioning. That said, we realize there are other aspects of project management (scheduling especially), and rather than try to re-invent the wheel – we believe integration is stronger that competition (we integrate with scheduling leaders like Primavera). So now, if you’ve defined what you want to manage – we only need to decide what “software” means to you.
  3. We need to define “software.” To be clear, we’re not interested in the technical definition of “software”, instead I’m working to define the category of things that are typically described as software. Let’s start with the basics: deployment options, purchase options, how it’s supported, and standalone or integrated.
    1. Deployment options are a point of contention, but the writing is on the wall: cloud is here to stay (see my presentation on the subject at PMI here).
    2. On purchasing – is it a CapEx or OpEx and can you fit it in your department’s budget? If you’re buying traditional on-premise software or deploying a private cloud, you’re looking at a significant capital expenditure and a significantly prolonged installation/implementation. On-premise can mean as much as a 10X increase in budget, the addition of IT support personnel, a decrease in redundancy, and 3-4X increase in the implementation timeline (which means less project-oriented work gets done). Good luck (and I’m not the only one who feels this way).
    3. How’s it supported? Having someone standing by to take your calls and correctly handle and escalate issues is something that really, really matters. Like anything, you may not realize how much it matters until you really need the support, but don’t dismiss this when you define what software means to you. And please don’t confuse “maintenance plans” for support; a maintenance plan is a poorly-disguised profit-generating mechanism – while support is designed to help clients and customers when they need it.
    4. Standalone or integrated? Everyone is talking about Big Data, but what they’re finding is Big Data Silos. Collecting data is an exercise in futility if it sits within a single application and isn’t used across the organization to make better decisions. Whether your chose multiple “best-in-class” systems and integrate them, or choose a comprehensive solution – you should understand the importance of integrated systems. At ProjecTools we fall into the “comprehensive solution” bucket but we also integrate with other applications to offer our clients a better control and decision-making platform and that’s important. Why is integration important? Because integration saves double-entry, preserves data integrity, allows for better decision-making, increases adoption rates, and leads to dramatically increased success in deployment and operation. But just because a company claims their software products are “integrated” doesn’t mean it was built together – be wary of larger vendors that “integrate” multiple products through acquisition of (once) entirely separate companies.

If you’ve followed this post so far, your needs in Project Management Software should be fairly clear. By defining what you mean by “project”, “management” and “software” you will be better equipped to make a purchasing decision, specifically as it relates to complex capital construction and EPC project management. Of course we’d love to answer any additional questions you have – feel free to send them to me personally.

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

ProjecTools Videos, Demos, and Webinars

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.

3 Ways to Treat Project Chaos

Get a grasp on how project devolves into chaos and see 3 sure fire ways to treat them and defeat project chaos.

3 Ways To Treat Project Chaos

Oil & Gas Construction GuyIn large Oil & Gas and EPC projects there is a ton of money on the line. The difference between a successful project, and an unsuccessful one is often the effective organization of the projects from FEED to Handover. The right project management infrastructure can help teams deliver capital projects with normal amounts of cost growth and schedule variance (typically ~10%). Alternatively, there is project chaos.  And in an industry that has a median cost growth of 24% and median schedule slip of 20% – this is the most common scenario. Effective project management requires the right systems and infrastructure to support it but that’s just a drop in the bucket.  Effective project management can reduce cost growth by 58% and schedule variance by 50%. Yes, project chaos is avoidable.

So how do you get from project chaos to order?  You’re in luck, this is our specialty, and there are 3 key ways to treat project chaos.

Stop using emails, spreadsheets and homegrown systems to manage projects. Have you ever wasted time digging through an email chain looking for critical information, or poured over somebody else’s spreadsheet trying to find what you need? Most folks have and those are just small examples of how ineffective spreadsheets, emails, and homegrown systems are. So quit using systems that provide little organization, accountability, and visibility – they allow project management chaos to flourish.
Get all of your teams working in the same system. Centralize. Collaborate. Have you ever been roadblocked by rouge teams, partners, or contractors using a different system? This happens in almost every project, and can be a tough situation to navigate. By implementing an effective, web-based project management system you can provide the most up-to-date data to all project stakeholders, in a single system. When the end game is reducing project chaos – you need to get everything in one place and everybody working in one system.
Enforce standardization. Ever encountered confusion due to multiple numbering systems or naming conventions? If you have, you know that this inconsistency makes it hard to track progress, report, and find the data you need. An effective project management system will allow you to track and enforce your numbering system, as well as partners, suppliers, or owners.  To prevent project chaos and enforce standards, start using an application that has defined numbering systems and naming conventions.  You might not realize how much project chaos is weighing you down.

If you, or someone you know is experiencing project chaos – please contact ProjecTools as soon as possible.  Symptoms include:  lack of reporting, cost growth of more than 10%, schedule slip of more than 10%, premature graying in management, lack of return customers, and many more.

The side effects of successful project management with ProjecTools include:  more sleep at night, promotions, an increase in profitability, more time, and more effective reporting.

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

ProjecTools Videos, Demos, and Webinars

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.

Capital Project Challenges

Operating with inefficient processes and lack of accountability within projects causes increased man-hours, schedule slippages and the inability to identify and track project issues. ProjecTools allows users to enforce workflows across disciplines such

Capital Project Challenges and Consequences

Oil & Gas, Energy, and Capital construction projects are among the most complex in the world. They deserve more attention to detail than spreadsheet-based project management systems can give. That is why it is important to address the most fatal capital project challenges and consequences before they cripple your projects.

Engineering-centric projects (Oil & Gas, Engineering Procurement Construction, Architecture, Capital Construction, Aerospace, Etc.) face constant change and a competitive global market. To stay current and drive growth, companies must overcome relentless capital project challenges and consequences, including:

Lack of a Standardized, Enforced Workflow

Operating with inefficient processes and lack of accountability within projects causes increased man-hours, schedule slippages and the inability to identify and track project issues. ProjecTools allows users to enforce workflows across disciplines such as procurement, commissioning, etc. The end result is that managers and executives can efficiently track performance down to individual user’s tasks, generate invaluable reports (late action, discipline progress, status, and earned-value) to prevent financial loss, keep schedule, and maintain accountability.

Inaccurate and Incomplete Data

Poor communication and lack of organization are core capital project challenges that prevent success. Missing data, incomplete data and inconsistent reporting errors produce confusion, project delays, and lost credibility with clients as consequences. ProjecTools enforces workflows and ensures no steps are skipped or repeated unnecessarily and allows users to communicate consistently with clients. A central document repository and system-enforced processes prevent information mismanagement and loss. Leverage previous project knowledge, structure and experience to develop effective, efficient, repeatable processes with ProjecTools.

Inability to scale

Spreadsheets and siloed departments lack the flexibility, scalability and consistency required by today’s Oil & Gas asset owners and operators. These limitations lead to profit-killing mistakes that devastate reputations and paralyze company growth. ProjecTools provides scalable and proven project management tools to satisfy even the largest and most demanding client needs.

Poor Access to Information and Data

Today’s complex projects span the globe with team members and contractors in multiple locations and time zones. The consequence of using an outdated system that can’t accommodate is delayed access to project information and missed deadlines creating serious obstacles to successful project completion. ProjecTools web-based system gives users real-time access to the project information they need whenever they need it.

Capital Project Management Trends

Technical complexity and increased government regulation require companies to be more vigilant than at any time in history. In this era of costly litigation and skyrocketing compensatory and punitive judgments, firms must be able to

Capital Project Management Trends

Oil & Gas, EPC, Rngineering, Construction, Architecture, and Infrastructure projects are changing. You can either adapt and prosper or get left behind.

Capital project management trends include increasing technical complexity and increased government regulation. This requires companies to be more vigilant than at any time in history. In this era of costly litigation and skyrocketing compensatory and punitive judgments, firms must be able to prove each team, supplier, and subcontractor has performed responsibly and consistently throughout execution.

Superior risk management is attained through standardized and controlled processes, which provide precise auditable results. Any authorized member of your team can use ProjecTools to access and report project information. Whether your project spans multiple countries or just one, is on land or offshore, uses dollars or euros, ProjecTools software gives you the tools to efficiently and successfully manage today’s complex project landscape to deliver superior quality, safety, and profitability.

Globalization is another capital project management trend that greatly affects the quality, schedule, and profitability of projects. Project managers are leveraging teams spread across the globe because they are great in terms of diversity of experience, problem solving and initial cost estimate. These project managers are finding a major gap in the strategy, however. The gap arises from the fact that globalization of teams, professionals, and supply chain has outpaced the tools that integrate these teams. This is making way for costly situations where engineers are working on the wrong things, suppliers are working from superseded revisions, and progress and status reporting is left to the individual units. These are what we call siloes. The result of these siloes is confusion that creates rework, duplicated effort, delays, overruns, change orders, and other profitability killers.

ProjecTools software is the only capital project management software in the AEC/PPM market that was built to specifically address complexity, risk management, and globalization challenges. The system does so by integrating all project information and teams into a single system to eliminate the siloes, confusion, and disorganization that hurts project performance.

Leverage ProjecTools industry expertise to buck the capital project management trends and mitigate risk to stop losing profit to avoidable project management challenges.

Request a personal demo of ProjecTools – the most reliable, efficient project management tool that understands capital project management trends.

AEC PPM Software Buyer Guide

When low price is the primary factor in choosing an application, the old adage “You get what you pay for” usually rings true. It’s easy to approach software with a low price mentality. Don’t do it!

10 Fatal Mistakes of AEC/PPM Byuers

Shopping the AEC/PPM Software market is usually driven by legitimate, pressing problems that need to be solved. Schedule slippage, cost growth, and preventable stoppages in production may tempt you to settle for applications that look good but just don’t deliver.

Be the hero, not the goat, by avoiding these ten common mistakes buyers in the AEC/PPM Market make.

View PDF Version

Focusing on price rather than value

When low price is the primary factor in choosing an application, the old adage “You get what you pay for” usually rings true. It’s easy to approach software with a low price mentality. Don’t do it! Step back and make sure the application will solve your problems and add value to your company before signing a contract. After all, it’s easier to deal with price once than to suffer with poor quality forever.

Insufficient due diligence

Buying software that will change the way you do business is a big deal. Improperly vetting customer support, reputation, financial viability, innovative ability, and integrity of your software partner will lead to a painful (possibly fatal) software purchase.

Hidden costs

You couldn’t see the hidden costs because they were… hidden. We get it.
These hidden costs can be avoided by proper due diligence. Take extra care to read the service agreement. Pick up the phone and call the references provided by the sales team. Heck, even call other users that aren’t on the reference sheet.

No roadmap or growth plan

If an application works like you need it to work, you will be solving real problems and creating real value for your company. Chances are you are going to want to roll it out to more divisions or company-wide. To avoid unexpected jumps in price, make sure to get pricing for plausible growth scenarios from years two through five.

Focusing on technology and features rather than solving business problems

Don’t let this be you. Always have your problems and objectives in mind. Don’t get distracted by bells, whistles, and unproven technology. This seems like a simple concept, but we hear of this mistake time and time again.

Settling for software that requires major customizations

A blank slate can sound nice, but not in the context of business-critical software. Extensive customization is expensive, time consuming, and slow to be delivered. If an application has your key functionality already – go with it. The customization route spells money, anguish, and uncertainty.

Lacking industry experience

There is great risk in being the guinea pig for any software vendor trying to branch into a new vertical where they have no expertise or experience. Your business is too important for that. Find a software application that is proven in your industry.

Overlooking integrations with other business-critical applications

If a software company can’t or won’t deliver a key product integration, whether the integration is with Dynamics, Salesforce, Oracle, SAP, or a legacy database from 1983, look elsewhere. This is not 1998 – your applications need to work together.

Underestimating training & implementation needs

Can your team leverage your new tools, without adequate training? Probably not. Is the software partner willing and able to thoughtfully map out and deliver meaningful training and implementation that will make your power users and your casual users successful? Do they offer a train-the-trainer approach, so your on-staff experts can bring your other team members up to speed?

Culture doesn’t change with the new application

Not everyone on the team will be in love with a new application, or welcome any change whatsoever. It’s important to recognize this. Nothing can rally a team around a new application like strong leadership and executive buy-in. Make sure your executive team will help lead the charge.

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

ProjecTools Videos, Demos, and Webinars

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.

Standard Project Management Features

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

ProjecTools Standard Project Management Features

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability and further integrate project teams and information.

View PDF Version

Standard Project Management Features of ProjecTools Software

Administration Manager

ProjecTools Administration Manager allows instance administrators to configure and maintain project settings. Manage users, permissions, numbering formats, and other configurations to ensure standard processes and proper execution.

Key Features:

  • Maintain global and project address books
  • Create and manage projects and users
  • Define global and project user permissions
  • Apply configurations and components from other
    projects
  • Define numbering formats and naming conventions for:
    – Project – Transmittals – Purchasing – Documents
    – Correspondence – Work Breakdown Structures

Time and Expense Tracking

ProjecTools Time and Expense provides time logging and management infrastructure to ensure project control. Teams can log time and expenses and management can review, approve, report on labor and expenses. Management teams can define thresholds.

Key Features:

  • Log time and expenses online
  • Define and enforce approval workflows
  • Ensures time is logged to valid budget items
  • Ensures budget adherence
  • Produce detailed reports by staff, budget item(s), change order(s), CTR(s), etc.
  • Integrate with cost and accounting*

*Financial Interface integration required

Action Items

ProjecTools Action Items provides users and administrators tools to create, assign, and report on action items to promote meaningful dialogue and maintain accountability. Action items are assigned to specific users, communicated through the task manager, and overseen by the action items coordinator.

Key Features:

  • Maintain Project Action Item and HSE Registers
  • Tracks action item progress and closeout
  • Maintains personal responsibility and schedule adherence
  • Refer to resolutions in the Project Decisions Register
  • Engage clients in HSE dialogue

Performance Analyzer

ProjecTools Continuous Improvement provides convenient tools to submit lessons learned to facilitate continuous improvement, best practices, and knowledge share.

Key Features:

  • Maintains Lessons Learned Register
  • Tracks due dates and responsible parties
  • Maintains personal responsibility and top-down visibility

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.

ProjecTools Videos, Demos, and Webinars

Pipeline Project Case Study

The Contractor needed a way to manage deliverables of the remote engineering subcontractors. To do this they employed ProjecTools Documents to house all engineering and technical documents for the pipeline. The remote engineering companies would log into ProjecTools application and execute revisions that came

ProjecTools Pipeline Project Case Study

Pipeline Engineering and Construction Project

The Pipeline Contractor used ProjecTools application to manage engineering/design and cost for the 1500+ mile pipeline. The engagement began when the contractor acknowledged that a key to maintaining profitability in this competitively priced project was to outsource much of the Engineering to more cost-effective labor markets and keeping a close eye on the project cost. In this pipeline project case study we’ll examine how choosing to manage the cost and engineering/design in ProjecTools cloud application:

  • Allowed the contractor to effectively integrate the global engineering team
  • Allowed complete visibility into the remote engineering/design team’s performance
  • Ensured each team member, regardless of physical location, was working from the latest approved revision
  • Allowed the contractor to improve cash flows by tracking document progress and status to bill for completed work sooner.
  • Allowed the cost control team to regularly report on project cost at discipline level, keeping the project in control

Lets take a look at the specific functional uses of ProjecTools in this Pipeline Project Case Study

View PDF Version

Functional Uses of ProjecTools on this Project

Documents

The Contractor needed a way to manage deliverables of the remote engineering subcontractors. To do this they employed ProjecTools Documents to house all engineering and technical documents for the pipeline. The remote engineering companies would log into ProjecTools application and execute revisions that came to each engineer as tasks. In these tasks the engineers could download, markup, comment and upload the revised file(s), and submit the task. ProjecTools application returned the work to the document controller who sent the new revision to the appropriate engineering supervisor or manager for review comment and approval. This automated cycle continued until the documents were approved for construction.

Throughout this iterative engineering/design process, managers and supervisors at the contractor company had visibility into the progress and status of each document. They could also pull late action reports from the application to identify the highest performing remote engineers. This reporting allowed them to keep the engineering/design on track and maintain personal accountability for the work that was done.

Cost Control

The contractor needed a way to manage project cost and log actuals, commitments, and forecasted costs against the appropriate WBS. ProjecTools cost control allowed the contractor to define a WBS that made sense for the project and track project costs against the budget baseline. This process improved accuracy, resource allocation, and reporting for project costs which the contractor identified as issues they faced in the past.

ProjecTools application also allowed the cost control team to track document progress and feed the progress back to ProjecTools Cost Control. With a click of a button, the progress in document manager would sync over to Cost Control, allowing Cost Control to notify Accounts Receivable that billable progress had been made. This simple automation step reduced time spent in progress and status meetings by 70% compared to similar projects by eliminating the use of disjointed spreadsheets, which meant consistently impressing the client with real time progress and status of the project.

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

ProjecTools Videos, Demos, and Webinars

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.

Construction Project Management Services

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Services (AKA ProjecTeams)

ProjecTools teams are for Oil & Gas, EPC, Engineering, and Capital Construction that are looking beyond the traditional temp-style staffing arrangement. Your projects are important and you need better than temps that require tons of costly training. You need project experts with experience, passion, and knowledge to make your projects more successful that can step in and pick up slack at a moments notice.

The ProjecTeams group comprised of immensely talented individuals from all project disciplines that will support your project on-site or remotely. With scalable, on-demand ProjecTeams you can avoid the waste associated with adding full-time staff to address short-term demand. Our teams are experts, so you don’t have to worry about extensive training. Simply plug our team into your process and we dig in, saving you anywhere from $20,000 to $50,000 USD per team member.

View PDF Version

Project Staffing

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

As key members of ProjecTools software company, the ProjecTeams staff are never rusty or gathering moss. We always have work – either deployed on project work or in ProjecTools Software segment. This unique competitive advantage

means you can affordably scale up or down according to project demand. ProjecTeams highly motivated staff will plug into your project for short-term (daily/weekly) or long-term engagements with little or no training required. Forget costly deals and staffing or temp agencies with expensive training and onboarding. Never again hire long-term staff for short-time work.

ProjecTeams has resources to support the following project functions from execution level to management level.

Document ControlHealth, Safety  Environment / HSECost Control
ConstructionProject ManagementAdministrative Services
Quality SurveillanceCompletionsProcurement / Purchasing
Supplier Doc ControlSchedulingEngineering

Consulting

ProjecTeams Consultants are experts that look at your process and examine the flow and processing of information in your project. We uncover gaps, breakdowns, and opportunities to increase effective use of time as well as visibility and accountability in the workplace.

We approach an engagement with the right lenses. We examine how process improvement can improve project execution. We expose project processes that kill schedule and budget. We encourage project processes from human impact and quality-of-life perspectives. This multi-lens approach reveals problems affecting your project, client, and teams. We then bring you our findings and work with you for effective and efficient resolution, focused on an approach to fit your values and resources.

ProjecTeams consulting guarantees value to projects and delivers on that guarantee with expertise and experience to tackle any project management process problem.

Application Training

Using software applications is like driving a car – success depends on training and practice. To ensure your teams are road-ready with ProjecTools application, the ProjecTeams staff delivers in-person or remote training that equips end-users with the skills they need to win.

Courses are tailored to groups of no more than ten students to create an intimate solution-focused training environment that ensures each graduate is confident and competent to perform their tasks in a live project environment.

Training varies in length from half-day to multiple day courses. Some end-uses attend multiple courses depending on their role.

Application Implementation

ProjecTools application is powerful, robust, and flexible. ProjecTools Implementation teams bring the knowledge and skills to work with your teams to configure the application to enhance your processes and deliver the most value to your project, personnel, and clients. Similar to consulting, the implementation staff can reflect your existing processes in the tool or enhance your processes to better leverage the tool and improve project processes. It is up to you how far you want our implementation to take your project and team, but we assure you the only thing holding you back from a stellar implementation and better work processes will be resistance to change and and organizational inertia.

ProjecTools Product Information

  • 817

ProjecTools Client Spotlight

September 24th, 2015|0 Comments

ProjecTools Client Spotlight "I don't see how companies can manage projects like [...]

  • 568

Standard Project Management Features

September 2nd, 2015|0 Comments

ProjecTools subscriptions provide valuable standard features that support projects. ProjecTools standard features are available to each user to complement core application functions and business processes. Utilize the modules below to increase top-down visibility, communication, accountability

  • 545

Security and Reliability

September 1st, 2015|0 Comments

Users need a secure, reliable environment to access project information and perform work. All applications and client data resides in a private cloud network with data replication and failover to geographically diverse datacenter equipment. ProjecTools provides 99.5% Network Availability

  • 492

Construction Project Management Services

August 31st, 2015|0 Comments

ProjecTeams is proven for flexible on-site or remote project deployments. Each ProjecTeam specialist has deep work history with a career of improving project execution, information management processes, with tools that make projects efficient, timely, and profitable.

ProjecTools Resources

  • 1872

Spreadsheets and Email as Project Management Tools

March 9th, 2017|0 Comments

Projects have too many moving parts and too many players to be trusting critical data to spreadsheets and emails. You need a spreadsheet reduction strategy.

  • 1811

Project Management Assessment

November 15th, 2016|0 Comments

Project Management Assessment Assess your project management practices against the best project execution teams in the Capital Construction, [...]

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1357

Aligning Document Control and Cost Control

February 15th, 2016|0 Comments

Align Document Control with Cost Control and create seamless progress and earned value reports to stay on budget and improve cash flows.

ProjecTools Videos, Demos, and Webinars

  • 1519
  • Review and Approvals

Optimizing Review and Approval Processes for Engineering

October 14th, 2021|0 Comments

Let’s talk about review and approvals, and closed-loop systems, and how to execute the review and approval processes for engineering and commercial...

  • 1567
  • Document Management

The Keys to Successful Document Management

November 23rd, 2020|0 Comments

Let's talk specifically about document management software, and the key factors for clean and organized documentation, accessibility, finding a system...

  • 1716
  • Review & Approvals

Document Management Software ROI

October 5th, 2016|0 Comments

Document management is massively important for engineering and construction projects. Take the approach and use the tools that add the most value.

  • 1631

Document Distribution and Access for EPC and Construction

August 24th, 2016|0 Comments

Global projects have global teams that need to be in the loop. Cloud technology takes the pain out of giving teams on demand access to project data.