{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":137,"n_cols":4,"rows_kept":137,"cut":false,"hidden":false,"merged":[]}
["规则","点数计算","类型","优先级修订"]
["p.CaseNo.StartsWith(\"J\")",0,"其它",136]
["p.AgentFeedbackMemo==\"已核算绩效\"",0,"其它",135]
["p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"中-德\"","p.WordCount/1000*0.18","其它",134]
["p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"中-英\"","p.WordCount/1000*0.16","其它",133]
["p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"英-中\"","p.WordCount/1000*0.1","其它",132]
["(p.DoItem==\"提交检索主题申明\" || p.DoItem==\"提交检索主题声明\") && p.CaseNo.StartsWith(\"PAEPO\")",0.2,"其它",131]
["p.DoItem==\"请求优先审查\"",0,"其它",130]
["p.ApplicationType==\"外观设计\"",0.2,"其它",129]
["p.DoItem==\"专利挖掘与布局\"",0,"其它",128]
["p.DoItem==\"知识点总结\"",0,"其它",127]
["p.DoItem==\"询问放弃或复审\"",0,"其它",126]
["p.DoItem==\"申请时提交IDS\"",0,"其它",125]
["p.DoItem==\"提交ids\" || p.DoItem==\"提交IDS\" ",0.1,"其它",124]
["p.DoItem==\"技术确认\"",0,"其它",123]
["p.DoItem==\"绘图\"",0,"其它",122]
["p.DoItem==\"分案评估+分案\"",0.2,"其它",121]
["p.DoItem==\"分案评估\"",0.1,"其它",120]
["p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PAUS\")",0.2,"其它",119]
["p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PAEPO\") ",0.2,"其它",118]
["p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PACN\")",0,"其它",117]
["p.DoItem==\"PPH\"",0.1,"其它",116]
["p.DoItem==\"OA答辩校核\"",0.2,"其它",115]
["p.DoItem==\"Election Action\"",0.2,"其它",114]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAUS\")",0.2,"其它",113]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAIN\")",0.2,"其它",112]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAGB\")",0.2,"其它",111]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAEPO\")",0.2,"其它",110]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PADE\")",0.2,"其它",109]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"WOCN\")",0,"其它",108]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PCTCN\")",0,"其它",107]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PACN\")",0,"其它",106]
["p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAAU\")",0.2,"其它",105]
["p.AgentFeedbackMemo==\"检索结案\"",0.2,"其它",104]
["p.DoItem==\"内部检索\"",0,"其它",103]
["p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外-内\"",0.2,"其它",102]
["p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"内-外\"",0.3,"其它",101]
["p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外-内\"",0.5,"其它",100]
["p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"内-外\"",0.7,"其它",99]
["p.DoItem==\"发明一次OA授权\" && p.ApplicationType==\"发明\"",0.2,"其它",98]
["p.DoItem==\"处理审查意见\" &&  p.AgentFeedbackMemo==\"客户不进行答辩\"",0,"OA",97]
["p.DoItem==\"处理审查意见\" &&  p.AgentFeedbackMemo==\"电询/补正\"",0,"OA",96]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"实用新型\"  && p.AgentFeedbackMemo==\"不请款\"",0,"OA",95]
["p.DoItem==\"意见陈述\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"不请款\"",0,"OA",94]
["p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\"  && p.AgentFeedbackMemo==\"不请款\"",0,"OA",93]
["p.DoItem==\"意见陈述\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"请款\"",0.14000000000000001,"OA",92]
["p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\"  && p.AgentFeedbackMemo==\"请款\"",0.35,"OA",91]
["p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"非实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"",0.21,"OA",90]
["p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"",0.35,"OA",89]
["p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"形式\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"",0.14000000000000001,"OA",88]
["p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"二通\" && p.AgentFeedbackMemo==\"请款\"",0.14000000000000001,"OA",87]
["p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\" || p.CaseStage==\"六通\" || p.CaseStage==\"七通\" || p.CaseStage==\"八通\") ",0,"OA",86]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",0.2,"OA",85]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",0.5,"OA",84]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\"  && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",0.3,"OA",83]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") &&  (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")",0,"OA",82]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") &&  (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")",0,"OA",81]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"二通\"",0.2,"OA",80]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"二通\"",0.2,"OA",79]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"",0.2,"OA",78]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PCTCN\")  && p.CaseStage==\"一通\"",0.5,"OA",77]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"",0.3,"OA",76]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"",0.2,"OA",75]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PACN\")  && p.CaseStage==\"一通\"",0.5,"OA",74]
["p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"",0.3,"OA",73]
["p.DoItem==\"意见陈述\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"复审\"",0.2,"OA",72]
["p.DoItem==\"请求复审\" && p.ApplicationType==\"发明\"",0.5,"OA",71]
["p.AgentFeedbackMemo==\"涉外OA不答辩，发报导函结案\"",0.1,"其它",70]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户未提供答辩点，撰写英文报导函\"",0.8,"OA",69]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户提供答辩点，撰写英文报导函\"",0.5,"OA",68]
["p.DoItem==\"申復\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PATW\")",0.2,"OA",67]
["p.DoItem==\"申復\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PATW\")",0.5,"OA",66]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAIN\")",0.2,"OA",65]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAGB\")",0.2,"OA",64]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAEPO\")",0.2,"OA",63]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PADE\")",0.3,"OA",62]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAAU\")",0.2,"OA",61]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAIN\")",1.5,"OA",60]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAGB\")",1.5,"OA",59]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAEPO\")",1.5,"OA",58]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PADE\")",1.6,"OA",57]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAAU\")",1.5,"OA",56]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAUS\")",0.2,"OA",55]
["p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAUS\")",1.5,"OA",54]
["p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"实质\"",1.5,"OA",53]
["p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"形式\"",0.2,"OA",52]
["p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"形式\"",0.2,"OA",51]
["p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"实质\"",1.5,"OA",50]
["p.DoItem==\"RCE\" && p.DoItemCoefficient==\"形式\"",0.2,"OA",49]
["p.DoItem==\"RCE\" && p.DoItemCoefficient==\"实质\"",1.5,"OA",48]
["p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"形式\"",0.2,"OA",47]
["p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"实质\"",1.5,"OA",46]
["p.DoItem==\"form 3-8（2）\" || p.DoItem==\"Form 3-8(2)\" || p.DoItem==\"Form 3-8(2)\"",0.1,"OA",45]
["p.DoItem==\"form 3\"",0.1,"OA",44]
["p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"形式\"",0.2,"OA",43]
["p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"实质\"",1.5,"OA",42]
["p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"形式\"",0.2,"OA",41]
["p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"实质\"",1.5,"OA",40]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"中-德\" && p.WordCount !=null","p.WordCount/1000*0.18","其它",39]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"中-英\" && p.WordCount !=null","p.WordCount/1000*0.16","其它",38]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"英-中\" && p.WordCount !=null","p.WordCount/1000*0.1","其它",37]
["(p.ApplicationType==\"实用新型\" || p.ApplicationType==\"发明\") && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"客户不进行答辩\"",0,"其它",36]
["p.CaseNo.StartsWith(\"PAUS\")  && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"",1.26,"新申请",35]
["p.CaseNo.StartsWith(\"PADE\")  && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"",1.33,"新申请",34]
["p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"",0.7,"新申请",33]
["p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"",0.49,"新申请",32]
["p.AgentFeedbackMemo==\"撰写中客户取消申请\"",0,"其它",31]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PCTCN\") && p.AgentFeedbackMemo==\"外到内首次申请\"",1.5,"新申请",30]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"转格式\"",0.1,"其它",29]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"外-内首次申请\"",1.5,"新申请",28]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"首次中文案\"",1,"新申请",27]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"涉外实质改权\"",0.7,"新申请",26]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权+改说明书\"",0.5,"其它",25]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权\"",0.3,"其它",24]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"PCT首次英文案\"",1.8,"新申请",23]
["p.AgentFeedbackMemo==\"我方转格式、复核\"",0.2,"其它",22]
["p.AgentFeedbackMemo==\"我方代交\"",0,"其它",21]
["p.CaseNo.StartsWith(\"PAUS\") && (p.CaseNo.EndsWith(\"-同套\") || p.CaseNo.EndsWith(\"CA\") || p.CaseNo.EndsWith(\"CIP\") || p.CaseNo.EndsWith(\"分案\")) ",0.5,"其它",20]
["(p.CaseNo.StartsWith(\"PAMY \") || p.CaseNo.StartsWith(\"PADE\") || p.CaseNo.StartsWith(\"PAGB\") || p.CaseNo.StartsWith(\"PAIN\") || p.CaseNo.StartsWith(\"PAUS\") || p.CaseNo.StartsWith(\"PAEPO\") ) && p.AgentFeedbackMemo==\"同套\"",0.2,"其它",19]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-分案\")",0.3,"其它",18]
["p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"欧洲案首次\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAEPO\")",1.8,"新申请",17]
["p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"大陆案转台湾案\"",0.2,"其它",16]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\"  && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",1,"新申请",15]
["p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"台湾案转大陆案\"",0.2,"其它",14]
["p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",0.1,"其它",13]
["p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",0.7,"新申请",12]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\"  && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",0.1,"其它",11]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAUS\") && p.Customer.Name.Contains(\"OPPO\")",1.7,"新申请",10]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAUS\")",1.8,"新申请",9]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAGB\")",1.8,"新申请",8]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAEPO\")",0.2,"其它",7]
["p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PADE\")",1.9,"新申请",6]
["p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")",0.1,"其它",5]
["p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\") && p.Customer.Name.Contains(\"OPPO\")",1,"新申请",4]
["p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\")",0.7,"新申请",3]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")",1,"新申请",2]
["p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\")",1,"新申请",1]