Menu Close

How to Do Bill of Quantities Using a Spreadsheet

A Bill of Quantities (BoQ) is a precise breakdown of all materials required to complete an architect’s design. It can be used for cost estimating and to help with construction project management. It is traditionally prepared using a process called ‘taking off’.

There are now a number of software programs and BIM systems available that can assist with the preparation of BoQs. Nevertheless, it’s still best practice to follow a standard method of preparing them.

1. Identify the materials

In order to do a bill of quantities, the first step is identifying the materials that are needed for the project. This can be done by reviewing the plans and specifications. The next step is to create a spreadsheet with the items and their quantities. The spreadsheet should also include the unit of measurement for each item, such as gallons or liters. This will ensure that the right amount of material is ordered and prevent any errors from occurring.

Identifying the materials is critical for making sure that the project is completed on time. It will also help you avoid any overruns in costs and prevent budget issues.

A bill of quantities is a document that itemizes labor, materials and parts required for a construction project. It is usually prepared by a cost consultant, such as a quantity surveyor. It offers a clear framework for tendering contractors to quote prices and reduces favouritism and human error in the estimating process. It can be prepared in work sections that reflect likely sub-contract packages. It can be used for residential, commercial and public works projects.

2. List the items

When you’re ready to prepare a bill of quantities, begin by looking at the architect’s plans and making a basic list of building materials needed for the project. This list should include items such as plasterboard, bricks, sheetrock, paint and other surface finishes, and other structural elements. Once you’ve identified all of the materials required, you should also write down their unit prices and quantity. This helps to ensure that your estimate is accurate and makes it easier for contractors to understand what you’re asking for.

The Bill of Quantities is a crucial document in the construction industry, and it is important to make sure that yours is accurate. This will help to avoid disputes over pricing and quantities. In addition, it will make it easier for you to compare contractor bids and find the best price for your project.

Many people use a software tool to create their Bill of Quantities, but there are still some things you need to keep in mind when creating one. The most important thing is to follow a standard methodology. This will prevent different interpretations of the numbers and help you to avoid mistakes like arithmetic errors and incorrect measurements.

3. Break down the items into categories

When preparing a bill of quantities, you can use a spreadsheet to collect the information you need. The spreadsheet should include columns for the item number, specification or description, measurement unit, amount or rate with respect to the item, labor, and overall expense for the item. The item numbers should be consecutive, starting from one. The spreadsheet should also include the section or sort of the build.

If the project design is not fully complete, you can prepare an approximate or notional bill of quantities. These are usually prepared by quantity surveyors or civil engineers who have a university education that has been specialized in the construction industry.

If you want to make the process of creating a bill of quantities faster and easier, you can use estimating software to do it for you. This type of software can help you organize your categories and make it easier to compare estimates from different contractors. It can also help you determine if there are any discrepancies in the estimates and identify the reasons for them.

4. Create a spreadsheet

Using a spreadsheet is a convenient way to create a bill of quantities. It is easier to use than a word processor and more accessible for construction professionals. It also allows for automation and customisation to suit specific project needs.

Creating a bill of quantities is a vital process in the life of any construction project. It allows for more accurate tendering and cost estimates, which will help reduce waste in materials and time. It also helps prevent disputes, delays, or overruns by clearly defining the scope of work on a project.

A bill of quantities is usually made by a quantity surveyor or civil engineer with expertise in estimating the necessary materials for a construction project. It typically contains items and activities, their corresponding unit rates, and the total cost estimate for the whole project.

Download our free BOQ template to help you produce yours more easily. Ensure you have the latest version of Excel to get the most out of it. Once you have the template ready, simply import it into the Commitments tool. The template will replace any existing line items in the commitment’s Bill of Quantities.

5. Calculate

A bill of quantities, or BoQ, is a document that is prepared by quantity surveyors using the construction drawings and specifications for a project. It lists all the materials and labor required to complete a particular project. The BoQ is then given to contractors for pricing. It helps to ensure that all contractors are bidding on the same scope of work and can compare prices.

It also allows the project owner to check if the contractor is including overheads and profit in their pricing. This can help them negotiate a better deal. A Bill of Quantities is also a useful tool for planning and tracking the progress of a construction project.

While preparing a Bill of Quantities, it is important to follow a standard methodology. This will avoid ambiguities and misunderstandings, which can lead to disputes. For example, in the UK, bills of quantities are normally prepared according to the Standard Method of Measurement (SMM) 7th Edition. However, this was replaced by the New Rules of Measurement on 1st July 2013. The process of preparing a BoQ can be time-consuming and complicated. It is important to appoint a quality surveyor or cost consultant who is experienced in this area.