{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["邳州公司","巨野分公司"],"read":"whole","date_system":"1900"}

{"sheet":"邳州公司","index":0,"n_rows":22,"n_cols":26,"rows_kept":22,"merged":[[0,0,0,26],[1,1,1,23],[2,0,3,0],[2,2,2,6],[2,8,2,19],[2,20,2,22],[2,23,3,23],[2,24,3,24],[2,25,3,25]]}
["收料登记表填报\n日期  ：2019 年 5 月 14日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"08:09:00","鲁QV8530","孙立","蒋学武",1777228098,"李海洋",13440,"WIN0050500","石子","1-2#",94.1,21.7,72.4,{"$nulls":3},"良好",7,1.5,70.9,103,{"$f":"V5*U5","v":7302.7},"李凤","杜娥"]
[2,"16:56:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋","退货",null,"石子","1-2#",{"$nulls":6},"含泥块、大块",{"$nulls":4},0,"李凤","马娜","含泥块、大块，退货"]
[3,"20:17:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13442,"WIN0050498","机制砂","中粗砂",93.54,21.48,72.06,6,1.5,2.9,"Ⅱ区",null,1.46,70.6,119,8401.4,"冯忠华","马娜"]
[4,"20:19:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13443,"WIN0050498","机制砂","中粗砂",96.44,22,74.44,6,1.5,2.9,"Ⅱ区",null,1.54,72.9,119,8675.1,"冯忠华","马娜"]
[5,"20:35:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13445,"WIN0050498","机制砂","中粗砂",95.78,21.16,74.62,6,1.5,2.9,"Ⅱ区",null,1.52,73.1,119,8698.9,"冯忠华","马娜"]
[6,"21:15:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13447,"WIN0050498","机制砂","中粗砂",96.92,23.36,73.56,6,1.5,2.9,"Ⅱ区",null,1.56,72,119,8568,"冯忠华","马娜"]
[7,"03:40:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13449,"WIN0050498","机制砂","中粗砂",89.52,2134,68.18,6,1.8,2.9,"Ⅱ区",null,1.38,66.8,119,7949.2,"冯忠华","马娜"]
[8,"03:42:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13450,"WIN0050498","机制砂","中粗砂",93.58,21.34,72.34,6,1.8,2.9,"Ⅱ区",null,1.54,70.7,119,8413.3,"冯忠华","马娜"]
[9,"03:45:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13451,"WIN0050498","机制砂","中粗砂",92.36,21.44,70.92,6,1.8,2.9,"Ⅱ区",null,1.42,69.5,119,8270.5,"冯忠华","马娜"]
[10,"03:48:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13452,"WIN0050498","机制砂","中粗砂",92.54,23.5,69.04,6,1.8,2.9,"Ⅱ区",null,1.44,67.6,119,8044.4,"冯忠华","马娜"]
[11,"04:10:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",13453,"WIN0050499","机制砂","中粗砂",93.76,22.68,71.08,6,1.8,2.9,"Ⅱ区",null,1.48,69.6,119,8282.4,"冯忠华","马娜"]
[12,"04:13:00","苏C2A698","高雷","高雷",13913462579,"杨需",13454,"WIN0050499","机制砂","中粗砂",107.12,29.4,77.72,6,1.8,2.9,"Ⅱ区",null,1.62,76.1,119,9055.9,"冯忠华","马娜"]
[]
[]
[]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N21)","v":796.36},{"$nulls":6},{"$f":"SUM(U5:U21)","v":779.8},null,{"$f":"SUM(W5:W21)","v":91661.8}]

{"sheet":"巨野分公司","index":1,"n_rows":73,"n_cols":25,"rows_kept":73,"merged":[[0,0,0,21],[1,1,1,21],[2,0,3,0],[2,2,2,6],[2,7,2,18],[2,19,2,21],[2,22,3,22],[2,23,3,23],[2,24,3,24]]}
["收料登记表填报\n日期    2019年 5 月 14 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:16:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013745","石子","1--2",30.02,8.59,{"$f":"K5-L5","v":21.43},{"$nulls":5},"01T",20.4,97,{"$f":"T5*U5","v":1978.8},"冯海英","聂恒光"]
[2,"06:18:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013746","石子","1--2",50.34,16.24,34.1,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[3,"06:20:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013747","石子","1--2",49.64,15.96,33.68,{"$nulls":5},"0.1T",33.5,535,17922.5,"冯海英","聂恒光"]
[4,"06:53:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013748","水泥","PO42.5",99.16,26.38,72.78,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.56,535,38819.6,"冯海英","聂恒光"]
[5,"06:56:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013749","水泥","PO42.5",99.53,26.37,73.16,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.94,97,7075.18,"冯海英","聂恒光"]
[6,"08:26:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013750","石子","1--2",27.51,8.55,18.96,{"$nulls":5},"0.8T",18.1,97,1755.7,"冯海英","聂恒光"]
[7,"08:28:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013751","石子","1--2",26.79,8.49,18.3,{"$nulls":5},"0.8T",17.5,97,1697.5,"冯海英","聂恒光"]
[8,"08:30:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013752","石子","1--2",51.78,15.1,36.68,{"$nulls":5},"0.2T",36.4,97,3530.8,"冯海英","聂恒光"]
[9,"09:03:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013753","石子","1--2",49.5,14.59,34.91,{"$nulls":5},"0.1T",34.8,97,3375.6,"冯海英","聂恒光"]
[10,"10:02:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013754","石子","1--2",50.37,15.89,34.48,{"$nulls":5},"0.1T",34.3,97,3327.1,"冯海英","聂恒光"]
[11,"10:41:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013755","石子","1--2",49.35,16.17,33.18,{"$nulls":5},"0.1T",33,97,3201,"冯海英","聂恒光"]
[12,"10:43:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013756","石子","1--2",50.87,15.89,34.98,{"$nulls":5},"0.1T",34.8,97,3375.6,"冯海英","聂恒光"]
[13,"11:06:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013757","石子","1--2",49.73,16.49,33.24,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[14,"12:00:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013758","石子","1--2",48.56,15.83,32.73,{"$nulls":5},"0.2T",32.5,97,3152.5,"冯海英","聂恒光"]
[15,"14:28:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013759","石子","1--2",28.32,8.53,19.79,{"$nulls":5},"0.1T",19.6,97,1901.2,"冯海英","聂恒光"]
[16,"14:30:00","鲁JA4773","王双喜","王恩军",15588714111,"郑言克","013760","石子","1--2",49.54,14.47,35.07,{"$nulls":5},"0.1T",34.9,97,3385.3,"冯海英","聂恒光"]
[17,"14:32:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013761","石子","1--2",49.49,14.56,34.93,{"$nulls":5},"0.1T",34.8,97,3375.6,"冯海英","聂恒光"]
[18,"14:39:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013762","石子","1--2",45.93,15.04,30.89,{"$nulls":5},"0.1T",30.7,97,2977.9,"冯海英","聂恒光"]
[19,"14:57:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013763","石子","1--2",49.54,15.83,33.71,{"$nulls":5},"0.1T",33.6,97,3259.2,"冯海英","聂恒光"]
[20,"15:22:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013764","石子","1--2",49.37,16.12,33.25,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[21,"15:24:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013765","石子","1--2",49.45,15.82,33.63,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[22,"16:18:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013766","石子","1--2",49.42,16.43,32.99,{"$nulls":5},"0.1T",32.8,97,3181.6,"冯海英","聂恒光"]
[23,"16:23:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013767","石子","1--2",49.9,15.78,34.12,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[24,"18:40:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013768","石子","1--2",27.75,8.51,19.24,{"$nulls":5},"0.1T",19.1,97,1852.7,"冯海英","聂恒光"]
[25,"18:57:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013769","石子","1--2",49.77,15.79,33.98,{"$nulls":5},"0.1T",33.8,97,3278.6,"冯海英","聂恒光"]
[26,"19:18:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013770","石子","1--2",49.44,16.16,33.28,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[27,"19:20:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013771","石子","1--2",51.6,15.78,35.82,{"$nulls":5},"0.1T",35.7,97,3462.9,"冯海英","聂恒光"]
[28,"19:47:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013772","石子","1--2",49.73,16.4,33.33,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[29,"20:53:00","鲁JA4773","王双喜","王恩军",15588714111,"郑言克","013773","石子","1--2",49.29,14.42,34.87,{"$nulls":5},"0.1T",34.7,97,3365.9,"冯海英","聂恒光"]
[30,"21:13:00","鲁RE5553","陈长秋","侯代华",13695308751,"英良运输","013774","机制沙","中粗",49.35,16.14,33.21,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[31,"21:20:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013775","机制沙","中粗",46.2,14.02,32.18,{"$nulls":5},"0.1T",32,139,4448,"冯海英","聂恒光"]
[32,"21:22:00","鲁RM3845","陈长秋","张先会",15990979156,"英良运输","013776","机制沙","中粗",49,15.06,33.94,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[33,"21:25:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013777","机制沙","中粗",46.42,14.04,32.38,{"$nulls":5},"0.1T",32.2,139,4475.8,"冯海英","聂恒光"]
[34,{"$nulls":11},0,{"$nulls":8},0]
[35,{"$nulls":11},0,{"$nulls":8},0]
[36,{"$nulls":11},0,{"$nulls":8},0]
[37,{"$nulls":11},0,{"$nulls":8},0]
[38,{"$nulls":11},0,{"$nulls":8},0]
[39,{"$nulls":11},0,{"$nulls":8},0]
[40,{"$nulls":11},0,{"$nulls":8},0]
[41,{"$nulls":11},0,{"$nulls":8},0]
[42,{"$nulls":11},0,{"$nulls":8},{"$f":"T46*U46","v":0}]
[43,{"$nulls":11},0,{"$nulls":8},0]
[44,{"$nulls":11},0,{"$nulls":8},0]
[45,{"$nulls":11},0,{"$nulls":8},0]
[46,{"$nulls":11},0,{"$nulls":8},0]
[47,{"$nulls":11},0,{"$nulls":8},0]
[48,{"$nulls":11},0,{"$nulls":8},0]
[49,{"$nulls":11},0,{"$nulls":8},0]
[50,{"$nulls":11},0,{"$nulls":8},0]
[51,{"$nulls":11},0,{"$nulls":8},0]
[52,{"$nulls":11},0,{"$nulls":8},0]
[53,{"$nulls":11},0,{"$nulls":8},0]
[54,{"$nulls":11},0,{"$nulls":8},0]
[55,{"$nulls":11},0,{"$nulls":8},0]
[56,{"$nulls":11},0,{"$nulls":8},0]
[57,{"$nulls":11},0,{"$nulls":8},0]
[58,{"$nulls":11},0,{"$nulls":8},0]
[59,{"$nulls":11},0,{"$nulls":8},0]
[60,{"$nulls":11},0,{"$nulls":8},0]
[61,{"$nulls":11},0,{"$nulls":8},0]
[62,{"$nulls":11},0,{"$nulls":8},0]
[63,{"$nulls":11},0,{"$nulls":8},0]
[64,{"$nulls":11},0,{"$nulls":8},0]
[65,{"$nulls":11},{"$f":"K69-L69","v":0},{"$nulls":8},0]
[66,{"$nulls":11},0,{"$nulls":8},0]
[67,{"$nulls":11},0,{"$nulls":8},0]
[68,{"$nulls":11},0,{"$nulls":8},0]
["合计：",{"$nulls":18},0,null,{"$f":"SUM(V5:V72)","v":160173.68}]