[Tool] What's your Most Profitable Building?
Alright, made this little calculator initially for myself as I really like the trading game in Settlers Online. It's purpose was to identify which buildings gave me the most profit in terms of gold coins when its goods was sold on the TT. This way I could put my excess building licences to good use by building the Most Profitable Buildings! The results was really an eye-opener to me as to how bad the highlevel buildings actually are in terms of profit. Yes, Supply and Demand dictates the marketprice, but looking at the cost of buildings and input materials, the market is way off at the moment for some buildings. Maybe this tool can help stabilize the economy by pointing at prices goods should actually be at? I doubt it, but I still like the thought ;)
The calculations are made by assuming the best production time possible in seconds. That is, shortest travel time to warehouse/workyard. It uses the marketprice of the input goods and determines the daily output according to production cycles and buffs used. It then multiplies the output goods with the marketprice The result is GPD (Gold Production per Day) in 3 different versions. Unbuffed, Buffed 50% of the time and Buffed 100%
Have a look at the spreadsheet which is locked in it's web version, but you can change the marketprices to your likings when downloaded. It's made in OpenOffice Calc, so it could look weird when opened in Excel and what not. I'll update the prices occasionally in the locked webversion, but you should really download the editable version and try to change prices to reflect better results for you.
Note that I'm no expert in spreadsheets or hosting them, but this is a good exercise for me to do so. It's very unpolished, but I'll try to shine and tidy it for a more pleasant view in the future. Calculations may be wrong somewhere, so please let me know if something seems terribly wrong. I've hidden the formulas for the public, and locked the sheet (atleast i think i did, else let me know asap). Suggestions for improvements VERY welcome!
MBP Beta v2
Plans for the future:- Add a thorugh userguide!
- Make marketvalues editable in webversion (if possible)
- Profit per Buff (it's in the hidden columns actually, but needs some tweaking)
- Time to Profit (how long until your building upgrade pays itself off)
- Automatically set default marketprices
- Cooler interface
- Suggestions?
Like this tool? A thank you here, in whisper or mail much appreciated. Donations even moreso (noblets, parrots or flowerbeds always welcome ^^)
