{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["2018年统计表 "],"read":"whole","date_system":"1900"}

{"sheet":"2018年统计表 ","index":0,"n_rows":269,"n_cols":12,"rows_kept":269,"merged":[[0,0,1,9],[2,0,2,9],[3,0,3,9],[30,0,30,8],[36,0,36,8],[53,0,53,7],[55,0,55,8],[72,0,72,7],[74,0,74,7],[93,0,93,8],[95,0,95,10],[96,0,96,6],[97,0,97,1],[97,2,97,3],[97,4,97,5],[98,0,98,1],[98,2,98,3],[98,4,98,5],[101,0,101,8],[102,6,102,7],[103,6,103,7],[104,6,104,7],[105,6,105,7],[106,6,106,7],[107,6,107,7],[108,6,108,7],[109,6,109,7],[110,6,110,7],[111,6,111,7],[112,6,112,7],[113,6,113,7],[114,6,114,7],[115,6,115,7],[116,6,116,7],[117,6,117,7],[118,0,118,9],[121,0,121,8],[141,0,141,1],[146,0,146,10],[163,0,163,10],[165,0,165,8],[182,0,182,1],[185,0,185,6],[186,0,186,6],[198,0,198,7],[201,0,201,5],[223,0,223,6],[229,0,229,7],[246,0,246,7],[251,0,251,3],[256,0,256,3],[258,0,258,3],[262,0,262,3],[263,0,263,2],[264,0,264,2],[268,0,268,1]]}
["                                                       2018年科研数据统计表\n\n注：1.只填2018年度数据。\n       2.请务必对照《北京电子科技学院专业技术人员年度考核实施细则》（院发〔2018〕12号）附录中“考核要素分值对照表”的科研部分（6.1~6.8）和《北京电子科技学院理工类期刊和会议目录和赋分办法》（院科发〔2017〕40号）中的有关条目要求填写。\n       3. 仅第一张表（理工类论文）中的级别（A、B、C...）是《北京电子科技学院理工类期刊和会议目录和赋分办法》（院科发〔2017〕40号）中的论文级别。其他表中的级别（A、B、C....)是“考核要素分值对照表”的科研部分（6.1~6.8）中相应的级别。\n       4.请严谨、据实填写，如有弄虚作假，一经查实严肃处理。\n       "]
[]
["一、公开发表的论文\n（理工类参照“北京电子科技学院理工类期刊和会议目录\";人文类参照“专技人员年度考核实施细则”中的目录）"]
["（1）理工类"]
["序号","论文名称","第一作者","刊物/会议","级别","分值","个人\n排名","排名分值比例","是否长文\n （非长文须降级）","得分"]
[1,{"$nulls":4},{"$f":"IF(E6=\"S\",1000,IF(E6=\"T\",480,IF(E6=\"A\",320,IF(E6=\"B\",200,IF(E6=\"C\",150,IF(E6=\"D\",50,IF(E6=\"E\",30)))))))","v":false},null,{"$f":"IF(G6=1,100%,IF(G6=2,70%,IF(G6=3,70%,IF(G6=4,40%,IF(G6=5,40%,IF(G6=\"通信作者\",100%))))))","v":false},null,{"$f":"IF(I6=\"是\",F6*H6,IF(I6=\"否\",F6*H6*IF(E6=\"S\",480,IF(E6=\"T\",320,IF(E6=\"A\",200,IF(E6=\"B\",150,IF(E6=\"C\",50,IF(E6=\"D\",30,IF(E6=\"E\",18,IF(E6=\"其他\",9))))))))/IF(E6=\"S\",1000,IF(E6=\"T\",480,IF(E6=\"A\",320,IF(E6=\"B\",200,IF(E6=\"C\",150,IF(E6=\"D\",50,IF(E6=\"E\",30,IF(E6=\"其他\",18))))))))))","v":false}]
[2,{"$nulls":4},{"$f":"IF(E7=\"S\",1000,IF(E7=\"T\",480,IF(E7=\"A\",320,IF(E7=\"B\",200,IF(E7=\"C\",150,IF(E7=\"D\",50,IF(E7=\"E\",30)))))))","v":false},null,{"$f":"IF(G7=1,100%,IF(G7=2,70%,IF(G7=3,70%,IF(G7=4,40%,IF(G7=5,40%,IF(G7=\"通信作者\",100%))))))","v":false},null,{"$f":"IF(I7=\"是\",F7*H7,IF(I7=\"否\",F7*H7*IF(E7=\"S\",480,IF(E7=\"T\",320,IF(E7=\"A\",200,IF(E7=\"B\",150,IF(E7=\"C\",50,IF(E7=\"D\",30,IF(E7=\"E\",18,IF(E7=\"其他\",9))))))))/IF(E7=\"S\",1000,IF(E7=\"T\",480,IF(E7=\"A\",320,IF(E7=\"B\",200,IF(E7=\"C\",150,IF(E7=\"D\",50,IF(E7=\"E\",30,IF(E7=\"其他\",18))))))))))","v":false}]
[3,{"$nulls":4},false,null,false,null,{"$f":"IF(I8=\"是\",F8*H8,IF(I8=\"否\",F8*H8*IF(E8=\"S\",480,IF(E8=\"T\",320,IF(E8=\"A\",200,IF(E8=\"B\",150,IF(E8=\"C\",50,IF(E8=\"D\",30,IF(E8=\"E\",18,IF(E8=\"其他\",9))))))))/IF(E8=\"S\",1000,IF(E8=\"T\",480,IF(E8=\"A\",320,IF(E8=\"B\",200,IF(E8=\"C\",150,IF(E8=\"D\",50,IF(E8=\"E\",30,IF(E8=\"其他\",18))))))))))","v":false}]
[4,{"$nulls":4},false,null,false,null,false]
[5,{"$nulls":4},false,null,false,null,false]
[6,{"$nulls":4},false,null,false,null,false]
[7,{"$nulls":4},false,null,false,null,false]
[8,{"$nulls":4},false,null,false,null,false]
[9,{"$nulls":4},false,null,false,null,false]
[10,{"$nulls":4},false,null,false,null,false]
[11,{"$nulls":4},false,null,false,null,false]
[12,{"$nulls":4},false,null,false,null,false]
[13,{"$nulls":4},false,null,false,null,false]
[14,{"$nulls":4},false,null,false,null,false]
[15,{"$nulls":4},false,null,false,null,false]
[16,{"$nulls":4},false,null,false,null,false]
[17,{"$nulls":4},false,null,false,null,false]
[18,{"$nulls":4},false,null,false,null,false]
[19,{"$nulls":4},false,null,false,null,false]
[20,{"$nulls":4},false,null,false,null,false]
[21,{"$nulls":4},false,null,false,null,false]
[22,{"$nulls":4},false,null,false,null,false]
[23,{"$nulls":4},false,null,false,null,false]
[24,{"$nulls":4},false,null,false,null,false]
[25,{"$nulls":4},false,null,false,null,false]
[" 小 计",{"$nulls":8},{"$f":"SUM(J6:J30)","v":0}]
[]
[]
[]
[]
[]
["（2）人文类"]
["序号","论文名称","第一作者","刊物","级别","分值","个人\n排名","排名分值比例","得分"]
[1,{"$nulls":4},{"$f":"IF(E39=\"A\",480,IF(E39=\"B\",320,IF(E39=\"C\",240,IF(E39=\"D\",160,IF(E39=\"E\",50,IF(E39=\"F\",30,IF(E39=\"G\",20,IF(E39=\"H\",10))))))))","v":false},null,{"$f":"IF(G39=1,100%,IF(G39=2,70%,IF(G39=3,70%,IF(G39=4,40%,IF(G39=5,40%,IF(G39=\"通信作者\",100%))))))","v":false},{"$f":"F39*H39","v":0}]
[2,{"$nulls":4},{"$f":"IF(E40=\"A\",480,IF(E40=\"B\",320,IF(E40=\"C\",240,IF(E40=\"D\",160,IF(E40=\"E\",50,IF(E40=\"F\",30,IF(E40=\"G\",20,IF(E40=\"H\",10))))))))","v":false},null,{"$f":"IF(G40=1,100%,IF(G40=2,70%,IF(G40=3,70%,IF(G40=4,40%,IF(G40=5,40%,IF(G40=\"通信作者\",100%))))))","v":false},{"$f":"F40*H40","v":0}]
[3,{"$nulls":4},false,null,false,0]
[4,{"$nulls":4},false,null,false,0]
[5,{"$nulls":4},false,null,false,0]
[6,{"$nulls":4},false,null,false,0]
[7,{"$nulls":4},false,null,false,0]
[8,{"$nulls":4},false,null,false,0]
[9,{"$nulls":4},false,null,false,0]
[10,{"$nulls":4},false,null,false,0]
[11,{"$nulls":4},false,null,false,0]
[12,{"$nulls":4},false,null,false,0]
[13,{"$nulls":4},false,null,false,0]
[14,{"$nulls":4},false,null,false,0]
[15,{"$nulls":4},false,null,false,0]
["小 计",{"$nulls":7},{"$f":"SUM(I39:I53)","v":0}]
[]
["（3）论文转载、转摘"]
["序号","论文名称","第一作者","刊物","级别","分值","个人\n排名","排名分值比例","得分"]
[1,{"$nulls":4},{"$f":"IF(E58=\"A\",240,IF(E58=\"B\",160,IF(E58=\"C\",120,IF(E58=\"D\",80,IF(E58=\"E\",40)))))","v":false},null,{"$f":"IF(G58=1,100%,IF(G58=2,70%,IF(G58=3,70%,IF(G58=4,40%,IF(G58=5,40%,IF(G58=\"通信作者\",100%))))))","v":false},{"$f":"F58*H58","v":0}]
[2,{"$nulls":4},{"$f":"IF(E59=\"A\",240,IF(E59=\"B\",160,IF(E59=\"C\",120,IF(E59=\"D\",80,IF(E59=\"E\",40)))))","v":false},null,{"$f":"IF(G59=1,100%,IF(G59=2,70%,IF(G59=3,70%,IF(G59=4,40%,IF(G59=5,40%,IF(G59=\"通信作者\",100%))))))","v":false},{"$f":"F59*H59","v":0}]
[3,{"$nulls":4},false,null,false,0]
[4,{"$nulls":4},false,null,false,0]
[5,{"$nulls":4},false,null,false,0]
[6,{"$nulls":4},false,null,false,0]
[7,{"$nulls":4},false,null,false,0]
[8,{"$nulls":4},false,null,false,0]
[9,{"$nulls":4},false,null,false,0]
[10,{"$nulls":4},false,null,false,0]
[11,{"$nulls":4},false,null,false,0]
[12,{"$nulls":4},false,null,false,0]
[13,{"$nulls":4},false,null,false,0]
[14,{"$nulls":4},false,null,false,0]
[15,{"$nulls":4},false,null,false,0]
["小 计",{"$nulls":7},{"$f":"SUM(I58:I72)","v":0}]
[]
["二、公开出版的著作"]
[]
[]
["序号","著作名称","第一作者","ISBN号","出版社","级别","分值","个人排名","排名分值比例","得分"]
[1,{"$nulls":5},{"$f":"IF(F79=\"A\",400,IF(F79=\"B\",150,IF(F79=\"C\",100)))","v":false},null,{"$f":"IF(H79=1,100%,IF(H79=2,70%,IF(H79=3,70%,IF(H79=4,40%,IF(H79=5,40%,IF(H79=\"其他\",10%))))))","v":false},{"$f":"G79*I79","v":0}]
[2,{"$nulls":5},{"$f":"IF(F80=\"A\",400,IF(F80=\"B\",150,IF(F80=\"C\",100)))","v":false},null,{"$f":"IF(H80=1,100%,IF(H80=2,70%,IF(H80=3,70%,IF(H80=4,40%,IF(H80=5,40%,IF(H80=\"其他\",10%))))))","v":false},{"$f":"G80*I80","v":0}]
[3,{"$nulls":5},false,null,false,0]
[4,{"$nulls":5},false,null,false,0]
[5,{"$nulls":5},false,null,false,0]
[6,{"$nulls":5},false,null,false,0]
[7,{"$nulls":5},false,null,false,0]
[8,{"$nulls":5},false,null,false,0]
[9,{"$nulls":5},false,null,false,0]
[10,{"$nulls":5},false,null,false,0]
[11,{"$nulls":5},false,null,false,0]
[12,{"$nulls":5},false,null,false,0]
[13,{"$nulls":5},false,null,false,0]
[14,{"$nulls":5},false,null,false,0]
[15,{"$nulls":5},false,null,false,0]
["小 计",{"$nulls":8},{"$f":"SUM(J79:J93)","v":0}]
[]
["三、科研项目"]
["（1）项目申报（仅填写作为主持人申报的项目）"]
["省部级项目申报且通过形式化审查",null,"项目名称",null,"项目类别",null,"得分"]
[{"$nulls":6},{"$f":"IF(A99=\"有\",5,0)","v":0}]
[]
[]
["（2）项目立项"]
["序号","项目名称","主持人","级别","分值","个人排名","排名分值比例",null,"是否信息化建设项目","权重","得分"]
[1,{"$nulls":3},{"$f":"IF(D104=\"A\",200,IF(D104=\"B\",140,IF(D104=\"C\",100,IF(D104=\"D\",60,IF(D104=\"E\",30)))))","v":false},null,{"$f":"IF(F104=1,100%,IF(F104=2,70%,IF(F104=3,70%,IF(F104=4,40%,IF(F104=5,40%,IF(F104=\"其他\",10%))))))","v":false},null,null,{"$f":"IF(I104=\"是\",0.5,IF(I104=\"否\",1))","v":false},{"$f":"E104*G104*J104","v":0}]
[2,{"$nulls":3},{"$f":"IF(D105=\"A\",200,IF(D105=\"B\",140,IF(D105=\"C\",100,IF(D105=\"D\",60,IF(D105=\"E\",30)))))","v":false},null,{"$f":"IF(F105=1,100%,IF(F105=2,70%,IF(F105=3,70%,IF(F105=4,40%,IF(F105=5,40%,IF(F105=\"其他\",10%))))))","v":false},null,null,{"$f":"IF(I105=\"是\",0.5,IF(I105=\"否\",1))","v":false},{"$f":"E105*G105*J105","v":0}]
[3,{"$nulls":3},false,null,false,null,null,false,0]
[4,{"$nulls":3},false,null,false,null,null,false,0]
[5,{"$nulls":3},false,null,false,null,null,false,0]
[6,{"$nulls":3},false,null,false,null,null,false,0]
[7,{"$nulls":3},false,null,false,null,null,false,0]
[8,{"$nulls":3},false,null,false,null,null,false,0]
[9,{"$nulls":3},false,null,false,null,null,false,0]
[10,{"$nulls":3},false,null,false,null,null,false,0]
[11,{"$nulls":3},false,null,false,null,null,false,0]
[12,{"$nulls":3},false,null,false,null,null,false,0]
[13,{"$nulls":3},false,null,false,null,null,false,0]
[14,{"$nulls":3},false,null,false,null,null,false,0]
[15,{"$nulls":3},false,null,false,null,null,false,0]
["小 计",{"$nulls":9},{"$f":"SUM(K104:K118)","v":0}]
[]
[]
["（3）项目过程"]
["序号","项目名称","本年度过程分"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
["小  计",null,{"$f":"SUM(C124:C141)","v":0}]
[]
[]
[]
[]
["（4）项目结题验收"]
["序号","项目名称","主持人","级别","分值","个人排名","排名分值比例","是否密码项目","密码项目加权","是否信息化建设项目","权重","得分"]
[1,{"$nulls":3},{"$f":"IF(D149=\"A\",200,IF(D149=\"B\",140,IF(D149=\"C\",100,IF(D149=\"D\",60,IF(D149=\"E\",30,IF(D149=\"F\",20,IF(D149=\"G\",10)))))))","v":false},null,{"$f":"IF(F149=1,100%,IF(F149=2,70%,IF(F149=3,70%,IF(F149=4,40%,IF(F149=5,40%,IF(F149=\"其他\",10%))))))","v":false},null,{"$f":"IF(H149=\"是\",1.2,IF(H149=\"否\",1))","v":false},null,{"$f":"IF(J149=\"是\",0.5,IF(J149=\"否\",1))","v":false},{"$f":"E149*G149*I149*K149","v":0}]
[2,{"$nulls":3},{"$f":"IF(D150=\"A\",200,IF(D150=\"B\",140,IF(D150=\"C\",100,IF(D150=\"D\",60,IF(D150=\"E\",30,IF(D150=\"F\",20,IF(D150=\"G\",10)))))))","v":false},null,{"$f":"IF(F150=1,100%,IF(F150=2,70%,IF(F150=3,70%,IF(F150=4,40%,IF(F150=5,40%,IF(F150=\"其他\",10%))))))","v":false},null,{"$f":"IF(H150=\"是\",1.2,IF(H150=\"否\",1))","v":false},null,{"$f":"IF(J150=\"是\",0.5,IF(J150=\"否\",1))","v":false},{"$f":"E150*G150*I150*K150","v":0}]
[3,{"$nulls":3},false,null,false,null,false,null,false,0]
[4,{"$nulls":3},false,null,false,null,false,null,false,0]
[5,{"$nulls":3},false,null,false,null,false,null,false,0]
[6,{"$nulls":3},false,null,false,null,false,null,false,0]
[7,{"$nulls":3},false,null,false,null,false,null,false,0]
[8,{"$nulls":3},false,null,false,null,false,null,false,0]
[9,{"$nulls":3},false,null,false,null,false,null,false,0]
[10,{"$nulls":3},false,null,false,null,false,null,false,0]
[11,{"$nulls":3},false,null,false,null,false,null,false,0]
[12,{"$nulls":3},false,null,false,null,false,null,false,0]
[13,{"$nulls":3},false,null,false,null,false,null,false,0]
[14,{"$nulls":3},false,null,false,null,false,null,false,0]
[15,{"$nulls":3},false,null,false,null,false,null,false,0]
["小 计",{"$nulls":10},{"$f":"SUM(L149:L163)","v":0}]
[]
["（5）项目经费"]
["序号","项目名称","本年度经费分"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["小 计",null,{"$f":"SUM(C168:C182)","v":0}]
[]
[]
["四、授权专利\n（必须得到国家知识产权局正式授权）"]
["（1）专利（须得到国家知识产权局正式最终授权；处于初审、复审、公示过程中的不填报。）"]
["序号","专利名称","第一发明人","专利号","类别","分值","个人排名","排名分值比例","得分"]
[1,{"$nulls":4},{"$f":"IF(E189=\"发明专利\",180,IF(E189=\"实用新型专利\",30,IF(E189=\"外观设计专利\",10)))","v":false},null,{"$f":"IF(G189=1,100%,IF(G189=2,70%,IF(G189=3,70%,IF(G189=4,40%,IF(G189=5,40%,IF(G189=\"其他\",10%))))))","v":false},{"$f":"F189*H189","v":0}]
[2,{"$nulls":4},{"$f":"IF(E190=\"发明专利\",180,IF(E190=\"实用新型专利\",30,IF(E190=\"外观设计专利\",10)))","v":false},null,{"$f":"IF(G190=1,100%,IF(G190=2,70%,IF(G190=3,70%,IF(G190=4,40%,IF(G190=5,40%,IF(G190=\"其他\",10%))))))","v":false},{"$f":"F190*H190","v":0}]
[3,{"$nulls":4},false,null,false,0]
[4,{"$nulls":4},false,null,false,0]
[5,{"$nulls":4},false,null,false,0]
[6,{"$nulls":4},false,null,false,0]
[7,{"$nulls":4},false,null,false,0]
[8,{"$nulls":4},false,null,false,0]
[9,{"$nulls":4},false,null,false,0]
[10,{"$nulls":4},false,null,false,0]
["小 计",{"$nulls":7},{"$f":"SUM(I189:I198)","v":0}]
[]
[]
["（2）软件著作权登记"]
["序号","著作权名称","第一发明人","著作权号","分值","个人排名","排名分值比例","得分"]
[1,{"$nulls":3},{"$f":"IF(ISBLANK(B204),\"0\",\"5\")","v":"0"},null,{"$f":"IF(F204=1,100%,IF(F204=2,70%,IF(F204=3,70%,IF(F204=4,40%,IF(F204=5,40%,IF(F204=\"其他\",10%))))))","v":false},{"$f":"E204*G204","v":0}]
[2,{"$nulls":3},{"$f":"IF(ISBLANK(B205),\"0\",\"5\")","v":"0"},null,{"$f":"IF(F205=1,100%,IF(F205=2,70%,IF(F205=3,70%,IF(F205=4,40%,IF(F205=5,40%,IF(F205=\"其他\",10%))))))","v":false},{"$f":"E205*G205","v":0}]
[3,{"$nulls":3},"0",null,false,0]
[4,{"$nulls":3},"0",null,false,0]
[5,{"$nulls":3},"0",null,false,0]
[6,{"$nulls":3},"0",null,false,0]
[7,{"$nulls":3},"0",null,false,0]
[8,{"$nulls":3},"0",null,false,0]
[9,{"$nulls":3},"0",null,false,0]
[10,{"$nulls":3},"0",null,false,0]
[11,{"$nulls":3},"0",null,false,0]
[12,{"$nulls":3},"0",null,false,0]
[13,{"$nulls":3},"0",null,false,0]
[14,{"$nulls":3},"0",null,false,0]
[15,{"$nulls":3},"0",null,false,0]
[16,{"$nulls":3},"0",null,false,0]
[17,{"$nulls":3},"0",null,false,0]
[18,{"$nulls":3},"0",null,false,0]
[19,{"$nulls":3},"0",null,false,0]
[20,{"$nulls":3},"0",null,false,0]
["小 计",{"$nulls":6},{"$f":"SUM(H204:H223)","v":0}]
[]
[]
[]
[]
[]
["五、科研获奖\n（教学、人事类奖项不统计；国家最高科学技术奖、国家自然科学奖、国家技术发明奖、国家科学技术进步奖，奖等选\"无\"）"]
["序号","获奖成果或项目名称","第一完成人","奖项","奖等","分值","个人排名","排名分值比例","得分"]
[1,{"$nulls":4},{"$f":"IF(D232=\"国家最高科学技术奖\",2000,IF(D232=\"国家自然科学奖\",1000,IF(D232=\"国家技术发明奖\",1000,IF(D232=\"国家科学技术进步奖\",1000,IF(AND(D232=\"其他国家级科研项目/成果奖\",E232=\"特等奖\"),300,IF(AND(D232=\"其他国家级科研项目/成果奖\",E232=\"一等奖\"),240,IF(AND(D232=\"其他国家级科研项目/成果奖\",E232=\"二等奖\"),200,IF(AND(D232=\"其他国家级科研项目/成果奖\",E232=\"三等奖\"),160,IF(AND(D232=\"其他国家级科研项目/成果奖\",E232=\"优秀奖\"),120,IF(AND(D232=\"省部级科研项目/成果奖\",E232=\"特等奖\"),240,IF(AND(D232=\"省部级科研项目/成果奖\",E232=\"一等奖\"),200,IF(AND(D232=\"省部级科研项目/成果奖\",E232=\"二等奖\"),160,IF(AND(D232=\"省部级科研项目/成果奖\",E232=\"三等奖\"),120,IF(AND(D232=\"省部级科研项目/成果奖\",E232=\"优秀奖\"),80,IF(AND(D232=\"院级科研项目/成果奖\",E232=\"一等奖\"),60,IF(AND(D232=\"院级科研项目/成果奖\",E232=\"二等奖\"),40,IF(AND(D232=\"院级科研项目/成果奖\",E232=\"三等奖\"),30,IF(AND(D232=\"院级科研项目/成果奖\",E232=\"优秀奖\"),10))))))))))))))))))","v":false},null,{"$f":"IF(G232=1,100%,IF(G232=2,70%,IF(G232=3,70%,IF(G232=4,40%,IF(G232=5,40%,IF(G232=\"其他\",10%))))))","v":false},{"$f":"F232*H232","v":0}]
[2,{"$nulls":4},{"$f":"IF(D233=\"国家最高科学技术奖\",2000,IF(D233=\"国家自然科学奖\",1000,IF(D233=\"国家技术发明奖\",1000,IF(D233=\"国家科学技术进步奖\",1000,IF(AND(D233=\"其他国家级科研项目/成果奖\",E233=\"特等奖\"),300,IF(AND(D233=\"其他国家级科研项目/成果奖\",E233=\"一等奖\"),240,IF(AND(D233=\"其他国家级科研项目/成果奖\",E233=\"二等奖\"),200,IF(AND(D233=\"其他国家级科研项目/成果奖\",E233=\"三等奖\"),160,IF(AND(D233=\"其他国家级科研项目/成果奖\",E233=\"优秀奖\"),120,IF(AND(D233=\"省部级科研项目/成果奖\",E233=\"特等奖\"),240,IF(AND(D233=\"省部级科研项目/成果奖\",E233=\"一等奖\"),200,IF(AND(D233=\"省部级科研项目/成果奖\",E233=\"二等奖\"),160,IF(AND(D233=\"省部级科研项目/成果奖\",E233=\"三等奖\"),120,IF(AND(D233=\"省部级科研项目/成果奖\",E233=\"优秀奖\"),80,IF(AND(D233=\"院级科研项目/成果奖\",E233=\"一等奖\"),60,IF(AND(D233=\"院级科研项目/成果奖\",E233=\"二等奖\"),40,IF(AND(D233=\"院级科研项目/成果奖\",E233=\"三等奖\"),30,IF(AND(D233=\"院级科研项目/成果奖\",E233=\"优秀奖\"),10))))))))))))))))))","v":false},null,{"$f":"IF(G233=1,100%,IF(G233=2,70%,IF(G233=3,70%,IF(G233=4,40%,IF(G233=5,40%,IF(G233=\"其他\",10%))))))","v":false},{"$f":"F233*H233","v":0}]
[3,{"$nulls":4},false,null,false,0]
[4,{"$nulls":4},false,null,false,0]
[5,{"$nulls":4},false,null,false,0]
[6,{"$nulls":4},false,null,false,0]
[7,{"$nulls":4},false,null,false,0]
[8,{"$nulls":4},false,null,false,0]
[9,{"$nulls":4},false,null,false,0]
[10,{"$nulls":4},false,null,false,0]
[11,{"$nulls":4},false,null,false,0]
[12,{"$nulls":4},false,null,false,0]
[13,{"$nulls":4},false,null,false,0]
[14,{"$nulls":4},false,null,false,0]
[15,{"$nulls":4},false,null,false,0]
["小 计",{"$nulls":7},{"$f":"SUM(I232:I246)","v":0}]
[]
[]
[]
[]
["六、密码方案审查或密码工程验收工作"]
[]
["项数","分数"]
[null,{"$f":"A255*15","v":0}]
[]
["七、当年是否为《北京电子科技学院学报》编辑",{"$nulls":4},{"$f":"IF(E257=\"是\",30,IF(E257=\"否\",0))","v":false}]
[]
["八、密码装备定型鉴定"]
["项数","分数"]
[null,{"$f":"A261*140","v":0}]
[]
["九、科研产品生产、销售和成果转移转化"]
["生产、销售和转移转化工作内容",null,null,"数量或金额","得分"]
[{"$nulls":4},{"$f":"IF(D265=\"1000台套或600万元以上\",300,IF(D265=\"800台套或400万元以上\",200,IF(D265=\"400台套或200万元以上\",100,IF(D265=\"200台套或100万元以上\",70))))","v":false}]
[]
[]
[]
["各项得分合计",null,{"$f":"SUM(I73,J94,G99,K119,C142,L164,C183,I199,H224,I247,F257,B261,E265,B255,J31,I54)","v":0}]