Excel tool for block-time calculation

[Settler_Daniel]

You need a Microsoft Excel Version (1997 and higher - 64 bit isn't supported, yet)
Version 2.0 is based on game design. Inside the tool, there are helpful tooltips and help buttons, which will show you a detailed post in this thread. If you have still questions, you can ask in this thread or write to me.

With this tool, you can find out, how long a block have to be. This is calculated in rounds. That means, the tool says you the distans from the block garisons to the block camp, how many rounds they have to fight and in which round the first defeat can be at earliest.

That's for beginners and tactical map writer with expirience a helpful tool.
If ther's a bug or if you have a question you're welcome to write in this thread or to me.

Updates will be as an upgrade version as well, so saved results will be saved still after an update.

Download Instructions (last changes)
Help posts

Change-Logs

CURRENT: Version 2.0- 14. October 2013


New user interface

Design is based on game design
Beginners are able to pile in to the material cause helpful tooltips and help-buttons
Only fields are visible, which you have to fill out.
The language is adjust automatically cause your language of system. (Only GB and DE)
Sounds are added

Changes at calculation

It isn't calculated anymore with win probability.
The needed number of rounds from the locks is calculated instead of the time.
So, you don't give number of rounds for blocks.
The round, where at earliest may occur a defeat is calculated, that's why the win probability isn't needed anymore.
There're 2 inputs for flags, now (up to area of reach and total)

→ The distance from the block-general to his camp is calculated

Other changes

It's possible to save results
Updates will exists in a patch-version, what means that after an update saved results are still saved.
The open-office version won’t exists for a moment. OO has another programming language, so I've to program the tool newly for OO. At first I leave the Microsoft-Version mature.
Old versions of Excel are supported, the download is as *.xlsm (2007 and higher) and as *.xls (97-2003) available.


Download Instructions


Version 1.2.1- 26. May 2013

Features:

OpenOffice: Tick-boxes to choose, if you took cannoneers or not


Bugfixes:

The calculation of travel time is more accurate, now
Text of column "cannoneers" has been improved.


Downloads
Download for Microsoft (https://www.workupload.com/download/UdArk4Y)
Download for OpenOffice (https://www.workupload.com/download/HmtzVDj)
Download with BuildingCosts for Microsoft (https://www.workupload.com/download/z5fOC1g)
Download with BuildingCosts for OpenOffice (https://www.workupload.com/download/pvU3YQw)


Version 1.1.0- 09. May 2013

Features:

Added column "cannoneers", were you can chose, if you take cannoneers or not. (Cannoneers will bisect the camp demolition).
OpenOffice: Added an auto-fill, too. Please notice: there're always English and German and not only the selected Language like in Microsoft.


Downloads
Download for Microsoft (https://www.workupload.com/download/eFh3FKc)
Download for OpenOffice (https://www.workupload.com/download/EYkTRSw)
Download with BuildingCosts for Microsoft (https://www.workupload.com/download/Ws1NcIf)
Download with BuildingCosts for OpenOffice (https://www.workupload.com/download/zRlYbb5)


Version 1.0.0- 05. May 2013

Features:

Table pushed up to 200 Camps
Headlines are fixed (so if you scroll, you'll still see the Headlines)
Added big Headline ("Does your block take long enough? Find it out!")
Added link to this and the german thread (exchanging depending on selected language)


Added several fault indications
• Not possible to add a win probability over 100% or less 0.
• At a value over 100 in "flags" there is a security query
• At a value over 10 in "Rounds" there is a security query


Microsoft: blade guard don't disable several features of Excel anymore:
• cells/columns/rows can be formated now
• cells/columns/rows can be added and removed.
• You're able to edit empty cells now


Microsoft: added an auto-fill for Attack/Block and kind of camp (for example, if you write "ba" in kind of camp, you'll have the whole word "bandit camp" in it.)

Bugfixes:

At Microsoft Excel 2007 the dropdownlists do functioning now
added an English translation for "lahmen nehmen" (=take slow general)

Downloads
Download for Microsoft (https://www.workupload.com/download/gvETeab)
Download for OpenOffice (https://www.workupload.com/download/hgP9tQx)
Download with BuildingCosts for Microsoft (https://www.workupload.com/download/SmjPW9M)
Download with BuildingCosts for OpenOffice (https://www.workupload.com/download/Eh4xpPS)


Version 0.1.2- 30. April 2013
Bugfixes
In the OpenOffice-file the results-columns are only says "kind of camp!", if the information is really missing
Now the first row calculates right
change English-translation of A2

Downloads
Download for Microsoft (https://www.workupload.com/download/4wq4UvY)
Download for OpenOffice (https://www.workupload.com/download/1Z5HPbr)
Download with BuildingCosts for Microsoft (http://www.workupload.com/download/mjYlVq0)
Download with BuildingCosts for OpenOffice (http://www.workupload.com/download/O5oHNYh)


Version 0.1.1- 08. April 2013
first English version

Downloads
Download for Microsoft (http://forum.diesiedleronline.de/attachment.php?attachmentid=11370&d=1365443187)
Download for OpenOffice (http://forum.diesiedleronline.de/attachment.php?attachmentid=11372&d=1365455491)
Download with BuildingCosts for Microsoft (https://www.workupload.com/download/ETOn4fk)
Download with BuildingCosts for OpenOffice (https://www.workupload.com/download/2Jou3g5)



Thanks for using, Daniel

[Settler_Daniel]

Big Update, no Beta anymore (Version 1)
Picture of Version 1:
http://imageshack.us/a/img560/2462/calculaterinaction.png (http://imageshack.us/a/img560/2462/calculaterinaction.png)

New Features:

Table pushed up to 200 Camps


Headlines are fixed (so if you scroll, you'll still see the Headlines)


Added big Headline ("Does your block take long enough? Find it out!")


Added link to this and the german thread (exchanging depending on selected language)


Added several fault indications
• Not possible to add a win probability over 100% or less 0.
• At a value over 100 in "flags" there is a security query
• At a value over 10 in "Rounds" there is a security query


Microsoft: blade guard don't disable several features of Excel anymore:
• cells/columns/rows can be formated now
• cells/columns/rows can be added and removed.
• You're able to edit empty cells now


Microsoft: added an auto-fill for Attack/Block and kind of camp (for example, if you write "ba" in kind of camp, you'll have the whole word "bandit camp" in it.)


Bugfixes:

At Microsoft Excel 2007 the dropdownlists do functioning now


added an English translation for "lahmen nehmen" (=take slow general)

Download block-time calculation 1.0.0.xlsx (Microsoft) (https://www.workupload.com/download/gvETeab)
Download block-time calculation 1.0.0.ods (OpenOffice) (https://www.workupload.com/download/hgP9tQx)

Download block-time calculation 1.0.0 and BuildingCosts 2.2.1.xlsx (Microsoft) (https://www.workupload.com/download/SmjPW9M)
Download block-time calculation 1.0.0 and BuildingCosts 2.2.1.ods (OpenOffice) (https://www.workupload.com/download/Eh4xpPS)

[Settler_Daniel]

New Features:

Added column "cannoneers", were you can chose, if you take cannoneers or not. (Cannoneers will bisect the camp demolition).
OpenOffice: Added an auto-fill, too. Please notice: there're always English and German and not only the selected Language like in Microsoft.


Download block-time calculation 1.1.0.xlsx (Microsoft) (https://www.workupload.com/download/eFh3FKc)
Download block-time calculation 1.1.0.ods (OpenOffice) (https://www.workupload.com/download/EYkTRSw)

Download block-time calculation 1.1.0 and BuildingCosts 2.2.1.xlsx (Microsoft) (https://www.workupload.com/download/Ws1NcIf)
Download block-time calculation 1.1.0 and BuildingCosts 2.2.1.ods (OpenOffice) (https://www.workupload.com/download/zRlYbb5)

[Forester684]

Really really amazing this you have done, thanks a lot, I was thinking in use an excel tool too, and I made one, really simple, but this one is amazing.

[Settler_Daniel]

Really really amazing this you have done, thanks a lot, I was thinking in use an excel tool too, and I made one, really simple, but this one is amazing.
Thanks a lot for your positive feedback :)
Do you have any idea for a new feature, maybe one, which was in your own tool?

[Settler_Daniel]

New Features:

OpenOffice: Tick-boxes to choose, if you took cannoneers or not


Bugfixes:

The calculation of travel time is more accurate, now
Text of column "cannoneers" has been improved.


Download block-time calculation 1.2.1.xlsx (Microsoft) (https://www.workupload.com/download/UdArk4Y)
Download block-time calculation 1.2.1.ods (OpenOffice) (https://www.workupload.com/download/HmtzVDj)

Download block-time calculation 1.2.1 and BuildingCosts 2.3.xlsx (Microsoft) (https://www.workupload.com/download/z5fOC1g)
Download block-time calculation 1.2.1 and BuildingCosts 2.3.ods (OpenOffice) (https://www.workupload.com/download/pvU3YQw)

[Settler_Daniel]

Hello, everyone!
There was for a long time no update, but I've continue programming.
A big new version is comming soon- version 2.0!
It will be based on Excel as well, but it will programmed in the programming language "Visual Basic for Applications" (VBA)
Furthermore, it won't be based on a table, it will have it's own windows ("UserForms").
For every input box there will be a tooltip and for every window there will be a help- button, which will open a corresponding post in this thread.
The Design will be in game design

Here a preview. Please Note, that everything can changed up to final version


http://www.m-i-u.de/images-i68145bewskn.png

You're welcome to give feedback!

Greetings, Daniel

[Settler_Daniel]

The following posts are exsisting:


Download Instructions
choose kind of block
Window "double block"
Input Window
Window "Results" (distance of flags)
Window "Results" (calculated Rounds)

[Settler_Daniel]

Hello everyone!
At first you download one of the following urls (depending on your Excel version)
Download as *.xlsm (Microsoft Excel 2007 - 64 bit isn't supported, yet) (http://www.workupload.com/file/Pr2u6WDT)
Download as *.xls (Microsoft Excel 1997-2003) (http://www.workupload.com/file/3NL0cFRd)

You get a *.zip file. Now you have to unpack it. Click with the right mouse button the zipped file folder and choose "extract all" (can be different, depending on windows version, but there should be something like unpack/extract)
http://www.m-i-u.de/images-i71117b6xtg4.png

Now, you get a file folder with two subdirectories and one Excel file. The subdirectories you can ignore, but don't delete or move them! They have to be in the same file folder like the excel sheet!
http://www.m-i-u.de/images-i71105bk8qds.png

Now, open the excel file. They may be questions, if you want to enable macros. Answer them with "yes" or "enable"
http://www.m-i-u.de/images-i71120bqd6gh.png

If there isn't any question, and they're not enabled, you have to change the settings of excel. Click File → Options → Trust Centre and click "Trust Centre Settings"
http://www.m-i-u.de/thumb-i71122bfrw14.png click to make bigger (http://www.m-i-u.de/images-i71122bfrw14.png)

In the trust centre click "Macro Settings" and choose there "Disable all Macros with notification" (Than you get a question, if you want to enable) or choose "Enable all Macros" (macros will be enable without question).
http://www.m-i-u.de/thumb-i71123bb3zlm.png click to make bigger (http://www.m-i-u.de/images-i71123bb3zlm.png)

And now you can start with calculation :)

[Settler_Daniel]

http://www.m-i-u.de/images-i71000bjt18t.png
simple Block : A simple block means that you only block one camp. If you don’t have much experience with calculate blocks, you should begin with simple blocks. It's important, that the general only would catch from the block camp and not from another camp.
Go on with Input Window

double- block : If you want to calculate a double- block, you should already have some experience with simple blocks.
At a double block, you're blocking 2 camps.
That means your general would catch from two camps on the way to the leader camp. Now, you're going to block both camps, so the fighting general can go to the leader camp without any problems.
If you choose "double-block" this window is opening: Window "double block"

Now, we know if we want to make a simple or double block. Now, we only have to choose in the drop-down-list.

http://www.m-i-u.de/ihsthumb-i71001b7qn93.png

Tip: You can also write a s for simple block or a d for double-block.

[Settler_Daniel]

http://www.m-i-u.de/images-i71003b00i0r.png
Choose the combat preview in the garrison of the block general and click the corresponding camp.

http://www.m-i-u.de/images-i69220brmmp0.png
If there is the framed text at the bottom, the general is cached. If this is cause a camp, which is not blocked, you have to destroy it first.
If the general would catch from the other block-camp, you have to choose in the drop down "would catch from block x". If it isn't choose "would not catch"

http://www.m-i-u.de/images-i71005b7nz2c.png

[Settler_Daniel]

(varies depending on the information required)
http://www.m-i-u.de/images-i71010bid3cg.gif

border-parts

http://www.m-i-u.de/images-i71012bhe4lo.png

information-thread and newest Version :
http://www.m-i-u.de/images-i71013bvf9pw.png
This button is conducting to this thread. Use it frequently, to have always the current version. (An update does not mean, that the saved results are deleted.)


CheckBox "play Sounds":
http://www.m-i-u.de/images-i71014b6zffp.png
Who don't like the sounds, can deactivate them here.
To deactivate the sounds, makes the tool faster.


Safety distance (in flags):
http://www.m-i-u.de/images-i71015b49kgi.png
The attacking general should always have a safety distance to the area of influence from the block-camp. How high the safety distance is, you can give here.
Possible are numbers between 1 and 9.


back-button :
http://www.m-i-u.de/images-i71016bx1xbl.png
If you have chosen a wrong block-type, you can go back here.


calculate block:
http://www.m-i-u.de/images-i71017bmztfa.png
If you have fill out every field, you only have to click this button. If you have forgotten an input, you get a message box, which gives information about the missing inputs.


attack


http://www.m-i-u.de/images-i71018brzrec.png

flags up to area of reach:
http://www.m-i-u.de/images-i71019btvdfd.png
Click the garrison, which is going to attack the leader camp and choose attack or combat preview.
Zoom as wide out as you can see the garrison and the leader camp at the same moment. Move your mouse over the leader camp. Now, count the flags from the garrison to the area of reach from the corresponding block-camp. Insert your result now in the input box.


total flags :
http://www.m-i-u.de/images-i71020bl9m05.png
Count the flags from your attack-garrison to the leader camp (see flags up to area of reach but count to the leader camp and not to a area of reach).


kind of camp:
http://www.m-i-u.de/images-i71021btxu43.png
Here you have to choose the kind of camp, which you're going to attack. The several kinds have difference in the graphic. Here a list with possible leader camps and there graphic. (Click the pictures to make them bigger)


• Bandit Leader Camp: http://www.m-i-u.de/images-i68551bioc9n.png (http://www.m-i-u.de/images-i68550buny60.png)http://www.m-i-u.de/images-i68553b40c7n.png (http://www.m-i-u.de/images-i68552bqdumn.png)http://www.m-i-u.de/images-i68555b6pln3.png (http://www.m-i-u.de/images-i68554bo8yj0.png)http://www.m-i-u.de/images-i68556bso1m2.png (http://www.m-i-u.de/images-i68557bvlt78.png)http://www.m-i-u.de/ihsthumb-i71022bmly4n.png (http://www.m-i-u.de/images-i68558bpw8zc.png)http://www.m-i-u.de/images-i68561b0idro.png (http://www.m-i-u.de/ihsthumb-i71023bv9udm.png)

• White castle: http://www.m-i-u.de/images-i68563bc24an.png (http://www.m-i-u.de/images-i68562bgsxc1.png)

• Witch tower: http://www.m-i-u.de/images-i68565b5cvu7.png (http://www.m-i-u.de/images-i68564bb6c2k.png)

• Bone church: http://www.m-i-u.de/images-i68567bytcr9.png (http://www.m-i-u.de/images-i68566bnbia2.png)

• Dark castle: http://www.m-i-u.de/images-i68569bh3c38.png (http://www.m-i-u.de/images-i68568bace11.png)



general:
http://www.m-i-u.de/images-i71024b4wn0i.png
Here you can choose, if a slow or fast general attacks. Slow generals you've buy in the tavern, fast general you can buy at the shop. A slow general is looking like the followring, the others are fast generals.
http://www.siedlertools.de/w/images/8/89/General.gif


maximum rounds:
http://www.m-i-u.de/images-i71025bf0o4z.png
The attack you've to calculate before. You can use for example the Settlersimulator (http://settlersonlinesimulator.com/dso_kampfsimulator/en/) or the settler online tools simulator (http://www.settlersonlinetools.com/en/combat_simulator/).
If you use the Settlersimulator, click the simulation battle button as often as there is written 2200 simulations. At the settler online tools simulator you should give at the right 10.000 repetitions or more. With the settler online tools simulator you get a more exact result, but the Settlersimulator is for people, who don't want to write a tactical map exact enough.
At the Settlersimulator you use the number, which you can see behind maximal loss in brackets, at the settler online tools simulator you can see the rounds above the table with the losses
surviving cannoneers
http://www.m-i-u.de/images-i71026bgtqd9.png
If you have already cannoneers, you should take at least one in the attack-garrison (the cannoneers have to survive). At the block-garrisons don't take cannoneers!!!


block

http://www.m-i-u.de/images-i71027bf7x98.png

flags up to area of reach from block x:
http://www.m-i-u.de/images-i68583b3h1eo.png
If that isn't show, the input isn't required.
Choose the garrison for the 1st or 2nd block. (Which from both, you can see in the big headline: http://www.m-i-u.de/images-i71029bpoi03.png)
Click this garrison and choose attack or combat preview.
Zoom as wide out as you can see the garrison and the leader camp at the same moment. Move your mouse over the camp, which this general blocks. Now, count the flags from the garrison to the area of reach from the other block camp. Insert your result now in the input box.


kind of camp:
http://www.m-i-u.de/images-i71030b9zkc0.png
Here you have to choose the kind of camp, which you're going to block. The several kinds have difference in the graphic. Here a list with possible block camps and there graphic. (Click the pictures to make them bigger)



• Bandit Camp: http://www.m-i-u.de/images-i68587blty3d.png (http://www.m-i-u.de/images-i68586ba1go1.png) http://www.m-i-u.de/images-i68589b35kjp.png (http://www.m-i-u.de/ihsthumb-i68588beia7k.png) http://www.m-i-u.de/images-i68591b1jgar.png (http://www.m-i-u.de/images-i68590bltrax.png) http://www.m-i-u.de/images-i68593bz8jhl.png (http://www.m-i-u.de/images-i68592bwcp98.png) http://www.m-i-u.de/images-i68595bq1xqn.png (http://www.m-i-u.de/images-i68594b8aecn.png) http://www.m-i-u.de/images-i68617btbmwf.png (http://www.m-i-u.de/images-i68616b0aupg.png) http://www.m-i-u.de/images-i68597bxm4ej.png (http://www.m-i-u.de/images-i68596b8t1r8.png) http://www.m-i-u.de/images-i68599b9ho5f.png (http://www.m-i-u.de/images-i68598blu62c.png) http://www.m-i-u.de/images-i68601b4qurh.png http://www.m-i-u.de/images-i68603b24ttp.png (http://www.m-i-u.de/images-i68600bk3ubb.png) http://www.m-i-u.de/images-i68605b8c6br.png (http://www.m-i-u.de/images-i68604bi0kkr.png) http://www.m-i-u.de/images-i68607bonnko.png (http://www.m-i-u.de/images-i68606b23u7l.png) http://www.m-i-u.de/images-i68609bh2165.png (http://www.m-i-u.de/images-i68608bb6lo7.png) http://www.m-i-u.de/images-i68611b88lcr.png (http://www.m-i-u.de/images-i68610boe6xp.png) http://www.m-i-u.de/images-i68613bx4ery.png (http://www.m-i-u.de/images-i68612ba73yj.png) http://www.m-i-u.de/images-i68615bnat9h.png (http://www.m-i-u.de/images-i68614bdikvo.png)

• Watchtower: http://www.m-i-u.de/images-i68619bw51wn.png (http://www.m-i-u.de/images-i68618b73zhk.png) http://www.m-i-u.de/images-i68621bxu5c8.png (http://www.m-i-u.de/images-i68620b8m7lf.png) http://www.m-i-u.de/images-i68623b5grmb.png (http://www.m-i-u.de/images-i68622bi6p3y.png)

• Reinforced Watchtower: http://www.m-i-u.de/images-i68625b9nb9x.png (http://www.m-i-u.de/images-i68624b9r0ks.png) http://www.m-i-u.de/images-i68627bae3cf.png (http://www.m-i-u.de/images-i68626beox8b.png) http://www.m-i-u.de/images-i68629b4ulyx.png (http://www.m-i-u.de/images-i68628bvsvj5.png)

• Stone tower: http://www.m-i-u.de/images-i68631bbq91s.png (http://www.m-i-u.de/images-i68630b59i4a.png) http://www.m-i-u.de/images-i68633bwbwso.png (http://www.m-i-u.de/images-i68632b56zl7.png) http://www.m-i-u.de/images-i68635b20a93.png (http://www.m-i-u.de/images-i68634ba2xpa.png)

[Settler_Daniel]

http://www.m-i-u.de/images-i71094btiafa.png

Click your block-general and choose attack or combat preview. Zoom as wide out as you can see the garrison and the leader camp at the same moment and move your mouse towards the block-camp. Now, count the flags. If you've at the example of 19 flags a distance of 19 flags, everything is good. If it isn't you have to transfer your garrisons. (If you've more than 19, you have to transfer the garrisons, too. If you want to have a higher safety distance, you can change it in the input box at the top left side.)
If we have for example a distance of 15, we transfer the garrison 4 flags backwards. Now we count again, because it could be, that the general have another route than we thought.
Alternative we can transfer the attack-garrison forwards. If the transferring don't work, we can wait up to the attack general has walk 4 flags and then we can start the other general.
It could be, that the flag-inputs we've done are wrong, because of the transferring of the generals. To change the inputs, we click "back" at the bottom left.

[Settler_Daniel]

http://www.m-i-u.de/images-i71036b3ivk8.gif

The results belong always to the tab on the bottom, which is chosen (at the picture e.g. the first block). If there aren't tabs, you've calculated a simple block and at a simple block there is only one block.
http://www.m-i-u.de/images-i71047bz6bcc.png

The description from the 1st part of the result ("Your general of block have to have a distance of x flags") you can find at [ResultBoxFlags].

"Your general of block have to fight at least x Rounds. The first defeat may occur at earliest in Round y."
Now, we have to find a simulation, which is complying with the result. Now, we try that with an example.

Your general of block has to fight at least 5 Rounds. The first defeat may occur at earliest in Round 7.

Description with using the Settlersimulator (recommended for average consumer)

http://www.m-i-u.de/images-i71059bkm7y9.png
For us there are only the lines in they picture above relevant. The simulations should be at 2.200. If it is, click at the framed area. You will see a picture like that:
http://www.m-i-u.de/images-i69234bubby8.png
Below the bars, you can see the numbers of rounds. Here it begins with 5 and ends with 13. The block-time-calculator has said us that the general have to fight at least 5 rounds. That's true, because the bar chat begins with 5. More is always better, so it would be better, if the minimum rounds were 6 or even more, but 5 rounds are enough.
The block time calculator has said us that the first defeat may occur at earliest after 7 rounds. At the bottom are the numbers of rounds. Above them are bars. Above the bars are numbers.
The blue bar refers to the victories, which were of all simulations in that round. The number above is the exact number of simulations.
The red bar is referring to the defeats.

At round 5, there isn't any bar, but there are the numbers 0 and 1. 0 is at the left side, where is normally the blue bar and the 1 is on the right side, where is normally the red bar. That means that already in round 5 one simulation was a defeat. But the first defeat has to come at earliest in round 7.
So, we have to simulate different. To rise up the win probably we take more units.

http://www.m-i-u.de/images-i69239biyuy1.png
A few simulations later, we have the result above. As you can see, the minimum rounds are also 5. At round 5 and 6 we have 0 defeats. First in round 7 there were 3 defeats. The block-time-calculator has said as well, that the first defeat may occur at earliest in round 7. This condition is true, now as well. This simulation is good and we can take the units.


Description with using the settler online tools simulator (recommended for tactical map writer)

At first we should take a high repetition. Minimum is 10.000 I recommend 99,999 (maximum input)
http://www.m-i-u.de/images-i71069b6u587.png

Now, we have to scroll at the button. Under the table, we click "rounds"
http://www.m-i-u.de/images-i71070brsfgg.png

http://www.m-i-u.de/images-i71072bragtj.png
The numbers at the bottom are the rounds. It begins at round 5 and it ends at round 13. So, the attack is taking minimum 5 rounds. The block-time-calculator has said us that the general have to fight at least 5 rounds. That's true, because the bar chat begins with 5. More is always better, so it would be better, if the minimum rounds were 6 or even more, but 5 rounds are enough.
For use, only the red graph is relevant, because it shows the defeats of the rounds. If we move the mouse above it, we see the exact number of defeats of the round below. We begin with round 5.

http://www.m-i-u.de/images-i71073b2npp2.png
At the defeat-tooltip the first number is a 5. That means only, that this is round 5. Below the 5 is a 14. That means that 14 of 99,999 simulations didn't come over round 5! But we want to come to round 7!
So, we have to simulate different. To rise up the win probably we take more units.

http://www.m-i-u.de/images-i71076budq2l.png
A few simulations later, we have the graphic above. As you can see, the red graph is everywhere at the bottom. To go sure, we look at the tooltips.

http://www.m-i-u.de/images-i71077b4coiu.png
At the tooltip from round 5 and 6, there is a 0. At round 7 we have 3 defeats. So, we're finish!

[Settler_Daniel]

Hello, everyone!
Version 2.0 is finished

New user interface

Design is based on game design
Beginners are able to pile in to the material cause helpful tooltips and help-buttons
Only fields are visible, which you have to fill out.
The language is adjust automatically cause your language of system. (Only GB and DE)
Sounds are added

Changes at calculation

It isn't calculated anymore with win probability.
The needed number of rounds from the locks is calculated instead of the time.
So, you don't give number of rounds for blocks.
The round, where at earliest may occur a defeat is calculated, that's why the win probability isn't needed anymore.
There're 2 inputs for flags, now (up to area of reach and total)

→ The distance from the block-general to his camp is calculated

Other changes

It's possible to save results
Updates will exists in a patch-version, what means that after an update saved results are still saved.
The open-office version won’t exists for a moment. OO has another programming language, so I've to program the tool newly for OO. At first I leave the Microsoft-Version mature.
Old versions of Excel are supported, the download is as *.xlsm (2007 and higher) and as *.xls (97-2003) available.



Download Instructions

[Fexno]

Hi Settler_Daniel,

Your posts have been hidden till they can be approved by bb.
I would kindly ask you to send a private message to BB_alpaca and ask for permission of posting these links.

[ Thread closed ]

Thanks,
Fexno

[Fexno]

These links have now been approved.

Please note that this only means they can be posted on the forum. Blocking is done on your own risk and not a supported feature

[ Thread reopened ]

Cheers,
Fexno

[Settler_Daniel]

Hello everyone,

Of course, I'm continuing develop the tool. At moment I haven't much time for tso… So the following preview can take a while for an official update.

New Window "Settings"
The Design of this window isn't final; it's just a first preview
http://www.m-i-u.de/images-i73738brt1m6.png
Instead of the "play Sounds"- check box, there will be a button for Settings.
There will be new options like show tooltips / mouse over. You will be able to decide, what happen if you press the "X" at top right. If you've chosen the second option, you will have a message box, where you can decide how to be continued (for every window there will be several options).


http://www.m-i-u.de/images-i73733bqc5mt.png http://www.m-i-u.de/images-i73734b4nbba.png

News for saving
http://www.m-i-u.de/images-i73736bpafmr.png


name
Until now, there is a max length of 10 for a block-name. This will be increase to 30. A too long name will be shorten by the tool. The whole name, you'll see in a tooltip at the list of saved results.

delete-feature
There will be a possibility to delete saved results. Therefore you'll have a little cross at the right side for every save

http://www.m-i-u.de/images-i73737b1p3ld.png

http://www.m-i-u.de/images-i73735bd9wa2.png

The OpenOffice version won't be finished next time :(

Please give me some Feedback!

Greetings
Settler_Daniel

[Cheetahke]

@ Settler_Daniel,

If you need help for making this tool for 64-bit version, just let me know :D

Greetings

Cheetahke

[nemothechemo]

really like your work.

[Settler_Daniel]

@ Settler_Daniel,

If you need help for making this tool for 64-bit version, just let me know :D

Greetings

Cheetahke

Thanks for your offer - maybe you can test it for me later…


really like your work.

Thank you :)