Oooh, Nooo!!!!
I forgot, I have the imaginary numbers add in installed. You must go to TOOLS ADDINS and select the analysis ToolPak. You must have the Excel CD. The add in lets the spread sheet do complex math. I must use the
=IMEXP() instead of =EXP()
=IMREAL() to get the real part of a complex number
=IMAGINARY() to get the imaginary part of a complex number.
I didn't really need the IMABS() and IMARGUMENT() functions.
The IM???() function are not supported by normal installations of Excel. You must add the add in. I will try think of another way of describing how complex numbers work, but this sheet is pretty good.
It uses Euler's equation. This is in my high school math book.
exp(c*t)=exp(real(c)*t)*(cos(imag(c)*t)+j*sin(imag(c)*t)
Where c is the complex number and t is continous time.
for calculation purposes one must substitute n*T for t.
exp(c*n*T)=exp(real(c)*n*T)*(cos(imag(c)*n*T)+j*sin(imag(c)*n*T)
n is the period number
T is the period between updated.
The problem with the high school math book is that it just presents the formula and doesn't say why it is useful. I can see why we all forgot about this equation when there are so many more 'important' things to think about in high school.