S3 Series
http://squadselectseries.com/s3forum/

S6 database reorg complete, FINAL STATS OMH to SOF
http://squadselectseries.com/s3forum/viewtopic.php?f=1&t=3273		 Page 1 of 1
Author:  phenix [ Fri Dec 27, 2019 6:52 pm ]
Post subject:  S6 database reorg complete, FINAL STATS OMH to SOF
New site for data as the old one is now the archive. Welcome to the S6c (S6 continued)

http://www.errthum.com/warbirds/s6c

Database was separated between SOF and ABTF, when one life was removed from S3 rules. This was done to keep queries efficient as the old S6 had over a million rows of data. It also made sense as things have changed over time, such as play style, flight models, etc. In particular the removal of 1-life-only changed player behavior. This allows me (us) to compare data on an equal foot.

And now the stats from OMH-SOF in following replies to this post.
Author:  phenix [ Fri Dec 27, 2019 6:53 pm ]
Post subject:  Re: S6 database reorg complete, FINAL STATS OMH to SOF
The O-CLUB. These represent the top 1% in each of their class.

Top 1% killers:
juice= 918
vulche 517
todzla 390
daddy= 327
-deak- 326
crhtwo 310
jlordj 306
=wilz= 299
sluger 285
-wcat- 271
chicdg 265

Top 1% GV killers:
coolon 303
mt-dew 297
farout 214
houndg 177
muzz-- 162
-deak- 160
jlordj 156
stlrai 133

Top 1% BDA:
mrbang 1279
whawk- 1256
-gums- 1252
gundoc 1024
-hawk- 1007
bigwlg 829
darryl 807
mt-dew 767
snoopy 726
warier 724

Top 1% TOT (no longer utilized):
-pd--- 10048486
plmokn 6551850
-gums- 6472677
=scrm= 6310150
wallyg 5747274
under- 4668000

Top 1% series attended:
rock-- 88
-fooo- 88
beaver 88
-deak- 88
muzz-- 88
-splt- 88
todzla 88
dewolf 88
=wilz= 87
slpsht 87
-wcat- 85
swede- 85
-gums- 85
vulche 83
-briar 83
theoph 82
foss-j 81
gundoc 81
WLDBIL 81
=vslp= 81

Top 1% frames attended:
dewolf 433
rock-- 423
-deak- 417
slpsht 414
-splt- 413
vulche 406
=wilz= 405
-fooo- 402
beaver 402
juice= 384
swede- 378
todzla 376
-briar 366
foss-j 365
muzz-- 357
besea- 353
trigr= 352
-gums- 349
crommm 333
-wcat- 329

Top 1% sorties flown:
-deak- 1415
vulche 1375
juice= 1193
rock-- 1182
trigr= 1174
dewolf 1148
-splt- 1145
beaver 1140
todzla 1115
swede- 1094
slpsht 1089
jedijc 1060
=wilz= 1052
foss-j 1045
-briar 1017
pappyb 976
raamon 974
nookyb 972
crommm 967
besea- 962

Top 1% number of medals won (9 series yet to be awarded):
-deak- 45
=wilz= 44
juice= 40
vonmc= 34
=chnk= 34
-briar 33

Top 1% cups won (incomplete):
juice= 18

Top 1% times as CO:
beaver 74

Top 1% in number of airframes flown:
todzla 73
rock-- 71
beaver 68
muzz-- 68
=wilz= 68
swede- 68
crommm 67
-fooo- 67
juice= 66
madcat 65
dewolf 65
slpsht 65
chicdg 64
okdoc- 64
-deak- 63
-wcat- 63
vulche 63
yobtee 62
-splt- 62
phenix 62
=weis= 62
kapsyl 62
oledkk 62
jlordj 62

Top 1% in assists:
vulche 347
juice= 300
=jman= 195
jlordj 185
todzla 179
slpsht 176
-briar 174
-splt- 166
-deak- 162
=vslp= 157
yamon- 157
Author:  phenix [ Fri Dec 27, 2019 7:01 pm ]
Post subject:  Re: S6 database reorg complete, FINAL STATS OMH to SOF
And now some lists of 10:

KILLS per SHOT DOWN
1. jamjo+ 8.5
2. vonmc= 7.056
3. =kjbl= 7
4. hygame 7
5. scarpo 6.973
6. daddy= 6.957
7. kungfu 6.6
8. colmbo 6.395
9. -epic- 6.304
10. mrbill 6
11. scooby 6

Frames per KIA
1. fether 20.667
2. artmiz 20
3. nuker- 19
4. deacon 19
5. *coug* 18
6. makko- 17
7. gunfit 16
8. scooby 15.7
9. vert++ 14.875
10. -cage- 14
11. chumly 14
12. toofar 14
13. knuckr 14

Frames / Lost Plane (inc. KIA)
1. pirate 12
2. ccemtp 11
3. guinan 10
4. hygame 8
5. raffie 8
6. stachl 8
7. fatboy 8
8. banjo- 7
9. deuce- 7
10. drdeth 7
11. drilin 7

