beatquest_djnn wrote:Okay... here's version 2.0... I made mistakes in the speed calculations on the first attempt!
Alt15K_Excel_Extractor_V2.zip
This version works with sample rates of 10 or 20 samples/sec...it has Altitude and derived speed curves calculated with 10 samples intervals to get better average (1 sec or 0.5 sec interval depending on sample rate). It can take up to 20 000 samples and graphics are resizing automaticaly. I added G. force graph but i'ts a bit ugly since it is a derivative of speed... and speed is already a derivative of altitude! Derivative function adds "noise" to an already "noisy" curve. I'll try to integrate filtering and averaging in V2.1 !
The principle is the same: Rename your ".pfa" file to "data.csv" and place it in the Excel extractor directory. Open it and then open "Graph_2007_up.xlsx" or "Graph_1997_2003.xls" depending on your version of Microsoft office. Make sure you have the "Calibri" font installed if you whant the result to look okay...
It's enough for this week! please try it and if possible, post your original ".pfa" files so I can see the result with real Data...
Some screenshots with Perfect Flight sample Data:
screenshot1.jpg
This looks great!
I was wondering if this would work in openoffice or another application. I don't want to give Bill Gates any more money then he already has.
Great program!!! This is really a nice looking utility. One thing, though.... would it be possible to support both of the perfectflite altimeter file formats with one program? We have both models and use them in different rockets and sometimes both on the same rocket. That would be the ultimate! Thanks for the contribution!
It does... it supports both of them! You just have to select 20 or 10 samples per sec on the "imperial" graphic page. The spreadsheet will adjust automaticaly.
Check the specifications on your altimeter model to make sure what sampling rate it uses...
Can you send some of your files so I can view the result with actual data?... Plz!!!!
If it has been done, I can do it...
If not, give me some time to find out how!
I was wondering if this would work in openoffice or another application. I don't want to give Bill Gates any more money then he already has.
Anyone try it with another spreadsheet?
You would have to try it...
Open Office Calc has always given me headaches… For once, Bill made a good job with a program that is Excel! For the rest, I also prefer Open Office for its versatility, but Calc isn’t as efficient as Excel is for my taste…
I’ll try to convert it to fit Calc’s needs next week if it does not work directly… Let me know !
If it has been done, I can do it...
If not, give me some time to find out how!
beatquest_djnn wrote:Okay... here's version 2.0... I made mistakes in the speed calculations on the first attempt!
Alt15K_Excel_Extractor_V2.zip
This version works with sample rates of 10 or 20 samples/sec...it has Altitude and derived speed curves calculated with 10 samples intervals to get better average (1 sec or 0.5 sec interval depending on sample rate). It can take up to 20 000 samples and graphics are resizing automaticaly. I added G. force graph but i'ts a bit ugly since it is a derivative of speed... and speed is already a derivative of altitude! Derivative function adds "noise" to an already "noisy" curve. I'll try to integrate filtering and averaging in V2.1 !
The principle is the same: Rename your ".pfa" file to "data.csv" and place it in the Excel extractor directory. Open it and then open "Graph_2007_up.xlsx" or "Graph_1997_2003.xls" depending on your version of Microsoft office. Make sure you have the "Calibri" font installed if you whant the result to look okay...
It's enough for this week! please try it and if possible, post your original ".pfa" files so I can see the result with real Data...
The design team wants to add support for importing files native to commercially available altimeters so the simulations can be tweaked to match. This may be of interest to you, since you are already familiar with the files.
It looks like a great project with a lot of very experienced contributors. It outclasses the "homebrew" simulators available on the web, and is rapidly catching the commercial simulators currently on the marker. It should surpass them very soon.