Quote Originally Posted by Kenji1134 View Post
But beyond just having the damage formula, we also need a way to get some useful data out of it.
There's one thing wrong with this unless you're formulating this on a rotation basis;
The key thing missing by just checking changes in potency is interactions, rng, and procs from abilities and the fact that even though theres a set amount of crit rate, that you have more chances to crit when an ability is used more.

It's hard to pin a weight when you can't formulate/simulate a scenario.
If you really want to do this via a spreadsheet I'd recommend trying to pin a perfect rotation down over a span of say minutes and check the amount of abilities used during that duration. You can calculate damage etc from that amount and get real DPS and formulated weights for that run. You can then adjust the crit values to an assumed average and try to generate a nice report and weights based on this.