FF3 Monster Damage Excel Spreadsheet

I'm gonna be real nitpicky, so feel free to tell me to buzz off, but having an average defense of 128 is perhaps misleading. Terra's starting defense is 97, and as such, 128 is surpassed rather quickly. If I were making such a spreadsheet, I'd probably add a graph that projects the damage for all defense values. I can imagine that may be beyond the scope of the file, so I'd at least recommend declaring what average defense is so that the user knows what benchmarks are being used.

I was going to do that, but I could not find the formula anywhere online to accomplish this.  If you can find the algorithm, I can do it.  I just don't know how the game factors it!  For some reason, only the other part of the formula was listed on various sites.