Note: All Excel files are Excel 2016.

Pittsburgh_Penguins_2018_19.xlsm (12.8MB)

This file provides data entry capabilities for the 2018-19 season. Worksheet "Data Entry Instructions" details the steps to follow to enter stats on the input forms. Also, stats can be directly imported from the website "Hockey-Reference.com" into the appropiate Excel tables. The steps are self explanatory; just click on the paste button to run the Excel Power Query. (Other websites could be used with different VBA coding.)

Stats2018_19.xlsm (4.6MB)

This file provides interactive dashboards for various opposing team statistics for the 2018-19 season (up to 3/31/19). These include team and individual scoring and penalty summaries as well as opposing team statistics by Conference and Division. The summaries are explained on the "Introduction".

Stats2017_18.xlsm (4.6MB)

This file is identical to Stats2018_19.xlsm except it has stats for the entire 2017_18 season.