FORZA 4 EK9.org challenge cup race nights??????


Which nights is best for you to run the EK9 challage cup?????


  • Total voters
    16

JIMBOB-EK9

Moderator
Donator
Joined
Jun 24, 2007
Messages
2,669
Any chance some of you could add me on Xbox. or send me your gamer tag so i can add you. I have no mates on Xbox like its new and most people i know use PS3.

If any of you remember the old GT5 races we used to have you know im a fair and clean racer like.
I'll add you when I go online in a min mate!:nice:
 


NeilVtec

Chuck Norris
Joined
Oct 17, 2008
Messages
2,241
Feel free to add me Kieran!

I Personally don't see the issue with him using an EG aslong it is still a B-Class 500, As goes for ITR's ???

But "TECHNICALLY" it is an EK9 Cup So only fair for everyone to have EK9's :D

After the Main Race we usually have a few other races anyway where you are free to choose whatever B-class you want! :)
 


keithiesbig1

EAT SLEEP BOOST RPT
Joined
Jun 15, 2010
Messages
1,284
Yeah the "EK9 CUP" will be limited to Ek9's, but any other races you can use whatever :nice:

The spreadsheet has evolved AGAIN!!! I am my worse critic :blabla:

I will Start a new topic at some point today with all the info and send you 2 lads the admin password with an e-mail explaining whats open and whats closed....this is to avoid a major failure with formula's and conditional formatting. Example of ONE of the formulas i worked on:

=COUNTIFS(Results!$C$11:$C$20,G$5,Results!$E$11:$E$20,$E6,Results!$B$11:$B$20,1)+COUNTIFS(Results!$C$30:$C$39,'User INFO'!G$5,Results!$E$30:$E$39,'User INFO'!$E6,Results!$B$30:$B$39,1)+COUNTIFS(Results!$C$49:$C$58,'User INFO'!G$5,Results!$E$49:$E$58,'User INFO'!$E6,Results!$B$49:$B$58,1)+COUNTIFS(Results!$C$68:$C$77,'User INFO'!G$5,Results!$E$68:$E$77,'User INFO'!$E6,Results!$B$68:$B$77,1)+COUNTIFS(Results!$C$87:$C$96,'User INFO'!G$5,Results!$E$87:$E$96,'User INFO'!$E6,Results!$B$87:$B$96,1)+COUNTIFS(Results!$C$106:$C$115,'User INFO'!G$5,Results!$E$106:$E$115,'User INFO'!$E6,Results!$B$106:$B$115,1)+COUNTIFS(Results!$C$125:$C$134,'User INFO'!G$5,Results!$E$125:$E$134,'User INFO'!$E6,Results!$B$125:$B$134,1)+COUNTIFS(Results!$I$11:$I$20,G$5,Results!$K$11:$K$20,$E6,Results!$H$11:$H$20,1)+COUNTIFS(Results!$I$30:$I$39,'User INFO'!G$5,Results!$K$30:$K$39,'User INFO'!$E6,Results!$H$30:$H$39,1)+COUNTIFS(Results!$I$49:$I$58,'User INFO'!G$5,Results!$K$49:$K$58,'User INFO'!$E6,Results!$H$49:$H$58,1)+COUNTIFS(Results!$I$68:$I$77,'User INFO'!G$5,Results!$K$68:$K$77,'User INFO'!$E6,Results!$H$68:$H$77,1)+COUNTIFS(Results!$I$87:$I$96,'User INFO'!G$5,Results!$K$87:$K$96,'User INFO'!$E6,Results!$H$87:$H$96,1)+COUNTIFS(Results!$I$106:$I$115,'User INFO'!G$5,Results!$K$106:$K$115,'User INFO'!$E6,Results!$H$106:$H$115,1)+COUNTIFS(Results!$I$125:$I$134,'User INFO'!G$5,Results!$K$125:$K$134,'User INFO'!$E6,Results!$H$125:$H$134,1)

