ͨ´ïÐÅ»ù½ð¼Ó²Ö¹«Ê½£¨Í¨´ïÐÅ˽ļÄÚ²¿×¨ÓÃÖ¸±ê¹«Ê½£©

ÆÚ»õ½»Ò× 2025-08-28 08:26ÆÚ»õ½»Ò×www.xyhndec.cn

ͨ´ïÐżӲÖÖ¸±êתΪÌõ¼þÑ¡¹ÉÖ¸±ê

Ò»¡¢±£³ÖÔ­Òâ£¬×¢ÖØÊµÓÃÐÔ

¶þ¡¢×ª»¯Ï¸½Ú

ÔÚ½«¼Ó²ÖÖ¸±êת»¯ÎªÌõ¼þÑ¡¹ÉÖ¸±êʱ£¬ÎÒÃÇÐèÒª¹Ø×¢¼¸¸ö¹Ø¼üµã£º

1. ²ÎÊýµ÷Õû£º±ÜÃâʹÓÃδÀ´²ÎÊý£¬ÒÔ¼õÉÙ½á¹ûµÄ²»È·¶¨ÐÔ¡£Î´À´²ÎÊý¿ÉÄܻᵼÖÂÖ¸±êµÄÏÔʾ½á¹ûËæÊ±¼ä·¢Éú±ä»¯£¬´Ó¶øÓ°ÏìÑ¡¹ÉµÄ׼ȷÐÔ¡£

2. Ñ¡¹ÉÂß¼­£º¸ù¾Ýͨ´ïÐŵÄÑ¡¹É»úÖÆ£¬¹¹½¨ÇåÎúµÄÑ¡¹ÉÂß¼­¡£Õâ°üÀ¨Ê¶±ðÄÄЩ¹ÉƱº¬ÓС°¼Ó²Ö¡±»ò¡°ÂòÈ롱µÄÐźţ¬ÒÔ¼°»ùÓÚÕâЩÐźŵĽøÒ»²½É¸Ñ¡Ìõ¼þ¡£

Èý¡¢¾ßÌåʵÏÖ·½Ê½

¶ÔÓÚº¬ÓС°¼Ó²Ö¡±»ò¡°ÂòÈ롱µÄ¹ÉƱɸѡ£¬ÎÒÃÇ¿ÉÒÔʹÓÃͨ´ïÐŵÄÎı¾ÍÚ¾ò¹¦ÄÜ£¬½áºÏ¹Ø¼ü´ÊËÑË÷ºÍ¹ÉƱ³ØÉ¸Ñ¡À´ÊµÏÖ¡£¶ÔÓÚ¾ßÌåµÄÑ¡¹É¹«Ê½ºÍËã·¨£¬¿ÉÄÜÐèÒª½áºÏͨ´ïÐÅÈí¼þµÄ¹«Ê½ÓïÑÔ½øÐбàд¡£ÒÔÏÂÊÇÒ»¸ö¼òµ¥µÄʾÀý¹«Ê½£º

```plaintext

// ¼Ó²ÖÑ¡¹É¹«Ê½Ê¾Àý

VAR1:=FINDTEXT('¼Ó²Ö',DYNAINFO(27)); // ÔÚ¶¯Ì¬ÐÅÏ¢ÖÐËÑË÷°üº¬¡°¼Ó²Ö¡±µÄÎı¾

VAR2:=FINDTEXT('ÂòÈë',DYNAINFO(27)); // ÔÚ¶¯Ì¬ÐÅÏ¢ÖÐËÑË÷°üº¬¡°ÂòÈ롱µÄÎı¾

Ìõ¼þ:=VAR1 OR VAR2; // Âú×ãÈÎÒ»Ìõ¼þµÄ¹ÉƱ±»Ñ¡ÖÐ

```

2¡¢ÈçºÎÑ¡³öͨ´ïÐÅÖдøÓС°¼Ó²Ö¡±»ò¡°ÂòÈ롱ÐÅºÅµÄ¹ÉÆ±¼Ó²ÖµãÖ¸±ê

