spreadsheet woes - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

spreadsheet woes

Moderator: Baseball Moderators

spreadsheet woes

Postby WillieJay » Sun Mar 29, 2009 5:42 pm

I have a spreadsheet that I've used for several years. I've got tabs auction values, every team roster in a total summary, and every position in other individual tabs. I have every position linked into my auction values.

Here is what I do during a live draft. In my auction values tab I have two extra columns with team that won the bid and the value purchased. I highlight the row. I copy that row and paste the link into my team roster page. It then calculates money left over and other things.

There has got to be a easier way than copy and pasting links. I'm sure there has got to be a way but just don't know how to. Any help would be greatly appreciated. Thanks.
WillieJay
Little League Legend
Little League Legend


Posts: 12
Joined: 8 Jan 2006
Home Cafe: Baseball

Re: spreadsheet woes

Postby WillieJay » Sun Mar 29, 2009 6:41 pm

c'mon guys. 14 views.no help. someone has to know something to help.
WillieJay
Little League Legend
Little League Legend


Posts: 12
Joined: 8 Jan 2006
Home Cafe: Baseball

Re: spreadsheet woes

Postby RynoDyno » Mon Mar 30, 2009 2:08 pm

i think i know what you're asking. for

say this is your 1st sheet:

A1	B1
initial amount to spend $3,120
left to spend $3,015


and this is your 2nd:

A1	B1
Player Name Price
X 78
Y 14
Z 13


the cell with $3015 above will calculate automatically for you if you use this formula:

=B2-SUM(Sheet2!B:B)


a 2nd way to do it if you just want information to just automatically show up on your 1st sheet based on what you did with the 2nd sheet such as player's name, etc:

in your first sheet, click the cell you want the information to show up in, hit the equals key on your keyboard and then click over to your 2nd sheet and left click once on the cell you want the information to be copied from.

once you have that, you can copy and paste that "formula" to the rest of the cells in your 1st sheet. the formula looks like this:

=Sheet2!A1

hope that helps, i'm no excel genius but that's how i would do it.
DaSh 1s wrote:PS how do u not want to cup the best player in baseball's sack?


ewwww
RynoDyno
College Coach
College Coach

User avatar

Posts: 274
Joined: 7 Jan 2005
Home Cafe: Baseball

Re: spreadsheet woes

Postby WillieJay » Mon Mar 30, 2009 6:25 pm

here is the scenerio:

Worksheet 1
Player Pos Team Who Won Bid How much for?
Pujols 1b Team A $37

$37 is added on the worksheet during the draft on worksheet 1.
and appears on worksheet 2 by formula(as seen below).

Worksheet 2
Team A
Player
Pujols 1b $37
WillieJay
Little League Legend
Little League Legend


Posts: 12
Joined: 8 Jan 2006
Home Cafe: Baseball

Re: spreadsheet woes

Postby MikeBillsFan » Tue Mar 31, 2009 11:13 pm

So if I understand, each team has a worksheet and you need each of these team worksheets to know what players are won at auction by that team. You're going to need a combination of formulas including, likely, VLOOKUP formulas to get the right players to the team worksheet. Is that what you are trying to accomplish? It is a little complicated.
MikeBillsFan
Softball Supervisor
Softball Supervisor

User avatar

Posts: 27
Joined: 23 Feb 2007
Home Cafe: Baseball
Location: Toronto, Canada

Re: spreadsheet woes

Postby WillieJay » Wed Apr 01, 2009 6:41 am

Worksheet 2 is a Full Team Roster page. I was attempting to be able to put the players in specific position locations when I get this part down as well.

All teams are all Worksheet 2

For Example:

Team A Team B Team C Team D
Pujols 1b $37 Howard 1b $34 Berkman 1b $30
Utley 2b $28


and so forth
WillieJay
Little League Legend
Little League Legend


Posts: 12
Joined: 8 Jan 2006
Home Cafe: Baseball


Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 9 guests

cron
Forums Articles & Tips Sleepers Rankings Leagues


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

San Francisco at Kansas City
(8:07 pm)

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