:angry2: I have made all races 25 min long and the last race of the season 60 min long (Endurance). 7 races for season 1 and 7 races for season 2.

FULL details will be uploaded into new topic later, and i will try and find the time to send a group PM out to all xbox users that have added their details to : http://www.ek9.org/forum/gaming/7781-xbox-live-gamertags.html

:blinx:
 


keithiesbig1

EAT SLEEP BOOST RPT
Joined
Jun 15, 2010
Messages
1,284
And if i can get it done today i propose 1st race this Sunday 11th December 2011 @ 8PM :run:
 



Kozy

Bench Racer
Vendor
Joined
Aug 18, 2008
Messages
4,085
Slightly off topic, but...

=COUNTIFS(Results!$C$11:$C$20,G$5,Results!$E$11:$E$20,$E6,Results!$B$11:$B$20,1)+COUNTIFS(Results!$C$30:$C$39,'User INFO'!G$5,Results!$E$30:$E$39,'User INFO'!$E6,Results!$B$30:$B$39,1)+COUNTIFS(Results!$C$49:$C$58,'User INFO'!G$5,Results!$E$49:$E$58,'User INFO'!$E6,Results!$B$49:$B$58,1)+COUNTIFS(Results!$C$68:$C$77,'User INFO'!G$5,Results!$E$68:$E$77,'User INFO'!$E6,Results!$B$68:$B$77,1)+COUNTIFS(Results!$C$87:$C$96,'User INFO'!G$5,Results!$E$87:$E$96,'User INFO'!$E6,Results!$B$87:$B$96,1)+COUNTIFS(Results!$C$106:$C$115,'User INFO'!G$5,Results!$E$106:$E$115,'User INFO'!$E6,Results!$B$106:$B$115,1)+COUNTIFS(Results!$C$125:$C$134,'User INFO'!G$5,Results!$E$125:$E$134,'User INFO'!$E6,Results!$B$125:$B$134,1)+COUNTIFS(Results!$I$11:$I$20,G$5,Results!$K$11:$K$20,$E6,Results!$H$11:$H$20,1)+COUNTIFS(Results!$I$30:$I$39,'User INFO'!G$5,Results!$K$30:$K$39,'User INFO'!$E6,Results!$H$30:$H$39,1)+COUNTIFS(Results!$I$49:$I$58,'User INFO'!G$5,Results!$K$49:$K$58,'User INFO'!$E6,Results!$H$49:$H$58,1)+COUNTIFS(Results!$I$68:$I$77,'User INFO'!G$5,Results!$K$68:$K$77,'User INFO'!$E6,Results!$H$68:$H$77,1)+COUNTIFS(Results!$I$87:$I$96,'User INFO'!G$5,Results!$K$87:$K$96,'User INFO'!$E6,Results!$H$87:$H$96,1)+COUNTIFS(Results!$I$106:$I$115,'User INFO'!G$5,Results!$K$106:$K$115,'User INFO'!$E6,Results!$H$106:$H$115,1)+COUNTIFS(Results!$I$125:$I$134,'User INFO'!G$5,Results!$K$125:$K$134,'User INFO'!$E6,Results!$H$125:$H$134,1)
:wow:

Nice work! Easy to get lost in those spreadsheets especially when it develops an error, props for creating that beast! :nice:

Don't have much experience with kind of thing you've done there, but here's one of my finest pieces of work, it figures out how much pedal force it takes to hold a car at threshold braking... :nono:

