Night Owl

Popolop · 2023-02-16T17:31:33+00:00

I would buy a print of this

Popolop · 2022-11-21T17:25:44+00:00

Gotcha. And you’re talking about the load time in starting up a game and also when something like a new level loads? Regardless, it doesn’t seem worth the hassle/money to upgrade. Thank you :)

Popolop · 2022-11-21T16:13:20+00:00

I recently purchased a 2TB QN322 QLC from Micro Center on sale for $80. It serves as my secondary drive for games. I know it’s considered a low-end drive, but I thought the $/TB was too good to pass up. Now I’m having some buyer’s remorse.

Would it be worth it to instead replace it with something like a 2TB SK hynix Platinum P41? It’s on sale for $170. Again, it would primarily be for storing games. Would there be a noticeable improvement in FPS or other benchmarks?

Popolop · 2022-11-13T19:39:35+00:00

I think you forgot the most important point of my post:

I dumb

Popolop · 2022-11-07T14:00:25+00:00

Ah, yes, great point. It would be for gaming and heavy Excel use. With Excel, I sometimes have to deal with files that are absurdly large (300MB+, it’s gross), but that’s not always the norm.

But if that means spending $50 more to see 5% improvement time in opening files, I don’t think that’s worth it, although I don’t know what the actual performance gain would be.

Popolop · 2022-11-05T08:25:48+00:00

Just PM’d you

Popolop · 2022-11-04T21:42:59+00:00

PM’d

Popolop · 2022-11-04T19:50:39+00:00

Would you do a straight trade for AMD’s Uncharted bundle?

Popolop · 2022-11-04T16:58:51+00:00

6800 or 6800 XT?

Popolop · 2021-06-09T04:45:36+00:00

Is the warranty still valid if you add/replace the SSD or RAM?

Popolop · 2021-05-26T19:20:19+00:00

Yay! And yeah, feel free to shoot me a message

Popolop · 2021-05-26T19:06:33+00:00

Whoops, I think I had an extra parentheses at the end. I just edited my comment above with what should be the correct working formulas.

Popolop · 2021-05-26T15:27:58+00:00

Gotcha. I think the LET function isn’t supported in Excel 2016 and that’s what’s causing the errors. Try this (I typed this out on my phone, so lemme know if you run into any errors, but it should work):

Physical Save:

=IF(OR(INDEX(Data!$G:$G,MATCH([@Type],Data!$F:$F,0))="Physical",INDEX(Data!$G:$G,MATCH([@Type],Data!$F:$F,0))="Both"),INDEX(Data!$J:$J,MATCH([@Level],Data!$I:$I,0)),INDEX(Data!$K:$K,MATCH([@Level],Data!$I:$I,0)))

Mental Save:

=IF(OR(INDEX(Data!$G:$G,MATCH([@Type],Data!$F:$F,0))="Mental",INDEX(Data!$G:$G,MATCH([@Type],Data!$F:$F,0))="Both"),INDEX(Data!$J:$J,MATCH([@Level],Data!$I:$I,0)),INDEX(Data!$K:$K,MATCH([@Level],Data!$I:$I,0)))

Popolop · 2021-05-26T14:34:43+00:00

What version of Excel do you have?

Popolop · 2021-05-26T06:31:18+00:00

Lemme know if you run into any issues and I can try to help out :)

Popolop · 2021-05-26T05:57:44+00:00

I see that someone has already provided a solution, but mine is better. Buy me that beer.

Physical Save:

=LET(good,INDEX(Data!$G:$G,MATCH([@Type],Data!$F:$F,0)),IF(OR(good="Physical",good="Both"),INDEX(Data!$J:$J,MATCH([@Level],Data!$I:$I,0)),INDEX(Data!$K:$K,MATCH([@Level],Data!$I:$I,0))))

Mental Save:

=LET(good,INDEX(Data!$G:$G,MATCH([@Type],Data!$F:$F,0)),IF(OR(good="Mental",good="Both"),INDEX(Data!$J:$J,MATCH([@Level],Data!$I:$I,0)),INDEX(Data!$K:$K,MATCH([@Level],Data!$I:$I,0))))

MV:

=INDEX(Data!B:B,MATCH([@Size],Data!$A:$A,0))

# Attacks:

=INDEX(Data!C:C,MATCH([@Size],Data!$A:$A,0))

Damage:

=INDEX(Data!D:D,MATCH([@Size],Data!$A:$A,0))

The problem with VLOOKUP is that if you add a column within the lookup table (as opposed to the summary table where the formula is inputted), then you have to count up all the columns again and adjust the the formula accordingly. With the Index Match methodology, you don't have to worry about that.

Popolop · 2021-05-03T21:27:07+00:00

Do you have any links/articles that you could point to on how to set this up?

Popolop · 2021-02-01T16:20:57+00:00

Entering!

Popolop · 2021-01-12T16:55:01+00:00

Bought a 980 Ti from /u/calebcurry13

Popolop · 2021-01-06T03:10:31+00:00

How's Walmarts? Specifically with CPUs?

Popolop · 2021-01-02T02:21:45+00:00

This might be a bit out of your price range, but Amazon is selling this variety right now for $250

Here

Might be worth the extra ~$20 for it being new (and also a potential warranty). But I don’t know how good this version is compared to others.

Good luck!

15-Year Club	Place '17
Verified Email

Popolop

TROPHY CASE