2014-02-21, 06:12 PM
Hey there! I've been messing around with a range/damage calculator in Excel and the range part works great. I can't seem to get the damage part right though. I'm getting some pretty weird numbers (much more stable and higher damage ingame though so I'm not complaining about that!).
The formula I'm using is this: floor(maxrange*(1-([monster PDR]*(1-[my PDR]/100))/100)*maxcritdmg/100) for normal attack max damage.
(PDR part might seem a bit messy but it works.)
Is anything wrong here? Or am I missing something on the Max crit part maybe? Base should be 120-150% and Adrenaline and Expert gives an NL a total of 25% more, making it 175%. Adding an extra 5% here and 20% for Min crit puts the damage just above/below the highest/lowest seen ingame. If I start messing with Quad Star this no longer works though, and I'm still getting higher damage ingame so I guess it's not the crit part (I did remember to account for reinforce hypers here). I should probably try testing without critical but it's not easy with 105% critrate.
Any ideas?
(Bonus question: Any way to make Excel calculate multiplicative PDR for a full row? Without making it a huge formula repeating [*(1-n/100)] for every cell?)
Thanks!
The formula I'm using is this: floor(maxrange*(1-([monster PDR]*(1-[my PDR]/100))/100)*maxcritdmg/100) for normal attack max damage.
(PDR part might seem a bit messy but it works.)
Is anything wrong here? Or am I missing something on the Max crit part maybe? Base should be 120-150% and Adrenaline and Expert gives an NL a total of 25% more, making it 175%. Adding an extra 5% here and 20% for Min crit puts the damage just above/below the highest/lowest seen ingame. If I start messing with Quad Star this no longer works though, and I'm still getting higher damage ingame so I guess it's not the crit part (I did remember to account for reinforce hypers here). I should probably try testing without critical but it's not easy with 105% critrate.
Any ideas?
(Bonus question: Any way to make Excel calculate multiplicative PDR for a full row? Without making it a huge formula repeating [*(1-n/100)] for every cell?)
Thanks!