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
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.
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)
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.
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?
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
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.
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…).