Southperry.net
The Archer's Book; A Post-Big bang Archer Calculator. - Printable Version

+- Southperry.net (https://www.southperry.net)
+-- Forum: Maplestory (https://www.southperry.net/forumdisplay.php?fid=15)
+--- Forum: Training Center (https://www.southperry.net/forumdisplay.php?fid=32)
+---- Forum: Bowman (https://www.southperry.net/forumdisplay.php?fid=47)
+---- Thread: The Archer's Book; A Post-Big bang Archer Calculator. (/showthread.php?tid=28733)

Pages: 1 2

The Archer's Book; A Post-Big bang Archer Calculator. - JoeTang - 2010-08-13

Just get OpenOffice or Excel.

There's some sort of problem with how the damage range is being calculated. Changing weapon attack barely affects it.

The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-13

You are right... Something appears to be wrong. I am checking what the reasion is.

I feel stupid... It is amazing what 1 bracket placement can do.
Before:
[Image: zk5njp.png]
And After:
[Image: v3ne3l.png]

Yikes! I had Atk multiply STR instead of everything... Added Phoenix and Freezer. Have fun!

The Archer's Book; A Post-Big bang Archer Calculator. - strobli - 2010-08-13

Was fooling around with the numbers and got this:

[Image: noyix3.jpg]

Notice the dividing by zero errors. Also damage should probably be equal to 0 when the hit chance is 0% should it not?

EDIT: Also I just noticed that I had Arrow Bomb at level 30. All I did was actually type it in the cell instead of using the buttons. I didn't even know that Arrow Bomb maxed out at level 20 instead of 30!

The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-14

Well, the damage shown is the damage that you would actually do if you managed to land a hit, not saying if you will land a hit. And thanks for showing that, for now I know to edit the KHO range to include Hit chance. And I will get around to limiting the level amount eventually - I just have been a bit lazy, I guess.

Edit: Should have talked about what you said first; the DIV/0 error is for exp/shot, since the average hits to kill is...the reciprocal of 0.

The Archer's Book; A Post-Big bang Archer Calculator. - strobli - 2010-08-14

WayOfTime Wrote:Well, the damage shown is the damage that you would actually do if you managed to land a hit, not saying if you will land a hit. And thanks for showing that, for now I know to edit the KHO range to include Hit chance. And I will get around to limiting the level amount eventually - I just have been a bit lazy, I guess.

Edit: Should have talked about what you said first; the DIV/0 error is for exp/shot, since the average hits to kill is...the reciprocal of 0.

Yeah I know the reason behind the error but I pointed all those things out for the sake of... aesthetics I guess. Makes it a little easier on the eyes not to see error messages in my opinion. Though I suppose if you're getting 0's you're doing it wrong anyway (or have one of your skills at 0).

The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-14

I plan to eventually make it so the cells appear completely blank if the skill is set at 0. This takes a while, so I have been rather late to start at it, since I haven't found time. I'll try to clear up the asthetics by the end of the week.

Anyone know if a +% atk item affects the atk from expertise?

The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-24

I have updated the Archer's book with the potential system, but it is not fully done yet; I will still need to add +% boss damage. If you have any suggestions, feel free to post them here or send me a message.

My only fear is that this thread will be deleted if there aren't enough posts... uh-oh!

Good luck, and have fun, everyone!