downtowndragons
Footballguy
Excellent work, as always! Thanks!
Snogger,What is the name of the file that you are using?Using Excel 2000.. Able to open, but after clicking the generate Cheatsheet button get a runtime error 1004 "application defined or object defined error"
I have a similar situation where we start 5 flex (WR/RB). If I set at 2.5 RB and 2.5 WR will I get correct values?BTW... It was amazing to follow this thread to actually get an idea of how hard you guys work at this. My hats off to you.cheersWhat I would do is create my own overall by lumping WRs, RBs and TEs in one bucket. No the app won't directly do that, but it will give all of the points. Choose 60 as the baseline for this lumped list and you should be good.
Found a different link.. http://footballguys.net/03vbdapp_a2.zip and that one worked like a charm.. For some reason you could still get to the a1 file and that was the one that failed.ThanksSnogger,What is the name of the file that you are using?
I would suggest downloading the zip file again. I just opened the zip file without a problem using WinZip ver 6.3If you are still having problems, email me @ maxwell@footballguys.comAnyone else having these problems?Windows NT 4.0 SP6Office Excel 97 SR-2WinZip 8.0 (3105)Problem: 03vbdapp_a3.zip, 393216 bytes Cannot open file. It does not appear to be a valid archive.Problem: 03vbdapp_a3.xls, 1736704 bytes The Instruction at "blahblahblah" referenced memory at "more blah". The memory could not be read. Click Ok to terminate or cancel to debug.I was able to open a previoe version of the xls file and did reveive the same runtime errors as others posted. However, everyone seems to be working fine now except me Thanks
Did you happen to sort the data pages?Also, are you sure you hit "Generate Cheatsheet" since the last time you modified projections or changed scoring inputs?Having some issues here….Order doesn’t follow ranking1 Marshall Faulk StL/5 3602 Shaun Alexander Sea/4 3113 LaDainian Tomlinson SD/6 3774 Charlie Garner Oak/8 2885 Curtis Martin NYJ/5 250...
No, I didn't sort or anything like that, just input the league spec's and generated. I tried it again from scratch and it worked fine the 2nd time.Did you happen to sort the data pages?Also, are you sure you hit "Generate Cheatsheet" since the last time you modified projections or changed scoring inputs?
how the hell did you find that LOL.most years you wouldnt want to see the bad luck bengals jinxing your cheatsheet anywaysDavid, great work as always, but:
1 minor fix:
On the Cheat worksheet, cell B105 has the text value "Cincinnati Bengals" in it. You can't see it on screen b/c it's black text on a black line, but it's there and I can see it when I reformat the cheatsheet & print it out. (BTW: This "easter egg" has been in the VBD App for a couple of years now.)
It's something that I found a couple of years ago (when they were cheatsheets.net) and I'm guessing that David and Co. have never removed it.When the VBD app comes out every year, somehow I remember to check that cell and I have told them about it every year and look where that has gotten me........how the hell did you find that LOL.most years you wouldnt want to see the bad luck bengals jinxing your cheatsheet anywaysDavid, great work as always, but:
1 minor fix:
On the Cheat worksheet, cell B105 has the text value "Cincinnati Bengals" in it. You can't see it on screen b/c it's black text on a black line, but it's there and I can see it when I reformat the cheatsheet & print it out. (BTW: This "easter egg" has been in the VBD App for a couple of years now.)
my league scores something like this too. Because the projections are done for the year and not on a game by game basis as my scoring requires it makes it tough to use these projections and thus the application. I have played around with the scoring but would also be interested to see what others with this type of scoring do.thanks.Couldn't wait for this one and it's working perfectly for me so far!Quick question on how to adjust scoring for pts. per yards. Our QB gets 1 pt. per 25 yards after the first 100 yards so a 248 yard game would = 6 pts. What is the best way to enter this in the input sheet?Our RB's and WR's get 1 pt. per 10 yards after the first 40 yards so same question for those positions.I'm sure I won't be able to get it exactly right but I'd like to get it as close as possible.Thanks!
Budman,Email me the name of the excel file that your are using.maxwell@footballguys.comI'm getting this error when I run the excel version. Run-tim error '1004' application defined ot object defined error.
Nevermind. Worked fine from zip.When I try to download and save, I get a password login box. Do you have to me a member to use this? If not, what do I need to do to save the download?Thanks
They are inflated so you know the ceiling of players. Ideally this app would show a range of values (High and low) to look for, but I am limited to one field.The logic goes like this:1. These represent the maximum you should ever pay for a player. 2. Since you are bidding to get bargains, except for core players you HAVE to have, you will be getting players that come in cheaper than these numbers.3. Many players worth $3-$10 will likely go for a dollar as people blow their cap. Our value shows what they are worth (high end of that scale).4. By showing maximums, it shows that you should not be afraid to get a LT or Ricky Williams etc. It just means you will need to save a lot of cap later. I am going to tweak things in the future that allow you to assign percentages of cap to positions as well as adjust this fudge factor (all the way to zero if you want). I can tell you from personal experience though if you relax the fudge factor to zero, you will be outbid on all the stars and be getting outstanding value in the middle and end. Unfortunately that will get you a marginal team.I feel our numbers will make sure no one gets the stars too cheap and allow you to get value early so you can afford a few of them.Just a matter of preference I guess, but I have always liked how this presents things. Winning auctions generally means having some stars and then saving the rest of the way with every pick. You should never bid more than our values unless you know it will fit.Hope that helps.I found another bug:Auction values are inflated by 25%. Ok, I know this is how you designed it. But why?!
Thanks, David, it makes sense and I agree with you to some extent. Your personal experience is a bit different then mine. Last year in Beta league I used what would amount to a zero fudge factor and did end up with no real studs but a lot of middle tier players. I ended up 4th best in points through 17 weeks. I guess the thing about having a lot of middle tier players is that if some of them break out(Moulds, Garner and Toomer in my case) you will excel. However, if you forked out a third of your cap for Faulk and he tanks you're likely done unless you got very lucky on 1%-2% players.Also, point #2 is invalid. Since the VBD app prices players 25% more than the available money there are going to be lots of players that come in under your listed price, which still doesn't necessarily equal a bargain if they go for 10% "over" instead of the listed 25% "over".They are inflated so you know the ceiling of players. Ideally this app would show a range of values (High and low) to look for, but I am limited to one field.The logic goes like this:I found another bug:
Auction values are inflated by 25%.
Ok, I know this is how you designed it. But why?!
1. These represent the maximum you should ever pay for a player.
2. Since you are bidding to get bargains, except for core players you HAVE to have, you will be getting players that come in cheaper than these numbers.
3. Many players worth $3-$10 will likely go for a dollar as people blow their cap. Our value shows what they are worth (high end of that scale).
4. By showing maximums, it shows that you should not be afraid to get a LT or Ricky Williams etc. It just means you will need to save a lot of cap later.
I am going to tweak things in the future that allow you to assign percentages of cap to positions as well as adjust this fudge factor (all the way to zero if you want).
I can tell you from personal experience though if you relax the fudge factor to zero, you will be outbid on all the stars and be getting outstanding value in the middle and end. Unfortunately that will get you a marginal team.
I feel our numbers will make sure no one gets the stars too cheap and allow you to get value early so you can afford a few of them.
Just a matter of preference I guess, but I have always liked how this presents things. Winning auctions generally means having some stars and then saving the rest of the way with every pick. You should never bid more than our values unless you know it will fit.
Hope that helps.
S.K.A.,This is a must read if you plan on using VBD.VBD virgin here. Any links to "how to use" would be great. I did read the tab that said to "Read Me First" and will tinker with the program, but like I said, some reference material would be great.
Just so people don't think you're crazy for finding, I thought I'd point out that I also notice this every year. I do because I do some reformatting on the Cheatsheet and start by removing all existing formatting... which makes the formerly black-on-black Bengals show up.It's something that I found a couple of years ago (when they were cheatsheets.net) and I'm guessing that David and Co. have never removed it.When the VBD app comes out every year, somehow I remember to check that cell and I have told them about it every year and look where that has gotten me........
OTW,You should post this question in the Applications Forum and give a little more detail so that we can assist you.Why is the IDP cheatsheet blank yet my offensive cheatsheet isn't ?