Tag Archives: Patreon

Standings Tracker

I’ve created a standings tracker for Google Sheets for your teams.  You can use this to automate the power rankings all into a one stop shop for your team standings.  

The importhtml formula is  =importhtml(“https://www51.myfantasyleague.com/2020/options?L=?????&O=101“,”table”,2).  Your 5 digit league code goes where the ?s are in the formula.  

You vlookup formula is  =vlookup($B3,**Sheet name**’!$A:$P,2+C$1,false)