All Activity

So about the pc i just upgraded the HP COMPEK ELITE 8300 MICROTOWER VERSION . So uh one problem about this pc is the fucking heatsink make me so mad. Like i got an asus gtx 750 2gb dual fan. The fan isnt fitting so i decided to take off and put behind of the heatsink and boom its fit because the HEATSINK IS SO SO SHIT. never buy prebuild hp pc but i got no choice because it have i7-3rd gen before the its sold out. Somebody said u can turn cooler heatsink to 90 degree. Is there anything that i can upgrade from this shitty PROPRIETARY cooler. If i was at dell side i able to do something with space and good upgrade cus dell know they customer than Hewlett DICKARD. So guys can be upgraded with special hp mobo ? Pls tell if theres no solution im screwed up for not buying smaller lp gpu size

Thanks

The laptops i have used will show bios on the external monitor, but the lid of the laptop has to be closed. Turn it on, close the lid, reboot with ctrl+alt+delete? UEFI makes the whole install os - move drive more difficult, somehow you would need to tell the UEFI that drive has an os on it. Windows has some funky mechanism to automatically add its boot entry when moving drives between machines but grub has no such thing (as far as i know). If the laptop booted from a usb on its own, you could do a headless install. You can test if it booted by pushing the power button - if it shuts down instantly with a short press, it was probably stuck in UEFI. If linux was running it would take a few seconds to shut down.

Sony putting the managed in managed democarcy

So it seems it was related to the RAM, pulled two sticks out and the PC wouldn't boot up, the MB would show Q code 00 and the boot process wouldn't finish. So I then inspected the serial numbers and discovered that they are almost the same but one set finishes in 21 and the other in 20, so I just plugged in the one set that ended in 20 and so far no crashes have happened, I suspect that the ram might have been wrongly positioned, instead of 1a 2a, 1b, 2b it was 1a 1b, 2a 2b. I haven't yet put in the rest of the ram, but I will test that soon.

I think he's referring to the really strong ones, like the Delta I listed, and the Young Yi Snowfan, both of which are so power-hungry that none of my FCs can handle them.

I was wondering if your team could make a video on how to make an easy home server where you can safely store family pics and/or videos but also make it easy for the non-techie people in your family to access and upload files to share with the rest of your family and friends. (maybe 2 part vid 1 the build and 1 the software??) I like OneDrive, Google, Amazon and other cloud services but I don't always want to upload all my personal content to an online service where I feel like they will likely try to use profiling software or face recognition to tie to other people or perhaps link to social media services/marketing. Love what y'all do. Thx!

BambuLab A1 mini. Without the AMS it is $280.

Apples to oranges though. Lets say Sapphire's cooler was undisputedly better than the inno3d, but the AMD GPU in question has similar TDP to the R9 390X. Would you still advocate a change of GPU on the merits of just the cooler?

It can be really difficult, I have problems throwing things out or giving them away, because I rationalize keeping things like old computers because 'what if' there's a time I need it. Case in point: The server at my office nosedived some years back and I had to get something back in service over a weekend, and I had all the parts at home to make it happen. It's probably just reinforcing bad habits, but the way I see things is it saved my bacon many times, so in the back of my mind I always wonder if tossing something will put me in a jam later. It doesn't help that I'm the repair guy in my immediate family and for many of my friends in terms of computers, cars, motorcycles, and even bicycles, so I've accumulated so much stuff over the years it's ridiculous. So the answer to the question of which stuff do I keep? Seemingly everything, haha.

Best part about 12th gen intel to me is how good quicksync is while being very competitive in general cpu performance. I see absolutely no point in buying an intel cpu without an igpu. The encoding is so good on it I can record and stream 4k footage without it even breaking a sweat, with quality that meets or exceeds my 3070.

fair point

huh? their the same price there? the one with a 13th gen i9 and a 4070?

Ah, my mistake For the GPU, I would just buy 2-3 different thickness and start with the thinnest. Place the pads and mount the cooler. Unmount the cooler and look for an impression on every pad Those that do not have an impression, replace with a thicker pad Repeat steps 1-3 until there is an impression on every pad Often the ideal situation involves use of pads of varying thickness, as you might have noticed when disassembling the card for the very first time

Am I right in assuming that the data in those CSV files is a single line of values? If that's the case, I'd suggest splitting it into an array in your VBA code, instead of relying on formulas to do the splitting. Also, I don't see a reason why you're trying to import the data into this file and save it as an .xlsx file. The easier way is to just create an .xltx template that has all the column headers populated, add a new file based on that template, aggregate the data from those CSV files into that new workbook and save that as an .xlsx. Something like this: Sub Import_CSV_Files() 'Turns off drawing the file contents to the screen, speeding up the process Application.ScreenUpdating = False 'Create a new file to aggregate the contents of the CSV files 'First you need to create an Excel template file that contains the desired column headers Dim targetFile As Workbook Set targetFile = Workbooks.Add("C:\Example\template.xltx") 'Folder where all your CSV files are located Dim filePath As String filePath = "C:\Example\CSV files\" 'Fetching the first file in the folder specified above Dim fileName As String fileName = Dir(filePath) 'Loops through all the files in the folder specified above Do While Len(fileName) > 0 Dim csvFile As Workbook Set csvFile = Workbooks.Open(filePath & fileName) 'Load the data stored in the first cell into an array 'Assumes the data is separated by ; 'If not, change the delimiter to whatever type your files use Dim data As Variant data = Split(csvFile.Sheets(1).Range("A1").Value, ";") csvFile.Close SaveChanges:=False 'Define the range in the target file where the stored data should be copied into. 'Range("A1048576") is the last possible row of an Excel sheet 'End(xlUp) jumps up from the last possible row to the last one filled with data 'Offset(1) moves one row below, to the first empty row in the file 'Resize(1, Ubound(data) + 1) expands the range to the number of columns determined by the copied data in the array targetFile.Sheets(1).Range("A1048576").End(xlUp).Offset(1).Resize(1, UBound(data) + 1).Value = data 'Fetch the next file in the folder fileName = Dir Loop targetFile.SaveAs fileName:="C:\Example\Output.xlsx", FileFormat:=xlOpenXMLWorkbook targetFile.Close Application.ScreenUpdating = True End Sub Also, on a more general note, when you write these routines, get into the habit of declaring your variables where you need them. You tend to have declaration blocks right at the top for everything, which, coupled with the terse names of your variables, makes it hard to understand what types they are and why you've used them. Especially since you rely too much on the object datatype, instead of using more appropriate ones. Like when you want to refer to a workbook, define the varible as a workbook. That way you also get the autocomplete feature for the methods of that type.

not bad either, it will easily cool any amd chip, imo the deepcool ones look better but if you like its a nice cooler

since it's labeled "wwan" too, i presume it's either for an SSD, or for a 4G modem.

Cooler Master MasterLiquid ML240L ARGB V2 Liquid Cooler What about this one

Almost like he was wanting to switch to a 7800xt by sapphire.

I agree. I would pay a million dollars if someone could bring me a 4070 Super that is officially released by Sapphire

Switch the CPU to one with quicksync and use that to offload to OBS. Much more power efficient and less conflict with drivers. 10th gen intel quicksync will absolutely cream the encoding quality on your ancient 1050.

Asus one

This is GPU repadding. Usually for VRMs and such.

Any way use Galaxy Tab S9 Ultras as second screen for PC ? I tried Samsung second screen but is very bad and impossible to work at all not even possible scale to full screen and it have massive lags. As well battery drain is abnormal with samsung second screen.