Currently I’m making an adventure platformed game. In game, player collect coins (how original idea). After every level, player can use these coins to purchase 1 ups. Every 1up purchased will increase the 1up price by 1 (one). From levels player can also find items which will decrease the current 1up price by half.
I ran into a problem of calculating 1up price. I’m designing and figuring out, how many coins and price reduction items I need to place in levels for best balance. So I thought that easiest way of doing that is to create a spreadsheet, where I can input coin amount per level. That way, I could (in theory) easily play around with the coin amounts to find the best balance.
I tried and failed. Math isn’t my thing for sure. So could anyone help me to figure out how to make that spreadsheet? Even correct math formula is enough.
At the beginning of the game: 1up price = 1 coin.
Every 1up purchased increases the 1up price by 1.
Item which will reduce the current 1up price by half.
Any kind of help is highly appreciated.