ÔÚ¹ÉÊÐÖУ¬Ñ°ÕÒ¾ßÓС°¼Ó²Ö¡±»ò¡°ÂòÈ롱ÐÅºÅµÄ¹ÉÆ±ÊÇÿ¸öͶ×ÊÕߵıØÐ޿Ρ£ÔÚͨ´ïÐÅÈí¼þÖУ¬ÎÒÃÇ¿ÉÒÔͨ¹ýһϵÁеļ¼ÊõÖ¸±êÀ´É¸Ñ¡³öÕâЩ¹ÉƱ¡£

ÎÒÃÇÀ´¿´ÎåÈÕ¹ÔÀëÂÊ£¬Ëü·´Ó³ÁË¹ÉÆ±½üÆÚ¼Û¸ñµÄ²¨¶¯Çé¿ö¡£µ±ÕâÒ»Ö¸±êÓ볤ÆÚƽ¾ù¼Û¸ñ²úÉúÕýÏòÆ«²îʱ£¬¿ÉÄܾÍÊÇÎÒÃǹØ×¢µÄʱºò¡£ÔÙ¼ÓÉÏBB05Ïߣ¨Í¨¹ýATANº¯Êý¼ÆËãµÃµ½£©µÄ×ßÊÆ£¬µ±¸ÃÏßÉÏ´©Ä³Ò»Ìض¨Êýֵʱ£¬¸üÔö¼ÓÁËÎÒÃǵĹØ×¢Á¦¶È¡£ÎÒÃÇ»¹ÒªÈ·±£¶ÌÆÚÄڵļ***ٶȺÍËÙ¶ÈÖ¸±ê¶¼ÔÚÔö³¤¡£

