Hello to all.
In a previous project I captured plenty of process data, like setpoints, measurements, PID output, Lead/Lag output, and many more points. I import selected data points in Excel, I generate similiar algorithms in Excel (like PID or Lead/Lag and etc.) that simulate a loop or two similiar to the logic that generated the data, and run a macro. I compare it to the captured data and when outputs match I know the code is a match. I then inject a transient by increasing the measurement or setpoint or other and monitor output initial behavior. I also use it to change PID gains and to get a an idea of how controller will initially behave or how output behaves at steady state.
Question, doing this in Excel is very tedious because PID controller and others require previous data and the worksheet gets big. Is there software out there tailored for this? I want a software that will allow me to generate my own code and inject data from a text file and also capture the calcualted data? I don't want to spend much time putting this test together, I want to spend most of my time evaluating the data. Any help is greatly appreciated.