Guild Wars Calculator for GW Islands
Burmeliinis
Member Posts: 1,245 ✭✭✭✭✭
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/1pCzxzkR95IbkkqKVT0bY82lsAlLh7gPiPaq4vy8dE/edit?usp=sharing
edit Mar 20; corrected the rounding on the red gas
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/1pCzxzkR95IbkkqKVT0bY82lsAlLh7gPiPaq4vy8dE/edit?usp=sharing
edit Mar 20; corrected the rounding on the red gas
Ingame username: Jubjab
Comments

Your link for the EXCEL version takes us to your OneDrive
Leader of STALKERS_CAMP
Level 78
Its STINGER01 not Singer01 lol 

Love it. Did you make assumptions or did you have inside information?
the example map shows bonus areas as L27L29. So either you assumed this sample map was for L27 survivors or someone told you?
Or maybe bonus maps are player level1?
I started looking to modifying spread sheets but came searching to find out if map was based on L27. 
The difficulty of map 1A 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

You know the people demand more and more. So, could you include the Solver in this version?
Thank you very much for your job. 
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 

Oh, ok. It’s really a problem. But at least both teams will have the same problem.

corrected a rounding error on the red gas usage and cleared up some editing done by someoneIngame username: Jubjab

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?

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?

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 
Or ABC as one value to find her on bonus sectors?The Expendables  Polska gildia

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 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 
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?

@Crocodile
95% covering this sectors ( maybe 18 not )
or Tracking completing 3 sectors ABC: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 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 complicatedThe Expendables  Polska gildia
Categories
 All Categories
 339 Welcome
 3 Rules
 334 Announcements
 1 Community Spotlight
 21.8K The Walking Dead: No Man's Land
 13.8K General No Man's Land Discussion
 955 Guild Wars Discussion
 68 Girl Power Community
 55 Nations United (former Nation Wars)
 1.6K Strategy Discussion
 82 Guild Discussion
 12 Players looking for guilds
 67 Guilds Recruiting
 859 Video Vault
 113 CheckIn Thread Corner
 3.5K Suggestions & Ideas
 4.6K Bugs & Issues
 1.6K Game Issues
 2K Bug Reports
 1.5K Off Topic
 1.4K Off Topic Discussion
 100 TV Show Discussion