Page 1 of 1

Points League Rankings

Posted: January 23rd, 2012, 9:19 pm
by cccp00a
Hello,

Just purchased the platinum package as I wanted to move to this site from others I have used in the past. Software looks good and I like the projections.

But, a number of my leagues are points based. Is there any current system or plans in the future to allow the ability to input points to certian categories and then have the rankings based on these settings?

Thanks
Scott

Re: Points League Rankings

Posted: January 23rd, 2012, 9:34 pm
by Todd Zola
If you post your scoring system, I can either cyber-talk you through the means to do it (depending on your Excel acumen) or I can set it up for you.

Re: Points League Rankings

Posted: March 13th, 2012, 7:41 pm
by SteveSteve2000
I am in a total points league as well. Can you help me with using some of your excel tools?

I have already figured out your hitters and pitchers projections. does any of your draft or CVRC software?

Re: Points League Rankings

Posted: March 13th, 2012, 8:09 pm
by Todd Zola
SteveSteve2000 wrote:I am in a total points league as well. Can you help me with using some of your excel tools?

I have already figured out your hitters and pitchers projections. does any of your draft or CVRC software?
Sorry, i don't understand what you are saying then asking.

But to make a guess, I can tweak the CVRC into producing rankings based on your scoring system if you post your league spec, etc.

Re: Points League Rankings

Posted: March 13th, 2012, 8:38 pm
by SteveSteve2000
Oh boy. I didnt finish my sentence.

You guessed correctly. Wondering how you make the CVRC software sort by points?

Re: Points League Rankings

Posted: March 13th, 2012, 9:50 pm
by Todd Zola
Depends on how good you are with excel. Basically, you set up a formula to calculate the points, then copy/paste that into one of the categories and tell the CVRC to only count that category using the category weights.

If you post your scoring system and league specs, I can post directions.

Re: Points League Rankings

Posted: March 14th, 2012, 6:24 pm
by SteveSteve2000
very good with excel. so basically i enter my scoring formula into say the "HR" category (my scoring is based on TB so the HR category is useless) then on the "league setup" tab under "category weights" i would make "HR" 1 and all the rest 0? likewise for pitchers say "ERA" (we score based on earned runs not ERA specifically). if this is right dont worry about instructions. i know what to do.

just in case my scoring is as follows:

2pts per sb. 1pts per tb, rbi, run, bb, hbp, sac, sf. -1pts for k, cs.
10pts per win and save. 3pts per IP. 1pts per k. -1pts per bb, hit, er. -5pts per loss and blown save.


also does this work with the draft software?

Re: Points League Rankings

Posted: March 14th, 2012, 8:42 pm
by Todd Zola
SteveSteve2000 wrote:very good with excel. so basically i enter my scoring formula into say the "HR" category (my scoring is based on TB so the HR category is useless) then on the "league setup" tab under "category weights" i would make "HR" 1 and all the rest 0? likewise for pitchers say "ERA" (we score based on earned runs not ERA specifically). if this is right dont worry about instructions. i know what to do.

just in case my scoring is as follows:

2pts per sb. 1pts per tb, rbi, run, bb, hbp, sac, sf. -1pts for k, cs.
10pts per win and save. 3pts per IP. 1pts per k. -1pts per bb, hit, er. -5pts per loss and blown save.


also does this work with the draft software?
Yes on the hitting and almost on the pitching. The ERA is funky because it is a ratio category,so you need to do it under a counting category. Please use strikeouts since the replacement calculation is funky for wins and saves -- strikeouts it is straightforward. Just use a cell to the right for the formula, then copy - paste special - values into the strikeout column and you are good to go.

I am not sure about Mastersdraft, though I think it should work the same way, leave the points in HR and K and tell MD the weights and it should be fine.