Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 21
  1. #1
    Player
    StouterTaru's Avatar
    Join Date
    Sep 2013
    Posts
    2,924
    Character
    Stouter Taru
    World
    Exodus
    Main Class
    Thaumaturge Lv 70

    Max Level Submersible Planner

    Submersible route planner (Excel)
    Submersible route planner (html)

    Airship route planner (Excel)
    Airship route planner (html)

    Excel spreadsheet:
    • 1st Sheet (Path) - Requires download and enabling macros to be useful. You select up to 5 destinations, and it shows you the shortest range needed.
    • 2nd Sheet (Builds) - Every possible build, filterable and sortable. Click the filter and sort in the header row to filter out builds that don't have enough range for your route, and sort speed or surveillance from high to low. Will show a voyage time for the route selected on the Path sheet.
    • 3rd Sheet (Parts) - The various sub parts, there for formulas. You can use the "Include" column to remove parts you don't have from the possible builds on the Builds sheet.

    html built with Notepad for Chrome by someone with basic web page skills, might not work properly on other browsers.

    Leave questions, comments, or suggestions here.
    (3)
    Last edited by StouterTaru; 10-10-2018 at 03:17 AM.

  2. #2
    Player
    AlexanderBlackiris's Avatar
    Join Date
    May 2015
    Posts
    6
    Character
    Vitae Midwinter
    World
    Famfrit
    Main Class
    Arcanist Lv 70
    This is a really great spreadsheet! Thank You!
    (0)

  3. #3
    Player
    StouterTaru's Avatar
    Join Date
    Sep 2013
    Posts
    2,924
    Character
    Stouter Taru
    World
    Exodus
    Main Class
    Thaumaturge Lv 70
    Updated with rough voyage time and ability to exclude parts from builds. Fixed a mistake where minimum stat used "greater than" instead of "greater than or equal to"
    (0)

  4. #4
    Player
    AlexanderBlackiris's Avatar
    Join Date
    May 2015
    Posts
    6
    Character
    Vitae Midwinter
    World
    Famfrit
    Main Class
    Arcanist Lv 70
    your latest version keeps re-protecting the sheet. It makes it hard to sort. But the estimated time is helpful!
    (0)

  5. #5
    Player
    StouterTaru's Avatar
    Join Date
    Sep 2013
    Posts
    2,924
    Character
    Stouter Taru
    World
    Exodus
    Main Class
    Thaumaturge Lv 70
    Quote Originally Posted by AlexanderBlackiris View Post
    your latest version keeps re-protecting the sheet. It makes it hard to sort. But the estimated time is helpful!
    I'll do something about that tomorrow, along with a time estimator that should be around 99.9% precise.

    The page protection was due to the formulas in the builds table; if you accidentally click on one of the numbers in the table it reverts to the formula, which requires ctrl+alt+enter and the web version doesn't accept.
    (0)

  6. #6
    Player
    StouterTaru's Avatar
    Join Date
    Sep 2013
    Posts
    2,924
    Character
    Stouter Taru
    World
    Exodus
    Main Class
    Thaumaturge Lv 70
    Sheet protection is gone, and time estimator should be within a minute or two.
    (1)

  7. #7
    Player
    AlexanderBlackiris's Avatar
    Join Date
    May 2015
    Posts
    6
    Character
    Vitae Midwinter
    World
    Famfrit
    Main Class
    Arcanist Lv 70
    It works great! I really like this spreadsheet, it's very helpful! Thank you!
    (0)

  8. #8
    Player
    StouterTaru's Avatar
    Join Date
    Sep 2013
    Posts
    2,924
    Character
    Stouter Taru
    World
    Exodus
    Main Class
    Thaumaturge Lv 70
    Made a separate workbook for Airships
    (0)

  9. #9
    Player
    StouterTaru's Avatar
    Join Date
    Sep 2013
    Posts
    2,924
    Character
    Stouter Taru
    World
    Exodus
    Main Class
    Thaumaturge Lv 70
    Web pages added
    (0)

  10. #10
    Player
    AlexanderBlackiris's Avatar
    Join Date
    May 2015
    Posts
    6
    Character
    Vitae Midwinter
    World
    Famfrit
    Main Class
    Arcanist Lv 70
    Just curious Do you plan to update your spreadsheet for the new Coelacanth parts from 4.4? I tried to fill out the table myself but gave up...
    (0)

Page 1 of 3 1 2 3 LastLast