Tabellab
Industry Finance Intermediate

Industrial Automation Math: Analog Signal Scaling, Live-Zero Inputs, Tank Levels, Totalisers, Conveyor Speeds & Alarm Limits with Hysteresis

Do the calculations a controls technician does every day: scale raw input counts and current signals to engineering units, detect wire breaks, scale outputs backwards, convert pressure to tank level and volume, add up flow into totals, set conveyor speeds and build alarm limits with deadbands, with every cell checked as you go.

8 lessons 8 labs 2.2 h Certificate

One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.

About this course

This course works through the everyday calculations of a controls technician at a fictional bottling plant. You scale raw input counts to engineering units and back, turn 4–20 mA readings into percent and values and classify wire breaks and out-of-range signals with IFS. You clamp outputs with MIN and MAX and scale them to mA, card counts and a 0–10 V speed reference. You convert pressure to tank level and volume, interpolate a strapping table, total flow by shift with SUMIFS and handle counter rollover with MOD. Then you rebuild timers and counters, flag pumps for service, calculate conveyor speeds and design alarms with deadbands and filters.

Lessons

  1. Linear Scaling: Raw Counts to Engineering Units and BackLab15 min Pro
  2. 4–20 mA Live-Zero Inputs: Percent, Units, Out-of-Range & Wire BreaksLab16 min Pro
  3. Output Scaling: Setpoints to mA, Card Counts & Volts with ClampingLab15 min Pro
  4. Pressure to Level & Volume: Density, Cylinders & Strapping TablesLab17 min Pro
  5. Totalisers: Flow per Interval, Shift Totals & Counter RolloverLab16 min Pro
  6. Timers, Counters & Run-Hours: On-Delay Logic and Service FlagsLab17 min Pro
  7. Conveyors & Encoders: Belt Speed, Required Motor rpm, Pulses to DistanceLab16 min Pro
  8. Alarm Limits with Hysteresis, Moving Averages & Filtered SignalsLab18 min Pro