Final Fantasy Baseball Projections Update for Cheatsheet Compiler & Draft Buddy

I am away for some rest and relaxation right now, but constantly connected and still updating ye ole website as possible and as needed. Today we were due for an update. I received a final fantasy baseball projections update from Steamer Projections Blog for the Steamer-Razzball projections. FantasyPros also updated their Zeile Consensus projections, and with Opening Day now officially in the books yesterday, I’m putting a cap on that and calling those the final projections as well.

The update is now available for the Cheatsheet Compiler & Draft Buddy. Each set of projections are updated, plus Average Draft Position (ADP) data from each of FantasyPros, Mock Draft Central and National Fantasy Baseball Championship.

The depth charts are taking a little more time than I’d like with all the final week changes, and my desire to not mess up the available players we already have in the Compiler & Draft Buddy. I updated the AL East so far, plus the Los Angeles Angels of Anaheim so I could get Vernon Wells on the New York Yankees, and I’ll work away at the rest as time allows (and to not annoy the wife while on vacation).

Thanks once again to all the guys at FantasyPros, Steamer, MDC and NFBC for their contributions to the Compiler & Draft Buddy this fantasy baseball season. It is very much appreciated.

Thanks to all of you, our members, for continuing to use the CC/DB, or trying it for the first time this season. I hope you liked it, and will remember us again next year. Or, even better, if you play fantasy football make sure to try out the fantasy football version of the CC/DB.

Have a great season. Go Blue Jays!

One Day to Opening Day, Projections Update

It is nearing 1:30 am in the morning where I’m sitting, and I have a family vacation planned to start tomorrow. Er… later today. Not too late in the day though. Our flight leaves at a ridiculous 6:30 am, so just 5 more hours to boarding and departure.

Why then am I up right now instead of getting some much needed rest? We have another projections update! To start with, I had to stay up until the final of the Florida Gulf Coast-Florida game so I could appropriately update my March Madness Survivor Pool.

As I was waiting for the game to finish, I flipped over to FantasyPros and saw they updated their Zeile Consensus projections. Then I zoomed over to Steamer Projections Blog to find out they updated their Steamer-Razzball projections. Everyone is keen for a last final tweak to their projections before we hit Opening Day on Sunday night and Monday.

I guess it is time for an update for the Cheatsheet Compiler & Draft Buddy, and our online fantasy baseball cheatsheet rankings. Those are now updated as of this post, so open your copy of the Compiler, select the projections you want to update, and hit Update Projections.

Thanks again for all of the support this year. The response to the baseball Compiler & Draft Buddy continues to be very strong. If you are still drafting this final weekend before real baseball starts, good luck! Have a great season!

Projections, ADP and Depth Charts Update

Status

The Cheatsheet Compiler & Draft Buddy update is now available! That was quite a chore, starting yesterday and finally finishing today, but we have updated projections from each of FantasyPros and Steamer-Razzball, Average Draft Position (ADP) data from each of Pros, Mock Draft Central and NFBC, plus updated depth charts. These updates also helped create updated fantasy baseball cheatsheets, for those who want to quickly print and run to their draft instead of downloading and setting up the CC/DB.

If I could mention the depth charts (and accompanying rosters) for a moment, I’m still not entirely happy with how they are presented on the website. The 25-man rosters are in good shape, as that is what I’m concentrating on mostly because those are most relevant for fantasy purposes, and they feed into the Cheatsheet Compiler (well, it all does). It is the remaining 40-man roster players and non-roster players that are tougher to keep straight.

As time allows, I can see I’m still going to continue to fuss around with the depth chart and roster pages to provide as much information, in a clean and organized format, as possible. What isn’t helping entirely is the roster data purchased from our stats provider. It gives me all the players, but in terms of identifying what roster a player is currently on, and whether he is injured or not, the data falls short in places.

Anyway, something for me to continue to work at and improve. If you are still drafting this week and Easter weekend leading to Opening Day, grab the update and good luck!

