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
Types of building sensors on BD
From biometric to electrical current, chemical and more.
Government mandates detectors in rented homes
Changes are due to come into force on 1st October 2022.
80% of major government projects are rated red or amber
Heed advice and insight of this report IPA tells the government.
The end of the games but continued calls for action
From the Commonwealth Association of Architects.
CIOB respond to the government call for evidence
For the Levelling Up, Housing & Communities Committee.
How are buildings and their occupants responding to extreme heat?
BSRIA's Technical Director reflects on recent weather patterns.
Landownership in England in 1909
A national valuation to fund old-age pensions.
The world’s largest Commonwealth memorial to the missing.
Long after the end of the defects liability period.
BSRIA Occupant Wellbeing survey BOW
Occupant satisfaction and wellbeing in buildings.
Geometric form and buildings in brief
From the simple to the complex.
Understanding the changing nature of insulation
And the UK Government guidelines.
Three year action plan to improve equity, diversity and inclusion
Commitment agreed to by major built environment bodies.
The Construction Route – what needs to change?
Electrical skills, low carbon, high-tech and the building services revolution.
Deep geothermal power possibilities
Ultra-deep drilling with millimeter-wave beam technology.
BSRIA Briefing 2022- From the outside looking in
Looking at the built environment from space.
Competence requirements for principal contractors and designers
BSI standards 8671, 8672 and 8673.
Bringing life to burial grounds.
From failed modernism to twenty-minute neighbourhoods.
Design chill and design freeze
The gates process and change control.
Neuroscience for project success
Why people behave as they do. APM book.
Comments
Unfortunately this sounds like marketing.