When I started to develop the PWTWP&C Spreadsheet for Emperor, I never realized how complicated the formulas would become. Without the help of Nero Would, I don’t think that I would ever have been able to complete it. And, Emperor is a simple (straightforward) game compared to Pharaoh.

The major problem that I would have developing a similar spreadsheet for Pharaoh is that I don’t know how to calculate the number of workers that a population will provide. Also, I know that the number of available workers changes with time due to the “aging population”. When I am designing a new city, I typically assume that about 40% of the people living in common housing will be workers and usually end up with a few extra workers if I don’t spend too many years completing the city. I guess that this could be handled by providing a box where the user could enter the percentage of the population living in common housing that works, with 40% being the default value (unless someone has a better idea).

To complicate the formulas for Pharaoh even further is the fact that 1x1 housing consumes more goods per resident than the 2x2 version of the same housing type. There would have to be separate entries for 1x1 houses. Food consumption is reduced if there is a Temple Complex to Bast, or an Altar to Sebek, so there would have to be an option to include them.

One bonus that a PWTWP&C Spreadsheet for Pharaoh could provide is that it could calculate the Prosperity Rating of the city. It could also be set up to provide the entertainment, education, health, and religion requirements of the Culture Rating. If I was feeling particularly masochistic, I could set it up to calculate the additional goods consumed by the culture structures (scribe schools, mortuaries, senet houses, etc.) depending on the presence of an Oracle of Thoth or Altar of Anubis. Then, of course, one would have to consider if Cleopatra was installed.

If I could get Nero Would interested, I might try it. Don’t hold your breath waiting for it. If we did decide to try set one up, with would take a while to get everything worked out. Maybe we could get Brugle to beta test it for us.

As for Djed djedi’s desire calculator for Pharaoh, check out the thread New city designing tool.

The worksheet will calculate food and goods consumption by houses and culture buildings, taxes, culture rating and prosperity cap (the maximum prosperity rating based on housing levels).

I have renamed your thread so that it will be easier to locate in the future. I hope you don’t mind.

Use this thread for posting comments and/or questions about the Worksheet.

[This message has been edited by VitruviusAIA (edited 03-24-2004 @ 03:03 PM).]

I have corrected the error and submitted the new version to the download section. It should be available in a couple of days, and will be called "Pharaoh Housing and Culture Worksheet v1.1".

My apologies to those who downloaded the original version.

Click Here for a larger image.