Spreadsheet help

[qqqqqqqq]

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.

[lsommerer]

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.

[himoc918]

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.