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:


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

    Dim objOutlook As Object
    Set objOutlook = CreateObject("Outlook.Application")
    ' 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">
<summary>Whether to draw user backgrounds</summary>
Change the value true to false.

You can also remove the white dots by changing this key node:
<key name="draw-grid" type="b">
<summary>Whether to draw an overlay grid</summary>
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