Bruce Henderson

VBD Spreadsheet App

151 posts in this topic

VBD Spreadsheet App - Frequently Asked Questions

1) The VBD only shows the top 60. How can I show the top 100?

Hightlight cells Q62 to U62.

Click menu Edit - Copy.

Highlight cells Q63 to Q102.

Click menu Edit - Paste.

Highlight cells Q62 to Q102.

Click menu Edit - Fill - Series, then click OK.

Note: The Draft Dominator will print cheatsheets for the Top 200 and Top 400.

2) How do I avoid losing my league variables and scoring settings each time I update the VBD Spreadsheet.

Open your Previous VBD Spreadsheet (the one with the correct scoring and league variables).

Click on the Input Tab at the bottom.

Click on the box left of A and above 1. The whole sheet should be selected (highlighted).

Click Edit Copy.

Open your New VBD Spreadsheet.

Click on the Input Tab at the bottom.

Click on the box left of A and above 1. The whole sheet should be selected (highlighted).

Click Edit Paste.

Save your New VBD Spreadsheet.

Click the Generate Cheatsheet button.

Note: Click on the Readme First tab for additional Help.

Share this post


Link to post
Share on other sites

I can't seem to get this to work. Do you mean fill, not file for the last step? I seem to have the cells highlighted on the sheet, but no players in the spots. Any ideas?

Share this post


Link to post
Share on other sites

I can't seem to get this to work. Do you mean fill, not file for the last step? I seem to have the cells highlighted on the sheet, but no players in the spots. Any ideas?

Edit - Fill - Series...

Share this post


Link to post
Share on other sites

I can't seem to get this to work. Do you mean fill, not file for the last step? I seem to have the cells highlighted on the sheet, but no players in the spots. Any ideas?

I've followed the steps as described, yet it still only gives the top 60. Any ideas? I have a draft on Wed where I start 3 RB's, 3 WR's, 1 TE, 1 QB, 1K, and 1 D, so I could really use the additional player listings. Thanks fot the help! Also, do I do the steps prior to inputing my scoring or after. I've tried both ways with no success. Also for the last step when filling the series there are options for Series In-(Rows or columns), Type-(linear, growth, date, and Auto-fill), Step value, stop value, and a box for trend. How should these be filled? Edited by carnag

Share this post


Link to post
Share on other sites

The above steps should work. I double checked them on this end, and step through them step by step. For the Fill Series... the Default is Rows, Linear with a step value of 1. This is what you want so just click Ok.Have you peeked at the Draft Dominator yet? It prints out cheatsheets by position for almost all of the players... and it prints out Top 200 lists too. Actually Top 400 lists if you want them.The league variables and scoring is exactly the same as the VBD Spreadsheet.

Share this post


Link to post
Share on other sites

The above steps should work. I double checked them on this end, and step through them step by step. For the Fill Series... the Default is Rows, Linear with a step value of 1. This is what you want so just click Ok.

Have you peeked at the Draft Dominator yet? It prints out cheatsheets by position for almost all of the players... and it prints out Top 200 lists too. Actually Top 400 lists if you want them.

The league variables and scoring is exactly the same as the VBD Spreadsheet.

I figured it out. What I was doing was following the steps, but in the input section, not the cheat section.

Share this post


Link to post
Share on other sites

I'm getting players isted out of point total order. For example Warrick Dunn comes in at RB# 32 with 109 pts while other backs ahead of him have fewer pts. It's happening with every position also. Any ideas what might be wrong?

Share this post


Link to post
Share on other sites

Any chance next season the spreadsheet can be done with macros in the free OpenOffice spreadsheet program, rather than Excel? Some of us don't have Excel on the home computer.

Share this post


Link to post
Share on other sites

I'm getting players isted out of point total order. For example Warrick Dunn comes in at RB# 32 with 109 pts while other backs ahead of him have fewer pts. It's happening with every position also. Any ideas what might be wrong?

If you change the scoring system... without clicking the Generate Cheatsheets button afterwards this will happen.

Share this post


Link to post
Share on other sites

