Friday 10 September 2010

Load the Analysis Toolpak in Office 2003 Excel

Link: http://office.microsoft.com/en-us/excel/HP011277241033.aspx
The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.
On the Tools menu, click Add-Ins.
In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
Tip If Analysis Toolpak is not listed, click Browse to locate it.
If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.
Note To include Visual Basis for Application (VBA) functions for the Analysis Toolpak, you can load the Analysis Toolpak - VBA Add-in the same way you load the Analysis Toolpak. In the Add-ins available box, select the check box next to Analysis Toolpak - VBA.

Connecting to Ubuntu from Windows using Putty

To make sure you have ssh installed, you can run (on your Ubuntu box):
sudo apt-get install ssh

Sunday 5 September 2010

Watchguard Firebox Edge Factory Default Configuration

Trusted network
The default IP address for the trusted network is 192.168.111.1. The subnet mask for the trusted network is 255.255.255.0.
The Firebox X Edge is configured to give IP addresses to computers on the trusted network through DHCP. By default, the IP addresses given can be from 192.168.111.2 to 192.168.111.254.
External network
The Firebox is configured to get an IP address with DHCP.
Optional network
The optional network is disabled.
Firewall settings
All incoming policies are denied. The outgoing policy allows all outgoing traffic. Ping requests received on the external network are denied.
System Security
The Firebox X Edge e-Series administrator account is set to the default user name of “admin” and the default passphrase of “admin.” When you connect to the Edge, the Quick Setup Wizard includes a dialog box for you to set the administrator account user name and passphrase. After you complete the Quick Setup Wizard, you must use the user name and password that you selected to see the configuration pages.
The Firebox X Edge is set up for local management from the trusted network only. Additional configuration changes must be made to allow administration from the external network.
Upgrade Options
Upgrade options such as WebBlocker, spamBlocker, and Gateway AV/IPS are always available. You must type the feature keys into the configuration page or use the feature key synchronization feature to activate upgrade options. If you restore the Firebox X Edge to its factory default settings, you do not have to type the feature keys again.