Spreadsheet Vault by Zami

First things first, a huge thank you to Mechengg and ConfusedKate for all the hard work they put into creating these valuable resources for the community. Sad to see any of these original giants leave, but we all do what we think is best.

A reminder from Mechengg: Probably worth noting, many of these spreadsheets have multiple tabs, remember to check them all out for all of the information.


Important Notes

  • All sheets with a comment of [download link] will come up to a page for you to make a copy to your Drive. For this page to show up, you must be logged into your Google account.
    image

  • All requests for edit access are ignored and deleted. Any community editable sheets will be listed as such.


Zami’s Adopted Spreadsheet Vault

Since I am acquiring other spreadsheets not in the original vault, I think these should go in their own section.

  • Sigil Spender v1.4.6 - [download link] Will let you see how many more sigils you need to finish a line, discounted or not, track out an entire season if you want, and look at sigils spent on a week to week basis. (Original sheet by BadgerWar)

  • Event Start and End Times - Forgot when an event starts and ends? It is listed here. Check the second sheet for the code to embed this into your in-game wiki. Timezone converter for world timezones, War Dragons runs off time in San Francisco, CA USA (Pacific Time).

  • Troop Planner [download link, fill out your info] - This will let you fill out how many trainings you do a day, whether you run Atlas Elite, how many bullhorns per training you use, to see how long you need to make a certain amount of troops.

  • Comparison of Gold and Platinum/Draconic Chests - This is just a quick document I made with screenshots showing cost equivalents of gold chests vs platinum and draconic chests bought with rubies in each type of event and what you will get. May be outdated, use with caution.

  • Zami’s In-game Wiki Pages - pre-formatted wiki pages you can drop into your in-game wiki. Most outdated to some degree, use with caution.

  • Chest Drop Predictor v1.1 [download link, fill out your info] - Fill out with community found chest sequence info, then open a few chests, fill out the appropriate predictor sheet and the sheet will spit out the remaining sequence of returns should you continue to open up to 1k chests. Includes a summary sheet to see your total drops possible.
    Currently only available for gold and sigil (super sigil) chest sequences.

  • Crystal Caves Crystal Info - crystal hp and info per league


ConfusedKate’s Spreadsheet Vault

  • Fortification Planner
    A thank you to Mech for the format of this planner. All backend info has been completely redone to allow easier updating.
    Post with the how to video I made.

  • Research Planner v1.2
    Select which research has been completed and filter by Yes to better see what you have left to research. Enter Yes under Want for any research you would like to complete (be sure to watch prerequisites). Enter the number of eggs you have on the Eggs Needed tab and you will see how many tokens you’ll need to complete the research. For more research eggs combos see: Egg token combos for Red eggs - Neon War Dragons

  • Event Chest Drops v1.4.3
    This worksheet allows you to enter the number of chests you open based on the event you choose and will give an average drop rate. It is based on averages, so the more chests you open, the more accurate it will be. Based on Mechengg’s Chest Drop Rates which you can view in his vault below.

“Rider Leveling and Skill Trees” and “Breeding Table” have been permanently removed. Please view Morreion’s website for current and relevant rider and breeding data.


Mechengg’s Spreadsheet Vault

Miscellaneous Game Spreadsheets

  • Zeppelin Mission Table - View egg token and timer payouts from the mission balloon for any tier, with or without elite, and with or without season mission boost.

Event Spreadsheets

  • Event History - History of events back to start of seasons in 2016 and kept updated with tentative schedule of events to come.

Event Prizes

Minor Event Prizes

Major Event Prizes

Team Prizes

Event Information

Chest Drop %'s

Downloadable Worksheets

Atlas Spreadsheets

Information Tables

Atlas Events

Downloadable worksheets

