Log in

I forgot my password

Latest topics
» Moved to PC racing.
Fri Feb 24, 2017 9:15 pm by JVanEssen

» Announcing...
Wed Aug 31, 2016 2:58 pm by EZT MAKO 6669

» ..................its been a while!!
Thu Aug 11, 2016 3:17 am by OutlawedXJ

» Whos up for some racing?!?
Sat Aug 06, 2016 4:46 pm by OutlawedXJ

» Its Me Innit
Fri Jun 17, 2016 8:23 pm by HCR TJSteel

» VIR whos bought it??
Sun Jun 12, 2016 5:48 am by OutlawedXJ

» Forza 6: schedule question
Tue May 31, 2016 9:21 pm by t0rm3nt3d 3vil

» D Production Season 1 - Schedule
Sat Apr 30, 2016 4:42 pm by HCR Karma

» Hello Fellow Racers
Wed Apr 27, 2016 5:37 pm by HCR Bellmond

Counter
hit counter
hit counter
Search
 
 

Display results as :
 


Rechercher Advanced Search

Keywords


RUF CUP- THANK YOU

Page 1 of 2 1, 2  Next

View previous topic View next topic Go down

RUF CUP- THANK YOU

Post by F4H Devil on Mon Dec 30, 2013 12:04 am

Hey guys, just want to say thank you to the 6/7 of you who stuck with the championship until the end. Im sorry more racers didnt turn out for this. The car wasnt the best but i thought it gave some great racing. A shame so many missed out.

On another note: thats my final FM4 championship. Some great times, thank you sooo much, its been MY pleasure to provide you all with some Xtremely close racing/championships and i have EVERY replay.

Here's hoping FM5 gets sorted otherwise my next comp will be Autumn 2014 on Project C.A.R.S

_________________

XPLR - XBOX Pro League Racing

www.TheUltimateRacingNetwork.com
www.f4h.es
www.twitch.tv/F4HDevil
avatar
F4H Devil

Posts : 1592
Points : 3837
Join date : 2012-10-20
Age : 34
Location : Swadlincote

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by XPR ChicaiN on Mon Dec 30, 2013 4:15 pm

Thanks for running this. I thought the cars and racing was great and don't think it had anything to do with the lack of participants throughout the series. It may not be a bad idea to put up a results thread or rearrange the stat sheet so its clear who placed where.
avatar
XPR ChicaiN

Posts : 213
Points : 1800
Join date : 2013-08-30
Age : 41
Location : Canton, Michigan

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Mon Dec 30, 2013 6:02 pm

I got a bit bored so worked on a sheet that automatically updates the standings, team standings and privateer standings in sorted order and takes into account the drop scores so if anyone wants a copy of the document to use for future events then let me know

I havent added any colour to it but its functional

Oh and look who's top of the Privateers Very Happy




HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR Karma on Mon Dec 30, 2013 6:08 pm

TJSteel wrote:I got a bit bored so worked on a sheet that automatically updates the standings, team standings and privateer standings in sorted order and takes into account the drop scores so if anyone wants a copy of the document to use for future events then let me know

I havent added any colour to it but its functional

Oh and look who's top of the Privateers Very Happy




I like it a lot chief....How would you feel about helping out in the future with other spreadsheets for the various series? We are always needing willing skilled hands and from the one u posted u have them in spades sir Very Happy 

_________________

XPLR - XBOX Pro League Racing
Site Co-Founder

If at first you don't succeed, skydiving is not for you.



If you wish to submit a stewards inquiry please do so by clicking >>here<<
avatar
HCR Karma
Co Founder

Posts : 2683
Points : 4898
Join date : 2012-10-20
Age : 44
Location : Lauder, Scottish Borders

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by XPR ChicaiN on Mon Dec 30, 2013 6:32 pm

Thank you Devil
avatar
XPR ChicaiN

Posts : 213
Points : 1800
Join date : 2013-08-30
Age : 41
Location : Canton, Michigan

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Mon Dec 30, 2013 11:08 pm

Eerm I may have an obsession with spreadsheets lol.

I really wouldnt mind building more.

Think that one only took around an hour.

Took longer to copy the results in lol

Most of it auto completes. All you need to add is the driver number, quali times and positions and everything else calculates itself Smile

Just let me know what you want in the next one (Amount of rounds, races per round, and points per position) and when you need it and I'll happily build it Smile

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR Karma on Tue Dec 31, 2013 11:35 am

