{"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 年 6 月 18 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"13:36:00","鲁Q126CC","吴作运","吴作运",13921764022,"李海洋",14310,"WIN0050920","石子","1-2#",48.58,7.48,31.1,{"$nulls":3},"良好",7,0.3,30.8,103,{"$f":"U5*V5","v":3172.4},"陈金芳","马娜"]
[2,"16:31:00","鲁Q522BG","戴春宇","郑嘉雷",15862121767,"李海洋",14311,"WIN0050920","石子","1-2#",95.6,22.86,72.74,{"$nulls":3},"良好",7,1.04,71.7,103,7385.1,"陈金芳","马娜"]
[3,"21:29:00","鲁Q718BZ","孙立","胡广发",18761484744,"李海洋",14315,"WIN0050920","石子","1-2#",94.8,23.2,71.6,{"$nulls":3},"良好",7,1,70.6,103,7271.8,"李思","杜娥"]
[4,"22:01:00","鲁Q502BY","戴春宇","王各异",15152016113,"李海洋",14316,"WIN0050920","石子","1-2#",71.1,16.38,54.72,{"$nulls":3},"良好",7,0.52,54.2,103,5582.6,"李思","杜娥"]
[5,"22:04:00","鲁Q126CC","吴作运","吴作运",13921764022,"李海洋",14317,"WIN0050920","石子","1-2#",49.2,17.44,31.76,{"$nulls":3},"良好",7,0.56,31.2,103,3213.6,"李思","杜娥"]
[6,"23:59:00","鲁QV9022","孙立","谭海阳",18762209682,"李海洋",14318,"WIN0050920","石子","1-2#",98.08,23.96,74.12,{"$nulls":3},"良好",7,0.52,73.6,103,7580.8,"李思","杜娥"]
[7,"04:13:00","鲁QV9022","孙立","谭海阳",18762209682,"李海洋",14320,"WIN0050920","石子","1-2#",100.6,23.9,76.7,{"$nulls":3},"良好",7,1,75.7,103,7797.1,"李思","杜娥"]
[8,"05:07:00","鲁QV8018","戴春宇","李勇",18052254999,"李海洋",14321,"WIN0050920","石子","1-2#",92.28,23.96,68.32,{"$nulls":3},"良好",7,1.02,67.3,103,6931.9,"李思","杜娥"]
[9,"05:26:00","鲁QV8855","韩榆","韩榆",15162001555,"李海洋",14322,"WIN0050920","石子","1-2#",96.74,23.4,73.34,{"$nulls":3},"良好",7,1.04,72.3,103,7446.9,"李思","杜娥"]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N14)","v":554.4},{"$nulls":6},{"$f":"SUM(U5:U14)","v":547.4},null,{"$f":"SUM(W5:W14)","v":56382.2}]

