This may be a bad question; if it is, I apologize. Anyway, I have OpenOffice and it seems to be only opening this with "Microsoft Excel Viewer," so I can't edit anything, i.e. I can't input stats/moves. How do I get around this? Do I need special unzipping software (I have a feeling that's a really stupid question) or something else? I can't foretell getting the actual Microsoft Excel anytime soon, and I don't have the power or money to do so, either.
-
Welcome to Smogon! Take a moment to read the Introduction to Smogon for a run-down on everything Smogon, and make sure you take some time to read the global rules.
-
Congrats to the winners of the 2023 Smog Awards!
Pokemon Type Coverage (Excel Sheet) - NEW! Version 2.2 using December Stats!
- Thread starter X-Act
- Start date
I don't see Hyper Beam or its variations on the list of moves. Did you program it that way?
AWESOME! Now that I figured out how to get it to work...
I had to copy and paste, since I can only view Excel Spreadsheets with my program (I can't edit). Then, I had to fix all of the "$#REF!" errors. To do that, I had to figure out how you made this, X-Act.
Once I did figure it all out (the thing that perplexed me at first was the VLOOKUP command), I found out how awesome this thing is. You really know how to work spreadsheets! Yeah, I'm more impressed by the spreadsheet itself, but it really is awesome (that's the 3rd time I've used that word in this post, but it is fitting), and it helped me learn to use spreadsheets a lot better. It wouldn't be quite so useful to me, since I like to play defensively (not quite stall, but rather my own mixture), but it is nice all the same.
Thanks a bunch! And awesome (there's #4) work and awesome (there's #5) effort!
One question: is it possible to make a drop-down menu? How would you do it (i.e. what command), since it doesn't have that for me?
EDIT: Ah, I found it. Look here for OpenOffice and here for Excel.
I had to copy and paste, since I can only view Excel Spreadsheets with my program (I can't edit). Then, I had to fix all of the "$#REF!" errors. To do that, I had to figure out how you made this, X-Act.
Once I did figure it all out (the thing that perplexed me at first was the VLOOKUP command), I found out how awesome this thing is. You really know how to work spreadsheets! Yeah, I'm more impressed by the spreadsheet itself, but it really is awesome (that's the 3rd time I've used that word in this post, but it is fitting), and it helped me learn to use spreadsheets a lot better. It wouldn't be quite so useful to me, since I like to play defensively (not quite stall, but rather my own mixture), but it is nice all the same.
Thanks a bunch! And awesome (there's #4) work and awesome (there's #5) effort!
One question: is it possible to make a drop-down menu? How would you do it (i.e. what command), since it doesn't have that for me?
EDIT: Ah, I found it. Look here for OpenOffice and here for Excel.
Payback wasn't on the list. Could you add it?
I've implemented Version 2.0 of this sheet. Now, besides the average damage dealt, you can also see the 9 Pokemon that take the least amount of damage from your moveset.
For example, here's which Pokemon take the least damage from the MixMence set:
Seems like Heatproof Bronzong is the best switch-in to MixMence, then.
Simply redownload the ZIP file for this latest version.
By the way, it still uses October's stats. I'll update it with December's stats once they are released.
For example, here's which Pokemon take the least damage from the MixMence set:
Seems like Heatproof Bronzong is the best switch-in to MixMence, then.
Simply redownload the ZIP file for this latest version.
By the way, it still uses October's stats. I'll update it with December's stats once they are released.
I could not find Giga Impact, Hyper Beam, or Giga Drain in the Attack List.
Can't believe I only just discovered this. X-Act, you are a shiny legendary.
As a side compliment, your real name is pretty cool too :-)
As a side compliment, your real name is pretty cool too :-)
What EVs are assumed for "least damage"?
Anyway, this app is unbelieveably helpful for finding paper counters to things. Choice Band Flygon has only a handful of paper counters! Skarmory, Hippowdon, Tangrowth, and Cresselia are the only things the app says always win with no residual damage (though Donphan has Ice Shard)
Anyway, this app is unbelieveably helpful for finding paper counters to things. Choice Band Flygon has only a handful of paper counters! Skarmory, Hippowdon, Tangrowth, and Cresselia are the only things the app says always win with no residual damage (though Donphan has Ice Shard)
Defense EVs (and abilities) are the average EVs and abilities used in October as per Doug's stats.
I'll update the Excel sheet when the January stats are released.
Quick question, how does Fake-Out work in this whole amazingly, spectacularly and stupendously awesome thing?
Does this also factor in Accuracy and flinch rates for non-Fake Out moves? Also on the lowest damage part, is that average, max or lowest damage?
This is truly awesome, thanks a lot for your hard work X-Act.
I can see me using this very frequently.
I can see me using this very frequently.
Is there any way to factor in Scizors Tech'd Bullet Punch =/?
Edit: Nevermind, magnet bomb works just fine as a substitution for it...
Edit: Nevermind, magnet bomb works just fine as a substitution for it...
Truly an amazing program. I'll definitely be using this often in the future.
On a different note, I don't know if you've been told already or not, but it seems one of the pictures in the first post isn't loading anymore. I've tried refreshing several times, so I don't believe it's just me, as all the other pictures are loading. The missing picture in question is right here...
On a different note, I don't know if you've been told already or not, but it seems one of the pictures in the first post isn't loading anymore. I've tried refreshing several times, so I don't believe it's just me, as all the other pictures are loading. The missing picture in question is right here...
Finally, we'll add Thunderbolt and HP Ice by choosing them from the boxes next to Move 3 and Move 4 respectively. Our Gengar would be able to deal an average of...
That's very good damage indeed.
