Guild Wars Tools

Hi everybody. New excel file (maybe someone could turn it into google sheet)
This one serves to verify your points, but also of personal data base for you to recall your matches and the teams that you used.

The link for download:

Excel file
(Click on the arrow)

Some screenshots

DB sheet (updated 05/07/2017):


Simulator Sheet

Summarize Sheet

Day Sheet

use filters

for your pleasure… Kaya :wink:

18 Likes

Great job!!!

2 Likes

Thanks for making this, Kaya :slight_smile:

2 Likes

Nice! I find the point calculator to be particularly useful, particularly for my smaller account that has to decide between winning or using a lot of the same color.

2 Likes

:two_hearts:its really great work.:heart_eyes:

1 Like

Thanks to sœur Marie-Thérèse for her helpfulness. :slight_smile:

1 Like

A little explanation for the novices of excel: for troop cells, the drop-down list with autocomplete on excel is different from a google sheet.
Use: first delete the Troop word from all cells, then type the first letter of your troop, and then clicking the arrow (top right of the cell) you will have a smaller list of choices with the troop starting by the chosen letter.

Formula :sweat_smile:

=SI(G3<>“”;DECALER(F_Troop;EQUIV(G3&““;F_Troop;0)-1;;NB.SI(F_Troop;G3&””);1);F_Troop)

PS: same for Weapon cells

1 Like

great work :slight_smile:

1 Like

Hi all

Want to know some feedback about this spreadsheet … functional or not … we can improve some points ?

For the simulator sheet, and following the update, please remove the protection of the sheet and modified the values of the basis points

1 Like