Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
The Aran Calculator V3.5
#1
The maple world is in great peril from the forces of evil, and no one is there to stop it... Long ago, the Black Magician invaded the world, trying to capture it, or destroy it, but was thrawt by Five Legendary Heroes... With the heroes gone, and the black magician returning, there is no hope left for the Maple World...or is there?

Enter the Aran!

The Aran is one of the five heroes who faught the Black Magician, and was encased in ice. Years later, the Arans finally come back on the island of Rienne, which is eternally in winter because of the curse. Woken by a pale girl, the Aran tries to gain back his power, and his memories.

You are the Aran. The Aran is unique in the sence that they use polearms and attack really fast. Sorry, that is not unique, you say? What about the fact that they use a new combo system that improves their power? Yes.

The Aran class was developed in KMS and was recently released in MSEA. On december the 9th, the class will be debued in GMS.

I created this calculator because I first wanted to see for myself how the Aran would compare to other classes. Once I started this little project, though, I felt like I needed to show everybody how well they could do also. While not exactly powerful on singular hits, they are great mobbers in the sense that they can hit about 12 monsters at a time. They also do not get all of their attacks right away, but have to do quests to get the skills.

Here are the two versions:
 Aran Calculator V4.2

The first of these removes some "unneeded things" like Average HKO, chance of 1hko, and exp/shot just to name a few. It also removes the potion icons and just leaves an area to enter your potion's attack. The second one still has these parts to them, and is a bit more tidy looking (in my own eyes). Both of them have a new "HP and MP" area where you enter your HP and MP to check how much HP you can have after washing. It won't say how many times you need to get hit before dieing, but whatever! For the DWC version it is under the main information, and for v4.2b it is under the "Damage Recieved" area where the image used to be. Also, I combined PA combo and Critical count, but forgot to remove critical count, so ignore that.


You will need Microsoft Excel (Vista) for these links.

 Earlier Excel 97-03 Versions

For Excel 97-2003

 List of Features


You will notice that when you raise the Mob number, your damage per hit lowers. All of this can be explained here. Basically, to make sure Arans are not over-powered, when you have more mobs, you do less damage per monster, but more over-all.

If you have any sudjestions, feel free to tell me.


Special thanks to:
-Fiel, for this great site and the tables
-Spadow for his amazing picture featured in my calculator
-Sybaris of the IronArrows guild of Bera for the calculator I used as a template
-...All of you guys for being freaking amazing with all of the support.

UPDATE: I have fixed the bug with the damage recieved in the .xls format. You now are able to see the numbers. I also modified the MIN damage since Devil pointed out I was just down-right wrong! =P

UPDATE for V3.8: I have updated this because of three reasons: There was not enough room to put all of your STR and DEX in (New max is 1500), when looking at the Monster Table, the monster you are currently on will be high-lighted, and critical combo was "out of whack". I changed critical combo so that it would stack 10 times and give 6% chance and 10% damage each time, because, apparently, we may have been wrong before. Now, better than ever, V3.8 has fixed these problems and per-peeves and is one step closer to perfection! Well done guys!

Updated my V3.8 files to include a Boss Flag on boss monsters, meaning that Smart KB will not work on those that were flagged.


Final note: I locked the cells so that you may change the numbers for damage, but are not able to steal it! Be warned! Wink
Reply
#2
Not bad... not bad at all
Reply
#3
Why does it seem calcs like this always seem to be restricted to Excell documents? a-@

Just seems like it would be more usefull if used in a more open format that doesnt require another program to use. Like a java app or something.

Idk, this is mainly ranting for annoying (to myself at least) trends that never seem to die.
Reply
#4
Looks great! ^^
Reply
#5
Thank you very much, guys. The only reason I have it in excel is because I am only compitent in that format. If I learn java script, or something like that, I can upload it in that program.
Reply
#6
Dude, this kicks ass!Redface

Only a request, can you add 2 things:
- Average damage per second with avg critical chance (just max + min damage / 2, calculating in critical chance)
- Sharp Eyes option
Reply
#7
It looks much simpler to use than the excel documents I'm used to, but wow it sure does look good lol.
Reply
#8
It looks pretty neat and organized. I'm definitely using that for my aran.
Reply
#9
Devil Wrote:Dude, this kicks ass!Redface

