Pages

Friday, May 12, 2023

2023 NFL Helmet Schedule Spreadsheet

The 2023 NFL schedule was released yesterday and since I used my Excel skills to automate the creation of this spreadsheet I was able to create the 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. I wrote the macro myself but nowadays you could probably just ask ChatGPT to write the macro for you.

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 2023 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?

1 comment:

  1. Excel | Gyansetu is an invaluable resource for mastering Excel's intricate features. The courses offered here are both comprehensive and easy to follow, making it an excellent choice for learners of all levels. Whether you're a beginner looking to create basic spreadsheets or an advanced user seeking to harness complex data analysis tools, Gyansetu's Excel courses provide the knowledge and skills you need to excel in your professional and personal endeavors.
    For more info:- https://www.gyansetu.in/blogs/best-10-uses-of-ms-excel-in-daily-life/

    ReplyDelete

I'd love to hear from you!
-Nick