Excel and construction
Contents |
[edit] Introduction
At a time when data has the power to make or break organisations, having the right tools for managing projects, sites or the organisation as a whole – is paramount.
Audits have shown that nearly 90% of spreadsheets with more than 150 rows include errors; with a 1 in 50 chance of each individual cell containing an error. Large spreadsheets used for construction management, consisting of hundreds and thousands of cells may contain a high level of inaccuracies.
There are alternatives however, in the form of off-the-shelf software systems that can help with this, giving improved performance throughout a project.
[edit] How software tools compare
[edit] Precision
Many organisations can cite a time when spreadsheet mistakes led to poor decision-making. Software tools with specific data-entry and manipulation functions minimise user error considerably.
[edit] Integration
Excel doesn't integrate well with new management software systems. Specific construction industry software directly integrates with many popular software systems, eliminating the need to manually enter data.
[edit] Remote working
Most construction software available today is run using cloud-based software, meaning data is not tied to one computer and can be accessed, amended and updated from anywhere. This makes data entry more streamlined and allows all users to access live data.
[edit] Support
Unlike Excel, specific construction software tools are often created and managed by teams of qualified construction professionals, enabling quick troubleshooting and effective timely support.
[edit] Security
When collaborating between departments and/or other organisations, constant emailing of spreadsheets leaves open the possibility of hacking. Cloud-based software tools with multiple users reduce the risk of potentially sensitive information being hacked.
With so many evident benefits to using specifically-designed construction software tools it is certain they will play an increasingly important role in improving the efficiency and performance.
This article was originally published as 'Construction and Excel - an average formula' by BRE Buzz on 7 Dec 2016. It was written by Harriet Cooper.
--BRE Buzz
[edit] Related articles on Designing Buildings Wiki
- BRE Buzz articles on Designing Buildings Wiki.
- Bill of quantities software.
- Building management systems.
- Common data environment.
- Computers in building design.
- Computers in the management of construction.
- Construction project management software.
- Information and communications technology.
- Information and communications technology (ICT) consultant.
- Internet of things.
- Project extranet.
- SiteSmart.
- Top big data tools used to store and analyze data.
- WiFi.
Featured articles and news
Professional practical experience for Architects in training
The long process to transform the nature of education and professional practical experience in the Architecture profession following recent reports.
A people-first approach to retrofit
Moving away from the destructive paradigm of fabric-first.
International Electrician Day, 10 June 2025
Celebrating the role of electrical engineers from André-Marie Amperè, today and for the future.
New guide for clients launched at Houses of Parliament
'There has never been a more important time for clients to step up and ...ask the right questions'
The impact of recycled slate tiles
Innovation across the decades.
EPC changes for existing buildings
Changes and their context as the new RdSAP methodology comes into use from 15 June.
Skills England publishes Sector skills needs assessments
Priority areas relating to the built environment highlighted and described in brief.
BSRIA HVAC Market Watch - May 2025 Edition
Heat Pump Market Outlook: Policy, Performance & Refrigerant Trends for 2025–2028.
Committing to EDI in construction with CIOB
Built Environment professional bodies deepen commitment to EDI with two new signatories: CIAT and CICES.
Government Grenfell progress report at a glance
Line by line recomendation overview, with links to more details.
An engaging and lively review of his professional life.
Sustainable heating for listed buildings
A problem that needs to be approached intelligently.
50th Golden anniversary ECA Edmundson apprentice award
Deadline for entries has been extended to Friday 27 June, so don't miss out!
CIAT at the London Festival of Architecture
Designing for Everyone: Breaking Barriers in Inclusive Architecture.
Mixed reactions to apprenticeship and skills reform 2025
A 'welcome shift' for some and a 'backwards step' for others.
Comments
Unfortunately this sounds like marketing.