Only a request, can you add 2 things:
- Average damage per second with avg critical chance (just max + min damage / 2, calculating in critical chance)
- Sharp Eyes option

Lets see:
-When you say average damage per second with avg critical chance, do you want me to show the damage of a singular strike of a normal attack? Or do you mean the damage per second of a skill, breaking down the damage per monster in a mob? If something else, please explain.
-A Sharp Eyes option Seems good. I can get on that as soon as possible.

I am happy that you guys are giving as much support as you are right now. I would just like to point out that Tempest only hits boss monsters for the damage shown; on normal mobs it freezes them and any attack will then 1HKO them.

Edit: So, yeah, if you mean damage per second of a skill, that can easily be changed. Maybe I can insert a row under the attacks per minute and above the total damage per second. I'll cook something up if that is what you mean.

|80 per min|
|SINGLE MONSTER|
|MOB TOTAL .|
|______________|
Reply
#10
WayOfTime Wrote:Tempest only hits boss monsters for the damage shown; on normal mobs it freezes them and any attack will then 1HKO them.

Does it hit each boss for the damage % * number of combos gained (in all cases, 4) or is it just the damage %?

If the former, tempest is immensely useful. If the latter, it's useless.
Reply
#11
Takebacker Wrote:Does it hit each boss for the damage % * number of combos gained (in all cases, 4) or is it just the damage %?

If the former, tempest is immensely useful. If the latter, it's useless.
I am entirely possitive that it is the former. For that long of a casting time for just 1500% would be horrible, and considering that it takes 200 combo for this move. In my calculator, I put it as 4 hits.


Edit: Finished adding in SE. Would you like me to add them now, or should I wait a week? =P

Side note: I will make you able to expand the width of the columns in my next update, because I realize that the damage is a little too high to fit in the later levels/higher mobs.
Reply
#12
WayOfTime Wrote:When you say average damage per second with avg critical chance, do you want me to show the damage of a singular strike of a normal attack? Or do you mean the damage per second of a skill, breaking down the damage per monster in a mob? If something else, please explain.
Uhm let's see... how should this be done... Tongue

Well, first of all, I meant an extra row under the 4 rows of max / min damages from the skills.

About the avg damage calculations, you'll need to split the:
- Clean normal (non critical) average damage
- Clean critical average damage (the clean critical extra damage, not the total combined damage with criticals like you have now in 2 rows).

Since criticals don't happens 100% of the time and at a fixed ratio with Arans, you'll need to make the clean ciritcal extra added average damage dependant on:
- SE yes/no (+0% or +15% chance)
- Combo counter (+0% / +10% / +20% / +30% / +40% / +50% / +60% chance)
And all make that into an average calculation (for example, max SE + max Combo = Clean critical -average- damage is multiplied by 0.75 since it "only" happens 75% of the time).

Then add the "normal average" and "clean critical average" damage together for the final average damage.

I hope you get what I mean. Smile
Reply
#13
Devil Wrote:Uhm let's see... how should this be done... Tongue

Well, first of all, I meant an extra row under the 4 rows of max / min damages from the skills.

About the avg damage calculations, you'll need to split the:
- Clean normal (non critical) average damage
- Clean critical average damage (the clean critical extra damage, not the total combined damage with criticals like you have now in 2 rows).

Since criticals don't happens 100% of the time and at a fixed ratio with Arans, you'll need to make the clean ciritcal extra added average damage dependant on:
- SE yes/no (+0% or +15% chance)
- Combo counter (+0% / +10% / +20% / +30% / +40% / +50% / +60% chance)
And all make that into an average calculation (for example, max SE + max Combo = Clean critical -average- damage is multiplied by 0.75 since it "only" happens 75% of the time).

Then add the "normal average" and "clean critical average" damage together for the final average damage.

I hope you get what I mean. Smile

