Stephen Guimond wrote: Hehe, either Stephen or Steven is fine. Thanks for the Fourier analysis! I hadn't tried it yet. How did you import the data into MathCAD? While that file is very useful, it still doesn't answer my original problem with Excel 2007. The data is just some basic high frequency/low frequency interference on a simple periodic signal. |
Stephem,
Just make sure your Passeport is OK.
It's OK to receive data from foreign software as Excel table, but reading from Mathcad is source of all troubles as well as the version of Windows . My Office 97 research and VB got zapped by Office 2000 ! No way to recover [lost patience trying]. My actual Office 2000 does not recover your Excel 2007 ... no scroll function, hardly the column select, which column select I have transited via ORIGINLAB 7.5 [I could have pasted as "paste table" directly in a Mathcad input table. If colleagues collect data from some equipment, would it possible to have the data saved as *.dat or *.txt ? Mathcad reads those two directly from file. The *.prn was from Labtech [DBase ...] and not sure if compatible with the Mathcad *.prn version ? That does not solve your problem. The READFILE is a module introduced in the Mathcad 11 DAEP [Data Analysis Extension Pack, 2003]. It might read your Excel 2007. Leslie was generous enough to give the coding of READFILE. If you want to try, will be glad. Many more collabs are keen on that stuff and may read you and offer an alternative. Mona as well will be delighted helping.
Not sure if you can easily separate the two components high/low frequency. The other thing is that your signal suffers [invisibly] the digitization noise. A very small "ksmooth" gets rid of that little noise. All that is to say that eventually if you specify more about your project, it will capture interest and participation.
Jean
