Bode Plot using Complex FunctionsDescription| How it works| Butterworth Filter Analysis
This app uses Complex Functions (provided under Analysis Toolpak in Excel 2003) to generate Bode Plots for rational transfer functions upto order 5.
Download.xls file (285 KB) or .zip file (77 KB)
How to useKey in the numerator and denominator coefficients into the coloured cells, the bode plot is generated.
The following screenshots show the entries and Bode plot for 1/(s+1)5 from 0.1 to 10 rad/time.
Also See:Laplace to Time Domain Converter
Nyquist Plot Generator
PID Loop Simulator
Bode Plot Generator