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

{"sheet":"邳州公司","index":0,"n_rows":19,"n_cols":26,"rows_kept":19,"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 月 12日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"06:56:00","鲁Q718BZ","陈磊","彭杰",16775839508,"段俊成",13392,"WIN0050476","石子","1-5#",111.84,23.18,88.66,{"$nulls":3},"含碎石、风化石",9,3.06,85.6,98,{"$f":"U5*V5","v":8388.8},"刘会良","杜娥","三车间"]
[2,"08:06:00","鲁Q300DB","丁大庆","宋恒贵",17110514888,"李海洋",13393,"WIN0050475","石子","1-2#",123.4,28.1,95.3,{"$nulls":3},"良好",7,2.5,92.8,98,9094.4,"李凤","杜娥"]
[3,"09:26:00","鲁QV8991","孙立","彭杰",13775839508,"段俊成",13394,"WIN0050476","石子","1-5#",101.38,23.1,78.28,{"$nulls":3},"良好",7,2.58,75.7,98,7418.6,"刘会良","杜娥","三车间"]
[4,"11:40:00","鲁QV8855","孙立","韩瑜",15162001555,"段俊成",13396,"WIN0050476","石子","1-5#",98.26,23.46,74.8,{"$nulls":3},"良好",7,1.5,73.3,98,7183.4,"刘会良","杜娥","三车间"]
[5,"11:48:00","鲁QV7771","孙立","张海亮",17712028977,"段俊成",13397,"WIN0050476","石子","1-5#",98.98,23.92,75.06,{"$nulls":3},"良好",7,1.56,73.5,98,7203,"刘会良","杜娥","三车间"]
[6,"13:58:00","鲁Q718BZ","陈磊","胡光发",18761484744,"段俊成",13401,"WIN0050476","石子","1-5#",102.92,23.42,79.5,{"$nulls":3},"良好",7,1.5,78,98,7644,"李凤","杜娥","三车间"]
[7,"00:28:00","苏CGA040","冯永盛","赵东亚",15062043566,"李海洋",13406,"WIN0050474","机制砂","中粗砂",92.04,21.52,70.52,7,2,2.9,"Ⅱ区",null,2.12,68.4,119,8139.6,"杨家辉","马娜"]
[8,"00:32:00","苏CGF365","冯永清","崔学良",13775854328,"李海洋",13407,"WIN0050474","机制砂","中粗砂",97.22,21.94,75.28,7,2,2.9,"Ⅱ区",null,2.28,73,119,8687,"杨家辉","马娜"]
[9,"00:34:00","苏CGP356","张赛赛","张飞",18251742399,"李海洋",13408,"WIN0050474","机制砂","中粗砂",98.56,21.64,75.92,8,2,2.9,"Ⅱ区",null,3.12,72.8,119,8663.2,"杨家辉","马娜"]
[10,"00:43:00","鲁QV8018","孙立","彭杰",13775839508,"李海洋",13409,"WIN0050475","石子","1-2#",98.14,23.6,74.54,{"$nulls":3},"良好",7,0.54,74,98,7252,"杨家辉","马娜"]
[11,"00:45:00","鲁Q323CD","冯永盛","卓昌银",18168615153,"李海洋",13410,"WIN0050474","机制砂","中粗砂",90.14,23.36,66.78,7,2,2.9,"Ⅱ区",null,2.08,64.7,119,7699.3,"杨家辉","马娜"]
[12,"00:57:00","鲁Q718BZ","陈磊","彭杰",16775839508,"李海洋",13411,"WIN0050475","石子","1-2#",106.38,23.3,83.08,{"$nulls":3},"良好",7,0.58,82.5,98,8085,"杨家辉","马娜"]
[]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N18)","v":937.72},{"$nulls":6},{"$f":"SUM(U5:U18)","v":914.3},null,{"$f":"SUM(W5:W18)","v":95458.3}]

