The Aran Calculator V3.5

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

Yes, maple shows it, but that's not applied in-game for Arans.

What that attack range shows is Maple's implementations of the DK attack range, no matter if its a Polearm DK or Spear DK. Actually Maple has to show 2 ranges for DK's, but since there isn't room, it just shows both.

Assuming it's still basic 60% mastery (no High Mastery from 4th job):
3142~5818 -> For stabbing with a Polearm (DK style) <= This isn't correct for Arans, since they can't stab their polearm. Still it shows up.
3615~6696 -> For swinging with a Polearm (DK style) <= Aran's should display this value in stats...

At this moment, Arans attack range would show the attack range as 3142~6696, while it should show 3615~6696 with 60% mastery.

Assuming 4th job's High Mastery is maxed (90%):
4712~5818 -> For stabbing with a Polearm (DK style) <= This isn't correct for Arans, since they can't stab their polearm. Still it shows up.
5423~6696 -> For swinging with a Polearm (DK style) <= Aran's should display this value in stats...

At this moment, Arans attack range would show the attack range as 4712~6696, while it should show 5423~6696 with 90% mastery.

It's just a "bug", I'm surprised this still hasn't been fixed by Nexon... shouldn't be too hard... o.0

Get it?

Yes, maple shows it, but that's not applied in-game for Arans.

What that attack range shows is Maple's implementations of the DK attack range, no matter if its a Polearm DK or Spear DK. Actually Maple has to show 2 ranges for DK's, but since there isn't room, it just shows both.

Assuming it's still basic 60% mastery (no High Mastery from 4th job):
3142~5818 -> For stabbing with a Polearm (DK style) <= This isn't correct for Arans, since they can't stab their polearm. Still it shows up.
3615~6696 -> For swinging with a Polearm (DK style) <= Aran's should display this value in stats...

At this moment, Arans attack range would show the attack range as 3142~6696, while it should show 3615~6696 with 60% mastery.

Assuming 4th job's High Mastery is maxed (90%):
4712~5818 -> For stabbing with a Polearm (DK style) <= This isn't correct for Arans, since they can't stab their polearm. Still it shows up.
5423~6696 -> For swinging with a Polearm (DK style) <= Aran's should display this value in stats...

At this moment, Arans attack range would show the attack range as 4712~6696, while it should show 5423~6696 with 90% mastery.

It's just a "bug", I'm surprised this still hasn't been fixed by Nexon... shouldn't be too hard... o.0

Get it?

Yeah, you are right.

On the fact with Matt, we need someone to dig into the files again for MSEA with the Critical skill. Is it possible that someone, like Fiel, can do that to confirm this?

Tada?

 10 critical

Edit: Just had a chat with Fiel. It was quite interesting:

...Anyway, straight from the data:

Code:

skill.21110000.level.20.x    10
skill.21110000.level.20.damage    10
skill.21110000.level.20.y    6

I assumed that y = number of times stacked. It's entirely plausible that x is times stacked and y is probability and I just flipped them on accident. So yeah... stacking 10 times is a very real possibility.

This apparently means that it is possible that critical at max: stacks 10 times, does 10% damage each stacking, and 6% chance each stacking. So instead of +160% damage with a 60% chance, it is +200% damage with a 60% chance. I will update my calculator accordingly and only post it when Fiel confirms this.

Yeah, you are right.

On the fact with Matt, we need someone to dig into the files again for MSEA with the Critical skill. Is it possible that someone, like Fiel, can do that to confirm this?

Tada?

 10 critical

Edit: Just had a chat with Fiel. It was quite interesting:


This apparently means that it is possible that critical at max: stacks 10 times, does 10% damage each stacking, and 6% chance each stacking. So instead of +160% damage with a 60% chance, it is +200% damage with a 60% chance. I will update my calculator accordingly and only post it when Fiel confirms this.

Hasn't Fiel done the most he can do to confirm it at the moment? He has to guess which one it is, but only one of them allow me to the damage I can do. The most likely scenario is that it is +200%.

