ͨ´ïÐÅÿ±Ê¾ùÁ¿Ö¸±êÊÇÒ»ÖÖ¼¼ÊõÖ¸±ê£¬ÓÃÓÚÆÀ¹À¹ÉƱµÄ½»Ò×Á¿¡£Í¨¹ý¼ÆËãÿ±Ê½»Ò×µÄƽ¾ù³É½»Á¿£¬¿ÉÒÔÁ˽âÊг¡µÄÂòÂôÁ¦Á¿ºÍ¸¡¶¯Çé¿ö¡£ÀûÓÃÕâ¸öÖ¸±ê¸¨Öú¹ÉƱѡ¹É£¬¿ÉÒÔ¸üºÃµØ°ÑÎÕÊг¡·ÕΧ¡£ ͨ´ïÐÅÿ±Ê¾ùÁ¿Ö¸±êµÄ¼ÆË㹫ʽÈçÏ£º MAVB:= SUM( IF( DJV = REF(DJV,1) , VOL , 0 ), MAVBDays ) / ((REF(MAVBDays,1) * N + 1) / N) ÆäÖУ¬MAVB±íʾͨ´ïÐÅÿ±Ê¾ùÁ¿Ö¸±ê£¬DJV±íʾÿ±Ê³É½»Á¿£¬VOL±íʾ¸Ã±Ê½»Ò׵ijɽ»Á¿£¬MAVBDays±íʾ¼ÆËãÖÜÆÚ£¬N±íʾÒƶ¯Æ½¾ùµÄÌìÊý¡£ ΪÁËÀûÓÃÕâ¸öÖ¸±ê¸¨ÖúÑ¡¹É£¬¿ÉÒÔ¸ù¾ÝÒÔϲ½Öè½øÐвÙ×÷£º 1. ´ò¿ªÍ¨´ïÐÅÈí¼þ£¬½øÈëÏàÓ¦µÄ¹ÉƱ·ÖÎö½çÃæ¡£ 2. ÔÚÖ¸±ê¹«Ê½ÖÐÊäÈëÉÏÊöµÄ¼ÆË㹫ʽ£¬É趨ºÏÊʵļÆËãÖÜÆÚºÍÒƶ¯Æ½¾ùÌìÊý¡£ 3. È·ÈÏÖ¸±ê¹«Ê½ÎÞÎóºó£¬µã»÷È·¶¨£¬¼´¿ÉÔÚͼ±íÉÏÏÔʾÿ±Ê¾ùÁ¿Ö¸±ê¡£ 4. ¸ù¾Ýÿ±Ê¾ùÁ¿Ö¸±êµÄÊýÖµ±ä»¯£¬ÅжÏÊг¡µÄÂòÂôÁ¦Á¿ºÍ¸¡¶¯Çé¿ö£¬´Ó¶ø¸¨ÖúÑ¡È¡¹ÉƱ¡£ ͨ¹ýÀûÓÃͨ´ïÐÅÿ±Ê¾ùÁ¿Ö¸±ê½øÐйÉƱѡ¹É£¬¿ÉÒÔ¸üÈ«ÃæµØÁ˽âÊг¡µÄ½»Ò×Á¿ºÍÇ÷ÊÆ£¬Ìá¸ßÑ¡¹ÉµÄ׼ȷÐÔºÍˮƽ¡£ ͨ´ïÐÅ,ÿ±Ê¾ùÁ¿Ö¸±ê,¹ÉƱѡ¹É,¼¼ÊõÖ¸±ê,½»Ò×Á¿,ÂòÂôÁ¦Á¿,¸¡¶¯Çé¿ö,Òƶ¯Æ½¾ù,Êг¡·ÕΧ,Ñ¡¹É׼ȷÐÔ