Spreadsheet help - Fantasy Baseball Cafe 2015 Fantasy Baseball Cafe

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.

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

Forums Articles & Tips Sleepers Rankings Leagues

Get Ready...
The 2015 MLB season starts in 10:35 hours
(and 29 days)

  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact