《EXCEL甘特图模板 gantt-chart_L.xls》由会员分享，可在线阅读，更多相关《EXCEL甘特图模板 gantt-chart_L.xls（7页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、Gantt Chart Template by V 2008 Vertex42 LLC Project Name Company NameTodays Date:2/24/2009Tuesday (vertical red line) Project Lead: Name Start Date: 1/2/2012Monday 42First Day of Week (Mon=2):21/2/20121/3/20121/4/20121/5/20121/6/20121/7/20121/8/20121/9/20121/10/20121/11/20121/12/20121/13/20121/14/20
2、121/15/20121/16/20121/17/20121/18/20121/19/20121/20/20121/21/20121/22/20121/23/20121/24/20121/25/20121/26/20121/27/20121/28/20121/29/20121/30/20121/31/20122/1/20122/2/20122/3/20122/4/20122/5/20122/6/20122/7/20122/8/20122/9/20122/10/20122/11/20122/12/20122/13/20122/14/20122/15/20122/16/20122/17/20122
3、/18/20122/19/20122/20/20122/21/20122/22/20122/23/20122/24/20122/25/20122/26/20122/27/20122/28/20122/29/20123/1/20123/2/20123/3/20123/4/20123/5/20123/6/20123/7/20123/8/20123/9/20123/10/20123/11/20123/12/20123/13/20123/14/20123/15/20123/16/20123/17/20123/18/20123/19/20123/20/20123/21/20123/22/20123/23
4、/20123/24/20123/25/20123/26/20123/27/20123/28/20123/29/20123/30/20123/31/20124/1/20124/2/20124/3/20124/4/20124/5/20124/6/20124/7/20124/8/20124/9/20124/10/20124/11/20124/12/20124/13/20124/14/20124/15/20124/16/20124/17/20124/18/20124/19/20124/20/20124/21/20124/22/20124/23/20124/24/20124/25/20124/26/20
5、124/27/20124/28/20124/29/20124/30/20125/1/20125/2/20125/3/20125/4/20125/5/20125/6/20125/7/20125/8/20125/9/20125/10/20125/11/20125/12/20125/13/20125/14/20125/15/20125/16/20125/17/20125/18/20125/19/20125/20/20125/21/20125/22/20125/23/20125/24/20125/25/20125/26/20125/27/20125/28/20125/29/20125/30/20125
6、/31/20126/1/20126/2/20126/3/20126/4/20126/5/20126/6/20126/7/20126/8/20126/9/20126/10/20126/11/20126/12/20126/13/20126/14/20126/15/20126/16/20126/17/20126/18/20126/19/20126/20/20126/21/20126/22/20126/23/20126/24/20126/25/20126/26/20126/27/20126/28/20126/29/20126/30/20127/1/20127/2/20127/3/20127/4/201
7、27/5/20127/6/20127/7/20127/8/20127/9/20127/10/20127/11/20127/12/20127/13/20127/14/20127/15/20127/16/20127/17/20127/18/20127/19/20127/20/20127/21/20127/22/20127/23/20127/24/20127/25/20127/26/20127/27/20127/28/20127/29/20127/30/20127/31/20128/1/20128/2/20128/3/20128/4/20128/5/20128/6/20128/7/20128/8/2
8、0128/9/20128/10/20128/11/20128/12/20128/13/20128/14/20128/15/20128/16/20128/17/20128/18/20128/19/20128/20/20128/21/20128/22/20128/23/20128/24/20128/25/20128/26/2012 WBSTasks Task LeadStartEnd Duration (Days) % Complete Working Days Days Complete Days Remaining 02 - Jan - 12 09 - Jan - 12 16 - Jan -
9、12 23 - Jan - 12 30 - Jan - 12 06 - Feb - 12 13 - Feb - 12 20 - Feb - 12 27 - Feb - 12 05 - Mar - 12 12 - Mar - 12 19 - Mar - 12 26 - Mar - 12 02 - Apr - 12 09 - Apr - 12 16 - Apr - 12 23 - Apr - 12 30 - Apr - 12 07 - May - 12 14 - May - 12 21 - May - 12 28 - May - 12 04 - Jun - 12 11 - Jun - 12 18
10、- Jun - 12 25 - Jun - 12 02 - Jul - 12 09 - Jul - 12 16 - Jul - 12 23 - Jul - 12 30 - Jul - 12 06 - Aug - 12 13 - Aug - 12 20 - Aug - 12 1Task Category 1Name1/2/121/31/12300%22030 1.1Sub Task level 21/2/121/6/1250%505 1.2Sub Task level 21/7/121/11/1250%305 1.2.1Sub Task level 31/12/121/16/1250%305 1
11、.2.2Sub Task level 31/17/121/21/1250%405 1.3Sub Task level 21/22/121/26/1250%405 1.4Sub Task level 21/27/121/31/1250%305 2Task Category 2Name1/2/121/27/122625%20620 2.1Sub Task level 21/2/121/6/12525%514 2.2Sub Task level 21/9/121/13/12525%514 2.3Sub Task level 21/16/121/20/12525%514 2.4Sub Task lev
12、el 21/23/121/27/12525%514 3Task Category 3Name1/2/121/28/122750%201314 3.1Sub Task level 21/2/121/7/12650%533 3.2Sub Task level 21/9/121/14/12650%533 3.3Sub Task level 21/16/121/21/12650%533 3.4Sub Task level 21/23/121/28/12650%533 4Task Category 4Name1/2/121/21/12200%15020 4.1Sub Task level 21/2/12
13、1/6/1250%505 4.2Sub Task level 21/7/121/11/1250%305 4.3Sub Task level 21/12/121/16/1250%305 4.4Sub Task level 21/17/121/21/1250%405 Gantt Chart Template Pro Gantt Chart Template Pro is similar to this free version, but it is unlocked, more feature-packed, and includes other bonus content such as sam
14、ple project schedules. Already spent a lot of time working with this free version? Thats okay. In addition to downloading the Gantt Chart Template Pro files, you will be given the password for unlocking this spreadsheet. Learn More About Gantt Chart Template Pro - View screenshots - Watch demo video
15、s Benefits and Features of Gantt Chart Template Pro Unlocked (worksheets are not password-protected) By unlocking the free version or using Gantt Chart Template Pro, you will be able to use all of the functions and features available in Excel, such as formatting cells, inserting columns, and groupin
16、g rows. More Ways to Define a Task Choose from a larger set of template rows that provide more options for defining the Start date, End date, duration, and dependency of tasks. Define a task based on the - Start date and End date - Start date and Work days - Start date and Calendar days - Predecesso
17、r and End date - Predecessor and Work days - Predecessor and Calendar days Easily Create Task Dependencies Though you can still use your own formulas for creating task dependencies, the new Predecessor options make it very simple. One of the demo videos discusses this in detail. Exclude Holidays fro
18、m Work Days List holidays in a separate sheet that you want to exclude from work days. Sample Project Schedules To get a head start on defining your project schedule, you can use one of the 3 sample gantt charts: - Home Construction Project Schedule - Custom Software Project Schedule - Website Devel
19、opment Project Schedule New Excel 2007+ Version (XLSX) In addition to Gantt Chart Template Pro for Excel 2003, you will be able to download an XLSX version, for Excel 2007 or later, that allows you to easily color-code the bars of the gantt chart. Learn More About Gantt Chart Template Pro Gantt Char
20、t Template Pro is similar to this free version, but it is unlocked, more feature-packed, and includes other Already spent a lot of time working with this free version? Thats okay. In addition to downloading the Gantt Chart Template Pro files, you will be given the password for unlocking this spreads
21、heet. Learn More About Gantt Chart Template Pro Terms of Use 2006 - 2012 Vertex42 LLC. All rights reserved. This template is considered a copyrighted work under the Unites States and other copyright laws and is the property of Vertex42 LLC. The items listed below are additional points to help clarif
22、y how you may use this template. Not for Resale or Public Sharing You may make archival copies and customize this template only for your personal use or use within your company or organization and not for resale or public sharing. You may not remove or alter any logo, trademark, copyright, disclaime
23、r, brand, terms of use, attribution, or other proprietary notices or marks within this template. This template and any customized or modified version of this template may NOT be sold, distributed, published to an online gallery, hosted on a website, or placed on a public server. Limited Private Shar
24、ing Provided that you observe the above terms, you may share your edited version of this template *privately* with those specific people who *require* access to it within your immediate family, organization, or company. * Privately means only accessible to those few people who you expressively give
25、permission to view or edit your file. It is your responsibility to ensure that adequate security measures are used so that your file is not available to the public. * Examples of acceptable private sharing with people who require access may include (a) sharing a budget spreadsheet with a spouse, (b)
26、 sharing a project schedule with your project team, or (c) sharing a timesheet with your employee or manager. See the following page on V for the complete license agreement and examples of other allowed uses: Disclaimer This template is provided for informational or educational use only and is not i
27、ntended to be relied on as medical, financial, legal, or other professional advice. Vertex42 LLC makes no guarantee or representations about this template, or the accuracy or completeness of the content contained within this template. Vertex42 LLC encourages you to seek the aid of a qualified professional before making decisions regarding health, financial, or legal issues.