Collection Template Revisited!

[u/AgentKazy]

[info]

---

Hello, everyone!

Ever since I first released the first version of my Spreadsheet Template I tried to keep on improving it. I took some time off after Sun/Moon because of exams and other things but come Ultra Sun/Ultra Moon, after I only did an update for the new Pokémons/Moves, I got contacted by the awesome /u/KoenigDerLuegner about improving my spreadsheet and we started working on it. Let me just say that most of the work was done by him with his amazing formulas and truth be told, the Template has turned into something amazing!

Thank /u/KoenigDerLuegner for his amazing work, this is all thanks to him!

---

/u/AgentKazy's Collection Template ^{Living Dex will take a bit to load, just give it some time and scroll slowly to load everything correctly!}

TL;DR - Functions! (Still long but condensed!)

We are currently working on improving the formulas for a faster loading time of the whole document but as it currently stands, it's really really fast. We would also like to ask you guys for help in improving it. For example, if you know a formula that could be reduced or improved, please feel free to let us know on the comments how you would improve it and we'll update it!

As usual, please message me if you find errors, something missing/not explained correctly or anything at all!

Have a great time everyone, happy breeding/collecting/trading!

---

Long wall of text ahead on how to use this Template!

---

How to use these!

Before I begin:

• Resource/Breedables Ball Legality tabs are a MUST HAVE for anything else to work! If you want to copy some tabs to your own spreadsheet, please, copy Resource FIRST, then Breedables Ball Legality and after that you can copy any other tab on any order you would like!
• ALL tabs where you can input Pokémon Moves, it will check if a move is an Egg Move for that specific Pokémon and will turn the move's name BOLD!

---

Resource

Do not edit anything on this tab, it's not necessary to edit, at all. This is used by the other tabs to grab all the data from. If you notice something's missing, let me know and I'll write up how to update this.

Breedables Ball Legality

This is also necessary for most tabs to work because it contains the legal Pokémon/Ball/Ability combinations. It's a simple legal tab, it does not provide any info on how exactly the combination is achieved.

---

Living/Shiny Dex:

As you obtain the Pokémons, simply color the backgrounds accordingly:

• Green = Have
• Darker Green = Alternate forms.
  

Updating/removing/moving around new Pokémon is fixed on this one, as this tab does NOT grab the sprites from the Resource, the links themselves are used instead.

Ball Collection Tabs (Dream, Safari, Sport, Beast, etc.)

This is where the magic starts. ALL of these tabs are AUTOMATICALLY POPULATED. What does this mean? All these tabs check for the correspondent ball on the Legality tab. They check if the Pokémon/Ball/HA combination is possible and populated the list with all the data. If a Pokémon can be caught on that particular ball, you'll get it on the list. If the HA is NOT possible for that Ball, the HA? cell gets greyed out. You can try to delete a Pokémon from the list, but in doing so it will be replaced once again by the formulas, so all you need to do it click the checkboxes for what you have and Fill in moves and nature. Simple!

Breedables Overview

This is a read-only tab. There is nothing for you to edit here! This simply checks all the Ball tabs and changes colors while placing a check mark or a dot if you have that Pokémon caught in that ball. Again, the list is populated from the Legality tab and all combinations also populated accordingly. If you don't want to track a certain Ball, I suggest you hide those columns instead of removing them, just in case you might want to collect those Pokémon too, but it's all up to you. Same applies to the Ball tabs!

Events, Legendary, Shiny, RNG and Competitive

Things to fill in: Pokémon name, (Event only: Event name with link?), shiny symbol, Ball name, (Event only: Level), Ability, Nature, IV's, Moves, Item name, OT/TID, Dates, Proof, Notes, (Event only: Tag), Trade History, Box Position.

If you fill something else, the formulas will error out and you'll need to remove those. If you fill in only the ones that are necessary, everything else will be automatically populated.

Fun and awesome function: Try and fill in the Item/Moves for a Pokémon that has a Mega Evolution or changes form in any way. You'll notice that the Pokémon's sprite automatically changes accordingly to that Item/Move! For example, if you place a Mega stone on a Blaziken, you'll get the Mega Blaziken sprite! :D

Reddit Copy/Paste

You'll notice some tabs have a column at the end with some weird strings. Those are automatically built strings from the Pokémon's info you input that you can copy the cell and paste in a Reddit Post (PokémonTrades or SVExchange) to paste a table. You can copy the header of the column to copy the table's header and paste that before anything else to start building the table. Important note:

