Spotting Boards Masterclass

Spotting Boards 100 - Understand what’s possible (FREE)
Spotting Boards 101 - How spreadsheets work: formulas & functions (FREE)
Spotting Boards 102 - How to select and scrape data from the web
Spotting Boards 103 - How to make the data you scrape dynamic
Spotting Boards 104 - Creating dropdown menus to change multiple tables at once
BUILDING AN NCAA WBB SPOTTING BOARD STEP-BY-STEP
Spotting Boards 105 - How to manipulate data on stats.ncaa.org
Spotting Boards 106 - Data cleanup for game schedules on stats.ncaa.org
Spotting Boards 107 - Calculating situational statistics from scraped data
Spotting Boards 108 - Building dynamic player boxes on spotting boards
Spotting Boards 109 - Adding a scraped schedule onto your boards
Spotting Boards 110 - Adding scraped stat rankings to your boards (and color coding!)
Spotting Boards 111 - Adding a player’s statistical ranking in their conference
Spotting Boards 112 - How to combine functions and nest formulas without AI
Spotting Boards 113 - How to automatically load a team’s top players to your board
Spotting Boards 114 - Adding season highs or career highs to your board
Spotting Boards 115 - Adding the previous game’s stats to a player’s line
Spotting Boards 116 - How to pull a player’s bio off a team’s website
BUILDING AN NCAA FOOTBALL SPOTTING BOARD STEP-BY-STEP
Spotting Boards 117 - Intro to creating an NCAA Football offensive board
Spotting Boards 118 - Continue laying the foundation for the offense
Spotting Boards 119 - Data cleanup using the SUBSTITUTE function
Spotting Boards 120 - Placing a phonetic offensive-only roster on your board
Spotting Boards 121 - How to autoload the starting and backup QBs
Spotting Boards 122 - Autoloading the Top 10 o-lineman in numerical order
Spotting Boards 123 - Grouping the skilled position players together numerically
Spotting Boards 124 - Building a team schedule and total offense table (Part 1)
Spotting Boards 125 - Building a team schedule and total offense table (Part 2)
Spotting Boards 126 - Integrating a team dropdown menu onto the board
Spotting Boards 127 - Listing team offensive stats and rankings on the board
Spotting Boards 128 - Creating your own analytics
BUILDING AN NCAA MBB SPOTTING BOARD STEP-BY-STEP
Spotting Boards 129 - What’s possible for D1, D2 and D3 men’s basketball
Spotting Boards 130 - Using IMPORTXML and FILTER to pinpoint your needs
Spotting Boards 131 - Using IMPORTHTML to load all tables from filtered URLs
Spotting Boards 132 - Automating game-by-game team stats to tell stories
Spotting Boards 133 - Creating an enormous 364-team dropdown menu
Spotting Boards 134 - Creating a career-high generator (and a backup data source)
Spotting Boards 135 - Pulling a player’s career stats and previous season stats
More to come…