Sunday, 27 October 2019

Dual monitors on Windows - How do I set a different DPI or text size on each monitor?

My laptop is a 15" wide screen running at 1600x1050, and in addition to that I connect an external 19" LCD which runs at 1280x1024. The problem with this setup is that if I increase the text size to make the laptop screen readable, the text on the external LCD is huge. Normal text on the LCD results in tiny text on the laptop.


What options do I have to get around this?

Windows 10 unable to boot, failure to repair loop-refer to srttrail.txt inside

UDPATE2: This has been SOLVED by following this video: https://www.youtube.com/watch?v=2f-GorXWkoc


It shows how to copy the registry hives from the Regback folder to the config folder. The Regback folder contains backups of the Registry Hives in the config folder which may have been corrupted during the update.


UPDATE: I have an AMD processor. dism.txt output pasted here: https://pastebin.com/XLuLQpc0


ISSUE: We have a relatively new (couple months) Windows 10 HP Computer that was suddenly unable to boot into the OS. Unable to enter Safe Mode. Automatic Repair failed. System Restore failed.


After trying a bunch of solutions, Self-Repair system referred an srttrail.txt file to me, which I copied to a drive and have posted below. I'm not sure what to glean from it. Can anyone else:


Session details


System Disk = \Device\Harddisk0 Windows directory = C:\WINDOWS AutoChk Run = 0 Number of root causes = 0


Test Performed:


Name: Check for updates Result: Completed successfully. Error code = 0x0 Time taken = 0 ms


Test Performed:


Name: System disk test Result: Completed successfully. Error code = 0x0 Time taken = 0 ms


Test Performed:


Name: Disk failure diagnosis Result: Completed successfully. Error code = 0x0 Time taken = 47 ms


Test Performed:


Name: Disk metadata test Result: Completed successfully. Error code = 0x0 Time taken = 1656 ms


Test Performed:


Name: Disk metadata test Result: Completed successfully. Error code = 0x0 Time taken = 47 ms


Test Performed:


Name: Target OS test Result: Completed successfully. Error code = 0x0 Time taken = 187 ms


Test Performed:


Name: Volume content check Result: Completed successfully. Error code = 0x0 Time taken = 469 ms


Test Performed:


Name: Boot manager diagnosis Result: Completed successfully. Error code = 0x0 Time taken = 0 ms


Test Performed:


Name: System boot log diagnosis Result: Completed successfully. Error code = 0x0 Time taken = 16 ms


Test Performed:


Name: Event log diagnosis Result: Completed successfully. Error code = 0x0 Time taken = 78 ms


Test Performed:


Name: Internal state check Result: Completed successfully. Error code = 0x0 Time taken = 31 ms


Test Performed:


Name: Check for pending package install Result: Completed successfully. Error code = 0x4 Time taken = 2422 ms


---------------------------

battery - Can I charge my laptop with a charger that has different specifications?


I'm using a common charger for both of my laptops.


The charger is specified at 20 Volts and 3.25 Amperes. My other laptop has a specification of 19 V and 3.42 A.


Is it safe to charge my laptop with chargers whose specifications exceed or are not equal to the mentioned specifications?


I have read somewhere that it may cause some damage if the voltage or amperage is not matching the specs.



Answer



Using a charger with the wrong voltage rating can potentially damage your laptop. This is typically caused by too high voltage. But using a charger with too high current won't damage your laptop. Using a charger with too low current rating might fry the power supply, but not the laptop.


As the difference in voltage in this case is small, it should be OK. But I really doubt that anyone would stick their neck out and guarantee this. I believe it should be OK because your laptop will [most likely] have circuitry in it which will filter and regulate the voltage on-board - it must do this to charge the battery, and 1 volt is not a big deal to most of these kinds of circuits. It's probably not ideal though.


uefi - How to delete OS from boot menu


After installing fedora and Centos and other OS now I have them all showing in my Boot menu [F2] on start up not the menu form the OS even after deleting them and reinstaling other OS - Ubuntu -so It just shows one when the OS starts but when I go to UEFI setting I still find all the old ones they instruct you to use DEL to take them out but that does not work



Answer



