On Tue, 27 Dec 2016 10:35:48 -0800, Tony wrote:

Looking to analyze a bunch of igc files for our clubs trophy program.
These will be flights made throughout the year by club pilots often
flying different gliders on different flights. I've investigated using
SeeYou Competition for the scoring but it is not designed for this type
of year long competition.

Alternative I'm thinking about is finding a way to write the SeeYou
statistics to an Excel file where I can then sort to find the highest
speed, best altitude gain, etc.

If you can write the statistics to a CSV (comma-separated variable) file
with a .csv extension, then you can import that into Excel.

The following assumes that you'd want to put the raw stats from each
flight into a separate spreadsheet row.

The only issue with using CSV is that using Excel to combine a set of new
flight stats with the rest of the year's details would be a bit messy,
because it would involve reading the accumulated results into one spread
sheet, each additional set of results into separate spreadsheet(s) and
then using cut'n'paste between sheets to add them to the accumulated
results.

A better way would be to keep the flights database as a CSV file. Then
you can simply append more flight stats to it as you get them, only
pulling the file into Excel for analysis.

I tried a few suggested Pascal methods of writing to Excel but it seems
the Pascal version used in SeeYou Competition does not support this.

Almost every programming language can read and write a properly formatted
CSV file, though the definition of 'properly formatted' can and does vary
a bit, but if you stick to using commas as field separators, enclosing
text fields in double quotes and using normal linefeeds at the end of
each line(row) it should pretty much 'just work', e.g.

# Fields
# ======
# Date,Pilot,Glider,N-number,distance(km),Hours,mins
#
15June2016,"X.C. Pilot","SGS1-26","N12345",300,05,19

Does anyone out there have any ideas on how to get this information
extracted? Thanks,

Does this help?


--
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |