TORA GT S9 - Results and Standings

WILL YOU PLEASE CORRECT MY MUGELLO RACE 2 FINISHING POSITION? SHOULD BE 3RD NOT 4TH.

THANKS!!!

Hey mate I was looking at the Team Standings and you guys haven't updated the points LMR Deftone got in Round 3.. That should give us a significant boost in the standings! Thanks the team is GTR Modena, BTW and with the corrections we should be 24th in the standing not 29th

LMR Scuderia wrote:Hey mate I was looking at the Team Standings and you guys haven't updated the points LMR Deftone got in Round 3.. That should give us a significant boost in the standings! Thanks the team is GTR Modena, BTW and with the corrections we should be 24th in the standing not 29th

Fixed, but the formula problem affected other teams too, so you're still 29th I'm afraid!

no results for round 1 and 2 for myself.

HLR Toffo wrote:no results for round 1 and 2 for myself.

Fixed. The formula was looking for HLR Toffo, and those two rounds had not been changed from your old gamertag.

Results are updated.

Is it possible to see the standings with your worst 2 results dropped?

F4H Koenigsegg wrote:Is it possible to see the standings with your worst 2 results dropped?

Yes, but it means some technical changes. Also, that will mean only showing 2 scored rounds at this point....

Chris the following calculation works in excel -

=SUM(H2:K2)-SMALL(H2:K2,1)-SMALL(H2:K2,2)

I totaled up all points scored then took away 1st smallest number and then 2nd smallest to give total points so far

the small calculation - range and 1st smallest number (1) - - range and 2nd smallest number (2)

I can work it out in excel very easy but not sure if google docs has the above calculation all you would have to do then is expand the range or limit the rounds visible for the calculation to work

Just a quick question, I know our two worst rounds aren't scored, but what about if you have only take part in one or two rounds?

Just asking cause I've only been in two rounds, yet I only really have the points from last night. Should it be your dropped rounds are counted after you have competed in X amount of races?

Richy59 wrote:Just a quick question, I know our two worst rounds aren't scored, but what about if you have only take part in one or two rounds?

Just asking cause I've only been in two rounds, yet I only really have the points from last night. Should it be your dropped rounds are counted after you have competed in X amount of races?

Hmmmm I thought I included the points for ppl that only race in 2 races separately .

Will go back and check.

Duncans figures are incorrect I'm afraid.

BG Beanz for example: he has scored 306, 329, 0 and 304.

Two lowest scoring are zero and 304, leaving him with 635 yet Duncans points table has him at 329?

I'm guessing it didn't figure in the 0s.

CMGraphix wrote:Duncans figures are incorrect I'm afraid.

BG Beanz for example: he has scored 306, 329, 0 and 304.

Two lowest scoring are zero and 304, leaving him with 635 yet Duncans points table has him at 329?

No the calculation is correct what is incorrect is that as stated above I only accounted for drivers that have raced in every race.

I am working on a update now.

0 added cheers HABURi lol always need 0's in data bases school boy error

