EnPluzz - Elioty's Data vault (and tools to come at some point in the future)

mrchief · January 4, 2024, 1:51pm

Can you also add which ones of these have a Bonus Chest? Usually it’s the 3000 and above ones but I can’t remember if any 2600 ones break pattern.

Elioty33 · January 4, 2024, 3:38pm

Yes, I can probably give some information on the bonus chests too.

CrazyChemist3891 · January 12, 2024, 11:27am

@Elioty33 when you extract the heroes, could you add their special text, which describes what it does? I saw the names of each special in your tables, and in ancient times (S1 only) same name meant same special. But nowadays there are so many changes and differences between them, that having a reference would be totally cool!

Elioty33 · January 12, 2024, 11:48am

That’s one of the things I need to do but it’s extremely complex the way special skills are scripted in the game’s data. I will do it eventually one day.

Ufeel · January 12, 2024, 12:40pm

If you dont mind, i integrate @Elioty33 hero stat data with HeroPlan data, so that almost heroes have some special skill as well as passive text (but may not 100% accurate due to HeroPlan team manual work).

It is in a CSV file here (update approx. Once a month)

github.com

ratthachat/heroplan_streamlit/blob/main/heroes_ep_extra.csv

name,color,star,class,speed,power,attack,defense,health,skill,effects,passives,types,source,family,image,costume_id,dot_string,total_dot_damage,n_turns,dot_damage_per_turn,max_special_percent,min_special_percent,max_special_stat_percent,min_special_stat_percent,Title,Costume,Museum,Element,Rarity,Origin,Family,Release date,Class,Mana Speed,Special Skill,Passive #1,Passive #2,Passive #3,Passive #CB1,Aether Power,Max level: Attack,Max level: Defense,Max level: Health,Max level: Power,Limit Break #1: Attack,Limit Break #1: Defense,Limit Break #1: Health,Limit Break #1: Power,Limit Break #2: Attack,Limit Break #2: Defense,Limit Break #2: Health,Limit Break #2: Power,Mana Bonus CB1,Max level CB1: Attack,Max level CB1: Defense,Max level CB1: Health,Max level CB1: Power,Limit Break CB1 #1: Attack,Limit Break CB1 #1: Defense,Limit Break CB1 #1: Health,Limit Break CB1 #1: Power,Limit Break CB1 #2: Attack,Limit Break CB1 #2: Defense,Limit Break CB1 #2: Health,Limit Break CB1 #2: Power,Mana Bonus CB2,Max level CB2: Attack,Max level CB2: Defense,Max level CB2: Health,Max level CB2: Power,Limit Break CB2 #1: Attack,Limit Break CB2 #1: Defense,Limit Break CB2 #1: Health,Limit Break CB2 #1: Power,Limit Break CB2 #2: Attack,Limit Break CB2 #2: Defense,Limit Break CB2 #2: Health,Limit Break CB2 #2: Power,Mana Bonus CB3,Max level CB3: Attack,Max level CB3: Defense,Max level CB3: Health,Max level CB3: Power,Limit Break CB3 #1: Attack,Limit Break CB3 #1: Defense,Limit Break CB3 #1: Health,Limit Break CB3 #1: Power,Limit Break CB3 #2: Attack,Limit Break CB3 #2: Defense,Limit Break CB3 #2: Health,Limit Break CB3 #2: Power
Bane,yellow,3,Monk,Fast,440,469,410,693,Harmonic Slam,"['Deals 300% damage to the target', 'The target gets -35% accuracy for 4 turns. Chance to miss also applies to offensive Special Skills.']",0,"['Hit 1', 'Blind']",Season1,Classic,https://i.imgur.com/9aCbPHu.jpg,0,,0,0,0.0,300,300,-35,-35,Noble Defender,0.0,822.0,Holy,3,Classic,Classic Family,,Monk,Fast,Harmonic Slam,,,,,Attack Up,469,410,693,440,531.0,464.0,786.0,490.0,657.0,574.0,971.0,591.0,5%,492.0,430.0,762.0,464.0,557.0,487.0,864.0,517.0,689.0,602.0,1068.0,624.0,,,,,,,,,,,,,,,,,,,,,,,,,,
Bane C,yellow,3,Ranger,Fast,464,529,423,682,Harmonic Bash,"['Deals 280% damage to the target', 'The target gets -40% accuracy for 4 turns. Chance to miss also applies to offensive Special Skills.']",0,"['Hit 1', 'Blind']",Season1,Classic,https://i.imgur.com/oMyq8FB.jpg,1,,0,0,0.0,280,280,-40,-40,Noble Brawler,1.0,823.0,Holy,3,Classic,Classic Family,2020-01-01T07:00:00,Ranger,Fast,Harmonic Bash,,,,,Special Boost,504,403,620,441,571.0,457.0,703.0,491.0,705.0,564.0,868.0,591.0,5%,529.0,423.0,682.0,464.0,599.0,479.0,773.0,516.0,740.0,592.0,954.0,623.0,,,,,,,,,,,,,,,,,,,,,,,,,,
Dawa,yellow,3,Rogue,Average,440,488,391,679,Leaping Attack,['Deals 210% damage to the target and minor damage to nearby enemies'],0,['Hit 3'],Season1,Classic,https://i.imgur.com/p1FG8Av.jpg,0,,0,0,0.0,210,210,0,0,Ranger of Shaguad,0.0,824.0,Holy,3,Classic,Classic Family,,Rogue,Average,Leaping Attack,,,,,Dodge,488,391,679,440,553.0,443.0,770.0,490.0,683.0,547.0,951.0,590.0,5%,512.0,410.0,746.0,463.0,580.0,465.0,847.0,516.0,717.0,574.0,1046.0,623.0,,,,,,,,,,,,,,,,,,,,,,,,,,
Dawa C,yellow,3,Barbarian,Average,463,527,423,684,Pounding Attack,"['Deals 200% damage to the target', 'Deals 230% damage to a random different enemy. Deals extra damage to the target if the target is Dark.']",0,['Hit 1'],Season1,Classic,https://i.imgur.com/4JD88JW.jpg,1,,0,0,0.0,230,200,0,0,Shaguadian Guardian,1.0,825.0,Holy,3,Classic,Classic Family,2021-01-18T07:00:00,Barbarian,Average,Pounding Attack,,,,,Rage,502,403,622,440,569.0,457.0,705.0,490.0,703.0,564.0,871.0,590.0,5%,527.0,423.0,684.0,463.0,597.0,479.0,775.0,516.0,738.0,592.0,958.0,623.0,,,,,,,,,,,,,,,,,,,,,,,,,,
Kailani,yellow,3,Cleric,Slow,444,429,453,729,Spirit Link,"['All allies become Soul Connected for 5 turns. Soul Connected allies share received damage.', 'All allies get +63% defense for 5 turns.']",0,"['Ally Damage Share', 'Defense Buff']",Season1,Classic,https://i.imgur.com/h7fAkgX.jpg,0,,0,0,0.0,0,0,63,63,Selfless Healer,0.0,826.0,Holy,3,Classic,Classic Family,,Cleric,Slow,Spirit Link,,,,,Special Armor,429,453,729,444,486.0,514.0,827.0,494.0,601.0,635.0,1022.0,596.0,5%,450.0,475.0,801.0,467.0,510.0,539.0,909.0,521.0,631.0,666.0,1124.0,629.0,,,,,,,,,,,,,,,,,,,,,,,,,,
Kailani C,yellow,3,Sorcerer,Slow,467,423,497,825,Spirit Rally,"['All allies become Soul Connected for 5 turns. Soul Connected allies share received damage.', 'All allies get +50% attack for 5 turns']",0,['Attack Buff'],Season1,Classic,https://i.imgur.com/OOF8ysq.jpg,1,,0,0,0.0,0,0,50,50,Magnanimous Mender,1.0,827.0,Holy,3,Classic,Classic Family,2021-01-18T07:00:00,Sorcerer,Slow,Spirit Rally,,,,,Defense Up,403,474,750,443,457.0,537.0,851.0,494.0,564.0,664.0,1051.0,595.0,5%,423.0,497.0,825.0,467.0,479.0,563.0,936.0,521.0,592.0,697.0,1156.0,629.0,,,,,,,,,,,,,,,,,,,,,,,,,,
Paeia,yellow,3,Cleric,Very Slow

