Thursday, February 26, 2015

#PackADailyCircus: Updates; Automating; Recruiting new managers!

Hello, everyone! Thanks for stopping by. Let's take a look at the Pack-A-Daily Circus happenings as of February 26, 2015! This is lengthy, so watch me for the changes and try to keep up. ;-)

I sent an email to the 2014 Managers, so if you were one last year, check your email!

I have heard back from just about every manager. Nearly everyone is coming back for this season's pack-breaking fun! That is awesome! I am very excited to see what this season holds!

Each manager from the 2014 season was allowed to keep nine (9) carryovers from last season. As the Commissioner of this endeavor, I thought it was a fun way to bring folks back in and add a little "team cohesiveness" to the breaks.

Some managers have come up with new names for their teams, so we may see familiar names, but they will have new faces! Most of us are keeping the team name we used last season. Will keeping tradition or shaking things up be one of the key factors in making it to the championships this season? We will find out as the season unfolds.

This season, we will not have write-in players. Each draft will have a set choice list (more on that in the next section). This will help cut down on duplication and typos.

A *VERY* special thanks goes to JoshD for taking some time to work out an automated draft Excel Workbook! I've played with it a bit, and it should do quite nicely in terms of running the drafts this season! As with previous drafts, all drafts will be Serpentine style (also called "snake drafts"). His custom programming handles the snaking perfectly in my tests!

I asked Josh to share anything he wanted about the process, etc. Here is his summary:
1) Paste in the Draft Selections
1B) If requested, randomize the draft order.
2) Figure out for each pick #, whose turn it is.  This depends on how many entrants, and whether it is an odd round (going down in the snake) or an even round (going up).  This currently only works for snake drafts.
3) Figure out which is the first choice for that person that is still available.  Put this person into the "Picked" list.
4) Do this for all the Picks (using a Loop in Excel VBA).
5) Summarize the results into the format shown using VLOOKUPs in Excel.
I cannot tell you how excited I am to put this program into use! In previous seasons, I have had to run the drafts by hand, using a laborious, monotonous process of selecting the player, finding all of that same player in each manager's picks, removing the duplicate picks, shifting the draft, then moving to the next pick, lather, rinse, repeat. This adaptation does all that for me with the push of a single button!

Just to be sure, I will verify the drafts to make sure they ran accurately. As I said, though, my initial tests are proving this to be a smooth system.

In order to help the process, as I mentioned above, this season I am shifting to using a set draft pick list. I will be using Google Forms to collect draft picks. In the past, we've had issues of missing picks, but I have a script that will run each time you submit draft picks so that you get an emailed copy of your picks, I get an emailed copy of your picks and your picks will be in the results sheet. Before I run each draft, I will make sure that everything matches up. If something is amiss, I should have a record of it beforehand! I can use the results to feed into Josh's workbook, and cut my draft times from hours to less than a minute (or thereabouts)!

Before the breaks actually start, each team will be able to fill their 25-man roster. After I have all the managers in place (see below), I will start running OPEN DRAFTS. These will occur about once a week for the next few weeks. I will have about 50-75 players in each list. Managers will be able to pick up to thirty (30) each draft. Remember, just because you pick 30 doesn't mean you will get anywhere near 30 after everyone chimes in!  All drafted players will be assigned to their respective manager. If any team does not have 25 players by the time Opening Day rolls around, I will assign random players to those teams to fill things out.

For the record, I will be using OOTP as the simulation environment to run the games.

Attention *ALL* readers: If you did not play in the 2014 game/breaks, this is your chance to get in on the action!

I will be contacting new managers within 48 hours after sign-up to verify email addresses and answer any questions you may have as a new manager. Most of those questions can be answered by visiting the 2015 PackADaily Info page at the top of this site.

The top two questions are:

  1. How much does this cost? Nothing. It is free to play along! Several folks donate money or packs during the season, but that is not required.
  2. How does this work? In a nutshell: I open packs of cards every day during the regular baseball season. If I draw a player you have on your roster, you get that player's cards. ALL of that player's cards drawn during the season. As the season goes on, any "undrafted" players drawn are put into a draft. If you win that player, you get ALL that player's cards for the whole season. In addition to the cards, I also host a fantasy baseball league in which you participate automatically, using your drafted players. Win the fantasy Tribecards Championship and you get bonus items in addition to the cards!

New Recruits Sign up here:

CUT-OFF for signing up is 9pm, Thursday March 5, 2015.

If you have questions before signing up, please respond to this post or drop me an email.

No comments:

Post a Comment