Thursday, November 04, 2010

Infographic on Infographics

Infographic on Infographics
Though it seems infographics have only hit the online world recently, they've actually been with us throughout history. Who knew?
via: flickr.com

Search Amazon.com for infographics

My Bookmarks for 11/04/2010


Posted from Diigo. The rest of my favorite links are here.

Wednesday, November 03, 2010

Analyze Event Logs using Excel Pivot Table


Juan over at Raymond.cc posted an excellent article on Analyzing Windows Event logs using Excel's Pivot Tables. If you've ever tried tried sifting through a systems Event Logs trying to find a pattern you'll know what a pain in the rear it is.

The article includes a walkthrough on how to export your logs and set up the Pivot Table.
"If you want to troubleshoot a Windows system, definitely you will think about analyzing the event logs from the Event Viewer. Instead of looking at the event logs using Event Viewer, it is advisable that we save the log files as CSV format. After that insert the table in the CSV file, then we can analyze and sort the necessary information with ascending or descending order."
Read Post: Analyze Event Logs using Excel Pivot Table

What are Event Logs?

Event Logs first appeared in Windows NT (1993) allowing the Operation System and Applications to make use of a centralized log service to log events Informational, Warning, Error and Critical events. There are three type of logs which include System, Application, and Security. Windows 2000 introduced the option for 3rd party application to create their own log sources. You can find more information on Event Logs and their history on Wikipedia.

What are Pivot Tables?

Excel Pivot Tables are used to summarize, analyze and visualize data. Pivot Table can sort, count, and total the data in a table and create a new Pivot Table displaying a summary of the data. Pivot Tables get their name from their ability to rotate/pivot on specific fields from the source data and automatically update to show the new information. For a hands on explanation of Pivot Tables visit "Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one"

Search Amazon.com Books for Excel Pivot Tables

Monday, November 01, 2010

Gundam Rock

I just got "Gundam Rock" by Andrew W.K. and it is amazing (unless you're not a Gundam fan). I'm surprised I haven't heard of this CD before since it was released in 2009.

I now have 16 tracks of Gundam Awesomeness to accompany the rest of my Anime Collection:


  1. TV Series Opening Narration
  2. Gundam On The Earth
  3. Fly, Gundam!
  4. Char The Great
  5. Here Comes Char
  6. Star Children
  7. The Cross of Sand
  8. Eye Catch
  9. Soldiers of Sorrow
  10. Peace For A Moment
  11. Alone In The Wind
  12. Beginning
  13. Fear To Fight
  14. Encounter
  15. Amuro Forever
  16. Garma Zabi's Funeral Speech By Gihren Zabi
I've got a few other Anime soundtracks on the way, I'll probably post something simple like this once I get them (having to rebuild my collection).

You can purchase the album at Amazon.


Installing jDownloader under Ubuntu


First of all... What is jDownloader?

jDownloader is an application which simplifies downloads from One-Click-Hosters like Rapidshare, Megaupload and Hotfiles. It is able to download multiple files in parallel and offers captcha recognition and automatic file extraction.

jDownload is open source and written in Java making it platform independent. There are packages available for Windows (portable version available), Linux and Mac.

Installing jDownloader

One of the things I really enjoy about using most Linux distribution is having a software repository where you tell it what to install and it takes care of the installation. Unfortunately jDownloader is not included in the official repositories for Ubuntu, but thanks to Ubuntu's Personal Package Archives (PPA's) it is really simple to get jDownload up and running.

First off, we need to find the PPA page for jDownlaoder which is located here. Next we extract the package details from the "Adding this PPA to your system" section (ppa:jd-team/jdownloader) and add it to our repository (don't forget to update your package indexes)

sudo apt-add-repository ppa:jd-team/jdownloadersudo

apt-get update

After we import or PPA we are now able to install the package

sudo apt-get install jdownloader


jDownloader will now be under the Appliation->Internet menu which will launch the updater and complete the installation. The updater does take a while to download all the required components which make up jDownloader, so you might want to take a break and come back in a while.

Additional Information

Ubuntu Personal Package Archives (PPA)

What is a PPA?

A PPA is a published apt repository in that a contributor uploads source packages which get built (compiled) and packaged as an apt repository by Launchpad (Launchpad is a Project Management software by Canonical, Ltd. which includes a knowledge base, issue tracker, and code repository to name a few).

For the end user working with PPA's has eliminated the need to modify the sources.list in order to include new repositories into apt. All that is required is to import the PPA and run the apt-get update command in order to install the new packages included by the repository.

For developers there are many advantages for creating new software packages or modifying existing. All published repositories (source) will be compiled for i386 and AMD64 on all supported ubuntu releases.

Installing Software using PPA

If for some reason you are not able to find the software package you are looking for in the official Ubuntu repositories, visit the PPA's overview page in Launchpad and search for your package.

PPA Overview page (Searching for gwibber-daily)

Once you've found the package find the section on the page title "Adding this PPA to your system" and make note of the PPA's location (ppa:gwibber-daily/ppa).

gwibber-daily PPA page

Open a terminal and enter the following command replaceing ppa:user/ppa-name with the PPA location from the overview page:

sudo apt-add-repository ppa:user/ppa-name

The apt-add-repository command will fetch the PPA's key and add the source and key to your repositories list.

apt-add-repository output


Next you'll need to tell your system to pull all of the latest software information for your instlled repositories (which will include your newly added PPA).

sudo apt-get update

You are now ready to install any software package included within the ppa. For example:

sudo apt-get install gwibber

The available packages for each PPA are available in the Overview page for the PPA.

Published packages for the gwibber-daily PPA

If you're adding a PPA for a package you've already installed in order to get a newer or modified version all you need to do is:

sudo apt-get dist-upgrade

Additional Information