This file has been truncated. show original

There is also web interface version here.
(Click on team-simulation tab, not filtering tab)

u2371 · February 3, 2024, 12:54pm

@Elioty33 Could you make the cell of mobs detail wider in the spreadsheet ?

Elioty33 · February 3, 2024, 1:56pm

No, I cannot because it’s only CSV. Maximum portability but you need to make a copy on your computer or in your GDrive and widen the columns, put filters, etc as you like with your favourite spreadsheet app (be it Excel, Libre Office Calc, Sheet, etc)

StroopwafelJack · February 3, 2024, 3:06pm

Any news on dragon soul changes?

Also why do they not have all legendary troops available in the portal? That’s just bad business sense!

mogulemon · February 9, 2024, 8:03am

Hei elioty i forgot where do i can find upcoming fated summon prediction list, hope you can always list your prediction in this thread also for easier search

Elioty33 · February 9, 2024, 9:32am

Hey, they are part of my event predictions in the calendar threads. You have a link at the bottom of the second post of each calendar threads. But indeed, I should list them in the OP of this thread too. Will do it over the weekend

mogulemon · February 9, 2024, 12:49pm

I think soul exchange and fated summon prediction list should be displayed on this main thread (first or second post) as it is important for easier search

Toebelix · March 4, 2024, 7:31am

