GoW Events spreadsheet


#21

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!


#22

The devs said in the steam it will be the 29th instead because the 26th is a holiday.


#23

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! :smile: :beers:


#24

An upcoming Shentang UR troop is marked yellow-red with Arcane Lava. Something must be wrong there…


#25

According to Taran’s World, that one should be Arcane Lava with Red/Brown. Probably just a data-entry error.


#26

Okay, fixed. Thanks :wink: .


#27

Updated the spreadsheet to take the Epics only available in Event shops into account.


#28

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.


#29

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.


#30

The spreadsheet wasn’t updated…

You’re right, Thanks :wink: .


#31

Should Blackhawk on 2nd July be in orange as it hits 9*?


#32

Yes it should :wink: . Fixed. Thanks.


#33

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.

Edit: Oh, and your gap between 6 stars and 7 stars is wrong also. That should also be 300:

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


#34

Thanks :wink: .

I don’t know how and why but I was missing the 2900 threshold…

It should be fixed now.


#35

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.


#36

Thanks :wink: .

I used now the MATCH function which sounds better.

Here the Silver star is Power level 0.


#37

Nice, that makes much more sense. It’s a great spreadsheet. Thank you for your work!


#38

Oh, hey, the Kingdoms tab is missing the Mythic Ubastet in Pridelands.


#39

Kingdom power level fixed on the spreadsheet to take the pets and weapons into account.

If you see any mistakes, please let me know :wink: .


#40

Level 6 kingdoms require 2 legendary troops from that kingdom, but the spreadsheet doesn’t appear to be able to accommodate for that.