The Aran Calculator V3.5

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.