Other Useful Commands

Block title

Google Apps Helpful Commands

Copy a particular field cell value from one Google Apps Spreadsheet to another Google Spreadsheet automatically.

Add this value to the field cell you want the data to copy to automatically, similarly to how you would for a function.

=importRange("ABCDEFGHIJK012345","FieldName!A1")
In this example, the first value is the value in your URL on your Google Spreadsheet after key= and before the & sign. That key will be a combination of letters, numbers, and possibly underscores. The second value is the Sheet Name within that document and the field value separated by a !. In this example that is Sheet1 and field A1. This will copy the value in the spreadsheet key specified on Sheet 1 field A1 to field you have this function.

Copy a particular range of field cell values from one Google Apps Spreadsheet to another Google Spreadsheet automatically.

=importRange("ABCDEFGHIJK012345","FieldName!A1:A25")
In this example, the first value is again the value in your URL on your Google Spreadsheet after key= and before the & sign. That key will be a combination of letters, numbers, and possibly underscores. The second value is the Sheet Name within that document and the field range value separated by a !. In this example that is Sheet1 and field A1:25. This will copy the values in the spreadsheet key specified on Sheet 1 fields A1 through A25 starting in the field you have this function.

Copy a particular field cell value from one sheet to another sheet within the same Google Apps Spreadsheet automatically.

=Sheet1!A1
In this example, the first value is the sheet name where the field cell value you want to copy is located. The second value is the field cell value itself. In this case, it is copying from a sheet named Sheet1 and field cell A1.

Please Note: I recommend removing spaces in your sheet names where you want to set this up. Use underscores _ or dashes - instead. It is much easier to setup without spaces in the sheet names.

Windows 7 Command Line Commands

Cleanup your WinSXS folder in Windows 7. Especially useful for Windows 7 installations on solid state hard drives (SSD).

dism /online /cleanup-image /spsuperseded
This command has reduced my WinSXS folder by over 50% in most cases. For instance, after a clean install of Windows 7 with all updates including Service Pace 1 (SP1), my WinSXS folder was over 12GB. That was a fair amount of my 110GB total of my SSD drive. By running the above command, I was able to reduce the size of the folder to around 6GB. I plan on running this command often to keep the size of this folder as low as possible.

DNS Settings

Set a SPF record to raise less spam flags. Set the host to @ if your registrar requires.

v=spf1 include:_spf.google.com ~all

SUPHP Setup

So when you need to chmod 755 a directory for SuPHP to function correctly, this means the user permissions are set to 7 (rwx) the group permissions are set to 5 (r-x) and the world permissions are set to 5 (r-x). The correct PHP file permissions for SuPHP to function correctly is 644. This means the user permissions are set to 6 (rw-), the group permissions are set to 4 (r--) and the world permissions are set to 4 (r--).

Block title

Signup for Dropbox and get 2GB free storage plus 500GB per referral