Spreadsheet help - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Beginner's Forum

Spreadsheet help

Spreadsheet help

Postby qqqqqqqq » Sun Mar 23, 2008 7:07 pm

So I'm using Microsoft Excel, and I want to combine a few projections together. How do I align them player to player?

What I want to do is take the mean of each person's projected stats and compare them. And also, I want to have the ADP in there as well, just to have everything in one place.

At first, I tried to sort them by their names, but they don't all project the same people, and it's sort of tedious to sort them all by hand. Is there anyway to automate this? There are probable scripts and stuff, but I don't know if I really want to learn any....

Or, it would be really cool if someone already did this, and wouldn't mind sharing it with me. :)
I searched google for a while and found nothing.

Thanks.
qqqqqqqq
T-Ball Trainer


Posts: 2
Joined: 23 Mar 2008
Home Cafe: Baseball

Re: Spreadsheet help

Postby lsommerer » Mon Mar 24, 2008 10:24 pm

You need to find some way to tie the data together. Name is probably the easiest, but you'll probably have to massage it a little to get it i nthe same format on all projections. After you have all of your names the same you can all of the data on a single player by using a bunch of VLOOKUP functions.

But I think you would be better off looking at the projections and figuring out which ones look like they know what they are doing. Taking the average of several projections won't necessarily give you a better projection. Search the forums to see which projections other people like.
lsommerer
College Coach
College Coach


Posts: 111
Joined: 15 Feb 2006
Home Cafe: Baseball
Location: Nebraska

Re: Spreadsheet help

Postby himoc918 » Tue Mar 25, 2008 9:45 am

If you want to send me your projections I can have my wife try to combine them for you. She is an excel wiz. Just wanted to extend you that offer.
himoc918
Little League Legend
Little League Legend

User avatar

Posts: 15
Joined: 20 Mar 2008
Home Cafe: Baseball


Return to Beginner's Forum

Who is online

Users browsing this forum: No registered users and 1 guest

Forums Articles & Tips Sleepers Rankings Leagues


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

Philadelphia at Atlanta
(12:10 pm)
Pittsburgh at St. Louis
(1:45 pm)
San Francisco at Colorado
(3:10 pm)
Washington at LA Dodgers
(3:10 pm)
Seattle at Oakland
(3:35 pm)
Boston at NY Yankees
(7:05 pm)
Detroit at Cleveland
(7:05 pm)
Cincinnati at Baltimore
(7:05 pm)
NY Mets at Miami
(7:10 pm)
indoors
Toronto at Tampa Bay
(7:10 pm)
indoors
Milwaukee at Chi Cubs
(8:05 pm)
LA Angels at Houston
(8:10 pm)
Texas at Kansas City
(8:10 pm)
Chi White Sox at Minnesota
(8:10 pm)
Arizona at San Diego
(10:05 pm)

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