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

{"sheet":"邳州分公司","index":0,"n_rows":32,"n_cols":26,"rows_kept":32,"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 月 5日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"17:47:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13225,"WIN0050363","机制砂","中粗砂",91.4,21.48,69.92,6,1.8,2.9,"Ⅱ区",null,1.42,68.5,119,{"$f":"U5*V5","v":8151.5},"王瑶瑶","马娜"]
[2,"21:10:00","鲁Q502BY","戴春宇","王戈义",15152016113,"段俊成",13226,"WIN0050366","石子","1-5#",72.64,19.24,53.4,{"$nulls":3},"良好",7,0.5,52.9,98,5184.2,"王瑶瑶","马娜"]
[3,"21:16:00","苏CCZ319","庄猛","刘军",18251586223,"庄团结",13227,"WIN0050364","机制砂","中粗砂",72.38,16.68,55.7,6,1.8,2.9,"Ⅱ区",null,1.2,54.5,119,6485.5,"王瑶瑶","马娜"]
[4,"21:24:00","苏CHK123","庄猛","陈丁",15252204580,"庄团结",13228,"WIN0050364","机制砂","中粗砂",72.88,16.98,55.9,6,1.8,2.9,"Ⅱ区",null,0.2,54.7,119,6509.3,"王瑶瑶","马娜"]
[5,"21:27:00","苏CHW072","庄宁","贾方乐",18112214446,"庄团结",13229,"WIN0050364","机制砂","中粗砂",75.4,17.38,58.02,6,1.8,2.9,"Ⅱ区",null,1.22,56.8,119,6759.2,"王瑶瑶","马娜"]
[6,"21:27:00","苏CV9188","庄二团","白喜阳",13370990088,"庄团结",13230,"WIN0050364","机制砂","中粗砂",69.98,17.48,52.5,6,1.8,2.9,"Ⅱ区",null,1.1,51.4,119,6116.6,"王瑶瑶","马娜"]
[7,"21:32:00","苏CHJ119","庄二团","刘照钱",18751671739,"庄团结",13231,"WIN0050364","机制砂","中粗砂",74.72,17.6,57.12,6,1.8,2.9,"Ⅱ区",null,1.22,55.9,119,6652.1,"王瑶瑶","马娜"]
[8,"21:45:00","苏CDM071","杜坤","杜辉",15062043488,"庄团结",13232,"WIN0050364","机制砂","中粗砂",73.92,17.22,56.7,6,1.8,2.9,"Ⅱ区",null,1.2,55.5,119,6604.5,"王瑶瑶","马娜"]
[9,"21:47:00","苏CH6588","庄猛","王志勇",15852275790,"庄团结",13233,"WIN0050364","机制砂","中粗砂",72.06,17.06,55,6,1.8,2.9,"Ⅱ区",null,1.1,53.9,119,6414.1,"王瑶瑶","马娜"]
[10,"21:49:00","苏CU3668","庄楠","张凯",18751667158,"庄团结",13234,"WIN0050364","机制砂","中粗砂",70.66,17.48,53.18,6,1.8,2.9,"Ⅱ区",null,1.08,52.1,119,6199.9,"王瑶瑶","马娜"]
[11,"21:54:00","鲁Q188BD","戴春宇","李宋",18913488722,"段俊成",13235,"WIN0050366","石子","1-5#",76.26,19.38,56.88,{"$nulls":3},"良好",7,0.58,56.3,98,5517.4,"王瑶瑶","马娜"]
[12,"23:41:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13228,"WIN0050363","机制砂","中粗砂",85.94,23.44,62.5,7,1.8,2.9,"Ⅱ区",null,1.9,60.6,119,7211.4,"王瑶瑶","马娜"]
[13,"00:21:00","苏CJA596","李海洋","李海洋",15005229789,"李海洋","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[14,"00:27:00","苏C9T292","庄尚","程宁",18751665165,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[15,"00:35:00","苏CJY880","庄团结","吕鹏",15190796222,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[16,"00:37:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13242,"WIN0050363","机制砂","中粗砂",92.34,21.54,70.8,7,1.8,2.9,"Ⅱ区",null,2.2,68.6,119,{"$f":"U20*V20","v":8163.4},"王瑶瑶","马娜"]
[17,"00:41:00","苏CGB136","丙运军","丙运军",13629251378,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[18,"00:44:00","冀B5378A","庄团驻","庄团驻",15852064444,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[19,"00:47:00","苏CHJ376","庄二团","庄二团",13952277209,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[20,"00:49:00","苏CHC869","丙赛","丙赛",13605222731,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[21,"00:52:00","冀BW0521","付学辉","付学辉",13805223296,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[22,"00:55:00","苏CGK409","庄楠","庄汉斌",13705222089,"庄团结","退货",null,"镍砂","中粗砂",{"$nulls":12},"王瑶瑶","马娜","含粉量10%，退货"]
[23,"01:41:00","鲁D39525","尹振刚","尹振义",13775858067,"庄团结",13149,"WIN0050364","机制砂","中粗砂",79.6,17.34,62.26,6,1.8,2.9,"Ⅱ区",null,1.26,61,119,{"$f":"U27*V27","v":7259},"王瑶瑶","马娜"]
[24,"06:37:00","鲁Q522BG","戴春宇","郑嘉磊",15862121767,"李海洋",13250,"WIN0050365","石子","1-2#",102.68,22.42,80.26,{"$nulls":3},"良好",7,0.56,79.7,98,{"$f":"U28*V28","v":7810.6},"王瑶瑶","马娜"]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N31)","v":900.14},{"$nulls":6},{"$f":"SUM(U5:U31)","v":882.4},null,{"$f":"SUM(W5:W31)","v":101038.7}]

{"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 月 5 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"05:47:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013527","水泥","PO42.5",99.61,28.19,{"$f":"K5-L5","v":71.42},{"$nulls":5},{"v":0.003,"d":"0.30%"},71.2,535,{"$f":"T5*U5","v":38092},"冯海英","聂恒光"]
[2,"05:50:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013528","水泥","PO42.5",98.45,25.95,72.5,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.28,535,38669.8,"冯海英","聂恒光"]
[3,"07:07:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013529","石子","1--2",49.67,16.19,33.48,{"$nulls":5},"0.2T",33.2,97,3220.4,"冯海英","聂恒光"]
[4,"07:09:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013230","石子","1--2",26.45,8.46,17.99,{"$nulls":5},"0.2T",17.7,97,1716.9,"冯海英","聂恒光"]
[5,"07:11:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013531","石子","1--2",25.99,8.44,17.55,{"$nulls":5},"0.2T",17.3,97,1678.1,"冯海英","聂恒光"]
[6,"07:13:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013532","石子","1--2",49.91,16.03,33.88,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[7,"08:02:00","鲁H29972","刘运武","刘运武",15092851971,"刘运武","013533","带钢","148*1.2",48.95,16.14,32.81,{"$nulls":6},32.81,null,0,"冯海英","聂恒光"]
[8,"10:34:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013534","矿粉",null,71.4,16.99,54.41,{"$nulls":5},{"v":0.003,"d":"0.30%"},54.24,370,20068.8,"冯海英","聂恒光"]
[9,"12:36:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013535","石子","1--2",26.18,8.52,17.66,{"$nulls":5},"0.3T",17.3,97,1678.1,"冯海英","聂恒光"]
[10,"12:38:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013536","石子","1--2",25.87,8.53,17.34,{"$nulls":5},"0.3T",17,97,1649,"冯海英","聂恒光"]
[11,"12:41:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013537","机制沙","中粗",48.78,16.32,32.46,{"$nulls":5},"0.1T",32.3,139,4489.7,"冯海英","聂恒光"]
[12,"12:43:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","013538","机制沙","中粗",48.98,15.05,33.93,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[13,"13:05:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013539","机制沙","中粗",45.97,13.88,32.09,{"$nulls":5},"0.1T",31.9,139,4434.1,"冯海英","聂恒光"]
[14,"14:55:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013540","石子","1--2",49.19,15.97,33.22,{"$nulls":5},"0.2T",33,97,3201,"冯海英","聂恒光"]
[15,"14:57:00","鲁H78E87","张庆刚","张庆刚",15853706592,"郑言克","013541","石子","1--2",49.57,15.66,33.91,{"$nulls":5},"0.2T",33.7,97,3268.9,"冯海英","聂恒光"]
[16,"17:58:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013542","石子","1--2",25.72,8.49,17.23,{"$nulls":5},"1T",16.2,97,1571.4,"冯海英","聂恒光"]
[17,"18:00:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013543","石子","1--2",26.83,8.49,18.34,{"$nulls":5},"1T",17.3,97,1678.1,"冯海英","聂恒光"]
[18]
[19,"合计：",{"$nulls":19},{"$f":"SUM(V5:V22)","v":133383.4}]
[20,{"$nulls":11},{"$f":"K24-L24","v":0},{"$nulls":8},{"$f":"T24*U24","v":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},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:V23)","v":266766.8}]