+ Reply to Thread
Results 1 to 2 of 2

Creating a scoring sheet for race series

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    Cleveland
    MS-Off Ver
    Excel 2007
    Posts
    1

    Creating a scoring sheet for race series

    I was going to ask this in the "formulas" section, but I think describing the result I'd like to achieve will get me a better answer than asking "how do I" do what I think is the correct way...

    I am trying to track points standings for a 10-round race series. Each weekend, we run two heats for each class, with first place being awarded 25 points, second being awarded 20, and so on.

    So for example, if "Jeff" gets first place in both heats on the first two race weekends (4 races total), his finishes would be listed as "1" (or I could live with having to enter "1st" or even "first"), but when I total his points at the bottom of the column, I need for those 4 heat wins to total 100 points (25 for each win).

    What is the best way to accomplish this? If I could simply make 1=25, 2=20, 3=16, 4=13, 5=11, and so on down to 15th place, that would really be the simplest thing to do, so long as it doesn't screw up my simple "sum" function for the columns.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Creating a scoring sheet for race series

    The standard answer would be - get familiar with VLOOKUP function.
    It will let you easily assign 1=25, 2=20, 3=16...
    you can either have your table in a spreadsheet or built into formula.
    lets say you have a place in first race of first on the start list in cell B2 (and he finished 4th - so it is 4 in B2)
    in F2 (3 columns left for races 2-4 places) we will write his points as formula:
    =VLOOKUP(B2,{1,25;2,20;3,16;4,13;5,11},2,0)

    of course - a longer one, because you has to add ;6,pointsfor6;7,pointsfor7 etc.

    the final 2,0 are important arguments - do not change it.

    Probably less standard answer would be even simpler, but I think most of this thread readers will first think of VLOOKUP, as I did.

    The alternative is:
    =CHOOSE(B2,25,20,16,13,11)


    So now you are on pole position to win "your Excel race" ;-).
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a Fantasy Football Scoring Spreadsheet
    By joeman242320 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-24-2013, 02:53 PM
  2. Race scoring worksheet template/request
    By Diplomatti in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2013, 08:38 PM
  3. Creating a performance scoring system
    By Tony89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2012, 05:22 AM
  4. Replies: 0
    Last Post: 06-27-2012, 11:01 AM
  5. Creating a race submition form
    By Shawn in forum Excel General
    Replies: 1
    Last Post: 08-09-2005, 06:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1