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

{"sheet":"大力神分公司","index":0,"n_rows":14,"n_cols":26,"rows_kept":14,"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 月 23 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"20:22:00","苏CGV338","周桂林","李城市",18751653412,"杨需",13090,"WIN0050254","机制砂","中粗砂",85.5,21.36,64.14,6,2.8,2.9,"Ⅱ区",null,1.34,62.8,119,{"$f":"U5*V5","v":7473.2},"杨家辉","马娜","卸三车间商混"]
[2,"20:25:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",13091,"WIN0050254","机制砂","中粗砂",81.04,22.56,58.48,6,2.8,2.9,"Ⅱ区",null,1.18,57.3,119,6818.7,"杨家辉","马娜","卸三车间商混"]
[3,"00:06:00","鲁Q502BY","戴春宇","王戈义",15152016113,"李海洋",13094,"WIN0050252","石子","1-2#",76.48,19.32,57.16,{"$nulls":3},"良好",7,0.56,56.6,99,5603.4,"杨家辉","马娜"]
[4,"00:52:00","苏C1T837","戴春宇","吴云龙",15252222092,"李海洋",13096,"WIN0050252","石子","1-2#",105.98,23.16,82.82,{"$nulls":3},"良好",7,1.02,81.8,99,8098.2,"杨家辉","马娜"]
[5,"00:58:00","鲁Q188BD","戴春宇","李宋",18913488722,"李海洋",13097,"WIN0050252","石子","1-2#",78,19.4,58.6,{"$nulls":3},"良好",7,0.5,58.1,99,5751.9,"杨家辉","马娜"]
[]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N13)","v":321.2},{"$nulls":6},{"$f":"SUM(U5:U13)","v":316.6},null,{"$f":"SUM(W5:W13)","v":33745.4}]

{"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 月 23 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:52:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013285","矿粉",null,69.74,17.22,{"$f":"K5-L5","v":52.52},{"$nulls":5},{"v":0.003,"d":"0.30%"},52.36,370,{"$f":"T5*U5","v":19373.2},"冯海英","聂恒光"]
[2,"06:56:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013286","水泥","PO42.5",92.96,25.96,67,{"$nulls":5},{"v":0.003,"d":"0.30%"},66.8,535,35738,"冯海英","聂恒光"]
[3,"06:59:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013287","水泥","PO42.5",94.03,26.06,67.97,{"$nulls":5},{"v":0.003,"d":"0.30%"},67.76,535,36251.6,"冯海英","聂恒光"]
[4,"07:08:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013288","石子","1--2",49.79,16.02,33.77,{"$nulls":5},"0.1T",33.6,97,3259.2,"冯海英","聂恒光"]
[5,"07:10:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013289","石子","1--2",49.34,16.13,33.21,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[6,"07:13:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013290","石子","1--2",32.39,9.53,22.86,{"$nulls":5},"0.1T",22.7,97,2201.9,"冯海英","聂恒光"]
[7,"07:43:00","鲁JA6811","王德刚","王德刚",17705485901,"王德刚","013291","195线材","&6.5",48.32,14.67,33.65,{"$nulls":6},33.65,4110,138301.5,"冯海英","聂恒光"]
[8,"07:44:00","鲁H85E35","马文冬","王广伟",13287213022,"马文冬","013292","钢棒","&10.7",56.35,23.84,32.51,{"$nulls":6},32.51,4770,155072.7,"冯海英","聂恒光"]
[9,"09:21:00","鲁ED2674","陈广华","陈广华",18663581382,"陈广华","013293","端板",null,45.41,21.73,23.68,{"$nulls":6},23.68,null,0,"冯海英","聂恒光"]
[10,"09:38:00","鲁RL7377","李斌","王帅",18264007774,"李广坤","013294","石子","1--2",27.04,8.62,18.42,{"$nulls":5},"0.2T",18.2,97,1765.4,"冯海英","聂恒光"]
[11,"09:40:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013295","石子","1--2",25.87,8.69,17.18,{"$nulls":5},"0.2T",16.9,97,1639.3,"冯海英","聂恒光"]
[12,"09:45:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013296","石子","1--2",49.82,15.52,34.3,{"$nulls":5},"0.1T",34.2,97,3317.4,"冯海英","聂恒光"]
[13,"09:48:00","鲁RM8082","安春峰","安春峰",18764504777,"李广坤","013297","石子","1--2",51.45,16.03,35.42,{"$nulls":5},"0.1T",35.3,97,3424.1,"冯海英","聂恒光"]
[14,"09:50:00","鲁RL5456","吕东华","吕东华",15562719795,"英良运输","013298","石子","1--2",49.52,15.7,33.82,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[15,"09:59:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013299","石子","1--2",48.13,15,33.13,{"$nulls":5},"0.1T",33,97,3201,"冯海英","聂恒光"]
[16,"10:31:00","鲁H85E35","马文冬","王广伟",13287213022,"马文冬","013300","钢棒","&9.0",23.84,14.98,8.86,{"$nulls":6},8.86,4770,42262.2,"冯海英","聂恒光"]
[17,"11:47:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013301","机制沙","中粗",48.88,15.97,32.91,{"$nulls":5},"0.1T",32.8,139,4559.2,"冯海英","聂恒光"]
[18,"11:49:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013302","机制沙","中粗",49.21,16.21,33,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[19,"11:51:00","鲁RK0329","陈长秋","侯代华",15864603123,"英良运输","013303","机制沙","中粗",49.56,15.59,33.97,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[20,"12:06:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","013304","机制沙","中粗",49,14.99,34.01,{"$nulls":5},"0.1T",33.9,139,4712.1,"冯海英","聂恒光"]
[21,"12:09:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013305","机制沙","中粗",46.3,14.07,32.23,{"$nulls":5},"0.1T",32.1,139,4461.9,"冯海英","聂恒光"]
[22,"12:23:00","鲁RE5553","陈长秋","文洪兴",13695308751,"英良运输","013306","机制沙","中粗",49.6,16.18,33.42,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[23,"12:25:00","鲁RF7132","陈长秋","文洪涛",13869741571,"英良运输","013307","机制沙","中粗",49.65,15.28,34.37,{"$nulls":5},"0.1T",34.2,139,4753.8,"冯海英","聂恒光"]
[24,"12:39:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013308","石子","1--2",50.42,44.01,6.41,{"$nulls":5},"2T",4.4,97,426.8,"冯海英","聂恒光"]
[25,"13:54:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013309","石子","1--2",49.29,16.27,33.02,{"$nulls":5},"0.1T",32.9,97,3191.3,"冯海英","聂恒光"]
[26,"14:00:00","鲁ED2674","陈广华","陈广华",18663581382,"陈广华","013310","端板",null,21.73,15.44,6.29,{"$nulls":6},6.29,null,0,"冯海英","聂恒光"]
[27,"14:34:00","鲁RM1362","张旭","宋化卿",15990979076,"英良运输","013311","石子","1--2",49.26,15.77,33.49,{"$nulls":5},"0.3T",33.1,97,3210.7,"冯海英","聂恒光"]
[28,"14:52:00","鲁RM8082","安春峰","安春峰",18764504777,"李广坤","013312","石子","1--2",51.05,15.97,35.08,{"$nulls":5},"0.3T",34.7,97,3365.9,"冯海英","聂恒光"]
[29,"15:03:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013313","石子","1--2",26.55,8.65,17.9,{"$nulls":5},"0.3T",17.6,97,1707.2,"冯海英","聂恒光"]
[30,"15:05:00","鲁RL7377","李斌","王帅",18264007774,"李广坤","013314","石子","1--2",26.12,8.59,17.53,{"$nulls":5},"0.3T",17.2,97,1668.4,"冯海英","聂恒光"]
[31,"15:07:00","鲁RL5456","吕东华","吕东华",15562719795,"英良运输","013315","石子","1--2",50.71,15.64,35.07,{"$nulls":5},"0.5T",34.5,97,3346.5,"冯海英","聂恒光"]
[32,"15:33:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013316","石子","1--2",49.56,15.46,34.1,{"$nulls":5},"0.3T",33.8,97,3278.6,"冯海英","聂恒光"]
[33,"15:35:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013317","石子","1--2",49.91,15.14,34.77,{"$nulls":5},"0.3T",34.4,97,3336.8,"冯海英","聂恒光"]
[34,"16:09:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013318","石子","1--2",48.94,15.76,33.18,{"$nulls":5},"0.1T",33,97,3201,"冯海英","聂恒光"]
[35,"16:11:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013319","石子","1--2",49.35,15.66,33.69,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[36,"20:24:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013320","石子","1--2",26.02,8.62,17.4,{"$nulls":5},"0.3T",17.1,97,1658.7,"冯海英","聂恒光"]
[37,"20:26:00","鲁RL7377","李斌","王帅",18264007774,"李广坤","013321","石子","1--2",26.75,8.55,18.2,{"$nulls":5},"0.3T",17.9,97,1736.3,"冯海英","聂恒光"]
[38,"20:46:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013322","石子","1--2",49.24,15.7,33.54,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[39,"20:49:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013323","石子","1--2",48.36,15.6,32.76,{"$nulls":5},"0.1T",32.6,97,3162.2,"冯海英","聂恒光"]
[40,"22:02:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013324","机制沙","中粗",48.26,15.85,32.41,{"$nulls":5},"0.1T",32.3,139,4489.7,"冯海英","聂恒光"]
[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":528943.5}]