{"id":1884,"date":"2026-08-18T20:14:14","date_gmt":"2026-08-18T12:14:14","guid":{"rendered":"https:\/\/tongchun.website\/index.php\/kimiagent-18-xlsx\/"},"modified":"2026-08-18T20:26:35","modified_gmt":"2026-08-18T12:26:35","slug":"kimiagent-18-xlsx","status":"publish","type":"page","link":"https:\/\/tongchun.website\/index.php\/kimiagent-18-xlsx\/","title":{"rendered":"18-xlsx\uff1a\u8868\u683c\u660e\u661f\u6280\u80fd\u7ec4\u6df1\u62c6\uff08xlsx \u5168\u5bb6\u6876 + chart-gen\/data-viz \u5bf9\u6bd4\uff09"},"content":{"rendered":"\n

\u2190 \u8fd4\u56de\u4e3b\u62a5\u544a\uff1aKimi Agent\uff08\u4e91\u7aef\u6c99\u7bb1\uff09\u6280\u672f\u62a5\u544a<\/a> \uff5c GitHub \u539f\u6587<\/a><\/p>\n\n\n\n

\u5408\u89c4\u4e0e\u98ce\u9669\u58f0\u660e<\/strong>\uff1a\u672c\u62a5\u544a\u4e3a\u5b89\u5168\u7814\u7a76\u4e0e\u4e92\u64cd\u4f5c\u5b66\u4e60\u76ee\u7684\u7684\u9006\u5411\u5206\u6790\uff0c\u5168\u7a0b\u53ea\u8bfb\u91c7\u96c6\uff0c\u672a\u5bf9\u76ee\u6807\u7cfb\u7edf\u505a\u4efb\u4f55\u4fee\u6539\uff1b\u6587\u4e2d\u6240\u6709\u5bc6\u94a5\u3001token\u3001\u8d26\u53f7\u7ea7\u6807\u8bc6\uff08chat_id \/ project_id \/ tenant_id \u7b49\uff09\u5747\u5df2\u8131\u654f\uff1b\u6c99\u7bb1\u5185\u53d1\u73b0\u7684\u9ed8\u8ba4\u5f31\u53e3\u4ee4\uff08VNC\/SSH\uff09\u5c5e\u5e73\u53f0\u4fa7\u914d\u7f6e\uff0c\u4ec5\u4f5c\u5b89\u5168\u53d1\u73b0\u62ab\u9732\uff0c\u8bf7\u52ff\u7528\u4e8e\u8bbf\u95ee\u4efb\u4f55\u4e0d\u5c5e\u4e8e\u81ea\u5df1\u7684\u7cfb\u7edf\u3002docx\/pdf\/xlsx\/kimi-slides \u7b49\u5f15\u64ce\u4e8c\u8fdb\u5236\u4e3a Moonshot \u4e13\u6709\u8bb8\u53ef\uff08\u7981\u518d\u5206\u53d1\/\u9006\u5411\uff09\uff0c\u672c\u6587\u4ec5\u4f5c\u884c\u4e3a\u7ea7\u63cf\u8ff0\u3002\u62a5\u544a\u57fa\u4e8e\u5355\u6b21\u5206\u6790\u7a97\u53e3\uff08\u7ea6 50 \u5206\u949f\u751f\u547d\u5468\u671f\uff09\uff0c\u8f6f\u4ef6\u7248\u672c\u4e0e\u6280\u80fd\u5e93\u5b58\u968f\u955c\u50cf\u66f4\u65b0\u53ef\u80fd\u53d8\u5316\u3002<\/p><\/blockquote>\n\n\n\n

\u91c7\u96c6\u65b9\u5f0f\uff1aHTTP \u53ea\u8bfb\u955c\u50cf\uff08http:\/\/127.0.0.1:18080\/app\/.agents\/skills\/<\/code>\uff09\u3002 \u539f\u59cb\u6587\u672c\u5df2\u955c\u50cf\u5230 sections\/18-xlsx-raw\/<\/code>\uff08SKILL.md 992 \u884c\u5168\u6587\u30013 \u4efd\u91d1\u878d\u5b50\u6280\u80fd\u3001comps \u4e09\u5c42 references\u3001pivot-table.md\uff0c\u5171\u7ea6 2900 \u884c\uff09\u3002 \u7b2c\u4e00\u8f6e\u62a5\u544a \u00a73.2\uff08sections\/09-skills-d.md:224\uff09\u53ea\u8986\u76d6\u5230 SKILL.md \u524d 130 \u884c\uff0c\u672c\u7ae0\u4e3a\u5168\u91cf\u8865\u9f50 + \u5de5\u7a0b\u6df1\u62c6\u3002<\/p><\/blockquote>\n\n\n\n

1. \u6280\u80fd\u7ec4\u6e05\u5355\u4e0e\u4f53\u91cf<\/h2>\n\n\n\n
\u8def\u5f84<\/th>\u4f53\u91cf<\/th>\u6027\u8d28<\/th><\/tr><\/thead>
xlsx\/SKILL.md<\/code><\/td>992 \u884c \/ 45KB<\/td>\u4e3b\u6280\u80fd\uff08\u7236\u6280\u80fd\uff09<\/td><\/tr>
xlsx\/scripts\/Xlsx<\/code><\/td>77,001,601 \u5b57\u8282 ELF x86-64<\/strong><\/td>\u95ed\u6e90 CLI\uff0c\u7edf\u4e00\u6821\u9a8c\/\u900f\u89c6\u8868\u5de5\u5177<\/td><\/tr>
xlsx\/reference\/3_statement_model_skill.md<\/code><\/td>959 \u884c<\/td>\u91d1\u878d\u5b50\u6280\u80fd\uff1a\u4e09\u8868\u6a21\u578b<\/td><\/tr>
xlsx\/reference\/DCF_SKILL.md<\/code><\/td>456 \u884c<\/td>\u91d1\u878d\u5b50\u6280\u80fd\uff1aDCF \u4f30\u503c\uff08\u5185\u5d4c\u7248\u5f0f\u53c2\u8003\uff09<\/td><\/tr>
xlsx\/reference\/comps-analysis\/Comps_analysis SKILL.md<\/code><\/td>102 \u884c<\/td>\u91d1\u878d\u5b50\u6280\u80fd\uff1a\u53ef\u6bd4\u516c\u53f8\uff08\u5165\u53e3\uff09<\/td><\/tr>
xlsx\/reference\/comps-analysis\/references\/{calculation_guide,model_construction,workbook_format}.md<\/code><\/td>108\/200\/210 \u884c<\/td>comps \u7684\u4e09\u5c42\u5d4c\u5957\u53c2\u8003<\/td><\/tr>
xlsx\/reference\/pivot-table.md<\/code><\/td>339 \u884c<\/td>PivotTable \u64cd\u4f5c\u624b\u518c\uff08\u914d\u5408 CLI\uff09<\/td><\/tr>
xlsx\/LICENSE.txt<\/code><\/td>719 \u5b57\u8282<\/td>Moonshot AI \u4e13\u6709\u8bb8\u53ef\uff0c\u660e\u786e\u7981\u6b62\u9006\u5411\/\u518d\u5206\u53d1<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u5bf9\u6bd4\u7ec4\uff08\u540c\u5728 \/app\/.agents\/skills\/<\/code>\uff09\uff1a<\/p>\n\n\n\n

\u6280\u80fd<\/th>\u5b9e\u73b0<\/th>\u8bb8\u53ef<\/th><\/tr><\/thead>
chart-gen<\/code> \/ chart-image<\/code><\/td>\u540c\u4e00\u5957 chart.mjs<\/code>\uff0854KB\uff0cVega-Lite + Sharp \u51fa PNG\uff09\uff0cCN\/EN \u514b\u9686\u5bf9<\/td>chart-gen \u6ce8\u660e <!-- Localized from: chart-image --><\/code>\uff0c\u662f\u5916\u90e8\u6280\u80fd\uff08clawd \u751f\u6001\uff0c\/data\/clawd\/skills\/<\/code> \u8def\u5f84\u6b8b\u7559\uff09\u7684\u672c\u5730\u5316<\/td><\/tr>
data-viz-gen<\/code> \/ data-viz-renderer<\/code><\/td>\u540c\u4e00\u4efd build_infographic.py<\/code>\uff08669 \u884c\u7eaf Python\uff0cJSON\u2192\u81ea\u5305\u542b HTML\/SVG\uff0c4 \u7c7b\u578b 8 \u914d\u8272\uff09\uff0cCN\/EN \u514b\u9686\u5bf9<\/td>MIT<\/td><\/tr>
code-to-chart<\/code><\/td>analyze_codebase.py<\/code>\uff1aAST \u89e3\u6790 import \u4f9d\u8d56\u2192Mermaid\/SVG<\/td>MIT<\/td><\/tr>
gantt-chart-builder<\/code><\/td>gantt_generator.py<\/code>\uff1aCPM \u5173\u952e\u8def\u5f84\u2192\u4ea4\u4e92\u5f0f HTML \u7518\u7279\u56fe<\/td>MIT<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

xlsx<\/code> \u81ea\u8eab\u4e0d\u5e26 LICENSE \u4e4b\u5916\u7684\u4f9d\u8d56\u58f0\u660e\uff1bchart-gen \u7684 package.json<\/code> \u4ec5 vega ^5.30 \/ vega-lite ^5.21 \/ sharp ^0.33<\/code>\u3002<\/p>\n\n\n\n

2. scripts\/Xlsx \u4e8c\u8fdb\u5236\u9274\u5b9a\uff08\u672c\u8f6e\u91cd\u70b9\u4e4b\u4e00\uff09<\/h2>\n\n\n\n
  • file<\/code> \u5c42\u9762\uff1aELF 64-bit\uff0c\u52a8\u6001\u94fe\u63a5 libgcc_s<\/code>\uff0cC++ \u8fd0\u884c\u5e93\u7b26\u53f7\u9f50\u5168\u3002<\/li>
  • strings \u53d6\u8bc1\uff08\u6d41\u5f0f\u53d6\u6837\uff0c\u672a\u843d\u76d8\uff09\uff1a\u51fa\u73b0 corehost_main_with_output_buffer<\/code>\u3001Error: Attempt to access unloaded AppDomain<\/code>\u3001ELEMENT_TYPE_SENTINEL<\/code>\u3001DotNETRuntimePrivate:ParseXml<\/code>\u3001BrotliEncoderHasMoreOutput<\/code>\u3001libssl \u7b26\u53f7\u89e3\u6790\u63d0\u793a\u7b49\u2014\u2014\u8fd9\u662f .NET (CoreCLR) \u81ea\u5305\u542b\u5355\u6587\u4ef6\u53d1\u5e03\u4ea7\u7269<\/strong>\uff08self-contained single-file app\uff09\uff0cnative host \u5185\u5d4c\u5b8c\u6574 CoreCLR \u8fd0\u884c\u65f6\uff0c\u6258\u7ba1 DLL \u4ee5 Brotli \u538b\u7f29\u8fdb bundle\uff08\u56e0\u6b64 strings \u91cc\u5927\u91cf”\u7f51\u9875\u8bed\u6599”\u5176\u5b9e\u662f Brotli \u9759\u6001\u5b57\u5178\uff0c\u4e0d\u662f\u4e1a\u52a1\u6587\u672c\uff09\u300277MB \u4f53\u91cf\u4e0e\u81ea\u5305\u542b .NET \u5e94\u7528\u543b\u5408\u3002<\/li>
  • \u7ed3\u5408 SKILL.md \u81ea\u8ff0\uff08”pure OpenXML SDK (C# tool)”\uff09\uff0c\u53ef\u786e\u8ba4\uff1aC# + DocumentFormat.OpenXml \u5b9e\u73b0\u7684 6 \u547d\u4ee4 CLI<\/strong>\uff0c\u65e0\u5916\u90e8\u8fdb\u7a0b\u4f9d\u8d56\uff08\u4e0d\u8c03 LibreOffice\/soffice\u2014\u2014strings \u4e2d\u672a\u89c1 soffice \u7ebf\u7d22\uff0c\u4e14\u6c99\u7bb1\u4fa7\u4e5f\u672a\u58f0\u660e\uff09\u3002<\/li>
  • \u503c\u5f97\u6ce8\u610f\uff1arecheck<\/code> \u80fd\u62a5”\u516c\u5f0f\u7ed3\u679c\u4e3a 0 \u7684\u5355\u5143\u683c<\/strong>“\u548c”#VALUE!\/#REF! \u7b49\u516c\u5f0f\u9519\u8bef”\uff0c\u8bf4\u660e\u4e8c\u8fdb\u5236\u5185\u90e8\u81ea\u5e26\u516c\u5f0f\u6c42\u503c\u5f15\u64ce<\/strong>\uff08openpyxl \u672c\u8eab\u4e0d\u6c42\u503c\uff09\uff1bSKILL.md \u63d0\u5230”\u8fd9\u4e9b\u516c\u5f0f\u80fd\u901a\u8fc7 LibreOffice \u91cd\u7b97\u4f46\u5728 MS Excel \u62a5 #N\/A”\uff0c\u6697\u793a\u5176\u6c42\u503c\u8bed\u4e49\u5bf9\u9f50 LibreOffice\u3002\u5177\u4f53\u6c42\u503c\u5e93\u65e0\u6cd5\u4ece\u538b\u7f29 bundle \u53d6\u8bc1\uff0c\u6807\u8bb0\u4e3a\u63a8\u65ad\u3002<\/li>
  • \u6cd5\u5f8b\u8fb9\u754c<\/strong>\uff1aLICENSE.txt \u660e\u786e”proprietary property of Moonshot AI \u2026 Reverse engineering, decompiling \u2026 is prohibited”\u3002\u76f4\u63a5\u628a\u4e8c\u8fdb\u5236\u642c\u8fdb Hermes\/Kimi Code \u5206\u53d1\u6709\u5408\u89c4\u98ce\u9669\uff0c\u79fb\u690d\u65f6\u5e94\u4ee5\u91cd\u5199\u66ff\u4ee3\uff08\u89c1 \u00a77\uff09\u3002<\/li><\/ul>\n\n\n\n

    3. \u4e3b\u6280\u80fd SKILL.md \u7ed3\u6784\u89e3\u5256\uff08992 \u884c\uff09<\/h2>\n\n\n\n

    \u8f93\u5165\u8f93\u51fa\u5951\u7ea6\uff08<\/code>\uff09\uff1a<\/p>\n\n\n\n

    “You must eventually deliver an Excel file \u2026 must include a .xlsx file”\uff1b”do not provide any files other than what the user requested, especially readme documentation<\/strong>, as this will take up too much context.”\uff08SKILL.md:29-30\uff09<\/p><\/blockquote>\n\n\n\n

    \u6280\u672f\u6808\u786c\u9501\u5b9a\uff08<\/code>\uff09\uff1aPython3 + openpyxl\/pandas \u8d70 ipython<\/code> \u5de5\u5177\u505a\u751f\u6210\uff1b.\/scripts\/Xlsx<\/code> \u8d70 shell<\/code> \u5de5\u5177\u505a\u6821\u9a8c\u3002\u751f\u6210\u4e0e\u6821\u9a8c\u804c\u8d23\u5206\u79bb<\/strong>\u2014\u2014LLM \u53ea\u7528 openpyxl \u5199\uff0c\u6b63\u786e\u6027\u7531\u786e\u5b9a\u6027\u4e8c\u8fdb\u5236\u88c1\u51b3\u3002<\/p>\n\n\n\n

    3.1 Xlsx CLI \u7684 6 \u547d\u4ee4\uff08\u5951\u7ea6\u7ea7\u7ec6\u8282\uff09<\/h3>\n\n\n\n
    1. recheck<\/code>\uff08\u6bcf\u6b21\u4fdd\u5b58\u540e\u5fc5\u8dd1\uff09\uff1a\u68c0\u6d4b 7 \u7c7b\u516c\u5f0f\u9519\u8bef\u503c\uff08#VALUE!\/#DIV\/0!\/#REF!\/#NAME?\/#NULL!\/#NUM!\/#N\/A\uff09\u3001\u96f6\u503c\u516c\u5f0f\u5355\u5143\u683c<\/strong>\uff08”often indicates reference errors”\uff09\u3001\u9690\u5f0f\u6570\u7ec4\u516c\u5f0f<\/strong>\u2014\u2014\u5982 MATCH(TRUE(), range>0, 0)<\/code> \u5728 LibreOffice \u81ea\u52a8\u6570\u7ec4\u5316\u3001\u5728 MS Excel \u9700 CSE \u5426\u5219 #N\/A\uff1bSKILL.md \u76f4\u63a5\u7ed9\u51fa\u6539\u5199\u5904\u65b9\uff1aSUMPRODUCT((A1:A10>0)*ROW(A1:A10))-ROW(A1)+1<\/code>\u3002<\/li>
    2. reference-check<\/code>\uff08\u522b\u540d refcheck<\/code>\uff09\uff1a\u9488\u5bf9 AI \u751f\u6210\u516c\u5f0f\u7684 4 \u7c7b\u5178\u578b\u75c5<\/strong>\u2014\u2014\u5f15\u7528\u8303\u56f4\u8fdc\u8d85\u5b9e\u9645\u6570\u636e\u884c\u3001\u628a\u8868\u5934\u884c\u5377\u8fdb\u8ba1\u7b97\u3001SUM\/AVERAGE \u53ea\u8986\u76d6 \u22642 \u683c\u3001\u540c\u5217\u4e2d\u504f\u79bb\u4e3b\u5bfc\u6a21\u5f0f\u7684”\u5b64\u7acb\u516c\u5f0f”\u3002\u8fd9\u662f\u7528\u9759\u6001\u89c4\u5219\u7f16\u7801”LLM \u5199\u516c\u5f0f\u7684\u5e38\u89c1\u5e7b\u89c9\u6a21\u5f0f”\uff0c\u9488\u5bf9\u6027\u6781\u5f3a\u3002<\/li>
    3. inspect<\/code>\uff1a\u8f93\u51fa JSON\uff08sheets\/tables\/headers\/dataRange\uff09\uff0c\u662f pivot<\/code> \u7684\u524d\u7f6e\u53c2\u6570\u53d1\u73b0\u6b65\u9aa4\uff08pivot-table.md \u7ed9\u51fa inspect \u5b57\u6bb5\u2192pivot \u53c2\u6570\u7684\u6620\u5c04\u8868\uff09\u3002<\/li>
    4. pivot<\/code>\uff1a\u7eaf OpenXML SDK \u751f\u6210 PivotTable + \u81ea\u52a8\u914d\u56fe\uff08bar\/line\/pie\uff09\uff0c--style monochrome|finance<\/code>\uff08\u5185\u5efa PivotStyleMedium9\/2\uff09\uff0c\u652f\u6301 rows\/cols\/filters\/values \u4e94\u79cd\u805a\u5408\uff08sum\/count\/avg\/max\/min\uff09\u3002<\/li>
    5. chart-verify<\/code>\uff1a\u9a8c\u8bc1\u56fe\u8868\u975e\u7a7a\uff0c\u9000\u51fa\u7801\u8bed\u4e49\u5316<\/strong>\uff080 \u53ef\u4ea4\u4ed8 \/ 1 \u5fc5\u987b\u4fee\uff09\u3002<\/li>
    6. validate<\/code>\uff1aOpenXML schema \u6821\u9a8c\uff08Office 2013 \u57fa\u7ebf\uff09\u3001\u7981\u7528\u51fd\u6570\u9ed1\u540d\u5355<\/strong>\uff08FILTER\/UNIQUE\/XLOOKUP\/LET\/LAMBDA\/SEQUENCE \u7b49 Excel 365 \u52a8\u6001\u6570\u7ec4\u51fd\u6570 + Google Sheets \u4e13\u6709\u51fd\u6570\uff0cSKILL.md \u7ed9\u51fa 12 \u884c\u5bf9\u7167\u66ff\u4ee3\u8868\uff09\u3001.rels<\/code> \u7edd\u5bf9\u8def\u5f84\u68c0\u6d4b\uff08”absolute paths cause Excel to crash”\uff09\u3001\u900f\u89c6\u8868\/\u56fe\u8868\u7ed3\u6784\u5b8c\u6574\u6027\u3002--lenient<\/code> \u53ef\u67e5\u770b\u88ab\u667a\u80fd\u767d\u540d\u5355\u5ffd\u7565\u7684 openpyxl \u826f\u6027 schema \u95ee\u9898\uff1bpivotCache\/pivotTable\/rowItems \u7c7b\u9519\u8bef\u6c38\u4e0d\u8c41\u514d<\/strong>\u3002<\/li><\/ol>\n\n\n\n

      3.2 \u516c\u5f0f\u4fdd\u771f\u539f\u5219\uff08\u4e3a\u4ec0\u4e48\u4e25\u7981 Python \u7b97\u5b8c\u8d34\u786c\u7f16\u7801\uff09<\/h3>\n\n\n\n

      \u539f\u6587\uff08SKILL.md:106, 111-112\uff09\uff1a<\/p>\n\n\n\n

      “It is strictly forbidden to calculate derived model outputs in Python or any external tool and then paste finished hardcoded numbers into Excel; if a value can be linked by workbook formulas, it MUST remain formula-driven in the delivered file.” “static hardcoded values are allowed only for true inputs, assumptions, or historical\/raw reported data.” “Build the logic in Excel formulas so the workbook remains linked, traceable, and updateable<\/strong>.”<\/p><\/blockquote>\n\n\n\n

      \u7406\u7531\u94fe\uff1a\u4ea4\u4ed8\u7269\u662f\u6d3b\u6a21\u578b<\/strong>\u4e0d\u662f\u6b7b\u62a5\u8868\u2014\u2014\u6295\u884c\u7528\u6237\u8981\u6539\u5047\u8bbe\u770b\u8054\u52a8\uff1bPython \u9884\u8ba1\u7b97\u7b49\u4e8e\u628a\u903b\u8f91\u70e7\u6210\u7070\u3002\u4f8b\u5916\u767d\u540d\u5355\u660e\u786e\uff1a\u5916\u90e8\u53d6\u6570\u3001\u771f\u5e38\u91cf\u3001\u4f1a\u6210\u5faa\u73af\u5f15\u7528\u7684\u573a\u666f\u624d\u5141\u8bb8\u9759\u6001\u503c\uff08SKILL.md:352-355\uff09\u3002\u654f\u611f\u6027\u5206\u6790\u8868\u4e5f\u70b9\u540d”\u5fc5\u987b\u516c\u5f0f\u9a71\u52a8”\uff08DCF_SKILL.md:53\uff09\u3002<\/p>\n\n\n\n

      3.3 \u6821\u9a8c\u95ed\u73af\u4e0e\u53cd”\u7406\u6027\u5316”\u8bbe\u8ba1<\/h3>\n\n\n\n

      \u5de5\u4f5c\u6d41\u662f\u9010 sheet \u95e8\u63a7<\/strong>\uff08SKILL.md:299-310\uff09\uff1aPLAN\u2192CREATE\u2192SAVE\u2192recheck+reference-check\u21920 \u9519\u624d\u8bb8\u5efa\u4e0b\u4e00\u4e2a sheet\u2192\u5168\u90e8\u5b8c\u6210\u540e validate\u2192\u4ea4\u4ed8\u3002\u660e\u786e\u7981\u6b62”\u5168\u90e8\u5efa\u5b8c\u6700\u540e\u7edf\u4e00\u6821\u9a8c”\uff08\u9519\u8bef\u4f1a\u7ea7\u8054\uff09\u3002<\/p>\n\n\n\n

      \u6700\u6709\u5de5\u7a0b\u4ef7\u503c\u7684\u662f\u9884\u5224 LLM \u7684\u63a8\u8bff\u8bdd\u672f\u5e76\u9010\u6761\u5c01\u5835<\/strong>\uff08SKILL.md:371-384\uff09\uff1a<\/p>\n\n\n\n

      \u274c “These errors will disappear when the user opens the file in Excel” \u2014 WRONG \u274c “The #REF! error is because openpyxl doesn’t evaluate formulas” \u2014 WRONG \u274c “Zero values are expected” \u2014 VERIFY each one “Files with ANY recheck<\/code> errors CANNOT be delivered.”<\/p><\/blockquote>\n\n\n\n

      validate \u5931\u8d25\u65f6\u7684\u5904\u7f6e\u540c\u6837\u662f\u53cd\u4fee\u8865\u7eaa\u5f8b\uff1a”Do NOT attempt to ‘fix’ the file. Regenerate it from scratch<\/strong> with corrected code.”\uff08SKILL.md:267\uff09<\/p>\n\n\n\n

      \u5df2\u77e5\u6df1\u5751\u88ab\u663e\u5f0f\u7f16\u7801\uff1aopenpyxl \u91cd\u4fdd\u5b58\u4f1a\u7834\u574f pivotCache \u8def\u5f84<\/strong>\u5bfc\u81f4 Excel \u5d29\u6e83\uff0c\u56e0\u6b64 pivot \u5fc5\u987b\u662f\u6d41\u6c34\u7ebf\u6700\u540e\u4e00\u6b65\u3001\u8f93\u51fa\u6587\u4ef6\u4e0d\u5f97\u518d\u88ab openpyxl \u6253\u5f00\uff08pivot-table.md:314-339 \u7ed9\u51fa\u6b63\u786e\/\u9519\u8bef\u65f6\u5e8f\u56fe\uff09\u3002<\/p>\n\n\n\n

      3.4 \u6837\u5f0f\u4e0e\u884c\u4e1a\u60ef\u4f8b\u7f16\u7801<\/h3>\n\n\n\n
      • \u5b57\u4f53\u989c\u8272\u4e09\u8272\u89c4\u5219<\/strong>\uff08SKILL.md:728-734\uff0c\u91d1\u878d\u6a21\u578b\u4e3a”hard minimum standards”\uff09\uff1a\u84dd=\u56fa\u5b9a\u503c\/\u8f93\u5165\uff1b\u9ed1=\u8ba1\u7b97\u516c\u5f0f\uff1b\u7eff=\u7eaf\u8de8\u8868\u5f15\u7528\uff1b\u7ea2=\u5916\u90e8\u94fe\u63a5<\/strong>\u3002\u7ec6\u5316\u89c4\u5219\uff1a\u516c\u5f0f\u6df7\u5408\u5f15\u7528\u4e0e\u8fd0\u7b97\uff08\u5982 =-('Balance Sheet'!H12-'Balance Sheet'!G12)<\/code>\uff09\u7b97\u9ed1\u4e0d\u7b97\u7eff\uff083_statement_model_skill.md:121-122 \u4e13\u95e8\u4e3e\u4f8b\uff09\u3002<\/li>
      • \u533a\u57df\u6da8\u8dcc\u8272\u7ea6\u5b9a<\/strong>\uff1a\u4e2d\u56fd\u7ea2\u6da8\u7eff\u8dcc\u3001\u56fd\u9645\u7eff\u6da8\u7ea2\u8dcc\uff08SKILL.md:655-661 \u8868\u683c\uff09\u3002<\/li>
      • \u53cc\u98ce\u683c\u4f53\u7cfb\uff1a\u9ed8\u8ba4\u6781\u7b80\u9ed1\u767d\u7070+\u84dd\u70b9\u7f00\uff08\u975e\u91d1\u878d\uff09\uff0c\u91d1\u878d\u7528 Professional Finance\uff08\u6df1\u85cf\u9752 #122B49<\/code> \u8868\u5934\uff09\uff1b\u7f51\u683c\u7ebf\u5fc5\u987b\u9690\u85cf\uff1b\u4ece B2 \u8d77\u6392\uff1b\u9ed8\u8ba4\u7981 wrap text\uff1b\u6bcf\u4e2a\u4ea4\u4ed8\u7269\u5fc5\u987b\u6709\u5c01\u9762\u9875<\/strong>\uff08\u6807\u9898\/\u5173\u952e\u6307\u6807\/sheet \u7d22\u5f15\/\u900f\u89c6\u8868\u5237\u65b0\u63d0\u793a\uff09\u3002<\/li>
      • \u6570\u5b57\u7eaa\u5f8b\uff1a\u91d1\u989d\u5b58\u6700\u5c0f\u5355\u4f4d\uff0815000000 \u800c\u975e 1.5M\uff09\u9760 Excel \u683c\u5f0f\u663e\u793a\uff1b\u7981\u7528\u7f29\u653e\u5355\u4f4d\u8fdb\u516c\u5f0f\uff1b\u767e\u5206\u6bd4 0.0%<\/code>\uff1bstatement \u503c\u6574\u6570\u3001\u96f6\u4ee5\u683c\u5f0f\u663e\u793a -<\/code>\uff08#,##0;(#,##0);-<\/code>\uff09\u800c\u975e\u624b\u6253\u5b57\u7b26\u3002<\/li>
      • \u56fe\u8868\u5f3a\u5236\u4ee4\uff1a\u7528\u6237\u63d0\u5230 visual\/chart \u5c31\u5fc5\u987b\u7528 openpyxl \u5d4c\u771f\u56fe\u8868\uff0c\u7981\u6b62<\/strong>\u5efa”CHARTS DATA”\u8868\u8ba9\u7528\u6237\u81ea\u5df1\u53bb Insert\uff08SKILL.md:810-817\uff09\uff0cchart-verify \u5361\u51fa\u53e3\u3002<\/li><\/ul>\n\n\n\n

        4. \u91d1\u878d\u5b50\u6280\u80fd\u4f53\u7cfb\uff08\u4e09\u8868\/DCF\/comps\uff09<\/h2>\n\n\n\n

        \u7236\u6280\u80fd\u5b9a\u4e49\u4e86\u52a0\u8f7d\u534f\u8bae<\/strong>\uff08SKILL.md:81-118\uff09\uff1a\u5b50\u6280\u80fd\u662f\u65b9\u6cd5\u8bba\/\u7248\u5f0f\/\u6821\u9a8c\u7684\u6700\u9ad8\u6743\u5a01\uff1b\u7ec4\u5408\u89c4\u5219\u2014\u2014comps \u72ec\u7acb\u3001DCF \u9ed8\u8ba4\u5148\u5efa\u4e09\u8868\u3001LBO \u4ece\u4e09\u8868\u8d77\u6b65\uff1b\u88ab\u8def\u7531\u5230\u5b50\u6280\u80fd\u5219\u5fc5\u987b\u5168\u6587\u8bfb\u5b8c<\/strong>\u624d\u80fd\u52a8\u624b\uff1bRaw Data \u53ea\u8bb8\u5386\u53f2\u3001\u5386\u53f2\u987b\u5148\u4e0e\u62ab\u9732\u603b\u989d reconcile\uff1b”\u6a21\u578b\u4e0d\u8fc7\u5168\u90e8 check \u5c31\u4e0d\u662f\u4ea4\u4ed8\u7269”\u3002<\/p>\n\n\n\n

        4.1 \u4e09\u8868\u6a21\u578b\uff08959 \u884c\uff0c\u5b50\u6280\u80fd\u4e2d\u6700\u539a\uff09<\/h3>\n\n\n\n
        • \u56fa\u5b9a\u516d\u8868\u7ed3\u6784<\/strong>\uff1aRaw Data \u2192 Operating Drivers \u2192 Income Statement \u2192 Supporting Schedules \u2192 Balance Sheet \u2192 Cash Flow\u3002\u9ed8\u8ba4 5 \u5e74\u5386\u53f2 + 3 \u5e74\u9884\u6d4b\uff1bRaw Data \u6c38\u4e0d\u51fa\u73b0\u9884\u6d4b\u5e74\u4efd\uff0816.3 \u8282\u7528”under any circumstance”\u5f3a\u8c03\uff09\u3002<\/li>
        • Operating Drivers \u662f\u7075\u9b42<\/strong>\uff1a\u7981\u6b62”\u5355\u884c\u589e\u957f\u7387\u9884\u6d4b”\uff0c\u6309\u884c\u4e1a\u7ed9\u9a71\u52a8\u6808\u6a21\u677f\uff08\u8f66\u4f01=\u5206\u8f66\u578b\u4ea4\u4ed8\u00d7ASP\uff1bSaaS=\u5ba2\u6237\u00d7ARPU\u00d7\u7559\u5b58\uff1b\u96f6\u552e=\u540c\u5e97\u00d7\u65b0\u5e97\u2026\u2026\uff09\uff0c\u6bcf\u4e2a\u9884\u6d4b\u5757\u5fc5\u987b\u914d Growth Catalyst\uff08\u4f55\u4e8b\/\u4e3a\u4f55\/\u8bc1\u636e\/\u6301\u7eed\u671f\/\u5468\u671f\u6027\uff09\uff0c\u53cd\u4f8b\u76f4\u63a5\u5199\u51fa”2026 growth = 15%<\/code>“\u8fd9\u79cd\u662f\u65e0\u6548\u7684\u3002<\/li>
        • \u5047\u8bbe\u6cbb\u7406<\/strong>\uff1a\u6bcf\u4e2a\u786c\u7f16\u7801\u5fc5\u987b\u6709\u5047\u8bbe\u8868\uff08Line Item\/\u5404\u5e74\u4efd\/Source\/Rationale \u516b\u5217\uff09\uff0cSource \u53ef\u63a5\u53d7\u6807\u7b7e\u679a\u4e3e\u5230 “sell-side channel check” \u7ea7\u522b\u3002<\/li>
        • \u5b8c\u6574\u52fe\u7a3d\u516c\u5f0f\u5e93<\/strong>\uff1aPP&E \u4e09\u6bb5\u6eda\u52a8\u3001\u503a\u52a1\u5229\u606f\uff08\u5e73\u5747\u503a\u52a1\u00d7\u5229\u7387\u9632\u5faa\u73af\uff09\u3001NOL\/\u9012\u5ef6\u7a0e\u5168\u5957\u516c\u5f0f\uff08NOL Utilized = MIN(Beginning NOL, Utilization Limit)<\/code> \u7b49 7 \u884c\uff09\u3001\u8425\u8fd0\u8d44\u672c roll-forward\uff08AR\/\u5b58\u8d27\/AP \u7684 ending=prior+\u6d41\u5165-\u6d41\u51fa\uff09\u3001\u6743\u76ca\u6cd5\u6295\u8d44\u9ec4\u91d1\u89c4\u5219 Investing_Cash_LT = -(\u0394LT_Investments - Equity_Income_Affiliates)<\/code>\uff08\u542b\u4e3a\u4ec0\u4e48\uff1a\u6743\u76ca\u6536\u76ca\u5df2\u5728\u51c0\u5229\u4e14\u975e\u73b0\u91d1\uff0c\u4e0d\u51cf\u4f1a\u9519 CFI \u5e76\u6253\u7834\u5e73\u8861\uff09\u3002<\/li>
        • \u5faa\u73af\u5f15\u7528\u5904\u7406<\/strong>\uff1a\u4e0d\u56de\u907f\u2014\u2014\u660e\u786e\u5141\u8bb8\u8fed\u4ee3\u8ba1\u7b97\uff08max iterations 100 \/ max change 0.001\uff09\uff0c\u5efa\u8bae circuit breaker\uff0c\u4e14”\u4e0d\u5f97\u4e3a\u6d88\u9664\u5faa\u73af\u800c\u6253\u65ad\u6838\u5fc3\u503a\u52a1\/\u73b0\u91d1\/\u5229\u606f\u94fe\u63a5”\u3002<\/li>
        • \u6821\u9a8c\u673a\u5236\u662f\u63d0\u793a\u8bcd\u7ea7\u800c\u975e\u811a\u672c\u7ea7<\/strong>\uff1a11.1 \u8282 14 \u6761\u4ea4\u4ed8\u524d\u6d4b\u8bd5 + 10 \u884c\u52fe\u7a3d\u68c0\u67e5\u8868\uff08Balance\/Cash Tie-Out\/NI Link\/RE Roll-Forward\/Debt\/WC\/Capex-PPE\/D&A\/Equity\/DTA\uff0c\u6bcf\u6761\u7ed9\u516c\u5f0f\u548c\u671f\u671b=0\uff09\uff1b\u5bb9\u5dee\u516c\u5f0f =IF(ABS(TA-TL&E)<0.1,\"Check\",\"Error\")<\/code>\uff1bBalance Check \u884c\u5fc5\u987b\u7ea2\u8272\u52a0\u7c97<\/strong>\u3001\u6bcf\u5e74\u663e\u793a Check\/Error\u3002<\/li>
        • \u8c03\u8bd5\u542f\u53d1\u5f0f<\/strong>\uff0811.3-11.4\uff09\uff1a\u4e0d\u5e73\u8861\u65f6\u6309 11 \u6b65\u987a\u5e8f\u67e5\uff08\u5148\u67e5 CF \u7b26\u53f7\uff09\uff0c\u5e76\u7ed9”\u5dee\u989d\u5b9a\u4f4d\u6cd5”\u2014\u2014\u5dee\u989d=\u67d0\u884c\u6216\u5176\u500d\u6570\u5c31\u5148\u67e5\u8be5\u884c\uff1b\u5dee\u989d=Cash \u5148\u67e5 BS Cash\u2190CF Ending Cash \u6620\u5c04\uff1b\u5dee\u989d=Capex \u67e5 PP&E \u6eda\u52a8\u2026\u2026\u8fd9\u662f\u628a\u6295\u884c\u5206\u6790\u5e08 debug \u7ecf\u9a8c\u7f16\u7801\u6210\u51b3\u7b56\u6811\u3002<\/li>
        • \u5e74\u5ea6\u6807\u7b7e\u6620\u5c04\u9677\u9631<\/strong>\uff0816.1\uff09\uff1aBS \u73b0\u91d1\u94fe\u63a5 CF \u671f\u672b\u73b0\u91d1\u5fc5\u987b\u6309\u5e74\u4efd\u6807\u7b7e\u800c\u975e\u5217\u5b57\u6bcd<\/strong>\u6620\u5c04\uff0c\u9010\u5e74\u9a8c\u8bc1\u3002\u8fd9\u7c7b”\u770b\u7740\u663e\u7136\u3001AI \u5e38\u9519”\u7684\u70b9\u88ab\u5355\u5217\u6210\u5f3a\u5236\u6761\u6b3e\u3002<\/li><\/ul>\n\n\n\n

          4.2 DCF\uff08456 \u884c\uff0c\u5185\u5d4c\u7248\u5f0f\u53c2\u8003\uff09<\/h3>\n\n\n\n
          • \u65b9\u6cd5\u8bba\u5b8c\u6574\u94fe\uff1a\u4f30\u503c\u6846\u67b6\u786e\u8ba4\uff08\u4f30\u503c\u65e5\/\u5e01\u79cd\/\u6298\u73b0\u60ef\u4f8b\uff09\u2192 \u4ece\u8fd0\u8425\u6a21\u578b\u94fe\u63a5\u9884\u6d4b\uff08\u7981\u6b62\u5728 DCF \u9875\u91cd\u5efa\u7b2c\u4e8c\u4efd\u9884\u6d4b\uff09\u2192 NOPAT\u2192UFCF\uff08\u9ed8\u8ba4 NOPAT = EBIT\u00d7(1-t)<\/code>\uff1bUFCF \u5fc5\u987b\u65e0\u6760\u6746\u3001\u4e0d\u542b\u5229\u606f\/\u5206\u7ea2\uff1b\u4e0d\u673a\u68b0\u52a0\u56de SBC\uff09\u2192 WACC \u9010\u6b65\u642d\u5efa\uff08CAPM \u9ed8\u8ba4\uff1bbeta \u5378\u8f7d\/\u518d\u52a0\u8f7d\u516c\u5f0f\u9f50\u5168\uff1b\u5e02\u503c\u6743\u91cd\uff1b\u7a0e\u540e\u503a\u52a1\u6210\u672c\uff09\u2192 \u7ec8\u503c\uff08\u6c38\u7eed\u589e\u957f\u4e3b\u65b9\u6cd5\uff0cg<WACC \u786c\u7ea6\u675f<\/strong>\uff1b\u9000\u51fa\u500d\u6570\u505a\u4ea4\u53c9\u9a8c\u8bc1\u4e14”\u500d\u6570\u4e0e\u7ec8\u503c\u57fa\u6570\u8981\u5339\u914d”\uff09\u2192 \u5e74\u4e2d\u6298\u73b0\u60ef\u4f8b\u9ed8\u8ba4 \u2192 EV\u2192Equity\u2192\u9690\u542b\u80a1\u4ef7\u6865\uff08\u51c0\u73b0\u91d1\u60c5\u5f62\u81ea\u7136\u6d41\u8fc7\uff1b\u8d1f\u80a1\u6743\u4ef7\u503c\u4e0d\u5f97\u673a\u68b0\u653e\u884c\uff0c\u987b\u590d\u67e5\u786e\u8ba4\u5408\u7406\uff09\u3002<\/li>
          • Format Reference \u7cbe\u786e\u5230\u5355\u5143\u683c<\/strong>\uff1a\u6807\u9898\u5408\u5e76 B1:H1\u3001WACC \u5757 K12:P12\u3001\u654f\u611f\u6027\u53cc\u8868 B63:G69\/J63:O69\u3001\u4ec5 C3 \u7528\u9ec4\u5e95\u865a\u7ebf\u6846\u3001\u5b57\u4f53 Arial 8-10\u3001\u8272\u677f #0F243E\/#D9E2F3\/#FFF2CC\/#0000FF<\/code>\uff08\u7eaf\u84dd\u786c\u7f16\u7801\uff09\uff0c\u5e76\u89c4\u5b9a”\u4e0d\u5f97\u628a comps \u7684\u7eff\u5e95\u5e26\u5165 DCF”\u3002<\/li>
          • \u9a8c\u8bc1\u6e05\u5355 11 \u6761\uff0c\u542b”\u654f\u611f\u6027\u65b9\u5411\u6027\u68c0\u67e5”\uff08WACC\u2191\u5219\u503c\u2193\uff09\u3002<\/li><\/ul>\n\n\n\n

            4.3 comps-analysis\uff08102 \u884c\u5165\u53e3 + 518 \u884c\u4e09\u5c42 references\uff09<\/h3>\n\n\n\n
            • database-first \u67b6\u6784<\/strong>\uff1a\u5148\u5efa\u5bbd\u53e3\u5f84 DATABASE \u5757\uff08\u6df1\u85cf\u9752\u5206\u9694\u6761\uff09\uff0c\u9876\u5c42\u7cbe\u9009 6-10 \u5bb6 peers \u7684\u8868\u7528 XLOOKUP\/INDEX-MATCH\/VLOOKUP \u4ece\u5e93\u4e2d\u5f15\u7528\u800c\u975e\u91cd\u6253<\/strong>\uff1b\u5206\u6790\u5757\uff08\u589e\u957f\/\u5229\u6da6\u7387\/\u500d\u6570\uff09\u4ece\u5f15\u7528\u503c\u73b0\u7b97\uff1b\u4f30\u503c\u6865\u5f15\u7528\u7cbe\u9009\u7ec4\u7684 Mean\/Median + \u84dd\u8272\u76ee\u6807\u8f93\u5165\u3002<\/li>
            • Year Lock \u534f\u8bae<\/strong>\uff1a\u5f00\u5de5\u524d\u9501\u6b7b\u6574\u7c3f Year Set\uff08\u5982 2025A\/2026E\/2027E<\/code>\uff09\uff0c\u7528\u6237\u6307\u5b9a\u5e74\u4efd\uff08”FY26″\/”26E”\uff09\u8986\u76d6\u4e00\u5207\u9ed8\u8ba4\u503c<\/strong>\uff0c”\u7981\u6b62\u9759\u9ed8\u56de\u9000\u5230\u719f\u6089\u7684 2023\/2024″\uff1b\u5217\u6807 2026 \u800c\u516c\u5f0f\u5582 2023 \u6570\u636e\u88ab\u5217\u4e3a\u660e\u786e\u8fdd\u89c4\u3002<\/li>
            • NM\/– \u8bed\u4e49<\/strong>\uff1a\u8d1f EBITDA \u7684 EV\/EBITDA\u3001\u8d1f EPS \u7684 P\/E \u663e\u793a NM \u4e14\u4e0d\u8fdb Mean\/Median<\/strong>\uff08\u4e0d\u5f97 coercion \u4e3a 0\uff09\uff1b\u672a\u7528\u6865\u5217\u663e\u793a --<\/code>\uff1b\u4ea4\u4ed8\u9762\u4e0a\u4e0d\u7559 Excel \u9519\u8bef\u503c\u3002<\/li>
            • \u884c\u4e1a\u5316\u6307\u6807\u96c6<\/strong>\uff1a\u660e\u793a\u4e0d\u641e universal metric set\u2014\u2014Big Tech \u770b\u89c4\u6a21\/\u589e\u957f\/\u73b0\u91d1\u6d41\uff0cSaaS \u770b EV\/Revenue \u800c\u975e P\/E\uff0c\u94f6\u884c\/\u4fdd\u9669\/REIT\/\u80fd\u6e90\/\u534a\u5bfc\u4f53\u5404\u81ea\u4e0d\u540c\u3002<\/li>
            • \u7248\u5f0f\u7cbe\u786e\u5230 RGB\uff1a\u786c\u7f16\u7801\u84dd rgb(79,113,190)<\/code>\u3001Mean\/Median \u7eff\u5e95 rgb(228,238,220)<\/code> \u5168\u5bbd+\u7ec6\u5916\u6846\uff08\u4e14\u4f30\u503c\u6865\u7684 Mean\/Median \u4e0d\u7ee7\u627f<\/strong>\u7eff\u5e95\u2014\u2014”\u6865\u662f\u4f30\u503c\u60c5\u5f62\u4e0d\u662f comps \u6c47\u603b\u884c”\uff09\u3001\u500d\u6570\u81ea\u5b9a\u4e49\u683c\u5f0f 0.0\"x\"<\/code> \u663e\u793a 6.2x \u4f46\u4fdd\u6301\u6570\u503c\u578b\u3001\u4e09\u5c42\u8868\u5934+\u7ec4\u4e0b\u5212\u7ebf”\u62ec\u53f7\u6548\u679c”\u3001\u6761\u4ef6\u683c\u5f0f\u4e09\u8272\u6807\u5ea6\uff08\u589e\u957f\/\u5229\u6da6\u7387\u8d8a\u9ad8\u8d8a\u7eff\uff0c\u500d\u6570\u53cd\u5411<\/strong>\u8d8a\u4f4e\u8d8a\u7eff\uff09\u3002<\/li>
            • Peer \u9009\u62e9\u542f\u53d1\u5f0f 6 \u6761\uff08\u5546\u4e1a\u6a21\u5f0f\u76f8\u4f3c\u5ea6\u4f18\u5148\u4e8e\u54c1\u724c\u77e5\u540d\u5ea6\uff09\uff0c\u6392\u9664\u660e\u663e\u540d\u5b57\u8981\u5199\u660e\u7406\u7531\u3002<\/li><\/ul>\n\n\n\n

              5. \u4e0e chart-gen\/data-viz \u7cfb\u7684\u5bf9\u6bd4\u7ed3\u8bba<\/h2>\n\n\n\n

              \u4e24\u6761\u5b8c\u5168\u4e0d\u540c\u7684\u56fe\u8868\u8def\u7ebf\uff1a<\/p>\n\n\n\n

              • xlsx \u8def\u7ebf<\/strong>\uff1a\u56fe\u8868\u5fc5\u987b\u662f Excel \u539f\u751f\u56fe\u8868\u5bf9\u8c61<\/strong>\uff08openpyxl.chart \u6216 pivot \u547d\u4ee4\u81ea\u52a8\u751f\u6210\uff09\uff0c\u968f .xlsx \u4ea4\u4ed8\u3001\u7528\u6237\u53ef\u5728 Excel \u91cc\u7ee7\u7eed\u7f16\u8f91\uff1bchart-verify \u628a\u5173\u3002\u9762\u5411”\u53ef\u7ee7\u7eed\u52a0\u5de5\u7684\u529e\u516c\u4ea4\u4ed8\u7269”\u3002<\/li>
              • chart-gen\/chart-image<\/strong>\uff1aVega-Lite\u2192Sharp \u5149\u6805\u5316 PNG\uff0c\u5f3a\u8c03\u65e0\u6d4f\u89c8\u5668\u3001~15MB \u4f9d\u8d56\u3001<500ms \u51b7\u542f\u52a8\u2014\u2014\u9762\u5411”\u62a5\u544a\/\u544a\u8b66\u91cc\u8d34\u56fe”\u3002\u672c\u8eab\u662f\u5916\u90e8 clawd \u6280\u80fd\u672c\u5730\u5316\uff08\u8def\u5f84\u6b8b\u7559 \/data\/clawd\/skills\/<\/code>\uff0c\u4e0e speech-synthesis \u4e00\u6837\u662f\u5bfc\u5165\u6742\u8d28\u8bc1\u636e\uff09\u3002<\/li>
              • data-viz-gen\/renderer<\/strong>\uff1a669 \u884c\u7eaf Python \u96f6\u4f9d\u8d56\u811a\u672c\uff0cJSON\u2192\u81ea\u5305\u542b HTML\/SVG\uff08\u7edf\u8ba1\u5361\/\u5bf9\u6bd4\u67f1\u72b6\/\u6d41\u7a0b\u56fe\/\u4eea\u8868\u76d8\uff09\uff0cCN\/EN \u540c\u4e00\u4efd\u811a\u672c\u4e24\u4e2a\u58f3\u2014\u2014\u5197\u4f59\u514b\u9686\u5bf9<\/strong>\uff0c\u79fb\u690d\u65f6\u53ea\u9700\u4e00\u4efd\u3002<\/li>
              • code-to-chart\u3001gantt-chart-builder \u4e0e\u8868\u683c\u65e0\u5173\uff0c\u662f”JSON\/\u4ee3\u7801\u2192HTML\/Mermaid”\u5bb6\u65cf\u6210\u5458\uff0c\u5747\u4e3a MIT + \u5355 Python \u811a\u672c\u3002<\/li><\/ul>\n\n\n\n

                6. \u5de5\u7a0b\u8d28\u91cf\u4eae\u70b9\u4e0e\u5751\uff08\u6c47\u603b\uff09<\/h2>\n\n\n\n

                \u4eae\u70b9\uff1a<\/p>\n\n\n\n

                1. \u751f\u6210\/\u6821\u9a8c\u4e8c\u5206<\/strong>\uff1aLLM \u53ea\u5199 openpyxl\uff0c\u786e\u5b9a\u6027\u4e8c\u8fdb\u5236\u505a\u7ec8\u5ba1\uff08\u9000\u51fa\u7801=\u4ea4\u4ed8\u95e8\uff09\uff0c\u4e0e pdf \u6280\u80fd\u7684 .pptd DSL+CLI \u540c\u5c5e”\u786e\u5b9a\u6027\u5f15\u64ce\u515c\u5e95”\u8303\u5f0f\u3002<\/li>
                2. \u53cd\u5e7b\u89c9\/\u53cd\u63a8\u8bff\u63d0\u793a\u5de5\u7a0b<\/strong>\uff1areference-check \u7684 4 \u7c7b AI \u5178\u578b\u516c\u5f0f\u75c5\u3001”errors will auto-resolve” \u8bdd\u672f\u5c01\u5835\u3001”validate \u5931\u8d25\u987b\u91cd\u65b0\u751f\u6210\u800c\u975e\u4fee\u8865”\uff0c\u90fd\u662f\u53ef\u88ab\u76f4\u63a5\u6284\u8d70\u7684 prompt \u6a21\u5f0f\u3002<\/li>
                3. \u9886\u57df know-how \u5bc6\u5ea6\u6781\u9ad8<\/strong>\uff1a\u4e09\u8272\u5b57\u4f53\u3001\u533a\u57df\u6da8\u8dcc\u8272\u3001\u52fe\u7a3d\u68c0\u67e5\u8868\u3001\u5dee\u989d\u5b9a\u4f4d\u8c03\u8bd5\u6cd5\u3001Year Lock\u3001database-first\u2014\u2014\u76f8\u5f53\u4e8e\u628a\u6295\u884c\u5efa\u6a21\u57f9\u8bad\u624b\u518c\u538b\u8fdb markdown\u3002<\/li>
                4. \u5d4c\u5957\u5b50\u6280\u80fd + \u4f18\u5148\u7ea7\/\u7ec4\u5408\u89c4\u5219<\/strong>\uff1a\u7236\u6280\u80fd\u53ea\u7ba1\u8c03\u5ea6\u4e0e\u515c\u5e95\uff0c\u5b50\u6280\u80fd\u662f\u6743\u5a01\uff1bcomps \u81ea\u5df1\u8fd8\u6709\u4e09\u5c42 references\u2014\u2014skill \u5185”\u6309\u9700\u52a0\u8f7d”\u5206\u5c42\u662f\u672c\u5e93\u6700\u6210\u719f\u7684\u6837\u672c\u3002<\/li>
                5. \u6821\u9a8c\u65e0\u5916\u90e8 API\/\u51ed\u8bc1\u4f9d\u8d56<\/strong>\uff1aXlsx CLI \u79bb\u7ebf\u8fd0\u884c\uff0c\u53d6\u6570\u8d70 datasource\/web_search \u63d2\u4ef6\u4f46\u6280\u80fd\u53ea\u89c4\u5b9a”\u5f15\u7528\u6765\u6e90\u4e24\u5217”\u7684\u5448\u73b0\u5951\u7ea6\uff0c\u804c\u8d23\u5206\u79bb\u5e72\u51c0\u3002<\/li><\/ol>\n\n\n\n

                  \u5751\uff1a<\/p>\n\n\n\n

                  1. Xlsx \u4e8c\u8fdb\u5236\u95ed\u6e90\u4e14\u7981\u6b62\u9006\u5411<\/strong>\uff08LICENSE.txt\uff09\uff0c77MB\uff0c\u662f\u79fb\u690d\u7684\u6700\u5927\u969c\u788d\uff1b\u5176”\u96f6\u503c\u516c\u5f0f\u68c0\u6d4b”\u6697\u793a\u5185\u5d4c\u6c42\u503c\u5f15\u64ce\uff0c\u91cd\u5199\u5de5\u4f5c\u91cf\u4e0d\u5c0f\u3002<\/li>
                  2. openpyxl\u2194pivotCache \u4e92\u65a5\uff1apivot \u5fc5\u987b\u6700\u540e\u8dd1\u3001\u4ea7\u7269\u4e0d\u53ef\u518d\u88ab openpyxl \u89e6\u78b0\u2014\u2014\u79fb\u690d\u5de5\u4f5c\u6d41\u65f6\u5fc5\u987b\u4fdd\u7559\u6b64\u65f6\u5e8f\u7ea6\u675f\u3002<\/li>
                  3. LibreOffice\/Excel \u8bed\u4e49\u5dee\uff08\u9690\u5f0f\u6570\u7ec4\u516c\u5f0f\uff09\u9760\u9ed1\u540d\u5355+\u6539\u5199\u5904\u65b9\u515c\u5e95\uff0c\u8bf4\u660e\u6c42\u503c\u5f15\u64ce\u4e0e\u771f\u5b9e Excel \u4ecd\u6709\u9e3f\u6c9f\uff0c”recheck \u8fc7 \u2260 Excel \u6253\u5f00\u6ca1\u95ee\u9898”\u7684\u6b8b\u4f59\u98ce\u9669\u5b58\u5728\u3002<\/li>
                  4. \u91d1\u878d\u6821\u9a8c\u5927\u91cf\u505c\u7559\u5728\u63d0\u793a\u8bcd checklist\uff0814 \u6761\u4ea4\u4ed8\u524d\u6d4b\u8bd5\uff09\uff0c\u4f9d\u8d56\u6a21\u578b\u81ea\u89c9\u6267\u884c recheck\/\u8089\u773c\u6838\u5bf9\u989c\u8272\u2014\u2014\u786e\u5b9a\u6027\u6821\u9a8c\u53ea\u8986\u76d6\u516c\u5f0f\u9519\u8bef\/schema\/\u56fe\u8868\u975e\u7a7a\uff0c\u4e0d\u8986\u76d6\u52fe\u7a3d\u5e73\u8861\u4e0e\u914d\u8272\u5408\u89c4<\/strong>\u3002<\/li>
                  5. \u5de5\u5177\u540d\u8026\u5408 ipython<\/code>\/shell<\/code>\uff08Kimi agent runtime\uff09\uff0c\u642c\u5230\u5176\u4ed6 runtime \u9700\u6539\u5de5\u5177\u5f15\u7528\u3002<\/li>
                  6. \u591a\u4efd\u6587\u4ef6\u4e2d\u82f1\u5c0f\u7455\u75b5\uff08”coloered”\u3001”ful row”\uff09\u8868\u660e\u8fd9\u4e9b\u6587\u6863\u7ecf\u591a\u8f6e\u4eba\u5de5\/\u6a21\u578b\u6df7\u5408\u7f16\u8f91\uff0c\u4f46\u4e0d\u5f71\u54cd\u8bed\u4e49\u3002<\/li><\/ol>\n\n\n\n

                    7. \u79fb\u690d\u8bc4\u4f30\u8868<\/h2>\n\n\n\n
                    \u7ec4\u4ef6<\/th>\u5bf9 Hermes \u4ef7\u503c<\/th>\u5bf9 Kimi Code \u4ef7\u503c<\/th>\u79fb\u690d\u5de5\u4f5c\u91cf<\/th>\u786c\u4f9d\u8d56<\/th><\/tr><\/thead>
                    \u91d1\u878d\u4e09\u5b50\u6280\u80fd\uff083SM 959 \u884c \/ DCF 456 \u884c \/ comps \u5168\u5957 620 \u884c\uff09<\/td>\u9ad8<\/strong>\u2014\u2014\u6295\u884c\u7ea7\u5efa\u6a21\u65b9\u6cd5\u8bba+\u52fe\u7a3d\u6821\u9a8c+\u4e09\u8272\u89c4\u5219\uff0c\u7eaf\u63d0\u793a\u8bcd\uff0cHermes \u82e5\u505a\u91d1\u878d\u573a\u666f\u76f4\u63a5\u83b7\u5f97\u9886\u57df\u7eb5\u6df1<\/td>\u9ad8<\/strong>\u2014\u2014SKILL.md \u683c\u5f0f\u4e0e Kimi Code \u6280\u80fd\u7cfb\u7edf\u540c\u6784\uff0c\u653e user\/plugin scope \u5373\u6302\u5373\u5f97<\/td>\u7eaf\u62f7\u8d1d<\/strong>\uff08\u6539 ipython<\/code>\u2192\u672c\u5730 python \u6267\u884c\u7ea6\u5b9a\u5373\u53ef\uff09<\/td>python3+openpyxl\uff1b\u65e0 API\/\u51ed\u8bc1<\/td><\/tr>
                    xlsx \u4e3b SKILL.md \u975e\u91d1\u878d\u90e8\u5206\uff08\u9010 sheet \u95e8\u63a7\u3001\u6837\u5f0f\u89c4\u5219\u3001\u56fe\u8868\u5f3a\u5236\u4ee4\u3001\u5c01\u9762\u9875\u3001\u6765\u6e90\u5f15\u7528\u5951\u7ea6\uff09<\/td>\u9ad8<\/strong>\u2014\u2014”\u786e\u5b9a\u6027\u6821\u9a8c+\u53cd\u63a8\u8bff\u8bdd\u672f”\u662f\u901a\u7528\u4ea4\u4ed8\u7eaa\u5f8b<\/td>\u9ad8<\/strong>\u2014\u2014\u540c\u4e0a<\/td>\u7eaf\u62f7\u8d1d<\/strong><\/td>\u65e0<\/td><\/tr>
                    Xlsx CLI\uff0877MB \u95ed\u6e90 .NET\uff09<\/td>\u4e2d<\/strong>\u2014\u2014\u6821\u9a8c\u95ed\u73af\u7684\u7269\u7406\u57fa\u7840\uff0c\u4f46\u8bb8\u53ef\u8bc1\u7981\u6b62\u9006\u5411\/\u518d\u5206\u53d1<\/td>\u4e2d<\/strong>\u2014\u2014\u540c\u7406<\/td>\u9700\u91cd\u5199<\/strong>\uff1a\u53ef\u7528 LibreOffice headless \u91cd\u7b97 + Python \u9759\u6001\u68c0\u67e5\u5668\uff08\u516c\u5f0f\u9519\u8bef\/\u96f6\u503c\/\u8303\u56f4\u5f02\u5e38\/\u7981\u7528\u51fd\u6570\u9ed1\u540d\u5355\/schema \u6821\u9a8c\u53ef\u7528 openpyxl+\u6b63\u5219+lxml \u590d\u523b\u5927\u90e8\u5206\uff1bpivot \u751f\u6210\u6700\u96be\uff0c\u53ef\u5148\u780d\u6389\u6216\u6539\u7528 pandas \u6c47\u603b\u8868\u66ff\u4ee3\uff09<\/td>\u539f\u7248\uff1a\u65e0\u8fd0\u884c\u65f6\u4f9d\u8d56\u4f46\u95ed\u6e90\uff1b\u91cd\u5199\u7248\uff1aLibreOffice \u6216\u81ea\u7814\u6c42\u503c<\/td><\/tr>
                    pivot-table.md<\/td>\u4f4e-\u4e2d\u2014\u2014\u4e0e CLI \u5f3a\u8026\u5408<\/td>\u4f4e-\u4e2d<\/td>\u9700\u9002\u914d\uff08\u968f CLI \u91cd\u5199\u800c\u5b9a\uff09<\/td>Xlsx CLI<\/td><\/tr>
                    \u91d1\u878d\u6821\u9a8c checklist\uff0814 \u6761\u4ea4\u4ed8\u6d4b\u8bd5\/\u52fe\u7a3d\u8868\uff09<\/td>\u9ad8<\/strong>\u2014\u2014\u4e0d\u4f9d\u8d56\u4e8c\u8fdb\u5236\uff0c\u7eaf\u6d41\u7a0b\u7eaa\u5f8b<\/td>\u9ad8<\/strong><\/td>\u7eaf\u62f7\u8d1d<\/td>\u65e0\uff08\u4f46\u6267\u884c\u9760\u6a21\u578b\u81ea\u89c9\uff09<\/td><\/tr>
                    chart-gen\uff08chart.mjs + vega\/sharp\uff09<\/td>\u4e2d\u2014\u2014\u62a5\u544a\u8d34\u56fe\u573a\u666f\u53ef\u7528\uff1b\u6ce8\u610f\u662f\u7b2c\u4e09\u65b9\u6280\u80fd\u672c\u5730\u5316\uff0c\u9700\u6838\u8bb8\u53ef<\/td>\u4e2d<\/td>\u9700\u9002\u914d\uff08npm install\uff0c~15MB\uff09<\/td>Node.js + sharp \u9884\u7f16\u8bd1\u4e8c\u8fdb\u5236<\/td><\/tr>
                    data-viz-gen\/build_infographic.py<\/td>\u4e2d\u2014\u2014669 \u884c\u96f6\u4f9d\u8d56\u5355\u811a\u672c\uff0cMIT<\/td>\u4e2d<\/td>\u7eaf\u62f7\u8d1d<\/strong><\/td>python3 \u6807\u51c6\u5e93<\/td><\/tr>
                    code-to-chart \/ gantt-chart-builder<\/td>\u4f4e-\u4e2d\uff08\u4e0e\u8868\u683c\u4e3b\u9898\u65e0\u5173\uff09<\/td>\u4f4e-\u4e2d<\/td>\u7eaf\u62f7\u8d1d\uff08MIT\uff09<\/td>python3\uff1bSVG \u8f93\u51fa\u9700 mmdc<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

                    \u603b\u7ed3\u8bba<\/strong>\uff1a\u672c\u6280\u80fd\u7ec4 80% \u7684\u4ef7\u503c\u5728\u91d1\u878d\u5b50\u6280\u80fd\u4e0e\u4e3b\u6280\u80fd\u7684\u63d0\u793a\u8bcd\u6587\u672c\u2014\u2014\u7eaf\u63d0\u793a\u8bcd\u5373\u53ef\u642c\u8d70<\/strong>\uff0c\u4e14\u4e0e Kimi Code \u7684 SKILL.md \u4f53\u7cfb\u5929\u7136\u540c\u6784\uff1b\u552f\u4e00\u771f\u6b63\u7684\u786c\u9aa8\u5934\u662f 77MB \u95ed\u6e90 Xlsx CLI\uff0c\u5efa\u8bae\u4ee5”LibreOffice headless \u91cd\u7b97 + Python \u9759\u6001\u6821\u9a8c\u5668”\u91cd\u5199\u4e00\u4e2a\u5f00\u6e90\u66ff\u4ee3\uff08pivot \u547d\u4ee4\u53ef\u6682\u7f13\uff09\uff0c\u91cd\u5199\u540e\u6574\u5957”\u751f\u6210-\u6821\u9a8c-\u4ea4\u4ed8\u95e8”\u95ed\u73af\u5373\u53ef\u5728 Hermes\/Kimi Code \u590d\u73b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

                    \u2190 \u8fd4\u56de\u4e3b\u62a5\u544a\uff1aKimi Agent\uff08\u4e91\u7aef\u6c99\u7bb1\uff09\u6280\u672f\u62a5\u544a \uff5c GitHub \u539f\u6587 \u5408\u89c4\u4e0e\u98ce\u9669\u58f0\u660e\uff1a\u672c\u62a5\u544a\u4e3a\u5b89\u5168 … \u7ee7\u7eed\u9605\u8bfb\u201c18-xlsx\uff1a\u8868\u683c\u660e\u661f\u6280\u80fd\u7ec4\u6df1\u62c6\uff08xlsx \u5168\u5bb6\u6876 + chart-gen\/data-viz \u5bf9\u6bd4\uff09\u201d<\/span><\/a><\/p>\n","protected":false},"author":55404,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"wpai_generated_summary":"","wpai_meta_description":"","footnotes":""},"class_list":["post-1884","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/pages\/1884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/users\/55404"}],"replies":[{"embeddable":true,"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/comments?post=1884"}],"version-history":[{"count":1,"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/pages\/1884\/revisions"}],"predecessor-version":[{"id":1904,"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/pages\/1884\/revisions\/1904"}],"wp:attachment":[{"href":"https:\/\/tongchun.website\/index.php\/wp-json\/wp\/v2\/media?parent=1884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}