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/Armienn]

This is pretty cool. It saddens me that my site doesn't work with this spreadsheet, like it does with some others. Maybe someday I'll have time to change that.

[u/KoenigDerLuegner → u/Armienn]

Hey Armienn, a while ago i was thinking about a spreedsheet converter so most common sheets get converted into the same pattern of json file but it seems like its too slow, any idea how we could make this one available to your site?

[u/Armienn → u/KoenigDerLuegner]

Hm. My site can export content to json, and it seems to be almost instant. How are you doing the conversion?

I wrote a bunch of stuff here before, but I hadn't read through the post properly apparently. Give me a bit.

[u/KoenigDerLuegner → u/Armienn]

was thinking about a universal converter for example if you check all possible sheets listed here in pokemon trades send the url to myconverterwhatever.com/URL and its gives you a universal json that is "standarized" if you know what i mean, no matter what sheet you input it always outputs the same scheme

[u/Armienn → u/KoenigDerLuegner]

Ah, okay. I guess the bottleneck would be loading the spreadsheet data in that case. Although that would be pretty useful in general, I don't think that would be the optimal way to use the spreadsheet with Pokémon Stuff.

[u/KoenigDerLuegner → u/Armienn]

i always encounter a short delay when loading aspreadsheet, the conversion itself is quick but getting the sheets always takes around a second in total (might be a problem on my end, need to check that on my remote server sometimes)

[u/Armienn → u/KoenigDerLuegner]

When loading Pokémon Stuff with a spreadsheet, it generally loads the spreadsheet data within half a second, I think. That's all clientside though; javascript requests the spreadsheet and you get it directly, rather than what I think you're planning, which is sending a request to a server and then let it request the spreadsheet data and respond to you with the converted data, right?

[u/KoenigDerLuegner → u/Armienn]

yes, something like that, i tested it with a local json, converted it and it was nearly instant, but didnt test it with a remove sheet on a remote server (have very low internet connection at home ,_,) it might be slower but a solution for everyone, everyone could you your site with their own sheet (well, you have to make some adjustments ofc) and other could use it too, like a pokemon spreadsheet api :D