Saturday, September 29, 2018

PC rescue instructions

https://kb.acronis.com/content/60131?build=13660&edition=0&gaID=234071240.931830426&language=1&sn=G2YLNMNR-8H23CHFF&winver=10.0

USB monitor not waking up

https://www.startech.com/faq/usb-video-adapters-windows-usb-sleep-mode

If the display connected through your USB display adapter does not wake up after your computer has been in extended hibernation, it is likely that Windows has automatically turned off the USB Root hub to save power.

The steps below outline how to configure the USB root hub to stay on during hibernation, to prevent this from happening.
Windows 8 / 10
  1. On your keyboard, press the Windows key + X and select Control Panel.
  2. Click Hardware and Sound, then click Power Options.
  3. Click Change plan settings for the plan you want to change.
  4. Click Change advanced power settings.
  5. Click the plus sign (+) next to “USB settings” and “USB selective suspend setting” to expand the options and change the setting to Disabled.
  6. Click OK to apply the setting.
Note: You may need to disconnect and re-connect your USB display adapter after applying these settings to re-establish the connection.

Saturday, September 15, 2018

filter lines in a text file


File.ReadLines("c:\test.txt").Where(x => !x.StartsWith("xYz--"));
File.ReadLines("c:\test.txt").AsParallel().Where(x => !x.StartsWith("xYz--"));

Thursday, September 6, 2018

How to insert picture to Google Sheet to have it show up in the cell

In the Google sheet cell type like following

=image("https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsqXLO_m3Do-XLeNyV3lk06wHN73C3b2qTm98I1n4ZFl9Fde34GOevVgHuTK0PpRE6dr5gCG6o2DRAIE5fnoLlwUHxYcyowDNuzPYJzGu05qpjncjiAHFW9eVC5aYzMAhFrr4mpD6ruHMy/w945-h600-p-k-no-nu/door.JPG,4,300,300)")

URL must be have picture extension at the end. I just use Blogger posts which has the picture and copy the image link address

4,300,300)

4 must be used if need to specify width and height in pixels