I don't think fiel has to confirm anything. People have said tons of times that the crit damage is +160% maxed out. *-*

I don't think fiel has to confirm anything. People have said tons of times that the crit damage is +160% maxed out. *-*

But that doesn't work. I posted a SS of me doing more damage than +160% from critical would let me!

EDIT: With a mac range of 6778, snow charge, and over 100 combo I hit a 20k touch damage to a skelegon. If criticals were 100% I could have only hit ~19k to a monster with 0 DEF. Since something in the calculations is probably incorrect, it makes the most sense that it is critical. And also, the only people that have said it is +160% haven't had experience on a real Aran,they are just basing it off on Fiel's best guess on which was x an which was y.

Also look at the Google translation of the skill, it makes enough sense to me. The last part says that it stacks up to 10 times. This is for level 20 combo critical.

10% critical damage, increase the probability of 6% each for up to 10 times

Original Korean text: 크리티컬 데미지 10%, 확률 6%씩 최대 10회 증가

But that doesn't work. I posted a SS of me doing more damage than +160% from critical would let me!

EDIT: With a mac range of 6778, snow charge, and over 100 combo I hit a 20k touch damage to a skelegon. If criticals were 100% I could have only hit ~19k to a monster with 0 DEF. Since something in the calculations is probably incorrect, it makes the most sense that it is critical. And also, the only people that have said it is +160% haven't had experience on a real Aran,they are just basing it off on Fiel's best guess on which was x an which was y.

Also look at the Google translation of the skill, it makes enough sense to me. The last part says that it stacks up to 10 times. This is for level 20 combo critical.


Original Korean text: 크리티컬 데미지 10%, 확률 6%씩 최대 10회 증가

That is all the confirmation I need, then. I will upload the two calculators shortly.

Edit: Once again, guys, you have been a real help. Here are the two calculators:
Vista
97-03

Check the Edits for V3.8 on the first page for full details.

This looks almost exactly like Sybaris' Archer calculator. Are you Sybaris?

This looks almost exactly like Sybaris' Archer calculator. Are you Sybaris?

No, but I did ask her permission to use her calculator as a template. Since her cells are locked, though, I used my own formulae. I also added other features, so there are diversities.

No, but I did ask her permission to use her calculator as a template. Since her cells are locked, though, I used my own formulae. I also added other features, so there are diversities.

I'm pretty sure her whole calculator is locked with no password. Same with mine. Yours is the only one I know of that has a password. Why? It's not like any of the calculations and formulae weren't taken from other people's testing to begin with.

I'm pretty sure her whole calculator is locked with no password. Same with mine. Yours is the only one I know of that has a password. Why? It's not like any of the calculations and formulae weren't taken from other people's testing to begin with.

Well, sorry to say it is. And I don't know fully why I decided to lock it...I just have a fear of some person stealing it and branding it as their own. Some of the things I placed in here feel like personal battles that I managed to accomplish and prevail over, because it takes a while to find the exact way to put them. If some people absolutely wanted to see an un-locked version, I may do so, but for accademic purposes only.

You may see me as someone big-headed and who has stolen a very good idea, but I would say you are wrong. And I feel like my achievement is being underminded to a degree. I feel hurt...

It would be cool if you could add in boss flags or a reminder that smart KB does not apply to bosses. I think a lot of people still don't know that smart KB doesn't work with bosses.

It would be cool if you could add in boss flags or a reminder that smart KB does not apply to bosses. I think a lot of people still don't know that smart KB doesn't work with bosses.

Nice sudjestion. I did not think of that. I will do both! =)

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

Here are the links:
Vista Version
97-03 Version

If you have any other sudjestions, feel free to ask.


By the way: Sorry if this sounds impertinent, but how does one get their thread to qualify to be stickied? Do they need to have their thread absolutely necessary to the community, or something along those lines?

Issues:

• Aren't the rows "Average HKO" and "HKO Range" worthless because you can't just spam skills such as Double Swing and Combo Peril?
  
