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

{"sheet":"邳州公司","index":0,"n_rows":17,"n_cols":26,"rows_kept":17,"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 月 12 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"13:11:00","鲁Q718BZ","孙立","胡广发",18761484744,"李海洋",14212,"WIN0050825","石子","1-2#",90.62,23.34,67.28,{"$nulls":3},"良好",7,0.58,66.7,103,{"$f":"U5*V5","v":6870.1},"刘会良","李彤彤"]
[2,"14:02:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",14214,"WIN0050827","石子","1-5#",100.68,22.92,77.76,{"$nulls":3},"良好",7,1.56,76.2,93,7086.6,"刘会良","李彤彤"]
[3,"19:17:00","鲁Q718BZ","孙立","戴广明",13813277728,"李海洋",14215,"WIN0050825","石子","1-2#",95.18,23.28,71.9,{"$nulls":3},"良好",7,1,70.9,103,7302.7,"王瑶瑶","杜娥"]
[4,"21:01:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",14217,"WIN0050826","石子","1-2#",102.44,22.68,79.76,{"$nulls":3},"良好",7,1.06,78.7,103,8106.1,"王瑶瑶","杜娥"]
[5,"21:02:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",14219,"WIN0050826","石子","1-2#",98.16,22.4,75.76,{"$nulls":3},"良好",7,1.06,74.7,103,7694.1,"王瑶瑶","杜娥"]
[6,"21:31:00","鲁Q673AX","戴春宇","闫志强",15885219275,"李海洋",14222,"WIN0050825","石子","1-2#",60.38,18.22,42.16,{"$nulls":3},"良好",7,0.36,41.8,103,4305.4,"王瑶瑶","杜娥"]
[7,"01:07:00","鲁Q902AJ","陈建","冯凯歌",18352221875,"丁庆余",14225,"WIN0050826","石子","1-2#",76.52,19.48,57.04,{"$nulls":3},"良好",7,0.54,56.5,103,5819.5,"王瑶瑶","杜娥"]
[8,"05:45:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",14226,"WIN0050827","石子","1-5#",85.32,22.48,62.84,{"$nulls":3},"良好",7,1.04,61.8,93,5747.4,"王瑶瑶","杜娥"]
[9,"06:28:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",14227,"WIN0050826","石子","1-2#",104.38,22.54,81.84,{"$nulls":3},"良好",7,1.04,80.8,103,8322.4,"王瑶瑶","杜娥"]
[10,"06:31:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",14228,"WIN0050826","石子","1-2#",102.18,22.26,79.92,{"$nulls":3},"良好",7,1.02,78.9,103,8126.7,"王瑶瑶","杜娥"]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N16)","v":696.26},{"$nulls":5},{"$f":"SUM(T5:T16)","v":9.26},{"$f":"SUM(U5:U16)","v":687},null,{"$f":"SUM(W5:W16)","v":69381}]

