Daily Discussion & Question Thread for 10 November 2018

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.

/r/pokemontrades Thread