Is there a good excel program somewhere or basic breakdown of how to implement a control loop in excel if trying to simulate the performance of a circuit? I have data from an operating plant and am trying to simulate the control loop but I'm not getting the correct outputs for the loop inputs.
Update: I think what i'm missing is basic. I have cv, mv, and sp and I'm trying to simulate the controller. I have the PID settings for the controller as well (I think it was Siemens). Gain is 0.8, Integral time is 15 seconds and i have data on a 2 second sample time (I realize this is low resolution). The issue i'm having is i'm looking at output between t1 and t2 and trying to pull the appropriate data to estimate the PID output but i am consistently getting a different delta and i think I'm just setting it up wrong mathematically.