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
The UK's Modern Industrial Strategy: A 10 year plan
Previous consultation criticism, current key elements and general support with some persisting reservations.
Building Safety Regulator reforms
New roles, new staff and a new fast track service pave the way for a single construction regulator.
Architectural Technologist CPDs and Communications
CIAT CPD… and how you can do it!
Cooling centres and cool spaces
Managing extreme heat in cities by directing the public to places for heat stress relief and water sources.
Winter gardens: A brief history and warm variations
Extending the season with glass in different forms and terms.
Restoring Great Yarmouth's Winter Gardens
Transforming one of the least sustainable constructions imaginable.
Construction Skills Mission Board launch sector drive
Newly formed government and industry collaboration set strategy for recruiting an additional 100,000 construction workers a year.
New Architects Code comes into effect in September 2025
ARB Architects Code of Conduct and Practice available with ongoing consultation regarding guidance.
Welsh Skills Body (Medr) launches ambitious plan
The new skills body brings together funding and regulation of tertiary education and research for the devolved nation.
Paul Gandy FCIOB announced as next CIOB President
Former Tilbury Douglas CEO takes helm.
UK Infrastructure: A 10 Year Strategy. In brief with reactions
With the National Infrastructure and Service Transformation Authority (NISTA).
Ebenezer Howard: inventor of the garden city. Book review.
The Grenfell Tower fire, eight years on
A time to pause and reflect as Dubai tower block fire reported just before anniversary.
Airtightness Topic Guide BSRIA TG 27/2025
Explaining the basics of airtightness, what it is, why it's important, when it's required and how it's carried out.
Construction contract awards hit lowest point of 2025
Plummeting for second consecutive month, intensifying concerns for housing and infrastructure goals.
Understanding Mental Health in the Built Environment 2025
Examining the state of mental health in construction, shedding light on levels of stress, anxiety and depression.
Comments
Unfortunately this sounds like marketing.