Aggregate (CBS, Chone, ESPN, Marcel) 2009 Projections - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

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

Moderator: Baseball Moderators

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

Postby klvrdude » Sat Mar 21, 2009 6:11 pm

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


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

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

Postby flloyd » Tue Mar 24, 2009 6:15 pm

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
Minor League Mentor

User avatar

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

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

Postby Broncmet724 » Tue Mar 24, 2009 10:05 pm

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

User avatar

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

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

Postby Curtis Pride » Tue Mar 24, 2009 10:24 pm

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
Major League Manager

User avatar

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

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

Postby flloyd » Wed Mar 25, 2009 5:13 pm

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
Minor League Mentor

User avatar

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

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

Postby kingmike74 » Tue Mar 31, 2009 12:32 pm

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
General Manager

User avatar

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

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

Postby kingmike74 » Tue Mar 31, 2009 1:39 pm

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

User avatar

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

Previous

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 9 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Thursday, Aug. 21
(All times are EST, weather icons show forecast for game time)

Houston at NY Yankees
(1:05 pm)
Cleveland at Minnesota
(1:10 pm)
Detroit at Tampa Bay
(1:10 pm)
indoors
Arizona at Washington
(4:05 pm)
LA Angels at Boston
(7:10 pm)
Atlanta at Cincinnati
(7:10 pm)
San Francisco at Chi Cubs
(8:05 pm)
San Diego at LA Dodgers
(10:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact