PUT THE FORMULA INTO PRACTICE
Engineering & maintenance guides
Understand the inputs, check the assumptions and keep useful records.
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 blank Excel register to track quantities, minimum stock, part value, suppliers and equipment criticality without mixing currencies.
Read guide →