一个算法问题。

悬赏园豆：100 [已解决问题] 解决于 2009-05-31 17:09

用户喜好分析 一、用户的喜好属性分为七大属性：  喜欢的色调，喜欢的名星，喜欢的运动，喜欢听的歌曲，喜欢吃的小吃，喜欢的车，喜欢的衣服牌子 二、七大属性的权重（整数）可以设定，七大属性权重之和为100，跟据设定的七大属性指数，与阀值在海量用户中比对，列出符合要求的用户，只要给定的属性与列表中用户属性相等，就加上对应的权重数，最后得出总数。   举例： 以下是用户信息列表 <table class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;" border="1" cellspacing="0" cellpadding="0"> <tbody> <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"> <td style="padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; border: windowtext 1pt solid;" width="71"> 姓名 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 色调 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 名星 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 运动 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 歌曲 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 小吃 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 车 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 衣服 </td> </tr> <tr style="mso-yfti-irow: 1;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 张三 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 红 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 赵薇 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 跑步 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 神化 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 铁板烧 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 丰田 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 雅格尔 </td> </tr> <tr style="mso-yfti-irow: 2;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 李四 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 蓝 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 赵薇 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 爬山 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 我和你 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 烤肉串 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 丰田 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 苹果 </td> </tr> <tr style="mso-yfti-irow: 3;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 王五 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 蓝 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 周杰化 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 蓝球 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 七里香 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 来伊份 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 凯迪拉克 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 登喜路 </td> </tr> <tr style="mso-yfti-irow: 4;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 赵六 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 黄 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 林心如 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 足球 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 七里香 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 坐上客 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 奥迪 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 波仕漫 </td> </tr> <tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 426.1pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" colspan="8" width="568"> …… …… …… </td> </tr> </tbody> </table>   以下是设定的权重： <table class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;" border="1" cellspacing="0" cellpadding="0"> <tbody> <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"> <td style="padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; border: windowtext 1pt solid;" width="71"> 色调 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 名星 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 运动 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 歌曲 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 小吃 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 车 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 衣服 </td> </tr> <tr style="mso-yfti-irow: 1; mso-yfti-lastrow: yes;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 12 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 13 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 14 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 16 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 10 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 20 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 15 </td> </tr> </tbody> </table> 阀值为： 60     以下是给定属性，跟据这个属性来列出符合的用户： <table class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;" border="1" cellspacing="0" cellpadding="0"> <tbody> <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"> <td style="padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; border: windowtext 1pt solid;" width="71"> 色调 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 名星 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 运动 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 歌曲 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 小吃 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 车 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 衣服 </td> </tr> <tr style="mso-yfti-irow: 1; mso-yfti-lastrow: yes;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 红 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 赵薇 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 跑步 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 七里香 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 铁板烧 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 丰田 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.3pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 登喜路 </td> </tr> </tbody> </table>     运算后： <table class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;" border="1" cellspacing="0" cellpadding="0"> <tbody> <tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"> <td style="padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 41.4pt; padding-right: 5.4pt; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; border: windowtext 1pt solid;" width="55"> 姓名 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.7pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="72"> 色调 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.55pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="63"> 名星 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="63"> 运动 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="63"> 歌曲 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="63"> 小吃 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="71"> 车 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 54pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="72"> 衣服 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 33.7pt; padding-right: 5.4pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" width="45" valign="top"> 得分 </td> </tr> <tr style="mso-yfti-irow: 1;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 41.4pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="55"> 张三 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 12 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.55pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 13 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 14 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 神化 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 10 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 20 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 54pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 雅格尔 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 33.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="45" valign="top"> 69 </td> </tr> <tr style="mso-yfti-irow: 2;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 41.4pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="55"> 李四 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 蓝 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.55pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 13 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 爬山 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 我和你 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 烤肉串 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 20 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 54pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 苹果 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 33.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="45" valign="top"> 33 </td> </tr> <tr style="mso-yfti-irow: 3;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 41.4pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="55"> 王五 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 蓝 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.55pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 周杰化 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 蓝球 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 16 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 来伊份 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 凯迪拉克 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 54pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 15 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 33.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="45" valign="top"> 31 </td> </tr> <tr style="mso-yfti-irow: 4; mso-yfti-lastrow: yes;"> <td style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 41.4pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="55"> 赵六 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 黄 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.55pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 林心如 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 足球 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 16 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 47.5pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="63"> 坐上客 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 53.25pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="71"> 奥迪 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 54pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="72"> 波仕漫 </td> <td style="border-bottom: windowtext 1pt solid; border-left: #ebe9ed; padding-bottom: 0cm; background-color: transparent; padding-left: 5.4pt; width: 33.7pt; padding-right: 5.4pt; border-top: #ebe9ed; border-right: windowtext 1pt solid; padding-top: 0cm; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" width="45" valign="top"> 16 </td> </tr> </tbody> </table>   符合要求的只有：张三。     程序要求： 程序要求： 用户数据放在数据库中，在程序运行时，要求把用户信息表里的所有用户数据加载到程序内存里（不能用数据库去做，否则太慢了），数据量在50000左右，一次要处理的给定属性及权重数大约在1万到2万之间，程序处理完所有给定值后的运行时间不能超过5秒。(从属性的给定，到把符合给定值的用户出列出来总这5秒,如果都循环的话，10000*50000需要3分钟左右。)请高人给个算法（.net/java实现）。

