Thursday 30 September 2010

[Software] Wake on Lan - Magic Packet

Over the past month we have had a lot of problems setting up some some software that included integrated Wake on LAN. The software wouldn't wake any of our computers up even though the computers BOIS settings were correctly set to enable Wake on LAN.

During this time I was inspired to create my own Wake on LAN (WOL) programme so that I could prove that our network wasn't to blame for the computers not waking up.

WOL Magic Packet v.1 Download Here

WOL - Magic Packet has the following features

  • Send Wake on LAN packets to a number of computers at the same time by using computer MAC addresses.
  • Retrieve computer MAC addresses by supplying a range of ip addresses. The start and finish ip address must be in the same ip subnet. i.e. Both should have the same first three numbers.
  • Save and retrieve lists of computer MAC addresses to a text for later use
  • Run saved MAC address lists from the command line by using the format
WOLMagicPacket.exe [path to list of mac addresses file]

Please let me know what you think about this.

Wednesday 8 September 2010

[Tip] Find duplicate rows in spreadsheet

A number of times in the past I have helped users to remove duplicates rows from excel or calc spreadsheets.

Below is the process I have used.

  1. Order the spreadsheet by the columns from which you want to remove duplicates. This will group together all duplicate rows.
  2. Create a calculation in an empty field to concatenate all fields that are being duplicated. For example '=CONCATENATE(A1,B1,C1)'. With A,B,C being the columns that contain duplicate data.
  3. Create another calculation in an empty field to compare each rows concatenated result column with the previous rows concatenated result column. For example '=if(D1=D2,"duplicate","unique")'. With D being the column with the concatenate calculation in it.
This will give you a list of "duplicates" and "uniques" to identify if a row is unique or a duplicate of the previous row. This list can be filtered on "unique" or copied to a new sheet to get a set of unique rows.

Below is an example google spreadsheet to give an idea of the columns required accomplish the task

Hope someone finds this useful

Wednesday 1 September 2010

New look website

I have decided to freshen up the look and feel of the website.

Please let me know what you think.