{"id":656,"date":"2026-03-03T11:17:46","date_gmt":"2026-03-03T03:17:46","guid":{"rendered":"http:\/\/xuebuwan.com\/wp\/?p=656"},"modified":"2026-03-05T10:36:18","modified_gmt":"2026-03-05T02:36:18","slug":"%e9%80%9a%e8%be%be%e4%bf%a1%e4%b9%96%e7%a6%bb%e4%b9%b0%e5%85%a5tdx00021","status":"publish","type":"post","link":"http:\/\/xuebuwan.com\/wp\/?p=656","title":{"rendered":"\u901a\u8fbe\u4fe1\u4e56\u79bb\u4e70\u5165TDX00021"},"content":{"rendered":"

\u6307\u6807\u6e90\u7801<\/h4>\n
MA30:=MA(C,30);\nA9:= DATETODAY(DATE);\nDS:=IF(A9<9966,1,DRAWNULL);\nVARB29:=IF(A9<15366,1,DRAWNULL);\nAA05:=MA(C,5);\n\u4e94\u65e5\u4e56\u79bb\u7387:=(C-AA05)\/AA05*VARB29*100*DS;\n\u4e09\u62fe\u65e5\u4e56\u79bb\u7387:=(C-MA30)\/MA30*100*VARB29;\nMR:=COUNT(CROSS(\u4e94\u65e5\u4e56\u79bb\u7387,0),3)>=1 AND \u4e09\u62fe\u65e5\u4e56\u79bb\u7387>REF(\u4e09\u62fe\u65e5\u4e56\u79bb\u7387,1) AND AA05>REF(AA05,1) AND (C\/REF(C,1)-1)*100>5 AND REF(C,1)<MA30;\n\u4e70\u5165:FILTER(MR,10) ;<\/code><\/pre>\n
\u8fd9\u662f\u4e00\u6b3e\u7ecf\u5178\u7684\u4e56\u79bb\u7387\u9009\u80a1\u6307\u6807<\/strong>\uff0c\u4e13\u95e8\u7528\u4e8e\u6355\u6349\u201c\u5747\u7ebf\u56de\u5f52<\/strong>\u201d\u8fc7\u7a0b\u4e2d\u7684\u5f3a\u52bf\u53cd\u5f39\u80a1\u3002\u8bbe\u8ba1\u7406\u5ff5\u662f\uff1a\u5728\u80a1\u4ef7\u504f\u79bb\u5747\u7ebf\u8fc7\u8fdc\u540e\uff0c\u7531\u7a7a\u8f6c\u591a<\/strong>\u7684\u90a3\u4e2a\u4e34\u754c\u70b9\u4e70\u5165\u3002<\/p>\n
\n
\u4e00\u3001 \u4ee3\u7801\u6838\u5fc3\u903b\u8f91\u5206\u6790<\/h2>\n
1. \u57fa\u7840\u53c2\u6570\u8bbe\u5b9a<\/h3>\n
MA30:=MA(C,30);    \/\/ 30\u65e5\u5747\u7ebf\uff08\u957f\u671f\u6210\u672c\u7ebf\uff09\nAA05:=MA(C,5);     \/\/ 5\u65e5\u5747\u7ebf\uff08\u77ed\u671f\u6210\u672c\u7ebf\uff09<\/code><\/pre>\n
    \n
  • MA30<\/strong>\uff1a\u4ee3\u8868\u4e2d\u671f\u5e02\u573a\u5e73\u5747\u6210\u672c<\/strong><\/li>\n
  • AA05<\/strong>\uff1a\u4ee3\u8868\u77ed\u671f\u5e02\u573a\u5e73\u5747\u6210\u672c<\/strong><\/li>\n<\/ul>\n
    2. \u4e56\u79bb\u7387\u8ba1\u7b97<\/h3>\n
    \u4e94\u65e5\u4e56\u79bb\u7387:=(C-AA05)\/AA05*100;    \/\/ 5\u65e5\u4e56\u79bb\u7387\n\u4e09\u62fe\u65e5\u4e56\u79bb\u7387:=(C-MA30)\/MA30*100;   \/\/ 30\u65e5\u4e56\u79bb\u7387<\/code><\/pre>\n\n\n\n\n\n\n
    \u6307\u6807<\/th>\n\u516c\u5f0f<\/th>\n\u542b\u4e49<\/th>\n<\/tr>\n<\/thead>\n
    \u4e94\u65e5\u4e56\u79bb\u7387<\/strong><\/td>\n(\u6536\u76d8\u4ef7 – 5\u65e5\u5747\u7ebf) \u00f7 5\u65e5\u5747\u7ebf \u00d7 100<\/td>\n\u77ed\u671f\u80a1\u4ef7\u504f\u79bb\u77ed\u671f\u6210\u672c\u7684\u7a0b\u5ea6<\/td>\n<\/tr>\n
    \u4e09\u5341\u65e5\u4e56\u79bb\u7387<\/strong><\/td>\n(\u6536\u76d8\u4ef7 – 30\u65e5\u5747\u7ebf) \u00f7 30\u65e5\u5747\u7ebf \u00d7 100<\/td>\n\u80a1\u4ef7\u504f\u79bb\u4e2d\u671f\u6210\u672c\u7684\u7a0b\u5ea6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      \n
    • \u6b63\u6570<\/strong>\uff1a\u80a1\u4ef7\u5728\u5747\u7ebf\u4e0a\u65b9<\/strong>\uff0c\u5c5e\u4e8e\u8d85\u4e70<\/strong><\/li>\n
    • \u8d1f\u6570<\/strong>\uff1a\u80a1\u4ef7\u5728\u5747\u7ebf\u4e0b\u65b9<\/strong>\uff0c\u5c5e\u4e8e\u8d85\u5356<\/strong><\/li>\n<\/ul>\n
      3. \u6838\u5fc3\u9009\u80a1\u6761\u4ef6\uff08MR\uff09<\/h3>\n
      MR:=COUNT(CROSS(\u4e94\u65e5\u4e56\u79bb\u7387,0),3)>=1   \/\/ \u6761\u4ef61\uff1a5\u65e5\u4e56\u79bb\u73873\u5929\u5185\u4e0a\u7a7f\u8fc70\u8f74\n    AND \u4e09\u62fe\u65e5\u4e56\u79bb\u7387>REF(\u4e09\u62fe\u65e5\u4e56\u79bb\u7387,1)  \/\/ \u6761\u4ef62\uff1a30\u65e5\u4e56\u79bb\u7387\u5f53\u5929\u6bd4\u6628\u5929\u5927\uff08\u6b63\u5728\u53cd\u5f39\uff09\n    AND AA05>REF(AA05,1)                \/\/ \u6761\u4ef63\uff1a5\u65e5\u5747\u7ebf\u5f53\u5929\u6bd4\u6628\u5929\u9ad8\uff08\u77ed\u671f\u8d8b\u52bf\u5411\u4e0a\uff09\n    AND (C\/REF(C,1)-1)*100>5            \/\/ \u6761\u4ef64\uff1a\u5f53\u5929\u6da8\u5e45>5%\uff08\u5f3a\u52bf\u80a1\u7279\u5f81\uff09\n    AND REF(C,1)<MA30;                  \/\/ \u6761\u4ef65\uff1a\u6628\u5929\u6536\u76d8\u4ef7\u572830\u65e5\u5747\u7ebf\u4e0b\u65b9\uff08\u4f4e\u4f4d\u542f\u52a8\uff09<\/code><\/pre>\n
      \u4e94\u5927\u6761\u4ef6\u89e3\u8bfb\uff1a<\/h4>\n\n\n\n\n\n\n\n\n\n
      \u5e8f\u53f7<\/th>\n\u6761\u4ef6<\/th>\n\u542b\u4e49<\/th>\n<\/tr>\n<\/thead>\n
      1<\/td>\n5\u65e5\u4e56\u79bb\u7387\u4e0a\u7a7f0\u8f74<\/strong><\/td>\n\u80a1\u4ef7\u4ece\u4f4e\u4e8e\u77ed\u671f\u6210\u672c\uff0c\u53d8\u4e3a\u9ad8\u4e8e\u6210\u672c\uff0c\u7a7a\u8f6c\u591a\u7684\u4e34\u754c\u70b9<\/td>\n<\/tr>\n
      2<\/td>\n30\u65e5\u4e56\u79bb\u7387\u4e0a\u5347<\/strong><\/td>\n\u4e2d\u671f\u8d8b\u52bf\u6b63\u5728\u597d\u8f6c\uff0c\u53cd\u5f39\u6709\u6301\u7eed\u6027<\/td>\n<\/tr>\n
      3<\/td>\n5\u65e5\u5747\u7ebf\u5411\u4e0a<\/strong><\/td>\n\u77ed\u671f\u8d8b\u52bf\u5df2\u7ecf\u8d70\u5f3a<\/td>\n<\/tr>\n
      4<\/td>\n\u6da8\u5e45>5%<\/strong><\/td>\n\u5f53\u5929\u662f\u5f3a\u52bf\u6da8\u505c\/\u5927\u6da8<\/strong>\u80a1\uff0c\u4e0d\u662f\u5f31\u52bf\u53cd\u5f39<\/td>\n<\/tr>\n
      5<\/td>\n\u6628\u5929\u572830\u65e5\u5747\u7ebf\u4e0b\u65b9<\/strong><\/td>\n\u80a1\u4ef7\u5904\u4e8e\u76f8\u5bf9\u4f4e\u4f4d<\/strong>\uff0c\u542f\u52a8\u524d\u5728\u5e95\u90e8\u9707\u8361<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      4. \u4e70\u5165\u4fe1\u53f7<\/h3>\n
      \u4e70\u5165:FILTER(MR,10);<\/code><\/pre>\n
        \n
      • FILTER\u51fd\u6570<\/strong>\uff1a\u8fc7\u6ee4\u8fde\u7eed\u4fe1\u53f7\uff0c10\u5929\u5185\u4e0d\u91cd\u590d\u663e\u793a<\/strong>\uff0c\u907f\u514d\u4fe1\u53f7\u6cdb\u6ee5\u3002<\/li>\n<\/ul>\n
        \n
        \u4e8c\u3001 \u9009\u80a1\u6548\u679c\u5206\u6790<\/h2>\n
        \u7b5b\u9009\u51fa\u7684\u80a1\u7968\u7279\u5f81<\/h3>\n
        \u8be5\u6307\u6807\u9009\u51fa\u7684\u80a1\u7968\u901a\u5e38\u6ee1\u8db3\u4ee5\u4e0b\u7279\u5f81\uff1a<\/p>\n
          \n
        1. \u957f\u671f\u6a2a\u76d8<\/strong>\uff1a\u80a1\u4ef7\u957f\u671f\u572830\u65e5\u5747\u7ebf\u4e0b\u65b9\u9707\u8361<\/li>\n
        2. \u8d85\u8dcc\u53cd\u5f39<\/strong>\uff1a\u8fd1\u671f\u6709\u4e00\u6ce2\u4e0b\u8dcc\uff0c\u4e56\u79bb\u7387\u8fbe\u5230-10%\u4ee5\u4e0b<\/strong><\/li>\n
        3. \u7a81\u7136\u542f\u52a8<\/strong>\uff1a\u67d0\u4e00\u5929\u653e\u91cf\u5927\u6da8\uff08>5%\uff09<\/strong>\uff0c\u540c\u65f6\u7a81\u78345\u65e5\u548c30\u65e5\u5747\u7ebf<\/li>\n
        4. \u8d8b\u52bf\u8f6c\u591a<\/strong>\uff1a5\u65e5\u5747\u7ebf\u5f00\u59cb\u5411\u4e0a\uff0c5\u65e5\u4e56\u79bb\u7387\u7531\u8d1f\u8f6c\u6b63<\/li>\n<\/ol>\n
          \n
          \u4e09\u3001 \u4f7f\u7528\u65b9\u6cd5<\/h2>\n
          1. \u5b89\u88c5\u6b65\u9aa4<\/h3>\n
            \n
          1. \u901a\u8fbe\u4fe1 -> \u529f\u80fd<\/strong> -> \u516c\u5f0f\u7cfb\u7edf<\/strong> -> \u516c\u5f0f\u7ba1\u7406\u5668<\/strong>\u3002<\/li>\n
          2. \u9009\u62e9 \u201c\u6761\u4ef6\u9009\u80a1\u201d<\/strong> \u6216 \u201c\u526f\u56fe\u6307\u6807\u201d<\/strong>\u3002<\/li>\n
          3. \u70b9\u51fb \u201c\u65b0\u5efa\u201d<\/strong>\uff0c\u7c98\u8d34\u4ee3\u7801\u3002<\/li>\n
          4. \u540d\u79f0\u8f93\u5165\uff1a\u4e56\u79bb\u4e70\u5165<\/code>\u3002<\/li>\n
          5. \u786e\u5b9a<\/strong>\u4fdd\u5b58\u3002<\/li>\n<\/ol>\n
            2. \u9009\u80a1\u64cd\u4f5c<\/h3>\n
              \n
            1. \u529f\u80fd<\/strong> -> \u9009\u80a1\u5668<\/strong> -> \u6761\u4ef6\u9009\u80a1<\/strong>\u3002<\/li>\n
            2. \u9009\u62e9 \u4e56\u79bb\u4e70\u5165<\/code> \u516c\u5f0f\u3002<\/li>\n
            3. \u9009\u80a1\u8303\u56f4<\/strong>\uff1a\u53ef\u6839\u636e\u9700\u8981\u9009\u62e9\uff08\u5982\u201c\u6caa\u6df1A\u80a1\u201d\u3001\u201c\u521b\u4e1a\u677f\u201d\u7b49\uff09\u3002<\/li>\n
            4. \u9009\u80a1\u5468\u671f<\/strong>\uff1a\u5efa\u8bae\u9009\u62e9\u65e5\u7ebf<\/strong>\u3002<\/li>\n
            5. \u6267\u884c\u9009\u80a1<\/strong>\u3002<\/li>\n<\/ol>\n
              3. \u5b9e\u6218\u4ea4\u6613\u7b56\u7565<\/h3>\n
              \u4fe1\u53f7\uff1a\u4e70\u5165<\/strong><\/h4>\n