Posted by Jtpsops on 6/30/2020 7:23:00 PM (view original):
Out of curiosity, why does the google sheet say it’s “auto-updating” if it needs to be done manually?

For context, the sheet is set to update automatically at certain times but, since it's hosted locally on my laptop, my laptop has to be on and connected to the internet at that time in order for it to work. That hasn't been the case lately. I should just host it online somewhere instead but I'm lazy

Ok, standings should be back to updating regularly now. The Per 162G tab will look off for another day or so while I gather the "Standings at game X" from the other commissioners.

After the first 162 games, I was in 26th place. After the second 162 games, I was in 26th place. As of this moment, two days before the halfway point, I am in 26th place.

Consistency For The Fringe!!

5th schwarze. Puts me in 24th right before the break.

Just an FYI... the projected playoff team count can't be right. By my calculations, there are 8 playoff teams per league and there are 6 themes x 4 leagues / theme = 24 leagues so there should be 24 x 8 = 192 playoff teams. However, the spreadsheet totals only 150 playoff teams.

As an example, I'm listed as having 5 projected playoff teams, but at this point in time I should have 6 projected playoff teams (4 division leaders and 2 WC)

Posted by justinlee_24 on 7/6/2020 9:04:00 PM (view original):
Just an FYI... the projected playoff team count can't be right. By my calculations, there are 8 playoff teams per league and there are 6 themes x 4 leagues / theme = 24 leagues so there should be 24 x 8 = 192 playoff teams. However, the spreadsheet totals only 150 playoff teams.

As an example, I'm listed as having 5 projected playoff teams, but at this point in time I should have 6 projected playoff teams (4 division leaders and 2 WC)

I’m leading 4 divisions and it shows 3 for my projection. Maybe ozomatli knows something about one of my teams...

Is there a way to track cycle standings? I'm curious to know how many 4-2's and 3-3's I've had.

Posted by besterateam on 7/6/2020 9:54:00 PM (view original):

Posted by justinlee_24 on 7/6/2020 9:04:00 PM (view original):
Just an FYI... the projected playoff team count can't be right. By my calculations, there are 8 playoff teams per league and there are 6 themes x 4 leagues / theme = 24 leagues so there should be 24 x 8 = 192 playoff teams. However, the spreadsheet totals only 150 playoff teams.

As an example, I'm listed as having 5 projected playoff teams, but at this point in time I should have 6 projected playoff teams (4 division leaders and 2 WC)

I’m leading 4 divisions and it shows 3 for my projection. Maybe ozomatli knows something about one of my teams...

I currently hold 3 playoff spots, with sizeable leads. But my projection is 2.

Posted by Jtpsops on 7/7/2020 12:31:00 PM (view original):

Posted by besterateam on 7/6/2020 9:54:00 PM (view original):

Posted by justinlee_24 on 7/6/2020 9:04:00 PM (view original):
Just an FYI... the projected playoff team count can't be right. By my calculations, there are 8 playoff teams per league and there are 6 themes x 4 leagues / theme = 24 leagues so there should be 24 x 8 = 192 playoff teams. However, the spreadsheet totals only 150 playoff teams.

As an example, I'm listed as having 5 projected playoff teams, but at this point in time I should have 6 projected playoff teams (4 division leaders and 2 WC)

I’m leading 4 divisions and it shows 3 for my projection. Maybe ozomatli knows something about one of my teams...

I currently hold 3 playoff spots, with sizeable leads. But my projection is 2.

Obviously, the algorithm knows who it's dealing with....

Touche

Posted by odalisgagne on 7/7/2020 12:34:00 PM (view original):

Posted by Jtpsops on 7/7/2020 12:31:00 PM (view original):

Posted by besterateam on 7/6/2020 9:54:00 PM (view original):

Posted by justinlee_24 on 7/6/2020 9:04:00 PM (view original):
Just an FYI... the projected playoff team count can't be right. By my calculations, there are 8 playoff teams per league and there are 6 themes x 4 leagues / theme = 24 leagues so there should be 24 x 8 = 192 playoff teams. However, the spreadsheet totals only 150 playoff teams.

As an example, I'm listed as having 5 projected playoff teams, but at this point in time I should have 6 projected playoff teams (4 division leaders and 2 WC)

I’m leading 4 divisions and it shows 3 for my projection. Maybe ozomatli knows something about one of my teams...

I currently hold 3 playoff spots, with sizeable leads. But my projection is 2.

Obviously, the algorithm knows who it's dealing with....

LOL...but I don't think that's it.

Try steelerfan19... the current #96 in the WISC rankings. All of his teams are bad enough that there is no way he has a playoff team in that lot (and I checked his leagues just to be sure). Somehow, ozomatli projects he'll have a playoff team...

The formula on Input tab for Wildcard is looking at the wrong cell at the beginning of the IF statement, should be looking for column Y (to filter out division leaders) but it's looking at column V (win total). The range where it looks at the 12 teams in the AL or NL is also not right in a lot of cases, it's jumping down 4 cells for each new division, should be staying the same for all twelve teams on that side of the league.

Hopefully that will fix it, ozomatli I am happy to volunteer to fix it if you grant me temporary edit privileges.

Posted by besterateam on 7/6/2020 9:54:00 PM (view original):

Posted by justinlee_24 on 7/6/2020 9:04:00 PM (view original):
Just an FYI... the projected playoff team count can't be right. By my calculations, there are 8 playoff teams per league and there are 6 themes x 4 leagues / theme = 24 leagues so there should be 24 x 8 = 192 playoff teams. However, the spreadsheet totals only 150 playoff teams.

As an example, I'm listed as having 5 projected playoff teams, but at this point in time I should have 6 projected playoff teams (4 division leaders and 2 WC)

I’m leading 4 divisions and it shows 3 for my projection. Maybe ozomatli knows something about one of my teams...

I've done this by simply copying and pasting the entire season's game scores (for all 6 leagues) into a spreadsheet. And manipulating it from there.

Death by a thousand cuts. Losing 1-2 spots in the standings each cycle now.

Posted by schwarze on 7/7/2020 3:09:00 PM (view original):

Posted by besterateam on 7/6/2020 9:54:00 PM (view original):

Posted by justinlee_24 on 7/6/2020 9:04:00 PM (view original):
Just an FYI... the projected playoff team count can't be right. By my calculations, there are 8 playoff teams per league and there are 6 themes x 4 leagues / theme = 24 leagues so there should be 24 x 8 = 192 playoff teams. However, the spreadsheet totals only 150 playoff teams.

As an example, I'm listed as having 5 projected playoff teams, but at this point in time I should have 6 projected playoff teams (4 division leaders and 2 WC)

I’m leading 4 divisions and it shows 3 for my projection. Maybe ozomatli knows something about one of my teams...

I've done this by simply copying and pasting the entire season's game scores (for all 6 leagues) into a spreadsheet. And manipulating it from there.

Yep — noticed this with my own teams as well. I've temporarily removed the column and will fix it ASAP.