Which is the best best level for xp in season 5 during dunes? (like 10-10 normal in season 4) thank you

alonyor · March 7, 2024, 6:39pm

10-10
Last level of 6 flags

Elioty33 · April 1, 2024, 10:07pm

Hey everyone,

Today’s my forum anniversary so here’s some teaser of what I’m working on in my very thin free time (which is already used quite a lot for the never-ending calendar updates). Keep in mind this is a very early draft (and I’m really good with algorithms but not so much with UI and UX haha and I know one important thing is missing: the hero’s talent classes). I plan on having filtering and sorting options of course but for the troop view, I already find it to be wholly better than the in-game bonkers troop sorting (the missing “prioritize team” toggle setting in the barrack view is the main raison it is so bad).
There will be a little tool to upload your roster, troops, teams, items and more with a single click. However, it will work only on PC when playing with an Android emulator (at least BlueStacks 5, and probably MEmuPlay and NoxPlayer). It would require rooting your device to let have an application be able to retrieve your game save file directly from your physical device but I cannot advise anyone to root their device unless they are actual tech savvy and know what they are doing. This might be ToS borderline but I hope staff will accept it as a community-effort and since I, in no way, plan to modify the save file to attempt cheating or anything, just take a readonly snapshot of it.

I also plan to have a hero database accessible through this website (just like the CSV files I already provide in my data vault but with a shiny UI) with builtin filtering and sorting options of course and a quest and map season database (again just like the CSV files I already provide in my data vault). And probably more later on (custom teams building, talent grid simulator on the hero from the database or from your roster).

But first, I hope to be able to lay the foundation and host a first/early version with at least the hero database and to share it on GitHub (just the website itself, I don’t plan on sharing my tools to extract the data from the game files, again, this one would be even more ToS borderline) for very much needed and appreciated contribution from anyone willing to help. I’m using the Django web framework (in Python 3) and Bootstrap (CSS) for the web design. I haven’t added any javascript in yet but it will certainly use the jQuery framework.

What do you guys think? What should be the top priority in this big project?
I know many people will come to think of the resemblance of this to HeroPlan, I cannot deny the main goal is similar, if not at least the same but in my opinion actually a superset. Also, HeroPlan (the actual website’s backend, not the data itself) is sadly not maintained anymore and is lacking on the costume side and (maybe, I don’t actually use but I believe so) on the legendary troops.

Happy gaming, and enjoy having a look at my roster all you want, this is the state of my roster a few weeks ago.

Junim · April 1, 2024, 10:47pm

Exceptional tool!
The fact that you don’t have to register your heroes manually helps a lot.
If you need a guinea pig, I can apply. lol

StroopwafelJack · April 2, 2024, 8:47pm

I see Madhammer, where’s the other one?

I don’t have android and wouldn’t root it, but it looks cool!

Elioty33 · April 2, 2024, 11:48pm

Sadly, she came alone since… She came from last Black Friday, not the Goblin Summon

Anmar · April 3, 2024, 12:28pm

hi Elioty Very nice work and project!! super interesting because indeed heroplan is not compatible with all costume versions… leniver has a lot of trouble listing all the heroes on the screens… it’s very interesting. Sorting heroes is more logical as you suggest. I would like to test on PC

Nynaeve_alMeara · April 6, 2024, 6:59pm

awesome work !!

as you knw, i’m retired from the game.

please tell me if it’d be convenient for you if i share any work i made.

Badkins · April 20, 2024, 10:10pm

Amazing work! Thank you - thank you!!
I’ve shared this post with others and you’re compilations are so helpful. I will watch for any new updates on the next phase that you’re creating (oh I wish I had the brain of a developer!).
Again, thank you!

Topic		Replies	Views
Summon Simulator Spreadsheet Player Guides heroes , summons , guides , pulls	64	6655	January 4, 2021
Coppersky - The search for minions! Player Guides	9	3018	April 14, 2018
E&P Data Bible Player Guides	28	24602	January 7, 2019
Hero Database Player Guides heroes , guides , search	6	1701	July 17, 2020
Where to farm in s5? Player Guides	2	1223	January 15, 2024

EnPluzz - Elioty's Data vault (and tools to come at some point in the future)

Related topics