Hey there, welcome to the very first entry of [...]

How accurate are SOGs allowed by position? If you've [...]

In Part 1, we went over our Google Sheet template and what each tab was for, built our player selection tool and set up our sheet to pull in the game log of any selected player. In Part 2, we’ll take the data from the game log we now have access to and build out our Player SOG Consistency Chart.

In this series, we will be building a Google Sheet that fetches NHL players’ shot data, which updates based on the player the user selects. If you don’t care about this specific metric or even hockey in general, don’t worry – my goal is that you take away some key concepts so you can create your dream cheat sheet.