I was wondering if anyone has ever created a spreadsheet (excel) to calculate the spell damage / total damage taken by enemy (including pierce)
I'm trying to make one but my brain starts melting halfway.
It could be useful to check what stat is best to boost when you can choose between +skill or +sd%, synergy, Energy factor to SD... Typically when crafting items.
yes and no.
Some people - me included - made excel sheets to compare gearing options in terms of Spell Damage. Since every spell scales differently with the skill level, this is the only part that cannot be implemented easily. Most of those documents are made for private use only since they are neither convenient to use nor fool proof.
Stick to the TLDR: Pierce -> SD -> ene+ EF. Later on balance the stuff with your Abacus