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

X-Act · Aug 17th, 2008, 6:59:30 PM

Quote:

Originally Posted by Fat Tracker

I'm going to assume this doesn't Abilities like Adaptability or Technician into account, am I right? Still this is a very useful tool.

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).

***RBG**** · Aug 17th, 2008, 7:37:26 PM

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?

Syprus · Aug 17th, 2008, 7:47:57 PM

Really sweet! Awesome job.

X-Act · Aug 18th, 2008, 5:11:09 AM

Quote:

Originally Posted by Fat RB Golbat

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

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.

Quote:

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

Yes it does.

X-Act · Aug 19th, 2008, 6:30:33 AM

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.

Too_Hungry35 · Aug 19th, 2008, 9:22:59 PM

When I try to type in the Attack stat, it won't let me. Help please?

X-Act · Aug 20th, 2008, 3:26:24 AM

Quote:

Originally Posted by Fat Too_Hungry35

When I try to type in the Attack stat, it won't let me. Help please?

It's probably either too high or too low. What number are you typing?

Too_Hungry35 · Aug 20th, 2008, 5:54:23 PM

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.

***Aldaron**** · Aug 20th, 2008, 6:11:02 PM

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.

Too_Hungry35 · Aug 20th, 2008, 6:22:40 PM

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?

X-Act · Aug 21st, 2008, 5:40:59 AM

You're pressing ENTER after inputting the number right?

What Excel version do you have?

thetorsoboy · Aug 25th, 2008, 2:06:56 AM

Very awesome. ^-^

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

Too_Hungry35 · Aug 25th, 2008, 2:16:35 PM

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?

X-Act · Aug 26th, 2008, 4:22:58 AM

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).

ARx1000 · Sep 22nd, 2008, 2:29:19 AM

Platinum update?

This thing is awesome and it would be sad for it not to be updated =\

Not Scicky · Oct 1st, 2008, 5:24:59 PM

Uhhh, you might want to change this what with garchomp being in uber now, ice and dragon type moves could be miscalculated :3

Quote:

Originally Posted by Fat Woj

Platinum update?

This thing is awesome and it would be sad for it not to be updated =\

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...

CHENN · Oct 1st, 2008, 11:28:59 PM

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.

X-Act · Oct 3rd, 2008, 6:55:04 AM

I can only update this once I have Platinum statistics handy.

Legacy Raider · Oct 11th, 2008, 4:11:34 PM

When you use the 'Standard' calculator, does it calculate just for every pokemon in the OU tier, or every pokemon bar Ubers?

X-Act · Oct 20th, 2008, 10:05:35 AM

All metagame calculations (Uber, Standard, UU) use every Pokemon's usage in that metagame.

darkie · Oct 20th, 2008, 10:45:56 AM

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?

X-Act · Oct 21st, 2008, 4:15:17 AM

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.

acinod · Oct 21st, 2008, 4:28:26 AM

What's the highest average Damage you can possibly get?
(without illegal movesets and 999 Special Attack that sort of stuff)

acinod · Oct 29th, 2008, 6:02:18 AM

been over a week since i've posted but can anyone answer my FAQ?

X-Act · Oct 30th, 2008, 10:30:04 AM

Maybe nobody answered you because nobody knows the answer.

Aug 17th, 2008, 7:37:26 PM	#27
*RBG It's only after we've lost everything that we're free to do anything. Super Moderator** Join Date: Jan 2008 Posts: 3,237 Home: Goshen Scout Reservation	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? __________________ Alder: N, even if we don't understand each other, that's not a reason to reject each other. There are two sides to an argument. Is there one point of view that has all the answers? Give it some thought.

Aug 17th, 2008, 7:47:57 PM	#28
Syprus Join Date: May 2008 Posts: 353	Really sweet! Awesome job. __________________ Faaaaaaaantastic!

Aug 19th, 2008, 6:30:33 AM	#30
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,678 Malta	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. __________________ http://users.smogon.com/X-Act For all your Pokemon needs (and more!) including: the Defensive EVs applet, the Probabilities of Breeding IVs in Pokemon applet, and the Ratings of Pokemon Base Stats applet (now Version 2.0!). And also the IV to PID applet!

Aug 19th, 2008, 9:22:59 PM	#31
Too_Hungry35 Join Date: May 2007 Posts: 2,675	When I try to type in the Attack stat, it won't let me. Help please? __________________ TradeThread.Looking for a Bold/Relaxed & Timid HP Electric Suicune, & a Timid/Hasty HP Ice Raikou (need a better one than LGY's for an EV spread). Pokemon Pearl FC:0258 6811 2487

