Technology Insights

GoogleDocs Spreadsheet: Add 1 to a String That Includes Letters, for Sequential Serial Numbers

GoogleDocs is awesome. There is nothing better than storing all of your spreadsheets, documents, forms, and presentations in an online secure location. Not only that but you can open and edit from any PC in the world at any time without having to worry about access, etc.

Today I was creating a spreadsheet on GoogleDocs to list account numbers and serial numbers that were sequential though they also contained letters. An example of the set of numbers I was trying to enter quickly is listed below.

Technology Insights

How to Test Disk Input and Output on Linux

There are a couple useful utilities on Linux to test disk input/ouput.

Sequential Disk Access: hdparm

The hdparm command will test sequential disk access and can be used with the below command. Replace /dev/sda1 with the mounted disk you would like to test such as /dev/hda1.

bash

  1. hdparm -t /dev/sda1

The results will output similar to the below.