Note: This will be the first in a series of downloadable tutorials. Each tutorial runs in a self-contained browser with all files and software embedded [where legal]. If you would like a specific topic covered, please leave a message here.

Download: Mirror#1

Simplicity is key when presenting statistics to management or customers. Data analysts are often tempted to put as many details as possible on the standard “one sheet” template; however, too many numbers on a page can cause confusion about where to initially focus. When reducing the number of statistics on a page is not an option and summary stats are not appropriate, traffic-lighting is a quick and effective method to highlight trends or draw attention to information that need to be addressed.

Included:
-Example Excel File
-Full tutorial

Update: If you are having trouble with this tutorial you can do the following -

1. Try following some of the tips provided by Alien X in the comments section
2. Visit the Blink7 page on the newest available patch for network gaming with Age of Mythology: (click here)Â

Important Note -

Try this tutorial first, and if it does not work for you then try AlienX’s suggest listed below in the comments section (thanks to AlienX!)
Background -
Tutorial: Internet Gaming with Age of Empires 3 and Hamachi

Age of Mythology typically defaults to the internal IP address rather than the Hamachi address during network play. This behaviour can prevent players from hosting multi-player games over Hamachi networks. Luckily there is a workaround …
Continue reading ‘Tutorial: Internet Gaming with Age of Mythology and Hamachi’

What is an IP address?

An IP (Internet Protocol) address is a unique address within a network used by devices to communicate with other devices within the network. Computers, printers, routers, and network hard drives are examples of devices that could have an IP address within a network.

IP addresses are generally assigned according to country and internet provider. There are also some specially reserved IP addresses or IP ranges that are universally understood:

• Local Machine IP – The IP address 127.0.0.1 (localhost) is always synonymous with the local machine. This IP address is valid only within the local machine environment, as every computer is its own “localhost”.
• Private Network IP’s – The IP ranges 192.168.0.1-192.168.0.254, 10.0.0.0–10.255.255.255 and 172.16.0.0–172.31.255.255 are reserved for private internal networks, such as a home networks or corporate intranets. These IP addresses are only valid within the local network and cannot be used if, for instance, a user wanted to connect to another user over the internet. Thus, it is typical for a computer to have an IP address for the local network (e.g. 10.1.2.1) and an IP address visible to the Internet (e.g. 65.34.24.24), which is itself one large network.

For the purpose of this tutorial, private network IP’s will be referred to as internal IP’s while internet-accessible IP’s will be referred to as external IP’s.

Why would I need to know my IP address?

1. Network gaming [internal or external]
2. Running a private server (e.g. FTP, HTTP) [internal or external]
3. Windows file sharing within an home network [internal]
4. … and any time another computer or service needs to identify your machine for commication or software deployment

Continue reading ‘Tutorial: Two Ways to Lookup Your Own IP Address’