Excel甘特图（进度横道图）.xls

《Excel甘特图（进度横道图）.xls》由会员分享，可在线阅读，更多相关《Excel甘特图（进度横道图）.xls（7页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、Gantt Chart Template by V 2008 Vertex42 LLC 项项目目名名称称 公司名称当前日期:2015/2/28星期六 (垂直红线) 项目负责人: 姓名 开始日期: 2015/1/1星期四 42一周的第一天（周一=2）:22014/12/292014/12/302015/1/22015/1/32015/1/42015/1/52015/1/62015/1/72015/1/82015/1/92015/1/102015/1/122015/1/132015/1/142015/1/152015/1/162015/1/172015/1/182015/1/192015/1/20

2、2015/1/222015/1/232015/1/242015/1/252015/1/262015/1/272015/1/282015/1/292015/1/302015/2/22015/2/32015/2/42015/2/52015/2/62015/2/72015/2/82015/2/92015/2/102015/2/122015/2/132015/2/142015/2/152015/2/162015/2/172015/2/182015/2/192015/2/202015/2/222015/2/232015/2/242015/2/252015/2/262015/2/272015/2/2820

3、15/3/22015/3/32015/3/42015/3/52015/3/62015/3/72015/3/82015/3/92015/3/102015/3/122015/3/132015/3/142015/3/152015/3/162015/3/172015/3/182015/3/192015/3/202015/3/222015/3/232015/3/242015/3/252015/3/262015/3/272015/3/282015/3/292015/3/302015/4/22015/4/32015/4/42015/4/52015/4/62015/4/72015/4/82015/4/9201

4、5/4/102015/4/122015/4/132015/4/142015/4/152015/4/162015/4/172015/4/182015/4/192015/4/202015/4/222015/4/232015/4/242015/4/252015/4/262015/4/272015/4/282015/4/292015/4/302015/5/22015/5/32015/5/42015/5/52015/5/62015/5/72015/5/82015/5/92015/5/102015/5/122015/5/132015/5/142015/5/152015/5/162015/5/172015/

5、5/182015/5/192015/5/202015/5/222015/5/232015/5/242015/5/252015/5/262015/5/272015/5/282015/5/292015/5/302015/6/22015/6/32015/6/42015/6/52015/6/62015/6/72015/6/82015/6/92015/6/102015/6/122015/6/132015/6/142015/6/152015/6/162015/6/172015/6/182015/6/192015/6/202015/6/222015/6/232015/6/242015/6/252015/6/

6、262015/6/272015/6/282015/6/292015/6/302015/7/22015/7/32015/7/42015/7/52015/7/62015/7/72015/7/82015/7/92015/7/102015/7/122015/7/132015/7/142015/7/152015/7/162015/7/172015/7/182015/7/192015/7/202015/7/222015/7/232015/7/242015/7/252015/7/262015/7/272015/7/282015/7/292015/7/302015/8/22015/8/32015/8/4201

7、5/8/52015/8/62015/8/72015/8/82015/8/92015/8/102015/8/122015/8/132015/8/142015/8/152015/8/162015/8/172015/8/182015/8/192015/8/202015/8/222015/8/23 WBS任任务务责责任任人人开开始始结结束束 工期（天数） % 完成 工作日 日历天内完成 日期剩余天数 2014年12月29日 2015年1月5日 2015年1月12日 2015年1月19日 2015年1月26日 2015年2月2日 2015年2月9日 2015年2月16日 2015年2月23日 2015年

8、3月2日 2015年3月9日 2015年3月16日 2015年3月23日 2015年3月30日 2015年4月6日 2015年4月13日 2015年4月20日 2015年4月27日 2015年5月4日 2015年5月11日 2015年5月18日 2015年5月25日 2015年6月1日 2015年6月8日 2015年6月15日 2015年6月22日 2015年6月29日 2015年7月6日 2015年7月13日 2015年7月20日 2015年7月27日 2015年8月3日 2015年8月10日 2015年8月17日 1Task Category 1姓名2015/1/1 2015/1/3030

9、0%22030 1.1Sub Task level 22015/1/12015/1/550%305 1.2Sub Task level 22015/1/6 2015/1/1050%405 1.2.1Sub Task level 32015/1/11 2015/1/1550%405 1.2.2Sub Task level 32015/1/16 2015/1/2050%305 1.3Sub Task level 22015/1/21 2015/1/2550%305 1.4Sub Task level 22015/1/26 2015/1/3050%505 2Task Category 2姓名2015

10、/1/1 2015/1/232325%17518 2.1Sub Task level 22015/1/12015/1/5525%314 2.2Sub Task level 22015/1/6 2015/1/10525%414 2.3Sub Task level 22015/1/12 2015/1/16525%514 2.4Sub Task level 22015/1/19 2015/1/23525%514 3Task Category 3姓名2015/1/1 2015/1/282850%201414 3.1Sub Task level 22015/1/12015/1/6650%433 3.2S

11、ub Task level 22015/1/9 2015/1/14650%433 3.3Sub Task level 22015/1/16 2015/1/21650%433 3.4Sub Task level 22015/1/23 2015/1/28650%433 4Task Category 4姓名2015/1/2 2015/1/21200%14020 4.1Sub Task level 22015/1/22015/1/650%305 4.2Sub Task level 22015/1/7 2015/1/1150%305 4.3Sub Task level 22015/1/12 2015/1

12、/1650%505 4.4Sub Task level 22015/1/17 2015/1/2150%305 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 sample project schedules. Already spent a lot of time working with this free ver

13、sion? 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 videos Benefits and Features of Gantt Chart Template Pro Unlocked (worksheets are

14、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 grouping rows. More Ways to Define a Task Choose from a larger set of template rows

15、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 - Predecessor and End date - Predecessor and Work days - Predecessor and Calendar days Ea

16、sily 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 from Work Days List holidays in a separate sheet that you want to exclude from w

17、ork 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 Development Project Schedule New Excel 2007+ Version (XLSX) In addition to Gantt C

18、hart 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 Chart Template Pro is similar to this free version, but it is unlocked, more feat

19、ure-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 spreadsheet. Learn More About Gantt Chart Template Pro Terms of Use 2006 - 2012 Vert

20、ex42 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 clarify how you may use this template. Not for Resale or Public Sharing You may mak

21、e 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, disclaimer, brand, terms of use, attribution, or other proprietary notices or marks wi

22、thin 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 Sharing Provided that you observe the above terms, you may share your edited vers

23、ion 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 permission to view or edit your file. It is your responsibility to ensure tha

24、t 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) sharing a project schedule with your project team, or (c) sharing a timeshee

25、t 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 intended to be relied on as medical, financial, legal, or other professional a

26、dvice. 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.