Exporting Flight Stats from SeeYou

[Tony[_5_]]

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.

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.

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

Tony

[Dan Daly[_2_]]

On Tuesday, December 27, 2016 at 1:35:51 PM UTC-5, 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.
>
> 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.
>
> Does anyone out there have any ideas on how to get this information extracted? Thanks,
>
> Tony

Our club defines our awards with respect to the Canadian OLC. I download the 2016 best and all flights Excel files from the OLC. Once there, you can sort by club gliders, private ships, flight length, etc. As a bonus, when you do this, your OLC participation increases.

Dan
2D

[Martin Gregorie[_5_]]

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 |

[Stephan van den Berg]

I'm also looking for a Excel tool which downloads flights from Soaring Spot or SeeYou and then displays the statistics page from SeeYou for all the flights on any particular day on one page to make analysis between flights easier. I'm thinking of, for example, the following stats:
Speed
Total distance flown
Extra distance flown (total distance flown minus task distance)
Glides
Average glide length
Mean L/D
Ave IAS
Total Climbs
Ave Climb
Tries

Does anyone have something like this to share?

[Tony[_5_]]

On Tuesday, December 27, 2016 at 1:15:35 PM UTC-6, Dan Daly wrote:
> On Tuesday, December 27, 2016 at 1:35:51 PM UTC-5, 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.
> >
> > 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.
> >
> > Does anyone out there have any ideas on how to get this information extracted? Thanks,
> >
> > Tony
>
> Our club defines our awards with respect to the Canadian OLC. I download the 2016 best and all flights Excel files from the OLC. Once there, you can sort by club gliders, private ships, flight length, etc. As a bonus, when you do this, your OLC participation increases.
>
> Dan
> 2D

we have good OLC participation but try to model our club trophies primarily off the sporting code to simulate badge and record flights. speed flights need to be pre-declared (verbal is OK). some trophies are handicapped some are not.