Aqua Chat (OOC): Porygon is going cray! | Page 402 | The Other Archives | Guild Forums

Ginji of Thunder

Offline

Posted: Thu Sep 17, 2009 11:01 pm

Well that solves that mystery. It now works correctly for critical hits. Awesome. I tried a few things but quickly got overwhelmed and made little to no head way...

So...as far as the halfing of Psypoke answers... Stab, Super Effective, x1.2... could it just be the same problem? But in a different place?

Things that need working:
- True Accuracy
- TRUE Random Number Generator
- Readme.txt or a Readme Sheet. Because I can, and because I'd like to list all the features in one place.
- Can't remember whatever else I wanted in it...

Posted: Thu Sep 17, 2009 11:05 pm

No, it was the same problem. Adding the parentheses fixed it on my end.

Accuracy formula, stat mods only (not items or ability):
=D21*(IF(D16>0, (3+D16)/3, 3/(ABS(D16)+3))) / (IF(L16>0, (3+L16)/3, 3/(ABS(L16)+3)))

I got an error about exceeding the maximum columns and/or rows when I loaded this version. Did you go past IV or 65xxx?
(Edit: Check your ItemDex sheet on this one)

Thard_Verad
Vice Captain

Offline

Ginji of Thunder

Offline

Posted: Thu Sep 17, 2009 11:11 pm

Ohsnap. How did that happen?! Is there a way to "Select Inverse" on Excel? To google!

Thanks for the Accuracy thing!

Posted: Thu Sep 17, 2009 11:21 pm

Other bugs/errors seen (possibly resulting from converting to my older format):

MoveDex1> Flail and Reversal have !VALUE errors.
ItemDex> Griseous Orb has abnormal formatting. (It dun look purdy)
Aqua Lab items not included in ItemDex.
MoveDex2> Spit Up, Ice Ball, Focus Punch, Snore, and Fury Cutter thru Natural Gift all have !REF errors. They're trying to access a non-existent file.

Also, the A<->D Macro was locked because of some security thing. Dunno the details, but I haven't tried it out.

Edit: Holy $#17, Exploud is immune to Roar of Time??! Must test this!

Thard_Verad
Vice Captain

Offline

Ginji of Thunder

Offline

Posted: Thu Sep 17, 2009 11:31 pm

Thard_Verad

Other bugs/errors seen (possibly resulting from converting to my older format):

MoveDex1> Flail and Reversal have !VALUE errors.
ItemDex> Griseous Orb has abnormal formatting. (It dun look purdy)
Aqua Lab items not included in ItemDex.
MoveDex2> Spit Up, Ice Ball, Focus Punch, Snore, and Fury Cutter thru Natural Gift all have !REF errors. They're trying to access a non-existent file.

Also, the A<->D Macro was locked because of some security thing. Dunno the details, but I haven't tried it out.

Excel's Macro security sucks, every time I open it back up I have to re allow the program to use the macro and then reopen the workbook. All it does is take Cell A, put it in a "holding area", replace it with Cell B and then paste Cell A where Cell B was.

@Movedex 1> Flail and Reversal. I don't see the errors here on mine.

@Itemdex> Purdy isn't exactly what I've been going for XD And I thought I'd get the meat of it working before I broke it again by adding new items XD

@Movedex2> The way the sheet calculates damage is to find the "Additional Effect" Movedex2 is like an extra copy of that for ONLY attack moves. It checks to see if the move hits during fly, Recoil (&rock head), if it's a Punch attack for Iron Fist, sound+Soundproof, ect. I would move it over to the other movedex, but 2 doesn't have the status moves, and is therefor very ugly to transfer. I tried it once and failed epically.

I'll just delete the #ref! moves' column. Way easier.

Posted: Thu Sep 17, 2009 11:36 pm

Further move-specific fixes:

SolarBeam - needs half damage in adverse weather.
Earthquake - needs double-damage against diggers.
Pursuit - needs... wait

Is this crap what the 'custom multiplier' is for?
Guess a ref needs to be on his toes no matter what, eh?

Anyway, it's getting late. G'night for now. Good luck integrating BrightPowder, Wide Lens, and Compound Eyes.

EDIT!!!!! - Excel supports the >= operand, if you want to simplify some of your =OR() formulas.

Thard_Verad
Vice Captain

Offline

Ginji of Thunder

Offline

Posted: Thu Sep 17, 2009 11:40 pm

Thard_Verad

Further move-specific fixes:

SolarBeam - needs half damage in adverse weather.
Earthquake - needs double-damage against diggers.
Pursuit - needs... wait

Is this crap what the 'custom multiplier' is for?
Guess a ref needs to be on his toes no matter what, eh?

Anyway, it's getting late. G'night for now. Good luck integrating BrightPowder, Wide Lens, and Compound Eyes.

Sigh. Don't remind me.

I'm pretty sure since all the things are listed and work is shown, a custom multiplier would cover anything that isn't listed. Haha. Yes, even refs using my program need to be able to know what it does and what it calculates. And they need to be able to know the game mechanics well enough.

And then there's Accuracy of Thunder/Blizzard in Rain/Snow.

Posted: Thu Sep 17, 2009 11:44 pm

Ginji of Thunder

Thard_Verad

Further move-specific fixes:

SolarBeam - needs half damage in adverse weather.
Earthquake - needs double-damage against diggers.
Pursuit - needs... wait

Is this crap what the 'custom multiplier' is for?
Guess a ref needs to be on his toes no matter what, eh?

Anyway, it's getting late. G'night for now. Good luck integrating BrightPowder, Wide Lens, and Compound Eyes.

Sigh. Don't remind me.

I'm pretty sure since all the things are listed and work is shown, a custom multiplier would cover anything that isn't listed. Haha. Yes, even refs using my program need to be able to know what it does and what it calculates. And they need to be able to know the game mechanics well enough.

And then there's Accuracy of Thunder/Blizzard in Rain/Snow.

See previous post for new edit.

Also, those attacks become 256% accurate (FF way of saying they can't miss) in proper weather. They also have a 1/4 chance to break Protect/Detect. Harder to compute is Thunder's drop from 70 to 50 in sunshine.

(Incidentally, No Guard also makes attacks from both sides sure-hit -- type immunity notwithstanding -- and gives a chance to break Protect/Detect)

Edit - Not 'Break.' That's what Feint and Shadow Force do. Bypass is a better word.

Thard_Verad
Vice Captain

Offline

Ginji of Thunder

Offline

Posted: Thu Sep 17, 2009 11:49 pm

>= FUN =D

Yepyepyep. Things refs need to know off the top of their head. Which I won't put in tonight, but will later. Making notes now in the Excel file. Um...

Early morning tomorrow after I grade these missions. Almost done.
3 am is UNHOLY.