Guild Wars Calculator for GW Islands

Burmeliinis
Burmeliinis Member Posts: 1,245 ✭✭✭✭✭
edited March 2021 in Guild Wars Discussion
New map means new calculator! Here is the link to my updated GW calculator.

The Excel version has macros to make filling and clearing easier. Link here: https://1drv.ms/x/s!AgGQ_C83qUKqhqxUYdYryUfS7uDm4A?e=1aBtBG

The Google Sheets version is without macros. Link here: https://docs.google.com/spreadsheets/d/1pCzxzkR95IbkkqKVT0bY82lsAlL-h7gP-iPaq4vy8dE/edit?usp=sharing

edit Mar 20; corrected the rounding on the red gas
Ingame username: Jubjab
Vovm4s[Deleted User]AlexKomiosononeganSJCMagnusRexAlexNEngAamiemirs7eyeW8PasteNovellmarroba2000SpikedTeenahGee
· Share on Twitter

Comments

  • Singer01
    Singer01 Member Posts: 75 ✭✭✭
    edited March 2021
    Your link for the EXCEL version takes us to your OneDrive

    Leader of STALKERS_CAMP
    Level 78
    Its STINGER01 not Singer01 lol
    · Share on Twitter
  • Burmeliinis
    Burmeliinis Member Posts: 1,245 ✭✭✭✭✭
    Thanks, link is fixed now
    Ingame username: Jubjab
    [Deleted User]
    · Share on Twitter
  • tbdbitl
    tbdbitl Member Posts: 40 ✭✭✭
    Love it. Did you make assumptions or did you have inside information?

    the example map shows bonus areas as L27-L29.  So either you assumed this sample map was for L27 survivors or someone told you?

    Or maybe bonus maps are player level-1?

    I started looking to modifying spread sheets but came searching to find out if map was based on L27. 


    · Share on Twitter
  • Burmeliinis
    Burmeliinis Member Posts: 1,245 ✭✭✭✭✭
    The difficulty of map 1-A and the Bonus Sectors is the same as your survivor max level. For some reason NG published a map based on lvl 27 survivors, but since most play with lvl 28 survivors I made that the default. But you can adjust the level in the upper left corner to match that of your own survivors.
    Ingame username: Jubjab
    mir
    · Share on Twitter
  • marroba2000
    marroba2000 Member Posts: 240 ✭✭✭
    You know the people demand more and more. So, could you include the Solver in this version?
    Thank you very much for your job. 
    · Share on Twitter
  • Burmeliinis
    Burmeliinis Member Posts: 1,245 ✭✭✭✭✭
    edited March 2021
    The problem is that there are so many sectors with similar scores. It's easily thousands of combinations. So to get something worthwhile also individual player scores should be included, but that again makes the solving much more complicated, and at least so far I haven't found a reasonable way to program that.

    Below all possible combinations for something as simple as a team having completed island 1A 1B 1C, which gived 520 sector points:

    520:,1A,1B,1C
    520:,1A,6A,3A
    520:,1A,6A,3B
    520:,1A,6B,3A
    520:,1A,6B,3B
    520:,1A,13A,14A
    520:,1A,13A,14B
    520:,1A,13A,14D
    520:,1A,13B,14A
    520:,1A,13B,14B
    520:,1A,13B,14D
    520:,1A,13D,14A
    520:,1A,13D,14B
    520:,1A,13D,14D
    520:,1A,2A,7A
    520:,1A,2A,7B
    520:,1A,2B,7A
    520:,1A,2B,7B
    520:,1B,6A,3A
    520:,1B,6A,3B
    520:,1B,6B,3A
    520:,1B,6B,3B
    520:,1B,13A,14A
    520:,1B,13A,14B
    520:,1B,13A,14D
    520:,1B,13B,14A
    520:,1B,13B,14B
    520:,1B,13B,14D
    520:,1B,13D,14A
    520:,1B,13D,14B
    520:,1B,13D,14D
    520:,1B,2A,7A
    520:,1B,2A,7B
    520:,1B,2B,7A
    520:,1B,2B,7B
    520:,B1,6A,3A
    520:,B1,6A,3B
    520:,B1,6B,3A
    520:,B1,6B,3B
    520:,B1,13A,14A
    520:,B1,13A,14B
    520:,B1,13A,14D
    520:,B1,13B,14A
    520:,B1,13B,14B
    520:,B1,13B,14D
    520:,B1,13D,14A
    520:,B1,13D,14B
    520:,B1,13D,14D
    520:,B1,2A,7A
    520:,B1,2A,7B
    520:,B1,2B,7A
    520:,B1,2B,7B
    520:,B2,6A,3A
    520:,B2,6A,3B
    520:,B2,6B,3A
    520:,B2,6B,3B
    520:,B2,13A,14A
    520:,B2,13A,14B
    520:,B2,13A,14D
    520:,B2,13B,14A
    520:,B2,13B,14B
    520:,B2,13B,14D
    520:,B2,13D,14A
    520:,B2,13D,14B
    520:,B2,13D,14D
    520:,B2,2A,7A
    520:,B2,2A,7B
    520:,B2,2B,7A
    520:,B2,2B,7B
    520:,B3,6A,3A
    520:,B3,6A,3B
    520:,B3,6B,3A
    520:,B3,6B,3B
    520:,B3,13A,14A
    520:,B3,13A,14B
    520:,B3,13A,14D
    520:,B3,13B,14A
    520:,B3,13B,14B
    520:,B3,13B,14D
    520:,B3,13D,14A
    520:,B3,13D,14B
    520:,B3,13D,14D
    520:,B3,2A,7A
    520:,B3,2A,7B
    520:,B3,2B,7A
    520:,B3,2B,7B
    520:,B4,6A,3A
    520:,B4,6A,3B
    520:,B4,6B,3A
    520:,B4,6B,3B
    520:,B4,13A,14A
    520:,B4,13A,14B
    520:,B4,13A,14D
    520:,B4,13B,14A
    520:,B4,13B,14B
    520:,B4,13B,14D
    520:,B4,13D,14A
    520:,B4,13D,14B
    520:,B4,13D,14D
    520:,B4,2A,7A
    520:,B4,2A,7B
    520:,B4,2B,7A
    520:,B4,2B,7B
    520:,6A,6B,14A
    520:,6A,6B,14B
    520:,6A,6B,14D
    520:,6A,13A,7A
    520:,6A,13A,7B
    520:,6A,13B,7A
    520:,6A,13B,7B
    520:,6A,13D,7A
    520:,6A,13D,7B
    520:,6A,2A,2B
    520:,6B,13A,7A
    520:,6B,13A,7B
    520:,6B,13B,7A
    520:,6B,13B,7B
    520:,6B,13D,7A
    520:,6B,13D,7B
    520:,6B,2A,2B
    520:,13A,13B,2A
    520:,13A,13B,2B
    520:,13A,13D,2A
    520:,13A,13D,2B
    520:,13B,13D,2A
    520:,13B,13D,2B
    Ingame username: Jubjab
    [Deleted User]marroba2000FuriousMoldovanPastehunter_xghost_pepperVovm4s
    · Share on Twitter
  • [Deleted User]
    [Deleted User] Member Posts: 996
    this Jubjab is broken bring new one :) 
    KarajocaPasteFuriousMoldovan
    · Share on Twitter
  • marroba2000
    marroba2000 Member Posts: 240 ✭✭✭
    Oh, ok. It’s really a problem. But at least both teams will have the same problem. 
    · Share on Twitter
  • Burmeliinis
    Burmeliinis Member Posts: 1,245 ✭✭✭✭✭
    corrected a rounding error on the red gas usage and cleared up some editing done by someone
    Ingame username: Jubjab
    · Share on Twitter
  • Daesymae
    Daesymae Member Posts: 4
    Can someone explain to me how I can do the same Island Clusters two battles in a row and score different points? Or even go to a harder tier and score less?
    · Share on Twitter
  • [Deleted User]
    [Deleted User] Member Posts: 996
    Daesymae said:
    Can someone explain to me how I can do the same Island Clusters two battles in a row and score different points? Or even go to a harder tier and score less?
    do you use red gas? 
    · Share on Twitter
  • m4s
    m4s Member Posts: 681 ✭✭✭✭✭
    I try to use solver for solve this question.
    Typically most played sectors: 5,9,10,11,12,16ABC +D6,17ABC+D,18,12 , this list creating narrow range for calculating.
    Second problem: How to include bonus C after close sectors AB?
    First routine calculating AB, and Next C 🤔
    The Expendables - Polska gildia
    · Share on Twitter
  • m4s
    m4s Member Posts: 681 ✭✭✭✭✭
    Or ABC as one value to find her on bonus sectors?
    The Expendables - Polska gildia
    · Share on Twitter
  • [Deleted User]
    [Deleted User] Member Posts: 996
    m4s said:
    I try to use solver for solve this question.
    Typically most played sectors: 5,9,10,11,12,16ABC +D6,17ABC+D,18,12 , this list creating narrow range for calculating.
    Second problem: How to include bonus C after close sectors AB?
    First routine calculating AB, and Next C 🤔
    when you complete A and B opening C and when you complete C you got bonus from C  B)
    · Share on Twitter
  • [Deleted User]
    [Deleted User] Member Posts: 996
    when you complete 12A you got 395 VP bonus
    when completing 12B you got more 395 VP bonus
    total sector bonus now 790 and etc
    complete any next location A B C or D will add VP to sector bonus

    if I'm right understanding your question :) 
    · Share on Twitter
  • Daesymae
    Daesymae Member Posts: 4
    Crocodile said:
    Daesymae said:
    Can someone explain to me how I can do the same Island Clusters two battles in a row and score different points? Or even go to a harder tier and score less?
    do you use red gas? 
    Very rarely… I know that drops it, but my group is pretty steady and we’ve been together over a year… this new map we’re loosing almost 30% of the time now if not more…
    · Share on Twitter
  • m4s
    m4s Member Posts: 681 ✭✭✭✭✭
    edited May 2021
    @Crocodile
    95% covering this sectors ( maybe 18 not :( )
    5A 300
    5B 300
    5C 490
    9A 270
    9B 270
    9C 440
    10A 315
    10B 315
    10C 515
    11A 355
    11B 355
    11C 575
    16A 285
    16B 285
    16C 465
    16D 285
    17A 335
    17B 335
    17C 545
    17D 355
    18A 375
    18B 375
    18C 605
    18D 375
    or Tracking completing 3 sectors ABC:
    5ABC 1090
    9ABC 980
    10ABC 1145
    11ABC 1285
    16ABC 1035
    17ABC 1215
    18ABC 1355
    16D 285
    17D 335
    18D 375

     Narrows down the number of combinations. Tracking by individual sectors is possible from the beginning of the battle and after full sectors it is possible only after the battle.
    This is my short explanation of what I meant with the ABC sector calculations.
    For this you also need to take into account the number of people in the team 7,8,9,10 because it changes the number of sectors to close.

    For this you can also try to deduce the result assuming opening Sectors A and B will close sector C

    So it's a bit complicated :o
    The Expendables - Polska gildia
    · Share on Twitter

Categories