• Your "Chance of OHKO" is wrong because you didn't factor in the Law of Large Numbers for any of Aran's 2-hit skills. Also, the "Chance of OHKO" isn't helpful if you can't even do that attack first on a monster. For example, you'd have to do regular attack and Double Swing before you can even do Triple Swing -- at which point your chance to OHKO is irrelevant. Also, Double Swing shows 100% chance to OHKO regardless of monster HP.
  
• Your list of choosable attack potions, while pretty looking, are somewhat annoying if you want to use a potion not on the list. Witch Brew and Naricain Elixers come to mind. I'd say it's easier on everyone, especially for future planning, if you do away with it entirely and let the person enter in their own attack pot.
  
• Do you honestly think anyone gets use out of the "meso/shot" and "exp/shot"? Especially since it suffers from the same non-spammability issue mentioned above. I'd just get rid of it.
  
• Your DPS (labeled "Exp Damage per Second") doesn't make sense. You don't spam regular attack, double swing, or triple swing, so those are invalid. Better to have just one big box cover all 3 cells that expects you to spam all 3 skills. Then, for skills like Final Blow, assume that the person does Final Blow after every Double -> Triple, since that's obviously not spammable either.

Also, didn't you say you put a password on it? I was able to unlock it without a password. So unless OpenOffice can just hack documents, you forgot to password your stuff.

I really need to steal Excel. I hate having to view good spreadsheets made in Excel with OpenOffice because they look like garbage.

Issues:

• Aren't the rows "Average HKO" and "HKO Range" worthless because you can't just spam skills such as Double Swing and Combo Peril?I guess for this it might seem useless, but it just shows how many attacks of that type you would need to kill the monster. Basically, it is just some eye-candy in this case and eliminates the need to add it in later when someone asks.
  
• Your "Chance of OHKO" is wrong because you didn't factor in the Law of Large Numbers for any of Aran's 2-hit skills. Also, the "Chance of OHKO" isn't helpful if you can't even do that attack first on a monster. For example, you'd have to do regular attack and Double Swing before you can even do Triple Swing -- at which point your chance to OHKO is irrelevant. Also, Double Swing shows 100% chance to OHKO regardless of monster HP.I'll see what I did wrong on the LLN. And on the fact of DS, I have had that issue for a while, but have not been able to find a way to solve it effectively.
  
• Your list of choosable attack potions, while pretty looking, are somewhat annoying if you want to use a potion not on the list. Witch Brew and Naricain Elixers come to mind. I'd say it's easier on everyone, especially for future planning, if you do away with it entirely and let the person enter in their own attack pot. That may be the best way... I'll just remove the images, and the buttons, and put the -add potion- at the side somewhere. It may be an option, though.
  
• Do you honestly think anyone gets use out of the "meso/shot" and "exp/shot"? Especially since it suffers from the same non-spammability issue mentioned above. I'd just get rid of it. Well, it just shows how much meso/exp you would earn for that particular attack.
  
• Your DPS (labeled "Exp Damage per Second") doesn't make sense. You don't spam regular attack, double swing, or triple swing, so those are invalid. Better to have just one big box cover all 3 cells that expects you to spam all 3 skills. Then, for skills like Final Blow, assume that the person does Final Blow after every Double -> Triple, since that's obviously not spammable either.As mentioned above, this would show the damage per second of that skill, so it would help in choosing which skill to use after another. You can say that is obvious (Final Blow), but it would be the difference between finishing the monster, or pushing them away for another monster.

Also, didn't you say you put a password on it? I was able to unlock it without a password. So unless OpenOffice can just hack documents, you forgot to password your stuff. Does OO have a password protection thing in its files and abilities? That is really disconserting in the fact that it does not recognize a "secure file."

I really need to steal Excel. I hate having to view good spreadsheets made in Excel with OpenOffice because they look like garbage. May I ask what this sheet looks like in OO? It might persuade me to make an OO exclusive sheet.

(Attempted) answers in bold.

I guess for this it might seem useless, but it just shows how many attacks of that type you would need to kill the monster. Basically, it is just some eye-candy in this case and eliminates the need to add it in later when someone asks.

