An Iconic Fantasy Baseball Community
Moderator: Baseball Moderators
screwyinstlouie wrote:I suppose you could set up indiv. sheets on your Excel file for each projection source, then create a summary sheet and link the formulas to each source...
Sheet1 - Abreu (in cell +A2) 30 (for proj 30 HR's in Cell +B2)
Sheet2 - Abreu (also in Cell +A2) 26 (for proj 26 HR's; also Cell +B2)
Sheet3 - (summary) - Abreu (Cell +A2); Cell +B2 =+('Sheet1'!B2+'Sheet2'!B2)/2
you should get 28 HRs avg
But it would get tricky unless you had the same number of players and stats, and as you suggested, in the same order on all the sheets (rows for players as well as columns for stats).
I'm no expert on databases, but it sounds to me like a database program such as Microsoft Access or Lotus Approach might serve you better. Good luck to you.
The odds of the AL MVP coming from the American League are looking pretty good.
Users browsing this forum: No registered users and 8 guests