What's new
Fantasy Football - Footballguys Forums

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Excel Cheatsheet Generator (1 Viewer)

  • Thread starter Thread starter ianfitzy
  • Start date Start date
I

ianfitzy

Guest
I remember either last year or the year before there was an excel program out there with rankings and projections and you could input your league info and it would generate rankings, similiar to the Draft Dominator but for fantasy baseball. It might have been from Baseball Tangent but I don't think that is up anymore. Anyone know if there is one for this year and where can I download it? Thanks a ton.

 
Captain Hook said:
It is not free, but www.fantasybaseball.com has the Automated Value Calculator which does what you are talking about
Click to expand...
I see it costs $29.95 to get this with a subscription. Have you used the AVC before? Do you think its worth it?
 
curta269 said:
Captain Hook said:
It is not free, but www.fantasybaseball.com has the Automated Value Calculator which does what you are talking about
Click to expand...
I see it costs $29.95 to get this with a subscription. Have you used the AVC before? Do you think its worth it?
Click to expand...
1) Yes, it is worth it if YOU want to use that type of program - but Platinum subscription comes with a whole lot more than just the AVC2) There is my personal money back guarantee for FBG (see previous threads or just shoot me a PM)PVH
 
I got a great one from Mr. Pickles a few years back, totally dominated my league.

Lets get another one out Pickles!

 
Mike said:
Vikes Fan said:
Not up yet, but coming...

http://www.myofficepool.ca/mlb/
Click to expand...
To give an update on this one, we are targetting Mar. 1st to release the '09 Cheatsheet Compiler and Draft Buddy. We've had Mar. 1st circled from the beginning, so here is hoping for no hiccups in the final week putting it together.
Click to expand...
Awesome, can't wait. Looking forward to another title.Did you take some of the feedback from this forum to improve this year's version? I know we have a few posts in another thread last year pertaining to improvements.

 
Last edited by a moderator:
Lehigh98 said:
Mike said:
Vikes Fan said:
Not up yet, but coming...

http://www.myofficepool.ca/mlb/
Click to expand...
To give an update on this one, we are targetting Mar. 1st to release the '09 Cheatsheet Compiler and Draft Buddy. We've had Mar. 1st circled from the beginning, so here is hoping for no hiccups in the final week putting it together.
Click to expand...
Ugh, my draft is Friday night. Wish I could have tried it out!
Click to expand...
Sorry Lehigh. I will do what I can to get it out early, but I'm not that optimistic, especially considering you really should have some time to try out the features and such before going live to draft with it. We're going to really target to get this out a lot earlier next year (like Feb. 1st instead). We did right around Mar. 1st last year and didn't notice anyone we missed because they are already drafting, but this year there have been a few like yourself.
 
Bobcat10 said:
Mike said:
Vikes Fan said:
Not up yet, but coming...

http://www.myofficepool.ca/mlb/
Click to expand...
To give an update on this one, we are targetting Mar. 1st to release the '09 Cheatsheet Compiler and Draft Buddy. We've had Mar. 1st circled from the beginning, so here is hoping for no hiccups in the final week putting it together.
Click to expand...
Awesome, can't wait. Looking forward to another title.Did you take some of the feedback from this forum to improve this year's version? I know we have a few posts in another thread last year pertaining to improvements.
Click to expand...
I like that testimonial Bobcat :banned: I didn't see any feedback in this forum, but there was some in my own forum and by email which I definitely took into consideration. I am adding quite a few new things which is why this is taking some time to get ready. Hopefully I hit on the items you are thinking about.

 
Did I read that correctly. The draft buddy and compiler are free. I was about to dish out another $50 for rotolab. May not have to now.

 
Mike said:
Bobcat10 said:
Mike said:
Vikes Fan said:
Not up yet, but coming...

http://www.myofficepool.ca/mlb/
Click to expand...
To give an update on this one, we are targetting Mar. 1st to release the '09 Cheatsheet Compiler and Draft Buddy. We've had Mar. 1st circled from the beginning, so here is hoping for no hiccups in the final week putting it together.
Click to expand...
Awesome, can't wait. Looking forward to another title.Did you take some of the feedback from this forum to improve this year's version? I know we have a few posts in another thread last year pertaining to improvements.
Click to expand...
I like that testimonial Bobcat :confused: I didn't see any feedback in this forum, but there was some in my own forum and by email which I definitely took into consideration. I am adding quite a few new things which is why this is taking some time to get ready. Hopefully I hit on the items you are thinking about.
Click to expand...
Page 2 of this thread here had some stuff from me and a few others...
 
