There isn't, and I might make one at some point, but for now you could make another column to take the impedance angle (for the purposes of this) to be =X/R (multiply *180/PI() if you want this in degrees) These should all span from 0 to 90 degrees if done correctly, for the HP filter, and from 0 to -90 for the LP filter, taking XC as negative when calculating X/R. Then, make a column for the angle of the current, this will be minus whatever the previous column was, so negative Z angles will become positive and vice-versa. Finally, for the phase we are looking for the phase angle of the voltage across the output component, and V = I*X. We add the angles here, so to our current column we add either +90 in the case of an inductor (HP) or subtract 90 in the case of a capacitor (LP) This is not an ideal explanation for a youtube comment but hope it helps for now.
@@EngineersAcademyLTD thanks a ton for the reply. It's a bit over my head as I'm mathematically challenged and usually learn from examples ;) I managed to get the graph working in Excel, thanks to your explanation.
Very useful and so sweet that even a physician (MD) understated every thing. I am so thankful for this free knowledge sharing
Wow! I have been searching for this
That was so clear and useful sir .well explained 👏
Thank you so much
Glad it was useful
You are a life saver. Thank you
Hi, great tutorial. How would one do this with inductors in place of the resistors, I would like to plot loudspeaker crossovers?
Is there a video showing how to plot the phase on the above graph?
There isn't, and I might make one at some point, but for now you could make another column to take the impedance angle (for the purposes of this) to be =X/R (multiply *180/PI() if you want this in degrees)
These should all span from 0 to 90 degrees if done correctly, for the HP filter, and from 0 to -90 for the LP filter, taking XC as negative when calculating X/R.
Then, make a column for the angle of the current, this will be minus whatever the previous column was, so negative Z angles will become positive and vice-versa.
Finally, for the phase we are looking for the phase angle of the voltage across the output component, and V = I*X. We add the angles here, so to our current column we add either +90 in the case of an inductor (HP) or subtract 90 in the case of a capacitor (LP)
This is not an ideal explanation for a youtube comment but hope it helps for now.
@@EngineersAcademyLTD thanks a ton for the reply. It's a bit over my head as I'm mathematically challenged and usually learn from examples ;) I managed to get the graph working in Excel, thanks to your explanation.
Amazing thank you
Thank you so much