Damage formula problems

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!

You give each cell one PDRignore contribution (say... [0.3, 0.15, 0.1, 0.1]), then in another row you take its difference with 1 [0.7, 0.85, 0.9, 0.9], then multiply these last cells together [=PRODUCT(...)]. You can easily combine these together into a 1 or 2 step operation without making the formulae too unwieldy. My usual formula is 1 - PDR*(PRF), where PRF is PDR reduction factor which is the "=PRODUCT(...)" cell.

Learn to use decimals to represent fractions, and don't put too much into one cell. You will have hell troubleshooting.

For the observable damage issue, check your character cards, IA and equipment (especially rings) and stuff. You may have a source of those numbers that you didn't factor in.

Hadriel