Thanks guys. I've fixed the calculation issues with the green flow spell (thanks joey). I've also updated the original post to read simply spreadsheet vs Excel file so that I'm using politically correct non platform specific descriptions..
You are correct Joey, with the melee damage and will work that into the spreadsheet at some point with specifics on your characters dex vs enemies etc..
Also added a note that the spreadsheet applies specifically to PVM and not PVP for spell damage.
David
Forgotten Tales ID - davidjett1
"True humility is not thinking less of yourself; it is thinking of yourself less." C.S. Lewis
Stat sheet now includes a selectable drop down of every monster in FT along with that monsters stats.
New calculations will show the following when selecting a particular monster.
v2014-08-10
-Now has a drop down for all enemies including enemy stats (Missing stats Shadow Mage and Freya
-New Calculation - Chance of hitting enemy in percentage based on dexterity match and possible die roll
-New Calculation - Damage done to enemy based on die roll (4 or 5 critical)
-New Calculation - Damage done to enemy if non-critical roll (ARM vs DMG)
-New Calculation - Number of hits required to kill enemy IF NO criticals ever rolled (worst case scenario)
I have not found information on how the enemies within FT do damage. Based on die roll system I'm believing they follow same Damage delivered rules that the players follow. IE, they roll per hit and do Damage minus Player Armor UNLESS a critical hit is landed delivering 100% of potential damage to player. Assuming also that monster criticals are also a 4 or 5 roll? Can someone confirm?
David
Forgotten Tales ID - davidjett1
"True humility is not thinking less of yourself; it is thinking of yourself less." C.S. Lewis
davidjett wrote:I have not found information on how the enemies within FT do damage. Based on die roll system I'm believing they follow same Damage delivered rules that the players follow. IE, they roll per hit and do Damage minus Player Armor UNLESS a critical hit is landed delivering 100% of potential damage to player. Assuming also that monster criticals are also a 4 or 5 roll? Can someone confirm?