Why You Should Stop Using Spreadsheets in Construction Projects

stop sign over a laptop with spreadsheet

Since the invention of Excel, the spreadsheet program has been used as a tool to run construction projects. While it is extremely useful, spreadsheets do not have the capability to ensure smooth operations in construction, due to the complexity involved. In order to secure profit, construction expenses must be within budget, and contractors rely on these spreadsheet-generated reports to make multi million dollars’ worth of decisions.

However, despite its many capabilities, using spreadsheet program is not good enough for construction projects for the following reasons:

1. Potentially Inaccurate and Delayed Reports

inaccurate spreadsheet

To make good decisions that have high-value impact (millions of dollars), contractors need accurate and real-time information. However, spreadsheets will only generate reports when the user inputs data; the data is not automatically collected, processed or even displayed. The user will have to perform such tasks manually. This means that the generated report is not done in real-time, which may not reflect the current conditions. With manual and delayed input, there is a high risk of inaccuracy in the data, which would then be detrimental to contractors who need to make crucial decisions.

2. Ineffective and Minimal Collaboration

person confused by multiple spreadsheets handled to him

Collaboration between stakeholders is key to a successful construction project. However, using a spreadsheet program will result in the information being stored on one computer and thus, hinder the collaboration between the site and office. On the other hand, using an online spreadsheet program such as Google Sheets may lack the capabilities available in the desktop version of Microsoft Excel, which are superior.

With the information only available on one computer and dependent on the user to distribute to other stakeholders in a timely manner, mistakes are bound to happen due to poor communication between site and office. Poor collaboration and communication also can cause reduced accountability, where it may be unclear whose responsibility it is to ensure construction projects stay within its budget. Ultimately, the risk of losses will become too high.

3. Highly Dependent on Manual Entry

manual entry of spreadsheets

Managing spreadsheets involves a lot of manual work, and updates may not be timely. In fact, it may be delayed until absolutely needed. Besides manual updates, maintaining spreadsheets involves a lot of manual entry, where it is the user’s responsibility to ensure accurate data is entered. This is when the user will spend a disproportionately large amount of time to verify their data and find the source of a mistake.

4. Error-Prone in Over 85% of Excel Spreadsheets

different versions of spreadsheet files

In an effort to foster collaboration among stakeholders, some users resort to sharing a spreadsheet file between different departments. This will definitely lead to different versions of the same report, which then takes up additional time and effort to reconcile the information so that the final version is reliable.

When there is an issue with a spreadsheet-generated report, the source of the problem is not identified immediately. Manual investigations will take time. If it takes too long to find the source of the error, it will be already too late.

The decision maker needs good data to make a decision. This is unachievable when a decision is made based on unreliable data. The decision maker will not be able to verify the information provided to them, and will have to wait and depend on the employee to verify instead. In urgent cases, the decision maker will be forced to make assumptions based on unreliable data.

5. Inaccessibility

spreadsheet files taking a long time to transfer

The person responsible for producing the report will have the file saved in their computer, and this person is not the decision maker. It is the employee then who will have to ensure the decision maker receives the correct file in a timely manner. More often than not, this will hinder both the decision maker and the employee’s work, as requests for update or information may happen at any time, and with the access only available to one person, it will result in a delay.

How Can Contractors Manage Projects Without Using Excel Spreadsheets?

It is important to remember and consider these factors when choosing the right tool to manage your construction projects successfully:

  • Accurate, real-time data

  • Seamless collaboration between office and sites

  • Full accessibility and convenient

  • Real-time flagging of critical issues

As such, it is important to consider good building construction software, especially those that are built based on the aforementioned principles. Speedbrick offers a few construction software products that help contractors to improve their workflow, from procurement and business analytics, to subcon management and revenue tracking. Speedbrick’s products ensure all stakeholders have the necessary access to the information needed, as well as the accuracy of the information presented. Moreover, decision makers will receive real-time updates and quickly identify and mitigate the risks in the projects they handle. By using the right construction software, the digital transformation of your construction business will be smooth and worth the ROI.

If you’re interested in any of our solutions, please schedule a free demo with us today!

See Speedbrick in action

Schedule a free demo with us to see how we have served projects worth more than RM13.2b, and achieved 99% client satisfaction along the way.

Top 6 Challenges Malaysian Contractors Will Face After MCO

