Ballot Update

I worked on that crazy excel file today. Yeah, it is super tedious. Previously my template for the season on had one conference, the ACC. Well, clearly if I want rank all the teams I need to be able to have all the DI-A teams in my spreadsheet. Now, I thought it was going to be pretty smooth in copying the ACC template a few times, and wham, there is the whole thing. Turns out to be a little more intricate than that.

First I had to copy the ACC template. This was pretty easy, just copy and rename. Then I had to change the names of the teams on the individual conference sheets, still not too bad. Then came the crazy part. I have a sheet that is referenced called 'Opponents'. This sheet references all the team's averages to compare with the team's they are playing... aka the opponents, hints the name. Well, this sheet references all the conference sheets and that becomes complicated making sure all the references have the right cell and number and sheet name referenced. I know everyone is completely lost, and I can't even remember what I was saying. But it is tedious. I promise.

Alright, I have not forgot that I haven't even shared with the 3 of you the results from last year's ACC games who was the best in the ACC. So someone remind me to do that tomorrow. I have a lot more work to do. I have mark the bye weeks for all the teams and continue adding all the conferences.

It will be done, I am not worried... yet.