.NET技术 C#

深蓝色的鱼 | 初学一级 | 园豆：50
提问于：2009-05-29 23:27

< >

最佳答案

我用多维立方体模型（一种数据挖掘算法）来解决这个问题，程序模拟了5万条记录进行测试。测试机器配置是 WinXP SP2,

Pentium4 3.06GHz, 1G 内存。

用传统方法循环比较，测试10000次，用时 125 秒，采用多维立方体模型，用时31秒。采用优化后的多维立方体模型用时15秒。我感觉已经把这种算法的效率发挥到了极致，不过我还有办法把查询速度再提高1倍左右。

我的机器是3年前的配置，如果用目前流行的 intel core 2 duo 普通PC，5秒钟之内我认为还是可以达到的。

近两天我将写一篇博文来专门介绍这个算法。

另外我用的是模拟数据，如果用实际数据，效果可能会更好，为什么会更好，看了我的博文就会知道。

代码没办法在这里贴出来，楼主如果现在想要，请发站内短信给我。

下面我给出程序的主函数，和测试结果：

static void Main(string[] args)
{

//产生模拟数据
UserPreference[] users = GenerateData.Generate(50000);

            //设置各分量的匹配条件，和权重
            PreferencRank[] pRanks = {
                new PreferencRank("红", 12),
                new PreferencRank("赵薇", 13),
                new PreferencRank("跑步", 14),
                new PreferencRank("七里香", 16),
                new PreferencRank("铁板烧", 10),
                new PreferencRank("丰田", 20),
                new PreferencRank("登喜路", 15),
                                     };

             //阀值为60，查询10000次
            Test(new SimpleAnlayse(), users, pRanks, 60, 10000);
            Test(new CubeAnlayse(), users, pRanks, 60, 10000);
            Test(new SuperCubeAnalyse(), users, pRanks, 60, 10000);

            Console.ReadKey();
        }

Test SimpleAnlayse 查询10000次
Count=3
姓名:芮建新, 色调:青,名星:林志林,运动:跑步,歌曲:七里香,小吃:铁板烧,车:丰田,衣服:
太平鸟,得分:60
姓名:吕雨欣, 色调:紫,名星:范冰冰,运动:攀岩,歌曲:七里香,小吃:铁板烧,车:丰田,衣服:
登喜路,得分:61
姓名:赖文婷, 色调:灰,名星:周笔畅,运动:跑步,歌曲:七里香,小吃:兰州拉面,车:丰田,衣
服:登喜路,得分:65
用时 125 秒
Test CubeAnlayse 查询10000次
Count=3
姓名:芮建新, 色调:青,名星:林志林,运动:跑步,歌曲:七里香,小吃:铁板烧,车:丰田,衣服:
太平鸟,得分:60
姓名:吕雨欣, 色调:紫,名星:范冰冰,运动:攀岩,歌曲:七里香,小吃:铁板烧,车:丰田,衣服:
登喜路,得分:61
姓名:赖文婷, 色调:灰,名星:周笔畅,运动:跑步,歌曲:七里香,小吃:兰州拉面,车:丰田,衣
服:登喜路,得分:65
用时 31 秒
Test SuperCubeAnalyse 查询10000次
Count=3
姓名:芮建新, 色调:青,名星:林志林,运动:跑步,歌曲:七里香,小吃:铁板烧,车:丰田,衣服:
太平鸟,得分:60
姓名:吕雨欣, 色调:紫,名星:范冰冰,运动:攀岩,歌曲:七里香,小吃:铁板烧,车:丰田,衣服:
登喜路,得分:61
姓名:赖文婷, 色调:灰,名星:周笔畅,运动:跑步,歌曲:七里香,小吃:兰州拉面,车:丰田,衣
服:登喜路,得分:65
用时 15 秒

