In Civ 3, I would look at a tile, and instantly know its potential FPC values for almost every possible in-game effect that could modify its values for better or worse. The numbers were just there in my head the instant I looked at a tile.
Now we have Civ 4, I haven’t got the first idea what FPC a tile could be generating in 50 turns, 2 civics, an improvement and a couple of techs time from now. It takes me 5 minutes to find reference and think through all the options.
I want Point > Click > Answer, for any possible terrain, feature, resource or improvement, or for any legal combination of the four. That’s why I made a start on it.
Notes:
1 - This is for finding out the potential FPC values of a particular terrain tile, it is not for finding out whether a certain resource or improvement can be located on a certain base terrain type or terrain feature.
What that means is: if you want to see how much commerce a tile generates having Gold with a Mine located on an Ocean tile, go ahead, the spreadsheet will (probably) let you calculate that. You’ll never actually work that tile in a game of course.
So to use the spreadsheet, it helps to know what tiles resources can appear on. This is only a problem if you are making up a tile yourself. If you are looking at a tile in the game and enter the relevant resource info for that tile, you shouldn’t have trouble.
2 - This will likely contain errors. It hasn’t had a thorough testing. If anyone spots an incorrect value being used for something or spurious results, please let me know.
3 – The fold out poster thing you get with the game was used as the source data for the entire spreadsheet. If there are any errors on there, they will be in the spreadsheet.
4 – While I am no noob on previous Civs, Ive only played through about five Civ 4 games, and am therefore no expert on many things. As far as I know this spreadsheet could contain some alarmingly embarrassing gaps, resulting in entire aspects of the game that have an effect on the FPC values being omitted or being incorrect. Please let me know if there is anything missing.
5 – It was written using Excel 2003 SP1, I don’t know if it works with earlier versions.
6 - The only Improvement formula that isnt doen yet is Farms. I appreciate farms are prettu important to the food thing, but Food also the only improvement that improves by differing amounts both a base terrain tile without resource and an improved resource tile. I couldnt get it working at 1st try but will do in a day or two.
Now we have Civ 4, I haven’t got the first idea what FPC a tile could be generating in 50 turns, 2 civics, an improvement and a couple of techs time from now. It takes me 5 minutes to find reference and think through all the options.
I want Point > Click > Answer, for any possible terrain, feature, resource or improvement, or for any legal combination of the four. That’s why I made a start on it.
Notes:
1 - This is for finding out the potential FPC values of a particular terrain tile, it is not for finding out whether a certain resource or improvement can be located on a certain base terrain type or terrain feature.
What that means is: if you want to see how much commerce a tile generates having Gold with a Mine located on an Ocean tile, go ahead, the spreadsheet will (probably) let you calculate that. You’ll never actually work that tile in a game of course.
So to use the spreadsheet, it helps to know what tiles resources can appear on. This is only a problem if you are making up a tile yourself. If you are looking at a tile in the game and enter the relevant resource info for that tile, you shouldn’t have trouble.
2 - This will likely contain errors. It hasn’t had a thorough testing. If anyone spots an incorrect value being used for something or spurious results, please let me know.
3 – The fold out poster thing you get with the game was used as the source data for the entire spreadsheet. If there are any errors on there, they will be in the spreadsheet.
4 – While I am no noob on previous Civs, Ive only played through about five Civ 4 games, and am therefore no expert on many things. As far as I know this spreadsheet could contain some alarmingly embarrassing gaps, resulting in entire aspects of the game that have an effect on the FPC values being omitted or being incorrect. Please let me know if there is anything missing.
5 – It was written using Excel 2003 SP1, I don’t know if it works with earlier versions.
6 - The only Improvement formula that isnt doen yet is Farms. I appreciate farms are prettu important to the food thing, but Food also the only improvement that improves by differing amounts both a base terrain tile without resource and an improved resource tile. I couldnt get it working at 1st try but will do in a day or two.