Mike said:
AcerFC said:
Did I read that correctly. The draft buddy and compiler are free. I was about to dish out another $50 for rotolab. May not have to now.
Click to expand...
Yes, that is right. The Compiler and Buddy are (will be) free.
Click to expand...
I just want to give out props to this! Yes, free! Yes, easy to use much like the FBGs draft dominator! I have been in a keeper league three years. The first year I finished last in my division (mainly because of what I inherited) without the Compiler. Finished one game out of the playoffs the next year with the Compiler and won my division (but got bounced in the playoffs) the third year using it again.Good stuff!!! :lmao: (Here's hoping nobody in my league is reading this post!)
 
Update: the 2009 Compiler is now available for download. Draft Buddy will be along... um... soon. I don't want to commit to a day yet. I haven't updated any of the pages except the download links yet, but you can find those and last year's description, here:

http://www.myofficepool.ca/compiler/baseball_index.html

Vikes Fan - Thanks for kudos! I'm going to have to add a testimonials page for this thing.

midwest_kc - Sorry, I don't think it will work on OO, due to the Visual Basic programming and more advanced Excel features that the Compiler uses. It is possible OO has been updated to support it since last I tried, but it hasn't worked in the past. Perhaps you can download a trial version of Excel from microsoft.com?

 
Mike said:
Update: the 2009 Compiler is now available for download. Draft Buddy will be along... um... soon. I don't want to commit to a day yet. I haven't updated any of the pages except the download links yet, but you can find those and last year's description, here:

http://www.myofficepool.ca/compiler/baseball_index.html

Vikes Fan - Thanks for kudos! I'm going to have to add a testimonials page for this thing.

midwest_kc - Sorry, I don't think it will work on OO, due to the Visual Basic programming and more advanced Excel features that the Compiler uses. It is possible OO has been updated to support it since last I tried, but it hasn't worked in the past. Perhaps you can download a trial version of Excel from microsoft.com?
Click to expand...
What is up with your projections for Choo and McLouth? Good Lord..Something is amiss with this thing. Looks terrific, but it's giving a bunch of nonsense as output.

 
Hey Pickles. Scroll down on the setup tab and change the default allocation key drop-down from 100% MOP (projections) to 100% 2008, and hit Compile Cheatsheets again. Do those values more or less seem what you would expect based on prior year stats? This will help us determine if it is a projection issue, valuation issue or both.

There are some outside the box projections, like A-Rod lower than I've seen anywhere. Rick is intending to write in his blog about the players who are somewhat higher or lower than the normal expectation.

 
Great job on the app.

Question - If I'm using a 5x5 h2h league that assigns 1 pt for category (i.e. if I have more HRs than my opponent, I win that category and get 1 pt....max 10 points per week). Should I choose 5x5 roto or points?

 
Thanks TF, I appreciate it. You should set it to roto. If the scoring acts like a roto league:

- you get a point for how you rank in a category no matter how much you beat the other guy by in that category (1 HR, 20 HRs, etc.)

- or put another way, you do not earn a point value for every single stat you accumulate like 1 point per HR, so 12 HRs = 12 points

then it is considered a roto league.

I need to start getting this stuff down in some sort of instruction or reference manual.

 
Mr. Pickles said:
Mike said:
Update: the 2009 Compiler is now available for download. Draft Buddy will be along... um... soon. I don't want to commit to a day yet. I haven't updated any of the pages except the download links yet, but you can find those and last year's description, here:

http://www.myofficepool.ca/compiler/baseball_index.html

Vikes Fan - Thanks for kudos! I'm going to have to add a testimonials page for this thing.

midwest_kc - Sorry, I don't think it will work on OO, due to the Visual Basic programming and more advanced Excel features that the Compiler uses. It is possible OO has been updated to support it since last I tried, but it hasn't worked in the past. Perhaps you can download a trial version of Excel from microsoft.com?
Click to expand...
What is up with your projections for Choo and McLouth? Good Lord..Something is amiss with this thing. Looks terrific, but it's giving a bunch of nonsense as output.
Click to expand...
Yeah I've noticed some odd projections.For example, Kinsler keeps coming out around 10th of 2Bs. Soto 7th catcher. etc..

I'll just tweak it more to my liking b/c the tool is fantastic overall. I hope they made the needed changes to the draft buddy and it will be perfect.

 
Mike said:
Hey Pickles. Scroll down on the setup tab and change the default allocation key drop-down from 100% MOP (projections) to 100% 2008, and hit Compile Cheatsheets again. Do those values more or less seem what you would expect based on prior year stats? This will help us determine if it is a projection issue, valuation issue or both.

There are some outside the box projections, like A-Rod lower than I've seen anywhere. Rick is intending to write in his blog about the players who are somewhat higher or lower than the normal expectation.
Click to expand...
A link when this is ready would be awesome. Great job on the app. Very easy to move things around and manipulate.
 
Bobcat10 said:
Mr. Pickles said:
Mike said:
Update: the 2009 Compiler is now available for download. Draft Buddy will be along... um... soon. I don't want to commit to a day yet. I haven't updated any of the pages except the download links yet, but you can find those and last year's description, here:

http://www.myofficepool.ca/compiler/baseball_index.html

Vikes Fan - Thanks for kudos! I'm going to have to add a testimonials page for this thing.

midwest_kc - Sorry, I don't think it will work on OO, due to the Visual Basic programming and more advanced Excel features that the Compiler uses. It is possible OO has been updated to support it since last I tried, but it hasn't worked in the past. Perhaps you can download a trial version of Excel from microsoft.com?
Click to expand...
What is up with your projections for Choo and McLouth? Good Lord..Something is amiss with this thing. Looks terrific, but it's giving a bunch of nonsense as output.
Click to expand...
Yeah I've noticed some odd projections.For example, Kinsler keeps coming out around 10th of 2Bs. Soto 7th catcher. etc..

I'll just tweak it more to my liking b/c the tool is fantastic overall. I hope they made the needed changes to the draft buddy and it will be perfect.
Click to expand...
I'm assuming the high Choo projections is a refleciton of his low AB total (300)...assuming there are %s built into the final output
 
what are everyone's thoughts about the SB weighting. I know I was a big proponent of lowering the weight of SB and increasing the HR weighting in the past. Now I'm not so sure.

 
Tough As Nails said:
Mike said:
Hey Pickles. Scroll down on the setup tab and change the default allocation key drop-down from 100% MOP (projections) to 100% 2008, and hit Compile Cheatsheets again. Do those values more or less seem what you would expect based on prior year stats? This will help us determine if it is a projection issue, valuation issue or both.

There are some outside the box projections, like A-Rod lower than I've seen anywhere. Rick is intending to write in his blog about the players who are somewhat higher or lower than the normal expectation.
Click to expand...
A link when this is ready would be awesome. Great job on the app. Very easy to move things around and manipulate.
Click to expand...
I just realized with the Soto comment that Rick did alter a few players, which I updated on the website, but I haven't change the Compiler update pages yet. I wanted to wait a few days to see if he had more tweaks. At any rate, whenever a new Compiler projection update is ready, it will be easy enough for you guys to figure out simply by clicking "Check for Update".Here is Rick's first comments re: A-Rod.

 
Mike said:
Thanks TF, I appreciate it. You should set it to roto. If the scoring acts like a roto league:- you get a point for how you rank in a category no matter how much you beat the other guy by in that category (1 HR, 20 HRs, etc.)- or put another way, you do not earn a point value for every single stat you accumulate like 1 point per HR, so 12 HRs = 12 pointsthen it is considered a roto league.I need to start getting this stuff down in some sort of instruction or reference manual.
Click to expand...
how do you calculate the $$ values. I'm trying to determine how much better player A is than player B. Right now, all I have is $15 vs. $13, but that really doesn't tell me much.
 
Although this isn't terribly detailed, it is the PVM method described here:

http://www2.mockdraftcentral.com/articles/460

I had a more detailed article but it has since been taken off the web. I plan to write my own describing the methodology in the Compiler in the near future.

I think you asked last year about being able to see the marginal contribution percentages rather than dollar values in the Compiler. I think we can do that. Unhide the sheet compile_hitters, and scroll across to cell DC9. It has this formula:

=IF(OR(AR$26=1,AR$27=TRUE)=TRUE,MAX(FLOOR(CZ9/CZ$7*AR$39+AP$31,AR$31),AP$31),AV9)

Try changing it to this:

=IF(OR(AR$26=1,AR$27=TRUE)=TRUE,CZ9,AV9)

which basically deletes the part that calculates the dollar value and inserts the marginal contribution percentage for that player. Copy the formula down for all players, and repeat on the compile_pitchers tabs. Hit Compile Cheatsheets.

Might want to keep a backup copy first in case something happens I'm not expecting. You probably have to change the formatting of the dollar columns on the cheatsheets. Does that help?

 
Mike said:
Although this isn't terribly detailed, it is the PVM method described here:

http://www2.mockdraftcentral.com/articles/460

I had a more detailed article but it has since been taken off the web. I plan to write my own describing the methodology in the Compiler in the near future.

I think you asked last year about being able to see the marginal contribution percentages rather than dollar values in the Compiler. I think we can do that. Unhide the sheet compile_hitters, and scroll across to cell DC9. It has this formula:

=IF(OR(AR$26=1,AR$27=TRUE)=TRUE,MAX(FLOOR(CZ9/CZ$7*AR$39+AP$31,AR$31),AP$31),AV9)

Try changing it to this:

=IF(OR(AR$26=1,AR$27=TRUE)=TRUE,CZ9,AV9)

which basically deletes the part that calculates the dollar value and inserts the marginal contribution percentage for that player. Copy the formula down for all players, and repeat on the compile_pitchers tabs. Hit Compile Cheatsheets.

Might want to keep a backup copy first in case something happens I'm not expecting. You probably have to change the formatting of the dollar columns on the cheatsheets. Does that help?
Click to expand...
Actually, after opening the hidden sheets, it looks like if there was an option to view %s instead of $, all you would need to do is to ask the cheatsheet to read column CZ (Adjusted) on the compile_hitters tab and CE (Adjusted) on the compile_pitchers tab and then you'd have it. Do you agree?
 
Mike said:
Yep, makes sense. Does that number mean more to you than being converted to dollars?
Click to expand...
It does to me....the $ number is adjusted for 65/35 or however you split it. I like to see exactly how much better player 1 is than player 20 in a position.Assume those who play in a non $ league would feel the same :lmao:
 
Tiger Fan said:
Mike said:
Although this isn't terribly detailed, it is the PVM method described here:

http://www2.mockdraftcentral.com/articles/460

I had a more detailed article but it has since been taken off the web. I plan to write my own describing the methodology in the Compiler in the near future.

I think you asked last year about being able to see the marginal contribution percentages rather than dollar values in the Compiler. I think we can do that. Unhide the sheet compile_hitters, and scroll across to cell DC9. It has this formula:

=IF(OR(AR$26=1,AR$27=TRUE)=TRUE,MAX(FLOOR(CZ9/CZ$7*AR$39+AP$31,AR$31),AP$31),AV9)

Try changing it to this:

=IF(OR(AR$26=1,AR$27=TRUE)=TRUE,CZ9,AV9)

which basically deletes the part that calculates the dollar value and inserts the marginal contribution percentage for that player. Copy the formula down for all players, and repeat on the compile_pitchers tabs. Hit Compile Cheatsheets.

Might want to keep a backup copy first in case something happens I'm not expecting. You probably have to change the formatting of the dollar columns on the cheatsheets. Does that help?
Click to expand...
Actually, after opening the hidden sheets, it looks like if there was an option to view %s instead of $, all you would need to do is to ask the cheatsheet to read column CZ (Adjusted) on the compile_hitters tab and CE (Adjusted) on the compile_pitchers tab and then you'd have it. Do you agree?
Click to expand...
TF,What exactly did you do/manipulate here?

Thx

 
Okay, so that is two who want that option :)

