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

{"sheet":"邳州公司","index":0,"n_rows":25,"n_cols":26,"rows_kept":25,"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 月 20日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"00:30:00","鲁Q956BY","王浩","臧琪",13505201115,"李海洋",13582,"WIN0050568","石子","1-2#",99.66,19.16,80.5,{"$nulls":3},"偏大颗粒较多",6,0,80.5,100,{"$f":"U5*V5","v":8050},"李凤","李彤彤","三车间"]
[2,"02:06:00","鲁Q000AJ","王浩","何杰",15852107231,"李海洋",13584,"WIN0050568","石子","1-2#",101.42,23.7,77.72,{"$nulls":3},"偏大颗粒较多",6,0.02,77.7,100,7770,"李凤","李彤彤","三车间"]
[3,"02:10:00","苏CGD838","王浩","薛良波",18852244533,"李海洋",13585,"WIN0050568","石子","1-2#",89.1,19.92,69.18,{"$nulls":3},"偏大颗粒较多",6,3.08,66.1,100,6610,"李凤","李彤彤","三车间"]
[4,"08:45:00","鲁Q718BZ","陈磊","胡光发",18761484744,"李海洋",13588,"WIN0050568","石子","1-2#",98.46,23.22,75.24,{"$nulls":3},"良好",7,0.54,74.7,100,7470,"李凤","李彤彤"]
[5,"08:49:00","鲁QV8018","孙立","王凤辉",17772257699,"李海洋",13589,"WIN0050568","石子","1-2#",95.4,24.12,71.28,{"$nulls":3},"良好",7,0.58,70.7,100,7070,"陈金芳","李彤彤"]
[6,"08:52:00","鲁QV7771","孙立","张海亮",17712028977,"李海洋",13590,"WIN0050568","石子","1-2#",95.24,23.22,72.02,{"$nulls":3},"良好",7,0.52,71.5,100,7150,"陈金芳","李彤彤"]
[7,"22:33:00","苏CGS000","周桂林","刘宝云",18906019310,"庄团结",13593,"WIN0050567","机制砂","中粗砂",93.3,21.82,71.48,7,1.8,2.8,"Ⅱ区",null,2.18,69.3,122,8454.6,"杨家辉","杜娥","三车间"]
[8,"22:35:00","苏C2A698","高雷","高雷",13913462579,"庄团结",13594,"WIN0050567","机制砂","中粗砂",106.56,29.46,77.1,7,1.8,2.8,"Ⅱ区",null,2.4,74.7,122,9113.4,"杨家辉","杜娥","三车间"]
[9,"23:28:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",13595,"WIN0050567","机制砂","中粗砂",91.68,22.48,69.2,7,1.8,2.8,"Ⅱ区",null,2.1,67.1,122,8186.2,"杨家辉","杜娥","三车间"]
[10,"01:34:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13596,"WIN0050566","机制砂","中粗砂",91.28,23.26,68.02,6,2,2.8,"Ⅱ区",null,1.42,66.6,122,8125.2,"杨家辉","杜娥"]
[11,"01:35:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13597,"WIN0050566","机制砂","中粗砂",89.44,21.18,68.26,6,2,2.8,"Ⅱ区",null,1.46,66.8,122,8149.6,"杨家辉","杜娥"]
{"$rows_empty":9}
["合计",{"$nulls":12},{"$f":"SUM(N5:N24)","v":800},{"$nulls":6},{"$f":"SUM(U5:U24)","v":785.7},null,{"$f":"SUM(W5:W24)","v":86149}]

{"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 月 20 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:07:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013890","水泥","PO42.5",99.5,26.2,{"$f":"K5-L5","v":73.3},{"$nulls":5},{"v":0.003,"d":"0.30%"},73.8,535,{"$f":"T5*U5","v":39483},"冯海英","聂恒光"]
[2,"06:09:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013891","水泥","PO42.5",97.44,26.13,71.31,{"$nulls":5},{"v":0.003,"d":"0.30%"},71.1,535,38038.5,"冯海英","聂恒光"]
[3,"06:40:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013892","石子","1--2",49.41,16.15,33.26,{"$nulls":5},"0.1T",33.1,97,3210.7,"冯海英","聂恒光"]
[4,"06:40:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013893","石子","1--2",50.41,16.18,34.23,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[5,"07:18:00","鲁RM9806","朱昌庆","刘景来",13355408966,"朱昌庆","013894","端板",null,44.65,24.16,20.49,{"$nulls":6},20.49,null,0,"冯海英","聂恒光"]
[6,"08:40:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013895","石子","1--2",28.81,8.52,20.29,{"$nulls":5},"0.1T",20.1,97,1949.7,"冯海英","聂恒光"]
[7,"08:42:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013896","石子","1--2",28.51,8.5,20.01,{"$nulls":5},"0.1T",19.9,97,1930.3,"冯海英","聂恒光"]
[8,"09:10:00","鲁RM9806","朱昌庆","刘景来",13355408966,"朱昌庆","013897","端板",null,24.16,14.51,9.65,{"$nulls":6},9.65,null,0,"冯海英","聂恒光"]
[9,"11:45:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013898","石子","1--2",49.63,15.41,34.22,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[10,"15:00:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","013899","机制沙","中粗",50.29,16.44,33.85,{"$nulls":5},"0.1T",33.7,139,4684.3,"冯海英","聂恒光"]
[11,"15:02:00","鲁RM1853","狄方丁","狄方丁",17661385222,"英良运输","013900","机制沙","中粗",50.48,15.43,35.05,{"$nulls":5},"0.1T",34.9,139,4851.1,"冯海英","聂恒光"]
[12,"15:04:00","鲁RM7658","谢红伟","谢红伟",15106407336,"英良运输","013901","机制沙","中粗",49.14,16.68,32.46,{"$nulls":5},"0.1T",32.3,139,4489.7,"冯海英","聂恒光"]
[13,"17:08:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013902","石子","1--2",29.47,8.45,21.02,{"$nulls":5},"0.1T",20.9,97,2027.3,"冯海英","聂恒光"]
[14,"17:11:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013903","石子","1--2",49.89,15.27,34.62,{"$nulls":5},"0.1T",34.5,97,3346.5,"冯海英","聂恒光"]
[15,"21:35:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013904","石子","1--2",49.12,16.03,33.09,{"$nulls":5},"0.1T",32.9,97,3191.3,"冯海英","聂恒光"]
[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":3},".",{"$nulls":4},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]
[24,{"$nulls":11},0,{"$nulls":8},{"$f":"T28*U28","v":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":113817.8}]