{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":60,"n_cols":25,"rows_kept":60,"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日期    2018年 09 月 29 日                                填表人  ：吴艳苓                                 "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,0.04,"鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联",9311,"水泥","PO42.5",91.93,26.16,{"$f":"K5-L5","v":65.77000000000001},{"$nulls":5},{"v":0.003,"d":"0.30%"},65.57,470,{"$f":"T5*U5","v":30817.899999999998},"冯海英","聂恒光"]
[2,6.45,"鲁RL7782","仝西娟","仝西娟",15668216788,"郑言克",9312,"石子","1--2",46.39,15.34,31.05,{"$nulls":5},"0.4T",30.6,108,3304.8,"冯海英","聂恒光"]
[3,6.47,"鲁HSC752","聂红波","聂红波",13396217663,"吕先稳",9313,"石子","1--2",47.62,15.84,31.779999999999998,{"$nulls":5},"0.4T",31.3,108,3380.4,"冯海英","聂恒光"]
[4,6.49,"鲁H86373","张兆群","张兆群",15153785444,"李广坤",9314,"石子","1--2",31.95,9.43,22.52,{"$nulls":5},"0.3T",22.2,108,2397.6,"冯海英","聂恒光"]
[5,6.51,"鲁HW1792","梁兵","梁兵",13705371473,"李广坤",9315,"石子","1--2",25.31,9.37,15.94,{"$nulls":5},"0.3T",15.6,108,1684.8,"冯海英","聂恒光"]
[6,6.54,"鲁HG0192","王华逢","王华逢",13953701343,"李广坤",9316,"石子","1--2",25.49,9.79,15.7,{"$nulls":5},"0.3T",15.4,108,1663.2,"冯海英","聂恒光"]
[7,6.56,"鲁HA5180","张丙稳","张丙稳",13853769834,"李广坤",9317,"石子","1--2",25.15,9.18,15.969999999999999,{"$nulls":5},"0.3T",15.6,108,1684.8,"冯海英","聂恒光"]
[8,6.58,"鲁HW1136","付士涛","付士涛",13854777883,"李广坤",9318,"石子","1--2",26.61,8.74,17.869999999999997,{"$nulls":5},"0.3T",17.5,108,1890,"冯海英","聂恒光"]
[9,{"v":7,"d":"7.00"},"鲁HA6727","付永信","付永信",15064721789,"李广坤",9319,"石子","1--2",30.44,9.28,21.160000000000004,{"$nulls":5},"0.3T",20.8,108,2246.4,"冯海英","聂恒光"]
[10,7.24,"鲁R33378","许东亮","许东亮",18888393599,"李广坤",9320,"石子","1--2",51.7,16.27,35.43000000000001,{"$nulls":5},"0.4T",35,108,3780,"冯海英","聂恒光"]
[11,7.26,"鲁HG2098","李先锋","李先锋",15564748807,"李广坤",9321,"石子","1--2",49.62,14.69,34.93,{"$nulls":5},"0.4T",34.5,108,3726,"冯海英","聂恒光"]
[12,7.28,"鲁HG6983","田延卫","田延卫",13365378599,"李广坤",9322,"石子","1--2",50.39,15.14,35.25,{"$nulls":5},"0.4T",34.8,108,3758.3999999999996,"冯海英","聂恒光"]
[13,8.18,"鲁HR3606","李业举","李业举",15053798399,"成武金利宏",9323,"矿粉",null,71.53,16.92,54.61,{"$nulls":5},{"v":0.003,"d":"0.30%"},54.44,370,20142.8,"冯海英","聂恒光"]
[14,9.47,"鲁H96E65","郭凯","郭凯",15064777797,"郑言克",9324,"石子","1--2",49.27,16.45,32.82000000000001,{"$nulls":5},"0.3T",32.5,108,3510,"冯海英","聂恒光"]
[15,10.39,"鲁RA6591","刘郑","李恒顺",15265032423,"莱芜延辉",9325,"减水剂",null,30.51,14.83,15.680000000000001,{"$nulls":6},15.68,1900,29792,"冯海英","聂恒光"]
[16,11.05,"鲁PH0753","兰园征","兰守园",18953086939,"吕先稳",9326,"石子","1--2",46.56,15.17,31.39,{"$nulls":5},"1T",30.3,108,3272.4,"冯海英","聂恒光"]
[17,13.07,"鲁RL7782","仝西娟","仝西娟",15668216788,"郑言克",9327,"石子","1--2",46.69,15.28,31.409999999999997,{"$nulls":5},"0.4T",31,108,3348,"冯海英","聂恒光"]
[18,13.22,"鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联",9328,"水泥","PO42.5",98,26.74,71.26,{"$nulls":5},{"v":0.003,"d":"0.30%"},71.04,470,33388.8,"冯海英","聂恒光"]
[19,15.47,"鲁RM6981","黄果栋","黄果栋",13583034566,"郑言克",9329,"石子","1--2",49.39,16.11,33.28,{"$nulls":5},"0.3T",32.9,108,3553.2,"冯海英","聂恒光"]
[20,15.51,"鲁RE1367","黄金永","黄金永",15605408855,"郑言克",9330,"石子","1--2",49.78,16.27,33.510000000000005,{"$nulls":5},"0.3T",33.2,108,3585.6000000000004,"冯海英","聂恒光"]
[21,19.43,"鲁RJ1282","王彦钦","徐龙福",17753053016,"巨野中联",9331,"水泥","PO42.5",90.18,26.45,63.730000000000004,{"$nulls":5},{"v":0.003,"d":"0.30%"},63.53,470,29859.100000000002,"冯海英","聂恒光"]
[22,20.11,"鲁HSC752","聂红波","聂红波",13396217663,"吕先稳",9332,"石子","1--2",47.25,15.77,31.48,{"$nulls":5},"0.5T",30.9,108,3337.2,"冯海英","聂恒光"]
[23,21.29,"鲁HG2098","李先锋","李先锋",15564748807,"李广坤",9333,"石子","1--2",47.12,14.63,32.489999999999995,{"$nulls":5},"0.5T",31.9,108,3445.2,"冯海英","聂恒光"]
[24,21.32,"鲁HG6983","田延卫","田延卫",13365378599,"李广坤",9334,"石子","1--2",47.74,15.08,32.660000000000004,{"$nulls":5},"0.5T",32.1,108,3466.8,"冯海英","聂恒光"]
[25,21.59,"鲁HD1820","张炳伟","张炳伟",18853746459,"李广坤",9335,"石子","1--2",30.87,9.2,21.67,{"$nulls":5},"0.5T",21.1,108,2278.8,"冯海英","聂恒光"]
[26,22.13,"鲁RK3339","高西安","高西安",18605309508,"郑言克",9336,"石子","1--2",50.29,16.29,34,{"$nulls":5},"0.5T",33.5,108,3618,"冯海英","聂恒光"]
[27,23.16,"鲁RN2329","张庆友","张庆友",15965695489,"郑言克",9337,"石子","1--2",50.4,16.45,33.95,{"$nulls":5},"0.3T",33.6,108,3628.8,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},0,{"$nulls":8},0,"冯海英","聂恒光"]
[{"$nulls":12},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,"冯海英","聂恒光"]
[null,"合计",{"$nulls":19},{"$f":"SUM(V5:V58)","v":210561}]
[null,"备注：退货也登记，在备注中注明不合格退货，所有重量和单价、金额均以0标记"]