workers facing issues at contruction site

As of February 2021, Malaysia is now a few weeks into its second Movement Control Order (MCO) as a result of the COVID-19 pandemic. It is unclear when the MCO will end. Even after the restrictions have been lifted, life will never be the same as pre-MCO times, especially in the construction industry.

In order to be successful, construction businesses will have to anticipate and adapt to new challenges.

Below are the top 6 challenges contractors will face post-MCO.

1. Stringent Workers’ Accommodation Requirement

workers dormitory

Due to several COVID-19 clusters originating from construction sites and factories, the government is seriously looking into curbing the source of COVID-19 spread—workers’ accommodation.

The Workers’ Minimum Standards of Housing and Amenities (Amendment) Act 2019 (“Amended Act”) is currently enforced together with the Employees’ Minimum Standards of Housing, Accommodations and Amenities (Accommodation and Centralised Accommodation) Regulations 2020.

What does this mean for contractors?

Contractors providing workers accommodation now have stricter laws and regulations to follow. Failure to follow such law is an offence; upon conviction, contractors will be liable to a fine not exceeding RM50,000 or to imprisonment for a term not exceeding 1 year or both.

This law includes obtaining “Certificate of Accommodation” from the Director General of Labour Department Peninsular Malaysia. The provided accommodation needs to fulfill certain requirements such as:

  1. to provide separate accommodation to employees of the opposite gender;

  2. to take necessary preventative measures to ensure employees’ safety and well-being;

  3. to ensure that the electrical wiring systems comply with safety requirements in accordance with the relevant written laws;

  4. to ensure that the employees receive the necessary medical assistance where necessary;

  5. to take preventative measures to contain the spread of infectious diseases as ordered by the Medical Officer of Health in accordance with the relevant written laws and the employer shall, at his own expense, make arrangements as ordered by the Medical Officer of Health so that all or any of the employees be given immunization against any infectious disease; and many more as listed in the Amended Act itself.

2. Price increase on raw material

stacks of rebar for construction project with graph showing increasing price trend

The pandemic severely disrupted the global supply chain, as of February 2021, raw material prices have increased by 30-40%. Contractors that have existing projects not only will see its profit being slash but potentially risk making a loss to complete the projects.

One may ask, can contractors go back to its client and ask for the client to take up the price increment?

This depends on the contract. The majority of the construction contract will entail “no changes on contract price regardless of raw material price fluctuation”. Contractually, contractors may not be able to ask for more money as a result of raw material price fluctuation.

3. Mandatory QLASSIC

stamping document for approval

In 2017, the Quality Assessment System in Construction (QLASSIC) was formed in a bid to measure quality within the sector. In 2019, the Works Ministry reiterated its commitment to making the QLASSIC certification mandatory for all upcoming developments by 2020, as outlined in the National Housing Policy 2.0 (NHP 2.0). This plan was partly disrupted by MCO, but soon enough, QLASSIC will be mandatory in all construction projects.

Stricter regulations will also be introduced to reduce accidents and injuries during projects. This will include ensuring all contractors who are bidding for projects will account for the extra cost needed to meet with health and safety requirements in their estimates.

In other words, contractors will face higher cost to do business.

4. Competition With Foreign Contractors

construction with red background

Beginning in 2009, our government began removing restrictions on foreign equity participation in various construction-related industries. As a consequence, this has attracted lots of foreign investors, especially those from China. Statistics by the Malaysian Investment Development Authority (MIDA) showed that China has taken over Singapore’s rank as the biggest investor in Malaysian real estate.

However, the attention from China has also paved way to an increase in foreign competition, stirring up unease in Malaysia’s construction markets. Based on the Construction Industry Development Board’s (CIDB) statistics, local contractors’ market share in value had consistently fallen year-on-year from 94% to 78% from 2006 to 2014.

“Of late, we are seeing more participation from Chinese contractors in the Malaysian market either directly or through joint ventures with local contractors. In our view, we think the edge that Chinese contractors have over other foreign contractors as well as our local ones is access to funding, cheaper labour, access to materials and fast turnaround construction period,” AllianceDBS Research opined.

The presence of Chinese contractors has sparked mixed views, no doubt forcing local contractors to become more competitive, driving many to up their game in efficiency and productivity. Some regard these foreign contractors as a threat because it is tough to compete with cash-loaded Chinese contractors. Not only are they richer than most contractors in Malaysia, but they also bring in materials and labour in droves from China, leaving many local contractors at a loss.

