{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["申请审批表","代码表"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"申请审批表","index":0,"n_rows":67,"n_cols":49,"rows_kept":67,"merged":[[1,0,1,48],[2,0,2,48],[3,15,3,17],[3,19,3,21],[3,22,3,23],[3,24,4,24],[3,25,4,25],[3,26,4,26],[3,27,4,27],[3,28,4,28],[3,29,4,29],[3,30,4,30],[3,31,4,31],[3,32,4,32],[3,33,4,33],[3,34,4,34],[3,35,4,35],[3,36,4,36],[3,37,4,37],[3,38,4,38],[3,39,4,39],[3,40,4,40],[3,41,4,41],[3,42,4,42],[3,43,3,45],[3,46,5,46],[3,47,5,47],[3,48,5,48],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,22,5,22],[4,23,5,23],[5,24,5,35]]}
["附件2",{"$nulls":10},""]
["2023-2024学年国家奖学金追加名额申请表"]
["注意：\n1严禁对表格进行修改、调整顺序等操作行为，提交前请务必检查好并取消“隐藏”。\n2.为保证数据准确性，请严格按照提示填写各项内容。\n3.以院系为单位提交。\n4.设有下拉菜单的栏目只能从下拉菜单中选填，不得擅自修改。\n5.自动生成的数据不得擅自修改。"]
["姓名","性别","身份证号","学生类型","院系","专业","出生年月","民族","政治面貌","学号","入学年月","年级","班级","学制","联系电话","学习成绩排名",null,null,"是否实行综合考评排名","综合考评排名",null,null,"及格课程门数/必修课门数",null,"获奖日期1","奖项名称1","颁奖单位1","获奖日期2","奖项名称2","颁奖单位2","获奖日期3","奖项名称3","颁奖单位3","获奖日期4","奖项名称4","颁奖单位4","申请理由","申请理由日期","推荐理由","推荐理由日期","院系意见","院系意见日期","公示天数（工作日）","院系不需要填写",null,null,"2023-2024学年所获校级奖励提名（下拉菜单中选填，不要自行改动）\n必填","现任职务（指当前在岗）\n（如有，必填）\n\n如：学生兼职辅导员、**党支部书记、**团委书记、***团委副书记、**班长、**社团社长等","个人特长\n（如有，必填）\n\n如：舞蹈、绘画、唱歌、书法、手工、设计、摄影、视频编辑、***乐器演奏、主持、宣传文案撰写及策划等"]
["填写学生姓名，姓名为汉字（可包含·）或大小写字母（仅当姓名出现生僻字时可使用字母），长度大于等于2，且不超过30个汉字，例如“张三”\n必填","下拉菜单选择学生的性别，须与身份证号相匹配\n必填","填写学生居民身份证号码,须填写正确的身份证号码，与性别、出生年月相互校验是否一致。例如：“110000199910018888”（最后一位为字母X必须大写）\n必填","选择学生的类型，只能填写“本科”\n必填","填写学生所在院系的名称，必须是全称。长度大于1，但不得超过100个字符\n必填","填写学生所读专业的名称，如：“思想政治”“语文教育”等，长度大于1，不能超过100个字符\n必填","填写学生的出生年月，格式如“2016年9月”\n必填","选择学生的民族（下拉菜单中选填，不要自行改动）\n必填","选择学生的政治面貌（下拉菜单中选填，不要自行改动）\n必填","填写学生的学号，长度不得超过40个字符，例如“1100011000”\n必填","填写学生的入学报名年月。格式如“2016年9月”\n必填","选择学生的年级\n必填","选择学生的班级\n必填","选择学生的学制（下拉菜单中选填，不要自行改动）\n必填","填写学生的联系电话，长度为11位的数字，例如“13812341212”\n必填","填写学生学习成绩排名名次，只能填写正整数\n必填\n\n填写说明：名次与总人数（须与综合考评总人数保持一致）均必须填写正整数且总人数不能小于名次。","填写学生学习成绩排名总人数，只能填写正整数且不能小于学习成绩排名名次的值\n必填\n","排名率\n\n学习成绩应为同一年级同一专业排名前10%\n\n校验说明：如排名率为10.01%及以上，不符合评选资格）","选择是否实行综合考评，选择“是”则须填写综合考评排名；选择“否”则不填写综合考评排名（下拉菜单中选填，不要自行改动）\n必填","填写学生综合考评排名名次，只能填写正整数\n“是否实行综合考评”选择为“是”，则需要填写；左侧“是否实行综合考评”选择为“否”，则不填写","填写学生综合考评排名总人数，只能填写正整数且不能小于综合考评排名名次的值，“是否实行综合考评”选择为“是”，则需要填写；左侧“是否实行综合考评”选择为“否”，则不填写\n\n填写说明：名次与总人数（须与学习成绩总人数保持一致）均必须填写正整数且总人数不能小于名次。","排名率\n\n综测应为同一年级同一专业排名前10%\n\n校验说明：如排名率为10.01%及以上，不符合评选资格）","填写及格课程门数，只能填写正整数，且必须与右侧必修课门数相等\n必填\n填写说明：必修课门数应计算2023-2024学年所修必修课程门数。同年级同专业学生必修课门数应相同。","填写必修课门数，只能填写正整数，且必须与左侧及格课程门数相等\n必填\n填写说明：必修课门数应计算参评当年所修必修课程门数。同年级同专业学生必修课门数应相同。",{"$nulls":19},"学校意见公示开始日期","学校意见公示结束日期","学校意见日期"]
[{"$nulls":24},"不必填：满足学习成绩排名和综合考评排名\n1. 获奖日期：填写获奖日期，格式如“2016年09月”或“2016年9月”；\n2. 奖项名称：填写获奖名称，长度大于1，不能超过88个字符，格式如“大学生英语竞赛”；\n3. 颁奖单位：填写颁奖单位名称，长度大于1，不能超过88个字符，格式如“高等学校大学外语教学指导委员会”；\n4. 最多填写4个奖项，不用所有奖项都填写\n",{"$nulls":11},"填写申请理由，字数大于等于100字，小于等于300字\n必填\n\n填写说明：1.不要体现综测排名、成绩等信息，避免与前面填写的基础信息不一致。2.申请理由应为学生本人录入，全面反映学生各方面的综合素质，做到逻辑清晰、层次分明、格式整齐、语句通顺，无错字、别字，无使用不当的标点符号，严谨规范，整洁美观。3.开始填写时只需“首行缩进”2个字符，不要分段，不要换行。","填写申请理由日期，格式如“2016年9月1日”\n必填\n\n填写说明：申请时间应不晚于辅导员或班主任推荐时间。","填写推荐理由，字数大于等于50字，小于等于150字\n必填\n\n填写说明：1.应为申请学生所属的辅导员或班主任本人录入，不可代填。2.辅导员或班主任应根据不同申请学生的个性，实事求是给出客观、准确、个性化的推荐理由，不得搞千篇一律，万人一面雷同化。3.开始填写时只需“首行缩进”2个字符，不要分段，不要换行。","填写推荐理由日期，格式如“2016年9月1日”\n必填","填写院系意见，字数大于等于20字，小于等于300字\n必填\n\n填写说明：1.不可只填同意或同意推荐，不可过于简单。文字重复率>=60%判定为申请理由重复，将无法成功提交，请各院系认真查阅和把关。2.开始填写时只需“首行缩进”2个字符，不要分段，不要换行。","填写院系意见日期，格式如“2016年9月1日”\n必填","填写公示天数，只能填写正整数\n必填","填写学校意见公示开始日期，格式如“9月1日”\n必填","填写学校意见公示结束日期，格式如“9月1日”\n必填","填写学校意见日期，格式如“2016年9月1日”\n必填"]
["例：北大","男","110108200*****765X","本科","数学科学学院","数学类","200*年1月","汉族","共青团员",2200012131,"2022年9月","2023级","班级3","四年","15228372694",1,32,{"$f":"P7/Q7","v":{"v":0.03125,"d":"3.13%"}},"是",2,{"$f":"Q7","v":32},{"$f":"T7/U7","v":{"v":0.0625,"d":"6.25%"}},6,6,{"$nulls":13},"2023年9月19日",null,"2023年9月20日",null,"2023年9月28日",5,"11月15日","11月22日","11月23日","学术创新奖+三好学生标兵"]
[{"$nulls":17},{"$f":"P8/Q8","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Q8","v":0},{"$f":"T8/U8","v":{"$error":"#DIV/0!"}}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$f":"P40/Q40","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Q40","v":0},{"$f":"T40/U40","v":{"$error":"#DIV/0!"}}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":17},{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"}]

{"sheet":"代码表","index":1,"n_rows":141,"n_cols":8,"rows_kept":141,"hidden":true}
["方法名","序号/说明","名称","类型",{"$nulls":3},"bzkStudentEntry"]
[{"$nulls":7},"FAILURE"]
["checkYesNo","0","否","是",{"$nulls":3},"4150012605"]
["checkYesNo","1","是","否"]
[]
["checkGender","2","女","性别女"]
["checkGender",1,"男","性别男"]
[]
[]
["checkXSLX","41","专科","学生类型"]
["checkXSLX","42","专科（高职）","学生类型"]
["checkXSLX","43","专升本","学生类型"]
["checkXSLX","44","本科","学生类型"]
["checkXSLX","45","第二学士学位","学生类型"]
["checkXSLX","46","预科生","学生类型"]
[]
["checkXXXS","01","全日制","学习形式"]
["checkXXXS","02","非全日制","学习形式"]
[]
[]
[]
[]
["checkZZMM","1","中共党员","政治面貌类型"]
["checkZZMM","2","中共预备党员","政治面貌类型"]
["checkZZMM","3","共青团员","政治面貌类型"]
["checkZZMM","4","民革党员","政治面貌类型"]
["checkZZMM","5","民盟盟员","政治面貌类型"]
["checkZZMM","6","民建会员","政治面貌类型"]
["checkZZMM","7","民进会员","政治面貌类型"]
["checkZZMM","8","农工党党员","政治面貌类型"]
["checkZZMM","9","致公党党员","政治面貌类型"]
["checkZZMM","10","九三学社社员","政治面貌类型"]
["checkZZMM","11","台盟盟员","政治面貌类型"]
["checkZZMM","12","无党派人士","政治面貌类型"]
["checkZZMM","13","群众","政治面貌类型"]
[]
[]
["checkXL","44","本科","攻读学历类型"]
["checkXL","41","专科","攻读学历类型"]
["checkXL","42","专科（高职）","攻读学历类型"]
["checkXL","43","专升本","攻读学历类型"]
["checkXL","45","第二学士学位","攻读学历类型"]
[]
[]
["checkXZ","1","二年","学制"]
["checkXZ","1.5","三年","学制"]
["checkXZ","2","四年","学制"]
["checkXZ","2.5","五年","学制"]
["checkXZ","3","六年","学制"]
["checkXZ","3.5","七年","学制"]
["checkXZ","4","八年","学制"]
[]
[]
[]
["checkMZ","01","汉族","民族"]
["checkMZ","02","蒙古族","民族"]
["checkMZ","03","回族","民族"]
["checkMZ","04","藏族","民族"]
["checkMZ","05","维吾尔族","民族"]
["checkMZ","06","苗族","民族"]
["checkMZ","07","彝族","民族"]
["checkMZ","08","壮族","民族"]
["checkMZ","09","布依族","民族"]
["checkMZ",10,"朝鲜族","民族"]
["checkMZ","11","满族","民族"]
["checkMZ","12","侗族","民族"]
["checkMZ","13","瑶族","民族"]
["checkMZ","14","白族","民族"]
["checkMZ","15","土家族","民族"]
["checkMZ","16","哈尼族","民族"]
["checkMZ","17","哈萨克族","民族"]
["checkMZ","18","傣族","民族"]
["checkMZ","19","黎族","民族"]
["checkMZ","20","傈僳族","民族"]
["checkMZ","21","佤族","民族"]
["checkMZ","22","畲族","民族"]
["checkMZ","23","高山族","民族"]
["checkMZ","24","拉祜族","民族"]
["checkMZ","25","水族","民族"]
["checkMZ","26","东乡族","民族"]
["checkMZ","27","纳西族","民族"]
["checkMZ","28","景颇族","民族"]
["checkMZ","29","柯尔克孜族","民族"]
["checkMZ","30","土族","民族"]
["checkMZ","31","达斡尔族","民族"]
["checkMZ","32","仫佬族","民族"]
["checkMZ","33","羌族","民族"]
["checkMZ","34","布朗族","民族"]
["checkMZ","35","撒拉族","民族"]
["checkMZ","36","毛南族","民族"]
["checkMZ","37","仡佬族","民族"]
["checkMZ","38","锡伯族","民族"]
["checkMZ","39","阿昌族","民族"]
["checkMZ","40","普米族","民族"]
["checkMZ","41","塔吉克族","民族"]
["checkMZ","42","怒族","民族"]
["checkMZ","43","乌孜别克族","民族"]
["checkMZ","44","俄罗斯族","民族"]
["checkMZ","45","鄂温克族","民族"]
["checkMZ","46","德昂族","民族"]
["checkMZ","47","保安族","民族"]
["checkMZ","48","裕固族","民族"]
["checkMZ","49","京族","民族"]
["checkMZ","50","塔塔尔族","民族"]
["checkMZ","51","独龙族","民族"]
["checkMZ","52","鄂伦春族","民族"]
["checkMZ","53","赫哲族","民族"]
["checkMZ","54","门巴族","民族"]
["checkMZ","55","珞巴族","民族"]
["checkMZ","56","基诺族","民族"]
["checkMZ","57","穿青人族","民族"]
["checkMZ","97","其他","民族"]
["checkMZ","98","外国血统中国籍人士","民族"]
[]
[]
["checkZYDL","01","哲学","专业大类"]
["checkZYDL","02","经济学","专业大类"]
["checkZYDL","03","法学","专业大类"]
["checkZYDL","04","教育学","专业大类"]
["checkZYDL","05","文学","专业大类"]
["checkZYDL","06","历史学","专业大类"]
["checkZYDL","07","理学","专业大类"]
["checkZYDL","08","工学","专业大类"]
["checkZYDL","09","农学","专业大类"]
["checkZYDL","10","医学","专业大类"]
["checkZYDL","11","军事学","专业大类"]
["checkZYDL","12","管理学","专业大类"]
["checkZYDL","13","艺术学","专业大类"]
[]
["checkZjlx",1,"居民身份证","身份证件类型"]
["checkZjlx",2,"军官证","身份证件类型"]
["checkZjlx",3,"士兵证","身份证件类型"]
["checkZjlx",4,"文职干部证","身份证件类型"]
["checkZjlx",5,"部队离退休证","身份证件类型"]
["checkZjlx",6,"香港特区护照/身份证明","身份证件类型"]
["checkZjlx",7,"澳门特区护照/身份证明","身份证件类型"]
["checkZjlx",8,"台湾居民来往大陆通行证","身份证件类型"]
["checkZjlx",9,"境外永久居住证","身份证件类型"]
["checkZjlx","A","护照","身份证件类型"]
["checkZjlx","B","户口薄","身份证件类型"]
["checkZjlx","Z","其他","身份证件类型"]