applications

applications — No Comments
27
Jan 12

How to use conditional formatting to shade every other row in Excel

The other day I was on MS Excel and I wanted to have every other row colored, since it was really difficult to read due to the content that I had.  I found a really good solution where all you would have to do is to

  1. Select the rows that you would like to color
  2. Go to Format -> Conditional Formatting
  3. In Condition 1 change it to select Formula Is instead
  4. enter the following formula =MOD(ROW(),2)=1
  5. Click on Format button
  6. When then new box opens up, click on the Patterns tab
  7. Pick the color that you would like, and then click OK.
  8. Now on the Conditional Formatting dialog box, click OK.

Then enjoy your colors on every other row :P

Source How to use conditional formatting to shade every other row in Excel.

applications — No Comments
25
Oct 11

Upgrade to Ubuntu from Natty Narwhal 11.04 to Oneiric Ocelot 11.10

The following steps below from Ubuntu will guide you in terms of successfully upgrading your Ubuntu system from Natty Narwhal 11.04 to Oneiric Ocelot 11.10.

To upgrade from Ubuntu 11.04 on a desktop system, press Alt+F2 and type in “update-manager -d” (sans quotes) into the command box. Update Manager should open up and display following message: “New distribution release ’11.10′ is available. Click Upgrade and follow the on-screen instructions”.

To upgrade from Ubuntu 11.04 on a server system, follow the steps listed below: Step 1: Install the update-manager-core package (if it is not already installed). Step 2: Use following command sudo do-release-upgrade -d to launch the upgrade tool. Step 3: Follow the on-screen instructions. Note that the server upgrade is now more robust and will utilize GNU screen and automatically re-attach in case of dropped connection problems, for example.

Source: OneiricOcelot/ReleaseNotes – Ubuntu Wiki.

applications — No Comments
1
Aug 11

Installing XML plugin in Notepad++

i recently started working on more XML data since i am trying to do more data transfer between databases.  i use notepad++ as my main editor and i wanted to keep using it with my XML data without having the need of installing another program on my computer.  i found out that that there was a plugin develop for notepad++ in order to allow me to use it as my XML editor.  the problem was that there was no documentation on how to install what file and where.  below you will be able to find the proper steps on how to do so.

NOTE: you need to have notepad++ installed in your computer before proceeding. if you don’t have notepad++ install you can click on this link.

  1. after you have notepad++ installed
  2. goto this link http://bit.ly/rcCK1N download these packages
    1. External libs -> ext_libs.zip
    2. XML Tools -> Xml Tools 2.3.1 r764 Unicode Beta1 -> xmltools_2.3.1_r805_unicode_beta2.zip
  3. when extracting the files here is where you will need to place them…
    i am going to assume that you have installed notepad++ in it’s default directory which is “C:\Program Files\Notepad++”
    1. the ext_libs.zip will extracted on “C:\Program Files\Notepad++”
    2. the xmltools_2.3.1_r805_unicode_beta2.zip will be extracted on “C:\Program Files\Notepad++\plugins”
  4. now, if you had notepad++ open, restart it and you should be able to use the XML plugin …

enjoy!!!

applications — No Comments
21
Jun 10

Windows blue screen even on virtual machines

if you thought that blue screens are only on regular windows boxes…. you are wrong!!! yesterday i just experience  a blue screen on my windows virtual machine (vm).  i am currently running ubuntu 10.04 and have windows xp pro on my virtual machine.  apparently the vm got stock on a process with a infinite loop.  isn’t that something…. only on the windows journey.

vboxdisp

Virtual Machine Blue Screen of Death

applications — No Comments
25
Apr 10

untangle linux protecting me from virus

i have been having utangle for a while now and i did not know how useful it was to protect my gateway until today.  out of 52072 files that the clamav antivirus look for 25761 were blocked :o .  that is about 49% of the files that would of probably infect my computer were blocked at the gate making by only windows pc safe.  so, if you are thinking about safety on a windows environment, maybe utangle might be the solution :) .

for more information about untangle visit the following site http://www.untangle.com/.

applications — No Comments
24
Jun 09

Ubuntu Backup Before Upgrade (UBBU)

just in case you didn’t know i created not too long my first linux bash script.  the reason why i developed this was because i was getting tired of backing up my ubuntu linux system every six months.  so, if you would like to be able to backup certain selected folders and files you could download a copy by going to Ubuntu Backup Before Upgrade site.

applications — No Comments
18
Mar 09

Install Fedora using a Flash Drive

if you are running windows and you will like to install fedora on your flash drive this is liveusb-creator the program to go.  it is so easy that it is even impossible to believe.  you could either download fedora distro or use the program to download it from the web.  then browse the file and hit “Create Live USB.”  yeap, is that easy.  then all you have to do is to boot from the USB drive, so you have to make sure that you will tell your BIOS that.

Resources
Install Fedora to a flash drive using Windows

applications — No Comments
23
Jan 09

Upgrade Amarok to 2.0

this one will allow you to have the lastest verison of amarok in your sources.

  1. add the following line to your sources list

    2. deb http://ppa.launchpad.net/kubuntu-members-kde4/ubuntu intrepid main

  2. then find “amarok-kde4″ on synaptic manager and install it
  3. the upgrade will take care of deleting the old amarok and installing the new one in
applications — No Comments
23
Jan 09

Upgrade OpenOffice to 3.0

i’ve been using the older version of openoffice and i wanted to upgrade to 3.0 in ubuntu.  well it is not as easy as … i download the files and then click upgrade.  there are repositories that i need to download in order to install them properly.  you will be using ppa (personal package archive) in order to have such of installation.

so what i did in order to have this upgrade automatically is the following steps:

  1. first you will need to open “synaptic package manager“
  2. go to “third-party software” tab and then click on “add”
  3. add this following line
    deb http://ppa.launchpad.net/openoffice-pkgs/ubuntu intrepid main
  4. now reload the package information the synaptic package manager and then upgrade
applications — No Comments
8
Jun 08

Free Application

NTI Shadow for backup utilities is offering their program for free.  you have until midnight to download the full version.

here is the web link http://www.ntius.com/shadow_promotion.asp

← Older Entries