Fantasy Football - Footballguys Forums

Recommended Posts

I am currently on version D1 and have done a bit of updating to it (conditional formatting, updated stats, etc). Can I keep updating statistics for the rest of the year, or do I risk losing out on additions / deletions / updates as a result and need to keep downloading the latest version and reapplying my modifications?

Share this post


Link to post
Share on other sites

Is there a simple way to make the VBD spreadsheet not have the week 17 projections in there?

I think that well over 50% of leagues don't use week 17, surely there's an option to remove those stats to get a truer value for the players in question isn't there?

Edited by Dr. No

Share this post


Link to post
Share on other sites

I can't get the VBD values to match up in the Dominator. I have completed the scoring and enabled macros in the VBD. Saved it. Imported it and Andre Johnson is still 20 points lower in the Dominator than in the VBD excel file. I have also imported the scoring with the VBD file and confirmed that it matches what is in the Dominator. Seriously frustrating. If I double check by going to Set Up in Dominator after importing the VBD calculations they don't match the VBD. What am I doing wrong?

Edited by Ultima Thule

Share this post


Link to post
Share on other sites

I can't get the VBD values to match up in the Dominator. I have completed the scoring and enabled macros in the VBD. Saved it. Imported it and Andre Johnson is still 20 points lower in the Dominator than in the VBD excel file. I have also imported the scoring with the VBD file and confirmed that it matches what is in the Dominator. Seriously frustrating. If I double check by going to Set Up in Dominator after importing the VBD calculations they don't match the VBD. What am I doing wrong?

you are having the same problem as me.the DD is only through week 16, which is great.the VBD spreadsheets use week 17, which i wish they didn't since most leagues don't use week 17

Share this post


Link to post
Share on other sites

Hello,I've used the VBD app with great success over the last few years (won the league last year). Thanks for the hard work. My question is this. I like listing the top 100, and have been able to generate the top 100 using the directions at the top of this thread in the past. I'm having trouble generating the top 100 this year. I'm using the Aug 21st update. Thanks,DD

