Monday 2 February 2009

Locate itunes downloaded firmware on a Windows XP and Vista OS

Find the itunes downloaded firmware on a Windows Vista OS at
C:\Users\UserName\AppData\Roaming\Apple Computer\iTunes\i[phone/pod] Software Updates

Find the itunes downloaded firmware on a Windows XP OS at
C:\Documents and Settings\UserName\Application Data\Apple Computer\iTunes\i[phone/pod] Software Updates

You can copy the link above and paste in your windows file path field
Note:
UserName should be changed with the name of the machine.
i[phone/ipod] Software Updates should be either 'ipod Software Updates' or 'iphone Software Updates'

Have fun!!

Thursday 8 January 2009

Create a Gantt chart in Excel

There are many ways to create a Gantt chart. For example, Microsoft
Project, a task-planning program, makes it easy to track and chart
project timelines with a built-in Gantt chart view. Another option is
to use Excel. Excel does not contain a built-in Gantt chart format;
however, you can create a Gantt chart in Excel by customizing the
stacked bar chart type.


This article shows you how to create a Gantt chart like the following example.


Example of a Gantt chart in Excel


HideStep 1: Enter the sample data





  1. Open a new worksheet in Excel and enter the following values in cells A1 through D6:




























































    ABCD
    1
    Start DateCompletedRemaining
    2Task 108/01/200020510
    3Task 210/15/2000200120
    4Task 312/15/2000140200
    5Task 402/06/0144345
    6Task 505/06/010380


    Note  The values in columns C and D (Completed and Remaining) represent numbers of days.


  2. Select cell B2 and format with the date format you want to use for the chart by clicking Cells on the Format menu, and then clicking the Number tab. Click Date in the Category list, and select the format you want to use in the Type list.


HideStep 2: Create a stacked bar chart





  1. Select cells A1:D6 and click Chart Wizard.
  2. In step 1, click Bar under Chart Type, and then click the Stacked Bar sub-type (you can see the name of each chart sub-type at the bottom of the dialog box).
  3. Click Next, Next, and then Finish.


HideStep 3: Make the chart look like a Gantt chart





  1. Double-click the first series in the chart. This is the series for Start Date. If default colors are set in Excel 2002, this series is blue.
  2. On the Patterns tab of the Format Data Series dialog box, click None for Border and None for Area, and then click OK.
  3. Double-click the category (x) axis, which in a bar chart is the
    vertical axis. (In a bar chart, the traditional x and y axes are
    reversed.) Click the Scale tab, and select the Categories in reverse order check box.
  4. Click the Font tab, click 8 under Size, and then click OK.
  5. Double-click the value (y) axis, which in a bar chart is the
    horizontal axis. After completing the last step, this axis should be
    located at the top of the chart plot area. Click the Scale tab and type the following values in the appropriate boxes:

    Minimum: 36739



    Maximum: 37441



    Major unit: 61



    Minor unit: 1



    These values are serial numbers that represent the dates to be used
    for the value (y) axis. The minimum value 36739 represents the date
    August 1, 2000. The maximum value 37441 represents the date July 4,
    2002. The major unit of 61 represents about two months, while the minor
    unit represents one day. To see the serial number for a date, enter the
    date in a cell, and then format that cell with the General number format.



  6. Also on the Scale tab, select the Category (X) axis crosses at maximum value check box.


  7. Click the Alignment tab, and under Orientation, type 45 in the Degrees box.
  8. Click the Font tab, and under Font style, click Bold. Under Size, click 8, and then click OK.
  9. Right-click the legend, and click Format Legend on the shortcut menu.
  10. Click the Placement tab, and click Bottom.
  11. Within the legend, click Start Date so that it is selected, and then press DELETE.

Friday 2 January 2009

Use Outlook with Google Gmail

You can send and receive e-mail messages by using your Google Gmail e-mail account and Outlook. Gmail requires a Secure Sockets Layer (SSL) (Secure Sockets Layer (SSL): A proposed open standard that was developed by Netscape Communications for establishing a secure communications channel to prevent the interception of critical information, such as credit card numbers.) encrypted connection when you retrieve and send e-mail. Gmail uses POP3 (POP3: A common protocol that is used to retrieve e-mail messages from an Internet e-mail server.) port number 995 and Simple Mail Transfer Protocol (SMTP) (Simple Mail Transfer Protocol (SMTP): A common protocol that is used to send e-mail messages across the Internet.) port number 465. These settings are not the default for a POP3 account in Outlook and require you to modify account settings in Outlook.

