I was planning on making a thread for this earlier but never had the time/patience for it. So here's a little background for what this is. Just make a copy of the spreadsheet in the file menu to change it yourself.
Link to spreadsheet
Let's start with some simple 'What it does' and 'What it doesn't do' for the spreadsheet in regards to the CAP process as a whole - and why I spent the time to make the damn thing in the first place.
What it does:
How to use it
This spreadsheet really, really hand-holdy. Just enter your typing in the yellow box and it'll update itself. Just add a new Pokemon in the OUTypeList page at the bottom and the rest of the sheet will update itself.
How checks and counters are defined
A Pokemon is considered a check against CAP's Typing if the following is true:
Okay. So that about wraps up me spewing out 'hey how do you use this' part of the post. Let's get to the next section of the post, the 'hey why did you make this' part.
So why did I spend like, 3 days making a spreadsheet that a lot of people will probably just not even bother using? Here's the simple reason - I'm lazy. I don't like doing this stuff by hand. Also, spreadsheets are cool.
Here's the long reason - Typing Discussion is right off the bat one of the most complicated parts of the CAP process. It arguably is the most important part of the whole project, and deserves a godamn spreadsheet. Do you know how hard it is to figure out what type is good for a project without missing like 3-4 different things that the type has that actually set the concept farther back? Well, if you've been around for a project or two you do and you should. This spreadsheet is supposed to help with just that - getting past the gunk that comes with typing discussion. So, now if you remember to consider Keldeo, Thundurus, and Skarmory, you won't forget to consider the other 90% of the metagame! Yay! Pretty great, huh?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Now I don't think I've forgotten to dump anything else in this post - and I'll do my best to answer any questions anyone has about the spreadsheet. Also, if you have anything else you want me add to the spreadsheet, I can do that. This is how I spend my free time apparently so if there's something that's worth adding, I'll do it. Furthermore, if you find a bug, tell me. If you find a typo, tell me. That's about it. Happy Spreadsheeting!
Link to spreadsheet
Let's start with some simple 'What it does' and 'What it doesn't do' for the spreadsheet in regards to the CAP process as a whole - and why I spent the time to make the damn thing in the first place.
What it does:
- Takes the type you want to look at and pulls up a list of resistances and weaknesses to every pokemon in the OU metagame.
- Further compiles a list of potential checks and counters based on typing. How I defined a check or counter based on typing is below this section.
- Allows for extra entries in to the OU list - if you think Dunsparce is a massive threat in OU, you can add that.
- Allows for extra type immunity abilities in the same manner - This mostly is irrelevant but it's there, so that's nice. Wonder Guard is special and doesn't exist.
- Factor in anything that doesn't directly relate to typing. If it isn't a pokemon type, this spreadsheet doesn't care about it.
- Have the power of game knowledge. Even though it SAYS Gengar checks a Grass/Dragon, it doesn't know that Gengar has the defenses of a garden gnome. Therefore, it's best used in conjunction with other references (Like your brain)
How to use it
This spreadsheet really, really hand-holdy. Just enter your typing in the yellow box and it'll update itself. Just add a new Pokemon in the OUTypeList page at the bottom and the rest of the sheet will update itself.
How checks and counters are defined
A Pokemon is considered a check against CAP's Typing if the following is true:
- The Pokemon resists one of CAP's STABs.
- The Pokemon has a super effective STAB against CAP.
- The Pokemon counters CAP.
- The Pokemon resists both of CAP's STABs.
- The Pokemon has at least one neutrally effective STAB against CAP.
Okay. So that about wraps up me spewing out 'hey how do you use this' part of the post. Let's get to the next section of the post, the 'hey why did you make this' part.
So why did I spend like, 3 days making a spreadsheet that a lot of people will probably just not even bother using? Here's the simple reason - I'm lazy. I don't like doing this stuff by hand. Also, spreadsheets are cool.
Here's the long reason - Typing Discussion is right off the bat one of the most complicated parts of the CAP process. It arguably is the most important part of the whole project, and deserves a godamn spreadsheet. Do you know how hard it is to figure out what type is good for a project without missing like 3-4 different things that the type has that actually set the concept farther back? Well, if you've been around for a project or two you do and you should. This spreadsheet is supposed to help with just that - getting past the gunk that comes with typing discussion. So, now if you remember to consider Keldeo, Thundurus, and Skarmory, you won't forget to consider the other 90% of the metagame! Yay! Pretty great, huh?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Now I don't think I've forgotten to dump anything else in this post - and I'll do my best to answer any questions anyone has about the spreadsheet. Also, if you have anything else you want me add to the spreadsheet, I can do that. This is how I spend my free time apparently so if there's something that's worth adding, I'll do it. Furthermore, if you find a bug, tell me. If you find a typo, tell me. That's about it. Happy Spreadsheeting!
Last edited: