Ottoneu Points Standings Dashboard

dashboard
standings
tools
Tags: #<Tag:0x00007f82a52374c0> #<Tag:0x00007f82a5237380> #<Tag:0x00007f82a5237240>

#1

The Ottoneu Standings Dashboard has been updated for both FanGraph Points and SABR (New!).

FGPTS

link

SABR

link

Just plug in your league ID (located in URL of your league home page) into cell B1 and the Dashboard will update your league standings in real time to give you more depth (and projections) than what are found on your league site.

Hat tip to @eamuscatuli for his help building this tool.

More about the Dashboard here.


#2

Hey @eamuscatuli - these are fantastic. However, it looks like the pacing totals aren’t working properly in the SABR sheet, so the nice ‘Projected Champion’ graph isn’t plotting either.


#3

For those owners in tight league races, don’t forget about the availability of the dashboard, which can help you determine just how aggressive you need to be heading into the trade deadline.


#4

Is this broken?


#5

Yes, this has not been updated since a new “CHG” column was added to the standings, though I think @eamuscatuli has released a multi-league version: Multi League FGPts Standings Dashboard


#6

That one also seems to be broken.


#7

@avs18fan @LuckyStrikes

Easy fix is just to insert a new column in the sheet to account for the addition of the ‘CHG’ column to the standings page. In the sheet, click the ‘V’ column (just a black separator) and ‘Insert 1 Left’. Everything should auto-populate after that. Then remove the black fill on column V, as this is now ‘P/IP’. I think I fixed all the formulas for some of the calculations, but no guarantees. :smile:

Updated Ottoneu Points League


#8

It looks like the latest site updates have broken the dashboard again. :frowning:


#9

@dalewilson13

Should be good to go with this version. Needed to update the location for the importhtml function in cell A19 to match the new format on the site.

Ottoneu Points League Standings Dashboard (2018)5.10


#10

Yes. Works perfectly. Thanks for the update! Suggestion for future versions (I always change it on my version) - a column chart displays the Pace graph much better than the smoothed curve.

Thanks again.

Dale