{"id":691,"date":"2026-03-03T12:12:01","date_gmt":"2026-03-03T04:12:01","guid":{"rendered":"http:\/\/xuebuwan.com\/wp\/?p=691"},"modified":"2026-03-05T12:01:20","modified_gmt":"2026-03-05T04:01:20","slug":"%e8%b6%85%e8%b7%8c%e7%9f%ad%e7%ba%bf%e6%88%98%e6%b3%95%e9%80%89%e8%82%a1%e6%8c%87%e6%a0%87tdx00047","status":"publish","type":"post","link":"http:\/\/xuebuwan.com\/wp\/?p=691","title":{"rendered":"\u8d85\u8dcc\u77ed\u7ebf\u6218\u6cd5\u9009\u80a1\u6307\u6807TDX00047"},"content":{"rendered":"

\u6307\u6807\u6e90\u7801<\/h4>\n
A1:=REF(C,2)\/REF(C,3)>=1.097;\nA2:=REF(C,2)\/REF(C,1)>=1.097;\nA3:=REF(C,1)\/C>=1.06;\nXG:A1 AND A2 AND A3;<\/code><\/pre>\n
\u8fd9\u662f\u4e00\u6b3e\u6781\u5176\u7b80\u6d01\u7684\u8d85\u8dcc\u53cd\u5f39\u9009\u80a1\u6307\u6807<\/strong>\uff0c\u4e13\u95e8\u6355\u6349\u8fde\u7eed\u6da8\u505c\u540e\u5927\u5e45\u56de\u8c03<\/strong>\u7684\u80a1\u7968\u3002\u8bbe\u8ba1\u7406\u5ff5\u662f\u201c\u7269\u6781\u5fc5\u53cd<\/strong>\u201d\u2014\u2014\u8fde\u7eed\u66b4\u6da8\u540e\u5feb\u901f\u4e0b\u8dcc\uff0c\u53ef\u80fd\u8fce\u6765\u53cd\u5f39\u673a\u4f1a\u3002<\/p>\n
\n
\u4e00\u3001 \u4ee3\u7801\u6838\u5fc3\u903b\u8f91\u5206\u6790<\/h2>\n
1. A1\uff1a\u4e09\u5929\u524d\u7684\u5927\u9633\u7ebf<\/h3>\n
A1:=REF(C,2)\/REF(C,3)>=1.097;<\/code><\/pre>\n\n\n\n\n\n\n\n
\u5143\u7d20<\/th>\n\u542b\u4e49<\/th>\n<\/tr>\n<\/thead>\n
REF(C,2)<\/code><\/td>\n2\u5929\u524d\u7684\u6536\u76d8\u4ef7<\/td>\n<\/tr>\n
REF(C,3)<\/code><\/td>\n3\u5929\u524d\u7684\u6536\u76d8\u4ef7<\/td>\n<\/tr>\n
>=1.097<\/code><\/td>\n\u6da8\u5e45 \u2265 9.7%<\/strong>\uff08\u63a5\u8fd1\u6da8\u505c\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n
  • \u542b\u4e49<\/strong>\uff1a3\u5929\u524d<\/strong>\u80a1\u4ef7\u6da8\u5e45\u22659.7%<\/strong>\uff08\u5927\u9633\u7ebf\/\u6da8\u505c\u677f\uff09<\/li>\n<\/ul>\n
    \n
    2. A2\uff1a\u4e8c\u5929\u524d\u7684\u5927\u9633\u7ebf<\/h3>\n
    A2:=REF(C,2)\/REF(C,1)>=1.097;<\/code><\/pre>\n\n\n\n\n\n\n\n
    \u5143\u7d20<\/th>\n\u542b\u4e49<\/th>\n<\/tr>\n<\/thead>\n
    REF(C,2)<\/code><\/td>\n2\u5929\u524d\u7684\u6536\u76d8\u4ef7<\/td>\n<\/tr>\n
    REF(C,1)<\/code><\/td>\n\u6628\u5929\uff081\u5929\u524d\uff09\u7684\u6536\u76d8\u4ef7<\/td>\n<\/tr>\n
    >=1.097<\/code><\/td>\n\u6da8\u5e45 \u2265 9.7%<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      \n
    • \u542b\u4e49<\/strong>\uff1a2\u5929\u524d<\/strong>\u80a1\u4ef7\u6da8\u5e45\u22659.7%<\/strong>\uff08\u8fde\u7eed\u5927\u9633\u7ebf\uff09<\/li>\n<\/ul>\n
      \n
      3. A3\uff1a\u6628\u5929\u7684\u66b4\u8dcc<\/h3>\n
      A3:=REF(C,1)\/C>=1.06;<\/code><\/pre>\n\n\n\n\n\n\n\n
      \u5143\u7d20<\/th>\n\u542b\u4e49<\/th>\n<\/tr>\n<\/thead>\n
      REF(C,1)<\/code><\/td>\n\u6628\u5929\uff081\u5929\u524d\uff09\u7684\u6536\u76d8\u4ef7<\/td>\n<\/tr>\n
      C<\/code><\/td>\n\u4eca\u5929\u6536\u76d8\u4ef7<\/td>\n<\/tr>\n
      >=1.06<\/code><\/td>\n\u8dcc\u5e45 \u2265 6%<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \n
      • \u542b\u4e49<\/strong>\uff1a\u6628\u5929<\/strong>\u80a1\u4ef7\u8dcc\u5e45\u22656%<\/strong>\uff08\u5927\u9634\u7ebf\/\u66b4\u8dcc\uff09<\/li>\n<\/ul>\n
        \n
        4. XG\uff1a\u6700\u7ec8\u6761\u4ef6<\/h3>\n
        XG:A1 AND A2 AND A3;<\/code><\/pre>\n
        \n
        \u4e8c\u3001 \u9009\u80a1\u903b\u8f91\u89e3\u8bfb<\/h2>\n
        \u5b8c\u6574\u6761\u4ef6\u89e3\u91ca<\/h3>\n\n\n\n\n\n\n\n\n
        \u65f6\u95f4<\/th>\n\u6761\u4ef6<\/th>\n\u542b\u4e49<\/th>\n<\/tr>\n<\/thead>\n
        3\u5929\u524d<\/strong><\/td>\nA1<\/td>\n\u6da8\u505c\/\u5927\u9633\u7ebf<\/strong>\uff08\u6da8\u5e45\u22659.7%\uff09<\/td>\n<\/tr>\n
        2\u5929\u524d<\/strong><\/td>\nA2<\/td>\n\u8fde\u7eed\u6da8\u505c\/\u5927\u9633\u7ebf<\/strong>\uff08\u6da8\u5e45\u22659.7%\uff09<\/td>\n<\/tr>\n
        \u6628\u5929<\/strong><\/td>\nA3<\/td>\n\u66b4\u8dcc<\/strong>\uff08\u8dcc\u5e45\u22656%\uff09<\/td>\n<\/tr>\n
        \u4eca\u5929<\/strong><\/td>\n–<\/td>\n\u6ee1\u8db3\u9009\u80a1\u6761\u4ef6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \u5f62\u6001\u89e3\u8bfb<\/h3>\n
        3\u5929\u524d: \ud83d\udcc8 \u5927\u9633\u7ebf\uff08+9.7%\u4ee5\u4e0a\uff09\n2\u5929\u524d: \ud83d\udcc8 \u5927\u9633\u7ebf\uff08+9.7%\u4ee5\u4e0a\uff09\n\u6628\u5929:   \ud83d\udcc9 \u5927\u9634\u7ebf\uff08-6%\u4ee5\u4e0a\uff09\n\u4eca\u5929:   \u2705 \u6ee1\u8db3\u9009\u80a1\u6761\u4ef6<\/code><\/pre>\n
          \n
        • \u672c\u8d28<\/strong>\uff1a\u8fde\u7eed\u66b4\u6da8\u540e\u6025\u8dcc<\/strong>\uff0c\u5f62\u6210\u5c16\u9876\u5f62\u6001<\/strong><\/li>\n
        • \u539f\u7406<\/strong>\uff1a\u77ed\u671f\u5185\u80a1\u4ef7\u5927\u8d77\u5927\u843d\uff0c\u4e56\u79bb\u7387\u6781\u5927<\/strong>\uff0c\u7269\u6781\u5fc5\u53cd\uff0c\u53cd\u5f39\u6982\u7387\u9ad8<\/li>\n<\/ul>\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> -> \u201c\u65b0\u5efa\u201d<\/strong>\u3002<\/li>\n
          3. \u7c98\u8d34\u4ee3\u7801\uff0c\u540d\u79f0\u8f93\u5165\uff1a\u8d85\u8dcc\u77ed\u7ebf<\/code>\u3002<\/li>\n
          4. \u786e\u5b9a<\/strong>\u4fdd\u5b58\u3002<\/li>\n<\/ol>\n
            \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 \u8d85\u8dcc\u77ed\u7ebf<\/code> \u516c\u5f0f\u3002<\/li>\n
            3. \u9009\u80a1\u8303\u56f4<\/strong>\uff1a\u9009\u62e9\u201c\u6caa\u6df1A\u80a1\u201d\u3002<\/li>\n
            4. \u9009\u80a1\u5468\u671f<\/strong>\uff1a\u65e5\u7ebf<\/strong>\u3002<\/li>\n
            5. \u6267\u884c\u9009\u80a1<\/strong>\u3002<\/li>\n<\/ol>\n
              \n
              3. \u9884\u8b66\u8bbe\u7f6e<\/h3>\n
                \n
              1. \u529f\u80fd<\/strong> -> \u9884\u8b66\u7cfb\u7edf<\/strong> -> \u9884\u8b66\u516c\u5f0f\u8bbe\u7f6e<\/strong>\u3002<\/li>\n
              2. \u6dfb\u52a0 \u8d85\u8dcc\u77ed\u7ebf<\/code> \u516c\u5f0f\u3002<\/li>\n
              3. \u542f\u52a8\u9884\u8b66\uff0c\u76d8\u4e2d\u5b9e\u65f6\u76d1\u63a7\u3002<\/li>\n<\/ol>\n
                \n
                \u56db\u3001 \u5b9e\u6218\u4ea4\u6613\u7b56\u7565<\/h2>\n
                \u4fe1\u53f7\uff1aXG\uff08\u8d85\u8dcc\u77ed\u7ebf\uff09<\/h3>\n