Wednesday, February 12, 2014

Low-pass filter and integrator in Excel


Today I want to publish a couple of useful spreadsheet I made to solve electrical circuits.
The first is an integrator circuit: a pulsing DC voltage charges a capacitor in steps. This spreadsheet calculates the voltages across the capacitor over time. It's a pretty complex formula to do it manually.

Download the file

The second spreadsheet calculates the frequency response in a series RLC circuit, in this case the voltage is taken across the capacitor, therefore it's a low-pass filter.

Download the file

No comments:

Post a Comment