Measurement Book (MB) Format in Excel (Free) – Nos × L × B × D with Abstract of Cost

Measurement book format in Excel with Nos, length, breadth, depth and quantity

Advertisement

Quick answer: A measurement book (MB) records the work done on site, item by item:

  • the date, the BOQ item number and the location
  • Nos, length, breadth and depth (or height)
  • the quantity = Nos × L × B × D in the item’s unit

Deductions such as door and window openings are entered with a minus number. The item totals are then priced in an abstract of cost against the BOQ.

Download a free measurement book format in Excel below.

Key takeaways

  • BOQ Items: up to 40 items with unit, BOQ quantity and rate.
  • MB Entries: up to 500 lines. A blank dimension counts as 1, and a minus Nos is a deduction.
  • Unit picked up from the BOQ, and an item total after the last line of each item.
  • Abstract of cost: done to date, % done, amount to date and the amount for this running bill.
  • A warning when any item goes over its BOQ quantity.

↓ Jump to the free download

FOR CONTRACTORSBOQ, measurement book and RA bills in one Excel file.XploreWorks prepares every running bill with GST, TDS, labour cess and security deposit worked out.See XploreWorks — from ₹999 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreWorks

Measurement book format in Excel with Nos, length, breadth, depth and quantity
Excavation, PCC, RCC, steel and brick work. Door and window openings are deducted with a minus Nos.

Abstract of cost

Abstract of cost in Excel – BOQ quantity, done to date, % done and this bill amount
Work done to date is ₹9,87,733, of which ₹3,93,165 is in running bill RA-2.

How to use the template

  1. BOQ Items: type the name of work, agreement, contractor and MB number, then copy the BOQ items with unit, quantity and rate.
  2. MB Entries: record each measurement with the item number and the running bill it goes into (RA-1, RA-2 …).
  3. Abstract: type the running bill number to see its amount, and check the % done for each item.

Tips for MB entries

  • Write the location clearly (grid, floor, wall) so the checking officer can find it on site.
  • Record deductions on the same day as the work they belong to.
  • Watch the % done. An item near 100% needs a deviation or extra-item approval before you go on.
Outgrown the free sheet? Here’s what XploreWorks adds

Free sheetXploreWorks
GST, TDS, labour cess, security deposit—✓
Payments received and balance—✓
Bills register with payments—✓
TDS summary for 26AS—✓
Progress dashboard—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreWorks — from ₹999 →

Download the free Measurement Book Format

There are three sheets: BOQ Items, MB Entries and Abstract. Fill in the yellow cells; everything else is worked out.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

How do I enter steel in kg?

Enter the weight from the bar bending schedule in Nos and leave the dimensions blank. The quantity is then the weight.

Advertisement

Can I use it for road or electrical works?

Yes. Use the units in your BOQ, for example rmt, nos or km.

Does this replace the official MB?

No. Government works need the official MB. Use this to prepare and check measurements before they are recorded.

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.