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

{"sheet":"邳州公司","index":0,"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 年 5 月 13日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"08:52:00","鲁QV8018","孙立","王凤辉",17772257699,"李海洋",13414,"WIN0050483","石子","1-2#",98.44,23.54,74.9,{"$nulls":3},"良好",7,1.5,73.4,98,{"$f":"U5*V5","v":7193.2},"李凤","杜娥"]
[2,"14:57:00","苏CGV338","高雷","李城市",13913462579,"庄团结",13416,"WIN0050482","机制砂","中粗砂",91.16,21.48,69.68,7,2,2.9,"Ⅱ区",null,2.18,67.5,119,8032.5,"陈金芳","杜娥"]
[3,"14:59:00","苏CGS000","周桂林","刘宝云",18906019310,"庄团结",13417,"WIN0050482","机制砂","中粗砂",90.36,24.78,68.58,7,2,2.9,"Ⅱ区",null,2.08,66.5,119,7913.5,"陈金芳","杜娥"]
[4,"18:35:00","苏C1T986","李全亮","刘刚林",19984684567,"庄团结",13418,"WIN0050482","机制砂","中粗砂",110.68,23.02,87.66,7,2,2.9,"Ⅱ区",null,2.66,85,119,10115,"杨家辉","马娜"]
[5,"17:05:00","苏C7T337","李全亮","李波",15252241812,"庄团结",13419,"WIN0050482","机制砂","中粗砂",113.56,22.94,90.62,7,2,2.9,"Ⅱ区",null,2.72,87.9,119,10460.1,"杨家辉","马娜"]
[6,"17:09:00","苏CU6999","李全亮","冯黎明",18952238456,"庄团结",13420,"WIN0050482","机制砂","中粗砂",105.54,22.42,83.12,7,2,2.9,"Ⅱ区",null,2.52,80.6,119,9591.4,"杨家辉","马娜"]
[7,"21:35:00","鲁QV8855","孙立","姚婷辉",17712020577,"李海洋",13421,"WIN0050483","石子","1-2#",100.6,23.6,77,{"$nulls":3},"良好",7,1,76,98,7448,"杨家辉","马娜"]
[8,"21:39:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13422,"WIN0050483","石子","1-2#",98.34,23.68,74.66,{"$nulls":3},"良好",7,4.66,70,98,6860,"杨家辉","马娜"]
[9,"21:56:00","鲁QV8018","孙立","王凤辉",17772257699,"李海洋",13426,"WIN0050483","石子","1-2#",97.54,24.38,73.16,{"$nulls":3},"良好",7,2.76,70.4,98,6899.2,"杨家辉","马娜"]
[10,"22:45:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13427,"WIN0050481","机制砂","中粗砂",89.82,21.44,68.38,7,1.8,2.9,"Ⅱ区",null,2.08,66.3,119,7889.7,"杨家辉","马娜"]
[11,"22:48:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13428,"WIN0050481","机制砂","中粗砂",88.24,21.9,66.34,7,1.8,2.9,"Ⅱ区",null,2.04,64.3,119,7651.7,"杨家辉","马娜"]
[12,"22:50:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13429,"WIN0050481","机制砂","中粗砂",88.46,21.7,66.76,7,1.8,2.9,"Ⅱ区",null,2.06,64.7,119,7699.3,"杨家辉","马娜"]
[13,"02:57:00","鲁Q522BG","戴春宇","郑嘉磊",15862121767,"李海洋",13431,"WIN0050483","石子","1-2#",109.68,22.64,87.04,{"$nulls":3},"良好",7,0.54,86.5,100,8650,"杨家辉","马娜"]
[14,"03:21:00","鲁Q515BZ","冯波","郭方猛",13813273822,"李海洋",13432,"WIN0050483","石子","1-2#",111.12,26.7,84.42,{"$nulls":3},"良好",7,1.02,83.4,100,8340,"杨家辉","马娜"]
[15,"03:25:00","鲁Q338AA","冯波","娄雷",15062093660,"李海洋",13433,"WIN0050483","石子","1-2#",102.4,23.02,79.38,{"$nulls":3},"良好",7,1.08,78.3,100,7830,"杨家辉","马娜"]
[16,"04:10:00","鲁QV8018","孙立","王凤辉",17772257699,"李海洋",13434,"WIN0050483","石子","1-2#",99.76,24.32,75.44,{"$nulls":3},"良好",7,1.04,74.4,100,7440,"杨家辉","马娜"]
[17,"04:24:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13435,"WIN0050483","石子","1-2#",101.8,23.62,78.18,{"$nulls":3},"良好",7,1.08,77.1,100,7710,"杨家辉","马娜"]
[18,"04:30:00","鲁QV8991","孙立","彭杰",13775839508,"李海洋",13436,"WIN0050483","石子","1-2#",99.16,23.12,76.04,{"$nulls":3},"良好",7,1.04,75,100,7500,"杨家辉","马娜"]
[19,"04:32:00","鲁QV8855","孙立","姚婷辉",17712020577,"李海洋",13437,"WIN0050483","石子","1-2#",102.48,23.46,79.02,{"$nulls":3},"良好",7,1.02,78,100,7800,"杨家辉","马娜"]
[]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N26)","v":1460.38},{"$nulls":6},{"$f":"SUM(U5:U26)","v":1425.3},null,{"$f":"SUM(W5:W26)","v":153023.6}]

{"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年 5 月 13 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:05:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013727","水泥","PO42.5",98.47,25.89,{"$f":"K5-L5","v":72.58},{"$nulls":5},{"v":0.003,"d":"0.30%"},72.36,535,{"$f":"T5*U5","v":38712.6},"冯海英","聂恒光"]
[2,"06:08:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013728","水泥","PO42.5",100.96,25.94,75.02,{"$nulls":5},{"v":0.003,"d":"0.30%"},74.8,535,40018,"冯海英","聂恒光"]
[3,"07:59:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013729","石子","1--2",48.82,15.15,33.67,{"$nulls":5},"0.4T",33.2,97,3220.4,"冯海英","聂恒光"]
[4,"08:29:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013730","石子","1--2",49.65,14.66,34.99,{"$nulls":5},"0.2T",34.7,97,3365.9,"冯海英","聂恒光"]
[5,"09:13:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013731","石子","1--2",49.18,15.65,33.53,{"$nulls":5},"0.3T",33.2,97,3220.4,"冯海英","聂恒光"]
[6,"09:56:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013732","石子","1--2",26.8,8.51,18.29,{"$nulls":5},"02T",18,97,1746,"冯海英","聂恒光"]
[7,"09:58:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013733","石子","1--2",27.13,8.53,18.6,{"$nulls":5},"0.2T",18.4,97,1784.8,"冯海英","聂恒光"]
[8,"10:40:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013734","石子","1--2",49.47,14.61,34.86,{"$nulls":5},"0.1T",34.7,97,3365.9,"冯海英","聂恒光"]
[9,"12:29:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013735","石子","1--2",50.16,16.11,34.05,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[10,"12:31:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013736","石子","1--2",49.94,16.08,33.86,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[11,"12:45:00","鲁H08B83","陈连春","马凡光",18954794883,"莱芜延辉","013737","减水剂",null,32.55,15.53,17.02,{"$nulls":6},17.02,1900,32338,"冯海英","聂恒光"]
[12,"14:00:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013738","石子","1--2",49.02,16.39,32.63,{"$nulls":5},"0.2T",32.4,97,3142.8,"冯海英","聂恒光"]
[13,"16:01:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013739","石子","1--2",49.64,16.05,33.59,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[14,"16:03:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013740","石子","1--2",49.22,16.03,33.19,{"$nulls":5},"0.1T",33,97,3201,"冯海英","聂恒光"]
[15,"19:38:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013741","石子","1--2",49.41,16.53,32.88,{"$nulls":5},"0.1T",32.7,97,3171.9,"冯海英","聂恒光"]
[16,"21:02:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013742","矿粉",null,68.98,16.97,52.01,{"$nulls":5},{"v":0.003,"d":"0.30%"},51.85,370,19184.5,"冯海英","聂恒光"]
[17,"21:07:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013743","石子","1--2",49.58,16,33.58,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[18,"21:09:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013744","石子","1--2",49.77,15.99,33.78,{"$nulls":5},"0.1T",33.6,97,3259.2,"冯海英","聂恒光"]
[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":172768.2}]