Water cannon Range modifier

I owe you a bit of an apology. We got off on the wrong foot. Which I am completely to blame for. I come in here and say your formula is wrong. A formula you obvious spent a good amount of time on. That you included a distance modifier at all was a pleasant surprise. At the time I started examining water cannon damage, the concept was foreign to the high level alchemists I talked to on Mari.

I also unintentionally misled you. I logged on my test character to test your claims some more, and discovered its WC rank was not rF as I suggested you test.

My low rank test subject had rN water cannon.

So, I dug out my notes for the testing I did. At max range, rN WC, rN AM, r6 crit, no enchants vs young brown legged fennec foxes, I had a non-crit damage range of 2-8. I'm not sure how that 8 fits with any rounding in your formula, but it's close enough to 60% to make it a non-point of interest to me. However, my damage range for crits was 12-22, which does not in anyway match your formula. At minimum range, same test subject same target, I had a non crit damage range of 7-22 and a crit range of 30-44, which does not match your range of distance modifiers.

I ranked the WC of my tester to rF and shot off a total of 300 water crystals at max range and minimum range at the same young brown legged fennec foxes as I did in my previous tests. I didn't record results tonight, as I was looking for minimums and maximums. At Maximum range, the non-crit damage fell never fell below 9, which is consistent with 60% distance modifier, however the max damage was slightly higher than what 60% would allow. Crit hits were usually within the appropriate range for your formula, though I had a few that were higher than they should be. The interesting thing here is that the crits were not substantially higher than you would expect from a normal crit on the lower damage of your formula. and certainly nowhere near as out of the norm as rN. At minimum range, I did hit values higher 100% for both non-crit and crit hits, though it was not as common as it had been at rN.

So, my question is: why doesn't your formula's crit work for rN at max range?