The menu to which you refer is the firmware's built-in boot manager. Its entries are stored in NVRAM, and can be edited by any number of tools in various environments:



  • Some EFIs provide a means to do this via their setup utility. Details vary from one system to another, though, and many don't permit you to add or delete boot manager entries.

  • The EFI version 2 shell provides a command called bcfg that can do the job. You'd need to do bcfg boot dump -b to see the entries, then bcfg boot rm # to delete entry number # -- # must be the number associated with whatever entry you want to remove.

  • In Linux, efibootmgr can do the job: Type efibootmgr or efibootmgr -v to see the entries, then do efibootmgr -b # -B to delete entry #. (You must type these commands as root or using sudo.)

  • In Windows, the EasyUEFI tool should be able to handle the job, although I've only toyed with it briefly, so I can't give detailed instructions.


Be aware that in any of these cases, you may have leftover files on your EFI System Partition (ESP). You can delete them through normal file-manipulation commands, although depending on your OS, you may need to explicitly mount the ESP. If they aren't referenced, the files won't do any real harm, unless they consume so much space that they prevent you from installing another OS or updating your boot manager. The files will normally be stored in subdirectories of the EFI directory on the ESP; most OSes create subdirectories named after themselves or the companies that create them, such as EFI/ubuntu for Ubuntu or EFI/Microsoft for Windows.


worksheet function - Excel, want to read a column and sum up the values that match in another column


I have the table below and i want it to read through columns A-B and then sum the values that match their names in columns C-D.


So that in a column elsewhere of a list of names i have the sum of their values from this table. For example Ed features in both columns with a value of 1 and 3, so would return a value of 4. Struggling to get this to work nicely. My actual table consists of 4 columns names and two sets of 4 columns with numbers.


Screenshot


A       B       C   D
Steve Jeff 4 1
James Calum 1 1
Alex Andy 2 1
Peter Ed 0 3
Owen Harry 1 2
Jeff Steve 4 1
James Calum 1 1
Andy Alex 2 1
Peter Owen 0 3
Ed Harry 1 2

Answer



You can use SUMIF, e.g.


=SUMIF(A:B,"ed",C:D)


replace "ed" with a cell value which contains your name, e.g.


With names in F2 down use this in G2


=SUMIF(A:B,F2,C:D)


SUMIF works on a 1 to 1 basis so this only sums column C when column A matches and sums column D when B matches


You can also use where ranges are 4 columns wide


shell - Sed replace line stored in a variable

I need to find a line that starts with mysql.unmetric.twt.url and replace the entire line with line stored in the variable ip.


ip="mysql.unmetric.twt.url=jdbc:mysql://ec2-a-b-c-d.compute-1.amazonaws.com:3306/unmetric? jdbcCompliantTruncation=false&useUnicode=yes&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true"

How can this be achieved using sed?

windows 7 - Win7 cannot sleep because of GRUB

I have Win7 on an MBR HDD for 6 years now, that was my primary operation system, but I intend to use Linux instead.


sdb


At least I am trying out several Linux distros on another HDD, which I set to GPT from Windows.


sda


That HDD is sda, so by booting first the GRUB menu starts, and I can select Windows 7 booting from sdb if I want.


After a while I noticed that I cannot put Windows 7 in sleep mode, it logs out, but nothing happens after that. I am not sure whether this had been the situation in the beginning (1.5 months ago) of this multi boot experiment or I got this "feature" later.


I checked the sda and noticed that I have 2 small partitions. One is unknown with msftres flag, and one is the fat32 I created for GPT booting. I got a screenshot from that:


partitioning


I am pretty sure I wanted to have only a single ~250MB FAT32 partition for GPT booting, but the installer created 2 partitions. I pressed the back button, because I forgot to add the biosgrub type (and I read somewhere that it is needed for GPT booting) and I made this screenshot then. I think I did not notice that I have 2 partitions, not a single FAT32, because I was concentrating on taking screenshots.


Now my question is that is there a chance, that these 2 partitions cause that Windows is not capable of sleeping? If not, what can possibly cause this kind of problem?


Edit:


I attached the BIOS power management settings: bios power


As far as I understand S3 should be enough, so the problem is not there.


I removed every pendrive, so USB devices does not cause the issue. Sleeping worked for 6 years with the current mouse, keyboard, monitor and UPS, so their USB connections are not the cause.


I checked with GRUB Win7 loader and BIOS F12 direct boot. The problem occurs only with GRUB. So the following statement of Christian Isaksson



No, partition layout and/or GRUB has nothing to do with Windows sleep mode.



is not true.

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...