TF is saying "if there was an option/switch", Bobcat, but there isn't currently. What you can do is what I'm suggesting in my post (also quoted), to change the formula so it doesn't calculate dollars anymore, but brings over the % instead. Once this change is made, then you won't be able to go back to dollars for an auction league, unless the formulas gets changed back.

Update: Draft Buddy is ready. I shot past my deadline, but I think it has plenty of bells and whistles that hopefully make up for that. People can download it off the site using the same download link as the Compiler. Both the Compiler and Buddy are included in the same download file.

One great feature of Buddy is that you can re-rank players on the cheatsheets simply by changing their ranking number, so you don't have to mess around with detailed projections. This could be beneficial to those who disagree with the projections in the Compiler, as there are apparently a few people in that boat, although Rick is looking pretty good with his bear-ish A-Rod projection right now. Just sayin'... :lmao:

Anyway, if there are any I can answer questions tomorrow. I have to get some sleep. I'm exhausted :thumbup:

 
Last edited by a moderator:
As of now I plan to use this for my cheat sheet for my draft tomorrow.

Is there any other cheat sheets I could look at to compare this one to?

Thanks

 
Wooderson said:
As of now I plan to use this for my cheat sheet for my draft tomorrow. Is there any other cheat sheets I could look at to compare this one to?Thanks
Click to expand...
Really work that ADP info. to get a sense if you can wait on a guy or not. Good luck!
 
