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

{"sheet":"邳州公司","index":0,"n_rows":36,"n_cols":26,"rows_kept":36,"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 年 6 月 24日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"07:08:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余","退货","退货","石子","1-2#",{"$nulls":6},"含片石、页岩",{"$nulls":5},"刘会良","马娜","含片石、页岩，退货"]
[2,"07:11:00","苏CJW885","陈建","任士威",18352212987,"丁庆余","退货","退货","石子","1-2#",{"$nulls":6},"含片石、页岩",{"$nulls":5},"刘会良","马娜","含片石、页岩，退货"]
[3,"07:32:00","鲁Q000AJ","王浩","曹天强",15312655333,"李海洋",14514,"WIN0051013","石子","1-2#",97.92,23.2,74.72,{"$nulls":3},"含风化石",8,2.02,72.7,103,{"$f":"U7*V7","v":7488.1},"刘会良","马娜"]
[4,"07:44:00","鲁Q956BY","王浩","耿超",18018475777,"李海洋",14515,"WIN0051013","石子","1-2#",91.82,18.6,72.68,{"$nulls":3},"含风化石",8,2.08,70.6,103,7271.8,"刘会良","马娜"]
[5,"07:47:00","鲁Q522BG","戴春宇","郑嘉雷",15862121767,"李海洋",14516,"WIN0051013","石子","1-2#",96.74,22.92,73.82,{"$nulls":3},"含风化石",8,2.02,71.8,103,7395.4,"刘会良","马娜"]
[6,"13:40:00","鲁QV8991","孙立","韩洪吉",15195483119,"李海洋",14518,"WIN0051013","石子","1-2#",94.06,23.8,70.26,{"$nulls":3},"良好",7,0.56,69.7,103,7179.1,"李凤","马娜"]
[7,"13:43:00","鲁QV8855","韩榆","韩榆",15162001555,"李海洋",14519,"WIN0051013","石子","1-2#",96.56,23.86,72.7,{"$nulls":3},"良好",7,0.5,72.2,103,7436.6,"李凤","马娜"]
[8,"13:48:00","鲁Q506BE","戴春宇","刘振华",15852066668,"李海洋",14520,"WIN0051013","石子","1-2#",67.48,18.66,48.82,{"$nulls":3},"良好",7,0.52,48.3,103,4974.9,"李凤","马娜"]
[9,"13:50:00","鲁Q187BP","戴春宇","冯康",13585365885,"李海洋",14521,"WIN0051013","石子","1-2#",84.66,18.84,65.82,{"$nulls":3},"良好",7,0.52,65.3,103,6725.9,"李凤","马娜"]
[10,"14:03:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",14522,"WIN0051014","石子","1-2#",90.62,22.66,67.96,{"$nulls":3},"良好",7,0.56,67.4,103,6942.2,"李凤","马娜"]
[11,"14:10:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",14523,"WIN0051014","石子","1-2#",101.6,22.2,79.4,{"$nulls":3},"良好",7,0.5,78.9,103,8126.7,"李凤","马娜"]
[12,"18:19:00","鲁QV8991","孙立","韩洪吉",15195483119,"李海洋",14525,"WIN0051013","石子","1-2#",98.96,23.58,75.38,{"$nulls":3},"良好",7,0.58,74.8,103,7704.4,"冯忠华","李彤彤"]
[13,"18:21:00","鲁QV8855","韩榆","韩榆",15162001555,"李海洋",14526,"WIN0051013","石子","1-2#",97.74,23.7,74.04,{"$nulls":3},"良好",7,1.04,73,103,7519,"冯忠华","李彤彤"]
[14,"19:08:00","苏CJW038","马传霞","李全民",13805221610,"李海洋",14527,"WIN0051011","机制砂","中粗砂",67.62,20.3,47.32,7,2.4,2.9,"Ⅱ区",null,1.02,46.3,125,5787.5,"冯忠华","李彤彤"]
[15,"19:24:00","鲁QV8018","戴春宇","李勇",18052254999,"李海洋",14528,"WIN0051011","石子","1-2#",94.16,23.56,70.6,{"$nulls":3},"良好",7,1,69.6,103,7168.8,"冯忠华","李彤彤"]
[16,"19:43:00","鲁Q522BG","戴春宇","郑嘉雷",15862121767,"段俊成",14529,"WIN0051015","石子","1-5#",85.8,22.7,63.1,{"$nulls":3},"良好",7,0.5,62.6,103,6447.8,"冯忠华","李彤彤"]
[17,"21:10:00","鲁Q197BF","韩红","韩飞",18305228333,"李海洋",14531,"WIN0051013","石子","1-2#",59.64,18.12,41.52,{"$nulls":3},"良好",7,0.52,41,103,4223,"冯忠华","李彤彤"]
[18,"21:16:00","鲁Q673AX","戴春宇","闫志强",15885219275,"李海洋",14532,"WIN0051013","石子","1-2#",65.68,18.36,47.32,{"$nulls":3},"良好",7,0.52,46.8,103,4820.4,"冯忠华","李彤彤"]
[19,"23:23:00","鲁QV8991","孙立","韩洪吉",15195483119,"李海洋",14534,"WIN0051013","石子","1-2#",99.3,23.26,76.04,{"$nulls":3},"良好",7,1.04,75,103,7725,"冯忠华","李彤彤"]
[20,"23:25:00","鲁QV8855","韩榆","韩榆",15162001555,"李海洋",14535,"WIN0051013","石子","1-2#",98.98,23.36,75.62,{"$nulls":3},"良好",7,0.52,75.1,103,7735.3,"冯忠华","李彤彤"]
[21,"23:55:00","鲁Q956BY","王浩","耿超",18018475777,"李海洋","退货.未卸","退货.未卸","石子","1-2#",{"$nulls":6},"风化石较多",{"$nulls":3},103,0,"冯忠华","李彤彤","风化石较多，退货"]
[22,"23:58:00","鲁Q000AJ","王浩","曹天强",15312655333,"李海洋","退货.未卸","退货.未卸","石子","1-2#",{"$nulls":6},"风化石较多",{"$nulls":3},103,0,"冯忠华","李彤彤","风化石较多，退货"]
[23,"00:01:00","苏CGD838","王浩","张玉",13626150626,"李海洋","退货.未卸","退货.未卸","石子","1-2#",{"$nulls":6},"风化石较多",{"$nulls":3},103,0,"冯忠华","李彤彤","风化石较多，退货"]
[24,"03:14:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",14541,"WIN0051014","石子","1-2#",91.38,22.08,69.3,{"$nulls":3},"良好",7,2,67.3,103,6931.9,"冯忠华","李彤彤"]
[25,"03:54:00","鲁QV8991","孙立","韩洪吉",15195483119,"李海洋",14542,"WIN0051013","石子","1-2#",97.5,23.14,74.36,{"$nulls":3},"良好",7,1.56,72.8,103,7498.4,"冯忠华","李彤彤"]
[26,"03:58:00","鲁QV8855","孙立","韩榆",15162001555,"李海洋",14543,"WIN0051013","石子","1-2#",103.62,23.3,80.32,{"$nulls":3},"良好",7,1.52,78.8,103,8116.4,"冯忠华","李彤彤"]
[27,"04:01:00","苏CJV338","汤可希","宫东明",15563375779,"李海洋",14544,"WIN0051011","机制砂","中粗砂",99.2,21.26,77.94,8,2.1,2.9,"Ⅱ区",null,0.94,77,125,9625,"冯忠华","李彤彤"]
[28,"04:04:00","苏CGS000","周桂霖","黄亿武",15062093139,"庄团结",14545,"WIN0051010","机制砂","中粗砂",97.04,21.82,75.22,8,2.1,2.9,"Ⅱ区",null,1.22,74,125,9250,"冯忠华","李彤彤"]
[29,"05:25:00","苏CGR299","陈鹏","陈鹏",18651776110,"刘保安","退货.未卸","退货.未卸","机制砂","中粗砂",{"$nulls":4},3.2,{"$nulls":6},0,"冯忠华","李彤彤","含泥量超标，退货"]
[30,"05:26:00","苏CHU637","薛牛","冀北全",19825911080,"刘保安","退货.未卸","退货.未卸","机制砂","中粗砂",{"$nulls":4},3.2,{"$nulls":6},0,"冯忠华","李彤彤","含泥量超标，退货"]
[31,"05:30:00","鲁Q235AK","吴迪","吴迪",15952103855,"刘保安","退货.未卸","退货.未卸","机制砂","中粗砂",{"$nulls":4},3.2,{"$nulls":6},0,"冯忠华","李彤彤","含泥量超标，退货"]
["合计",{"$nulls":12},{"$f":"SUM(N5:N35)","v":1574.26},{"$nulls":5},{"$f":"SUM(T5:T35)","v":23.26},{"$f":"SUM(U5:U35)","v":1551},null,{"$f":"SUM(W5:W35)","v":164093.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年 6 月 24 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:34:00","鲁RN9829","米强栋","米强栋",18953005713,"英良运输","014592","石子","1--2",49.97,16.22,{"$f":"K5-L5","v":33.75},{"$nulls":5},"0.1T",33.6,103,{"$f":"T5*U5","v":3460.8},"冯海英","聂恒光"]
[2,"06:36:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014593","石子","1--2",49.88,16.05,33.83,{"$nulls":5},"0.1T",33.7,103,3471.1,"冯海英","聂恒光"]
[3,"06:38:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014594","石子","1--2",49.94,16.09,33.85,{"$nulls":5},"0.1T",33.7,103,3471.1,"冯海英","聂恒光"]
[4,"06:52:00","鲁RL9770","赵磊","张振",18905303343,"郑言克","014595","石子","1--2",49.81,16.13,33.68,{"$nulls":5},"0.1T",33.5,103,3450.5,"冯海英","聂恒光"]
[5,"06:54:00","鲁RN0686","张军","付长友",17753088776,"郑言克","014596","石子","1--2",50.53,15.63,34.9,{"$nulls":5},"0.1T",34.8,103,3584.4,"冯海英","聂恒光"]
[6,"07:26:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","014597","石子","1--2",30.32,8.46,21.86,{"$nulls":5},"0.2T",21.6,103,2224.8,"冯海英","聂恒光"]
[7,"07:28:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014598","石子","1--2",30.84,8.49,22.35,{"$nulls":5},"0.2T",22.1,103,2276.3,"冯海英","聂恒光"]
[8,"07:36:00","鲁H56A96A","刘文权","李海旭",15554446520,"刘文权","014599","钢棒","&10.7",50.19,36.19,14,{"$nulls":6},14,null,0,"冯海英","聂恒光"]
[9,"07:51:00","鲁JB2331","王磊","王恩军",18653677018,"郑言克","014600","石子","1--2",49.42,14.84,34.58,{"$nulls":5},"0.1T",34.4,103,3543.2,"冯海英","聂恒光"]
[10,"08:30:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","014601","石子","1--2",50.06,15.37,34.69,{"$nulls":5},"0.1T",34.5,103,3553.5,"冯海英","聂恒光"]
[11,"10:02:00","鲁RM8082","安春峰","安春峰",18761504770,"李广坤","014602","石子","1--2",52.16,15.99,36.17,{"$nulls":5},"0.1T",36,103,3708,"冯海英","聂恒光"]
[12,"10:04:00","鲁RL7377","李斌","李广远",18264007774,"李广坤","014603","石子","1--2",28.23,8.48,19.75,{"$nulls":5},"0.1T",19.6,103,2018.8,"冯海英","聂恒光"]
[13,"10:06:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","014604","石子","1--2",50.04,15.68,34.36,{"$nulls":5},"0.1T",34.2,103,3522.6,"冯海英","聂恒光"]
[14,"10:08:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","014605","石子","1--2",51.62,16.11,35.51,{"$nulls":5},"0.1T",35.9,103,3697.7,"冯海英","聂恒光"]
[15,"10:10:00","鲁H87H87","张庆刚","张庆刚",17564290789,"郑言克","014606","石子","1--2",52.56,15.56,37,{"$nulls":5},"0.1T",36.9,103,3800.7,"冯海英","聂恒光"]
[16,"10:12:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","014607","石子","1--2",51.01,16.68,34.33,{"$nulls":5},"0.1T",34.2,103,3522.6,"冯海英","聂恒光"]
[17,"10:16:00","鲁H56A96A","刘文权","李海旭",15554446520,"刘文权","014608","钢棒","&9.0",36.19,16.44,19.75,{"$nulls":6},19.75,null,0,"冯海英","聂恒光"]
[18,"12:11:00","鲁H56A96A","刘文权","李海旭",15554446520,"刘文权","014609","离心机轴",null,16.44,14.97,1.47,{"$nulls":6},1.47,null,0,"冯海英","聂恒光"]
[19,"14:15:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","014610","石子","1--2",49.66,15.31,34.35,{"$nulls":3},".",null,"0.1T",34.2,103,3522.6,"冯海英","聂恒光"]
[20,"14:19:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","014611","石子","1--2",60.45,8.42,52.03,{"$nulls":5},"0.4T",21.6,103,2224.8,"冯海英","聂恒光"]
[21,"14:51:00","鲁JB2331","王磊","王恩军",18653677018,"郑言克","014612","石子","1--2",49.22,14.76,34.46,{"$nulls":5},"0.1T",34.3,103,3532.9,"冯海英","聂恒光"]
[22,"14:53:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014613","石子","1--2",28.81,8.57,20.24,{"$nulls":5},"0.1T",20.1,103,2070.3,"冯海英","聂恒光"]
[23,"14:57:00","鲁RM6829","付镇利","付镇利",13176057614,"郑言克","014614","石子","1--2",49.96,15.94,34.02,{"$nulls":5},"0.1T",33.9,103,3491.7,"冯海英","聂恒光"]
[24,"15:02:00","鲁RL9770","赵磊","张振",18905303343,"郑言克","014615","石子","1--2",50.15,16.06,34.09,{"$nulls":5},"0.1T",33.9,103,3491.7,"冯海英","聂恒光"]
[25,"15:05:00","鲁RN0686","张军","付长友",17753088776,"郑言克","014616","石子","1--2",49.26,15.6,33.66,{"$nulls":5},"0.1T",33.5,103,3450.5,"冯海英","聂恒光"]
[26,"15:07:00","鲁RL5667","付长兵","付兴伦",18369021213,"郑言克","014617","石子","1--2",49.47,15.51,33.96,{"$nulls":5},"0.1T",33.8,103,3481.4,"冯海英","聂恒光"]
[27,"15:33:00","鲁RN9829","魏祥远","魏祥远",15854038599,"英良运输","014618","石子","1--2",48.93,16.17,32.76,{"$nulls":5},"0.1T",32.6,103,3357.8,"冯海英","聂恒光"]
[28,"15:35:00","鲁RL7377","李斌","李广远",18264007774,"李广坤","014619","石子","1--2",27.13,8.54,18.59,{"$nulls":5},"0.1T",18.4,103,1895.2,"冯海英","聂恒光"]
[29,"15:56:00","鲁HQN895","李建文","李建文",18765042818,"孙雷","014620","端板",null,32.44,15.77,16.67,{"$nulls":6},16.67,null,0,"冯海英","聂恒光"]
[30,"16:51:00","鲁RH8090","赵海洋","赵海洋",18053055550,"郑言克","014621","石子","1--2",49.7,15.65,34.05,{"$nulls":5},"0.1T",33.9,103,3491.7,"冯海英","聂恒光"]
[31,"17:00:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","014622","石子","1--2",49.45,16.06,33.39,{"$nulls":5},"0.1T",33.2,103,3419.6,"冯海英","聂恒光"]
[32,"17:04:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","014623","石子","1--2",50.12,16.02,34.1,{"$nulls":5},"0.1T",34,103,3502,"冯海英","聂恒光"]
[33,"17:06:00","鲁RM8082","安春峰","安春峰",18761504770,"李广坤","014624","石子","1--2",50.95,16.1,34.85,{"$nulls":5},"0.2T",34.6,103,3563.8,"冯海英","聂恒光"]
[34,"17:31:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014625","石子","1--2",50.35,16,34.35,{"$nulls":5},"0.1T",34.2,103,3522.6,"冯海英","聂恒光"]
[35,"18:47:00","鲁RA6191","宗伟","宗伟",17705401586,"郑言克","014626","石子","1--2",46.49,14.45,32.04,{"$nulls":5},"0.1T",31.9,103,3285.7,"冯海英","聂恒光"]
[36,"18:49:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014627","石子","1--2",49.31,16.68,32.63,{"$nulls":5},"0.1T",32.5,103,3347.5,"冯海英","聂恒光"]
[37,"18:52:00","鲁RM7809","张福兵","张福兵",15054016160,"英良运输","014628","石子","1--2",49.64,16.2,33.44,{"$nulls":5},"0.1T",33.3,103,3429.9,"冯海英","聂恒光"]
[38,"18:54:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","014629","石子","1--2",49.52,16.47,33.05,{"$nulls":5},"0.1T",32.9,103,3388.7,"冯海英","聂恒光"]
[39,"18:56:00","鲁RL9469","付宁","付宁",15666910999,"英良运输","014630","机制沙","中粗",50.77,15.65,35.12,{"$nulls":5},"0.1T",35,139,4865,"冯海英","聂恒光"]
[40,"18:58:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","014631","石子","1--2",49.99,15.12,34.87,{"$nulls":5},"0.1T",34.7,103,3574.1,"冯海英","聂恒光"]
[41,"19:31:00","鲁H87H87","张庆刚","张庆刚",17564290789,"郑言克","014632","石子","1--2",51.61,15.9,35.71,{"$nulls":5},"0.1T",35.6,103,3666.8,"冯海英","聂恒光"]
[42,"19:58:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","014633","水泥","PO42.5",99.62,25.99,73.63,{"$nulls":5},{"v":0.003,"d":"0.30%"},73.4,525,38535,"冯海英","聂恒光"]
[43,"20:00:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","014634","水泥","PO42.5",82.71,23.52,59.19,{"$nulls":5},{"v":0.003,"d":"0.30%"},59,525,30975,"冯海英","聂恒光"]
[44,"20:11:00","鲁RN9829","魏祥远","魏祥远",15854038599,"英良运输","014635","石子","1--2",50.01,16.12,33.89,{"$nulls":5},"0.1T",33.7,103,3471.1,"冯海英","聂恒光"]
[45,"20:51:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","014636","石子","1--2",49.5,15.99,33.51,{"$nulls":5},"0.1T",33.4,103,3440.2,"冯海英","聂恒光"]
[46,"21:26:00","鲁RM6829","付镇利","付镇利",13176057614,"郑言克","014637","石子","1--2",49.79,15.87,33.92,{"$nulls":5},"0.1T",33.8,103,3481.4,"冯海英","聂恒光"]
[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":202785.1}]