Stats Sortable List

Here is an excel spreadsheet that is fully filterable and sortable. You can organize by monster number (from the Monstagram), monster name, rarity, elemental types, books, relics, and stats (power, life, and speed). I've also added the trait or immunity each monster has. You'll need a recent version of Excel to run the macros properly (and may need to Enable Editing and then Enable Macros when you first load up the spreadsheet). If you find they don't work, just download the imageless version (at the bottom of this post) and use advanced filtering (described below).

HOW TO USE THE SPREADSHEET
To filter, simply click the image of the rarity, element, book, or relic you want to see. To clear a filter, just click the corresponding button to clear that particular filter. To clear all filters, just click the clear all filters button on the far right (you may get an error message if the filters are already cleared). The filters are additive: you'll see monsters that have ALL the items you've selected, click as many as you want! Only rarity and relic filters allow you select one at the time. If you notice all the extra columns on the right, leave them alone: that's where the magic is.

ADVANCED FILTERING
For advanced filtering, click the arrow at the top column to filter, move down to Text Filters, then select "Contains..." This will open a pop up window where you can type the word you want shown (e.g.- fire, female, trap, etc.). It's not case sensitive. If you want to do a little more advance filtering (like filtering all water/thunder monsters), in that box that popped up, click the radio button for "And", hit the drop-down box right below it, click "contains" and type the second term you're looking for. If you want, for example, to see all monsters in Dragons and all monsters in Underworld (not just those in both), click that "Or" radio button. If you need any help navigating the filters, feel free to post on here and let me know.

