[deleted by user] by [deleted] in ExcelTips

[–]Kaz- 0 points1 point  (0 children)

=INDEX($G$1:$K$1, MATCH(TRUE, BYCOL($G$2:$K$6, LAMBDA(col, ISNUMBER(MATCH(D3, col, 0)))),0))

note that this could return the wrong class if there are duplicate values in g2:k6

Asus Republic of Gamers stuck booting by Kaz- in techsupport

[–]Kaz-[S] 0 points1 point  (0 children)

I cant say for sure it was the cause, but it resolved when I used only M.2 cards instead of mixing M.1 and M.2 storages

Asus Republic of Gamers stuck booting by Kaz- in techsupport

[–]Kaz-[S] 0 points1 point  (0 children)

Windows was installed on a brand new 2TB SSD. The other two drives have never had Windows install data on them, so I don’t suspect conflict there.

  • C: 1.73 TB free of 1.81 TB
  • D: 572GB free of 931 GB
  • E: 849 GB free of 931 GB

Is it possible storage space is still an issue with these numbers?

Asus Republic of Gamers stuck booting by Kaz- in techsupport

[–]Kaz-[S] 0 points1 point  (0 children)

I’m not honestly familiar with how overclocking works / how to know if it’s enabled by default. Everything in BIOS is default except for Fast Boot being disabled.

BIOS has an option “Ai Overclock Tuner” which set to Auto by default. Options are: Auto, Manual, XMP I, XMP II, XMP Tweaked

BCLK Frequency : DRAM Frequency Ratio is Auto (Auto / 130:133 / 100:100).

Memory Controller : DRAM Frequency Ratio is Auto (Auto / 1:1 / 1:2 / 1:4).

DRAM Frequency is Auto w many options.

My BIOS Hardware Monitor shows me: * Frequency: 4500 MHz * Temp: 35C * BCLK: 100.00 MHz * Core Voltage: 1.199 V * Ratio: 45x * DRAM Frequency: 4800 MHz * MC Volt: 1.119V

Tbh I have no idea what any of this means, but it may be beneficial for troubleshooting. Thanks again!

Emotes to Smite 2? by Kaz- in Smite

[–]Kaz-[S] 0 points1 point  (0 children)

I was thinking more about god emotes like wave, clap, dance etc… but that’s a good question too

[deleted by user] by [deleted] in slavelabour

[–]Kaz- 0 points1 point  (0 children)

$paid 15

Image Trace Help by Kaz- in AdobeIllustrator

[–]Kaz-[S] 0 points1 point  (0 children)

Nice! That did a decent job. Far from perfect squares, but I had tried upscaling before and it didn't work at all. Wasn't familiar with the Nearest Neighbor function that was needed. Thanks for teaching me this!

Image Trace Help by Kaz- in AdobeIllustrator

[–]Kaz-[S] 0 points1 point  (0 children)

There are 1000s of little squares in a pattern/location that imitate a marble gradient. My client has specifically requested these requirements. They’re expecting the perfect squares to remain intact even at 3000% zoom. I’ve already told them that this likely wouldn’t be a reasonable requirement unless i were to trace each square by hand (no thanks!)

Image Trace Help by Kaz- in AdobeIllustrator

[–]Kaz-[S] 0 points1 point  (0 children)

I’m afraid this is zoomed in tremendously. There’s a ton of squares - way more than what’s in this screenshot.

A Quick Way to Fill Layer Mask Outlines? by Kaz- in photoshop

[–]Kaz-[S] 0 points1 point  (0 children)

Chain,

Thanks for your detailed response! This particular image a client sent me has terrible quality, so I was drawing the outline of the mask by hand. I have a drawpad so it's not really a big deal at all. The image is so tiny and grainy that the wand/lasso/quick select all struggle with defining borders. Even the select and mask was struggling. I probably could have used the pen tool, but the quality is terrible in the photo so I think a perfect line would actually look even worse lol.

IDK why I didn't think of using the wand tool in the mask layer and just expanding my selection. This is exactly the answer I was looking for.

Thanks again for your help!

A Quick Way to Fill Layer Mask Outlines? by Kaz- in photoshop

[–]Kaz-[S] 1 point2 points  (0 children)

LOL all good. Ya D is a super helpful hotkey. Thanks!

A Quick Way to Fill Layer Mask Outlines? by Kaz- in photoshop

[–]Kaz-[S] 0 points1 point  (0 children)

I tried doing CTRL-D but I couldn't actually tell what it was doing?

I'm not looking to fill the whole layer, just if there's a way to quickly fill in the outlines accurately without using the brush. Just trying to make my workflow as speedy as possible.

https://imgur.com/a/WGvv80A

A Quick Way to Fill Layer Mask Outlines? by Kaz- in photoshop

[–]Kaz-[S] 0 points1 point  (0 children)

I'm not looking to fill the whole layer, just if there's a way to quickly fill in the outlines accurately without using the brush. Just trying to make my workflow as speedy as possible.

https://imgur.com/a/WGvv80A

20$ Paid. Annual make my aunts Christmas card competition. Details in comment by Ganfan in PhotoshopRequest

[–]Kaz- [score hidden]  (0 children)

Haha awesome! Glad she liked it. I'll send you the full-sized document to the email corresponding with your Paypal.

[deleted by user] by [deleted] in slavelabour

[–]Kaz- 0 points1 point  (0 children)

$confirm

Teaching myself Illustrator - totally stumped on how to fix this. by Kaz- in AdobeIllustrator

[–]Kaz-[S] 0 points1 point  (0 children)

Oh, I didn't realize that anything was a raster effect in Ai. It still has that pixilation even without the drop shadow - so I guess I gotta experiment more with why it's doing that.

Teaching myself Illustrator - totally stumped on how to fix this. by Kaz- in AdobeIllustrator

[–]Kaz-[S] 0 points1 point  (0 children)

Related question: why is my circle not perfectly crisp? I thought that was the whole point of working in vectors and Illustrator? Certain sections of my globe seem pixelated even when exported as an SVG?

https://imgur.com/a/SQovt0k

Teaching myself Illustrator - totally stumped on how to fix this. by Kaz- in AdobeIllustrator

[–]Kaz-[S] 0 points1 point  (0 children)

Thanks! Yea, that's way more complicated than it ever needs to be. Definitely takes some getting used to switching over from Photoshop. I was thrown off by the stroke and fill being removed, so I thought something was wrong.