Posted by robusk on 9/14/2020 4:01:00 PM (view original):
I don't always have time to post the latest standings, so I am sharing this with the league. If you want to get the latest standings, just hit "refresh all" twice on the data tab (technically you can just do refresh all once, and then refresh once but the other way is just less clicking. The pivot table refreshes before the Power Query tabs which is why you have to do it twice. It takes like less than 10 seconds to do.

Anyone can just download this, keep it local and rerun. The URLs are hardcoded so it won't work in future vintages of Savage. You will probably have to "enable content" since it references external sources (Whatifsports.com in this case).

https://1drv.ms/x/s!Ald3PE_Y7GFNgYIw-CKpN8asu5VPIA?e=SkDodM

Does anyone happen to know how to get this to work on an iPhone? I have Excel on my phone but when I click “open in excel” on this link, it keeps just opening it in Safari, but I can’t pull the new data from the Safari version. I can’t download it either.

Posted by dBKC on 9/28/2020 10:10:00 AM (view original):

Posted by robusk on 9/14/2020 4:01:00 PM (view original):
I don't always have time to post the latest standings, so I am sharing this with the league. If you want to get the latest standings, just hit "refresh all" twice on the data tab (technically you can just do refresh all once, and then refresh once but the other way is just less clicking. The pivot table refreshes before the Power Query tabs which is why you have to do it twice. It takes like less than 10 seconds to do.

Anyone can just download this, keep it local and rerun. The URLs are hardcoded so it won't work in future vintages of Savage. You will probably have to "enable content" since it references external sources (Whatifsports.com in this case).

https://1drv.ms/x/s!Ald3PE_Y7GFNgYIw-CKpN8asu5VPIA?e=SkDodM

Does anyone happen to know how to get this to work on an iPhone? I have Excel on my phone but when I click “open in excel” on this link, it keeps just opening it in Safari, but I can’t pull the new data from the Safari version. I can’t download it either.

Pretty sure the refresh function isn’t there in iOS unless I missed it.

Unsure about your Safari problem. I just see stuff like that in the “shared with me” section of the Excel app. Jhsukow sounded like he figured out how to open it.

Ben had the file locked over the weekend. Not sure if he still does.

I’m honestly not a big fan of the mobile Excel experience. I prefer to RDP into my desktop from the phone and use Excel that way.

Posted by robusk on 9/28/2020 10:32:00 AM (view original):

Posted by dBKC on 9/28/2020 10:10:00 AM (view original):

Posted by robusk on 9/14/2020 4:01:00 PM (view original):
I don't always have time to post the latest standings, so I am sharing this with the league. If you want to get the latest standings, just hit "refresh all" twice on the data tab (technically you can just do refresh all once, and then refresh once but the other way is just less clicking. The pivot table refreshes before the Power Query tabs which is why you have to do it twice. It takes like less than 10 seconds to do.

Anyone can just download this, keep it local and rerun. The URLs are hardcoded so it won't work in future vintages of Savage. You will probably have to "enable content" since it references external sources (Whatifsports.com in this case).

https://1drv.ms/x/s!Ald3PE_Y7GFNgYIw-CKpN8asu5VPIA?e=SkDodM

Does anyone happen to know how to get this to work on an iPhone? I have Excel on my phone but when I click “open in excel” on this link, it keeps just opening it in Safari, but I can’t pull the new data from the Safari version. I can’t download it either.

Pretty sure the refresh function isn’t there in iOS unless I missed it.

Unsure about your Safari problem. I just see stuff like that in the “shared with me” section of the Excel app. Jhsukow sounded like he figured out how to open it.

Ben had the file locked over the weekend. Not sure if he still does.

Locked it by accident. Didn't even realize I could do that. Should be unlocked now.

I still haven’t found a solution on my phone. If someone does, please post.

Row Labels	Sum of Wins	Max of Wins	Min of Wins	Sum of L50 Wins	Sum of L50 Losses	Sum of DivisionLead
pexetera	197	43	37	34	16	4
dBKC	185	44	28	33	17	1
bds9992	178	44	26	30	20	2
dh555	176	39	29	28	22	3
24kpyrite	175	44	29	27	23	1
longtallbrad	170	38	24	24	26	2
mptrey	169	35	32	28	22	0
gerryred	169	37	30	25	25	0
ashamael	163	37	29	29	21	0
tarheel1991	163	39	26	28	22	1
pharrop	162	36	27	28	22	1
benhoidal	159	36	28	27	23	0
20ks	151	35	26	24	26	0
cmcafeeky	149	34	25	22	28	1
robusk	149	35	19	26	24	1
mikee1	146	40	23	24	26	1
dskantor	144	36	21	26	24	2
amerk1180	144	34	22	24	26	1
jcred5	139	40	22	20	30	1
goetz93	130	29	20	23	27	0
jhsukow	127	33	18	26	24	0
ysw128	122	31	12	17	33	0
jpevans31	103	25	16	17	33	0
albiband0	90	28	11	10	40	0

Posted by jhsukow on 9/28/2020 11:32:00 AM (view original):
I still haven’t found a solution on my phone. If someone does, please post.

I did a quick web search and it doesn't look like the refresh functionality is there for iOS version.

So this will only be useful for people using desktop Excel.

I doubt I’m going to finish any higher than 2nd, but at least I can probably claim back-to-back podium finishes with some ballsy moves like picking Harden higher than anyone else would have, trading Wilt for Curry, burning a 3rd on a guy who only has 3 seasons (Simmons), and getting drunk and drafting George Gervin and Josh Smith.

Posted by dBKC on 9/28/2020 11:45:00 AM (view original):
I doubt I’m going to finish any higher than 2nd, but at least I can probably claim back-to-back podium finishes with some ballsy moves like picking Harden higher than anyone else would have, trading Wilt for Curry, burning a 3rd on a guy who only has 3 seasons (Simmons), and getting drunk and drafting George Gervin and Josh Smith.

Huh. Maybe the WISNBA has missed out on the opportunity to run a theme league featuring a speed draft - maybe a super-compressed three hours with all owners under the influence.

On a vaguely related note, my very first open league team (I don't know how many years ago) involved only players who had been suspended for drug use.

I’m down for a speed draft if you guys are. We’d each set aside an afternoon together and just power through it. Also down to do it while drinking.

288 picks in an afternoon. At 1 minute per pick, it would take 5 hours

Posted by dBKC on 9/28/2020 11:59:00 AM (view original):
I’m down for a speed draft if you guys are. We’d each set aside an afternoon together and just power through it. Also down to do it while drinking.

set up the google meet to insure drinks are being had. You know i'd be down

any time your exceed your 1 minute time slot you are skipped (can catch up anytime) and have to pound your drink. of course, your next round pick would be in 24 minutes

Posted by pexetera on 9/28/2020 12:06:00 PM (view original):
288 picks in an afternoon. At 1 minute per pick, it would take 5 hours

Most drafts aren’t 12 rounds. We could do a 5 round draft or something.

24 person zoom call, I'm in.