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

{"sheet":"邳州公司","index":0,"n_rows":22,"n_cols":26,"rows_kept":22,"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 月 15日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"20:23:00","鲁Q515BZ","冯波","郭方猛",13813273822,"段俊成",13461,"WIN0050511","石子","1-5#",109.56,26.8,82.76,{"$nulls":3},"良好",7,1.06,81.7,95,{"$f":"U5*V5","v":7761.5},"杨家辉","马娜"]
[2,"20:46:00","苏CGQ817","陈建","黄海波",18114797999,"丁庆余",13463,"WIN0050513","石子","1-2#",111.74,22.66,89.08,{"$nulls":3},"良好",7,1.08,88,100,8800,"杨家辉","马娜"]
[3,"20:48:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",13464,"WIN0050513","石子","1-2#",102.14,23.1,79.04,{"$nulls":3},"良好",7,1.04,78,100,7800,"杨家辉","马娜"]
[4,"20:50:00","苏CJW885","陈建","任士威",18352212987,"丁庆余",13465,"WIN0050513","石子","1-2#",103.12,23.02,80.1,{"$nulls":3},"良好",7,1,79.1,100,7910,"杨家辉","马娜"]
[5,"22:18:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13468,"WIN0050510","机制砂","中粗砂",90.26,21.54,68.72,8,2,2.9,"Ⅱ区",null,2.82,65.9,119,7842.1,"杨家辉","马娜"]
[6,"22:20:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13469,"WIN0050510","机制砂","中粗砂",90.42,21.54,68.88,8,2,2.9,"Ⅱ区",null,2.78,66.1,119,7865.9,"杨家辉","马娜"]
[7,"22:20:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13470,"WIN0050510","机制砂","中粗砂",88.58,21.66,66.92,8,2,2.9,"Ⅱ区",null,2.72,64.2,119,7639.8,"杨家辉","马娜"]
[8,"02:40:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13472,"WIN0050510","机制砂","中粗砂",93.3,23.3,70,10,2,2.9,"Ⅱ区",null,4.2,65.8,119,7830.2,"杨家辉","马娜"]
[9,"04:02:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13473,"WIN0050510","机制砂","中粗砂",95.34,21.32,74.02,9,2.4,2.9,"Ⅱ区",null,3.72,70.3,119,8365.7,"杨家辉","马娜"]
[10,"04:05:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13474,"WIN0050510","机制砂","中粗砂",92,21.48,70.52,9,2.4,2.9,"Ⅱ区",null,3.62,66.9,119,7961.1,"杨家辉","马娜"]
[11,"04:07:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13475,"WIN0050510","机制砂","中粗砂",98.82,21.48,77.34,9,2.4,2.9,"Ⅱ区",null,3.94,73.4,119,8734.6,"杨家辉","马娜"]
[12,"04:08:00","苏CGV338","高雷","李城市",13913462579,"庄团结",13476,"WIN0050509","机制砂","中粗砂",91.5,21.52,69.98,7,1.8,2.9,"Ⅱ区",null,2.18,67.8,119,8068.2,"杨家辉","马娜"]
[13,"04:11:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",13477,"WIN0050509","机制砂","中粗砂",92.82,22.58,70.24,7,1.8,2.9,"Ⅱ区",null,2.14,68.1,119,8103.9,"杨家辉","马娜"]
[14,"04:14:00","苏CGS000","周桂林","刘宝云",18906019310,"庄团结",13478,"WIN0050509","机制砂","中粗砂",90.82,21.92,68.9,7,1.8,2.9,"Ⅱ区",null,2.1,66.8,119,7949.2,"杨家辉","马娜"]
[15,"04:16:00","苏C2A698","高雷","高雷",13913462579,"庄团结",13479,"WIN0050509","机制砂","中粗砂",111.66,29.34,82.32,7,1.8,2.9,"Ⅱ区",null,2.52,79.8,119,9496.2,"杨家辉","马娜"]
[16,"04:46:00","鲁Q718BG","陈雷","孙明",1806714006,"李海洋",13480,"WIN0050512","石子","1-2#",106.04,23.36,82.68,{"$nulls":3},"良好",7,1.08,81.6,100,8160,"杨家辉","马娜"]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N21)","v":1201.5},{"$nulls":6},{"$f":"SUM(U5:U21)","v":1163.5},null,{"$f":"SUM(W5:W21)","v":130288.4}]

{"sheet":"巨野分公司","index":1,"n_rows":62,"n_cols":25,"rows_kept":62,"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 月 15 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:42:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013778","石子","1--2",50.79,16.05,{"$f":"K5-L5","v":34.74},{"$nulls":5},"0.1T",34.6,97,{"$f":"T5*U5","v":3356.2},"冯海英","聂恒光"]
[2,"06:44:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013779","石子","1--2",52.44,16.14,36.3,{"$nulls":5},"0.1T",36.2,97,3511.4,"冯海英","聂恒光"]
[3,"06:47:00","鲁RJ5036","孙永海","郭胜全",13395406029,"孙永海","013780","钢棒","&10.7",49.27,14.25,35.02,{"$nulls":5},{"v":0.003,"d":"0.30%"},35.02,null,0,"冯海英","聂恒光"]
[4,"08:34:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013781","石子","1--2",26.89,8.46,18.43,{"$nulls":5},"0.8T",17.6,97,1707.2,"冯海英","聂恒光"]
[5,"08:36:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013782","石子","1--2",27.13,8.58,18.55,{"$nulls":5},"0.8T",17.7,97,1716.9,"冯海英","聂恒光"]
[6,"09:12:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013783","石子","1--2",51.02,15.01,36.01,{"$nulls":5},"0.8T",35.2,97,3414.4,"冯海英","聂恒光"]
[7,"13:00:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013784","机制沙","中粗",49.24,16.07,33.17,{"$nulls":5},"0.2T",32.9,139,4573.1,"冯海英","聂恒光"]
[8,"13:02:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013785","机制沙","中粗",50.78,16.18,34.6,{"$nulls":5},"0.2T",34.5,139,4795.5,"冯海英","聂恒光"]
[9,"15:41:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013786","石子","1--2",27.67,8.56,19.11,{"$nulls":5},"0.2T",18.9,97,1833.3,"冯海英","聂恒光"]
[10,"16:30:00","鲁RK0329","陈长秋","张华洗",15615708910,"英良运输","013787","机制沙","中粗",49.5,15.43,34.07,{"$nulls":5},"0.2T",33.8,139,4698.2,"冯海英","聂恒光"]
[11,"16:32:00","鲁RM3845","陈长秋","张先会",15990979156,"英良运输","013788","机制沙","中粗",48.64,14.93,33.71,{"$nulls":5},"0.1T",33.6,139,4670.4,"冯海英","聂恒光"]
[12,"16:34:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013789","机制沙","中粗",45.9,13.94,31.96,{"$nulls":5},"0.1T",31.8,139,4420.2,"冯海英","聂恒光"]
[13,"16:44:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013790","石子","1--2",28.08,8.55,19.53,{"$nulls":5},"0.3T",19.2,97,1862.4,"冯海英","聂恒光"]
[14,"17:14:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013791","石子","1--2",50.01,16.24,33.77,{"$nulls":5},"0.2T",33.5,97,3249.5,"冯海英","聂恒光"]
[15,"16:16:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013792","石子","1--2",49.47,16.05,33.42,{"$nulls":5},"0.2T",33.2,97,3220.4,"冯海英","聂恒光"]
[16,"20:14:00","鲁RM7658","谢洪涛","谢洪涛",15106407336,"英良运输","013793","机制沙","中粗",48.29,16.54,31.75,{"$nulls":5},"0.1T",31.6,139,4392.4,"冯海英","聂恒光"]
[17,"20:16:00","鲁RM1853","狄方丁","狄方丁",17661385222,"英良运输","013794","机制沙","中粗",48.6,15.61,32.99,{"$nulls":5},"0.1T",32.8,139,4559.2,"冯海英","聂恒光"]
[18,"20:18:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","013795","机制沙","中粗",48.62,16.14,32.48,{"$nulls":5},"0.1T",32.3,139,4489.7,"冯海英","聂恒光"]
[19,"20:21:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013796","水泥","PO42.5",98.69,null,98.69,{"$nulls":5},{"v":0.003,"d":"0.30%"},null,null,0,"冯海英","聂恒光","转16号"]
[20,"20:24:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013797","水泥","PO42.5",99.51,26.03,73.48,{"$nulls":5},{"v":0.003,"d":"0.30%"},73.26,535,39194.1,"冯海英","聂恒光"]
[21,"21:47:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013798","石子","1--2",51.13,16.2,34.93,{"$nulls":5},"0.1T",34.8,97,3375.6,"冯海英","聂恒光"]
[22,"21:57:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013799","石子","1--2",49.6,16,33.6,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[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":"T35*U35","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},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:V61)","v":106289.6}]