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. It was sad to see them go, but we all must do what we feel is best.

I have copied all of Mechengg’s and ConfusedKate’s spreadsheets to my drive and will host them. I will also keep them updated as best as I can. If anyone finds any issues with any of these spreadsheets, please let me know. If you know of any missing data, I would appreciate any evidence of the missing data so it can be added.

For the moment I will be using Kate’s post as a template so you can find everything just as it was on her post.

And 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.

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 being ignored. Any community editable sheets will be listed as such.

All requests to for me adopt and update Red’s Breeding Paths will be ignored. She specifically asked for no one to touch her paths or take them over.

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.4 - [download link] currently for SunScorch season. 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. Currently in beta (v1.0) and may be buggy as a few significant back-end changes were needed. (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.

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.

Zami’s In-game Wiki Pages - pre-formatted wiki pages you can drop into your in-game wiki.

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
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 (Google is fighting me with the backend data, will be fixed soon)
The skill tree is rudimentary at best but will give you a general idea. For a better rider skill tree, please see Riders - Hunter - Neon War Dragons or wdstats.com: War Dragons statistics

Breeding Table (Google is fighting me with the backend data, will be fixed soon)
The token costs are rounded up to the nearest per fragment cost. For example, if the per fragment cost is at a discounted rate of 13 tokens, I have rounded the token cost up to the nearest 13th. This makes the token costs more accurate, although it is based on chance so some may pay more, some less.

Mechengg’s Spreadsheet Vault

Miscellaneous Game Spreadsheets

Zeppelin Mission Table - Updated with timers & up to Abyssal tier.

Event Spreadsheets

Event History - Updated to include tentative event schedule.

Event Prizes

Minor Event Prizes
Breeding
Feeding - Feeding is no longer an event, leaving here for posterity.
Fortification

Major Event Prizes
Crystal Caves
Fight Pits
Kingdom Wars - no longer an event, leaving here for posterity.
Team Gauntlet
Temple Raid

Team Prizes
Team Achievement Prizes (All events, check tabs)
Final Prizes (All events, check tabs)
Team Quest Prizes

Event Information

Team Gauntlet Information
Kingdom Wars Information

Chest Drop %'s

Chest Drop Rates

Downloadable Worksheets

PvP Event Planner [download link, fill out your info]
Half-cost Energy PVP Event Planner [download link, fill out your info] (Currently only for the half cost energy in Team Gauntlet.)
Season Planner [download link, fill out your info]

Atlas Spreadsheets

Information Tables

Rider Leveling Information - No longer accurate as new riders gain more skill points. Please see Riders - Hunter - Neon War Dragons or wdstats.com: War Dragons statistics
Primarch Leveling Information
Rider Gear Cost & Buff Tables
Atlas Infrastructure Upgrade Table
Infrastructure Upgrade Bonuses
Atlas Bank Storage & Transfer Information
WTF do i upgrade first? (A guide to leveling gear)

Atlas Events

Crafting Event Prizes
Primarch & Rider Training Event Prizes
Troop Building Event Prizes

Downloadable worksheets

Gold Mine & Beast Tables [download link, fill out your info]
Rider Gear Worksheet [download link, fill out your info]
Crafting Gear Analysis [download link, fill out your info] - Not updated for Elite or Mythic gear
Glory Calculator [download link, fill out your info] - Old calculator leaving here for posterity. NidoGod is updating this. View his thread here.
Crafting Event Planner [download link, fill out your info] - This was still in progress by Mech, so I do not know how accurate it is.

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

Thanks for contributing your time to help the community

4 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:)

Sorry about that, should be fixed now.

2 Likes

Thank you for linking me here :slight_smile:

Thnx for taking over and maintaining sheets :partying_face:

1 Like

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

5.xx fort planner automatically updates

wheres that?

Thank you very much for picking this up.

1 Like

Thanks Zami :+1:

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.

1 Like

Thank you :heart: :heart:

1 Like

looks great, thank you!

Thank you for picking up the hosting of these resources.

1 Like

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!

Thank you

I noticed the same.

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

2 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.

2 Likes