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

{"sheet":"巨野分公司","index":0,"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 月 14 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"12:04:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","012974","机制沙","中粗",49.47,15.05,{"$f":"K5-L5","v":34.42},{"$nulls":5},"0.1T",34.3,139,{"$f":"T5*U5","v":4767.7},"冯海英","聂恒光"]
[2,"12:07:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","012975","机制沙","中粗",49.43,15.95,33.48,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[3,"14:04:00","鲁RF7132","陈长秋","文洪涛",13695308751,"英良运输","012976","机制沙","中粗",49.4,15.23,34.17,{"$nulls":5},"0.1T",34,139,4726,"冯海英","聂恒光"]
[4,"14:06:00","鲁RE5553","陈长秋","文洪星",13695308751,"英良运输","012977","机制沙","中粗",49.43,16.18,33.25,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[5,"19:53:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","012978","水泥","PO42.5",98.49,25.93,72.56,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.34,535,38701.9,"冯海英","聂恒光"]
[6,"20:05:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","012979","水泥","PO42.5",101.11,26.19,74.92,{"$nulls":5},{"v":0.003,"d":"0.30%"},74.7,535,39964.5,"冯海英","聂恒光"]
[7,"20:31:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","012980","石子","1--2",26.02,8.58,17.44,{"$nulls":5},"0.1T",17.3,99,1712.7,"冯海英","聂恒光"]
[8,"20:34:00","鲁RM5188","李斌","马增杰",15005402467,"李广坤","012981","石子","1--2",25.72,8.62,17.1,{"$nulls":5},"0.1T",17,99,1683,"冯海英","聂恒光"]
[9,{"$nulls":11},0,{"$nulls":8},0]
[10,{"$nulls":11},0,{"$nulls":8},0]
[11,{"$nulls":11},0,{"$nulls":8},0]
[12,{"$nulls":11},0,{"$nulls":8},0]
[13,{"$nulls":11},0,{"$nulls":8},0]
[14,{"$nulls":11},0,{"$nulls":8},0]
[15,{"$nulls":11},0,{"$nulls":8},0]
[16,{"$nulls":11},0,{"$nulls":8},0]
[17,{"$nulls":11},0,{"$nulls":8},0]
[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},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":100785.4}]

{"sheet":"邳州分公司","index":1,"n_rows":24,"n_cols":26,"rows_kept":24,"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 月 14 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"09:04:00","叉车",{"$nulls":8},9.14,7.2,1.94,{"$nulls":10},"李彤彤","拉去中大泥墙"]
[2,"12:21:00","叉车",{"$nulls":8},9.3,7.18,2.12,{"$nulls":10},"李彤彤","拉去中大泥墙"]
[3,"13:54:00","鲁Q515BZ","王彬","冯波",13347936982,"李海洋",12848,"WIN0050161","石子","1-2#",106.64,26.74,79.9,{"$nulls":3},"良好",7,0.5,79.4,98,{"$f":"V7*U7","v":7781.2},"陈金芳","李彤彤"]
[4,"13:57:00","鲁Q338AA","冯波","刘金虎",17318833688,"李海洋",12849,"WIN0050161","石子","1-2#",102.16,22.42,79.74,{"$nulls":3},"良好",7,0.54,79.2,98,7761.6,"刘会良","李彤彤"]
[5,"15:10:00","苏CJV338","周桂林","李城市",18751653412,"庄团结",12851,"WIN0050163","机制砂","中粗砂",88.76,21.42,67.34,5,1.9,2.8,"Ⅱ区",null,0.74,66.6,122,8125.2,"刘会良","李彤彤"]
[6,"15:11:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",12852,"WIN0050163","机制砂","中粗砂",90.36,22.5,67.86,5,1.9,2.8,"Ⅱ区",null,0.76,67.1,122,8186.2,"刘会良","李彤彤"]
[7,"15:14:00","苏C2A698","高雷","高雷",13913462579,"庄团结",12853,"WIN0050163","机制砂","中粗砂",107.74,29.74,78,5,1.9,2.8,"Ⅱ区",null,0.8,77.2,122,9418.4,"刘会良","李彤彤"]
[8,"23:14:00","鲁Q582BY","陈伟","陈伟",15852102259,"丁庆余",12857,"WIN0050162","石子","1-2#",70.92,17.58,53.34,{"$nulls":3},"良好",7,0.54,52.8,98,5174.4,"王瑶瑶","马娜"]
[9,"02:14:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",12859,"WIN0050161","石子","1-2#",101.44,22.84,78.6,{"$nulls":3},"良好",7,0.5,78.1,98,7653.8,"王瑶瑶","马娜"]
[10,"02:58:00","苏CGP356","冯永清","马飞飞",13951463058,"李海洋",12862,"WIN0050164","机制砂","中粗砂",87.2,21.7,65.5,6,1.8,2.8,"Ⅱ区",null,1.9,63.6,122,7759.2,"王瑶瑶","马娜"]
[11,"03:00:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",12861,"WIN0050164","机制砂","中粗砂",85.7,21.5,64.2,6,1.8,2.8,"Ⅱ区",null,1.3,62.9,122,7673.8,"王瑶瑶","马娜"]
[12,"03:25:00","鲁Q323CD","冯永青","刘宝云",19806019316,"李海洋",12863,"WIN0050164","机制砂","中粗砂",88.56,23.3,65.26,6,1.8,2.8,"Ⅱ区",null,1.36,63.9,122,7795.8,"王瑶瑶","马娜"]
[13,"03:28:00","苏CGA040","冯永胜","赵东亚",15062043566,"李海洋",12864,"WIN0050164","机制砂","中粗砂",83.62,21.3,62.32,6,1.8,2.8,"Ⅱ区",null,1.32,61,122,7442,"王瑶瑶","马娜"]
[14,"06:09:00","苏P000AJ","王浩","曹天强",13357931887,"李海洋",12865,"WIN0050161","石子","1-2#",95.18,21.58,73.6,{"$nulls":3},"良好",7,1,72.6,98,7114.8,"王瑶瑶","马娜"]
[15,"06:46:00","鲁Q582BY","陈伟","陈伟",15852102259,"丁庆余",12866,"WIN0050162","石子","1-2#",73.98,17.34,54.64,{"$nulls":3},"良好",7,0.54,56.1,98,5497.8,"王瑶瑶","马娜"]
[]
[]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N23)","v":894.36},{"$nulls":6},{"$f":"SUM(U5:U23)","v":880.5},null,{"$f":"SUM(W5:W23)","v":97384.2}]