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

{"sheet":"大力神","index":0,"n_rows":19,"n_cols":26,"rows_kept":19,"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 月 24 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"19:45:00","苏CR8888","林磊","范振",18344886678,"丁庆余",13103,"WIN0050263","石子","1-2#",104.8,23.7,81.1,{"$nulls":3},"含碎石",8,2,{"$f":"N5-T5","v":79.1},98,{"$f":"U5*V5","v":7751.8},"杨家辉","马娜"]
[2,"19:50:00","鲁QV9028","林磊","周勇",15062019333,"丁庆余",13104,"WIN0050263","石子","1-2#",108.88,23.52,85.36,{"$nulls":3},"含碎石",8,2.06,83.3,98,8163.4,"杨家辉","马娜"]
[2,"19:00:00","苏C1T967","林磊","于雷",15062019633,"丁庆余",13105,"WIN0050263","石子","1-2#",104.42,23.18,81.24,{"$nulls":3},"含碎石",8,2.04,79.2,98,7761.6,"杨家辉","马娜"]
[4,"20:27:00","鲁Q076AS","林磊","韩风",18913458999,"丁庆余",13106,"WIN0050263","石子","1-2#",105.92,23.06,82.86,{"$nulls":3},"含碎石",8,2.06,80.8,98,7918.4,"杨家辉","马娜"]
[5,"21:21:00","苏CGV338","周桂林","李城市",18751653412,"杨需",13108,"WIN0050261","机制砂","中粗砂",88.54,21.46,67.08,6,2.3,2.8,"Ⅱ区",null,1.38,65.7,119,7818.3,"杨家辉","马娜"]
[6,"21:23:00","鲁Q627AP","官东明","官东明",15263915869,"杨需",13109,"WIN0050261","机制砂","中粗砂",94.76,22.7,72.06,6,2.3,2.8,"Ⅱ区",null,1.46,70.6,119,8401.4,"杨家辉","马娜"]
[7,"21:26:00","苏C2A698","高震","高震",13913462579,"杨需",13110,"WIN0050261","机制砂","中粗砂",110.8,29.3,81.5,6,2.3,2.8,"Ⅱ区",null,1.7,79.8,119,9496.2,"杨家辉","马娜"]
[8,"21:29:00","苏CGS000","周桂林","刘宝云",19806019310,"杨需",13111,"WIN0050261","机制砂","中粗砂",88.34,21.58,66.76,6,2.3,2.8,"Ⅱ区",null,1.36,65.4,119,7782.6,"杨家辉","马娜"]
[9,"01:15:00","苏CJV709","戴建","刘林",18762236617,"丁庆余",13114,"WIN0050263","石子","1-2#",77.34,18.32,59.02,{"$nulls":3},"含石粉、碎石",8,1.52,57.5,98,5635,"杨家辉","马娜"]
[10,"01:24:00","鲁Q366CQ","戴春宇","刘玉良",13775857003,"李海洋",13116,"WIN0050262","石子","1-2#",98.08,18.58,79.5,{"$nulls":3},"含石粉、碎石",8,1,78.5,98,7693,"杨家辉","马娜"]
[11,"02:37:00","鲁Q333AA","冯波","刘金虎",17318833688,"李海洋",13117,"WIN0050262","石子","1-2#",102.2,23.3,78.9,{"$nulls":3},"含石粉、碎石",8,1.5,77.4,98,7585.2,"杨家辉","马娜"]
[12,"02:41:00","鲁Q515BZ","王彬","冯波",13347936982,"李海洋",13118,"WIN0050262","石子","1-2#",111.52,26.9,84.62,{"$nulls":3},"含石粉、碎石",8,1.52,83.1,98,8143.8,"杨家辉","马娜"]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N18)","v":920},{"$nulls":6},{"$f":"SUM(U5:U18)","v":900.4},null,{"$f":"SUM(W5:W18)","v":94150.7}]