¹«Ê½ÈçÏ£º¼ÆËãMA£¨ÊÕÅ̼ۣ¬3£©×÷Ϊ¶ÌÆÚ²Î¿¼Ïߣ¬¼ÆËãÎåÈÕ¹ÔÀëÂÊ£»Ê¹ÓÃATANº¯Êý¼ÆËãBB05Ïߵı仯ÂÊ£»ÔÙ¼ÆËãËÙ¶È5ºÍ¼***Ù¶È5µÈÖ¸±ê¡£µ±COUNTº¯Êý¼ÆËãµÄ½»²æ´ÎÊý´ïµ½Ò»¶¨ÊýÖµ£¬ÇÒÂú×ãÆäËûÌõ¼þʱ£¬ÎÒÃǽ«Æä±ê¼ÇΪº¬ÓС°¼Ó²Ö¡±ÐÅºÅµÄ¹ÉÆ±¡£¾ßÌ幫ʽΪ£ºFILTER£¨COUNT(CROSS(BB05,30),5£©>=1 AND AA05>REF(AA05,1) ¡­¡­£©¡£

3¡¢Í¨´ïÐÅ»ù½ðÕ¼Á÷ͨÅ̱ÈÂʹ«Ê½

ÏëÒªÁ˽â»ù½ðÔÚ¹ÉÆ±ÖеÄÕ¼Á÷ͨÅ̱ÈÂÊ£¬¿ÉÒÔͨ¹ýÒ»¸ö¼òµ¥µÄ¹«Ê½À´¼ÆË㣺»ù½ðÕ¼Á÷ͨÅ̱ÈÂÊ = ³Ö¹ÉÊý£¨Íò£©/ A¹ÉÁ÷ͨÅÌ£¨Íò£©%¡£Õâ¸ö±ÈÂÊ¿ÉÒÔ°ïÖúÎÒÃÇÁ˽â»ù½ðÔÚijֻ¹ÉƱÖеijֹÉÇé¿ö¡£ÔÚͨ´ïÐÅÈí¼þÖУ¬¿ÉÒÔͨ¹ýÏàÓ¦µÄÊý¾Ý²éѯ¹¦ÄÜÀ´»ñÈ¡ÕâЩÐÅÏ¢¡£

4¡¢Í¨´ïÐÅÑ¡¹É¹«Ê½ÖеļӲÖÐźÅת»¯

ÔÚͨ´ïÐŵÄÑ¡¹É¹«Ê½ÖУ¬½«¼Ó²ÖÐźÅת»¯Îª¾ßÌåµÄÑ¡¹ÉÌõ¼þÊÇÒ»Ïî¼¼ÊõÌôÕ½¡£ÏÂÃæÌṩһ¸ö¿ÉÄܵÄÑ¡¹É¹«Ê½Ô´Â룺Ê×Ïȶ¨ÒåһЩ»ù´¡Ö¸±êÈçDIF¡¢DEAµÈ£¬È»ºó¼ÆËãRSVÖµÒÔ¼°ÆäËûÏà¹ØÖ¸±ê¡£ÔÚ´Ë»ù´¡ÉÏ£¬Í¨¹ýһϵÁеÄÌõ¼þÅжÏÀ´É¸Ñ¡³ö¾ßÓмӲÖÐÅºÅµÄ¹ÉÆ±¡£Çë×¢Ò⣬´Ë¹«Ê½¿ÉÄܺ¬ÓÐδÀ´º¯Êý£¬Ê¹ÓÃʱÐè½÷É÷¡£¾ßÌ幫ʽΪ£º¡­¡­£¨ÓÑÇéÌáÐÑ£º¸ÃÖ¸±êº¬ÓÐ׼δÀ´Ðźţ¬»áÆ¯ÒÆ£¬²»¶®µÄÈËÇëÉ÷Óã©¡£

5¡¢¹ÉƱׯ¼ÒÎü³ïµÄÖ¸±ê¹«Ê½

ׯ¼ÒµÄÎü³ïÐÐΪÊǹÉÊÐÖеÄÖØÒªÏÖÏó¡£ÔÚͨ´ïÐÅÈí¼þÖУ¬ÎÒÃÇ¿ÉÒÔͨ¹ýһϵÁÐÖ¸±ê¹«Ê½À´¸¨ÖúÅжÏׯ¼ÒµÄÎü³ïÐÐΪ¡£ÕâЩָ±ê°üÀ¨VAR1¡¢VAR2µÈ¼ÆËã¹É¼ÛÆ«ÀëÂʵÄÖ¸±ê£¬ÒÔ¼°ÓÃÓÚÅжÏÇ÷ÊÆµÄ²¨¡¢¶ÎµÈ¡£µ±ÕâЩָ±ê³öÏÖ½»²æ²¢Âú×ãÒ»¶¨Ìõ¼þʱ£¬¿ÉÄÜÒâζ×Åׯ¼ÒÕýÔÚÎü³ï¡£¾ßÌ幫ʽ½ÏΪ¸´ÔÓ£¬°üÀ¨CROSSº¯Êý¡¢FILTERº¯ÊýµÈµÄʹÓ᣹«Ê½Öл¹°üº¬Ò»Ð©¸¨ÖúÏߺÍÅжÏÌõ¼þ£¬°ïÖúͶ×ÊÕ߸üºÃµØ°ÑÎÕ»ú»á¡£ÀýÈ磬µ±¹Éº£Öµ³¬¹ýijһãÐֵʱ£¬¿ÉÄܳöÏÖÄ¿±êB»òÄ¿±êAµÄÂòÈëÐźš£ÇëͶ×ÊÕßÔÚʹÓÃÕâЩ¹«Ê½Ê±½÷É÷Åжϲ¢×÷³ö¾ö²ß¡£

ÄãÊÇ·ñÔÚѰÕÒÒ»ÖÖÄܹ»Í¸ÊÓ»ú¹¹Ë½Ä¼½»Ò×Ã÷ϸµÄ¹«Ê½£¿ºÜÒź¶µØ¸æËßÄ㣬ĿǰûÓÐÈκι«Ê½¿ÉÒÔÖ±½Ó½Òʾÿ±Ê½»Ò×±³ºóµÄ»ú¹¹Éí·Ý¡£ÏëÁ˽â˽ļ½»Ò×µÄÇé¿ö£¬Ö÷ÒªÒÀÀµÓÚÁú»¢°ñËùÌṩµÄÊý¾Ý£¬ÕâÊÇÒ»¸ö¹«¿ªÇÒÏà¶Ô¿É¿¿µÄÐÅÏ¢À´Ô´£¬Ã¿Ì컦Éî½»Ò×Ëù¶¼»á·¢²¼Ïà¹ØÊý¾Ý¡£ËäÈ»ÎÒÃDz»ÄÜÖ±½Ó¿ú̽µ½»ú¹¹µÄ½»Ò×ÃØÃÜ£¬µ«¿ÉÒÔͨ¹ýÆäËû·½Ê½Ñо¿Êг¡¶¯Ì¬¡£

ÔÙÀ´ËµËµÑ¡¹É¹«Ê½µÄÎÊÌ⡣ʹÓÃͨ´ïÐŵÄÑ¡¹É¹«Ê½È·ÊµÐèҪһЩ¼¼Çɺ;­Ñ飬¿ÉÄÜÈÃһЩÐÂÊָе½ÓÐЩÀ§»ó¡£ÊDz»ÊǾõµÃÕâЩ¹«Ê½ÏñÊÇÒþÐεÄÕϰ­£¬ÈÃÄãÎÞ·¨ÇáËÉɸѡ³öÐÄÒÇµÄ¹ÉÆ±£¿Õâʱ£¬Äã¿ÉÄÜÔÚ¿¼ÂÇÊÇ·ñÓиü¼ò±ãµÄ×Ô¶¯Ñ¡¹É¹¤¾ß¡£

´ð°¸ÊÇÓС£ÏÖÔÚµÄÊг¡ÉÏÓÐÐí¶à×Ô¶¯Ñ¡¹ÉÈí¼þ£¬ËüÃÇ¿ÉÒÔ»ùÓÚ¸÷ÖÖ¼¼ÊõÖ¸±ê¡¢²ÆÎñÊý¾Ý¡¢Êг¡Ç÷ÊÆµÈ£¬°ïÖúÄã¿ìËÙɸѡ³öDZÁ¦¹É¡£ÕâЩÈí¼þµÄ³öÏÖ£¬¾ÍÏñÊÇΪÄãÁ¿Éí¶¨ÖÆµÄ³´¹ÉÖúÊÖ£¬ÈÃÄã²»ÔÙΪ¸´ÔӵĹ«Ê½·³ÄÕ¡£ËüÃDz»½ö¼ò»¯ÁËÑ¡¹ÉÁ÷³Ì£¬»¹Ìá¸ßÁËÑ¡¹ÉµÄЧÂʺÍ׼ȷÐÔ¡£

¼Çס£¬Í¶×ÊÊг¡ÓÀÔ¶Ôڱ仯£¬ÐµĹ¤¾ßºÍ²ßÂÔÒ²ÔÚ²»¶ÏÓ¿ÏÖ¡£ÀͶ¯ÊÇ´´Ôì²Æ¸»µÄԴȪ£¬µ«½èÖúÏÖ´ú¿Æ¼¼µÄÁ¦Á¿£¬ÎÒÃÇ¿ÉÒÔ¸ü¸ßЧµØ»ñÈ¡²Æ¸»¡£ÎÞÐè¾ÖÏÞÓÚ´«Í³µÄÑ¡¹É¹«Ê½£¬Äã¿ÉÒÔ¸ü¶àÏÖ´ú»¯µÄ¹¤¾ßºÍ·½·¨£¬ÈÃÄãµÄͶ×Ê֮·¸ü¼Ó¿í¹ãºÍ˳³©¡£

ÏëÒªÁ˽â˽ļ½»Ò×Ã÷ϸºÍ¼ò»¯Ñ¡¹ÉÁ÷³ÌµÄÅóÓÑÃÇ£¬ÏÖÔÚÓÐÁ˸ü¶àµÄÑ¡ÔñºÍ¿ÉÄÜ¡£²»¶ÏѧϰºÍÊÊÓ¦ÐµĹ¤¾ß£¬½«ÓÐÖúÓÚÄãÔÚͶ×ÊÊг¡ÉÏ×ߵøüÔ¶¡£

Copyright@2015-2025 www.xyhndec.cn Å£³´¹É °æÈ¨ËùÓÐ