New Member, ZERO Excel Skills... CVRC for Points League
-
- Double-A
- Posts: 13
- Joined: February 25th, 2017, 4:11 am
New Member, ZERO Excel Skills... CVRC for Points League
I would really appreciate help getting my CVRC off the ground for my H2H points league. I've never had a need for Excel in the past, but I'm a quick learner. Just need a little advice how to get started. Thanks in advance!
Eric
Eric
Re: New Member, ZERO Excel Skills... CVRC for Points League
Welcome aboard!
Please post your league parameters and scoring.
Please post your league parameters and scoring.
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
-
- Double-A
- Posts: 13
- Joined: February 25th, 2017, 4:11 am
Re: New Member, ZERO Excel Skills... CVRC for Points League
Batting
Single: 1 point
Double: 2 points
Triple: 3 points
Home Run: 4 points
Run Scored: 1 point
RBI: 1 point
Hit by Pitch: 1 point
Stolen Base: 1.5 points
Walk: 1 point
Strikeout: -1 point
Starting Pitching
Appearance: 1 point
Inning: 1 point (scored in 0.33 points per ⅓ of an inning pitched)
Earned Run: -1 point
Strikeout: 1 point
Win: 5 points
Loss: -5 points
Quality Start: 5 points
Complete Game: 5 points
No Hitter: 25 points
Perfect Game: 50 points
Relief Pitching
Appearance: 1 point
Inning: 1 point (scored in 0.33 points per ⅓ of an inning pitched)
Earned Run: -1 point
Strikeout: 1 point
Win: 5 points
Loss: -5 points
Hold: 2 points
Save: 3 points
Blown Save: -3 points
Single: 1 point
Double: 2 points
Triple: 3 points
Home Run: 4 points
Run Scored: 1 point
RBI: 1 point
Hit by Pitch: 1 point
Stolen Base: 1.5 points
Walk: 1 point
Strikeout: -1 point
Starting Pitching
Appearance: 1 point
Inning: 1 point (scored in 0.33 points per ⅓ of an inning pitched)
Earned Run: -1 point
Strikeout: 1 point
Win: 5 points
Loss: -5 points
Quality Start: 5 points
Complete Game: 5 points
No Hitter: 25 points
Perfect Game: 50 points
Relief Pitching
Appearance: 1 point
Inning: 1 point (scored in 0.33 points per ⅓ of an inning pitched)
Earned Run: -1 point
Strikeout: 1 point
Win: 5 points
Loss: -5 points
Hold: 2 points
Save: 3 points
Blown Save: -3 points
Re: New Member, ZERO Excel Skills... CVRC for Points League
Half way there -- also need league parameters (size, roster composition).
The only stat not projected is blown save (really can't project CG/NH/PG). I actually project BS, it's just not on the downloads. Maybe I can add it down the line.
HITTING
Download the HITCVRC
HITTERS TAB
in cell Z2, type =L2+M2+N2+O2+1.5*Q2+V2-P2
L2 is total bases, which accounts for the 1B, 2B, 3B and HR points. Hopefully you can pick up the idea behind that formula. Starting with "=" tells excel you're about to enter a formula. You don't have to actually type "L2" etc, you can click in the cell to have it appear, then type the next operation, then the cell etc.
Next step is left-clicking and holding on cell Z2 then dragging down to the end of the data, then releasing. This highlights that column. Now hit CTRL d simultaneously. This fills the formula all the way down.
Let me know you got this far by posting how many points Jose Abreu is projected for, then provide the league parameters and I'll work you through the rest of hitting and pitching.
The only stat not projected is blown save (really can't project CG/NH/PG). I actually project BS, it's just not on the downloads. Maybe I can add it down the line.
HITTING
Download the HITCVRC
HITTERS TAB
in cell Z2, type =L2+M2+N2+O2+1.5*Q2+V2-P2
L2 is total bases, which accounts for the 1B, 2B, 3B and HR points. Hopefully you can pick up the idea behind that formula. Starting with "=" tells excel you're about to enter a formula. You don't have to actually type "L2" etc, you can click in the cell to have it appear, then type the next operation, then the cell etc.
Next step is left-clicking and holding on cell Z2 then dragging down to the end of the data, then releasing. This highlights that column. Now hit CTRL d simultaneously. This fills the formula all the way down.
Let me know you got this far by posting how many points Jose Abreu is projected for, then provide the league parameters and I'll work you through the rest of hitting and pitching.
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
-
- Double-A
- Posts: 13
- Joined: February 25th, 2017, 4:11 am
Re: New Member, ZERO Excel Skills... CVRC for Points League
Type: 10 Team, H2H points, AL/NL mixed, weekly games, 5-player retainer league
No. Games: 22 regular season, 3 playoff
Each team can carry a maximum of 22 players:
17 active players (required)
9 Hitters
C (1), 1B (1), 2B (1), 3B (1), SS (1), OF (3), DH (1)
Note: DH can be player of any hitting position
5 Starting Pitchers (SP)
3 Relief Pitchers (RP)
4 reserve players (required)
Can be of any position
1 injured reserve player (optional)
Can be of any position
No. Games: 22 regular season, 3 playoff
Each team can carry a maximum of 22 players:
17 active players (required)
9 Hitters
C (1), 1B (1), 2B (1), 3B (1), SS (1), OF (3), DH (1)
Note: DH can be player of any hitting position
5 Starting Pitchers (SP)
3 Relief Pitchers (RP)
4 reserve players (required)
Can be of any position
1 injured reserve player (optional)
Can be of any position
Re: New Member, ZERO Excel Skills... CVRC for Points League
If you confirm you were able to follow the directions above, I can walk you through the final steps.
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
-
- Double-A
- Posts: 13
- Joined: February 25th, 2017, 4:11 am
Re: New Member, ZERO Excel Skills... CVRC for Points League
Abreu 414.5 is what I have.
Re: New Member, ZERO Excel Skills... CVRC for Points League
Next...
Click on the Z - this highlights the entire column
RIGHT-click on the Z, then COPY
Click on the H for Column H (this is the HR column)
RIGHT-click on the H, then Paste Special, then choose VALUES then OK
You've pasted the points into the HR column
Go to the League Set Up page
Put 0 in the box under RBI, SB, BA, R
Change Number of Teams to 10
Change catcher to 10
Change Outfielder to 80
CLICK TO GENERATE VALUES
That's the ranking for your league.
If Arenado is $65 and Donaldson is $61, you're doing it right.
Do you play an auction or draft format?
Click on the Z - this highlights the entire column
RIGHT-click on the Z, then COPY
Click on the H for Column H (this is the HR column)
RIGHT-click on the H, then Paste Special, then choose VALUES then OK
You've pasted the points into the HR column
Go to the League Set Up page
Put 0 in the box under RBI, SB, BA, R
Change Number of Teams to 10
Change catcher to 10
Change Outfielder to 80
CLICK TO GENERATE VALUES
That's the ranking for your league.
If Arenado is $65 and Donaldson is $61, you're doing it right.
Do you play an auction or draft format?
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
-
- Double-A
- Posts: 13
- Joined: February 25th, 2017, 4:11 am
Re: New Member, ZERO Excel Skills... CVRC for Points League
We play in a draft format. I did get the values you mentioned for Arenado and Donaldson. Thanks!
Last edited by ericpatnoudes on March 3rd, 2017, 2:33 pm, edited 1 time in total.
Re: New Member, ZERO Excel Skills... CVRC for Points League
Doesn't matter -- rankings are derived from auction values.
FYI - my time is going to be real tight so if you want to work through this, please do so ASAP. I can't promise immediate help once the crunch hits. Thanks.
FYI - my time is going to be real tight so if you want to work through this, please do so ASAP. I can't promise immediate help once the crunch hits. Thanks.
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
-
- Double-A
- Posts: 13
- Joined: February 25th, 2017, 4:11 am
Re: New Member, ZERO Excel Skills... CVRC for Points League
No worries, I totally understand. I think I'm all set. Thanks again, Todd!
-
- Double-A
- Posts: 13
- Joined: February 25th, 2017, 4:11 am
Re: New Member, ZERO Excel Skills... CVRC for Points League
Last question!
Any recommendations on how to edit the pitching sheet?
Any recommendations on how to edit the pitching sheet?
Re: New Member, ZERO Excel Skills... CVRC for Points League
By edit, do you mean setting up the formula and pasting it into the CVRC?
It's the same process as the hitting, obviously using the correct coefficients and cells. On my laptop now don't have all my material at the ready, so not sure if what you need is projected on the CVRC or if we'll need to jump from the projection sheet to the CVRC. Home Monday, can look then if you can't glean what you need to do from the hitting process.
It's the same process as the hitting, obviously using the correct coefficients and cells. On my laptop now don't have all my material at the ready, so not sure if what you need is projected on the CVRC or if we'll need to jump from the projection sheet to the CVRC. Home Monday, can look then if you can't glean what you need to do from the hitting process.
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord
I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord
Always remember, never forget, never say always or never. - The Forum Funklord
You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord