Login | Register

Guru
Panama - Member - New Member Hobbies - CNC - New Member Engineering Fields - Marine Engineering - New Member Engineering Fields - Retired Engineers / Mentors - New Member

Join Date: Dec 2006
Location: Panama
Posts: 1248
Good Answers: 51
#27
In reply to #25
Find in discussion

Re: Linux Issues

05/17/2008 11:27 AM

You need the Analysis Tool Pack, which comes (came?) with the Office CD, but you have to load it specifically. In this tool pack, along with some useful statistical functions, is an fft. It can only handle 4096 data points, which is generally to small for me, but OK for a quick look. Output is complex numbers, and you have to do some conversion to make them useful, but, as I say, It's OK for a quick look...Mostly, I am trying to strip the data of frequency components I can explain, then see if there is any structure left in the noise...

I have not been able to find the Analysis Tool Pack for Excel 2003, which does not mean it doesn't exist, it just means I can't find it. The tool pack was included with my Office 2000 CD. I haven't tried to add the Excel 2000 tool packs to Excel 2003- maybe that would work.

I have another little trick you might be interested in- I wrote a VBA package to read data from my digital multimeter directly into Excel, and output not only a time record, but a "real time" chart recorder (slow, but when I'm using it, I am generally not looking for fast refresh). I had to add a program called XMCOMM to accomplish this, because Microsoft is pretty stingy and won't give you the communications dll's unless you buy the full VB package (I used the abreviated version of VB that comes with Excel 2000). I believe XMCOMM was actually written by a Microsoft insider, but I am not sure. If you have a similar need, I can send you the macro and point you to XMCOMM. Send me an e-mail.

Now maybe you have a better perspective on why I don't like Excel 2003, and consider is a degrade rather than upgrade?