Need some formulas for a management game
Hello everyone! I have a board for a management game, which you’ll find attached. Normally, everything is in English except for the ‘actions’. On my main board, I have 120 squares representing 120 seconds during which the player can construct or upgrade buildings depending on their resources (there are two resources: wheat and wood) (the buildings are listed, and the player simply clicks on the square and selects the building they wish to purchase). Next to this, I have three tables corresponding to the three types of buildings in the game (farms producing wheat, sawmills producing wood, and schools boosting the output of the first two buildings), showing their levels, the resources required for upgrades, and their production. Just below that, I have a table with one column summarising current earnings and another summarising the highest earnings achieved.
Based on this, I’m encountering several issues with my cells and need various formulas.
For the 120-second timer:
- I’d like to be able to colour the cells using conditional formatting, but instead of a fixed number, I’d like the colour to vary depending on the building’s level, and therefore vary from one cell to another based on the associated level. I suppose the INDEX formula would be the most suitable, but I’m not quite sure how to implement it.
- As an added bonus, I’d like it to be impossible to construct a building if the necessary resources aren’t available (in the first screenshot, you can see that my selection is possible right from the start of the table even though I have no resources to build the buildings, so I’d like to be able to add a restriction).
For the summary table:
- A formula that replaces the best row with te current row if the maximum return is exceeded (and that doesn’t change with every negative change)
- In addition, the ability to display the seconds at which buildings are purchased (and, if possible, to do so in a single cell for each building as shown below; otherwise, to do so in different cells depending on the number of buildings constructed)
Thanks in advance to everyone who will help me!
[link] [comments]
Want to read more?
Check out the full article on the original site