Projects
Fantasy Football Consensus Rater
Jul 2023 – Aug 2025
2025 Project:
- Updated and improved a previous project to create fantasy football rankings based upon average critic consensus. I converted the project, based in Python, to be based in MS Excel, featuring Power Query, Pivot Tables, and search functions like VLOOKUP.
- Calculated VORP, Value Over Replacement Player, to enhance draft strategy and reveal critically overrated and underrated players.
- Utilized AI to clean, filter, and prepare data for entry into Excel.
2023 Project:
- Designed Python program to analyze multiple Fantasy Football Player Rankings, calculating the average ranking of each player.
For example, in 2024, here are the top 5 players in the NFL and their average rankings, according to Yahoo, ESPN, NFL.com, The Athletic, USA Today, and Fantasy Pros:
Christian McCaffrey: 1.0
Tyreek Hill: 2.83
CeeDee Lamb: 3.33
Ja’Marr Chase: 4.67
Breece Hall: 5.5
Independent Study – Calculating fWAR for Pitchers
Apr 2024 – Sep 2024
– Independent Study class guided by a Mathematics professor
– Studied how to calculate both fWAR and bWAR, advanced baseball statistics measuring the value of a player, for pitchers.
– Designed a tool that allows users to customize inputs and calculate WAR themselves.
– Created demonstration videos and slideshows, featuring walkthroughs and detailed explanations.