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

{"sheet":"巨野分公司","index":0,"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 月 22 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"06:33:00","鲁RK1976","王彦钦","宋彦兵",15966330156,"巨野中联","013256","水泥","PO42.5",100.8,26.01,{"$f":"K5-L5","v":74.79},{"$nulls":5},{"v":0.003,"d":"0.30%"},74.58,535,{"$f":"T5*U5","v":39900.3},"冯海英","聂恒光"]
[2,"06:36:00","鲁HR3606","李业举","杜昌慈",15053798399,"金利宏物流","013257","矿粉",null,68.1,17.05,51.05,{"$nulls":5},{"v":0.003,"d":"0.30%"},50.9,370,18833,"冯海英","聂恒光"]
[3,"06:38:00","鲁RN9839","米强栋","米强栋",18953005713,"英良运输","013258","石子","1--2",49.74,16.29,33.45,{"$nulls":5},"0.1T",33.3,97,3230.1,"冯海英","聂恒光"]
[4,"07:18:00","鲁RM2498","魏庆如","崔伟标",13061551313,"英良运输","013259","石子","1--2",48.82,16.24,32.58,{"$nulls":5},"0.1T",32.4,97,3142.8,"冯海英","聂恒光"]
[5,"09:56:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013260","石子","1--2",26.27,8.54,17.73,{"$nulls":5},"0.3T",17.4,97,1687.8,"冯海英","聂恒光"]
[6,"09:56:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013261","石子","1--2",49.81,15.59,34.22,{"$nulls":5},"0.2T",34,97,3298,"冯海英","聂恒光"]
[7,"09:59:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013262","石子","1--2",50.92,14.69,36.23,{"$nulls":5},"0.1T",36.1,97,3501.7,"冯海英","聂恒光"]
[8,"10:03:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013263","石子","1--2",49.38,14.52,34.86,{"$nulls":5},"0.1T",34.7,97,3365.9,"冯海英","聂恒光"]
[9,"10:28:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013264","石子","1--2",25.84,8.65,17.19,{"$nulls":5},"0.2T",16.9,97,1639.3,"冯海英","聂恒光"]
[10,"12:34:00","鲁RL5456","吕东华","吕东华",15562719795,"英良运输","013265","石子","1--2",50.99,15.74,35.25,{"$nulls":5},"0.1T",35.1,97,3404.7,"冯海英","聂恒光"]
[11,"12:36:00","鲁RM8082","安春峰","安春峰",18764504777,"李广坤","013266","石子","1--2",51.28,16.06,35.22,{"$nulls":5},"0.1T",35.1,97,3404.7,"冯海英","聂恒光"]
[12,"12:38:00","鲁RN9995","李兆春","李兆春",13305403315,"李广坤","013267","石子","1--2",49.78,15.02,34.76,{"$nulls":5},"0.1T",34.6,97,3356.2,"冯海英","聂恒光"]
[13,"12:41:00","苏C2J189","陈平西","吴涛",15376868553,"英良运输","013268","机制沙","中粗",49.28,16.12,33.16,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[14,"12:46:00","鲁RM3845","田运增","田运增",15020525186,"英良运输","013269","机制沙","中粗",49.09,15.19,33.9,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[15,"13:08:00","鲁H63E30","白传青","白传青",18854791828,"郑言克","013270","石子","1--2",49.39,15.8,33.59,{"$nulls":5},"0.1T",33.4,97,3239.8,"冯海英","聂恒光"]
[16,"13:13:00","鲁PC6907","陈长秋","姚树习",15753010056,"英良运输","013271","机制沙","中粗",45.91,13.89,32.02,{"$nulls":5},"0.1T",31.9,139,4434.1,"冯海英","聂恒光"]
[17,"14:09:00","皖S56792","陈平西","吕长华",18364082622,"英良运输","013272","机制沙","中粗",48.91,16.32,32.59,{"$nulls":5},"0.1T",32.4,139,4503.6,"冯海英","聂恒光"]
[18,"14:12:00","鲁PH8532","陈平西","任重连",18661581646,"英良运输","013273","机制沙","中粗",46.33,14.17,32.16,{"$nulls":5},"0.1T",32,139,4448,"冯海英","聂恒光"]
[19,"14:14:00","鲁RK0329","陈平西","张华洗",15615708910,"英良运输","013274","机制沙","中粗",49.6,15.64,33.96,{"$nulls":5},"0.1T",33.8,139,4698.2,"冯海英","聂恒光"]
[20,"15:14:00","鲁HW0617","张兆群","张兆群",15153785444,"李广坤","013275","石子","1--2",26.94,8.51,18.43,{"$nulls":5},"0.1T",18.3,97,1775.1,"冯海英","聂恒光"]
[21,"15:20:00","鲁RN5188","李斌","安孔青",15163023899,"李广坤","013276","石子","1--2",25.93,8.63,17.3,{"$nulls":5},"0.1T",17.2,97,1668.4,"冯海英","聂恒光"]
[22,"15:40:00","鲁RL7377","李斌","常云龙",18264007774,"李广坤","013277","石子","1--2",25.71,8.65,17.06,{"$nulls":5},"0.1T",16.9,97,1639.3,"冯海英","聂恒光"]
[23,"16:17:00","鲁JB2331","王磊","王磊",15006574352,"郑言克","013278","石子","1--2",49.88,14.67,35.21,{"$nulls":5},"0.1T",34.2,97,3317.4,"冯海英","聂恒光"]
[24,"16:19:00","鲁JA4773","王双喜","王双喜",15588714111,"郑言克","013279","石子","1--2",50.29,14.52,35.77,{"$nulls":5},"0.1T",34.7,97,3365.9,"冯海英","聂恒光"]
[25,"16:24:00","鲁H22H87","魏保强","魏保强",13385379688,"李广坤","013280","石子","1--2",49.84,15.59,34.25,{"$nulls":5},"0.1T",34.1,97,3307.7,"冯海英","聂恒光"]
[26,"16:50:00","鲁RL3873","兰守玉","兰守玉",15376102612,"郑言克","013281","机制沙","中粗",50.09,15.55,34.54,{"$nulls":5},"0.1T",34.4,139,4781.6,"冯海英","聂恒光"]
[27,"18:56:00","鲁H05K18","谢鹏","谢鹏",18264788201,"郑言克","013282","石子","1--2",49.67,15.73,33.94,{"$nulls":5},"0.1T",33.8,97,3278.6,"冯海英","聂恒光"]
[28,"21:18:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","013283","石子","1--2",48.58,16.26,32.32,{"$nulls":5},"0.1T",32.2,97,3123.4,"冯海英","聂恒光"]
[29,"21:20:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","013284","石子","1--2",49.12,16.21,32.91,{"$nulls":5},"0.1T",32.8,97,3181.6,"冯海英","聂恒光"]
[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":148812.4}]

{"sheet":"邳州分公司","index":1,"n_rows":14,"n_cols":26,"rows_kept":14,"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 月 22 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"21:43:00","苏CGV338","周桂林","李城市",18751653412,"庄团结",13078,"WIN0050242","机制砂","中粗砂",88.26,21.68,66.58,5,2.2,2.8,"Ⅱ区",null,1.38,65.2,119,{"$f":"U5*V5","v":7758.8},"杨家辉","马娜"]
[2,"21:45:00","鲁Q627AP","宫东明","宫东明",15253915869,"庄团结",13079,"WIN0050242","机制砂","中粗砂",91.4,22.78,68.62,6,2.2,2.8,"Ⅱ区",null,1.42,67.2,119,7996.8,"杨家辉","马娜"]
[3,"21:47:00","苏C2A698","高雷","高雷",13913462579,"庄团结",13080,"WIN0050242","机制砂","中粗砂",107.34,29.6,77.74,6,2.2,2.8,"Ⅱ区",null,1.64,76.1,119,9055.9,"杨家辉","马娜"]
[4,"00:33:00","鲁Q582by","陈大伟","陈大伟",15852102259,"丁庆余",13081,"WIN0050244","石子","1-2#",73.94,17.95,55.98,{"$nulls":3},"良好",7,0.58,55.4,98,5429.2,"杨家辉","马娜"]
[5,"00:41:00","苏C1T507","戴春宇","祁建辉",18751646723,"丁庆余",13082,"WIN0050244","石子","1-2#",104.88,22.84,82.04,{"$nulls":3},"良好",7,1.04,81,98,7938,"杨家辉","马娜"]
[6,"01:50:00","鲁Q366CQ","戴春宇","柳玉良",13775857003,"丁庆余",13083,"WIN0050244","石子","1-2#",95.3,18.84,76.46,{"$nulls":3},"良好",7,0.56,75.9,98,7438.2,"杨家辉","马娜"]
[7,"01:53:00","鲁Q506BE","戴春宇","张胜",15105202990,"李海洋",13084,"WIN0050243","石子","1-2#",76.9,18.52,58.38,{"$nulls":3},"良好",7,1.08,57.3,98,5615.4,"杨家辉","马娜"]
[]
[]
[{"$nulls":13},{"$f":"SUM(N5:N13)","v":485.8},{"$nulls":6},{"$f":"SUM(U5:U13)","v":478.1},null,{"$f":"SUM(W5:W13)","v":51232.3}]