Help - Search - Members - Calendar
Full Version: DD - Cheat Sheets
Footballguys Forums > Our Forums > Applications Questions (VBD, Draft Dominator, etc.)
cashman88
I love the DD - but at the draft, all I use are the cheat sheets which are produced by the software. The cheat sheets have Rank, Player Name, Team/Bye Week, Points and Overall. Is it possible to include the VBD of each player on the cheat sheet. I would rather have that than Points or Overall category -- maybe it can be designed so the user can choose which categories to have on the cheat sheet?

Thanks in advance.
Bruce Henderson
The Top 200/400 List has VBD and ADP too.
LehighGuy
Cashman

If you look at the spreadsheet for the cheatsheet - Column U is the VBD value.

Hope that helps

biggrin.gif
george
QUOTE (cashman88 @ Jul 11 2006, 11:31 AM)
I love the DD - but at the draft, all I use are the cheat sheets which are produced by the software.  The cheat sheets have Rank, Player Name, Team/Bye Week, Points and Overall.  Is it possible to include the VBD of each player on the cheat sheet.  I would rather have that than Points or Overall category -- maybe it can be designed so the user can choose which categories to have on the cheat sheet?

Thanks in advance.
*

I agree wiht these requests. I would rather have the VBD number and ADP numbers on the cheat sheet. I do not take the DD to my draft. I use it to help me make up my cheat sheet. So having the ADP and VBD numbers on the cheat sheet would cut down on the number of sheets I need at the draft.
george
QUOTE (LehighGuy @ Jul 11 2006, 09:26 PM)
Cashman

If you look at the spreadsheet for the cheatsheet - Column U is the VBD value.

Hope that helps

biggrin.gif
*


Okay, maybe this answers my other post. How do I download the cheat sheet asa spreadsheet without printing it?
Bruce Henderson
QUOTE (george @ Jul 19 2006, 03:49 PM)
QUOTE (LehighGuy @ Jul 11 2006, 09:26 PM)
Cashman

If you look at the spreadsheet for the cheatsheet - Column U is the VBD value.

Hope that helps

biggrin.gif
*


Okay, maybe this answers my other post. How do I download the cheat sheet asa spreadsheet without printing it?
*



You can export the Player Pool as a CSV file. Just double click on the CSV, and it will pull up in Excel. This will have both ADP and VBD.
george
QUOTE (Bruce Henderson @ Jul 19 2006, 06:27 PM)
QUOTE (george @ Jul 19 2006, 03:49 PM)
QUOTE (LehighGuy @ Jul 11 2006, 09:26 PM)
Cashman

If you look at the spreadsheet for the cheatsheet - Column U is the VBD value.

Hope that helps

biggrin.gif
*


Okay, maybe this answers my other post. How do I download the cheat sheet asa spreadsheet without printing it?
*



You can export the Player Pool as a CSV file. Just double click on the CSV, and it will pull up in Excel. This will have both ADP and VBD.
*



That works but it is only the overall rankings. I would really prefer it broken down by position.

I tried to sort it by position, but it ranks RB1, RB11, RB12....before RB2 when I use the sort feature by the position column. Any suggestions?
Anon
In a spare column (I am using K), Row 2 .. type in =LEFT(B2,2) then copy that formula down until the end of the players. Then sort on clumn K and Column F.
george
QUOTE (Anon @ Jul 19 2006, 10:30 PM)
In a spare column (I am using K), Row 2 .. type in =LEFT(B2,2) then copy that formula down until the end of the players. Then sort on clumn K and Column F.
*

Thank you, I never sorted by two columns before. Took me a while to figure out how to do it, but ater I realized you said to put the formula in Row 2 instead of Row 1 it worked.

This will be a big help. Still think there should be an easier way to export it already sorted. But this will work too.

Thanks again,
george
george
bump so I remember how to do this.
glock
QUOTE (Anon @ Jul 19 2006, 10:30 PM) *
In a spare column (I am using K), Row 2 .. type in =LEFT(B2,2) then copy that formula down until the end of the players. Then sort on clumn K and Column F.


Soooo, there is no way to do this if you aren't an Excel geek? kicksrock4.gif
george
QUOTE (glock @ Aug 30 2008, 10:55 AM) *
QUOTE (Anon @ Jul 19 2006, 10:30 PM) *
In a spare column (I am using K), Row 2 .. type in =LEFT(B2,2) then copy that formula down until the end of the players. Then sort on clumn K and Column F.


Soooo, there is no way to do this if you aren't an Excel geek? kicksrock4.gif
I'm not very Excel proficient as you can see from my earlier quesiton. I've been sorting by Position. Then cut and paste each position onto it's own page/tab. Then sort each position by Total Points.

Do you know how to sort? If not, click on one cell at the top of the column you wnat to sort. Then click on "data" on the toolbar and you select which columns you want to sort by. You can do 1-3 columns once you figure it out.
Anon
QUOTE (glock @ Aug 30 2008, 10:55 AM) *
QUOTE (Anon @ Jul 19 2006, 10:30 PM) *
In a spare column (I am using K), Row 2 .. type in =LEFT(B2,2) then copy that formula down until the end of the players. Then sort on clumn K and Column F.


Soooo, there is no way to do this if you aren't an Excel geek? kicksrock4.gif


sadbanana.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.