(Programming) Pokemon Resource (for DP; made in Excel) - Page 3

CardsOfTheHeart · Sep 2nd, 2008, 4:19:33 PM

Yup, that's the order I had them in my notes, as well. (by "notes" I mean the raw file filled with scattered information before I organize it and present it as the Resource) Thanks for the reminder.

Dr.Traveler · Oct 22nd, 2008, 10:51:53 PM

Hello,

This looks awesome. Is there a chance you'll put this online like metalkid's calculators or rig up a iPhone version for the app store?

I'd love to be able to use this on the go during trips.

CardsOfTheHeart · Oct 22nd, 2008, 11:45:12 PM

I would need someone else's help on that. Coding isn't exactly my strong suit... but I'd love to be able to do that, eventually.

Anyway, I'm planning on giving the Damage Calculator a face-lift because I don't really like the way it looks now. There's too much clutter IMO. I only want to show the information relevant to the moves/abilities actually used.

I don't know how long it'll be before I can tinker with the interface, though...

Dr.Traveler · Oct 23rd, 2008, 10:16:00 AM

Quote:

Originally Posted by Fat CardsOfTheHeart

I would need someone else's help on that. Coding isn't exactly my strong suit... but I'd love to be able to do that, eventually.

Anyway, I'm planning on giving the Damage Calculator a face-lift because I don't really like the way it looks now. There's too much clutter IMO. I only want to show the information relevant to the moves/abilities actually used.

I don't know how long it'll be before I can tinker with the interface, though...

Unfortunately I'm quite the novice at coding, so I can't help there.

I do know that to put an App on the App Store for the iPhone costs green. Should you decide at some future point to move it to the iPhone in one form or another, you should ask for donations here to defray that cost. I know I'd chip in.

I currently use Metalkid's and Serebii's calculators, inaccuraccies and all, because they're available when I travel online. I'd love to have something more accurate.

Legacy Raider · Dec 6th, 2008, 4:32:44 PM

CoftH, I'd like to give you my thanks for making this resource. It is incredible. A lot more accurate than online ones as well.

I was wondering, are you going to update it with stats for the new rotom forms, giratina-o and shaymin-s?

Thanks,

LR.

CardsOfTheHeart · Dec 6th, 2008, 9:25:34 PM

Right now, I'm trying to clean up the interface and add a few things. The damage calculator, in particular, is full of clutter and in need of the most work. Here's what I'll be looking to add:

-IV Calculator

I've been wanting to do this for a while, but it wasn't until a while back that I had been able to work out the IV formula the way I wanted it to.

-Mass Attack and Defense Damage Calculator

This is the one thing missing from every calculator that I have ever seen.

This will be an addition to the stat calculator that will allow for the same variables as the damage calculator, but it will calculate the damage dealt to and taken from various Pokemon, their spreads, and their attacks. I'd like to allow input for HUNDREDS of Pokemon to make it truly feel like a mass damage calculator.

I'm still trying to work out how I want to show the data, though.

I'd also like to put in a Hidden Power calculator when I can, but that's not as high a priority as the first two.

I'll be working on this over my Christmas break which starts on the 18th. I'm hoping to have something released by mid-January, but that's an optimistic forecast. Look forward to it!

Shelcario · Dec 6th, 2008, 9:44:48 PM

Great work CardsoftheHeart! This is seriously going to help me thanks for the contributions,really a big help.

Edit: One question though, how do you enter evs and ivs into the stat calculator?

CardsOfTheHeart · Dec 6th, 2008, 10:12:01 PM

Quote:

Originally Posted by Fat Shelcario

Great work CardsoftheHeart! This is seriously going to help me thanks for the contributions,really a big help.

Glad I could help.

Quote:

Originally Posted by Fat Shelcario

One question though, how do you enter evs and ivs into the stat calculator?

There should be a section for EVs and IVs. I put a black border around all of the cells that you were meant to change: Pokemon name, Level, EVs, IVs, and Nature.

***RBG**** · Dec 6th, 2008, 10:21:10 PM

Not to nitpick, but would it be possible to get a quick update with all the new formes?

Also, I assume i don't need to ask, but would Gyro Ball use the speed formula in your final?

Colonel M · Dec 6th, 2008, 10:41:07 PM

Quote:

