{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["数据源","个人信息查询"],"read":"whole","date_system":"1900"}

{"sheet":"数据源","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"hidden":true}
["面试成绩","身份证号","姓名","报考岗位","综合成绩","综合排名","笔试成绩"]
[89.8,"513021199210023450","聂川","体育管理",{"$f":"G2*0.6+A2*0.4","v":80.32},1,74]
[79.4,"511722200310198221","余澄龙","体育管理",{"$f":"G3*0.6+A3*0.4","v":73.16},2,69]
[69.2,"612326199906206037","向彬","体育管理",{"$f":"G4*0.6+A4*0.4","v":70.28},3,71]
[]
[]
[83.8,"511702200110280022","方琪","党建管理",{"$f":"G7*0.6+A7*0.4","v":75.52},2,70]
[92.1,"500381200208236725","袁露芸","党建管理",{"$f":"G8*0.6+A8*0.4","v":84.84},1,80]
[77.4,"511722200106056058","袁诗堪","党建管理",{"$f":"G9*0.6+A9*0.4","v":74.76},3,73]
[]
[79.6,"513022199708044992","吴港","网络管理",{"$f":"G11*0.6+A11*0.4","v":73.84},2,70]
[69.9,"513022199809103031","陈卓","网络管理",{"$f":"G12*0.6+A12*0.4","v":68.76},3,68]
[91.6,"51172220040107737X","王淼","网络管理",{"$f":"G13*0.6+A13*0.4","v":86.44},1,83]
[]
[]
[91.4,"511702200007270213","刘洋成","广告设计",{"$f":"G16*0.6+A16*0.4","v":86.96},2,84]
[91,"513022199504020040","于晓凤","广告设计",{"$f":"G17*0.6+A17*0.4","v":89.8},1,89]
[86.6,"511702200210272820","杜雨薇","广告设计",{"$f":"G18*0.6+A18*0.4","v":83.84},3,82]
[]
[91.4,"513001199508211045","高茂连","会计",{"$f":"G20*0.6+A20*0.4","v":86.96},1,84]
[75.4,"51302219951113728X","胡青婷","会计",{"$f":"G21*0.6+A21*0.4","v":69.76},3,66]
[77.8,"511923200012227634","向俊杰","会计",{"$f":"G22*0.6+A22*0.4","v":70.12},2,65]
[69.4,"511923199810093989","罗琪","会计",{"$f":"G23*0.6+A23*0.4","v":66.76},4,65]
[]
["迟到放弃","511724200207291017","廖托尼","物流管理",44.4,4,74]
[82,"513021199711060778","许贵杨","物流管理",{"$f":"G26*0.6+A26*0.4","v":77.2},2,74]
["确认放弃","513022199804250403","刘丽","物流管理",45.3,3,75.5]
[89.8,"511724200107106099","张煜","物流管理",{"$f":"G28*0.6+A28*0.4","v":89.32},1,89]

{"sheet":"个人信息查询","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[0,0,0,4],[4,2,7,3]]}
["达州市文化旅游投资有限公司2025年度公开招聘工作人员笔试成绩查询"]
[]
["请输入身份证号："]
[]
["姓名：",{"$f":"IFERROR(VLOOKUP(B3,数据源!$B:$F,2,FALSE),\"\")","v":""},"输入正确的身份证号码后自动显示"]
["报考岗位：",{"$f":"IFERROR(VLOOKUP(B3,数据源!$B:$F,3,FALSE),\"\")","v":""}]
["综合成绩：",{"$f":"IFERROR(VLOOKUP(B3,数据源!$B:$F,4,FALSE),\"\")","v":""}]
["综合排名：",{"$f":"IFERROR(VLOOKUP(B3,数据源!$B:$F,5,FALSE),\"\")","v":""}]
[]
["提示：请输入正确的18位身份证号码查看"]