have a column called Playoff Wins (keep for every team) and pull the win normally. then in another excel column called Playoff Points multiply playoff win column by 2. then for every team if(conference standing = top 2, then +8 to playoff points) then for every team if(total playoff points = 32, then +20 to total points), , then if(all 5 teams by owner have playoff wins >0, +20 to playoff points). then add all to Total Points Column

are you able to pull conference standings 1-12? if not, then the +8 for first round bye may have to be entered manually. but the rest can be modeled in excel with if(x,then y,else z) statements

Posted by pexetera on 4/8/2021 10:58:00 AM (view original):
have a column called Playoff Wins (keep for every team) and pull the win normally. then in another excel column called Playoff Points multiply playoff win column by 2. then for every team if(conference standing = top 2, then +8 to playoff points) then for every team if(total playoff points = 32, then +20 to total points), , then if(all 5 teams by owner have playoff wins >0, +20 to playoff points). then add all to Total Points Column

are you able to pull conference standings 1-12? if not, then the +8 for first round bye may have to be entered manually. but the rest can be modeled in excel with if(x,then y,else x) statements

For your latter sentence, yes I am planning to do that. It is pretty straightforward. It is already how I calculate playoff teams and I have a method elsewhere that I already put together for counting byes. All that is pretty simple for me.

My screen scraper only scrapes the league pages. Scraping the actual results pages is a much larger undertaking and involves some step through logic that would probably break the request limit that Google sets on Sheets. I did something similar to this in Excel in season 1 but accessibility was a problem for most of the people I shared it with, which is why I went to Sheets.

Ultimately, my plan is to have a score column that contain all the logic I can script within the limits WiS and Google set for me. And worse case scenario I manually populate the playoff wins and championships column for calc'ing the rest of the score.

gotcha, makes sense. it's good work.

After lots and lots of 1-4 or 2-3 slates...IT’S MY M0THERFU*KING BIRTHDAY!

(don’t look at the overall standings though)

No one told me Tree Rollins fouls so much. What the heck?

of course it was Danny Ainge....

Another 0-5 funeral.

Effing ****** is a major understatement.

Even that statement gets rejected.

6-6, 6-6, 6-6, 6-6 and 5-7... My team is the basketball equivalent of a shoulder-shrug.

Rank___	Owner__________	League 1___	League 2___	League 3___	League 4__	League 5__
1 (42)	mikee1	6	9	10	10	7
1	amerk1180	8	6	10	8	10
3 (41)	ashamael	10	8	8	7	8
4 (39)	robusk	8	9	5	9	8
5 (38)	kinoa1	9	4	8	9	8
6 (37)	24kpyrite	9	7	6	7	8
6	pexetera	5	10	6	4	12
6	beloud	8	8	7	8	6
9 (36)	jhsukow	8	9	6	7	6
10 (35)	cmcafeeky	9	11	8	2	5
11 (34)	bds9992	5	7	6	8	8
12 (33)	jkaye24	8	6	2	9	8
13 (32)	tarheel1991	9	6	4	6	7
13	jcred5	5	5	7	7	8
15 (31)	jpevans31	6	7	7	6	5
15	dbKC	3	5	8	8	7
15	Midge	3	7	10	4	7
18 (29)	dh555	6	4	6	7	6
19 (27)	20ks	5	5	3	7	7
19	NotoriousJ	8	4	5	6	4
21 (26)	benhoidal	6	7	5	4	4
22 (22)	albiband0	3	6	8	2	3
23 (21) 24 (20)	gerryred ysw128	3 6	3 3	3 8	8 3	4 0

I apologize for being so disconnected of late, but I want to thank DH, robusk, Ben, and anyone else behind the scenes working so hard putting and keeping this massive undertaking together. It is very much appreciated. Robusk the spreadsheet is just fantastic.

Glad everyone is digging it. I often make stuff like this but this is the first league I ever shared it.

the sleeping giant has awoken, and is currently the only one with 5 teams in the playoffs

OR the has-been had a good run of late but it's still too early to tell. depending on your point of view

Thanks for the left handed compliment, guy who is good in no cap leagues.