The Aran Calculator V3.5

I thought that the damage range WAS a multiple of 3.0 anyways for minimum instead of 5.0. If it is always 5.0 for swinging, this will change the numbers DRASTICALLY. If so, I will change my calculator accordingly.

Anyways, I finished the modifications you asked for. I think you may like the name of it.

Aran Calculator V3.7 Devil-Will-Cry (Vista)

Aran Calculator V3.7 Devil-Will-Cry(Excel 93-2003)

Hehe, nice name indeed!

Hmmm yeah, now only the minimum mastery. That will raise the numbers a little bit much. xD

P.S. Sharp Eyes -really- buffs up Arans a LOT, just wow...

It's very good although I would suggest crediting Sybaris for taking the layout and monster list from her (http://ironarrows.com/wp/?page_id=41). I give you full credit for the formulas though, very well done.

what does "M. Piece val" means in the monster database inside the excel spreadsheet?

It's very good although I would suggest crediting Sybaris for taking the layout and monster list from her (http://ironarrows.com/wp/?page_id=41). I give you full credit for the formulas though, very well done.

I originally have, ans fully asked her for permission. The problem is that once I started asking serious questions about the sheet, she sort of shut me down. I will find a place to put it in the credits, though.

The M. Piece val is the cost of the monster piece that is dropped when you sell it to an NPC.

Changed the MIN damage and gave credit where credit's due. I also corrected the format glitch for the Physical damage below level60 in the earlier versions of excel (97-03). All Calculators were given these updates.

I originally have, ans fully asked her for permission. The problem is that once I started asking serious questions about the sheet, she sort of shut me down. I will find a place to put it in the credits, though.

Alright I was just wondering. I wasn't trying insult you or anything I was just wondering why your calculator looked so much like like hers and there were no credits or thanks anywhere in it. It's all good if you have her permission to use the layout. Of course we're both familiar with it because we're both Bowman... but anyway great calculator. I'll use this as well come December 9th.

On a side note I was just wondering if you knew whether Sybaris had any plans to continue her calculator? Because if she isn't I was thinking of making an updated one myself.

Alright I was just wondering. I wasn't trying insult you or anything I was just wondering why your calculator looked so much like like hers and there were no credits or thanks anywhere in it. It's all good if you have her permission to use the layout. Of course we're both familiar with it because we're both Bowman... but anyway great calculator. I'll use this as well come December 9th.

On a side note I was just wondering if you knew whether Sybaris had any plans to continue her calculator? Because if she isn't I was thinking of making an updated one myself.

I, myself, have no idea. Her most recent update, I gather, was the "what-damage-each-hit-in-a-mob" addition. Maybe you can update it, but you may need to ask her.

And no offence taken.

Something doesn't seem right. I know I can hit more than what is displaying. i.e. this says that in 1 hit for the triple swing in overswing my maximum critical is ~19k. I know I can at least hit 29.5k (to chief oblivion guardians). I checked the damage range, and it matches up (without snow charge).

 Spoiler

EDIT: I noticed I forgot to check the combo count. Still didn't do much though.

 Spoiler

I, myself, have no idea. Her most recent update, I gather, was the "what-damage-each-hit-in-a-mob" addition. Maybe you can update it, but you may need to ask her.

And no offence taken.

Yes and that update was a while ago and is outdated anyway what with Arrow Bomb doing 120% on every hit now. And I wasn't going to take hers and update it but make an entirely new one that's like a spiritual successor. But alas these things are for another thread.

Something doesn't seem right. I know I can hit more than what is displaying. i.e. this says that in 1 hit for the triple swing in overswing my maximum critical is ~19k. I know I can at least hit 29.5k (to chief oblivion guardians). I checked the damage range, and it matches up (without snow charge).

 Spoiler

EDIT: I noticed I forgot to check the combo count. Still didn't do much though.

 Spoiler

There are TWO possibilities:
1. There is something totally wrong with the calculations. But I do not think so, so there may be other factors.
2. Is this with or without SE you are talking about? Because I see in your picture that SE is not checked.

Also, both of them your PA combo is unchecked, which can lead to a miniscule difference.

Edit: didnt see the edit.

There are TWO possibilities:
1. There is something totally wrong with the calculations. But I do not think so, so there may be other factors.
2. Is this with or without SE you are talking about? Because I see in your picture that SE is not checked.

Also, both of them your PA combo is unchecked, which can lead to a miniscule difference.

