{"text_format":"3","workbook":"xlsx","n_sheets":36,"sheets":["Sheet2","20-4","20-5","20-6","20-7","20-8","20-9","20-10","2020-11","2020-12","2021-01","2021-02","2021-03","2021-04","2021-05","2021-06","2021-07","2021-08","2021-09","2021-10","2021-11","2021-12","2022-01","2022-02","2022-03","2022-04","2022-05","2022-06","2022-07","2022-08","2022-09","2022-10","2022-11","2022-12","2023-01","2023-02"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet2","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[0,1,0,6]]}
[null,"典 诚  员  工 "]
["序号","姓名","计时工","电杆工资","带班","实发工资","电话号码"]
[1,"余新宇",{"$nulls":3},4500,13789319688]
[2,"刘国英",{"$nulls":3},6500,15987516999]
[3,"余布江",{"$nulls":3},5800,13574063666]
[4,"谢慧",{"$nulls":3},1800,15273263555]
[5,"余典",{"$nulls":3},5000,13975220666]
[6,"郭坚",null,5200,null,5200,18173212287]
[7,"彭军民",{"$nulls":3},5000,18975272968]
[8,"田福珍",{"$nulls":3},3200,13973263650]
[9,"柳习军",300,5377,null,5677,15073203762]
[10,"李新建",{"$nulls":3},5480,13467913657]

