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

{"sheet":"邳州分公司","index":0,"n_rows":33,"n_cols":26,"rows_kept":33,"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 月 18 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"13:33:00","鲁Q300BD","丁大庆","索兴旺",13952122752,"李海洋",12993,"WIN0050201","石子","1-2#",118.86,28.02,90.84,{"$nulls":3},"含碎石、黄皮",8,2.04,88.8,98,{"$f":"U5*V5","v":8702.4},"刘会良","杜娥"]
[2,"13:37:00","鲁Q516AW","丁大庆","王虎",13270270878,"李海洋",12994,"WIN0050201","石子","1-2#",109.7,23.42,86.28,{"$nulls":3},"含碎石、黄皮",8,2.08,84.2,98,8251.6,"刘会良","杜娥"]
[3,"16:53:00","苏CGP356","冯永清","马飞",13951463058,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":4},3.4,{"$nulls":7},"杨家辉","杜娥","含泥量超标，退货"]
[4,"16:54:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":4},3.2,{"$nulls":7},"杨家辉","杜娥","含泥量超标，退货"]
[5,"16:56:00","鲁Q323CD","冯永青","刘宝云",19806019316,"李海洋","退货",null,"机制砂","中粗砂",{"$nulls":4},3.2,{"$nulls":7},"杨家辉","杜娥","含泥量超标，退货"]
[6,"18:46:00","鲁Q366CQ","戴春宇","柳玉良",13775857003,"丁庆余",12998,"WIN0050200","石子","1-2#",92.44,18.8,73.56,{"$nulls":3},"良好",7,0.56,73,98,7154,"王瑶瑶","马娜"]
[7,"17:22:00","苏CJV193","丁培善","李民",15062056402,"李海洋",12999,"WIN0050201","石子","1-2#",110.88,24.28,86.6,{"$nulls":3},"良好",7,0.5,86.1,98,8437.8,"王瑶瑶","马娜"]
[8,"19:49:00","苏CGV338","周桂林","李城市",18751653412,"杨需",13000,"WIN0050198","机制砂","中粗砂",92.08,21.64,70.44,5,2,2.8,"Ⅱ区",null,0.74,69.7,119,8294.3,"王瑶瑶","马娜"]
[9,"19:52:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",13001,"WIN0050198","机制砂","中粗砂",92.4,22.68,67.72,5,2,2.8,"Ⅱ区",null,0.72,69,119,8211,"王瑶瑶","马娜"]
[10,"20:29:00","鲁Q338AA","冯波","刘金虎",17318833688,"李海洋",13002,"WIN0050201","石子","1-2#",104.56,22.88,81.68,{"$nulls":3},"良好",7,0.58,81.1,98,7947.8,"王瑶瑶","马娜"]
[11,"20:36:00","鲁Q152AK","冯波","李响",18501414148,"李海洋",13004,"WIN0050201","石子","1-2#",97.86,21.74,76.12,{"$nulls":3},"良好",7,0.52,75.6,98,7408.8,"王瑶瑶","马娜"]
[12,"21:13:00","鲁Q515BZ","王彬","郭方猛",13347936982,"李海洋",13006,"WIN0050201","石子","1-2#",108.98,26.5,82.48,{"$nulls":3},"良好",7,0.58,81.9,98,8026.2,"王瑶瑶","马娜"]
[13,"23:32:00","鲁Q562BG","魏辉","魏辉",15252200168,"丁庆余",13008,"WIN0050200","石子","1-2#",108.18,23.24,84.84,{"$nulls":3},"良好",7,0.54,84.4,98,8271.2,"王瑶瑶","马娜"]
[14,"23:43:00","鲁Q366CQ","戴春宇","柳玉良",13775857003,"丁庆余",13009,"WIN0050200","石子","1-2#",93.74,18.7,75.04,{"$nulls":3},"良好",7,0.54,74.5,98,7301,"王瑶瑶","马娜"]
[15,"00:43:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋",13010,"WIN0050201","石子","1-2#",77.7,19.24,58.46,{"$nulls":3},"良好",7,0.56,57.9,98,5674.2,"王瑶瑶","马娜"]
[16,"00:50:00","苏C1T837","戴春宇","吴云龙",15252222092,"李海洋",13011,"WIN0050201","石子","1-2#",106.46,22.9,83.56,{"$nulls":3},"良好",7,1.06,82.5,98,8085,"王瑶瑶","马娜"]
[17,"01:46:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",13012,"WIN0050201","石子","1-2#",106.48,22.78,83.7,{"$nulls":3},"良好",7,1,82.7,98,8104.6,"王瑶瑶","马娜"]
[18,"02:01:00","鲁Q582BY","陈大伟","陈大伟",15852102259,"丁庆余",13013,"WIN0050200","石子","1-2#",71.9,16.7,55.2,{"$nulls":3},"良好",7,0.5,54.7,98,5360.6,"王瑶瑶","马娜"]
[19,"02:23:00","鲁Q188BD","戴春宇","李宋",18913488722,"李海洋",13014,"WIN0050201","石子","1-2#",78.72,18.7,60.02,{"$nulls":3},"良好",7,0.52,59.5,98,5831,"王瑶瑶","马娜"]
[20,"04:38:00","苏CGP356","冯永清","马飞",13951463058,"李海洋",13016,"WIN0050197","机制砂","中粗砂",93.32,21.66,71.66,8,2.2,2.8,"Ⅱ区",null,2.96,68.7,119,8175.3,"王瑶瑶","马娜"]
[22,"04:39:00","鲁Q323CD","冯永青","刘宝云",19806019316,"李海洋",13017,"WIN0050197","机制砂","中粗砂",94.12,23.24,70.88,8,2.2,2.8,"Ⅱ区",null,2.88,68,119,8092,"王瑶瑶","马娜"]
[23,"04:42:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",13018,"WIN0050198","机制砂","中粗砂",93.98,22.52,71.46,5,1.8,2.8,"Ⅱ区",null,0.76,70.7,119,8413.3,"王瑶瑶","马娜"]
[24,"04:45:00","苏CGV338","周桂林","李城市",18751653412,"杨需",13019,"WIN0050198","机制砂","中粗砂",95.92,21.54,74.38,5,1.8,2.8,"Ⅱ区",null,0.78,73.6,119,8758.4,"王瑶瑶","马娜"]
[]
[]
[]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N32)","v":1504.92},{"$nulls":6},{"$f":"SUM(U5:U32)","v":1486.6},null,{"$f":"SUM(W5:W32)","v":154500.5}]