Why would anyone ask for something useless? Maybe consider which rows are good for Aran instead of insisting on keeping every row Sybaris had in his calc for whatever reason.

Well, it just shows how much meso/exp you would earn for that particular attack.

Yes. I'm aware of that. That's what it says it is. I'm asking if you think anyone gets any use out of it. Would you (or anyone for that matter. Speak up if you would) actually use this to find out how many mesos you're theoretically making/losing? It's not really applicable for Aran since they're constantly hitting a different number of monsters and using different skills. I'm not trying to be mean, I just want to help you get rid of some of the things on it that might not have any use for anyone so that it looks better.

As mentioned above, this would show the damage per second of that skill, so it would help in choosing which skill to use after another. You can say that is obvious (Final Blow), but it would be the difference between finishing the monster, or pushing them away for another monster.

Yeah, reiteration. But wouldn't you use the "Exp Total Damage" for this as opposed to the DPS? I don't know about you, but when I think DPS, I think damage to a single monster over time. I don't see how that could possibly be used to figure out which attack to use next.

Does OO have a password protection thing in its files and abilities? That is really disconserting in the fact that it does not recognize a "secure file."

Yeah it does. You can password protect the document, but you don't have to put in a password. Your document was locked when I got it; it just didn't have a password. So either you didn't put in a password, or OpenOffice doesn't think any excel documents have passwords. So I have all your formulae now. I'm gonna put my name on it and post it in some KMS forum and tell everyone how dumb you are now. Then it's world domination time, baby.

May I ask what this sheet looks like in OO? It might persuade me to make an OO exclusive sheet.

 Here ya go

Ugly, ain't it? I can't even see a lot of it. I have to click on the box in question and look at what it says on top.

EDIT: Oh, what's up with the two floating checkboxes in the mid-left? Nevermind. But I shouldn't be able to check both of them at once, right? That doesn't make sense.

 Here ya go

Ugly, ain't it? I can't even see a lot of it. I have to click on the box in question and look at what it says on top.

EDIT: Oh, what's up with the two floating checkboxes in the mid-left? Nevermind. But I shouldn't be able to check both of them at once, right? That doesn't make sense.

Can not...breathe...from...sheer...horror! That really destroys the spread sheet! The problem with having only one check box is that you can not alternate easily between the two. Having two gives you the option of "what-if" scenerioes.

What would you suggest instead of two seperate buttons? Maybe one button for "weak/strong to ice" and then another that if checked it is weak and unchecked it is strong against? That may work.

P.S. THE HORROR!

You should get a default +100% damage at a rate of 10% with an additional +x% damage and +y% rate each time it stacks, up to 10, totaling for +200% at 70% Chance maxed.

What would you suggest instead of two seperate buttons? Maybe one button for "weak/strong to ice" and then another that if checked it is weak and unchecked it is strong against? That may work.

A drop-down box, silly. Like in my spreadsheet. Have it be set to Neutral by default, then be able to drop down between "Weak" and "Strong." Although weak is somewhat moot since if you would be attacking something that's strong to Ice, you'd just turn off Snow charge, it's hardly too much effort to just add it anyway.

A drop-down box, silly. Like in my spreadsheet. Have it be set to Neutral by default, then be able to drop down between "Weak" and "Strong." Although weak is somewhat moot since if you would be attacking something that's strong to Ice, you'd just turn off Snow charge, it's hardly too much effort to just add it anyway.

The only problem with that would be that I have to show when the monster is already strong/weak to ice as show on the Monster Table. So, leave those cells that show if it is strong/weak, take away the buttons, and add a scroller.

And, JoeTang, you mean 60%? I think I solved the critical problem also. Thanks though!

The only problem with that would be that I have to show when the monster is already strong/weak to ice as show on the Monster Table. So, leave those cells that show if it is strong/weak, take away the buttons, and add a scroller.

And, JoeTang, you mean 60%? I think I solved the critical problem also. Thanks though!

No, I mean 70%. 10 + 6 * 10 = 70.