|
BWagstaff
|
 |
« on: July 09, 2011, 03:02:43 AM » |
|
My computer crashed so i got it rebuilt and now I have Excel...
So heres the combined season Pax points after three events. Round it yourself.
|
|
|
|
|
Logged
|
|
|
|
|
BWagstaff
|
|
« Reply #1 on: July 09, 2011, 10:52:10 AM » |
|
And here it is for those of you too lazy to log in.
Nathan Whipple 297.0017516
Billy Davis 294.6959989
Ben Wagstaff 294.1638419
Grant Reeve 290.4505982
Charlie Thompson 287.9615918
Brian Levesque 285.4326257
Bob Davis 282.7687266
Roger Whipple 282.4304006
PJ Corrales 281.2504481
Jeff Anderson 280.6405578
David Gott 279.0693948
Todd Kean 279.0027262
Marc Monnar 277.4337124
Bryan Mancuso 277.3311252
Stephanie Zadrozny 277.2027229
Joshua Noble 277.086895
Greg Cullen 276.6534838
Barbara Seeger 276.5830013
Derek Sivret 275.607134
Joshua Parker 275.3306364
David Fried 275.0604077
Russ Siggelkoe 274.9684711
Justin Lau 274.0647321
Patrick Gallagher 273.1162855
Jeff Seeger 272.9093608
Sam Creasey 272.6818988
Robert Woodsom 272.6222937
Eric Krueger 272.5200736
Matthew Mickle 272.3940106
Robert Lang 271.060951
Matt Thompson 270.5954037
Don Kuehl 269.0581495
Sarah Bowin 268.2900278
Chang Ho Kim 266.8541577
Lawrence Coffin 266.6350872
Jason Volk 265.4078405
Jonathan R. Havener 265.391454
Paul Bowin 265.2197493
Paul Zahornasky 263.9225554
Aaron Telage 261.0513845
Paul Krysiak 260.5336879
Jenna D'Amico 260.3891249
Ian Krueger 260.0388638
Allen Parker 256.9473017
Stanley Gorham 255.3992187
Philip G Gott 253.7784936
Jack Washington 253.6593152
Cheryl Woodsom 252.6371247
Jason Dobson 251.3942902
Myron Steere 251.0942025
James Murdocco 246.2201108
Stacey Strout 243.4030126
Daniel Howard 240.4690588
Christine Murdocco 236.3827844
Allison Krueger 235.4368713
Evan Woodsom 232.8541767
Kimsoo Gopnik 221.8919352
Adam Woodsom 211.9883238
Matt Murray 194.2229558
David Thomas 185.982846
Dan Kimber 185.1652913
Scott Thursby 184.7969009
Michael Gowdar 183.7150416
Chris Egan 181.9886139
Greg Cullen 180.4824362
David White 180.3597529
Michael McIver 177.6746692
Rob MacAlpine 176.6518639
Patrick Heck 176.2495045
David Fried 175.996904
Kathleen Barnes 175.5814637
Andrew Del Donno 175.5047375
Brent VanDer Werf 174.4725839
Wiley Cox 174.3585935
William Salie 173.408233
Chris Fitzgerald 173.2400203
Joanna Ellis 171.3180181
Terence Davidovits 171.2748231
Scott Bowin 169.3414648
Bryan Mills 166.8111606
Bill Gendron 165.9636745
Cameron Bosnic 165.1885102
Jason Dobson 164.4348729
Carolyn Green 163.7069178
William Goodale 163.6903606
Robert Totten 159.7562142
Robert A. Jordan 149.4899623
Lauren Dobson 148.4921071
Isaac Miskoe 103.6685678
Mark Daddio 99.87069621
Sam Krauss 96.48234191
Cliff Strout 96.40243753
Kenneth Johnson 96.349769
Eric Chiang 96.22581591
Matthew Wilder 95.29108208
Shahan Sarkissia n 94.81657129
Mark Dudek 94.50135547
Howard Roundy 94.35152289
Robert Mills 93.57865729
Ed Hondzinski 93.26183204
Charles Moss 92.380394
Chris Mills 92.35223783
Nicholas Fontana 92.10546354
Michael Condict 91.73523947
William Brundige 91.29064405
Krisztian Kopasz 91.22346584
John Rappa 91.07902564
Soter Slomski 90.89423258
Brian Kuehl 90.73131406
Shane Landry 90.6949081
Stephen Flesher 90.46580166
William Lamb 90.27184357
Matt Dougherty 89.79560824
Mitchell Baker 89.17438254
Igor Romashsko 88.64858782
Mathew Nieman 88.39395911
James Ray 88.19073915
Jason Huepenbecker 87.57317525
Jong Shin 87.2621342
Jesse Buzzell 86.79494712
Chris Strock 86.34022313
Dan Boudria 86.14762165
Rebecca Mallory 85.97463823
Kyle Quinn 85.46270291
Dan Wolpert 84.82888001
Daniel Pardee 84.60767468
Jason Fair 84.26423086
Athena DeGangi 84.13464619
Brian Springmann 84.08256489
Carl Hayn 83.76608187
Viet Le 83.57946107
Ben Albert 83.3090117
Daniel Sheridan 83.01391486
Geoffrey Findon 82.49769624
Jonathan Leith 82.45107274
Janna Lovell 82.323848
Thomas Turner 82.16043718
Randall Pratt 82.11506392
Ted Del Donno 81.85663289
Drew VanDer Werf 81.75968783
Koby Albrecht 81.72389913
Scott Petrilli 81.56668668
Derek Tangard 81.55171251
Bob Guenthner 81.51324213
Ryan Giorgio 81.5025553
Lev Benkin 81.46715751
Matt Miskoe 81.3474116
Jason Neuman 81.34467627
Nicole Zahornasky 81.14833574
Alex Grabau 81.00143944
Sal Estacio 80.93486747
Theresa Harcourt 80.87006508
Derek Schradieck 80.77922078
Zachary Veugen 80.49860364
Cris Raposo 80.3848744
Jeremy Bruecken 80.28657033
Bill Murray 79.98115484
Brian Pray 79.41403756
Yavuz Kiremit 79.3389595
Ethan Ananny 78.35811227
Devin Taylor 78.26389303
Daryl Beck 78.11799703
Gabriel Ling 77.27816687
Charles Smith 76.66576875
Kazim Charles 74.80250665
Amanda Kohr 74.14218224
Christine Kuehl 73.50164204
Jack Nguyen 72.10507047
Sandi Moreno 71.82895697
David Oliveira 70.97093851
|
|
|
|
|
Logged
|
|
|
|
|
GWCSC2
|
|
« Reply #2 on: July 10, 2011, 08:07:21 AM » |
|
Why is my name on the list twice Thanks Greg
|
|
|
|
|
Logged
|
|
|
|
|
BWagstaff
|
|
« Reply #3 on: July 10, 2011, 03:36:48 PM » |
|
Greg, I am a beginner when it comes to excel... I've only had it for a week. That is why you are on the list twice.
Ignore your first entry. You have only competed in two points events out of a possible three.
|
|
|
|
|
Logged
|
|
|
|
|
cmt52663
|
|
« Reply #4 on: July 10, 2011, 06:24:46 PM » |
|
Dude,
Excel has a bug, or it's GIGO. I am way too high on that list.
Cheers,
Charlie
|
|
|
|
|
Logged
|
Charlie
Works Cooper - STX #1
NER Cannon Fodder
|
|
|
|
Jenna
|
|
« Reply #5 on: July 11, 2011, 08:39:59 AM » |
|
What formula did you use to determine the points?
I downloaded your sheet and only saw values, and no equations in the cells.
|
|
|
|
|
Logged
|
You can't rationalize cars like these. They're not something you buy with your head - you buy them with your heart, because you love them. And who can explain love?
Lo mejor está por llegar.
#99 SSM Panda
|
|
|
|
BWagstaff
|
|
« Reply #6 on: July 11, 2011, 10:53:29 AM » |
|
Jenna, TOP PAX time*100/PAX time.
For example, to figure out my PAX points from event #1... Charlie Thompson was top PAX with a time of 48.383, now multiply that by 100 and you have 4838.3, then divide that number by my PAX time at that event 4838.3/48.636= 99.4798.
Once you do the first one u just double click on the right lower corner of the box and it does the whole column for you.
|
|
|
|
|
Logged
|
|
|
|
|
ChrisFranson
|
|
« Reply #7 on: July 11, 2011, 11:03:51 AM » |
|
What formula did you use to determine the points?
I downloaded your sheet and only saw values, and no equations in the cells.
Jenna, Axware can track and generate pax points. |
|
|
|
|
Logged
|
|
|
|
|
Jenna
|
|
« Reply #8 on: July 13, 2011, 07:20:37 AM » |
|
Chris, I know that.
I didn't know if Ben had used that or not.
|
|
|
|
|
Logged
|
You can't rationalize cars like these. They're not something you buy with your head - you buy them with your heart, because you love them. And who can explain love?
Lo mejor está por llegar.
#99 SSM Panda
|
|
|
|
Gus Heck
|
|
« Reply #9 on: July 13, 2011, 01:27:04 PM » |
|
The other interesting permutation relevant to predicting the winner is average per event so far...
Mark Daddio 99.87069621 1 99.87069621
Nathan Whipple 297.0017516 3 99.00058388
Billy Davis 294.6959989 3 98.23199964
Ben Wagstaff 294.1638419 3 98.05461395
Matt Murray 194.2229558 2 97.11147789
Grant Reeve 290.4505982 3 96.81686608
Sam Krauss 96.48234191 1 96.48234191
Cliff Strout 96.40243753 1 96.40243753
Kenneth Johnson 96.349769 1 96.349769
Eric Chiang 96.22581591 1 96.22581591
Charlie Thompson 287.9615918 3 95.98719728
Matthew Wilder 95.29108208 1 95.29108208
Brian Levesque 285.4326257 3 95.14420856
Shahan Sarkissian 94.81657129 1 94.81657129
Mark Dudek 94.50135547 1 94.50135547
Howard Roundy 94.35152289 1 94.35152289
Bob Davis 282.7687266 3 94.2562422
Roger Whipple 282.4304006 3 94.14346688
PJ Corrales 281.2504481 3 93.75014938
Robert Mills 93.57865729 1 93.57865729
Jeff Anderson 280.6405578 3 93.54685259
Ed Hondzinski 93.26183204 1 93.26183204
David Gott 279.0693948 3 93.02313159
Todd Kean 279.0027262 3 93.00090873
David Thomas 185.982846 2 92.99142302
Dan Kimber 185.1652913 2 92.58264567
Marc Monnar 277.4337124 3 92.47790415
Bryan Mancuso 277.3311252 3 92.4437084
Stephanie Zadrozny 277.2027229 3 92.40090763
Scott Thursby 184.7969009 2 92.39845045
Charles Moss 92.380394 1 92.380394
Joshua Noble 277.086895 3 92.36229834
Chris Mills 92.35223783 1 92.35223783
Greg Cullen 276.6534838 3 92.21782794
Barbara Seeger 276.5830013 3 92.19433375
Nicholas Fontana 92.10546354 1 92.10546354
Derek Sivret 275.607134 3 91.86904467
Michael Gowdar 183.7150416 2 91.85752081
joshua parker 275.3306364 3 91.77687878
Michael Condict 91.73523947 1 91.73523947
David Fried 275.0604077 3 91.68680256
Russ Siggelkoe 274.9684711 3 91.65615704
brent vander werf 274.1772212 3 91.39240707
Justin Lau 274.0647321 3 91.35491071
William Brundige 91.29064405 1 91.29064405
Krisztian Kopasz 91.22346584 1 91.22346584
John Rappa 91.07902564 1 91.07902564
Patrick Gallagher 273.1162855 3 91.03876183
chris egan 181.9886139 2 90.99430693
Jeff Seeger 272.9093608 3 90.96978694
Soter Slomski 90.89423258 1 90.89423258
Sam Creasey 272.6818988 3 90.89396627
Robert Woodsom 272.6222937 3 90.87409789
Eric Krueger 272.5200736 3 90.84002453
matthew mickle 272.3940106 3 90.79800354
Brian Kuehl 90.73131406 1 90.73131406
Shane Landry 90.6949081 1 90.6949081
stephen flesher 90.46580166 1 90.46580166
Robert Lang 271.060951 3 90.35365033
William Lamb 90.27184357 1 90.27184357
Greg Cullen 180.4824362 2 90.2412181
Matt Thompson 270.5954037 3 90.19846791
David White 180.3597529 2 90.17987643
Matt Dougherty 89.79560824 1 89.79560824
Don Kuehl 269.0581495 3 89.68604984
Sarah Bowin 268.2900278 3 89.43000927
Mitchell Baker 89.17438254 1 89.17438254
Chang Ho Kim 266.8541577 3 88.9513859
Lawrence Coffin 266.6350872 3 88.87836239
Michael McIver 177.6746692 2 88.83733459
Igor Romashsko 88.64858782 1 88.64858782
Jason Volk 265.4078405 3 88.46928016
Jonathan R. Havener 265.391454 3 88.46381799
Paul Bowin 265.2197493 3 88.40658309
Mathew Nieman 88.39395911 1 88.39395911
Rob MacAlpine 176.6518639 2 88.32593197
James Ray 88.19073915 1 88.19073915
Patrick Heck 176.2495045 2 88.12475223
David Fried 175.996904 2 87.99845199
Paul Zahornasky 263.9225554 3 87.97418515
Kathleen Barnes 175.5814637 2 87.79073186
Andrew Del Donno 175.5047375 2 87.75236874
Jason Huepenbecker 87.57317525 1 87.57317525
Jong Shin 87.2621342 1 87.2621342
Jesse Buzzell 87.25957101 1 87.25957101
brent vander werf 174.4725839 2 87.23629195
Wiley Cox 174.3585935 2 87.17929677
Aaron Telage 261.0513845 3 87.01712817
Paul Krysiak 260.5336879 3 86.84456264
Jenna D'Amico 260.3891249 3 86.79637498
Andrew Buzzell 86.79494712 1 86.79494712
William Salie 173.408233 2 86.70411652
Ian Krueger 260.0388638 3 86.67962126
Chris Fitzgerald 173.2400203 2 86.62001014
Chris Strock 86.34022313 1 86.34022313
Dan Boudria 86.14762165 1 86.14762165
Rebecca Mallory 85.97463823 1 85.97463823
Joanna Ellis 171.3180181 2 85.65900904
allen parker 256.9473017 3 85.64910057
Terence Davidovits 171.2748231 2 85.63741154
Kyle Quinn 85.46270291 1 85.46270291
Stanley Gorham 255.3992187 3 85.1330729
Dan Wolpert 84.82888001 1 84.82888001
Scott Bowin 169.3414648 2 84.67073239
Daniel Pardee 84.60767468 1 84.60767468
Philip G Gott 253.7784936 3 84.59283119
Jack Washington 253.6593152 3 84.55310507
Jason Fair 84.26423086 1 84.26423086
Cheryl Woodsom 252.6371247 3 84.21237489
Athena DeGangi 84.13464619 1 84.13464619
Brian Springmann 84.08256489 1 84.08256489
Jason Dobson 251.3942902 3 83.79809672
Carl Hayn 83.76608187 1 83.76608187
Myron Steere 251.0942025 3 83.69806751
Viet Le 83.57946107 1 83.57946107
Bryan Mills 166.8111606 2 83.40558032
Ben Albert 83.3090117 1 83.3090117
Daniel Sheridan 83.01391486 1 83.01391486
Bill Gendron 165.9636745 2 82.98183727
Cameron Bosnic 165.1885102 2 82.59425512
Geoffrey Findon 82.49769624 1 82.49769624
Jonathan Leith 82.45107274 1 82.45107274
Janna Lovell 82.323848 1 82.323848
Jason Dobson 164.4348729 2 82.21743646
Thomas Turner 82.16043718 1 82.16043718
Randall Pratt 82.11506392 1 82.11506392
James Murdocco 246.2201108 3 82.07337028
Ted Del Donno 81.85663289 1 81.85663289
Carolyn Green 163.7069178 2 81.85345888
william goodale 163.6903606 2 81.8451803
drew vander werf 81.75968783 1 81.75968783
Koby Albrecht 81.72389913 1 81.72389913
Scott Petrilli 81.56668668 1 81.56668668
Derek Tangard 81.55171251 1 81.55171251
Bob Guenthner 81.51324213 1 81.51324213
Ryan Giorgio 81.5025553 1 81.5025553
Lev Benkin 81.46715751 1 81.46715751
Matt Miskoe 81.3474116 1 81.3474116
Jason Neuman 81.34467627 1 81.34467627
Nicole Zahornasky 81.14833574 1 81.14833574
Stacey Strout 243.4030126 3 81.13433753
Alex Grabau 81.00143944 1 81.00143944
Sal Estacio 80.93486747 1 80.93486747
Theresa Harcourt 80.87006508 1 80.87006508
Derek Schradieck 80.77922078 1 80.77922078
Zachary Veugen 80.49860364 1 80.49860364
Cris Raposo 80.3848744 1 80.3848744
Jeremy Bruecken 80.28657033 1 80.28657033
daniel howard 240.4690588 3 80.15635294
Bill Murray 79.98115484 1 79.98115484
Robert Totten 159.7562142 2 79.87810712
Brian Pray 79.41403756 1 79.41403756
Yavuz Kiremit 79.3389595 1 79.3389595
Christine Murdocco 236.3827844 3 78.79426146
Allison Krueger 235.4368713 3 78.4789571
Ethan Ananny 78.35811227 1 78.35811227
Devin Taylor 78.26389303 1 78.26389303
Daryl Beck 78.11799703 1 78.11799703
Evan Woodsom 232.8541767 3 77.61805889
Gabriel Ling 77.27816687 1 77.27816687
charles smith 76.66576875 1 76.66576875
Kazim Charles 74.80250665 1 74.80250665
Robert A. Jordan 149.4899623 2 74.74498113
Lauren Dobson 148.4921071 2 74.24605353
Amanda Kohr 74.14218224 1 74.14218224
Kimsoo Gopnik 221.8919352 3 73.96397839
Christine Kuehl 73.50164204 1 73.50164204
Jack Nguyen 72.10507047 1 72.10507047
Sandi Moreno 71.82895697 1 71.82895697
David Oliveira 70.97093851 1 70.97093851
Adam Woodsom 211.9883238 3 70.6627746
Isaac Miskoe 103.6685678 2 51.83428388
|
|
|
|
|
Logged
|
|
|
|
|
pj
|
|
« Reply #10 on: July 19, 2011, 01:39:11 PM » |
|
As the dust settles from Event 4, the top 20 comes to:
Position Driver Total From First
1 Nathan Whipple (P) 395.50
2 Billy Davis (P) 392.66 2.84
3 Ben Wagstaff (P) 390.97 4.53
4 Grant Reeve (P) 388.96 6.54
5 Charlie Thompson 380.71 14.79
6 PJ Corrales (P) 380.06 15.44
7 Bob Davis (P) 379.48 16.02
8 Roger Whipple 374.07 21.43
9 Todd Kean (P) 373.60 21.90
10 Jeff Anderson (P) 373.53 21.97
11 David Gott 373.23 22.27
12 Barbara Seeger 372.34 23.16
13 Marc Monnar 371.10 24.40
14 Derek Sivret 369.55 25.95
15 Russ Siggelkoe 369.30 26.21
16 joshua parker 368.33 27.17
17 Justin Lau 367.66 27.84
18 Bryan Mancuso 367.42 28.08
19 Eric Krueger 367.24 28.26
20 Sarah Bowin 365.59 29.92
And dropping the lowest:
Position Driver W/ Drops From First
1 Nathan Whipple 297.00
2 Grant Reeve 296.80 0.20
3 Billy Davis 294.99 2.01
4 Ben Wagstaff 294.16 2.84
5 PJ Corrales 292.89 4.11
6 Matt Murray 290.70 6.31
7 Charlie Thompson 287.96 9.04
8 Bob Davis 287.89 9.11
9 Todd Kean 286.52 10.49
10 Brian Levesque 285.43 11.57
11 Barbara Seeger 284.99 12.01
12 Marc Monnar 284.61 12.39
13 David Gott 284.28 12.72
14 Derek Sivret 282.69 14.31
15 joshua parker 282.56 14.44
16 Roger Whipple 282.43 14.57
17 Justin Lau 282.42 14.58
18 Jeff Anderson 282.10 14.90
19 Eric Krueger 280.58 16.42
20 Paul Bowin 280.33 16.67
Fixed an error with Matt Murray not showing up for Event 2, throwing off the "W/ Drops" calculation
|
|
|
|
« Last Edit: July 19, 2011, 04:25:55 PM by PJ »
|
Logged
|
|
|
|
|
solo-x
|
|
« Reply #11 on: July 20, 2011, 02:18:54 PM » |
|
Where is Dave in that?
|
|
|
|
|
Logged
|
|
|
|
|
Bob Davis
|
|
« Reply #12 on: July 20, 2011, 02:26:02 PM » |
|
Where is Dave in that?
Freudian slip?  |
|
|
|
|
Logged
|
|
|
|
|
pj
|
|
« Reply #13 on: July 20, 2011, 03:44:12 PM » |
|
Where is Dave in that?
Poor PAX finish at the rain event and skipped NHMS. The point system exponentially rewards the winner of a class while PAX percentages carry a higher point scale with less discrepancy based on distance to the winner. For instance, the difference between points from first to second is a 33% reduction, while first to second in PAX is generally less than 1%. It would be nearly impossible to win the PAX battle with more than 1 missed event, since you lose so many points for doing so and have no way to recover. Perhaps a better PAX scoring system is needed in the future? |
|
|
|
|
Logged
|
|
|
|
|
solo-x
|
|
« Reply #14 on: July 20, 2011, 04:02:49 PM » |
|
I must be doing something wrong. Dave had 180.359 pax points after Event #3 and scored 100 additional pax points at event 4 for a total of 280.359. He drops his zero from NHMS, putting him in 19th after drops, right?
|
|
|
|
|
Logged
|
|
|
|
|
