{"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 月 21 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:24:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013226","石子","1--2",48.3,16.01,{"$f":"K5-L5","v":32.29},{"$nulls":5},"0.1T",32.1,97,{"$f":"T5*U5","v":3113.7},"冯海英","聂恒光"]
[2,"06:29:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013227","石子","1--2",49.16,15.92,33.24,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[3,"06:32:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013228","石子","1--2",46.59,15.75,30.84,{"$nulls":5},"0.1T",30.7,97,2977.9,"冯海英","聂恒光"]
[4,"06:34:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013229","石子","1--2",49.09,16.12,32.97,{"$nulls":5},"0.1T",32.8,97,3181.6,"冯海英","聂恒光"]
[5,"07:19:00","赣C3G557","王祥济","王祥济",15298610071,"王祥济","013230","钢棒","&9.0",48.78,38.49,10.29,{"$nulls":6},10.29,null,0,"冯海英","聂恒光"]
[6,"08:04:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013231","石子","1--2",28.79,8.5,20.29,{"$nulls":5},"0.3T",19.9,97,1930.3,"冯海英","聂恒光"]
[7,"09:09:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013232","石子","1--2",25.91,8.6,17.31,{"$nulls":5},"0.3T",17,97,1649,"冯海英","聂恒光"]
[8,"09:11:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013233","石子","1--2",26.26,8.63,17.63,{"$nulls":5},"0.3T",17.3,97,1678.1,"冯海英","聂恒光"]
[9,"10:01:00","赣C3G557","王祥济","王祥济",15298610071,"王祥济","013234","钢棒","&10.7",38.49,16.43,22.06,{"$nulls":6},22.06,null,0,"冯海英","聂恒光"]
[10,"12:12:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013235","机制沙","中粗",49.59,15.96,33.63,{"$nulls":5},"0.1T",33.5,139,4656.5,"冯海英","聂恒光"]
[11,"12:14:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","013236","机制沙","中粗",49.04,15.15,33.89,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[12,"12:16:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013237","石子","1--2",49.99,15.41,34.58,{"$nulls":5},"0.3T",34.2,97,3317.4,"冯海英","聂恒光"]
[13,"13:02:00","鲁RB1266","李江红","李江红",15266991988,"莱芜延辉","013238","减水剂",null,31.44,14.41,17.03,{"$nulls":6},17.03,1900,32357,"冯海英","聂恒光"]
[14,"14:24:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013239","石子","1--2",49.53,15.87,33.66,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[15,"14:26:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013240","石子","1--2",48.93,15.68,33.25,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[16,"14:38:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013241","石子","1--2",49.6,14.54,35.06,{"$nulls":5},"0.1T",34.9,97,3385.3,"冯海英","聂恒光"]
[17,"14:40:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013242","石子","1--2",50.01,14.36,35.65,{"$nulls":5},"0.1T",35.5,97,3443.5,"冯海英","聂恒光"]
[18,"15:41:00","鲁RL7377","李斌","王帅",18264007774,"李广坤","013243","石子","1--2",26.15,8.57,17.58,{"$nulls":5},"0.3T",17.2,97,1668.4,"冯海英","聂恒光"]
[19,"15:43:00","鲁RL3873","兰守玉","兰守玉",15376102612,"郑言克","013244","机制沙","中粗",49.34,15.45,33.89,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[20,"15:45:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013245","石子","1--2",27.7,8.54,19.16,{"$nulls":5},"0.3T",18.8,97,1823.6,"冯海英","聂恒光"]
[21,"16:14:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013246","石子","1--2",27.39,8.6,18.79,{"$nulls":5},"0.3T",18.4,97,1784.8,"冯海英","聂恒光"]
[22,"19:30:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013247","机制沙","中粗",49.49,15.91,33.58,{"$nulls":5},"0.1T",33.4,139,4642.6,"冯海英","聂恒光"]
[23,"19:32:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","013248","机制沙","中粗",49.59,15.06,34.53,{"$nulls":5},"0.1T",34.4,139,4781.6,"冯海英","聂恒光"]
[24,"19:35:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013249","石子","1--2",49.53,15.35,34.18,{"$nulls":5},"0.3T",33.8,97,3278.6,"冯海英","聂恒光"]
[25,"19:56:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013250","矿粉",null,69.42,17.11,52.31,{"$nulls":5},{"v":0.003,"d":"0.30%"},52.15,370,19295.5,"冯海英","聂恒光"]
[26,"20:23:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013251","水泥","PO42.5",101.53,26.06,75.47,{"$nulls":5},{"v":0.003,"d":"0.30%"},75.24,535,40253.4,"冯海英","聂恒光"]
[27,"20:25:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013252","石子","1--2",49.91,14.57,35.34,{"$nulls":5},"0.1T",35.2,97,3414.4,"冯海英","聂恒光"]
[28,"20:27:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013253","石子","1--2",49.85,16.05,33.8,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[29,"20:29:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013254","石子","1--2",48.84,15.99,32.85,{"$nulls":5},"0.1T",32.7,97,3171.9,"冯海英","聂恒光"]
[30,"21:15:00","鲁RM1362","张旭","宋化卿",15990979076,"英良运输","013255","石子","1--2",49.4,15.97,33.43,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[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":171343.6}]

{"sheet":"邳州分公司","index":1,"n_rows":15,"n_cols":26,"rows_kept":15,"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 月 21 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"08:16:00","鲁Q188BD","戴春宇","李宋",18913488722,"李海洋",13065,"WIN0050237","石子","1-2#",76.34,18.62,57.72,{"$nulls":3},"良好",7,0.52,57.2,98,{"$f":"U5*V5","v":5605.6},"李凤","杜娥"]
[2,"10:37:00","苏C1T837","戴春宇","吴云龙",15252222092,"李海洋",13066,"WIN0050237","石子","1-2#",100.34,22.32,78.02,{"$nulls":3},"含少量泥块",8,2.02,76,98,7448,"刘会良","杜娥"]
[3,"13:05:00","鲁Q836BG","戴春宇","刘伟",13952192088,"李海洋",13067,"WIN0050237","石子","1-2#",78.24,19.02,59.22,{"$nulls":3},"良好",7,1.02,58.2,98,5703.6,"刘会良","杜娥"]
[4,"23:53:00","苏CGP356","冯永清","马飞",13951463058,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":5},3.2,{"$nulls":6},"杨家辉","马娜","细度模数3.2，偏粗，退货"]
[5,"23:55:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":5},3.2,{"$nulls":6},"杨家辉","马娜","细度模数3.2，偏粗，退货"]
[6,"23:56:00","鲁Q323CD","冯永青","刘宝云",19806019316,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":5},3.2,{"$nulls":6},"杨家辉","马娜","细度模数3.2，偏粗，退货"]
[]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N14)","v":194.96},{"$nulls":6},{"$f":"SUM(U5:U14)","v":191.4},null,{"$f":"SUM(W5:W14)","v":18757.2}]