Aug 20th, 2008, 5:54:23 PM	#33
Too_Hungry35 Join Date: May 2007 Posts: 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. __________________ TradeThread.Looking for a Bold/Relaxed & Timid HP Electric Suicune, & a Timid/Hasty HP Ice Raikou (need a better one than LGY's for an EV spread). Pokemon Pearl FC:0258 6811 2487

Aug 20th, 2008, 6:11:02 PM	#34
*Aldaron Don't tell me what to do. Super Moderator** Join Date: Aug 2007 Posts: 3,412	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. __________________ beast mode

Aug 20th, 2008, 6:22:40 PM	#35
Too_Hungry35 Join Date: May 2007 Posts: 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? __________________ TradeThread.Looking for a Bold/Relaxed & Timid HP Electric Suicune, & a Timid/Hasty HP Ice Raikou (need a better one than LGY's for an EV spread). Pokemon Pearl FC:0258 6811 2487

Aug 21st, 2008, 5:40:59 AM	#36
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,678 Malta	You're pressing ENTER after inputting the number right? What Excel version do you have? __________________ http://users.smogon.com/X-Act For all your Pokemon needs (and more!) including: the Defensive EVs applet, the Probabilities of Breeding IVs in Pokemon applet, and the Ratings of Pokemon Base Stats applet (now Version 2.0!). And also the IV to PID applet!

Aug 25th, 2008, 2:06:56 AM	#37
thetorsoboy Join Date: Mar 2008 Posts: 2,301	Very awesome. ^-^ I can now say that this works in Excel '97. :P __________________ Coming back with a vengeance. 2013.

Aug 25th, 2008, 2:16:35 PM	#38
Too_Hungry35 Join Date: May 2007 Posts: 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? __________________ TradeThread.Looking for a Bold/Relaxed & Timid HP Electric Suicune, & a Timid/Hasty HP Ice Raikou (need a better one than LGY's for an EV spread). Pokemon Pearl FC:0258 6811 2487

Aug 26th, 2008, 4:22:58 AM	#39
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,678 Malta	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). __________________ http://users.smogon.com/X-Act For all your Pokemon needs (and more!) including: the Defensive EVs applet, the Probabilities of Breeding IVs in Pokemon applet, and the Ratings of Pokemon Base Stats applet (now Version 2.0!). And also the IV to PID applet!

Sep 22nd, 2008, 2:29:19 AM	#40
ARx1000 Join Date: Jul 2008 Posts: 11 Check your mom's room...	Platinum update? This thing is awesome and it would be sad for it not to be updated =\ __________________ Shoddy Accounts: UpInSmoke13 & .Woj

Oct 1st, 2008, 11:28:59 PM	#42
CHENN Join Date: Aug 2008 Posts: 413	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. __________________ <@Priscilla> i like pretending i have a dick <+joshe> :(

Oct 3rd, 2008, 6:55:04 AM	#43
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,678 Malta	I can only update this once I have Platinum statistics handy. __________________ http://users.smogon.com/X-Act For all your Pokemon needs (and more!) including: the Defensive EVs applet, the Probabilities of Breeding IVs in Pokemon applet, and the Ratings of Pokemon Base Stats applet (now Version 2.0!). And also the IV to PID applet!

Oct 11th, 2008, 4:11:34 PM	#44
Legacy Raider Join Date: May 2008 Posts: 1,829 Scotland- GMT+0	When you use the 'Standard' calculator, does it calculate just for every pokemon in the OU tier, or every pokemon bar Ubers? __________________ Warstories: UU Deathmatch (A) \| Raining on the Parade \| The Great War Breaching the Fortress (A) \| UU - Dodging Bullets (A) \| Mushroom Warfare (OU Warstory) (A)

Oct 20th, 2008, 10:05:35 AM	#45
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,678 Malta	All metagame calculations (Uber, Standard, UU) use every Pokemon's usage in that metagame. __________________ http://users.smogon.com/X-Act For all your Pokemon needs (and more!) including: the Defensive EVs applet, the Probabilities of Breeding IVs in Pokemon applet, and the Ratings of Pokemon Base Stats applet (now Version 2.0!). And also the IV to PID applet!

Oct 20th, 2008, 10:45:56 AM	#46
darkie coolcoolcool Join Date: Dec 2005 Posts: 5,363 Plano, TX	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? __________________

Oct 21st, 2008, 4:15:17 AM	#47
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,678 Malta	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. __________________ http://users.smogon.com/X-Act For all your Pokemon needs (and more!) including: the Defensive EVs applet, the Probabilities of Breeding IVs in Pokemon applet, and the Ratings of Pokemon Base Stats applet (now Version 2.0!). And also the IV to PID applet!

Oct 21st, 2008, 4:28:26 AM	#48
acinod Join Date: Aug 2007 Posts: 798 Australia	What's the highest average Damage you can possibly get? (without illegal movesets and 999 Special Attack that sort of stuff) __________________ Platinum Friend Code: 1676 6413 1995 Heart Gold Friend Code: 4340 4908 9618 Trade Thread has been revived: http://www.smogon.com/forums/showthread.php?t=46182 NEWEST RNG BREED: Adamant Gyarados 31 / 31 / 31 / x / 31 / 31 (Flawless much?) Annoying Mushrooms - OU RMT

Oct 29th, 2008, 6:02:18 AM	#49
acinod Join Date: Aug 2007 Posts: 798 Australia	been over a week since i've posted but can anyone answer my FAQ? __________________ Platinum Friend Code: 1676 6413 1995 Heart Gold Friend Code: 4340 4908 9618 Trade Thread has been revived: http://www.smogon.com/forums/showthread.php?t=46182 NEWEST RNG BREED: Adamant Gyarados 31 / 31 / 31 / x / 31 / 31 (Flawless much?) Annoying Mushrooms - OU RMT

Oct 30th, 2008, 10:30:04 AM	#50
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,678 Malta	Maybe nobody answered you because nobody knows the answer. __________________ http://users.smogon.com/X-Act For all your Pokemon needs (and more!) including: the Defensive EVs applet, the Probabilities of Breeding IVs in Pokemon applet, and the Ratings of Pokemon Base Stats applet (now Version 2.0!). And also the IV to PID applet!