Baseball Coming Soon! Projections Update Coming Sooner

It is getting a bit late in the day here Monday (when I take into account hustling kids home from school, some other chaos going on in this household (don’t get me started), and the fact I play hockey tonight), so I don’t want to guarantee the next projections update will be done today. However, it looks like Steamer updated their projections and FantasyPros updated their Zeile consensus projections, so we are definitely due for an update heading into the final week before the start of the season. I wanted to post a quick Monday update saying that is what I’m working on, and for you guys to expect it shortly.

I’ll also hit the ADP which should be updated to reflect drafts from this past weekend, and whatever depth charts changes are needed, like Vernon Wells to the New York Yankees, assuming it gets approved. What a contract he got from the Toronto Blue Jays. Even after an unbelievable offseason of player acquisitions, shipping Wells off to the Los Angeles Angels of Anaheim may still rank as Jays GM Alex Anthopolous’ greatest magic trick.

If you have a minute, and you’ve had a good experience using the Cheatsheet Compiler & Draft Buddy this season, please add a testimonial. I’d really appreciate it.

Also like us on Facebook or follow us on Twitter, if you haven’t already. I’m not the most rah-rah social media butterfly around, but each of those sites do prove to be very good ways for us to communicate if you have thoughts or questions about the CC/DB or other features at the website. Okay, on to the update. I’ll be back as soon as possible.

Steamer-Razzball and Zeile Projections Updates

Welcome to a new week, another week closer to the start of baseball season. I know a bunch of our members drafted this past weekend and I’m sure there are still plenty of fantasy baseball drafts scheduled the next couple weeks. That, coupled with March Madness* kicking off this week, and we’ve got a pretty darn exciting sports calendar ahead of us.

To start the new week, we have an update to both sets of projections available in the Cheatsheet Compiler & Draft Buddy. The Steamer-Razzball projections from Steamer Projections Blog and Razzball, plus the Zeile Consensus Projections from FantasyPros, each updated on Sunday.

Those are now updated on our side, so you need to open your copy of the Cheatsheet Compiler, go to the setup tab, select which one you want to update, and hit Update Projections. Remember, if you want to update both sets of projections, select one, click Update Projections, then click the button to move it from Site A to Site B. Once that is done, select the other set and click Update Projections again.

The Average Draft Position (ADP) data from each of Mock Draft Central, FantasyPros and National Fantasy Baseball Championship also received an update. Select the one you prefer on the ADP tab in the Compiler and it will update when you update projections.

Last but not least, in terms of update news, new projections meant the Compiler kicked out new baseball cheatsheets for us, if you simply want to print the player rankings from the website and go.

I received a note from member btscot7 this morning wondering why he was getting an error opening Draft Buddy… something to do with the TimerModule. From that he reminded me that the countdown timer does not work in 64-bit versions of Excel. This happened last year too, I just forgot exactly what the issue was.

As of this morning there is a new alternate version of Draft Buddy available from our download page for 64-bit Excel users. You won’t be able to use the countdown timer, as I simply had to remove it (sorry), but better to get 100% of the core features of Draft Buddy and lose one frill feature than not be able to use it at all.

* Are you a college basketball fan, or even March Madness bandwagon fan this time of year (like me)? Over at one of my other websites, MyOfficePool.ca, I run a unique March Madness Survivor Pool that has steadily grown in popularity. If you want to try it out, sign up over there and give it a shot. It is a lot of fun and frustration trying to pick winners each round of the tourney to move on – survivor style. And you can’t pick the same team twice, so plan ahead!

Another Zeile Consensus Projections Update

Status

I moseyed over to FantasyPros today and noticed they updated the Zeile Consensus Projections again, so even though we did an update yesterday, I don’t want you guys heading into the weekend with outdated projections. A new update is now ready, and it is strictly for the Zeile projections. The ADP, depth charts and Steamer-Razzball projections all stayed the same. If you are using Zeile, open the Compiler, go to the update tab and hit Update Projections and you’ll be all set.

