Season standings based on points earned

Awesome! You are a godsend!

So, while the topic is fresh.. I have another question for you...

I attached the updated spreadsheet (all I did was expand how far down the columns the formula goes. But if you look at it again maybe it will help you answer this question.

Is there a way to associate a given number of points for a place finished?

Example: Lets say Mike Bell (from the spreadsheet) finishes 2nd in the [week 4] race and instead of entering the points earned, he simply entered "2nd" into the cell and hit enter. Now if 1st place is worth 20 points, 2nd = 18, 3rd = 16, 4th = 14, 5th = 12 , is there a way to reference these values so that all you have to enter is the place finished instead of points earned?

Points reduce per place by 2 until 11th place. 11th place and lower receive 1 point if they finish.

Reading tutorials on how to accomplish this feat has confused me more than anything else.

Thanks for your time!!

That is awesome!

I am not sure how you made the drop down list possible I guess, but it looks great! Now if I insert columns after "Week 4" for additional weeks will the formatting stay the same?
I know how to expand the range of standard formulas, but I cannot see where the info for the drop down is to apply it to "Week 5" and "Week 6" that I want to add.

Is there a simple way to do this?

P.S. Im jealous of your Excel skills

Hi again, please ignore my last post.

I was able to add the additional weeks without problems.
But I still have a wrench to throw in the machine if your willing to help me out still!?!?

Turns out that the scoring system isn't as simple as I originally thought.

Unless there are more than 5 racers in a single race, the points are reduced by half.
First I thought maybe I can create a second chart listing the other point system, and use some sort of IF THEN function to count the number of names in the racers names cell. But I have no idea how to do this since "week 1" could be a full race whereas "week 2" could be a bad turnout and only have 4 racers participate.

Is there a way to change the WEEK cells into drop down lists to select "Full Points" which references the original points chart, and a second option to select "Half Points" that would reference a new chart with points at half?

You Rock!
Thank you again for all your time!

great spreadsheet.

how did you manage to extend the weeks? i want to get to 9 weeks.

Thanks!

Just RIGHT click on heading of any week's column (letters E through J) and from context manu that will appear select "Insert"; that will bring you up new column, which is fully functional, but you just need to re-write headers "Week *n* results", to count from 1 to 9.

Hi everyone,

i would like to know how can i program it to have Class Rider to be in another Standings ( Standing for Class B )

i take the current version as overall standing

any one can help?