If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exporting Flight Stats from SeeYou
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 |
#2
|
|||
|
|||
Exporting Flight Stats from SeeYou
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 |
#3
|
|||
|
|||
Exporting Flight Stats from SeeYou
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 | |
#4
|
|||
|
|||
Exporting Flight Stats from SeeYou
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? |
#5
|
|||
|
|||
Exporting Flight Stats from SeeYou
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Latest update of SeeYou and OLC flight claims causing problems | [email protected] | Soaring | 6 | October 30th 14 07:59 PM |
PowerFLARM Flight Circles in SeeYou | John Carlyle | Soaring | 5 | June 7th 13 03:02 PM |
Flight track playback in Google Earth using SeeYou 4.1 | Andy[_10_] | Soaring | 1 | July 1st 11 02:49 AM |
SeeYou Flight Display | Hal[_2_] | Soaring | 12 | January 11th 09 12:27 PM |
OLC 2006 flight uploads with SeeYou | Ted Wagner | Soaring | 2 | October 15th 05 05:31 AM |