I'm getting players isted out of point total order. For example Warrick Dunn comes in at RB# 32 with 109 pts while other backs ahead of him have fewer pts. It's happening with every position also. Any ideas what might be wrong?

If you change the scoring system... without clicking the Generate Cheatsheets button afterwards this will happen.

Thanks for responding Bruce. It seemed to work,then when I tried the latest version released on the 10th I get this error message when I click "generate cheatsheet"..."06app_F1.xls?'!Macro1' cannot be found....

any idea what that's all about,the rankings are ALMOST in order,maybe 2 or 3 players at RB and WR that are off. Thanks for any help.

Share this post


Link to post
Share on other sites

I'd like to delete my league's keepers from the VBD player lists.. how can I do that without messing up the formulas?

Share this post


Link to post
Share on other sites

I'd like to delete my league's keepers from the VBD player lists.. how can I do that without messing up the formulas?

Just set their projections to zero.

Share this post


Link to post
Share on other sites

I'd like to delete my league's keepers from the VBD player lists.. how can I do that without messing up the formulas?

Just set their projections to zero.

Ah, figured it would be something simple. Thanks inca.

Share this post


Link to post
Share on other sites

I'm getting players isted out of point total order. For example Warrick Dunn comes in at RB# 32 with 109 pts while other backs ahead of him have fewer pts. It's happening with every position also. Any ideas what might be wrong?

If you change the scoring system... without clicking the Generate Cheatsheets button afterwards this will happen.

Thanks for responding Bruce. It seemed to work,then when I tried the latest version released on the 10th I get this error message when I click "generate cheatsheet"..."06app_F1.xls?'!Macro1' cannot be found....

any idea what that's all about,the rankings are ALMOST in order,maybe 2 or 3 players at RB and WR that are off. Thanks for any help.

shameless bump

Share this post


Link to post
Share on other sites

If you click Tools -> Macro -> Macros... does it show a Macro1? If not, you might have to download a new copy.

Also make sure your Security in the Macro settings is Medium or lower.

Share this post


Link to post
Share on other sites

Thanks Bruce. The macro was there but I still had the same problem,however,when I downloaded the zip file and then ran it everything was in order so I can go with that,thanks for the help.

Share this post


Link to post
Share on other sites

Sorry, I posted this below, but then thought, that I had put this question in the wrong spot....here it is

I don't want to lose my projections I've done with the top 15-20 players in each position, but I'd like to update the middle to late round players I haven't done the projections on. Is there a way to update without losing my latest projections?

THanks.

Share this post


Link to post
Share on other sites

Sorry, I posted this below, but then thought, that I had put this question in the wrong spot....here it isI don't want to lose my projections I've done with the top 15-20 players in each position, but I'd like to update the middle to late round players I haven't done the projections on. Is there a way to update without losing my latest projections?THanks.

The only way to do this in the VBD spreadsheet... is to open both Spreadsheets... and then copy / paste your modified projections into the new one.

Share this post


Link to post
Share on other sites

VBD Spreadsheet App - Frequently Asked Questions

1) The VBD only shows the top 60. How can I show the top 100?

Hightlight cells Q62 to U62.

Click menu Edit – Copy.

Highlight cells Q63 to Q140.

Click menu Edit – Paste.

Highlight cells Q62 to Q140.

Click menu Edit – File – Series, then click OK.

Two very minor points. I think you meant to type 104 (or perhaps even 102 to get the top 100), not 140. Either way, it works. And the last line (again, very minor) should be Edit - FILL - Series.

Share this post


Link to post
Share on other sites

After I click the Generate Cheatsheet button, the "values" in Col U for the Top 50-60 all become #VALUE. Everything looks good before I generate the cheatsheet. Any suggestions?

Share this post


Link to post
Share on other sites

After I click the Generate Cheatsheet button, the "values" in Col U for the Top 50-60 all become #VALUE. Everything looks good before I generate the cheatsheet. Any suggestions?

If you stretch the column wider... to the values come in?I'm guessing that it has something to do with your starters or league scoring. I tried it here and it looks ok. Do you remember which values you changed?

Share this post


Link to post
Share on other sites