Mike said:
Wooderson said:
As of now I plan to use this for my cheat sheet for my draft tomorrow. Is there any other cheat sheets I could look at to compare this one to?Thanks
Click to expand...
Really work that ADP info. to get a sense if you can wait on a guy or not. Good luck!
Click to expand...
Thanks. More then the rankings the ADP will be the biggest help.I for some reason still feel over my head more in fantasy baseball then fantasy football.
 
What's the story with the DH position in the Draft Buddy? I was trying to evaluate a draft using this thing and people like Ortiz weren't available to be drafted.

 
Mr. Pickles said:
What's the story with the DH position in the Draft Buddy? I was trying to evaluate a draft using this thing and people like Ortiz weren't available to be drafted.
Click to expand...
I noticed this too. Couldn't even choose them as keepers. Had to write Ortiz in at 1B (uggh).
 
Hey guys, not far off the mark. I just uploaded a new version 1.1 earlier today ... er, yesterday (2:40am here right now) ... which fixes that DH issue. Used to be, DH would only show up if the league had a DH starter. Now, DH shows up through the Compiler and Buddy if the league used DH or UT. If you input any scenarios where this is not the case (with 1.1), please let me know.

Plus there were a few other fixes. They are all described here. Nothing too major. The roto tab in Draft Buddy grabbed the whole roster before when it was meant to only grab starters.