P # Driver Team Car TOTAL
1 240 TPR B0x TPR Racing (P) Ferrari F458 Italia 751
2 390 SNR ANDY Yo Sushi Racing Mercedes SLS AMG GT3 729
3 277 CQR VtecTorquE CQR Skullcandy Ferrari F458 Italia 706
4 707 CQR MAGiC CQR Bulldogs Jaguar XKR RSR 699
5 7 ATR DAN ATR Dynamics BMW Z4 GT3 699
6 117 F4H Koenigsegg F4H Team Panoz (P) Panoz Abruzzi 694
7 283 BG Crunk BGRT (P) Panoz Abruzzi 678
8 211 CQR D4NI3L CQR Bulldogs Jaguar XKR RSR 673
9 1 PLOW RUN WIDE Yo Sushi Racing Mercedes SLS AMG GT3 667
10 523 MonoCob Cobblepop Motorsport Ferrari F458 Italia 651
11 60 F4H Carrera F4H Competition Porsche 997 GT3 RSR 643
12 57 BG Beanz Vodafone British Gamers BMW M3 GT2 635
13 357 xNIGHTMARE84 Team DK Jaguar XKR RSR 618
14 118 CQR HABURi CQR Spitfires McLaren MP4-12C GT3 614
15 979 CQR Smokey CQR Skullcandy Ferrari F458 Italia 610
16 112 CQR Senna CQR Bulldogs Jaguar XKR RSR 572
17 103 BG Hainesy Vodafone British Gamers BMW M3 GT2 560
18 110 Cpt nemo71 NTR BMW Z4 GT3 522
19 47 SelectiveRogue Mad Croc STORM Ford GT Mk7 505
20 40 CMGraphix Mad Croc STORM Ford GT Mk7 500
21 101 BG Blackbird BG Race Division Dodge Viper CC 496
22 12 gen3ral ts0 Mad Croc STORM Ford GT Mk7 488
23 102 BG Smithy Vodafone British Gamers BMW M3 GT2 479
24 105 BG Wumba Vodafone British Gamers BMW M3 GT2 476
25 160 F4H Insanity F4H NFS Racing BMW M3 GT2 473
26 179 HLR Toffo Jaguar GBR (P) Jaguar XKR RSR 448
27 946 S2M Kenny Dellenny Racing Panoz Abruzzi 442
28 888 tsafoot Team CRA KOYO Racing BMW M3 GT2 439
29 4 FranchittiFan Team GB ATR Dynamics BMW Z4 GT3 438
30 122 CQR Vapor NTR BMW Z4 GT3 432
31 197 PLOW TheButcher Yo Sushi Racing Mercedes SLS AMG GT3 425
32 229 F4H Diablo F4H Motorsport Chevrolet Corvette ZR1 416
33 50 F4H mikem F4H Competition Porsche 997 GT3 RSR 414
34 339 PLFSpurtle YaH Racing Mercedes SLS AMG GT3 408
35 80 CQR Aero Team GB ATR Dynamics BMW Z4 GT3 404
36 908 S2M Dellorto Dellenny Racing Panoz Abruzzi 393
37 109 BG Regaddict BG Race Division Dodge Viper CC 390
38 48 SNR CAMDUP 1 Yo Sushi Racing Mercedes SLS AMG GT3 383
39 123 CQR Phil CQR Bulldogs Jaguar XKR RSR 380
40 550 F4H Music Man F4H NFS Racing BMW M3 GT2 379
41 9 Hailfire97x Hailfire Racing Ford GT Mk7 377
42 311 BloodYCaiN Hailfire Racing Ford GT Mk7 368
43 83 B0Xc8 BG Race Division Dodge Viper CC 366
44 6 Rollin InAn STi M&M Racing Mercedes SLS AMG GT3 363
45 116 CQR Champion CQR Skullcandy Ferrari F458 Italia 363
46 20 Richy59 M&M Racing Mercedes SLS AMG GT3 363
47 669 adder20 Team CRA KOYO Racing BMW M3 GT2 359
48 136 iiTz SPiDerzZ Dynamics Motorsports Porsche 997 GT3 RSR 355
49 30 Bli33ard ATR Dynamics BMW Z4 GT3 353
50 530 Gregbie Cobblepop Motorsport Ferrari F458 Italia 351
51 138 xOverdrive99x Hailfire Racing Ford GT Mk7 348
52 157 BG Alex 8 BG Race Division Dodge Viper CC 348
53 321 VVV Axiom NTR BMW Z4 GT3 341
54 411 Graftersroom X Continental Racing Dodge Viper CC 339
55 767 Saunders82 Team BSR Chevrolet Corvette ZR1 338
56 462 ThirdEyeGirl Forty Six & Two Racing (P) Chevrolet Corvette ZR1 327
57 135 ShrinkingSteven Dynamics Motorsports Porsche 997 GT3 RSR 327
58 66 Red Dirt Bandit Hailfire Racing Ford GT Mk7 323
59 170 aidtheace RWS Velocity Motorsport McLaren MP4-12C GT3 321
60 77 AudiSport Louis M&M Racing Mercedes SLS AMG GT3 317
61 15 F4H Bullet F4H NFS Racing BMW M3 GT2 313
62 54 R1CARDOUK R4NG (P) BMW M3 GT2 310
63 141 Jonny705 RWS Prawn GP Audi R8 LMS 309
64 45 jenson09 ATR Dynamics BMW Z4 GT3 304
65 53 WCM Outlaw Mad Croc STORM Ford GT Mk7 304
66 747 Morphader NL Team CRA KOYO Racing BMW M3 GT2 300
67 555 FMS BriSCA Fusion Motorsport Ford GT Mk7 299
68 959 xSECR3T Cobblepop Motorsport Ferrari F458 Italia 297
69 246 Racert46 Team CRA KOYO Racing BMW M3 GT2 292
70 44 AMR Garage Scuderia Dewi Sant PopMax (P) BMW Z4 GT3 288
71 997 MaxpowerImerika Max Power Racing (P) Lamborghini Gallardo 288
72 221 MrRaZzT Krypton Motorsports Jaguar XKR RSR 286
73 980 hannibaljazz 98 JR Hamster Racing Lotus Evora Type T124 284
74 405 big dj210 Petronas Motorsport (P) McLaren MP4-12C GT3 282
75 768 BEESEA666 Team BSR Chevrolet Corvette ZR1 282
76 79 Duke of Bruno Virgin Team Racing Ferrari F458 Italia 281
77 230 MISTAR TOM Team Spiritus Chevrolet Corvette ZR1 279
78 926 Bandit1097 Jr Hamster Racing Lotus Evora Type T124 278
79 515 RW26 BLAZE Team Blaze Racing (P) Dodge Viper CC 271
80 275 LMR Deftone MX GTR Modena Porsche 997 GT3 RSR 267
81 175 Smu3l3y Krypton Motorsports Jaguar XKR RSR 263
82 380 GRA Kinetic RBX Motorsport Audi R8 LMS 261
83 232 MaxpowerIreland Ecurie Eire (P) BMW Z4 GT3 254
84 121 gregtwo RWS Prawn GP Audi R8 LMS 251
85 500 oX BEHEMOTH Xo Team Spiritus Chevrolet Corvette ZR1 244
86 433 XBR Jocker Underground Racing Lamborghini Gallardo 241
87 905 MATT PASTRAMNI Jr Hamster Racing Lotus Evora Type T124 239
88 11 lfcnicklfc Virgin Team Racing Ferrari F458 Italia 239
89 193 TrippyBoii X Continental Racing Dodge Viper CC 238
90 140 CQR CHRIS CQR Spitfires McLaren MP4-12C GT3 233
91 373 Om3ga73 Reverse Motorsports (P) McLaren MP4-12C GT3 232
92 382 GRA Calculon RBX Motorsport Audi R8 LMS 232
93 994 mopar4t4 Hailfire Racing Ford GT Mk7 232
94 180 PLOW tubbi PLOW Motorsport (P) Mercedes SLS AMG GT3 230
95 120 Raza20 RWS RJFF Lamborghini Gallardo 226
96 165 BalmierPie671 RWS RJFF Lamborghini Gallardo 221
97 207 LAPI74 NO-LAP Racing (P) Jaguar XKR RSR 219
98 3 F4H MOPAR001 F4H Motorsport Chevrolet Corvette ZR1 208
99 681 AndyT306 Underground Racing Lamborghini Gallardo 202
100 699 BCC BUSHWACKER Underground Racing Lamborghini Gallardo 198
101 149 DangerDave49 RWS RJFF Lamborghini Gallardo 191
102 94 Standaman94 Team Nurbracer Audi R8 LMS 188
103 152 Crisis Nine X Continental Racing Dodge Viper CC 187
104 2 Ianmr M&M Racing Mercedes SLS AMG GT3 186
105 505 S2M Jono Cobblepop Motorsport Ferrari F458 Italia 184
106 527 OcR Project239x OcR Tech Motorsport (P) Lamborghini Gallardo 182
107 173 AMLorick Fusion Motorsport Ford GT Mk7 180
108 73 CQR Magictap CQR Spitfires McLaren MP4-12C GT3 178
109 208 XBR EGGY Team XBR Lotus Evora Type T124 178
110 340 SSRT Pronebird YaH Racing Mercedes SLS AMG GT3 177
111 137 iTeknix Dynamics Motorsports Porsche 997 GT3 RSR 176
112 74 UK II Blackbird Team Nurbracer Audi R8 LMS 175
113 268 NoGoldie NTR BMW Z4 GT3 172
114 772 CQR Basher CQR Spitfires McLaren MP4-12C GT3 169
115 18 THEshat3r3dsoul Boost Mobile Racing (P) Lamborghini Gallardo 169
116 983 BCC DEANO Dellenny Racing Panoz Abruzzi 169
117 504 Realizd Runny Chicken Racing McLaren MP4-12C GT3 162
118 341 Rizzo5586 YaH Racing Mercedes SLS AMG GT3 160
119 317 Kungfu17 Blue Bomber Racing (P) McLaren MP4-12C GT3 159
120 24 AngelKristensen Spirit Motorsports (P) Chevrolet Corvette ZR1 156
121 909 S2M Ranger Dellenny Racing Panoz Abruzzi 156
122 27 LMR Scuderia GTR Modena Porsche 997 GT3 RSR 155
123 300 EZT Spartan BMW Motoradical (P) BMW Z4 GT3 155
124 21 Roflmaiwafflez RWS Mush Mush Racing Lamborghini Gallardo 152
125 36 MAJ0R LAZER RWS RJFF Lamborghini Gallardo 147
126 622 curleychris22 amd fibreworks racing Lotus Evora Type T124 141
127 359 Racing DK Team DK Jaguar XKR RSR 138
128 503 SAS v Bennett x Runny Chicken Racing McLaren MP4-12C GT3 138
129 84 GTR Evoluzione GTR Modena Porsche 997 GT3 RSR 137
130 93 Mandown46 Team Nurbracer Audi R8 LMS 137
131 216 MISTAR MANN Team Spiritus Chevrolet Corvette ZR1 133
132 187 Dav of Krypton Krypton Motorsports Jaguar XKR RSR 132
133 745 LosingShark Team CRA V-Power Racing (P) BMW M3 GT2 129
134 67 Friedrich II Team Nurbracer Audi R8 LMS 126
135 212 xC Davidson 7x RWS Velocity Motorsport McLaren MP4-12C GT3 124
136 254 TubeJockey2004 Never Forget Racing (P) Jaguar XKR RSR 121
137 969 CQR Hungover CQR Skullcandy Ferrari F458 Italia 120
138 92 XBR McRae Team GB ATR Dynamics BMW Z4 GT3 120
139 914 S2M Deuce Team DK Jaguar XKR RSR 118
140 712 Wiz v1 RWS Prawn GP Audi R8 LMS 116
141 260 k3mblesa1t Salt Racing (P) Aston Martin DBR9 112
142 406 Ri WEALy bin RWS Mush Mush Racing Lamborghini Gallardo 112
143 58 F4H Bandicoot F4H Motorsport Chevrolet Corvette ZR1 110
144 75 F4H Hamilton F4H Competition Porsche 997 GT3 RSR 106
145 687 alan687 amd fibreworks racing Lotus Evora Type T124 105
146 218 S2M Evo KW Motorsport (P) Porsche 997 GT3 RSR 97
147 195 matty786 amd fibreworks racing Lotus Evora Type T124 95
148 325 GAZ POT 71 Team CRA KOYO Racing BMW M3 GT2 94
149 245 gunnerman1100 South East Coast Racing (P) Lotus Evora Type T124 94
150 696 mattmeir 696 Motorsport (P) Lotus Evora Type T124 90
151 99 BG Papa H Aston Gulf Racing (P) Aston Martin DBR9 89
152 360 Bright Lights British Racing Greenz (P) Dodge Viper CC 85
153 721 aka Luka5 RWS Velocity Motorsport McLaren MP4-12C GT3 74
154 777 SirSegTheGreat Dynamics Motorsports Porsche 997 GT3 RSR 71
155 51 Stonewall458 ATR Dynamics BMW Z4 GT3 71
156 176 Sizemarlis1 Krypton Motorsports Jaguar XKR RSR 70
157 213 XBR Speedy Team XBR Lotus Evora Type T124 56
158 189 JAKE ALPHA JGMotorsports (P) Dodge Viper CC 40
159 600 TGE MiTcH Team XBR Lotus Evora Type T124 24
160 271 BlackLabel III BlackLabel Racing (P) BMW M3 GT2 22
161 209 CrMk Goldie Team XBR Lotus Evora Type T124 8
162 95 DeweyTee Underground Racing Lamborghini Gallardo 2
163 29 BuckeyeBullet20 Team GB ATR Dynamics BMW Z4 GT3 0
164 17 F4H FACEPALMER F4H NFS Racing BMW M3 GT2 0
165 22 FMS Jezza Fusion Motorsport Ford GT Mk7 0
166 818 FMS Nella Fusion Motorsport Ford GT Mk7 0
167 72 GLR Gashi F4H Motorsport Chevrolet Corvette ZR1 0
168 915 HIDEyourKIDS113 Jr Hamster Racing Lotus Evora Type T124 0
169 tbc IPR1VATE PARTSI RWS Mush Mush Racing Lamborghini Gallardo 0
170 996 J8mmy RWS Mush Mush Racing Lamborghini Gallardo 0
171 301 KingPrawn1 Team Nurbracer Audi R8 LMS 0
172 978 Lowrider Glissa Northland Peratielle Racing (P) Audi R8 LMS 0
173 924 M5RSCaptin Jr Hamster Racing Lotus Evora Type T124 0
174 28 nickyf1 Virgin Team Racing Ferrari F458 Italia 0
175 962 posixmosh X Continental Racing Dodge Viper CC 0
176 272 ry8114 RVS Motorsport (P) Chevrolet Corvette ZR1 0
177 532 S2M HERFORTH Team DK Jaguar XKR RSR 0
178 630 SandstormGeorge RWS Prawn GP Audi R8 LMS 0
179 42 silentalarm42 Virgin Team Racing Ferrari F458 Italia 0
180 222 xVampirAx MSM (P) Mercedes SLS AMG GT3 0

I've already done it on the Google doc.....what I meant by my previous statement was "give me some time to change it", not that I couldn't do it.

theres me thinking i was doing great now dropped 9 places with the points re done lol

checked and matches well I was only tying help.............................

On another matter, how come Carrera got points despite not racing?

No rush gents as it will probably be one of my dropped rounds at the end of the season but I'm showing as 0 points for round one where I actually got 181 points.

SelectiveRogue wrote:checked and matches well I was only tying help.............................

I know you were. I had all the formulas there, but for reasons of choice (i.e. not wanting to only show 1 scoring round up until yesterday), had it counting all 12 rounds so the two dropped rounds were two zeros for everyone and would have automatically kicked in from round 11 onwards.

All I had to do was change the sum range to rounds 1-4, but this will mean I now have to change the formula after every round.

CQR HABURi wrote:On another matter, how come Carrera got points despite not racing?

A slight admin error on my part. Since he (and some others) qualified, they score for "last" (when there's more than one they're then ordered by who qualified fastest) for race 1. I've removed the points for race 2 and re-sorted the standings.