{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["20130901"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":1,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"20130901","index":0,"n_rows":49,"n_cols":38,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,0,3],[42,11,42,15],[6,25,7,25],[40,11,40,15],[41,11,41,15],[7,0,27,0],[5,1,6,8],[28,21,28,22],[48,11,48,15],[5,10,6,15],[46,11,46,15],[47,11,47,15],[18,23,19,23],[8,22,8,23],[9,22,9,23],[20,22,20,23],[10,22,10,23],[29,21,29,22],[30,21,30,22],[31,21,31,22],[43,11,43,15],[44,11,44,15],[45,11,45,15],[39,10,39,15]]}
[null,"logo"]
[null,"姓名",null,"月","9月",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"得分",{"$f":"R6","v":73.333333333333329}]
[null,"工号",null,"日期",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"感情",{"$f":"R7*R8","v":21}]
[null,"部门",null,"跳转到",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,16,20]
[null,"固定工作",null,null,null,null,null,null,null,null,"临时工作",null,null,null,null,null,"得分",{"$f":"IF(W9-W21=0,\"0\",(5*W19+1*W20)/((W9-W21)*5)*100)","v":73.333333333333329},null,null,100,"完全区"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"工作量",{"$f":"W19+W20","v":3},null,null,80,"警告区"]
[null,"序号","技能等级","表格或工作内容","目标时机","完成情况","情况描述","重要程度","备注",null,"序号","表格或工作内容","完成情况","情况描述","重要程度","备注","重要性",{"$f":"IF(SUM(X29,X30,X31,X32)=0,\"0\",(X29*5+X30*4+X31*3+X32*2)/((X29+X30+X31+X32)*5)*10)","v":7},null,null,60,"危险区",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"1月"]
[null,1,4,"无质量问题生产东风带扣锁2000个 \n卷收器第二工序","每天","完成",null,"不重要+不紧急",null,null,1,"临时会议","未完成",null,"紧急+不重要",null,null,null,null,null,null,"总任务",{"$f":"COUNTA(F9:F43)+COUNTA(M9:M38)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,2,"2月"]
[null,2,4,"检查上一道工序纰漏，发现问题，向主管提出","每天","无需完成",null,"重要+不紧急",null,null,2,null,null,null,null,null,null,null,null,null,null,"固定任务",{"$f":"COUNTA(F9:F43)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3月"]
[null,3,4,"保持工作台面及地下的卫生","每天","完成",null,"紧急+重要",null,null,3,null,null,null,null,null,null,null,null,null,null,"临时任务",{"$f":"COUNTA(M9:M38)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,4,"4月"]
[null,4,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"5月"]
[null,5,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"6月"]
[null,6,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"7月"]
[null,7,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"8月"]
[null,8,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"9月"]
[null,9,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"10月"]
[null,10,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"11月"]
[null,11,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,"完成",{"$f":"COUNTIF(F9:F43,\"完成\")+COUNTIF(M9:M38,\"完成\")","v":2},{"$f":"W20+W19","v":3},null,null,null,null,null,null,null,null,null,null,null,null,12,"12月"]
[null,12,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,"未完成",{"$f":"COUNTIF($F$9:$F$43,\"未完成\")+COUNTIF($M$9:$M$38,\"未完成\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,13,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,"无需完成",{"$f":"COUNTIF($F$9:$F$43,\"无需完成\")+COUNTIF($M$9:$M$38,\"无需完成\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,14,null,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,15,null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,16,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,17,null,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,18,null,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,19,null,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,20,null,null,null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,21,null,null,null,null,null,null,null,null,21,null,null,null,null,null,null,null,null,null,null,"紧急+重要",null,{"$f":"COUNTIF(H9:H43,\"紧急+重要\")+COUNTIF(O9:O38,\"紧急+重要\")","v":1},"紧急+重要",{"$f":"X29","v":1},null,null,null,null,null,null,null,null,null,null,22]
[null,22,null,null,null,null,null,null,null,null,22,null,null,null,null,null,null,null,null,null,null,"紧急+不重要",null,{"$f":"COUNTIF(H9:H43,\"紧急+不重要\")+COUNTIF(O9:O38,\"紧急+不重要\")","v":1},"紧急+不重要",{"$f":"X30","v":1},null,null,null,null,null,null,null,null,null,null,23]
[null,23,null,null,null,null,null,null,null,null,23,null,null,null,null,null,null,null,null,null,null,"重要+不紧急",null,{"$f":"COUNTIF(H9:H43,\"重要+不紧急\")+COUNTIF(O9:O38,\"重要+不紧急\")","v":1},"重要+不紧急",{"$f":"X31","v":1},null,null,null,null,null,null,null,null,null,null,24]
[null,24,null,null,null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,null,null,"不重要+不紧急",null,{"$f":"COUNTIF(H9:H43,\"不重要+不紧急\")+COUNTIF(O9:O38,\"不重要+不紧急\")","v":1},"不重要+不紧急",{"$f":"X32","v":1},null,null,null,null,null,null,null,null,null,null,25]
[null,25,null,null,null,null,null,null,null,null,25]
[null,26,null,null,null,null,null,null,null,null,26]
[null,27,null,null,null,null,null,null,null,null,27]
[null,28,null,null,null,null,null,null,null,null,28]
[null,29,null,null,null,null,null,null,null,null,29]
[null,30,null,null,null,null,null,null,null,null,30]
[null,31]
[null,32,null,null,null,null,null,null,null,null,"备注"]
[null,33,null,null,null,null,null,null,null,null,1,"底部sheet栏名改为日期（如格式：20130901）,与日志上部日期对应"]
[null,34,null,null,null,null,null,null,null,null,2,"保存文档名：（如赵顺叶，格式：zsy201309工作日志)"]
[null,35,null,null,null,null,null,null,null,null,3,"本日志每日需上传今目标日志；记录表单等需上传，做好保存、归类、提交等",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,4,"该文件一月归档一次，底部sheet栏应为一月工作天数(最多31日)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,5,"情况描述栏：未完成任务:描述进度情况   完成任务:描述完成证据",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,6,"在使用时，遇到技术问题，可咨询朱主任或徐总。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,7,"添加日志：底部日期栏(sheet栏)鼠标右键>移动或复制>移至最后(创建副本)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,8,"跳转到：可查看任何已保存日期的日志（如查看9月25号日志，选择跳转到25）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,9,"已保存日志不得更改"]