lz said:
Does Excel support mathematical equations in polar form? Also,
is there a function set for AC circuits?
No, Excel doesn't support complex polar form. You could create text string
using =IMABS(z)&" exp("&IMARGUMENT(z)&"i)" but they'd be a PITA to work
with in subsequent calculations.
As for electric circuits of any sort, Excel, like almost all functional
programming and procedural programming languages, provides no built-in
support for the sort of effectively instantaneous physical effects that any
sort of nontrivial circuit simulation requires. A simple amplified negative
feedback loop can't be simulated in Excel because of this.
In Excel, you'd need to use transfer functions exclusively. Perhaps that's
what you want to do. But you'd also need to forgo polar form except for
final results. But there's no built-in support for circuit elements or
analysis.
There are lots of circuit simulators available as shareware and as open
source, though much of the latter would require that you run them under an
OS other than Windows. There is a version of the venerable SPICE system
available for PCs running Windows. That'd be a much better platform than
Excel for doing anything for circuit analysis. As for signal analysis, most
stats packages provide better tools than Excel, such as ARIMA analysis and
Fourier and wavelet decomposition. The Fourier Analysis tool Excel provides
is a sad joke in comparison.
