Well i keep picking up new projects but this one has already had a lot of grunt work done on it. If you have paid any attention to my personal blog you will know that I am playing a game called Ikariam. Its interface is not that great and its hard to know whats going on with all your cities and calculate for the future etc. So I designed this spreedsheet as I do with many aspects of my life. It started out simple but I ran into many problems so I started learning a little Visual Basic and soon it became a full fledged project.

You set the start date and put in the current satisfaction, population, and resources for three towns. Then you set the Population Capacity and your on your way. Set up the number of people you have on each resource and then hit update. Your spread sheet will track over time things that change and can give you estimates on future date by using the simulation date. Set the simulation date to some future time and and hit Simulation update and it will tell you your resources and population at that time. Hit the regular old update and it will go back to normal.

Next step is to add Building information which I started with Academy. Also there is a transaction place where you put transfers and imports to your various cities. You can also put what you spent on buildings there too and it will be factored into your totals. Building decrease is the percentage the building requirements are dropped.

As far as gold and researchers that has not been finished but since thats the most straight forward thing I will leave that to last. Buildings is a really big pain and it would be great to see what I need for resources for each building and what level each building in my town is. Thats the next step but also the hardest. If you want to look at the excel sheet go download it in my downloads section. I promise new updates on that as time goes by.