Measurement and Billing
Measurement and Billing KCTangNote
26/2/2023: Some taking-off fundamentals added.
20/2/2023: Revised.
23/3/2020: Page on query list merged into here.
27/7/2019: Partly split to different pages.
23/12/2014: Moved from wiki.
Processes 程序
-
The traditional manual processes of measurement and billing are:
- Take-off (measure dimensions)
- Square (calculate products and sums)
- Transfer (carry forward quantities)
- Abstract (summarize)
- Bill (describe and list)
- Transfer (bring forward quantities).
- Concurrent with the measurement and billing, query lists should be issued.
- After the transferring process, there are the following processes:
- Edit (the written draft BQ)
- Type
- Read over
- Clear Drawings, Specification and Preambles
- Bulk check
- Adjust
- Edit finally
- Correct finally
- Read quantities
- Photocopy
- Check pages
- Bind
- Pre-tender Estimate
- Issue Tender Addendum.
- With the use of BQ production software, squaring, transferring, abstracting and billing can be combined by linking the dimensions with the final BQ items.
- The dimension by dimension taking off may be replaced with CAD or BIM measurement.
- However, the processes still exist implicitly though taking a different form.
Taking-off 度數/計量
-
The process of measuring the quantities of items of work is called "taking-off" or "quantity-take-off" or "QTO" whereby the dimensions of the items of work are (traditionally) written down on a dimension sheet.
- Person(s) taking-off are called "Taker(s)-off".
Some taking-off fundamentals
(section added, 26/3/2023)
- Clarify which Method of Measurement:
- The Method of Measurement (more properly “rules”) to be used or which has been used should be clarified during the briefing session upon commencement of taking-off
- For pre-contract cost estimates, the Method of Measurement will be determined by the Consultants, and the quantities are usually approximate and relative items are grouped together to save time
- For Pricing Schedules with quantities provided by the Consultants, the Method of Measurement should be stated
- For new works, the Method of Measurement will be prescribed as to follow the Hong Kong Standard Method of Measurement of Building Works – Fourth Edition 2005 (“HKSMM4”) or Fourth Edition Revised 2018 ("HKSMM4R") published by The Hong Kong Institute of Surveyors
- For Government term maintenance contracts, they use Architectural Services Department Schedule of Rates for Term Contracts for Building Works 2019 Edition: (https://www.archsd.gov.hk/media/publications-publicity/schedule-of-rates/sor2019_vol_1_bw_2.pdf and https://www.archsd.gov.hk/media/publications-publicity/schedule-of-rates/sor2019_vol_2_bs_2.pdf), which prescribe the Method of Measurement
- The standard methods of measurement describe what should be measured and what can be deemed to be included in the rates and prices and need not be measured
- For Pricing Schedules with quantities to be inserted by the Tenderers, the Method of Measurement may be prescribed by the Consultants but usually it is left to the Tenderers
- The Tenderers may follow the standard Method of Measurement or may simplify or deviate
- In any case, the method used by the Tenderers in the Pricing Schedule should be used for pricing variations and remeasured provisional quantities.
- Read Method of Measurement:
- Inexperienced Takers-off should read the relevant sections of the prescribed Method of Measurement before taking-off
- Experienced Takers-off should review the relevant sections of the prescribed Method of Measurement from time to time during the course of taking-off
- Upon completion of taking-off, all Takers-off should take a final review of the prescribed Method of Measurement to ensure that there are no missing items to be measured.
- Pay extra attention to how to treat:
- Wastage (not measured)
- Gross or net measurement
- Deductions for openings (small voids or openings not deducted, such as those not exceeding 0.50 m2 or 1.00 m2 or 0.50 m3 depending on the type of work)
- Laps and intersections
- Working space for excavation (0.25 m or 0.60 m depending on the height of formwork below ground)
- Slopes of excavated spaces (designed or restricted excavation profiles)
- Staging or ranging where items can be measured together or separately (excavation depth below ground in successive stages of 1.50 m, soffit formwork and ceiling finishes heights above floor not exceeding 3.50 m high, then in 1.50 m stages, etc.)
- Sloping work (from horizontal) / slanting work (from vertical)
- Circular work (usually measured separately)
- Extra over items (principal items overlapping with the extra over items not deducted in the quantities, but to be considered in the unit rates, e.g., pipe bends, tees, etc.)
- Tenderers not strictly following any standard Method of Measurement may follow the above treatment as common practice.
- Measure net quantities:
- Measure all work net as fixed in position, unless otherwise stated
- This is a very important principle
- If there is no prescribed Method of Measurement, at least state that “all work is to be measured its net quantity as fixed in position with no allowance for wastage and, in case of work measured superficially, for laps, unless otherwise stated”
- Work which are “superficial” (as compared to “linear” or “cubic”) and have laps not to be measured are wire mesh, waterproof layers, pitched roof tiling, etc.
- Work which are linear and have laps to be measured are reinforcement bars, door frames, skirtings, etc.
- Deduct voids:
- Voids (openings and wants) smaller than the sizes specified in the SMM are not to be deducted
- However, this refers to voids detached from the boundaries of the space measured
- Voids caused by projections from the boundary of the space measured are always deducted:
- Costs held to be included in items (HKSMM4 and 4R):
- Labour and all costs in connection therewith
- Materials, goods and all costs in connection therewith (e.g., conveyance, delivery, unloading, storing, returning packings, handling, hoisting and lowering)
- Fitting and fixing materials and goods in positions
- Use of plant
- All cutting and waste
- Establishment charges, overhead charges and profit.
- Units of measurement (HKSMM4 and 4R):
- Items given by weight - kilograms
- Items given cube - cubic metres
- Items given super - square metres
- Items given run - linear metres
- Items enumerated - number of sets, as applicable
- Items given by time - Days or Hours, with definitions stated
- Dimensions used in calculations - rounded off to the nearest 10 mm.
- Units of billing (HKSMM4 and 4R):
- Billing BQ:
- Rounded to the nearest whole unit
- Subject to a minimum of 1 if more than 0
- Billing variations and remeasurement:
- Rounded to the nearest 0.1 for m, m2, m3
- Rounded to the nearest 1 for kg
- Applicable to omissions or additions
- Quantity less than 1 but billed as 1 in the original contract to be omitted as 1 if the quantity is not done
- Order of dimensions in BQ or dimension sheets:
- Generally, in the sequence of length, width and height.
- Billing BQ:
- Ranges:
- When a range of widths, heights, depths, etc. is given in the item description in a Pricing Schedule, “A – B” usually means “exceeding A but not exceeding B”.
- A - B = exceeding A but not exceeding B = "> A but <= B".
- Pipe and tubing (HKSMM4 and HKSMM4R):
- Pipe size: to be described by nominal sizes
- HKSMM4 pipe size groups for the purposes of painting (all measured run):
- pipes <= 50 mm diameters
- pipes 50 - 100 mm diameters
- pipes > 110 mm diameters, pipe size stated
- HKSMM4R pipe size groups for the purposes of painting:
- pipes <= 300 mm girth (measured run)
- pipes > 300 mm girth (measured super).
- Circular work (HKSMM4 and HKSMM4R):
- No grouping by radius.
- Prime cost rates (P.C. Rates):
- Where a prime cost rate (P.C. rate) is included for a component in the description of an item in the Bills of Quantities, the prime cost rate is either (a) for the material cost of that component delivered to site only and the Contractor shall allow in addition for all waste, fixing, all ancillary materials required for fixing such as mortar for bedding and jointing and all other similar items of a like nature, and for profits and overheads, or (b) for the cost of supply and installation or application of the component (such as specialist suspended ceilings or finishes) as charged by a domestic sub-contractor, and the Contractor shall allow for his own profits and overheads.
- In the settlement of the Final Account, the rate for the item will be adjusted by the net difference between the prime cost rate and the actual unit cost and will be applied to the nett quantity of the component measured as fixed, installed or applied in position, exclusive of wastage.
- Provisional Sum:
- A sum provided for work or for costs which cannot be entirely foreseen, defined or detailed at the time the tendering documents are issued.
- In the settlement of the Final Account, the provisional sum will be omitted from, and the actual expenditure added to the Contract Sum.
- Prime Cost Sum:
- A sum provided for work or for services to be executed by a Nominated Sub-Contractor or for materials or goods to be obtained from a Nominated Supplier. Such sum shall be deemed to be exclusive of any profit or attendance required by the Contractor and provision shall be made for the addition thereof.
- In the settlement of the Final Account, the Prime Cost Sum will be omitted from, and the actual expenditure added to the Contract Sum.
- The Contractor’s profit is to be allowed as a percentage of the Prime Cost Sum. The same percentage will be applied to the final expenditure of the Prime Cost Sum in the settlement of the Final Account.
- The Contractor’s attendance is to be allowed as a lump sum not to be adjusted in the settlement of the Final Account, but if the Prime Cost Sum is not expended at all, then the lump sum will be omitted.
- Work to be specifically described as such:
- Work under reservoir, river or sea water
- Work in compressed air
- Work outside the curtilage of the Site
- Work in existing building
- Temporary works.
Long hand manual dimension sheets (school arithmetic) 長式手工計算紙
- Calculations may be set out in the usual arithmetical form:
計算可如一般的算式列出: - This uses less paper, but is difficult to trace, compare and inspect for errors.
這樣非常省紙,但難於對比和檢查錯誤。
Traditional manual dimension sheets
- Traditional dimension sheets used to take-off quantities take the following form (as seen in textbooks):
- Dimensions are set in vertical stack, in the order of length, width and breadth.
- A line is used to separate each set of dimensions.
- Timesings are written on the left column.
- In this column, "/" means multiply, not divide.
- ". " means add, an action called "dotted on".
- The products are given in the right column.
- The descriptions are very much abbreviated to reduce writing.
- The calculation in the description column is the build-up of one of the dimensions.
- It is called a "waste calculation" or "side-cast".
- The annotations "bm B1", "bm B2" in the description column are to identify the locations of sets of dimensions.
- This action is called "sign-posting".
Another kind of manual dimension sheets
- Another kind of dimension sheets is to lay out the dimensions horizontally as follows:
- The products of dimensions are not written one by one.
- Only the total of the products is entered at the bottom.
- This is made feasible with the popular use of electronic calculators with memory function.
- It would be faster to calculate once more than write down all the products before summing up.
- Laying out the dimensions horizontally actually improve the presentation and make comparison of dimensions easier.
- Deductions are indicated by putting brackets to enclose the set of dimensions, and write them in red:
- The right hand columns can be utilized as rate and extension columns for final account purposes.
Manual taking-off schedules 計算表
- Dimension sheets require descriptions against group of dimensions.
- To reduce writing descriptions, dimensions of all quantities of the same item should be measured in one go and this requires greater experience.
- For measurement of group of items which have a lot of inter-related dimensions, use of dimension sheets would be cumbersome.
- A taking-off schedule would be preferred.
- The schedule sets out inter-related dimensions and items in a systematic manner.
- This reduces the need to repeat descriptions.
- This enables measurement of more than one items at the same time.
- This makes comparison and identification of errors easier.
- The following schedule for the same dimensions above measures concrete and formwork at the same time sharing the same set of dimensions:
下列的計算表,把共用原始尺寸的項目並列一起計算,較容易看到互相的關係: - The following schedule puts all finishes items sharing the same primary dimensions together and enables easier understanding of their inter-relationship:
- "/" = Times.
乘 - () = Deduct.
扣減
- Deductions are written in red or, if black and white photocopying is anticipated, marked with a minus sign or with brackets.
- The number of columns for each set of dimensions is flexible.
- For items measured Cube, four columns are allocated.
欄數可加減,立方項用4欄。 - Since the width of a sheet of paper is limited, a column needs to be shared by more than one item, e.g. two types of floor finishes, and colouring of the boxes is used to distinguish dimensions of different items.
因紙寬有限,可用顏色在同一組欄下表示不同的專案,加總時按顏色分開加。
Squaring 運算
- The process of calculating the products of dimensions and totals on dimension sheets and taking-off schedules is called squaring.
- The person is called a "Squarer" or "Comptometer".
- To ensure correctness, each calculated total entered by a Squarer must be counter-checked and initialled by another Squarer.
- Squaring is a tedious process even with the help of electronic calculators before the use of computer spreadsheets or BQ production software.
- 計算紙或計算表列式後要運算。
- 用普通計算器及人手計算的要另外有人覆核並簽署。
- 用電子計算器及軟體計算的,要建立覆核公式覆核。
Abstracting 匯總
- Dimension sheets or taking-off schedules measure more than one item on the same sheet or schedule.
- The same BQ item may appear on more than one sheet or schedule.
- Therefore, it is necessary to collate the individual quantities of the same BQ item appearing on more than one sheet or schedule together to arrive at the grand total of the item.
- A summary schedule is used to bring together the individual quantities to add up the grand total.
- The process of transferring the individual quantities from dimension sheets or taking-off schedules to the summary schedule is called "abstracting".
- 計算紙或計算表運算後要匯總。
- 工程量清單某分項數量可能要由幾張計算紙或計算表得出,所以要匯總。
Billing 列單
- The items in the summary schedule are then transferred to the draft BQ pages in the correct sequence with the descriptions expanded in full without abbreviations.
- This process is called "billing" and requires experienced Surveyors to do.
- The whole process from squaring to billing is called "working up".
Transferring 轉移
- Information is transferred from the dimension sheets or taking-off schedules to the summary schedule to the draft BQ.
- Every transfer of descriptions, units and quantities has to be counter-checked by another Surveyor.
- The actions are called "transferring" and "transfer-checking" or "to check transfer".
- 從計算紙或計算表轉移到匯總卡後要他人覆核簽署。
- 從那裡來往、往那裡去,都要寫。
Cut and shuffle 洗牌式
- Abstracting and working up are tedious processes involving a lot of transferring and transfer checking.
- More movements of information from one to another will increase the chances of making errors.
- A method has been devised whereby:
- each dimension sheet only contains one item
- when the taking-off is finished, dimension sheets of the same BQ item are collated and stapled together
- if taking-off schedules are used, the totals are transferred to the respective dimension sheets
- squaring is done to obtain the grand total which is written on the front dimension sheet
- short descriptions are expanded to full descriptions on the front dimension sheets
- the dimension sheets are then shuffled according to the intended BQ sequence
- headings are added as appropriate
- BQ is directly typed from the dimension sheets which have headings, descriptions, unit and total quantities.
- The number of processes is greatly reduced.
- A drawback of this system is that when the dimension sheets are shuffled, the original sequence and logic of measurement are lost.
- Therefore, when the system was originally invented, the dimension sheets came together in 4 on one sheet of paper and were backed with a self impressed carbon copy.
- After taking-off in a logical sequence, the front sheet (A4 size) was taken out and cut into 4 vertical pieces or 2 horizontal pieces which were shuffled and sorted with other sheets.
- The carbon copy was kept in the original sequence to facilitate future reference.
- 每一個工程量清單分項都有一張卡,可以A4紙分為二或四。
- 每卡都寫上工程量清單分項的工程合同名稱、卡號、清單號、分項說明、單位、計算紙或計算表編號、搬來數量、匯總數量。
- 格式例:
-
-
- 匯總卡可按清單分項次序自由排序。
- 排序後要運算每卡總數,寫在上部。
- 總數由他人覆核。
Using Excel
- Electronic spreadsheet software like Excel can be used as dimension sheets or taking-off schedules.
- However, using electronic spreadsheets to imitate dimension sheets would require the defining of many calculation formulae.
- If the formulae cannot be consistently defined to enable copy-and-paste repeatedly, the defining process will be tedious and prone to errors.
- Using electronic spreadsheets to imitate taking-off schedules is more suitable.
- However, taking-off schedules when put into an Excel worksheet will become too wide to view on screen.
- It is suggested to set out the dimensions using less columns in the following manner:|
- Instead of adding columns for different items of work, codes are used to represent items row by row.
- Note that Columns B and I and Rows 4, 16, 18, 24 and 26 have been reduced to narrow widths and heights respectively.
- They will be used as the boundaries of ranges of columns or rows used in formulae such that any insertion of columns or rows within the boundaries would not go outside the defined ranges unexpectedly.
- The PRODUCT(range) function has been used in the following tables to calculate the Qty:
- Note that the range is from the narrow Column B to Column I.
- Within the defined range, empty cells are regarded as having value 1.
- “$” is used to anchor the columns in case the Qty column is copied to some other places without the intention to change the referred columns.
- The SUM(range) function has been used in the following table to calculate the total:
- Note that the range is from the narrow Row 4 to Row 16.
- The SUMIF(range to check, criteria, range to sum if criteria matched) function has been used in the following table to calculate the total qty per code:
- In the above table, if a cell value in the range to check is equal to the criteria, e.g. a cell value in the range to check “J$4:J$16” matches the value of cell J20, then the cell value on the same row in “K$4:K$16” will be added to the sum.
- “$” has been used to anchor the rows such that when the formula is copied down to other rows, the defined range will not change as shown in the following table:
- Column J may need to be anchored as well if the same formula is copied sideway to other columns.
- To ensure that the sum of all sub-totals equal to the grand total, another check total should be calculated.
- Note that in the following table, the upper boundary of the range to sum is Row 19 the heading row instead of Row 18 the narrow row:
- This serves the same purposes of bounding the ranges.
- An advantage is that Rows 19 to 25 can be moved to elsewhere independent of Row 18.
- It is important that insertion must be by rows or columns not by cells, and copying and pasting of cell values to other places are preferred to cutting and pasting, to avoid corrupting the formulae.
- Formulae must be refreshed by copying the correct ones to the other corresponding cells.
- There must always be a double-check of the totals using alternative method or formula to ensure no omission or duplication.
(positions of images relative to items adjusted, 20/2/2023)
Paper based table
- When doing quick measurement without using Excel, users may use coloured rows to highlight rows to be added using manual calculator to obtain the total:
- Individual qty per row may be skipped to save time.
- It is important to calculate the totals twice to ensure no error.
(position of image relative to item adjusted, 20/2/2023)
Direct billing
- With substantial portion of taking-off information given in taking-off schedules in tabulated and inter-related manner, the portion of taking-off directly on dimension sheets is greatly reduced.
- The need for carbon copy to keep the original taking-off sequence and logic is also reduced.
- "Cut" is also no longer required, one independent sheet can be used for one BQ item, leaving the "shuffle" behind.
- Taking-off directly onto these dimension sheets which can be shuffled immediately for billing is called "direct billing".
Query list 编标问卷
- During the course of BQ production, there is bound to be uncertainty of information either in respect of the project particulars or in respect of the Drawings and Specification.
编制工程量清单时,常会碰到工程细节、图纸或工料规范有不清楚的地方 - Clarify with the Architects or Engineers using telephone conversation or email.
先以电话或电邮询问设计单位 - Write down the answers obtained on a query list.
用编标问卷书面记录答案 - Make reasonable and confident assumptions on the query list prior to receipt of answers.
未有答案前,可把有信心的合理假设写在问卷上 - Refer to the following sample form:
参考以下格式例:-
-
- To avoid grammatical mistakes and to reduce the subsequent time to make corrections, write the queries in note form which is still understandable, particularly when assumptions or answers have been made such that a query and assumption or answer can be read together to make sensible and complete meaning.
- Dispatch the query list from time to time to the Architects or Engineers for answering outstanding queries or confirming answered queries and for record.
定期发出问卷以便取得未有的答案或确定已有的答案及做为记录 - Chase for the return of the query list with answers within a reasonable time.
跟进在合理时间之内有回复 - Reflect the final answers in the Bills of Quantities.
把最后的答案在工程量清单反映