Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 21

Thread: Excel tool for block-time calculation

  1. #1
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland

    Excel tool for block-time calculation 2.0

    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
    Spoiler

    CURRENT: Version 2.0- 14. October 2013
    Spoiler
    • 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
    Spoiler

    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
    Download for OpenOffice
    Download with BuildingCosts for Microsoft
    Download with BuildingCosts for OpenOffice


    Version 1.1.0- 09. May 2013
    Spoiler

    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
    Download for OpenOffice
    Download with BuildingCosts for Microsoft
    Download with BuildingCosts for OpenOffice


    Version 1.0.0- 05. May 2013
    Spoiler

    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
    Download for OpenOffice
    Download with BuildingCosts for Microsoft
    Download with BuildingCosts for OpenOffice


    Version 0.1.2- 30. April 2013
    Spoiler
    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
    Download for OpenOffice
    Download with BuildingCosts for Microsoft
    Download with BuildingCosts for OpenOffice


    Version 0.1.1- 08. April 2013



    Thanks for using, Daniel
    Last edited by Settler_Daniel; 16.10.13 at 21:10. Reason: Version 2.0

  2. #2
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland

    UPDATE Version 1.0.0

    Big Update, no Beta anymore (Version 1)
    Picture of Version 1:


    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)
    Download block-time calculation 1.0.0.ods (OpenOffice)


    Download block-time calculation 1.0.0 and BuildingCosts 2.2.1.xlsx (Microsoft)
    Download block-time calculation 1.0.0 and BuildingCosts 2.2.1.ods (OpenOffice)
    Last edited by Settler_Daniel; 09.05.13 at 21:41.

  3. #3
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland

    UPDATE Version 1.1.0

    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)
    Download block-time calculation 1.1.0.ods (OpenOffice)


    Download block-time calculation 1.1.0 and BuildingCosts 2.2.1.xlsx (Microsoft)
    Download block-time calculation 1.1.0 and BuildingCosts 2.2.1.ods (OpenOffice)
    Last edited by Settler_Daniel; 09.05.13 at 21:49.

  4. #4
    Original Serf
    Join Date
    Oct 2012
    Posts
    23
    World
    Newfoundland
    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.

  5. #5
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland
    Quote Originally Posted by Forester684 View Post
    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?
    Last edited by Settler_Daniel; 13.05.13 at 16:44.

  6. #6
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland

    UPDATE Version 1.2.1

    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)
    Download block-time calculation 1.2.1.ods (OpenOffice)


    Download block-time calculation 1.2.1 and BuildingCosts 2.3.xlsx (Microsoft)
    Download block-time calculation 1.2.1 and BuildingCosts 2.3.ods (OpenOffice)
    Last edited by Settler_Daniel; 27.05.13 at 14:08.

  7. #7
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland

    Preview Version 2.0

    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


    You're welcome to give feedback!

    Greetings, Daniel
    Last edited by Settler_Daniel; 04.08.13 at 12:44.

  8. #8
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland
    Last edited by Settler_Daniel; 14.10.13 at 13:14.

  9. #9
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland

    Download Instructions

    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)
    Download as *.xls (Microsoft Excel 1997-2003)

    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)


    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!


    Now, open the excel file. They may be questions, if you want to enable macros. Answer them with "yes" or "enable"


    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"
    click to make bigger

    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).
    click to make bigger

    And now you can start with calculation
    Last edited by Settler_Daniel; 16.10.13 at 11:23.

  10. #10
    Original Serf Settler_Daniel's Avatar
    Join Date
    Apr 2013
    Posts
    16
    World
    Newfoundland

    Help: choose kind of block

    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.

    Tip: You can also write a s for simple block or a d for double-block.
    Last edited by Settler_Daniel; 14.10.13 at 13:20.

Reply to Thread

Similar Threads

  1. [Info] Block&time
    By NightEye in forum Game Guides
    Replies: 8
    Last Post: 11.07.14, 13:36
  2. Weird Calculation..
    By AmySafeunderdark in forum Bugs & Technical Issues
    Replies: 5
    Last Post: 26.09.13, 08:44
  3. Incorrect trade calculation: carriages
    By Tripi in forum Bugs & Technical Issues
    Replies: 4
    Last Post: 11.06.13, 10:03
  4. production calculation
    By osman-pasa in forum Game Suggestions
    Replies: 1
    Last Post: 14.02.12, 16:49
  5. Excel Spreadsheet with tools for settlers online
    By Arnatos in forum Game Guides
    Replies: 2
    Last Post: 01.02.12, 07:16

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Ubisoft uses cookies to ensure that you get the best experience on our websites. By continuing to use this site you agree to accept these cookies. More info on our privacy.