{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["测评情况汇总","Sheet1"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"测评情况汇总","index":0,"n_rows":96,"n_cols":36,"rows_kept":96,"merged":[[0,0,0,32],[1,0,1,1],[1,2,1,4],[1,5,1,6],[1,7,1,14],[1,15,1,16],[1,17,1,20],[1,21,1,22],[1,23,1,30],[1,31,1,32],[1,33,1,35],[2,0,2,1],[2,3,2,6],[2,7,2,14],[2,15,2,20],[2,21,2,22],[2,23,2,30],[2,32,2,33],[2,34,2,35],[3,0,3,1],[3,3,3,6],[3,7,3,14],[3,15,3,18],[3,19,3,20],[3,21,3,29],[3,30,3,31],[3,32,3,33],[3,34,3,35],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,16],[4,17,4,30],[4,31,5,31],[4,32,5,32],[4,33,5,33],[4,34,5,34],[4,35,5,35]]}
["附件：9.西华大学家庭经济困难学生认定测评汇总统计表"]
["学院",{"$nulls":4},"专业",{"$nulls":9},"年级",{"$nulls":5},"班级",{"$nulls":9},"认定学年",null,"2022-2023"]
["评议人员人数",null,null,"班级人数",{"$nulls":3},{"$f":"COUNTA(B7:B96)","v":0},{"$nulls":7},"申请认定人数",{"$nulls":5},{"$f":"COUNTA(D7:D96)","v":0},null,"特殊困难人数",{"$nulls":7},{"$f":"COUNTA(AI7:AI96)","v":0},"申请认定率",null,{"$f":"V3/H3","v":{"$error":"#DIV/0!"}}]
["特别困难人数",null,{"$f":"COUNTIF(AH7:AH96,\"特别困难\")","v":0},"困难人数",{"$nulls":3},{"$f":"COUNTIF(AH7:AH96,\"困难\")","v":0},{"$nulls":7},"一般困难人数",{"$nulls":3},{"$f":"COUNTIF(AH7:AH96,\"一般困难\")","v":0},null,"认定为不困难人数",{"$nulls":8},{"$f":"COUNTIF(AH7:AH96,\"不困难\")","v":0},null,"困难认定率",null,{"$f":"(C4+H4+T4)/H3","v":{"$error":"#DIV/0!"}}]
["序号","学号","姓名","困难程度P",{"$nulls":13},"节俭程度J",{"$nulls":13},"测评分","排名","贫困档次","特殊困难学生类别","备注"]
[{"$nulls":3},"A","B","C","D","E","F","G","H","I","J","K","L","M","得分","A","B","C","D","E","F","G","H","I","J","K","L","M","得分"]
["3",{"$nulls":15},{"$f":"((SUM(D7:P7)-MAX(D7:P7)-MIN(D7:P7))/(COUNTA(D7:P7)-2))","v":0},{"$nulls":13},{"$f":"((SUM(R7:AD7)-MAX(R7:AD7)-MIN(R7:AD7))/(COUNTA(R7:AD7)-2))","v":0},{"$f":"Q7*0.7+AE7*0.3","v":0},{"$f":"RANK(AF7,$AF:$AF)","v":1}]
["1",{"$nulls":15},0,{"$nulls":13},0,0,1]
["2",{"$nulls":15},0,{"$nulls":13},0,0,1]
["4",{"$nulls":15},0,{"$nulls":13},0,0,1]
["5",{"$nulls":15},0,{"$nulls":13},0,0,1]
["6",{"$nulls":15},0,{"$nulls":13},0,0,1]
["7",{"$nulls":15},0,{"$nulls":13},0,0,1]
["8",{"$nulls":15},0,{"$nulls":13},0,0,1]
["9",{"$nulls":15},0,{"$nulls":13},0,0,1]
["10",{"$nulls":15},0,{"$nulls":13},0,0,1]
["11",{"$nulls":15},0,{"$nulls":13},0,0,1]
["12",{"$nulls":15},0,{"$nulls":13},0,0,1]
["13",{"$nulls":15},0,{"$nulls":13},0,0,1]
["14",{"$nulls":15},0,{"$nulls":13},0,0,1]
["15",{"$nulls":15},0,{"$nulls":13},0,0,1]
["16",{"$nulls":15},0,{"$nulls":13},0,0,1]
["17",{"$nulls":15},0,{"$nulls":13},0,0,1]
["18",{"$nulls":15},0,{"$nulls":13},0,0,1]
["19",{"$nulls":15},0,{"$nulls":13},0,0,1]
["20",{"$nulls":15},0,{"$nulls":13},0,0,1]
["21",{"$nulls":15},0,{"$nulls":13},0,0,1]
["22",{"$nulls":15},0,{"$nulls":13},0,0,1]
["23",{"$nulls":15},0,{"$nulls":13},0,0,1]
["24",{"$nulls":15},0,{"$nulls":13},0,0,1]
["25",{"$nulls":15},0,{"$nulls":13},0,0,1]
["26",{"$nulls":15},0,{"$nulls":13},0,0,1]
["27",{"$nulls":15},0,{"$nulls":13},0,0,1]
["28",{"$nulls":15},0,{"$nulls":13},0,0,1]
["29",{"$nulls":15},0,{"$nulls":13},0,0,1]
["30",{"$nulls":15},0,{"$nulls":13},0,0,1]
["31",{"$nulls":15},0,{"$nulls":13},0,0,1]
["32",{"$nulls":15},0,{"$nulls":13},0,0,1]
["33",{"$nulls":15},{"$f":"((SUM(D39:P39)-MAX(D39:P39)-MIN(D39:P39))/(COUNTA(D39:P39)-2))","v":0},{"$nulls":13},{"$f":"((SUM(R39:AD39)-MAX(R39:AD39)-MIN(R39:AD39))/(COUNTA(R39:AD39)-2))","v":0},{"$f":"Q39*0.7+AE39*0.3","v":0},{"$f":"RANK(AF39,$AF:$AF)","v":1}]
["34",{"$nulls":15},0,{"$nulls":13},0,0,1]
["35",{"$nulls":15},0,{"$nulls":13},0,0,1]
["36",{"$nulls":15},0,{"$nulls":13},0,0,1]
["37",{"$nulls":15},0,{"$nulls":13},0,0,1]
["38",{"$nulls":15},0,{"$nulls":13},0,0,1]
["39",{"$nulls":15},0,{"$nulls":13},0,0,1]
["40",{"$nulls":15},0,{"$nulls":13},0,0,1]
["41",{"$nulls":15},0,{"$nulls":13},0,0,1]
["42",{"$nulls":15},0,{"$nulls":13},0,0,1]
["43",{"$nulls":15},0,{"$nulls":13},0,0,1]
["44",{"$nulls":15},0,{"$nulls":13},0,0,1]
["45",{"$nulls":15},0,{"$nulls":13},0,0,1]
["46",{"$nulls":15},0,{"$nulls":13},0,0,1]
["47",{"$nulls":15},0,{"$nulls":13},0,0,1]
["48",{"$nulls":15},0,{"$nulls":13},0,0,1]
["49",{"$nulls":15},0,{"$nulls":13},0,0,1]
["50",{"$nulls":15},0,{"$nulls":13},0,0,1]
["51",{"$nulls":15},0,{"$nulls":13},0,0,1]
["52",{"$nulls":15},0,{"$nulls":13},0,0,1]
["53",{"$nulls":15},0,{"$nulls":13},0,0,1]
["54",{"$nulls":15},0,{"$nulls":13},0,0,1]
["55",{"$nulls":15},0,{"$nulls":13},0,0,1]
["56",{"$nulls":15},0,{"$nulls":13},0,0,1]
["57",{"$nulls":15},0,{"$nulls":13},0,0,1]
["58",{"$nulls":15},0,{"$nulls":13},0,0,1]
["59",{"$nulls":15},0,{"$nulls":13},0,0,1]
["60",{"$nulls":15},0,{"$nulls":13},0,0,1]
["61",{"$nulls":15},{"$f":"((SUM(D67:P67)-MAX(D67:P67)-MIN(D67:P67))/(COUNTA(D67:P67)-2))","v":0},{"$nulls":13},{"$f":"((SUM(R67:AD67)-MAX(R67:AD67)-MIN(R67:AD67))/(COUNTA(R67:AD67)-2))","v":0},{"$f":"Q67*0.7+AE67*0.3","v":0},{"$f":"RANK(AF67,$AF:$AF)","v":1}]
["62",{"$nulls":15},0,{"$nulls":13},0,0,1]
["63",{"$nulls":15},0,{"$nulls":13},0,0,1]
["64",{"$nulls":15},0,{"$nulls":13},0,0,1]
["65",{"$nulls":15},0,{"$nulls":13},0,0,1]
["66",{"$nulls":15},0,{"$nulls":13},0,0,1]
["67",{"$nulls":15},0,{"$nulls":13},0,0,1]
["68",{"$nulls":15},0,{"$nulls":13},0,0,1]
["69",{"$nulls":15},0,{"$nulls":13},0,0,1]
["70",{"$nulls":15},0,{"$nulls":13},0,0,1]
["71",{"$nulls":15},0,{"$nulls":13},0,0,1]
["72",{"$nulls":15},0,{"$nulls":13},0,0,1]
["73",{"$nulls":15},0,{"$nulls":13},0,0,1]
["74",{"$nulls":15},0,{"$nulls":13},0,0,1]
["75",{"$nulls":15},0,{"$nulls":13},0,0,1]
["76",{"$nulls":15},0,{"$nulls":13},0,0,1]
["77",{"$nulls":15},0,{"$nulls":13},0,0,1]
["78",{"$nulls":15},0,{"$nulls":13},0,0,1]
["79",{"$nulls":15},0,{"$nulls":13},0,0,1]
["80",{"$nulls":15},0,{"$nulls":13},0,0,1]
["81",{"$nulls":15},0,{"$nulls":13},0,0,1]
["82",{"$nulls":15},0,{"$nulls":13},0,0,1]
["83",{"$nulls":15},0,{"$nulls":13},0,0,1]
["84",{"$nulls":15},0,{"$nulls":13},0,0,1]
["85",{"$nulls":15},0,{"$nulls":13},0,0,1]
["86",{"$nulls":15},0,{"$nulls":13},0,0,1]
["87",{"$nulls":15},0,{"$nulls":13},0,0,1]
["88",{"$nulls":15},0,{"$nulls":13},0,0,1]
["89",{"$nulls":15},0,{"$nulls":13},0,0,1]
["90",{"$nulls":15},0,{"$nulls":13},0,0,1]

{"sheet":"Sheet1","index":1,"n_rows":9,"n_cols":15,"rows_kept":9}
[{"$nulls":12},"特别困难"]
[{"$nulls":12},"困难","脱贫家庭","评议人"]
[{"$nulls":12},"一般困难","边缘易致贫","退役复学"]
[{"$nulls":12},"不困难","脱贫不稳定","深贫县定向生"]
[{"$nulls":13},"突发严重困难","放弃"]
[{"$nulls":13},"城乡低保"]
[{"$nulls":13},"特困救助"]
[{"$nulls":13},"孤儿"]
[{"$nulls":13},"残疾"]