NHL Excel Template
NHL 2020-2021 Excel Template to track Schedules, Playoffs, Standings, and much more! Includes History and All-Time Award Winners!
Are you getting ready for the new season of NHL? The 2020-2021 National Hockey League will start on Jan 13, 2021, and it will last for another five months until the last match of the fixture 8th of May.
Finally, the tournament will be played for the 103rd time and 31 teams will compete with each other for the championship. Teams are going to compete in a 56-game in the season.
NHL Excel Template Features:
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:
Navigates the NHL Workbook to make switching between other worksheets so moving from sheet to sheet will be easier.
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.
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.
Once you input the score details, the table in the “standings” section will automatically rank the teams according to the National Hockey League Standards. The successor team will be moved to the next level.
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.
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.
This section shows you the seven round of NHL from Round 1 to Round 7.
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.
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 Features Summary:
- Easy to fill 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.