Originally Posted by Fat CardsOfTheHeart

-Mass Attack and Defense Damage Calculator

This is the one thing missing from every calculator that I have ever seen.

This will be an addition to the stat calculator that will allow for the same variables as the damage calculator, but it will calculate the damage dealt to and taken from various Pokemon, their spreads, and their attacks. I'd like to allow input for HUNDREDS of Pokemon to make it truly feel like a mass damage calculator.

If you actually accomplish this (which I really hope you do)... I will be so excited to try this out. You don't know how long I've been waiting for something like this.

Good luck.

CardsOfTheHeart · Dec 6th, 2008, 10:54:55 PM

Quote:

Originally Posted by Fat RB Golbat

Not to nitpick, but would it be possible to get a quick update with all the new formes?

I was having trouble deciding whether to do this or not. I wanted to put it off for my next update, mainly because I have so many things to fix, but I'll get on it.

Also, I assume i don't need to ask, but would Gyro Ball use the speed formula in your final?

Yes it will.

I'll try to have something up later tonight that has Shaymin-S, the Rotom forms, Giratina-O, and the Platinum Orb.

EDIT! The Resource has been updated for Platinum! It's quite a bit overdue, but here it is. Shaymin-S, the Rotom forms, Giratina-O, and the Platinum Orb have been added for your pleasure. This was created a bit hastily, though, so if you find errors, please let me know.

Here's the link to Pokemon Resource version 1.2:

Pokemon Resource 1.2 (Excel 2007 version)

NOTICE! 10:54PM 12/6/08 If you downloaded the first version of this I uploaded at 10:37, that one had an error concerning Pokedex Numbers of the Rotom forms. Please download it again; the link has been replaced.

The file SHOULD be compatible with Excel 2003, but if that is a problem, here is the 2003 version:

Pokemon Resource 1.2 (Excel 2003 version)

NOTICE! 7:47AM 12/7/08 If you have a problem with invalid Pokemon data entry in the damage calculator, you have an outdated version. Please download it again; the link has been replaced.

Note to OpenOffice users: the files are probably NOT optimized for OpenOffice. Don't worry, though: the next major update is being created in OpenOffice 3.0, thus it should be a lot kinder to you. It might come with a slight loss of functionality, though. I don't hope so, but I thought it would be nice to give the heads-up.

Kirby119 · Jun 1st, 2009, 6:20:19 PM

(Sorry if this has been mentioned before or is kinda off topic), but in your description don't you mean Special Defense for Rock type Pokemon in Sandstorm?

Accent · Jul 18th, 2009, 9:39:14 AM

Hi,

This is amazing. CoftH, am I allowed to use this file to make a new spreadsheet that will be more convenient for in-battle use? I'll post it here of course.

CardsOfTheHeart · Jul 18th, 2009, 10:02:12 AM

I don't care. Depending on what you want to use, you might be better off waiting until I fix some things with the damage calculator. (It's outdated, for starters.) I've been putting off working on it because I've overwhelmed myself trying to create it again from scratch. I'll have a lot more time to work on it in a couple of weeks, though; maybe then I can focus more on getting this done.

Accent · Jul 18th, 2009, 10:12:05 AM

Ok, Thanks. I'll begin working on my project, and then I'll update it when you do.

Arb · Jul 21st, 2009, 4:25:00 PM

this thing is great, i just wish it was printer freindly

STILL AWSOME THOUGHT!

Rating:

five slices of toast = AWSOME!

Xia · Jul 25th, 2009, 11:48:55 PM

Every time I try to use the Damage Calculator, the only choices I get from the drop-down menu for Defending Pokemon is error #508.

And I'm using the latest version, for Excell 2007. If it's just me don't worry about it, I just felt it needed to be brought to your attention.

CardsOfTheHeart · Jul 26th, 2009, 12:25:59 AM

I can't remember ever seeing that error, but I guess you're opening it in OpenOffice, aren't you? Opening an Excel spreadsheet file in OpenOffice will mess up some cell references. The Excel 2003 version MIGHT work better for you, but I think some references are messed up there, too.

I've been meaning to make a version that works best with OpenOffice; all it'd take would be to fix some references, but I'm just plain lazy and not motivated to work on it for reasons I outlined in my previous post. I'll be finishing my Master's degree in a few days; hopefully then I'll be more motivated to work on this...

