I updated the file and it is working for me, although rather slowly. It did not take this long to calculate previously, so wondering if it is my computer. (Doing a restart did seem to help).
You still have to manually pull down or delete the rows on the draft_pool_edit tab to the correct amount and also change the columns EW and EX on the PasteDataHere tab, including editing the range formula of the rank column.
What it cannot yet do which seems to be a big flaw in feeder leagues is change the ratio of starting to relief pitchers. It would need to add another pitch to some segment of the population but has no way of doing that now.
Last edited by stealofhome; 11-07-2018 at 08:24 AM.
|