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

{"sheet":"6.3","index":0,"n_rows":20,"n_cols":26,"rows_kept":20,"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 月 3 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"12:42:00","苏CBA768","余宝军","杨国强",15252221345,"丁庆余",13961,"WIN0050723","石子","1-2#",100.1,22.08,78.02,{"$nulls":3},"良好",7,0.52,77.5,103,{"$f":"V5*U5","v":7982.5},"刘会良","杜娥"]
[2,"12:59:00","苏C1T817","陈建","刘明亮",18151890009,"丁庆余",13962,"WIN0050723","石子","1-2#",93.08,22.84,70.24,{"$nulls":3},"良好",7,0.54,69.7,103,7179.1,"刘会良","杜娥"]
[3,"13:15:00","苏CJW885","陈建","袁维",18018460313,"丁庆余",13964,"WIN0050723","石子","1-2#",103.04,22.66,80.38,{"$nulls":3},"良好",7,0.58,79.8,103,8219.4,"刘会良","杜娥"]
[4,"19:00:00","鲁QV8855","韩榆","韩榆",15162001555,"李海洋",13965,"WIN0050722","石子","1-2#",102.5,23.44,79.06,{"$nulls":3},"良好",7,0.56,78.5,103,8085.5,"杨家辉","马娜"]
[5,"22:00:00","苏CGV338","汤可奇","宫东明",15563375779,"李海洋",13969,"WIN0050721","机制砂","中粗砂",95.92,21.62,74.3,7,1.5,3.3,"Ⅱ区",null,2.3,72,122,8784,"杨家辉","马娜","三车间"]
[6,"22:02:00","鲁Q627AP","宫爱军","宫爱军",15253915869,"李海洋",13970,"WIN0050721","机制砂","中粗砂",96.22,22.68,73.54,7,1.5,3.3,"Ⅱ区",null,2.24,71.3,122,8698.6,"杨家辉","马娜","三车间"]
[7,"22:05:00","苏CGS000","周桂霖","黄亿武",15062093139,"庄团结",13971,"WIN0050720","机制砂","中粗砂",93.4,21.84,71.56,7,1.5,3.3,"Ⅱ区",null,2.16,69.4,122,8466.8,"杨家辉","马娜","三车间"]
[8,"22:15:00","苏C2A698","高雷","高雷",13913462579,"李海洋",13973,"WIN0050721","机制砂","中粗砂",112,30.06,81.94,7,1.5,3.3,"Ⅱ区",null,2.54,79.4,122,9686.8,"杨家辉","马娜","三车间"]
[9,"22:49:00","鲁Q636CQ","韩磊","柳西亮",18168677039,"李海洋",13974,"WIN0050722","石子","1-2#",68.34,18.14,50.2,{"$nulls":3},"良好",7,0.5,48.7,103,5016.1,"杨家辉","马娜"]
[10,"03:02:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13978,"WIN0050721","机制砂","中粗砂",87.82,21.6,66.22,6,2,2.9,"Ⅱ区",null,1.42,64.8,122,7905.6,"杨家辉","马娜"]
[11,"03:04:00","苏CGF365","冯永青","崔学良",13775854328,"李海洋",13977,"WIN0050721","机制砂","中粗砂",87.94,21.54,66.4,6,2,2.9,"Ⅱ区",null,1.4,65,122,7930,"杨家辉","马娜"]
[12,"03:14:00","鲁Q627AP","宫爱军","宫爱军",15253915869,"李海洋",13981,"WIN0050721","机制砂","中粗砂",99.2,22.88,76.32,8,2,2.9,"Ⅱ区",null,3.12,73.2,122,8930.4,"杨家辉","马娜"]
[]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N19)","v":868.18},{"$nulls":6},{"$f":"SUM(U5:U19)","v":849.3},null,{"$f":"SUM(W5:W19)","v":96884.8}]

{"sheet":"6.4","index":1,"n_rows":27,"n_cols":26,"rows_kept":27,"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 月 4 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"11:21:00","鲁Q627AP","宫爱军","宫爱军",15253915869,"庄团结",13987,"WIN0050732","机制砂","中粗砂",92.44,22.56,69.88,8,2.1,2.9,"Ⅱ区",null,2.88,67,122,{"$f":"U5*V5","v":8174},"陈金芳","杜娥"]
[2,"11:25:00","苏CGV338","汤可奇","宫东明",15563375779,"庄团结",13988,"WIN0050732","机制砂","中粗砂",92.28,21.5,70.78,8,2.1,2.9,"Ⅱ区",null,2.88,67.9,122,8283.8,"陈金芳","马娜"]
[3,"19:38:00","苏CGV338","汤可奇","宫东明",15563375779,"庄团结",13989,"WIN0050732","机制砂","中粗砂",21.58,21.58,71.28,7,1.6,2.9,"Ⅱ区",null,2.18,69.1,122,8430.2,"冯忠华","马娜"]
[4,"19:41:00","鲁Q627AP","宫爱军","宫爱军",15253915869,"庄团结",13990,"WIN0050732","机制砂","中粗砂",91.12,22.7,68.42,7,1.6,2.9,"Ⅱ区",null,2.12,66.3,122,8088.6,"冯忠华","马娜"]
[5,"20:25:00","苏CGS000","周桂霖","黄亿武",15062093139,"庄团结",13991,"WIN0050732","机制砂","中粗砂",92.28,21.68,70.6,7,1.6,2.9,"Ⅱ区",null,2.2,68.4,122,8344.8,"冯忠华","马娜"]
[6,"20:27:00","苏C2A698","高雷","高雷",13913462579,"庄团结",13992,"WIN0050732","机制砂","中粗砂",107.36,29.42,77.94,7,1.6,2.9,"Ⅱ区",null,2.34,75.6,122,9223.2,"冯忠华","马娜"]
[7,"21:18:00","苏CGA040","冯永盛","李城市",13913462579,"李海洋",13994,"WIN0050733","机制砂","中粗砂",93.46,21.58,71.88,8,1.6,2.9,"Ⅱ区",null,2.88,69,122,8418,"冯忠华","马娜"]
[8,"21:20:00","苏CGF365","冯永青","崔学良",13775854328,"李海洋",13995,"WIN0050733","机制砂","中粗砂",92.48,21.42,71.06,8,1.6,2.9,"Ⅱ区",null,2.86,68.2,122,8320.4,"冯忠华","马娜"]
[9,"21:21:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13996,"WIN0050733","机制砂","中粗砂",94.26,21.72,72.54,8,1.6,2.9,"Ⅱ区",null,2.94,69.6,122,8491.2,"冯忠华","马娜"]
[10,"04:02:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",14008,"WIN0050733","机制砂","中粗砂",99.98,21.58,78.4,9,2,2.9,"Ⅱ区",null,4,74.4,122,9076.8,"冯忠华","马娜"]
[11,"04:04:00","苏CGF365","冯永青","崔学良",13775854328,"李海洋",14006,"WIN0050733","机制砂","中粗砂",99,21.64,77.36,9,2,2.9,"Ⅱ区",null,3.96,73.4,122,8954.8,"冯忠华","马娜"]
[12,"04:06:00","苏CGA040","冯永盛","李城市",13913462579,"李海洋",14007,"WIN0050733","机制砂","中粗砂",93.16,21.14,72.02,9,2,2.9,"Ⅱ区",null,3.62,68.4,122,8344.8,"冯忠华","马娜"]
{"$rows_empty":10}
["合计",{"$nulls":12},{"$f":"SUM(N5:N26)","v":872.16},{"$nulls":6},{"$f":"SUM(U5:U26)","v":837.3},null,{"$f":"SUM(W5:W26)","v":102150.6}]

{"sheet":"巨野分公司","index":2,"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 月 4 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"05:45:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","014145","水泥","PO42.5",98.83,26.06,{"$f":"K5-L5","v":72.77},{"$nulls":5},{"v":0.003,"d":"0.30%"},72.55,525,{"$f":"T5*U5","v":38088.75},"冯海英","聂恒光"]
[2,"05:51:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","014146","水泥","PO42.5",99.18,25.95,73.23,{"$nulls":5},{"v":0.0033,"d":"0.33%"},73.01,525,38330.25,"冯海英","聂恒光"]
[3,"06:22:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","014147","机制沙","中粗",49.35,16.23,33.12,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[4,"06:25:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","014148","机制沙","中粗",50.33,16.36,33.97,{"$nulls":5},"0.17T",33.8,139,4698.2,"冯海英","聂恒光"]
[5,"06:28:00","鲁RJ5036","李翔","郭胜全",13395406029,"李翔","014149","钢棒","&10.7",48.09,31.78,16.31,{"$nulls":6},16.31,4850,79103.5,"冯海英","聂恒光"]
[6,"07:57:00","鲁JA5339","朱汪平","朱汪平",17705485906,"山东永信","014150","线材","&6.5",48.4,14.89,33.51,{"$nulls":6},33.51,4002,134107.02,"冯海英","聂恒光"]
[7,"08:05:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","014151","石子","1--2",29.03,8.44,20.59,{"$nulls":5},"0.19T",20.4,97,1978.8,"冯海英","聂恒光"]
[8,"08:08:00","鲁JB2331","王磊","王恩平",18653677018,"郑言克","014152","石子","1--2",48.88,14.73,34.15,{"$nulls":5},"0.15T",34,97,3298,"冯海英","聂恒光"]
[9,"08:12:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","014153","石子","1--2",48.48,14.39,34.09,{"$nulls":5},"0.19T",33.9,97,3288.3,"冯海英","聂恒光"]
[10,"08:20:00","鲁RJ5036","李翔","郭胜全",13395406029,"李翔","014154","钢棒","&9.0",31.79,14.28,17.51,{"$nulls":6},17.51,4850,84923.5,"冯海英","聂恒光"]
[11,"08:28:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","014155","石子","1--2",49.66,15.39,34.27,{"$nulls":5},"0.17T",34.1,97,3307.7,"冯海英","聂恒光"]
[12,"09:38:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","014156","石子","1--2",26.88,8.51,18.37,{"$nulls":5},"0.37T",18,97,1746,"冯海英","聂恒光"]
[13,"09:49:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014157","石子","1--2",30.96,8.55,22.41,{"$nulls":5},"0.11T",22.3,97,2163.1,"冯海英","聂恒光"]
[14,"10:58:00","鲁RN7809","张福兵","张福兵",15106407336,"英良运输","014158","机制沙","中粗",49.31,16.18,33.13,{"$nulls":5},"0.13T",33,139,4587,"冯海英","聂恒光"]
[15,"11:03:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","014159","机制沙","中粗",49.29,16.51,32.78,{"$nulls":5},"0.18T",32.6,139,4531.4,"冯海英","聂恒光"]
[16,"11:07:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014160","机制沙","中粗",49.68,16.68,33,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[17,"13:07:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","014161","石子","1--2",50.03,14.4,35.63,{"$nulls":5},"0.13T",35.5,97,3443.5,"冯海英","聂恒光"]
[18,"13:11:00","鲁JB2331","王磊","王恩军",18653677018,"郑言克","014162","石子","1--2",49.56,14.73,34.83,{"$nulls":5},"0.13T",34.7,97,3365.9,"冯海英","聂恒光"]
[19,"13:21:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","014163","机制沙","中粗",49.49,16.15,33.34,{"$nulls":3},".",null,"0.14T",33.2,139,4614.8,"冯海英","聂恒光"]
[20,"13:25:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","014164","机制沙","中粗",50.59,16.28,34.31,{"$nulls":5},"0.11T",34.2,139,4753.8,"冯海英","聂恒光"]
[21,"14:12:00","鲁RLA9469","付宁","付宁",15666910999,"英良运输","014165","机制沙","中粗",49.32,15.64,33.68,{"$nulls":5},"0.18T",33.5,139,4656.5,"冯海英","聂恒光"]
[22,"14:17:00","鲁RM9829","付兴顺","付兴顺",13285401222,"英良运输","014166","机制沙","中粗",50.44,15.69,34.75,{"$nulls":5},"0.15T",34.6,139,4809.4,"冯海英","聂恒光"]
[23,"14:39:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","014167","石子","1--2",25.77,8.49,17.28,{"$nulls":5},"0.58T",16.7,97,1619.9,"冯海英","聂恒光"]
[24,"14:45:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","014168","石子","1--2",28.38,8.53,19.85,{"$nulls":5},"0.55T",19.3,97,1872.1,"冯海英","聂恒光"]
[25,"14:49:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","014169","石子","1--2",28.57,8.43,20.14,{"$nulls":5},"0.14T",20,97,1940,"冯海英","聂恒光"]
[26,"14:58:00","鲁UC1188","高雨","高雨",18754032666,"英良运输","014170","机制沙","中粗",49.99,15.19,34.8,{"$nulls":5},"0.1T",34.7,139,4823.3,"冯海英","聂恒光"]
[27,"15:03:00","鲁RN3418","付长友","付长友",13954023888,"英良运输","014171","机制沙","中粗",49.65,15.73,33.92,{"$nulls":5},"0.12T",33.8,139,4698.2,"冯海英","聂恒光"]
[28,"15:14:00","鲁RN3418","张庆友","张庆友",17660309111,"英良运输","014172","机制沙","中粗",50.52,15.98,34.54,{"$nulls":5},"0.14T",34.4,139,4781.6,"冯海英","聂恒光"]
[29,"17:04:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","014173","石子","1--2",49.62,14.39,35.23,{"$nulls":5},"0.13T",35.1,97,3404.7,"冯海英","聂恒光"]
[30,"17:11:00","鲁JB2331","王磊","王恩军",18653677018,"郑言克","014174","石子","1--2",49.52,14.64,34.88,{"$nulls":5},"0.18T",34.7,97,3365.9,"冯海英","聂恒光"]
[31,"17:23:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","014175","机制沙","中粗",50.25,16.41,33.84,{"$nulls":5},"0.14T",33.7,139,4684.3,"冯海英","聂恒光"]
[32,"17:27:00","鲁RN7809","张福兵","张福兵",15106407336,"英良运输","014176","机制沙","中粗",50.23,16.02,34.21,{"$nulls":5},"0.11T",34.1,139,4739.9,"冯海英","聂恒光"]
[33,"17:30:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","014177","机制沙","中粗",49.7,16.53,33.17,{"$nulls":5},"0.17T",33,139,4587,"冯海英","聂恒光"]
[34,"18:54:00","鲁RN9429","魏翔远","米庆栋",18953005713,"英良运输","014178","机制沙","中粗",49.55,16.19,33.36,{"$nulls":5},"0.16T",33.2,139,4614.8,"冯海英","聂恒光"]
[35,"19:00:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","014179","机制沙","中粗",50.13,16.04,34.09,{"$nulls":5},"0.19T",33.9,139,4712.1,"冯海英","聂恒光"]
[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":488827.12}]