PID Tuning Spreadsheet

[Bootalito]

I developed this tool a while ago and thought I'd share.  This is a spreadsheet that I use to tune PID loops, specifically the PID ladder logic function block in Allen Bradley PLCs.  There is lots of software that can automate this (TuneWizard is another I use), however for a quick PID tuning job that gets it 95% optimized (really all you need for most industrial control) this spreadsheet is pretty much all I use.

https://www.dropbox.com/s/m4czdt3ex253z0b/PID%20tuning.xlsx?dl=0

A couple of notes:
1. The PID parameter units are in minutes not seconds (because AB's PID block was programmed that way).
2. The PID parameters calculated are for the dependant PID equation, whereas most people are used to Independant equation, or Velocity Form as in ABs PIDE function block.  There is a little converter section in the spreadsheet to go between the two.  Arguably the Dependant equation is better, but Independant is easier to understand.  If anyone is interested I can explain

I haven't tried using it to tune many things that are not ABs PID function block, however with a little tweaking it would work fine, as the math is all there.  For example, if you wanted to tune a loop using the arduino PID library (https://github.com/br3ttb/Arduino-PID-Library), you would want to do two things: 1. In the Closed Loop Tuning Method get rid of all of the "/60"'s in I and D. 2. Whichever parameters you want to try use the "Independent / Dependent Conversion" table on the right to convert to Independent, and I can almost guarantee that the numbers will work as I've studied that library with the intention of using it for some projects, and its sound.

[windsoul]

the file has been deleted. Could you please update it?
thx

[sorin]

Im not the author, but I saved it my pc.