Fantasy Football - Footballguys Forums
Welcome to Our Forums. Once you've registered and logged in, you're primed to talk football, among other topics, with the sharpest and most experienced fantasy players on the internet.
The ghost of BaseballTangent presents... (1 Viewer)
- Thread starter Mr. Pickles
- Start date
Mr. Pickles
Footballguy
Updated Dropbox direct link: app link
Just some general points:
[*]This is an old version of the spreadsheet with only projections updated. There may be bugs. Probably nothing major. It seems to be working.
[*]You will need to enable macros for this to function. If you're worried about viruses, don't be. We're not that bright.
[*]I make no warranties about accuracy of the data; for example, the positions (esp. SP/RP) might not be correct since I changed them by hand (from memory).
[*]You can edit anything you want to in the data/projections yourself by changing the cell entries via the PITCHERS and HITTERS tabs. Once you're done, re-run it from the front page.
[*]I'm not going to support this in any way. I may make slight tweaks, but please don't ask me to make wholesale changes.
[*]Whatever cash you win as a result of using this app requires that you tithe 10% to BBT Enterprises, LLC and its subsidiaries.*
[*]Profit.
* This statement is for shtick purposes only. The app is free.
Just some general points:
[*]This is an old version of the spreadsheet with only projections updated. There may be bugs. Probably nothing major. It seems to be working.
[*]You will need to enable macros for this to function. If you're worried about viruses, don't be. We're not that bright.
[*]I make no warranties about accuracy of the data; for example, the positions (esp. SP/RP) might not be correct since I changed them by hand (from memory).
[*]You can edit anything you want to in the data/projections yourself by changing the cell entries via the PITCHERS and HITTERS tabs. Once you're done, re-run it from the front page.
[*]I'm not going to support this in any way. I may make slight tweaks, but please don't ask me to make wholesale changes.
[*]Whatever cash you win as a result of using this app requires that you tithe 10% to BBT Enterprises, LLC and its subsidiaries.*
[*]Profit.
* This statement is for shtick purposes only. The app is free.
Last edited by a moderator:
Giant Wooden Badger
the Beav
Nice.
Whose projections?
Whose projections?
Notorious T.R.E.
Showdown!™ Administrator
WE'RE BACK BABY
RnR
Footballguy
Giant Wooden Badger
the Beav
Mr. Pickles
Footballguy
There is a in-draft companion Excel app that goes with this one. I've never released it because it's not super user-friendly, but the idea is that you can track all teams during the draft and gauge how you're doing. The way I set it up, you have type in the players' names to draft them. This requires proper spelling or it dies. I didn't work with it to improve it beyond that, but it works great. I also needed to make custom versions depending on how big the league is. I've used it myself for a while now (premiered it at the NFBC the one year we went).
Mr. Pickles
Footballguy
They're not mine.. that much I know.Giant Wooden Badger said:
Tremendous Upside
Footballguy
Arcade Fire wins AOTY and Pickles re-releases his app? Could the last 24 hours get any more AWESOME!!
oso diablo
Footballguy
thanks for the app. i may be doing something wrong, but in generating a cheatsheet for NL-only, i am also getting the LA Angels players.
Mr. Pickles
Footballguy
Along with fake profits comes the vexing challenge of splitting up the fake residuals.
Mr. Pickles
Footballguy
Yeah, that's one of the flaws. I used a vblookup to translate league info based on a table. If the label is wrong, it might get the league wrong. I can probably fix it.
Mr. Pickles
Footballguy
Try downloading it again. The problem was in the vblookup which only used an approximate match, so it took LAA to be the same as LA and made all Angels in the NL.If this sharing site gives anyone issues, let me know.. and maybe suggest a better host.
oso diablo
Footballguy
thanks again.i changed all the "LA" players (the Dodgers) to "LAD", and that did the trick, too. Had to update the lookup tables out in columns AJ, as well.
Mr. Pickles
Footballguy
I also fixed the free agents. They are listed as FAN and FAA. The table handles those now. If a player finds a team, can you change their team code and update the projections as necessary.Any projections will work as along as you format it correctly. That was the hard part.
Mr. Pickles
Footballguy
That previous hosting site was terrible. I changed it to link to my Dropbox account. This should be much smoother.
Mr. Pickles
Footballguy
No clue whatsoever. It runs with VBA, so my guess is no.
Mr. Pickles
Footballguy
There is a BBT raw score associated with the ranking which tells you how much it values that player in a vacuum. There is no attempt at VBD, however. If you are playing head to head that's another wrinkle that lessens the importance of discriminating by position.It's not that I don't think position scarcity and baselines aren't important, it's just much more difficult to handle with so many positions in baseball. You can essentially get at it by looking at the overall ranking and visualizing tiers on your own. To include it explicitly in the score would skew things too much. Actually, there is a little bit of "special sauce" thrown in for certain categories, but not for positions.
gotcha, thx.
snitwitch
Footballguy
It appears not to work. Can you tell me where these projections are from though?
Mr. Pickles
Footballguy
Trade secret.
Jethro Q. Walrustitty
Footballguy
Excellent
Last edited by a moderator:
RnR
Footballguy
WTF have you been, GB?
Mr. Pickles
Footballguy
Good. You're on the street team.
General Malaise
Footballguy
Oh, herrro!
DoubleBandit
Footballguy
I still remember crossing over to the Baseball Tanget site after your NFBC draft a couple of years back. You had the most traffic in one night ever. What happened to the site? I think I still have a post I made in my NFBC message board private message page. Do you play in the high stakes baseball games?
Mr. Pickles
Footballguy
What happened? How much time do you have?
DoubleBandit
Footballguy
All baseball season....your girl in your picture, looks like she enjoyed you pickle...'Mr. Pickles said:
Mr. Pickles
Footballguy
It's a long and sordid tale.
ditka...mike ditka
Footballguy
Thanks for this! I ran a cheatsheet and it doesnt merge my hitters and pitchers. It may be because I dont see where I can put in the amount of starters for each position. Am I missing something here or is that not part of the app?
Mr. Pickles
Footballguy
Can you explain what you mean here?
ditka...mike ditka
Footballguy
Sorry. I guess I meant on the ranking page. I was hoping it would intertwine the hitters and pitchers. For example it might list 7 hitters, then the top pitcher, a few more hitters, couple pitchers, etc. Instead, it ranks the hitters 1-500 or whatever, then does the same with the pitchers...it is essentially ranking all the pitchers below all the hitters.
Mr. Pickles
Footballguy
It should have a mix of players with their relative score/dollar value. I'm not sure why it's not doing that or how you got it to do that. If you download the copy provided and run nothing, it will have it formatted in this way. The only thing you really need to change is your league size and the number of hitters and pitchers on your roster.
Bobcat10
Footballguy
Not sure what's wrong...but when I try to use the create cheatsheet button, I get the following:
'bbtdraftapp11.xlsm.xls' could not be found. Check the spelling of the file name and verify the file location is correct.
I tried to save the file as bbtdraftapp11.xlsm.xls and that doesn't help. Macros enabled. Even straight off the download that button will not work...or if I simply check OPS after the download. I've downloaded multiple times.
Any ideas?
'bbtdraftapp11.xlsm.xls' could not be found. Check the spelling of the file name and verify the file location is correct.
I tried to save the file as bbtdraftapp11.xlsm.xls and that doesn't help. Macros enabled. Even straight off the download that button will not work...or if I simply check OPS after the download. I've downloaded multiple times.
Any ideas?
Mr. Pickles
Footballguy
Not really. Works fine for me. The name that you're quoting above isn't right, though. Why does it have two extensions? It should be .xlsm only.'Bobcat10 said:
Mr. Pickles
Footballguy
Requires Excel with macros enabled.I cant open it. Guess i dont have the program required to open it.
dirtyhalos
capital letter hater!
i heard hoss registered babymakingtangent.com