Xia · Jul 26th, 2009, 1:08:46 PM

yeah, I'm opening it through OpenOffice. Just making usre you knew it was there.

I'll keep my fingers crossed for the refrences to be fixed, then.

moqca · Aug 29th, 2009, 12:19:50 PM

Hey CardofHearts, i was just working on something like this, and honestly yours seems very very detailed. I do have a team weakness chart, like the one on marriland, for use with excel, if you want you can incorporate that

swampie · Nov 11th, 2009, 1:57:42 PM

I really like this thing. I'm using it over and over for my own little projects. Now i'm working on a mass damage calculator. Keep up the good work!

Hobbers · Aug 1st, 2010, 7:34:37 AM

Dead links? I'd really like to have this, but all links are broken.

Sep 2nd, 2008, 4:19:33 PM	#51
CardsOfTheHeart Join Date: Aug 2007 Posts: 1,971 My Soul, Your Beats!	Yup, that's the order I had them in my notes, as well. (by "notes" I mean the raw file filled with scattered information before I organize it and present it as the Resource) Thanks for the reminder. __________________ 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)

Oct 22nd, 2008, 10:51:53 PM	#52
Dr.Traveler Join Date: Dec 2007 Posts: 176 Flatland	Hello, This looks awesome. Is there a chance you'll put this online like metalkid's calculators or rig up a iPhone version for the app store? I'd love to be able to use this on the go during trips. __________________ My Trainer Card. http://www.pokecharms.com/trainercar...8cb1d8916c.png

Oct 22nd, 2008, 11:45:12 PM	#53
CardsOfTheHeart Join Date: Aug 2007 Posts: 1,971 My Soul, Your Beats!	I would need someone else's help on that. Coding isn't exactly my strong suit... but I'd love to be able to do that, eventually. Anyway, I'm planning on giving the Damage Calculator a face-lift because I don't really like the way it looks now. There's too much clutter IMO. I only want to show the information relevant to the moves/abilities actually used. I don't know how long it'll be before I can tinker with the interface, though... __________________ 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)

Dec 6th, 2008, 4:32:44 PM	#55
Legacy Raider Join Date: May 2008 Posts: 1,829 Scotland- GMT+0	CoftH, I'd like to give you my thanks for making this resource. It is incredible. A lot more accurate than online ones as well. I was wondering, are you going to update it with stats for the new rotom forms, giratina-o and shaymin-s? Thanks, LR. __________________ Warstories: UU Deathmatch (A) \| Raining on the Parade \| The Great War Breaching the Fortress (A) \| UU - Dodging Bullets (A) \| Mushroom Warfare (OU Warstory) (A)

Dec 6th, 2008, 9:25:34 PM	#56
CardsOfTheHeart Join Date: Aug 2007 Posts: 1,971 My Soul, Your Beats!	Right now, I'm trying to clean up the interface and add a few things. The damage calculator, in particular, is full of clutter and in need of the most work. Here's what I'll be looking to add: -IV Calculator I've been wanting to do this for a while, but it wasn't until a while back that I had been able to work out the IV formula the way I wanted it to. -Mass Attack and Defense Damage Calculator This is the one thing missing from every calculator that I have ever seen. This will be an addition to the stat calculator that will allow for the same variables as the damage calculator, but it will calculate the damage dealt to and taken from various Pokemon, their spreads, and their attacks. I'd like to allow input for HUNDREDS of Pokemon to make it truly feel like a mass damage calculator. I'm still trying to work out how I want to show the data, though. I'd also like to put in a Hidden Power calculator when I can, but that's not as high a priority as the first two. I'll be working on this over my Christmas break which starts on the 18th. I'm hoping to have something released by mid-January, but that's an optimistic forecast. Look forward to it! __________________ 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)

Dec 6th, 2008, 9:44:48 PM	#57
Shelcario Join Date: Nov 2007 Posts: 1,421	Great work CardsoftheHeart! This is seriously going to help me thanks for the contributions,really a big help. Edit: One question though, how do you enter evs and ivs into the stat calculator? __________________ Currently: Diamond: At the Battle Tower Platinum: At the Battle Factory Last edited by Shelcario; Dec 6th, 2008 at 9:52:30 PM.

