Engineers-Excel.com

     
Engineering using Spreadsheets

Bode Plot using Complex Functions

Description
How it works







This tool uses Complex Functions provided under Analysis Toolpak to generate Bode Plots for rational transfer functions upto order 5.

Download

.xls file (285 KB) or .zip file (77 KB)

How to use the tool

Ensure that the Analysis Toolpak add-in is enabled. Key in the numerator and denominator coefficients into the coloured cells, the bode plot is generated.

The following screenshots shows the entries and Bode plot for 1/(s+1)5 from 0.1 to 10 rad/time.


Bode Plot Entries

Bode Plot
Share this page:
Share/Bookmark