5. Shortage of Skilled Labour

construction labourer

As a result of the pandemic, many countries have closed their borders, making it harder to import skilled labour. Malaysian contractors rely heavily on foreign labour, so with the shutdown of the source of labour, the cost of labour has driven up as the country now faces a shortage of labour.

The ability to attract and retain the best talents always provides a company with a competitive advantage. But if this skilled labour shortage continues, contractors will be increasingly challenged to maintain superiority over competitors in the industry.

6. Technology Adoptionconstruction worker using technology in site

As businesses scramble to ensure their employees continue working, technology adoption has sped up within the construction industry. Most sectors, construction included, have also started practicing the work-from-home (WFH) concept. With employers and employees adapting to this new normal, it has become apparent that the WFH concept is here to stay even after MCO. One of the ways companies adapt to this new working condition is by adopting the necessary technology, including cloud-based software, integrated collaboration, and mobile project management.

In construction specifically, we will see a higher adoption rate of the use of building information modelling (BIM), industrial building system (IBS), laser scanning, and machine automation. BIM and IBS are becoming more commercially affordable.

Recognizing the contractors’ increasing need for technology specifically catered to the industry, Speedbrick offers several products for construction management, allowing contractors to manage their team and site efficiently in real-time, without needing to be on-site all the time.

The exorbitant upfront cost for technology adoption may not seem to be worthwhile in the beginning, but it is necessary and will be more cost-effective in the long run as multiple processes will be streamlined.

In a nutshell, the upcoming events/trends show that it will be tougher to be a contractor in the near future. It would be wise to prepare the business to be recession-proof, or at the very least, to be able to weather the challenging times ahead. However, businesses that successfully navigate this storm will be better equipped to capitalise on the recovery. Efficiency gained through the hard times would make businesses be more resilient and efficient; strengthening them for robust long term expansion.

See Speedbrick in action

Schedule a free demo with us to see how we have served projects worth more than RM13.2b, and achieved 99% client satisfaction along the way.

A Special Thanks to L2 Construction Series for carrying out 30 days of webinars during MCO period

handwritten thank you note

As the war against COVID-19 intensifies in Malaysia, the government of Malaysia has issued a restriction of movement that has essentially halted the operations of various businesses in Malaysia to limit the spread of the virus. On 16.3.2020, the Prime Minister, via a special message, issued the Restriction of Movement Order (MCO). 

 

Since then, the construction industry is left in dilemma, construction sites had to stop operating, hundreds of thousands in the industry had to leave their jobs and stay at home. Many were uncertain of what to do next. What happens post-MCO? What should a contractor do in the face of this crisis? 

 

As the construction industry had been slow with digital adoption, many now find themselves struggling to work remotely. Our founder, Pui Mun was invited by L2 Construction Series to share her knowledge on how cloud-based construction software can help builders to work remotely. She then gave some advice on how to choose the best construction software for contractors in the industry. 

 

L2 Construction Series was set up by two gentlemen, Mr. Lam Wai Loon from Harold & Lam Partnership, and Mr. Leong Hong Kit from MAC Consultant. They carried out a cost-free daily webinar since 30 March. In total, the series went on for 30 days and had seen viewerships of over 13,000 across 8 countries. Topics carried out including construction tech, fintech, dispute resolution and many more industry-related topics. 

 

As an appreciation of their selfless act of spending so much time, giving back to the construction industry during this difficult time, Speedbrick had compiled a short appreciation video to thank the L2 Construction Series. 

 

About Speedbrick 

Speedbrick is a leading provider of cloud-based construction management software. Our construction technology connects every department in your construction business allowing them to get things done faster. Our software is designed for contractors, by contractors. It allows different stakeholders to see different information to help them make better decisions. Available products are in the region of material management, project management, budget control, financial control, subcontractors claim control, and extension of time monitoring. Learn more at www.speedbrick.com

Speedbrick On BFM Radio

interview recording mic in radio studio

Our founder was interviewed on Business FM, listen to their thoughts and journey on helping to digitise the construction industry.

Speedbrick Webinar 2nd April 2020

online webinar on desktop

Construction industry experts share thoughts on digitizing the construction industry and how Speedbrick Solutions can help you get started.