{"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年 4 月 18 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"21:49:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013086","水泥","PO42.5",96.89,26.11,{"$f":"K5-L5","v":70.78},{"$nulls":5},{"v":0.003,"d":"0.30%"},70.56,535,{"$f":"T5*U5","v":37749.6},"冯海英","聂恒光","接17号"]
[2,"06:40:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013087","石子","1--2",50.2,16.07,34.13,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[3,"06:42:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013088","石子","1--2",50.02,16,34.02,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[4,"07:28:00","苏GB5637","万延强","万延强",15061351568,"万延强","013089","钢棒","&10.7",48.21,30.68,17.53,{"$nulls":6},17.53,4790,83968.7,"冯海英","聂恒光"]
[5,"08:00:00","鲁RN1859","王江华","王江华",18555119799,"英良运输","013090","石子","1--2",48.29,15.84,32.45,{"$nulls":5},"0.1T",32.3,97,3133.1,"冯海英","聂恒光"]
[6,"09:38:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013091","石子","1--2",49.54,15.8,33.74,{"$nulls":5},"0.3T",33.4,97,3239.8,"冯海英","聂恒光"]
[7,"09:40:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013092","石子","1--2",25.42,8.62,16.8,{"$nulls":5},"0.3T",16.5,97,1600.5,"冯海英","聂恒光"]
[8,"09:42:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013093","石子","1--2",49.36,14.67,34.69,{"$nulls":5},"0.1T",34.5,97,3346.5,"冯海英","聂恒光"]
[9,"09:44:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013094","石子","1--2",49.85,14.46,35.39,{"$nulls":5},"0.1T",35.2,97,3414.4,"冯海英","聂恒光"]
[10,"10:04:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013095","石子","1--2",49.54,15.01,34.53,{"$nulls":5},"0.4T",34.1,97,3307.7,"冯海英","聂恒光"]
[11,"10:07:00","鲁RM5188","李斌","安孔青",15163023899,"李广坤","013096","石子","1--2",26.49,8.65,17.84,{"$nulls":5},"0.2T",17.6,97,1707.2,"冯海英","聂恒光"]
[12,"10:27:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013097","石子","1--2",49.18,16.05,33.13,{"$nulls":5},"0.1T",33,97,3201,"冯海英","聂恒光"]
[13,"10:30:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","013098","石子","1--2",50.64,16.06,34.58,{"$nulls":5},"0.1T",34.4,97,3336.8,"冯海英","聂恒光"]
[14,"10:32:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013099","石子","1--2",49.45,15.98,33.47,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[15,"10:41:00","鲁RN1859","王江华","王江华",18555119799,"英良运输","013100","石子","1--2",49.6,15.8,33.8,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[16,"10:46:00","鲁RL5456","吕东华","吕东华",15562719795,"李广坤","013101","石子","1--2",49.82,15.78,34.04,{"$nulls":5},"0.1T",33.9,97,3288.3,"冯海英","聂恒光"]
[17,"12:08:00","苏GB5637","万延强","万延强",15061351568,"万延强","013102","钢棒","&9.0",30.69,15.56,15.13,{"$nulls":6},15.13,4790,72472.7,"冯海英","聂恒光"]
[18,"12:10:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013103","石子","1--2",49.37,15.81,33.56,{"$nulls":5},"0.3T",33.2,97,3220.4,"冯海英","聂恒光"]
[19,"12:13:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013104","机制沙","中粗",45.41,13.87,31.54,{"$nulls":5},"0.1T",31.4,139,4364.6,"冯海英","聂恒光"]
[20,"12:15:00","鲁RM3845","陈长秋","张先会",15990979150,"英良运输","013105","机制沙","中粗",49.39,15.11,34.28,{"$nulls":5},"0.1T",34.1,139,4739.9,"冯海英","聂恒光"]
[21,"12:17:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013106","机制沙","中粗",48.94,16.31,32.63,{"$nulls":5},"0.1T",32.5,139,4517.5,"冯海英","聂恒光"]
[22,"12:20:00","鲁RH8993","陈平西","李玉山",15215490396,"英良运输","013107","机制沙","中粗",49.35,15.98,33.37,{"$nulls":5},"0.1T",33.2,139,4614.8,"冯海英","聂恒光"]
[23,"12:29:00","鲁RK0329","陈平西","张华洗",15615708910,"英良运输","013108","机制沙","中粗",48.75,15.51,33.24,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[24,"13:30:00","鲁PH8537","陈平西","任重连",18661581646,"英良运输","013109","机制沙","中粗",46.22,14.11,32.11,{"$nulls":5},"0.1T",32,139,4448,"冯海英","聂恒光"]
[25,"14:31:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013110","石子","1--2",49.4,14.62,34.78,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[26,"14:32:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013111","石子","1--2",49.51,14.42,35.09,{"$nulls":5},"0.1T",34.9,97,3385.3,"冯海英","聂恒光"]
[27,"14:41:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013112","石子","1--2",26.14,8.58,17.56,{"$nulls":5},"0.2T",17.3,97,1678.1,"冯海英","聂恒光"]
[28,"14:43:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013113","石子","1--2",49.8,16.06,33.74,{"$nulls":5},"0.1T",33.6,97,3259.2,"冯海英","聂恒光"]
[29,"14:45:00","鲁RK0329","陈长秋","侯代华",15864603123,"英良运输","013114","机制沙","中粗",49.54,16.13,33.41,{"$nulls":5},"0.1T",33.3,139,4628.7,"冯海英","聂恒光"]
[30,"14:47:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013115","石子","1--2",49.67,15.72,33.95,{"$nulls":5},"0.1T",33.8,97,3278.6,"冯海英","聂恒光"]
[31,"15:01:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013116","石子","1--2",49.77,15.91,33.86,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[32,"15:03:00","鲁RN1859","王江华","王江华",18555119799,"英良运输","013117","石子","1--2",49.32,15.75,33.57,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[33,"15:05:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","013118","石子","1--2",49.69,16.01,33.68,{"$nulls":5},"0.1T",33.5,97,3249.5,"冯海英","聂恒光"]
[34,"15:07:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013119","石子","1--2",50.1,15.93,34.17,{"$nulls":5},"0.1T",34,97,3298,"冯海英","聂恒光"]
[35,"15:26:00","鲁RM5188","李斌","安孔青",15163023899,"李广坤","013120","石子","1--2",26.33,8.61,17.72,{"$nulls":5},"0.3T",17.4,97,1687.8,"冯海英","聂恒光"]
[36,"15:57:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013121","石子","1--2",49.01,15.1,33.91,{"$nulls":5},"0.8T",33.1,97,3210.7,"冯海英","聂恒光"]
[37,"16:31:00","鲁RL5456","吕东华","吕东华",15562719795,"李广坤","013122","石子","1--2",49.61,19.68,29.93,{"$nulls":5},"0.5T",29.4,97,2851.8,"冯海英","聂恒光"]
[38,"18:45:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013123","石子","1--2",49.3,15.74,33.56,{"$nulls":5},"0.2T",33.4,97,3239.8,"冯海英","聂恒光"]
[39,"18:47:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013124","石子","1--2",48.47,15.91,32.56,{"$nulls":5},"0.1T",32.4,97,3142.8,"冯海英","聂恒光"]
[40,"18:49:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","013125","石子","1--2",49.48,15.99,33.49,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[41,"18:51:00","鲁RN1859","王江华","王江华",18555119799,"英良运输","013126","石子","1--2",48.88,16.21,32.67,{"$nulls":5},"0.1T",32.5,97,3152.5,"冯海英","聂恒光"]
[42,"18:53:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013127","石子","1--2",50.56,16.32,34.24,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[43,"19:41:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013128","石子","1--2",26.01,8.54,17.47,{"$nulls":5},"0.3T",17.1,97,{"$f":"M47*U47","v":1694.59},"冯海英","聂恒光"]
[44,"20:13:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013129","矿粉",null,72.37,17.09,55.28,{"$nulls":5},{"v":0.003,"d":"0.30%"},55.11,370,0,"冯海英","聂恒光"]
[45,"20:22:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013130","石子","1--2",49.65,15.86,33.79,{"$nulls":5},"0.1T",33.6,97,{"$f":"T49*U49","v":3259.2},"冯海英","聂恒光"]
[46,"20:24:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013131","石子","1--2",49.02,15.08,33.94,{"$nulls":5},"0.1T",33.8,97,3278.6,"冯海英","聂恒光"]
[47,"21:00:00","鲁RM5188","李斌","安孔青",15163023899,"李广坤","013132","石子","1--2",26.11,8.58,17.53,{"$nulls":5},"0.2T",17.3,97,1678.1,"冯海英","聂恒光"]
[48,"21:53:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013133","石子","1--2",50.1,15.89,34.21,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[49,"22:08:00","鲁RN1859","王江华","王江华",18555119799,"英良运输","013134","石子","1--2",50.94,16.16,34.78,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[50,"22:10:00","鲁RM0327","张中强","张中强",15163082725,"英良运输","013135","石子","1--2",51.61,15.95,35.66,{"$nulls":5},"0.1T",35.5,97,3443.5,"冯海英","聂恒光"]
[51,"22:12:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013136","石子","1--2",50.69,16.22,34.47,{"$nulls":5},"0.1T",34.3,97,3327.1,"冯海英","聂恒光"]
[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":347168.19}]