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

{"sheet":"Sheet1","index":0,"n_rows":41,"n_cols":25,"rows_kept":41,"merged":[[0,0,0,24],[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 年 9 月 29日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"05:40:00","鲁Q221CK","王朱击","王朱击",13153930909,"丁宝利","WIN0047884","石子","1-2#",51.3,17.56,33.74,{"$nulls":3},"良好",7,0.54,33.2,107,{"$f":"T5*U5","v":3552.4},"耿小龙","杜娥娥","泉头石子"]
[2,"07:16:00","鲁Q050BN","冯永胜","冯仰恩",13815383248,"孙燕昭","WIN0047883","石子","1-2#",61.78,18.22,43.56,{"$nulls":3},"良好",8,0.56,43,107,4601,"董国政","杜娥娥"]
[3,"07:19:00","鲁Q587CW","冯永胜","曹善龙",15052055477,"孙燕昭","WIN0047883","石子","1-2#",61.2,16.78,44.42,{"$nulls":3},"良好",7,0.52,43.9,107,4697.3,"董国政","杜娥娥"]
[4,"07:22:00","鲁Q166BV","冯永胜","曹进喜",15062089303,"孙燕昭","WIN0047883","石子","1-2#",64.18,18.94,45.24,{"$nulls":3},"良好",7,0.54,44.7,107,4782.9,"董国政","杜娥娥"]
[5,"07:34:00","苏CY0813","胡郑伟","胡郑伟",13815386464,"庄团结","WIN0047887","河沙","中粗砂",56.02,18.46,37.56,8,1.6,2.8,"Ⅱ区",null,1.56,36,117,4212,"陈金芳","杜娥娥"]
[6,"08:16:00","鲁Q838BG","冯永胜","孙正一",15852351058,"孙燕昭","WIN0047883","石子","1-2#",62.68,17.64,45.04,{"$nulls":3},"较差",8,1.04,44,107,4708,"陈金芳","杜娥娥"]
[7,"08:33:00","苏C1T386","张磊","张磊",13372224551,"庄团结","WIN0047887","河沙","中粗砂",58.18,16.44,41.74,7,1.8,2.7,"Ⅱ区",null,1.34,40.4,117,4726.8,"陈金芳","杜娥娥"]
[8,"11:12:00","皖LC7696","吴猛","吴猛",18305223122,"庄团结","WIN0047887","河沙","中粗砂",64.18,16.2,47.98,7,2,2.8,"Ⅱ区",null,1.48,46.5,117,5440.5,"刘会良","杜娥娥"]
[9,"11:17:00","苏CU6672","孙立山","吴忠志",18261176599,"庄团结","WIN0047887","河沙","中粗砂",52.32,16.76,35.56,7,2,2.8,"Ⅱ区",null,1.16,34.4,117,4024.8,"刘会良","杜娥娥"]
[10,"11:57:00","苏CHT311","冯永清","冯遵伟",13816522380,"庄团结","WIN0047887","河沙","中粗砂",54.9,16.7,38.2,7,2,2.9,"Ⅱ区",null,1.2,37,117,4329,"刘会良","杜娥娥"]
[11,"12:44:00","鲁D39525","尹正刚","尹振义",13775858067,"庄团结","退货","河沙","中粗砂",60.72,{"$nulls":3},3.6,2.7,"Ⅱ区",{"$nulls":5},"陈金芳","杜娥娥"]
[12,"15:18:00","苏CJU969","仁光文","仁光文",15150097222,"孙燕昭","WIN0047885","河沙","中粗砂",58.46,18.54,39.92,7,1.9,2.8,"Ⅱ区",null,1.22,38.7,117,{"$f":"T16*U16","v":4527.9},"刘会良","杜娥娥"]
[13,"15:23:00","苏CAG616","王飞","王飞",13852238516,"孙燕昭","WIN0047885","河沙","中粗砂",55.94,17.24,38.7,7,1.9,2.7,"Ⅱ区",null,1.2,37.5,117,4387.5,"刘会良","杜娥娥"]
[14,"15:27:00","苏CBA581","王小四","汤威",15298727655,"孙燕昭","WIN0047885","河沙","中粗砂",57.28,17.86,39.42,7,1.9,2.7,"Ⅱ区",null,1.22,38.2,117,4469.4,"刘会良","杜娥娥"]
[15,"15:48:00","苏CHZ067","汤浩","汤浩",18751649288,"庄团结","WIN0047887","河沙","中粗砂",60.34,18.12,42.22,9,2.4,2.9,"Ⅱ区",null,2.12,40.1,117,4691.7,"刘会良","杜娥娥"]
[16,"15:55:00","苏CDH027","丙赛","丙赛",13605222731,"庄团结","WIN0047887","河沙","中粗砂",57.58,18.06,39.52,8,2.1,2.9,"Ⅱ区",null,1.62,37.9,117,4434.3,"刘会良","杜娥娥"]
[17,"16:00:00","苏CX3937","陆英坡","陆英坡",13815334019,"庄团结","WIN0047887","河沙","中粗砂",61.12,18.68,42.44,7,2,2.8,"Ⅱ区",null,1.34,41.1,117,4808.7,"刘会良","杜娥娥"]
[18,"16:14:00","苏CS6173","曹七","曹七",13395290088,"庄团结","退货","河沙","中粗砂",57.04,{"$nulls":3},"含泥块",null,"Ⅱ区",{"$nulls":5},"刘会良","杜娥娥"]
[19,"16:18:00","苏CGF319","庄团柱","庄团柱",15852064444,"庄团结","退货","河沙","中粗砂",59.96,{"$nulls":3},"含泥块",null,"Ⅱ区",{"$nulls":5},"刘会良","杜娥娥"]
[20,"16:32:00","苏CT3573","庄猛","胡刚",15705228073,"庄团结","退货","河沙","中粗砂",59.76,{"$nulls":3},"含泥块",null,"Ⅱ区",{"$nulls":5},"刘会良","杜娥娥"]
[21,"16:36:00","苏CJY303","胡征","刘永",13952195882,"庄团结","WIN0047887","河沙","中粗砂",55.5,18.78,36.72,8,1.8,2.8,"Ⅱ区",null,1.52,35.2,117,{"$f":"T25*U25","v":4118.4},"刘会良","杜娥娥"]
[22,"17:11:00","鲁Q079CP","索银猛","王超",13913483789,"孙燕昭","WIN0047885","河沙","中粗砂",57.82,17.64,40.18,7,1.6,2.8,"Ⅱ区",null,1.28,38.9,117,4551.3,"耿小龙","杜娥娥"]
[23,"17:26:00","苏CHW072","庄猛","张中华",13805222822,"庄团结","WIN0047887","河沙","中粗砂",62.2,18.06,44.14,8,1.8,2.8,"Ⅱ区",null,1.84,42.3,117,4949.1,"耿小龙","杜娥娥"]
[24,"17:53:00","苏CH6588","庄宁","贾方乐",18112214446,"庄团结","WIN0047887","河沙","中粗砂",61.7,17.96,43.74,8,1.8,2.8,"Ⅱ区",null,1.84,41.9,117,4902.3,"耿小龙","杜娥娥"]
[25,"17:57:00","苏CU3668","刘良","刘良",13921769059,"庄团结","WIN0047887","河沙","中粗砂",60.2,18.14,42.06,8,1.8,2.8,"Ⅱ区",null,1.76,40.3,117,4715.1,"耿小龙","杜娥娥"]
[26,"18:37:00","苏CJM267","吕作辉","吕作辉",18136006678,"庄团结","WIN0047887","河沙","中粗砂",63.82,18.22,45.6,7,1.8,2.8,"Ⅱ区",null,1.4,44.2,117,5171.4,"耿小龙","杜娥娥"]
[27,"18:42:00","苏C9T019","唐怀山","唐怀山",15852408165,"庄团结","WIN0047887","河沙","中粗砂",59.78,17.74,42.04,7,1.8,2.8,"Ⅱ区",null,1.34,40.7,117,4761.9,"耿小龙","杜娥娥"]
[28,"18:46:00","苏C9T121","刘召迎","刘召迎",13372221456,"庄团结","WIN0047887","河沙","中粗砂",59.44,17.44,42,7,1.8,2.8,"Ⅱ区",null,1.3,40.7,117,4761.9,"耿小龙","杜娥娥"]
[29,"18:51:00","苏CJY880","吕鹏","吕彬",15162229552,"庄团结","WIN0047887","河沙","中粗砂",60.36,18.6,41.76,7,1.8,2.8,"Ⅱ区",null,1.26,40.5,117,4738.5,"耿小龙","杜娥娥"]
[30,"19:04:00","苏CCZ319","庄猛","陈丁",15252204580,"庄团结","WIN0047887","河沙","中粗砂",55.46,16.72,38.74,7,1.8,2.8,"Ⅱ区",null,1.24,37.5,117,4387.5,"耿小龙","杜娥娥"]
[31,"19:08:00","苏CDM071","杜坤","杜辉",15062043488,"庄团结","WIN0047887","河沙","中粗砂",56.84,17.32,39.52,7,1.8,2.8,"Ⅱ区",null,1.22,38.3,117,4481.1,"耿小龙","杜娥娥"]
[32,"19:44:00","鲁Q062AV","范红利","许宜永",18051674444,"庄团结","WIN0047887","河沙","中粗砂",61.04,21.28,39.76,7,1.8,2.8,"Ⅱ区",null,1.26,38.5,117,4504.5,"耿小龙","杜娥娥"]
[33,"01:51:00","鲁Q221CK","宋栋梁","李亮",13355010691,"丁宝利","WIN0047884","石子","1-2#",53.52,17.52,36,{"$nulls":3},"良好",7,0.5,35.5,107,3798.5,"耿小龙","杜娥娥","泉头石子"]
[34,"02:35:00","苏CGV338","汤继名","孙合伟",13676392600,"杨需","WIN0047886","河沙","中粗砂",78.7,21.78,56.92,8,1.4,2.7,"Ⅱ区",null,2.32,54.6,117,6388.2,"耿小龙","杜娥娥"]
[35,"02:39:00","苏CGS000","汤继名","黄仁武",15062093139,"杨需","WIN0047886","河沙","中粗砂",77.06,21.94,55.12,8,1.4,2.7,"Ⅱ区",null,2.22,52.9,117,6189.3,"耿小龙","杜娥娥"]
[null,"合计",{"$nulls":10},{"$f":"SUM(M5:M39)","v":1299.56},{"$nulls":6},{"$f":"SUM(T5:T39)","v":1258.6},null,{"$f":"SUM(V5:V39)","v":144813.2}]
[null,"备注：退货也登记，在备注中注明不合格退货，所有重量和单价、金额均以0标记"]