[Strykr]

I am trying to create an excel player level calculator for an online football game that I am involved with.

I have created some drop down tabs that allow for specific entries within a specific range.

Basically the inputs are as follows:

Current player level (1-50)
Current player experience (0-999)
Game days remaining (0-16)
Season days remaining (0-40)
Game day (odd or even)

Then for each level there are 2 sets of exp. daily experience and game experience.

So I need the calculator to take into account that a level 1 earns 100 exp per day and 479 exp per game. A level 2 earns 89 exp per day and 445 per game and so on.

So if they hit 1000 experience the calculator will pull the daily/game exp from the level 2 ranges.

Also the odd/even is set up because daily exp is given at the beginning of the day and it is possible that a player will level before a game and thus need to use information from 2 different areas.

Example (long-hand)

Level 1 w/ 905 exp already.

Daily exp +100= level 2 with 5 exp, then they play a game and receive 445 rather than 479 exp.


Anyone have any idea how I might set up a formula on excel to do this, or is it just too complicated?