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
Deputy editor of AT, Tim Fraser, discusses the newly formed society with its current chair, Chris Halligan MCIAT.
Barratt Lo-E passivhaus standard homes planned enmasse
With an initial 728 Lo-E homes across two sites and many more planned for the future.
Government urged to uphold Warm Homes commitment
ECA and industry bodies write to Government concerning its 13.2 billion Warm Homes manifesto commitment.
Places of Worship in Britain and Ireland, 1929-1990. Book review.
The emancipation of women in art.
CIOB Construction Manager of the Year 2025
Just one of the winners at the CIOB Awards 2025.
Call for independent National Grenfell oversight mechanism
MHCLG share findings of Building Safety Inquiry in letter to Secretary of State and Minister for Building Safety.
The Architectural Technology Awards
AT Awards now open for this the sixth decade of CIAT.
50th Golden anniversary ECA Edmundson awards
Deadline for submissions Friday 30 May 2025.
The benefits of precast, off-site foundation systems
Top ten benefits of this notable innovation.
Encouraging individuals to take action saving water at home, work, and in their communities.
Takes a community to support mental health and wellbeing
The why of becoming a Mental Health Instructor explained.
Mental health awareness week 13-18 May
The theme is communities, they can provide a sense of belonging, safety, support in hard times, and a sense purpose.
Mental health support on the rise but workers still struggling
CIOB Understanding Mental Health in the Built Environment 2025 shows.
Design and construction material libraries
Material, sample, product or detail libraries a key component of any architectural design practice.
Construction Products Reform Green Paper and Consultation
Still time to respond as consultation closes on 21 May 2025.
Resilient façade systems for smog reduction in Shanghai
A technical approach using computer simulation and analysis of solar radiation, wind patterns, and ventilation.
Comments
Unfortunately this sounds like marketing.