The Azure Heights Forum: Multi-purpose Pokemon Excel Spreadsheet

$The Azure Heights Forum$

$Post New Topic$ $New Poll$ $Post A Reply$
my profile | search | faq | forum home

$next oldest topic$ $next newest topic$

»	The Azure Heights Forum » Onix Annex » Azure Pokemon Center » Multi-purpose Pokemon Excel Spreadsheet

UBBFriend: Email this page to someone!

Author

Topic: Multi-purpose Pokemon Excel Spreadsheet

Tghost
Farting Nudist
Member # 1418

Member Rated:

posted 12-06-2001 08:17 PM $Profile for Tghost$ $Author's Homepage$ $Email Tghost$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

Ever wanted to calculate damages from one Pokemon onto all of the other 251 Pokemon? Well, how about a mass-damage calculator to do it for you automatically?

Need help working out the DVs of your Pokemon, how does a stat finder that works almost identical to Meowth346's program sound?

Want to see what your team is weak to? How does a weakness chart that's automatically colour-coded sound?

It's fro Excel 97 only, and if that sales pitch hasn't convinced you, go check out the screenshots.

Pokemon Excel Spreadsheet

Enjoy.

- - - - -
My brain went on vacation and left my pancreas in charge

From: Auckland, New Zealand | Registered: Jan 2001 | IP: Logged

Jolt135
Farting Nudist
Member # 1974

Member Rated:

posted 12-07-2001 05:28 PM $Profile for Jolt135$ $Author's Homepage$ $Email Jolt135$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

*points out this wasn't brought up until AFTER I started distributing my chart, which works almost exactly like the one you're advertising*

From: Woodbridge, VA, USA | Registered: Jul 2001 | IP: Logged

Tghost
Farting Nudist
Member # 1418

Member Rated:

posted 12-07-2001 10:18 PM $Profile for Tghost$ $Author's Homepage$ $Email Tghost$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

*Points out that he's been working on this for over 3 months*
*Points out that an earlier version was distributed among some people*

And, besides, Jolt, you're piffy little thing was rather pathetic in my view. It didn't have anything of value that I could use, that, and if you read the email I sent to you, it even mentions this! Before you go jumping to conclusions, just note how much more advanced this is over your work. Note how similiar they are, becvause in essence, there is very little you can do with a utility spreadsheet for the Pokemon games.

And, lastly, go have a look at the screenshots. It's totally different to your thing.

- - - - -
My brain went on vacation and left my pancreas in charge

From: Auckland, New Zealand | Registered: Jan 2001 | IP: Logged

Knef
Farting Nudist
Member # 2208

Member Rated:

posted 12-09-2001 05:56 AM $Profile for Knef$ $Email Knef$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

Well done! The sheet is excellent, I like it, especially the Mass Damage calculator. *thinks about his self-made Damage Formula sheet* *Knef’s Envy greatly rose!*

Ps: In the first sheet –named “Pokemon”-, the Attack 1 Name slot doesnt contain any Hp-Bug/Hp-Rock entry. About the Mass Damage sheet, why is there an entry for an unevolved form like Weepinbell, while Ledian and Persian are ignored? Not to sound pedant…As I said, I’m just envious. òò-

- - - - -
-Knef

From: Italy | Registered: Sep 2001 | IP: Logged

Tghost
Farting Nudist
Member # 1418

Member Rated:

posted 12-09-2001 06:21 PM $Profile for Tghost$ $Author's Homepage$ $Email Tghost$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

If Weepinbell made it through the ghiding all of the unevolved Pokemon (you can unhide them and they'll all be there), it's because i was doingh it manually and had to redo the hiding everytime I updated the Mass Damage sheet.

The reason the two attack PivotTables are out of whack, is some attack entires (like the HPs) where entered after the original creation of them, and they don't refresh well. I also foud that if I deleted them, I could never seem to recreate them in the same place, and that broke everything down. So, for now,HP Rock and HP Bug are only available in the second attack slot. Another problem with the Pivottables is the Pokemon one suddenly decided it wouldn't be in alphabetical order...it's got quite a few little quirks / bugs like that.

- - - - -
My brain went on vacation and left my pancreas in charge

From: Auckland, New Zealand | Registered: Jan 2001 | IP: Logged

TeeJay
Farting Nudist
Member # 265

Member Rated:

posted 12-09-2001 06:35 PM $Profile for TeeJay$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

It took you three months to do that?

- - - - -
What

From: Overland Park, Kansas, USA | Registered: Apr 2000 | IP: Logged

Tghost
Farting Nudist
Member # 1418

Member Rated:

posted 12-09-2001 06:40 PM $Profile for Tghost$ $Author's Homepage$ $Email Tghost$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

Yes. Is there a problem with that?

From: Auckland, New Zealand | Registered: Jan 2001 | IP: Logged

Jman
Farting Nudist
Member # 618

Member Rated:

posted 12-10-2001 03:22 PM $Profile for Jman$ $Author's Homepage$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

I find it very useful, thank you Tghost.

- - - - -
lol pokemon

From: da burgh | Registered: Jul 2000 | IP: Logged

St George
Farting Nudist
Member # 1923

Member Rated:

posted 12-23-2001 04:08 PM $Profile for St George$ $Email St George$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

G'Day,

Gives Tghost sex out of sex (He will know) for the excel spreadsheet - no macro's?? This is dedicated work he has put forward - well done.

I also enjoyed your website, keep up the good work - not bad for a Kiwi, you still can't play Cricket or Rugby L/U though(ouch) :-)

Looking forward to Wendall vs Lumo !!

Regards,

St. George

PS. If you get stuck on a excel formula or macro - give me a buzz, it will be a pleasure to assist.

- - - - -
A.D.D. = Attention. Deficient. Disorder = Take your tablets when you get a blood rush, or better still, do something useful with the extra blood - get a girl friend, not Claris the Computer ;-)

From: Quensland Australia | Registered: Jul 2001 | IP: Logged

Tghost
Farting Nudist
Member # 1418

Member Rated:

posted 12-23-2001 05:19 PM $Profile for Tghost$ $Author's Homepage$ $Email Tghost$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

::Whips out Kiwi / Aussie Slang Dictonary::
S..S...err..it's not there..although, I sort of get it.

Of course I can't play Cricket or Rugby...my co-ordination is limited to WASD and a mouse...

Well, it may have no macros, but it's got quite a bit of VBA coding.

- - - - -
My brain went on vacation and left my pancreas in charge

From: Auckland, New Zealand | Registered: Jan 2001 | IP: Logged

St George
Farting Nudist
Member # 1923

Member Rated:

posted 12-23-2001 06:33 PM $Profile for St George$ $Email St George$ $Send New Private Message$ $Edit/Delete Post$ $Reply With Quote$

RRrr ya boof, sex = six, ya just don't know how to pronounce it properly - even the Yanks do not speak proper, they need to be edufucated from the southerners ;-)

St George

PS Loved the sucker punch you had at Pojo recently - give em heaps.

- - - - -
A.D.D. = Attention. Deficient. Disorder = Take your tablets when you get a blood rush, or better still, do something useful with the extra blood - get a girl friend, not Claris the Computer ;-)

From: Quensland Australia | Registered: Jul 2001 | IP: Logged

All times are ET (US)

$Post New Topic$ $New Poll$ $Post A Reply$

$Close Topic$ $Move Topic$ $Delete Topic$

$next oldest topic$ $next newest topic$

Printer-friendly view of this topic

The views and opinions expressed on this page are strictly those of the author(s). The contents and links have not been reviewed or approved by the University of Miami.