# GoW Events spreadsheet

**URL:** <https://community.gemsofwar.com/t/gow-events-spreadsheet/29260>\
**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:** 1

<div class="post-metadata">

**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:** [August 23, 2017, 12:35pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/1 "2017-08-23T12:35:42Z")

</div>

Hi there,

I am currently the one managing the [GoW Events spreadsheet](https://docs.google.com/spreadsheets/d/1hvL6AijrIk4B2HHAh0A9yh3J7jVHlN2DV54fINvRkV8/edit#gid=0) 🙂 .

This spreadsheet was created by @Rasper and afterwards it was @MakoSipper who updated it. Big thanks to them.  
Big thanks also to @yonizaf for giving the spoilers.

In this topic, I will put some updates and what I’m planning to do. If you have any comments/suggestions, just post here 😉 .

---

<div class="post-metadata">

**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:** [August 25, 2017, 7:05am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/2 "2017-08-25T07:05:52Z")

</div>

Here we go with the 1st update:

## General

Aside ByColor tab, everything was manual. So I did some scripts to update the tabs automatically 🙂 . It means bug can occurs 😅.

## By Date

- add a MaxStar column, so one can know how many stars you can get for the corresponding kingdom when the new troop(s) will be there. If it’s red it means you can increase your kingdom power level.
- **TODO** replace the values by a picture → need to find a way to stock online these pictures…
- add the Arcane + its colors that you will need for the new troops
- add the troops from the new kingdom directly here
- **TODO** troops not in the chest will be kept in this tab with a new status (if Console player are interested I can also put another status, like _not released on Console_ and _not in chest on Console_)

## By Color

- merge with “Arcanes for Non-Glory Troops”: on the left, you have the old “By Color” tab contents and on the right “Arcanes for Non-Glory Troops” tab ones.
- add a glory counter: it takes into account the discount of a 2xArcane week.
- but, it’s incoherent because the glory needed to trait the _Glory troops_ were not taken into account, so I add the number of Arcane required for the _Glory troops_

## Arcanes for Non-Glory Troops

- it will be kept hidden

## Future Kingdoms

- I don’t know what to do with this one 😉

## Base Mythics

- add kingdoms to provide: 1) compute the max number of stars from the “History” tab, 2) add the Mythics so one can quickly see which kingdom hasn’t its Mythic yet

If you have any comments, just let me know.

---

<div class="post-metadata">

**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\
**Post date:** [August 25, 2017, 8:00am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/3 "2017-08-25T08:00:49Z")

</div>

One to add/update, perhaps:

Sep-24: Stormheim, Yellow/Brown UR

---

<div class="post-metadata">

**Author:** ![Rasper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/rasper/32/2363_2.png) [@Rasper](https://community.gemsofwar.com/u/Rasper)\
**Post date:** [August 25, 2017, 1:29pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/4 "2017-08-25T13:29:08Z")

</div>

Looking good guys!

---

<div class="post-metadata">

**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:** [August 28, 2017, 1:02am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/5 "2017-08-28T01:02:06Z")

</div>

I need some help: I’m alright with that?  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/7/a/7a4a2f52d584107159070b501afbe45ed8f385dd.png)  
@Saltypatra, is it okay that I used these pictures on the google spreadsheet?

---

<div class="post-metadata">

**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:** [August 28, 2017, 8:17am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/6 "2017-08-28T08:17:02Z")

</div>

If some console players are interested by the spreadsheet could they tell me what troops are missing on Console compared to PC/mobile, please?

---

<div class="post-metadata">

