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

{"sheet":"邳州分公司","index":0,"n_rows":44,"n_cols":26,"rows_kept":44,"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 月 11 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"04:09:00","鲁Q2H788","高帮","高云雷",15162017575,"庄团结","退货",null,"河沙","中粗砂",{"$nulls":5},1.9,{"$nulls":6},"陈金芳","李彤彤","太细，退货"]
[2,"04:13:00","苏CJH446","陈肖飞","黄继忠",13585369881,"庄团结",12755,"WIN0050135","河沙","中粗砂",60.8,16.24,44.56,9,2.3,{"$nulls":3},2.26,42.3,125,{"$f":"U6*V6","v":5287.5},"陈金芳","李彤彤"]
[3,"06:12:00","鲁Q506BE","戴春宇","张胜",15105202990,"李海洋",12758,"WIN0050137","石子","1-2#",76.52,18.6,57.92,{"$nulls":3},"良好",7,0.52,57.4,98,5625.2,"陈金芳","李彤彤"]
[4,"06:22:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋",12759,"WIN0050137","石子","1-2#",75.34,18.7,56.64,{"$nulls":3},"良好",7,0.54,56.1,98,5497.8,"陈金芳","李彤彤"]
[5,"06:25:00","鲁Q522BG","魏辉","魏辉",15252200168,"李海洋",12760,"WIN0050137","石子","1-2#",103.54,23.14,80.7,{"$nulls":3},"含碎石",7,2,78.4,98,7683.2,"陈金芳","李彤彤"]
[6,"06:48:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",12761,"WIN0050137","石子","1-2#",106.98,22.78,84.2,{"$nulls":3},"良好",7,1,83.2,98,8153.6,"陈金芳","李彤彤"]
[7,"06:50:00","鲁Q611BY","周磊","周磊",13776756667,"李海洋",12762,"WIN0050137","石子","1-2#",91.22,17.46,73.76,{"$nulls":3},"良好",7,1.06,72.7,98,7124.6,"陈金芳","李彤彤"]
[8,"09:24:00","鲁DC1206","张富国","沈广",15852120079,"李海洋",12764,"WIN0050137","石子","1-2#",77.42,18.2,59.22,{"$nulls":3},"良好",7,0.52,58.7,98,5752.6,"陈金芳","李彤彤"]
[9,"09:36:00","鲁Q827AM","张富国","滕勇",15852109399,"李海洋",12765,"WIN0050137","石子","1-2#",88.9,20.1,68.8,{"$nulls":3},"良好",7,0.5,68.3,98,6693.4,"陈金芳","李彤彤"]
[10,"09:39:00","鲁Q153AK","郭照岗","张强明",13952276886,"李海洋",12766,"WIN0050137","石子","1-2#",103.38,22.94,80.44,{"$nulls":3},"良好",7,0.54,79.9,98,7830.2,"陈金芳","李彤彤"]
[11,"15:00:00","苏CJV709","戴建丽","刘德林",18762236617,"丁庆余",12767,"WIN0050136","石子","1-2#",75.94,18.4,57.54,{"$nulls":3},"良好",7,0.54,57,98,5586,"陈金芳","李彤彤"]
[12,"15:03:00","苏C2A698","高雷","高雷",13913462579,"杨需",12768,"WIN0050134","机制砂","中粗砂",107.2,29.4,77.8,5,1.6,2.9,"Ⅱ区",null,0.8,77,122,9394,"陈金芳","李彤彤"]
[13,"15:05:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",12769,"WIN0050134","机制砂","中粗砂",90.76,22.7,68.06,5,1.6,2.9,"Ⅱ区",null,0.76,67.3,122,8210.6,"陈金芳","李彤彤","三车间"]
[14,"15:07:00","苏CJV338","周桂林","李城市",18751653412,"杨需",12770,"WIN0050134","机制砂","中粗砂",88.7,21.72,66.98,5,1.6,2.9,"Ⅱ区",null,0.68,66.3,122,8088.6,"陈金芳","李彤彤"]
[15,"15:09:00","苏CGS000","周桂林","梅光喜",15396848658,"杨需",12771,"WIN0050134","机制砂","中粗砂",87.18,21.82,65.36,5,1.6,2.9,"Ⅱ区",null,0.66,64.7,122,7893.4,"陈金芳","李彤彤","三车间"]
[16,"15:16:00","鲁Q562BG","戴春宇","郑嘉雷",15862121767,"丁庆余",12772,"WIN0050136","石子","1-2#",106.38,22.76,83.62,{"$nulls":3},"良好",7,0.52,83.1,98,8143.8,"陈金芳","李彤彤"]
[17,"20:25:00","苏CJV709","戴建丽","刘德林",18762236617,"丁庆余",12775,"WIN0050136","石子","1-2#",73.12,18.12,55,{"$nulls":3},"良好",7,0.5,54.5,98,5341,"王瑶瑶","杜娥娥"]
[18,"20:29:00","苏C1T833","刘文龙","刘团结",13646114999,"丁庆余",12776,"WIN0050136","石子","1-2#",105.14,22.02,83.12,{"$nulls":3},"良好",7,3.02,80.1,98,7849.8,"王瑶瑶","杜娥娥"]
[19,"21:21:00","鲁Q562BG","戴春宇","郑嘉雷",15862121767,"丁庆余",12780,"WIN0050136","石子","1-2#",106.82,22.84,83.98,{"$nulls":3},"良好",7,0.58,83.4,98,8173.2,"王瑶瑶","杜娥娥"]
[20,"23::00","鲁Q502BY","戴春宇","陈大伟",15852102259,"李海洋",12782,"WIN0050137","石子","1-2#",77.74,19.04,58.7,{"$nulls":3},"良好",7,0.5,58.2,98,5703.6,"王瑶瑶","杜娥娥"]
[21,"23:01:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",12783,"WIN0050137","石子","1-2#",105.96,23.42,82.54,{"$nulls":3},"良好",7,0.54,82,98,8036,"王瑶瑶","杜娥娥"]
[22,"23:29:00","鲁Q233AA","彭兆","彭兆",15195487666,"李海洋",12784,"WIN0050137","石子","1-2#",97.38,20.2,77.18,{"$nulls":3},"良好",7,0.58,76.6,98,7506.8,"王瑶瑶","杜娥娥"]
[23,"23:32:00","鲁Q611BY","周磊","周磊",13776756667,"李海洋",12785,"WIN0050137","石子","1-2#",91.84,17.52,74.32,{"$nulls":3},"良好",7,0.52,73.8,98,7232.4,"王瑶瑶","杜娥娥"]
[24,"22:48:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋",12781,"WIN0050137","石子","1-2#",74.14,18.6,55.54,{"$nulls":3},"良好",7,0.54,55,98,5390,"王瑶瑶","杜娥娥"]
[25,"23:35:00","鲁Q855BR","宋振雨","宋振雨",13952132110,"李海洋",12786,"WIN0050137","石子","1-2#",93.64,18.94,74.7,{"$nulls":3},"良好",7,0.5,74.2,98,7271.6,"王瑶瑶","杜娥娥"]
[26,"23:52:00","苏C2A698","高雷","高雷",13913462579,"庄团结",12787,"WIN0050135","机制砂","中粗砂",108.02,29.46,78.56,5,1.8,2.9,"Ⅱ区",null,0.86,77.7,122,9479.4,"王瑶瑶","杜娥娥"]
[27,"23:54:00","苏CGS000","周桂林","梅光喜",15396848658,"庄团结",12788,"WIN0050135","机制砂","中粗砂",88.28,21.8,66.48,5,1.8,2.9,"Ⅱ区",null,0.68,65.8,122,8027.6,"王瑶瑶","杜娥娥"]
[28,"23:56:00","苏CGV338","周桂林","李城市",18751653412,"庄团结",12789,"WIN0050135","机制砂","中粗砂",89.44,21.4,68.04,5,1.8,2.9,"Ⅱ区",null,0.74,67.3,122,8210.6,"王瑶瑶","杜娥娥"]
[29,"23:59:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",12790,"WIN0050135","机制砂","中粗砂",92.76,22.5,70.26,5,1.8,2.9,"Ⅱ区",null,0.76,69.5,122,8479,"王瑶瑶","杜娥娥"]
[30,"00:12:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",12791,"WIN0050133","机制砂","中粗砂",89.12,21.38,67.74,8,2.2,2.9,"Ⅱ区",null,2.74,65,122,7930,"王瑶瑶","杜娥娥"]
[31,"00:16:00","鲁Q323CD","冯永青","刘宝云",19806019316,"李海洋",12792,"WIN0050133","机制砂","中粗砂",90,23.02,66.98,8,2.2,2.9,"Ⅱ区",null,2.68,64.3,122,7844.6,"王瑶瑶","杜娥娥"]
[32,"01:36:00","鲁Q9539H","张允宝","张允宝",13678695267,"李海洋",12794,"WIN0050137","石子","1-2#",98.53,18.36,80.16,{"$nulls":3},"良好",7,0.56,79.6,98,7800.8,"王瑶瑶","杜娥娥"]
[33,"05:30:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",12795,"WIN0050137","石子","1-2#",103.86,23,80.86,{"$nulls":3},"良好",7,0.56,80.3,98,7869.4,"王瑶瑶","杜娥娥"]
[34,"05:35:00","鲁Q827AM","张富国","滕勇",15852109399,"李海洋",12796,"WIN0050137","石子","1-2#",91.82,20.24,71.58,{"$nulls":3},"良好",7,1.08,70.5,98,6909,"王瑶瑶","杜娥娥"]
[35,"05:38:00","鲁DC1206","张富国","沈广",15852120079,"李海洋",12797,"WIN0050137","石子","1-2#",82.78,17.74,65.04,{"$nulls":3},"良好",7,1.04,64,98,6272,"王瑶瑶","杜娥娥"]
[36,"05:40:00","鲁Q153AK","郭照岗","张强明",13952276886,"李海洋",12798,"WIN0050137","石子","1-2#",101.78,23,78.78,{"$nulls":3},"良好",7,1.08,77.7,98,7614.6,"王瑶瑶","杜娥娥"]
[37,"05:44:00","鲁Q152AK","郭照岗","花伟",13921760292,"李海洋",12799,"WIN0050137","石子","1-2#",97.24,21.4,75.84,{"$nulls":3},"良好",7,1.04,74.8,98,7330.4,"王瑶瑶","杜娥娥"]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N43)","v":2541},{"$nulls":6},{"$f":"SUM(U5:U43)","v":2506.7},null,{"$f":"SUM(W5:W43)","v":263236.3}]

