Hello, all! I would like some help testing a spreadsheet template!
I tried to optimize the template by /u/Knightinkodes. If you're using that template, and you'd like to try a potentially faster sheet, please check it out here:
Packrats optimized draft of the /u/Knightinkodes template
I would like to know if there are any bugs!
Here's a small list of the changes I made. It may or may not be complete:
LegalityChart
Switched positions of the "Dex #" and "Pokémon" columns
Resource
Switched positions of the "Dex #" and "Pokémon" columns
Resorted sheet by "Dex #" (ascending), then by "Pokémon" (ascending)
All sheets:
Adjusted refs to Resource!A:x to Resource!B:x
and adjusted column index return values from COLUMN() to COLUMN()-1
Summary sheets
Changed Ability and Ball Legality VLOOKUP to return multiple columns
Individual ball sheets
Changed column ordering and VLOOKUP return cols to reduce VLOOKUP calls
Changed VLOOKUP to Sorted=True and key to a pseudo compound key
Simplified HA-checking formula
Breedables/Shinies/Competitive/Legendaries/Events
Changed Ability and Egg Move VLOOKUP to return multiple columns
I wonder if all the time spent adjusting the sheet after changing Resource was worth it! I wanted to get a pseudo compound key search on Dex# and Pokemon across all 27 of the individual ball sheets, and I couldn't think of a better way to do it. I guess I could have returned a filtered view like so: "{Resource!B:B,Resource!A:A,Resource!C:Z}", but I don't know how efficient that is.