{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Project Plan","Project weekly report","Project monthly report ","Project doc managment","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Project Plan","index":0,"n_rows":174,"n_cols":16,"rows_kept":174,"cut":false,"hidden":false,"merged":[[102,1,102,5],[103,1,103,5],[54,1,54,5],[64,1,64,5],[67,1,67,5],[72,1,72,5],[71,1,71,5],[63,1,63,5],[85,1,85,5],[89,1,89,5],[90,1,90,5],[87,1,87,5],[91,1,91,5],[92,1,92,5],[95,1,95,5],[96,1,96,5],[98,1,98,5],[100,1,100,5],[101,1,101,5],[59,1,59,5],[61,1,61,5],[62,1,62,5],[60,1,60,5],[53,1,53,5],[55,1,55,5],[65,1,65,5],[66,1,66,5],[78,1,78,5],[68,1,68,5],[70,1,70,5],[93,1,93,5],[94,1,94,5],[86,1,86,5],[88,1,88,5],[69,1,69,5],[74,1,74,5],[75,1,75,5],[76,1,76,5],[77,1,77,5],[79,1,79,5],[73,1,73,5],[81,1,81,5],[80,1,80,5],[82,1,82,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[0,0,0,15],[2,12,2,15],[3,12,3,15],[4,12,4,15],[5,12,5,15],[1,11,1,15],[15,1,15,5],[6,12,6,15],[7,12,7,15],[11,11,11,12],[8,12,8,15],[9,12,9,15],[1,8,1,10],[2,8,2,10],[3,8,3,10],[4,0,4,1],[4,2,4,5],[4,6,4,7],[7,1,7,4],[8,1,8,4],[8,5,8,6],[9,1,9,4],[9,5,9,6],[10,1,10,4],[18,1,18,5],[1,0,1,1],[2,0,2,1],[2,6,2,7],[12,11,12,15],[1,6,1,7],[21,1,21,5],[22,1,22,5],[23,1,23,5],[5,0,5,10],[3,0,3,1],[3,6,3,7],[1,2,1,5],[2,2,2,5],[3,2,3,5],[6,1,6,4],[6,5,6,6],[7,5,7,6],[14,1,14,5],[19,1,19,5],[20,1,20,5],[13,0,13,15],[10,5,10,6],[10,11,10,12],[4,8,4,10],[10,13,10,15],[11,13,11,15],[11,1,11,4],[11,5,11,6],[12,1,12,4],[12,5,12,6],[16,1,16,5],[17,1,17,5],[34,1,34,5],[36,1,36,5],[35,1,35,5],[38,1,38,5],[24,1,24,5],[25,1,25,5],[37,1,37,5],[26,1,26,5],[27,1,27,5],[32,1,32,5],[33,1,33,5],[28,1,28,5],[31,1,31,5],[29,1,29,5],[30,1,30,5],[45,1,45,5],[49,1,49,5],[52,1,52,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[47,1,47,5],[48,1,48,5],[50,1,50,5],[51,1,51,5],[46,1,46,5],[140,7,140,11],[148,1,148,5],[149,1,149,5],[150,1,150,5],[151,1,151,5],[152,1,152,5],[153,1,153,5],[140,1,140,5],[141,1,141,5],[142,1,142,5],[143,1,143,5],[144,1,144,5],[145,1,145,5],[146,1,146,5],[147,1,147,5],[135,1,135,5],[172,1,172,5],[173,1,173,5],[163,1,163,5],[164,1,164,5],[165,1,165,5],[166,1,166,5],[167,1,167,5],[168,1,168,5],[169,1,169,5],[170,1,170,5],[171,1,171,5],[111,1,111,5],[107,1,107,5],[162,1,162,5],[109,1,109,5],[110,1,110,5],[154,1,154,5],[155,1,155,5],[156,1,156,5],[157,1,157,5],[158,1,158,5],[159,1,159,5],[160,1,160,5],[161,1,161,5],[133,1,133,5],[139,1,139,5],[137,1,137,5],[138,1,138,5],[134,1,134,5],[125,1,125,5],[126,1,126,5],[127,1,127,5],[136,1,136,5],[129,1,129,5],[130,1,130,5],[104,1,104,5],[84,1,84,5],[83,1,83,5],[97,1,97,5],[99,1,99,5],[105,1,105,5],[108,1,108,5],[131,1,131,5],[132,1,132,5],[121,1,121,5],[120,1,120,5],[119,1,119,5],[115,1,115,5],[106,1,106,5],[113,1,113,5],[112,1,112,5],[128,1,128,5],[114,1,114,5],[122,1,122,5],[123,1,123,5],[124,1,124,5],[117,1,117,5],[118,1,118,5],[116,1,116,5]]}
["DFS Global Engineering -  Growth Markets\nProject Plan"]
["Project Name",null,"VR Monitoring system",null,null,null,"WAP #",null,"CHE20018",null,null,"New Product Development (NPD) Process 1.0"]
["Region",null,"Guangzhou",null,null,null,"Project Tiering",null,"TIER 1",null,null,"No","Stage"]
["Budget($)",{"$nulls":5},"Plan Man-days",{"$nulls":4},"1900-01-01","Concept Entry"]
["Project Manager",null,"Tao Yongqiang",null,null,null,"Team Members",null,"Wu Jianhong     Chen Shuo ",null,null,"1900-01-02","Stage 1：Requirements"]
["Version Change List",{"$nulls":10},"1900-01-03","Stage 2: Planning"]
["Version","Description of Change",null,null,null,"Reason ",null,"Date","Edit","Audit ","Approval","1900-01-04","Stage 3: Implementation"]
["v0.1","Initial ",{"$nulls":9},"1900-01-05","Stage 4: Beta"]
["v0.2",{"$nulls":10},"1900-01-06","Stage 5: Pre-Production "]
["v0.3",{"$nulls":10},"1900-01-07","Stage 6: Hand-Off"]
["v0.4",{"$nulls":10},"Current Stage:",null,"\nSelect NPI Stage from drop down box, and set color as follows:\n\nSet Cell color to either Green, Yellow, or Red based on following definitions:\nGreen - Project/Deliverable on Track per committed plan\nYellow - Project/Deliverable off track due to specific issue but team is working plan to recover. No Executive involvement required.Red - Project off track, recovery plan not yet identified. Executive escalation either coming or ongoing."]
["v0.5",{"$nulls":10},"Current Completion(%):"]
["v0.6",{"$nulls":10},"Remark: Update this report to manager on Thursday(AM) weekly."]
["Project Plan/Status"]
["No","WBS",{"$nulls":4},"Milestone","Plan Man-days","Owner","Plan start date","Actual start date","Plan end date","Actual end date","Status","Key Deliverable","Issues/comments"]
["1900-01-01","Stage 1：Requirements",{"$nulls":7},"2017-04-12","2017-04-12","2017-04-12","2017-04-12","Not start"]
["1900-01-01T02:24:00","PPR",{"$nulls":11},"Finished"]
["1.1.1","PPR 市场输入",{"$nulls":6},"梁重杰",{"$nulls":4},"Finished"]
["1.1.2","PPR技术评估",{"$nulls":6},"陶永强",{"$nulls":4},"Finished"]
["1.1.3","PPR评审",{"$nulls":6},"梁重杰",{"$nulls":4},"Finished"]
["1.1.4","PPR发布",{"$nulls":4},"Yes",null,"梁重杰",{"$nulls":4},"Finished"]
["1900-01-01T04:48:00","核心团队",{"$nulls":11},"Finished"]
["1.2.1","Product manager 梁重杰",{"$nulls":11},"Finished"]
["1.2.2","Program manager(PMO) ",{"$nulls":11},"Finished"]
["1.2.3","Technical leader 陶永强",{"$nulls":11},"Finished"]
["1900-01-01T07:12:00","Gate1 Review at PIC 关卡评审",{"$nulls":4},"Yes",{"$nulls":6},"Finished"]
["1900-01-02","Stage 2: Planning  计划"]
["1900-01-02T02:24:00","产品需求规格书"]
["2.1.1"]
["2.1.2"]
["2.1.3"]
["1900-01-02T04:48:00","技术方案"]
["2.2.1","设计需求讨论和制定",{"$nulls":6},"陶永强","2019-01-02","2019-01-04","2019-01-04","2019-01-04","Finished"]
["2.2.2","设计需求文档评审",{"$nulls":6},"陶永强","2019-01-12","2019-01-15","2019-01-15","2019-01-15","Finished"]
["2.2.3","设计需求完成",{"$nulls":6},"陶永强","2019-01-12","2019-01-15","2019-01-15","2019-01-15","Finished"]
["1900-01-02T07:12:00","项目计划"]
["2.3.1","项目计划制定",{"$nulls":6},"陶永强","2019-01-15","2019-01-15","2019-01-15","2019-01-15","Finished"]
["2.3.2","项目计划评审",{"$nulls":6},"陶永强","2019-01-12","2019-01-15","2019-01-15","2019-01-15"]
["2.3.3","项目启动",{"$nulls":6},"陶永强","2019-01-12","2019-01-15","2019-01-15","2019-01-15","Finished"]
["2.3.4"]
["1900-01-02T09:36:00","关卡评审"]
["2.4.1"]
["2.4.2"]
["2000-01-03","Stage 3: Implementation  实施"]
["3.1.1.1","硬件研发"]
["3.1.1.1.1","设计VRC36控制板"]
["3.1.1.1.2","原理图设计",{"$nulls":6},"喻敏","2019-01-15","2019-01-15","2019-01-25",null,"Delay"]
["3.1.1.1.3","原理图评审",{"$nulls":6},"喻敏","2015-01-25","2019-02-25","2019-01-28",null,"Delay"]
["3.1.1.1.4","原理图修改或完成",{"$nulls":6},"喻敏","2019-01-28","2019-02-25","2019-01-31",null,"Delay"]
["3.1.1.1.5","PCB设计",{"$nulls":6},"喻敏","2019-02-16",null,"2019-02-26",null,"Delay"]
["3.1.1.1.6","PCB评审",{"$nulls":6},"喻敏","2019-02-26",null,"2019-02-27"]
["3.1.1.1.7","PCB修改或完成",{"$nulls":6},"喻敏","2019-02-27",null,"2019-02-28"]
["3.1.1.1.8","硬件打样",{"$nulls":6},"喻敏","2019-03-01",null,"2019-03-20"]
["3.1.1.1.9","硬件调试",{"$nulls":6},"喻敏","2019-03-20",null,"2019-03-25"]
["3.1.1.1.10","样品评审",{"$nulls":6},"喻敏","2019-03-26",null,"2019-03-29"]
["3.1.1.1.11","设计完成",{"$nulls":6},"项目组","2019-03-27",null,"2019-03-30"]
["3.1.1.2.1","托肯RS485通信控制板本地化"]
["3.1.1.2.2","原理图绘制",{"$nulls":6},"喻敏","2015-01-25",null,"2019-01-28",null,"Not start"]
["3.1.1.2.3","PCB绘制",{"$nulls":6},"喻敏","2019-02-16",null,"2019-02-26",null,"Not start"]
["3.1.1.2.4","打样",{"$nulls":6},"喻敏","2019-03-01",null,"2019-03-30"]
["3.1.1.2.5","调试",{"$nulls":6},"喻敏","2019-03-20",null,"2019-03-25"]
["3.1.1.2.6","样品评审",{"$nulls":6},"喻敏","2019-03-26",null,"2019-03-29"]
["3.1.1.2.7","设计完成",{"$nulls":6},"项目组","2019-03-27",null,"2019-03-30"]
["3.1.2.1","软件开发"]
["3.1.2.1","制定协议",{"$nulls":6},"车娟 陈硕","2019-01-15",null,"2019-01-18"]
["3.1.2.2","协议评审",{"$nulls":6},"车娟","2019-01-19",null,"2019-01-19"]
["3.1.2.3","制定协议完成",{"$nulls":6},"车娟","2019-01-20",null,"2019-01-20",null,"Finished"]
["3.1.2.2","编写软件流程图\n（气体流量计通信、加油脉冲采集、锁枪、POS操作、485通信）",{"$nulls":6},"车娟","2019-01-21",null,"2019-02-20",null,"On going"]
["3.1.2.3","软件流程图评审",{"$nulls":6},"车娟","2019-02-21",null,"2019-02-23"]
["3.1.2.4","流程图优化和完成",{"$nulls":6},"车娟","2019-02-24",null,"2019-02-28"]
["3.1.2.5","软件开发\n（气体流量计通信、加油脉冲采集、锁枪、POS操作、485通信）",{"$nulls":6},"车娟","2019-03-01",null,"2019-03-20"]
["3.1.2.6","软件调试",{"$nulls":6},"车娟 胡琴倩","2019-03-20",null,"2019-03-25"]
["3.1.2.7","样品评审 ",{"$nulls":6},"车娟 胡琴倩","2019-03-26",null,"2019-03-29"]
["3.1.2.8","软件开发完成"]
["3.1.3,1","系统研发"]
["3.1.3.1","制定协议 与3.1.2.1同步",{"$nulls":6},"陈硕"]
["3.1.3.2","编写485后台通信程序流程图",{"$nulls":6},"陈硕","2019-01-21",null,"2019-02-20",null,"Finished"]
["3.1.3.3","流程图评审",{"$nulls":6},"陈硕","2019-02-21",null,"2019-02-23"]
["3.1.3.4","流程图优化和完成",{"$nulls":6},"陈硕","2019-02-24",null,"2019-02-28"]
["3.1.3.5","485后台通信程序设计设计",{"$nulls":6},"陈硕","2019-03-01",null,"2019-03-20"]
["3.1.3.6","联机调试 ",{"$nulls":6},"陈硕 胡琴倩","2019-03-20",null,"2019-03-25"]
["3.1.3.7","样品测试 ",{"$nulls":6},"陈硕 胡琴倩","2019-03-26",null,"2019-03-29"]
["3.1.3.8","系统研发完成"]
[]
["1900-01-04","Stage 4: Beta 实地测试"]
["4.1.1","实地测试启动会议"]
["4.1.1.1"]
["4.1.1.2"]
["4.1.1.3"]
["4.1.1.4"]
["4.1.1.5"]
["4.1.1.6"]
["4.1.1.7"]
["4.1.1.8"]
["4.1.1.9"]
["4.1.2","上站前调查与确认"]
["4.1.2.1"]
["4.1.2.2"]
["4.1.2.3"]
["4.1.2.4"]
["4.1.2.5"]
["4.1.2.6"]
["4.1.3","实地测试备料与发货"]
["4.1.3.1"]
["4.1.3.2"]
["4.1.3.3"]
["4.1.4","上站安装与联调"]
["4.1.4.1"]
["4.1.4.2"]
["4.1.4.3"]
["4.1.4.4"]
["4.1.4.5"]
["4.1.4.6"]
["4.1.4.7"]
["4.1.4.8"]
["4.1.5","实地测试跟踪"]
["4.1.5.1"]
["4.1.5.2"]
["4.1.5.3"]
["4.1.5.4"]
["4.1.5.5"]
[]
["1900-01-05","Stage 5: Pre-Production"]
["1900-01-05T02:24:00"]
["5.1.1"]
["5.1.2"]
["5.1.3"]
["5.1.4"]
["1900-01-05T04:48:00"]
["5.2.1"]
["5.2.2"]
["5.2.3"]
["5.2.4"]
["1900-01-05T07:12:00"]
["5.3.1"]
["5.3.2"]
["5.3.3"]
["5.3.4"]
["1900-01-05T09:36:00"]
["5.4.1"]
["5.4.2"]
["5.4.3"]
["5.4.4"]
["1900-01-05T12:00:00"]
["5.5.1"]
["5.5.2"]
["5.5.3"]
["5.5.4"]
["1900-01-06","Stage 6: Hand-Off"]
["1900-01-06T02:24:00"]
["6.1.1"]
["6.1.2"]
["6.1.3"]
["6.1.4"]
["1900-01-06T04:48:00"]
["6.2.1"]
["6.2.2"]
["6.2.3"]
["6.2.4"]
["1900-01-06T07:12:00"]
["6.3.1"]
["6.3.2"]
["6.3.3"]
["6.3.4"]
["1900-01-06T09:36:00"]
["6.4.1"]
["6.4.2"]
["6.4.3"]
["6.4.4"]
["1900-01-06T12:00:00"]
["6.5.1"]
["6.5.2"]
["6.5.3"]
["6.5.4"]

{"sheet":"Project weekly report","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["DFS Global Engineering -  Growth Markets\nProject  Weekly Report"]
["Remark: Update this report to manager on Thursday(AM) weekly."]
["    Week          ",null,null,null,"Major Achivements   ","Next Week Key Points"]
["W1"]
["W2"]
["W3"]
["W4"]
["W5"]
["W6"]
["W7"]
["W8"]
["W9"]
["W10"]
["W11"]
["W12"]
["W13"]
["W14"]
["W15"]
["W16"]
["W17"]
["W18"]
["W19"]
["W20",{"$nulls":4},"协助采购购买集线器等设备"]
["W21"]
["W22"]
["W23"]
["W24"]
["W25"]
["W26"]

{"sheet":"Project monthly report ","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["DFS Global Engineering -  Growth Markets\nProject  Monthly Report"]
["Remark: Update this report to manager on 28th monthly."]
["Month       ","Project Status  Update","Major Deliverables","Major Issues/Roadblocks","Major Achivements   ","Next Month Key Points"]
["Jan"]
["Feb"]
["Mar"]
["Apr"]
["May"]
["Jun"]
["Jul"]
["Aug"]
["Sep"]
["Oct"]
["Nov"]
["Dec"]

{"sheet":"Project doc managment","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["DFS Global Engineering -  Growth Markets\nProject Documentation Managment List"]
["Remark: Update this report to manager on Thursday(AM) weekly."]
["No"," Doc Name","Version","Category","Writer","Reviewer","Date"," Upload","Store Location"]
["1900-01-01",null,null,"Source code",{"$nulls":4},"Perforce"]
["1900-01-02",{"$nulls":7},"Local Git"]
["1900-01-03",{"$nulls":7},"Local SVN"]
["1900-01-04"]
["1900-01-05"]
["1900-01-06"]
["1900-01-07"]
["1900-01-08"]
["…"]

{"sheet":"Sheet1","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"实地测试工作小组"]