Results 1 to 5 of 5

Thread: Standings using Google Spreadsheets

  1. #1
    WMD Member Asturbo's Avatar
    Join Date
    Jun 2012
    Location
    Asturias / Spain
    Posts
    1,279
    Platform
    PC

    Standings using Google Spreadsheets

    I'm using Google spreadsheets from a long time ago to keep the standings of my comunity.

    The advantage is that is easy to use, is easy to edit, and you can program decent statistics, without much efforts. Also you can publish directly from Google, or you can insert it as iframe in your own web or forum (if it allows iframes).

    Someone of other comunity asked me about that question, and I've made a template from mine's spreadsheet, that I have shared for him and anyone here who wants to use it :

    https://docs.google.com/spreadsheets...it?usp=sharing

    You can copy to your own Google Drive account, and use it the way you like.

    Some features:

    - Up to 25 races and 32 drivers.
    - Programable scoring system.
    - Discard "n" worst results for each driver.
    - Statitics of wins, podiums, poles & fiascos.
    - Number of races, best position, worst position, average & most repeated.
    - Autohighligths of the best in each category.
    - Team standings with statistics and comparision between both players of each team (second sheet of the book).
    - Macros to sort the list and apply format. Other button to clear the data but not the formulas (be careful with you data!!!)

    The published result linked as iframe looks something like this: http://sanganchao.com/h4-test (two iframes in same HTML)

    You can share/publish from Google with the share option. Also you can specify the range of cells you want to publish adding it to the resulting URL. Example: &range=a1%3Aar25&widget=false

    I've also a little bit more complex spreadsheets with rounds of races (we usually make cycles of 4-6 races with same car/category), with partials and overall standings. This one is still in spanish but if someone is interested ask me by PM. This one looks like this: http://sanganchao.com/portal?pid=24

    Edit:
    Quote Originally Posted by Asturbo View Post
    Added Blank template with Rounds: https://docs.google.com/spreadsheets...it?usp=sharing

    Up 7 rounds of 6 races. If less rounds or races per round, you only need hidde the required columns
    Last edited by Asturbo; 20-02-2019 at 17:39.
    CPU: Intel i7-8700K | GPU: nVidia RTX2080 | RAM: Gskill 2x8GB DDR4 3200 | MB: Asus ROG Strix Z370 | SSD: Samsung EVO 970 500Gb | Monitor: Acer Predator Z35P UW WQHD | Wheel: Fanatec CSW 2.5 | SO: Windows 10 Pro 64bits
    WMD1 & WMD2 Gold Member /// Steam Profile /// Unofficial Issue List /// Button Box Label Template /// DS Flags Calculator /// Open Weather App /// DS Config Samples /// Google Standings /// PC3 wish list
    The following 6 users likes this Post: Chawabax, cpcdem, F1_Racer68, Hammerpgh, isfahanvisit, Konan


  2. #2
    Moderator Konan's Avatar
    Join Date
    May 2015
    Location
    Belgium
    Posts
    13,205
    Platform
    PS4 Pro
    Very useful buddy, thanks
    AN OUTLAW MIGHT GIVE IN TO DESTINY BUT HIS LEGEND LIVES ON FOR ETERNITY!
    The following 2 users likes this Post: Asturbo, isfahanvisit


  3. #3
    GT3 Pilot
    Join Date
    Jul 2017
    Posts
    3,804
    Platform
    PC
    Maybe post/move it in the Online or General forums for more visibility? I am sure a lot of people can make use of this...
    The following user likes this Post: isfahanvisit


  4. #4
    Moderator Konan's Avatar
    Join Date
    May 2015
    Location
    Belgium
    Posts
    13,205
    Platform
    PS4 Pro
    Moved...
    AN OUTLAW MIGHT GIVE IN TO DESTINY BUT HIS LEGEND LIVES ON FOR ETERNITY!
    The following user likes this Post: cpcdem


  5. #5
    Superkart Pilot
    Join Date
    May 2015
    Location
    London
    Posts
    843
    Platform
    XBOX1 X
    Very handy.. good work
    2018 Indycar League on pCars 2 - http://consoleracing.boards.net/boar...ar-league-2018
    Vintage F1 on pCars 2 - http://consoleracing.boards.net/boar...1-championship
    Xbox One X, TM Ferrari Italia 458 TX, Xrocker Gaming Chair, Samsung 30" TV, RsDash.
    The following 2 users likes this Post: Asturbo, isfahanvisit


Similar Threads

  1. Career Standings gone?
    By Mowzer in forum Project CARS 2 on XBOX One
    Replies: 1
    Last Post: 03-12-2017, 16:30
  2. Useful software - Google Web Designer
    By jimmyb_84 in forum Off Topic Discussion
    Replies: 0
    Last Post: 31-12-2015, 23:05
  3. Google eavesdropping on you.
    By Martini Da Gasalini in forum Off Topic Discussion
    Replies: 8
    Last Post: 26-06-2015, 19:03

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •