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

{"sheet":"邳州分公司","index":0,"n_rows":32,"n_cols":26,"rows_kept":32,"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 月 6 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"23:13:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13255,"WIN0050407","机制砂","中粗砂",95.48,21.48,74,5,1.8,2.8,"Ⅱ区",null,0.8,73.2,119,{"$f":"U5*V5","v":8710.8},"王瑶瑶","马娜"]
[2,"23:22:00","苏CHJ119","庄二团","刘照钱",18751671739,"庄团结",13256,"WIN0050408","机制砂","中粗砂",81.62,17.56,64.06,7,1.8,2.8,"Ⅱ区",null,1.96,62.1,119,7389.9,"王瑶瑶","马娜"]
[3,"23:24:00","苏CCZ319","庄猛","刘军",18251586223,"庄团结",13257,"WIN0050408","机制砂","中粗砂",77.04,16.68,60.36,7,1.8,2.8,"Ⅱ区",null,1.86,58.5,119,6961.5,"王瑶瑶","马娜"]
[4,"23:26:00","苏CDM071","杜坤","杜辉",15062043488,"庄团结",13258,"WIN0050408","机制砂","中粗砂",78.68,17.18,61.5,7,1.8,2.8,"Ⅱ区",null,1.9,59.6,119,7092.4,"王瑶瑶","马娜"]
[5,"23:31:00","苏CHW072","庄宁","贾方乐",18112214446,"庄团结",13259,"WIN0050408","机制砂","中粗砂",78.32,17.36,60.96,7,1.8,2.8,"Ⅱ区",null,1.86,59.1,119,7032.9,"王瑶瑶","马娜"]
[6,"23:33:00","鲁D39525","尹振刚","尹振义",13775858067,"庄团结",13260,"WIN0050408","机制砂","中粗砂",78.72,17.28,61.44,7,1.8,2.8,"Ⅱ区",null,1.94,59.5,119,7080.5,"王瑶瑶","马娜"]
[7,"23:36:00","苏CHK123","庄猛","陈丁",15252204580,"庄团结",13261,"WIN0050408","机制砂","中粗砂",80.18,16.92,63.62,7,1.8,2.8,"Ⅱ区",null,1.96,61.3,119,7294.7,"王瑶瑶","马娜"]
[8,"23:39:00","苏CV9188","庄二团","白喜阳",13370990088,"庄团结",13262,"WIN0050408","机制砂","中粗砂",82.24,17.36,62.88,7,1.8,2.8,"Ⅱ区",null,1.98,60.9,119,7247.1,"王瑶瑶","马娜"]
[9,"23:43:00","冀B5378A","戴春宇","魏楠",13655213111,"庄团结",13263,"WIN0050408","机制砂","中粗砂",75.92,16,59.92,7,1.8,2.8,"Ⅱ区",null,1.82,58.1,119,6913.9,"王瑶瑶","马娜"]
[10,"00:01:00","鲁Q380BH","戴春宇","魏楠",13655213111,"李海洋",13264,"WIN0050409","石子","1-2#",80.36,18.34,62.02,{"$nulls":3},"良好",7,0.52,61.5,98,6027,"王瑶瑶","马娜"]
[11,"00:06:00","鲁Q522BG","戴春宇","郑嘉磊",15862121767,"李海洋",13265,"WIN0050409","石子","1-2#",106.36,23.06,83.3,{"$nulls":3},"良好",7,1,82.3,98,8065.4,"王瑶瑶","马娜"]
[12,"00:09:00","鲁Q506BE","戴春宇","张胜",15105202990,"李海洋",13266,"WIN0050409","石子","1-2#",74.74,18.28,56.46,{"$nulls":3},"良好",7,0.56,55.9,98,5478.2,"王瑶瑶","马娜"]
[13,"00:13:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋",13267,"WIN0050409","石子","1-2#",75.92,18.8,57.12,{"$nulls":3},"良好",7,0.52,56.6,98,5546.8,"王瑶瑶","马娜"]
[14,"00:17:00","鲁Q197BF","何志光","韩飞",18305228333,"李海洋",13268,"WIN0050409","石子","1-2#",77.04,18.66,58.38,{"$nulls":3},"良好",7,0.58,57.8,98,5664.4,"王瑶瑶","马娜"]
[15,"00:42:00","苏CH6588","庄猛","王志勇",15852275790,"庄团结",13269,"WIN0050408","机制砂","中粗砂",76.2,17.38,58.82,8,1.8,2.8,"Ⅱ区",null,2.42,56.4,119,6711.6,"王瑶瑶","马娜"]
[16,"00:52:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",13270,"WIN0050408","机制砂","中粗砂",89.66,22.28,67.38,6,1.8,2.8,"Ⅱ区",null,1.38,66,119,7854,"王瑶瑶","马娜"]
[17,"00:55:00","苏C2A698","高雷","高雷",13913462579,"庄团结",13271,"WIN0050408","机制砂","中粗砂",104.42,29.48,74.94,6,1.8,2.8,"Ⅱ区",null,1.54,73.4,119,8734.6,"王瑶瑶","马娜"]
[18,"00:57:00","苏CGS000","周桂林","刘宝云",18906019310,"庄团结",13272,"WIN0050408","机制砂","中粗砂",86.18,21.52,64.66,6,1.8,2.8,"Ⅱ区",null,1.36,63.3,119,7532.7,"王瑶瑶","马娜"]
[19,"01:15:00","苏CJY880","吕朋","吕朋",15190796222,"庄团结",13273,"WIN0050408","机制砂","中粗砂",84.96,17.7,64.26,8,1.8,2.8,"Ⅱ区",null,2.66,61.6,119,7330.4,"王瑶瑶","马娜"]
[20,"01:53:00","鲁Q582BY","陈大伟","陈大伟",15852102259,"李海洋",13274,"WIN0050409","石子","1-2#",73.8,16.36,57.44,{"$nulls":3},"良好",7,0.54,56.9,98,5576.2,"王瑶瑶","马娜"]
[21,"03:43:00","苏CHJ376","庄二团","庄二团",13952277209,"庄团结",13275,"WIN0050408","机制砂","中粗砂",100.94,21.18,79.76,8,1.8,2.8,"Ⅱ区",null,3.26,76.5,119,9103.5,"王瑶瑶","马娜"]
[22,"04:27:00","苏cu3668","庄楠","张凯",18751671858,"庄团结",13276,"WIN0050408","机制砂","中粗砂",77.38,17.34,60.04,8,1.8,2.8,"Ⅱ区",null,2.44,57.6,119,6854.4,"王瑶瑶","马娜"]
[]
[]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N31)","v":1413.32},{"$nulls":6},{"$f":"SUM(U5:U31)","v":1378.1},null,{"$f":"SUM(W5:W31)","v":156202.9}]