Im having the same issue, nothing happens when I do the Edit - Fill - Series. (I'm using Excel 2000)So instead I copied the last line of the top 60 and pasted it in all the rows below, up to 100. I think it worked :unsure: but it does show 60 ranking for all of the players 61 through 100. Edited by footballnerd

Share this post


Link to post
Share on other sites

I can't get the VBD values to match up in the Dominator. I have completed the scoring and enabled macros in the VBD. Saved it. Imported it and Andre Johnson is still 20 points lower in the Dominator than in the VBD excel file. I have also imported the scoring with the VBD file and confirmed that it matches what is in the Dominator. Seriously frustrating. If I double check by going to Set Up in Dominator after importing the VBD calculations they don't match the VBD. What am I doing wrong?

you are having the same problem as me.the DD is only through week 16, which is great.the VBD spreadsheets use week 17, which i wish they didn't since most leagues don't use week 17
Any way to change this? I noticed the same discrepancy but hadn't realized the extra week was the trigger.

Share this post


Link to post
Share on other sites

I can't get the VBD values to match up in the Dominator. I have completed the scoring and enabled macros in the VBD. Saved it. Imported it and Andre Johnson is still 20 points lower in the Dominator than in the VBD excel file. I have also imported the scoring with the VBD file and confirmed that it matches what is in the Dominator. Seriously frustrating. If I double check by going to Set Up in Dominator after importing the VBD calculations they don't match the VBD. What am I doing wrong?

you are having the same problem as me.

the DD is only through week 16, which is great.

the VBD spreadsheets use week 17, which i wish they didn't since most leagues don't use week 17

Any way to change this? I noticed the same discrepancy but hadn't realized the extra week was the trigger.

Using Joe's Secret Formula as your Baseline is the root of the problem. However, you can eliminate week 17 by following the procedure outlined here.

Share this post


Link to post
Share on other sites

Will the VBD app be updated today with the 9/4 projections? Thanks in advance for any info. Basically a print now or print in 4 hours question.

Share this post


Link to post
Share on other sites

can i still not use open office calc?

I use Open Office and it works perfectly fine for me.I do have a question though...Is there a way to change the ADP? I am in a PPR league and it appears that the ADP that is listed with the players is based on standard non-ppr. When trying to decide whether to jump on a player or wait a round or two, ADP is really useful. For instance, the ppr ADP that I've seen for Jabar Gaffney is around 10.9. The ADP on the cheatsheet is 14.01. That is a huge difference.I'm hoping to be able to just use the excel sheet this year as opposed to the DD. The DD is a little hard to keep up with in a league where the draft moves kind of quickly.
:goodposting:

Share this post


Link to post
Share on other sites

You could setup a user-defined ADP based off of your previous years' drafts. I would think that would be even better than one just for ppr because it would take into account all of the nuances of your league. Link describes how to use ADP_User.

http://forums.footballguys.com/forum/index.php?showtopic=249631&hl=adp_user&st=0

RR

Share this post


Link to post
Share on other sites

I use the VBD app every year to help with my own projections for my drafts. However, I just tried to download the VBD app today and after entering all the variables i got an error message that says "The macro 12app_G1.xls?'!Macro1' cannot be found"

The error comes up when I click on generate cheatsheet. Any help would be appreciated. Thanks!

Share this post


Link to post
Share on other sites

Does it now work on open office? i'm still not getting that to happen

Share this post


Link to post
Share on other sites

I use the VBD app every year to help with my own projections for my drafts. However, I just tried to download the VBD app today and after entering all the variables i got an error message that says "The macro 12app_G1.xls?'!Macro1' cannot be found"The error comes up when I click on generate cheatsheet. Any help would be appreciated. Thanks!

If you are in windows you need to enable macros. As soon as you open the spreadsheet, there should be a yellow tool bar with a Enable Macros button on it. If you are using a Mac, the Mac doesn't handle VBA macros.

Share this post


Link to post
Share on other sites

Does it now work on open office? i'm still not getting that to happen

The VBD Spreadsheet App doesn't work in Open Office, because Open Office doesn't support VBA macros. I would look at the Draft Dominator for Mac instead. It is available on the Tools tab of the main page of www.footballguys.com.

Share this post


Link to post
Share on other sites

I use the VBD app every year to help with my own projections for my drafts. However, I just tried to download the VBD app today and after entering all the variables i got an error message that says "The macro 12app_G1.xls?'!Macro1' cannot be found"The error comes up when I click on generate cheatsheet. Any help would be appreciated. Thanks!

I was getting this also for some reason I was not getting that box to pop up but then went in and did it under the zip file and it worked fine.

Share this post


Link to post
Share on other sites

Whose projections are included in the app?Just Dodds or consensus?

VBD and DD are just Dodds...

Share this post


Link to post
Share on other sites

Is the VBD app still widely used? I have made some enhancements and additions to the app and I think its really good! Is there a footballguys staffer who would be interested in reviewing it?

Share this post


Link to post
Share on other sites

I still use it as my primary tool for projections and then import it ino DD. I also have customized it to include Depth Charts for RBs and WRs as well as Tiers for ranking purposes. I would like to see what you have done with it if you are interested in sharing a copy. If you want to use Drop Box or something similar, I could pick it up from there.

RR

Share this post


Link to post
Share on other sites

I was actually talking to DD about it, but he appears buried in projects at this time. I really want a footballgus staffer to review it first and give their blessing or ok or how to share since this in additions to their app.

I really think it would be useful to run drafts, for personal drafts, & etc.

Share this post


Link to post
Share on other sites

There are plenty of FBG non-staffers who would gladly take a look at this for you. Nothing wrong with you sharing free application enhancements for reviews by knowledgeable folks. FBG gives the first version away for free and once you have that you can tweak the projections and mess around with it anyway.

Edited by Ruffrodys05

Share this post


Link to post
Share on other sites

(1) I have used the VBD every year and would definitely be interested in any enhances added to it.

(2) Is there going to be a Mac Version this year?

Share this post


Link to post
Share on other sites

what are the enhancements. you don't need FBGs blessing to at least tell us what you have done to it

I was actually talking to DD about it, but he appears buried in projects at this time. I really want a footballgus staffer to review it first and give their blessing or ok or how to share since this in additions to their app.

I really think it would be useful to run drafts, for personal drafts, & etc.

Share this post


Link to post
Share on other sites

I have enhanced the premium version and I would want the share to be under the staff control.

Can you modify the free version, and post it to the forum, and let others determine if it is useful or not?

Share this post


Link to post
Share on other sites

Can anyone tell me what tool on the FBG's site is the BEST to use during my draft?? I am in a Standard 12 Team League and I not sure which tool to use?? VBD Tool, Projections Tool or the Draft Dominator Tool???

Also, should I just try to get as many players from the Top 50 Section?? Or should I pay more attention to ADP??? How do you go about utilizing these tools while you are drafting??

Any help would really be appreciated?? Frist time FF player lookin for some help!!!!

Thanks!!

Benny227

Share this post


Link to post
Share on other sites

My brother and I own a team together. He likes the traditional paper Draft Board, so I print out a VBD Board for him after we've customized it with our projection variants. He uses highlighters and marks up his board during the Draft. I prefer DD on my laptop, so I import from the VBD sheet into DD...keeping us mostly consistent...DD doesn't use Week 17 projections.

My point is that you should familiarize yourself with both to determine what works best for you.

I like PD, but it won't export to the VBD Spreadsheet, so I keep track of the customizations in a different (non Football Guy) spreadsheet. We mostly like the VBD projections, but there are usually 15-20 that we change per year. I've also customized our VBD to include Depth Chart & Injury info for RBs and WRs as well as "Tier" numbers. I import that info into DD as "Notes" so I don't have to scramble for that information during the Draft.

Hope that helps,

RR

Share this post


Link to post
Share on other sites

My brother and I own a team together. He likes the traditional paper Draft Board, so I print out a VBD Board for him after we've customized it with our projection variants. He uses highlighters and marks up his board during the Draft. I prefer DD on my laptop, so I import from the VBD sheet into DD...keeping us mostly consistent...DD doesn't use Week 17 projections.

My point is that you should familiarize yourself with both to determine what works best for you.

I like PD, but it won't export to the VBD Spreadsheet, so I keep track of the customizations in a different (non Football Guy) spreadsheet. We mostly like the VBD projections, but there are usually 15-20 that we change per year. I've also customized our VBD to include Depth Chart & Injury info for RBs and WRs as well as "Tier" numbers. I import that info into DD as "Notes" so I don't have to scramble for that information during the Draft.

Hope that helps,

RR

DD will in fact use week 17 projections if you go into the Game By Game Projections window and set Week 17 to "1.00"

DD defaults to only 16 weeks as that is when the vast majority of leagues hold their championship game.

Edited by Ruffrodys05

Share this post


Link to post
Share on other sites

Can anyone tell me what tool on the FBG's site is the BEST to use during my draft?? I am in a Standard 12 Team League and I not sure which tool to use?? VBD Tool, Projections Tool or the Draft Dominator Tool???

Also, should I just try to get as many players from the Top 50 Section?? Or should I pay more attention to ADP??? How do you go about utilizing these tools while you are drafting??

Any help would really be appreciated?? Frist time FF player lookin for some help!!!!

Thanks!!

Benny227

Benny, if you have the ability to use a PC or Laptop during your draft, the combination of PD and DD is still the strongest.

My suggestion is to go into some of the pinned threads at the top of the forum and read how DD works. Also, within the DD application is an article call VBD Revisited - it's the holy bible of drafting and the basis for DD. Finally, close to the last week of preseason, Dodds will post an article on "The Perfect Draft". The key is not just trying to get top 50 guys - it's getting the right top 50 guys.

Share this post


Link to post
Share on other sites

I think there's something wrong on the latest spreadsheet. The fantasy points for wide receivers is way too high across the board. Version 13app_G1

Share this post


Link to post
Share on other sites

I think there's something wrong on the latest spreadsheet. The fantasy points for wide receivers is way too high across the board. Version 13app_G1

Not seeing that at all. Have you accidently changed the scoring for PPR or receiving yards?

RR

Share this post


Link to post
Share on other sites

Year after year in my league, QBs dominate in scoring as they are usually the top 6-8 players. Yet every year VBD has RB's way ahead on salary. With 6pt per Passing TD it makes sense.

We have a $300 cap, and this year, AP $110 is double what Aaron Rodgers $52 is in salary, almost triple Drew Brees $40.

Same with DD. Is there a way to bring these closer to what they should be?

Edited by Mr.Pack

Share this post


Link to post
Share on other sites

I have a question about the ADP data in the VBD spreadsheet.....where is it pulling from? When I look at the latest PPR ADP data on FBG, it's drastically different than what I'm seeing on the VBD spreadsheet. Do we have an option to change?

Share this post


Link to post
Share on other sites

I don't think this forum is moderated anymore.

Ya, know a lot of drafts are starting now, no need to help out.

  • Like 2

Share this post


Link to post
Share on other sites

I have a question about the ADP data in the VBD spreadsheet.....where is it pulling from? When I look at the latest PPR ADP data on FBG, it's drastically different than what I'm seeing on the VBD spreadsheet. Do we have an option to change?

ADP is not PPR, it's standard. You can find it here but it can't be changed in the VBD.

Edited by GoBears84

Share this post


Link to post
Share on other sites

I have a question about the ADP data in the VBD spreadsheet.....where is it pulling from? When I look at the latest PPR ADP data on FBG, it's drastically different than what I'm seeing on the VBD spreadsheet. Do we have an option to change?

ADP is not PPR, it's standard. You can find it here but it can't be changed in the VBD.

that really sucks

Share this post


Link to post
Share on other sites

I have a question about the ADP data in the VBD spreadsheet.....where is it pulling from? When I look at the latest PPR ADP data on FBG, it's drastically different than what I'm seeing on the VBD spreadsheet. Do we have an option to change?

ADP is not PPR, it's standard. You can find it here but it can't be changed in the VBD.

that really sucks

The VBD sheets are a relic from another time. They were incorporated into DD. In DD you can use various ADP's or you can set your own. You can import projections and notes from VBD sheets into DD and utilize them there. You can then generate Cheetsheets from DD. How can we help you get what you want from VBD through DD?

Share this post


Link to post
Share on other sites

I have a question about the ADP data in the VBD spreadsheet.....where is it pulling from? When I look at the latest PPR ADP data on FBG, it's drastically different than what I'm seeing on the VBD spreadsheet. Do we have an option to change?

ADP is not PPR, it's standard. You can find it here but it can't be changed in the VBD.

that really sucks

The VBD sheets are a relic from another time. They were incorporated into DD. In DD you can use various ADP's or you can set your own. You can import projections and notes from VBD sheets into DD and utilize them there. You can then generate Cheetsheets from DD. How can we help you get what you want from VBD through DD?

Thanks for answering..here's where I'm at:

I like to apply AVT to do positional projections, and then apply the FBG player rankings according to my scoring system. This is easily accomplished using the VBD Sheets by simply adding a column on the cheatsheets with my points, then updating the cheatsheet when new projections come out. Also, I like to operate off of one sheet of paper.

As far as I know, I can't accomplish this through the DD....but if I'm wrong, please let me know.

Share this post


Link to post
Share on other sites

I have a question about the ADP data in the VBD spreadsheet.....where is it pulling from? When I look at the latest PPR ADP data on FBG, it's drastically different than what I'm seeing on the VBD spreadsheet. Do we have an option to change?

ADP is not PPR, it's standard. You can find it here but it can't be changed in the VBD.

Why can't you take those points, copy them into the VBD and import those into DD? Or am

I missing something?

that really sucks

The VBD sheets are a relic from another time. They were incorporated into DD. In DD you can use various ADP's or you can set your own. You can import projections and notes from VBD sheets into DD and utilize them there. You can then generate Cheetsheets from DD. How can we help you get what you want from VBD through DD?

Thanks for answering..here's where I'm at:

I like to apply AVT to do positional projections, and then apply the FBG player rankings according to my scoring system. This is easily accomplished using the VBD Sheets by simply adding a column on the cheatsheets with my points, then updating the cheatsheet when new projections come out. Also, I like to operate off of one sheet of paper.

As far as I know, I can't accomplish this through the DD....but if I'm wrong, please let me know.

Share this post


Link to post
Share on other sites

I have a question about the ADP data in the VBD spreadsheet.....where is it pulling from? When I look at the latest PPR ADP data on FBG, it's drastically different than what I'm seeing on the VBD spreadsheet. Do we have an option to change?

ADP is not PPR, it's standard. You can find it here but it can't be changed in the VBD.

that really sucks

The VBD sheets are a relic from another time. They were incorporated into DD. In DD you can use various ADP's or you can set your own. You can import projections and notes from VBD sheets into DD and utilize them there. You can then generate Cheetsheets from DD. How can we help you get what you want from VBD through DD?

Thanks for answering..here's where I'm at:

I like to apply AVT to do positional projections, and then apply the FBG player rankings according to my scoring system. This is easily accomplished using the VBD Sheets by simply adding a column on the cheatsheets with my points, then updating the cheatsheet when new projections come out. Also, I like to operate off of one sheet of paper.

As far as I know, I can't accomplish this through the DD....but if I'm wrong, please let me know.

Why can't you take those points, copy them into the VBD and import those into DD? Or am

I missing something?

Here's what I do:

1. Forecast the total points for QB01, QB02, QB03, etc for each position.

2. Set up the VBD spreadsheet according to my scoring system

3. Replace the Pts column on the cheatsheet with my forecasted points. I do a copy paste here, b/c these points will stay static per each positional ranking. What I do want to change is the player rankings themselves....this is what I count on this spreadsheet for....so each time there is an update, it recalculates the rankings.

As far as I know, I can't simply bring my points into the VBD and import that into the DD, b/c the points aren't tied to a specific player name...they're tied to a positional ranking.

Share this post


Link to post
Share on other sites

Is there an estimated release date for the 2014 version yet?

I downloaded the 2014 version and have noticed an error. If I change the WR projected yards to 1100 - 1200 or higher the spreadsheet calculates the fantasy points as a 4 digit number in the thousands

Share this post


Link to post
Share on other sites

Is there an estimated release date for the 2014 version yet?

I downloaded the 2014 version and have noticed an error. If I change the WR projected yards to 1100 - 1200 or higher the spreadsheet calculates the fantasy points as a 4 digit number in the thousands

found another glitch in the sheet that was uploaded 06/07......TD totals do not calculate for EJ Manuel......his fantasy points stay the same whether he has 0 or 60 TD

Share this post


Link to post
Share on other sites

I'm using the auction settings on the app but something seems off with the values. When i add up the total drafted player pool it's way off the total dollar amount available by all teams.

10 team league

30 roster spots per team

$200 budget per team

$2000 total to spend by all teams

Top 300 players add up to only $1660

I tried changing the inputs but again something seems off. Any ideas?

Share this post


Link to post
Share on other sites

Is there a way to have the total fantasy points be a percent of the whole number? If a player is projected to score 200 points then is there a way to adjust the formula so it reads 150 points instead on the spreadsheet. Can we take the TP and multiply it by .75 to show 150 instead of 200 on the sheet without changing the projections?

Share this post


Link to post
Share on other sites

Having an issue with the current VBD. When I go to update projections, it gives me this error:

Run-time error '53':

File not found: urlmon

Share this post


Link to post
Share on other sites

Having an issue with the current VBD. When I go to update projections, it gives me this error:

Run-time error '53':

File not found: urlmon

Ensure you are logged into the Premium site. If that doesn't work,just download the latest version.

Share this post


Link to post
Share on other sites

On the input screen - i have a question about the flex calculations-

we start

2rb

3wr

1te

1flex rb/wr

1flex wr/te

How do we handle that?

I am thinking since it would be rare to start 2 TE's to have it be:

2rb

4wr

1 flex rb/wr

agreed?

Any thoughts?

Thanks

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.