Skip to content
rupsdbbPublic

About

Offline measurement book and BOQ tool in one web page. No install needed.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

12 Commits

Folders and files

Repository files navigation

MBook

Measurement book and Bill of Quantities in a single web page

Record site measurements, price them against your Schedule of Rates, and turn them into a BOQ — offline, in the browser, with nothing to install.

License: GPL-3.0-or-later Version Dependencies: none Works offline Chrome | Edge

▶ Try it online  ·  ⬇ Download

Features · Quick start · Using MBook · Your own SOR · File formats · Developers · License


Overview

MBook replaces the Excel workbooks used to record site measurements and price them against a Schedule of Rates (SOR). Enter dimensions entry by entry, and MBook looks up each item's description, unit and rate, works out quantities and amounts, consolidates them into a BOQ, and exports the result to PDF, Excel or HTML.

Everything runs in your browser — no installation, no server, no internet connection and no third-party libraries. Your data never leaves your computer.

Features

Feature What it does
Measurement sheet No × L × B × H/D for every entry, with arithmetic in any cell — 2*(1.1+1), sqrt(3^2+4^2), pi*0.6^2
SOR lookup Type a service code or search descriptions by keyword. Hover a code for its rate and full scope of work
Rates by date and State Keep several SOR periods and State SORs side by side; each entry takes the rate valid for the chosen date and State
Steel weights Type a section such as ISA 65 and pick its kg/m from the BIS tables
Rounding by unit Whole numbers for EA / NO / LS, 2 decimals for lengths and areas, 3 for volumes and weights; amounts to 2
Templates Save and reuse standard BOQs; entries that no longer match the SOR are flagged for review
Import from Excel Paste measurements into a blank Excel sheet, or upload an existing measurement sheet, and bring them in as entries
Reports Quantities consolidated by Asset and/or PO Item, with subtotals and a grand total
Export PDF, Excel with live formulas, and plain HTML
Drawings Drawing numbers in the SOR text open the matching drawing file
Works on phones Used upright: a compact layout with a menu, and each entry in two lines (Service No and Short Text, then No, L, B, H/D and Qty). On Android, Add to Home screen makes it an app that stays upright
Safe by default Autosave in the browser, project files you can save and open, undo for deleted rows

Quick start

Online — open rupsdbb.github.io/mbook. It runs entirely in your browser; nothing you enter is sent anywhere.

On your computer — download the ZIP, unzip it and double-click index.html. It works offline in Chrome or Edge.

Try it — MBook starts with a small sample SOR of made-up rates. Click + Row, type excavation under Service No and press Enter, or use Import template… to load sample-foundation.boqt.

When you're ready, load your own SOR.

Using MBook

The measurement sheet

Column What to enter
Service No An SOR code, or words from its description, then Enter to pick from the matches
Description Where or what was measured
No, L, B, H/D Numbers or arithmetic; blank cells are skipped. In H/D, type IS… to pick a steel section's weight
PO Item, Asset Labels used to group the report

Short Text, Unit, Price and Amount fill in automatically:

Price = SOR rate × (1 − Discount %)  ·  Amount = Qty × Price

Keyboard shortcuts

Keys Action
Enter / ↑ / ↓ Move between rows (Enter on the last row adds one)
Tab Next cell; from Asset it goes to the next row's Service No, adding a row at the end
Ctrl + D Copy the cell above into this one, as in Excel (a Service No brings its description, unit and rate)
Esc Cancel a search and restore the cell
Ctrl + I Show the full SOR text for the current entry
Delete Delete the selected row(s)
Ctrl + Z Bring back deleted rows
Ctrl + S Save the project

Rates as on, and State

  • Rates as on — for each item, the rate whose validity period covers this date is used. Leave it blank to use the rate valid today; if your SOR has expired, the latest rate on file is used and the entry is flagged so you can set the date of the work.
  • State — becomes available once your SOR contains State-specific rates, and lists just those States; one is always chosen. Each entry uses that State's rate, falling back to rates that apply in every State.

Entries without a valid rate are flagged in red.

Importing measurements from Excel

