{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["使用说明","封面","设置","花名","汇总","“三率”分析","分数段统计","分班成绩模板"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"使用说明","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[]
["第一步：","在“设置”表中设置好考试基本信息、任课教师、总分、优生标准、及格标准等信息。"]
["第二步：","将成绩数据复制（选择性粘贴数值）到“汇总”表中。"]
["第三步：","在“汇总”表中计算总分、分班（速度视计算机配置高低而不同）。"]
["第四步：","分类打印。"]
[null,"设计制作：饶军"]
[null,"2018年7月第二版"]

{"sheet":"封面","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"设置","index":2,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,0,5,12],[6,0,6,1],[25,0,25,12],[26,0,26,1],[27,0,27,1],[7,0,24,0],[3,0,3,3],[3,4,3,5],[3,7,3,8],[3,9,3,12],[4,0,4,3],[4,4,4,5],[4,7,4,8],[4,9,4,12],[0,0,0,12],[1,0,1,12],[2,0,2,3],[2,4,2,5],[2,7,2,8],[2,9,2,12]]}
[{"$f":"E3&E5&\"成绩管理系统设置窗口\"","v":"天景初级中学八年级成绩管理系统设置窗口"}]
[]
["学校名称",null,null,null,"天景初级中学",null,null,"期   别",null,"2018年上期"]
["填表时间",null,null,null,"2018.07.05",null,null,"考试类型",null,"期中考试"]
["考试年级",null,null,null,"八年级",null,null,"统计人",null,"余红军",null,null,null,null,null,null,{"$f":"IF(E5=\"九年级\",\"9年级\",IF(E5=\"八年级\",\"8年级\",IF(E5=\"七年级\",\"7年级\",\"\")))","v":"8年级"}]
[]
[null,null,"班主任","语文","数学","英语","物理","化学","生物","历史","思品","地理","体育"]
[null,"总分",null,150,150,150,80,70,25,100,100,100,50]
[null,"该科折算率",null,1,1,1,1,1,1,1,1,1,1]
[null,"一班"]
[null,"二班"]
[null,"三班"]
[null,"四班"]
[null,"五班"]
[null,"六班"]
[null,"七班"]
[null,"八班"]
[null,"九班"]
[null,"十班"]
[null,"十一班"]
[null,"十二班"]
[null,"十三班"]
[null,"十四班"]
[null,"十五班"]
[null,"十六班"]
[]
["优生标准",null,null,{"$f":"D8*0.8","v":120},{"$f":"E8*0.8","v":120},120,64,56,20,80,80,80,40]
["及格标准",null,null,{"$f":"D8*0.6","v":90},{"$f":"E8*0.6","v":90},90,48,42,15,60,60,60,30]

{"sheet":"花名","index":3,"n_rows":87,"n_cols":17,"rows_kept":87,"cut":false,"hidden":false,"merged":[[0,0,0,15],[86,0,86,15]]}
[{"$f":"设置!E3&设置!J3&设置!J4&\"各班花名核对情况\"","v":"天景初级中学2018年上期期中考试各班花名核对情况"}]
["1班","2班","3班","4班","5班","6班","7班","8班","9班","10班","11班","12班","13班","14班","15班","16班"]
[{"$f":"83-COUNTIF(A4:A86,\"\")","v":5},{"$f":"83-COUNTIF(B4:B86,\"\")","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,{"$f":"SUM(A3:P3)","v":80}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(分班成绩模板!#REF!=\"\",\"\",分班成绩模板!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(分班成绩模板!#REF!=\"\",\"\",分班成绩模板!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(分班成绩模板!#REF!=\"\",\"\",分班成绩模板!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(分班成绩模板!#REF!=\"\",\"\",分班成绩模板!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF(分班成绩模板!#REF!=\"\",\"\",分班成绩模板!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
["    每竖排为本班全部学生，最上面有本班现有人数，请各班班主任仔细核对人员信息，如有错误报请年级处更正。"]

{"sheet":"汇总","index":4,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,0,16,14],[5,13,6,13],[4,14,5,14],[0,0,1,14],[2,0,3,1],[2,7,3,8],[7,13,15,14],[7,0,15,1],[2,2,2,3],[2,10,2,13],[5,0,5,2],[6,0,6,2]]}
[{"$f":"设置!E3&设置!J3&设置!E5&设置!J4&\"年级成绩汇总\"","v":"天景初级中学2018年上期八年级期中考试年级成绩汇总"}]
[]
[null,null,{"$f":"\"统计人：\"&设置!J5","v":"统计人：余红军"},null,null,null,null,null,null,null,{"$f":"\"时间：\"&设置!E4","v":"时间：2018.07.05"}]
[]
["班级","姓  名","学号",{"$f":"IF(设置!D7=\"\",\"\",设置!D7)","v":"语文"},{"$f":"IF(设置!E7=\"\",\"\",设置!E7)","v":"数学"},{"$f":"IF(设置!F7=\"\",\"\",设置!F7)","v":"英语"},{"$f":"IF(设置!G7=\"\",\"\",设置!G7)","v":"物理"},{"$f":"IF(设置!H7=\"\",\"\",设置!H7)","v":"化学"},{"$f":"IF(设置!I7=\"\",\"\",设置!I7)","v":"生物"},{"$f":"IF(设置!J7=\"\",\"\",设置!J7)","v":"历史"},{"$f":"IF(设置!K7=\"\",\"\",设置!K7)","v":"思品"},{"$f":"IF(设置!L7=\"\",\"\",设置!L7)","v":"地理"},{"$f":"IF(设置!M7=\"\",\"\",设置!M7)","v":"体育"},"总分","年级\n名次"]
["该   科  总  分",null,null,{"$f":"IF(设置!D8=\"\",\"\",设置!D8)","v":150},{"$f":"IF(设置!E8=\"\",\"\",设置!E8)","v":150},{"$f":"IF(设置!F8=\"\",\"\",设置!F8)","v":150},{"$f":"IF(设置!G8=\"\",\"\",设置!G8)","v":80},{"$f":"IF(设置!H8=\"\",\"\",设置!H8)","v":70},{"$f":"IF(设置!I8=\"\",\"\",设置!I8)","v":25},{"$f":"IF(设置!J8=\"\",\"\",设置!J8)","v":100},{"$f":"IF(设置!K8=\"\",\"\",设置!K8)","v":100},{"$f":"IF(设置!L8=\"\",\"\",设置!L8)","v":100},{"$f":"IF(设置!M8=\"\",\"\",设置!M8)","v":50}]
["总分中该科折算率",null,null,{"$f":"IF(设置!D9=\"\",\"\",设置!D9)","v":1},{"$f":"IF(设置!E9=\"\",\"\",设置!E9)","v":1},{"$f":"IF(设置!F9=\"\",\"\",设置!F9)","v":1},{"$f":"IF(设置!G9=\"\",\"\",设置!G9)","v":1},{"$f":"IF(设置!H9=\"\",\"\",设置!H9)","v":1},{"$f":"IF(设置!I9=\"\",\"\",设置!I9)","v":1},{"$f":"IF(设置!J9=\"\",\"\",设置!J9)","v":1},{"$f":"IF(设置!K9=\"\",\"\",设置!K9)","v":1},{"$f":"IF(设置!L9=\"\",\"\",设置!L9)","v":1},{"$f":"IF(设置!M9=\"\",\"\",设置!M9)","v":1}]
["数据分析",null,null,null,null,null,null,null,null,null,null,null,null,"数据分析"]
[null,null,"参考人数",{"$f":"IF(D18=\"\",\"\",COUNTIF(D18:D$65536,\">0\"))","v":""},{"$f":"IF(E18=\"\",\"\",COUNTIF(E18:E$65536,\">0\"))","v":""},{"$f":"IF(F18=\"\",\"\",COUNTIF(F18:F$65536,\">0\"))","v":""},{"$f":"IF(G18=\"\",\"\",COUNTIF(G18:G$65536,\">0\"))","v":""},{"$f":"IF(H18=\"\",\"\",COUNTIF(H18:H$65536,\">0\"))","v":""},{"$f":"IF(I18=\"\",\"\",COUNTIF(I18:I$65536,\">0\"))","v":""},{"$f":"IF(J18=\"\",\"\",COUNTIF(J18:J$65536,\">0\"))","v":""},{"$f":"IF(K18=\"\",\"\",COUNTIF(K18:K$65536,\">0\"))","v":""},{"$f":"IF(L18=\"\",\"\",COUNTIF(L18:L$65536,\">0\"))","v":""},{"$f":"IF(M18=\"\",\"\",COUNTIF(M18:M$65536,\">0\"))","v":""}]
[null,null,"最  低 分",{"$f":"IF(D$18=\"\",\"\",MIN(D18:D$65536))","v":""},{"$f":"IF(E$18=\"\",\"\",MIN(E18:E$65536))","v":""},{"$f":"IF(F$18=\"\",\"\",MIN(F18:F$65536))","v":""},{"$f":"IF(G$18=\"\",\"\",MIN(G18:G$65536))","v":""},{"$f":"IF(H$18=\"\",\"\",MIN(H18:H$65536))","v":""},{"$f":"IF(I$18=\"\",\"\",MIN(I18:I$65536))","v":""},{"$f":"IF(J$18=\"\",\"\",MIN(J18:J$65536))","v":""},{"$f":"IF(K$18=\"\",\"\",MIN(K18:K$65536))","v":""},{"$f":"IF(L$18=\"\",\"\",MIN(L18:L$65536))","v":""},{"$f":"IF(M$18=\"\",\"\",MIN(M18:M$65536))","v":""}]
[null,null,"最  高 分",{"$f":"IF(D$18=\"\",\"\",MAX(D18:D$65536))","v":""},{"$f":"IF(E$18=\"\",\"\",MAX(E18:E$65536))","v":""},{"$f":"IF(F$18=\"\",\"\",MAX(F18:F$65536))","v":""},{"$f":"IF(G$18=\"\",\"\",MAX(G18:G$65536))","v":""},{"$f":"IF(H$18=\"\",\"\",MAX(H18:H$65536))","v":""},{"$f":"IF(I$18=\"\",\"\",MAX(I18:I$65536))","v":""},{"$f":"IF(J$18=\"\",\"\",MAX(J18:J$65536))","v":""},{"$f":"IF(K$18=\"\",\"\",MAX(K18:K$65536))","v":""},{"$f":"IF(L$18=\"\",\"\",MAX(L18:L$65536))","v":""},{"$f":"IF(M$18=\"\",\"\",MAX(M18:M$65536))","v":""}]
[null,null,"平  均  分",{"$f":"IF(D9=\"\",\"\",SUM(D18:D$65536)/D9)","v":""},{"$f":"IF(E9=\"\",\"\",SUM(E18:E$65536)/E9)","v":""},{"$f":"IF(F9=\"\",\"\",SUM(F18:F$65536)/F9)","v":""},{"$f":"IF(G9=\"\",\"\",SUM(G18:G$65536)/G9)","v":""},{"$f":"IF(H9=\"\",\"\",SUM(H18:H$65536)/H9)","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I18:I$65536)/I9)","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J18:J$65536)/J9)","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K18:K$65536)/K9)","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L18:L$65536)/L9)","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M18:M$65536)/M9)","v":""}]
[null,null,"优生人数",{"$f":"IF(D18=\"\",\"\",COUNTIF(D18:D$65536,\">=\"&设置!D27))","v":""},{"$f":"IF(E18=\"\",\"\",COUNTIF(E18:E$65536,\">=\"&设置!E27))","v":""},{"$f":"IF(F18=\"\",\"\",COUNTIF(F18:F$65536,\">=\"&设置!F27))","v":""},{"$f":"IF(G18=\"\",\"\",COUNTIF(G18:G$65536,\">=\"&设置!G27))","v":""},{"$f":"IF(H18=\"\",\"\",COUNTIF(H18:H$65536,\">=\"&设置!H27))","v":""},{"$f":"IF(I18=\"\",\"\",COUNTIF(I18:I$65536,\">=\"&设置!I27))","v":""},{"$f":"IF(J18=\"\",\"\",COUNTIF(J18:J$65536,\">=\"&设置!J27))","v":""},{"$f":"IF(K18=\"\",\"\",COUNTIF(K18:K$65536,\">=\"&设置!K27))","v":""},{"$f":"IF(L18=\"\",\"\",COUNTIF(L18:L$65536,\">=\"&设置!L27))","v":""},{"$f":"IF(M18=\"\",\"\",COUNTIF(M18:M$65536,\">=\"&设置!M27))","v":""}]
[null,null,"优  生  率",{"$f":"IF(D9=\"\",\"\",(D13/D9))","v":""},"","","","","","","","",""]
[null,null,"及格人数",{"$f":"IF(D18=\"\",\"\",COUNTIF(D18:D65536,\">=\"&设置!D28))","v":""},{"$f":"IF(E18=\"\",\"\",COUNTIF(E18:E65536,\">=\"&设置!E28))","v":""},{"$f":"IF(F18=\"\",\"\",COUNTIF(F18:F65536,\">=\"&设置!F28))","v":""},{"$f":"IF(G18=\"\",\"\",COUNTIF(G18:G65536,\">=\"&设置!G28))","v":""},{"$f":"IF(H18=\"\",\"\",COUNTIF(H18:H65536,\">=\"&设置!H28))","v":""},{"$f":"IF(I18=\"\",\"\",COUNTIF(I18:I65536,\">=\"&设置!I28))","v":""},{"$f":"IF(J18=\"\",\"\",COUNTIF(J18:J65536,\">=\"&设置!J28))","v":""},{"$f":"IF(K18=\"\",\"\",COUNTIF(K18:K65536,\">=\"&设置!K28))","v":""},{"$f":"IF(L18=\"\",\"\",COUNTIF(L18:L65536,\">=\"&设置!L28))","v":""},{"$f":"IF(M18=\"\",\"\",COUNTIF(M18:M65536,\">=\"&设置!M28))","v":""}]
[null,null,"及  格 率",{"$f":"IF(D9=\"\",\"\",(D15/D9))","v":""},"","","","","","","","",""]

{"sheet":"“三率”分析","index":5,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,1,1,2],[1,9,1,10],[19,1,19,2],[19,4,19,5],[19,7,19,8],[19,10,19,11]]}
[{"$f":"设置!E3&设置!J3&设置!E5&设置!J4&\"成绩“三率”分析\"","v":"天景初级中学2018年上期八年级期中考试成绩“三率”分析"}]
[null,{"$f":"\"统计人：\"&设置!J5","v":"统计人：余红军"},null,null,null,null,null,null,null,{"$f":"\"时间：\"&设置!E4","v":"时间：2018.07.05"}]
["班级","科目","教师","参考人数","平均分","排名","优生数","优生率","排名","及格数","及格率","排名","单科排名累计","单科综合排名","班机累计","班级名次","单科排名累计","单科综合排名","班机累计","班级名次"]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A4=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D4=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B4,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A4,LEN($A4)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B4,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A4,LEN($A4)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B4,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},{"$f":"IFERROR(RANK(E4,OFFSET(INDIRECT(\"E\"&17*INT((ROW()-3)/17)+4),0,0,16,1)),\"\")","v":""},{"$f":"IF(D4=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B4,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B4,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},{"$f":"IFERROR(G4/D4,\"\")","v":""},{"$f":"IFERROR(RANK(H4,OFFSET(INDIRECT(\"H\"&17*INT((ROW()-3)/17)+4),0,0,16,1)),\"\")","v":""},{"$f":"IF(G4=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B4,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B4,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},{"$f":"IFERROR(J4/D4,\"\")","v":""},{"$f":"IFERROR(RANK(K4,OFFSET(INDIRECT(\"K\"&17*INT((ROW()-3)/17)+4),0,0,16,1)),\"\")","v":""},{"$f":"F4+I4+L4","v":{"$error":"#VALUE!"}},{"$f":"IF(M4=\"\",\"\",RANK(M4,M$4:M$19,1))","v":{"$error":"#VALUE!"}},{"$f":"N4+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$f":"IF(O4=\"\",\"\",RANK(O4,O$4:O$19,1))","v":{"$error":"#VALUE!"}},{"$f":"F4+I4+L4","v":{"$error":"#VALUE!"}},{"$f":"IF(Q4=\"\",\"\",RANK(Q4,Q$4:Q$19,1))","v":{"$error":"#VALUE!"}},{"$f":"R4+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$f":"IF(S4=\"\",\"\",RANK(S4,S$4:S$19,1))","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A5=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D5=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A5,LEN($A5)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B5,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A5,LEN($A5)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B5,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D5=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B5,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B5,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G5=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B5,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B5,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"F5+I5+L5","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"N5+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"F5+I5+L5","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"R5+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A6=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D6=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B6,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A6,LEN($A6)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B6,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A6,LEN($A6)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B6,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D6=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B6,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B6,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G6=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B6,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B6,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N6+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R6+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A7=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D7=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B7,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A7,LEN($A7)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B7,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A7,LEN($A7)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B7,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D7=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B7,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B7,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G7=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B7,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B7,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N7+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R7+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A8=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D8=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B8,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A8,LEN($A8)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B8,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A8,LEN($A8)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B8,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D8=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B8,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B8,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G8=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B8,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B8,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N8+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R8+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A9=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D9=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B9,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A9,LEN($A9)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B9,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A9,LEN($A9)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B9,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D9=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B9,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B9,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G9=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B9,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B9,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N9+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R9+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A10=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D10=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B10,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A10,LEN($A10)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B10,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A10,LEN($A10)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B10,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D10=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B10,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B10,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G10=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B10,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B10,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N10+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R10+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A11=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D11=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B11,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A11,LEN($A11)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B11,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A11,LEN($A11)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B11,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D11=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B11,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B11,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G11=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B11,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B11,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N11+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R11+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A12=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D12=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B12,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A12,LEN($A12)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B12,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A12,LEN($A12)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B12,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D12=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B12,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B12,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G12=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B12,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B12,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N12+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R12+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A13=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D13=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B13,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A13,LEN($A13)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B13,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A13,LEN($A13)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B13,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D13=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B13,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B13,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G13=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B13,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B13,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N13+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R13+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A14=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D14=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B14,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A14,LEN($A14)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B14,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A14,LEN($A14)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B14,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D14=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B14,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B14,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G14=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B14,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B14,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N14+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R14+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A15=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D15=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B15,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A15,LEN($A15)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B15,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A15,LEN($A15)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B15,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D15=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B15,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B15,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G15=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B15,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B15,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N15+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R15+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A16=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D16=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B16,设置!$C$7:$M$7,0)))","v":""},{"$f":"IFERROR(COUNTIFS(汇总!$A$18:$A$10000,LEFT($A16,LEN($A16)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B16,汇总!$D$5:$M$5,0)-1),\">0\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A16,LEN($A16)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B16,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D16=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B16,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B16,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G16=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B16,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B16,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N16+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R16+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A17=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D17=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B17,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(COUNTIFS(CHOOSE(INT((ROW()-4)/17)+1,汇总!$D$18:$D$10000,汇总!$E$18:$E$10000,汇总!$F$18:$F$10000,汇总!$G$18:$G$10000,汇总!$H$18:$H$10000,汇总!$I$18:$I$10000,汇总!$J$18:$J$10000,汇总!$K$18:$K$10000,汇总!$L$18:$L$10000,汇总!$M$18:$M$10000),\">0\",汇总!$A$18:$A$10000,MOD(ROW()-3,17))>0,COUNTIFS(CHOOSE(INT((ROW()-4)/17)+1,汇总!$D$18:$D$10000,汇总!$E$18:$E$10000,汇总!$F$18:$F$10000,汇总!$G$18:$G$10000,汇总!$H$18:$H$10000,汇总!$I$18:$I$10000,汇总!$J$18:$J$10000,汇总!$K$18:$K$10000,汇总!$L$18:$L$10000,汇总!$M$18:$M$10000),\">0\",汇总!$A$18:$A$10000,MOD(ROW()-3,17)),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A17,LEN($A17)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B17,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D17=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B17,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B17,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G17=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B17,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B17,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N17+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R17+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A18=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D18=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B18,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(COUNTIFS(CHOOSE(INT((ROW()-4)/17)+1,汇总!$D$18:$D$10000,汇总!$E$18:$E$10000,汇总!$F$18:$F$10000,汇总!$G$18:$G$10000,汇总!$H$18:$H$10000,汇总!$I$18:$I$10000,汇总!$J$18:$J$10000,汇总!$K$18:$K$10000,汇总!$L$18:$L$10000,汇总!$M$18:$M$10000),\">0\",汇总!$A$18:$A$10000,MOD(ROW()-3,17))>0,COUNTIFS(CHOOSE(INT((ROW()-4)/17)+1,汇总!$D$18:$D$10000,汇总!$E$18:$E$10000,汇总!$F$18:$F$10000,汇总!$G$18:$G$10000,汇总!$H$18:$H$10000,汇总!$I$18:$I$10000,汇总!$J$18:$J$10000,汇总!$K$18:$K$10000,汇总!$L$18:$L$10000,汇总!$M$18:$M$10000),\">0\",汇总!$A$18:$A$10000,MOD(ROW()-3,17)),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A18,LEN($A18)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B18,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D18=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B18,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B18,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G18=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B18,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B18,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N18+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R18+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"IF(INDEX(设置!$C$10:$C$25,MOD(ROW()-3,17))=\"\",\"\",MOD(ROW()-3,17)&\"班\")","v":""},{"$f":"IF(A19=\"\",\"\",INDEX(设置!$D$7:$M$7,LARGE(NOT(设置!$D$10:$M$10=\"\")*(COLUMN(设置!$D$10:$M$10)-3),10-COUNTBLANK(设置!$D$10:$M$10)-INT((ROW()-4)/17))))","v":""},{"$f":"IF(D19=\"\",\"\",INDEX(设置!$C$10:$M$25,MOD(ROW()-3,17),MATCH(B19,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(COUNTIFS(CHOOSE(INT((ROW()-4)/17)+1,汇总!$D$18:$D$10000,汇总!$E$18:$E$10000,汇总!$F$18:$F$10000,汇总!$G$18:$G$10000,汇总!$H$18:$H$10000,汇总!$I$18:$I$10000,汇总!$J$18:$J$10000,汇总!$K$18:$K$10000,汇总!$L$18:$L$10000,汇总!$M$18:$M$10000),\">0\",汇总!$A$18:$A$10000,MOD(ROW()-3,17))>0,COUNTIFS(CHOOSE(INT((ROW()-4)/17)+1,汇总!$D$18:$D$10000,汇总!$E$18:$E$10000,汇总!$F$18:$F$10000,汇总!$G$18:$G$10000,汇总!$H$18:$H$10000,汇总!$I$18:$I$10000,汇总!$J$18:$J$10000,汇总!$K$18:$K$10000,汇总!$L$18:$L$10000,汇总!$M$18:$M$10000),\">0\",汇总!$A$18:$A$10000,MOD(ROW()-3,17)),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(汇总!$A$18:$A$10000,LEFT($A19,LEN($A19)-1),OFFSET(汇总!$D$18:$D$10000,0,MATCH($B19,汇总!$D$5:$M$5,0)-1)),\"\")","v":""},"",{"$f":"IF(D19=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B19,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$27:$M$27,MATCH($B19,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$f":"IF(G19=\"\",\"\",COUNTIFS(OFFSET(汇总!$D$18:$D$10000,0,MATCH($B19,汇总!$D$5:$M$5,0)-1),\">=\"&INDEX(设置!$D$28:$M$28,MATCH($B19,设置!$D$7:$M$7,0)),汇总!$A$18:$A$10000,MOD(ROW()-3,17)))","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"N19+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R19+#REF!+#REF!","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["年级汇总",{"$f":"B4","v":""},{"$f":"IF(B20=\"\",\"\",INDEX(设置!$D$7:$M$7,INT((ROW()-4)/17)+1))","v":""},{"$f":"SUM(D4:D19)","v":0},{"$f":"IFERROR(AVERAGE(CHOOSE(MATCH(B20,汇总!$D$5:$M$5,0),汇总!$D$18:$D$10000,汇总!$E$18:$E$10000,汇总!$F$18:$F$10000,汇总!$G$18:$G$10000,汇总!$H$18:$H$10000,汇总!$I$18:$I$10000,汇总!$J$18:$J$10000,汇总!$K$18:$K$10000,汇总!$L$18:$L$10000,汇总!$M$18:$M$10000)),\"\")","v":""},null,{"$f":"IF(SUM(G4:G19)>0,SUM(G4:G19),\"\")","v":""},"",null,{"$f":"IFERROR(SUM(J4:J19),\"\")","v":0},""]

{"sheet":"分数段统计","index":6,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,0,27,2],[28,0,28,2],[26,19,28,19],[10,20,14,21],[3,20,3,21],[4,1,4,2],[5,1,5,2],[25,1,25,2],[26,0,26,2],[0,0,0,19],[1,3,1,5],[1,16,1,18],[2,0,2,2],[3,1,3,2]]}
[{"$f":"设置!E3&设置!J3&设置!E5&设置!J4&\"分段成绩统计\"","v":"天景初级中学2018年上期八年级期中考试分段成绩统计"}]
[null,null,null,{"$f":"\"时间：\"&设置!E4","v":"时间：2018.07.05"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"统计人：\"&设置!J5","v":"统计人：余红军"}]
[null,null,null,{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},{"$f":"TEXT(IF(INDEX(设置!$C$10:$C$25,COLUMN()-3)<>\"\",(COLUMN()-3)&\"班\",\"\"),\"00\")","v":""},"合计"]
[{"$f":"V7","v":680},"分以上",null,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A4,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},{"$f":"SUM(D4:S4)","v":0},"设置"]
[{"$f":"V8","v":510},"分以上",null,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A5,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},{"$f":"SUM(D5:S5)","v":0}]
[{"$f":"C7+1","v":720},"分以上",null,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A6,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},{"$f":"SUM(D6:S6)","v":0},"请输入本次考试总分：",850]
[700,null,{"$f":"A7+19","v":719},{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A7,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C7,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},{"$f":"SUM(D7:S7)","v":0},"总分优生线(＞＝80%）：",{"$f":"IF($V$6=\"\",\"\",$V$6*0.8)","v":680}]
[680,null,699,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A8,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C8,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0,"总分及格线(＞＝60%）：",{"$f":"IF($V$6=\"\",\"\",$V$6*0.6)","v":510}]
[660,null,679,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A9,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C9,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0,"总分学困线(＜＝40%）：",{"$f":"IF($V$6=\"\",\"\",$V$6*0.4)","v":340}]
[640,null,659,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A10,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C10,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[620,null,639,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A11,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C11,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0,"　　说明：1、在V6单元格中输入本次考试总分后点击保存按钮，即可更新数据。2、左表黄色区域分别为总分优生、及格、学困生统计数。"]
[600,null,619,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A12,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C12,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[580,null,599,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A13,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C13,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[560,null,579,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A14,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C14,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[540,null,559,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A15,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C15,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[520,null,539,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A16,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C16,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[500,null,519,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A17,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C17,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[480,null,499,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A18,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C18,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[460,null,479,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A19,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C19,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[440,null,459,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A20,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C20,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[420,null,439,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A21,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C21,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[400,null,419,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A22,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C22,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[380,null,399,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A23,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C23,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[360,null,379,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A24,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C24,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[{"$f":"A26","v":340},null,359,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\">=\"&$A25,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1)))-COUNTIFS(汇总!$N$18:$N$65536,\">\"&$C25,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
[{"$f":"V9","v":340},"分以下",null,{"$f":"IF(D$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(D$3,LEN(D$3)-1))),\"\")","v":""},{"$f":"IF(E$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(E$3,LEN(E$3)-1))),\"\")","v":""},{"$f":"IF(F$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(F$3,LEN(F$3)-1))),\"\")","v":""},{"$f":"IF(G$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(G$3,LEN(G$3)-1))),\"\")","v":""},{"$f":"IF(H$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(H$3,LEN(H$3)-1))),\"\")","v":""},{"$f":"IF(I$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(I$3,LEN(I$3)-1))),\"\")","v":""},{"$f":"IF(J$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(J$3,LEN(J$3)-1))),\"\")","v":""},{"$f":"IF(K$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(K$3,LEN(K$3)-1))),\"\")","v":""},{"$f":"IF(L$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(L$3,LEN(L$3)-1))),\"\")","v":""},{"$f":"IF(M$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(M$3,LEN(M$3)-1))),\"\")","v":""},{"$f":"IF(N$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(N$3,LEN(N$3)-1))),\"\")","v":""},{"$f":"IF(O$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(O$3,LEN(O$3)-1))),\"\")","v":""},{"$f":"IF(P$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(P$3,LEN(P$3)-1))),\"\")","v":""},{"$f":"IF(Q$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(Q$3,LEN(Q$3)-1))),\"\")","v":""},{"$f":"IF(R$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(R$3,LEN(R$3)-1))),\"\")","v":""},{"$f":"IF(S$3<>\"\",COUNTIFS(汇总!$N$18:$N$65536,\"<\"&$A26,汇总!$A$18:$A$65536,VALUE(LEFT(S$3,LEN(S$3)-1))),\"\")","v":""},0]
["参考人数",null,null,{"$f":"IF(D3<>\"\",SUM(D6:D26),\"\")","v":""},{"$f":"IF(E3<>\"\",SUM(E6:E26),\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"SUM(D6:S26)","v":0}]
["最高分",null,null,{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(D$3,LEN(D$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(E$3,LEN(E$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(F$3,LEN(F$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(G$3,LEN(G$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(H$3,LEN(H$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(I$3,LEN(I$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(J$3,LEN(J$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(K$3,LEN(K$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(L$3,LEN(L$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(M$3,LEN(M$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(N$3,LEN(N$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(O$3,LEN(O$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(P$3,LEN(P$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(Q$3,LEN(Q$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(R$3,LEN(R$3)-1)))),\"\")","v":""},{"$f":"IFERROR(MAX((汇总!$N$18:$N$65536)*((汇总!$A$18:$A$65536)=INT(LEFT(S$3,LEN(S$3)-1)))),\"\")","v":""}]
["最低分",null,null,{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(D$3,LEN(D$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(E$3,LEN(E$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(F$3,LEN(F$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(G$3,LEN(G$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(H$3,LEN(H$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(I$3,LEN(I$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(J$3,LEN(J$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(K$3,LEN(K$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(L$3,LEN(L$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(M$3,LEN(M$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(N$3,LEN(N$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(O$3,LEN(O$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(P$3,LEN(P$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(Q$3,LEN(Q$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(R$3,LEN(R$3)-1))),2),\"\")","v":""},{"$f":"IFERROR(SMALL((汇总!$N$18:$N$65536)*(汇总!$N$18:$N$65536>0)*((汇总!$A$18:$A$65536)=INT(LEFT(S$3,LEN(S$3)-1))),2),\"\")","v":""}]

{"sheet":"分班成绩模板","index":7,"n_rows":107,"n_cols":16,"rows_kept":107,"cut":false,"hidden":true,"merged":[[7,1,15,1],[5,13,6,13],[4,14,5,14],[4,15,5,15],[0,0,1,15],[2,7,3,8],[7,13,15,15],[2,2,2,3],[2,10,2,13],[3,11,3,14],[5,1,5,2],[6,1,6,2],[2,1,3,1]]}
[{"$f":"设置!E3&设置!J3&设置!E5&RIGHT(CELL(\"filename\"),2)&\"班\"&设置!J4&\"成绩统计\"","v":"天景初级中学2018年上期八年级模板班期中考试成绩统计"}]
[]
[null,null,{"$f":"\"班主任：\"&IF(D9=\"\",\"模板\",INDEX(设置!$C$10:$C$25,VALUE(RIGHT(CELL(\"filename\",A1),2))))","v":"班主任：模板"},null,null,null,null,null,null,null,{"$f":"\"日期：\"&设置!E4","v":"日期：2018.07.05"}]
[]
["班级","姓  名","学号",{"$f":"IF(设置!D7=\"\",\"\",设置!D7)","v":"语文"},{"$f":"IF(设置!E7=\"\",\"\",设置!E7)","v":"数学"},{"$f":"IF(设置!F7=\"\",\"\",设置!F7)","v":"英语"},{"$f":"IF(设置!G7=\"\",\"\",设置!G7)","v":"物理"},{"$f":"IF(设置!H7=\"\",\"\",设置!H7)","v":"化学"},{"$f":"IF(设置!I7=\"\",\"\",设置!I7)","v":"生物"},{"$f":"IF(设置!J7=\"\",\"\",设置!J7)","v":"历史"},{"$f":"IF(设置!K7=\"\",\"\",设置!K7)","v":"思品"},{"$f":"IF(设置!L7=\"\",\"\",设置!L7)","v":"地理"},{"$f":"IF(设置!M7=\"\",\"\",设置!M7)","v":"体育"},"总分","年级\n名次","班级\n名次"]
[null,"该   科  总  分",null,{"$f":"IF(设置!D8=\"\",\"\",设置!D8)","v":150},{"$f":"IF(设置!E8=\"\",\"\",设置!E8)","v":150},{"$f":"IF(设置!F8=\"\",\"\",设置!F8)","v":150},{"$f":"IF(设置!G8=\"\",\"\",设置!G8)","v":80},{"$f":"IF(设置!H8=\"\",\"\",设置!H8)","v":70},{"$f":"IF(设置!I8=\"\",\"\",设置!I8)","v":25},{"$f":"IF(设置!J8=\"\",\"\",设置!J8)","v":100},{"$f":"IF(设置!K8=\"\",\"\",设置!K8)","v":100},{"$f":"IF(设置!L8=\"\",\"\",设置!L8)","v":100},{"$f":"IF(设置!M8=\"\",\"\",设置!M8)","v":50}]
[null,"总分中该科折算率",null,{"$f":"IF(设置!D9=\"\",\"\",设置!D9)","v":1},{"$f":"IF(设置!E9=\"\",\"\",设置!E9)","v":1},{"$f":"IF(设置!F9=\"\",\"\",设置!F9)","v":1},{"$f":"IF(设置!G9=\"\",\"\",设置!G9)","v":1},{"$f":"IF(设置!H9=\"\",\"\",设置!H9)","v":1},{"$f":"IF(设置!I9=\"\",\"\",设置!I9)","v":1},{"$f":"IF(设置!J9=\"\",\"\",设置!J9)","v":1},{"$f":"IF(设置!K9=\"\",\"\",设置!K9)","v":1},{"$f":"IF(设置!L9=\"\",\"\",设置!L9)","v":1},{"$f":"IF(设置!M9=\"\",\"\",设置!M9)","v":1}]
[null,"数据分析","任课教师",{"$f":"IF(D9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",A1),2)),MATCH(D5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(E9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",B1),2)),MATCH(E5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(F9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",C1),2)),MATCH(F5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(G9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",D1),2)),MATCH(G5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(H9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",E1),2)),MATCH(H5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(I9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",F1),2)),MATCH(I5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(J9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",G1),2)),MATCH(J5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(K9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",H1),2)),MATCH(K5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(L9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",I1),2)),MATCH(L5,设置!$C$7:$M$7,0)))","v":""},{"$f":"IF(M9=\"\",\"\",INDEX(设置!$C$10:$M$25,VALUE(RIGHT(CELL(\"filename\",J1),2)),MATCH(M5,设置!$C$7:$M$7,0)))","v":""},"数据分析"]
[null,null,"参考人数",{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",A1),2)),汇总!D$18:D$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",A1),2)),汇总!D$18:D$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",B1),2)),汇总!E$18:E$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",B1),2)),汇总!E$18:E$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",C1),2)),汇总!F$18:F$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",C1),2)),汇总!F$18:F$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",D1),2)),汇总!G$18:G$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",D1),2)),汇总!G$18:G$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",E1),2)),汇总!H$18:H$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",E1),2)),汇总!H$18:H$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",F1),2)),汇总!I$18:I$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",F1),2)),汇总!I$18:I$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",G1),2)),汇总!J$18:J$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",G1),2)),汇总!J$18:J$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",H1),2)),汇总!K$18:K$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",H1),2)),汇总!K$18:K$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",I1),2)),汇总!L$18:L$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",I1),2)),汇总!L$18:L$10000,\">=0\"))","v":""},{"$f":"IF(COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",J1),2)),汇总!M$18:M$10000,\">=0\")=0,\"\",COUNTIFS(汇总!$A$18:$A$10000,VALUE(RIGHT(CELL(\"filename\",J1),2)),汇总!M$18:M$10000,\">=0\"))","v":""}]
[null,null,"最低分",{"$f":"IF(D$18=\"\",\"\",MIN(D18:D$65536))","v":""},{"$f":"IF(E$18=\"\",\"\",MIN(E18:E$65536))","v":""},{"$f":"IF(F$18=\"\",\"\",MIN(F18:F$65536))","v":""},{"$f":"IF(G$18=\"\",\"\",MIN(G18:G$65536))","v":""},{"$f":"IF(H$18=\"\",\"\",MIN(H18:H$65536))","v":""},{"$f":"IF(I$18=\"\",\"\",MIN(I18:I$65536))","v":""},{"$f":"IF(J$18=\"\",\"\",MIN(J18:J$65536))","v":""},{"$f":"IF(K$18=\"\",\"\",MIN(K18:K$65536))","v":""},{"$f":"IF(L$18=\"\",\"\",MIN(L18:L$65536))","v":""},{"$f":"IF(M$18=\"\",\"\",MIN(M18:M$65536))","v":""}]
[null,null,"最高分",{"$f":"IF(D$18=\"\",\"\",MAX(D18:D$65536))","v":""},{"$f":"IF(E$18=\"\",\"\",MAX(E18:E$65536))","v":""},{"$f":"IF(F$18=\"\",\"\",MAX(F18:F$65536))","v":""},{"$f":"IF(G$18=\"\",\"\",MAX(G18:G$65536))","v":""},{"$f":"IF(H$18=\"\",\"\",MAX(H18:H$65536))","v":""},{"$f":"IF(I$18=\"\",\"\",MAX(I18:I$65536))","v":""},{"$f":"IF(J$18=\"\",\"\",MAX(J18:J$65536))","v":""},{"$f":"IF(K$18=\"\",\"\",MAX(K18:K$65536))","v":""},{"$f":"IF(L$18=\"\",\"\",MAX(L18:L$65536))","v":""},{"$f":"IF(M$18=\"\",\"\",MAX(M18:M$65536))","v":""}]
[null,null,"平均分",{"$f":"IF(D9=\"\",\"\",SUM(D18:D$65536)/D9)","v":""},{"$f":"IF(E9=\"\",\"\",SUM(E18:E$65536)/E9)","v":""},{"$f":"IF(F9=\"\",\"\",SUM(F18:F$65536)/F9)","v":""},{"$f":"IF(G9=\"\",\"\",SUM(G18:G$65536)/G9)","v":""},{"$f":"IF(H9=\"\",\"\",SUM(H18:H$65536)/H9)","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I18:I$65536)/I9)","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J18:J$65536)/J9)","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K18:K$65536)/K9)","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L18:L$65536)/L9)","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M18:M$65536)/M9)","v":""}]
[null,null,"优生人数",{"$f":"IF(D18=\"\",\"\",COUNTIF(D18:D$65536,\">=\"&设置!D27))","v":""},{"$f":"IF(E18=\"\",\"\",COUNTIF(E18:E$65536,\">=\"&设置!E27))","v":""},{"$f":"IF(F18=\"\",\"\",COUNTIF(F18:F$65536,\">=\"&设置!F27))","v":""},{"$f":"IF(G18=\"\",\"\",COUNTIF(G18:G$65536,\">=\"&设置!G27))","v":""},{"$f":"IF(H18=\"\",\"\",COUNTIF(H18:H$65536,\">=\"&设置!H27))","v":""},{"$f":"IF(I18=\"\",\"\",COUNTIF(I18:I$65536,\">=\"&设置!I27))","v":""},{"$f":"IF(J18=\"\",\"\",COUNTIF(J18:J$65536,\">=\"&设置!J27))","v":""},{"$f":"IF(K18=\"\",\"\",COUNTIF(K18:K$65536,\">=\"&设置!K27))","v":""},{"$f":"IF(L18=\"\",\"\",COUNTIF(L18:L$65536,\">=\"&设置!L27))","v":""},{"$f":"IF(M18=\"\",\"\",COUNTIF(M18:M$65536,\">=\"&设置!M27))","v":""}]
[null,null,"优生率",{"$f":"IF(D9=\"\",\"\",(D13/D9))","v":""},"","","","","","","","",""]
[null,null,"及格人数",{"$f":"IF(D18=\"\",\"\",COUNTIF(D18:D65536,\">=\"&设置!D28))","v":""},{"$f":"IF(E18=\"\",\"\",COUNTIF(E18:E65536,\">=\"&设置!E28))","v":""},{"$f":"IF(F18=\"\",\"\",COUNTIF(F18:F65536,\">=\"&设置!F28))","v":""},{"$f":"IF(G18=\"\",\"\",COUNTIF(G18:G65536,\">=\"&设置!G28))","v":""},{"$f":"IF(H18=\"\",\"\",COUNTIF(H18:H65536,\">=\"&设置!H28))","v":""},{"$f":"IF(I18=\"\",\"\",COUNTIF(I18:I65536,\">=\"&设置!I28))","v":""},{"$f":"IF(J18=\"\",\"\",COUNTIF(J18:J65536,\">=\"&设置!J28))","v":""},{"$f":"IF(K18=\"\",\"\",COUNTIF(K18:K65536,\">=\"&设置!K28))","v":""},{"$f":"IF(L18=\"\",\"\",COUNTIF(L18:L65536,\">=\"&设置!L28))","v":""},{"$f":"IF(M18=\"\",\"\",COUNTIF(M18:M65536,\">=\"&设置!M28))","v":""}]
[null,null,"及格率",{"$f":"IF(D9=\"\",\"\",(D15/D9))","v":""},"","","","","","","","",""]
[]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(RANK(N18,$N$18:$N$100),\"\")","v":""}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(RANK(N19,$N$18:$N$100),\"\")","v":""}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(RANK(N51,$N$18:$N$100),\"\")","v":""}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(RANK(N83,$N$18:$N$100),\"\")","v":""}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]