Icon

Day3_​S2_​ok

Stage 1 - Read and align

Read what S1 wrote and put every row on an hour clock

Stage 1


  1. Read the S1 hourly file, 2,894 rows
  2. 8 hour backward mean of flow = ma8
  3. Watch window start as a real date
  4. Hours from 1 Jan, negative = before

Stage 2 - Fit the baseline on 2024

Three models fitted on the reference window only, each one scored

Stage 2


  1. Split reference (743 h) from watch (2,151 h)
  2. temp ~ flow now, R2 0.8015
  3. temp ~ ma8, R2 0.9424 - the driver wins
  4. Reference mean and SD become flow variables

Stage 3 - Score the watch window

Turn the residuals into three z descriptors and flag 3SD

Stage 3


  1. z_temp, z_vib and z_ratio on one axis
  2. z_ratio uses no model at all, for comparison
  3. Alarm when |z| > 3
  4. Roll the hours up to one row a day

Stage 4 - Confusion matrix

Score each descriptor against the work order, day by day

Stage 4


  1. Label every day TP / FP / FN / TN
  2. Unpivot, then pivot to a 3 x 4 matrix
  3. Empty cells become 0 before dividing
  4. precision and recall per descriptor
Node 60Apply the vibration modelp_vib
Regression Predictor
Node 61Score the vibration modelR2 0.9263
Numeric Scorer
Node 80Session result tablez_vib recall 1.000
Table View
Node 81Write residual file for S32,151 rows
CSV Writer
Node 64Baseline constants to vars6 variables
Table Row to Variable
Node 43Read the S1 hourly file2,894 rows
CSV Reader
Node 65Apply temp model to watchp_ma8
Regression Predictor
Node 62Residuals on the referencesd 0.6923
Expression
Node 63Reference mean and SDsd_vib 0.0661
GroupBy
Node 46Rename Mean(flow) to ma8no brackets
Column Renamer
Node 68Three z on one axisz_vib climbs
Line Plot
Node 47Watch window start as textsame every row
Expression
Node 69Spread of z_viblong right tail
Histogram
Node 44Parse ts_hour0 failed
String to Date&Time
Node 66Apply vib model to watchp_vib
Regression Predictor
Node 458 hour mean of flowmedian 143.4
Moving Aggregator
Node 67Residuals + 3 descriptorsz_vib +3.98
Expression
Node 48Parse bound to date timeone value
String to Date&Time
Node 49Hours from window start-744 to 2159
Date&Time Difference
Node 71Flag the rows of PUMP-022025-02-22
Expression
Node 50Flags is_ref is_pre + vpfref 743 h
Expression
Node 723SD alarm flags + eventz_vib 471 h
Expression
Node 70Read the work orders12 events
CSV Reader
Node 53Option A: temp ~ flow nowb = 0.11046
Linear Regression Learner
Node 75Label each day TP FP FN TN3 columns
Expression
Node 54Apply A to the referencep_flow
Regression Predictor
Node 76Turn 3 columns into rows270 rows
Unpivot
Node 51Reference window rows743 hours
Row Filter
Node 73Day number floor(h/24)day 0 = 1 Jan
Expression
Node 52Watch window rows2,151 hours
Row Filter
Node 74Roll up to one row a day90 days
GroupBy
Node 57Apply B to the referencep_ma8
Regression Predictor
Node 79precision and recallz_vib R 1.000
Expression
Node 58Score B, pick the driverR2 0.9424 wins
Numeric Scorer
Node 55Score option AR2 0.8015
Numeric Scorer
Node 77Count and pivot to a matrix3 x 4 matrix
Pivot
Node 56Option B: temp ~ ma8b = 0.12571
Linear Regression Learner
Node 78Empty cell counts to 0no blanks
Missing Value
Node 59Vibration ~ flow nowb = 0.01002
Linear Regression Learner

Nodes

Extensions

Links