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

{"sheet":"邳州分公司","index":0,"n_rows":36,"n_cols":26,"rows_kept":36,"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 月 8 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含粉量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"13:32:00","苏CGP136","韦艳庆","韦艳庆",15852344111,"庄团结",12659,"WIN0050094","镍砂","中粗砂",75.92,18.18,57.74,6,8,{"$nulls":3},1.24,56.5,102,{"$f":"U5*V5","v":5763},"陈金芳","杜娥娥"]
[2,"14:02:00","苏CU3668","庄南","张凯",18751667158,"庄团结",12660,"WIN0050094","镍砂","中粗砂",72.38,17.54,54.84,6,8,{"$nulls":3},1.14,53.7,102,5477.4,"陈金芳","杜娥娥"]
[3,"14:04:00","苏CGK409","庄汉彬","庄中华",13913468529,"庄团结",12661,"WIN0050094","镍砂","中粗砂",74.3,17.1,57.2,6,8,{"$nulls":3},1.2,56,102,5712,"陈金芳","杜娥娥"]
[4,"14:08:00","苏CH6588","庄猛","王志勇",15852275790,"庄团结",12662,"WIN0050094","镍砂","中粗砂",68.16,16.9,51.26,6,8,{"$nulls":3},1.06,50.2,102,5120.4,"陈金芳","杜娥娥"]
[5,"14:22:00","鲁Q522BG","魏辉","魏辉",15252200168,"李海洋",12663,"WIN0050099","石子","1-2#",99.2,23.18,76.02,{"$nulls":3},"良好",7,0.52,75.5,98,7399,"陈金芳","杜娥娥"]
[6,"16:18:00","鲁Q855BR","宋振宇","宋振宇",13952132110,"李海洋",12664,"WIN0050099","石子","1-2#",95.82,18.22,77.6,{"$nulls":3},"含碎石",8,3,74.6,98,7310.8,"陈金芳","李彤彤","三车间"]
[7,"16:30:00","鲁Q905BU","丁宝利","付强",13280525199,"丁宝利",12666,"WIN0050098","石子","1-2#",63.4,17.1,46.6,{"$nulls":3},"良好",7,0.5,45.8,98,4488.4,"陈金芳","李彤彤"]
[8,"16:32:00","鲁Q932BR","丁宝利","张吉成",13864917051,"丁宝利",12667,"WIN0050098","石子","1-2#",64.96,17.04,47.92,{"$nulls":3},"良好",7,0.52,47.4,98,4645.2,"陈金芳","李彤彤"]
[9,"17:14:00","苏CGL729","王发业","陈鹏飞",15252211881,"庄团结",12668,"WIN0050096","河砂","中粗砂",61.62,16.94,44.68,7,1.8,{"$nulls":3},1.38,43.3,135,5845.5,"杨家辉","李彤彤"]
[10,"17:39:00","苏CGF365","冯永清","崔学良",13775854328,"杨需",12669,"WIN0050095","镍砂","中粗砂",96.86,21.6,75.26,6,{"$nulls":4},1.56,73.7,102,7517.4,"杨家辉","李彤彤"]
[11,"17:41:00","苏CGP356","冯永清","马飞飞",13951463058,"杨需",12670,"WIN0050095","镍砂","中粗砂",96.16,21.44,74.72,6,{"$nulls":4},1.52,73.2,102,7466.4,"杨家辉","李彤彤"]
[12,"17:44:00","苏CGA040","冯永清","单边",15062043566,"杨需",12671,"WIN0050095","镍砂","中粗砂",94.18,21.24,72.94,6,{"$nulls":4},1.54,71.4,102,7282.8,"杨家辉","李彤彤"]
[13,"18:14:00","鲁Q515BZ","冯波","王彬",13347936982,"李海洋",12672,"WIN0050099","石子","1-2#",12672,26.66,83.3,{"$nulls":3},"良好",7,0.5,82.8,98,8114.4,"杨家辉","李彤彤"]
[14,"18:17:00","鲁Q338AA","冯波","刘金虎",17318833688,"李海洋",12673,"WIN0050099","石子","1-2#",97.58,22.96,74.62,{"$nulls":3},"良好",7,0.52,74.1,98,7261.8,"杨家辉","李彤彤"]
[15,"18:20:00","苏C1T837","戴春宇","吴云龙",13585365885,"李海洋",12674,"WIN0050099","石子","1-2#",81.98,21.32,60.66,{"$nulls":3},"良好",7,0.56,60.1,98,5889.8,"杨家辉","李彤彤"]
[16,"18:22:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋",12675,"WIN0050099","石子","1-2#",77.46,19.34,58.12,{"$nulls":3},"良好",7,0.52,57.6,98,5644.8,"杨家辉","李彤彤"]
[17,"23:25:00","苏CGS000","周桂林","梅光喜",15396848658,"杨需",12681,"WIN0050095","镍砂","中粗砂",97,21.4,75.6,6,{"$nulls":4},1.6,74,102,7548,"杨家辉","李彤彤"]
[18,"23:28:00","苏CJV338","周桂林","李城市",18751653412,"杨需",12682,"WIN0050095","镍砂","中粗砂",101.76,21.88,79.88,6,{"$nulls":4},1.68,78.2,102,7976.4,"杨家辉","李彤彤"]
[19,"23:30:00","苏C2A698","高雷","高雷",13913462579,"杨需",12683,"WIN0050095","镍砂","中粗砂",118.12,29.52,88.6,6,{"$nulls":4},1.8,86.8,102,8853.6,"杨家辉","李彤彤"]
[20,"23:47:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",12686,"WIN0050095","镍砂","中粗砂",100.54,22.54,78,6,{"$nulls":4},1.6,76.4,102,7792.8,"杨家辉","李彤彤"]
[21,"23:50:00","苏CBU193","马传霞","马传霞",13776758879,"李海洋",12687,"WIN0050097","河砂","中粗砂",43.72,11.06,32.66,8,2.5,{"$nulls":3},1.36,31.3,135,4225.5,"杨家辉","李彤彤"]
[22,"00:55:00","苏CGP356","冯永清","马飞飞",13951463058,"杨需",12689,"WIN0050095","镍砂","中粗砂",97.58,21.54,76.04,6,{"$nulls":4},1.54,74.5,102,7599,"杨家辉","李彤彤"]
[23,"00:58:00","鲁Q323CD","冯永清","糕昌银",13951463058,"杨需",12690,"WIN0050095","镍砂","中粗砂",98.58,23.16,75.42,6,{"$nulls":4},1.52,73.9,102,7537.8,"杨家辉","李彤彤"]
[24,"01:01:00","苏CGF365","冯永清","崔学良",13775854328,"杨需",12691,"WIN0050095","镍砂","中粗砂",97.82,21.72,76.1,6,{"$nulls":4},1.6,74.5,102,7599,"杨家辉","李彤彤"]
[25,"01:03:00","鲁Q338AA","冯波","刘金虎",17318833688,"李海洋",12692,"WIN0050099","石子","1-2#",97.94,23.1,74.84,{"$nulls":3},"良好",7,0.54,74.3,98,7281.4,"杨家辉","李彤彤"]
[26,"01:06:00","鲁Q515BZ","冯波","王彬",13347936982,"李海洋",12693,"WIN0050099","石子","1-2#",110.42,26.88,83.54,{"$nulls":3},"良好",7,0.54,83,98,8134,"杨家辉","李彤彤"]
[27,"05:09:00","鲁Q338AA","冯波","刘金虎",17318833688,"李海洋",12697,"WIN0050099","石子","1-2#",99.94,23.06,76.08,{"$nulls":3},"良好",7,0.58,76.3,98,7477.4,"杨家辉","李彤彤"]
[28,"05:12:00","鲁Q515BZ","冯波","王彬",13347936982,"李海洋",12698,"WIN0050099","石子","1-2#",110.18,26.7,83.48,{"$nulls":3},"良好",7,0.58,82.9,98,8124.2,"杨家辉","李彤彤"]
[]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N35)","v":1913.72},{"$nulls":6},{"$f":"SUM(U5:U35)","v":1882},null,{"$f":"SUM(W5:W35)","v":191088.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年 4 月 08 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:10:00","鲁RM2498","魏庆如","张庆收",13061551313,"英良运输","012873","机制沙","中粗",48.67,16.08,{"$f":"K5-L5","v":32.59},{"$nulls":5},"0.1T",32.4,139,{"$f":"T5*U5","v":4503.6},"冯海英","聂恒光"]
[2,"06:13:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","012874","机制沙","中粗",49.52,16.19,33.33,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[3,"06:15:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","012875","矿粉",null,70.8,17.05,53.75,{"$nulls":5},{"v":0.003,"d":"0.30%"},53.58,370,19824.6,"冯海英","聂恒光"]
[4,"06:19:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","012876","水泥","PO42.5",98.67,26.16,72.51,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.3,535,38680.5,"冯海英","聂恒光"]
[5,"06:25:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","012877","水泥","PO42.5",101.9,26.24,75.66,{"$nulls":5},{"v":0.003,"d":"0.30%"},75.43,535,40355.05,"冯海英","聂恒光"]
[6,"07:05:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","012878","石子","1--2",29.51,8.57,20.94,{"$nulls":5},"0.1T",20.8,99,2059.2,"冯海英","聂恒光"]
[7,"07:23:00","鲁RN1859","王江华","程峰",18954769126,"英良运输","012879","机制沙","中粗",49.11,15.85,33.26,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[8,"07:25:00","鲁RM3027","张中强","张中强",15163082725,"英良运输","012880","机制沙","中粗",49.43,15.97,33.46,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[9,"09:29:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","012881","石子","1--2",49.68,16.04,33.64,{"$nulls":5},"0.1T",33.5,99,3316.5,"冯海英","聂恒光"]
[10,"09:55:00","鲁RN1362","张旭","石善勇",18653038898,"英良运输","012882","机制沙","中粗",48.5,15.59,32.91,{"$nulls":5},"0.1T",32.8,139,4559.2,"冯海英","聂恒光"]
[11,"10:23:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","012883","石子","1--2",50.43,15.56,34.87,{"$nulls":5},"0.1T",34.7,99,3435.3,"冯海英","聂恒光"]
[12,"11:53:00","鲁RM8082","安春峰","安春峰",18765450477,"李广坤","012884","石子","1--2",48.66,16.02,32.64,{"$nulls":5},"0.1T",32.5,99,3217.5,"冯海英","聂恒光"]
[13,"11:55:00","鲁RL5456","吕东华","吕东华",15562719795,"李广坤","012885","石子","1--2",48.89,15.8,33.09,{"$nulls":5},"0.1T",32.9,99,3257.1,"冯海英","聂恒光"]
[14,"11:57:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","012886","石子","1--2",49.15,15.02,34.13,{"$nulls":5},"0.1T",34,99,3366,"冯海英","聂恒光"]
[15,"11:59:00","鲁H18B77","魏利营","魏利营",13465799558,"李广坤","012887","石子","1--2",25.9,10.2,15.7,{"$nulls":5},"0.1T",15.6,99,1544.4,"冯海英","聂恒光"]
[16,"12:01:00","鲁HJ3377","魏永起","魏永起",15822072199,"李广坤","012888","石子","1--2",25.68,9.11,16.57,{"$nulls":5},"0.1T",16.4,99,1623.6,"冯海英","聂恒光"]
[17,"12:32:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","012889","石子","1--2",49.74,15.46,34.28,{"$nulls":5},"0.1T",34.1,99,3375.9,"冯海英","聂恒光"]
[18,"12:36:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","012890","机制沙","中粗",47.85,16.38,31.47,{"$nulls":5},"0.1T",31.3,139,4350.7,"冯海英","聂恒光"]
[19,"13:30:00","鲁RN1859","王江华","王江华",18954769126,"英良运输","012891","机制沙","中粗",49.14,15.75,33.39,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[20,"13:32:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","012892","机制沙","中粗",49.55,15.94,33.61,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[21,"13:34:00","鲁RM3027","张中强","张中强",15163082725,"英良运输","012893","机制沙","中粗",49.77,15.88,33.89,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[22,"13:40:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","012894","机制沙","中粗",49.38,16.09,33.29,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[23,"16:48:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","012895","石子","1--2",25.32,8.63,16.69,{"$nulls":5},"1.5T",15.1,99,1494.9,"冯海英","聂恒光"]
[24,"16:49:00","鲁RN1362","张旭","魏祥鹏",13583069007,"英良运输","012896","机制沙","中粗",49.72,15.87,33.85,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[25,"17:21:00","鲁RF2786","解云胜","王建平",13791468658,"解云胜","012897","钢棒","&9.0",48.13,14.08,34.05,{"$nulls":6},34.05,4670,159013.5,"冯海英","聂恒光"]
[26,"17:58:00","鲁HJ3377","魏永起","魏永起",15822072199,"李广坤","012898","石子","1--2",25.53,9.08,16.45,{"$nulls":5},"0.2T",16.2,99,1603.8,"冯海英","聂恒光"]
[27,"18:00:00","鲁H18B77","魏利营","魏利营",13465799558,"李广坤","012899","石子","1--2",25.93,10.16,15.77,{"$nulls":5},"0.1T",15.6,99,1544.4,"冯海英","聂恒光"]
[28,"18:02:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","012900","石子","1--2",49.79,15.4,34.39,{"$nulls":5},"0.3T",34,99,3366,"冯海英","聂恒光"]
[29,"19:34:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","012901","机制沙","中粗",49.68,16.47,33.21,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[30,"20:06:00","鲁RN1859","王江华","王江华",18954769126,"英良运输","012902","机制沙","中粗",49.75,15.7,34.05,{"$nulls":5},"0.1T",33.9,139,4712.1,"冯海英","聂恒光"]
[31,"20:38:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","012903","机制沙","中粗",49.69,16.02,33.67,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[32,"20:41:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","012904","机制沙","中粗",49.56,15.92,33.64,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[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},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},{"$f":"T69*U69","v":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":360216.85}]