2012 Cape-to-Cape Event Tracking

***PRB*** · March 27th, 2012, 15:51

For this event, data will be tracked in a Google Docs spreadsheet. Included are data sheets for each pilot, and a summary page that gathers up the key numbers from each pilot's data sheet. Pilots are encouraged, but not required, to enter data for each leg flown. I'm hoping it's self explanatory, but I will keep this up to date in any case. Just don't make any direct edits on the summary page, or bad things will happen.

https://docs.google.com/spreadsheet/...EVOYi1GYl9zU2c

**buzzbee** · April 9th, 2012, 13:58

Can you check the formulas on the spreadsheet? The Race Time column = (Flight Time + Bonus time) - Penalty Time. Shouldn't the formula be (Flight Time + Penalty Time) - Bonus Time ?

Currently my Race Time = My Flight time + my Bonus time.

Thanks
-Buzz

***PRB*** · April 9th, 2012, 15:46

Will check it out in a bit. Thanks. Gotta mow the grass...

***PRB*** · April 9th, 2012, 18:50

Looks like you were correct, Buzz. I had my "guzzintas" and "guzzoutas" backwards. Thanks for the HU.

**buzzbee** · April 9th, 2012, 18:58

Thank you sir. Great little spreadsheet you have put together to total everything up.

***Taco*** · April 10th, 2012, 06:50

Thanks Paul! Ditto what Buzz said.

Jim

***Willy*** · April 10th, 2012, 11:26

Thanks Paul! That was easy enough to update.

**RedGreen** · April 10th, 2012, 21:17

The spreadsheet will definitely make it easier to track both how I'm doing and how my competition's doing in both aspects of the Modern Age class. Thanks for putting it together, Paul!

***PRB*** · April 11th, 2012, 05:03

Thanks shipmates. What would really be cool is if the duenna tracking web site itself could be "configured" to track the data we want for a particular event as the duennas are logged. Then I could just fly...

***PRB*** · May 4th, 2012, 11:37

I just went through all the race threads and updated the spreadsheet. Please check to ensure I haven't missed any bonuses or penalties you may have acummulated along the way...

***Moses03*** · May 4th, 2012, 13:38

Thanks P!

***Dil52*** · May 5th, 2012, 10:55

Originally Posted by PRB

I just went through all the race threads and updated the spreadsheet. Please check to ensure I haven't missed any bonuses or penalties you may have acummulated along the way...

Thanks for the update Paul.

Sorry, I forget to declare the additional 15 minute bonus on Leg #6 LSMI-LFML. (Interlaken to Marseille)

Fred