Thanks. I'll be on a flight this weekend and am hopeful I'll be able to knock out the script so that it happens automatically from now on

My teams have been doing well. I'm due for a 1-5.

Posted by ozomatli on 1/22/2020 3:39:00 PM (view original):
Thanks. I'll be on a flight this weekend and am hopeful I'll be able to knock out the script so that it happens automatically from now on

FYI -- looking good to have this done. Only constraint will be that I'm going to be having it run on my local machine rather than on a VM (so that I don't need to pay to host it each month) so, if my laptop is off during one of the scheduled times I want it to run (i.e. after the games sim), it'll skip that cycle and there won't be and update until the next cycle (unless I run it manually, which I probably won't do). Regardless, this will be way better than the manual / infrequent process right now, and this will probably happen infrequently since I'm usually with my laptop at those times, especially the PM and PM2 sets.

Thanks, ozo. Appreciate the effort!

In general (only a few exceptions) the rankings from round 1 correlate (roughly) to the rankings in round 2 (thus far). I wish I didn't screw up my variable cap team in round 1.... I'm still not sure why I didn't score more runs in that league in all honesty.

I would disagree with that -- the correlation is .406 right now. Not terrible but not great. For context, last year it was .515

There is clearly a correlation between round 1 & round 2 rankings minus a few exceptions, which is exactly what I said. The teams that rank 12-22 currently in round 2 finished 15-24 in round 1---- minus 2 teams that do not fit that description. I'd say that is a rough correlation,is it not??? Which is what I stated.

milest, you are a prickly dude lol...

Anyway, finished the script today. It will run 3x per day. Just need to reformat the sheet itself tomorrow and then we'll be good to go with auto updates

Ok, test run with the script worked so I'm going to leave it on autopilot for the PM2 and AM sets. Will check in in the morning to see how it does. I still need to update the logic for the standings page so that the owners get auto-ranked correctly each cycle, but the data import is working

0-6 am followed by 6-0 pm. That’s insane.

Very happy to have the second most Round 2 wins. Very unhappy to have only 2 playoff teams (my other four teams are 2, 4, 4, 4 games out)

I only have the one team in sure playoff position and one other with a 4-game lead. Two teams are within a game of a spot, one on the good side and one on the down side. And two have basically no shot at all. I'd be happy to wind up with 3, but 2 seems fairly likely too.

Going for the efficiency award...if the season ended now, I'd have 2 playoff teams...while my other 4 teams are a combined 88 games below .500.

Hard to see myself winning this year when I messed up 4 teams. Not my best. Though, to be fair, I was distracted at the time

Oops. That last post was incorrect. Looks at some wrong numbers