Import Excel… brings in measurements kept in a spreadsheet.

  1. Click Download blank sheet. Its columns are in the same order as the measurement sheet (# · Service No · Short Text · Description · No · L · B · H/D · Qty · Unit · Price · Amount · PO Item · Asset), so a block copied from an existing measurement sheet pastes straight in.
  2. Paste from row 2 and save. Only Service No, Description, No, L, B, H/D, PO Item and Asset are read; Short Text, Unit and Price come from the SOR.
  3. Click Choose file…, pick the workbook, and import.

Any .xlsx, .xlsm or .csv with these headings works too, such as an existing MES sheet; MBook finds the heading row and the columns by name (Description may be headed Details, and H/D may be D/H). Arithmetic such as =2*(0.52+0.42) comes across as an expression, a BIS section name in H/D becomes its kg/m, and the import can be undone from the message that follows. Old .xls workbooks need saving as .xlsx first.

Report

The Report tab totals each service code by Asset, by PO Item, or by both, with subtotals and a grand total. It can hide items that net to zero and list the measurement entries behind each total. Print it, or export it as CSV.

Export

Export… saves the measurement sheet and/or the report as:

Format Details
PDF A4 landscape with repeated headings and page numbers, ready to print
Excel (.xlsx) Live formulas for quantities, amounts and totals
HTML A plain page with no scripts, for sharing

Saving your work

Work is saved automatically in the browser you use. Save writes a .boq project file you can back up, email or open on another computer.

Using your own SOR

The online version comes with a small sample SOR. MBook picks the SOR in this order: one you imported in your browser, a data/sor.js next to the page, and finally the built-in sample. To use your own rates:

From a CSV file — in Excel, save your SOR sheet as CSV, then in MBook use Data ▸ Replace SOR from CSV…. Use Data ▸ Add SOR rates from CSV… to add another period or another State alongside the current rates.

From an Excel workbook — run the extractor once (requires pip install openpyxl):

python3 tools/extract_data.py "your workbook.xlsm" --state "State name"

It reads the SOR and BIS sheets and writes data/sor.js, which MBook then loads instead of the sample. --state is optional.

CSV format

Columns are matched by heading, or taken in this order if there is no heading row:

Service No Short Text Rate Unit Valid From Valid To Long Text State
  • Only the first four columns are required.
  • Dates may be 2025-04-01, 01.04.2025, 01-04-2025 or 01/04/2025 (day first).
  • State takes a code of 2–4 letters: MP, CG, UP …, or MPCG for an SOR that serves both States. Leave it blank for rates that apply in every State. If the file has no State column, MBook asks which State it is for.
Drawings

Drawing numbers in the SOR text — for example "as per std drg no STD.DRG.101" — open drawings/<number>.pdf, with / written as - (ABC/XY/02 opens drawings/ABC-XY-02.pdf). Data ▸ Drawings folder… points to another folder, such as D:\Drawings or /home/me/drawings, or changes the file type. Browsers don't let a page on the web open files on your computer, so for drawings on your own disk use a downloaded copy of MBook; the online version copies the drawing's address instead.

File formats

Extension Contents
.boq A project — measurement entries plus project name, State, rate date and discount
.boqt A template — a reusable set of entries. On import, MBook asks for the PO Item and Asset and takes descriptions, units and rates from the current SOR
.xlsx Measurements to import (Import Excel…); the blank sheet is available from the same dialog
Template example

Both formats are plain JSON. A template entry looks like:

{ "serviceNo": "9900003", "shortText": "FOUNDN . RCC 1:1.5:3 MIX",
  "description": "Footings", "no": "4", "l": "1.2", "b": "1.2", "hd": "0.45",
  "unit": "M3", "qty": 2.592 }

Privacy

MBook never sends anything anywhere. Your SOR, projects and settings stay on your computer — in the browser's storage and in the files you save.

For developers

index.html     page layout
css/app.css    styles
js/            app code — js/app.js holds the name and version
data/          sample SOR and BIS steel tables
templates/     sample template
drawings/      sample drawings
tools/         extract_data.py (workbook → data/*.js) · build.py (single-file build)
  • Single-file build — python3 tools/build.py bundles everything into dist/MBook.html, one file that opens with a double-click, plus a zip that includes drawings/.
  • Work data stays out of git — .gitignore excludes workbooks, .boq projects, CSV files, data/sor.js and dist/.
  • New version — bump version in js/app.js, add its notes at the top of js/changelog.js (shown in the app when the version is clicked), and run tools/build.py to regenerate CHANGELOG.md.

License

Copyright © 2026 rupsdbb

MBook is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

MBook is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. See LICENSE for the full text.

About

Offline measurement book and BOQ tool in one web page. No install needed.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages