Buy and Download
Jump to information about the simulator
This simulator is available as a MS Excel workbook. It requires MS Excel 97 or later. Simulator cost: $45
There are two ways to pay by credit card: (most major cards accepted. I will not have access to your card number).
By clicking on the BUY and Download, you will be taken to a secure site operated by ClickBank where you will enter your credit card number and credit card address (for credit card verification only). I will not see your credit card number. After your card is verified you will be linked to another page where you will be able to download the E-Book in either or both formats. You may bookmark that page and return in case the download fails or in the future to obtain any free updates I may add.
About the simulator
ControllerSim is a simulation of a controller and a simple process (dead time and three lags) based on Excel spreadsheets in an Excel workbook. The simulator can be used to learn about the PID controller and its elements, process dynamics, and controller tuning.
One spreadsheet is used to simulate the process, another is used to simulate the controller, and a third is used to hold the chart and the tuning and dynamic parameters.
For each of the simulation spreadsheets, one row is used for each second of time.
Parts of workbook
The workbook comprises three pages, or spreadsheets: Main, Process, and Control. All operation of the simulation takes place on the Main page. On that page is the data entry for the process model, the controller tuning, and the chart showing the results. Detailed second by second numerical calculations of the process model and the controller may be found on the Process and Control pages.
The controller used in ControllerSim is a PID controller similar to those used in industrial control. It has derivative on measurement only to eliminate the kick due to setpoint changes. Reset is provided by a positive feedback loop. The output is limited at 0 and 100 percent. The controller uses Gain (100/Proportional Band), Reset Rate (1/Reset Time) in Repeats per minute, and Derivative in minutes. The controller is similar to the one described on the web site: www.jashaw.com/pid/code.htm.
The Process simulation
The process for the simulation comprises one dead time and three lags, all entered in minutes on the main page of the workbook. Because the simulation operates in increments of 1 second, the values are converted into seconds internally.
The minimum deadtime is one second (every digital controller has a dead time based on the scan rate, in this case once per second), or 0.0166 minutes. Any dead time less than that value will be converted to one second. Any dead time greater than 0.0166 minutes will be converted to seconds, in integers.
If a lag is entered that is zero, the lag will not be used in the simulation. If the lag is less that 0.0166 minutes it will be converted to zero.Jump to information about ordering
This page is provided as a service to engineers and others by Process Control Solutions, John Shaw, President. If you have any problem with links on this page, or any other comments, please e-mail me at firstname.lastname@example.org