skip to Main Content

NHL 2019/20 Excel Template

4.0 (4 reviews)

NHL 2019-2020 Excel Template to track Schedules, Playoffs, Standings and much more! Includes History and All-Time Award Winners!

Buy Modifiable Version

TEMPLATE DETAILS
License: Personal Use
Works on: Windows / Mac (Min. Excel 2007)

Watch Video:
PRODUCT DESCRIPTION

Are you getting ready for the new season of NHL? The 2019-2020 National Hockey League will start on Oct 2, 2019 and it will last for another six months until the last match of the fixture 4th of April. Because of Stanley Cup Playoffs begin a few days after it is expected to end on June 2020. The playoffs held in late May and early June.

Finally, the tournament will be played for the 102nd time and 31 teams will compete with each other for the championship. Teams are going to compete in an 82-game regular season.

NHL 2019-2020 Excel Template Features:

2019-2020 National Hockey League Template will allow you to track the details of Daily Schedules of the matches, Standings, Cities and Venues info and (once you enter the match scores) NHL rankings of each group.

The template consists of 8 different sections:

NHL-Excel-Template-Someka_S01Dashboard:

Navigates the NHL Workbook to make switching between other worksheets so moving from sheet to sheet will be easier.

NHL Schedule:

Contains the match details like who is teams, dates and arenas they are playing. Basically, you will enter your scores for each team on the schedule and you can go to the necessary monthly by just clicking on the month buttons on the top.

NHL-Schedule-Excel-Template-Someka-S02

If the teams are tied, put down the scores of overtime in the Overtime Scores column. Within this period, if there are no shots in the overtime, choose the winner of shootouts by selecting from the drop-down menu.

The arrows on the left side takes you to the top of the page once you press it.

Playoffs:

Once you input the score details, the table in the “standings” section will automatically rank the teams according to the 2019-2020 National Hockey League Standards. The successor team will be moved to the next level.

Standings:

You will find 3 standings in this sections which are Division Standings, Conference Standings and Wild Card.

In these sheet tabs, teams have been divided according to their division and conference. Once you input the scores properly in previous sections, the tables in this section will dynamically rank and order them.

NHL-Standings-Excel_Template-Someka-S04

The columns in the table stand for the amount of Game Played, Win, Lose, Overtime Lose, Points, ROW (Regulation or Overtime Wins), Goals For, Goals Against and the difference.

2019 Draft:

This section shows you the seven round of NHL from Round 1 to Round 7.

Team Info:

This section shows the chosen team’s general information and Championships. You can click on the team cell where yellow arrow points and choose the team from the drop-down menu to display the required season’s properties.

History:

Gives you information about the past National Hockey League History in terms of Competitors, All-Star and All-Rookie Team, Points, Goals, Assists, Plus-Minus, GAA (Goals Against Average), Save Percentage, Wins and Shootouts.

All-Time Award Winners:

Finally you can check all the Trophy and Award owners of the chosen year.

NHL_Excel_Template_Someka_S06

NHL Excel Template Features Summary:

  • Easy to fill 2019 NHL Spreadsheet
  • NHL Schedule, Playoff, Standings, Team Info
  • All Time Award Winners and History
  • Full Print Ready
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2007 and later versions
  • Does not include any VBA macros

**This NHL Excel Template compiles the information which is officially available at nhl.com. You can check all the national hockey league season news, standings, schedule & playoffs there. Someka is not associated with The National Hockey League.

This NHL Schedule Excel Template is ready-to-use. If you need customization on your reports or need more complex templates, please refer to our custom services.

USER REVIEWS

4 reviews for NHL 2019/20 Excel Template

  1. Miles

    The standings does not recognizes OT with a shootout winner right. I wrote 0-0 in the OT columns and selected the Shootout winner, but the defeated team does not get the 1 point they deserved for getting in OT. The same if a winner is determined in OT.

    • Someka

      Hello Miles!

      Thank you for the wonderful review and taking your time to send us feedback on it. We just wanted to let you know that the fault has just fixed by our developers with your contribution and it is very much appreciated.

  2. Jens Demuynck

    Please help, once i put some results the standings tab doesn’t automatically update?

    • Someka

      Hello Jens!

      Thanks for reaching out! Our developers has already contacted you regarding the issue you ran into. If you have more feedback/concerns about the template please feel free to contact us!

  3. Nic

    Love this template, it’s really good and easy to use. I’m trying to build something myself that’s similar to this but struggling to get a steer on how to do the wildcards. Any advice would be greatly appreciated.

    • Someka

      Hello Nic,

      Thank you for your feedback! Appreciated!

      You can contact our developers and ask all the questions you may have. Just submit your query here: Custom Services

  4. Marmanu

    Please help. I have not been able to open the file location.
    PS. I do not want to ruin your ratings.

    • Someka

      Hello Marmanu,

      As far as we understand, you can not able to use the template after you download it, right? Did you unzip your file before starting to use it? Because otherwise it will be opened in a readable format and you can not enable the editing option.

      Hope that helps!

Leave a customer review

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