Stop MS Edge running in Background MS Edge Navigate to: edge://settings/?search=startup or go to Settings and search for startup. Uncheck “Startup boost”. Uncheck “Continue running background extensions and apps when Microsoft Edge is closed”.

Formula for converting Excel Column Number to Column Name (Column Number specified in B1): =SUBSTITUTE(ADDRESS(2, B1, 4), "2", "") Formula for converting Excel Column Name to Column Number (Column Name specified in B2): =COLUMN(INDIRECT(B2&"1"))

Windows - Open Settings via CLI (command line interface) Wn+R to open Run window Can paste command here or type in cmd and press enter to open command window start ms-settings:

Vim Useful Commands List - 1 Command Description i insert - insert new text before cursor x delete current character X backspace delete previous character i insert - insert new text before cursor x delete current character X backspace delete previous character u undo Escape change to command mode o new line below O new line above dd cut current line dw cut current word p paste before P paste after /[search_string] find [search_string] n next result N previous result /( find next opening parentesis % jump to matching parentesis ci( change all text inside brackets () di( delete all text inside brackets () w next word Ctrl-D move down a page (around 15 lines) Ctrl-U move up a page (around 15 lines) :new [filename] open a new [filename] to edit (can {tab} to see list) Ctrl-w w switch down between windows / buffers Ctrl-w W switch up between windows / buffers Ctrl-w N Convert terminal into a “normal mode” buffer :ls list opened buffers / files opened for edit :wa write all - save all opened files :bd buffer delete - to close current buffer :term opens terminal in separate window yw yank / copy word yy yank / copy line

Create Application specific password for Google Starting 2022-05-30 Google is no longer supporting less secure apps. Please use below steps to turn on App password for your google account. Login to your Google email at https://gmail.google.com. Navigate to https://myaccount.google.com/signinoptions/two-step-verification. Enable “two step verification”. Create application-specific password via https://security.google.com/settings/security/apppasswords. Save a 16 digits App password that can be used by specific app using your Google email address.

Fix Bad Owner / Permissions for SSH Config in Windows 10 Error: Bad Owner or Permissions on SSH Config Resolution: Folder should only be accessible to SYSTEM and your logged in user Steps: Navigate to %USERPROFILE% in Windows Explorer Right-Click on .ssh folder and choose Properties Click on Security tab. It should only show your account and SYSTEM under “Group or user names”. If not, here are the steps to take: Click Advanced button Click Disable inheritance button and Convert inherited permissions into explicit … Select and Remove any Principal in the list EXCEPT FOR your account name and SYSTEM Click OK and then OK on the Properties window You might perform similar steps on the all of the files in %UserProfile%\.ssh folder If you run OpenSSH SSH Server, you might need to restart it in the services.msc

Raspberry Pi Headless Server from Scratch WHY Since ISP (Internet Service Provider) started to change public IPs at will, I wanted to have sort of a control center network appliance that would monitor things like Public IP changes and possibly other things (like speed tests, checking if certain external sites are up, etc.) utilizing existing, unused, and, probably soon, outdated hardware. WHAT Raspberry Pi 1 Model B+ Board Clear acrylic case for RPi Model B+ 8GB SD card Old iPhone 1A adapter (works fine for Model 1b) Micro USB to USB Cable RJ45 Ethernet cable HOW Prepare RPi SD Card Download Raspberry Pi OS Lite (at the time of writing Kernel version 5.00 released on March 4th 2021) Download Balena Etcher or similar software to copy image to SD card (Raspberry Pi Imager did not work for me but was my first choice) Plug SD Card into your Windows / OSX / Linux host machine and copy downloaded image to SD Card Navigate to the SD Card (you might have more than one drive mounted / available under windows) and create an empty file named ssh (this will ensure that SSH server on headless Raspberry Pi (RPi) will start on the first boot) First Time Setup On windows I have download and installed wonderful Cygwin that provides a large collection of GNU and Open Source tools to provide functionality similar to a Linux distribution on windows. If using Windows 10, you might want to look into much heavier but “out of box” option called WSL2. Unmount SD Card and plug it into RPi (via SD adapter if required), plug in RJ45 for wired internet connection (other side should go to your router), and then plug in Power cable. RPi lights will be lit. Identify an IP address of newly built RPi using either your Router’s DHCP list of IPs – RPi MAC addresses would start with B8-27-EB or use one of the utilities like Adafruit Pi Finder, nmap, Angry IP Scanner (try older version with a single executable ipscan.exe), or just type in something like “ping -4 raspberrypi.local” at the command prompt. Sample Naming RPi hostname: raspberry ==> headless_horseman RPi IP Address: 192.168.1.123 SSH Port: 22 ==> 7522 Sample Sudo User / Pass: mysudouser / Pwd.926! Sample SSH User / Pass: mysshuser / T3n.F0ur! SSH Public key file on Host machine: ~/.ssh/id_rsa-headless_horseman.pub First Time Login Using Cygwin or WSL2 (from windows) or Terminal (on OSX / Linux), connect to RPi (default user “pi” with default password “raspberry”): user@host $ ssh pi@192.168.1.123 ...

Prompt: [2020-03-13][23:49:21] [pi@raspberry:~] Add at the end of ~/.profile ##### modify standard command prompt # \n = new line; \u = current username; \w = current working dir (home = ~) ##### Colors # Black 0;30 Dark Gray 1;30 # Blue 0;34 Light Blue 1;34 # Green 0;32 Light Green 1;32 # Cyan 0;36 Light Cyan 1;36 # Red 0;31 Light Red 1;31 # Purple 0;35 Light Purple 1;35 # Brown 0;33 Yellow 1;33 # Light Gray 0;37 White 1;37 export PS1="\[\033[0;33m\][\D{%Y-%m-%d}][\t]\[\033[0;36m\] [\u\[\033[0;37m\]@\[\033[0;36m\]\h:\[\033[0;32m\]\w]\[\033[0m\] \n$ " ##### Modify default ls command # -G colorizes output # -h makes sizes human readable # -F throws a / after a directory, * after an executable, and a @ after a symlink # -l listing format (as opposed to default wide) # -a shows all files (even hidden) alias ls='ls -laGFh'

Python 3 Script to Get IPs #!/usr/bin/env python3 def getips(): import re import subprocess # get ip(s) from ifconfig found_ips = [] ips = re.findall( r'[0-9]+(?:\.[0-9]+){3}', subprocess.getoutput("/sbin/ifconfig")) for ip in ips: if ip.startswith("255") or ip.startswith("127") or ip.endswith("255"): continue found_ips.append(ip) return ", ".join(found_ips)