Has anyone come up with a macro that will color the player names if they're on a keeper list? For example, I put my players in green, my rookies in light blue, all other taken players in red, and all other taken rookies in dark blue. For one league, that's only 36 players, but for another, it's 264 players! It would be nice if I could just have the list in a worksheet and run a macro such that if a player is on the list, it will automatically do the coloring for me.

Share this post


Link to post
Share on other sites

After I click the Generate Cheatsheet button, the "values" in Col U for the Top 50-60 all become #VALUE. Everything looks good before I generate the cheatsheet. Any suggestions?

If you stretch the column wider... to the values come in?I'm guessing that it has something to do with your starters or league scoring. I tried it here and it looks ok. Do you remember which values you changed?
The problem seems to coming from the "flex calculations" cells. I changed those to 0 and I get the #VALUE (column width doesn't matter). If I change those "flex" cells to an integer, everything works ok. I don't have a flex lineup so I inputted 0 as the "Number of Flex RB/WR/TE". But what numbers should I use in the "flex calculation" cells, as different numbers result in different VBD value amounts on the Cheat tab.

Share this post


Link to post
Share on other sites

After I click the Generate Cheatsheet button, the "values" in Col U for the Top 50-60 all become #VALUE. Everything looks good before I generate the cheatsheet. Any suggestions?

If you stretch the column wider... to the values come in?I'm guessing that it has something to do with your starters or league scoring. I tried it here and it looks ok. Do you remember which values you changed?
The problem seems to coming from the "flex calculations" cells. I changed those to 0 and I get the #VALUE (column width doesn't matter). If I change those "flex" cells to an integer, everything works ok. I don't have a flex lineup so I inputted 0 as the "Number of Flex RB/WR/TE". But what numbers should I use in the "flex calculation" cells, as different numbers result in different VBD value amounts on the Cheat tab.
Since you aren't using flex... they should be the same as the starters.

Share this post


Link to post
Share on other sites

After I click the Generate Cheatsheet button, the "values" in Col U for the Top 50-60 all become #VALUE. Everything looks good before I generate the cheatsheet. Any suggestions?

If you stretch the column wider... to the values come in?I'm guessing that it has something to do with your starters or league scoring. I tried it here and it looks ok. Do you remember which values you changed?
The problem seems to coming from the "flex calculations" cells. I changed those to 0 and I get the #VALUE (column width doesn't matter). If I change those "flex" cells to an integer, everything works ok. I don't have a flex lineup so I inputted 0 as the "Number of Flex RB/WR/TE". But what numbers should I use in the "flex calculation" cells, as different numbers result in different VBD value amounts on the Cheat tab.
Since you aren't using flex... they should be the same as the starters.
I don't get it either. Isn't a flex player someone you can start from any position? My league has 9 starters (1 X QB, 3 X WR, 2 X RB, 1 X TE, 1 X K, and 1 X DEF) and 6 bench players that can be anything. My understanding is that I have 0 flex players but are you saying that is not the case?

Share this post


Link to post
Share on other sites

No. You put 0 in the Flex Starters (RB/WR/TE). He was talking about the Flex Calculation box. When you put a 0 in the Fex Starters, it should set the RB, WR, TE equal to your starters automatically.

I think he overwrote them with zeros... which then caused the VBD values to not show up.

Share this post


Link to post
Share on other sites

No. You put 0 in the Flex Starters (RB/WR/TE). He was talking about the Flex Calculation box. When you put a 0 in the Fex Starters, it should set the RB, WR, TE equal to your starters automatically. I think he overwrote them with zeros... which then caused the VBD values to not show up.

Ya I put 0's in and got the same error.

Share this post


Link to post
Share on other sites

No. You put 0 in the Flex Starters (RB/WR/TE). He was talking about the Flex Calculation box. When you put a 0 in the Fex Starters, it should set the RB, WR, TE equal to your starters automatically. I think he overwrote them with zeros... which then caused the VBD values to not show up.

