Dhoomstriker
Girlie Builder
- Joined
- Aug 12, 2006
- Messages
- 13,474
The "KEY INFO" row tells you a lot of what you need to know.I think most of those are in the spreadsheet Dhoomstriker has sent me, but I need to make sense of it.
The only real info missing from the "KEY INFO" row is that I only mention the Scientists being hired in some parts of that text, while in other parts it assumes that you can look up a bit to the relevant values under the headings of "Total Scientists at current Size," "Total Scientists at (Current Size +1)," and "Total Scientists at (Current Size +2)."
There are a few NOTES in the row below that row which you should also read, to get a feel for the timing of the first couple of Great People and what options we have in terms of the timing.
The other data in the spreadsheet just helped me in coming to those values.
Note that you'll also have to scroll down to see which City a scenario is for. Below each City name, I put in a short but descriptive bit of text that helps you to figure out what the scenario is trying to accomplish, such as "Starve a bit," "Food Neutral," and "Grow +1 Size First," where "Grow +1 Size First" means growing the City by one more population point before hiring a ton of Scientists.
Values by hand
Sure, but as I suggested in my last message, if you come up with the Base GPP formulaically (the formulas should be pretty-straight forward to write, the trickiest part will be to anchor the cell values with dollar signs $), then you can copy and paste the columns multiple times and have all of the info laid out before you, instead of constantly having to recalculate the Base GPP values, which can get tricky because the number of turns at a particular Base GPP value changes over time for almost all scenarios except for the couple of cases where growth was stagnant from the start.Changing the base values (and fiddling with different options by hand) seems easiest to me.
Your Approach
That sounds fair, although I'd suggest that you check out the text in the NOTES area, as there are some tough choices to be made in terms of choosing where to generate the first 1 to 2 Great People, since we are so close to generating a couple of them in multiple Cities.This is how I plan to go about it.
1. First, create an estimate of the total number of GPP that city can generate.
2. Use that to work out how many great people each city can generate.
3. Create a great peson ordering, which is essentially an assignment of cities to great person numbers. Mostly by hand, obviously with help from the spreadsheet. This will be a combination of when the great people would naturally be generated, and when we want them to be generated (insofar as we can practically re-order anything).
4. Check that the ordering and plan is practical and robust. If not, return to step 2 or 3 to fix it.
5. If it is robust, make a note of it, then go back to step 2 and try and see if there could possibly be a better plan.
Your Questions
End Date... ummm... I have no clue? Hehe. Okay, let's say that you have 40 turns in which to generate Great People, after which any that get generated will take too long to reach their destination.Should be easy enough, I just need to get the answers to the questions I mentioned earlier:
* End date estimate
To help you out, we currently have these Great People:
1. Great Engineer (for sure to be used on The UN)
2. Great Engineer (maybe used on The UN--probably don't count on it for one of the final four)
3. Great Scientist (probably count it as a write-off for being Lightbulbed)
4. Great Scientist (probably count it as a write-off for being Lightbulbed)
5. Great Artist (here you have the most flexibility--Golden Age, one of the Final Four, or Lightbulbing part of Radio or Mass Media. Remember that Lightbulbing using non-Great-Scientists is pretty inefficient, so Lightbulbing is probably the weakest choice out of the available options)
6. Great Scientist from Physics (okay, we don't have him yet, but I just wanted to say that we'll count him as a Lightbulber, so don't rely on him being one of the Final Four--even if we do take Electricity with Liberalism, we shouldn't RELY on him for one of the Final Four, although he would become one of the Final Four in that case)
As I mentioned in one of my cross-posted messages, we're working on generating the Great Person worth 1500 GPP and I just listed the Great People that we have on hand.* Current great person number
Use my suggestion of a formulaic Base column, which simply takes as input a value from a Scientists column, multiplies it by 3, and adds to it 6 * the value of the "Parthenon?" column for Delhi, and adds to it 15 for Delhi or 1 for Grt Person Farm.* Correct base GPP values at food-neutral
You don't even need to account for the National Epic anywhere, as Mitch has changed a "1" to a "2" in the "Total" formulas for Grt Person Farm.
Actually, you probably WOULD NOT want to use dollar sign $ anchors, since you'd want the Base column's values to change relative to the relevant Scientist column's values, so these formulas should be incredibly easy to write.
See row 258 of the spreadsheet that I sent to you, which breaks it out by City but then has the value copied and pasted for each scenario of that City, as I'd planned to do a formulaic approach but Mitchum's already got that part done.* Correct current GPP value