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

{"sheet":"邳州分公司","index":0,"n_rows":12,"n_cols":26,"rows_kept":12,"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 年 4 月 29 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"14:40:00","鲁QV8954","孙立","刘东起",13921762980,"李海洋",13167,"WIN0050313","石子","1-2#",102.36,23.6,{"$f":"L5-M5","v":78.76},{"$nulls":3},"良好",7,1.06,{"$f":"N5-T5","v":77.7},98,{"$f":"U5*V5","v":7614.6},"陈金芳","马娜"]
[2,"17:27:00","鲁QV8530","孙立","蒋学武",17772280398,"李海洋",13171,"WIN0050313","石子","1-2#",97.02,22.44,74.58,{"$nulls":3},"良好",7,1.08,73.5,98,{"$f":"U6*V6","v":7203},"杨家辉","马娜"]
[3,"17:38:00","鲁QV8991","孙立","江万磊",13913466223,"李海洋",13172,"WIN0050313","石子","1-2#",101.18,23.24,77.94,{"$nulls":3},"良好",7,1.04,76.9,98,{"$f":"U7*V7","v":7536.2},"杨家辉","马娜"]
[4,"23:46:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",13175,"WIN0050313","石子","1-2#",106.76,23.46,83.3,{"$nulls":3},"良好",7,1,82.3,98,{"$f":"U8*V8","v":8065.4},"杨家辉","马娜"]
[5,"05:18:00","鲁Q562BG","魏辉","魏辉",15252200168,"丁庆余",13176,"WIN0050312","石子","1-2#",101.36,22.68,78.68,{"$nulls":3},"含石粉、碎石",8,2.08,76.6,98,{"$f":"U9*V9","v":7506.8},"杨家辉","马娜"]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N11)","v":393.26},{"$nulls":6},{"$f":"SUM(U5:U11)","v":387},null,{"$f":"SUM(W5:W11)","v":37926}]

{"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年 4 月 29 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:00:00","鲁H56H26","李福军","杨金喜",18264782088,"巨野中联","013460","水泥","PO42.5",48.65,15.04,{"$f":"K5-L5","v":33.61},{"$nulls":5},{"v":0.003,"d":"0.30%"},33.5,535,{"$f":"T5*U5","v":17922.5},"冯海英","聂恒光"]
[2,"06:35:00","鲁RM2138","刘德法","刘起平",13395408996,"刘德法","013461","钢棒","&9.0",50.56,15.81,34.75,{"$nulls":6},34.73,4860,168787.8,"冯海英","聂恒光"]
[3,"06:38:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013462","石子","1--2",49.11,16.19,32.92,{"$nulls":5},"0.1T",32.8,97,3181.6,"冯海英","聂恒光"]
[4,"06:40:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013463","石子","1--2",50.39,16.04,34.35,{"$nulls":5},"0.1T",34.2,97,3317.4,"冯海英","聂恒光"]
[5,"09:24:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013464","石子","1--2",27.01,8.62,18.39,{"$nulls":5},"0.2T",18.1,97,1755.7,"冯海英","聂恒光"]
[6,"09:26:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013465","石子","1--2",26.32,8.63,17.69,{"$nulls":5},"0.2T",17.4,97,1687.8,"冯海英","聂恒光"]
[7,"09:48:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013466","石子","1--2",49.56,15.47,34.09,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[8,"10:40:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013467","石子","1--2",50.23,15.99,34.24,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[9,"10:52:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013468","石子","1--2",49.01,16.15,32.86,{"$nulls":5},"0.1T",32.7,97,3171.9,"冯海英","聂恒光"]
[10,"12:07:00","鲁JA4773","王双喜","王恩军",18653677018,"郑言克","013469","石子","1--2",49.32,14.42,34.9,{"$nulls":5},"0.1T",34.8,97,3375.6,"冯海英","聂恒光"]
[11,"15:55:00","鲁H27A96","李福军","任修杰",15063781383,"巨野中联","013470","水泥","PO42.5",49.33,14.92,34.41,{"$nulls":5},{"v":0.003,"d":"0.30%"},34.3,535,18350.5,"冯海英","聂恒光"]
[12,"15:59:00","鲁H9J293","李金中","黄继勋",13753789226,"巨野中联","013471","水泥","PO42.5",46.82,18.33,28.49,{"$nulls":5},{"v":0.003,"d":"0.30%"},28.39,535,15188.65,"冯海英","聂恒光"]
[13,"16:04:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013472","石子","1--2",49.26,14.62,34.64,{"$nulls":5},"0.1T",34.5,97,3346.5,"冯海英","聂恒光"]
[14,"16:07:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013473","石子","1--2",49.71,16.08,33.63,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[15,"16:09:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013474","石子","1--2",48.79,15.43,33.36,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[16,"16:13:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013475","石子","1--2",27.08,8.68,18.4,{"$nulls":5},"0.1T",18.3,97,1775.1,"冯海英","聂恒光"]
[17,"16:15:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013476","石子","1--2",26.41,8.59,17.82,{"$nulls":5},"0.1T",17.7,97,1716.9,"冯海英","聂恒光"]
[18,"16:17:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013477","石子","1--2",49.52,15.95,33.57,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[19,"20:11:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013478","石子","1--2",49.42,16.04,33.38,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[20,"21:37:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013479","石子","1--2",50.37,15.9,34.47,{"$nulls":5},"0.1T",34.3,97,3327.1,"冯海英","聂恒光"]
[21,"22:14:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013480","机制沙","中粗",48.68,16.31,32.37,{"$nulls":5},"0.1T",32.2,139,4475.8,"冯海英","聂恒光"]
[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":270906.95}]