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

{"sheet":"邳州公司","index":0,"n_rows":26,"n_cols":26,"rows_kept":26,"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],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8]]}
["收料登记表填报\n日期  ：2019 年 6 月 13 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"07:40:00","苏CHC216","汤霞","李民",15062056402,"丁庆余",14229,"WIN0050845","石子","1-5#",88.86,20.48,68.38,{"$nulls":3},"良好",7,1.08,67.3,93,{"$f":"U5*V5","v":6258.9},"刘会良","李彤彤"]
[2,"07:43:00","苏C1T978","陈建","汤海洋",17351967567,"丁庆余",14230,"WIN0050845","石子","1-5#",89.16,22.46,66.7,{"$nulls":3},"良好",7,1,65.7,93,6110.1,"刘会良","李彤彤"]
[3,"14:22:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",14231,"WIN0050848","石子","1-2#",95.58,22.58,73.08,{"$nulls":3},"良好",7,1.08,72,103,7416,"陈金芳","李彤彤"]
[4,"14:25:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",14232,"WIN0050848","石子","1-2#",100.84,23.22,77.62,{"$nulls":3},"良好",7,1.02,76.6,103,7889.8,"陈金芳","李彤彤"]
[5,"14:56:00","苏C1T978","陈建","汤海洋",17351967567,"丁庆余",14233,"WIN0050848","石子","1-2#",89.22,22.98,66.24,{"$nulls":3},"良好",7,1.04,65.2,103,6715.6,"陈金芳","李彤彤"]
[6,"14:58:00","苏CHC216","汤霞","李民",15062056402,"丁庆余",14234,"WIN0050848","石子","1-2#",90,20.62,69.38,{"$nulls":3},"良好",7,1.08,68.3,103,7034.9,"陈金芳","李彤彤"]
[7,"15:00:00","苏CBA768","余宝军","杨国强",15252221345,"丁庆余",14235,"WIN0050848","石子","1-2#",95.9,21.32,74.58,{"$nulls":3},"良好",7,1.08,73.5,103,7570.5,"陈金芳","李彤彤"]
[8,"15:13:00","苏C1T890","曹新镇","刘可",13914822209,"丁庆余",14236,"WIN0050848","石子","1-2#",93.24,22.9,70.34,{"$nulls":3},"良好",7,1.04,69.3,103,7137.9,"陈金芳","李彤彤"]
[9,"16:05:00","鲁Q522BG","戴春宇","魏辉",15252200168,"李海洋",14238,"WIN0050846","石子","1-2#",95.28,23.32,71.96,{"$nulls":3},"良好",7,1.06,70.9,103,7302.7,"陈金芳","李彤彤"]
[10,"17:23:00","鲁Q506BE","戴春宇","刘振华",15852066668,"段俊成",14239,"WIN0050844","石子","1-5#",66.68,18.9,47.78,{"$nulls":3},"良好",7,0.58,47.2,93,4389.6,"李思","李彤彤"]
[11,"17:27:00","鲁Q380BH","戴春宇","杨发展",15335127656,"李海洋",14240,"WIN0050846","石子","1-2#",63.78,18.46,45.32,{"$nulls":3},"良好",7,0.32,45,103,4635,"李思","杜娥"]
[12,"20:18:00","鲁Q718BZ","孙立","胡广发",18761484744,"李海洋",14243,"WIN0050846","石子","1-2#",96.44,23.32,73.12,{"$nulls":3},"良好",7,0.52,72.6,103,7477.8,"李思","杜娥"]
[13,"22:52:00","苏C9T292","庄尚","程宁",18751665165,"庄团结",14247,"WIN0050843","机制砂","中粗砂",72.42,18.7,53.72,9,2.9,2.9,"Ⅱ区",null,2.72,51,122,6222,"李思","杜娥","三车间"]
[14,"00:32:00","苏C2A277","高松钦","刘金良",18151292567,"庄团结",14248,"WIN0050843","机制砂","中粗砂",105.28,25.08,80.2,9,2.4,2.9,"Ⅱ区",null,4.1,76.1,122,9284.2,"李思","杜娥","三车间"]
[15,"00:37:00","苏C1T867","高松钦","李平",13775850031,"庄团结",14249,"WIN0050843","机制砂","中粗砂",104.64,25.52,79.12,9,2.4,2.9,"Ⅱ区",null,4.02,75.1,122,9162.2,"李思","杜娥","三车间"]
[16,"00:50:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",14250,"WIN0050848","石子","1-2#",102.56,23.06,79.5,{"$nulls":3},"良好",7,1,78.5,103,8085.5,"李思","杜娥","三车间"]
[17,"03:10:00","苏CGV338","汤可奇","宫东明",15563375779,"李海洋","司机要求退货",null,"机制砂","中粗砂",{"$nulls":13},"杜娥"]
[18,"03:15:00","苏CGS000","周桂霖","黄亿武",15062093139,"李海洋","司机要求退货",null,"机制砂","中粗砂",{"$nulls":13},"杜娥"]
[19,"03:19:00","鲁Q627AP","宫爱军","宫爱军",15253915869,"杨需","司机要求退货",null,"机制砂","中粗砂",{"$nulls":13},"杜娥"]
[20,"04:07:00","苏C2A698","高雷","高雷",13913462579,"庄团结","司机要求退货",null,"机制砂","中粗砂",{"$nulls":13},"杜娥"]
[21,"04:27:00","鲁Q636CQ","戴春宇","柳玉良",13775857003,"李海洋",14255,"WIN0050846","石子","1-2#",66.94,18.56,48.38,{"$nulls":3},"良好",7,0.58,47.8,103,{"$f":"U25*V25","v":4923.4},"李思","杜娥"]
[22,"05:35:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",14256,"WIN0050848","石子","1-2#",97.22,22.82,74.4,{"$nulls":3},"良好",7,1,73.4,103,{"$f":"U26*V26","v":7560.2},"李思","杜娥","三车间"]

{"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年 6 月 13 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"07:08:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","014301","水泥","PO42.5",99.48,25.91,{"$f":"K5-L5","v":73.57},{"$nulls":5},{"v":0.003,"d":"0.30%"},73.34,525,{"$f":"T5*U5","v":38503.5},"冯海英","聂恒光"]
[2,"07:12:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","014302","水泥","PO42.5",81.76,23.4,58.36,{"$nulls":5},{"v":0.003,"d":"0.30%"},58.18,525,30544.5,"冯海英","聂恒光"]
[3,"07:17:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014303","机制沙","中粗",49.37,16.08,33.29,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[4,"07:20:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014304","机制沙","中粗",51.7,15.93,35.77,{"$nulls":5},"0.1T",35.6,139,4948.4,"冯海英","聂恒光"]
[5,"07:42:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","014305","石子","1--2",49.81,15.58,34.23,{"$nulls":5},"0.1T",34.1,103,3512.3,"冯海英","聂恒光"]
[6,"09:35:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","014306","石子","1--2",49.84,15.11,34.73,{"$nulls":5},"0.2T",34.5,103,3553.5,"冯海英","聂恒光"]
[7,"10:44:00","鲁RL6563","孔祥安","孔祥安",15053072937,"李广坤","014307","机制沙","中粗",50.46,15.69,34.77,{"$nulls":5},"0.1T",34.6,139,4809.4,"冯海英","聂恒光"]
[8,"10:46:00","鲁RB9133","孔令哲","闫昭",15554092111,"李广坤","014308","机制沙","中粗",51.4,16.17,35.23,{"$nulls":5},"0.4T",34.8,139,4837.2,"冯海英","聂恒光"]
[9,"12:12:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014309","石子","1--2",49.72,16.01,33.71,{"$nulls":5},"0.1T",33.6,103,3460.8,"冯海英","聂恒光"]
[10,"12:50:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏","014310","矿粉",null,70.11,null,70.11,{"$nulls":8},0,"冯海英","聂恒光"]
[11,"15:07:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014311","石子","1--2",50.63,15.77,34.86,{"$nulls":5},"0.1T",34.7,103,3574.1,"冯海英","聂恒光"]
[12,"15:09:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","014312","石子","1--2",49.33,15.05,34.28,{"$nulls":5},"0.1T",34.1,103,3512.3,"冯海英","聂恒光"]
[13,"15:51:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014313","石子","1--2",49.52,15.98,33.54,{"$nulls":5},"0.1T",33.4,103,3440.2,"冯海英","聂恒光"]
[14,"16:57:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","014314","石子","1--2",49.68,15.52,34.16,{"$nulls":5},"0.1T",34,103,3502,"冯海英","聂恒光"]
[15,"17:53:00","鲁RB9133","孔令哲","闫昭",15554092111,"李广坤","014315","机制沙","中粗",50.36,16.07,34.29,{"$nulls":5},"0.1T",34.1,139,4739.9,"冯海英","聂恒光"]
[16,"17:55:00","鲁RL6563","孔祥安","孔祥安",15053072937,"李广坤","014316","机制沙","中粗",50.08,15.66,34.42,{"$nulls":5},"0.1T",34.3,139,4767.7,"冯海英","聂恒光"]
[17,"20:05:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014317","石子","1--2",49.84,15.71,34.13,{"$nulls":5},"0.1T",34,103,3502,"冯海英","聂恒光"]
[18,"20:07:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014318","石子","1--2",49.08,15.92,33.16,{"$nulls":5},"0.1T",33,103,3399,"冯海英","聂恒光"]
[19,"21:36:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014319","石子","1--2",49.67,16.53,33.14,{"$nulls":3},".",null,"0.1T",33,103,3399,"冯海英","聂恒光"]
[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":132606.7}]