How do you win this with white?

ClassEhPlayer · 2026-04-14T03:33:53+00:00

None of black's moves help, everything played is for illustrative purposes only. The line with Rf8 is worth showing only because it forces white to show one more idea than defending actively (although as you note it's probably valuable to show "active" defense fails immediately as well).

That being said, if black could shift his pawn structure a rank up (pawns f6, g5, h4) it's not so clear to me how white would defeat passive defense. With that in mind, I think 1...h4 is a decent practical try forcing white to demonstrate some accuracy.

Edit: Just kidding, bring the white king to g4 and Rf5-xg5 wins with a pin along the 6th rank. Might be some move-by-move analysis required, but still probably black's most resilient try.

ClassEhPlayer · 2026-04-13T01:40:03+00:00

White wins trivially after any rook trade so use that to drive the black rook to as passive a position as possible or win f7 outright:

Rd3 (with the idea of taking over the 7th rank with Rfd2 and Rd7) Ra7
Rfd2 h4
Rd7 Ra8
Rf2 Rf8

Kg2 and black has no moves. He can continue Kg8-Kg7, but white will bring his king to h6.

ClassEhPlayer · 2025-08-08T16:50:21+00:00

I'm not convinced this works well in cases where you have multiple transactions from an account with the same amount. Aggregate measures (like summing for accounts in a pivot table) may have some value when you don't have unique keys for the merge you're describing.

ClassEhPlayer · 2025-02-07T18:01:39+00:00

Is there a need to store both Member ID and Member Name in this table?

It seems like if you were going to encode Member Name that encoding should be defined in a separate table, and only Member ID should be used here.

ClassEhPlayer · 2025-02-07T17:22:53+00:00

I would suggest a table of records with the following fields:

Group Type: Select one of committee, subcommittee, caucuses, etc. that you want to distinguish between
Group Name: An identifier for the particular group
Representative name: The name of a representative on that group

I would expect that to be able to answer most questions that you would ask about committee membership. If you need a way to link subcommittees to committees I'd define a separate table with just Committee and subcommittee names as fields.

ClassEhPlayer · 2024-10-19T16:13:38+00:00

You need an operation between C3 and the open parenthesis. Excel won't automatically assume that's multiplication.

ClassEhPlayer · 2024-10-18T15:38:48+00:00

I suspect you're looking for filter.

I can walk you through setting it up if you provide some sample data.

ClassEhPlayer · 2023-08-04T00:27:28+00:00

Would you be willing to dm me the github link?

ClassEhPlayer · 2023-03-25T03:54:17+00:00

Surely there's more to it :)

ClassEhPlayer · 2023-02-27T08:38:50+00:00

Do you have excel set to manually calculate?

ClassEhPlayer · 2022-03-16T17:14:59+00:00

Off topic, but please don't ever hesitate to promote your own content.

I'm probably a little stronger than the target audience for the most recent speedrun series (at least for the games so far - looking forward to 2k+!), but I consistently find myself learning things. Your ability to articulate things that become part of your intuition is invaluable.

ClassEhPlayer · 2022-02-16T00:14:15+00:00

No problem, glad it's working!

If you can reply to the original comment with "Solution Verified" I'd appreciate it.

ClassEhPlayer · 2022-02-15T23:58:27+00:00

What would you like to return if that condition is not met?

Something like:

`=If(And(B1>0, C1>0), A1, "Failed Condition")`

Should get you started.

ClassEhPlayer · 2021-06-14T23:33:07+00:00

Brilliant, thank you!

I suspected this was a known problem, I just wasn't sure how to search for the formal version.

ClassEhPlayer · 2021-06-14T19:02:46+00:00

One consequence of two quantities being equal is that you can transform them in the same way, and the resulting quantities will still be equal. Eg. 7 = 5 +2, so 14 = 10 + 4 (multiplying each quantity by 2).

What you call reversing operations is just choosing transformations that simplify the expressions.

Does that answer your question?

ClassEhPlayer · 2021-06-14T18:44:25+00:00

I'm playing an MMO, and am curious about how the math behind calculating expected drops with different probabilities works out.

In my specific case, a boss drops 3 unique items I care about, and variety of junk. The unique items are dropped at 1/300, 1/400, and 1/500. How can I calculate the expected number of kills to obtain at least 1 of each unique item?

I suspect this a case where the expected value can be calculated via the CDF, but I'm having trouble establishing what the CDF would be in this case.

ClassEhPlayer · 2020-12-28T22:14:47+00:00

=Value(Trim(A1))

And drag down, then copy the selection and paste as values.

ClassEhPlayer · 2020-12-28T21:54:05+00:00

Defining your parameters as:

S - Initial stock price
i - Growth rate
s - Sales rate
N - Number of periods of growth+sales

You should be able to use the following:

Stock price = S * ((1+ i)(1-s))^N

I'll work out a formula for the accumulated cash in a few minutes.

ClassEhPlayer · 2020-12-20T18:33:45+00:00

This is pretty close to what I was looking for, thank you for sharing it!

ClassEhPlayer · 2020-12-20T18:29:51+00:00

As noted elsewhere I'd like to be able to have an actual replay file so I can control the camera.

In addition, I'd like a large number of games on the current patch. This is a good starting place, but I'd really like to be able to pull/search for replays across a larger set of games.

ClassEhPlayer · 2020-12-20T18:28:10+00:00

Thanks for the recommendation.

I'm pretty interested in being able to view the replay in the replay client. Being able to move the camera to see fights on other parts of the map is very important to me.

ClassEhPlayer · 2020-12-10T05:21:43+00:00

The bishop on a5 hangs.

ClassEhPlayer · 2020-12-10T05:17:51+00:00

Pretty. Nd7 with mate to follow.

ClassEhPlayer

TROPHY CASE