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

***Mekkah***** · Oct 30th, 2008, 10:40:20 AM

Quote:

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

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.

Jenigmat · Oct 30th, 2008, 11:53:38 AM

Quote:

Originally Posted by Fat acinod

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

http://www.smogon.com/forums/showpos...5&postcount=24

acinod · Oct 31st, 2008, 3:49:57 AM

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.

X-Act · Oct 31st, 2008, 10:40:24 AM

I know. Nobody knows the maximum percentage.

MustBeEmo · Nov 1st, 2008, 9:34:37 PM

WHen i go to input something it doesnt let me. Help?

X-Act · Nov 2nd, 2008, 3:20:50 AM

What version of Microsoft Excel do you have?

***Jumpman16***** · Nov 15th, 2008, 11:54:15 AM

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

X-Act · Nov 16th, 2008, 9:18:19 AM

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.

ace15 · Nov 16th, 2008, 9:51:06 AM

Woah, this is amazing.. awesome work X-act!

Bourbon · Nov 16th, 2008, 10:06:59 AM

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

Darth Meanie · Nov 16th, 2008, 3:07:24 PM

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

Jaroku · Nov 16th, 2008, 4:22:56 PM

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?

X-Act · Nov 16th, 2008, 4:55:45 PM

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.

Jaroku · Nov 16th, 2008, 5:14:51 PM

Wow thanks X-Act this is amazing! It works for me now.

crystalvelox · Nov 16th, 2008, 11:50:33 PM

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?

MetaNite · Nov 17th, 2008, 6:15:06 AM

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?

Ranz · Nov 17th, 2008, 7:47:11 AM

Dark Pulse + Focus Blast/HP fighting. aint that good?

or Night Slash/Brick Break(Weavile meh).

X-Act · Nov 17th, 2008, 8:49:32 AM

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.

Quote:

Originally Posted by Fat crystalvelox

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?

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.

Quote:

Originally Posted by Fat MetaNite

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?

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

MetaNite · Nov 17th, 2008, 3:12:30 PM

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.

X-Act · Nov 17th, 2008, 4:26:03 PM

My Excel version is also 2003, so yours should work.

dr4g0n · Nov 17th, 2008, 7:11:59 PM

X-Act is GOD. This is AWESOME!!!

crystalvelox · Nov 17th, 2008, 10:23:17 PM

Quote:

Originally Posted by Fat X-Act

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.

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.

CardsOfTheHeart · Nov 17th, 2008, 11:27:43 PM

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.

X-Act · Nov 18th, 2008, 2:28:08 AM

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.

X-Act · Nov 18th, 2008, 3:45:00 PM

I have just fixed the maximum attack and special attack allowed in the Excel sheet. Redownload it for the latest version.

Oct 31st, 2008, 3:49:57 AM	#53
acinod Join Date: Aug 2007 Posts: 798 Australia	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. __________________ 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 31st, 2008, 10:40:24 AM	#54
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,679 Malta	I know. Nobody knows the maximum percentage. __________________ 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!

Nov 1st, 2008, 9:34:37 PM	#55
MustBeEmo Join Date: Sep 2008 Posts: 156	WHen i go to input something it doesnt let me. Help? __________________ FC: 1075 3734 7829 (PM me any time for UU Battle) Me and Macle's Trade Thread Voltorb IVs 22+ / 31 / 20+ / 31 / 20+ / 31

Nov 2nd, 2008, 3:20:50 AM	#56
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,679 Malta	What version of Microsoft Excel 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!

Nov 15th, 2008, 11:54:15 AM	#57
*Jumpman16* np: Michael Jackson - 'Mon in the Mirror (Dream World mix off the "Black or White" album) Administrator** Join Date: Dec 2004 Posts: 4,737 Fuqua: Where business cases are read and devils are blue	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 __________________ You haven't trolled till you've trolled in real life. Read A Mullet's Tale for reference if you haven't yet!

Nov 16th, 2008, 9:18:19 AM	#58
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,679 Malta	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. __________________ 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!

Nov 16th, 2008, 9:51:06 AM	#59
ace15 Join Date: Jun 2007 Posts: 1,317 Everywhere	Woah, this is amazing.. awesome work X-act!

Nov 16th, 2008, 10:06:59 AM	#60
Bourbon Join Date: Sep 2007 Posts: 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%. Last edited by Bourbon; Nov 16th, 2008 at 4:43:27 PM.

Nov 16th, 2008, 3:07:24 PM	#61
Darth Meanie Join Date: Jan 2008 Posts: 580 Fresno, Ca	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 __________________ Maybe if my signature is clever enough I will finally be loved. Thanks to Moft for this wicked avatar! Last edited by Darth Meanie; Nov 16th, 2008 at 3:09:34 PM.

Nov 16th, 2008, 4:22:56 PM	#62
Jaroku Join Date: Aug 2007 Posts: 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?

Nov 16th, 2008, 4:55:45 PM	#63
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,679 Malta	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. __________________ 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!

Nov 16th, 2008, 5:14:51 PM	#64
Jaroku Join Date: Aug 2007 Posts: 59	Wow thanks X-Act this is amazing! It works for me now.

Nov 16th, 2008, 11:50:33 PM	#65
crystalvelox Join Date: Sep 2008 Posts: 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?

Nov 17th, 2008, 6:15:06 AM	#66
MetaNite Join Date: May 2008 Posts: 1,510 NJ-	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?

Nov 17th, 2008, 7:47:11 AM	#67
Ranz Join Date: Aug 2008 Posts: 243 Cebu City	Dark Pulse + Focus Blast/HP fighting. aint that good? or Night Slash/Brick Break(Weavile meh). __________________ Who cares?

Nov 17th, 2008, 3:12:30 PM	#69
MetaNite Join Date: May 2008 Posts: 1,510 NJ-	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.

Nov 17th, 2008, 4:26:03 PM	#70
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,679 Malta	My Excel version is also 2003, so yours should work. __________________ 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!

Nov 17th, 2008, 7:11:59 PM	#71
dr4g0n Join Date: Mar 2008 Posts: 96	X-Act is GOD. This is AWESOME!!! __________________ Lucario sweeps ftw!!!

Nov 17th, 2008, 11:27:43 PM	#73
CardsOfTheHeart Join Date: Aug 2007 Posts: 1,971 My Soul, Your Beats!	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. __________________ My Soul, Your Beats! Creator of the DPP Pokemon Resource, the one thing no Trainer should be without! (eventually... maybe) My YouTube Channel My Blog (VERY, VERY small, ATM)

Nov 18th, 2008, 2:28:08 AM	#74
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,679 Malta	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. __________________ 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!

Nov 18th, 2008, 3:45:00 PM	#75
X-Act np: Biffy Clyro - Shock Shock Join Date: Feb 2006 Posts: 4,679 Malta	I have just fixed the maximum attack and special attack allowed in the Excel sheet. Redownload it for the latest version. __________________ 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!