Steel,

Will u be online say tomorrow evening or the day after, as I would like to talk though what we need as far as the sheets go my friend  Smile 

Let me know when ur free

Happy new year to ya as well when it comes

Greg Cool 

_________________

XPLR - XBOX Pro League Racing
Site Co-Founder

If at first you don't succeed, skydiving is not for you.



If you wish to submit a stewards inquiry please do so by clicking >>here<<
avatar
HCR Karma
Co Founder

Posts : 2683
Points : 4898
Join date : 2012-10-20
Age : 44
Location : Lauder, Scottish Borders

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Tue Dec 31, 2013 1:24 pm

I'm off work tomorrow so I'll probably be on all day Smile

You on xbox one? I been on forza 5 non stop as I just bought myself one but if your on 360 just drop me a message on xbox and I'll jump on the 360 for you

I've started building a large template and adding in things that I think will be useful

I'm basing it at the minute on the CTCC season as this is the next season starting up so I'll have it complete before that starts. probably by the end of today as work is a bit quiet and have nothing else to do on breaks lol

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR Karma on Tue Dec 31, 2013 1:51 pm

ace,, not got a one yet so I will hit u up later today if ur free to chat chief.

Thank you for being up for helping. we are only as strong as the community we have.  Smile 

Greg

_________________

XPLR - XBOX Pro League Racing
Site Co-Founder

If at first you don't succeed, skydiving is not for you.



If you wish to submit a stewards inquiry please do so by clicking >>here<<
avatar
HCR Karma
Co Founder

Posts : 2683
Points : 4898
Join date : 2012-10-20
Age : 44
Location : Lauder, Scottish Borders

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Tue Dec 31, 2013 2:41 pm

I may be online tonight. I can PM you my number if you want incase I'm offline

Think I have the sheet complete Smile

I've linked it below

Basically you fill in everything in the light grey and the dark grey sorts itself out

Colours and things like that can be changed to whatever is needed but this colour scheme was just to highlight were the formula's are Smile

The driver list I have is on a seperate spreadsheet that can be used as the global name sheet for all drivers which will update all other sheets automatically if there are any name changes

If theres anything missing that you think needs adding let me know

This only has enough for 50 drivers but its not too hard to extend if needed Smile

Its been a while since we had a multi lobby league though Sad


HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR Karma on Tue Dec 31, 2013 4:03 pm

Am hopeful for better number this time. It feels like this comp is just coming at the right time plus with the quality of the builds and the team now in place..

Let us hope for busy days ahead,,lol

G  Laughing 

_________________

XPLR - XBOX Pro League Racing
Site Co-Founder

If at first you don't succeed, skydiving is not for you.



If you wish to submit a stewards inquiry please do so by clicking >>here<<
avatar
HCR Karma
Co Founder

Posts : 2683
Points : 4898
Join date : 2012-10-20
Age : 44
Location : Lauder, Scottish Borders

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by XPR ChicaiN on Tue Dec 31, 2013 4:05 pm

XPR Karma wrote:Am hopeful for better number this time. It feels like this comp is just coming at the right time plus with the quality of the builds and the team now in place..

Let us hope for busy days ahead,,lol

G  Laughing 

Everyone needs to do their part in spreading the word. Stephen is a great example of this.
avatar
XPR ChicaiN

Posts : 213
Points : 1800
Join date : 2013-08-30
Age : 41
Location : Canton, Michigan

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Tue Dec 31, 2013 4:16 pm

Well I'm hoping for more,

I miss the B lobbies,

I could actually make overtakes on that lobby and be more competitive,

All I do with the 1 lobby is defend. With that being said tho I do feel that my defensive racecraft has improved a lot from when I started racing with you guys so when if I get fast enough to overtake you I should be good at then defending the position.

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by XPR ChicaiN on Tue Dec 31, 2013 4:47 pm

Nice work on the spreadsheets TJ. Your efforts are much appreciated.

Here's some visual inspiration when you start prettying it up.

https://docs.google.com/spreadsheet/ccc?key=0Ap5YehT0FLLJdEpES1pjdkFiUHFFTWhBbjRVQkh0U3c&authkey=CLe-sI0F&hl=en&authkey=CLe-sI0F#gid=0
avatar
XPR ChicaiN

