Hey there!
Please check THIS LINK for some pertinent info about next weeks Event: Halloween!
As you may all know the info in the Settlers Online Wiki may not be 100% accurate as we will only know when it hits us... still, it's a great heads up!
One thing I wanted to point out:
When you look at the bottom of the Settlers Online Wiki page for Halloween 2013, you'll see that, in order to defeat the First Golem Heart (Caramel colour) you can ONLY use Marbles.
BUT, when you start defeating the Second Golem Heart (Purple colour) you can use BOTH Marbles and Ropes.
DO NOTICE that Marbles will give you LESS hit points damage and, as such, I would advise you NOT TO USE Marbles for the Second Golem Heart.
And same applies to the Third Golem Heart (Violet colour). Even though you can use both Marbles and Ropes on it too, the COST EFFECTIVE option is to simply build Buckets of Water as they are the cheapest of all three buffs.
If you stick to the most effective buffs for each Golem Heart you will effectively save much needed resources - which will not only save you coin but enable you to potentially defeat more Golems. Remember: it is likely that during this event the prices of Marble, Wheat and Water will be at a premium... so try to be as efficient as you can, IF you want to play this event in its entirety.
I will also update the Provision House Calc Tool so that it now includes the times and costs for producing all these special events buffs.
This way you will be able to know beforehand how tied up your Provision House will be making all these things, pretty much non-stop...
For the time being... CLICK HERE to see how long this event may take up on our Provision Houses...
Happy Settlering!
Showing posts with label calc tool. Show all posts
Showing posts with label calc tool. Show all posts
Saturday, 12 October 2013
Provision House Calc Tool
Hello everyone,
Ever since the Troop Calc Tool came about that I thought of doing a similar thing for the Provision House.
Sometimes I need to build stuff, don't know how long it will take, or how many resources will it require - nor do I know if it's actually worthwhile selling or converting it.
Well, this is the tool to answer all those questions. Just make a copy of the file for your personal use and you're set...
Click for the PROVISION HOUSE CALC TOOL.
As always the green cells are the ones you can tinker with. All others are supposed to be left alone... but, of course, feel free to mod the file according to your own specifications. If you come up with some ideas that you think would be good to add, do let me know and I will try to include them here so that others may benefit also.
INSTRUCTIONS:
1 - Fill out the PROVISION HOUSE LEVEL cell.
2 - You do not need to use the AVAILABLE column. Here you are simply supposed to fill in what you already have in stock.
3 - Please enter in the ORDERS NEEDED column how much you want of every item. Bear in mind when it comes to Deposits, it's the number of buffs you will be producing - not how much deposit you will get in the end (that's shown in QUANTITY column)
4 - Fill in the PRICES columns at the bottom. You can use the NEWFOUNDLAND TRADE SHEETS if you wish to find a rough approximation of said prices.
NOTE: for Fishfood and Musk Deer Fragrance Deposits simply enter the cost of 2500 deposit of each (a bundle of 25 buffs) - the tool will then calc the rest (on the brown cell next to these prices is the calculated price per buff ;) )
After you have done this you will have all the calculations done for you.
A few features you may want to have a look at:
1 - There are two columns, one in BLUE, another in PURPLE. The BLUE one gives you how much it costs to build the various things. The PURPLE one how much you would get if you were to sell them on TO (providing you have filled out all the prices correctly...)
2 - Further down you will see two BLUE cells and a RED one. These will give the total cost(minus Settlers and Balloons - which you cannot sell on TO) to BUILD and the total sales value if you were to sell the stuff you've just created on TO. The RED cell gives you the difference between one and the other.
Do not that the only things worthwhile selling seem to be (possibly) BUFFS and DEPOSITS. All the CONVERSION stuff seems to be running at a loss (often drastically so...).
3 - You can see the TOTAL PRODUCTION COSTS, side by side with how many ORDERS you are about to place and the TIME it would take to build all that (for this it is very important you place the correct Provision House Level!)
4 - On a BLUE row you can see the costs in resources used, distributed by resource type. So, if you're building Solid Sandwiches and Aunt Irma's Baskets and some Retired Bandits all in big clump you can see how much BREAD you're going to use - and how much that's worth in gold coins.
That's it! If you spot any incorrections, please do let me know so that I can fix them!
I hope this will be useful to you! Enjoy!
Ever since the Troop Calc Tool came about that I thought of doing a similar thing for the Provision House.
Sometimes I need to build stuff, don't know how long it will take, or how many resources will it require - nor do I know if it's actually worthwhile selling or converting it.
Well, this is the tool to answer all those questions. Just make a copy of the file for your personal use and you're set...
Click for the PROVISION HOUSE CALC TOOL.
As always the green cells are the ones you can tinker with. All others are supposed to be left alone... but, of course, feel free to mod the file according to your own specifications. If you come up with some ideas that you think would be good to add, do let me know and I will try to include them here so that others may benefit also.
INSTRUCTIONS:
1 - Fill out the PROVISION HOUSE LEVEL cell.
2 - You do not need to use the AVAILABLE column. Here you are simply supposed to fill in what you already have in stock.
3 - Please enter in the ORDERS NEEDED column how much you want of every item. Bear in mind when it comes to Deposits, it's the number of buffs you will be producing - not how much deposit you will get in the end (that's shown in QUANTITY column)
4 - Fill in the PRICES columns at the bottom. You can use the NEWFOUNDLAND TRADE SHEETS if you wish to find a rough approximation of said prices.
NOTE: for Fishfood and Musk Deer Fragrance Deposits simply enter the cost of 2500 deposit of each (a bundle of 25 buffs) - the tool will then calc the rest (on the brown cell next to these prices is the calculated price per buff ;) )
After you have done this you will have all the calculations done for you.
A few features you may want to have a look at:
1 - There are two columns, one in BLUE, another in PURPLE. The BLUE one gives you how much it costs to build the various things. The PURPLE one how much you would get if you were to sell them on TO (providing you have filled out all the prices correctly...)
2 - Further down you will see two BLUE cells and a RED one. These will give the total cost(minus Settlers and Balloons - which you cannot sell on TO) to BUILD and the total sales value if you were to sell the stuff you've just created on TO. The RED cell gives you the difference between one and the other.
Do not that the only things worthwhile selling seem to be (possibly) BUFFS and DEPOSITS. All the CONVERSION stuff seems to be running at a loss (often drastically so...).
3 - You can see the TOTAL PRODUCTION COSTS, side by side with how many ORDERS you are about to place and the TIME it would take to build all that (for this it is very important you place the correct Provision House Level!)
4 - On a BLUE row you can see the costs in resources used, distributed by resource type. So, if you're building Solid Sandwiches and Aunt Irma's Baskets and some Retired Bandits all in big clump you can see how much BREAD you're going to use - and how much that's worth in gold coins.
That's it! If you spot any incorrections, please do let me know so that I can fix them!
I hope this will be useful to you! Enjoy!
Monday, 7 October 2013
Troop Costs Calc Tool
Hello everyone,
I had done a version of this quite some time ago - but it was on an excell spreadsheet and I don't think a lot of people found it convenient precisely because of that. As such, I have done a google docs version.
Click for TROOP COSTS CALC TOOL.
The idea is that you input resource prices (for bread, brew, swords, etc), as well as the troops you may already have built and the troops you need for whatever adventure you may be on the verge of embarking.
After having done so, the tool calculates the amounts of resources needed, the costs for each individual resource and, of course, the total cost.
This is perhaps something you may want to consider using if you're trying to decide between setups to attack a given camp - or selecting a single guide for a given adventure from several possibilities.
As always I think it is always best to check prices on the Trade Office but, if you want the quick version... you can find the Newfoundland Trade Sheets HERE.
EXTRA:
I have decided to add Barracks Building Time to the Troop Costs Calc Tool. This way, you simply need to introduce your Barracks level and you will find how much time it will take for you to have your troops ready (unbuffed, of course).
If you find adding buffing and corresponding time changes to Barracks building time is important, do let me know and I will try and add this to the spreadsheet. ;
Hopefully this will help all of us that need to keep building troops while the adventure is taking place. This will allow for better planning in conjunction with the guide!
Hope this helps!
Happy adventuring!
I had done a version of this quite some time ago - but it was on an excell spreadsheet and I don't think a lot of people found it convenient precisely because of that. As such, I have done a google docs version.
Click for TROOP COSTS CALC TOOL.
The idea is that you input resource prices (for bread, brew, swords, etc), as well as the troops you may already have built and the troops you need for whatever adventure you may be on the verge of embarking.
After having done so, the tool calculates the amounts of resources needed, the costs for each individual resource and, of course, the total cost.
This is perhaps something you may want to consider using if you're trying to decide between setups to attack a given camp - or selecting a single guide for a given adventure from several possibilities.
As always I think it is always best to check prices on the Trade Office but, if you want the quick version... you can find the Newfoundland Trade Sheets HERE.
EXTRA:
I have decided to add Barracks Building Time to the Troop Costs Calc Tool. This way, you simply need to introduce your Barracks level and you will find how much time it will take for you to have your troops ready (unbuffed, of course).
If you find adding buffing and corresponding time changes to Barracks building time is important, do let me know and I will try and add this to the spreadsheet. ;
Hopefully this will help all of us that need to keep building troops while the adventure is taking place. This will allow for better planning in conjunction with the guide!
Hope this helps!
Happy adventuring!
Sunday, 6 October 2013
Collectibles Prices And Buffs Calc Tool
Hello everyone,
Since we have new resources in place and since we can not only trade them but also build buffs with them - and then trade that - I decided to make a simple calc tool for us to know what is most profitable: to sell the resources directly? Or to sell the buffs?
Click on Collectibles Prices And Buffs Calc Tool.
If this spreadsheet is working correctly you will be able to enter and change the Market Prices for the various Buffs and Collectibles and see in the end what makes you profit the most.
I have also added the option for you to simply enter all of the Collectible quantities you may have in store and find out roughly how much is worth.
Do bear in mind that the prices are Per Collectible Unit. If you are selling in bulk the price per unit is likely to drop - so take that into account when calculating the corresponding Buff Price. ;)
All prices are, of course, in Gold Coins.
The cells in green are the ones you can edit. All others are locked (hopefully!)
Hope this proves useful to you!
Since we have new resources in place and since we can not only trade them but also build buffs with them - and then trade that - I decided to make a simple calc tool for us to know what is most profitable: to sell the resources directly? Or to sell the buffs?
Click on Collectibles Prices And Buffs Calc Tool.
If this spreadsheet is working correctly you will be able to enter and change the Market Prices for the various Buffs and Collectibles and see in the end what makes you profit the most.
I have also added the option for you to simply enter all of the Collectible quantities you may have in store and find out roughly how much is worth.
Do bear in mind that the prices are Per Collectible Unit. If you are selling in bulk the price per unit is likely to drop - so take that into account when calculating the corresponding Buff Price. ;)
All prices are, of course, in Gold Coins.
The cells in green are the ones you can edit. All others are locked (hopefully!)
Hope this proves useful to you!
Subscribe to:
Posts (Atom)