• There seems to be an uptick in Political comments in recent months. Those of us who are long time members of the site know that Political and Religious content has been banned for years. Nothing has changed. Please leave all political and religious comments out of the forums.

    If you recently joined the forums you were not presented with this restriction in the terms of service. This was due to a conversion error when we went from vBulletin to Xenforo. We have updated our terms of service to reflect these corrections.

    Please note any post refering to a politician will be considered political even if it is intended to be humor. Our experience is these topics have a way of dividing the forums and causing deep resentment among members. It is a poison to the community. We appreciate compliance with the rules.

    The Staff of SOH

  • Server side Maintenance is done. We still have an update to the forum software to run but that one will have to wait for a better time.

SW Pacific Tour Standings and Statistics

Nice work Paul!!

We need to chat when the race is over this could be just the ticket for tons of events.


:ernae:
 
If it helps at all, I started to put this in a Google Spreadsheet - https://spreadsheets.google.com/ccc?...thkey=CJfXw84O

Anyone can go in and add/edit. Maybe pilots could be encouraged to do their own.

Edit ONLY columns A and B (Pilot name and class) in the Totals sheet and ONLY columns A-D and F in each pilot's sheet.

To add a new pilot, add their name and class to the Totals sheet, duplicate an existing pilot's sheet at the bottom, rename it to the new pilot's name (make sure spelling is same as column 1), clear out the data in columns A-D and F (don't delete the data in column E), and start entering the new information (Orig, Dest, Distance, and Flight Time). So long as the pilot's name in the first column in the Totals sheet matches the name of that pilot's sheet, it should do most of the work for you.

Feel free to modify as you see fit... or don't use it at all.
 
Yeah, we can all do this ...


Hey Smitty ... what values did you use for the speed entries?

Average Ground or Indicated?



Be somewhat easier to go through and double check or verify, than it would be to have to do it all.



Let me know Paul ... if you want us to do that, I'll get right after it.
 
Lets give it a shot and see how it goes. Looks like the average speed values are calculated (dist/time), which is what I was doing. I'll continue my data gathering as a backup.
 
PRB said:
Lets give it a shot and see how it goes. Looks like the average speed values are calculated (dist/time), which is what I was doing. I'll continue my data gathering as a backup.
Click to expand...



Okay ... leave speed blank ... record Flight Time and Distance Flown ... correct?

or isn't the figure you come up with the same a avg ground speed?



I don't know mista ... I jus work here okay?
 
salt_air said:
Okay ... leave speed blank ... record Flight Time and Distance Flown ... correct?

or isn't the figure you come up with the same a avg ground speed?



I don't know mista ... I jus work here okay?
Click to expand...

My comments about the speed was in response to what I thought was your question to Apollosmith about what sort of speed he was recording. It looked to me like he was calculating average speed using distance and time from the duenna file, which is what I'm doing.

Really, the only value that is needed to time. The winner will be determined, in each class, by the shortest time, overall. I'm calculating average speed just as a curiosity. So, as long as time is added up for each leg, we can figure out the winner.
 
Yep, just add time (apparently "Flight Time", not "Baton Time") and distance from the Duenna. It will calculate your average speed for that leg (and for all legs) automatically. It's just distance/time.
 
Nice.... Took me a sec or two to figure out how to duplicate a sheet, but I got it.... (for those wondering as well, yhou go to the name of the sheet you want to duplicate, on the name/sheet tab, click the triangle, when the menu pops up, it will give the option to duplicate, then click the duplicate sheet tab, click the triangle on the tab again, then select rename, then name it to the SAME name you used on the totals sheet...)

Very Nice Smitty! Thanks!
 
Was wondering where we were at on the standings. We supposed to fiddle with the google sheet now?

Paul- have you abandoned your initial stats and such?
 
No, I haven't abandoned mine. I am working on updating my spreadsheet now. I have been "derilic" in my progress tracking duties this week and am now playing "katchup". I think the Googlespreadsheet is meant to be updated by each pilot. Not 100% sure about that, however...
 
Ok, spreadsheet updated. Just click on the link in the first post of this thread.
 
I wish I new more about XML as it seems like there should be a way to pull out the pertinent values from the Duenna Text file and load them on a web page.
 
You must log in or register to reply here.
Back
Top