SW Pacific Tour Standings and Statistics

[PRB]

Here's my tracking spreadsheet for the race. I'll keep it updated as we go, unless I fall behind, like right now... It's just an OpenOffice spreadsheet saved out as an html file. Pretty cool.

http://www.prbsystems.com/AirRacing/SWPAC/Progress.html

[salt_air]

Nice work Paul!!

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


:ernae:

[Moses03]

Cool. Thanks P!

[robert41]

Nice. Thanks Paul.

[apollosmith]

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.

[PRB]

That's cool! I have to get with these Google tools...

[salt_air]

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.

[PRB]

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.

[salt_air]

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.

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?

[PRB]

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?

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.

[apollosmith]

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.

[salt_air]

I will have all in place around noon today EDT.


Thanks

[EdGeneer]

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!

[Moses03]

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?

[PRB]

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...

[PRB]

Ok, spreadsheet updated. Just click on the link in the first post of this thread.

[buzzbee]

Is there a paste Special in Google spreadsheets to just copy formula's but not the data?

[buzzbee]

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.

[mickj300]

Added my sheet, loaded my legs - simples!

[PRB]

Numbers updated:

http://www.prbsystems.com/AirRacing/SWPAC/Progress.html

[srgalahad]

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

Feel free to modify as you see fit... or don't use it at all.

Thanks for the sheet!
My numbers are in
(10:17:17 is the total)

Rob

[PRB]

Submitted my numbers into Apollosmith's cool Googlesheet, and updated my backup as well. Thanks, AS!

[PRB]

Updated numbers:


http://www.prbsystems.com/AirRacing/SWPAC/Progress.html

[DHC120]

Paul;
Thanks for the "special" update of my stats..
I appreciate, and hope the others do as well, all your efforts, hard work
and dedication to put on this event.. You, Sir, are truly an unsung hero :salute:
(okay, I can't sing, and you wouldn't want me to..)
Charles.

[PRB]

Thanks Charles. It's been fun. We've got another "job" coming soonish, as you saw MM's thread here aluding to. A different sort of challenge.