Dec 6th, 2008, 10:21:10 PM	#59
*RBG It's only after we've lost everything that we're free to do anything. Super Moderator** Join Date: Jan 2008 Posts: 3,230 Home: Goshen Scout Reservation	Not to nitpick, but would it be possible to get a quick update with all the new formes? Also, I assume i don't need to ask, but would Gyro Ball use the speed formula in your final? __________________ 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.

Jun 1st, 2009, 6:20:19 PM	#62
Kirby119 Join Date: Nov 2008 Posts: 34	(Sorry if this has been mentioned before or is kinda off topic), but in your description don't you mean Special Defense for Rock type Pokemon in Sandstorm? __________________ No Mercy Subscribe to - http://www.youtube.com/user/KirbyStar11 http://www.youtube.com/user/Arandomproduction1

Jul 18th, 2009, 9:39:14 AM	#63
Accent Join Date: Jul 2009 Posts: 877 10,000 miles away	Hi, This is amazing. CoftH, am I allowed to use this file to make a new spreadsheet that will be more convenient for in-battle use? I'll post it here of course.

Jul 18th, 2009, 10:02:12 AM	#64
CardsOfTheHeart Join Date: Aug 2007 Posts: 1,971 My Soul, Your Beats!	I don't care. Depending on what you want to use, you might be better off waiting until I fix some things with the damage calculator. (It's outdated, for starters.) I've been putting off working on it because I've overwhelmed myself trying to create it again from scratch. I'll have a lot more time to work on it in a couple of weeks, though; maybe then I can focus more on getting this done. __________________ 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)

Jul 18th, 2009, 10:12:05 AM	#65
Accent Join Date: Jul 2009 Posts: 877 10,000 miles away	Ok, Thanks. I'll begin working on my project, and then I'll update it when you do.

Jul 21st, 2009, 4:25:00 PM	#66
Arb Join Date: Jul 2009 Posts: 217	this thing is great, i just wish it was printer freindly STILL AWSOME THOUGHT! Rating: five slices of toast = AWSOME! __________________ Prismic Pokemon + Arbs Art Avatar by me

Jul 25th, 2009, 11:48:55 PM	#67
Xia I am your big brother Join Date: Nov 2007 Posts: 2,464	Every time I try to use the Damage Calculator, the only choices I get from the drop-down menu for Defending Pokemon is error #508. And I'm using the latest version, for Excell 2007. If it's just me don't worry about it, I just felt it needed to be brought to your attention.

Jul 26th, 2009, 12:25:59 AM	#68
CardsOfTheHeart Join Date: Aug 2007 Posts: 1,971 My Soul, Your Beats!	I can't remember ever seeing that error, but I guess you're opening it in OpenOffice, aren't you? Opening an Excel spreadsheet file in OpenOffice will mess up some cell references. The Excel 2003 version MIGHT work better for you, but I think some references are messed up there, too. I've been meaning to make a version that works best with OpenOffice; all it'd take would be to fix some references, but I'm just plain lazy and not motivated to work on it for reasons I outlined in my previous post. I'll be finishing my Master's degree in a few days; hopefully then I'll be more motivated to work on this... __________________ 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)

Jul 26th, 2009, 1:08:46 PM	#69
Xia I am your big brother Join Date: Nov 2007 Posts: 2,464	yeah, I'm opening it through OpenOffice. Just making usre you knew it was there. I'll keep my fingers crossed for the refrences to be fixed, then.

Aug 29th, 2009, 12:19:50 PM	#70
moqca Join Date: Aug 2009 Posts: 6	Hey CardofHearts, i was just working on something like this, and honestly yours seems very very detailed. I do have a team weakness chart, like the one on marriland, for use with excel, if you want you can incorporate that Last edited by moqca; Aug 29th, 2009 at 12:26:46 PM.

Nov 11th, 2009, 1:57:42 PM	#71
swampie Join Date: Nov 2009 Posts: 14	I really like this thing. I'm using it over and over for my own little projects. Now i'm working on a mass damage calculator. Keep up the good work! __________________ Wonder guard Shedinja actually is a threat to my laughing muscles! Thanks Lorak.

Aug 1st, 2010, 7:34:37 AM	#72
Hobbers Join Date: Jun 2010 Posts: 171 Belgium	Dead links? I'd really like to have this, but all links are broken.