sysconfig -a
Wednesday 24 February 2016
NetApp: Show NetApp Serial Number with Command
sysconfig -a
Friday 19 February 2016
Google: Autofill Numbers and Related Data in Google Spreadsheets
Google Spreadsheets can autofill cells with sequential numbers and other related data, like rivers and countries. It's still not an advanced Excel, but this feature can save you some time when you're numbering a column.
This feature works with both rows and columns. For example, start out by numbering your column with 1, 2, and 3 in three cells next to each other. Then select those three cells and move your cursor the the bottom right-hand corner of the selection. (You should see a blue dot.) Hold your Ctrl key (Alt/Opt on Mac), then click and hold the dot, and drag your cursor down—or across if you're filling in rows. (Note: This isn't strictly necessary with numbers, but with related data like countries, it is.)
It works for sequential numbers (1, 2, 3...), even numbers (2, 4, 6...), and more. Adding to the niftiness of it all, you can also autofill countries, car manufacturers, and other related sets of data. Try it out, and we'd love to hear about any other sets of data that you come across that this autofill works for.
This feature works with both rows and columns. For example, start out by numbering your column with 1, 2, and 3 in three cells next to each other. Then select those three cells and move your cursor the the bottom right-hand corner of the selection. (You should see a blue dot.) Hold your Ctrl key (Alt/Opt on Mac), then click and hold the dot, and drag your cursor down—or across if you're filling in rows. (Note: This isn't strictly necessary with numbers, but with related data like countries, it is.)
It works for sequential numbers (1, 2, 3...), even numbers (2, 4, 6...), and more. Adding to the niftiness of it all, you can also autofill countries, car manufacturers, and other related sets of data. Try it out, and we'd love to hear about any other sets of data that you come across that this autofill works for.
BlueCoat: View Event Logs and Syslog of BlueCoat PacketShaper
To view the event logs and Syslog of your BlueCoat PacketShaper, please refer to the following steps:
1. Click the Info tab.
2. Click file browser.
< View Event Logs >
3. Go to the unit's data disk, 9.258/
4. Go to the LOG/ directory. The event logs are listed. The file named EVENTS is the current set of log entries. The EVENTS.n files, where n is a sequential number, contain archived event records.
5. To view the contents of the current log file, click EVENTS.
< View Syslog >
3. Go to the unit's data disk, 9.256/
4. Go to the LOG/ directory. Then, go to the SYSLOG/ directory. The files named pshaper and messages are the Syslog files that you can refer to.
5. To view the contents of the syslog file, click pshaper or messages.
Tuesday 2 February 2016
Microsoft: Remove Extra Spaces in a Cell in Excel
The following formula allows you to remove the unwanted spaces in a cell:
Substitute(A1," ","")
Subscribe to:
Posts (Atom)