Page 1 of 1

Need help with CVRC

Posted: April 7th, 2016, 9:53 am
by CaptainTrunk
I think I have CVRC working properly. The values look reasonable. However, my league is 6x5. We have the standard 5 categories, but also add doubles-plus-triples to hitting.

I made a copy of the spreadsheet, then changed the projections page to put in the sum of DT into the HR column. Then I re-ran CVRC. The dollar values given for DT look fine. But I don't know what to do next. I now have an individual dollar number for each category, but if I just add in DT to the other total, then my budget's off since it's free money being added.

Do I just reduce each category by a certain percentage? I'm not sure how to figure out what percentage to use. I'm thinking that I just add the DT dollar amounts in, then figure out the total dollar amounts, and apply a universal percentage discount to get it back to the target dollars for all hitters.

My second thought was to reduce the category weights. So, if I was using 1's across the board, I would just change them to .8. That didn't help. It looks like those numbers are just relative.

My third thought was to reduce the team salary cap or reduce the hitting percentage. But I think that would do the same thing as my first idea.

Ideas?

Also, if I'm going to use CER, what would you suggest I use for the weights? Again, assuming that I have to run it twice.

Thanks.

Re: Need help with CVRC

Posted: April 7th, 2016, 11:09 am
by Todd Zola
I wouldn't use CER.

Averaging the two runs is probably the best - nothing is perfect but it really doesn't matter since the trick in auctions is always seeing how the market ranks players relative to you and finding the soft spot. I'd probably make a note how the players that move way up or down with <troubles> are handled since most of your league mates will adjust intuitively.

Re: Need help with CVRC

Posted: April 7th, 2016, 11:11 am
by CaptainTrunk
OK, thanks.