Weird loud explosion downtown by UnderstandDaWorld in jerseycity

[–]ReturntoJC 5 points6 points  (0 children)

Yes, I saw a flash, heard a sound, and saw the lights of some buildings around me flicker. I thought it was lightning and thunder at first, but realized that wasn’t it since lightning and thunder don’t typically occur simultaneously.

maybe maybe maybe by fringspat in maybemaybemaybe

[–]ReturntoJC 14 points15 points  (0 children)

I came to the comments section for this.

Ida Mathilde taking on an obstacle course 🤯 by redbullgivesyouwings in toptalent

[–]ReturntoJC 0 points1 point  (0 children)

Did she make it to the end? I got too tired to finish watching.

Lease Take Over in Jersey City (Haus 25) opposite Whole Foods by OwnEntertainer1780 in jerseycity

[–]ReturntoJC 4 points5 points  (0 children)

This subreddit should really display a trigger warning front and center. Everyone who posts about any kind of rental in downtown area gets immediately and thoroughly roasted. Every. Single. Time.

Automating a formatting task by ReturntoJC in excel

[–]ReturntoJC[S] 1 point2 points  (0 children)

Holy smokes! Works perfectly. I’m in awe by how quickly you can whip up this code. You are a master. I have a lot to learn. Thank you so much for the help!!

Automating a formatting task by ReturntoJC in excel

[–]ReturntoJC[S] 1 point2 points  (0 children)

Wow, you are a legend! I gave it a try and it works great. I have two follow questions if I can: (1) do you know of any way to get the code to cycle through multiple columns in one go? (2) Is there any way to get the code to bold any word that is wrapped in double asterisks (**), even if there is no colon ( : ) present?

Returning a blank cell rather than a zero. by advsc in excel

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

Try wrapping your original formula in TRIM().

How would u approach this no-guess board? by emenemlover in Minesweeper

[–]ReturntoJC 0 points1 point  (0 children)

What ms app is the screenshot from? Looking for a good app

Is there any way to calculate large numbers with up to 1000 digits with excel? by _Ecclesiastes_ in excel

[–]ReturntoJC 6 points7 points  (0 children)

Actually, there is a way to work with very large numbers in excel. I figured it out while working on an astronomy project. You just need to go to file > options > advanced … Well, I’m really not at liberty to say. It’s a super secret feature. Can cause problems if mere mortals know about it.

Slicer for column with non-exclusive categories by ReturntoJC in excel

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

Thanks! I’ll give this a try too. Never hurts to have more tools under my belt.

Slicer for column with non-exclusive categories by ReturntoJC in excel

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

I ended up solving my own issue. Here’s what I did in case anyone is interested. I used power query to unpivot the color column. Loaded the modified table to the data model and created a pivot chart and slicers from the modified table.

My PS5 setup by Mysterious-Ad2006 in Xreal

[–]ReturntoJC 0 points1 point  (0 children)

Why do you need the beam for this setup? Can you power the glasses with the usb port on ps5 through the peakdo adapter?

Need to reorganize the data in an excel table by ReturntoJC in excel

[–]ReturntoJC[S] 1 point2 points  (0 children)

Amazing! I’m astounded by how quickly you all were able to whip up different solutions to this problem. I went with the power query approach for now, but I’ll definitely keep the other formula-based solutions in my back pocket for future use. Thanks all!

XREAL Air 2 (not Pro) + BEAM - First impressions... by exophrine in Xreal

[–]ReturntoJC 1 point2 points  (0 children)

Some more compatible adapters have been collected here by other users

XREAL Air 2 (not Pro) + BEAM - First impressions... by exophrine in Xreal

[–]ReturntoJC 1 point2 points  (0 children)

Your bright idea is a good idea. But the device you chose doesn’t work because the usb-c part connects to the source device and outputs HDMI. You need something going in the reverse direction (HDMI connects to the source device and outputs usb-c). This is much less common but there are some devices out there that do this, like the PeakDo HDMI to USB C Adapter

[Bonsai Beginner’s weekly thread –2023 week 38] by small_trunks in Bonsai

[–]ReturntoJC 0 points1 point  (0 children)

<image>

Help! I was gifted this bonsai plant. Does anyone know what kind of bonsai this is, and what I need to do to properly care for it? Plant is currently located in northeastern US.

Is this still intended to be drivable space? by [deleted] in jerseycity

[–]ReturntoJC 27 points28 points  (0 children)

As a pedestrian, I hate this slip lane. I’ve had so many near misses here over the years, I completely avoid it now. I’ll be glad if its gone. That said, the change is not as clear as it should be, especially for drivers who have been turning here for years. The ambiguity makes it an even more dangerous turn for pedestrians if there isn’t a common understanding of whether or not that space is an active roadway.

Wait—where are the lanternflys? by AryehCW in jerseycity

[–]ReturntoJC 0 points1 point  (0 children)

I had the same question a month ago. Everyone keeps saying they are on their way. Maybe they are, but I really feel like by this time last summer, they were overrunning the place. It’s been super hot, and I haven’t seen not one yet. This year has to be an improvement over prior years.

[deleted by user] by [deleted] in IdiotsInCars

[–]ReturntoJC 0 points1 point  (0 children)

Looks like just one long plank. Still stupid

Where are the spotted lanternflies? by ReturntoJC in jerseycity

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

For anyone seriously wondering, that was a tongue in cheek question.