The outgoing e-mail server (e-mail server: A computer that stores e-mail messages.) is similar to those used by many Internet service providers (ISPs) (ISP: A business that provides access to the Internet for such things as electronic mail, chat rooms, or use of the World Wide Web. Some ISPs are multinational, offering access in many locations, while others are limited to a specific region.). However, Gmail requires authentication on their SMTP e-mail server. This requirement means that you must provide a user name and password — the same as your Gmail screen name and password — before you send your e-mail message. You can save the user name and password in Outlook so that you enter the information just one time.

The following steps configure Outlook for all necessary settings required to send and receive e-mail by using your Gmail e-mail account and Outlook.

Note  When you change your Gmail password, you need to update the Gmail account information in Outlook.

Do one of the following:

HideAdd your Gmail e-mail account

To use your Gmail e-mail account in Outlook, you must first make sure POP3 support is enabled in Gmail, and then you can add it to Outlook.

   1. Log in to your Gmail account.
   2. At the top of any Gmail page, click Settings.
   3. In the Mail Settings window, click Forwarding and POP.

      HideI don't see Forwarding and POP
      Gmail is turning on POP3 support for users in phases. If Forwarding and POP does not appear, your Gmail account cannot be configured for POP3 support.
   4. In the POP Download section, select Enable POP or all mail or Enable POP only for mail that arrives from now on.
   5. Click Save Settings.
   6. In Outlook, on the Tools menu, click E-mail Accounts.
   7. Click Add a new e-mail account, and then click Next.
   8. Click POP3, and then click Next.
   9. Under User Information, do the following:
         1. In the Your Name box, type your full name the way you want it to appear to other people.
         2. In the E-mail Address box, type your e-mail user name followed by @gmail.com.
  10. Under Server Information, do the following:
         1. In the Incoming mail server (POP3) box, type pop.gmail.com.
         2. In the Outgoing mail server (SMTP) box, type smtp.Gmail.com.
  11. Under Logon Information, do the following:
         1. In the User Name box, type your full e-mail address, including @gmail.com.
         2. In the Password box, type your password.
         3. Select the Remember password check box.

            Note  You have the option to have Outlook remember your password by typing it in the Password box and selecting the Remember password check box. Having Outlook remember your password means that you won't have to type your password each time you access the account; however, it also means that the account is vulnerable to anyone who has access to your computer. Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.
  12. Click More Settings.
  13. On the General tab, under Mail Account, type Gmail.
  14. Click the Outgoing Server tab, and then select the My outgoing server (SMTP) requires authentication check box.
  15. Select Use same settings as my incoming mail server.
  16. Click the Advanced tab, and then under Server Port Numbers for both Incoming server (POP3) and Outgoing server (SMTP), select the This server requires an encrypted connection (SSL) check boxes.
  17. Change the Outgoing server (SMTP) port number to 465.

      The Incoming server (POP3) port number should change automatically to 995 when you select the This server requires an encrypted connection (SSL) check box.
  18. Click OK.
  19. To verify that your account is working, click Test Account Settings. If there is missing or incorrect information, such as your password, you will be prompted to supply or correct it. Make sure your computer is connected to the Internet.
  20. Click Next, and then click Finish.

Notes

    * Do not select the Log on using Secure Password Authentication (SPA) check box.
    * Unless specified by Gmail, all server and address entries are typed in lowercase letters.

HideRemove your Gmail e-mail account

   1. On the Tools menu, click E-mail Accounts.
   2. Click View or change existing e-mail accounts, and then click Next.
   3. Click the Gmail e-mail account you want to remove, and then click Remove.
   4. Click Finish.

Note  You can export your Outlook Contacts as a Comma Separated Values (.csv) file and import your contacts (contact: Person, inside or outside of your organization, about whom you can save several types of information, such as street and e-mail addresses, telephone and fax numbers, and Web page URLs.) into your Gmail account. For help on exporting and importing your Outlook Contacts

Yahoo! Mail server information

