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

{"sheet":"邳州公司","index":0,"n_rows":30,"n_cols":26,"rows_kept":30,"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 月 28 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"08:58:00","苏CHC216","汤霞","李民",15062056402,"丁庆余",13742,"WIN0050648","石子","1-2#",101.24,20.38,80.86,{"$nulls":3},"良好",8,1.06,79.8,105,{"$f":"U5*V5","v":8379},"李凤","李彤彤"]
[2,"09:06:00","鲁Q902AJ","陈建","冯海格",18352221875,"丁庆余",13743,"WIN0050648","石子","1-2#",82.64,19.24,63.4,{"$nulls":3},"良好",8,1,62.4,105,6552,"李凤","李彤彤"]
[3,"09:10:00","苏CBA768","余宝军","杨国强",15252221345,"丁庆余",13744,"WIN0050648","石子","1-2#",104.86,21.96,82.9,{"$nulls":3},"良好",8,1,81.9,105,8599.5,"李凤","李彤彤"]
[4,"09:15:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",13745,"WIN0050648","石子","1-2#",112.66,22.48,90.18,{"$nulls":3},"良好",8,1.08,89.1,105,9355.5,"李凤","李彤彤"]
[5,"12:18:00","鲁QV8018","孙立","彭杰",13775839508,"李海洋",13747,"WIN0050647","石子","1-2#",104.32,24.12,80.2,{"$nulls":3},"良好",8,1,79.2,105,8316,"陈金芳","李彤彤"]
[6,"12:20:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13748,"WIN0050647","石子","1-2#",101.1,23.2,77.9,{"$nulls":3},"良好",8,1,76.9,105,8074.5,"陈金芳","李彤彤"]
[7,"13:32:00","苏CGQ817","陈建","刘德诚",18114660609,"丁庆余","退货",null,"石子","1-2#",{"$nulls":6},"表面粘黄泥、含页岩、片石",{"$nulls":5},"陈金芳","李彤彤","表面粘黄泥、含页岩、片石，退货"]
[8,"13:35:00","苏C1T817","陈建","王小龙",18852223688,"丁庆余","退货",null,"石子","1-2#",{"$nulls":6},"表面粘黄泥、含页岩、片石",{"$nulls":5},"陈金芳","李彤彤","表面粘黄泥、含页岩、片石，退货"]
[9,"16:43:00","苏CBA768","余宝军","杨国强",15252221345,"丁庆余",13753,"WIN0050648","石子","1-2#",109.42,22.2,87.22,{"$nulls":3},"良好",8,1.02,86.2,105,{"$f":"U13*V13","v":9051},"陈金芳","李彤彤"]
[10,"19:01:00","苏CGV338","高雷","李城市",13913462579,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":4},2.8,{"$nulls":7},"李思","马娜","含泥量超标，退货"]
[11,"19:15:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13756,"WIN0050647","石子","1-2#",99.06,23.84,75.22,{"$nulls":3},"良好",8,1.02,74.2,105,7791,"李思","马娜"]
[12,"19:23:00","苏C2A698","高雷","高雷",13913462579,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":4},2.8,{"$nulls":7},"李思","马娜","含泥量超标，退货"]
[13,"19:23:00","鲁Q827AM","张福宝","胡庆中",15062025252,"李海洋",13758,"WIN0050647","石子","1-2#",85.9,20.44,65.46,{"$nulls":3},"良好",8,1.06,64.4,105,6762,"李思","马娜"]
[14,"19:29:00","鲁Q515BZ","冯波","滕勇",15852109399,"李海洋",13759,"WIN0050647","石子","1-2#",97.9,26.72,71.18,{"$nulls":3},"良好",8,1.08,70.1,105,7360.5,"李思","马娜"]
[15,"00:47:00","鲁QV8018","孙立","彭杰",13775839508,"李海洋",13763,"WIN0050647","石子","1-2#",103.94,24.02,79.92,{"$nulls":3},"良好",8,0.52,79.4,105,8337,"李思","马娜"]
[16,"03:12:00","鲁Q515BZ","冯波","滕勇",15852109399,"李海洋",13764,"WIN0050647","石子","1-2#",109.78,26.62,83.16,{"$nulls":3},"良好",8,1.06,82.1,105,8620.5,"李思","马娜"]
[17,"03:38:00","苏CGQ817","陈建","刘德诚",18114660609,"丁庆余",13765,"WIN0050648","石子","1-2#",101.68,22.34,79.34,{"$nulls":3},"良好",8,1.04,78.3,105,8221.5,"李思","马娜"]
[18,"03:40:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13766,"WIN0050647","石子","1-2#",99.86,23.8,76.06,{"$nulls":3},"良好",8,0.56,75.5,105,7927.5,"李思","马娜"]
[19,"03:44:00","苏CHC216","汤霞","李民",15062056402,"丁庆余",13767,"WIN0050648","石子","1-2#",97.14,20.48,76.66,{"$nulls":3},"良好",8,1.06,75.6,105,7938,"李思","马娜"]
[20,"03:46:00","苏C1T817","陈建","王小龙",18852223688,"丁庆余",13768,"WIN0050648","石子","1-2#",96.28,22.9,73.38,{"$nulls":3},"良好",8,1.08,72.3,105,7591.5,"李思","马娜"]
[21,"03:48:00","苏CBA768","余宝军","杨国强",15252221345,"丁庆余",13769,"WIN0050648","石子","1-2#",104.2,22.12,82.08,{"$nulls":3},"良好",8,1.08,81,105,8505,"李思","马娜"]
[22,"06:49:00","鲁QV8018","孙立","彭杰",13775839508,"李海洋",13770,"WIN0050647","石子","1-2#",104.38,24.32,80.06,{"$nulls":3},"良好",8,0.56,79.5,105,8347.5,"李思","马娜"]
[]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N29)","v":1405.18},{"$nulls":6},{"$f":"SUM(U5:U29)","v":1387.9},null,{"$f":"SUM(W5:W29)","v":145729.5}]

{"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 月 28 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"05:58:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","014012","水泥","PO42.5",98.12,26.01,{"$f":"K5-L5","v":72.11},{"$nulls":5},{"v":0.003,"d":"0.30%"},71.9,535,{"$f":"T5*U5","v":38466.5},"冯海英","聂恒光"]
[2,"06:01:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","014013","水泥","PO42.5",98.73,26.12,72.61,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.4,535,38734,"冯海英","聂恒光"]
[3,"06:19:00","鲁RJ5036","孙永海","郭胜全",13395406029,"孙永海","014014","钢棒","&10.7",49.13,14.27,34.86,{"$nulls":6},34.86,null,0,"冯海英","聂恒光"]
[4,"06:44:00","鲁RN9829","米强栋","米强栋",18953005713,"英良运输","014015","机制沙","中粗",50.31,16.24,34.07,{"$nulls":5},"0.1T",33.9,139,4712.1,"冯海英","聂恒光"]
[5,"06:46:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","014016","石子","1--2",29.27,8.39,20.88,{"$nulls":5},"0.5T",20.29,97,1968.13,"冯海英","聂恒光"]
[6,"06:47:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","014017","机制沙","中粗",50.93,16.16,34.77,{"$nulls":5},"0.1T",34.6,139,4809.4,"冯海英","聂恒光"]
[7,"10:20:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","014018","机制沙","中粗",50.07,16.44,33.63,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[8,"10:22:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014019","机制沙","中粗",49.49,16.7,32.79,{"$nulls":5},"0.1T",32.6,139,4531.4,"冯海英","聂恒光"]
[9,"12:51:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014020","石子","1--2",26.8,8.48,18.32,{"$nulls":5},"0.5T",17.8,97,1726.6,"冯海英","聂恒光"]
[10,"12:53:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","014021","石子","1--2",26.53,8.44,18.09,{"$nulls":5},"0.5T",17.5,97,1697.5,"冯海英","聂恒光"]
[11,"13:37:00","鲁USW969","宁存良","宁存良",13954052758,"宁存良","014022","端板",null,35.79,16.21,19.58,{"$nulls":6},19.58,null,0,"冯海英","聂恒光"]
[12,"13:50:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","014023","机制沙","中粗",49.62,16.03,33.59,{"$nulls":5},"0.1T",33.4,139,4642.6,"冯海英","聂恒光"]
[13,"13:52:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","014024","机制沙","中粗",48.69,16.13,32.56,{"$nulls":5},"0.1T",32.4,139,4503.6,"冯海英","聂恒光"]
[14,"14:00:00","鲁RJ2828","张德国","张德国",15552028908,"张德国","014025","端板",null,31.78,15.97,15.81,{"$nulls":6},15.81,null,0,"冯海英","聂恒光"]
[15,"16:44:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014026","机制沙","中粗",49.79,16.6,33.19,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[16,"16:47:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","014027","机制沙","中粗",49.88,16.38,33.5,{"$nulls":5},"0.1T",33.4,139,4642.6,"冯海英","聂恒光"]
[17,"17:47:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","014028","石子","1--2",27.65,8.6,19.05,{"$nulls":5},"0.1T",18.9,97,1833.3,"冯海英","聂恒光"]
[18,"17:57:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014029","石子","1--2",27.76,8.45,19.31,{"$nulls":5},"0.1T",19.2,97,1862.4,"冯海英","聂恒光"]
[19,"19:48:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","014030","机制沙","中粗",49.33,16,33.33,{"$nulls":3},".",null,"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[20,"19:50:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","014031","机制沙","中粗",49.44,16.13,33.31,{"$nulls":5},"0.1T",33.2,139,4614.8]
[21,{"$nulls":11},0,{"$nulls":8},0]
[22,{"$nulls":11},0,{"$nulls":8},0]
[23,{"$nulls":11},0]
[24,{"$nulls":11},0,{"$nulls":8},{"$f":"T28*U28","v":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":132603.23}]