QSTERA by HyperStudy · Excel template
Construction estimation & cost control in one Excel workbook
QSTERA brings quantity take-off, BOQ, rate analysis, bar bending schedules and running-account billing into one connected workbook, so your quantities, rates and bills stay organised and checkable.
Take-off, BOQ, rate analysis, BBS and RA billing in one connected Excel workbook, with a guide and a worked case study.
- 17 worksheets
- 33 automatic checks
- PDF guide + case study
One workbook, every estimation task
Instead of jumping between disconnected spreadsheets, every sheet feeds the next: take-off totals flow into the BOQ, rates come from rate analysis, and the dashboard and checks update by themselves.
- Quantity take-offNumber × length × breadth × depth, with additions and deductions tagged to BOQ items.
- Bill of QuantitiesLinked quantities and rates, item amounts, trade totals and optional tax.
- Rate analysisConcrete, masonry, plaster, painting and earthwork rates built from a rate register.
- Bar bending scheduleCalculators for stirrups, columns, one-way and two-way slabs, plus a project BBS.
- RA billingRunning-account bills with previous, current and up-to-date quantities.
- Dashboard & checksCost by trade, steel by diameter and 33 automatic consistency checks.
Look inside the workbook
Real screenshots of QSTERA, with notes on what each sheet does.
Swipe sideways to see more sheets.
What you get
- Main workbook (.xlsx)17 connected worksheets, no macros, no external links
- How-to-use guide (PDF)32 illustrated pages with a worked example
- Tender BOQ template (.xlsx)Bill-wise BOQ with summary, GST and checks
- Case study (.xlsx + PDF)A fictional G+1 house in Nashik, filled in and hand-checked
- Reference drawingsDimensioned drawing, colour legend and steps on every working tab
Who it's for
Made for
- civil and site engineers
- estimation and billing engineers
- quantity surveyors and contractors
- civil engineering students learning estimation
Good to know
- Built for Microsoft Excel 2010 or newer; tested in LibreOffice Calc. Check results in Google Sheets or phone apps.
- Sample rates are illustrative, not current market rates. Use your own.
- Checks test arithmetic and completeness, not design. A qualified professional should verify estimates.
Get QSTERA
QSTERA: Construction Estimation & Cost Control System
Measure with precision. Estimate with confidence.
- Main workbook: 17 connected worksheets
- 32-page illustrated how-to guide (PDF)
- Tender BOQ template
- Worked G+1 house case study (Excel + PDF)
- Download straight after payment, keep it forever
Secure checkout by Superprofile. You'll get the download link on screen and by email.
Questions before you buy
Which software do I need?
Microsoft Excel 2010 or newer on a computer. Every formula was tested in LibreOffice Calc. It has not been tested in Google Sheets or phone spreadsheet apps, so check the first results if you use those.
Does it use macros?
No. The main workbook uses standard spreadsheet functions only, with no macros and no links to other files.
Can I change the formulas?
Yes. Sheets are protected without a password to prevent accidents. Use Review › Unprotect Sheet to edit a formula.
Are the rates current?
No. Sample and case-study rates are illustrative assumptions. Enter your own current rates and confirm conventions for your project and contract.
How do I receive it?
Right after payment you get a download link on screen and by email.
Can I get a refund?
Because it is a digital download, purchases are final. If you were charged twice or didn't receive the files, write to us within 7 days and we'll fix it. See the refund policy.