alt15k output

Post by **160psi** » Mon Mar 28, 2011 2:47 pm

What is the best way to get the graph produced by the alt15k onto the forum?

Post by **WRA2** » Mon Mar 28, 2011 3:42 pm

160psi wrote:What is the best way to get the graph produced by the alt15k onto the forum?

You can do a "print screen" Then paste it into "paint", crop the edges (to get rid of whatever else was on the screen at the time the "print screen" was done) and save as a jpeg image. Then simply upload the image to the forum as an attachment.

Hope that helps.

Post by **160psi** » Mon Mar 28, 2011 3:47 pm

thanks I'll have a go

Post by **Spaceman Spiff** » Tue Mar 29, 2011 8:53 am

WRA2 wrote:
160psi wrote:What is the best way to get the graph produced by the alt15k onto the forum?
You can do a "print screen" Then paste it into "paint", crop the edges (to get rid of whatever else was on the screen at the time the "print screen" was done) and save as a jpeg image. Then simply upload the image to the forum as an attachment.

Hope that helps.

You could just load up the flight data file too. The software they use is free so anyone could read it in.

I wonder if there's a way to get an excel sheet to display on the forum? That would be really ideal.

Post by **SaskAlex** » Wed Mar 30, 2011 11:19 pm

If you go the print screen route (that's my recommendation, too- I already have the software but I'd still be too lazy to download the graph to look at in most situations) you can just hit alt+printscreen. That just captures the active window so you have no cropping to do.

Alex

Post by **Spaceman Spiff** » Thu Mar 31, 2011 12:58 pm

SaskAlex wrote:If you go the print screen route (that's my recommendation, too- I already have the software but I'd still be too lazy to download the graph to look at in most situations) you can just hit alt+printscreen. That just captures the active window so you have no cropping to do.

Alex

I always wondered how to get just the window. I have been using paint to crop for years! Thanks!

Post by **U.S. Water Rockets1** » Sat Apr 02, 2011 9:51 pm

One of our old MSN group users had created an Excel spreadsheet importer for Perfectflite altimeters. If anyone here remembers what it was called, we could probably find it in the archives and upload it here.

Post by **beatquest_djnn** » Wed Apr 06, 2011 2:02 pm

Send me the output file... I'll code an excel importer for you in a minute ;)

I'll make it avaliable for everyone after that.

beatquest_djnn@hotmail.com

Post by **Spaceman Spiff** » Wed Apr 06, 2011 9:19 pm

beatquest_djnn wrote:Send me the output file... I'll code an excel importer for you in a minute ;)

I'll make it avaliable for everyone after that.

beatquest_djnn@hotmail.com

I tried importing a file directly but the file doesn't contain the time values only the altitudes. I think you can input formulas into excel that generate that column automaticaly. I am a total n00b at excel so I have no idea how to do any of that. I just know the program is a billion times more powerful than what I use it for.

Post by **beatquest_djnn** » Thu Apr 07, 2011 6:06 pm

There you go... a solution that I believe would be really complete and usefull for you guys!

Coded for Excel 1997-2003 and 2007-up... just open the file you need. The difference between old version and 2007+ version is that the "data.csv" file does not need to be opened for the fields to automaticaly update in newer version...

You just have to rename the output file to data.csv and paste it in the folder before opening the Graph_1997-2003.xls or Graph_2007_up.xlsx file

It is programmed to get data for a maximum of 5.7 minutes (the max. recording time of the Alt15K) in increments of 0,1 sec. Graphics are scaled automaticaly. I added speed curve with a 1 second interval between each mesurements (to reduce oscilation in the displayed curve)

I included the original example file from PerfectFlite named "3FNC on B6.pfa"... I renamed it to "data.csv" and VOILÀ !

Give it a try and leave me some feedback please...

EDIT 2: I have remove the file because it has errors inside... speed is not calculated the right way!!! V2.2 will be online in an hour or so ...

Post by **beatquest_djnn** » Thu Apr 07, 2011 6:14 pm

I could add acceleration to the graph if needed.. just tell me!

Post by **Spaceman Spiff** » Fri Apr 08, 2011 11:38 pm

beatquest_djnn wrote:I could add acceleration to the graph if needed.. just tell me!

I would like that VERY much!

Thanks for inputting this effort to the community! You rock!

Post by **beatquest_djnn** » Sat Apr 09, 2011 12:10 am

Did you try it??? I'dd like to know how it works with actual data.. in the meantime, I am working on V1.1 tonight... I'll probably call it V2.0 since I started all over due to a flaw in my original programming concept... I'll be using normal curve unstead of XY scatter graph...

Post by **beatquest_djnn** » Sat Apr 09, 2011 12:24 pm

Okay... here's version 2.0... I made mistakes in the speed calculations on the first attempt!

Alt15K_Excel_Extractor_V2.zip: (2.01 MiB) Downloaded 543 times

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 (62.7 KiB) Viewed 62 times

Sat Apr 09, 2011 10:34 pm

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

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!

Water Rocket Forum

alt15k output

alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output

Re: alt15k output