Fantasy Baseball Draft Workbook

I am creating a workbook to help myself stay organized in my fantasy baseball draft, and this is what I have so far in terms of how I am plotting it:

1) There will be 2 spreadsheets, the first sheet (Player Rankings) will list all the players by position. The second sheet (Draft Results) will list the players who have been drafted by the members of my fantasy baseball league.

2) The Draft Results sheet is where I want to be kind of fancy: The teams will each be on different columns, and what I want to do is when I type a player name, the player name will either disappear, or change color in the Player Rankings List. I thought of a VLOOKUP, but that doesn't work for my purposes.

Anyone have any ideas? Also, has anyone developed a sheet like mine already for the upcoming fantasy baseball season?

Thanks in advance for the feedback.

Originally Posted by mets3145

I am creating a workbook to help myself stay organized in my fantasy baseball draft, and this is what I have so far in terms of how I am plotting it:

1) There will be 2 spreadsheets, the first sheet (Player Rankings) will list all the players by position. The second sheet (Draft Results) will list the players who have been drafted by the members of my fantasy baseball league.

2) The Draft Results sheet is where I want to be kind of fancy: The teams will each be on different columns, and what I want to do is when I type a player name, the player name will either disappear, or change color in the Player Rankings List. I thought of a VLOOKUP, but that doesn't work for my purposes.

Anyone have any ideas? Also, has anyone developed a sheet like mine already for the upcoming fantasy baseball season?

Thanks in advance for the feedback.

I guess you need a macro triggered by a Worksheet Selection Change event. The selection would be the cell you choose to type a player name - although since you have player names listed anyway, why not be even fancier and have these listed in a Combobox, from which you pick the name.

The macro would then find which cell in the rankings list contains the player name, and set the cell/font formats accordingly.

HTH

That's a really good idea, but then i'd have somewhat of 300 combo boxes then?

12 teams with 25 players each = 300, that's where i came to that number.

I'd prefer to type the names in because there might be a player a team drafts that is not on my list... though unlikely, it could still happen.

Originally Posted by mets3145

That's a really good idea, but then i'd have somewhat of 300 combo boxes then?

12 teams with 25 players each = 300, that's where i came to that number.

I'd prefer to type the names in because there might be a player a team drafts that is not on my list... though unlikely, it could still happen.

No, Just one or at most two comboboxes.

With one combobox you could have all 300 team/player records from which you would make a choice by say player. Or with two comboboxes you could be even smarter and pick one of 12 teams from one combobox. This would then immediately populate the second combobox with all the players that play for that team.

Since we're using comboboxes, and unlike a ListBox, they will accept original entries into the box as well as picking names from the box. And this would overcome your problem of handling new players.

Rgds

Originally Posted by mets3145

Your idea sounds really interesting.

The most important part of this workbook is for me to stay organized throughout my fantasy baseball draft.

The first sheet is for me to see the best available player left at each position as the draft progresses.

The second sheet is for me to see what i, along with my competitors, have done throughout the draft and see if any trends have developed.

If you feel your combo box idea accomplishes this, I would really like to see it. I haven't found any viable ideas yet.

Hi,

I'm attaching a workbook which is the start of the sort of idea I have. I haven't written anything that delivers the specific requirement above because I don't yet have enough knowledge about precisely what your data looks like and what you wish to do with it.

However oOn this workbook is a Variables page, which would normally be hidden, which contains the team names and the player names and the teams they play for.

On the data sheet, if you click the babseball player icon you get a menu. This is an example of the sort of way in which you can control things. You can see how when you select items from the two drop down combo boxes, the two cells b3:b4 on the worksheet are chnaged to reflect the selection. In addition when you pick a team and click the 'List Team Players button, you get a list of the 12 players for that team.

Obviously as you capture data through the menu input, you can then use it to do virtually anything.

Hope it gives you some ideas.

Rgds

I see what you are doing and I like it. It really keeps things organized and the spreadsheet very clean and easy to view. This is a route I can see will be very good for me to stay organized. Your "Variables" sheet in the workbook is really cool and it's 1/2 of what I want to do.

Here is what I have in terms of what I want my goal to be in terms of looking for the best available player at each position as the draft progresses. My first sheet is mapped out and where all the data is.

From a visual standpoint from my head right now, I would imagine if I incorporate your idea, I'd need 3 sheets. The first one would be my player list by position, the 2nd would list the teams and the players they took, and the 3rd would be my data entry tab which would be similar to your "variables tab"

Here is what my first sheet looks like. Ignore the second sheet, as that is how I would map the teams without fancy macros.

Thank you for all the help!

bump it up... looking for additional feedback to aide my brainstorming

Originally Posted by mets3145

bump it up... looking for additional feedback to aide my brainstorming

Hi,

Could you try re-doing the zip for the file. I couldn't decompress the last one you uploaded.

I may not be able to get around to this until Monday.

Rgds

Originally Posted by mets3145

Hopefully the zip file will work this time:

Thanks for the help!

I deleted my other reply because the zip file didn't work.

But here are some notes about what I attached:

1) The format is what I imagined my workbook would look like.
2) I was wondering if there is a way to add to the functionality of the workbook to include making the names in my player list get crossed out or their font changed in some way as they get drafted.
3) I created a macro with what I imagined it would look like. I got rid of the combobox that listed all the player names because I did not think it'd be necessary. I looked at the code and did not think this would affect it, but if I am wrong, please add it back in.

So this is how I envision using the workbook. I input the 12 teams in my league in the variables sheet. The draft starts... as players get picked, I input it in the variables sheet. As I input it, the names I type in get crossed out in the player ranking sheet to note that they are no longer available. As the draft progresses, I use the macro to see what players each team has taken so far, and they are displayed in the Draft Tracker sheet.

Thanks again!

Hi,

One question.

Is the Player Ranking sheet the starting point for drafting players. I'm guessing that what you require is a 'Start Draft' button, which will list all the players in the player ranking sheet in a ListBox, and when you select them they get added to the Variables sheet and then deleted from the Player Ramking sheet. Your note above implies that you manually enter player names to the variables sheet.

If my assumption is correct, rather than list all the player names in the listbox, would you want to first filter the names by picking the column reference above the 9 columns of names, i.e the 'C', '1B', '2B' etc.

Rgds

bump it up