Anyone know of a formula for taking a given lineup of spots and applying it to a group of players of varying sizes & eligibilities?
I’ve tried recreating my own offline for projection based stuff but it’s always clunky and difficult to modify. Wondering if there is some basic stuff I’m overlooking.
So I have a bit of experience with this due to OPL. You’re gonna want a linear algebra solver to do this kind of math. It isn’t a simple formula, unfortunately.
OPL uses my fork of a PHP library:
This may be a path forward in Excel, I’m not sure. I miswrote earlier, I should have said “Linear programming”.