Some 2012 race statistics

MaddogK said:
:monkies:

That just made my day !
biglol.gif
Click to expand...

Do you wanna know what made my day? When we found out that Flightsim had picked the exact same airport for their entry into Australia but because we got there over 12 hours before they did, and our error was made evident they were able to alter their plan accordingly..
 
I've filled in the missing flights for the Team SOH pilots (people who were flying off-line) using the posted Duenna JPG data. Here's the summary of who flew for SOH. Other teams to follow...

Values
Row Labels
Sum of Time
Count of State
Moparmike
19:53:31
13
primary baton
12:26:15
9
wingman
06:23:33
3
ok
01:03:43
1
Dangerousdave26
19:20:38
14
primary baton
12:10:12
8
wingman
05:55:15
4
ok
01:15:11
2
Spookster67
16:04:10
11
primary baton
11:52:16
7
wingman
02:37:11
2
ok
01:34:43
2
fliger747
15:18:58
9
wingman
14:11:23
8
ok
01:07:35
1
Wnd
10:58:04
8
primary baton
08:30:42
6
wingman
02:27:22
2
Maddogk
10:33:34
7
primary baton
01:24:04
1
failed primary baton
04:14:00
1
wingman
02:37:54
2
ok
02:17:36
3
Tako_kichi
10:14:11
8
wingman
09:50:46
7
ok
00:23:25
1
Soh Moses
10:03:33
8
primary baton
07:42:28
6
wingman
01:57:34
1
ok
00:23:31
1
Prb
09:36:16
7
primary baton
04:26:12
3
wingman
05:10:04
4
Crash-soh
07:30:37
5
primary baton
02:38:48
2
wingman
04:27:13
2
ok
00:24:36
1
Flyin Bull
06:21:35
7
primary baton
06:21:35
7
Srgalahad
03:48:38
4
wingman
02:35:57
2
ok
01:12:41
2
Ferry_vo
03:01:01
2
primary baton
03:01:01
2
cputters
01:38:24
1
wingman
01:38:24
1
Taco
01:31:02
1
wingman
01:31:02
1
Grand Total
73:54:12
105
 
Rgr that. Explains why I have no ok, since I only participated in one team flight, in which I was the wing.
 
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
 
And here's Flightsim pilots times and flights.

Row LabelsSum of TimeCount of State
Wombat18:47:1512
primary baton12:54:118
wingman04:59:333
ok00:53:311
Freebird16:30:1610
primary baton11:41:418
wingman04:48:352
N3306tx13:52:3010
primary baton01:56:202
wingman11:02:517
ok00:53:191
Apollosmith13:36:278
primary baton10:35:295
wingman01:46:071
ok01:14:512
Salt_air12:09:1811
primary baton04:39:574
failed primary baton01:34:071
wingman05:31:465
ok00:23:281
Wtr75511:59:477
primary baton05:40:523
wingman05:26:513
ok00:52:041
Venture0611:12:137
primary baton06:22:463
wingman03:47:212
ok01:02:062
N350bc09:11:049
primary baton03:20:233
wingman05:26:165
ok00:24:251
Dusty08:54:017
primary baton06:48:365
wingman01:40:101
ok00:25:151
N2375e08:01:486
primary baton02:30:502
wingman05:30:584
Oblio07:22:246
primary baton04:28:053
wingman01:39:091
ok01:15:102
Codge06:43:455
wingman05:49:284
ok00:54:171
Redgreen06:41:206
primary baton03:45:083
wingman02:31:322
ok00:24:401
N22ca05:45:444
primary baton01:50:311
wingman03:55:133
Dil5205:23:085
wingman04:03:123
ok01:19:562
Sandman03:55:452
wingman03:55:452
EdGeneer03:53:283
primary baton00:33:281
wingman03:20:002
Reggie Fields00:55:281
ok00:55:281
 
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 LabelsSum of Dist. (nm)Sum of
Wind gain (nm)		Percentage
Sim-Outhouse301318512.82%
FlightSim3244310183.14%
Avsim3439310883.16%
 
Terrific stuff. Both interesting from a participant's point of view and valuable for the design of future events.

Thanks Martin.

--M
 
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.. :)
 
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.
 
You must log in or register to reply here.
Back
Top