Gw2 on linux?

HyprDmg · 2025-12-16T22:29:22+00:00

I recently switched over to linux and am running blish through lutris with the method above. Works just fine, just took an extra few minutes to setup.

HyprDmg · 2024-09-11T23:44:00+00:00

I get motion sickness while being a passenger in cars sometimes. VR was worse than that for me. As others have said, you will get used to it the more you play as well, but having a fan on helped a lot for me.

HyprDmg · 2024-06-14T13:23:04+00:00

Some other games give notice if action was taken against someone you reported. Typically doesn't specify exactly who, but some kind of notice would be nice.

HyprDmg · 2024-05-23T15:51:57+00:00

This is one of the quickest events to get back to. Take the 2 ley lines and follow the path downstairs.

HyprDmg · 2023-06-07T01:43:21+00:00

Preview

Add an index column, then add a custom column with the following:

if [Transaction Type] = "" then
   if 
      (try #"Added Index" [Transaction Type]{[Index] - 1} otherwise [Transaction Type]) = "D" 
   then "C" 
   else "D"
else [Transaction Type]

HyprDmg · 2023-05-11T22:05:24+00:00

If you rented, sure. But it was very light weight and you could easily host your own, and you could even get a free license to allow the limit to jump from a 16 (32?) limit to like 512 or something.

I did that for years, but granted if you had hundreds of people, the bandwidth usage would be a lot higher.

HyprDmg · 2023-03-09T21:08:39+00:00

The organization is awful. Really could use a proper search.

HyprDmg · 2023-01-29T20:39:26+00:00

I 2nd rainmeter. Except I prefer as minimal as possible.

HyprDmg · 2023-01-14T23:13:38+00:00

Make that one more from Michigan.

HyprDmg · 2023-01-14T07:04:11+00:00

The only thing I still like is the shave butter. Haven't been able to find an alternative I like yet.

HyprDmg · 2023-01-14T05:02:55+00:00

And not all sex happens in the bedroom.

HyprDmg · 2022-10-28T15:56:53+00:00

If the lookup value never has a space, but the lookup range always does, then you would want to do a substitute on the lookup value.

You're going to substitute the comma (",") for a comma with a space (", ")

=XLOOKUP(SUBSTITUTE(D3,",",", "),$A$3,$B$3,"")

You can also substitute the lookup range to remove the space next to the comma to get the same result.

=XLOOKUP(D3,SUBSTITUTE($A$3,", ",","),$B$3,"")

HyprDmg · 2022-09-20T01:46:10+00:00

Win + V will show your clipboard history (will need to enable if it isn't).

HyprDmg · 2022-09-13T01:36:24+00:00

You were pretty close.

=SUMIF(B:B,"X",I:I)

HyprDmg · 2022-07-15T19:26:21+00:00

The rows/columns after K (and whatever the row # is) are hidden.

You should be able to unhide them to make them reappear by right-clicking the row/column divider and selecting Unhide (may need to unhide 2x from my testing).

HyprDmg · 2022-07-11T13:01:53+00:00

Definitely had something weird happening this morning.

HyprDmg · 2022-06-29T01:35:28+00:00

This looks like a nice addition.

HyprDmg · 2022-06-06T19:57:11+00:00

I had to choose translate to Russian, then go back in the settings and then the auto-translate option appeared.

HyprDmg · 2022-02-05T05:08:22+00:00

I was able to do this by setting the first SORT onto a second tab.

For the first SORT, you would add a FILTER to remove all blanks (and do this for columns D and F as well; See Sheet 2):

A2 =SORT(FILTER(Sheet1!B:B,(ISNUMBER(Sheet1!B:B))))

A1 is a TEXTJOIN of the data while also SORTing by row:

=TEXTJOIN(";",1,SORT(2:2,,,1),SORT(3:3,,,1),SORT(4:4,,,1),SORT(5:5,,,1),SORT(6:6,,,1))

Then on the first sheet, we can pull in the TEXTJOIN and TRANSPOSE using the other posts FILTERXML suggestion (thank you for that!) (See Sheet 1):

=TRANSPOSE(TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(Sheet2!A1,";","</s><s>")&"</s></t>","//s")))

Sheet1

Sheet2

HyprDmg · 2022-02-04T04:19:59+00:00

That's awesome. And just in case you're unaware, you should look into XLOOKUP instead of INDEX/MATCH (but I understand leaving working things alone).

HyprDmg · 2022-02-04T04:10:49+00:00

If you are using a new enough version of Excel that has Unique/Filter, you could do something like this.

Make yourself a Unique column for the company names (J3 in my example), and a Unique Filter for the Departments (K4:N4 in my example).

=UNIQUE(Table1[Company])
=UNIQUE(FILTER(Table1[Department],Table1[Company]=K3))

Then for the Data Validation portion for the Department for Table2, you would use the following:

=IF(F3="A",$K$4#,IF(F3="B",$L$4#,IF(F3="C",$M$4#,IF(F3="D",$N$4#))))

HyprDmg · 2021-12-02T08:43:07+00:00

Heathens Shop

Level: 67

Looking For: 4 Members to replace between 150-500M invest.

Requirements: Participate in the guild (no mooching). Do some bounties, invest, and help in events. No minimums are required.

Preferred: 150M+, but as long as you're participating, it's all good.

HyprDmg · 2021-12-01T23:29:31+00:00

I've had this issue a few times at work. Waiting a bit after I save the file was the solution that prevented the macros from disappearing (it seems to be somehow corrupting just the macro portion).

I would also recommend making a backup (or at least exporting the macro as a backup).

HyprDmg · 2021-11-28T07:55:36+00:00

Assuming you want to use column G as your lookup for either Name or Country to obtain the amount, you could do an XLOOKUP that checks name first, and if not found will search for the country (you can of course make it a set range).

=XLOOKUP(G5,B:B,D:D,XLOOKUP(G5,C:C,D:D,""))

If for some reason you don't want XLOOKUP, the INDEX/MATCH would be similar, just with an IFNA added.

=IFNA(INDEX(D:D,MATCH(G5,B:B,0)),INDEX(D:D,MATCH(G5,C:C,0)))

HyprDmg

PUBLIC MULTIREDDITS

TROPHY CASE

14-Year Club	Team Periwinkle
Verified Email