{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["表一 实验室建设与管理工作量汇总（以单位汇总）","表二 实验室管理（汇总）","表三 实验项目开发（汇总）","表四 自制实验设备（汇总）"],"not_rendered":{"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"表一 实验室建设与管理工作量汇总（以单位汇总）","index":0,"n_rows":7,"n_cols":16,"rows_kept":7,"merged":[[0,0,0,15],[1,0,1,15]]}
["实验室建设与管理工作量汇总表"]
["部门盖章："]
["序号","工作单位","教师姓名","一卡通号","职称","管理实验室数量","实验室名称","实验室房间号","实验室管理工作量一","实验项目开发数量","实验项目开发工作量二","自制实验设备数量（套）","自制实验设备工作量三","实验实训中心主任/副主任","主任/副主任管理工作量四","实验室建设与管理工作量合计"]
[1,"设计学院","AAA",11059010000,"高级实验师",{"$nulls":8},"副主任",null,{"$f":"I4+K4+M4+O4","v":0}]
[{"$nulls":15},{"$f":"I5+K5+M5+O5","v":0}]
[{"$nulls":15},{"$f":"I6+K6+M6+O6","v":0}]
[{"$nulls":15},{"$f":"I7+K7+M7+O7","v":0}]

{"sheet":"表二 实验室管理（汇总）","index":1,"n_rows":15,"n_cols":45,"rows_kept":15,"merged":[[0,0,0,44],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,1,34],[1,35,1,41],[1,43,3,43],[1,44,3,44],[2,6,2,18],[2,19,2,22],[2,23,2,26],[2,27,2,32],[2,34,3,34],[2,35,3,35],[2,36,3,36],[2,37,3,37],[2,38,3,38],[2,39,3,39],[2,40,3,40],[2,41,3,41],[2,42,3,42],[4,0,13,0],[4,1,13,1],[4,2,13,2],[4,3,13,3],[4,4,8,4],[4,5,8,5],[4,11,8,11],[4,12,8,12],[4,13,8,13],[4,14,8,14],[4,15,8,15],[4,16,8,16],[4,17,8,17],[4,18,8,18],[4,19,8,19],[4,20,8,20],[4,21,8,21],[4,22,8,22],[4,23,8,23],[4,24,8,24],[4,25,8,25],[4,26,8,26],[4,31,8,31],[4,32,8,32],[4,33,8,33],[4,34,8,34],[4,35,8,35],[4,36,8,36],[4,37,8,37],[4,38,8,38],[4,39,8,39],[4,40,8,40],[4,41,8,41],[4,42,8,42],[4,43,8,43],[4,44,13,44],[9,4,13,4],[9,5,13,5],[9,11,13,11],[9,12,13,12],[9,13,13,13],[9,14,13,14],[9,15,13,15],[9,16,13,16],[9,17,13,17],[9,18,13,18],[9,19,13,19],[9,20,13,20],[9,21,13,21],[9,22,13,22],[9,23,13,23],[9,24,13,24],[9,25,13,25],[9,26,13,26],[9,31,13,31],[9,32,13,32],[9,33,13,33],[9,34,13,34],[9,35,13,35],[9,36,13,36],[9,37,13,37],[9,38,13,38],[9,39,13,39],[9,40,13,40],[9,41,13,41],[9,42,13,42],[9,43,13,43],[14,0,23,0],[14,1,23,1],[14,2,23,2],[14,3,23,3],[14,4,18,4],[14,5,18,5],[14,43,18,43],[14,44,23,44],[19,4,23,4],[19,5,23,5],[19,43,23,43]]}
["附件  实验室管理工作量统计表"]
["序号","工作单位","教师姓名","一卡通号","实验场所名称（与数据采集保持一致）","实验场所代码（与数据采集保持一致）","1.实验室综合效能工作量-分5项，共20学时",{"$nulls":28},"2.实验室安全-8学时",{"$nulls":6},"3.实验室开放-2学时","实验室管理工作量小计","教师实验室管理工作量合计"]
[{"$nulls":6},"1)实验室利用率-6学时",{"$nulls":12},"2)仪器设备完好率-5学时",{"$nulls":3},"3)仪器设备在用率-5学时",{"$nulls":3},"4)大型仪器设备利用率-2学时",{"$nulls":5},"5)日常管理-2学时","工作量小计1","配备负责人","制度健全、上墙","落实应急预案","落实安全准入制度","安全教育（需要记录）","安全检查(需有记录)","工作量小计2","对校内外开发，工作量小计3"]
[{"$nulls":6},"实验项目名称（此列暂时不填）","实验归属课程名称","实验学时数","学生人数","实验人时数","实验室开放人时数","学年实验总人时数","实验室使用面积","每生占有标准面积","实验室容量","实验室额定课时数","实验室利用率","学时","完好仪器设备台数","仪器设备总台数","仪器设备完好率","学时","在用仪器设备数","仪器设备总台数","仪器设备在用率","学时","仪器设备名称","有效机时","额定机时","单台利用率","大型仪器设备利用率","学时","账物相符，日志等"]
[1,"设计学院","AAA",11059010000,{"$nulls":4},4,{"$f":"45*6","v":270},{"$f":"I5*J5","v":1080},300,{"$f":"K5+K6+K7+K8+K9+L5","v":5700},60,4,{"$f":"N5/O5","v":15},450,{"$f":"M5/(P5*Q5)","v":{"v":0.8444444444444444,"d":"84%"}},5,20,20,{"$f":"T5/U5","v":{"v":1,"d":"100%"}},5,19,20,{"$f":"X5/Y5","v":{"v":0.95,"d":"95%"}},5,"设备1",310,300,{"$f":"AC5/AD5","v":{"v":1.0333333333333334,"d":"103%"}},{"$f":"(AE5+AE6+AE7+AE8)/4","v":{"v":1.0466666666666666,"d":"105%"}},2,2,{"$f":"S5+W5+AA5+AG5+AH5","v":19},0.5,1.5,0.5,0.5,1,4,{"$f":"SUM(AJ5:AO9)","v":8},2,{"$f":"AI5+AP5+AQ5","v":29},{"$f":"SUM(AR5:AR14)","v":58}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"设备2",450,500,{"v":0.9,"d":"90%"}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"设备3",400,300,{"v":1.3333333333333333,"d":"133%"}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"设备4",460,500,{"v":0.92,"d":"92%"}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"/","/","/","/"]
[{"$nulls":8},4,270,1080,300,{"$f":"K10+K11+K12+K13+K14+L10","v":5700},60,4,{"$f":"N10/O10","v":15},450,{"$f":"M10/(P10*Q10)","v":{"v":0.8444444444444444,"d":"84%"}},5,20,20,{"$f":"T10/U10","v":{"v":1,"d":"100%"}},5,19,20,{"$f":"X10/Y10","v":{"v":0.95,"d":"95%"}},5,"设备1",310,300,{"$f":"AC10/AD10","v":{"v":1.0333333333333334,"d":"103%"}},{"$f":"(AE10+AE11+AE12+AE13)/4","v":{"v":1.0466666666666666,"d":"105%"}},2,2,{"$f":"S10+W10+AA10+AG10+AH10","v":19},0.5,1.5,0.5,0.5,1,4,{"$f":"SUM(AJ10:AO14)","v":8},2,{"$f":"AI10+AP10+AQ10","v":29}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"设备2",450,500,{"v":0.9,"d":"90%"}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"设备3",400,300,{"v":1.3333333333333333,"d":"133%"}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"设备4",460,500,{"v":0.92,"d":"92%"}]
[{"$nulls":8},4,270,1080,{"$nulls":16},"/","/","/","/"]
[2,"设计学院","BBB",11059010000]

{"sheet":"表三 实验项目开发（汇总）","index":2,"n_rows":7,"n_cols":18,"rows_kept":7,"merged":[[0,0,0,17],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,1,12],[1,13,1,16],[1,17,3,17],[2,10,2,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,17,5,17],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,17,7,17]]}
["附件 实验项目开发工作量统计表"]
["序号","工作单位","教师姓名","一卡通号","实验项目开发名称","依托\n课程代码","依托\n课程名称","实验项目开发标时(计算标准)","实验学时","项目实施效果系数H",{"$nulls":3},"项目开发标时",{"$nulls":3},"合计"]
[{"$nulls":9},"实验项目开发","运用于教学实践",null,null,"本实验项目开发上一年度已报标时","本年度项目开发标时计算值","本年度可用标时","本年度实验项目开发标时"]
[{"$nulls":9},"资料准备系数：实验课程教学大纲、实验教材或实验指导书(H1=0.5/0)","已开展的学生人数","实验人时数","实验人时数系数H2\n[0-10)：0\n[10-30)：0.1\n[30-60)：0.3\n[60以上：0.5"]
[1,"设计学院","AAA","11059**","****","*********","名称",40,2,0.5,29,{"$f":"I5*K5","v":58},{"$f":"IF(L5<10,0,IF(L5<30,0.1,IF(L5<60,0.3,0.5)))","v":0.3},0,{"$f":"H5*(J5+M5)","v":32},{"$f":"H5-N5","v":40},{"$f":"IF(O5>P5,P5,O5)","v":32},{"$f":"SUM(Q5:Q6)","v":48}]
[{"$nulls":4},"****","*********","名称",40,2,0,30,{"$f":"I6*K6","v":60},{"$f":"IF(L6<10,0,IF(L6<30,0.1,IF(L6<60,0.3,0.5)))","v":0.5},24,{"$f":"H6*(J6+M6)","v":20},{"$f":"H6-N6","v":16},{"$f":"IF(O6>P6,P6,O6)","v":16}]
[2,"设计学院","BBB"]

{"sheet":"表四 自制实验设备（汇总）","index":3,"n_rows":7,"n_cols":18,"rows_kept":7,"merged":[[0,0,0,17],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,10,1,16],[1,17,3,17],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,17,5,17],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,17,7,17]]}
["附件 自制实验设备工作量统计表"]
["序号","工作单位","教师姓名","一卡通号","自制仪器设备名称","依托\n课程代码","依托\n课程名称","实验学时(计算标准)","实验学时","完成自制仪器设备","运用于教学实践标时情况",{"$nulls":6},"合计"]
[{"$nulls":9},"资料：实验课程教学大纲、实验教材或实验指导书(K1=0.5)","已开展的学生人数","实验人时数","实验人时数系数K2\n[0-10)：0\n[10-30)：0.1\n[30-60)：0.3\n[60以上：0.5","本自制仪器设备上一年度已报标时","本次自制仪器设备标时计算值","本年度可用标时","本年度自制仪器设备标时"]
[]
[1,"设计学院","AAA","11059******"]
[]
[2,"设计学院","BBB"]