Some 2012 race statistics

[Spookster67]

All the flights' data is captured now, so...

Here's Team Avsim pilots times and flights.

Row Labels	Sum of Time	Count of State
Bry Rosier	18:26:30	11
primary baton	06:42:42	4
wingman	07:54:23	6
ok	03:49:25	1
Arrvoo2	16:46:13	9
primary baton	07:34:32	5
wingman	09:11:41	4
Highmike	16:34:24	10
primary baton	04:30:55	3
wingman	12:03:29	7
Epwatson	15:28:34	8
primary baton	12:54:59	6
wingman	02:33:35	2
Jeff_w	14:14:30	8
primary baton	04:48:35	3
wingman	05:04:12	3
ok	04:21:43	2
Spokes2112	13:09:41	9
primary baton	07:31:48	5
wingman	04:38:34	3
ok	00:59:19	1
Rndguy	11:40:37	8
primary baton	09:34:32	6
wingman	01:38:01	1
ok	00:28:04	1
Jockha	11:37:53	10
primary baton	05:22:14	5
wingman	05:48:08	4
ok	00:27:31	1
Rgo	11:27:12	7
primary baton	03:07:02	2
wingman	07:56:12	4
ok	00:23:58	1
Buzzbee	11:12:58	7
primary baton	03:42:33	3
failed primary baton	02:59:10	1
wingman	03:31:44	2
ok	00:59:31	1
Lowflyer	09:23:21	6
primary baton	00:51:10	1
wingman	04:14:06	3
ok	04:18:05	2
Darkcharizma	09:22:42	8
primary baton	02:58:38	2
wingman	05:01:53	4
ok	01:22:11	2
Mm	09:16:50	7
primary baton	01:44:25	1
wingman	06:06:56	4
ok	01:25:29	2
Cavalierduck	07:26:06	5
primary baton	03:40:12	2
wingman	01:45:19	1
ok	02:00:35	2
Stonec0ld	06:54:05	5
primary baton	03:55:38	3
wingman	02:58:27	2
L_schuiling	06:33:36	5
primary baton	02:45:41	2
wingman	02:47:27	2
ok	01:00:28	1
Cbtaylor	04:07:17	3
primary baton	01:40:20	1
wingman	02:26:57	2

[Spookster67]

And here's Flightsim pilots times and flights.

Row Labels	Sum of Time	Count of State
Wombat	18:47:15	12
primary baton	12:54:11	8
wingman	04:59:33	3
ok	00:53:31	1
Freebird	16:30:16	10
primary baton	11:41:41	8
wingman	04:48:35	2
N3306tx	13:52:30	10
primary baton	01:56:20	2
wingman	11:02:51	7
ok	00:53:19	1
Apollosmith	13:36:27	8
primary baton	10:35:29	5
wingman	01:46:07	1
ok	01:14:51	2
Salt_air	12:09:18	11
primary baton	04:39:57	4
failed primary baton	01:34:07	1
wingman	05:31:46	5
ok	00:23:28	1
Wtr755	11:59:47	7
primary baton	05:40:52	3
wingman	05:26:51	3
ok	00:52:04	1
Venture06	11:12:13	7
primary baton	06:22:46	3
wingman	03:47:21	2
ok	01:02:06	2
N350bc	09:11:04	9
primary baton	03:20:23	3
wingman	05:26:16	5
ok	00:24:25	1
Dusty	08:54:01	7
primary baton	06:48:36	5
wingman	01:40:10	1
ok	00:25:15	1
N2375e	08:01:48	6
primary baton	02:30:50	2
wingman	05:30:58	4
Oblio	07:22:24	6
primary baton	04:28:05	3
wingman	01:39:09	1
ok	01:15:10	2
Codge	06:43:45	5
wingman	05:49:28	4
ok	00:54:17	1
Redgreen	06:41:20	6
primary baton	03:45:08	3
wingman	02:31:32	2
ok	00:24:40	1
N22ca	05:45:44	4
primary baton	01:50:31	1
wingman	03:55:13	3
Dil52	05:23:08	5
wingman	04:03:12	3
ok	01:19:56	2
Sandman	03:55:45	2
wingman	03:55:45	2
EdGeneer	03:53:28	3
primary baton	00:33:28	1
wingman	03:20:00	2
Reggie Fields	00:55:28	1
ok	00:55:28	1

[Spookster67]

I've extracted the headwind/tailwind data as well now, so we can see whose route got the most benefit from tail winds.

This table shows the baton flights only. "Wind gain" is the net distance each team was "blown" by the winds aloft, and it's interesting to see that Flightsim and Avsim are very similar here despite quite different routes. SOH got less benefit from tailwinds, but that was a feature of the polar routing.

Row Labels	Sum of Dist. (nm)	Sum of Wind gain (nm)	Percentage
Sim-Outhouse	30131	851	2.82%
FlightSim	32443	1018	3.14%
Avsim	34393	1088	3.16%

[Spookster67]

And finally (for now) here are the aircraft true speeds. Charts show average, plus the range from fastest to slowest.

[MM]

Terrific stuff. Both interesting from a participant's point of view and valuable for the design of future events.

Thanks Martin.

--M

[epwatson]

Good work Martin..

I have the raw data but I didn't do the analysis you did.. I think next year I will take a couple days off before the race too.. I was planning routes while working this year... I work from home so thats a luxury I have but it was hard to concentrate on work while trying to find the most efficient route through the south pacific..

[buzzbee]

Great data - I suggested we not turn back and hire lawyers (It is an estuary) but on google earth it does say "Island"

Argh!

Nice to see the data on the number of flights flown.