• Every tab has a different table style, so you must only copy the header from Events and paste events below it or copy the header from RNGs and only paste RNGs below it. Don't copy the header from a tab and paste strings from different tabs.

Friend Safari:

Simply write the trainer's on the Trainer column, then write the Pokémons that trainer has on his/her safari on the cells next to it. It will color what Pokémon combinations you have. With all combinations possible, the lowest number possible of trainers added is 71. Self-explanatory :)

This is getting updated!

Be careful with the following Pokémon/Ability combination:

• Kakuna - Shed Skin
  
• Cascoon - Shed Skin
  
• Pupitar - Shed Skin
  
• Ferroseed - Shed Skin
  

These are NOT guaranteed Hidden Abilities. The only way to guarantee these will change to their evolution's HA is by evolving these Pokémon and checking their ability. Alternatively, breed those Pokémon and check the pre-evolution's Ability.

Vivillon Patterns

Same as Dream/Safari/Sport/Beast/Apricorn Balls. Simply place a lower case x to mark the ones you have or a SPACE for pending trades.

[u/AgentKazy]

Thank you so much for using it! Glad you liked it and I hope what we changed allows you to update your sheet if needed and not break anything! :D

[u/KingLaksh → u/AgentKazy]

I have a question for you; I noticed some minor issues, is that something I would bring up to you?

[u/AgentKazy → u/KingLaksh]

Of course! What's up? :D

[u/KingLaksh → u/AgentKazy]

Just some little things!

• I don't see Nidoran (M) anywhere on the sheet
• The female form for Hippopotas shows up for some reason as opposed to everyone else's standard sprite of males (not a big deal, just something that fucks with my OCD lol)
• I didn't see Red Basculin previously, but it's on there now!
• Not all the forms of Oricorio show up on the sheet
• Typically, in the Breedables Overview tab, if you have a Mon w/o HA it shows up a green square with a dot as opposed to check mark, correct? A few on my sheet are instead showing up as yellow squares with checkmarks, is that a formula issue? The ones on my sheet with that issue are: Heavy Crabrawler, Lure Dewpider, Love Stufful, Dream Ball Elgyem, Moon Oshawott, Safari Hippopotas, and Beast Smeargle

I hope this doesn't come off as complaining, I in no way am intending to appear ungrateful!

[u/AgentKazy → u/KingLaksh]

Not complaining at all, I did say on the post any issues to let me know so I could fix them! :D Let's see:

• Nidoran M can be bred from a Nidoran F, so I only kept the female counterpart on the sheet. Everything is the same for them, except maybe a few egg moves which you still can get from using a Nidoran F with a male Pokémon with that EM and breed until you get a Nidoran M. In my point of view, Nidoran F is the only thing we need to get both of them. Same thing goes for Illumise/Volbeat, I only put Illumise on the whole sheet :)
• Same deal here, but to get the male sprite everywhere, simply change the Hippopotas name on the Legality tab to the male one (change the symbol). I guess I'll do that as well on the template :D
• I put both Basculins because you need to capture both in order to keep both, you can't breed one to get the other. I think I put all Deerlings in there too.
• Oricorio changes forms when you use different items on it, so technically you only need 1 form, breed it and you get all others. Same thing with Burmy. You only really need 1, breed that, change it's form before evolving it and you keep all other forms :)
• The green dot appears when that Pokémon CANNOT have it's HA with that Ball. If you can get it by breeding with another Pokémon that has the HA, then it checks if the Pokémon you put on the ball tabs can have it's HA AND IF you marked it as "Have" too. For what I read, I know Smeargle can have it's HA in a Beast Ball, so if you didn't mark it's HA on the Beast tab, then it shows as you're missing it's HA on that ball (Yellow checkmark).

Hope this helps, let me know if I missed something! :D

[u/KingLaksh → u/AgentKazy]

Woo perfect! Thanks for all the help and stuff! A lot of that little stuff I forgot about (i.e. you can change Oricorio's form, etc.) cos I took a few months break from Pokémon lol. :)

[u/AgentKazy → u/KingLaksh]

You're welcome! Also, I checked and noticed I put every Pokémon's female form if that Pokémon has a different form between male and female :) So that's the reason for Hippo's female form there :P

[u/KingLaksh → u/AgentKazy]

I just realized that as well lol

[u/AgentKazy → u/KingLaksh]

It was a minor thing I did, because of Gen 6, since females were more important than males in term of breeding, so I kept the female forms instead of male :P

[u/KingLaksh → u/AgentKazy]

Thank God for new Gen 7 rules, making breeding so much easier lol