Need some formulas for a management game
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Proper maintenance of game activity tableI'm part of a team of a rather small hobby game that we've been running for many years now. We've been running simple activity summaries in hours spent like this monthly, ever since beginning in April 2017. They simply go like this: GM Matt - 65.7h M Aiden - 54.3h K Hawk - 32.1h K Tell - 30.0h M Poe - 27.6h T Tribux - 25.4h M Vair - 24.5h K Rodian - 23.3h K Eventide - 20.1h T Crab - 14.4h M Voss- 14.3h M Teir - 9.1h M Vallin - 4.4h T Forrte - 0.5h They're posted monthly so there are similar tables for May 2017, June 2017 and so forth up to April 2026. I want to start storing them all in Excel, this is what I did so far: https://preview.redd.it/n9oem7xh2zug1.png?width=1529&format=png&auto=webp&s=95855988839af802d4d6830df3996943eecdc85f The sum part for each year is simply: =SUM(D3:L3) and so on. Then there's a final column "ALLTIME" where I sum everything to the left except the columns with yearly sums. This works so far, but I'm wondering if there's a better approach that's gonna be more comfortable in the future if I want to extract more data. I have zero experience with data management and Excel, this is what came intuitively to me, but I want to know if there isn't something that will bite me in the ass in the future. submitted by /u/Informal-Ordinary387 [link] [comments]
- Making recipe tree chart but having trouble formatting and automating itElectronic circuits recipe broken down and put into this weird format chat gpt recommended me 😭 The way I have formatted it for actual use (note that I don't know quite how to make it look readable and nice even for myself) Ok so basically I'm trying to make a sheet that will show an items recipe (this is a video game) and the recipe steps, the requirements I'm trying to meet are to have it be dynamic as more efficient ways of producing something (like making plates at a 1 to 1 instead of 3 to 2 for example) become available, and some sort of autofill where if I type like Red alloy cable it knows what makes up that material and will enter that down for me. I'm also wondering what format I should be using, because at the moment you can't tell (at least in the 2nd photo) which materials make up another at a glance. (I'm not sure if this follows the subs rules of not posting to learn excel, but I did check out the link associated with it for a good 30 mins and couldn't find the perfect answer I was looking for) anyway yeah any help is really REALLY appreciated I've been struggling for most of the day xD. If any more info is needed I can totally supply that as well (: submitted by /u/Fletcher_767 [link] [comments]