Head to Head: Can ChatGPT Replicate Rob’s Inspired Solution to a Power Query Challenge?

In this episode, Rob Collie and Justin Mannhardt step onto the data gridiron to test if AI can tackle the complexities of fantasy football data. Rob starts with a Power Query puzzle, full of messy stats, player names, and tricky injury codes—solving it manually in over 30 steps. But can ChatGPT, with Justin’s guidance, run the same play and simplify fantasy football data management?

Justin and ChatGPT take their shot at transforming the chaos into organized data. While ChatGPT makes some impressive moves, there are a few fumbles that leave us wondering—can AI truly handle the ever-changing landscape of fantasy football stats?

Want to know how this battle played out? Tune in to find out if AI has what it takes to streamline your fantasy football data or if human instincts still win the day.

Here is the companion Blog Post – Can AI Write an M Script When it Requires Inspiration? Rob Collie Squares Off Versus ChatGPT

See the code:

Rob’s M Code

Justin/Chat GPT’s M Code

Excel Roster Source

Justin/Chat GPT Final PBI

Rob’s Final PBI

Rob’s Roster Analyzer

Justin’s Chat GPT Roster Analyzer

Justin providing corrections to ChatGPT’s M code for cleaning and transforming fantasy football data.

Injury Correction