How do you underclock RAM?
I've purchased an AMD A10 7850K with a Gigabyte GA-F2A88XM-D3HP and 8GB 2400MHz Corsair RAM for my computer. The problem is that the AMD A10 7850K doesn't support RAM at 2400 MHz, so I'm trying to underclock it to 2133 MHz, which is supported. At 2400 MHz, the computer frequently gives BSOD errors, ...
Getting Excel to Conditionally Copy Data to Another Sheet
I have a spread sheet that will have new data entries on each row. I need to get excel to automatically check for a specific column's value, and if that value is a 1, it needs to go to the sheet with the same title as the column. See this below image for an example; Example So there are 6 columns I ...
WMIC in for-loop
I'm trying to get WMIC output into a variable so I can process it further. I have made a test batch file to illustrate the problem: wmic PROCESS where "commandline like '%%teststr%%'" get Processid,Caption,Commandlin but ´ for /F "usebackq" %%R in (`wmic PROCESS where "commandline like '%%teststr%%'...
Get certain parts of command parameters from ps -ef using grep
I need help building a grep from ps -ef to retu only java paths. Say we have the following ru ning process: bash> ps -ef | grep java user pid# 1 1 00:00 ? 00:04:00 /path/to/java/jdk_1.8/bin/java -foo=bar -foo2=bar2 ... etc. What i was from this is to display: bash> ps -ef | grep 'some regex or patte...
Is coLaboratory notebook still working?
I just downloaded the coLaboratory notebook Chrome app, as I'm looking for an easy and private way to allow non-technical people to see and play with a Jupyter notebook. However, when I try to launch the app and run a file from my Google drive it hangs on 'loading' forever and nothing ever happens. ...
excel spreadsheet for flange size selection
I have a spreadsheet with a drop down cell (B7) which has 4 values, each of which appear in a table on separate cells (H3,H4,H5,H6), values are 1.2.3.4 (covered by the formula below=IF(B7=H3,"1", IF(B7=H4,"2", IF(B7=H5,"3",IF(B7=H6,"4")))) Then I need the user to input in a separate cell a dimension...
recommended battery for 750 watt ups
It depends on the voltage of the battery. Use the following formula to calculate the voltage. volt = watt / amp or V = W / A For a 750W UPS hooked up to a 175A battery, the battery would have to supply at least 4.3V, so either a 6V, 175A battery or a 12V, 175A battery would supply enough power to ru...
Driver needed during windows installation
I just lately bought an Lenovo T560 and replaced the ssd with an samsung 850 pro ssd 512gb. Now I am trying to install windows 7 on it via usb and it works until I come to the partition part. My Laptop can't find the ssd and asks for a driver. I was looking for a driver the last couple of hours but ...
Hosting more than 1 website through 1 public IP
I have 2 websites e.g: http://abc.xyz.co.in and http://123.xyz.co.in:8089 hosted in a single physical server(Windows Server 2012) in port 80 and 8089. The server is in MZ zone and it is behind Exte al DNS, load balancer,firewall etc. My xyz.co.in domain is resolved into a public IP say: 11.22.33.44....
Retrieving windows License key
I have an older Toshiba R-800 laptop that's dying. Before I dispose the laptop, I want to recover the Windows License key. This laptop was given to me at my previous workplace and at some point, they might have replaced the OEM windows installation with an installation of Windows Enterprise (I think...
OS in a network computers
Hy everbody ! I have a networked computers that i have implemented the windows operating system at both the server and at stations. I would like to pass on to future operating system Linux, both on workstations and servers.I would like to advise me what version of Linux I use, which is more stable a...
difference in two strings by substring search
Do you think it is possible with notepad++ to do difference of two strings on a substring level?? Check if any element from list1 exists in list2. If so remove it. At the end retu only those unique list1 - "a" "b" "a" "a" "c" "f" "g" list2 - "a" "c" "a" "f" ------------------- result - "b" "g" list1...
How to merge live video and audio streams
I'm sending a live stream of bitmaps to ffmpeg through standardin like this: proc.StartInfo.Arguments = "-rtbufsize 1500M -f image2pipe -r 25 -i pipe:.bmp -vcodec libx264 -r 25 C:\test.avi"; The resulting video saves and plays with no problems. I want to add audio while the bitmaps are streaming, so...