SKILLS
For the skills, I only pulled from skill groups 2 and 3 (for legendaries), since skill group 1 is pointless 99% of the time (I know there are rare exceptions, so feel free to shout out any you think might need to be included). If an effect has only 50% chance of hitting, I haven't included it. I only included stamina drain skills that sap 50% or more of an enemy's stamina (so, I haven't included Stamina Leak or an attack that drains 25% stamina, for example). This should help you in narrowing down where to put your speed runes. At the present time, skills data is only available for legendaries and mythics.

SELECT
On each sheet, there is a column labelled "Select". Use this column to compare particular monsters with each other. Or use it to keep track of monsters you own. If you type in an 'x' (without the quotes), the star icon at the top will automatically filter this column.

DAMAGE CALCULATOR
The second tab at the bottom is a damage calculator. The highest powered attacks for legendaries/mythics should help you decide where to focus your strength runes.

Only legendaries and mythics are in this list, as you're not likely using another rarity to attack with. One of the many factors in damage calculation is your monster's level compared to the defending monster's level. As my stats are intended to help you decide which monster to choose (compared to other monsters) this formula assumes both you and the defender are level 100. The sheet already has the monster's base power and highest attack value filled it. If you want to know the damage output of any skill, just plug in that damage value of that skill instead.

There are other damage modifiers there as well after you get the base damage. Element Damage refers to a regular attack (1), strong (1.5) or weak (0.5) attack, or some other kind of elemental weakness like sticky lava, light weakness, etc. (1.8). The options there are fixed so just select the one that applies. Attack modifiers are for things like damage boost (1.5), double damage (2), or triple damage (3). Again, the numbers there are fixed and, if normal damage, just leave 1. For runes, add up your total strength rune bonuses and convert it to a decimal (move the decimal point over two places). The formula will take care of the rest.

MISCELLANEOUS INFO
Don't just view it in your browser (it'll look awful and won't be interactive). Be sure to download it.

Stats Sortable List

If you see anything needing fixing, let me know! The link in this post will always have the latest version. Hope this helps everyone!

Thank you for sharing. FYI, Harusami and Arcade are not adjusted for the stat correction/buff removal. And Kulkan's speed should be 3201 not 2301.

@sansot Awesome, thank you for sharing!

@darthmason Updated, thanks! New version with corrections to Arcade, Harusami, and Kulkan is up.
Also, I think those last two columns get all out of sorts when you filter and sort the other columns, so just ignore those.

Big update to the spreadsheet: added traits/immunities and fixed highest damage attacks for all legendaries. Updating original post with details.

Thanks !

You're the hero we needed but don't deserved

Amazing work @sansot hope you keep it updated

i pinned it too

Thanks guys! I intend to keep updating it. Like I said, it might not be with every single new event but I usually don't let more than 2 events go by without updating. I like knowing who my best options are too!

Any other stat areas y'all think might be helpful? No promises (each new column and category understandably takes a long time to get filled in), but I can try.

I am confused. So where is the latest list of all monsters with best skills then? Thanks.

I don't think there is any. We should unlock the master move list. I think I have avcuired about 10 legendary monsters recently that are not in the list yet.

@Frunobulax said in Monster Stats Sortable List:

I don't think there is any. We should unlock the master move list. I think I have avcuired about 10 legendary monsters recently that are not in the list yet.

The original poster from the list from the old forums stated he wanted to continue the list so until he does and starts a new list the old list will remain locked.

@Bleu7 This list is designed to help sort the stats of monsters to compare strength, life, and speed (and a few other things). It's not a recommendation of what moves to choose.

Just updated to include everything new through the Slavic Tales event.

@sansot All right, thanks sir for responding. It would be nice if there was such a list of all the monsters best skills list. Take care

Major update to the list. I've updated the original post, but here's what's new.

I have now included a column for books (a now necessary filter given the dungeons and team wars we're getting). Because many monsters are in more than 1 book and the way Excel handles things, it's difficult to just have the drop down list to find all the monsters for the book you're looking for. HERE'S WHAT TO DO: Click the arrow to open the drop down menu on books. Instead of manually selecting with the checkboxes, go down to "Text Filters..." and then click "Contains". In the new window that pops up, type in the book you're looking for and hit "Ok" or press enter. Then it'll filter all the monsters in that book.

HOW TO USE THE DAMAGE CALCULATOR:
Only legendaries are in this list, as you're not likely using another rarity to attack with. One of the many factors in damage calculation is your monster's level compared to the defending monster's level. As my stats are intended to help you decide which monster to choose (compared to other monsters) this formula assumes both you and the defender are level 100. The sheet already has the monster's base power and highest attack value filled it. You may not be running that skill, so feel free to plug in your own attack value in this column.

There are other damage modifiers there as well after you get the base damage. Element Damage refers to a regular attack (1), strong (1.5) or weak (0.5) attack, or some other kind of elemental weakness like sticky lava, light weakness, etc. (1.8). The options there are fixed so just select the one that applies. Attack modifiers are for things like damage boost (1.5), double damage (2), or triple damage (3). Again, the numbers there are fixed and if normal damage just leave 1. For runes, add up your total strength rune bonuses and convert it to a decimal (move the decimal point over two place). The formula will take care of the rest.

I got the formulation during a discussion on this thread:
https://forums.socialpointgames.com/topic/855/who-is-arguably-the-best-monster-for-dealing-huge-damage-in-one-hit

Nice work Sansot

btw can you change the link to the xlsx file directly instead of the zipped one
it will make things easier i think but not a big deal

Nice work again

Thanks. Afraid not. If I upload the file directly into my Google Drive, Google converts it for use in Google Docs and will strip it of its filters, which defeats the whole purpose of the thing.

@sansot

Strange ! cause i use your file on google sheets on line
So i download your zip , extract it and upload to my google drive and use google sheets to open it online,, and every thing works fine !

@Haka-Taka All the filtering works, not just sorting? What about the book filtering (which takes a little extra because of monsters being in multiple books)?

@sansot said in Monster Stats Sortable List:

@Haka-Taka All the filtering works, not just sorting? What about the book filtering (which takes a little extra because of monsters being in multiple books)?

Hi , sorry for my late reply but yes every thing and filtering works great with google sheet , here is a sample of sea filter

@Haka-Taka If I recall correctly, on Google Drive, the issue comes in with sharing. When the document is shared and anyone can edit it, the sorting and filters still work. But if you restrict who can edit, it removes the sorting and filtering for the person who can view it.

Update:

New link. Instead of my Google Drive, this one is Dropbox. So, no more .zip files to unpack. To use the sorting and filtering, you will need to download the file, don't just view it in your browser, it won't do any good there! Revised the element types into a single column. Just use a custom text filter (like with the books) to find the element you're looking for. Added the latest monsters through Ukuduma. Updated books with the latest additions (Good Legions and Evil Legions pages, Superheroes, and Families).

Update:
Nothing really substantive changed, however, you'll notice the spreadsheet file is now 100x larger because it now has graphics! Mouse over a monster's name to view a picture of that monster. Instead of the individual word for rarity being listed, it now has the actual rarity symbol (the words are just behind the graphics). Similarly, the elemental Type AND Books columns now have the symbols instead of the words (again, the words are just behind the graphics, colored white; sorting and filtering is unchanged). What do y'all think? Does it overload the senses or do you find it easier? Be warned that if you start messing with column widths, you will be skewing the images in that column. Lastly, I slapped the VIP graphic next to the names of the VIP monsters.

I considered putting in the images for the trait/immunity, but that didn't seem super necessary (especially since some, like Mountain, would still require a text explanation). Finally, I do intend to put in images in the columns for the various denial attacks (to represent single and AoE). But we'll see (I'd have to create one).

UPDATE:
Added new monsters through the Monstershore Island event. Also added a nemesis graphic next to the nemesis monster names, like I did for the VIP monsters.

Hey been trying to find the formula for figuring out the damage a monster will do with a given skill. I am unable to find the spreadsheet you speak of and the only pic available is blurry. Tried going to old forum where you got your info but its not there anymore. So can you tell me what the formula is? Also, if not apparent, where to find each value in the formula. Thanks.

@SideShow said in Monster Stats Sortable List:

Hey been trying to find the formula for figuring out the damage a monster will do with a given skill. I am unable to find the spreadsheet you speak of and the only pic available is blurry. Tried going to old forum where you got your info but its not there anymore. So can you tell me what the formula is? Also, if not apparent, where to find each value in the formula. Thanks.

The link to the sheet is in the 1st post , her it is
https://www.dropbox.com/s/w0dzeh9kpmbdm3b/Monster Legends Stats.xlsx?dl=0

It is xlsx file which you will have to download it and open it

All right got the spreadsheet nice word. Lots of good monster info. I saw the damage calculator and the values that you have calculated but I'm looking for a little bit more. I want to be able to look at any monster and pic any skill and calculate the damage it will do. What is the formula you used to figure this out? I understand that there are multiple variables involved such as buffs, debuffs, and elemental weakness. This I believe I can figure out. I'm looking for the formula to calculate damage assuming same lvl and no elemental weakness/strength modifiers. The base formula. Again if values are not obvious (monster power, skill str, ect) please specify where to find the information, if able.

@SideShow

Did you read this topic
https://forums.socialpointgames.com/topic/855/who-is-arguably-the-best-monster-for-dealing-huge-damage-in-one-hit/3

@Haka-Taka that is exactly what I was looking for thanks.

UPDATE:
Added the new books (as well as the new Undead monsters that were added) and added the latest monster additions.

@SideShow Additionally, if you know the skill you're wanting to see the damage output for, just plug that number in and replace the value I've got in there (in either the AoE Power or Single Power columns). Refer to the monster wiki for the power values of each attack.

Updated with the latest Eldritch Abomination island monsters and Warthak.

Big update today. New monsters added through Nishant's Bodyguard and also updated the new book additions.

@sansot You deserve a great big THANK YOU !!

This is great! When will it be updated again?

Soon. I'd have it done already, but my computer is dying on me. Should have a new one next week, then I can update it.

Updated list through Oikawa.

Updated through Cloud. Also corrected a couple mistakes in the books column. Lastly, swapped out the book images for what's on the Wiki, which I like better than the screenshot crops I used to have.

Pretty big update today. New monsters added, relics added, and put denial skills on their own tab.

Updated this evening with new monsters and fixed a couple minor errors. Winter book is also added, although the graphic isn't there yet, you CAN sort by the Winter book. Lastly, I removed all the monster images from the comments. Given the amount of images already in the spreadsheet and its size, the thing just loads and saves a lot faster without those pictures.

@sansot Thanks for your amazing work!

Minor update. Added Baron Traitor and Cryotan. Also added images for the Winter Book.

Updated through Nuclear Winter. Merry Christmas everybody!

Thanks @sansot for this amazing work

@Haka-Taka wow you put alot of time in thanks

This is a great idea. Have you thought of putting it in a Google spreadsheet instead of Excel so it's easier to update? You could also approve other people to help update it.

Minor tweaks. More importantly, updated through most recent monster additions.

@Boris Sure have! That was one of my first attempts. You might have missed this discussion earlier in the thread, but the only way to make a Google Spreadsheet work so that its filter and sort functions work is to make it fully editable to the public. In other words, if it's protected so that the general public cannot edit it, it will not sort or filter. Which is kind of the point! So that's not a viable option.

My VERY first goal was to create a site to have all of this online. Just a link to bookmark with a fully sortable and filterable table. So you wouldn't have to go into the Custom Filter part of the filter menu in Excel, just type it in.
Unfortunately, I know little about website making, even less about Javascript, and nothing about Access (which appear to be the go-to methods of making such a thing).

Actually, I think making all this an Access database and making a user-friendly, read-only web application for accessing it would probably be ideal. I've tinkered around with macros, command buttons, VBA, and few other things, but there doesn't seem to be a simple solution for how I'd ideally like this thing to look.

My ideal layout would have rarity, elemental type, book, relics, and possibly trait NOT in the table with the other stats, but slightly separated. You'd click on the fire image and it would automatically filter to just the fire types. You'd click dark and it would filter to just fire and dark types. You'd click either of those again and it would unfilter that element. Same with rarities, books, and the other filters. I'm not a fan of the user-interface of currently filtering things, but it's all I've got at my disposal!

If someone around here had such knowledge and skill, I'd be MORE than happy to work with them on making (and keeping up to date) said site/database.

Thanks for keeping this amazing work going

Big update today. Added some missing stats that were just released. Even bigger, I've redone the skills sheet. I added relics to it, in case you wanted that as an additional filter. More importantly, I've separated out various denial skills (like mega stun, mega freeze, cooldowns activated, etc.) and added a few more effects: evasion, extra turns, and mirror mirror.

Anyone see a particular need to include any other skills to the spreadsheet? Torture effects like burn, bleed, or nightmares? Good effects like regeneration, healing, and shields? Debuffs and damage modifiers? Thoughts anyone?

@sansot very user friendly very understandable 10 thumbs up