Engineers-Excel.com

PID Loop Simulator

Description| How it works| Derivative on PV| Process Model| Robustness| PID Tuning| PID Equations



This app simulates a control loop consisting of a first order process with deadtime and a PID controller. Advanced versions of this app are available at the Store.

PID Loop

Download

.xls file (118 KB) or .zip file (27 KB)

How to use

The process is specified by the process gain, time constant and dead time (see the Process Model page for more details).  The PID controller has 3 parameters: gain, integral and derivative. Key in these values into the appropriate cells. If the integral time is keyed in as 0, the integral term is ignored.

The response to a step change in the set point is displayed in the chart.

The screenshot below shows an example of the inputs and the output chart.

PID Simulator

Feedback and Contributions from Visitors

The PID Simulator tool has been the most downloaded tool on this site and I am both happy and grateful to recieve lot of positive feedback about it from the visitors to the site.

Torcuato Fernandez pointed out an error in original version, which has since has been corrected. I would like to thank Torcuato for pointing out the error.

Jose Maria, has shared some of his work with me and has kindly agreed to let me share it with others through this site. He has added scrollbars to the tool, which assist the user understand how the controller settings affect the loop.

Download the file here.

I also get a lot of queries on the form of the controller equation used in this app - for a discussion of the different equations and to download the tool containing the ideal form of the PID equation, visit the PID Equations page.

For any comments and discussions on this app, you can join and initiate a discussion on the open Linked-in group Engineering Using Spreadsheets.

(Alternatively, email mehta.nitin@gmail.com )

I look forward to getting more great suggestions and comments. Thank you! :)

More PID Simulators in the Store

If you like this app, you may wish to purchase advanced versions from the Store.

The Extended PID Loop Simulator is an extention of this app that also includes PID simulation of an integrating process (such as level or pressure) and also displays open and closed loop responses. At just $9, this app is great value.

PID Simulator

The Advanced PID Loop Simulator  is a powerful PID Simulation tool for use in industry. It is meant to be used for offline loop tuning before implementing on the actual process. It also makes a great tool for self learning and for training engineers and technicians.

Advanced PID Simulator

More Control Simulators

Simulation of On Off Control

PI Control of First Order Process

PI Control of Integrating Process

Simulation of a Model Predictive Controller (MPC)

Also See:

Instrument Loop Drawings using Excel

Excel OPC Client

Bode Plot Generator

Nyquist Plot Generator