The Archer's Book; A Post-Big bang Archer Calculator.

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.

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:

And After:


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

Was fooling around with the numbers and got this:



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!

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.

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

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?

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!