Here we can simulate a process variable or create a disturbance and observe the PID controller response with different set of PID controller gains.
Download the PID controller simulator created using excel and learn about how to tune a controller and observe its response.
INDEX OF PID CONTROLLER SIMULATOR EXCEL
Sheet 1 contains basic instructions for using this excel PID controller simulator.
Sheet 2 contains the PID Controller Simulator.
Sheet 3 contains various types of parameters set for different PID controllers.
Sheet 4 contains baisc theory of a PID controller philosphy.
Sheet 5 contains baiscs of PID simulator functions.
Sheet 6 contains PID controller calculations (Internal Purpose).
http://www.automationforum.co/2015/11/free-pid-loop-simulation-office-excel.html