Pages

Sunday, June 12, 2022

2022 NFL Helmet Schedule Spreadsheet

 As I explained last year, I finally automated this spreadsheet so I was able to create the 2022 NFL Helmet Schedule in less than a minute! All 32 teams, all 18 weeks of the season (now 17 games plus one bye week), all in one spreadsheet:


A job that used to take hour by moving helmets manually is now so easy to do. Yes, that's why I love the power of macros and automation. See how fast the sheet can be created by watching this clip:


On previous versions of the sheet I divided out the two conferences on separate sheets: NFC and AFC. This year, I’ve put all the teams into one sheet. However, there is a new filter option where you can filter by NFC or AFC or even by division: AFC North, AFC South, etc.

Download the 2022 NFL Helmet Schedule Spreadsheet here


Watch the video below to see how the filter works. I also so a tip in Excel how to select multiple objects at once with the mouse. And I walk through the populate helmets macro code as well. Lots of good stuff here!



As you can see, the NFL helmet schedule is printable too. You can save the spreadsheet as a PDF file or print it out and pin it up in your cubicle at work. If you do, please email or tweet me a picture of it hanging up - I'd love to see it!

Please note, an email is required to download it. I do this so you will be automatically updated you if changes or additions are made and will update you when the next year’s schedule is ready. I do not use your email for anything else.

As always, I welcome any comments or suggestions about how to fix or improve the sheet! How can I improve this football spreadsheet into something you’ll use all the time during pro-football season? What future features would you like to see?

PS. I will not be rooting for the dumpster fire known as the Cleveland Browns this season so if any fanbases want to recruit, now's your chance to pitch me on your favorite team!

2 comments:

  1. Are you planning on updating the 2022 NCAA Helmet schedule as well?

    ReplyDelete
    Replies
    1. Probably not, at least no until I can get a macro to update it automatically, it just takes too long otherwise.

      Delete

I'd love to hear from you!
-Nick