Zeile Projections Update To The Update

It is a tricky business relying on fantasy baseball projections from other sources, and trying to stay up to date all the time, especially when they have a seemingly random update schedule. After finalizing the update yesterday for the Cheatsheet Compiler & Draft Buddy, I woke up this morning and, after noticing one small mistake I wanted to correct, I checked the Zeile consensus projections over at FantasyPros and they updated them again, late last night, after our last update. Darn it.

It is the weekend and many of you might be drafting today or tomorrow, so lets get everyone up to date with the latest projections, even though it is difficult to decipher exactly what changed from the last version to the current version. Okay, as of typing this I updated the Zeile projections again. You’ll see even if you already hit Update Projections after yesterday’s update (Friday ~ 7:00pm Eastern), the Compiler will tell you once again this morning (Saturday ~ 8:00am) that there is an update available.

As for the small mistake, I noticed in the Cheatsheet Compiler that Reid Brignac was still on his old team, Tampa Bay, even though I know I switched him in our depth charts weeks ago. I finally realized the issue.

The Compiler update pages I create were pulling the team and position information from the Zeile projections instead of the depth charts. Zeile still shows Brignac on Tampa. Steamer, by the way, shows him as a free agent. You’ll notice this on his player page where each of those projections are shown below his historic season stats.

Now I am pulling the team and position data from the right spot, our depth charts, so the Compiler properly shows his current team, the Colorado Rockies, after running the aforementioned update. This would apply to any other player who switched teams recently where our projection source haven’t quite caught up yet.

Fantasy Baseball Projections, ADP and Depth Chart Update

That took some time – longer than I expected (per usual) – but the projections, average draft position and depth charts are now updated for the Cheatsheet Compiler & Draft Buddy. Open your copy of the Cheatsheet Compiler, go to the update tab, make sure the Zeile (FantasyPros) option is selected for projections source, and click Update Projections.

No update to the Steamer-Razzball projections this week, only the Zeile projections. I updated the ADP from all three of our sources, FantasyPros, Mock Draft Central and National Fantasy Baseball Championship. Thanks once again to each of our partners for their contributions to the CC/DB.

I also ran through every team to update our depth charts too. In terms of other online features, the projections update creates new updated player rankings for our cheatsheets and player pages, like Bryce Harper.

We had some questions the last few days about the projections, including a discussion on our Facebook page when member smackie1970 noticed there are way too many at-bats going to the Tampa Bay shortstops. Make sure to check that out to understand the reasoning behind it.

Commenting on a previous blog post, member prnichols7807 asked why Holds (and I noticed, Quality Starts too) aren’t included in our Steamer-Razzball projections when they are over at Razzball. It seems that Razzball adds those to Steamer, and they want to keep them proprietary, which is certainly understandable considering HLD and QS are not as commonly projected by fantasy baseball prognosticators across the inter webs. My suggestion if you really want these in your copy of the Cheatsheet Compiler would be to do so using Projection Pal. If I have time then I will revisit that topic next week to show how I would do it.

Okay, that is it for the update. Have a good one, and good luck if your draft is on this weekend.

Another Update, Plus Baseball Player Rankings

A new week and yet another update for the Cheatsheet Compiler & Draft Buddy. The Zeile Consensus Projections and ADP each received an update, which you can obtain by simply opening your copy of the Cheatsheet Compiler, going to the update tab, and hitting the Update Projections button, making sure you are asking for the Zeile (FantasyPros) projections from the available drop-down.

Don’t have the Cheatsheet Compiler & Draft Buddy yet? They are free, including updates from now to Opening Day. All you need to do is register a member account (or login with your old one and renew access) and go to the download page to get the CC/DB, fantasy baseball version for 2013. Testimonials and/or donations to help pay for our web hosting and time are appreciated.

