{"id":1570,"date":"2026-03-06T17:53:12","date_gmt":"2026-03-06T09:53:12","guid":{"rendered":"http:\/\/xuebuwan.com\/wp\/?p=1570"},"modified":"2026-03-06T17:53:12","modified_gmt":"2026-03-06T09:53:12","slug":"%e9%80%9a%e8%be%be%e4%bf%a1cog%e5%92%8cdo%e7%b3%bb%e7%bb%9f%e6%8c%87%e6%a0%87%e5%85%ac%e5%bc%8ftdx00449","status":"publish","type":"post","link":"http:\/\/xuebuwan.com\/wp\/?p=1570","title":{"rendered":"\u901a\u8fbe\u4fe1COG\u548cDO\u7cfb\u7edf\u6307\u6807\u516c\u5f0fTDX00449"},"content":{"rendered":"

\u6307\u6807\u6e90\u7801<\/h4>\n
\u4e2d\u5fc3\u91cd\u529b\u548c\u53bb\u52bf\u632f\u8361\u5668\u6307\u6807,\u7528\u4e8e\u5224\u65ad\u884c\u60c5\u8d70\u52bf.\nCOG:-1 *(REF(C,10)*(REF(C,10)+1))\/(REF(C,10))+C;\nDO:MA(C- MA(C,16),3);\n0,DOTLINE;<\/code><\/pre>\n
1. \u4ee3\u7801\u6574\u4f53\u7ed3\u6784\u4e0e\u542b\u4e49<\/h2>\n
\u4e0b\u9762\u628a\u901a\u8fbe\u4fe1\u6307\u6807 COG\uff08\u4e2d\u5fc3\u91cd\u529b\uff09<\/strong> \u4e0e DO\uff08\u53bb\u52bf\u632f\u8361\u5668\uff09<\/strong> \u7684\u516c\u5f0f\u9010\u884c\u62c6\u89e3\uff0c\u5e2e\u52a9\u4f60\u5feb\u901f\u628a\u63e1\u5b83\u7684\u8ba1\u7b97\u903b\u8f91\u4e0e\u7528\u9014\u3002<\/p>\n
\u4e2d\u5fc3\u91cd\u529b\u548c\u53bb\u52bf\u632f\u8361\u5668\u6307\u6807,\u7528\u4e8e\u5224\u65ad\u884c\u60c5\u8d70\u52bf.\nCOG:-1 *(REF(C,10)*(REF(C,10)+1))\/(REF(C,10))+C;\nDO:MA(C- MA(C,16),3);\n0,DOTLINE;<\/code><\/pre>\n\n\n\n\n\n\n\n\n
\u884c\u53f7<\/th>\n\u5185\u5bb9<\/th>\n\u89e3\u91ca<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\n\u4e2d\u5fc3\u91cd\u529b\u548c\u53bb\u52bf\u632f\u8361\u5668\u6307\u6807,\u7528\u4e8e\u5224\u65ad\u884c\u60c5\u8d70\u52bf.<\/code><\/td>\n\u6ce8\u91ca\uff08\u8bf4\u660e\u6307\u6807\u76ee\u7684\uff09<\/td>\n<\/tr>\n
2<\/td>\nCOG:-1 *(REF(C,10)*(REF(C,10)+1))\/(REF(C,10))+C;<\/code><\/td>\nCOG<\/strong>\uff08\u4e2d\u5fc3\u91cd\u529b\uff09\u6307\u6807\u7684\u8ba1\u7b97\u5f0f<\/td>\n<\/tr>\n
3<\/td>\nDO:MA(C- MA(C,16),3);<\/code><\/td>\nDO<\/strong>\uff08\u53bb\u52bf\u632f\u8361\u5668\uff09\u6307\u6807\u7684\u8ba1\u7b97\u5f0f<\/td>\n<\/tr>\n
4<\/td>\n0,DOTLINE;<\/code><\/td>\n\u5728\u96f6\u8f74\u4e0a\u7ed8\u5236\u4e00\u6761\u70b9\u7ebf\uff08\u8f85\u52a9\u5224\u65ad\u6b63\u8d1f\u533a\u95f4\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n
2. \u516c\u5f0f\u9010\u884c\u89e3\u6790<\/h3>\n
2.1 COG\uff08\u4e2d\u5fc3\u91cd\u529b\uff09<\/h4>\n
COG = -1 * ( REF(C,10) * (REF(C,10)+1) ) \/ REF(C,10) + C<\/code><\/pre>\n
    \n
  • REF(C,10)<\/code>\uff1a\u6536\u76d8\u4ef7 10 \u6839K\u7ebf\u524d<\/strong> \u7684\u503c  <\/li>\n
  • \u5316\u7b80\uff1a<\/li>\n<\/ul>\n
    [\n\\begin{aligned}\n\\frac{REF(C,10)(REF(C,10)+1)}{REF(C,10)} &= REF(C,10) + 1 \\\n-1 <\/em> (REF(C,10) + 1) &= -(REF(C,10) + 1) \\\n\\text{\u4e8e\u662f } COG &= C – REF(C,10) – 1\n\\end{aligned}\n]<\/p>\n
    \n
    \u672c\u8d28<\/strong>\uff1a\u5f53\u524d\u6536\u76d8\u4ef7 \u51cf\u53bb<\/strong> 10\u5468\u671f\u524d\u7684\u6536\u76d8\u4ef7\uff0c\u518d\u51cf\u53bb\u5e38\u6570 1\uff08\u4ec5\u662f\u4e3a\u4e86\u628a\u96f6\u70b9\u7a0d\u5fae\u5411\u4e0b\u5e73\u79fb\uff0c\u907f\u514d\u51fa\u73b0 0\u2011\u503c\u7684\u60c5\u5f62\uff09\u3002
    \n\u6362\u53e5\u8bdd\u8bf4\uff0c\u5b83\u662f\u4e00\u4e2a 10 \u671f\u7684\u4ef7\u683c\u52a8\u91cf<\/strong>\uff0c\u6570\u503c > 0 \u8868\u793a\u8fd1\u671f\u4ef7\u683c\u76f8\u5bf9 10 \u5929\u524d\u4e0a\u6da8\uff0c< 0 \u8868\u793a\u4e0b\u8dcc\u3002<\/p>\n<\/blockquote>\n
    2.2 DO\uff08\u53bb\u52bf\u632f\u8361\u5668\uff09<\/h4>\n
    DO = MA( C - MA(C,16) , 3 )<\/code><\/pre>\n
      \n
    1. MA(C,16)<\/code>\uff1a\u6536\u76d8\u4ef7\u7684 16 \u5468\u671f\u7b80\u5355\u79fb\u52a8\u5e73\u5747<\/strong>\uff08\u4e2d\u77ed\u671f\u5747\u4ef7\uff09\u3002  <\/li>\n
    2. C - MA(C,16)<\/code>\uff1a\u4ef7\u683c\u76f8\u5bf9\u5176 16 \u671f\u5747\u7ebf\u7684 \u504f\u79bb\uff08\u5dee\u503c\uff09<\/strong>\uff0c\u6b63\u503c\u4e3a\u4ef7\u683c\u9ad8\u4e8e\u5747\u7ebf\uff0c\u8d1f\u503c\u4e3a\u4f4e\u4e8e\u5747\u7ebf\u3002  <\/li>\n
    3. MA(...,3)<\/code>\uff1a\u5bf9\u4e0a\u8ff0\u5dee\u503c\u518d\u505a 3 \u5468\u671f\u7b80\u5355\u79fb\u52a8\u5e73\u5747<\/strong>\uff08\u5e73\u6ed1\uff09\uff0c\u5f97\u5230 DO<\/strong>\u3002<\/li>\n<\/ol>\n
      \n
      \u672c\u8d28<\/strong>\uff1a\u5bf9 \u4ef7\u683c\u4e0e\u5747\u7ebf\u4e4b\u95f4\u7684\u504f\u79bb<\/strong> \u8fdb\u884c\u5e73\u6ed1\uff0c\u5f62\u6210\u4e00\u79cd \u53bb\u52bf\uff08detrended\uff09\u632f\u8361\u5668<\/strong>\u3002
      \n\u5f53 DO > 0 \u65f6\uff0c\u4ef7\u683c\u77ed\u7ebf\u9ad8\u4e8e\u5176\u4e2d\u671f\u5747\u4ef7\uff08\u504f\u591a\uff09\uff1bDO < 0 \u5219\u504f\u7a7a\u3002<\/p>\n<\/blockquote>\n
      2.3 \u96f6\u70b9\u7ebf<\/h4>\n
      0,DOTLINE;<\/code><\/pre>\n
        \n
      • \u5728\u6307\u6807\u7a97\u53e3\u7684 0<\/strong> \u4f4d\u7f6e\u753b\u4e00\u6761 \u70b9\u7ebf<\/strong>\uff0c\u5e2e\u52a9\u76f4\u63a5\u5224\u65ad COG\u3001DO \u662f\u6b63\u8fd8\u662f\u8d1f\u3002<\/li>\n<\/ul>\n
        \n
        3. \u53c2\u6570\u5316\uff08\u53ef\u9009\uff09<\/h2>\n
        \u5982\u679c\u4f60\u60f3\u81ea\u884c\u8c03\u8282\u5468\u671f\uff0c\u53ef\u628a\u4ee3\u7801\u6539\u6210 \u8f93\u5165\u53c2\u6570<\/strong> \u5f62\u5f0f\uff1a<\/p>\n
        \/\/ \u53c2\u6570 N1\u3001N2\u3001N3 \u5206\u522b\u4e3a COG\u3001DO\u2011MA\u3001DO\u2011SMA \u7684\u5468\u671f\nN1:=10; N2:=16; N3:=3;\n\nCOG: C - REF(C,N1) - 1;\nDO:  MA(C - MA(C,N2), N3);\n0, DOTLINE;<\/code><\/pre>\n
          \n
        • N1<\/code>\uff1aCOG \u4f7f\u7528\u7684\u56de\u770b\u5468\u671f\uff08\u9ed8\u8ba4 10\uff09  <\/li>\n
        • N2<\/code>\uff1aDO \u4e2d\u5148\u6c42\u7684\u5747\u7ebf\u5468\u671f\uff08\u9ed8\u8ba4 16\uff09  <\/li>\n
        • N3<\/code>\uff1aDO \u518d\u6b21\u5e73\u6ed1\u7684\u5468\u671f\uff08\u9ed8\u8ba4 3\uff09<\/li>\n<\/ul>\n
          \n
          4. \u5982\u4f55\u5728\u901a\u8fbe\u4fe1\u4e2d\u52a0\u8f7d\u4f7f\u7528<\/h2>\n
          \n
          \u6ce8\u610f<\/strong>\uff1a\u4e0b\u9762\u7684\u64cd\u4f5c\u8def\u5f84\u57fa\u4e8e \u901a\u8fbe\u4fe1\u5b98\u65b9\u5ba2\u6237\u7aef\uff082024\u20112025 \u5e38\u7528\u7248\uff09<\/strong>\uff0c\u4e0d\u540c\u7248\u672c\u7ec6\u8282\u7565\u6709\u5dee\u522b\uff0c\u4f46\u5927\u4f53\u76f8\u540c\u3002<\/p>\n<\/blockquote>\n
            \n
          1. \n
            \u6253\u5f00\u516c\u5f0f\u7ba1\u7406\u5668<\/strong>  <\/p>\n
              \n
            • \u5728\u4e3b\u83dc\u5355\u680f\u70b9\u51fb \u201c\u516c\u5f0f\u201d \u2192 \u201c\u516c\u5f0f\u7ba1\u7406\u5668\u201d<\/strong>\uff08\u6216\u5feb\u6377\u952e Ctrl+F<\/code>\uff09\u3002  <\/li>\n<\/ul>\n<\/li>\n
            • \n
              \u65b0\u5efa\u6280\u672f\u6307\u6807<\/strong>  <\/p>\n
                \n
              • \u5728\u5de6\u4fa7\u6811\u5f62\u76ee\u5f55\u4e2d\u9009\u62e9 \u201c\u6280\u672f\u6307\u6807\u201d<\/strong>\uff0c\u70b9\u51fb \u201c\u65b0\u5efa\u201d<\/strong>\u3002  <\/li>\n
              • \u5f39\u51fa \u201c\u65b0\u5efa\u6307\u6807\u201d \u5bf9\u8bdd\u6846\uff0c\u586b\u5199 \u6307\u6807\u540d\u79f0<\/strong>\uff08\u5982 COG_DO<\/code>\uff09\uff0c\u9009\u62e9 \u6240\u5c5e\u7c7b\u522b<\/strong>\uff08\u53ef\u81ea\u884c\u65b0\u5efa\u5982 \u201c\u81ea\u5b9a\u4e49\u6307\u6807\u201d\uff09\uff0c\u70b9 \u786e\u5b9a<\/strong>\u3002  <\/li>\n<\/ul>\n<\/li>\n
              • \n
                \u7c98\u8d34\u6e90\u7801<\/strong>  <\/p>\n
                  \n
                • \u5728\u4ee3\u7801\u7f16\u8f91\u6846\u91cc\u7c98\u8d34 \u5b8c\u6574\u6e90\u7801<\/strong>\uff08\u5305\u62ec\u6ce8\u91ca\u884c\uff09\uff0c\u6216\u8005\u4f7f\u7528\u4e0a\u9762\u53c2\u6570\u5316\u7248\u672c\u3002  <\/li>\n
                • \u82e5\u4f7f\u7528\u53c2\u6570\u5316\u7248\uff0c\u9700\u8981\u5728 \u201c\u53c2\u6570\u201d<\/strong> \u6807\u7b7e\u9875\u91cc\u628a N1\u3001N2\u3001N3<\/code> \u8bbe\u4e3a \u53d8\u91cf<\/strong>\uff08\u9ed8\u8ba4 10\u300116\u30013\uff09\uff0c\u8fd9\u6837\u5728\u56fe\u8868\u4e0a\u53ef\u4ee5\u624b\u52a8\u8c03\u8282\u3002  <\/li>\n<\/ul>\n<\/li>\n
                • \n
                  \u4fdd\u5b58\u5e76\u7f16\u8bd1<\/strong>  <\/p>\n
                    \n
                  • \u70b9\u51fb \u201c\u4fdd\u5b58\u201d<\/strong>\uff08\u6216 Ctrl+S<\/code>\uff09\uff0c\u7cfb\u7edf\u4f1a\u81ea\u52a8\u68c0\u67e5\u8bed\u6cd5\u3002  <\/li>\n
                  • \u82e5\u51fa\u73b0\u9519\u8bef\uff0c\u5149\u6807\u4f1a\u5b9a\u4f4d\u5230\u9519\u8bef\u884c\uff0c\u4fee\u6b63\u540e\u91cd\u65b0\u4fdd\u5b58\u3002  <\/li>\n<\/ul>\n<\/li>\n
                  • \n
                    \u5728\u56fe\u8868\u4e2d\u8c03\u7528<\/strong>  <\/p>\n
                      \n
                    • \u6253\u5f00\u4efb\u610f\u4e00\u53ea\u80a1\u7968\uff08\u6216\u671f\u8d27\u3001\u6307\u6570\uff09\u7684 \u65e5\u7ebf\/\u5206\u949f\u7ebf<\/strong> \u56fe\u8868\u3002  <\/li>\n
                    • \u53f3\u952e\u70b9\u51fb\u56fe\u8868 \u2192 \u201c\u6307\u6807\u201d \u2192 \u201c\u9009\u62e9\u6307\u6807\u201d<\/strong>\uff08\u6216\u76f4\u63a5\u5728\u952e\u76d8\u4e0a\u6309 TAB<\/code> \u8c03\u51fa\u6307\u6807\u9009\u62e9\u6846\uff09\u3002  <\/li>\n
                    • \u5728\u5217\u8868\u4e2d\u627e\u5230\u521a\u624d\u521b\u5efa\u7684 COG_DO<\/strong>\uff08\u6216 COG<\/code>\u3001DO<\/code> \u4e24\u6761\u7ebf\uff09\uff0c\u9009\u4e2d\u540e \u786e\u5b9a<\/strong>\u3002  <\/li>\n<\/ul>\n<\/li>\n
                    • \n
                      \u663e\u793a\u6548\u679c<\/strong>  <\/p>\n
                        \n
                      • \u6307\u6807\u7a97\u53e3\u4f1a\u5f39\u51fa \u4e24\u6761\u66f2\u7ebf<\/strong>\uff08COG \u4e0e DO\uff09\uff0c\u5e76\u6709\u4e00\u6761 \u70b9\u7ebf<\/strong> \u5728 0 \u8f74\u3002  <\/li>\n
                      • \u4f60\u53ef\u4ee5\u628a COG<\/strong> \u4e0e DO<\/strong> \u5206\u522b\u62d6\u5230 \u4e3b\u56fe<\/strong>\uff08\u4e0e K \u7ebf\u540c\u7a97\uff09\u6216 \u526f\u56fe<\/strong>\uff08\u9ed8\u8ba4\uff09\u663e\u793a\uff0c\u4f9d\u636e\u4e2a\u4eba\u559c\u597d\u3002  <\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
                        \n
                        5. \u6307\u6807\u7684\u89e3\u8bfb\u4e0e\u4ea4\u6613\u601d\u8def<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n
                        \u5173\u952e\u4fe1\u53f7<\/th>\n\u89e3\u91ca<\/th>\n\u5178\u578b\u7528\u6cd5<\/th>\n<\/tr>\n<\/thead>\n
                        COG > 0<\/strong><\/td>\n10 \u65e5\u5747\u7ebf\u4e4b\u4e0a\uff08\u4e0a\u6da8\u52a8\u91cf\uff09<\/td>\n\u53ef\u89c6\u4e3a \u591a\u5934<\/strong> \u53c2\u8003<\/td>\n<\/tr>\n
                        COG < 0<\/strong><\/td>\n10 \u65e5\u5747\u7ebf\u4e4b\u4e0b\uff08\u4e0b\u8dcc\u52a8\u91cf\uff09<\/td>\n\u53ef\u89c6\u4e3a \u7a7a\u5934<\/strong> \u53c2\u8003<\/td>\n<\/tr>\n
                        DO > 0<\/strong><\/td>\n\u4ef7\u683c\u77ed\u7ebf\u9ad8\u4e8e 16 \u65e5\u5747\u7ebf\uff0c\u4e14\u7ecf 3 \u65e5\u5e73\u6ed1\uff0c\u504f\u591a<\/td>\n\u4e70\u5165<\/strong> \u673a\u4f1a\uff08\u5c24\u5176\u5f53 DO \u4ece\u8d1f\u8f6c\u6b63\u65f6\uff09<\/td>\n<\/tr>\n
                        DO < 0<\/strong><\/td>\n\u4ef7\u683c\u77ed\u7ebf\u4f4e\u4e8e 16 \u65e5\u5747\u7ebf\uff0c\u504f\u7a7a<\/td>\n\u5356\u51fa<\/strong> \u673a\u4f1a\uff08\u5c24\u5176\u5f53 DO \u4ece\u6b63\u8f6c\u8d1f\u65f6\uff09<\/td>\n<\/tr>\n
                        COG \u4e0e DO \u540c\u65f6\u4e3a\u6b63<\/strong><\/td>\n\u4e24\u6307\u6807\u540c\u65f6\u6307\u5411\u591a\u5934<\/td>\n\u5f3a\u52bf\u4e70\u5165<\/strong> \u4fe1\u53f7\uff0c\u53ef\u9002\u5f53\u52a0\u4ed3<\/td>\n<\/tr>\n
                        COG \u4e0e DO \u540c\u65f6\u4e3a\u8d1f<\/strong><\/td>\n\u4e24\u6307\u6807\u540c\u65f6\u6307\u5411\u7a7a\u5934<\/td>\n\u5f3a\u52bf\u5356\u51fa<\/strong> \u4fe1\u53f7\uff0c\u53ef\u8003\u8651\u51cf\u4ed3\u6216\u7a7a\u4ed3<\/td>\n<\/tr>\n
                        DO \u4ea4\u53c9 0 \u8f74<\/strong><\/td>\n\u5feb\u901f\u53d8\u5316\u7684\u5206\u6c34\u5cad<\/td>\n\u5e38\u4f5c\u4e3a \u6b62\u635f\/\u6b62\u76c8<\/strong> \u89e6\u53d1\u70b9<\/td>\n<\/tr>\n
                        COG \u4ea4\u53c9 0 \u8f74<\/strong><\/td>\n\u8f83\u6162\u7684\u8f6c\u6298\u70b9<\/td>\n\u53ef\u7528\u4e8e \u8d8b\u52bf\u786e\u8ba4<\/strong>\uff08\u914d\u5408\u66f4\u9ad8\u65f6\u95f4\u5468\u671f\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                        \n
                        \u5b9e\u6218\u63d0\u793a<\/strong>  <\/p>\n
                          \n
                        1. \u8d8b\u52bf\u8fc7\u6ee4<\/strong>\uff1a\u4ec5\u5728 \u5927\u52bf\u5411\u4e0a<\/strong>\uff08\u5982\u65e5\u7ebf MA20 \u4e0a\u884c\uff09\u65f6\u4f7f\u7528 COG\u3001DO \u7684\u4e70\u5165\u4fe1\u53f7\uff1b\u5728\u5927\u52bf\u5411\u4e0b\u65f6\u53ea\u505a\u7a7a\u6216\u89c2\u671b\u3002  <\/li>\n
                        2. \u4ed3\u4f4d\u7ba1\u7406<\/strong>\uff1aCOG\u3001DO \u540c\u65f6\u4e3a\u6b63\u65f6\u53ef\u4ee5\u628a\u4ed3\u4f4d\u653e\u5927\u5230 1.5~2 \u500d\uff1b\u4e24\u8005\u80cc\u79bb\u65f6\u964d\u81f3 0.5~0.7 \u500d\u3002  <\/li>\n
                        3. \u6b62\u635f\u6280\u5de7<\/strong>\uff1aDO \u7531\u6b63\u8f6c\u8d1f\uff08\u5373\u4e0b\u7a7f 0 \u8f74\uff09\u65f6\u7acb\u5373\u6b62\u635f\uff1bCOG \u4e0b\u7a7f 0 \u8f74\u53ef\u4f5c\u4e3a \u8d8b\u52bf\u6b62\u635f<\/strong>\u3002  <\/li>\n
                        4. \u914d\u5408\u5176\u4ed6\u6307\u6807<\/strong>\uff1a  \n