{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":40,"n_cols":41,"rows_kept":40,"merged":[[0,0,0,2],[0,3,0,19],[0,21,0,23],[0,24,0,34],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,14],[1,15,2,15],[1,16,2,16],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,24,1,35],[1,36,2,36],[1,37,2,37],[1,38,2,38],[1,39,2,39],[1,40,2,40]],"flags":["formulas_cached_only"]}
["班级",null,null,"学生成绩登记表",{"$nulls":17},"班级",null,null,"学生成绩登记表"]
["序号","学号","姓名","作          业",{"$nulls":11},"半期成绩","折合占%","期未成绩","折合占%","总   评",null,"序号","学号","姓名","作          业",{"$nulls":11},"半期成绩","折合占%","期未成绩","折合占%","总   评"]
[{"$nulls":3},1,2,3,4,5,6,7,8,9,10,"平均成绩","折合占%",{"$nulls":9},1,2,3,4,5,6,7,8,9,10,"平均成绩","折合占%"]
[1,{"$nulls":20},38]
[2,{"$nulls":20},39]
[3,{"$nulls":20},40]
[4,{"$nulls":20},41]
[5,{"$nulls":20},42]
[6,{"$nulls":20},43]
[7,{"$nulls":20},44]
[8,{"$nulls":20},45]
[9,{"$nulls":20},46]
[10,{"$nulls":20},47]
[11,{"$nulls":20},48]
[12,{"$nulls":20},49]
[13,{"$nulls":20},50]
[14,{"$nulls":20},51]
[15,{"$nulls":20},52]
[16,{"$nulls":20},53]
[17,{"$nulls":20},54]
[18,{"$nulls":20},55]
[19,{"$nulls":20},56]
[20,{"$nulls":20},57]
[21,{"$nulls":20},58]
[22,{"$nulls":20},59]
[23,{"$nulls":20},60]
[24,{"$nulls":20},61]
[25,{"$nulls":20},62]
[26,{"$nulls":20},63]
[27,{"$nulls":20},64]
[28,{"$nulls":20},65]
[29,{"$nulls":20},66]
[30,{"$nulls":20},67]
[31,{"$nulls":20},68]
[32,{"$nulls":20},69]
[33,{"$nulls":20},70]
[34,{"$nulls":20},71]
[35,{"$nulls":20},72]
[36,{"$nulls":20},73]
[37,{"$nulls":20},74]

{"sheet":"Sheet2","index":1,"n_rows":68,"n_cols":17,"rows_kept":68,"merged":[[0,0,0,1],[0,2,0,14],[1,0,2,0],[1,1,2,1],[1,2,1,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[48,0,48,1],[48,2,48,11],[49,0,50,0],[49,1,50,1],[49,2,49,10],[49,11,50,11],[49,12,50,12],[49,13,50,13],[49,14,50,14],[49,15,50,15],[49,16,50,16]],"flags":["formulas_cached_only"]}
["04级会计二班",null,"学生成绩登记表"]
["学号","姓名","作          业",{"$nulls":8},"第一次测验或半期","折合占%","第二次测验或期未","折合占%","合计分数","总   评"]
[]
["200421610301","杨宝"]
["200421610302","王虹"]
["200421610303","魏晓丽"]
["200421610304","米红梅"]
["200421610305","伍玲"]
["200421610306","唐艳"]
["200421610307","岳燕云"]
["200421610308","刘晓兰"]
["200421610309","纪莲"]
["200421610310","田玉酩"]
["200421610311","蔡昕"]
["200421610312","周霞"]
["200421610313","申清"]
["200421610314","曾君"]
["200421610315","刘一辉"]
["200421610316","刘毓"]
["200421610317","李长清"]
["200421610318","张美林"]
["200421610319","丁立"]
["200421610320","傅振宇"]
["200421610321","袁智"]
["200421610322","蔡丹"]
["200421610323","万方"]
["200421610324","李建"]
["200421610325","唐文博"]
["200421610326","青小利"]
["200421610327","孙金凤"]
["200421610328","迭梅"]
["200421610329","江金"]
["200421610330","李欣隆"]
["200421610331","敬小娟"]
["200421610332","史美华"]
["200421610333","何益"]
["200421610334","王霞淋"]
["200421610335","敬静"]
["200421610336","李雨馨"]
["200421610337","唐蓉"]
["200421610338","唐丹"]
{"$rows_empty":7}
["04级会计二班",null,"学生成绩登记表"]
["学号","姓名","作          业",{"$nulls":8},"第一次测验或半期","折合占%","第二次测验或期未","折合占%","合计分数","总   评"]
[]
["200421610339","刘丽红"]
["200421610340","张文静"]
["200421610341","周旭"]
["200421610342","刘颖梅"]
["200421610343","李科勇"]
["200421610344","宋亮"]
["200421610345","张洋"]
["200421610346","李涛"]
["200421610347","郝和莉"]
["200421610348","朱清"]
["200421610349","肖戴苧"]
["200421610350","奉叶"]
["200421610351","吴晓莉"]
["200421610352","陈思强"]
["200421610353","田莎"]
["200421610354","刘虹兵"]
["200421610355","张利"]

{"sheet":"Sheet3","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"flags":["formulas_cached_only"]}
[]
[]
["IF(LEN(M2)=18,MID(M2,7,8),CONCATENATE(19,(MID(M2,7,6))))"]