Documents that pass at the department.
A contractor is judged on what he can hand over. Every report here is built from the measurements you already entered — the Excel files carry live formulas, and the PDFs are laid out for A4 with repeating headers and signature blocks.
Six families of document, one set of numbers.
Nothing on this page is typed twice. Every figure that reaches paper is the same figure the app is showing you on screen at that moment.
The spreadsheet we export is a working file, not a picture of numbers.
Open the BOQ, click on a quantity cell, and look at the formula bar. You will not find 5.508 sitting there as typed text. You will find the cell pointing back at the estimation sheet in the same workbook.
- BOQ quantities link back to the estimation sheet. One workbook, two sheets. The client can trace any BOQ line back to the measurement that produced it.
- Amount = Qty × Rate is a real formula — =D14*F14 — not a number somebody pasted in.
- Category subtotals and the grand total are SUM(). Electrification, contingency and GST then stack on the running total, one after another, exactly as they do in the printed BOQ.
- The maths you typed is preserved. If you entered 1.8*1.8 in a width cell in the Measurement Book, that is what the exported cell holds — so anyone checking it can see where the figure came from.
- A survey export recalculates. Every material cell is =D7*7.6 — measured quantity × consumption per unit — and the totals row is a SUM. Change one measured quantity and the cement, sand and aggregate figures move with it.
If you would rather send figures nobody can edit, switch Dynamic Excel formulas off in the export dialog and the same workbook comes out with flat values instead.
| # | Description of work | Qty | Unit | Rate | Amount |
|---|---|---|---|---|---|
| 3 | RCC M25 in footingsClause 5.33.1.1 | =Estimation!G12 | cum | 7,178.75 | =D14*F14 |
| 4 | Reinforcement Fe-500D, cut, bent and placedClause 5.22.6 | =Estimation!G19 | MT | 1,07,850.00 | =D16*F16 |
| Sub Total — Concrete Work | =SUM(G8:G17) | ||||
The column header band repeats at the top of every printed page. So does the project name in the footer, next to the page number.
Set up for paper before you open it.
Most exported spreadsheets are unprintable — fourteen columns crushed onto A4, the header row only on page one, no page numbers, and a stray click prints forty blank sheets. Every report here arrives with the page already set up.
- Paper size and orientation are already chosen. A4 by default; A3, Letter or Legal when you need them. The estimation sheet always prints landscape, because eleven columns will not sit on a portrait page.
- Fit to width, so no column falls onto a second sheet on its own.
- The column header row repeats on every page. On page seven you can still tell which column is Quantity and which is Rate.
- Page numbers in the footer — "Page 3 of 11" on the right, the project name on the left. A signed set of papers has to be countable.
- Freeze panes, so the title, the project line and the column header stay put while you scroll a four-hundred-row estimate.
- Print area set to the used range, and narrow margins on the wide sheets.
For the BOQ you choose paper, orientation and fit-to-width in the export dialog — along with which sheets to include, how to group them, and whether add-on charges go at the bottom — before the file is made.
Everything the app can print for you.
Each one is a real file the software produces today. Excel means a working spreadsheet with formulas in it. PDF means a laid-out document with a masthead, a document number and signature blocks.
A card the bar bender can actually work from.
The cutting plan is a fine spreadsheet for the office and useless at the cutting yard. So the same plan prints again as cards — one card per rod pattern, sized for a clipboard, written for the man holding the cutter.
- It starts with what to pick up. "Take one 12 m rod, 12 mm" — or "Take off-cut OC-12-04 from the footing stage", when the rod is one you already saved.
- A picture of the rod, drawn to scale, so the cuts are obvious before anyone reads a single number.
- Feet beside every metre — 3.70 m (12'-2") — because that is how the yard talks.
- A numbered cut sequence, and how many rods to cut the same way.
- Where each piece goes, in plain words — "Column C2 — ring (stirrup), across the width" — not a bar mark that only the office can decode.
- Tick boxes when the count is small, and a running count out of the total when there are hundreds, so progress survives a shift change.
- A blank for the actual rod length, because a 12 m bar is rolled to roughly plus or minus 75 mm and the yard should record what it really got.
- What to do with the tail — keep it or scrap it — and if you keep it, the exact tag to write on the bar with chalk.
- Cut by, checked by, and one line to write down anything that did not match, before the steel is cut wrong twice.
- English, Hinglish or हिंदी — you choose before you print. The Hinglish says sariya, the word the yard uses.
The cards always print on a light background. A site printer should never be asked for a dark page.
How the steel schedule is builtSet the header once. Every report on that job carries it.
A report with somebody else's name on your client's desk is worse than no report. Before you generate anything you can set the header, and the app remembers it for that project.
- Company name — filled in from the project's client or organisation, and you can type over it.
- Report title and subtitle — call the document what your department calls it, not what we called it.
- Document number — built automatically from a prefix, the project number and the date, so two people generating the same report on the same day get the same number. Type your own if you run a numbering system.
- Date — today, written the Indian way.
- Remembered per project. Set it once for a job and every later report on that job comes out the same, even months later.
- Signature blocks are already on the page — Prepared by, Checked by, Approved by — and the payroll register carries one for accounts.
A bill that has not been finalised prints with a DRAFT watermark across it, so nobody signs a figure that is still moving.
The masthead repeats on every sheet of a multi-page document, so a page that gets separated from the set can still be identified.
If the screen says ₹12,97,800, the PDF says ₹12,97,800.
Reports here are not separate files that somebody reconciles afterwards. They read the same rows the app is showing you, through the same code.
- The Bill of Materials report uses the same consolidated list as the Materials screen, with the same weighted-average rate — not the raw un-merged figures underneath it. "Coarse Aggregate (20 mm)" and "Aggregate 20 mm" are one line in both places.
- The BOQ description is built from the clause and the sub-clause the same way on screen, in the PDF and in both Excel exports — so all four say exactly the same sentence.
- The Measurement Book layout is produced by one shared piece of code, used by the standalone export and by the combined estimation workbook. They cannot drift apart, because there is only one of them.
- Progress in the reports is weighted by value, the way it is on the dashboard — not by counting items, which flatters a job that has finished all the small work.
Bring one of your bills. We will print it back to you.
Thirty minutes on a call. Send us an estimate or a running bill and we will run it through the app while you watch, then hand you the Excel and the PDF.