Displaying posts tagged with

“Excel”

Update to the Free 2009 NFL Spread Sheet Calculator

Ok I have had a little to much fun with this spread sheet. I have been playing with “=IF”, “Nested IF” and “=VLookup” formulas for work and decided to put it some more interesting use. So I took the 2009 NFL Excel Spread Sheet and had a little fun. Since I am a bit proud of what I have done, I am uploading it and it is still a free download.

As of this post the two files have been downloaded about 175 times. Didn’t really expect that, as I have a pretty obscure website. So I will see about converting it to the Office 97-2003 format…

  • Share/Bookmark

Excel: Data Validation

ExcelIcon Over the last couple of weeks at school we have been learning a lot about Excel. I am pretty good at formulas and different uses of excel. My NFL spread sheet is just one example of how to use simple formulas, but I have never used some of the more advanced formulas like “Data Validation”. Data Validation has several really excellent uses and I’ll show just the list function.

Note: See below to download the update file.

  • Share/Bookmark

2009 NFL Excel Spreadsheet (Free)

imageUpdate: I have done a lot of work on this spread sheet since this post. Please read this post for more info.

Every year my family has a friendly contest of picking the weekly NFL games (Go Colts)… I have searched for a program to do this, but it always costs money and I am cheap. ;-)

So last year I created a basic spreadsheet to help calculate wins and this year I am making it publicly available here.Yes that means it’s free, but if you want to donate money feel free too ($1?).

  • Share/Bookmark