New Member, ZERO Excel Skills... CVRC for Points League

Ask questions or post comments concerning the CVRC, START or the Team and Player Tracker
Post Reply
Message
Author
ericpatnoudes
Double-A
Posts: 13
Joined: February 25th, 2017, 4:11 am

New Member, ZERO Excel Skills... CVRC for Points League

#1 Post by ericpatnoudes »

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

User avatar
Todd Zola
Hall of Famer
Posts: 8260
Joined: December 25th, 2008, 12:45 pm

Re: New Member, ZERO Excel Skills... CVRC for Points League

#2 Post by Todd Zola »

Welcome aboard!

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

ericpatnoudes
Double-A
Posts: 13
Joined: February 25th, 2017, 4:11 am

Re: New Member, ZERO Excel Skills... CVRC for Points League

#3 Post by ericpatnoudes »

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

User avatar
Todd Zola
Hall of Famer
Posts: 8260
Joined: December 25th, 2008, 12:45 pm

Re: New Member, ZERO Excel Skills... CVRC for Points League

#4 Post by Todd Zola »

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.
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

ericpatnoudes
Double-A
Posts: 13
Joined: February 25th, 2017, 4:11 am

Re: New Member, ZERO Excel Skills... CVRC for Points League

#5 Post by ericpatnoudes »

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

User avatar
Todd Zola
Hall of Famer
Posts: 8260
Joined: December 25th, 2008, 12:45 pm

Re: New Member, ZERO Excel Skills... CVRC for Points League

#6 Post by Todd Zola »

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

ericpatnoudes
Double-A
Posts: 13
Joined: February 25th, 2017, 4:11 am

Re: New Member, ZERO Excel Skills... CVRC for Points League

#7 Post by ericpatnoudes »

Abreu 414.5 is what I have.

User avatar
Todd Zola
Hall of Famer
Posts: 8260
Joined: December 25th, 2008, 12:45 pm

Re: New Member, ZERO Excel Skills... CVRC for Points League

#8 Post by Todd Zola »

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?
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

ericpatnoudes
Double-A
Posts: 13
Joined: February 25th, 2017, 4:11 am

Re: New Member, ZERO Excel Skills... CVRC for Points League

#9 Post by ericpatnoudes »

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.

User avatar
Todd Zola
Hall of Famer
Posts: 8260
Joined: December 25th, 2008, 12:45 pm

Re: New Member, ZERO Excel Skills... CVRC for Points League

#10 Post by Todd Zola »

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.
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

ericpatnoudes
Double-A
Posts: 13
Joined: February 25th, 2017, 4:11 am

Re: New Member, ZERO Excel Skills... CVRC for Points League

#11 Post by ericpatnoudes »

No worries, I totally understand. I think I'm all set. Thanks again, Todd!

ericpatnoudes
Double-A
Posts: 13
Joined: February 25th, 2017, 4:11 am

Re: New Member, ZERO Excel Skills... CVRC for Points League

#12 Post by ericpatnoudes »

Last question!

Any recommendations on how to edit the pitching sheet?

User avatar
Todd Zola
Hall of Famer
Posts: 8260
Joined: December 25th, 2008, 12:45 pm

Re: New Member, ZERO Excel Skills... CVRC for Points League

#13 Post by Todd Zola »

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.
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

Post Reply