Tutorial Downloads

The following releases combine one or more tutorials into a standalone package. All software and instructions are included. Downloads are available directly and/or through BitTorrent.

Excel Tutorial: Using Conditional Formats for Traffic Lighting

 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

Total Guide to Playing Age Of Empires 3 Through Hamachi

Download (v1.5): Mirror#1 | Mirror#2 | Mirror#3 (best)

Download (v1.0): BitTorrent (no AOE3VPN)

Since its release, AOE3 has caused many headaches for players due to the game only recognizing an internal IP address (ie 192.168.x.x). This flaw makes Internet gaming impossible, since only computers on an internal LAN can see an internal IP address. Ensemble have offered patches and suggestions to overcome this problem, but they have not worked for all gamers. Enter Hamachi, a free network application that allows two or more users to organize a Virtual Private Network with Peer to Peer facilities. A special patch (inlcluded in this E-book for download) allows the game to select network devices, enabling secure game play over a user’s Hamachi network.

Included:
-AOEVPN Patch, Universal AOE3/AOM Patch
-Full tutorial
-Links to live discussions

Tutorial Sections:
-Playing Age of Empires 3 through Hamachi
-Playing Age of Mythology through Hamachi
-Universal Hamachi Loader (for the Age of Empires 3 and Age of Mythology Series)
-Advanced Tips (when things don’t work out)
-Software Downloads

Issues Addressed:
-What to do when OverrideAddress fails
-How to force Age of Empires/Mythology to recognize your Hamachi IP
-Router and Firewall Problems