Downloadable Workbook Library

Excel Engineering Workbook Library

Fifty real Microsoft Excel workbooks, one engineering method each. Download the .xlsx, open it in Excel, Sheets or LibreOffice, enter your own values on the Inputs sheet, and every calculation and PASS / WARN / FAIL check recalculates from the method stated inside the workbook.

Water • ro

RO Mass Balance

Verify feed, permeate and concentrate flows and the salt balance of an RO train.

Water • ro

RO Recovery & Concentrate Flow

Compute permeate and concentrate flows from feed flow and recovery percentage.

Water • ro

RO Energy & Operating Cost

Estimate membrane train energy use, specific power and operating cost per m³.

Water • ro

RO Scaling & Saturation Indices

Langelier, Ryznar and Stiff & Davis indices for RO concentrate scaling tendency.

Water • ro

RO Membrane Element Count

Estimate required 8-inch membrane elements from flux, feed pressure and concentration factor.

Water • treatment

Chemical Dosing (Anti-scalant / Sanitizer)

Dose rate of anti-scalant or sanitizer chemical from target concentration and flow.

Water • hydraulics

Pump Total Dynamic Head

Compute total dynamic head from static lift, friction and minor losses.

Water • hydraulics

Pipe Head Loss (Hazen–Williams / Darcy–Weisbach)

Friction head loss and pressure drop in a water line by two methods.

Water • hydraulics

Pipe Sizing by Velocity & Pressure

Select nominal pipe size for design flow within velocity and pressure-drop limits.

Water • hydraulics

Open Channel Flow (Manning)

Channel and pipe capacity and normal depth by Manning's equation.

Water • resources

Water Demand & Peak Flow

Average, design and peak flow demand with fire and storage allowance.

Water • storage

Water Storage Tank Sizing

Size a gravity storage tank for capacity and peak-withdrawal duties.

Water • storage

Tank Fill / Empty Time

Time to fill or empty a tank given inlet/outlet rates.

Water • surge

Water Hammer (Joukowsky Surge)

Estimate surge pressure from sudden valve closure in a pipeline.

Water • treatment

Disinfection CT (Chlorine Contact)

Verify chlorine residual × contact time against pathogen inactivation requirement.

Water • stormwater

Stormwater Runoff (Rational Method)

Peak runoff from a catchment by the rational method.

Structural • rc

RC Beam Design (BS 8110)

Flexural and shear design of a singly reinforced rectangular beam.

Structural • rc

RC Slab Design (One / Two-Way)

Flexure, shear and deflection check for slab panels by simplified methods.

Structural • rc

RC Column Design (Short Column)

Axial capacity and reinforcement of a short braced column.

Structural • rc

Isolated Footing Design (ACI 318)

Pad footing: bearing, one-way shear, punching shear and flexural steel.

Structural • geotech

Retaining Wall Stability (EC7)

External stability of a gravity or cantilever retaining wall: sliding, overturning, bearing.

Structural • steel

Steel Beam Design (Elastic)

Elastic section modulus design and shear check for a hot-rolled beam.

Structural • geotech

Pile Capacity (Static Method)

Estimated ultimate and allowable static capacity of a pile from soil layers.

Construction • quantities

Concrete & Rebar Quantity Takeoff

Concrete volumes and reinforcement weights for common structural elements.

Construction • quantities

Bar Bending Schedule

Cutting schedule of reinforcing bars with unit and total steel weights.

Construction • mix

Concrete Mix Design (Absolute Volume)

Batch proportions per m³ by the absolute-volume method.

Construction • earthwork

Earthwork Cut & Fill

Cut, fill and net volumes by grid or cross-section areas.

Construction • earthwork

Trench & Excavation Quantity

Trench excavation and bedding/fill volumes.

Construction • quantities

Masonry & Blockwork Quantity

Blocks per m², mortar volume and cement/sand for masonry walls.

Construction • quantities

Slab Volume Calculator

Volume of slabs by method, with rebar and form-work estimates.

Construction • quantities

Pavement Quantity Takeoff

Layer volumes and masses for road pavement.

Construction • quantities

Bill of Quantities Extensions

Itemised BOQ with automatic extensions, sections and totals.

Construction • sustainability

Steel Embodied Carbon (Screening)

CO₂e of reinforcing steel tonnage with published EPD factors.

Project • cost

Rate Analysis (Construction Item)

Build an all-in unit rate from materials, labour, plant and overheads.

Project • cost

Project Cost Estimate

Category-based estimate with contingency and escalation.

Project • cost

Interim Payment Certificate (IPC)

Monthly payment computation from measured BOQ values, retention and recoveries.

Project • cost

Material Reconciliation

Compare received vs theoretical use, with wastage and variance value.

Project • project

S-Curve & Earned Value

Plan vs actual progress S-curve with earned value metrics (SPI/CPI).

Mechanical • hvac

HVAC Cooling / Heating Load (Simplified)

Peak room load estimate by transparent component method for screening.

Mechanical • hvac

Duct Sizing (Velocity / Friction)

Round and rectangular duct sizing from flow and velocity or friction rate.

Mechanical • pumps

Pump Sizing & Duty Point

Convert flow and system head into a duty point and absorbed power.

Mechanical • hvac

Chilled Water Flow & ΔT

Flow required for a chilled-water duty at design ΔT.

Mechanical • thermal

Heat Exchanger LMTD / Sizing

Required area or duty from LMTD (single-pass) with correction factor.

Mechanical • air

Compressed Air Demand & Receiver

FAD demand from tooling load factors and receiver volume estimate.

Electrical • cables

Cable Sizing & Voltage Drop (IEC)

Conductor selection for current capacity and voltage drop with adiabatic check.

Electrical • distribution

Load Schedule & Diversity

Connected load to diversified demand for panels and feeders.

Electrical • power

Generator / Standby Power Sizing

Size a generator from load schedule and starting conditions.

Electrical • power

UPS & Battery Sizing

UPS rating and battery capacity for required autonomy.

Electrical • lighting

Lighting Design (Lumen Method)

Luminaire count and spacing for target illuminance by the lumen method.

Electrical • distribution

Transformer Sizing

Transformer rating from diversified load with margin.