ͨ´ïÐÅÁ¬°åÊý¿ÉÓÃÓÚʶ±ðDZÁ¦¹É¡£Í¨¹ýÑ¡ÔñºÏÊʵÄÖ¸±ê¹«Ê½ºÍ¼¼Êõ·ÖÎö£¬ÎÒÃÇ¿ÉÒÔÀûÓÃͨ´ïÐÅÁ¬°åÊýÕÒµ½Á¬ÐøÕÇÍ£µÄDZÁ¦¹É¡£¾ßÌå·½·¨ÊÇʹÓÃÖ¸±ê¹«Ê½¼ÆËã³ö¸ÃÖ¸±êµÄÊýÖµ£¬È»ºó¸ù¾ÝÁ¬°åÊý½øÐÐɸѡºÍÅÅÐò£¬ÕÒµ½Ç±Á¦¹É¡£ ͨ´ïÐź¯ÊýÖеġ°Á¬°åÊý¡±Ö¸±êÔ´ÂëÈçÏ£º ͨ´ïÐź¯ÊýÃû£ºLB:=COUNT(C>REF(C,1),N-1)*1.0; ÆäÖÐC´ú±íµ±ÌìÊÕÅ̼ۣ¬REF(C,1)´ú±í×òÌìµÄÊÕÅ̼ۣ¬N´ú±íÁ¬°åµÄÌìÊý¡£ ͨ¹ýÀûÓøÃÖ¸±ê¹«Ê½£¬ÎÒÃÇ¿ÉÒԵõ½Ã¿Ö»¹ÉƱµÄÁ¬°åÊý£¬²¢¸ù¾ÝÁ¬°åÊýÀ´É¸Ñ¡³ö¾ßÓÐÁ¬ÐøÕÇͣDZÁ¦µÄ¹ÉƱ¡£ ͨ¹ýºÏÀíÔËÓÃÖ¸±ê¹«Ê½ºÍ¼¼Êõ·ÖÎö£¬ÎÒÃÇÄܸü¾«×¼µØÕÒµ½Ç±Á¦¹É£¬Ìá¸ßͶ×ÊÊÕÒæÂÊ¡£ ͨ´ïÐÅÁ¬°åÊý,Ö¸±ê¹«Ê½,¼¼Êõ·ÖÎö,DZÁ¦¹É,Á¬ÐøÕÇÍ£,¹ÉƱ,Ñ¡¹É,Ͷ×Ê,ÊÕÒæÂÊ,ÕÇÍ£°å