KILLS FROM BOMBERS(non AI)
1. -pd--- 56
2. gundoc 51
3. -gums- 49
4. mrbang 29
5. -gmni- 28
6. -hawk- 28
7. goflyj 26
8. tnymax 22
9. whawk- 22
10. coolon 20

KILLS per SHOT DOWN FROM BOMBERS
1. hotroc 3.333
2. andrew 2.25
3. spunoo 2
4. hitnrn 1.667
5. airfox 1.667
6. irgood 1.667
7. scuba- 1.5
8. rcadi- 1.333
9. skinez 1.3
10. mrbang 1.261

Frames per KIA IN BOMBERS
1. gldnbb 18.5
2. fether 16.5
3. alphad 16
4. dealr+ 15
5. stlrai 14
6. jcamp- 14
7. kidcan 14
8. irgood 13
9. rossco 12.667
10. wackko 12
11. phenix 12
12. tagged 12

Frames / Lost Plane (inc. KIA) IN BOMBERS
1. kapsyl 9
2. yukone 8
3. mspiro 8
4. -purt- 7
5. raven= 7
6. nuker- 7
7. stlrai 7
8. joystc 6.333
9. fishey 6
10. unuwot 6
11. pepdav 6
12. phenix 6
13. scuzzy 6
14. ohshix 6
Author:  phenix [ Fri Dec 27, 2019 7:14 pm ]
Post subject:  Re: S6 database reorg complete, FINAL STATS OMH to SOF
RANKINGS!

Top 10 planes KILLS per times KILLED
Bf-109F4-N 6.0000
FW-190A-1 4.5789
SpitXIV 3.4211
P-38G 3.3704
Bf-109k4r6 3.0000
MC2022 2.8750
Me262 2.8056
Hawk75 2.7391
htyphoon 2.7200
MC200 2.6622

Top 10 planes KILLS per PILOT-FRAME
FW-190A-1 1.7059
N1K-1J 1.1929
Bf-109F4-N 0.9231
htyphoon 0.8947
Spit2 0.8944
MC200 0.8491
P-38G 0.8426
MC205 0.8403
109E4AA 0.8023
F4U-4 0.7623

Top 10 planes BDA per loss
B-29 28.6250
B-17G-N 21.6667
Lancaster-III 17.8750
b29 11.3077
B-17F 11.1824
B-24J 9.9461
Lancaster-I 9.9127
Ju52 9.7778
G4M1 9.0941
C-47 8.5882

Top 10 planes ranked by lowest LOSS per PILOT-FRAME
Ju52 0.0849
C-47 0.1278
Bf-109F4-N 0.1538
sfish 0.2203
Bf-109k4r6 0.2500
B-17G-N 0.2500
B-29 0.2581
Lancaster-III 0.2759
NFII 0.3182
Me262 0.3246

Top 10 planes with KILLS
FW-190A4 2505
P-51D 1466
Bf-109G6 1457
HurricaneI 1260
SpitIXe 1154
Bf-109E 1019
FW-190D9 759
SpitVb 728
Bf-109F 711
Bf-109G2E 680

Top 10 planes with BDA
Ju88A-4 10100
B-24J 5351
B-17G 4243
B-25C 3974
He-111H3 3219
B-24D 2524
Ju87D 2143
B-25H 1723
B-17F 1655
B-25J 1640

Top 10 planes in FRAMES flown
Ju88A-4 214
Bf-109G6 172
FW-190A4 157
B-25C 114
B-24J 106
SpitIXe 105
B-17G 103
Bf-109G6/R6 101
P-47D 99
P-51D 89

Top 10 series unique players attending
DS 368
OMH 359
8BC 348
5DS 344
OTB 343
MB 325
T4T 308
FP 282
TFB 278
RTW 274
Author:  split [ Sat Dec 28, 2019 1:07 am ]
Post subject:  Re: S6 database reorg complete, FINAL STATS OMH to SOF
Thanks for the post phenix!!! We appreciate all you do.
<S>
Author:  jabo [ Thu Jan 02, 2020 5:57 pm ]
Post subject:  Re: S6 database reorg complete, FINAL STATS OMH to SOF
Thanks again Phenix!
Great to have the before 1 life to live and after databases. It does allow proper comparison for all those names in the past that have faded away.
Author:  Beaver [ Mon Jan 13, 2020 1:07 am ]
Post subject:  Re: S6 database reorg complete, FINAL STATS OMH to SOF
Outstanding Work Phenix :D
Author:  Sakai [ Thu Jan 30, 2020 8:59 pm ]
Post subject:  Re: S6 database reorg complete, FINAL STATS OMH to SOF
Hey Phenix!

Sure wish you'd re-enable the 'List of 10' Frame CO's.

The only 'scoreboard' I was able to achieve top status.

Thank you!

~Mediocrity!

Attachment:
sakai.png
sakai.png [ 213.76 KiB | Viewed 12388 times ]
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/