The Aran Calculator V3.5

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