The Aran Calculator V3.5

Well, I finally updated my calculator. The updates are as follows:
-Changed the Combo Skills so that they show the actual damage (Originaly I had them follow the same decreasing damage)
-Added an Accuracy to 100% monsters at that level. The number turns red when you do not have enough accuracy, and green when you can 100% hit the monster.
-Made it possible to delete the formula in the Potion Attack section if you do not like the options. The formula is able to be seen so you can re-add it later.
97-03 Version 4.0
Vista Version 4.0


Like all of the other times, feel free to offer any sudjestions.

sudjestions.

...suggestions?

The Exp/Shot, Meso/Shot, Chance of OHKO, HKO Range, Average HKO, and Exp Damage per Second rows are still completely useless. They're all either moot, don't account for non-spammability, or just plain wrong. And you still have those pictures of attack pots even though you can already enter in your own value.

You know what's useful? The expected damage of regular attack + double swing + triple swing. In fact, I think you should have a whole column dedicated to treating the three of them as a single attack so people can use it to see their DPS with that or their expected damage on a single monster with the whole combo. It appears you already have this with the Combo checkbox. Don't forget to adjust the cast time of double, triple, and any of the finishers to account for the time it takes to cast the things preceding it.

Minor notes:

• Monster HP is limited to 30000. You should remove that limit.
  
• Monster Def should be limited at 1999.
  
• The "PA Combo Count" box has a limit of 10. Didn't you mean 100?
  
• What does the "Critical Count" box do?
  
• What does the Combo checkbox (floating between Player Stats and Monster Stats) do? Nevermind, figured it out. You should make that more clear, though.
  
• The Mon MAtk cell on the right references monster def, not monster mattack. Put in "=INDEX(Monsterlist;D35;9)"
  
• The limits for player def/mdef are 1999, not 999.
  
• Why are INT and LUK in the Monster Damage section?
  
• Consider adding a section for player HP/MP in the space where you'll (hopefully) rip out those useless rows I mentioned above.
  

Oh umm... I was right about OpenOffice totally ignoring passwords set by Excel. I couldn't unprotect your document in Excel, but I can see everything in OpenOffice. Turns out Dusk's calculator was protected with a password too, but his formulae weren't hidden.

...suggestions?

The Exp/Shot, Meso/Shot, Chance of OHKO, HKO Range, Average HKO, and Exp Damage per Second rows are still completely useless. They're all either moot, don't account for non-spammability, or just plain wrong. And you still have those pictures of attack pots even though you can already enter in your own value. So having just an attack area that can be modified without those pretty images? I'll need to put something fancy up, then~

You know what's useful? The expected damage of regular attack + double swing + triple swing. In fact, I think you should have a whole column dedicated to treating the three of them as a single attack so people can use it to see their DPS with that or their expected damage on a single monster with the whole combo. It appears you already have this with the Combo checkbox. Don't forget to adjust the cast time of double, triple, and any of the finishers to account for the time it takes to cast the things preceding it.I already have them added, but maybe have the amout of damage if it can be spammed may be good. But, that would kind of be stupid =P (Sometimes stupid is good, though. Hurray for redundancies!)

Minor notes:

• Monster HP is limited to 30000. You should remove that limit.Good Catch, but the limit that excel will ALLOW you is 30K.
  
• Monster Def should be limited at 1999.O.k.
  
• The "PA Combo Count" box has a limit of 10. Didn't you mean 100?What this means is how many times it stacks. So, at level 6, it can stack 6 times. You put 6 in so it will be +6 atk, +30 def, and +30 Mdef
  
• What does the "Critical Count" box do?Same as above: this shows how many times that Critical stacks. It is limited to what the max is, so it will not raise past its limit, but it works.
  
• What does the Combo checkbox (floating between Player Stats and Monster Stats) do? Nevermind, figured it out. You should make that more clear, though. I outlined it in my first post in the List of Features. I'll put a comment, though.
  
• The Mon MAtk cell on the right references monster def, not monster mattack. Put in "=INDEX(Monsterlist;D35;9)"Yet again, good catch.
  
• The limits for player def/mdef are 1999, not 999.O.k. Thank you.
  
• Why are INT and LUK in the Monster Damage section? Believe it or not, STR, DEX, INT, and LUK all are used for the formula. Each of the 5 classes have a different defence formula. The one for Warriors (where Arans are unseromoniously) for max is:=(M_WATK^2*0.008-WDEF*A_Formula-(WDEF-StandPDD)*B_Formula) where
  • A_Formula is =Mod+0.28
    
  • Mod is =(STR)/2800+(DEX)/3200+(INT)/7200+(LUK)/3200
    
  • B_Formula is =IF(WDEF>=StandPDD,(Mod*28/45+(LVL)*7/13000+0.196),(Mod+(LVL)/550+0.28)*C_Formula)
    
  • C_Formula is =IF(LVL>=monster_lvl,(1/(1+(LVL-monster_lvl)/13)),1.3)
    
  • and StandPDD depends on your level (level 100 is 494)
  Fun, eh?
  
• Consider adding a section for player HP/MP in the space where you'll (hopefully) rip out those useless rows I mentioned above. So you mean the max/min that you can have in HP?
  

Oh umm... I was right about OpenOffice totally ignoring passwords set by Excel. I couldn't unprotect your document in Excel, but I can see everything in OpenOffice. Turns out Dusk's calculator was protected with a password too, but his formulae weren't hidden.

Main answers are in bold. What I am thinking for the sheet is merging the PA combo count and the Critical Combo Count together and have them raise by 10 each time and go up to 100. Maybe I can use the same check box. I will change the calculator by the end of the week, so check again (for sure) on saturday.

So you mean the max/min that you can have in HP?

Really, I mean something similar to what's in my calc.

 Spoiler

I have people put in their base and +HP and MP (you can't see the +HP/MP in the pic) and various other numbers I find useful. Also, I say how many times you can wash (Points Washable), how many points you have in HP that have yet to be washed (Points to Wash), and your theoretical HP were you to wash all your Points Washable right now. Considering that lots of Aran HP wash, you could do this or maybe something more like the HP/MP calc that was made in the training center. As you can see, I like comments (and parentheses). Really, I just put a comment on any cell that a random user might find ambiguous to make it a little more clear and help them understand how my calc works better.

Updated the calculator. You can view it on the main page. I added the HP and MP area, but it looked lopsided under all of the information, so I made two separate ones that has it in different areas. The first one has it under where all the things like HKO and exp/shot were, where the other one has it under the Damage Recieved area beside the intact info. So, you can choose wether or not you want to take away all of those cells.