It is meant to be without SE. In the second picture, I checked PA combo count.

It is without SE since I rarely ever get SE and I don't remember what the max I got with SE was. In the second picture, I checked PA combo count.

FOUND THE POSSIBILITY!

See above Pole-arm Toss? Check that box and that will be the damage done when the monster is thrown in the air and you hit it!

FOUND THE POSSIBILITY!

See above Pole-arm Toss? Check that box and that will be the damage done when the monster is thrown in the air and you hit it!

I can do that damage with them on the ground. I rarely even use toss anymore.

Look, if my max attack at 100 combo (using snow charge) is 7366, then I can theoretical max of 29,464 if the monster has 0 DEF. Overswing level 30 has triple swing dealing 240% x 2, and you add +160% to that for critical. So with a critical, one hit in triple swing can hit 400%. 400% of 7366 is 29,464 which is close to numbers I remember seeing while training.

I can do that damage with them on the ground. I rarely even use toss anymore.

With a hand-held it seems to work...Something is up!

Maybe the Aran criticals are not like archer criticals, where they add the percentage...Is it possible it is multipative? Instead of (skill_max)+(Max*critical_val) is it (skill_max)*critical_val?

Or, scratching that, maybe it is 1+(skill percentage) like 1+60%

Changed my calculator temporatily on my end: is this what you see?

 Spoiler

With a hand-held it seems to work...Something is up!

Maybe the Aran criticals are not like archer criticals, where they add the percentage...Is it possible it is multipative? Instead of (skill_max)+(Max*critical_val) is it (skill_max)*critical_val?

Or, scratching that, maybe it is 1+(skill percentage) like 1+60%

At critical count 1 it is +110%, at critical count 2 it is +120% all the way to critical count 6 which is +160%. You put in +10%, +20%. . .+60%. You forgot that combo critical has a base addition of 100% and for every ten combos it adds an additional 10% which can stack 6 times.

At critical count 1 it is +110%, at critical count 2 it is +120% all the way to critical count 6 which is +160%. You put in +10%, +20%. . .+60%. You forgot that combo critical has a base addition of 100% and for every ten combos it adds an additional 10% which can stack 6 times.

Yes, I did forget. So the image above is what you usually see whilst training?

Yes, I did forget. So the image above is what you usually see whilst training?

I am 99.9% certain I have seen a high 28 ~ low 29 at least.

EDIT: I just noticed my defense on a chief oblivion guardian was wrong for some reason. Barely changes anything though.

I have a question, did you make it so combo and attack pots stack? It isn't like energy charge where it just adds the difference between your attack pot and energy's added attack. (As in, if you are using a 12 attack potion, energy charge adds you 8 more and that is it.) Critical stacks. So if you were using a 12 attack potion, and you had 100 combo, you'd get a total of +22 attack. I'd go in game and get 100 combo to test, but I am not in the mood to walk to skelegons/ToT. That could be a reason your numbers are lower than what I saw.

I am 99.9% certain I have seen a high 28 ~ low 29 at least.

Hmmm... All I can say is that this is a BIT problematic. I am fairly certain that you added all things like Blessing of the Sprite and all that trash, so I am not sure where you recieved those highER numbers... Unfortunately, I can not work on it any longer tonight since I need to go to bed before my physics test tomorrow.

I see a 29.4k on a green snail, but I don't think the little guy would make it that far.

Let me know if you guys find anything else. I will be working on this tomorrow.

And yes, they stack.

I'll just leave this here:

I'll just leave this here:

Even ignoring defence I do not think that they normally hit that high... 6696*4*1.1=29462.4, so maybe it is not my calculator, but maybe the skill data is wrong... If the attack was 280%, it would hit those numbers. Or if snowcharge gave 120%, which it doesn't. Or even an extra *1.1.

This is REALLY odd.

Oh, and Devil, looking at the attack range I think the coefficient of the minumum is still 3, not 5.

Even ignoring defence I do not think that they normally hit that high... 6696*4*1.1=29462.4, so maybe it is not my calculator, but maybe the skill data is wrong... If the attack was 280%, it would hit those numbers. Or if snowcharge gave 120%, which it doesn't. Or even an extra *1.1.

This is REALLY odd.

Oh, and Devil, looking at the attack range I think the coefficient of the minumum is still 3, not 5.

It could be that critical is able to stack 10 times and get to +200%. Test that. It is more likely than than overswing's damage being wrong because I don't see a problem with overwing's damage in the calculator for non-critical hits.