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

{"sheet":"邳州公司","index":0,"n_rows":16,"n_cols":26,"rows_kept":16,"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 月 21日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"02:50:00","鲁QV8991","孙立","韩洪吉",15195483119,"李海洋",13601,"WIN0050574","石子","1-2#",100.48,22.62,77.86,{"$nulls":3},"良好",7,0.56,77.3,100,{"$f":"U5*V5","v":7730},"王瑶瑶","杜娥"]
[2,"02:59:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13602,"WIN0050573","机制砂","中粗砂",91.3,23.34,67.96,5,1.8,2.8,"Ⅱ区",null,0.76,67.2,122,{"$f":"U6*V6","v":8198.4},"王瑶瑶","杜娥"]
{"$rows_empty":9}
["合计",{"$nulls":12},{"$f":"SUM(N5:N15)","v":145.82},{"$nulls":6},{"$f":"SUM(U5:U15)","v":144.5},null,{"$f":"SUM(W5:W15)","v":15928.4}]

{"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 月 21 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:44:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013905","石子","1--2",49.94,16.03,{"$f":"K5-L5","v":33.91},{"$nulls":5},"0.1T",33.8,97,{"$f":"T5*U5","v":3278.6},"冯海英","聂恒光"]
[2,"06:47:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","013906","石子","1--2",48.93,15.91,33.02,{"$nulls":5},"0.1T",32.9,97,3191.3,"冯海英","聂恒光"]
[3,"06:49:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013907","石子","1--2",49.99,16.25,33.74,{"$nulls":5},"0.1T",33.6,97,3259.2,"冯海英","聂恒光"]
[4,"07:04:00","鲁Q560CQ","李峰","李峰",13365383110,"李峰","013908","钢棒","&10.7",46.78,14.24,32.54,{"$nulls":6},32.14,null,0,"冯海英","聂恒光"]
[5,"07:31:00","鲁JA4258","王立强","王立强",18953823399,"王立强","013909","195线材","&6.5",47.97,15.02,32.95,{"$nulls":6},32.95,4178,137665.1,"冯海英","聂恒光"]
[6,"08:40:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013910","石子","1--2",49.65,16.62,33.03,{"$nulls":5},"0.2T",32.8,97,3181.6,"冯海英","聂恒光"]
[7,"08:42:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013911","石子","1--2",28.97,8.54,20.43,{"$nulls":5},"0.1T",20.3,97,1969.1,"冯海英","聂恒光"]
[8,"08:59:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013912","石子","1--2",26.8,8.5,18.3,{"$nulls":5},"0.1T",18.2,97,1765.4,"冯海英","聂恒光"]
[9,"09:56:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013913","石子","1--2",49.85,15.97,33.88,{"$nulls":5},"0.2T",33.6,97,3259.2,"冯海英","聂恒光"]
[10,"10:03:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013914","石子","1--2",49.68,15.71,33.97,{"$nulls":5},"0.2T",33.7,97,3268.9,"冯海英","聂恒光"]
[11,"10:15:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013915","石子","1--2",49.71,15.66,34.05,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[12,"12:07:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013916","石子","1--2",49.62,15.52,34.1,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[13,"13:42:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013917","石子","1--2",49.62,14.56,35.06,{"$nulls":5},"0.1T",34.9,97,3385.3,"冯海英","聂恒光"]
[14,"13:44:00","鲁JA4773","王双喜","王恩军",15588714111,"郑言克","013918","石子","1--2",49.49,14.71,34.78,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[15,"14:43:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013919","石子","1--2",27.89,8.46,19.43,{"$nulls":5},"0.2T",19.2,97,1862.4,"冯海英","聂恒光"]
[16,"14:45:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013920","石子","1--2",29.03,8.51,20.52,{"$nulls":5},"0.2T",20.3,97,1969.1,"冯海英","聂恒光"]
[17,"14:55:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013921","石子","1--2",49.87,15.61,34.26,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[18,"14:57:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013922","石子","1--2",49.91,15.93,33.98,{"$nulls":5},"0.1T",33.8,97,3278.6,"冯海英","聂恒光"]
[19,"14:59:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013923","石子","1--2",50.6,15.68,34.92,{"$nulls":3},".",null,"0.1T",34.8,97,3375.6,"冯海英","聂恒光"]
[20,"16:37:00","鲁H96E65","郭凯","郭凯",15064777797,"英良运输","013924","石子","1--2",49.84,16.54,33.3,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[21,"18:51:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013925","石子","1--2",30.06,8.48,21.58,{"$nulls":5},"0.2T",21.3,97,2066.1,"冯海英","聂恒光"]
[22,"18:52:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013926","石子","1--2",30.07,8.45,21.62,{"$nulls":5},"0.2T",21.4,97,2075.8,"冯海英","聂恒光"]
[23,"18:55:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013927","石子","1--2",49.24,15.55,33.69,{"$nulls":5},"0.2T",33.4,97,3239.8,"冯海英","聂恒光"]
[24,"19:25:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013928","石子","1--2",50.03,15.89,34.14,{"$nulls":5},"0.2T",33.9,97,3288.3,"冯海英","聂恒光"]
[25,"19:27:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013929","石子","1--2",49.92,15.61,34.31,{"$nulls":5},"0.2T",34.1,97,3307.7,"冯海英","聂恒光"]
[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":205157.7}]