Let’s face it, blog posts about spreadsheets are about as engaging to read as spreadsheets are fun to use, but there’s a movement happening right now with construction technology and software solutions looking to pull the industry out of static spreadsheet systems like Microsoft Excel or Lotus 1 2 3. The reason for that is very simple. Excel is an incredibly powerful tool and it’s very simple to use at a basic level, just not both at the same time. It’s like giving an average golfer the best set of clubs and expecting them to hit the ball like a pro, when in reality they’re just going to be capable of slicing the ball even farther in the wrong direction.
Now imagine in that scenario you’re the average golfer, but instead of being given the best set of clubs to use, you have to build them first.
There are horror stories, Forbes has written about billions of dollars being lost due to non-integrated, untested spreadsheets that get copied and pasted together. They go so far as to say Excel specifically might be the most dangerous software on the planet. Fortune also writes that Excel is ‘ruining the world’, but while billions of dollars being lost isn’t a consistent problem for every general contractor using a spreadsheet, for almost all of them, significant errors certainly are.
These are the areas where spreadsheet systems fall short and will continue to let down the construction industry.
This is the big one. Anyone can create a spreadsheet, which means anyone can create a spreadsheet badly. In many cases, new spreadsheet systems are built by one person to replace old spreadsheet systems that became too highly personalized because they were built by one person, rinse, and repeat. In a survey of MBA spreadsheet users it was discovered that 72% had no company standards or policies for spreadsheet architecture and upkeep. How is Excel responsible for human error? Well, it’s important to remember that spreadsheets offer no way to test and ensure everything has been built correctly. Research from Raymond Panko, of the University of Hawaii, suggests that 88% of spreadsheets have significant errors in them and won’t indicate in any way that they’re broken, it will just continue to show the wrong data. Errors as simple as inconsistencies with employee titles (we’ve seen spreadsheets with six different spellings for project managers like: Project Managers, PM, P M, etc.) can lead to data falling through the cracks, and meaning people falling through the cracks when it comes time to create a manpower plan.
The most common method used for testing spreadsheets? Common sense, at 67%.
“In large spreadsheets with thousands of formulas, there will be dozens of undetected errors.”
— Ray Panko, Professor of IT Management at the University of Hawaii
Not built for collaboration
With the widespread growth in the use of networks and cross-functional teams in construction, sharing spreadsheets has become routine practise and yet controls around sharing have never caught up. Spreadsheets have become the foundation of most construction workforce and project planning processes. 90% of workplace spreadsheets have more than one user – those users will make around 40% of the modifications to those spreadsheets with no audit trail to see who made what changes.
Out of those surveyed, the most common method used to protect their spreadsheet? None, at 73%.
Since there’s no way to test spreadsheets, construction companies continue to use error-prone systems that are only legible to the original creator of the spreadsheet. We’ve heard numerous operations managers joke that they can never retire because “no one else can read their spreadsheets.” On top of that, under 40% catalogue or archive spreadsheets. It’s become a vicious cycle where less than 10% of spreadsheets become a permanent asset. New spreadsheets are created to replace old spreadsheets – but it’s all being done with the same tool. Albert Einstein said it best: “The definition of insanity is doing the same thing over and over again but expecting different results.”
“Chainsaws are also a very good tool, but who would use one without a chain guard. People don’t take safeguards to ensure their work is correct.”
— Patrick O’Beirne, European Spreadsheet Risks Interest Group
With no specific company guidelines for spreadsheet construction, the result is the “designer” tends to ignore the importance of structured and well-designed code, which ultimately catches up to them when the time comes for data collection and consolidation. Making project decisions based on accurate data and analysis becomes impossible, forcing operations teams to make high-level project decisions based on “gut feel” instead of hard data, simply because access is too difficult to navigate quickly and accurately. Time is also money. Wasting time navigating between multiple spreadsheets during a manpower meeting is costly to any general contractor. In fact, the Harvard Business Review released a study in which they surveyed top executives about strategic meetings and how effective they are, “their meetings often fail to produce both the quality and quantity of decisions required to drive superior performance.” Being able to communicate necessary information in a way that is easy to engage with leads to more time spent on planning and making strategic decisions to move the company forward.
90% of spreadsheets are used for data analysis – a major part of that is picking up on trends to better predict company needs in the future. For construction, that means being able to visualize, in an instant, where a new project can fit in with the company’s timeline and the impact it will have on their workforce needs. It also means being able to see the impact of changes made to current projects and how that will affect day-to-day processes and allocations. Spreadsheets offer a place to store data, but unfortunately, seeing the impact of that data clearly and concisely is where those systems continue to fall short.
The problem facing construction companies when it comes to software solutions is the same reason construction is so adaptive and able to thrive in the first place – every project is different than the last. The level of customization required for a spreadsheet system to fill all of the unique demands of the industry is almost impossible even for a skilled Excel architect. It’s the same reason construction was overlooked by the software community for so long – it requires dedication to the industry.
Some software solutions have been built, but to service as many industries as possible – great tools that service a lot of different markets because the level of customization required from industry to industry is minimal. For construction that means you’re forced to make it work, leading to it ultimately becoming as equally frustrating to communicate as a spreadsheet.
Bridgit Bench, on the other hand, was built from the ground up for construction workforce planning. Error-free data with permissions to make changes or view only. A living, breathing system that updates in real-time to enable collaboration at every stage of the project lifecycle with a dynamic dashboard to help visualize your most valuable workforce data, and people and project gantt views built to be the new foundation for manpower meetings.