Mastersball Fantasy Forum

A forum on fantasy baseball by the people who bring you Mastersball
Return to: Mastersball.
It is currently December 12th, 2017, 10:59 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 13 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 24th, 2017, 11:12 pm 
Offline
Double-A

Joined: February 25th, 2017, 4:11 am
Posts: 13
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


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 24th, 2017, 11:16 pm 
Offline
Hall of Famer
User avatar

Joined: December 25th, 2008, 12:45 pm
Posts: 6066
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


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 25th, 2017, 7:44 pm 
Offline
Double-A

Joined: February 25th, 2017, 4:11 am
Posts: 13
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


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 25th, 2017, 8:22 pm 
Offline
Hall of Famer
User avatar

Joined: December 25th, 2008, 12:45 pm
Posts: 6066
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


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 26th, 2017, 7:58 pm 
Offline
Double-A

Joined: February 25th, 2017, 4:11 am
Posts: 13
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


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 26th, 2017, 9:34 pm 
Offline
Hall of Famer
User avatar

Joined: December 25th, 2008, 12:45 pm
Posts: 6066
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


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 28th, 2017, 4:39 pm 
Offline
Double-A

Joined: February 25th, 2017, 4:11 am
Posts: 13
Abreu 414.5 is what I have.


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: February 28th, 2017, 7:53 pm 
Offline
Hall of Famer
User avatar

Joined: December 25th, 2008, 12:45 pm
Posts: 6066
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


Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: March 3rd, 2017, 2:27 pm 
Offline
Double-A

Joined: February 25th, 2017, 4:11 am
Posts: 13
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.

Top
 Profile  
 
 Post subject: Re: New Member, ZERO Excel Skills... CVRC for Points League
PostPosted: March 3rd, 2017, 2:31 pm 
Offline
Hall of Famer
User avatar

Joined: December 25th, 2008, 12:45 pm
Posts: 6066
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ]  Go to page 1, 2  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Translated by Xaphos © 2007, 2008, 2009 phpBB.fr