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

{"sheet":"邳州公司","index":0,"n_rows":18,"n_cols":26,"rows_kept":18,"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 月 24日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"07:49:00","鲁QV8855","孙立","王瑞永",15905222525,"李海洋",13638,"WIN0050606","石子","1-2#",101.4,23.3,78.1,{"$nulls":3},"良好",7,0.5,77.6,105,{"$f":"U5*V5","v":8148},"冯忠华","李彤彤"]
[2,"07:53:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13639,"WIN0050606","石子","1-2#",100.4,23.5,76.9,{"$nulls":3},"良好",7,0.5,76.4,105,8022,"冯忠华","李彤彤"]
[3,"12:04:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13627,"WIN0050606","石子","1-2#",99.8,23.62,76.18,{"$nulls":3},"良好",7,0.58,75.6,105,7938,"陈金芳","李彤彤"]
[4,"13:38:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",13641,"WIN0050605","石子","1-2#",103.7,22.78,80.92,{"$nulls":3},"良好",8,1.02,79.9,105,8389.5,"陈金芳","李彤彤"]
[5,"13:43:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",13642,"WIN0050605","石子","1-2#",92.58,23.18,69.4,{"$nulls":3},"良好",8,1,68.4,105,7182,"陈金芳","李彤彤"]
[6,"14:14:00","鲁QV9022","孙立","孙继龙",13775868277,"李海洋",13643,"WIN0050606","石子","1-2#",108.14,23.88,84.26,{"$nulls":3},"含石粉多",8,2.06,82.2,105,8631,"陈金芳","李彤彤"]
[7,"23:18:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13647,"WIN0050606","石子","1-2#",98.54,23.7,74.84,{"$nulls":3},"良好",7,0.54,74.3,105,7801.5,"李思","马娜"]
[8,"23:30:00","苏CGV338","高雷","李城市",13913462579,"李海洋",13648,"WIN0050604","机制砂","中粗砂",87.92,21.52,66.4,7,1.8,2.9,"Ⅱ区",null,2,64.4,122,7856.8,"李思","马娜"]
[9,"04:21:00","苏CJW885","陈建","袁维",18018460333,"丁庆余",13650,"WIN0050605","石子","1-2#",104.26,22.78,81.48,{"$nulls":3},"良好",8,1.08,80.4,105,8442,"李思","马娜"]
[10,"04:36:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",13651,"WIN0050605","石子","1-2#",105.38,23.16,82.22,{"$nulls":3},"良好",8,1.02,81.2,105,8526,"李思","马娜"]
[11,"04:43:00","苏CHC216","汤霞","李民",15062056402,"丁庆余",13652,"WIN0050605","石子","1-2#",103.58,20.48,83.1,{"$nulls":3},"良好",8,1,82.1,105,8620.5,"李思","马娜"]
[12,"04:46:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",13653,"WIN0050605","石子","1-2#",95.52,22.32,73.2,{"$nulls":3},"良好",8,1,72.2,105,7581,"李思","马娜"]
[13,"06:15:00","鲁Q718BZ","陈磊","胡光发",18761484744,"李海洋",13654,"WIN0050606","石子","1-2#",103.9,22.96,80.94,{"$nulls":3},"良好",8,1.04,79.9,105,8389.5,"李思","马娜"]
["合计",{"$nulls":12},{"$f":"SUM(N5:N17)","v":1007.94},{"$nulls":6},{"$f":"SUM(U5:U17)","v":994.6},null,{"$f":"SUM(W5:W17)","v":105527.8}]

{"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 月 24 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:16:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013950","水泥","PO42.5",98.79,26.01,{"$f":"K5-L5","v":72.78},{"$nulls":5},{"v":0.003,"d":"0.30%"},72.56,535,{"$f":"T5*U5","v":38819.6},"冯海英","聂恒光"]
[2,"06:21:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013951","水泥","PO42.5",98.97,25.88,73.09,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.87,535,38985.45,"冯海英","聂恒光"]
[3,"08:57:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013952","石子","1--2",26.72,8.5,18.22,{"$nulls":5},"0.2T",18,97,1746,"冯海英","聂恒光"]
[4,"09:38:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013953","石子","1--2",28.81,8.46,20.35,{"$nulls":5},"0.2T",20.1,97,1949.7,"冯海英","聂恒光"]
[5,"13:26:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013955","机制沙","中粗",49.93,16.06,33.87,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[6,"13:31:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013956","机制沙","中粗",49.57,16.27,33.3,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[7,"15:32:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013957","石子","1--2",26.33,8.54,17.79,{"$nulls":5},"1T",16.7,97,1619.9,"冯海英","聂恒光"]
[8,"15:34:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013958","石子","1--2",28.54,8.47,20.07,{"$nulls":5},"0.2T",19.8,97,1920.6,"冯海英","聂恒光"]
[9,"15:58:00","鲁RB1266","李红江","李红江",15266991988,"莱芜延辉","013959","减水剂",null,32.82,14.37,18.45,{"$nulls":6},18.33,1900,34827,"冯海英","聂恒光"]
[10,"18:22:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","013960","机制沙","中粗",49.53,16.92,32.61,{"$nulls":5},"0.1T",32.5,139,4517.5,"冯海英","聂恒光"]
[11,"22:50:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013961","机制沙","中粗",49.31,15.94,33.37,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[12,"22:52:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013962","机制沙","中粗",49.23,16.19,33.04,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[13,{"$nulls":11},0,{"$nulls":8},0]
[14,{"$nulls":11},0,{"$nulls":8},0]
[15,{"$nulls":11},0,{"$nulls":8},0]
[16,{"$nulls":11},0,{"$nulls":8},0]
[17,{"$nulls":11},0,{"$nulls":8},0]
[18,{"$nulls":11},0,{"$nulls":8},0]
[19,{"$nulls":11},0,{"$nulls":3},".",{"$nulls":4},0]
[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]
[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":142872.75}]