五星级的Excel项目管理甘特图模板.doc

Gantt ChartType your project name hereTask LevelWBSTasksStartdd/mmmmm/dd/yyyyEnddd/mmmmm/dd/yyyyCalendarDaysExcludeWeekendsGantt ColorPredecessorsTask OwnerRemarksStatus31-Jan-Wed01-Feb-Thu02-Feb-Fri03-Feb-Sat04-Feb-Sun05-Feb-Mon06-Feb-Tue07-Feb-Wed08-Feb-Thu09-Feb-Fri10-Feb-Sat11-Feb-Sun12-Feb-Mon13-Feb-Tue14-Feb-Wed15-Feb-Thu16-Feb-Fri17-Feb-Sat18-Feb-Sun19-Feb-Mon20-Feb-Tue21-Feb-Wed22-Feb-Thu23-Feb-Fri24-Feb-Sat25-Feb-Sun26-Feb-Mon27-Feb-Tue28-Feb-Wed01-Mar-Thu02-Mar-Fri03-Mar-Sat04-Mar-Sun05-Mar-Mon06-Mar-Tue07-Mar-Wed08-Mar-Thu09-Mar-Fri10-Mar-Sat11-Mar-Sun12-Mar-Mon11Level 101-Feb-Thu20-Feb-Tue2012xRain1.S0000000000000000000000000000000000000000021.1Level 201-Feb-Thu13-Feb-Tue139.Waner.TCompleted0000000000000000000000000000000000000000031.1.1Level 301-Feb-Thu05-Feb-Mon53.Clemm.M10%0000000000000000000000000000000000000000031.1.2Level 306-Feb-Tue13-Feb-TueTina.N40%00000000000000000000000000000000000000000Level 406-Feb-Tue08-Feb-ThuEmme.EPartial00000000000000000000000000000000000000000Level 409-Feb-Fri13-Feb-Tue53x1.1.2Emme.E0000000000000000000000000000000000000000021.2Level 214-Feb-Wed20-Feb-Tue.2Rain.S0000000000000000000000000000000000000000031.2.1Level 314-Feb-Wed15-Feb-ThuChar.L0000000000000000000000000000000000000000031.2.2Level 316-Feb-Fri20-Feb-Tue511.2.1Char.L0000000000000000000000000000000000000000012Level 121-Feb-Wed09-Mar-Fri1713.Clemm.M0000000000000000000000000000000000000000022.1Level 221-Feb-Wed09-Mar-Fri1713.Waner.T0000000000000000000000000000000000000000032.1.1Level 321-Feb-Wed27-Feb-Tue75.Tina.N0000000000000000000000000000000000000000032.1.2Level 328-Feb-Wed09-Mar-Fri108xRain.S00000000000000000000000000000000000000000-Project Title:Sample ProjectProject Manager:Company:Client:Last Update Date:Template Version:XL-EasyGantt V2.4Notes:XL-EasyGantt V2.4DataSheetNote:Non-Working Days Table (Content Editable)Project Resource Table (Content Editable)DateNon-Working Days / HolidaysProject Resource NameResource AliasResource RoleEmail AddressContact NumberFax NumberCostTime ZoneRemarks1/Jan/2007New Years DayRain SamdeRain.SProject Manager18/Feb/2007Chinese New Year Day 1Waner TidnabWaner.TProject Secretary19/Feb/2007Chinese New Year Day 2Clemmie MilClemm.MTeam Leader20/Feb/2007Chinese New Year Day Make UpTina NixxTina.NProject Member6/Apr/2007Good FridayEmme EnilEmme.EProject Member1/May/2007Labour DayChar NilChar.LPurchaser31/May/2007Vesak Day9/Aug/2007National Day13/Oct/2007Hari Raya Puasa8/Nov/2007Deepavali20/Dec/2007Hari Raya Haji25/Dec/2007Christmas DayDistribution and Modification LogFill up your contact information below if you are distributing modified copies of XL-EasyGanttClick Here to Check World HolidaysProject Data SheetThis data worksheet is use by XL-EasyGantt to check on the Non-Working days to calculate the tasks duration (duration excluding weekends and non-working days) and to generate the Resource Picklist. Please do not delete. This worksheet is protected without a password. However, you do not need to unprotect the worksheet for adding/changing the data within the tables below. These cells are unlocked. You can click on the data area to enter the Non-Working Days and manage the Project Resource Table. You need to unprotect the worksheet to add and remove rows. Take note that Adding or Removing Rows may affect the reference Range if not done correctly.This column is used for the Resource Pick List. Range name: RAliasAutoRepairXLEasyGantt23Type your project name hereTask LevelWBSTasksStartdd/mmmmm/dd/yyyyEnddd/mmmmm/dd/yyyyCalendarDaysExcludeWeekendsGantt ColorPredecessorsTask OwnerRemarksStatus31-Jan-Wed01-Feb-Thu02-Feb-Fri03-Feb-Sat04-Feb-Sun05-Feb-Mon06-Feb-Tue07-Feb-Wed08-Feb-Thu09-Feb-Fri10-Feb-Sat11-Feb-Sun12-Feb-Mon13-Feb-Tue14-Feb-Wed15-Feb-Thu16-Feb-Fri17-Feb-Sat18-Feb-Sun19-Feb-Mon20-Feb-Tue21-Feb-Wed22-Feb-Thu23-Feb-Fri24-Feb-Sat25-Feb-Sun26-Feb-Mon27-Feb-Tue28-Feb-Wed01-Mar-Thu02-Mar-Fri03-Mar-Sat04-Mar-Sun05-Mar-Mon06-Mar-Tue07-Mar-Wed08-Mar-Thu09-Mar-Fri10-Mar-Sat11-Mar-Sun12-Mar-Mon11Level 101-Feb-Thu20-Feb-Tue2012xRain.S0000000000000000000000000000000000000000021.1Level 201-Feb-Thu13-Feb-Tue139.Waner.TCompleted0000000000000000000000000000000000000000031.1.1Level 301-Feb-Thu05-Feb-Mon53.Clemm.M10%0000000000000000000000000000000000000000031.1.2Level 306-Feb-Tue13-Feb-TueTina.N40%00000000000000000000000000000000000000000Level 406-Feb-Tue08-Feb-ThuEmme.EPartial00000000000000000000000000000000000000000Level 409-Feb-Fri13-Feb-Tue53x1.1.2Emme.E0000000000000000000000000000000000000000021.2Level 214-Feb-Wed20-Feb-Tue.2Rain.S0000000000000000000000000000000000000000031.2.1Level 314-Feb-Wed15-Feb-ThuChar.L0000000000000000000000000000000000000000031.2.2Level 316-Feb-Fri20-Feb-Tue511.2.1Char.L0000000000000000000000000000000000000000012Level 121-Feb-Wed09-Mar-Fri1713.Clemm.M0000000000000000000000000000000000000000022.1Level 221-Feb-Wed09-Mar-Fri1713.Waner.T0000000000000000000000000000000000000000032.1.1Level 321-Feb-Wed27-Feb-Tue75.Tina.N0000000000000000000000000000000000000000032.1.2Level 328-Feb-Wed09-Mar-Fri108xRain.S00000000000000000000000000000000000000000-Project Title:Sample ProjectProject Manager:Company:Client:Last Update Date:Template Version:XL-EasyGantt V2.4Notes:XL-EasyGantt V2.4DataSheet2007en88aProject System Data SheetProject Reference (System Generated)Registration and Usage InformationRegistration Log(TRU)Users Log (TFN)First time useProject Calendar Start CellM3Registered Excel Username:Total0Total0Project Start Date31-Jan-WedRegistered Username:Project End Date12-Mar-MonRegistered On:Dont Show Macro Help0Registration Status:0Expiry Date:Number of Times Saved by Current Registered User (CTS):0Total Number of Times Template Saved (TTS):0XL-EasyGantt Unique Number (UID):Version Number (VSN):2.4Keep as text fieldUse to store total number of times this template has been saved.User to save the number of times this current registered user has saved the template.Use to store the registration status. 1 for registered, 0 for not registered. Reset to 0 if user choose action to unlock for registration.This is Excel Username.Based on ExcelUsernameT&C1028.xleasygantt3Once you have read and accepted the license of use, you can hide this Terms & Condictions by scrolling to the bottom of this page and click I Accept.Terms, Conditions and License of UseWebsite:http:/.xleasyganttHelp:You can find more information on how to use this Template at http:/.xleasygantt/learntouse.asp or click on the HELP button on the Gantt Chart Worksheet.License Agreement:You should carefully read the following terms and conditions before using this software / template. This license applies to all Free versions of XL-EasyGantt till the next license update.Your use of this template indicates your acceptance of this License Agreement and Warranty. XL-EasyGantts author and owner reserves the rights to change the terms of this License, as well as the XL-EasyGantt features and design anytime for the current or any future versions without any notifications or announcements.Limited Open Source:The cells that contain this license wordings are protected to protect the recipients should they be receiving modified copies of this template through other sources other than downloading directly from .xleasygantt.XL-EasyGantt aims to remain as an open source Excel Template (worksheet formulas only). While users are free to access the unprotected formulas in the worksheets, the Excel VBA source codes in XL-EasyGantt are protected and are copyrighted by the author and will not be made available to the users. The author is not obligated to response to requests for source code access or to inform the users / requestors should their requests to access the source codes is being rejected.Users who wish to learn the VBA / Macros used in this template may refer to the highlights at http:/.xleasygantt.Modifications and Distributions:You may freely use, distribute and share the original version of this template with your friends, colleagues and clients for personal, educational and commercial use. When distributing or forwarding this template or the resulting schedules and Gantt charts, you agree to distribute with this Terms & Conditions attached. At no time you should delete this Terms & Conditions. Using or distributing copies of XL-EasyGantt without this Terms and Conditions of use is in breach of the usage rights and you should delete the copies from your computer or any media immediately.Virus Free:The original unmodified version may be freely distribute to other parties except that If you modify the formulas, macro, VBA codes or this template for re-distribution, you agree to indicate clearly in this template that this is a modified version of the XL-EasyGantt and indicate clearly either your contact information and you shall be fully responsible for the modified copies. You should ensure that the copies that you distribute is free from virus and malicious codes.The original template is made available for download free of virus or malicious codes. However, the author of XL-EasyGantt cannot guarantee that the copies that you have received directly from XL-EasyGantt website or through any other channels will be free of virus(es) due to the transmission nature of the Internet. You agree to exercise your own care to protect yourself against any virus and would not hold XLEasyGantt or its author responsible for any damages or losses due the a corrupted copy of XL-EasyGantt received through any means.Grant of License and Registration:No Registration or Licensing fee is required for the use of the free version of this template. You can determine if you are using the free version by looking at the About box which will indicates if your version is a Free version. The author reserves the rights to charge a fee for future versions from XL-EasyGantt version 2.3 onwards if he decides to do so. You are also encouraged to register with .xleasygantt if you wish to be updated on new versions and news related to XL-EasyGantt from time to time. Registration does not grant you the ownership of XL-EasyGantt which remains as the property of the author of XL-EasyGantt. The free license only provides your with the license to use the software / template.Non-Competition:This license grant you the use and distribution of XL-EasyGantt. When distributing XL-EasyGantt templates you agree to keep the XL-EasyGantt logo and links within the templates at all time. You agree not to set up a competitive web-site or other media distribution channels in any form be it for non-profit, direct or indirect profit through any means including web advertisements, or self publicity unless you have obtained written permission from the author of XL-EasyGantt. If you have gained access to the source codes of XL-EasyGantt in anyway or through any means, you agree not to set up competitive software and/ or templates for downloads based on XL-EasyGantts codes be it for profit or non-profit. All downloads should be redirected to http:/.xleasygantt. At all time, your modified copies of templates should make reference and acknowledgement of XL-EasyGantt by referring to http:/.XLEasyGantt.Graphics and Icons:All icons and graphics contained in XL-EasyGantt template remains as the property of XL-EasyGantt and its author and you must not extract or capture them in any way for reuse in any other purposes.Hacking:You agree not to hack or reverse engineer this template in any way to gain access to its source codes. If you have received an unprotected copy of XL-EasyGantt, please inform the author immediately through .xleasygantt.Reserved Rights:The author of XL-EasyGantt reserves the rights to change this original template or to discontinue the download, upgrade, issuing of source codes or any discussions relating to the template anytime without any announcement or justification.Data TransferNo personal data will be transferred to xleasygantt when you use this template. During initialization, XL-EasyGantt may launch an Internet Browser to check for the availability of any new versions. Only the version number of this XL-EasyGantt, registration status and usage numbers will be transferred. Your use of this XL-EasyGantt automatically grant XL-EasyGantt the rights to transmit these information to xleasygantt servers. Disclaimer of Warranties:This template and the accompanying files is distributed "as is" and without Warranties as to performance of merchantability or any other Warranties whether expressed or implied. No Warranty of fitness for a particular purpose is offered.No Liability for Consequential Damages:The author of XL-EasyGantt shall not be liable for data loss, damages, loss of profits or and other kind of loss while using or misusing this template. The user assumes the entire risk of using the program / template. No support through any channels will be provided for the use of this template.Termination:If you do not agree with the terms of this License or fail to comply with the terms of this License, the License is automatically and immediately terminated. You then must immediately cease the use of the product and remove XL-EasyGantt file(s) from your system and other media.Original Version Verification:If you suspect that the version that you have received is not the original version of XL-EasyGantt or suspect that it has been modified to contain malicious codes, please seek verification and download the original copy from http:/.xleasygantt.Original License Location:The original license at http:/.xleasygantt/license.asp supersedes and overwrites all licenses that may be included in the Excel templates. It is your responsibility to check that you have verified that the license at xleasygantt and agreed to it before using or distributing the template.Questions:Should you have any questions concerning this License Agreement, or if you desire to contact the author please visit: http:/.xleasygantt.xleasyganttEnableMacroHelp1028You are seeing this page because you did not enable your Excel Macro.To take full advantage of XL-EasyGantt, you would need to turn on your Excel Macro.How to Enable Excel Macro (in Excel 2003)You can do this by closing and re-launching XL-EasyGantt. During the start-up, you will be prompted to with a Security Warning Box, click Enable Macro to proceed.If you do not see this Security Warning Box, you might have set you Macro Security level to High. You can change the Macro Security Level by going to:Menu> Tools > Macro > Security and set the Security to Medium as below. After which you can re-launch XL-EasyGantt and click Enable Macro to proceed.Enable Macro HelpYou are seeing this page because you did not enable your Excel Macro.To take full advantage of XL-EasyGantt, you would need to turn on your Excel Macro.How to Enable Excel Macro (in Excel 2003)You can do this by closing and re-launching XL-EasyGantt. During the start-up, you will be prompted to with a Security Warning Box, click Enable Macro to proceed.If you do not see this Security Warning Box, you might have set you Macro Security level to High. You can change the Macro Security Level by going to:Menu> Tools > Macro > Security and set the Security to Medium as below. After which you can re-launch XL-EasyGantt and click Enable Macro to proceed.Terms & Conditions.xleasyganttOnce you have read and ac