Mechengg's Spreadsheet Vault


#1

Welcome to Mechengg’s Spreadsheet Vault!

Figured i’d get a collection going for my various spreadsheets that i have started for data pulls and analysis. I’ll keep adding to this list as more get populated. Eventually all of this will end up on WDGeeks.info however due to our workloads i figured this may be an easy-ish interm solution to getting the information out for people to use.

As always if you find any incorrect information, or would like any explanations as to what i’ve done/why i’ve done things a certain way feel free to comment below, but please keep it constructive instead of just trolling for the hell of it :sunglasses:

Probably worth noting, many of these spreadsheets have multiple tabs, remember to check them all out for all of the information

~Mech


Miscellaneous Game Spreadsheets
Zeppelin Mission Table


Event Spreadsheets
Minor Event Prizes
Breeding
Feeding
Fortification

Major Event Prizes
Kingdom Wars
Fight Pits
Team Gauntlet
Temple Raid

Team Prizes
Team Achievement Prizes (All events, check tabs)
Final Prizes (All events, check tabs)
Team Quest Prizes (team and individual & strategies)

Chest Drop %'s
Chest Drop Rates

Event Information
Team Gauntlet Information
Kingdom Wars Information

Downloadable Worksheets
Fortification Planner [download link, fill out your own info]


Atlas Spreadsheets
Information Tables
Rider Leveling Information
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 own info]
Rider Gear Worksheet [download link, fill out your own info]
Crafting Gear Analysis [download link, fill out your own info]



Important Threads to find everything you need
Better Timers Drops in Breeding or PVP?
Mechengg's Rider Gear Worksheet
Fort chest drops
Does anyone know the gold cost for each lvl of primarchs upgrades?
Dragon Manager (Info Site)
Looking for various upgrade costs (element) of atlas def gear from this and last season
Gold chests, breeding tokens percent
How does the seasonal egg boost work/is it worth?
Gold Chest drop percentages 🐌
Worst Gold Chests ever
New Event, just wow!
What exactly does mythic hunter/warrrior buff mean
War Dragons trivia ... what lil nuggets of info do you know? 🤓
Infrastructure Bonus per level
Atlas: Beginner/Basic Posters for Line Chats
This week's event is....BREEDING (July 4th)
Sigil drops reduced
Beasts Hunting Power
Can E2P get Mythic first Wave without money?
Can E2P get Mythic first Wave without money?
How long does it take to max your base with L75 Towers?
Issues with the Egg Token Bonus and Chest Drops
Event Cadence Changes Official Discussion Thread
Version 4.92 Release Notes Official Discussion Thread
The First Duskfall Season Rider - Portia, The Iron Maiden
Fortification Team Prize Tiers
Discussion DuskFall Season Line Prices(keep it constructive and on topic)
Duskfall season first 2 weeks Event
#2

You are amazing Mechengg :heart_eyes::kissing_heart::kissing_heart:
Thank you for sharing these incredible resources.


#3

I’ve shared some of them before, they just reside buried way deep down in posts somewhere so i thought a clear concise location for them all to be found easily would be a nice change :slight_smile:


#4

:heart_eyes::heart_eyes::heart_eyes:
(Well, I’ll get a forum ban if not abbreviating it…)


#5

bookmarked that shit


#6

Someday there would be “rider mating event prizes” page then we spend speed up to reduce the pregnant time


#7

You are the man!

( my inner nerd loves spreadsheets :smile: )


#8

Awesome! You’ve saved me a ton of work. Thanks!


#9

#10

:heart_eyes: so much beauty in one place. We don’t deserve you :sob:


#11

One day I hope to have a single page I can link to instead of having to maintain my own list of resources. This is close :joy:


#12

Yaaaas. You are the best Mech. <3


#13

Based on feedback from a few individuals including @Morreion I have done a bit of tweaking to the drop rate spreadsheet.

  1. Added a cover page with a snapshot look at all of the averages for both gold and bronze.
  2. Added way more items to the averages including PvP items & resources (pearl/ember/shards)

Let me know your thoughts and opinions on this change and if you like it or not.


#14

This is awesome! Thanks!


#15

Team Gauntlet Data on Chest Drop % chart updated


#16

Nice! A lot more mystic fragments in the golds than I realised. Puts the pvp gold chests closer to the breeding ones than I thought, for breeding progression…


#17

If you ignore all the other items that help with even progression like food packs during breed or energy during PvP and you value 1 mystic frag at 200 egg tokens, you get around 23% more egg tokens combined (in raw tokens and mystic frags) during breeding event than you would get during Team Gaunlet.


#18

I believe breeding gives the most tokens and the second most timers. It is a no brainer to open gold during breeds.


#19

but maybe the ruby and token rewards during pvps may offset that a bit for grinders.
I do agree i didn’t do the math though, feeling a bit lazy.
I am not a convinced fan of opening chests during breeding somehow. :sweat_smile:


#20

Yes, that’s why I said “if you ignore all other items”.
If you can/want to grind, PvP may be better but I also didn’t do the math yet.

I switch a lot between opening during breed and PvP, as long as I’m on track with breeding and don’t meet a bottleneck or a huge cost for some mythic, I stick to PvP so I can contribute to my team in energy events.
I’m level capped for Harbs anyway so no need for me to open during breed right now. When I was in Sapphire, Garnet and Emerald I loved opening during breed events.