{"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 月 12 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:05:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013706","矿粉",null,69.34,17.01,{"$f":"K5-L5","v":52.33},{"$nulls":5},{"v":0.003,"d":"0.30%"},52.17,370,{"$f":"T5*U5","v":19302.9},"冯海英","聂恒光"]
[2,"06:08:00","鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联","013707","水泥","PO42.5",101.52,26.12,75.4,{"$nulls":5},{"v":0.003,"d":"0.30%"},75.17,535,40215.95,"冯海英","聂恒光"]
[3,"06:11:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013708","水泥","PO42.5",99.34,26.13,73.21,{"$nulls":5},{"v":0.003,"d":"0.30%"},72.99,535,39049.65,"冯海英","聂恒光"]
[4,"06:29:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013709","石子","1--2",51.52,16.09,35.43,{"$nulls":5},"0.1T",35.3,97,3424.1,"冯海英","聂恒光"]
[5,"06:31:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013710","石子","1--2",53.12,15.99,37.13,{"$nulls":5},"0.1T",37,97,3589,"冯海英","聂恒光"]
[6,"07:58:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013711","石子","1--2",49.69,15.04,34.65,{"$nulls":5},"0.2T",34.4,97,3336.8,"冯海英","聂恒光"]
[7,"08:04:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013712","石子","1--2",30.45,8.51,21.94,{"$nulls":5},"1.5T",20.4,97,1978.8,"冯海英","聂恒光"]
[8,"09:17:00","鲁JA4773","王双喜","王恩军",15588714111,"郑言克","013713","石子","1--2",49.54,14.43,35.11,{"$nulls":5},"0.1T",35,97,3395,"冯海英","聂恒光"]
[9,"10:24:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013714","石子","1--2",27.23,8.46,18.77,{"$nulls":5},"0.2T",18.5,97,1794.5,"冯海英","聂恒光"]
[10,"10:26:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013715","石子","1--2",26.9,8.56,18.34,{"$nulls":5},"0.2T",18.1,97,1755.7,"冯海英","聂恒光"]
[11,"10:55:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013716","石子","1--2",49.61,15.76,33.85,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[12,"12:02:00","鲁H78E87","张庆刚","马计",15853706592,"郑言克","013717","石子","1--2",48.97,15.64,33.33,{"$nulls":5},"0.1T",33.2,97,3220.4,"冯海英","聂恒光"]
[13,"12:20:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013718","石子","1--2",49.89,15.44,34.45,{"$nulls":5},"0.1T",34.3,97,3327.1,"冯海英","聂恒光"]
[14,"13:27:00","鲁RF7132","陈长秋","文洪涛",13869741571,"英良运输","013719","机制沙","中粗",49.34,15.2,34.14,{"$nulls":5},"0.1T",34,139,4726,"冯海英","聂恒光"]
[15,"13:29:00","苏C2J189","陈平西","吴涛",15376868552,"英良运输","013720","机制沙","中粗",48.75,16.04,32.71,{"$nulls":5},"0.1T",32.6,139,4531.4,"冯海英","聂恒光"]
[16,"15:49:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013721","石子","1--2",49.38,15.7,33.68,{"$nulls":5},"0.5T",33.1,97,3210.7,"冯海英","聂恒光"]
[17,"15:51:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013722","石子","1--2",27.61,8.55,19.06,{"$nulls":5},"0.5T",18.5,97,1794.5,"冯海英","聂恒光"]
[18,"15:53:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013723","石子","1--2",26.61,8.53,18.08,{"$nulls":5},"0.5T",17.5,97,1697.5,"冯海英","聂恒光"]
[19,"19:22:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013724","石子","1--2",50.12,15.38,34.74,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[20,"21:00:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013725","石子","1--2",49.73,15.93,33.8,{"$nulls":5},"0.1T",33.7,97,3268.9,"冯海英","聂恒光"]
[21,"21:02:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013726","石子","1--2",49.88,16.3,33.58,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[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":153483.8}]