Blindsides vs. Lethbridge Golden Seals BlackDevilHawks vs. Broadway The Ales vs. Royal Oak Fearsome Beavers Injured Reserve vs. asdfjkl; KC Reserves vs. Lost Cause Whalers vs. Tulane Flyers Newmarket Hurricanes vs. Toronto Rocket Iowa Crop Dusters vs. KC Reserves
Duane, tell me how you managed to get the standings to work in Google Sheets. I follow all the way to the division standings on the left... but how the hell do you get the league standings on the right to work? I don't see a formula anywhere...
Blindsides (-1.5) vs. Lethbridge Golden Seals 4.0 BlackDevilHawks 1.5 vs. Broadway 2.5 The Ales 2.0 vs. Royal Oak Fearsome Beavers 2.5 Injured Reserve 0.5 vs. asdfjkl; 2.5 KC Reserves 2.0 vs. Lost Cause (-1.0) Whalers 3.0 vs. Tulane Flyers 1.0 Newmarket Hurricanes 1.5 vs. Toronto Rocket 2.0 Iowa Crop Dusters 0.5 vs. KC Reserves 2.0
I'm still focused on baseball and have been neglecting my Crop Dusters GM duties. My squad knows I'll be fully committed to our championship run as soon as the Cubs complete this epic World Series comeback.
Duane, tell me how you managed to get the standings to work in Google Sheets. I follow all the way to the division standings on the left... but how the hell do you get the league standings on the right to work? I don't see a formula anywhere...
For the sorting of the left side standings click on the first place team in each division to see the formula
To see the sorting formula for the right side standing click on I:106 -- you'll see that the sort() function takes vargs (variable argument list). So first I sort by hidden values in Column A (so that all of the division leaders are on top) and then by PTS and then (as a rough tie-breaker) by fewest GP.
Duane, tell me how you managed to get the standings to work in Google Sheets. I follow all the way to the division standings on the left... but how the hell do you get the league standings on the right to work? I don't see a formula anywhere...
For the sorting of the left side standings click on the first place team in each division to see the formula
To see the sorting formula for the right side standing click on I:106 -- you'll see that the sort() function takes vargs (variable argument list). So first I sort by hidden values in Column A (so that all of the division leaders are on top) and then by PTS and then (as a rough tie-breaker) by fewest GP.
Just FYI, I went through and added some conditional formatting to the league/playoff standings, so the colours will always be right now. We don't need that colourize add on or whatever you had since I can't even do anything with it anyways. :)
