Football Fun in Excel

This Sunday is Super Bowl XLIX – the last one that will start with "XL".  Next year, it will be Super Bowl L – that doesn’t exactly roll off the tongue!

In 2011, I showed how you can use the ROMAN function in Excel, to change a number into a Roman numeral. That year, they were playing for the 45th time, which was XLV.

=ROMAN(A2)

FootballRoman

Other Football Functions

There are other Excel functions that sound like they could be used in a football game. Here are a few, and I’m sure you can think of others:

  • CONVERT
  • RECEIVE
  • YIELD
  • SUBSTITUTE
  • ISREF

Okay, that last one was a bit of a stretch, but I’ll allow it. What functions did I miss?

Close Football Games

While you wait for the game to start, you can look back at some historic games, with the data that Kevin Lehrbass compiled in an Excel file. You can download Kevin’s workbook, which contains enough data to entertain you for a couple of days, while you try to decide which was the closest game.

Did Kevin think of all the factors that make a football game close, and exciting to watch?

You can even select a couple of Super Bowls, and compare them. Have fun, and enjoy Sunday’s game!

superbowl

_____________________

You may also like...

11 Responses

  1. Tim Mayes says:

    Deb,

    I can’t believe that you missed Intercept. :-)

    Actually, this is kind of a silly post, but very useful. It encourages one to scan through all of the functions and reminds you of the ones you have forgotten about. Good post!

  2. Terry says:

    How about LOOKUP?

  3. Rudra says:

    What about Areas, Match,round etc.?

  4. Elias says:

    What about Choose?

    A1=Choose(2,”Run-Win”,”Pass-Lose”)

    Regards

  5. Randy emailed me with these excellent suggestions — thanks Randy!

    Football function: Replace
    Football function: Time (as in, call time-out)
    Football function: INT (as in, intercept)
    Football function: INTERCEPT
    Football function: Replace

  6. John says:

    Call, Second, Match, Average, Intercept, substitute, space

Leave a Reply to John Cancel reply

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