Using Spreadsheets For Fantasy Baseball Mock Draft

Be Sociable, Share!

grannyblogger at computerI’ve probably mentioned my mother, shown in the photo at left, and her affection for all things computer related (maybe that’s where I get it from). Anyway, this post talks about how she used spreadsheets for my father’s fantasy baseball hobby. Although mom is now in her late eighties, she still blogs and creates digital information products. I hope I’m half as productive in my more senior years.

[Guest Post]
When fantasy sports leagues first became popular several years ago, my husband needed help to keep track of baseball player statistics for the fantasy baseball mock draft in which he was involved.

At that time I was using a Lotus 123 spreadsheet program but later was introduced to the Excel program which I found much easier to use. As most people now know, Excel is part of the Microsoft Office suite of programs. When my husband and I used the program, it was much simpler than it is today.

The purpose of these first spreadsheets, as I mentioned earlier, was to keep track of my husband’s baseball fantasy league player statistics.

The drafts related to these fantasy leagues are conducted in a similar fashion to actual big league drafts. In a fantasy league, however, all the active players in a real league (in our case it was the American Division of Major League Baseball) are eligible for the draft. Because of this format, we had to keep our own stats for each of the players that my husband Bill had drafted for his fantasy team which consisted of many players from several different teams of an actual Major League Division.

If all this sounds very confusing, it certainly was to me at the time. Eventually, after laying it all out on paper, we came up with a solution – use the Excel spreadsheet to enter each player’s statistics with formulas resulting in averages for the players and totals for Bill’s very own team.

I remember Bill being so excited when he was invited to select a team of his own in the “Rotisserie League” that several of his friends had formed. The night before the draft he could hardly sleep and the next day, armed with his list of players, he set out for the venue where the draft was to take place. Those types of meetings can last several hours and involve much discussion.

From the day of the draft onward, we became very busy (even though we were retired) with keeping his team stats up to date so that the monetary value of his team’s players was always available. Whenever another owner would approach either one of us concerning a trade or negotiation of any kind, we were prepared to talk.

Today, there are countless numbers of these fantasy leagues on the internet and among friends and families in almost every sport you could mention.

My name is Eleanor McCallum. I am in my mid eighties and have been enjoying the internet and working on line for several years. My past experience is in the Accounting and Bookkeeping field. However my interests today are affiliate marketing, blogging and creating ebooks or guides. I have designed several websites using WordPress with its unique use of plugins and widgets. If you would like a website set up for you please get in touch with me by visiting my site.

Visit my site at for more information on any of these subjects.

Article Source:
Article Source:

P.S. I’d love it if you could check out mom’s site.

Happy Computing,


Be Sociable, Share!
This entry was posted in Computer Projects. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

CommentLuv badge