{"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 月 24 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:55:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013325","水泥","PO42.5",94.41,25.98,{"$f":"K5-L5","v":68.43},{"$nulls":5},{"v":0.003,"d":"0.30%"},68.22,535,{"$f":"T5*U5","v":36497.7},"冯海英","聂恒光"]
[2,"06:59:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013326","水泥","PO42.5",96.48,25.89,70.59,{"$nulls":5},{"v":0.003,"d":"0.30%"},70.37,535,37647.95,"冯海英","聂恒光"]
[3,"08:53:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013327","石子","1--2",25.82,8.59,17.23,{"$nulls":5},"0.3T",16.9,97,1639.3,"冯海英","聂恒光"]
[4,"09:51:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013328","石子","1--2",49.76,15.85,33.91,{"$nulls":5},"0.1T",33.8,97,3278.6,"冯海英","聂恒光"]
[5,"10:17:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013329","石子","1--2",27.65,8.62,19.03,{"$nulls":5},"2T",17,97,1649,"冯海英","聂恒光"]
[6,"10:19:00","鲁RL7377","李斌","王帅",18264007774,"李广坤","013330","石子","1--2",26.47,8.65,17.82,{"$nulls":5},"0.4T",17.4,97,1687.8,"冯海英","聂恒光"]
[7,"12:36:00","鲁RF7132","陈长秋","文洪涛",13869741571,"英良运输","013331","机制沙","中粗",49.58,15.17,34.41,{"$nulls":5},"0.1T",34.3,139,4767.7,"冯海英","聂恒光"]
[8,"12:38:00","鲁RE5553","陈长秋","文洪兴",13695308751,"英良运输","013332","机制沙","中粗",49.42,16.09,33.33,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[9,"12:41:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013333","石子","1--2",48.75,15.12,33.63,{"$nulls":5},"0.3T",33.3,97,3230.1,"冯海英","聂恒光"]
[10,"12:46:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013334","机制沙","中粗",46.46,14.1,32.36,{"$nulls":5},"0.1T",32.2,139,4475.8,"冯海英","聂恒光"]
[11,"12:48:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013335","机制沙","中粗",49.53,15.92,33.61,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[12,"12:50:00","鲁RK0329","陈长秋","张华洗",15615708910,"英良运输","013336","机制沙","中粗",49.18,15.54,33.64,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[13,"12:52:00","鲁RM3845","陈长秋","田运增",15020525186,"英良运输","013337","机制沙","中粗",49.4,14.97,34.43,{"$nulls":5},"0.1T",34.3,139,4767.7,"冯海英","聂恒光"]
[14,"12:54:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013338","机制沙","中粗",49.28,16.05,33.23,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[15,"12:56:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013339","机制沙","中粗",46.13,13.92,32.21,{"$nulls":5},"0.1T",32.1,139,4461.9,"冯海英","聂恒光"]
[16,"13:15:00","鲁RM8082","安春峰","安春峰",18764504777,"李广坤","013340","石子","1--2",51.99,16.08,35.91,{"$nulls":5},"0.3T",35.6,97,3453.2,"冯海英","聂恒光"]
[17,"13:58:00","鲁RL5456","吕华东","吕华东",15562719795,"英良运输","013341","石子","1--2",49.79,15.88,33.91,{"$nulls":5},"0.3T",33.6,97,3259.2,"冯海英","聂恒光"]
[18,"14:14:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013342","石子","1--2",25.79,8.66,17.13,{"$nulls":5},"0.3T",16.8,97,1629.6,"冯海英","聂恒光"]
[19,"15:17:00","鲁RM1486","陈平西","陈旺仓",15562056902,"英良运输","013343","机制沙","中粗",46.43,14.37,32.06,{"$nulls":5},"0.1T",31.9,139,4434.1,"冯海英","聂恒光"]
[20,"15:19:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013344","石子","1--2",28.07,8.53,19.54,{"$nulls":5},"0.3T",19.2,97,1862.4,"冯海英","聂恒光"]
[21,"15:22:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013345","石子","1--2",49.69,15.81,33.88,{"$nulls":5},"0.2T",33.6,97,3259.2,"冯海英","聂恒光"]
[22,"15:42:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013346","石子","1--2",26.12,8.62,17.5,{"$nulls":5},"0.3T",17.2,97,1668.4,"冯海英","聂恒光"]
[23,"15:47:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013347","石子","1--2",49.88,15.79,34.09,{"$nulls":5},"0.3T",33.7,97,3268.9,"冯海英","聂恒光"]
[24,"16:25:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013348","石子","1--2",49.99,14.52,35.47,{"$nulls":5},"0.2T",35.2,97,3414.4,"冯海英","聂恒光"]
[25,"16:27:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013349","石子","1--2",49.74,14.37,35.37,{"$nulls":5},"0.2T",35.1,97,3404.7,"冯海英","聂恒光"]
[26,"16:54:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013350","石子","1--2",49.56,15.96,33.6,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[27,"16:56:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013351","石子","1--2",49.77,15.76,34.01,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[28,"18:12:00","鲁RA6591","刘郑","刘郑",15265032423,"莱芜延辉","013352","减水剂",null,31.11,14.86,16.25,{"$nulls":6},16.25,1900,30875,"冯海英","聂恒光"]
[29,"19:16:00","鲁RM3845","陈长秋","田运增",15020525186,"英良运输","013353","机制沙","中粗",49.23,14.95,34.28,{"$nulls":5},"0.1T",34.1,139,4739.9,"冯海英","聂恒光"]
[30,"19:19:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013354","机制沙","中粗",48.61,15.97,32.64,{"$nulls":5},"0.1T",32.5,139,4517.5,"冯海英","聂恒光"]
[31,"19:22:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013355","机制沙","中粗",46.42,14.02,32.4,{"$nulls":5},"0.1T",32.3,139,4489.7,"冯海英","聂恒光"]
[32,"19:24:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013356","机制沙","中粗",48.25,15.86,32.39,{"$nulls":5},"0.1T",32.2,139,4475.8,"冯海英","聂恒光"]
[33,"19:36:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013357","石子","1--2",49.78,15.77,34.01,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[34,"19:38:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013358","石子","1--2",50.3,16.25,34.05,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[35,"19:40:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013359","石子","1--2",26.28,8.62,17.66,{"$nulls":5},"0.2T",17.4,97,1687.8,"冯海英","聂恒光"]
[36,"22:10:00","鲁RM1486","陈平西","陈旺仓",15562056902,"英良运输","013360","机制沙","中粗",46.52,14.39,32.13,{"$nulls":5},"0.1T",32,139,4448,"冯海英","聂恒光"]
[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":220634.45}]