Minor Point: 2017

Calculating Percent Change

Method 1: (new - old) / old
Method 2: (new / old) - 1

Old value	100
New value	50
Method 1	=(B2-B1)/B1	-50.00%
Method 2	B2/B1-1	-50.00%

Calculating Inflation in Excel

Future value of 100 dollars at 3% inflation in 10 years = $74.41:

=100/(1+.03)^10

Formula to copy in cells to calculate inflated value:
Col A        Col B
Year   Inflated Value
0        =100*(1+.03)^A1
=A1+1   =100*(1+.03)^A2
=A2+1   =100*(1+.03)^A3
=A3+1   =100*(1+.03)^A4
=A4+1   =100*(1+.03)^A5
=A5+1   =100*(1+.03)^A6
=A6+1   =100*(1+.03)^A7
=A7+1   =100*(1+.03)^A8
=A8+1   =100*(1+.03)^A9
=A9+1   =100*(1+.03)^A10
=A10+1   =100*(1+.03)^A11

Microsoft VBA Get Existing Outlook Instance

Sub Get_Existing_Outlook_Instance()
Dim objOutlook As Outlook.Application
' Gets the existing instance (if Outlook is already open) regardless of early or late binding
On Error Resume Next
Set objOutlook = GetObject(, "Outlook.Application")
If objOutlook Is Nothing Then
Debug.Print "Outlook is not open, getting a new instance"
Set objOutlook = New Outlook.Application
End If
Set objOutlook = Nothing
End Sub

Microsift VBA Early vs. Late Binding Example

Private Sub Early_vs_Late_Binding_Example()
#Const LATEBINDING = False

#If LATEBINDING Then
    Dim objOutlook As Object
    Set objOutlook = CreateObject("Outlook.Application")
#Else
    ' NOTE! Early binding requires a typelib reference. In the VBE click Tools -> References
    ' and make sure that "Microsoft Outlook xx.x Object Library" is selected
    Dim objOutlook As Outlook.Application
    Set objOutlook = New Outlook.Application
#End If

    Set objOutlook = Nothing
End Sub

Move Ubuntu Unity Launcher to the Bottom of the Screen

gsettings set com.canonical.Unity.Launcher launcher-position Bottom

To reset to the left side:
gsettings set com.canonical.Unity.Launcher launcher-position Left

Changing the window placement in Ubuntu

To see the current setting:
dconf read /org/compiz/profiles/unity/plugins/place/mode

To update the setting:
dconf write /org/compiz/profiles/unity/plugins/place/mode 1

(Try different values to understand the behavior.)

Restoring the default login screen background in Ubuntu Xenial

Changing the desktop wallpaper also changed the login screen. Follow these steps to override that behavior and reset the login screen back to the default.

cd /usr/share/glib-2.0/schemas/
sudo vi com.canonical.unity-greeter.gschema.xml

Look for this key node:

<key name="draw-user-backgrounds" type="b">
<default>true</default>
<summary>Whether to draw user backgrounds</summary>
</key>

Change the value true to false.

You can also remove the white dots by changing this key node:

<key name="draw-grid" type="b">
<default>true</default>
<summary>Whether to draw an overlay grid</summary>
</key>

Now recompile the schema with this command:

sudo glib-compile-schemas /usr/share/glib-2.0/schemas/

Log out and back in to see the change.

Biweekly vs. semi-weekly

Biweekly means once every two weeks.
Semi-weekly means twice per week.

Ubuntu Unity Configurations

To position the launcher at the bottom of the screen:
gsettings set com.canonical.Unity.Launcher launcher-position Bottom

To return to the default position on the left:
gsettings set com.canonical.Unity.Launcher launcher-position Left

To open new windows centered on the screen without installing compiz-conf:
dconf write /org/compiz/profiles/unity/plugins/place/mode 1

Minor Point