{"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 月 16日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"07:16:00","鲁QV8855","孙立","姚婷辉",17712020577,"李海洋","退货",null,"石子","1-2#",{"$nulls":7},14,{"$nulls":4},"李凤",null,"压碎值较大，退货"]
[2,"12:40:00","鲁QV9022","孙立","谭海洋",18762206092,"李海洋",13486,"WIN0050526","石子","1-2#",102.4,23.7,78.7,{"$nulls":3},"良好",7,1,77.7,100,{"$f":"U6*V6","v":7770},"陈金芳","李彤彤"]
[3,"16:10:00","鲁QV8954","孙立","吴伟",13914867594,"李海洋",13492,"WIN0050526","石子","1-2#",100.56,23.52,77.14,{"$nulls":3},"良好",7,1.54,75.6,100,7560,"陈金芳","马娜"]
[4,"19:04:00","鲁Q718BZ","陈磊","彭杰",16775839508,"李海洋",13493,"WIN0050526","石子","1-2#",105.02,23.54,81.48,{"$nulls":3},"良好",7,1.08,80.4,100,8040,"冯忠华","马娜"]
[5,"20:14:00","鲁QV9022","孙立","谭海洋",18762206092,"李海洋",13494,"WIN0050526","石子","1-2#",101.56,23.92,77.64,{"$nulls":3},"良好",7,1.04,76.6,100,7660,"冯忠华","马娜"]
[6,"20:56:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13495,"WIN0050526","石子","1-2#",99.84,23.84,76,{"$nulls":3},"良好",7,1,75,100,7500,"冯忠华","马娜"]
[7,"21:16:00","苏CGV338","高雷","李城市",13913462579,"杨需",13496,"WIN0050528","机制砂","中粗砂",92.28,21.52,70.76,7,2.4,2.9,"Ⅱ区",null,2.16,68.6,122,8369.2,"冯忠华","马娜"]
[8,"21:34:00","苏CGS000","周桂林","刘宝云",18906019310,"杨需",13497,"WIN0050528","机制砂","中粗砂",89.62,21.68,67.91,7,2.4,2.9,"Ⅱ区",null,2.04,65.9,122,8039.8,"冯忠华","马娜"]
[9,"22:29:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13498,"WIN0050527","机制砂","中粗砂",90.2,21.66,68.54,6,2,2.9,"Ⅱ区",null,1.44,67.1,122,8186.2,"冯忠华","马娜"]
[10,"22:34:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13500,"WIN0050527","机制砂","中粗砂",87.86,23.74,64.12,6,2,2.9,"Ⅱ区",null,1.32,62.8,122,7661.6,"冯忠华","马娜"]
[11,"22:35:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13501,"WIN0050527","机制砂","中粗砂",89.64,21.8,67.84,6,2,2.9,"Ⅱ区",null,1.44,66.4,122,8100.8,"冯忠华","马娜"]
[12,"22:36:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13502,"WIN0050527","机制砂","中粗砂",89.08,21.56,67.52,6,2,2.9,"Ⅱ区",null,1.42,66.1,122,8064.2,"冯忠华","马娜"]
[13,"03:29:00","苏C2A698","高雷","高雷",13913462579,"杨需",13506,"WIN0050528","机制砂","中粗砂",108.08,29.64,78.44,6,1.8,2.9,"Ⅱ区",null,1.64,76.8,122,9369.6,"冯忠华","马娜"]
[14,"04:08:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13507,"WIN0050527","机制砂","中粗砂",88.6,21.36,67.24,6,1.8,2.9,"Ⅱ区",null,1.44,65.8,122,8027.6,"冯忠华","马娜"]
[15,"04:10:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13508,"WIN0050527","机制砂","中粗砂",89.3,21.3,68,6,1.8,2.9,"Ⅱ区",null,1.4,66.6,122,8125.2,"冯忠华","马娜"]
[16,"04:24:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13509,"WIN0050527","机制砂","中粗砂",89.98,21.32,68.66,6,1.8,2.9,"Ⅱ区",null,1.46,67.2,122,8198.4,"冯忠华","马娜"]
[17,"05:00:00","鲁QV9022","孙立","谭海洋",18762206092,"李海洋",13510,"WIN0050526","石子","1-2#",103.3,23.76,79.54,{"$nulls":3},"良好",7,1.54,78,100,7800,"冯忠华","马娜"]
["合计",{"$nulls":12},{"$f":"SUM(N5:N21)","v":1159.53},{"$nulls":6},{"$f":"SUM(U5:U21)","v":1136.6},null,{"$f":"SUM(W5:W21)","v":128472.6}]

{"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 月 16 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"20:21:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013796","水泥","PO42.5",98.69,26.11,{"$f":"K5-L5","v":72.58},{"$nulls":5},{"v":0.003,"d":"0.30%"},72.36,535,{"$f":"T5*U5","v":38712.6},"冯海英","聂恒光","接15号"]
[2,"06:31:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013800","石子","1--2",52.8,16.21,36.59,{"$nulls":5},"0.1T",36.4,97,3530.8,"冯海英","聂恒光"]
[3,"06:34:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013801","石子","1--2",55.25,15.95,39.3,{"$nulls":5},"0.1T",39.2,97,3802.4,"冯海英","聂恒光"]
[4,"06:37:00","鲁RM5116","刘德法","韩杰",13395409956,"刘德法","013802","钢棒","&9.0",50.21,19.96,30.25,{"$nulls":6},30.25,4810,145502.5,"冯海英","聂恒光"]
[5,"08:46:00","鲁JA3618","马明永","房增东",17753836116,"马明永","013803","195线材","&6.5",47.98,14.49,33.49,{"$nulls":6},33.49,4022,134696.78,"冯海英","聂恒光"]
[6,"09:04:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013804","矿粉",null,69.55,17.04,52.51,{"$nulls":5},{"v":0.003,"d":"0.30%"},52.35,370,19369.5,"冯海英","聂恒光"]
[7,"09:25:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013805","石子","1--2",26.98,8.52,18.46,{"$nulls":5},"0.2T",18.2,97,1765.4,"冯海英","聂恒光"]
[8,"09:27:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013806","石子","1--2",27.77,8.52,19.25,{"$nulls":5},"0.2T",19,97,1843,"冯海英","聂恒光"]
[9,"09:52:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013807","机制沙","中粗",49.4,15.82,33.58,{"$nulls":5},"0.1T",33.4,139,4642.6,"冯海英","聂恒光"]
[10,"09:54:00","鲁RM3845","陈长秋","田运增",15020525186,"英良运输","013808","机制沙","中粗",47.84,15.03,32.81,{"$nulls":5},"0.1T",32.7,139,4545.3,"冯海英","聂恒光"]
[11,"10:13:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013809","机制沙","中粗",49.68,16.06,33.62,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[12,"10:19:00","鲁RM5116","刘德法","韩杰",13395409956,"刘德法","013810","钢棒","&10.7",19.96,15.34,4.62,{"$nulls":6},4.62,4810,22222.2,"冯海英","聂恒光"]
[13,"10:22:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013811","机制沙","中粗",49.42,16.33,33.09,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[14,"10:24:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013812","石子","1--2",49.51,16.44,33.07,{"$nulls":5},"0.1T",32.9,97,3191.3,"冯海英","聂恒光"]
[15,"10:47:00","鲁RM1853","狄方丁","狄方丁",17661385222,"英良运输","013813","机制沙","中粗",49.95,15.6,34.35,{"$nulls":5},"0.1T",34.2,139,4753.8,"冯海英","聂恒光"]
[16,"10:49:00","鲁RM7658","谢宏伟","谢宏伟",15106407336,"英良运输","013814","机制沙","中粗",49.97,16.72,33.25,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[17,"10:51:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","013815","机制沙","中粗",49.69,16.36,33.33,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[18,"12:19:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013816","石子","1--2",49.6,16.09,33.51,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[19,"12:21:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013817","石子","1--2",49.56,15.99,33.57,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[20,"15:01:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013818","石子","1--2",49.87,16.57,33.3,{"$nulls":5},"0.2T",33.1,97,3210.7,"冯海英","聂恒光"]
[21,"15:03:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013819","石子","1--2",29.16,8.48,20.68,{"$nulls":5},"1.5T",19.1,97,1852.7,"冯海英","聂恒光"]
[22,"16:55:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013820","石子","1--2",26.24,8.5,17.74,{"$nulls":5},"0.1T",17.6,97,1707.2,"冯海英","聂恒光"]
[23,"18:21:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013821","石子","1--2",50.06,16.05,34.01,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[24,"18:25:00","鲁RE5553","陈长秋","侯代华",13695308751,"英良运输","013822","机制沙","中粗",49.3,16.1,33.2,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[25,"18:27:00","鲁RK0329","陈长秋","张华洗",15615708910,"英良运输","013823","机制沙","中粗",49.18,15.56,33.62,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[26,"18:29:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013824","石子","1--2",49.49,15.82,33.67,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[27,"20:44:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013825","石子","1--2",28.46,8.49,19.97,{"$nulls":5},"0.1T",19.8,97,1920.6,"冯海英","聂恒光"]
[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":437989.48}]