Game System Design Task (Economy)

Using the spreadsheet software of your choice you must create a system that
demonstrates the structure of the following game economy:

•In an arena fighting game it costs 20 coins to enter a game with 5 other players
•You win 80 coins for 1st place, 40 coins for 2nd, 25 coins for 3rd, 10 coins for 4th and 0 coins for last.
•In a day a player can win up to 1500 coins. However average session time is 25m and each fight takes
4m
•There are 15 fighters available to unlock with the coins you earn.
• 20 Upgrades can also be purchased per fighter for coins.
•Design a system allows an average player to unlock fighters in 30 days and all upgrades in 180 days
(individual fighter stats not relevant for exercise, only upgrade costs)