Total peons | Per Peon income/h | Peon loss/h | Time calculated | Totalgold | |
Player1 | 10000 | 2.5 | 3% | n | ??? |
Player2 | 11000 | 2.5 | 3% | n | ??? |
Player3 | |||||
<tbody>
</tbody>
So, this is probably more a math problem than an excel problem. But while trying to simulate a game, I've come up with this problem. I want to be able to manipulate a number of constants (listed above) to give me the total gold gained over whatever unit of time.
The answer for player one would be:
10000*2.5 = 25000 for hour 1
10000*0.97*2.5 + 25000 (from hour 1) = 49250 for hour 2
9700*0.97*2.5 + 49250 (from hour 2) = 72772,5 for hour 3
etc...
I can sheet this out for one player using large tables and per time unit calculations, but I'm sure there's a way to do these calcs logarithmically, but can't for the life of me remember enough of my high school math...