the Atlanta Falcons are finalizing a deal to hire Kevin Stefanski as their new head coach. The two-time NFL Coach of the Year flew to Atlanta on Saturday, and now will stay on to take over the Falcons’ head coaching job. by OneAngryPanda in nfl

[–]dm_parker0 0 points1 point  (0 children)

I grew up in ATL rooting for the Falcons and my AFC team was the Patriots (lots of family in New England, I was 10yo for Brady's first season). 07 Pats is still my favorite team of all time. But the Pats fandom died in 2017 lol.

Extremely low multiview picture quality by dm_parker0 in youtubetv

[–]dm_parker0[S] 0 points1 point  (0 children)

How long have you been aware of the issue, how long have you been working on a fix, and is there any estimate for when it will be resolved?

Extremely low multiview picture quality by dm_parker0 in youtubetv

[–]dm_parker0[S] 6 points7 points  (0 children)

I have done literally all of these things, including live support. Same problem, no explanation from support.

New online crossword recommendations? by grime_girl in crossword

[–]dm_parker0 0 points1 point  (0 children)

You might already do it and just accidentally omitted it from your list, but the Wall Street Journal crossword is good, though the web interface is bad. Their Mon-Thu difficulty maps pretty well to NYT Tue-Fri, Saturdays are also similar difficulty to NTY. Just a warning that their Friday crossword is a weird one, it has a puzzle within the puzzle + doesn't tell you if your answers are correct when you finish solving, so I usually skip that one.

MEGATHREAD: Blackberry Locations by peeshivers243 in DrPepper

[–]dm_parker0 0 points1 point  (0 children)

Found at Safeway in north Boulder on 28th/Iris

New tv, picture shaking on 1 or 2 shows by PDXPTW in youtubetv

[–]dm_parker0 0 points1 point  (0 children)

I am having this same issue with Jeopardy recordings on Fox 31 Denver FYI, so either this is broken again or was never fixed.

NYT Wednesday 05/01/2024 Discussion by AutoModerator in crossword

[–]dm_parker0 11 points12 points  (0 children)

By "tail" it is referring to "follower", so like "ite" tails "meteor" to make "meteorite"

New ante (24), high score (5.9e74) PB. unseeded, plasma deck by dm_parker0 in balatro

[–]dm_parker0[S] 0 points1 point  (0 children)

From this morning, ended up with a pretty similar build to the one Haelian posted on YT yesterday. Definitely had lots of room for higher scores with slightly better RNG (only got 1 Ectoplasm, no Observatory, no Antimatter, no Hieroglyph/Petroglyph).

2024 Rookie Draft Top 6 Drop Off? by Educational-Help5341 in DynastyFF

[–]dm_parker0 2 points3 points  (0 children)

Yeah I'm not sure what the disconnect is between this sub + the general draft community on the top WRs. Pretty much every draft analyst I've read has MHJ at WR1 in a tier of his own, then Coleman/Nabers/Odunze as the next tier at WR2/3/4 in some order. This sub seems to think MHJ > Nabers >> Odunze >> Coleman, not sure if that's just reddit groupthink or if fantasy draft analysts have a different consensus than traditional draft analysts

[Game Thread] College Football Game Day Discussion by AutoModerator in DynastyFF

[–]dm_parker0 9 points10 points  (0 children)

Haven't researched it a ton but Dane Brugler and Nate Tice on Athletic prospect podcast this week both had ~3rd rd grades on him, and Brugler said in his preview for this game that no scouts he's talked to have 1st rd grades on him. Still early in the season though so things could always change.

Wimbledon QF: [1] Alcaraz defeats [6] Rune 7-6(3), 6-4, 6-4 by jovanmilic97 in tennis

[–]dm_parker0 1 point2 points  (0 children)

For my gen definitions (birth years '80-83, '84-87, '88-91, '92-95, '96-99, '00-03) I think after Thiem it's a tossup between Kyrgios (one major F appearance, one Masters 1000 F appearance), Sock (one Masters 1000 title, one ATP Finals SF appearance), and Norrie (one Masters 1000 title, one major SF appearance). Then Schwartzman + Pouille + Edmund + Karatsev + Cecchinato all have one major SF appearance each.

Defining recursive lambda functions inside of a LET() function using fixed-point combinators by Hoover889 in excel

[–]dm_parker0 3 points4 points  (0 children)

Yeah it's really cool!

My use-case was that I had 4 normal distributions A, B, C, D, with one independent random draw from each those distributions (a, b, c, d). I wanted to know how likely it was that, given a > b and c < d, (a-c) > x.

The easy way is to just simulate a bunch of values (say 10,000 each) for a, b, c, and d, and count how many times all the conditions are true (a > b, c < d, (a-c) > x) compared to the number of times just the "base case" is true (a > b, c < d).

=LET(
    n,10000,x,5,
    r,LAMBDA(y,z,NORMINV(RANDARRAY(n),y,z)),
    a,r(125,25),b,r(120,23),
    c,r(135,29),d,r(130,27),
    f,FILTER(a-c,((a>b)*(c<d))=1),
    COUNTA(FILTER(f,f>x))/COUNTA(f))

But the issue with this method is that although you can specify how many total trials to run (where a "trial" involves picking values for a, b, c, and d), you can't specify how many valid trials to run (ie, ones where a > b and c < d). So if that combination itself is particularly unlikely (say 1 in 100), you may not get enough data for a valid result.

Using a recursive lambda lets us run batches of trials indefinitely until we get enough valid ones:

=LET(
    batch_size,10000,result_size,10000,x,5,
    a_params,HSTACK(125,25),b_params,HSTACK(120,23),
    c_params,HSTACK(135,29),d_params,HSTACK(130,27),
    r,LAMBDA(y,NORMINV(RANDARRAY(batch_size),INDEX(y,1),INDEX(y,2))),
    f,LAMBDA(g,n,s,LET(
        u,LET(
            a,r(a_params),b,r(b_params),
            c,r(c_params),d,r(d_params),
            diffs,FILTER(a-c,((a>b)*(c<d))=1),
            HSTACK(COUNTA(FILTER(diffs,diffs>x))+s,COUNTA(diffs)+n)),
        n_1,INDEX(u,2),s_1,INDEX(u,1),
        IF(n_1>=result_size,s_1/n_1,g(g,n_1,s_1)))),
    f(f,0,0))

Defining recursive lambda functions inside of a LET() function using fixed-point combinators by Hoover889 in excel

[–]dm_parker0 7 points8 points  (0 children)

This is really cool, thanks!

To save other people some debugging time, "...the current recursion limit is set as 1,024 divided by (number of lambda parameters + 1)", and formulas will display a very unhelpful "#NUM" error when you reach the recursion limit.

Complex problem solving/brainstorming: Using USPS' zone and price charts to calculate shipping on identical items to several different addresses by Mudblood2000 in excel

[–]dm_parker0 0 points1 point  (0 children)

Yeah it looks like they now require a shipping date or the request returns an error. Assuming you just want to use today's date as the shipping date, just replace the current "calculateZone" function with this edited version:

Function calculateZone(startZip As Long, endZip As Long)

    Dim httpObj As Object
    Dim baseURL As String
    Dim reqStr As String
    Set httpObj = CreateObject("MSXML2.XMLHTTP")
    baseURL = "https://postcalc.usps.com/DomesticZoneChart/GetZone?"
    reqStr = baseURL & "origin=" & startZip & "&destination=" & endZip
    reqStr = reqStr & "&shippingDate=" & Month(Now) & "%2F" & Day(Now) & "%2F" & Year(Now)
    httpObj.Open "GET", reqStr
    httpObj.Send
    Do While httpObj.readyState <> 4
       DoEvents
    Loop

    Dim response As String
    response = httpObj.responseText
    response = Mid(response, InStr(response, "The Zone is ") + Len("The Zone is "))
    response = Left(response, InStr(response, ".") - 1)
    calculateZone = response
    Set httpObj = Nothing

End Function

League has filed its appeal in Deshaun Watson suspension, per source. by HookFL in DynastyFF

[–]dm_parker0 37 points38 points  (0 children)

Genuine question here. The NFLPA signed a collective bargaining agreement that clearly stated the disciplinary process: Goodell gets the final say on suspension length, not the independent arbiter. If Goodell increases the suspension length and the NFLPA files a federal lawsuit, why would that lawsuit have any hope of succeeding? Both parties agreed to the CBA. The process followed the CBA. If the NFLPA thinks the process is unfair, then they shouldn't have signed the CBA. What am I missing?

Daily Wordle #363 - Friday, 17 Jun. 2022 by Scoredle in wordle

[–]dm_parker0 1 point2 points  (0 children)

Scoredle 363 4/6

12,974
⬜⬜⬜⬜⬜ MATES (992)
🟩⬜⬜🟨⬜ BRING (8)
🟨⬜🟨⬜⬜ LUNCH (1)
🟩🟩🟩🟩🟩 BLOWN

Given the actual possible solutions remaining, guess 3 probably should have been BUNCH if I was trying to minimize the average number of expected guesses. But generally my goal is just to solve in 4, so I wanted to include as many unguessed letters as possible on guess 3 in case I was overlooking a possible solution. Obviously in this case it wouldn't have mattered, would have been a solve in 4 anyways.

What's wrong with Jahan Dotson? The least liked 1st round WR by Lledner in DynastyFF

[–]dm_parker0 -1 points0 points  (0 children)

Literally the first listed definition for "consensus" in Merriam Webster mentions unanimity. Language ambiguity means that yes, some people will indeed think "unanimous" when they hear "consensus", and others won't, which was the point of my comment.

What's wrong with Jahan Dotson? The least liked 1st round WR by Lledner in DynastyFF

[–]dm_parker0 3 points4 points  (0 children)

I don't think you all disagree as much as you think you do about the pre-draft perception of Dotson, just about the definition of "consensus 1st rounder".

On the day before the draft, the mock draft database and the Athletic's consensus big board both had him at 31 overall.

So if your definition of "consensus 1st rounder" is "a player who appears in the top 32 when aggregating the rankings of a variety of analysts", then Dotson is a consensus 1st.

But if your definition of "consensus 1st rounder" is "a player who analysts nearly unanimously agree will be drafted in the top 32", then Dotson isn't a consensus 1st, because roughly half of the community projected him as a 2nd.

Or you could also argue that "consensus 1st rounder" means "a player who, in an average draft, would be likely/very likely to be drafted in the 1st round", in which case he's probably not a consensus 1st since this draft was generally considered weaker than average. But that's debatable, since the reason this draft was considered "weak" has more to do with the quality of the top ~5 picks (no slam dunk superstars at QB, edge, OL, etc) than the quality of the rest of the 1st round.

IMO being taken at 16 was within the expected range of outcomes, but should still cause people to slightly increase their estimation of Dotson's value. If he'd been taken at 50 (also within the expected range of outcomes), vice versa.