{"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 月 11 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:44:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","012925","水泥","PO42.5",104.16,25.64,{"$f":"K5-L5","v":78.52},{"$nulls":5},{"v":0.003,"d":"0.30%"},78.28,535,{"$f":"T5*U5","v":41879.8},"冯海英","聂恒光"]
[2,"06:47:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","012926","机制沙","中粗",49.45,16.25,33.2,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[3,"06:49:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","012927","机制沙","中粗",48.44,15.9,32.54,{"$nulls":5},"0.1T",32.4,139,4503.6,"冯海英","聂恒光"]
[4,"06:51:00","鲁RN1362","张旭","魏祥鹏",13583069007,"英良运输","012928","机制沙","中粗",50.18,15.96,34.22,{"$nulls":5},"0.1T",34.1,139,4739.9,"冯海英","聂恒光"]
[5,"06:53:00","鲁RD9081","刘士安","刘士安",17753041905,"李广坤","012929","机制沙","中粗",46.12,14.91,31.21,{"$nulls":5},"0.1T",31.1,139,4322.9,"冯海英","聂恒光"]
[6,"06:57:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","012930","水泥","PO42.5",101.08,26.25,74.83,{"$nulls":5},{"v":0.003,"d":"0.30%"},74.6,535,39911,"冯海英","聂恒光"]
[7,"07:42:00","鲁RM3027","张中强","张中强",15163082725,"英良运输","012931","机制沙","中粗",48.21,16.21,32,{"$nulls":5},"0.1T",31.9,139,4434.1,"冯海英","聂恒光"]
[8,"07:44:00","鲁RN1859","王江华","王江华",18954769126,"英良运输","012932","机制沙","中粗",49.12,15.97,33.15,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[9,"13:05:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","012933","矿粉",null,70.64,17.21,53.43,{"$nulls":5},{"v":0.003,"d":"0.30%"},53.27,370,19709.9,"冯海英","聂恒光"]
[10,"15:33:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","012934","机制沙","中粗",49.07,15.91,33.16,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[11,"15:35:00","鲁RE5553","陈长秋","侯代华",15864603123,"英良运输","012935","机制沙","中粗",49.25,16.22,33.03,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[12,"15:42:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","012936","机制沙","中粗",48.47,null,48.47,{"$nulls":8},0,"冯海英","聂恒光","退货"]
[13,"15:45:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","012937","机制沙","中粗",49.44,16.42,33.02,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[14,"15:47:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","012938","机制沙","中粗",49.69,16.43,33.26,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[15,"17:17:00","鲁RM2498","魏庆如","张庆收",13061551313,"英良运输","012939","机制沙","中粗",49.52,16.19,33.33,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[16,"17:26:00","鲁RN1859","王江华","程峰",18954769126,"英良运输","012940","机制沙","中粗",49.12,16.06,33.06,{"$nulls":5},"0.1T",32.9,139,4573.1,"冯海英","聂恒光"]
[17,"17:29:00","鲁RM3027","张中强","张中强",15163082725,"英良运输","012941","机制沙","中粗",48.35,16.1,32.25,{"$nulls":5},"0.1T",32.1,139,4461.9,"冯海英","聂恒光"]
[18,"17:53:00","鲁RN1362","张旭","张旭",17362277788,"英良运输","012942","机制沙","中粗",50.02,15.86,34.16,{"$nulls":5},"0.1T",34,139,4726,"冯海英","聂恒光"]
[19,"19:29:00","鲁RD9081","刘士安","刘士安",17753041905,"李广坤","012943","机制沙","中粗",46.48,14.84,31.64,{"$nulls":5},"0.1T",31.5,139,4378.5,"冯海英","聂恒光"]
[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":169777.5}]

{"sheet":"连云港分公司","index":2,"n_rows":20,"n_cols":25,"rows_kept":20,"merged":[[0,0,0,24],[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 月11日                                填表人 张传迎、杜华军                                   "]
[null,"单位：江苏大力神管桩有限公司连云港分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含杂质%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"01:23:00","0553","孙冲","张来高",13775439287,"孙冲",5404,"碎石","5~25",141.38,27.08,114.3,1.4,0.8,null,"I",{"v":0.102,"d":"10.2%"},1.3,113,90,null,"杜华军","张传迎"]
[2,"08:13:00","0553","孙冲","张来高",13775439287,"孙冲",5405,"碎石","5~25",139.5,27.16,112.34,1.5,0.8,null,"I",{"v":0.1,"d":"10.0%"},1.34,111,90,null,"杜华军","张传迎"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15,{"$nulls":11},{"$f":"SUM(M5:M18)","v":226.64},{"$nulls":6},{"$f":"SUM(T5:T18)","v":224}]
[null,"备注：退货也登记，在备注中注明不合格退货，所有重量和单价、金额均以0标记"]