Posts : 213
Points : 1800
Join date : 2013-08-30
Age : 41
Location : Canton, Michigan

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Tue Dec 31, 2013 5:42 pm

Theres loads of data in there

I'm not normally too good at the making things look nice part, just the making it work part lol

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by XPR ChicaiN on Tue Dec 31, 2013 5:57 pm

TJSteel wrote:Theres loads of data in there

I'm not normally too good at the making things look nice part, just the making it work part lol



The stats that are on that spreadsheet won't be the same stats for this series. That is a series that will run later this year and just some food for thought. I believe Venom is your contact for whatever stats go for this series.
avatar
XPR ChicaiN

Posts : 213
Points : 1800
Join date : 2013-08-30
Age : 41
Location : Canton, Michigan

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by AndyT306 on Thu Jan 02, 2014 9:13 am

nice work TJ... our sheets currently do this, i just haven't been online to sort the results, should all be updated now Smile

_________________

XPLR - XBOX Pro League Racing
avatar
AndyT306
Co Founder

Posts : 2104
Points : 4554
Join date : 2012-10-20
Age : 36
Location : Birmingham

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Thu Jan 02, 2014 11:33 am

I thought your sheets would calculate things for you I just noticed it wasnt sorted automatically and I had a bit spare time so thought I'd give it a go.

for an auto sort you basically have the data in the sheet twice.

one set of calculated data but not sorted then another set which is an auto sort of the calculated data using the =sort function.

all you then do is hide the set of unsorted data

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by AndyT306 on Thu Jan 02, 2014 11:36 am

makes sense... just never got round it figuring out a way of doing it

_________________

XPLR - XBOX Pro League Racing
avatar
AndyT306
Co Founder

Posts : 2104
Points : 4554
Join date : 2012-10-20
Age : 36
Location : Birmingham

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Thu Jan 02, 2014 11:46 am

Didnt take me too long to build that one to be honest

If you need any help building sheets or want me to make any though then let me know

I've built a fair few of them for work and think I know most of the functions pretty well

google sheets are a little different to excel though so some things are a bit different

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by AndyT306 on Thu Jan 02, 2014 11:48 am

yeah i use excel all day... might need your help with the current sheets and updating etc...

pm me your google email and i'll give you access to a test sheet

_________________

XPLR - XBOX Pro League Racing
avatar
AndyT306
Co Founder

Posts : 2104
Points : 4554
Join date : 2012-10-20
Age : 36
Location : Birmingham

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Thu Jan 02, 2014 11:56 am

its : jaysteel78@gmail.com

and yeah I'm pretty much the same. not as much as I used to though.

Was going to use conditional formatting too so that the drop scores were highlighted but its not as good at excel for that. cant use formula's in the formats. you apparently can with the new google sheets but then the sort feature is not there yet so you cant win lol

I'll add you to these sheets too if you want to see how they work

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by AndyT306 on Thu Jan 02, 2014 11:57 am

added you to one of ours... i'll be changing it later to accommodate for the CTCC

_________________

XPLR - XBOX Pro League Racing
avatar
AndyT306
Co Founder

Posts : 2104
Points : 4554
Join date : 2012-10-20
Age : 36
Location : Birmingham

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by HCR TJSteel on Thu Jan 02, 2014 12:07 pm

Just moved my docs into a folder and added you to that if you want to see how I created mine

It looks to be honest like we've both built the sheets the same. just some slight differences in the way round some things are calculated lol.

and exactly the same idea with the driver list using importrange. was it just me or was the syntax for setting that up a bit hard to follow? took me about 4 attempts and realised I missed out adding the ""'s around the sheet url. lol

HCR TJSteel

Posts : 253
Points : 2149
Join date : 2012-10-21
Age : 30
Location : Sunderland

View user profile

Back to top Go down

Re: RUF CUP- THANK YOU

Post by AndyT306 on Thu Jan 02, 2014 12:08 pm

yeah was a tough one to setup, grab me on drive chat if you are about

_________________

XPLR - XBOX Pro League Racing
avatar
AndyT306
Co Founder

Posts : 2104
Points : 4554
Join date : 2012-10-20
Age : 36
Location : Birmingham

View user profile http://www.xboxproleagueracing.com

Back to top Go down

Re: RUF CUP- THANK YOU

Post by Sponsored content


Sponsored content


Back to top Go down

Page 1 of 2 1, 2  Next

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum