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

{"sheet":"邳州分公司","index":0,"n_rows":39,"n_cols":26,"rows_kept":39,"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 年 4 月 15 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"13:02:00","鲁QV9022","孙立","谭海洋",18762069692,"李海洋",12868,"WIN0050175","石子","1-2#",101.2,23.6,77.6,{"$nulls":3},"良好",7,0.5,77.1,98,{"$f":"V5*U5","v":7555.8},"陈金芳","李彤彤"]
[2,"13:04:00","鲁QV8954","孙立","刘东起",13921762980,"李海洋",12869,"WIN0050175","石子","1-2#",98.56,23.36,75.2,{"$nulls":3},"良好",7,0.5,74.7,98,7320.6,"陈金芳","李彤彤"]
[3,"14:07:00","鲁Q515BZ","王彬","冯波",13347936982,"李海洋",12870,"WIN0050175","石子","1-2#",105.34,26.74,78.6,{"$nulls":3},"良好",7,0.5,78.1,98,7653.8,"陈金芳","李彤彤"]
[4,"14:11:00","鲁Q718BZ","孙立","陈正旭",13852231207,"李海洋",12871,"WIN0050175","石子","1-2#",106.06,23.6,81.46,{"$nulls":3},"良好",7,0.56,80.9,98,7928.2,"陈金芳","李彤彤"]
[5,"19:32:00","鲁QV9022","孙立","谭海洋",18762069692,"李海洋",12872,"WIN0050175","石子","1-2#",103.42,24.18,79.24,{"$nulls":3},"良好",7,0.54,78.7,98,7712.6,"陈金芳","马娜"]
[6,"19:36:00","鲁Q718BZ","孙立","陈正旭",13852231207,"李海洋",12874,"WIN0050175","石子","1-2#",108.84,23.44,79.4,{"$nulls":3},"良好",7,0.5,78.9,98,7732.2,"王瑶瑶","马娜"]
[7,"19:41:00","鲁QV8954","孙立","刘东起",13921762980,"李海洋",12875,"WIN0050175","石子","1-2#",102.4,23.44,78.96,{"$nulls":3},"良好",7,0.56,78.4,98,7683.2,"王瑶瑶","马娜"]
[8,"19:51:00","苏CGD838","王浩","胡庆东",15062025252,"李海洋",12876,"WIN0050175","石子","1-2#",91.84,20.24,71.6,{"$nulls":3},"良好",7,1,70.6,98,6918.8,"王瑶瑶","马娜"]
[9,"19:55:00","鲁Q000AJ","王浩","曹天强",13357931887,"李海洋",12877,"WIN0050175","石子","1-2#",95.86,21.44,74.42,{"$nulls":3},"良好",7,0.52,73.9,98,7242.2,"王瑶瑶","马娜"]
[10,"20:51:00","鲁Q506BE","戴春宇","张胜",15105202990,"李海洋",12878,"WIN0050175","石子","1-2#",76.58,18.66,57.92,{"$nulls":3},"良好",7,0.52,57.4,98,5625.2,"王瑶瑶","马娜"]
[11,"20:55:00","鲁Q956BY","王浩","臧齐",13505201115,"李海洋",12879,"WIN0050175","石子","1-2#",97.62,18.82,78.8,{"$nulls":3},"良好",7,0.95,77.8,98,7624.4,"王瑶瑶","马娜"]
[12,"21:25:00","苏C2A698","高雷","高雷",13913462579,"庄团结",12881,"WIN0050171","机制砂","中粗砂",110.64,29.32,81.32,5,1.6,2.8,"Ⅱ区",null,0.82,80.5,122,9821,"王瑶瑶","马娜"]
[13,"21:30:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",12882,"WIN0050171","机制砂","中粗砂",96.94,22.58,74.58,5,1.6,2.8,"Ⅱ区",null,0.75,73.6,122,8979.2,"王瑶瑶","马娜"]
[14,"22:04:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",12883,"WIN0050175","石子","1-2#",104.74,22.9,81.84,{"$nulls":3},"良好",7,0.54,81.3,98,7967.4,"王瑶瑶","马娜"]
[15,"22:06:00","鲁Q367AX","蒋武","冯英武",15190795555,"丁庆余",12884,"WIN0050174","石子","1-2#",76.32,18.8,57.52,{"$nulls":3},"良好",7,0.52,57,98,5586,"王瑶瑶","马娜"]
[16,"23:34:00","鲁QV8530","孙立","蒋学武",17772280398,"李海洋",12887,"WIN0050175","石子","1-2#",94.14,21.92,72.22,{"$nulls":3},"良好",7,0.52,71.7,98,7026.6,"王瑶瑶","马娜"]
[17,"23:50:00","鲁QV9022","孙立","谭海洋",18762069692,"李海洋",12888,"WIN0050175","石子","1-2#",102.9,24.08,78.82,{"$nulls":3},"良好",7,0.52,78.3,98,7673.4,"王瑶瑶","马娜"]
[18,"00:21:00","鲁Q718BZ","孙立","陈正旭",13852231207,"李海洋",12889,"WIN0050175","石子","1-2#",107.86,23.36,84.5,{"$nulls":3},"良好",7,0.5,84,98,8232,"王瑶瑶","马娜"]
[19,"00:44:00","苏CGP356","冯永清","马飞飞",13951463058,"李海洋",12890,"WIN0050172","机制砂","中粗砂",88.28,21.46,66.82,6,1.7,2.8,"Ⅱ区",null,1.42,65.4,122,7978.8,"王瑶瑶","马娜"]
[20,"00:46:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",12891,"WIN0050172","机制砂","中粗砂",88.74,21.64,67.1,6,1.7,2.8,"Ⅱ区",null,1.4,65.7,122,8015.4,"王瑶瑶","马娜"]
[21,"01:03:00","鲁Q836BG","戴春宇","吕伟",13952192088,"李海洋",12892,"WIN0050175","石子","1-2#",78.64,18.64,60,{"$nulls":3},"良好",7,0.5,59.5,98,5831,"王瑶瑶","马娜"]
[22,"01:14:00","鲁Q605BU","丁宝利","宋佳伦",15266695067,"丁宝利",12893,"WIN0050173","石子","1-2#",65.26,17.04,48.22,{"$nulls":3},"良好",7,0.52,47.7,98,4674.6,"王瑶瑶","马娜"]
[23,"02:20:00","鲁Q506BE","戴春宇","张胜",15105202990,"李海洋",12894,"WIN0050175","石子","1-2#",76.02,18.42,57.6,{"$nulls":3},"良好",7,0.5,57.1,98,5595.8,"王瑶瑶","马娜"]
[24,"02:57:00","苏CGD838","王浩","胡庆东",15062025252,"李海洋",12895,"WIN0050175","石子","1-2#",88.22,20.34,67.88,{"$nulls":3},"良好",7,0.58,67.3,98,6595.4,"王瑶瑶","马娜"]
[25,"03:02:00","鲁Q000AJ","王浩","曹天强",13357931887,"李海洋",12896,"WIN0050175","石子","1-2#",93.14,21.56,71.58,{"$nulls":3},"良好",7,0.58,71,98,6958,"王瑶瑶","马娜"]
[26,"03:16:00","鲁Q367AX","蒋武","冯英武",15190795555,"丁庆余",12897,"WIN0050174","石子","1-2#",78.64,18.8,59.84,{"$nulls":3},"良好",7,0.54,59.3,98,5811.4,"王瑶瑶","马娜"]
[27,"03:24:00","鲁Q956BY","王浩","臧齐",13505201115,"李海洋",12898,"WIN0050175","石子","1-2#",96.36,19.86,77.5,{"$nulls":3},"良好",7,0.91,76.5,98,7497,"王瑶瑶","马娜"]
[28,"04:27:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",12899,"WIN0050172","机制砂","中粗砂",91.76,21.8,69.96,8,1.8,2.8,"Ⅱ区",null,2.86,67.1,122,8186.2,"王瑶瑶","马娜"]
[29,"04:20:00","鲁Q323CD","冯永青","刘宝云",19806019316,"李海洋",12900,"WIN0050172","机制砂","中粗砂",93.2,23.12,70.08,8,1.8,2.8,"Ⅱ区",null,2.88,67.2,122,8198.4,"王瑶瑶","马娜"]
[30,"04:38:00","鲁QV8530","孙立","蒋学武",17772280398,"李海洋",12901,"WIN0050175","石子","1-2#",93.52,21.84,71.68,{"$nulls":3},"良好",7,0.58,71.1,98,6967.8,"王瑶瑶","马娜"]
[]
[]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N38)","v":2152.26},{"$nulls":6},{"$f":"SUM(U5:U38)","v":2127.8},null,{"$f":"SUM(W5:W38)","v":218592.4}]

{"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年 4 月 15 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:37:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","012982","石子","1--2",49.64,16.26,{"$f":"K5-L5","v":33.38},{"$nulls":5},"0.1T",33.2,97,{"$f":"T5*U5","v":3220.4},"冯海英","聂恒光"]
[2,"06:39:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","012983","石子","1--2",50.01,16.41,33.6,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[3,"09:14:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","012984","矿粉",null,70.64,70.64,0,{"$nulls":5},{"v":0.003,"d":"0.30%"},53.37,370,19746.9,"冯海英","聂恒光"]
[4,"12:36:00","鲁RF7132","陈长秋","刘洪涛",13695308751,"英良运输","012985","机制沙","中粗",48.17,15.13,33.04,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[5,"12:38:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","012986","石子","1--2",49.42,16.26,33.16,{"$nulls":5},"0.1T",33,97,3201,"冯海英","聂恒光"]
[6,"12:40:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","012987","石子","1--2",49.15,16.19,32.96,{"$nulls":5},"0.1T",32.8,97,3181.6,"冯海英","聂恒光"]
[7,"12:42:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","012988","机制沙","中粗",48.71,14.93,33.78,{"$nulls":5},"0.1T",33.6,139,4670.4,"冯海英","聂恒光"]
[8,"13:08:00","鲁RL7377","李斌","常云龙",18905404182,"李广坤","012989","石子","1--2",26.04,8.56,17.48,{"$nulls":5},"0.1T",17.3,97,1678.1,"冯海英","聂恒光"]
[9,"13:48:00","鲁RM5188","李斌","马增杰",15005402467,"李广坤","012990","石子","1--2",25.14,8.6,16.54,{"$nulls":5},"0.1T",16.4,97,1590.8,"冯海英","聂恒光"]
[10,"13:52:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","012991","机制沙","中粗",49.58,15.83,33.75,{"$nulls":5},"0.1T",33.6,139,4670.4,"冯海英","聂恒光"]
[11,"16:58:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","012992","机制沙","中粗",48.88,16.2,32.68,{"$nulls":5},"0.1T",32.5,139,4517.5,"冯海英","聂恒光"]
[12,"18:26:00","鲁RL3873","兰守玉","兰守玉",15376102612,"郑言克","012993","机制沙","中粗",49.36,15.54,33.82,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[13,"18:29:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","012994","石子","1--2",50.34,16.15,34.19,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[14,"18:31:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","012995","石子","1--2",49.61,16.1,33.51,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[15,"18:33:00","鲁RL7377","李斌","常云龙",18905404182,"李广坤","012996","石子","1--2",25.61,8.53,17.08,{"$nulls":5},"0.1T",16.9,97,1639.3,"冯海英","聂恒光"]
[16,"18:51:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","012997","机制沙","中粗",48.82,14.87,33.95,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[17,"19:35:00","鲁RM5188","李斌","马增杰",15005402467,"李广坤","012998","石子","1--2",25.68,5.56,20.12,{"$nulls":5},"0.2T",16.9,97,1639.3,"冯海英","聂恒光"]
[18,"19:46:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","012999","水泥","PO42.5",99.99,25.71,74.28,{"$nulls":5},{"v":0.003,"d":"0.30%"},73.93,53,3918.29,"冯海英","聂恒光"]
[19,"19:55:00","鲁RF7132","陈长秋","刘洪涛",13695308751,"英良运输","013000","机制沙","中粗",49.1,15.07,34.03,{"$nulls":5},"0.1T",33.9,139,4712.1,"冯海英","聂恒光"]
[20,"20:00:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013001","机制沙","中粗",49.11,15.82,33.29,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[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},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},{"$f":"T69*U69","v":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":86729.89}]

{"sheet":"连云港分公司","index":2,"n_rows":20,"n_cols":25,"rows_kept":20,"merged":[[0,0,0,24],[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 年 4 月15日                                填表人 张传迎、杜华军                                   "]
[null,"单位：江苏大力神管桩有限公司连云港分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含杂质%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"10:25:00","1569","姜志","王伟利",13675275287,"姜志",5425,"机制砂","中粗砂",39.94,9.92,30.02,9.4,4.8,2.8,"I",null,1.02,29,74,null,"杜华军","张传迎"]
[2,"17:50:00","0553","孙冲","张来高",13775439287,"孙冲",5426,"碎石","5~25",135.6,28.66,108.72,1.3,0.6,null,"I",{"v":0.09,"d":"9.0%"},1.72,107,90,null,"杜华军","张传迎"]
[3,"21:33:00","0553","孙冲","张来高",13775439287,"孙冲",5427,"碎石","5~25",136.92,27.16,109.76,1.2,0.6,null,"I",{"v":0.098,"d":"9.8%"},1.76,108,90,null,"杜华军","张传迎"]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15,{"$nulls":11},{"$f":"SUM(M5:M18)","v":248.5},{"$nulls":6},{"$f":"SUM(T5:T18)","v":244}]
[null,"备注：退货也登记，在备注中注明不合格退货，所有重量和单价、金额均以0标记"]