**Author:** ![GameTagwastaken](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@GameTagwastaken](https://community.gemsofwar.com/u/GameTagwastaken)\
**Post date:** [August 28, 2017, 1:57pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/7 "2017-08-28T13:57:52Z")

</div>

> [@The (Un)Official Console Weekly Event Thread 3 (No further updates)](http://community.gemsofwar.com/t/the-un-official-console-weekly-event-thread-3-current-event-glacial-peaks/15315):
>
> As the console versions of GOW are now caught up with the PC/Mobile version, I will no longer be updating this post after today. I will leave the chronological list of all troops released on console since the 1.085 update up, with the last troops being those released on December 4, 2017. Please see the GOW events spreadsheet for current information and ongoing history: [GoW Events spreadsheet](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260) Last update: December 4, 2017 Current Console Version: 3.2 Troops released:play_button Troops released since …

@Stan updates this each week.

---

<div class="post-metadata">

**Author:** ![Scarlett](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/scarlett/32/31007_2.png) [@Scarlett](https://community.gemsofwar.com/u/Scarlett)\
**Post date:** [September 3, 2017, 1:41pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/8 "2017-09-03T13:41:21Z")

</div>

Hi Turintuor, could you insert the images of incoming troops on the spreadsheet just like in the past?  
Thanks for yoour work ^^

---

<div class="post-metadata">

**Author:** ![maximuse2004](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/maximuse2004/32/16700_2.png) [@maximuse2004](https://community.gemsofwar.com/u/maximuse2004)\
**Post date:** [September 3, 2017, 10:57pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/9 "2017-09-03T22:57:14Z")

</div>

Could you post pics of the new troops coming ??? It was on there but I haven’t seen it. I really enjoyed it 🙂

---

<div class="post-metadata">

**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:** [September 20, 2017, 6:34am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/10 "2017-09-20T06:34:13Z")

</div>

Sorry for the late answer. I’m not able to check by myself spoilers so I cannot provide this kind of informations… It’s better to check for spoilers [here](http://community.gemsofwar.com/t/spoiler-alert-any-details-provided-are-subject-to-change/1280).

The spreadsheet is updated until the beggining of Februray, but:

- no information for the week of December 17th
- double release of a Mythic troop in November whereas no Mythic in December
- no information about the Arcanes for the Mythics (aside the October’s one)

---

<div class="post-metadata">

**Author:** ![GREEK-13](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/greek-13/32/5511_2.png) [@GREEK-13](https://community.gemsofwar.com/u/GREEK-13)\
**Post date:** [September 30, 2017, 11:49pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/11 "2017-09-30T23:49:03Z")

</div>

Thanks for managing the spreadsheet. Really appreciate it. I really like that you’ve made it easier to see how many traitstones we will need in the future and when we will be available to buy them next. It helps a ton! Have you considered a page with future troops. That would be really nice to see what we have coming in the future. Not a must, but would be a nice addition. Keep up the good work.

---

<div class="post-metadata">

**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:** [October 2, 2017, 6:56am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/12 "2017-10-02T06:56:12Z")

</div>

You’re welcome 😉 .

I don’t think I will put a spoiler tab because:

- I don’t have this kind of informations
- the spreadsheet is more about arcane/glory management regardless of the troops stats/spell

If you another suggestions, please let me know 🙂 .

---

<div class="post-metadata">

**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:** [October 11, 2017, 8:06pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/13 "2017-10-11T20:06:45Z")

</div>

On the spreadsheet, through Oct 30 new troops are coming out on Mondays, while after that they are reported coming out on Sundays. (Nov 5, for example, is a Sunday.) Is this a real change, time zone confusion, or a mistake?

As always, thank you for doing the spreadsheet.

---

<div class="post-metadata">

**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\
**Post date:** [October 11, 2017, 8:22pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/14 "2017-10-11T20:22:38Z")

</div>

It’s time zone confusion. They’re releasing as always between Sunday/Monday PDT (for most folks, solidly Monday).

---

<div class="post-metadata">

**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:** [October 12, 2017, 1:08am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/15 "2017-10-12T01:08:24Z")

</div>

Very strange. I fixed it. Thanks for the report 😉 .

---

<div class="post-metadata">

**Author:** ![Kruegaron](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kruegaron](https://community.gemsofwar.com/u/Kruegaron)\
**Post date:** [November 24, 2017, 4:51am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/16 "2017-11-24T04:51:27Z")

</div>

I am curious if you are still planning to keep this spreadsheet up to date?  
This weeks epic from Broken Spire uses Arcane Spirit (blue/purple) instead of the announced Arcane Plains (yellow/purple).  
Also we are just about on time for the new mythic from Divinion Fields?

Thanks for your efforts to maintain this sheet. I reference it a lot.  
Cheers

---

<div class="post-metadata">

**Author:** ![Sheba](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/sheba/32/45190_2.png) [@Sheba](https://community.gemsofwar.com/u/Sheba)\
**Post date:** [November 24, 2017, 4:54am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/17 "2017-11-24T04:54:21Z")

</div>

From what I read, @turintuor is currently on vacation and therefore doesn’t manage the sheet right now, but will continue to do so upon returning.  
If I’m mistaken, someone will surely correct me soon.

---

<div class="post-metadata">

**Author:** ![Kruegaron](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kruegaron](https://community.gemsofwar.com/u/Kruegaron)\
**Post date:** [November 24, 2017, 8:03am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/18 "2017-11-24T08:03:23Z")

</div>

Ahh thanks Sheba. Everyone deserves a holiday 🙂

---

<div class="post-metadata">

**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:** [November 25, 2017, 10:40am UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/19 "2017-11-25T10:40:04Z")

</div>

Yeah I was in vacation 😛 .  
I didn’t expect to have no time/password for the spreadsheet… Sorry.  
But it’s up-to-date now 😉 (even if the new kingdom should be different…).

---

<div class="post-metadata">

**Author:** ![Kruegaron](https://avatars.discourse-cdn.com/v4/letter/k/f4b2a3/32.png) [@Kruegaron](https://community.gemsofwar.com/u/Kruegaron)\
**Post date:** [November 29, 2017, 11:05pm UTC](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260/20 "2017-11-29T23:05:59Z")

</div>

Thanks Turintuor. Your efforts here are much appreciated 👍

[Next page](https://community.gemsofwar.com/t/gow-events-spreadsheet/29260.md?page=2)
