Edit: The spreadsheet is located at the bottom of the post.
Spreadsheet usage:
1. Enter the current efficiency and other modifiers in J3~J7.
2. O3~O4 is used to enable manufactory and set trade good value.
3. RoI is given for base/advanced building [from scratch]. The 3rd RoI is if the base already exists.
* Values include: autonomy, build cost [with inflation], tax/production/trade efficiency, node trade control [for manufactories].
Original post below:
I'm sure many users are familiar with the following link: http://imgur.com/a/jBG5y
I myself found it rather useful even if some of the calculations were a bit off - using the full tax income instead of building profit only. Since I had a bit of time I decided to do some calculations myself.
Table/Graph explained:
1. Basic info and regular assumptions to ease calculations: autonomy 0%, tax/production/trade efficiency 100%, node control 25% [may be changed].
2. The first 2 sections [blue/orange] show how much years it would take for the building in question to return the investment and start making a profit - if building from scratch.
3. The 3rd section [yellow] shows how much years it would take for an upgrade to return the investment. Note that this shows less lucrative numbers since the comparison is done to income that includes the base building which is already present - and may have been for quite some time.
4. The upgrade ROI has a second meaning as well - it shows after how many years would the advanced building generate more profit than the basic building.
5. Trade is taken into account only with manufactories [percentage can be changed].
Initial findings
1. When choosing between a temple or workshop [disregarding "combo" with manufactury], a temple is the better choice for most provinces. A workshop is equal only on trade value 4.0 and superior only after upgrading the base building.
2. A combo of manufactury+production building is superior to a standalone manufactury due to the combo reducing ROI time by 20% [in state provinces].
Spreadsheet
This is the current version of the spreadsheet if anyone would like to tinker with it themselves. While not finished - or even refined enough - it should have its uses.
To use enter desired values [or leave at default] in the cells colored pale-orange [or/and yellow] - note that blue cells are just for info. Values include: autonomy, build cost [with inflation], tax/production/trade efficiency, node trade control [for manufactories].
If you spot a mistake or if I missed something do let me know. Obviously, if someone already did this a link would be appreciated.
Spreadsheet usage:
1. Enter the current efficiency and other modifiers in J3~J7.
2. O3~O4 is used to enable manufactory and set trade good value.
3. RoI is given for base/advanced building [from scratch]. The 3rd RoI is if the base already exists.
* Values include: autonomy, build cost [with inflation], tax/production/trade efficiency, node trade control [for manufactories].
Original post below:
I'm sure many users are familiar with the following link: http://imgur.com/a/jBG5y
I myself found it rather useful even if some of the calculations were a bit off - using the full tax income instead of building profit only. Since I had a bit of time I decided to do some calculations myself.
Table/Graph explained:
1. Basic info and regular assumptions to ease calculations: autonomy 0%, tax/production/trade efficiency 100%, node control 25% [may be changed].
2. The first 2 sections [blue/orange] show how much years it would take for the building in question to return the investment and start making a profit - if building from scratch.
3. The 3rd section [yellow] shows how much years it would take for an upgrade to return the investment. Note that this shows less lucrative numbers since the comparison is done to income that includes the base building which is already present - and may have been for quite some time.
4. The upgrade ROI has a second meaning as well - it shows after how many years would the advanced building generate more profit than the basic building.
5. Trade is taken into account only with manufactories [percentage can be changed].
Initial findings
1. When choosing between a temple or workshop [disregarding "combo" with manufactury], a temple is the better choice for most provinces. A workshop is equal only on trade value 4.0 and superior only after upgrading the base building.
2. A combo of manufactury+production building is superior to a standalone manufactury due to the combo reducing ROI time by 20% [in state provinces].
Spreadsheet
This is the current version of the spreadsheet if anyone would like to tinker with it themselves. While not finished - or even refined enough - it should have its uses.
To use enter desired values [or leave at default] in the cells colored pale-orange [or/and yellow] - note that blue cells are just for info. Values include: autonomy, build cost [with inflation], tax/production/trade efficiency, node trade control [for manufactories].
If you spot a mistake or if I missed something do let me know. Obviously, if someone already did this a link would be appreciated.
Attachments
Last edited:
- 1