# GoW Events spreadsheet **URL:** \ **Category:** Community Guides\ **Created:** [August 23, 2017, 12:35pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260 "2017-08-23T12:35:42Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Courtenay](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/courtenay/32/25096_2.png) [@Courtenay](https://community.gemsofwar.com/u/Courtenay)\ **Post date:** [January 20, 2018, 4:49pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/21 "2018-01-20T16:49:02Z")
Bright Forest say Jan-29. Shouldn’t that be Jan-26, a Friday, like all other new kingdoms? P.S. Thanks for all the work! ---
**Author:** ![VenusBlue](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/venusblue/32/38243_2.png) [@VenusBlue](https://community.gemsofwar.com/u/VenusBlue)\ **Post date:** [January 20, 2018, 4:51pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/22 "2018-01-20T16:51:39Z")
The devs said in the steam it will be the 29th instead because the 26th is a holiday. ---
**Author:** ![The\_Freak](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/the_freak/32/32738_2.png) [@The\_Freak](https://community.gemsofwar.com/u/The_Freak)\ **Post date:** [February 10, 2018, 5:37pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/23 "2018-02-10T17:37:07Z")
Many thanks @turintuor for keeping this up to date. Just noticed you updated it with data through 5/4… it helps me and my fellow fam with our resource allocation a ton! 😄 🍻 ---
**Author:** ![Bolatsi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/bolatsi/32/7182_2.png) [@Bolatsi](https://community.gemsofwar.com/u/Bolatsi)\ **Post date:** [February 12, 2018, 9:44pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/24 "2018-02-12T21:44:37Z")
An upcoming Shentang UR troop is marked yellow-red with Arcane Lava. Something must be wrong there… ---
**Author:** ![Stan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/stan/32/29888_2.png) [@Stan](https://community.gemsofwar.com/u/Stan)\ **Post date:** [February 12, 2018, 10:09pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/25 "2018-02-12T22:09:24Z")
According to Taran’s World, that one should be Arcane Lava with Red/Brown. Probably just a data-entry error. ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [February 12, 2018, 11:55pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/26 "2018-02-12T23:55:01Z")
Okay, fixed. Thanks 😉 . ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [February 22, 2018, 1:40am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/27 "2018-02-22T01:40:04Z")
Updated the spreadsheet to take the Epics only available in Event shops into account. ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [February 23, 2018, 8:52am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/28 "2018-02-23T08:52:59Z")
Updated the spreadsheet to add the banners to the “Kingdom” tab (as requested by someone). I just outline that there is 120 combinaisons of tri-color banner, abd that it’s going ages to have all of them… Aside if the banner system is changed to [something like that](https://community.gemsofwar.com/t/new-banner-system/16257). ---
**Author:** ![GameTagwastaken](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@GameTagwastaken](https://community.gemsofwar.com/u/GameTagwastaken)\ **Post date:** [March 5, 2018, 4:07pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/29 "2018-03-05T16:07:55Z")
Stormheim should be getting another kingdom star next week right? 9 stars is at 17 troops. It should have 17 or 18 troops by next weekend depending on if it gets the bounty troop or not. ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [March 6, 2018, 12:12am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/30 "2018-03-06T00:12:58Z")
The spreadsheet wasn’t updated… You’re right, Thanks 😉 . ---
**Author:** ![Fleg](https://avatars.discourse-cdn.com/v4/letter/f/5e9695/32.png) [@Fleg](https://community.gemsofwar.com/u/Fleg)\ **Post date:** [May 17, 2018, 12:35am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/31 "2018-05-17T00:35:29Z")
Should Blackhawk on 2nd July be in orange as it hits 9\*? ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [May 17, 2018, 12:48am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/32 "2018-05-17T00:48:37Z")
Yes it should 😉 . Fixed. Thanks. ---
**Author:** ![Neight](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Neight](https://community.gemsofwar.com/u/Neight)\ **Post date:** [June 3, 2018, 9:17pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/33 "2018-06-03T21:17:22Z")
I found a small mistake. On the Arcanes tab, it claims you need 2600 to reach 6 stars, but the difference between 5 and 6 is 300, which would make 2700 (assuming the value for 5 stars is correct). Adding picture of my Bright Forest which shows I need 300 to move up. ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/f/8/f8f8dadc94e627bf27c89907e2e77b5bef67db5a.jpg) Edit: Oh, and your gap between 6 stars and 7 stars is wrong also. That should also be 300: ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/9/3/93c098ac5e32678bb3a86deb6a0f46e7d65e9ce8.jpg) Currently it’s 400, but should become 500 once you correct the 5-6 gap. Edit2: I’ve found part of the problem. Your Max Level doesn’t count the stars correctly. Kingdoms start at no stars, then progress to 1 silver star, then 1 gold star. So 5 stars is actually the seventh conditional, instead of the sixth. In working with guildmates, the values should be as follows: \< 600 = no stars \< 1200 = silver \< 1700 = 1 gold \< 2100 = 2 gold \< 2400 = 3 gold \< 2600 = 4 gold \< 2900 = 5 gold \< 3200 = 1 platinum (or whatever it is) \< 3500 = 2 plat \< 3800 = 3 plat \< 4000 = 4 plat \> 4000 = 5 plat ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/7/3/73ec3b545254a4c3a54c4cf500276ab021480d88.png) ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [June 4, 2018, 1:12am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/34 "2018-06-04T01:12:02Z")
Thanks 😉 . I don’t know how and why but I was missing the 2900 threshold… It should be fixed now. ---
**Author:** ![Neight](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Neight](https://community.gemsofwar.com/u/Neight)\ **Post date:** [June 4, 2018, 1:34am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/35 "2018-06-04T01:34:42Z")
Great. Though, now there’s a new error. I suspect you did an insert, which slightly messed up your formula in Column D of the Kingdoms tab. You’ll noticed your conditions check cell F7, but then skip to F9. ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [June 4, 2018, 2:07am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/36 "2018-06-04T02:07:36Z")
Thanks 😉 . I used now the MATCH function which sounds better. Here the Silver star is Power level 0. ---
**Author:** ![Neight](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Neight](https://community.gemsofwar.com/u/Neight)\ **Post date:** [June 4, 2018, 3:41am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/37 "2018-06-04T03:41:16Z")
Nice, that makes much more sense. It’s a great spreadsheet. Thank you for your work! ---
**Author:** ![Neight](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Neight](https://community.gemsofwar.com/u/Neight)\ **Post date:** [June 4, 2018, 11:37am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/38 "2018-06-04T11:37:55Z")
Oh, hey, the Kingdoms tab is missing the Mythic Ubastet in Pridelands. ---
**Author:** ![turintuor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/turintuor/32/4097_2.png) [@turintuor](https://community.gemsofwar.com/u/turintuor)\ **Post date:** [June 21, 2018, 9:08am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/39 "2018-06-21T09:08:45Z")
Kingdom power level fixed on the spreadsheet to take the pets and weapons into account. If you see any mistakes, please let me know 😉 . ---
**Author:** ![Neight](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@Neight](https://community.gemsofwar.com/u/Neight)\ **Post date:** [June 26, 2018, 8:06pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/40 "2018-06-26T20:06:52Z")
Level 6 kingdoms require 2 legendary troops from that kingdom, but the spreadsheet doesn’t appear to be able to accommodate for that. ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/d/a/da16b5d3f9e3377d47b11ffb245e853c966f7653.jpg) [Previous page](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260.md?page=1) [Next page](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260.md?page=3)