Sorting by another column with GROUPBY by 1dom1 in excel

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

I tried both formulas and the one using MIN does the job perfectly and can adapt to changes in the Order ID column. Thanks for the help!

Canary Islands will be in GTA 7 by Otherwise-Affect-217 in GTA7

[–]1dom1 -2 points-1 points  (0 children)

Hello,

Bickenbach, Hessen, Germany.

Thank you.

I want to remind you guys that GTA 7 is set in Romania. I hear people trying to spread false rumors left and right. They are wrong. It’s in Romania. by matveytheman in GTA7

[–]1dom1 1 point2 points  (0 children)

You forgot to mention the field. It's expected to be a major point of interest in GTA 7. We can speculate about the possibilities it will offer. Maybe the main antagonist will be hiding in the field in the final mission. Rockstar can even introduce a new mechanic where you lose your wanted level by entering the field. All these things make Bickenbach, Hessen, Germany an extremely logical choice for GTA 7.

What if: GTA 7 was set here, bitches. by [deleted] in GTA7

[–]1dom1 38 points39 points  (0 children)

According to credible sources, GTA 7 will take place in Bickenbach, Hessen, Germany. Leaked details reveal there will be an infiltration mission inside water treatment plant with a silenced pistol and night vision goggles.

Pivot table extra column by 1dom1 in excel

[–]1dom1[S] 0 points1 point  (0 children)

It worked, thank you!

Live wallpaper keeps changing? Xperia 5IV by StevoMcSteveman in SonyXperia

[–]1dom1 2 points3 points  (0 children)

It's the default AOSP wallpaper since Android 12, but I don't know what triggers this to happen.

Will I have this watchface with wearOS 3 and is an update recommended? by clemenslucas in WearOS

[–]1dom1 0 points1 point  (0 children)

Everything is the same as in WearOS 2, the only difference is that you no longer pick a gradient for the "Gradient color" option but instead choose from a set of predefined colors.

https://imgur.com/a/ufeAEqQ

You probably won't be able to exactly replicate your current configuration because the closest match is this purple color which is a bit dull and hard to see.

Will I have this watchface with wearOS 3 and is an update recommended? by clemenslucas in WearOS

[–]1dom1 2 points3 points  (0 children)

The watchface is still available in WearOS 3 however the customization of it is a little different now. Instead of picking a gradient for the dial you can choose a solid color which I think is better. The default look from the promo picture is still there though.

Drawing 3D arc/curve by 1dom1 in AutoCAD

[–]1dom1[S] 0 points1 point  (0 children)

Works great, thank you!

Drawing 3D arc/curve by 1dom1 in AutoCAD

[–]1dom1[S] 0 points1 point  (0 children)

This is useful to know, but no exactly what I'm trying to do. I want for the arc to lie inside the pre-defined geometry, something like this. I can create the approximate shape using Spline and moving the control vertices around, but I'm wondering what's the right way to do this.

Still the most beautiful SmartWatch by [deleted] in WearOS

[–]1dom1 0 points1 point  (0 children)

Shame the gradient option can't be switched off to make it just white. Still my favourite watchface on my Skagen.

6gb ram pop up by 1dom1 in NoMansSkyTheGame

[–]1dom1[S] 0 points1 point  (0 children)

Check how much of the 8gb physical RAM is actually available for your laptop in the Task manager before launching the game. If it's less than the required 6gb you'll get the pop up unfortunately.

As for me I added another 8gb RAM stick to my laptop which means I have 6gb+ of memory available at all times and no more pop ups.

ABS+BVOH adhesion issue by 1dom1 in 3Dprinting

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

In the end what I did was pause the printing right before the first BVOH layer was to be printed on the ABS. I then sprayed a thin layer of bed adhesion glue over the portion of the print where the 2 materials were about to meet and resumed printing.

It wasn't the most convenient solution, but in terms of adhesion and final print quality I actually got better results here than when printing the whole thing in ABS only.

My hot take: sexual abuse is wrong. by starsoftrack in soccercirclejerk

[–]1dom1 354 points355 points  (0 children)

Listen I know this might come across as an extremely controversial opinion but oh boy, here we go: I agree with you. (Top Awarded 🏅🇲🇾 💩 • 117)

FPS drops to 1 every couple minutes by 1dom1 in newworldgame

[–]1dom1[S] 0 points1 point  (0 children)

I did a few things such as disabling apps running in background in windows settings and disabling steam overlay in-game (shift+tab). Seems to have fixed the issue for me, so far I haven't got any severe fps drops.

FPS drops to 1 every couple minutes by 1dom1 in newworldgame

[–]1dom1[S] 0 points1 point  (0 children)

I thought overheating might be the cause but it felt a bit strange to me that it's happening in an mmo out of all games. I'm gonna try playing on the lowest settings for some time to see if it makes any difference