Correct. What are the Flex Calculation boxes used for? Do you input the maximum # of players you could start at each position if you have a flex? Suppose I can start 1 QB, 1 RB, 2 WR, 1 TE and 1 flex. I enter those numbers as the Number of Starters and enter 2, 3, 1 in the Flex Calc boxes? I can't imagine starting a TE as a flex, so then would 2, 3, 0 be more appropriate? Or am I totally missing the boat here?Thanks for your help. I really think this info would be helpful in the Read Me First file...or something like that.

Share this post


Link to post
Share on other sites

No. You put 0 in the Flex Starters (RB/WR/TE). He was talking about the Flex Calculation box. When you put a 0 in the Fex Starters, it should set the RB, WR, TE equal to your starters automatically. I think he overwrote them with zeros... which then caused the VBD values to not show up.

Correct. What are the Flex Calculation boxes used for? Do you input the maximum # of players you could start at each position if you have a flex? Suppose I can start 1 QB, 1 RB, 2 WR, 1 TE and 1 flex. I enter those numbers as the Number of Starters and enter 2, 3, 1 in the Flex Calc boxes? I can't imagine starting a TE as a flex, so then would 2, 3, 0 be more appropriate? Or am I totally missing the boat here?Thanks for your help. I really think this info would be helpful in the Read Me First file...or something like that.
You shouldn't ever enter anything in the flex calculation box... it is just there for reference. In your example, you would set your starters: RB=1, WR=2, TE=1, and Flex=1... and the VBD app would automatically fill in the Flex Calculation box with something like: RB=1.7, WR=2.3, TE=1

Share this post


Link to post
Share on other sites

What's the easiest way to condense all of the IDPs into one category? We start 1 IDP player and the position is irrelevant. I figure I could cut and paste the highest scoring DBs in the LB category over top of some of th weakest LBs, but I figured there might be a more graceful solution.

I did try adding all DBs and DLs to the LB tab but it only seemed to use the first 5 or 6 or so, so I'm not sure if there's a field that I can increase to read in more LBs.

Share this post


Link to post
Share on other sites

I'd probably just create another sheet, and copy/paste all the IDP players with their FP and VBD... then sort by VBD.

Share this post


Link to post
Share on other sites

Bruce, I am having trouble adding players. I have used all the ZZ-add players area. I need to add others, however if I insert rows to add players, the formulas for the total points does not add up correctly. It looks like the protected/hidden columns is the problem, since adding the rows is not copying any of the formulas.

Help.

Roger

Share this post


Link to post
Share on other sites

You can try copying the whole row (click to the left of column 1). Then Insert Copied Cells before the last ZZZ row.

You might have to hand tweak the macros though... as I don't think those change automatically.

Share this post


Link to post
Share on other sites

Riddle me this....

Downloaded ver R and did the copy/paste on the input sheet as usual from the previous version (Q). Clicked on "Generate Cheatsheet" button and I get a pop-up window that says version P contains macros, etc etc. Click OK and Version P opens.

I've been updating this way since version M and haven't had any problems.

:confused:

Share this post


Link to post
Share on other sites

I figured it out.

If you select the entire input sheet to copy from a previous version, it seems the macro for the generate cheatsheet button is copied also so it references the previous version. I had done that on version Q (carried over from P) but didn't notice and that's why P was opening when I carried it to version R (because I copied Q).

Edited by Cowchip

Share this post


Link to post
Share on other sites

Is there something I'm missing, is P. Manning really $54 more than the second best QB?

$300 cap, 17 rds, 12 teams, 6pts/TD, -2/Int .04/pass yd.

This seems like a HUGE disparity.

Is there a flaw in the oinment?

Share this post


Link to post
Share on other sites

Here's something I'd like to do, but haven't been able to accomplish yet. I want to print out lists of each position that display the actual projections, sorted by the number of fantasy points.

Is this possible to do? If I just go into the sheets for each position, and resort the data by fantasy points, the players and projections get sorted, but the fantasy points do not. Any way to get those as well?

Share this post


Link to post
Share on other sites

Is there something I'm missing, is P. Manning really $54 more than the second best QB?$300 cap, 17 rds, 12 teams, 6pts/TD, -2/Int .04/pass yd.This seems like a HUGE disparity.Is there a flaw in the oinment?

Never mind, my auctions and draft are done now.Thanks! :thumbup:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.