Results 1 to 8 of 8

Thread: Standings using Google Spreadsheets

Threaded View

  1. #1
    WMD Member Asturbo's Avatar
    Join Date
    Jun 2012
    Asturias / Spain

    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 :

    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: (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:

    Quote Originally Posted by Asturbo View Post
    Added Blank template with Rounds:

    Up 7 rounds of 6 races. If less rounds or races per round, you only need hidde the required columns
    Added a new one:

    Ahd this is how it looks after publishing:
    Last edited by Asturbo; 24-01-2021 at 18:14.
    CPU: Intel i9-9900KF | GPU: nVidia RTX2080Ti | RAM: Gskill 2x16GB DDR4 3600 | MB: Asus ROG Strix Z370 | SSD: Samsung EVO 970 500Gb | Monitor: Acer Predator Z35P UW WQHD | Wheel: Fanatec DD1 + Porsche Endurance + Formula 1 V2 | 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 /// PCARS4 wish list
    The following 6 users likes this Post: Chawabax, cpcdem, F1_Racer68, Hammerpgh, isfahanvisit, Konan

Similar Threads

  1. Career Standings gone?
    By Mowzer in forum Project CARS 2 on XBOX One
    Replies: 1
    Last Post: 03-12-2017, 15:30
  2. Useful software - Google Web Designer
    By jimmyb_84 in forum Off Topic Discussion
    Replies: 0
    Last Post: 31-12-2015, 22: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