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

{"sheet":"巨野分公司","index":0,"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 月 4 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:49:00","鲁RN6981","黄国栋","黄国栋",13583034566,"英良运输","013524","机制沙","中粗",49.61,16.25,{"$f":"K5-L5","v":33.36},{"$nulls":5},"0.1T",33.25,139,{"$f":"T5*U5","v":4621.75},"冯海英","聂恒光"]
[2,"06:51:00","鲁RM7658","谢宏伟","谢宏伟",15106407336,"英良运输","013525","机制沙","中粗",49.75,16.5,33.25,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[3,"06:53:00","鲁R,1853","狄方丁","狄方丁",17661385222,"英良运输","013526","机制沙","中粗",48.88,15.45,33.43,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[4,{"$nulls":11},0,{"$nulls":8},0]
[5,{"$nulls":11},0,{"$nulls":8},0]
[6,{"$nulls":11},0,{"$nulls":8},0]
[7,{"$nulls":11},0,{"$nulls":8},0]
[8,{"$nulls":11},0,{"$nulls":8},0]
[9,{"$nulls":11},0,{"$nulls":8},0]
[10,{"$nulls":11},0,{"$nulls":8},0]
[11,{"$nulls":11},0,{"$nulls":8},0]
[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":8},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,{"$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":13851.35}]

{"sheet":"邳州分公司","index":1,"n_rows":21,"n_cols":26,"rows_kept":21,"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 月 4日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"07:41:00","苏C1T507","戴春宇","陈建辉",18751646723,"李海洋",13210,"WIN0050343","石子","1-2#",101.2,22.72,78.48,{"$nulls":3},"良好",7,1.08,77.4,98,{"$f":"U5*V5","v":7585.2},"陈金芳","李彤彤"]
[2,"08:22:00","鲁Q522BG","戴春宇","郑嘉磊",15862121767,"李海洋",13211,"WIN0050343","石子","1-2#",100.52,22.66,77.86,{"$nulls":3},"良好",7,1.06,76.8,98,7526.4,"陈金芳","李彤彤"]
[3,"08:44:00","鲁Q502BY","戴春宇","王各异",15152016113,"李海洋",13212,"WIN0050343","石子","1-2#",72.44,18.88,53.56,{"$nulls":3},"良好",7,1.06,52.5,98,5145,"李凤","李彤彤"]
[4,"15:07:00","苏CR8888","林磊","范振",18344886678,"丁庆余",13213,"WIN0050342","石子","1-2#",104.1,23.36,80.74,{"$nulls":3},"良好",7,1.54,79.2,98,7761.6,"李凤","李彤彤"]
[5,"15:11:00","鲁QV9028","林磊","周勇",15062019333,"丁庆余",13214,"WIN0050342","石子","1-2#",103.26,23.48,79.78,{"$nulls":3},"良好",7,1.28,78.5,98,7693,"李凤","李彤彤"]
[6,"15:14:00","苏C1T967","林磊","于雷",15062019333,"丁庆余",13215,"WIN0050342","石子","1-2#",105.04,23.18,81.86,{"$nulls":3},"良好",7,1.16,80.7,98,7908.6,"李凤","李彤彤"]
[7,"18:16:00","苏C1T507","戴春宇","陈建辉",18751646723,"李海洋",13216,"WIN0050343","石子","1-2#",103.86,22.78,81.08,{"$nulls":3},"良好",7,0.58,80.5,98,7889,"王瑶瑶","马娜"]
[8,"18:18:00","苏C1T837","戴春宇","吴云龙",15252222092,"李海洋",13217,"WIN0050343","石子","1-2#",104.36,22.74,81.62,{"$nulls":3},"良好",7,0.52,81.1,98,7947.8,"王瑶瑶","马娜"]
[9,"02:52:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13221,"WIN0050341","机制砂","中粗砂",96.84,21.38,75.46,7,1.8,2.9,"Ⅱ区",null,2.36,73.1,119,8698.9,"王瑶瑶","马娜"]
[10,"02:55:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13222,"WIN0050341","机制砂","中粗砂",95.46,23.34,72.12,7,1.8,2.9,"Ⅱ区",null,2.22,69.9,119,8318.1,"王瑶瑶","马娜"]
[]
[]
[]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N20)","v":762.56},{"$nulls":6},{"$f":"SUM(U5:U20)","v":749.7},null,{"$f":"SUM(W5:W20)","v":76473.6}]