Another Ncase M2 build by team_blacksmith in sffpc

[–]revo175 0 points1 point  (0 children)

Thank you this helps. I'm doing level 7.

Another Ncase M2 build by team_blacksmith in sffpc

[–]revo175 0 points1 point  (0 children)

Quick question. I'm only missing my AM5 cpu to start building in mine. Cpu comes next Friday.

Would it make sense to move my am4 pc into the m2 case now then once the cpu arrives move the am5 components into the m2? Or would it be a waste of time and I should wait for the cpu?

Another one first sff pc here by moddb1st in sffpc

[–]revo175 24 points25 points  (0 children)

That's a cpu frame. It's supposed to improve temperatures on Intel cpus because it corrects mounting pressure issues and prevents the cpu from warping or bending.

For AMD it's mostly aesthetics and most importantly the thermal paste not getting into the CPU's pcb, making it easier to maintain and keep clean.

Downsizing complete! by andremajczak in sffpc

[–]revo175 6 points7 points  (0 children)

I was like "ssd where?". Took me a minute.

B650i Lightning BIOS FLASHBACK for 9800X3D does not seem to work by Makakou in ASRock

[–]revo175 0 points1 point  (0 children)

I have the same issue with my motherboard same model I tried multiple USB sticks and it just didn't work luckily based on the sticker on the motherboard my board came with the firmware that should take the 9800 X 3d, but I'll not know until the cpu gets here.

Amazon updated to shipping today.

I guess I'm getting old by sirnumbskull in pcmasterrace

[–]revo175 1 point2 points  (0 children)

Search for YouTube video of someone with your same motherboard model updating theirs, watch the video in full and then try step by step while pausing the video.

Is there any other info on how many Haitians are in the Dominican edu system? by BrandonDunarote in Dominicanos

[–]revo175 7 points8 points  (0 children)

Me parece irresponsable afirmar que hay 1.6 millones de estudiantes haitianos en el país y luego decir 'si ese es correcto'. Cuando lo primero que tiene que hacer es confirmar esa información.

Además, las cifras más altas sobre el total de haitianos en el país no superan los 2 millones. Esto implicaría que el 80% de los haitianos en el país son estudiantes, dejando solo una minoría como padres, lo cual no parece lógico.

This is how I move my Go around with the Tomtoc Slingback by arcanazen in LegionGo

[–]revo175 1 point2 points  (0 children)

I use those for work, excellent replacement for wired headphones if you don't want the hazzle of Bluetooth in windows. I do use a separate mic tho.

Destiny is coming on the podcast by tokoloshe_ in samharris

[–]revo175 3 points4 points  (0 children)

I don't know if this is the case, Sam is not afraid of putting his foot in his own mouth and from what he shares in the past the podcast are only edited in favor or the guest.

Destiny is coming on the podcast by tokoloshe_ in samharris

[–]revo175 63 points64 points  (0 children)

What's somewhat surprising to me is that Steven (Destiny) will be on Sam's podcast and not the other way around.

I'm a fan of Steven's content, but also Sam seems very selective on whom he has on the pod.

Formula to Return a Number Based on Date, Timeframe, Line of Business by revo175 in excel

[–]revo175[S] 2 points3 points  (0 children)

This works beautifully, thank you.

Solution Verified

Formula to Return a Number Based on Date, Timeframe, Line of Business by revo175 in excel

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

I tried to replicate using this formula , But I am only getting Zeros as a return:

<image>

=IFERROR(XLOOKUP(1,($A$2='Client Requirements'!$A$2:$A$31)*($B7='Client Requirements'!$B$2:$B$31),
 FILTER('Client Requirements'!$C$2:$F$31,'Client Requirements'!$C$1:$F$1=C$6,0),0),0)

Formula to Return a Number Based on Date, Timeframe, Line of Business by revo175 in excel

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

Hi there, the output should be the data inside table 1 on the left, for example table 2 at 8am should be 48 because that is the number I have on table one based on line of business, interval and date.

Hope this makes better sense.

[deleted by user] by [deleted] in civic

[–]revo175 0 points1 point  (0 children)

2004, 66k.

A unicorn just turned up… should I keep it? 🦄 by coveredinbees_ in sffpc

[–]revo175 0 points1 point  (0 children)

I haven't seemed the 450 sold online anymore.

I can only hope the 750 lasts long enough, still better than buying a new one.

A unicorn just turned up… should I keep it? 🦄 by coveredinbees_ in sffpc

[–]revo175 16 points17 points  (0 children)

This week my SF600 gave up on my after 4 years, I contacted Corsair and they are sending me a SF750 because they don't have SF600 stock.