Yahoo! Mail server information
E-mail address     Incoming mail server (POP3)     Outgoing mail server (SMTP)
MemberID@yahoo.com     pop.mail.yahoo.com     smtp.mail.yahoo.com
MemberID@yahoo.com.ar     pop.mail.yahoo.com.ar     smtp.mail.yahoo.com.ar
MemberID@yahoo.com.au     pop.mail.yahoo.com.au     smtp.mail.yahoo.com.au
MemberID@yahoo.com.br     pop.mail.yahoo.com.br     smtp.mail.yahoo.com.br
MemberID@yahoo.ca     pop.mail.yahoo.ca     smtp.mail.yahoo.ca
MemberID@yahoo.com.cn     pop.mail.yahoo.com.cn     smtp.mail.yahoo.com.cn
MemberID@yahoo.es     pop.correo.yahoo.es     smtp.correo.yahoo.es
MemberID@yahoo.de     pop.mail.yahoo.de     smtp.mail.yahoo.de
MemberID@yahoo.dk     pop.mail.yahoo.com     smtp.mail.yahoo.com
MemberID@yahoo.fr     pop.mail.yahoo.fr     smtp.mail.yahoo.fr
MemberID@yahoo.com.hk     pop.mail.yahoo.com.hk     smtp.mail.yahoo.com.hk
MemberID@yahoo.co.id     pop.mail.yahoo.co.id     smtp.mail.yahoo.co.id
MemberID@yahoo.ie     pop.mail.yahoo.co.uk     smtp.mail.yahoo.co.uk
MemberID@yahoo.co.in     pop.mail.yahoo.co.in     smtp.mail.yahoo.co.in
MemberID@yahoo.it     pop.mail.yahoo.it     smtp.mail.yahoo.it
MemberID@yahoo.co.kr     pop.mail.yahoo.com     smtp.mail.yahoo.com
MemberID@yahoo.com.mx     pop.mail.yahoo.com     smtp.mail.yahoo.com
MemberID@yahoo.com.my     pop.mail.yahoo.com.my     smtp.mail.yahoo.com.my
MemberID@yahoo.no     pop.mail.yahoo.com     smtp.mail.yahoo.com
MemberID@yahoo.co.nz     pop.mail.yahoo.com.au     smtp.mail.yahoo.com.au
MemberID@yahoo.com.ph     pop.mail.yahoo.com.ph     smtp.mail.yahoo.com.ph
MemberID@yahoo.pl     pop.mail.yahoo.com     smtp.mail.yahoo.com
MemberID@yahoo.se     pop.mail.yahoo.com     smtp.mail.yahoo.com
MemberID@yahoo.com.sg     pop.mail.yahoo.com.sg     smtp.mail.yahoo.com.sg
MemberID@yahoo.co.th     pop.mail.yahoo.co.th     smtp.mail.yahoo.co.th
MemberID@yahoo.com.tw     pop.mail.yahoo.com.tw     smtp.mail.yahoo.com.tw
MemberID@yahoo.co.uk     pop.mail.yahoo.co.uk     smtp.mail.yahoo.co.uk
MemberID@yahoo.com.vn     pop.mail.yahoo.com.vn     smtp.mail.yahoo.com.vn

Yahoo partner ISPs in the United States

E-mail address     Incoming mail server (POP3)     Outgoing mail server (SMTP)
MemberID@ameritech.net     pop.ameritech.yahoo.com     smtp.ameritech.yahoo.com
MemberID@flash.net     pop.flash.yahoo.com     smtp.flash.yahoo.com
MemberID@nvbell.net     pop.nvbell.yahoo.com     smtp.nvbell.yahoo.com
MemberID@pacbell.net     pop.pacbell.yahoo.com     smtp.pacbell.yahoo.com
MemberID@prodigy.net     pop.prodigy.yahoo.com     smtp.prodigy.yahoo.com
MemberID@sbcglobal.net     pop.sbcglobal.yahoo.com     smtp.sbcglobal.yahoo.com
MemberID@snet.net     pop.snet.yahoo.com     smtp.snet.yahoo.com
MemberID@swbell.net     pop.swbell.yahoo.com     smtp.swbell.yahoo.com
MemberID@verizon.net     incoming.yahoo.verizon.net     outgoing.yahoo.verizon.net
MemberID@wans.net     pop.wans.yahoo.com     smtp.wans.yahoo.com

Yahoo partner ISPs in the United Kingdom

E-mail address     Incoming mail server (POP3)     Outgoing mail server (SMTP)
MemberID@btinternet.com     mail.btinternet.com     mail.btinternet.com
MemberID@btopenworld.com     mail.btinternet.com     mail.btinternet.com

Yahoo partner ISPs in Canada

E-mail address     Incoming mail server (POP3)     Outgoing mail server (SMTP)
MemberID@rogers.com     pop.broadband.rogers.com     smtp.broadband.rogers.com
MemberID@nl.rogers.com     pop.broadband.rogers.com     smtp.broadband.rogers.com