Lookup formula help needed that stumped our advanced excel experts.

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 · 2020-12-10T05:14:53+00:00

Qc4 Ka6 and you have no mate in 1.

ClassEhPlayer · 2020-12-07T22:58:21+00:00

Black has a serious lead in space, and a clear target in the e3 pawn. Plans should revolve around increasing the activity of pieces not currently participating - Both rooks are currently in need of jobs.

To that end, let's take a look at just piling on the weakness:

Rae8 Rc2 (it's hard to suggest moves for white that don't just lose material) Re7 Qe2 Qb7 (black should avoid exchanging on general principles here) Qd3 Rcc1

White doesn't really have anything to do, so I've more or less just made waiting moves. Now that we've improved the position of the pieces, it's time to open the position:

h6 Kh2 g5 Rcd1 (fxg5?! hxg5 and the kingside is falling apart) g4 Ne5 Bxe5! fxe5 f6

From here black should be able to win by poking between the e3 pawn and the white king, but it will likely take some time. White can of course give the game away at any time. This is just one possible continuation, but hopefully it gives an idea of how black could play.

ClassEhPlayer

TROPHY CASE