# Guild Wars Tools **URL:** \ **Category:** Community Content\ **Created:** [May 7, 2017, 10:59am UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682 "2017-05-07T10:59:22Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [May 7, 2017, 10:59am UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/1 "2017-05-07T10:59:22Z")
![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/3/a/3a88dd75be2e19aa30325183354aa9e51411abf8.png) 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](https://drive.google.com/file/d/0BwMaJlQOdnypYkc1WmNNS3Z3aXM/view) _(Click on the arrow ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/0/9/0963c0006a42a04ca7abb70b8f60c8a103f47c72.png))_ ## Some screenshots **DB sheet (updated 05/07/2017):** ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/a/4/a43eb7e39953653fe438d0463476cc9b76da330b.png) **Simulator Sheet** ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/4/1/4172fa727fc1bbef68a655020313453a527bc835.png) **Summarize Sheet** ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/4/2/426e83d1b48cdcb12e6a484482d508c0cccc5342.jpg) **Day Sheet** ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/8/d/8d42f22f994270f18c68b0bc9e201ea213c0c8e8.jpg) _ **use filters** _ _for your pleasure… Kaya_ 😉 ---
**Author:** ![madking](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/madking/32/62439_2.png) [@madking](https://community.gemsofwar.com/u/madking)\ **Post date:** [May 7, 2017, 11:19am UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/2 "2017-05-07T11:19:15Z")
Great job!!! ---
**Author:** ![Ashasekayi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ashasekayi/32/61090_2.png) [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)\ **Post date:** [May 7, 2017, 12:42pm UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/3 "2017-05-07T12:42:58Z")
Thanks for making this, Kaya 🙂 ---
**Author:** ![Tacet](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/tacet/32/35_2.png) [@Tacet](https://community.gemsofwar.com/u/Tacet)\ **Post date:** [May 7, 2017, 2:49pm UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/4 "2017-05-07T14:49:18Z")
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. ---
**Author:** ![Melissa96](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/melissa96/32/42630_2.png) [@Melissa96](https://community.gemsofwar.com/u/Melissa96)\ **Post date:** [May 7, 2017, 3:24pm UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/5 "2017-05-07T15:24:18Z")
💕its really great work.😍 ---
**Author:** ![Aelthwyn](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/aelthwyn/32/4645_2.png) [@Aelthwyn](https://community.gemsofwar.com/u/Aelthwyn)\ **Post date:** [May 7, 2017, 5:46pm UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/6 "2017-05-07T17:46:21Z")
Thanks to sœur Marie-Thérèse for her helpfulness. 🙂 ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [May 7, 2017, 6:35pm UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/7 "2017-05-07T18:35:16Z")
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. ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/0/3/03c6764bce99f09226c3d38af5a34eed1f562d28.PNG) Formula 😅 > =SI(G3\<\>“”;DECALER(F\_Troop;EQUIV(G3&“_“;F\_Troop;0)-1;;NB.SI(F\_Troop;G3&”_”);1);F\_Troop) _PS: same for Weapon cells_ ---
**Author:** ![hary](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/hary/32/9279_2.png) [@hary](https://community.gemsofwar.com/u/hary)\ **Post date:** [May 7, 2017, 7:11pm UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/8 "2017-05-07T19:11:05Z")
great work 🙂 ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [May 9, 2017, 3:34pm UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/9 "2017-05-09T15:34:32Z")
Hi all Want to know some feedback about this spreadsheet … functional or not … we can improve some points ? ---
**Author:** ![KAYA43V3R](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/kaya43v3r/32/312_2.png) [@KAYA43V3R](https://community.gemsofwar.com/u/KAYA43V3R)\ **Post date:** [May 22, 2017, 3:42am UTC](https://community.gemsofwar.com/t/guild-wars-tools/23682/10 "2017-05-22T03:42:24Z")
For the simulator sheet, and following the update, please remove the protection of the sheet and modified the values of the basis points ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/a/e/aea10d26d4a10091388cec394999f55eaccc9eca.PNG) > [@Bishop to King 4](http://community.gemsofwar.com/t/bishop-to-king-4/24498): > > Originally published at: [Bishop to King 4 – Gems of War](http://gemsofwar.com/bishop-to-king-4/) Checkmate! New Troop: Bishop [[image] ](http://gemsofwar.com/wp-content/uploads/2017/05/blog_bishop.png) The Bishops of Gard are the regional leaders of the Faith of Gard. Each province surrounding Whitehelm has its own Bishop, answerable to the Arch Bishop in the capital. A Bishop has many jobs beyond being a leader of the faith, including acting as a magistrate, and also as an advisor to local Lords and Nobles. New Troop: High Paladin [[image] ](http://gemsofwar.com/wp-content/uploads/2017/05/blog_highpaladin.png) Unlike the Bishops, the High Paladins remain in th…