Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point Scoring Using Substituted Numbers
Hi Everyone,
I'm having trouble creating a spreadsheet that calculates points for online racing simulation leagues. To make it easy to input the data I was thinking of having a table that contained the finishing positions and then excel could do the rest. The main problem I'm having is converting the table of finishing positions into a points table. The required data is as follows. Sprint Rounds constitute 2 races each worth 30 points 1st = 30 2nd = 28 3rd = 26 4th = 24 5th = 22 6th = 20 7th = 18 8th = 16 9th = 14 10th = 12 11th = 10 12th = 8 13th = 6 14th = 4 15th = 2 Enduro Rounds are 1 race only and therefore worth double points 1st = 60 2nd = 56 3rd = 52 4th = 48 5th = 44 6th = 40 7th = 36 8th = 32 9th = 28 10th = 24 11th = 20 12th = 16 13th = 12 14th = 8 15th = 4 You're worst (total) round will be dropped and the series champion decided on their best 5 rounds. In the long term I'm looking at making variables such as points awarded, dropping worst round and use of sprint rounds, etc... easily adjustable. Thanks in advance Nathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scoring rank change and corresponding point difference | Excel Worksheet Functions | |||
point scoring for sports club | Excel Discussion (Misc queries) | |||
Cell Value is substituted for value in command | Excel Discussion (Misc queries) | |||
how can i move the starting point for the numbers numbers down. | Setting up and Configuration of Excel | |||
Excel - can one value be automatically substituted for another? | Excel Discussion (Misc queries) |