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. 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
    No it doesn't... yet.

    But it does take into account Thick Fat, Wonder Guard, Solid Rock, Filter, Volt Absorb, Water Absorb, Flash Fire, Levitate, Heat Proof and Dry Skin when calculating the damage against Pokemon that have them. It also takes into account the ratio of Pokemon having one ability or the other (for example, it takes into account that there are more Levitate Bronzong than Heat Proof ones).
  2. RBG

    RBG But I keep cruising, can't stop, won't stop grooving.
    is a Smogon Social Media Contributoris a Super Moderatoris a Site Staff Alumnusis a Smogon IRC AOp Alumnusis a Researcher Alumnusis a Tiering Contributor Alumnusis a Battle Server Moderator Alumnus
    Facebook Manager

    Joined:
    Jan 27, 2008
    Messages:
    3,350
    would it be possible to make a move element type, physical or special, and BP input for a move or 2?

    for example Technician Hidden Powers, Reversal,

    also, does it use weight for grass knot/low kick?
  3. Syprus

    Syprus

    Joined:
    May 21, 2008
    Messages:
    353
    Really sweet! Awesome job.
  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
    You mean to invent your own move (let's say Hidden Power Grass with 90 BP or Eruption with 60 BP) to use it in the calculation? I think that can be managed.

    Yes it does.
  5. 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
    Please download the new version, as the old version overcalculated the damage dealt. The new version fixes this, and also has Rock Smash and Spacial Rend. It is also available in a ZIP file now.
  6. Too_Hungry35

    Too_Hungry35

    Joined:
    May 8, 2007
    Messages:
    2,675
    When I try to type in the Attack stat, it won't let me. Help please?
  7. 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
    It's probably either too high or too low. What number are you typing?
  8. Too_Hungry35

    Too_Hungry35

    Joined:
    May 8, 2007
    Messages:
    2,675
    Well, I wanted to see how an Adamant Swampert would be in the standard metagame, so I inputted its types and four moves. But when it came to the attack stats, I wasn't able to input any number in. I wanted to type in 350 in its attack stat. I also tried doing your Gengar example, but I also wasn't able to input its special attack stat.
  9. Aldaron

    Aldaron All da lil birdies chirpin
    is a Tournament Directoris a Battle Server Administratoris a Smogon IRC SOPis a Tiering Contributoris a Contributor to Smogonis an Administrator
    OU and IRC Leader

    Joined:
    Aug 5, 2007
    Messages:
    4,440
    You are double clicking right. You need to double click the box to be able to enter information there.

    Or you could click on the box once and go up to the formula box and enter it right there.
  10. Too_Hungry35

    Too_Hungry35

    Joined:
    May 8, 2007
    Messages:
    2,675
    Yes, I also tried to double click the box and then input the number. I also tried clicking it once and using the box at the top to change the number, but still, nothing seems to happen?
  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
    You're pressing ENTER after inputting the number right?

    What Excel version do you have?
  12. thetorsoboy

    thetorsoboy

    Joined:
    Mar 15, 2008
    Messages:
    2,304
    Very awesome. ^-^

    I can now say that this works in Excel '97. :P
  13. Too_Hungry35

    Too_Hungry35

    Joined:
    May 8, 2007
    Messages:
    2,675
    Yes, I've tried pressing enter after inputting the numbers. My Excel version is 2003. But it seems that I have found the problem now, but I'm not too quite sure if it is the specific problem. When I try to open Microsoft Excel, it says that my Excel has been expired? Could that be the reason why? If it was expired, shouldn't I have not been able to use it when I opened the file?
  14. 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
    Well, I have Excel 2003 just like you and it works fine for me. So maybe it's really its expiration that's the problem.

    You could maybe download OpenOffice to fix the problem (and to have a non-expiring version of Office).
  15. ARx1000

    ARx1000

    Joined:
    Jul 6, 2008
    Messages:
    11
    Platinum update?

    This thing is awesome and it would be sad for it not to be updated =\
  16. Not Scicky

    Not Scicky

    Joined:
    Jun 30, 2007
    Messages:
    2,310
    Uhhh, you might want to change this what with garchomp being in uber now, ice and dragon type moves could be miscalculated :3

    Uhhh, there's nothing to update :S

    It's not

    Select a pokemon, then select what moves it can learn

    it's

    Select any two types, select any 4 moves and see what damage is dealt...
  17. CHENN

    CHENN

    Joined:
    Aug 30, 2008
    Messages:
    423
    Actually, there are certain things to take into account for the new platinum updates. Skymin is playable now, and that changes Ice, Fire, Rock, Etc. damage. Also, I agree, if there is a next version, it should include the fact that Garchomp is now Uber, and other tier changes.

    This is awesome, and I'm certainly going to be using it to test out my movesets.
  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
    I can only update this once I have Platinum statistics handy.
  19. Legacy Raider

    Legacy Raider
    is a Team Rater Alumnusis a Smogon IRC AOp Alumnusis a Forum Moderator Alumnusis a Contributor Alumnusis a Smogon Media Contributor Alumnusis a Battle Server Moderator Alumnus

    Joined:
    May 1, 2008
    Messages:
    1,828
    When you use the 'Standard' calculator, does it calculate just for every pokemon in the OU tier, or every pokemon bar Ubers?
  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
    All metagame calculations (Uber, Standard, UU) use every Pokemon's usage in that metagame.
  21. darkie

    darkie 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
    Public Relations

    Joined:
    Dec 25, 2005
    Messages:
    6,127
    I think this would be a great tool for use in the CAP Project. Is it possible to implement Technician and/or new moves into this?
  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
    New moves and Technician can be implemented without a problem. And I could also include CAP usages to see the average damage dealt in the CAP metagame.
  23. acinod

    acinod

    Joined:
    Aug 27, 2007
    Messages:
    799
    What's the highest average Damage you can possibly get?
    (without illegal movesets and 999 Special Attack that sort of stuff)
  24. acinod

    acinod

    Joined:
    Aug 27, 2007
    Messages:
    799
    been over a week since i've posted but can anyone answer my FAQ?
  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
    Maybe nobody answered you because nobody knows the answer.

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