Sam Quentin - Projection Pal is still in development. Hope to get it done soon, but needed to set it aside for these other things first.

 
Yes and no. I can tell you how to do that fairly quickly.

Setup Buddy 1.1 the exact same was as you have 1.0. The keepers tabs in each should be formatted exactly the same.

Open both Buddy files. In each of them, go to the setup tab. See the option that says, "Allow copy-paste between tabs:"? Change that to "on" for both. Now simply highlight the player positions and names from 1.0 for each team (do 1 team at a time so you're not copying any cells with formulas), copy with CTRL-C, put it in the same spot in 1.1, and CTRL-V to paste. After you're done all the teams, then turn that option on the setup tab back to "off".

 
Mike said:
Yes and no. I can tell you how to do that fairly quickly.Setup Buddy 1.1 the exact same was as you have 1.0. The keepers tabs in each should be formatted exactly the same.Open both Buddy files. In each of them, go to the setup tab. See the option that says, "Allow copy-paste between tabs:"? Change that to "on" for both. Now simply highlight the player positions and names from 1.0 for each team (do 1 team at a time so you're not copying any cells with formulas), copy with CTRL-C, put it in the same spot in 1.1, and CTRL-V to paste. After you're done all the teams, then turn that option on the setup tab back to "off".
Click to expand...
I think that worked fine.Got another question....I have this compiler set up for fantasy points. When I go look at David Wright, for example, his "Roto Pts" (column AM in the hitters tab) is 356.6. Clearly this is very low if this is where I should be seeing his total points. My league is 1pt per TB, R, RBI and 2pts per SB for hitters. That same 356.6 is listed in the draft buddy also.Is this calculating properly? Will I not be able to see his projected total points (600 and something) anywhere in the spreadsheet?
 
You must log in or register to reply here.

Similar threads

Tonycarpenter
12 Team 15 Keeper Who do you keep
Replies
16
Views
561
Tonycarpenter
Tonycarpenter
DJackson10
Anyone interested in a keeper Baseball league Most likely Yahoo but can be discussed.
Replies
0
Views
800
DJackson10
DJackson10
M
Need managers for the ultimate fantasy baseball experience
Replies
4
Views
909
Bogart
Bogart

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top