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

{"sheet":"邳州公司","index":0,"n_rows":34,"n_cols":26,"rows_kept":34,"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 月 31 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"13:37:00","鲁Q718BZ","孙立","籍爱春",15996908444,"李海洋",13860,"WIN0050680","石子","1-2#",100.42,23.58,76.84,{"$nulls":3},"良好",8,1.04,75.8,105,{"$f":"U5*V5","v":7959},"刘会良","李彤彤"]
[2,"13:41:00","鲁Q317BG","汤伟","汤伟",15152002122,"李海洋",13861,"WIN0050680","石子","1-2#",83.12,20.14,62.98,{"$nulls":3},"良好",8,1.08,61.9,105,6499.5,"刘会良","李彤彤"]
[3,"13:45:00","鲁Q659BV","许浩","杨武",15252226528,"李海洋",13862,"WIN0050680","石子","1-2#",88.14,22.64,65.5,{"$nulls":3},"良好",8,1,64.5,105,6772.5,"刘会良","李彤彤"]
[4,"13:48:00","鲁DC1206","张福宝","沈广",15852120079,"李海洋","退货",null,"石子","1-2#",{"$nulls":6},"含风化石较多",{"$nulls":5},"刘会良","李彤彤"]
[5,"13:50:00","鲁Q827AM","张福宝","胡庆中",15062025252,"李海洋","退货",null,"石子","1-2#",{"$nulls":6},"含泥块较多",{"$nulls":5},"刘会良","李彤彤"]
[6,"13:59:00","鲁Q153AK","郭照岗","张祥明",13952276886,"李海洋","退货.未卸",null,"石子","1-2#",{"$nulls":6},"含泥块较多",{"$nulls":5},"刘会良","李彤彤"]
[7,"17:10:00","苏CHC216","汤霞","李民",15062056402,"丁庆余","退货",null,"石子","1-2#",{"$nulls":6},"含泥块较多",{"$nulls":5},"陈金芳","马娜"]
[8,"17:12:00","苏CBA768","余宝军","杨国强",15252221345,"丁庆余","退货",null,"石子","1-2#",{"$nulls":6},"含泥块较多",{"$nulls":5},"陈金芳","马娜"]
[9,"17:31:00","苏C1T890","曹新振","刘可",13914822209,"丁庆余",13869,"WIN0050681","石子","1-2#",3.32,22.26,71.06,{"$nulls":3},"良好",8,1.06,70,103,{"$f":"U13*V13","v":7210},"王尧","马娜"]
[10,"17:34:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",13870,"WIN0050681","石子","1-2#",88.94,22.72,66.22,{"$nulls":3},"良好",8,1.02,65.2,103,6715.6,"王尧","马娜"]
[11,"17:36:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",13871,"WIN0050681","石子","1-2#",95.52,22,74.52,{"$nulls":3},"良好",8,1.02,73.5,103,7570.5,"王尧","马娜"]
[12,"17:39:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",13872,"WIN0050681","石子","1-2#",111.86,22.62,89.24,{"$nulls":3},"良好",8,1.04,88.2,103,9084.6,"王尧","马娜"]
[13,"17:41:00","苏C1T978","陈建","汤继海",18762200666,"丁庆余",13873,"WIN0050681","石子","1-2#",98.26,22.84,75.42,{"$nulls":3},"良好",8,1.02,74.4,103,7663.2,"王尧","马娜"]
[14,"19:39:00","鲁Q718BZ","孙立","籍爱春",15996908444,"李海洋",13874,"WIN0050680","石子","1-2#",105.1,23.52,81.58,{"$nulls":3},"良好",8,1.08,80.5,103,8291.5,"王尧","马娜"]
[15,"20:34:00","鲁Q188BD","戴春宇","谭常来",15852103716,"李海洋",13877,"WIN0050680","石子","1-2#",77.34,19.1,58.24,{"$nulls":3},"良好",7,0.54,57.7,103,5943.1,"王尧","马娜"]
[16,"20:44:00","鲁Q673AX","戴春宇","闫志强",15885219275,"李海洋",13878,"WIN0050680","石子","1-2#",73.72,18.56,55.16,{"$nulls":3},"良好",8,1.26,53.9,103,5551.7,"王尧","马娜"]
[17,"22:53:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13880,"WIN0050679","机制砂","中粗砂",91.6,21.9,69.7,9,2.4,2.9,"Ⅱ区",null,3.5,66.2,122,8076.4,"李思","马娜"]
[18,"22:56:00","苏CGF365","冯永青","崔学良",13775854328,"李海洋",13881,"WIN0050679","机制砂","中粗砂",89.78,21.84,67.94,9,2.4,2.9,"Ⅱ区",null,3.44,64.5,122,7869,"李思","马娜"]
[19,"22:58:00","苏CGA040","冯永盛","李城市",13913462579,"李海洋",13882,"WIN0050679","机制砂","中粗砂",89.12,21.58,67.54,9,2.4,2.9,"Ⅱ区",null,3.44,64.1,122,7820.2,"李思","马娜"]
[20,"00:22:00","鲁Q718BZ","孙立","籍爱春",15996908444,"李海洋",13882,"WIN0050680","石子","1-2#",108.64,23.38,85.26,{"$nulls":3},"良好",7,0.56,84.7,103,8724.1,"李思","马娜"]
[21,"01:34:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",13885,"WIN0050680","石子","1-2#",106.26,22.9,83.36,{"$nulls":3},"良好",7,0.56,82.8,103,8528.4,"李思","马娜"]
[22,"01:38:00","鲁Q902AJ","陈建","冯凯歌",18352221875,"丁庆余",13886,"WIN0050681","石子","1-2#",85.22,19.72,65.5,{"$nulls":3},"良好",7,0.5,65,103,6695,"李思","马娜"]
[23,"01:42:00","苏CJM858","陈建","孙福建",15365400159,"丁庆余",13887,"WIN0050681","石子","1-2#",86.66,18.16,68.5,{"$nulls":3},"良好",7,0.5,68,103,7004,"李思","马娜"]
[24,"02:32:00","鲁Q522BG","戴春宇","郑佳雷",15862121767,"李海洋",13889,"WIN0050680","石子","1-2#",104.84,22.36,82.48,{"$nulls":3},"良好",8,1.08,81.4,103,8384.2,"李思","马娜"]
[25,"02:52:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",13890,"WIN0050681","石子","1-2#",111.14,22.62,88.52,{"$nulls":3},"良好",7,0.52,88,103,9064,"李思","马娜"]
[26,"03:24:00","鲁Q188BD","戴春宇","谭常来",15852103716,"李海洋","退货",null,"石子","1-2#",{"$nulls":6},"含风化石.黄皮较多",{"$nulls":5},"李思","马娜"]
[27,"03:30:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",13893,"WIN0050681","石子","1-2#",99.94,22.58,77.36,{"$nulls":3},"良好",7,0.56,76.8,103,{"$f":"U31*V31","v":7910.4},"李思","马娜"]
[28,"03:39:00","鲁QV8530","周闻声","杨武峰",13382661279,"李海洋",13894,"WIN0050680","石子","1-2#",101.22,22.2,79.02,{"$nulls":3},"良好",7,0.52,78.5,103,8085.5,"李思","马娜"]
[29,"03:55:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",13895,"WIN0050681","石子","1-2#",116.36,22.54,93.82,{"$nulls":3},"良好",7,0.52,93.3,103,9609.9,"李思","马娜"]
["合计",{"$nulls":12},{"$f":"SUM(N5:N33)","v":1705.76},{"$nulls":6},{"$f":"SUM(U5:U33)","v":1678.9},null,{"$f":"SUM(W5:W33)","v":177032.3}]

{"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 月 31 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:38:00","鲁RM5116","李翔","韩杰",13395409956,"李翔","014080","钢棒","&9.0",50.14,15.22,{"$f":"K5-L5","v":34.92},{"$nulls":6},34.92,4690,{"$f":"T5*U5","v":163774.8},"冯海英","聂恒光"]
[2,"06:43:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","014081","机制沙","中粗",50.17,16.37,33.8,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[3,"06:45:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","014082","机制沙","中粗",48.7,15.94,32.76,{"$nulls":5},"0.1T",32.6,139,4531.4,"冯海英","聂恒光"]
[4,"08:00:00","鲁RL8711","孟贺","孟贺",18769072996,"郑言克","014083","机制沙","中粗",49.73,15.63,34.1,{"$nulls":5},"0.1T",34,139,4726,"冯海英","聂恒光"]
[5,"08:02:00","鲁RN4496","刘传义","刘传义",18866605908,"郑言克","014084","机制沙","中粗",49.63,15.03,34.6,{"$nulls":5},"0.1T",34.5,139,4795.5,"冯海英","聂恒光"]
[6,"08:35:00","鲁Q8F6J8","张贵伦","张希超",15864970687,"张贵伦","014085","模边油",null,7.08,3.22,3.86,{"$nulls":6},3.86,null,0,"冯海英","聂恒光"]
[7,"10:37:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","014086","机制沙","中粗",49.28,16.6,32.68,{"$nulls":5},"0.1T",32.5,139,4517.5,"冯海英","聂恒光"]
[8,"10:39:00","鲁RN7809","张福兵","张福兵",15106407336,"英良运输","014087","机制沙","中粗",48.62,16.29,32.33,{"$nulls":5},"0.1T",32.2,139,4475.8,"冯海英","聂恒光"]
[9,"10:41:00","鲁RM1853","狄方丁","狄方丁",17661385222,"英良运输","014088","机制沙","中粗",49.63,15.7,33.93,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[10,"10:43:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014089","机制沙","中粗",49.92,16.77,33.15,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[11,"12:17:00","鲁RN9829","米强栋","米强栋",18953005713,"英良运输","014090","机制沙","中粗",49.6,16.3,33.3,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[12,"12:30:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","014091","机制沙","中粗",49.72,15.84,33.88,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[13,"15:26:00","鲁U9F383","单法奎","单正义",13771997678,"莱芜延辉","014092","减水剂",null,31.31,15.03,16.28,{"$nulls":6},16.28,1900,30932,"冯海英","聂恒光"]
[14,"17:19:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","014093","机制沙","中粗",49.01,16.58,32.43,{"$nulls":5},"0.1T",32.3,139,4489.7,"冯海英","聂恒光"]
[15,"17:21:00","鲁RN7809","张福兵","张福兵",15106407336,"英良运输","014094","机制沙","中粗",49.76,16.31,33.45,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[16,"17:23:00","鲁RM1853","狄方丁","狄方丁",17661385222,"英良运输","014095","机制沙","中粗",49.94,15.79,34.15,{"$nulls":5},"0.1T",34,139,4726,"冯海英","聂恒光"]
[17,"17:25:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014096","机制沙","中粗",48.83,16.7,32.13,{"$nulls":5},"0.1T",32,139,4448,"冯海英","聂恒光"]
[18,"18:39:00","鲁RN9829","米强栋","米强栋",18953005713,"英良运输","014097","机制沙","中粗",49.71,16.2,33.51,{"$nulls":5},"0.1T",33.4,139,4642.6,"冯海英","聂恒光"]
[19,"18:41:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","014098","机制沙","中粗",48.43,16.17,32.26,{"$nulls":3},".",null,"0.1T",32.1,139,4461.9,"冯海英","聂恒光"]
[20,{"$nulls":11},0,{"$nulls":8},0]
[21,{"$nulls":11},0,{"$nulls":8},0]
[22,{"$nulls":11},0,{"$nulls":8},0]
[23,{"$nulls":11},0,{"$nulls":8},0]
[24,{"$nulls":11},0,{"$nulls":8},0]
[25,{"$nulls":11},0,{"$nulls":8},0]
[26,{"$nulls":11},0,{"$nulls":8},0]
[27,{"$nulls":11},0,{"$nulls":8},0]
[28,{"$nulls":11},0,{"$nulls":8},0]
[29,{"$nulls":11},0,{"$nulls":8},0]
[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":268418.5}]