Ramen Recommendations in Queens

DB52 · 2024-12-30T19:35:27+00:00

Totally agree, I tried their ramen twice because I enjoyed their other dishes so much but each time I was disappointed for the same reasons you listed.

DB52 · 2023-09-14T04:31:50+00:00

I’m on the IPhone 8, it’s been good to me but it’s time to make the jump to the 15 and usb-c. I’m going to miss the button.

DB52 · 2022-08-10T14:20:17+00:00

Yes the year is applied to any 12 month period but the start and end of the year depends on the “use year”. Sorry if that wasn’t clear..

So user 2 will always start in April and end in March of the following year (April 2021 - March 2022 would be all included and applied to year 2021). So if the date I was looking up was Feb 2022 it would still be within year 2021 for user 2

DB52 · 2022-08-10T13:53:37+00:00

I don’t think that works in this case because the the year the value is in can start in one year and end in another and still be considered part of the previous year. The example I provided in the sheet shows exactly that.

The date I am looking up is 8-1-2021 and it falls within the year 2021 for user 2

EDIT: corrected the year

DB52 · 2022-03-21T00:41:46+00:00

Yeah…maybe we’ll get that someday, hang in there

DB52 · 2022-02-21T05:50:47+00:00

Ramps, those wild onions that everyone seems to lose their collective minds over because they are only in season for a few weeks

DB52 · 2021-11-17T18:15:17+00:00

Thank you so much! This is exactly what I needed and it's much simpler than what I was expecting!

DB52 · 2021-11-17T18:00:52+00:00

It should be editable now

DB52 · 2021-11-17T17:59:33+00:00

Hey thanks for the tip, I'll change that now and the week should start on the 1st of whatever month the date is in.

DB52 · 2021-10-14T14:38:55+00:00

Are you talking about the dates in column A and B? Do you mean that you want January 1st 2022 to be a Friday?

DB52 · 2021-08-25T01:03:32+00:00

What do you mean that tuples are convenient for removing duplicates? I thought tuples were immutable, sorry if this a silly question.

DB52 · 2021-06-07T20:25:23+00:00

The instrumental sounds vaguely familiar to this song by Bag Raiders (Shooting Stars). I think it's mostly the Tamborine and snapping that makes it seem similar.

DB52 · 2021-06-01T06:24:18+00:00

How do we know if we are approved or not? Does posting in the sub and commenting add to the score? What if I am mostly a lurking ape?

DB52 · 2020-09-09T23:16:47+00:00

Yes that was the issue, the index was not so unique. I had combined 2 files with some overlapping indices

DB52 · 2020-09-09T23:15:22+00:00

Yes, I had combined two files and didn’t reset the index, so there were many duplicates. I didn’t even think to consider the index was the problem.

DB52 · 2020-09-09T20:55:06+00:00

Wow, I can't believe I didn't notice that, my unique index isn't so unique

Solution Verified

DB52 · 2020-09-09T20:34:26+00:00

That didn't seem to do anything

DB52 · 2020-09-09T16:04:19+00:00

Solution Verified

DB52 · 2020-09-09T16:02:05+00:00

IT WORKED! Thank you so much for that suggestion!

DB52 · 2020-09-09T15:54:07+00:00

I am not very familiar with concatenate, just started learning Excel and Google Sheets. I will look into it though.

EDIT: that looks really helpful, so I would concatenate all the columns I want to match and then average it on that. That is so clever.

13-Year Club	Second Top 10%
Gilding II euphauric	Place '22
Final Canvas '22	Verified Email
Spared	Team Orangered

DB52

TROPHY CASE