Engineering & maintenance guides
Understand the inputs, check the assumptions and keep useful records. Each guide links to the calculators and templates it supports.
kW, kVA and amps: choosing the right calculation
Understand active power, apparent power, power factor and line current before converting a motor or equipment rating.
Read guide →Instrumentation4–20 mA scaling: check the transmitter and HMI ranges
Check lower and upper range values, linear scaling and out-of-range signals before interpreting a 4–20 mA reading.
Read guide →MaintenanceMTBF and MTTR: prepare a consistent breakdown log
Define operating time, failure count and repair time consistently before calculating equipment reliability and availability.
Read guide →MaintenanceOEE calculation: check availability, performance and quality
Prepare consistent production-time and count data, calculate the three OEE factors and investigate results above 100 percent.
Read guide →MaintenanceHow to use a preventive maintenance planner in Excel
Build an asset task schedule, enter completion dates and use formula-driven due dates and overdue alerts in the blank PM workbook.
Read guide →MaintenanceSpare parts register: stock, reorder alerts and criticality
Use the Excel register to track quantities, reorder and maximum levels, part value, suppliers and critical spares, with order suggestions and slow-moving stock flags.
Read guide →ElectricalMotor voltage and current imbalance: measurement checks
Compare phase readings without confusing magnitude imbalance with a full power-quality assessment.
Read guide →MechanicalCompressed air leak cost and repair payback
Estimate leakage cost using measured flow, pressure-network hours and your electricity tariff.
Read guide →MaintenanceSpare parts reorder levels and stock coverage
Separate stock physically available today from inventory position and incoming purchase orders.
Read guide →MaintenanceProduction downtime cost: contribution versus revenue
Estimate event costs without counting recovered production or avoidable costs twice.
Read guide →ElectricalVoltage drop in cables: how to check a cable run
Understand resistive cable voltage drop, work through single-phase and three-phase examples and learn what the calculation leaves out.
Read guide →ElectricalPower factor correction: sizing capacitor kVAR
Calculate the reactive compensation needed to move from an existing to a target power factor and see the effect on kVA and current.
Read guide →ElectricalTransformer sizing and prospective short-circuit current
Convert maximum demand into a transformer kVA rating, find the next standard size and estimate the upper-bound fault current at its terminals.
Read guide →MechanicalPump power, affinity laws and pipe friction
Estimate hydraulic, shaft and motor power, predict the effect of a speed change and check friction loss in the pipework.
Read guide →InstrumentationPt100 RTD resistance and temperature: converting both ways
How the Callendar–Van Dusen equation links Pt100 and Pt1000 resistance to temperature, with worked conversions, wiring error and loop scaling checks.
Read guide →InstrumentationInstrument calibration error: as-found checks in % of span
How to calculate as-found error in engineering units and percent of span, compare it with a tolerance, and record rising and falling test points.
Read guide →Instrumentation4–20 mA loop voltage budget: will the transmitter reach full output?
How to add up supply, transmitter minimum voltage, receiver, cable and extra drops at maximum loop current to find the voltage margin.
Read guide →InstrumentationZiegler–Nichols PID starting values and control valve Cv sizing
Two instrumentation calculations: classic Ziegler–Nichols PID starting settings and the basic liquid control valve Kv and Cv equation, with limits of each.
Read guide →MechanicalBearing life L10 explained: from load rating to operating hours
What basic rating life L10 means, how load and speed change it, and what the calculation leaves out before you use it for a replacement plan.
Read guide →MechanicalCompressed air receiver sizing for peak demand
Size an air receiver for a short peak demand from the allowable pressure drop, and see how leaks and pressure units fit into the same check.
Read guide →MaintenanceFMEA RPN and Weibull reliability: ranking risk and reading failure data
How to score failure modes with severity, occurrence and detection, why RPN has limits, and how Weibull shape and scale describe failure behaviour over time.
Read guide →MaintenanceMaintenance KPIs: PM compliance, planned work and backlog
Define PM compliance, planned work percentage and backlog weeks, then see how the PM planner and breakdown log dashboards report related figures.
Read guide →