I cut my ISO debt by 25% using this one weird trick
Comments
-
DFiPL wrote:FierceKiwi wrote:Why are you manually updating ISO costs? Most people have their sheets automatically modify the costs when they adjust the level.
I am not l33t enough with spreadsheet magic to figure out how to get the ISO column to automatically recalculate ISO costs when I increment the level. Or, rather, I know of a way to do it, but it's suuuuuuch a kludge. It's been easier for me to just manually type the level in one column and then adjust the named range that calculates ISO by removing a cell (or more, as necessary) from that range when I add levels.
And because anymore I'm going from 130 to 166 or 125 to 166, that means the ISO need is getting zeroed out when I add levels, so there hasn't been the urgency to figure out how to get the ISO column to automatically update with changes.
This sounds incredibly complicated and full of chances for whoopsness. Here's the sheet that I'm using with the appropriate Excel magic:
0 -
DFiPL wrote:mpqr7 wrote:The formulas include:
=sum(J$130:J$269)-D2
Which means the character is Level 130, so it's the sum of all ISO needed between levels 131 and 270, minus any ISO I have already accumulated.
With you so far, and that's basically what I'm doing. Except what I'm doing is naming a range after the character, with that range comprising the ISO from 130 or 125 to 166 for 3*, and from wherever they are to 270 for 4*. then I just have to go =SUM(SheHulk) or something to link it back to the main spreadsheet. That keeps my main page cleaner and makes it less of a headache for me linking pages.=B2+12500
Which means the total to Level 270, plus the 12500 ISO cost to champion.
Don't do this, but I should; I always forget about champion costs.
My spreadsheet has three worksheets that are relevant for this. One is the roster list: name, covers, level, status (dupe, fully covered, optimally covered, TU, champion). The second is ISO costs per level, based on rarity. The third is a list of rarities, with their max level and champion cost.
The formulas for ISO spent and ISO left are fairly complicated, but based on lookups (google 'excel vlookup' for details) into the other two worksheets. So everything is automatically updated when I change the level. Or change status to Champion. Took me half an hour to an hour to debug each of them.0 -
amusingfoo1 wrote:My spreadsheet has three worksheets that are relevant for this. One is the roster list: name, covers, level, status (dupe, fully covered, optimally covered, TU, champion). The second is ISO costs per level, based on rarity. The third is a list of rarities, with their max level and champion cost.
The formulas for ISO spent and ISO left are fairly complicated, but based on lookups (google 'excel vlookup' for details) into the other two worksheets. So everything is automatically updated when I change the level. Or change status to Champion. Took me half an hour to an hour to debug each of them.
My first worksheet has the roster in one column, levels in the next (X/Y where X is current level and Y is the highest level the character could achieve), the ISO needed to reach the character's current level cap in the third, and the final three columns are devoted to covers in the relevant power, so I can see at a glance what the build is.
Second worksheet has the ISO per level so I can create a range for each character and then name it (as previously discussed), so that that named range feeds the "ISO needed" column and I don't run the risk of having the wrong argument in a given cell.
I do that twice, once for 3* and once for 4*, but when I have the time/boredom, I may consolidate those.0 -
jobob wrote:Quebbster wrote:Vhailorx wrote:Quebbster wrote:I don't have an ISO debt. I spend it when I have it, not before.
You sure Quebbster? Admitting you have a problem with iso debt is the first step to treating your iso addiction. . .0 -
I expect to be firmly back in the ISO middle class since I just championed my last eligible 3* and my closest 4* is Ant-Man at 11 covers (but I need exactly two blue).0
-
aesthetocyst wrote:I was hoping the trick was going to be selling characters....
That is exactly what popped into my head when I read the thread title.0 -
i use this one weird trick called vlookup MS Excel function so that the ISO needed for each char updates automatically when I update the char's level.
SMH0 -
Link to said ISO spreadsheet?0
Categories
- All Categories
- 44.8K Marvel Puzzle Quest
- 1.5K MPQ News and Announcements
- 20.3K MPQ General Discussion
- 3K MPQ Tips and Guides
- 2K MPQ Character Discussion
- 171 MPQ Supports Discussion
- 2.5K MPQ Events, Tournaments, and Missions
- 2.8K MPQ Alliances
- 6.3K MPQ Suggestions and Feedback
- 6.2K MPQ Bugs and Technical Issues
- 13.6K Magic: The Gathering - Puzzle Quest
- 508 MtGPQ News & Announcements
- 5.4K MtGPQ General Discussion
- 99 MtGPQ Tips & Guides
- 424 MtGPQ Deck Strategy & Planeswalker Discussion
- 299 MtGPQ Events
- 60 MtGPQ Coalitions
- 1.2K MtGPQ Suggestions & Feedback
- 5.7K MtGPQ Bugs & Technical Issues
- 548 Other 505 Go Inc. Games
- 21 Puzzle Quest: The Legend Returns
- 5 Adventure Gnome
- 6 Word Designer: Country Home
- 381 Other Games
- 142 General Discussion
- 239 Off Topic
- 7 505 Go Inc. Forum Rules
- 7 Forum Rules and Site Announcements