NHL 2019/20 Excel Template
NHL 2019-2020 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 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:
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 2019-2020 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 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.