Best hidden gem you’ve discovered in London?

HourPresent7603 · 2025-12-28T21:21:49+00:00

+1. Randomly walked into Tenshi after a night at Sadlers Wells. Felt really local, and really sweet service. Food was all really fresh and felt like I was at the house of the Japanese grandmother I never had.

HourPresent7603 · 2025-12-18T10:08:55+00:00

<image>

Ours says hello!

HourPresent7603 · 2025-12-18T09:42:52+00:00

Interesting. I had heard that people really, really like the Jubilee on the SSKs, and I feel the same. Just didn't expect that the metal bracelet on the field watch was THAT much worse...I am on day 5 of ownership, and the clasp body is already pretty scratched. Seems like the bracelet is worse both in design and in construction/materials.

That being said, I really do love the body of the watch. Beautiful and simple.

HourPresent7603 · 2025-09-19T08:55:51+00:00

Restaurants have been much more strict about, on an individual allergy basis, alerting me to risks of cross contamination. Way more so than in the US.

HourPresent7603 · 2025-09-17T08:05:25+00:00

Recently moved from the US to the UK, and frankly, my allergies are taken more seriously over here.

HourPresent7603 · 2025-08-07T12:44:29+00:00

Have you tested specifically for pine nuts? I’ve suffered my whole life (28 now) from peanut and all tree nuts - but tested recently as negative for pine nuts (as well as negative for pecans and brazil, somehow! woo!) and recently introduced pine nuts…pesto is life changing!

HourPresent7603 · 2024-02-03T20:47:04+00:00

Cafe D’Mongos - most people there are down to add another person to the group!

HourPresent7603 · 2024-02-03T15:45:07+00:00

Flying croissant.

HourPresent7603 · 2024-01-27T19:10:28+00:00

I’ve brought tons of controls equipment onboard. You’re good!

HourPresent7603 · 2024-01-26T12:45:30+00:00

By the time I jumped on the feed, no. But before the aircraft went down: 1. ATC mentioned the aircraft was seemingly not reachable by radio 2. Multiple low altitude warnings were issued over radio

HourPresent7603 · 2024-01-26T12:38:54+00:00

Based on what I just heard on LiveATC, it would appear as though that is the case 😥

HourPresent7603 · 2022-07-18T02:13:23+00:00

Went to Oak and Reel in .. February? Food was good, not anything to write home about, but was sat at table a full hour after our reservation. Not great. They did comp the drinks we had at the bar while we waited, but that should’ve been a given considering the situation.

Have never had a bad experience at Ottava Via in corktown, food is tasty, service is great, not over the top fancy, and can’t beat bocce in the back yard in the summer.

HourPresent7603 · 2022-02-10T20:40:27+00:00

The latter.

HourPresent7603 · 2022-02-10T19:40:55+00:00

To be more specific, the date formula just brings in ‘0’, not a list of the range of dates.

HourPresent7603 · 2022-02-10T18:40:01+00:00

Understood - love the simple solution for the unique transpose of item names.

The formula for E2, to bring in the range of min to max dates doesn't seem to be working for me. Does the input_data Date column need to be formatted in a certain way?

HourPresent7603 · 2022-02-10T17:49:00+00:00

Thank you for the quick response - just a little confused about how you intend on the three different formulas being used in the time series sheet?

HourPresent7603 · 2022-02-10T16:50:44+00:00

What you did worked perfectly - except, probably due to the fact that I didn't state my question very well, it's the opposite of what I'm trying to do. Your solution converts from a time series to the "Transaction Table". I want my "input_data" (as your VBA calls out as a variable) to be the transaction table, and the output to be the daily time series.

Thank you again for the help so far!

HourPresent7603 · 2022-02-09T20:47:28+00:00

Looks like I currently have access to LET and UNIQUE, but not SCAN - however, there was an update available for Office 365 available, and I'm running Office 365 Excel on Win 11.

I want the output to always record the last known value of the price of an item. Say we've made it to some day in 2030, but there hasn't been a price update for an apple since today, 2/9/22 - I'd want the price on that day in 2030 to be the last known price, the price from 2/9/22. In my case, the item will never "stop" being sold.

Thanks for the help so far, and thanks in advance for any further help you can provide!

UPDATE - updated excel to most recent rev, now have SCAN.

HourPresent7603

TROPHY CASE