{"sheet":"20-4","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.04"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"刘国英",3500,{"$nulls":4},{"$f":"C5","v":3500}]
[2,"彭中达",2800,{"$nulls":4},2800]
[3,"许德芝",3020,{"$nulls":4},3020]
[4,"黄富军",3020,{"$nulls":4},3020]
[5,"严正良",3020,{"$nulls":4},3020]
[6,"严正明",3020,{"$nulls":4},3020]
[7,"邓达清",3020,{"$nulls":4},3020]
[]
[]
[]
[]
[]
[]
[null,"合计",{"$f":"SUM(C5:C16)","v":21400},{"$nulls":4},{"$f":"SUM(H5:H16)","v":21400}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"20-5","index":2,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.05"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"刘国英",3500,{"$nulls":4},{"$f":"C5","v":3500}]
[2,{"$nulls":6},0]
[3,{"$nulls":6},0]
[4,{"$nulls":6},0]
[5,{"$nulls":6},0]
[6,{"$nulls":6},0]
[7,{"$nulls":6},0]
[]
[]
[]
[]
[]
[]
[null,"合计",{"$f":"SUM(C5:C16)","v":3500},{"$nulls":4},{"$f":"SUM(H5:H16)","v":3500}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"20-6","index":3,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.06"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"刘国英",3500,{"$nulls":4},{"$f":"C5","v":3500}]
[2,{"$nulls":6},0]
[3,{"$nulls":6},0]
[4,{"$nulls":6},0]
[5,{"$nulls":6},0]
[6,{"$nulls":6},0]
[7,{"$nulls":6},0]
[]
[]
[]
[]
[]
[]
[null,"合计",{"$f":"SUM(C5:C16)","v":3500},{"$nulls":4},{"$f":"SUM(H5:H16)","v":3500}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"20-7","index":4,"n_rows":23,"n_cols":14,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.07"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500]
[3,"余布江",4200,{"$nulls":4},4200]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",46,115,{"$f":"L8*M8","v":5290}]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",37,40,1480]
[6,"郭坚",3616.5,{"$nulls":4},3616.5,null,null,"190*10",52,52,2704]
[7,"彭军民",3616.5,{"$nulls":4},3616.5,null,null,"190*12",62,62,3844]
[8,"柳习军",3616.5,{"$nulls":4},3616.5,null,"接","190*12",9,82,738]
[9,"李新建",3616.5,{"$nulls":4},3616.5,null,null,"230*12",5,82,410]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":14466}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":3616.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":33666},{"$nulls":4},{"$f":"SUM(H5:H17)","v":33666}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"20-8","index":5,"n_rows":23,"n_cols":14,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.08"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500]
[3,"余布江",4200,{"$nulls":4},4200]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875}]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640]
[6,"郭坚",2752,{"$nulls":4},2752,null,null,"190*10",72,52,3744]
[7,"彭军民",2752,{"$nulls":4},2752,null,null,"190*12",15,62,930]
[8,"柳习军",2752,{"$nulls":4},2752,null,"接","190*12",5,82,410]
[9,"李新建",2752,{"$nulls":4},2752,null,null,"230*12",5,82,410]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":30208},{"$nulls":4},{"$f":"SUM(H5:H17)","v":30208}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"20-9","index":6,"n_rows":23,"n_cols":21,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.09"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500]
[3,"余布江",4200,{"$nulls":4},4200]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300}]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400]
[6,"郭坚",4033.5,{"$nulls":4},4033.5,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980]
[7,"彭军民",4033.5,{"$nulls":4},4033.5,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650]
[8,"汤新河",4033.5,{"$nulls":4},4033.5,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820]
[9,"李新建",4033.5,{"$nulls":4},4033.5,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":35334},{"$nulls":4},{"$f":"SUM(H5:H17)","v":35334}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"20-10","index":7,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.10"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500]
[3,"余布江",4200,{"$nulls":4},4200,{"$nulls":16},"数量","单价","金额"]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150-7",468,28,{"$f":"Y8*Z8","v":13104}]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"150-8",185,33,{"$f":"Y9*Z9","v":6105}]
[6,"郭坚",{"v":4802.3,"d":"4802"},{"$nulls":4},{"v":4802.3,"d":"4802"},null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,{"$nulls":5},{"$f":"SUM(AA8:AA9)","v":19209}]
[7,"彭军民",{"v":4802.3,"d":"4802"},{"$nulls":4},{"v":4802.3,"d":"4802"},null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,{"$nulls":5},4]
[8,"汤新河",{"v":4802.3,"d":"4802"},{"$nulls":4},{"v":4802.3,"d":"4802"},null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,{"$nulls":5},{"$f":"AA10/AA11","v":4802.25}]
[9,"李新建",{"v":4802.3,"d":"4802"},{"$nulls":4},{"v":4802.3,"d":"4802"},null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",38408,{"$nulls":4},38408]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2020-11","index":8,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.11"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500]
[3,"余布江",4200,{"$nulls":4},4200,{"$nulls":16},"数量","单价","金额"]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"190*10",118,52,{"$f":"Y8*Z8","v":6136}]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*12",132,82,{"$f":"Y9*Z9","v":10824}]
[6,"郭坚",4240,{"$nulls":4},4240,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,{"$nulls":5},{"$f":"SUM(AA8:AA9)","v":16960}]
[7,"彭军民",4240,{"$nulls":4},4240,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,{"$nulls":5},4]
[8,"汤新河",4240,{"$nulls":4},4240,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,{"$nulls":5},{"$f":"AA10/AA11","v":4240}]
[9,"李新建",4240,{"$nulls":4},4240,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":36160},{"$nulls":4},{"$f":"SUM(H5:H17)","v":36160}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2020-12","index":9,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2020.12"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500]
[3,"余布江",4200,{"$nulls":4},4200,{"$nulls":16},"数量","单价","金额"]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"190*10",118,122,{"$f":"Y8*Z8","v":14396}]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*12",0,82,{"$f":"Y9*Z9","v":0}]
[6,"郭坚",3599,{"$nulls":4},3599,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,{"$nulls":5},{"$f":"SUM(AA8:AA9)","v":14396}]
[7,"彭军民",3599,{"$nulls":4},3599,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,{"$nulls":5},4]
[8,"汤新河",3599,{"$nulls":4},3599,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,{"$nulls":5},{"$f":"AA10/AA11","v":3599}]
[9,"李新建",3599,{"$nulls":4},3599,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":33596},{"$nulls":4},{"$f":"SUM(H5:H17)","v":33596}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-01","index":10,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.1"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"余布江",4200,{"$nulls":4},4200,{"$nulls":15},"150*8",240,33,{"$f":"Y7*Z7","v":7920}]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"190*10",82,122,{"$f":"Y8*Z8","v":10004}]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*12",0,82,{"$f":"Y9*Z9","v":0}]
[6,"郭坚",4480,{"$nulls":4},4480,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,{"$nulls":5},{"$f":"SUM(AA7:AA9)","v":17924}]
[7,"彭军民",4480,{"$nulls":4},4480,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,{"$nulls":5},4]
[8,"汤新河",4480,{"$nulls":4},4480,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,{"$nulls":5},{"$f":"AA10/AA11","v":4481}]
[9,"李新建",4480,{"$nulls":4},4480,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":37120},{"$nulls":4},{"$f":"SUM(H5:H17)","v":37120}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-02","index":11,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.2"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"余布江",4200,{"$nulls":4},4200,{"$nulls":15},"190*15",46,115,{"$f":"Y7*Z7","v":5290}]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",37,40,1480]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",52,52,2704]
[6,"郭坚",4354,{"$nulls":4},4354,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",62,62,3844]
[7,"彭军民",4354,{"$nulls":4},4354,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",45,82,3690]
[8,"汤新河",4354,{"$nulls":4},4354,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",5,82,410]
[9,"李新建",4354,{"$nulls":4},4354,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,{"$nulls":5},{"$f":"SUM(AA7:AA12)","v":17418}]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},{"$nulls":3},4,null,{"$f":"AA13/Y14","v":4354.5}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":36616},{"$nulls":4},{"$f":"SUM(H5:H17)","v":36616}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-03","index":12,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.3"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"余布江",4200,{"$nulls":4},4200,{"$nulls":15},"190*15",{"$f":"1+2+1+8+28","v":40},115,{"$f":"Y7*Z7","v":4600}]
[4,"谢慧",1800,{"$nulls":4},1800,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",{"$f":"16+3+11","v":30},40,1200]
[5,"余典",4200,{"$nulls":4},4200,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",{"$f":"2+9","v":11},52,572]
[6,"郭坚",4166,{"$nulls":4},4166,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",{"$f":"12+18+14+10+40","v":94},62,5828]
[7,"彭军民",4166,{"$nulls":4},4166,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",{"$f":"47","v":47},82,3854]
[8,"汤新河",4166,{"$nulls":4},4166,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",5,82,410]
[9,"李新建",4166,{"$nulls":4},4166,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,{"$nulls":5},{"$f":"SUM(AA7:AA12)","v":16464}]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},{"$nulls":3},4,null,{"$f":"AA13/Y14","v":4116}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":35864},{"$nulls":4},{"$f":"SUM(H5:H17)","v":35864}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-04","index":13,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.4"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},{"$f":"C6","v":4500},{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},{"$f":"C7","v":1800},{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",20,40,800]
[5,"郭坚",4405,{"$nulls":4},4405,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",250,52,13000]
[6,"彭军民",4405,{"$nulls":4},4405,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",14,62,868]
[7,"汤新河",4405,{"$nulls":4},4405,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",17,82,1394]
[8,"李新建",4405,{"$nulls":4},4405,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",5,82,410]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,{"$nulls":5},{"$f":"SUM(AA7:AA12)","v":17622}]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},{"$nulls":3},4,null,{"$f":"AA13/Y14","v":4405.5}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":32620},{"$nulls":4},{"$f":"SUM(H5:H17)","v":32620}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-05","index":14,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.5"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",30,115,{"$f":"Y7*Z7","v":3450}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",10,40,400]
[5,"郭坚",4890,{"$nulls":4},4890,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",120,52,6240]
[6,"彭军民",4890,{"$nulls":4},4890,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",80,62,4960]
[7,"汤新河",4890,{"$nulls":4},4890,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",30,82,2460]
[8,"李新建",4890,{"$nulls":4},4890,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",25,82,2050]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,{"$nulls":5},{"$f":"SUM(AA7:AA12)","v":19560}]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},{"$nulls":3},4,null,{"$f":"AA13/Y14","v":4890}]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5}]
[]
[]
[null,"合计",{"$f":"SUM(C5:C17)","v":34560},{"$nulls":4},{"$f":"SUM(H5:H17)","v":34560}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-06","index":15,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.6"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",{"$f":"80","v":80},115,{"$f":"Y7*Z7","v":9200}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",{"$f":"12","v":12},40,{"$f":"Y8*Z8","v":480}]
[5,"郭坚",4940,{"$nulls":4},4940,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",{"$f":"72","v":72},52,3744]
[6,"彭军民",4940,{"$nulls":4},4940,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",{"$f":"20+27","v":47},62,2914]
[7,"汤新河",4940,{"$nulls":4},4940,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",30,82,2460]
[8,"李新建",4940,{"$nulls":4},4940,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",{"$f":"1","v":1},82,82]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",{"$f":"1+1","v":2},115,230]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",{"$f":"1","v":1},135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",{"$f":"4","v":4},130,520]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":19765}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":34760},{"$nulls":4},{"$f":"SUM(H5:H17)","v":34760},{"$nulls":18},{"$f":"AA16/AA17","v":4941.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-07","index":16,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.7"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",null,115,{"$f":"Y7*Z7","v":0}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",593,40,23720]
[5,"郭坚",5130,{"$nulls":4},5130,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",null,52,0]
[6,"彭军民",5130,{"$nulls":4},5130,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",null,62,0]
[7,"汤新河",5130,{"$nulls":4},5130,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[8,"李新建",5130,{"$nulls":4},5130,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",null,115,0]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",null,130,0]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":23720}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":35520},{"$nulls":4},{"$f":"SUM(H5:H17)","v":35520},{"$nulls":18},{"$f":"AA16/AA17","v":5930}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-08","index":17,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.8"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",null,115,{"$f":"Y7*Z7","v":0}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",293,40,11720]
[5,"郭坚",4903,{"$nulls":4},4903,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",122,52,6344]
[6,"彭军民",4903,{"$nulls":4},4903,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",25,62,1550]
[7,"汤新河",4903,{"$nulls":4},4903,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[8,"李新建",4903,{"$nulls":4},4903,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",null,115,0]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",null,130,0]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":19614}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":34612},{"$nulls":4},{"$f":"SUM(H5:H17)","v":34612},{"$nulls":18},{"$f":"AA16/AA17","v":4903.5}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-09","index":18,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.9"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",null,115,{"$f":"Y7*Z7","v":0}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",{"$f":"212","v":212},40,8480]
[5,"郭坚",5230,{"$nulls":4},5230,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",{"$f":"216","v":216},52,11232]
[6,"彭军民",5230,{"$nulls":4},5230,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",{"$f":"84","v":84},62,5208]
[7,"汤新河",5230,{"$nulls":4},5230,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[8,"李新建",5230,{"$nulls":4},5230,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",null,115,0]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",null,130,0]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":24920}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":35920},{"$nulls":4},{"$f":"SUM(H5:H17)","v":35920},{"$nulls":18},{"$f":"AA16/AA17","v":6230}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-10","index":19,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.10"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",null,115,{"$f":"Y7*Z7","v":0}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",50,40,2000]
[5,"郭坚",4086,{"$nulls":4},4086,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",60,52,3120]
[6,"彭军民",4086,{"$nulls":4},4086,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",120,62,7440]
[7,"汤新河",4086,{"$nulls":4},4086,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[8,"李新建",4086,{"$nulls":4},4086,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",20,82,1640]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",5,115,575]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",2,135,270]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",10,130,1300]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":16345}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":31344},{"$nulls":4},{"$f":"SUM(H5:H17)","v":31344},{"$nulls":18},{"$f":"AA16/AA17","v":4086.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-11","index":20,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.11"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",null,115,{"$f":"Y7*Z7","v":0}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"郭坚",4618,{"$nulls":4},4618,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",90,52,4680]
[6,"彭军民",4618,{"$nulls":4},4618,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",115,62,7130]
[7,"汤新河",4618,{"$nulls":4},4618,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[8,"李新建",4618,{"$nulls":4},4618,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",28,115,3220]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",null,130,0]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":18470}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":33472},{"$nulls":4},{"$f":"SUM(H5:H17)","v":33472},{"$nulls":18},{"$f":"AA16/AA17","v":4617.5}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2021-12","index":21,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2021.12"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",8,115,{"$f":"Y7*Z7","v":920}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",null,40,0]
[5,"郭坚",4300,{"$nulls":4},4300,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",null,52,0]
[6,"汤新河",4300,{"$nulls":4},4300,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",196,62,12152]
[7,"李新建",4300,{"$nulls":4},4300,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[{"$nulls":9},"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",null,115,0]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":13202}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":27900},{"$nulls":4},{"$f":"SUM(H5:H17)","v":27900},{"$nulls":18},{"$f":"AA16/AA17","v":3300.5}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-01","index":22,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.01"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",8,115,{"$f":"Y7*Z7","v":920}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",null,40,0]
[5,"郭坚",4300,{"$nulls":4},4300,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",null,52,0]
[6,"汤新河",4300,{"$nulls":4},4300,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",196,62,12152]
[7,"李新建",4300,{"$nulls":4},4300,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[{"$nulls":9},"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",null,115,0]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":13202}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":27900},{"$nulls":4},{"$f":"SUM(H5:H17)","v":27900},{"$nulls":18},{"$f":"AA16/AA17","v":3300.5}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-02","index":23,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.02"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",8,115,{"$f":"Y7*Z7","v":920}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"郭坚",4160.5,{"$nulls":4},4160.5,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",null,52,0]
[6,"汤新河",4160.5,{"$nulls":4},4160.5,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",196,62,12152]
[7,"李新建",4160.5,{"$nulls":4},4160.5,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[{"$nulls":9},"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",null,115,0]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":16642}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":27481.5},{"$nulls":4},{"$f":"SUM(H5:H17)","v":27481.5},{"$nulls":18},{"$f":"AA16/AA17","v":4160.5}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-03","index":24,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.03"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"郭坚",4218,{"$nulls":4},4218,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,null,null,"190*10",null,52,0]
[6,"汤新河",4218,{"$nulls":4},4218,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,null,null,"190*12",196,62,12152]
[7,"李新建",4218,{"$nulls":4},4218,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,null,null,"190*12",null,82,0]
[{"$nulls":9},"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,null,null,"230*12",null,82,0]
[{"$nulls":10},"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,null,null,"230*15",null,115,0]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",null,135,0]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":16872}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":27654},{"$nulls":4},{"$f":"SUM(H5:H17)","v":27654},{"$nulls":18},{"$f":"AA16/AA17","v":4218}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-04","index":25,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.04"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",3045,{"$nulls":4},3045,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",3045,{"$nulls":4},3045,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",3045,{"$nulls":4},3045,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",3045,{"$nulls":4},3045,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",3045,{"$nulls":4},3045,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":30225},{"$nulls":4},{"$f":"SUM(H5:H17)","v":30225},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-05","index":26,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.05"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",4370,{"$nulls":4},4370,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",4370,{"$nulls":4},4370,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",4370,{"$nulls":4},4370,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",4370,{"$nulls":4},4370,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",4370,{"$nulls":4},4370,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":36850},{"$nulls":4},{"$f":"SUM(H5:H17)","v":36850},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-06","index":27,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.06"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,115,{"$f":"L8*M8","v":2875},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",3580,{"$nulls":4},3580,null,null,"150*8",66,40,2640,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",3580,{"$nulls":4},3580,null,null,"190*10",72,52,3744,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",3580,{"$nulls":4},3580,null,null,"190*12",15,62,930,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",3580,{"$nulls":4},3580,null,"接","190*12",5,82,410,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",3580,{"$nulls":4},3580,null,null,"230*12",5,82,410,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11009},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2752.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":32900},{"$nulls":4},{"$f":"SUM(H5:H17)","v":32900},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-07","index":28,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.07"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,50,{"$f":"L8*M8","v":1250},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",4240,{"$nulls":4},4240,null,null,"150*8",66,180,11880,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",4240,{"$nulls":4},4240,null,null,"190*10",72,100,7200,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",4240,{"$nulls":4},4240,null,null,"190*12",15,30,450,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",4240,{"$nulls":4},4240,null,"接","190*12",5,25,125,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",4240,{"$nulls":4},4240,null,null,"230*12",5,12,60,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":20965},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":5241.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":36200},{"$nulls":4},{"$f":"SUM(H5:H17)","v":36200},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-08","index":29,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.08"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,50,{"$f":"L8*M8","v":1250},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",4521,{"$nulls":4},4521,null,null,"150*8",50,180,9000,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",4521,{"$nulls":4},4521,null,null,"190*10",72,100,7200,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",4521,{"$nulls":4},4521,null,null,"190*12",15,30,450,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",4521,{"$nulls":4},4521,null,"接","190*12",5,25,125,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",4521,{"$nulls":4},4521,null,null,"230*12",5,12,60,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":18085},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":4521.25},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":37605},{"$nulls":4},{"$f":"SUM(H5:H17)","v":37605},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-09","index":30,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.09"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,50,{"$f":"L8*M8","v":1250},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",4883,{"$nulls":4},4883,null,null,"150*8",50,180,9000,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",4883,{"$nulls":4},4883,null,null,"190*10",85,100,8500,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",4883,{"$nulls":4},4883,null,null,"190*12",20,30,600,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",4883,{"$nulls":4},4883,null,"接","190*12",5,25,125,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",4883,{"$nulls":4},4883,null,null,"230*12",5,12,60,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":19535},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":4883.75},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":39415},{"$nulls":4},{"$f":"SUM(H5:H17)","v":39415},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-10","index":31,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.10"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",25,50,{"$f":"L8*M8","v":1250},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",3520,{"$nulls":4},3520,null,null,"150*8",50,180,9000,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",3520,{"$nulls":4},3520,null,null,"190*10",85,100,8500,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",3520,{"$nulls":4},3520,null,null,"190*12",20,30,600,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",3520,{"$nulls":4},3520,null,"接","190*12",5,25,125,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",3520,{"$nulls":4},3520,null,null,"230*12",5,12,60,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":19535},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":4883.75},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":32600},{"$nulls":4},{"$f":"SUM(H5:H17)","v":32600},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-11","index":32,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.11"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",5,50,{"$f":"L8*M8","v":250},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",2930,{"$nulls":4},2930,null,null,"150*8",50,180,9000,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",2930,{"$nulls":4},2930,null,null,"190*10",20,100,2000,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",2930,{"$nulls":4},2930,null,null,"190*12",10,30,300,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",2930,{"$nulls":4},2930,null,"接","190*12",5,25,125,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",2930,{"$nulls":4},2930,null,null,"230*12",5,12,60,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":11735},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2933.75},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":29650},{"$nulls":4},{"$f":"SUM(H5:H17)","v":29650},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2022-12","index":33,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2022.12"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",10,50,{"$f":"L8*M8","v":500},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",2511,{"$nulls":4},2511,null,null,"150*8",30,180,5400,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",2511,{"$nulls":4},2511,null,null,"190*10",22,100,2200,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",2511,{"$nulls":4},2511,null,null,"190*12",50,30,1500,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",2511,{"$nulls":4},2511,null,"接","190*12",15,25,375,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",2511,{"$nulls":4},2511,null,null,"230*12",6,12,72,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":10047},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2511.75},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":27555},{"$nulls":4},{"$f":"SUM(H5:H17)","v":27555},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2023-01","index":34,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2023.01"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",10,50,{"$f":"L8*M8","v":500},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",1110,{"$nulls":4},1110,null,null,"150*8",30,180,5400,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",1110,{"$nulls":4},1110,null,null,"190*10",22,100,2200,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",1110,{"$nulls":4},1110,null,null,"190*12",50,30,1500,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",1110,{"$nulls":4},1110,null,"接","190*12",15,25,375,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",1110,{"$nulls":4},1110,null,null,"230*12",6,12,72,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":10047},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2511.75},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":20550},{"$nulls":4},{"$f":"SUM(H5:H17)","v":20550},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]

{"sheet":"2023-02","index":35,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["工资表"]
["单位：湘潭典诚",{"$nulls":6},"月份：2023.02"]
["序号","姓名","基本工资","应扣工资",null,null,"加班补助","实发工资","备注"]
[{"$nulls":3},"缺勤","事假","病假"]
[1,"余新宇",4500,{"$nulls":4},{"$f":"C5","v":4500}]
[2,"刘国英",4500,{"$nulls":4},4500,{"$nulls":16},"数量","单价","金额"]
[3,"谢慧",1800,{"$nulls":4},1800,{"$nulls":15},"190*15",10,115,{"$f":"Y7*Z7","v":1150}]
[4,"余典",4200,{"$nulls":4},4200,null,null,"190*15",10,50,{"$f":"L8*M8","v":500},{"$nulls":3},"190*15",20,115,{"$f":"S8*T8","v":2300},null,null,"150*8",86,40,3440]
[5,"刘松林",3058,{"$nulls":4},3058,null,null,"150*8",30,180,5400,{"$nulls":3},"150*8",35,40,1400,"430321196110221513","13873263948","190*10",20,52,1040]
[6,"潘夏阳",3058,{"$nulls":4},3058,null,null,"190*10",22,100,2200,{"$nulls":3},"190*10",115,52,5980,"430321196205061516","13875222513","190*12",30,62,1860]
[7,"陈勇强",3058,{"$nulls":4},3058,null,null,"190*12",50,30,1500,{"$nulls":3},"190*12",75,62,4650,"430321196501151516","13875232146","190*12",30,82,2460]
[8,"刘菜良",3058,{"$nulls":4},3058,null,"接","190*12",15,25,375,null,null,"接","190*12",10,82,820,"430321195712041515","13487322343","230*12",10,82,820]
[9,"郭文亮",3058,{"$nulls":4},3058,null,null,"230*12",6,12,72,{"$nulls":3},"230*12",12,82,984,"430321197108091515","15073287599","230*15",10,115,1150]
[{"$nulls":13},{"$f":"SUM(N8:N13)","v":10047},{"$nulls":6},{"$f":"SUM(U8:U13)","v":16134},null,null,"230*18",1,135,135]
[{"$nulls":11},4,null,{"$f":"N14/L15","v":2511.75},{"$nulls":4},4,null,{"$f":"U14/S15","v":4033.5},null,null,"190*18",1,130,130]
[{"$nulls":26},{"$f":"SUM(AA7:AA15)","v":12185}]
[{"$nulls":26},4]
[null,"合计",{"$f":"SUM(C5:C17)","v":30290},{"$nulls":4},{"$f":"SUM(H5:H17)","v":30290},{"$nulls":18},{"$f":"AA16/AA17","v":3046.25}]
[]
[]
[]
[]
[{"$nulls":6},"制表：谢慧"]