Excel wizz needed to help with GT5 league spreadsheet

  • Thread starter PAPPACLART
  • 8 comments
  • 1,589 views
PAPPACLART

PAPPACLART

1,945
Italy
Treviglio
PAPPACLART
PAPPALCART
Hey

I am looking for somebody who is an Excel wizz to help me create a spreadsheet and formula for my GT5 League.

Our new season is about to kick of and it would be great if someody would help and offer some of there time.

The idea is for all of the results from our leagues to be inputed for each individual league, for points to be added up on a per race basis which add to the individual league standing, and for all results from all competitions to be added to an overall stats page. At the moment we have a stats page, where all race results are added individually regardless of the league but this atm moment is a manual affair and we want to save Admin time.

I would like to be able to just add the result of the race per member and then for points in the individual league to be updated automatically as well as added to the overall stats page.

Here is a link of our current stats page which I would like integrated with all other league standings/results. it was created by a member that is no longer active.

https://docs.google.com/spreadsheet...HhhZGV4VlBHc2FibDJoNTl0RGJ6VEE&hl=en_GB#gid=0

I have created this sheet (which needs revising) which has 5 of our upcoming championships. https://docs.google.com/spreadsheet...0zZjRnSEx0Umc&authkey=CIrR40E&hl=en_GB#gid=17

Any help will be much appreciated. For those that can help please add me on PSN and I can if required explain better on mic.

Many Thanks

Ryan
 
Last edited:
Bump

we actually finished our Q3 season above, and now are 2 events into the Q4 season, same problem again.


Anyone willing to help? It is such a chore to update my stats with all my other admin duties, I am 8 races behind for 2 championships spread across 2 divs! lol

Then once done will need everything added to this page. Which is a page that has been neglected but was orginally intended as a one stop shop to view our event histories, qualifier, race replays winners looser etc.

https://sites.google.com/site/gbracingclub/home-1/gbrc-official-stats


Again if anybody who is willing to help, I can post up or speak on mic in more detail.


Thanks a million
 
Last edited:
Hmmm... I'll have a quick look for you. While i'm by no means a whiz, I did manage to put together a pretty decent arvhive for a series i'm part of using Googles Docs. I've made a copy of yours so I can fiddle around with it and post you a link once i'm done 👍

EDIT: The "L" coloumn.... Does it really need to be there?
 
Last edited:
Thanks ever so much, if you need a proper description of what I need let me know and I can PM you. Really appreciate your help.
 
I need permission to access/view edit, just sent a request via my PAPPACLART google emai

Many thanks, can't wait to cehck it out
 
Hey, the sheets did not work for me exactly how I wanted so I gave it a go myself and realised that I am allot better then I thought. I still can't figure out how to make the GBRC stats update once an individual result is imputed so that will still have to be done manually but I now have the points adding up for individual championships automatically.

Linky https://docs.google.com/spreadsheet...GZFQ25DWG0zZjRnSEx0Umc&authkey=CIrR40E#gid=20 (sheet is tabbed)

Thanks for your help
 
Last edited:

Latest Posts

Back