{"sheet":"巨野分公司","index":1,"n_rows":35,"n_cols":25,"rows_kept":35,"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 月 6 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"05:37:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013545","水泥","PO42.5",98.59,26.4,{"$f":"K5-L5","v":72.19},{"$nulls":5},{"v":0.003,"d":"0.30%"},71.97,535,{"$f":"T5*U5","v":38503.95},"冯海英","聂恒光"]
[2,"05:40:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013546","水泥","PO42.5",98.9,25.96,72.94,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.72,535,38905.2,"冯海英","聂恒光"]
[3,"06:40:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013547","石子","1--2",51.46,16.28,35.18,{"$nulls":5},"1T",34.1,97,3307.7,"冯海英","聂恒光"]
[4,"06:42:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013548","石子","1--2",50.8,15.79,35.01,{"$nulls":5},"1T",34,97,3298,"冯海英","聂恒光"]
[5,"07:02:00","苏CHT826","王鹏","王鹏",15162000057,"王鹏","013549","钢棒","&9.0",50.18,17.59,32.59,{"$nulls":6},32.59,4860,158387.4,"冯海英","聂恒光"]
[6,"08:27:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013550","石子","1--2",49.26,14.75,34.51,{"$nulls":5},"0.1T",34.4,97,3336.8,"冯海英","聂恒光"]
[7,"09:32:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013551","石子","1--2",26.7,8.46,18.24,{"$nulls":5},"0.3T",17.9,97,1736.3,"冯海英","聂恒光"]
[8,"09:34:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013552","石子","1--2",26.93,8.46,18.47,{"$nulls":5},"0.4T",18,97,1746,"冯海英","聂恒光"]
[9,"10:13:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013554","石子","1--2",49,15.89,33.11,{"$nulls":5},"0.1T",33,97,3201,"冯海英","聂恒光"]
[10,"10:15:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013555","石子","1--2",49.66,15.75,33.91,{"$nulls":5},"0.1T",33.8,97,3278.6,"冯海英","聂恒光"]
[11,"10:49:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013556","石子","1--2",26.29,8.54,17.75,{"$nulls":5},"0.1T",17.6,97,1707.2,"冯海英","聂恒光"]
[12,"12:36:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013557","机制沙","中粗",49.14,16.32,32.82,{"$nulls":5},"0.1T",32.17,139,4471.63,"冯海英","聂恒光"]
[13,"12:39:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013558","石子","1--2",49.67,14.73,34.94,{"$nulls":5},"0.1T",34.8,97,3375.6,"冯海英","聂恒光"]
[14,"12:41:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013559","石子","1--2",49.54,16.23,33.31,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[15,"12:44:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013560","石子","1--2",51.04,16.19,34.85,{"$nulls":5},"0.1T",34.7,97,3365.9,"冯海英","聂恒光"]
[16,"12:59:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013561","石子","1--2",49.49,15.93,33.56,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[17,"13:01:00","鲁RE5553","陈长秋","侯代华",13695308751,"英良运输","013562","机制沙","中粗",49.54,16.13,33.41,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[18,"13:21:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013563","机制沙","中粗",68.64,17.11,51.53,{"$nulls":5},"0.1T",51.37,139,7140.43,"冯海英","聂恒光"]
[19,"15:05:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013564","矿粉",null,49.84,15.39,34.45,{"$nulls":5},{"v":0.003,"d":"0.30%"},34.3,370,12691,"冯海英","聂恒光"]
[20,"15:42:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013565","石子","1--2",49.43,15.87,33.56,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[21,"15:44:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013566","石子","1--2",49.57,15.7,33.87,{"$nulls":5},"0.2T",33.6,97,3259.2,"冯海英","聂恒光"]
[22,"15:46:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013567","石子","1--2",27.09,8.42,18.67,{"$nulls":5},"0.2T",18.4,97,1784.8,"冯海英","聂恒光"]
[23,"15:48:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013568","石子","1--2",27,8.53,18.47,{"$nulls":5},"0.2T",18.2,97,1765.4,"冯海英","聂恒光"]
[24,"17:16:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013569","石子","1--2",49.39,16.17,33.22,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[25,"17:18:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013570","石子","1--2",49.53,16.11,33.42,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[26,"18:21:00","鲁JA4773","王双喜","王恩平",15588714111,"郑言克","013571","石子","1--2",49.94,14.4,35.54,{"$nulls":5},"0.1T",35.4,97,3433.8,"冯海英","聂恒光"]
[27,"18:23:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013572","石子","1--2",50.32,15.56,34.76,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[28,"21:41:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013573","石子","1--2",49.58,16.13,33.45,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[29,"21:43:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013574","石子","1--2",51.56,16.09,35.47,{"$nulls":5},"0.1T",35.3,97,3424.1,"冯海英","聂恒光"]
[30,{"$nulls":11},0,{"$nulls":8},0]
["合计：",{"$nulls":18},0,null,{"$f":"SUM(V5:V34)","v":329466.11}]