专业的用Excel做的Project甘特图Gantt Chart in Excel

2013-7-1 2013-7-16 Corrective action plan for soft spool spool M4 sample with chamfer and CAR-13001 精密的完善 Enter Project Range center hole angle deviation Start Date 07/01/13 07/16/13 BERGER PRECISION (KUNSHAN) Co., Ltd. 1 Work Zoom (enter 1forDaily,7 for Weekly)-- -二三四 五 三三四 六 estimated 1-7月-13 5-7月-13 6-7月-13 10-7月-13 -7月-13 12-7月-13 7月-13 7月-13 13-7月-13 14-7月-13 7月-13 16-7月-13 Person Work Work 7月 Phase /Task Responsible 5 Start Date End Date done Left Sp0ol 700.001-F347555.01-0021 1-7月-13 16-7月-13 16.00 Turning(with differ chamfers and new Michael Meyer 1-7月-13 3-7月-13 3.00 center hole dril) QA measuring Steve.Feng 4-7月-13 5-7月-13 2.00 0.00 Sand blasting Michael Meyer 8-7月-13 8-7月-13 1.00 0.00 Grinding and brushing Michael Meyer 9-7月-13 10-7月-13 2.00 0.00 QA Measuring Steve.Feng 11-7月-13 12-7月-13 2.00 0.00 Prepare report Steve.Feng 15-7月-13 16-7月-13 2.00 0.00 The sand blasting machine was disassemblied and will be here within three months.So this project starts from 1st.July.2013 ,the center hole drill for 120°±10° will be arrive before the sand blasting machine. 2013-7-1 2013-7-16 Corrective action plan for soft spool spool M4 sample with chamfer and CAR-13001 精密的完善 Enter Project Range center hole angle deviation Start Date 07/01/13 07/16/13 BERGER PRECISION (KUNSHAN) CO., Ltd. Zoom (enter 1 for Daily, 7 for Weekly)--> Work 1 一二三四五 二三三四 estimated K 33 月-13 7月-13 3 13 12-7月-13 13-7月-13 4-7月-13 3 7月-13 月-13 16-7月-13 Person 7月- 10-7月－ 月 11-7月- Work Work E Phase / Task Responsible StartDate End Date done Left 2013-7-1 2013-7-16 Corrective action plan for soft spool spool M4 sample with chamfer and Enter Project Range center hole angle deviation Start Date 07/01/13 07/16/13 Zoom (enter 1 for Daily, 7 for Weekly)-- 1 Person Phase / Task Responsible Start Date End Date Sp0ol 700.001-F347555.01-0021 1-7月-13 16-7月-13 Turning(with difer chamfers and new Michael Meyer 1-7月-13 3-7月-13 center hole dril) QA