The CC/DB is in Microsoft Excel, which is software that some of you maybe don’t have on your computer, or don’t use currently or very often, or don’t care to try. I’ve tried to make the Cheatsheet Compiler & Draft Buddy as user-friendly as possible, but it is within the confines of Excel which isn’t everyone’s idea of a good time. As a (former) accountant, it was a natural for me, but I understand some reluctance or even frustration using a Microsoft product.

Overall
Rank
Player
Team 5X5 ADP
1 MIL $46 1.01
2 DET $46 1.02
3 LAA $44 1.03
4 NYY $36 1.07
5 LAD $35 1.04
6 LAA $35 1.06
7 LAD $33 2.02

To help bridge the gap by providing something beneficial to non-Excel users, I posted new player ranking pages on the website. Print and go, with the old pencil and paper draft method. Nothing wrong with that, and you are certain to not spill beer on your laptop at the draft. The rankings are based on standard 5X5 roto scoring with a typical $260 salary cap (i.e. same format as you see in outdated magazines on the racks at the book store), pulled from the Cheatsheet Compiler. There are overall rankings and rankings by position. I’ll update these each time we update the projections in the Compiler.

I hope you find that helpful. Feedback is welcome either here in the blog comments, or on Twitter or Facebook.

Big Baseball Update To End The Week

Where did the week go? Better question: Why do I find myself asking that same question every week?

Not to worry, I’m not expecting an answer to either question, but I do have good news in that we are going to finish the week just like it started, with an update to the Cheatsheet Compiler & Draft Buddy.

This time the update is to both sets of fantasy baseball projections – Steamer-Razzball and Zeile – plus the average draft position (ADP) data from all three sources – FantasyPros, Mock Draft Central and NFBC. Our depth charts are still in good shape, except the Chicago Cubs who got missed last time, so they got updated.

Since we have two sets of projections to update, and the Cheatsheet Compiler only does them one at a time, here are the steps you should follow, keeping in mind that from the default download file, Zeile projections are in Site A and Steamer projections are in Site B.

1. Update Steamer. Go to the update tab in the Compiler and change the Projections source drop-down to “Steamer-Razzball”. Click the Update Projections button.

2. Move Steamer. After you just updated, Steamer overwrote the prior projections in Site A. Lets move them to Site B so we don’t lose them from the Zeile update. Go to the update tab in the Compiler and near the top of the tab click the Move to Site B button.

3. Update Zeile. Repeat step 1 but change the Projections source drop-down to “Zeile (FantasyPros)”.

After that you are up to date.

For some added reading on the projections we are using in the Cheatsheet Compiler, check out Where Steamer and ZIPS Disagree by Dave Cameron over at FanGraphs. Then read Jared Cross’ response at the Steamer Projections Blog and adjustments made to Steamer as a result (and which led to the above noted update).

Longtime Draft Buddy member, BeanTown, did some sleuthing to find out if projections that are averages of a bunch of single sets of projections tended to be more or less accurate in general than single sets of projections. He found this article by Wil Larson over at FanGraphs, and mentioned similar findings from sabermetrician (is that a word?) Tom Tango. The findings? Average projections are good for hitters, but less good for pitchers. Interesting.

From that, BeanTown asked me how he could set the allocation keys in the Cheatsheet Compiler to use Zeile projections for hitters, and Steamer projections for pitchers. No problem I told him. Here is how:

1. First, set the default allocation on the setup tab to 100% Zeile (Site A). That we will use for hitters.

2. Then, go to the pitchers tab and do you notice just above the spreadsheet but below the toolbars a “+” sign. Click that and it will unhide some columns. In the yellow column under “Non-Default % Key” you can put a different allocation key for an individual player. Unless you’ve changed it, “8″ should be the 100% Steamer (Site B) key. Put 8 for the first player, copy it, and paste it all the way down for all players on the pitchers tab.

3. Hit Compile Cheatsheets.

After step 3, the cheatsheets are now generated based on Zeile for hitters, Steamer for pitchers. Hopefully that provides the best of both worlds.