Engineers-Excel.com

Bode Plot using Complex Functions

Description| 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 use

Key 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.

Bode Entries

High Order Bode Plot

Also See:

Laplace to Time Domain Converter

Nyquist Plot Generator

PID Loop Simulator

Bode Plot Generator