Working-Time & Equipment Sheets
Time calculations for equipment records, including start and end times, breaks, total working hours, and related cost entries — with formulas that can be checked.
Excel • Civil Engineering • Real Site Work
I Build Practical Excel Sheets for the Work Happening on Site
As a Site Engineer at the Nexa Prime project, I work with quantities, concrete records, material entries, daily progress, and equipment hours. I use Excel to make these tasks easier to calculate, track, and review — because good site records should be useful, not just filled in.
Built around everyday site tasks
From Site Entries to Useful Information
My interest in automation comes from the routine work a site engineer handles every day. I want calculations to be easy to follow, records to stay organised, and repeated tasks to take less effort — without hiding the calculation behind a formula.
Quantity Calculation Sheets
Measurement-based calculations for civil work, including converting dimensions and keeping units consistent from the first input to the final quantity.
Material Receipt & Inventory
A structured material-entry workflow with fields such as date, challan number, supplier, location, quantity, and intended use. Dropdowns and entry IDs help keep entries consistent.
Concrete & Cube Test Records
Organised concrete quantity sheets and cube-testing records that help keep pour details, test information, and supporting site documentation together.
Daily Site Documentation
Practical formats for DPR entries, labour attendance, daily photos, material records, and equipment-hour tracking — the information a site team needs to look back and follow up.
Simple, Checkable Formulas
I prefer sheets where the input, unit, formula, and result are easy to understand. The aim is to reduce avoidable manual work while keeping the result open to verification.
My approach
I Start With a Real Task, Then Build the Sheet Around It.
My approach is practical: understand what the site team needs to record, identify the inputs and units, build the formula or entry structure, and test the result against a manual check. A spreadsheet should make the work clearer — not make the user guess how it works.
For example, I have been organising material-receipt entries with supplier selection and automatic entry IDs, and building formula-based records for equipment hours and civil quantity calculations. I continue refining these tools as the requirements of site work become clearer.
- ✓Understand the site requirementDecide what must be recorded or calculated, and which details cannot be missed.
- ✓Keep the calculation visibleUse clear formulas, consistent units, and straightforward layouts that another person can follow.
- ✓Check before relying on the resultCompare outputs with a manual calculation or known site value, and review unusual results.
- ✓Make the record useful laterKeep dates, references, suppliers, and notes organised for review and follow-up.
Examples, sheets & working records
See the Work Behind the Formulas
I have created a separate page for detailed examples and supporting records. Open it to explore the actual sheets and work samples I choose to share as the collection develops.
Explore My Sheets & RecordsShared examples are for professional review and learning; project-specific calculations must always be checked against approved drawings, specifications, and site conditions.
Small Improvements. Better-Controlled Records.
I am interested in practical digital tools that help civil engineers spend less time repeating entries and more time checking the work that matters.
← Back to Yash's Portfolio