=(D11*(D5*D6+((D10*(((D53*D49*D13^4*((D54/24)-(D44/24))*(D51^2+D52^2)*(100*D13^2*M29*D8+25*PI()*D50^2*D43*D42+D32*D13^2*M29*D14-100*D13^2*M29*D43*D8-D32*D13^2*M29*D14*D43))/(600*D50^2))+((D36*D31*D13^6*(M29*D8+((D32*M29*D14)/100))*((D37/24)-(D26/24))*(D34^2+D35^2))/(6*D33^2))))/D9))-(((2*D10*D12)*(((D53*D49*D13^4*((D54/24)-(D44/24))*(D51^2+D52^2)*(100*D13^2*M29*D8+25*PI()*D50^2*D43*D42+D32*D13^2*M29*D14-100*D13^2*M29*D43*D8-D32*D13^2*M29*D14*D43))/(600*D50^2))+((D36*D31*D13^6*(M29*D8+((D32*M29*D14)/100))*((D37/24)-(D26/24))*(D34^2+D35^2))/(6*D33^2))))/D9)-(D36*D31*D13^6*(M29*D8+((D32*M29*D14)/100))*((D37/24)-(D26/24))*(D34^2+D35^2))/(6*D33^2))

Why do we do it to ourselves eh?
 

Last edited:

keithiesbig1

EAT SLEEP BOOST RPT
Joined
Jun 15, 2010
Messages
1,284
Haha i could have made it simple and get whoever was filling it out to fill in multiple things...but i thought i would experement with formula's etc and see if i could get it to a point where you fill out the results from a pre filled in list and it does it for you......

I WIN!!!! :cheers:

Its rewarding when it works, but when it fails :nono: I even transfered mine to a new sheet arfter error, forgetting the cells were locked! evertime it referenced a tab it had the file path to the original sheet....FAIL!!! :nono:

Actually had work to do this afternoon, so will try update things tonight and get it sorted for this sunday. Gives a few days practice etc :nice:

Edit: That formula, is 1 cell. Same formula used in over 500 cells for calculating how many times the user comes 1st, 2nd, 3rd...... NIGHTMARE :nerv:
 







NeilVtec

Chuck Norris
Joined
Oct 17, 2008
Messages
2,241
That Info Page is Epic mate. Fair play! Can't wait to get behind the toy wheel on sunday! :D
 


keithiesbig1

EAT SLEEP BOOST RPT
Joined
Jun 15, 2010
Messages
1,284
That Info Page is Epic mate. Fair play! Can't wait to get behind the toy wheel on sunday! :D
Cheers mate, need to see if its logged how many hours i have worked on it :blabla:

I tried the manual with clutch & ABS off last night.......gearbox was :nerv: after 1 lap! So hard to get out of your set ways :nono:

Think i will be getting used to the steering wheel for the season racing :nice: need to make a rig of some sort :woot:
 


Kozy

Bench Racer
Vendor
Joined
Aug 18, 2008
Messages
4,085
I need a wheel. Sadly, having seen those Fanatecs, nothing else will do!
 


NeilVtec

Chuck Norris
Joined
Oct 17, 2008
Messages
2,241
Yeah My MS wheel broke, and was going to fork out for a fanatec but then found a second hand wheel for £40 in a CEX store so just bought that, As much as i would LOVE to have the Fanatec i cant justify £500 odd point on a toy steering wheel, Thats a Couple of trackdays!!! :D haha

Maybe one day!!!
 


JIMBOB-EK9

Moderator
Donator
Joined
Jun 24, 2007
Messages
2,669
I had a go at using the clutch with the steering wheel the other night & its F**KING HARD to get used to, ill get there though!:p

Need to play with the cars setup more than anything!:(
 


JIMBOB-EK9

Moderator
Donator
Joined
Jun 24, 2007
Messages
2,669
Yeah My MS wheel broke, and was going to fork out for a fanatec but then found a second hand wheel for £40 in a CEX store so just bought that, As much as i would LOVE to have the Fanatec i cant justify £500 odd point on a toy steering wheel, Thats a Couple of trackdays!!! :D haha

Maybe one day!!!
Dam right it is!:drive:
 


Kozy

Bench Racer
Vendor
Joined
Aug 18, 2008
Messages
4,085
Clutch is a ballache, especially trying to re-learn braking with a different finger if you don't use ABS. You feel like an absolute hero when you get it all hooked up though, especially blipping the downchanges. :D
 


Top