Talk:Damage Calculator/@comment-11753608-20130825054805/@comment-11753608-20130825174950

Even if it makes it look more confusing, if I could get this set up so I can cut and paste the exact same equation into everycell, I would nut myself.

Reformating the enemies table is easy as using a pivot table cut and paste. However, wouldn't INDIRECT("A"&ROW,TRUE) require the mob name to be on every line? That would look sorta messy.

The other two roadblocks I can think of -


 * 1) Dealing with protected and unprotected body parts - in order to get this to work we would have to set up another INDIRECT check for body parts, add columns to the enemies table, and then set up an IF check in the calcs page to determine whether to apply armor or not.


 * 1) Dealing with damage type MPs would require also adding a damage type column for every damage type on every enemy and putting in a MP, even if it is 1.

There is also a much cleaner way in dealing with the base damage stuff I think but what is there on the calcs page is a evolution of my understanding of excel as I was making this thing. I could simply have each cell of the calcs sheet do an IF check on B4 to see if it matches the header and then plug in the value of modded base damage directly into the equation.

These edits are so significant it begins to feel like I should just start from scratch which is daunting.