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

{"sheet":"邳州公司","index":0,"n_rows":25,"n_cols":26,"rows_kept":25,"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 月 9 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"05:07:00","鲁Q673AX","戴春宇","闫志强",1585219575,"段俊成","退货",null,"石子","1-5#",{"$nulls":6},"含泥块",{"$nulls":5},"王瑶瑶","李彤彤","含泥块，退货"]
[2,"14:24:00","鲁Q522BG","戴春宇","郑嘉磊",15862121767,"段俊成",13338,"WIN0050443","石子","1-5#",100.94,23.06,77.88,{"$nulls":3},"良好",9,1.08,76.8,98,{"$f":"U6*V6","v":7526.4},"刘会良","李彤彤","三车间"]
[3,"21:20:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",13343,"WIN0050441","机制砂","中粗砂",88.52,22.6,65.92,5,1.5,2.8,"Ⅱ区",null,0.72,65.2,119,7758.8,"王瑶瑶","马娜"]
[4,"21:22:00","苏CGD838","王浩","张玉",13626150626,"庄团结",13344,"WIN0050441","机制砂","中粗砂",89.18,21.6,67.58,5,1.5,2.8,"Ⅱ区",null,0.68,66.9,119,7961.1,"王瑶瑶","马娜"]
[5,"21:25:00","苏C2A698","高雷","高雷",13913462579,"庄团结",13345,"WIN0050441","机制砂","中粗砂",106.54,29.62,76.92,5,1.5,2.8,"Ⅱ区",null,0.82,76.1,119,9055.9,"王瑶瑶","马娜"]
[6,"21:47:00","苏CGS000","周桂林","刘宝云",18906019310,"庄团结",13346,"WIN0050441","机制砂","中粗砂",87.32,21.76,65.56,5,1.5,2.8,"Ⅱ区",null,0.66,64.9,119,7723.1,"王瑶瑶","马娜"]
[7,"22:30:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13347,"WIN0050442","机制砂","中粗砂",90.52,21.68,68.84,5,1.6,2.8,"Ⅱ区",null,0.74,68.1,119,8103.9,"王瑶瑶","马娜"]
[8,"22:32:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13348,"WIN0050442","机制砂","中粗砂",89.7,23.02,66.68,5,1.6,2.8,"Ⅱ区",null,0.68,66,119,7854,"王瑶瑶","马娜"]
[9,"22:35:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13349,"WIN0050442","机制砂","中粗砂",90.66,21.4,69.26,5,1.6,2.8,"Ⅱ区",null,0.76,68.5,119,8151.5,"王瑶瑶","马娜"]
[10,"23:05:00","鲁QV8991","孙立","韩宏基",15195483119,"李海洋",13350,"WIN0050445","石子","1-2#",102.08,23.2,78.88,{"$nulls":3},"良好",7,1.08,77.8,98,7624.4,"王瑶瑶","马娜"]
[11,"23:10:00","鲁QV8855","孙立","姚庭辉",17712020577,"李海洋",13351,"WIN0050445","石子","1-2#",104.36,23.54,80.82,{"$nulls":3},"良好",7,1.02,79.8,98,7820.4,"王瑶瑶","马娜"]
[12,"00:17:00","鲁Q076AX","林磊","刘枫",13625120004,"丁庆余",13352,"WIN0050444","石子","1-2#",107.04,23.32,8.372,{"$nulls":3},"良好",7,1.02,82.7,98,8104.6,"王瑶瑶","马娜"]
[13,"02:54:00","鲁QV8855","孙立","姚庭辉",17712020577,"李海洋",13353,"WIN0050445","石子","1-2#",107.06,23.4,83.66,{"$nulls":3},"良好",7,1.06,82.6,98,8094.8,"王瑶瑶","马娜"]
[14,"02:58:00","鲁Q338AA","冯波","娄磊",15062093690,"李海洋",13354,"WIN0050445","石子","1-5#",101.02,22.9,78.12,{"$nulls":3},"良好",7,0.52,77.6,98,7604.8,"王瑶瑶","马娜"]
[15,"03:52:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13355,"WIN0050442","机制砂","中粗砂",95.24,21.38,73.86,6,2,2.8,"Ⅱ区",null,1.56,72.3,119,8603.7,"王瑶瑶","马娜"]
[16,"03:54:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13356,"WIN0050442","机制砂","中粗砂",94.66,23.06,71.6,6,2,2.8,"Ⅱ区",null,1.5,70.1,119,8341.9,"王瑶瑶","马娜"]
[17,"04:33:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13357,"WIN0050442","机制砂","中粗砂",94.66,21.6,73.06,5,2,2.8,"Ⅱ区",null,1.56,71.5,119,8508.5,"王瑶瑶","马娜"]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N24)","v":1107.012},{"$nulls":6},{"$f":"SUM(U5:U24)","v":1166.9},null,{"$f":"SUM(W5:W24)","v":128837.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 月 9 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:06:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013643","水泥","PO42.5",97.52,26.19,{"$f":"K5-L5","v":71.33},{"$nulls":5},{"v":0.003,"d":"0.30%"},71.1,535,{"$f":"T5*U5","v":38038.5},"冯海英","聂恒光"]
[2,"06:09:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013644","水泥","PO42.5",99.16,26.28,72.88,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.66,535,38873.1,"冯海英","聂恒光"]
[3,"06:58:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013645","石子","1--2",30.37,8.58,21.79,{"$nulls":5},"0.2T",21.5,97,2085.5,"冯海英","聂恒光"]
[4,"07:06:00","鲁P04294","闫记奎","夏德喜",17663521218,"闫记喜","013646","端板",null,46.09,30.35,15.74,{"$nulls":6},15.74,null,0,"冯海英","聂恒光"]
[5,"08:37:00","鲁P04294","闫记奎","夏德喜",17663521218,"闫记喜","013647","端板",null,30.35,15.63,14.72,{"$nulls":6},14.72,null,0,"冯海英","聂恒光"]
[6,"08:44:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013648","石子","1--2",49.22,14.51,34.71,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[7,"09:01:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013649","石子","1--2",26.05,8.5,17.55,{"$nulls":5},"0.2T",17.3,97,1678.1,"冯海英","聂恒光"]
[8,"09:21:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013650","石子","1--2",26.32,8.53,17.79,{"$nulls":5},"0.2T",17.5,97,1697.5,"冯海英","聂恒光"]
[9,"09:52:00","鲁JA4773","王双喜","王恩军",15588714111,"郑言克","013651","石子","1--2",49.64,14.5,35.14,{"$nulls":5},"0.1T",35,97,3395,"冯海英","聂恒光"]
[10,"10:03:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013652","石子","1--2",49.59,15.53,34.06,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[11,"12:33:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013653","石子","1--2",49.06,15.05,34.01,{"$nulls":5},"0.5T",33.5,97,3249.5,"冯海英","聂恒光"]
[12,"12:35:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013654","机制沙","中粗",45.52,13.97,31.55,{"$nulls":5},"0.1T",31.4,139,4364.6,"冯海英","聂恒光"]
[13,"12:37:00","鲁RE5553","陈长秋","侯代华",13695308751,"英良运输","013655","机制沙","中粗",49.56,16.22,33.34,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[14,"12:39:00","鲁RF7132","陈长秋","文洪涛",13869741571,"英良运输","013656","机制沙","中粗",49.03,15.1,33.93,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[15,"12:46:00","鲁RK0329","陈长秋","张华洗",15615708910,"英良运输","013657","机制沙","中粗",49.06,15.53,33.53,{"$nulls":5},"0.1T",33.4,139,4642.6,"冯海英","聂恒光"]
[16,"13:09:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013658","机制沙","中粗",48.89,16.07,32.82,{"$nulls":5},"0.1T",32.7,139,4545.3,"冯海英","聂恒光"]
[17,"13:11:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013659","机制沙","中粗",49.47,16.34,33.13,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[18,"13:14:00","鲁RM3845","陈长秋","张先会",15990979156,"英良运输","013660","机制沙","中粗",47.78,15.09,32.69,{"$nulls":5},"0.1T",32.5,139,4517.5,"冯海英","聂恒光"]
[19,"13:16:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013661","机制沙","中粗",45.22,14.12,31.1,{"$nulls":5},"0.1T",31,139,4309,"冯海英","聂恒光"]
[20,"14:25:00","鲁RF8997","陈平西","张双喜",13225307696,"英良运输","013662","机制沙","中粗",45.48,15.23,30.25,{"$nulls":5},"0.1T",30.1,139,4183.9,"冯海英","聂恒光"]
[21,"14:43:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013663","机制沙","中粗",47.74,16.21,31.53,{"$nulls":5},"0.1T",31.4,139,4364.6,"冯海英","聂恒光"]
[22,"14:45:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013664","机制沙","中粗",47.33,16.16,31.17,{"$nulls":5},"0.1T",31,139,4309,"冯海英","聂恒光"]
[23,"16:01:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013665","石子","1--2",49.84,15.47,34.37,{"$nulls":5},"0.1T",34.2,97,3317.4,"冯海英","聂恒光"]
[24,"16:03:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013666","石子","1--2",26.93,8.5,18.43,{"$nulls":5},"0.1T",18.3,97,1775.1,"冯海英","聂恒光"]
[25,"16:05:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013667","石子","1--2",26.66,8.48,18.18,{"$nulls":5},"1T",17.1,97,1658.7,"冯海英","聂恒光"]
[26,"20:24:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013668","石子","1--2",49.39,15.94,33.45,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[27,"20:26:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013669","石子","1--2",49.78,15.69,34.09,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[28,"20:49:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013670","机制沙","中粗",48.65,16.13,32.52,{"$nulls":5},"0.1T",32.4,139,4503.6,"冯海英","聂恒光"]
[29,"20:51:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013671","机制沙","中粗",49.59,16.07,33.52,{"$nulls":5},"0.1T",33.4,139,4642.6,"冯海英","聂恒光"]
[30,{"$nulls":11},0,{"$nulls":8},0,"冯海英","聂恒光"]
[31,{"$nulls":11},0,{"$nulls":8},0,"冯海英","聂恒光"]
[32,{"$nulls":11},0,{"$nulls":8},0,"冯海英","聂恒光"]
[33,{"$nulls":11},0,{"$nulls":8},0,"冯海英","聂恒光"]
[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":167214}]