I’ve been calculating a lot of components in series lately for an ECR255 class. I’ve also had to graph them on impedance diagrams and a power triangle.
In an effort to better understand the math I made a calculator for myself. Here is it for you to use and enjoy. If you see any problems please let me know. It was designed in excel 2011 for mac… there WILL be compatibility issues and I hope they’re minor.
How it works:
You can fill int the info you have in the orange boxes. Once the boxes are filled in the calculator should fill in the rest.
If you need to modify anything else, it’s all dependant on the orange boxes. I suggest a goal seek by modifying and orange cell.