1. Welcome to Smogon! Check out the Smogon Starters Hangout for everything you need to know about starting out in the community. Don't forget to introduce yourself in the Introduction and Hangout Thread, too!
  2. Welcome to Smogon Forums! Please take a minute to read the rules.

Pokemon Type Coverage (Excel Sheet) - NEW! Version 2.2 using December Stats!

Discussion in 'Archives' started by X-Act, Aug 17, 2008.

  1. Potential

    Potential

    Joined:
    Oct 12, 2008
    Messages:
    116
    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.
  2. CardsOfTheHeart

    CardsOfTheHeart

    Joined:
    Aug 21, 2007
    Messages:
    1,970
    It's just a .zip file. 7-Zip or WinRAR should be able to open/extract it with no problem.

    Once you extract it, you end up with a .xls file that OpenOffice should have no trouble opening--at least I have no trouble opening it with 3.0.
  3. kangaraptor

    kangaraptor

    Joined:
    Oct 8, 2007
    Messages:
    5
    I don't see Hyper Beam or its variations on the list of moves. Did you program it that way?
  4. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    Yes, I didn't include them.
  5. Potential

    Potential

    Joined:
    Oct 12, 2008
    Messages:
    116
    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.
  6. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    After receiving further feedback, I implemented Tyranitar's Sand Stream, Lati@s' Soul Dew and Clamperl's DeepSeaScale Special Defense boosts in the latest 1.2.2 version.
  7. Binabik

    Binabik

    Joined:
    Apr 5, 2007
    Messages:
    285
    amazing :D
    cb snorlax:
    98,52% because selfdestruct+crunch ohko everything but skarmory/spiritomb xD
  8. Bungalow Bill

    Bungalow Bill

    Joined:
    Sep 2, 2008
    Messages:
    429
    Payback wasn't on the list. Could you add it?
  9. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    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:

    [​IMG]

    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.
  10. Deck Knight

    Deck Knight Photorealistic Seagull (PSG)
    is a Forum Moderatoris a CAP Contributoris a Smogon Media Contributor
    Moderator

    Joined:
    May 27, 2005
    Messages:
    7,592
    I could not find Giga Impact, Hyper Beam, or Giga Drain in the Attack List.
  11. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    I implemented lots of new moves, including those mentioned by Deck Knight and oldsteel12.
  12. A$AP DARKY

    A$AP DARKY mfw i see alison brie
    is a member of the Site Staffis a Smogon Social Media Contributoris a Smogon IRC AOPis a Super Moderatoris a CAP Contributor Alumnusis a Contributor Alumnusis a Smogon Media Contributor Alumnusis a Battle Server Moderator Alumnus
    Super Moderator

    Joined:
    Dec 25, 2005
    Messages:
    6,189
    whoa that feature is sweet.
  13. jagged_angel

    jagged_angel

    Joined:
    Aug 29, 2007
    Messages:
    776
    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 :-)
  14. 1234gjy

    1234gjy

    Joined:
    Aug 3, 2008
    Messages:
    365
    Awsome!
    It's so great.
  15. cim

    cim happiness is such hard work
    is a Smogon Media Contributor Alumnus

    Joined:
    Jun 3, 2007
    Messages:
    5,412
    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)
  16. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    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.
  17. darthminer

    darthminer

    Joined:
    Dec 6, 2008
    Messages:
    15
    Quick question, how does Fake-Out work in this whole amazingly, spectacularly and stupendously awesome thing?
  18. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    Unfortunately, for now it works as if you have any other Normal Physical 40-power move.
  19. darthminer

    darthminer

    Joined:
    Dec 6, 2008
    Messages:
    15
    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?
  20. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    Accuracy and flinch isn't factored yet. For the lowest damage part, it's the maximum damage (ironically) that the moveset can deal to that Pokemon.
  21. Blue Kirby

    Blue Kirby Never back down.
    is a Tutor Alumnusis a Site Staff Alumnusis a Battle Server Admin Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Contributor Alumnusis a Smogon Media Contributor Alumnusis an Administrator Alumnusis a Past SPL + WCoP Winner

    Joined:
    Nov 1, 2007
    Messages:
    2,837
    This is truly awesome, thanks a lot for your hard work X-Act.

    I can see me using this very frequently.
  22. X-Act

    X-Act np: Biffy Clyro - Shock Shock
    is a Site Staff Alumnusis a Programmer Alumnusis a Smogon IRC SOp Alumnusis a Researcher Alumnusis a CAP Contributor Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Feb 17, 2006
    Messages:
    4,675
    I've just updated this Excel sheet to Version 2.2. It now uses Doug's December stats instead of the October ones. :) Redownload for the latest version. Enjoy!
  23. Not Scicky

    Not Scicky

    Joined:
    Jun 30, 2007
    Messages:
    2,310
    Is there any way to factor in Scizors Tech'd Bullet Punch =/?

    Edit: Nevermind, magnet bomb works just fine as a substitution for it...
  24. MagicMaster87

    MagicMaster87

    Joined:
    Nov 24, 2008
    Messages:
    1,182
    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...

  25. A$AP DARKY

    A$AP DARKY mfw i see alison brie
    is a member of the Site Staffis a Smogon Social Media Contributoris a Smogon IRC AOPis a Super Moderatoris a CAP Contributor Alumnusis a Contributor Alumnusis a Smogon Media Contributor Alumnusis a Battle Server Moderator Alumnus
    Super Moderator

    Joined:
    Dec 25, 2005
    Messages:
    6,189
    could add lati@s without soul dew for OU use?

Users Viewing Thread (Users: 0, Guests: 0)