{"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 年 5 月 8 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"07:16:00","苏CGD838","王浩","张玉",13626150626,"李海洋",13318,"WIN0050429","石子","1-2#",91.86,20.32,71.54,{"$nulls":3},"含碎石",8,2.04,69.5,98,{"$f":"V5*U5","v":6811},"陈金芳","马娜"]
[2,"17:49:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13321,"WIN0050429","石子","1-2#",105.96,23.86,82.1,{"$nulls":3},"良好",7,2,80.1,98,7849.8,"王瑶瑶","马娜"]
[3,"20:11:00","鲁Q956BY","王正方","杜祥波",15162009688,"李海洋",13322,"WIN0050429","石子","1-2#",94.74,19.24,75.5,{"$nulls":3},"良好",7,1,74.5,98,7301,"王瑶瑶","马娜"]
[4,"20:36:00","苏CGD838","王浩","张玉",13626150626,"李海洋",13325,"WIN0050429","石子","1-2#",89.72,20.22,69.5,{"$nulls":3},"良好",7,1,68.5,98,6713,"王瑶瑶","马娜"]
[5,"23:01:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13326,"WIN0050428","机制砂","中粗砂",95.82,21.36,74.46,7,1.6,2.9,"Ⅱ区",null,2.26,72.2,119,8591.8,"王瑶瑶","马娜"]
[6,"23:05:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13327,"WIN0050428","机制砂","中粗砂",98.7,21.86,76.84,7,1.6,2.9,"Ⅱ区",null,2.34,74.5,119,8865.5,"王瑶瑶","马娜"]
[7,"23:07:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13328,"WIN0050428","机制砂","中粗砂",98.64,21.6,77.04,7,1.6,2.9,"Ⅱ区",null,2.34,74.7,119,8889.3,"王瑶瑶","马娜"]
[8,"23:11:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13329,"WIN0050428","机制砂","中粗砂",96.74,23.6,73.14,7,1.6,2.9,"Ⅱ区",null,2.24,70.9,119,8437.1,"王瑶瑶","马娜"]
[9,"00:57:00","鲁QV9022","孙立","谭海洋",18762206092,"李海洋",13332,"WIN0050429","石子","1-2#",102.66,23.66,79.06,{"$nulls":3},"良好",7,1.06,78,98,7644,"王瑶瑶","马娜"]
[10,"01:40:00","鲁Q836BG","戴春宇","刘鹏",17558422777,"段俊成","退货",null,"石子","1-5#",{"$nulls":6},"含石粉较多、泥块",{"$nulls":5},"王瑶瑶","马娜","含石粉较多、泥块，退货"]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N16)","v":679.18},{"$nulls":6},{"$f":"SUM(U5:U16)","v":662.9},null,{"$f":"SUM(W5:W16)","v":71102.5}]

{"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年 5 月 8 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:20:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013609","水泥","PO42.5",97.3,26,{"$f":"K5-L5","v":71.3},{"$nulls":5},{"v":0.003,"d":"0.30%"},71.08,535,{"$f":"T5*U5","v":38027.8},"冯海英","聂恒光"]
[2,"06:23:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013610","水泥","PO42.5",97.02,26.2,70.82,{"$nulls":5},{"v":0.003,"d":"0.30%"},70.6,535,37771,"冯海英","聂恒光"]
[3,"06:35:00","鲁RN6981","黄国栋","黄国栋",13583034566,"英良运输","013611","机制沙","中粗",49.53,16.51,33.02,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[4,"06:37:00","鲁R,1853","狄方丁","狄方丁",17661385222,"英良运输","013612","机制沙","中粗",49.91,15.52,34.39,{"$nulls":5},"0.1T",34.2,139,4753.8,"冯海英","聂恒光"]
[5,"06:40:00","鲁RM7658","谢宏伟","谢宏伟",15106407336,"英良运输","013613","机制沙","中粗",49.69,16.55,33.14,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[6,"06:42:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013614","石子","1--2",51.98,15.85,36.13,{"$nulls":5},"0.1T",36,97,3492,"冯海英","聂恒光"]
[7,"06:44:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013615","石子","1--2",50.42,16.2,34.22,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[8,"06:47:00","鲁RK4998","李涛","任建行",15553056888,"李涛","013616","钢棒","&10.7",49.44,15.76,33.68,{"$nulls":6},33.68,null,0,"冯海英","聂恒光"]
[9,"09:12:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013617","石子","1--2",25.88,8.51,17.37,{"$nulls":5},"0.1T",17.2,97,1668.4,"冯海英","聂恒光"]
[10,"09:14:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013618","石子","1--2",49.73,14.56,35.17,{"$nulls":5},"0.1T",35,97,3395,"冯海英","聂恒光"]
[11,"10:44:00","鲁RB1266","李江红","李江红",15266991988,"莱芜延辉","013619","减水剂",null,31.43,14.27,17.16,{"$nulls":6},17.16,null,0,"冯海英","聂恒光"]
[12,"11:12:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013620","石子","1--2",26.06,8.45,17.61,{"$nulls":5},"0.2T",17.4,97,1687.8,"冯海英","聂恒光"]
[13,"11:19:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013621","石子","1--2",28.52,8.54,19.98,{"$nulls":5},"0.2T",19.7,97,1910.9,"冯海英","聂恒光"]
[14,"11:21:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013622","石子","1--2",50.08,15.39,34.69,{"$nulls":5},"0.1T",34.5,97,3346.5,"冯海英","聂恒光"]
[15,"12:23:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013623","石子","1--2",47.84,15.01,32.83,{"$nulls":5},"0.1T",32.7,97,3171.9,"冯海英","聂恒光"]
[16,"12:25:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013624","石子","1--2",50.16,16.15,34.01,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[17,"12:27:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013625","石子","1--2",50.21,15.79,34.42,{"$nulls":5},"0.1T",34.3,97,3327.1,"冯海英","聂恒光"]
[18,"12:29:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013626","石子","1--2",49.5,15.82,33.68,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[19,"15:07:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013627","石子","1--2",26.53,8.49,18.04,{"$nulls":5},"0.1T",17.9,97,1736.3,"冯海英","聂恒光"]
[20,"16:34:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013628","石子","1--2",49.65,15.79,33.86,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[21,"17:16:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013629","石子","1--2",49.65,15.34,34.31,{"$nulls":5},"0.1T",34.2,97,3317.4,"冯海英","聂恒光"]
[22,"17:21:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013630","石子","1--2",49.95,16.08,33.87,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[23,"17:23:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013631","石子","1--2",49.9,15.78,34.12,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[24,"17:26:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013632","机制沙","中粗",49.49,16.01,33.48,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[25,"17:28:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013633","机制沙","中粗",48.61,16.25,32.36,{"$nulls":5},"0.1T",32.2,139,4475.8,"冯海英","聂恒光"]
[26,"17:30:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013634","机制沙","中粗",45.67,13.84,31.83,{"$nulls":5},"0.1T",31.7,139,4406.3,"冯海英","聂恒光"]
[27,"17:32:00","鲁RM3845","田运增","田运增",15020525186,"英良运输","013635","机制沙","中粗",48.77,14.84,33.93,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[28,"17:34:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013636","石子","1--2",26.03,8.54,17.49,{"$nulls":5},"0.2T",17.2,97,1668.4,"冯海英","聂恒光"]
[29,"17:36:00","鲁RF7132","陈长秋","文洪涛",13869741571,"英良运输","013637","机制沙","中粗",49.31,15.22,34.09,{"$nulls":5},"0.1T",33.9,139,4712.1,"冯海英","聂恒光"]
[30,"17:38:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013638","石子","1--2",50.25,15.13,35.12,{"$nulls":5},"0.1T",35,97,3395,"冯海英","聂恒光"]
[31,"17:41:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013639","机制沙","中粗",46.08,14.05,32.03,{"$nulls":5},"0.1T",31.9,139,4434.1,"冯海英","聂恒光"]
[32,"19:20:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013640","石子","1--2",49.18,15.75,33.43,{"$nulls":5},"0.5T",32.9,97,3191.3,"冯海英","聂恒光"]
[33,"20:38:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013641","矿粉",null,69.08,16.95,52.13,{"$nulls":5},{"v":0.003,"d":"0.30%"},51.97,370,19228.9,"冯海英","聂恒光"]
[34,"21:03:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013642","石子","1--2",27.22,8.57,18.65,{"$nulls":5},"1T",17.6,97,1707.2,"冯海英","聂恒光"]
[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":192993.3}]