alaeth wrote: Great work Kcman! Care to go into more detail on how you calculated the per level offsets? I'm wondering if we can take one of the "known" 3* lookups (such as the third one) and apply the same math to populate the new ones fully The 3* ones are a lot worse. Based on the update (here), and characters that were not changed, there are now 12 distinctly unique HP lookups for 3* characters. fun times! The majority of the "original" ones stayed, but a bunch of new ones were added... so there's nothing populated except the 166 "max" right now: sorting all the 3* by max health I came up with: 1 - (no chg) The Hood 2 - (no chg) Loki 3 - (no chg) Daken, Wolverine 4 - (new) Storm 5 - (previously 4) - Iron Fist 6 - (new) GSBW, Falcon, Torch, Mystique 7 - (previously 5)- Beast, Blade, Daredevil, Deadpool, DocOc, Kamala, Mag, Psyloke, Punisher, QuickSilver, ScarletWitch, Spidey, Squirrely 8 - (new) Cyclops 9 - (new) B.Panther, CapAm, CapMarv, DocDoom, Gamora, IM40, LukeCage 10 - (previously 7 or 6?) - Thor 11 - (new) Colossus, Rags, Grocket, Sentry, She-Hulk 12 - (previously 8) - Hulk IM Hulkbuster is on my sheet, but I won't be offended if you don't copy it due to issues with the HP lookups now. Forgot to mention, I also re-did the 4* that changed. I don't think anything got dropped, but a few HP lookups did shift.
alaeth wrote: Updated mine (has Vision as well). The new numbers are a tiny bit off... Checking with a fairly under-leveled character (GSBW): Current level: 69 level max: 140 in-game ISO to level: 55,256 spreadsheet ISO to level: 55,465@evanberstein: looks like your 4* ISO numbers are still the original ones, so I populated mine with Happy's
DCUDCU wrote: Nobody has added Wilson Fisk yet to the sheet. I would, but I don't know the secrets of the the MPQ roster tracker.
DukeUpdate wrote: I added him after Ares. I know that when I type in the name now I have to note that he is out of order, but you only have to do it once, and then it all worked out. Not elegant, but an easy work around.
DukeUpdate wrote: Yes it would work. I sort them differently (I like to have them sorted the same way that they are sorted under "Roster" in-game), but you can certainly sort them the way you suggest.
Ebolamonkey84 wrote: I use alaeth's version of the spreadsheet, and I've run into problems when adding Ant-Man. He is the new alphabetically first character, and when I added a row above Ares, all of the formulas still only used the range from Ares row down. Is there a way to add a new row on top that will include it in the range being used for formulas? Or an easy way to change all those formulas en masse? I'm also having issues getting the third column to pull in version for him.