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

{"sheet":"邳州分公司","index":0,"n_rows":15,"n_cols":26,"rows_kept":15,"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 月 28 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"20:46:00","鲁Q582by","陈大伟","陈大伟",15852102259,"丁庆余",13157,"WIN0050305","石子","1-2#",73.86,18.24,55.62,{"$nulls":3},"良好",7,1.02,54.6,98,{"$f":"V5*U5","v":5350.8},"杨家辉","马娜"]
[2,"20:49:00","鲁Q185BD","戴春宇","李宋",18052166101,"丁庆余",13158,"WIN0050305","石子","1-2#",77.24,18.92,58.32,{"$nulls":3},"良好",7,1.02,57.3,98,5615.4,"杨家辉","马娜"]
[3,"01:39:00","鲁Q582by","陈大伟","陈大伟",15852102259,"丁庆余",13160,"WIN0050305","石子","1-2#",75.62,18,57.62,{"$nulls":3},"良好",7,1.02,56.6,98,5546.8,"杨家辉","马娜"]
[4,"01:42:00","鲁Q185BD","戴春宇","李宋",18052166101,"丁庆余",13161,"WIN0050305","石子","1-2#",79.82,18.9,60.92,{"$nulls":3},"良好",7,1.02,59.9,98,5870.2,"杨家辉","马娜"]
[5,"07:02:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",13162,"WIN0050304","石子","1-2#",103.92,22.96,80.96,{"$nulls":3},"良好",7,1.06,79.9,98,7830.2,"杨家辉","马娜"]
[]
[]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N14)","v":313.44},{"$nulls":6},{"$f":"SUM(U5:U14)","v":308.3},null,{"$f":"SUM(W5:W14)","v":30213.4}]

{"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 月 28 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:13:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013430","矿粉",null,71.24,17.18,{"$f":"K5-L5","v":54.06},{"$nulls":5},{"v":0.003,"d":"0.30%"},53.9,370,{"$f":"T5*U5","v":19943},"冯海英","聂恒光"]
[2,"06:27:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013431","石子","1--2",48.89,15.94,32.95,{"$nulls":5},"0.1T",32.8,97,3181.6,"冯海英","聂恒光"]
[3,"06:29:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013432","石子","1--2",50.82,16.17,34.65,{"$nulls":5},"0.1T",34.5,97,3346.5,"冯海英","聂恒光"]
[4,"06:36:00","鲁H56H26","李福军","杨金喜",18264782088,"巨野中联","013433","水泥","PO42.5",48.92,14.83,34.09,{"$nulls":5},{"v":0.003,"d":"0.30%"},33.98,535,18179.3,"冯海英","聂恒光"]
[5,"06:40:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013434","机制沙","中粗",48.94,15.87,33.07,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[6,"06:42:00","鲁RM3845","陈长秋","张先会",15990979156,"英良运输","013435","机制沙","中粗",49.37,15.1,34.27,{"$nulls":5},"0.1T",34.1,139,4739.9,"冯海英","聂恒光"]
[7,"08:10:00","鲁p02674","陈广华","陈广华",18963511210,"陈广华","013436","端板",null,46.91,31.13,15.78,{"$nulls":6},15.78,null,0,"冯海英","聂恒光"]
[8,"08:45:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013437","石子","1--2",26.69,8.69,18,{"$nulls":5},"03T",17.7,97,1716.9,"冯海英","聂恒光"]
[9,"08:47:00","鲁RL7377","李斌","王帅",18264007774,"李广坤","013438","石子","1--2",26.56,8.59,17.97,{"$nulls":5},"0.3T",17.6,97,1707.2,"冯海英","聂恒光"]
[10,"09:48:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013439","石子","1--2",49.56,15.87,33.69,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[11,"09:50:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013440","石子","1--2",48.89,15.84,33.05,{"$nulls":5},"0.2T",32.8,97,3181.6,"冯海英","聂恒光"]
[12,"09:52:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013441","石子","1--2",49.16,15.81,33.35,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[13,"09:55:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013442","石子","1--2",49.64,15.59,34.05,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[14,"10:28:00","鲁p02674","陈广华","陈广华",18963511210,"陈广华","013443","端板",null,31.13,15.48,15.65,{"$nulls":6},15.65,null,0,"冯海英","聂恒光"]
[15,"10:43:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013444","石子","1--2",50.23,15.84,34.39,{"$nulls":5},"0.2T",34.1,97,3307.7,"冯海英","聂恒光"]
[16,"10:45:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013445","石子","1--2",49.55,16.08,33.47,{"$nulls":5},"0.2T",33.2,97,3220.4,"冯海英","聂恒光"]
[17,"14:09:00","鲁RC0500","刘兴华","刘兴华",18888387393,"巨野中联","013446","水泥","PO42.5",49.26,18.37,30.89,{"$nulls":5},{"v":0.003,"d":"0.30%"},30.8,535,16478,"冯海英","聂恒光"]
[18,"14:37:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013447","石子","1--2",26.61,8.65,17.96,{"$nulls":5},"0.2T",17.7,97,1716.9,"冯海英","聂恒光"]
[19,"14:39:00","鲁RL7377","李斌","王帅",18264007774,"李广坤","013448","石子","1--2",26.08,8.67,17.41,{"$nulls":5},"0.2T",17.2,97,1668.4,"冯海英","聂恒光"]
[20,"16:59:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013449","石子","1--2",49.79,15.53,34.26,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[21,"17:35:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013450","石子","1--2",49.56,16.03,33.53,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[22,"17:37:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013451","石子","1--2",48.98,15.77,33.21,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[23,"19:20:00","鲁HD2956","金中","金中",18953750035,"巨野中联","013452","水泥","PO42.5",46.78,16.26,30.52,{"$nulls":5},{"v":0.003,"d":"0.30%"},30.4,535,16264,"冯海英","聂恒光"]
[24,"19:24:00","鲁H06B17","曹建民","曹建民",15553722662,"巨野中联","013453","水泥","PO42.5",49.46,17.76,31.7,{"$nulls":5},{"v":0.003,"d":"0.30%"},31.6,535,16906,"冯海英","聂恒光"]
[25,"19:37:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013454","机制沙","中粗",48.48,15.97,32.51,{"$nulls":5},"0.1T",32.4,139,4503.6,"冯海英","聂恒光"]
[26,"19:40:00","鲁RM3845","陈长秋","张先会",15990979156,"英良运输","013455","机制沙","中粗",48.08,15.01,33.07,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[27,"20:54:00","鲁RC0500","刘兴华","刘兴华",18888387393,"巨野中联","013456","水泥","PO42.5",51.02,18.33,32.69,{"$nulls":5},{"v":0.003,"d":"0.30%"},32.59,535,17435.65,"冯海英","聂恒光"]
[28,"21:34:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013457","石子","1--2",49.35,15.98,33.37,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[29,"21:36:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013458","石子","1--2",49.55,15.72,33.83,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[30,"22:11:00","鲁H60G85","王照青","史国庆",1756213845,"巨野中联","013459","水泥","PO42.5",48.8,16.44,32.36,{"$nulls":5},{"v":0.003,"d":"0.30%"},32.26,535,17259.1,"冯海英","聂恒光"]
[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":189907.65}]