{"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年 6 月 17 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:03:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","014417","水泥","PO42.5",84.59,23.61,{"$f":"K5-L5","v":60.98},{"$nulls":5},{"v":0.003,"d":"0.30%"},60.8,525,{"$f":"T5*U5","v":31920},"冯海英","聂恒光"]
[2,"06:06:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","014418","水泥","PO42.5",100.32,25.75,74.57,{"$nulls":5},{"v":0.003,"d":"0.30%"},74.35,525,39033.75,"冯海英","聂恒光"]
[3,"08:59:00","鲁RM3845","陈长秋","田运增",15020525186,"英良运输","014419","机制沙","中粗",49.99,16.03,33.96,{"$nulls":5},"0.1T",34.8,139,4837.2,"冯海英","聂恒光"]
[4,"09:01:00","鲁RN9829","米强栋","米强栋",18953005713,"英良运输","014420","机制沙","中粗",49.09,16.25,32.84,{"$nulls":5},"0.1T",32.7,139,4545.3,"冯海英","聂恒光"]
[5,"09:03:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014421","机制沙","中粗",50.9,16.18,34.72,{"$nulls":5},"0.1T",34.6,139,4809.4,"冯海英","聂恒光"]
[6,"09:06:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","014422","石子","1--2",28.16,8.43,19.73,{"$nulls":5},"0.1T",19.6,103,2018.8,"冯海英","聂恒光"]
[7,"09:08:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","014423","石子","1--2",49.66,15.55,34.11,{"$nulls":5},"0.1T",34,103,3502,"冯海英","聂恒光"]
[8,"09:10:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014424","石子","1--2",28.18,8.47,19.71,{"$nulls":5},"0.1T",19.6,103,2018.8,"冯海英","聂恒光"]
[9,"09:48:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","014425","石子","1--2",49.14,15.13,34.01,{"$nulls":5},"0.1T",33.8,103,3481.4,"冯海英","聂恒光"]
[10,"09:50:00","鲁RM8082","安春峰","安春峰",18764504777,"李广坤","014426","石子","1--2",50.94,16.06,34.88,{"$nulls":5},"0.1T",34.7,103,3574.1,"冯海英","聂恒光"]
[11,"10:17:00","鲁JA4773","王双喜","王勇",18954064499,"郑言克","014427","石子","1--2",51.67,14.69,36.98,{"$nulls":5},"0.1T",36.8,103,3790.4,"冯海英","聂恒光"]
[12,"10:19:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","014428","石子","1--2",50.69,15.59,35.1,{"$nulls":5},"0.1T",35,103,3605,"冯海英","聂恒光"]
[13,"10:46:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","014429","石子","1--2",25.53,8.49,17.04,{"$nulls":5},"0.1T",16.9,103,1740.7,"冯海英","聂恒光"]
[14,"12:30:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014430","石子","1--2",49.71,15.81,33.9,{"$nulls":5},"0.1T",33.8,103,3481.4,"冯海英","聂恒光"]
[15,"13:30:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","014431","石子","1--2",49.89,15.89,34,{"$nulls":5},"0.1T",33.9,103,3491.7,"冯海英","聂恒光"]
[16,"13:57:00","鲁RM7229","许光伟","张明发",18663568636,"许光伟","014432","端板",null,48.5,29.83,18.67,{"$nulls":6},15.97,null,0,"冯海英","聂恒光"]
[17,"14:39:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014433","石子","1--2",29.44,8.44,21,{"$nulls":5},"0.1T",20.9,103,2152.7,"冯海英","聂恒光"]
[18,"15:01:00","鲁RM7229","许光伟","张明发",18663568636,"许光伟","014434","端板",null,29.83,14.35,15.48,{"$nulls":6},15.48,null,0,"冯海英","聂恒光"]
[19,"15:43:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","014435","石子","1--2",49.6,15.48,34.12,{"$nulls":3},".",null,"0.1T",34,103,3502,"冯海英","聂恒光"]
[20,"15:45:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","014436","石子","1--2",27.07,8.45,18.62,{"$nulls":5},"0.1T",18.3,103,1884.9,"冯海英","聂恒光"]
[21,"16:07:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","014437","石子","1--2",50.81,15.53,35.28,{"$nulls":5},"0.1T",35.1,103,3615.3,"冯海英","聂恒光"]
[22,"16:10:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","014438","石子","1--2",29.75,8.4,21.35,{"$nulls":5},"0.1T",21.1,103,2173.3,"冯海英","聂恒光"]
[23,"16:13:00","鲁JB2331","王磊","王磊",18653677018,"郑言克","014439","石子","1--2",49.98,14.79,35.19,{"$nulls":5},"0.1T",34.6,103,3563.8,"冯海英","聂恒光"]
[24,"16:15:00","鲁JA4773","王双喜","王勇",18954064499,"郑言克","014440","石子","1--2",50.49,14.62,35.87,{"$nulls":5},"0.1T",35.3,103,3635.9,"冯海英","聂恒光"]
[25,"19:03:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","014441","机制沙","中粗",50.04,15.71,34.33,{"$nulls":5},"0.1T",34.2,139,4753.8,"冯海英","聂恒光"]
[26,"19:05:00","鲁RM2498","魏庆如","崔保东",13061551313,"英良运输","014442","机制沙","中粗",49.3,16.05,33.25,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[27,"19:07:00","鲁RN9829","米强栋","米强栋",18953005713,"英良运输","014443","机制沙","中粗",49.17,16.39,32.78,{"$nulls":5},"0.1T",32.6,139,4531.4,"冯海英","聂恒光"]
[28,"19:08:00","鲁RM3845","陈长秋","田运增",15020525186,"英良运输","014444","机制沙","中粗",49.77,14.98,34.79,{"$nulls":5},"0.1T",34.6,139,4809.4,"冯海英","聂恒光"]
[29,"19:11:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","014445","石子","1--2",49.73,15.79,33.94,{"$nulls":5},"0.1T",33.8,103,3481.4,"冯海英","聂恒光"]
[30,"19:36:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014446","石子","1--2",29.67,8.52,21.15,{"$nulls":5},"0.1T",20.9,103,2152.7,"冯海英","聂恒光"]
[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":160707.45}]