Land surveying
Level Run Adjustment in Excel: Misclosure, Allowable Error and Correction
An Excel sheet for a level book between two benchmarks of known level: it computes levels by the…
Engineering sheets
Land surveying
Vertical Curve Table in Excel: Design Levels, High Point and K-Value Check
An Excel sheet for designing a parabolic vertical curve between two grades: it gives a level table at…
Land surveying
Irregular Plot Area from Coordinates in Excel: Area, Perimeter and Bearings
An Excel sheet that computes the area and perimeter of an irregular plot from its corner coordinates, with…
Land surveying
UTM and Latitude/Longitude Converter in Excel: Precise Krüger Series and Automatic Zone
An Excel sheet that converts latitude and longitude to UTM (easting and northing) and back with Krüger series…
Land surveying
Slope and Gradient Calculator in Excel: Percent, 1:n and Angle for Every Segment
An Excel sheet that computes the slope of every profile segment as a percentage, as 1:n and in…
Project management & contracting
Punch List in Excel: Tracking Closure and Handover Readiness
An Excel punch list for handover: log each item with location, discipline, priority and owner to get due…
Project management & contracting
Heavy Equipment Log in Excel: Cost, Utilisation, Maintenance and Insurance Alerts
An Excel register for owned and rented site equipment: start date, daily cost, fuel, operator and utilisation, with…
Project management & contracting
Submittals Log in Excel: Drawings, Samples, Delays and Float
An Excel sheet to track shop drawings, samples and data sheets sent to the consultant: review dates, status,…
Project management & contracting
Contract Cash Flow and Payments in Excel: Advance, Retention and Peak Funding
An Excel cash flow for a construction contract: from contract value, duration and progress curve it builds monthly…
Project management & contracting
Project Risk Register in Excel: Heat Map, Expected Value and Response Plan
An Excel sheet for managing construction project risks: log risks and score probability and impact to get a…
Quantity takeoff & pricing
Building Cost per m² Calculator in Excel: A Quick Estimate by Type, Finish and Location
An Excel sheet that estimates building cost per square metre: pick building type, finish level and location, enter…
Quantity takeoff & pricing
Doors and Windows Schedule in Excel: Sizes, Areas, Cost and Daylight Ratio
An Excel doors and windows schedule: enter mark, material, size and quantity and it computes areas, cost by…