Hi everybody,
I have completed a macro for processing GPS tracks from skydiving.
It is working but some of the features are a little clumsy.
I would appreciate some help to iron out the macro.
I am using MS Excel 2003.

A little more infos about the context.
The macro is processing Flysight GPS CSV files.
For those interestest by the device here is the link to the device
http://www.flysight.ca/

The macro grabs the gps file and returns metrics and a few charts.
To get there, the program needs exit time, terminal velocity, pull time and end of parachute deployment time.

I am not trying to figure out an algorithm to find those events in the data.
Those events show up nicely on a glide ratio plot where the X axis is just the row number.
I just check with the mouse the row number on the plot and fill a corresponding cell in the spreadsheet.
I have attached a screenshot to clarify the procedure.
The macro then grabs those data without headaches.

So here is how the macro works
Step 1 w/ button "Formatting" : load the CSV file --> data crunching --> ouput TEMP.xls
Step 2 : Manually input row corresponding to events --> Close file
Step 3 w/ button "Calculations" : Resume data crunching (file path in the macro, needs to be updated to work on other computer!)

I am looking now to improve step 3.
How can I resume the calculations without having to close the file at the end of step 2, and reload it to start step 3 ?
I went to the file closing because I do not know how the resume work on the open file.

I am attaching

J249 FS.CSVEvents.jpgTEMP w input.xlsGPS FS VBA v0.0.xls

the macro
GPS FS VBA v0.0

An input file
J249 FS.CSV

FYI, a temp file with event row number
TEMP w input.xls
(Note the program creates and recalls "Temp.xls")

A screnshot for clarification of the event identification procedure
Events.jpg

A final output file from the current version
J249 FS.xls

Thanks for the help,

Pierre