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

{"sheet":"邳州分公司","index":0,"n_rows":17,"n_cols":26,"rows_kept":17,"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 月 25 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"15:42:00","鲁QV9022","孙立","谭海洋",18762209692,"李海洋",13119,"WIN0050272","石子","1-2#",102.72,23.72,{"$f":"L5-M5","v":79},{"$nulls":3},"含碎石",8,2,{"$f":"N5-T5","v":77},98,{"$f":"U5*V5","v":7546},"陈金芳","马娜"]
[2,"15:46:00","鲁QV8954","孙立","刘东起",13921762980,"李海洋",13120,"WIN0050272","石子","1-2#",99.84,23.16,76.68,{"$nulls":3},"含碎石",8,2.08,74.6,98,7310.8,"陈金芳","马娜"]
[2,"16:09:00","鲁QV8530","孙立","蒋学武",17772280398,"李海洋",13121,"WIN0050272","石子","1-2#",96.52,22.3,74.22,{"$nulls":3},"含碎石",8,1.52,72.7,98,7124.6,"陈金芳","马娜"]
[4,"20:16:00","鲁QV8954","孙立","刘东起",13921762980,"李海洋",13122,"WIN0050272","石子","1-2#",99,23.12,75.88,{"$nulls":3},"含碎石",8,1.58,74.3,98,7281.4,"杨家辉","马娜"]
[5,"21:02:00","鲁QV9022","孙立","谭海洋",18762209693,"李海洋",13124,"WIN0050272","石子","1-2#",102.06,23.82,78.24,{"$nulls":3},"含碎石",8,1.04,77.2,98,7565.6,"杨家辉","马娜"]
[6,"21:10:00","苏CGV338","周桂林","李城市",18751653412,"杨需",13125,"WIN0050271","机制砂","中粗砂",90.64,21.72,68.92,7,2,2.8,"Ⅱ区",null,2.12,66.8,119,7949.2,"杨家辉","马娜"]
[7,"21:12:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",13126,"WIN0050271","机制砂","中粗砂",94.16,22.56,71.6,7,2,2.8,"Ⅱ区",null,2.2,69.4,119,8258.6,"杨家辉","马娜"]
[8,"21:14:00","苏C2A698","高雷","高雷",13913462579,"杨需",13128,"WIN0050271","机制砂","中粗砂",109.78,29.76,80.02,7,2,2.8,"Ⅱ区",null,2.42,77.6,119,9234.4,"杨家辉","马娜"]
[9,"21:16:00","苏CGS000","周桂林","刘宝云",19806019310,"杨需",13127,"WIN0050271","机制砂","中粗砂",89.66,21.72,67.94,7,2,2.8,"Ⅱ区",null,2.04,65.9,119,7842.1,"杨家辉","马娜"]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N16)","v":672.5},{"$nulls":6},{"$f":"SUM(U5:U16)","v":655.5},null,{"$f":"SUM(W5:W16)","v":70112.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 月 25 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:16:00","苏GE5108","攀苏声","攀苏声",18352135651,"攀苏声","013361","钢棒","&9.0",49.52,44.65,{"$f":"K5-L5","v":4.87},{"$nulls":6},4.87,4830,{"$f":"T5*U5","v":23522.1},"冯海英","聂恒光"]
[2,"07:34:00","苏GE5108","攀苏声","攀苏声",18352135651,"攀苏声","013362","钢棒","&10.7",44.65,15.43,29.22,{"$nulls":6},29.22,4830,141132.6,"冯海英","聂恒光"]
[3,"17:45:00","鲁PD0901","徐光伟","马光里",18663568626,"徐光伟","013363","端板",null,45.53,29.76,15.77,{"$nulls":6},15.77,null,0,"冯海英","聂恒光"]
[4,"19:14:00","鲁PD0901","徐光伟","马光里",18663568626,"徐光伟","013364","端板",null,29.75,14.12,15.63,{"$nulls":6},15.63,null,0,"冯海英","聂恒光"]
[5,"19:37:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013365","石子","1--2",50.39,16.27,34.12,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[6,"19:39:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013366","石子","1--2",50.95,16.27,34.68,{"$nulls":5},"0.1T",34.5,97,3346.5,"冯海英","聂恒光"]
[7,"19:41:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013367","机制沙","中粗",49.15,15.95,33.2,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[8,"19:43:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013368","机制沙","中粗",49.05,16.07,32.98,{"$nulls":5},"0.1T",32.8,139,4559.2,"冯海英","聂恒光"]
[9,"19:45:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013369","机制沙","中粗",49.65,16.27,33.38,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[10,"19:47:00","鲁RK0329","陈长秋","张华洗",15615708910,"英良运输","013370","机制沙","中粗",49.64,15.54,34.1,{"$nulls":5},"0.1T",34,139,4726,"冯海英","聂恒光"]
[11,"19:49:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","013371","机制沙","中粗",49.51,15.23,34.28,{"$nulls":5},"0.1T",34.1,139,4739.9,"冯海英","聂恒光"]
[12,"19:51:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013372","机制沙","中粗",45.91,13.9,32.01,{"$nulls":5},"0.1T",31.9,139,4434.1,"冯海英","聂恒光"]
[13,"19:53:00","鲁RG3077","陈长秋","王君刚",18854068893,"英良运输","013373","机制沙","中粗",46.26,14.23,32.03,{"$nulls":5},"0.1T",31.9,139,4434.1,"冯海英","聂恒光"]
[14,"20:05:00","鲁RM3845","陈长秋","田运增",15020525186,"英良运输","013374","机制沙","中粗",49.31,15.16,34.15,{"$nulls":5},"0.1T",34,139,4726,"冯海英","聂恒光"]
[15,"20:07:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013375","机制沙","中粗",46.44,14.08,32.36,{"$nulls":5},"0.1T",32.2,139,4475.8,"冯海英","聂恒光"]
[16,"20:09:00","鲁RM1486","陈平西","陈旺仓",15562056902,"英良运输","013376","机制沙","中粗",46.35,14.42,31.93,{"$nulls":5},"0.1T",31.8,139,4420.2,"冯海英","聂恒光"]
[17,"20:12:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013377","矿粉",null,70.47,17.15,53.32,{"$nulls":5},{"v":0.003,"d":"0.30%"},53.16,370,19669.2,"冯海英","聂恒光"]
[18,{"$nulls":11},0,{"$nulls":8},0]
[19,{"$nulls":11},0,{"$nulls":8},0]
[20,{"$nulls":11},0,{"$nulls":8},0]
[21,{"$nulls":11},0,{"$nulls":8},0]
[22,{"$nulls":11},0,{"$nulls":8},0]
[23,{"$nulls":11},0,{"$nulls":8},0]
[24,{"$nulls":11},0,{"$nulls":8},0]
[25,{"$nulls":11},0,{"$nulls":8},0]
[26,{"$nulls":11},0,{"$nulls":8},0]
[27,{"$nulls":11},0,{"$nulls":8},0]
[28,{"$nulls":11},0,{"$nulls":8},0]
[29,{"$nulls":11},0,{"$nulls":8},0]
[30,{"$nulls":11},0,{"$nulls":8},0]
[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":236699.4}]