eaglet | 专家六级 |园豆：17139 | 2009-05-30 15:00

其他回答(4)

？这个问题（基于集合）用数据库去处理应该是强项吧？

周强 | 园豆：266 (菜鸟二级) | 2009-05-30 00:13

那只是因为你不会用而已.--->对楼主说的。

5万的数据量应该还好吧，最近也刚好在做类似的项目。

什么叫给定的权重及属性在1万到2万间呢？是每个用户有1万个属性，还是说有一万种权重还是说要进行一万次查询？根本没说清楚啊。

风海迷沙 | 园豆：4453 (老鸟四级) | 2009-05-30 12:11

我记得数据结构里面有总算法是求出最小路径

你可以通过给出的查询条件和阀值先算出不符合条件的所有情况

然后把这些过滤掉

然后再获得剩下的条件就ok了

别权重求和在输出

例如：你给的这个条件阀值是60

那么只要权重超过40获取不到的就全部过滤掉

条件1是车，歌曲，衣服不对的不用选（车的权重是20，歌曲是16，衣服是15，这3个都不对就超过40了）

然后是车，歌曲，运动不对的不用选等等

吧所有的不属于的情况列出来（这个可以通过类似最小树的算法吧所有的条件都列出来）

然后再查询条件里面通过select * from table where id not in ( select id from table where (车不相等 and 歌曲不对 and 衣服不对) or 等等) sql我不擅长应该可以优化一下的

这样就可以求出符合条件的人

然后再对每个人进行权重求和

在输出结果就可以了吧

阀值超过50用算法写出不属于的情况

阀值低于50用算法写出属于的情况

过滤条件是越少越好

ps：以上仅仅是个人见解，我没做过这种算法优化

小眼睛老鼠 | 园豆：2731 (老鸟四级) | 2009-05-30 18:27

提前建立好倒排索引，然后按照权重由大到小的顺序使用属性值进行查询，对结果做集合的并操作，同时计算集合中各个元素的潜力分数，如果当前分数加上潜力分数不够阈值的话，从集合中去除。

其中的倒排索引是提前建好的，不应算在5s时间内。

主要的操作是查询和集合合并，指定了多少个属性，就得有多少个查询，每个查询的时间基本是常数的了。

合并操作的复杂性明天再分析，太晚了，睡觉去。

~~~~~~~~~~~~

每个查询的结果列表都是排好序的（倒排表就可以这么建）
合并两个排好序的列表复杂性是列表长度之和
列表中每个元素维持一个当前分数，记录在已经观察了的属性上它所获得的分数
同时有一个全局的潜力分数，表示集合中的元素最多还能得多少分（其实就是剩余属性的分数之和）
在合并时，发现一个元素的当前分数加上潜力分数不足阈值，则将其从当前和所有后续列表中删除
如此得到的最后的列表就是所有慢足要求的元素了

如果平均一个属性值出现在1/K的元素中，合并的复杂性就是 10000×50000/K，K的值就是效率提升的倍数。加上其间对不满足元素的过滤，应该还有不小的提升。

楼主看看有什么启发没有，呵呵，代码懒得写了，只提供一下想法。还有倒排索引的概念是信息检索里的，我是搞信息检索的，望多多交流。

团子老爹 | 园豆：295 (菜鸟二级) | 2009-05-31 00:15

清除回答草稿

您需要登录以后才能回答，未注册用户请先注册。

欢迎，请先 登录 或者 注册 。

一个算法问题。

欢迎，请先登录或者注册。