{"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 月 12 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"07:18:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014290","机制沙","中粗",51.22,16.18,{"$f":"K5-L5","v":35.04},{"$nulls":5},"0.1T",34.9,139,{"$f":"T5*U5","v":4851.1},"冯海英","聂恒光"]
[2,"07:34:00","鲁JB2331","王磊","王磊",18653677018,"郑言克","014291","石子","1--2",49.39,14.78,34.61,{"$nulls":5},"0.1T",34.5,97,3346.5,"冯海英","聂恒光"]
[3,"10:38:00","鲁JA4773","王双喜","王勇",18954064499,"郑言克","014292","石子","1--2",49.19,14.45,34.74,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[4,"10:40:00","鲁RB9133","孔令哲","闫昭",15554092111,"李广坤","014293","机制沙","中粗",49.83,16.11,33.72,{"$nulls":5},"0.1T",33.6,139,4670.4,"冯海英","聂恒光"]
[5,"10:47:00","鲁RL6563","孔祥安","孔祥安",15053072937,"李广坤","014294","机制沙","中粗",50.59,15.66,34.93,{"$nulls":5},"0.1T",34.8,139,4837.2,"冯海英","聂恒光"]
[6,"13:19:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014295","机制沙","中粗",49.88,15.89,33.99,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[7,"13:21:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014296","机制沙","中粗",48.96,16.07,32.89,{"$nulls":5},"0.1T",32.7,139,4545.3,"冯海英","聂恒光"]
[8,"18:12:00","鲁RL6563","孔祥安","孔祥安",15053072937,"李广坤","014297","机制沙","中粗",49.47,15.79,33.68,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[9,"18:15:00","鲁RB9133","孔令哲","闫昭",15554092111,"李广坤","014298","机制沙","中粗",50.68,16.2,34.48,{"$nulls":5},"0.1T",34.3,139,4767.7,"冯海英","聂恒光"]
[10,"18:36:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014299","机制沙","中粗",50.56,16.01,34.55,{"$nulls":5},"0.1T",34.4,139,4781.6,"冯海英","聂恒光"]
[11,"18:38:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014300","机制沙","中粗",49.73,15.83,33.9,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[12,{"$nulls":11},0,{"$nulls":8},0]
[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":5},"0.40T",null,null,0]
[23,{"$nulls":11},0,{"$nulls":5},"0.41T",null,null,0]
[24,{"$nulls":11},0,{"$nulls":5},"0.42T",null,null,0]
[25,{"$nulls":11},0,{"$nulls":5},"0.43T",null,null,0]
[26,{"$nulls":11},0,{"$nulls":5},"0.44T",null,null,0]
[27,{"$nulls":11},0,{"$nulls":5},"0.45T",null,null,0]
[28,{"$nulls":11},0,{"$nulls":5},"0.46T",null,null,0]
[29,{"$nulls":11},0,{"$nulls":5},"0.47T",null,null,0]
[30,{"$nulls":11},0,{"$nulls":5},"0.48T",null,null,0]
[31,{"$nulls":11},0,{"$nulls":5},"0.49T",null,null,0]
[32,{"$nulls":11},0,{"$nulls":5},"0.50T",null,null,0]
[33,{"$nulls":11},0,{"$nulls":5},"0.51T",null,null,0]
[34,{"$nulls":11},0,{"$nulls":5},"0.52T",null,null,0]
[35,{"$nulls":11},0,{"$nulls":5},"0.53T",null,null,0]
[36,{"$nulls":11},0,{"$nulls":5},"0.54T",null,null,0]
[37,{"$nulls":11},0,{"$nulls":5},"0.55T",null,null,0]
[38,{"$nulls":11},0,{"$nulls":5},"0.56T",null,null,0]
[39,{"$nulls":11},0,{"$nulls":5},"0.57T",null,null,0]
[40,{"$nulls":11},0,{"$nulls":5},"0.58T",null,null,0]
[41,{"$nulls":11},0,{"$nulls":5},"0.59T",null,null,0]
[42,{"$nulls":11},0,{"$nulls":5},"0.60T",null,null,{"$f":"T46*U46","v":0}]
[43,{"$nulls":11},0,{"$nulls":5},"0.61T",null,null,0]
[44,{"$nulls":11},0,{"$nulls":5},"0.62T",null,null,0]
[45,{"$nulls":11},0,{"$nulls":5},"0.63T",null,null,0]
[46,{"$nulls":11},0,{"$nulls":5},"0.64T",null,null,0]
[47,{"$nulls":11},0,{"$nulls":5},"0.65T",null,null,0]
[48,{"$nulls":11},0,{"$nulls":5},"0.66T",null,null,0]
[49,{"$nulls":11},0,{"$nulls":5},"0.67T",null,null,0]
[50,{"$nulls":11},0,{"$nulls":5},"0.68T",null,null,0]
[51,{"$nulls":11},0,{"$nulls":5},"0.69T",null,null,0]
[52,{"$nulls":11},0,{"$nulls":5},"0.70T",null,null,0]
[53,{"$nulls":11},0,{"$nulls":5},"0.71T",null,null,0]
[54,{"$nulls":11},0,{"$nulls":5},"0.72T",null,null,0]
[55,{"$nulls":11},0,{"$nulls":5},"0.73T",null,null,0]
[56,{"$nulls":11},0,{"$nulls":5},"0.74T",null,null,0]
[57,{"$nulls":11},0,{"$nulls":5},"0.75T",null,null,0]
[58,{"$nulls":11},0,{"$nulls":5},"0.76T",null,null,0]
[59,{"$nulls":11},0,{"$nulls":5},"0.77T",null,null,0]
[60,{"$nulls":11},0,{"$nulls":5},"0.78T",null,null,0]
[61,{"$nulls":11},0,{"$nulls":5},"0.79T",null,null,0]
[62,{"$nulls":11},0,{"$nulls":5},"0.80T",null,null,0]
[63,{"$nulls":11},0,{"$nulls":5},"0.81T",null,null,0]
[64,{"$nulls":11},0,{"$nulls":5},"0.82T",null,null,0]
[65,{"$nulls":11},{"$f":"K69-L69","v":0},{"$nulls":5},"0.83T",null,null,0]
[66,{"$nulls":11},0,{"$nulls":5},"0.84T",null,null,0]
[67,{"$nulls":11},0,{"$nulls":5},"0.85T",null,null,0]
[68,{"$nulls":11},0,{"$nulls":5},"0.86T",null,null,0]
["合计：",{"$nulls":18},0,null,{"$f":"SUM(V5:V72)","v":49208.9}]