1. New to the forums? Check out our Mentorship Program!
    Our mentors will answer your questions and help you become a part of the community!
  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. Mekkah

    Mekkah
    is a Super Moderatoris a Tutor Alumnusis a Site Staff Alumnusis a Smogon IRC SOp Alumnusis a CAP Contributor Alumnusis a Smogon Media Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus
    Super Moderator

    Joined:
    Feb 8, 2005
    Messages:
    14,036
    Something like L100 +6 Atk Defense Curled Rollout with a Choice Band Tricked on, on a L1 -6 Delibird/Shedinja. Shedinja for the highest % damage, Delibird for actual damage.
  2. Jenigmat

    Jenigmat

    Joined:
    Oct 29, 2007
    Messages:
    769
  3. acinod

    acinod

    Joined:
    Aug 27, 2007
    Messages:
    799
    i'm taking about average damage as in percentage

    if you try the program
    the last box in the excel file is average damage
    i'm talking about that one.
  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
    I know. Nobody knows the maximum percentage.
  5. MustBeEmo

    MustBeEmo

    Joined:
    Sep 6, 2008
    Messages:
    156
    WHen i go to input something it doesnt let me. Help?
  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
    What version of Microsoft Excel do you have?
  7. Jumpman16

    Jumpman16 np: Michael Jackson - "Mon in the Mirror" (DW mix)
    is a Smogon IRC SOPis a Site Staff Alumnusis a Team Rater Alumnusis a Battle Server Admin Alumnusis a Researcher Alumnusis a Tiering Contributor Alumnusis a Contributor Alumnusis an Administrator Alumnus

    Joined:
    Dec 19, 2004
    Messages:
    4,763
    thought i posted here when i stumbled upon this three weeks ago but this may be the single most powerful tool we have in objectively assessing whether a pokemon is uber or ou, it's that good
  8. 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 updated this Excel sheet to include Doug's most recent stats, and tweaked a few more things to make it return an even more accurate percentage damage.
  9. ace15

    ace15

    Joined:
    Jun 26, 2007
    Messages:
    1,317
    Woah, this is amazing.. awesome work X-act!
  10. Bourbon

    Bourbon

    Joined:
    Sep 10, 2007
    Messages:
    3,047
    So what movesets have the best type coverage?

    So far I've gotten as high as 98.79% average damage with a Focus Punch / Overheat / Thunderbolt / HP Ice Magmortar. A Salamence with Outrage, Earthquake, Fire Blast gets 88%. Adamant Choice Band Garchomp gets over 106%.
  11. Darth Meanie

    Darth Meanie

    Joined:
    Jan 22, 2008
    Messages:
    580
    Head Smash / Earthquake / Fire Punch / Focus Punch Rampardos gets some pretty good coverage

    98% good

    of course you'll never see that set, but Stone Edge / Earthquake / Fire Punch / Superpower still does 92.4 %

    I am asking though what the number actually means. If it is 100% does that mean it OHKO's everyone?

    Edit: with choice band it would be 100.97% with the second set, but it tells me I can't put in 706 attack stat so I'm not sure if that's right
  12. Jaroku

    Jaroku

    Joined:
    Aug 20, 2007
    Messages:
    59
    This looks really really cool. I am having a problem though. I save as the file and then open it but it gives me a read only file with the stats of all the pokemon. How do I get the file where I can input the pokemon and moves and such?
  13. 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 updated the Excel sheet yet again today. I had the incorrect usages of Pokemon having two different abilities, which made the average damage slightly higher than how it should have been. Apologies for any inconvenience.

    Please redownload again for the latest version. This should finally work correctly.

    The latest version also fixes Jaroku's problem.
  14. Jaroku

    Jaroku

    Joined:
    Aug 20, 2007
    Messages:
    59
    Wow thanks X-Act this is amazing! It works for me now.
  15. crystalvelox

    crystalvelox

    Joined:
    Sep 17, 2008
    Messages:
    30
    Just a quick question. When entering in the attack stat, what multipliers do you have to put in when you type the number?

    For example, say I wanted to see which did more average damage between Platinum's Dance-Orb Scizor vs. Platinum's Choice Band Scizor? Do I keep the number the same 394 for both or do you input the number for what the attack stat would be after choice band and life orb/ swords dance multipliers?
  16. MetaNite

    MetaNite
    is a Team Rater Alumnus

    Joined:
    May 4, 2008
    Messages:
    1,510
    This looks very cool. For some reason when I download it I can't open it, because I need to know what created it.

    Or, even when I double click on the boxes nothing happens... Anybody know a way to fix this?
  17. Ranz

    Ranz

    Joined:
    Aug 8, 2008
    Messages:
    243
    Dark Pulse + Focus Blast/HP fighting. aint that good?

    or Night Slash/Brick Break(Weavile meh).
  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
    First of all, if the average damage is 100%, it means that it OHKOes everything. Version 1.2 overcalculated the damage resulting in the percentage sometimes exceeding 100%. This has been fixed in version 1.2.1.

    If you want Dance-Orb Scizor, you type in Scizor's attack x 2 x 1.3 and then the three attacks. If you want Choice Band Scizor, you type in Scizor's attack x 1.5 and then the four attacks.

    Just remember that Dance-orb Scizor would reach that type coverage after one turn of stat-up.

    I don't understand. Which Excel version do you have?
  19. MetaNite

    MetaNite
    is a Team Rater Alumnus

    Joined:
    May 4, 2008
    Messages:
    1,510
    I don't know if I even have Excel, but I must since I can at least open it. I think I have 2003, is that too old?

    Oh, and thanks.
  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
    My Excel version is also 2003, so yours should work.
  21. dr4g0n

    dr4g0n

    Joined:
    Mar 3, 2008
    Messages:
    96
    X-Act is GOD. This is AWESOME!!!
  22. crystalvelox

    crystalvelox

    Joined:
    Sep 17, 2008
    Messages:
    30
    Yeah, I know about taking into consideration the prestat-up results too. I was just using that as an example.

    Alright so for the Dance Orb even though I am typing in "1024" for the attack stat it still comes up with an entry is invalid. I get the average percentage, but it does not stay up. That supposed to happen? I have Excel 2007 and your most recent verison of this.
  23. CardsOfTheHeart

    CardsOfTheHeart

    Joined:
    Aug 21, 2007
    Messages:
    1,970
    That's normal. The Data Validation in those cells only allows whole numbers from 1 to 999 as opposed to just allowing whole numbers greater than 0.
  24. 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
    Actually I'm going to fix that, since the attack and special attack stats can go way beyond the current maximum allowed by the excel sheet.
  25. 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 have just fixed the maximum attack and special attack allowed in the Excel sheet. Redownload it for the latest version.

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