70 Likes
Spreadsheet Vault
Problem with fortification planner
Individual prizes
What are Primeachs max glory levels?
Castillos y fichas
Show Sum of timers
Can anyone please share me the link where I can know how much wood and elements need for level up each towers
SunScorch Week 10 - Fortification Frenzy
LotusBloom week 11 - FORTIIIIIEEEEEEEEEE
Updated fort planner
Neon War Dragons information site
Souldance Week 9 - Fort
Eclipse Week Four - Fortification
Eclipse Week Four - Fortification
Silver Chest Sequencing
Super Sigil Chest Sequencing
100% egg tokens
Egg missions bonus not applied
What is the next Event? Breeding Event?
Adding calculators into the wiki
First event of new season
Quick Advice on Mythics
Fort planner question
What level storage hut can I get?
Trading post value analysis - Eclipse week 7
What has happened to Geek website?
Timers and a Note about the Tower Branch
Timers and a Note about the Tower Branch
Eclipse Week Eight - Fortification
Release Notes 5.27 - Official Discussion Thread
Did PG just put the cost of energy refils up? Or did they add extra tiers
Is there somewhere that I can look that will tell me how many more events We have in this season?
Community's first thoughts about Jjin
24K point event prize. Is this a mistake?
Math Check 😅 - Final Steps To Hauhezen
Looking for gear levelling guide
Crystal cave prizes
Fortification prize point question
Level base it won’t move and I’m very frustrated I’m thinking about quitting the game if it’s not fixed
Levels team prize in Breeding
Official Discussion Thread: Fight for Glory
Egg Tokens Glitch?
SunScorch Week 10 - Fortification Frenzy
Question on buying a mithic
Silver Chest Sequencing
Sunscorch 6th week - FORTIFICATION - they cant glitch this can they?
Super Sigil Chest Sequencing
Primarch stats list
Gameplay Faction (GPF) Application
SunScorch - 2nd event - Fortification Frenzy - Week 2 of discounts
Does exist a graph of armors upgrading?
Draconic Chest chances
I want to know the fortification event prizes. Can you help me?
SunScorch - 2nd event - Fortification Frenzy - Week 2 of discounts
QQ- How many bronze chest will net me 200sigils
Next Breeding Event's Prizes?
New Arboralith Node + LotusBloom Bonus Season Key Branch
Post Lotusbloom - Lv. 400-500
Armor: legendary - elite - mythic
Trading post value analysis - Souldance week 7
Guide to prim leveling w costs?
PG needs to fix this in fort
Prims levels glory needs
Aftermath - Week 2 - Fortification
SunScorch Stream Notes - Base Boost is Week 1
Where the game is going
Content of the branches
Souldance Week 5 - FORTIFICATION FRENZY
Spreadsheet Vault
Souldance Season - Week 2 - TEAM GAUNTLET
Drop in timer levels in atlas event
Crystal Howitzer Not In Fort Planner
Celestial Rift Week Three - Fortification
Sigil chest drops?
Discount drag or Festive with Draconics
Event Plan for the Celestial Season 2021
Gold Chest Sequencing
Anyone knows the sigil count for individual prizes

Thanks for contributing your time to help the community

5 Likes

I’m getting a permissions error on the Fort Planner from the link above, on the link in DataFilesTOC sheet.

(thank you for taking over the vault :slight_smile:)

1 Like

Sorry about that, should be fixed now.

3 Likes

Thank you for linking me here :slight_smile:

1 Like

Thnx for taking over and maintaining sheets :partying_face:

2 Likes

is 5.0.8 the latest Fort? I think it only goes up to 95?

1 Like

5.xx fort planner automatically updates

1 Like

wheres that?

1 Like

Thank you very much for picking this up.

2 Likes

Thanks Zami :+1:

1 Like

It should be fixed now. The files only went to level 95 and I’m not sure why. I uploaded the newest files that go to 100. Please verify the planner does work. You shouldn’t need to download it again, should auto update when my files are updated.

2 Likes

Thank you :heart: :heart:

2 Likes

looks great, thank you!

1 Like

Thank you for picking up the hosting of these resources.

2 Likes

Thanks for hosting it, and @moderator why this one is not pinned yet?

Btw, can you check Fortification Planner version 5.0.8, which I assume is the latest.

When I try to fill the builder hut from level 47 to 48, they didn’t give you the wood and the points, even though in reality they used wood and eggs.

Thanks!

1 Like

Thank you

1 Like

I noticed the same.

1 Like

Some of the links dont point to where they should.
A few I noticed:
Kingdom Wars Event prizes-> Fort Event prizes
Fight Pits Event prizes -> Crafting Event prizes
Feeding Event prizes -> Crafting Event prizes
Breeding Event prizes -> Chest Drops

3 Likes

I have fixed the links I think. Please let me know if any others are messed up. I am still working on the fort planner and what went wrong there. I can look at it more after work.

3 Likes