Sometimes sorting gets really frustrating when all the data you are trying to sort isn’t formatted the same.

Create a new column next to the column you’re attempting to sort, then use this formula to move X amount of characters.  I’m using Ford Part #’s and I need to sort by the 4th character in which is the Z

A2 cell = C0AZ-7153-A

Whereas x = the amount you want to move for example

which gives

Z-7153-A

From there just copy that formula to the rest of the cells in the new column then u can sort sheet under that column.

 

Copied from https://gist.github.com/plepe

mdadm

md: multiple devices
command description

 

show status of all raids

 

detailed status of raid md0

 

new raid /dev/md0 with 2 disks, raid level 1 on /dev/sda1 and /dev/sda2

 

remove /dev/sda1 from /dev/md0

 

add /dev/sda1 to /dev/md0

 

use 3 disks in raid /dev/md0 (e.g. add an additional disk, so a damaged drive can be removed later-on)

 

Assemble /dev/md0 (e.g. when running live system)

 

Update list of arrays in /etc/mdadm/mdadm.conf ; you should remove old list by hand first!

 

What is this disk / partition?

 

Set minimum raid rebuilding speed to 10000 kiB/s (default 1000)

 

Copy partition table from sdX to sdY (MBR only)

 

Copy partition table from sdX to sdY (GPT)

To boot a machine even with a degraded array, modify /etc/initramfs-tools/conf.d/mdadm and run update-initramfs -c -kall (Use with caution!)

LVM

pv: physical device (e.g. /dev/md0 or /dev/sda1)
vg: volume group (consists of 1 or more pvs, contains lvs); has a name (e.g. lvm)
lv: logical volume (has a name which defines its path, e.g. /dev/lvm/root which equals dev/mapper/lvm-root)
command description

 

initializes /dev/md0 as phys device for a volume group

 

create volume group lvm with phys device /dev/md0

 

create logical volume root, sized 30G in volume group lvm; format with ext4

 

extend /dev/lvm/root to 60G; also resize file system to new size

 

show short info about pv, vg and lv

 

show long info

scan disks for physical volumes (e.g. when running live system)

 

add phys device /dev/md1 to volume group lvm (need pvcreate first!)

 

move all logical volumes from /dev/md0 and remove phys device from volume group

Other
create bios grub partition

 

This is really old, but still helpful

  1. Basic scan:

     
  2. Scan multiple addresses:

     
  3. Scan entire subnet looking for valid hosts. This quick scan will also grab MAC address and perform MAC lookup to help determine what the host is.

     
  4.   Discovery:  Before a scan nmap will attempt to send an ICMP echo request.  To not send the ICMP, :

     
  5. To do only a ping scan:

     
  6. Do an ARP Ping scan:

     
  7. Port Scanning options:  Performing a Fast scan:

     
  8. Scan only specific ports:

     
  9. Scan multiple ports:

     
  10. Scan ports by name (found in /etc/services)

     
  11. Scan all ports:

     
  12. Choose between TCP and/or UDP:

     
  13. What OS is the target running?

     
  14. If the OS is unknown, have nmap attempt to guess the OS

     
  15. Service version detection

     

I have no idea how or why this started happening however my monitors would go black after 15 seconds of idle.  No power settings or screensavers were causing it, nor did I see any helpful logs to help troubleshoot.  However somewhere/how the Energy Star features of my monitor got enabled and literally after 15 seconds of idle time the monitors would go black..

Simple fix:

 

This fixed the issue not only for the current logged in session but also after a reboot.

$# : Number of arguments passed via script

$0 : Name of the script

$@ : Names of arguments passed to the script at execution

$$ : Process ID associated with script

$OSTYPE : What’s the OS type?

$TERM :  What’s term is being used?

$USER : What’s the username that executed the script?

$HOSTNAME : What’s the hostname of the box that ran the script?

$LOGNAME :  What was the login username?

$LINENO : Current line # of the script

$RANDOM : Random #

$BASH_SOURCE :  What’s the bash source?

Example script: