Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections - Fantasy Baseball Cafe 2014

## Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

Moderator: Baseball Moderators

### Re: Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

Man, my work has been getting in the way of my fantasy this year...thanks for the awesome work
klvrdude
Major League Manager

Posts: 1010
Joined: 1 May 2004
Home Cafe: Baseball

### Re: Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

Is there any way that you could give a small tutorial on how to do this? I'm trying to figure out how I can match names from different sources. I think once I get that list I should be able to figure out how to average the values.

Any help would be greatly appreciated.
flloyd
Minor League Mentor

Posts: 597
Joined: 4 Jun 2003
Home Cafe: Baseball
Location: Santa Monica, CA

### Re: Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

What are you asking for, Excel help or something else?
 Broncmet724
Major League Manager

Posts: 1754
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

### Re: Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

flloyd wrote:Is there any way that you could give a small tutorial on how to do this? I'm trying to figure out how I can match names from different sources. I think once I get that list I should be able to figure out how to average the values.

Any help would be greatly appreciated.

=averageif(cell,range,sumrange)
Curtis Pride
Major League Manager

Posts: 1361
(Past Year: 3)
Joined: 19 May 2007
Home Cafe: Baseball

### Re: Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

I'm definitely an excel newbie (if not simply idiot) so maybe I'm asking too much. But how would I use that in an actual spreadsheet? I see how I might be able to use that to figure out one player's average runs. But how would one create a sheet so that all of a players stats are averaged and each player is counted? For example, right now one of my projections has individual cells for first and last name and others combine them, so I'm confused how I would match people up without averaging 10 Gonzalez's runs. Also doing this name by name seems insanely laborious and you said it was reasonably easy so I'm assuming you have it set up to average everybody's stats once the names are straightened out.

Not sure if you're willing to share it but maybe you'd be willing upload the actual spreadsheet that you used to find each player's average? That would be a ton of help, although I understand if it's private.
flloyd
Minor League Mentor

Posts: 597
Joined: 4 Jun 2003
Home Cafe: Baseball
Location: Santa Monica, CA

### Re: Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

Thx CP. you da man, saved me about 2 days work.
"I can't wait to put the uniform on each day" ~ Bobby Cox
kingmike74
General Manager

Posts: 2729
(Past Year: 28)
Joined: 12 Mar 2006
Home Cafe: Baseball
Location: On Deck

### Re: Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections

Any means for RP?
"I can't wait to put the uniform on each day" ~ Bobby Cox
kingmike74
General Manager

Posts: 2729
(Past Year: 28)
Joined: 12 Mar 2006
Home Cafe: Baseball
Location: On Deck

Previous

### Who is online

Users browsing this forum: Majestic-12 [Bot] and 5 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Monday, Sep. 22
(All times are EST, weather icons show forecast for game time)

 • Kansas City at Cleveland(7:05 pm)
 • Baltimore at NY Yankees(7:05 pm)
 • Seattle at Toronto(7:07 pm)
 • Chi White Sox at Detroit(7:08 pm)
 • Pittsburgh at Atlanta(7:10 pm)
 • St. Louis at Chi Cubs(8:05 pm)
 • Houston at Texas(8:05 pm)

Sunday, Aug. 31

 • Cleveland at Cody(8:07 pm)

Monday, Sep. 22

 • Arizona at Minnesota(8:10 pm)
 • LA Angels at Oakland(10:05 pm)
 • San Francisco at LA Dodgers(10:10 pm)
 • Colorado at San Diego(10:10 pm)