I think I get what you mean. Make a new section under MIN where it shows (PER HIT) the damage without criticals, and the damage added purely by critical (PER HIT). Right?

Well, if I make that, it will have to be an option, since maybe not everyone would like it. But, very good sudjestion!
Reply
#14
WayOfTime Wrote:I think I get what you mean. Make a new section under MIN where it shows (PER HIT) the damage without criticals, and the damage added purely by critical (PER HIT). Right?
Well if you want to make it easy for yourself, make 3 new rows:
- Average non critical damage (easy: row3 + row4 /2)
- Average (only) extra added critical damage (based on the rate of criticals happening because of the non-fixed critical chance rate > see previous post)
- Combined normal + critical average damage

If you want you could hide these first two rows, but that would make things more complicated while you're working on it.

I can't help you with the average critical formula since you locked everything... xD
Reply
#15
Devil Wrote:Well if you want to make it easy for yourself, make 3 new rows:
- Average non critical damage (easy: row3 + row4 /2)
- Average (only) extra added critical damage (based on the rate of criticals happening because of the non-fixed critical chance rate > see previous post)
- Combined normal + critical average damage

If you want you could hide these first two rows, but that would make things more complicated while you're working on it.

I can't help you with the average critical formula since you locked everything... xD

Well, that seems like 2 new rows:
-Average non-critical, yes, it would be =(Min+Max)/2
-Then this one would be (Min+Max)/2*(Critical_value-1)*Critical_chance.
-Third is already displayed in Exp damage per shot.

Seems do-able, not too complicated, and I can complete it in a day or two.

And, yes, that is why I lock everything =P
Reply
#16
WayOfTime Wrote:Well, that seems like 2 new rows:
-Average non-critical, yes, it would be =(Min+Max)/2
-Then this one would be (Min+Max)/2*(Critical_value-1)*Critical_chance.
-Third is already displayed in Exp damage per shot.

Seems do-able, not too complicated, and I can complete it in a day or two.

And, yes, that is why I lock everything =P
Wait, Exp damage per shot / second is already average damage? What does Exp mean then? Smile
Reply
#17
Devil Wrote:Wait, Exp damage per shot / second is already average damage? What does Exp mean then? Smile

Expected? =)

Also, what would you say to a Black (white font) and a grey (White font)?
Reply
#18
Sn1perJohnE Wrote:Why does it seem calcs like this always seem to be restricted to Excell documents? a-@

Just seems like it would be more usefull if used in a more open format that doesnt require another program to use. Like a java app or something.

Idk, this is mainly ranting for annoying (to myself at least) trends that never seem to die.
Java apps do need another program to use, namely Java. Rolleyes

I guess spreadsheet calculators are popular because they're relatively easy to make and structure.
Reply
#19
I'll post this in a new post, since you might miss it when I just edit old posts:

I think there something wrong with your mastery calculation, Arans always swing with their polearms, they never stab, right?
So your minimum damage from the damage range should be calculated just MaxDamageRange*(0.6+high mastery value, like 0.3, with maxed high mastery)*0.9. Or I'm I wrong on that one? Smile

The minimum value of the (base) damage ranges isn't right. With maxed high mastery, An Aran should have a (base) range of (for example) 9187~11343, not 5638~11343. Maple may display this, but unlike DK's, Aran polearms always swing afaik, so the minimum value you use to calculate minimum damage isn't correct... Smile
Reply
#20
Devil Wrote:I'll post this in a new post, since you might miss it when I just edit old posts:

I think there something wrong with your mastery calculation, Arans always swing with their polearms, they never stab, right?
So your minimum damage from the damage range should be calculated just MaxDamageRange*(0.6+high mastery value, like 0.3, with maxed high mastery)*0.9. Or I'm I wrong on that one? Smile

The minimum value of the (base) damage ranges isn't right. With maxed high mastery, An Aran should have a (base) range of (for example) 9187~11343, not 5638~11343. Maple may display this, but unlike DK's, Aran polearms always swing afaik, so the minimum value you use to calculate minimum damage isn't correct... Smile

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


Forum Jump:


Users browsing this thread: 3 Guest(s)