01-ui-started-by-computer-use.png
Computer Use 在 Safari 首頁輸入「台積電 財報分析」並啟動 Research 劇本
MadCowork Office E2E · Computer Use · Gemma 4 26B Q3
這份報告記錄 MadCowork 在本機 Gemma Q3 驅動下,從「台積電 財報分析」開始,自動搜尋、擷取、寫入 CSV、驗證、生成 xdeck 簡報、修正資料品質與單位錯誤,最後上傳 tmuh.ai 的端到端流程。
2025 年營收,單位已從 billion_NT 正確轉為兆台幣。
2026 Q1 營收,保留單季語境。
2026 Q1 毛利率。
最終 xdeck layout audit findings。
通過:Computer Use 啟動、web_search / web_fetch、CSV 產出、source/csv validation、xdeck_generate、xdeck_revise、xdeck_audit、xdeck_screenshots 都完成。
實測中抓到兩個品質問題並修正:placeholder zero、CSV note 欄位逗號警告,以及 billion_NT 被錯寫成「億元」的單位錯誤。
最終簡報已上傳 tmuh.ai,並以單頁 HTML 方式發布。
首頁劇本 prompt 由 UI 自動組合,後續三個 prompt 是測試中針對資料品質與單位正確性補送的修正要求。
[OFFICE_WORKFLOW=company_industry_investment_research] Company or industry input: 台積電 財報分析 General rules: - User-facing conversation and final answer must be in Traditional Chinese unless the user explicitly requests another language. - Internal planning and tool arguments should be concise English. - Do not rely on model memory for factual or numerical claims. - Prefer session workspace CSV files as the source of truth for charts and deck numbers. - Use update_plan to show progress; keep tool records concise. - Before xdeck generation, call list_skills and read relevant xdata workflow skills when available. - Default final presentation output is a self-contained web deck.html through xdeck_generate, followed by xdeck_audit and xdeck_screenshots. - If a required source, table, article, or URL is missing, ask one concise Traditional Chinese question and stop. Workflow requirements: 1. Interpret the input as a company name, stock ticker, industry name, or investment theme. If the company or industry is ambiguous, ask for clarification. 2. Search and fetch multiple sources before making claims: company IR/filings/earnings materials when available, market or industry research, competitor data, and analyst/forecast sources when available. 3. Create sources.csv with columns: source_type,title,url,published_date,used_for. 4. Create financial_metrics.csv for company revenue, profit, margins, cash flow, inventory or other material metrics that sources support. 5. Create industry_metrics.csv for market size, pricing, demand/supply, adoption, or macro drivers relevant to the company. 6. Create peer_comparison.csv when comparable companies can be sourced. 7. Create chart_inputs.csv with only source-backed numeric values; every row must include source_url. 8. Validate sources.csv with source_validate and validate all generated CSVs with csv_validate. 9. Derive insights from the CSVs: what changed, why it matters, risks, counterpoints, and what would surprise investors. 10. Generate an 8-slide investor-style web presentation. Include speaker_note on each slide. Use out_dir "company-industry-investment-deck". Start now if the user idea is sufficient.
Correction pass for the existing TSMC financial analysis workflow. User-facing answer must be Traditional Chinese. Internal tool calls and planning should be concise English. Current date: 2026-05-31. The previous run completed, but it needs quality correction before publishing: - financial_metrics.csv contains placeholder zero values such as revenue_growth_usd year_2025=0 and net_income_growth_usd year_2025=0. Do not use placeholder zeros unless the source explicitly says zero. - The deck must clearly state whether it uses latest quarterly data, 2025 annual data, or both. Required correction: 1. Re-open existing CSVs and sources. Use web_search and web_fetch again to find the latest available official TSMC quarterly results as of 2026-05-31, plus the official annual report already used. 2. Add or update sources.csv with each source's actual title, URL, published_date, and used_for. Record any source that cannot be fetched with used_for="attempted but unavailable". 3. Rewrite financial_metrics.csv in long/tidy format with columns: metric,period,value,unit,source_url,note Include only source-backed numeric rows. Remove placeholder zeros. Include annual 2024/2025 and latest quarter rows if available. 4. Rewrite chart_inputs.csv in long/tidy format with columns: chart_name,series,period,value,unit,source_url,note Include charts for revenue trajectory, margin/profitability share, advanced node mix, and latest quarter vs annual context. Every row must have source_url. 5. Re-run source_validate on sources.csv and csv_validate on all CSVs. 6. Regenerate the 8-slide web deck by calling xdeck_generate again with out_dir exactly "company-industry-investment-deck". The deck title should mention "台積電財報分析". 7. Run xdeck_audit and xdeck_screenshots again. If audit has findings, run one xdeck_revise pass. 8. Final answer: report corrected artifact paths, key source-backed findings, and caveats. Do not invent unavailable 2026 data. If latest official quarter is not fetchable through the tools, explicitly say so and use the latest fetchable official source.
Small artifact cleanup. The corrected TSMC workflow is otherwise good, but csv_validate reported warnings for financial_metrics.csv because some note values contain commas without CSV quoting. Please rewrite financial_metrics.csv only, keeping the same columns and source-backed values, but remove comma characters from note fields or quote fields correctly so csv_validate has zero warnings. Then run csv_validate on financial_metrics.csv. Do not regenerate the deck unless chart_inputs.csv changes. Final answer in Traditional Chinese with the validation result.
Deck unit correction before publishing. The CSV is now valid, but the web deck text uses the wrong Traditional Chinese unit: - financial_metrics.csv unit "billion_NT" means NT$ billions / 十億新台幣. - Do NOT render 3809.05 billion_NT as "NT$3,809.05 億元". That is off by 10x. - Render 3809.05 billion_NT as "NT$3.81 兆" or "NT$3,809.05 十億". - Render 1134.10 billion_NT as "NT$1.13 兆" or "NT$1,134.10 十億". - Render 1717.88 billion_NT as "NT$1.72 兆" or "NT$1,717.88 十億". Please regenerate or revise company-industry-investment-deck so every revenue/net-income/chart label uses correct units. Keep the existing source-backed values and CSV files. Run xdeck_audit and xdeck_screenshots again after the unit correction. Final answer in Traditional Chinese with the corrected deck path and audit result.
| source_type | title | url | published_date | used_for |
|---|---|---|---|---|
| official | TSMC 2025 Annual Report | https://investor.tsmc.com/static/annualReports/2025/english/index.html | 2025-01-01 | annual_2025_data |
| official | TSMC Q1 2026 SEC Filing (Form 6-K) | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html | 2026-04-15 | q1_2026_data |
| news | TSMC Q1 2026 Earnings Recap | https://www.allinvestview.com/earnings/TSM/q1-2026 | 2026-04-15 | q1_2026_context |
| attempted | TSMC Q2 2026 Official Results | https://investor.tsmc.com/chinese/quarterly-results/2026/q2 | 2026-05-31 | attempted_but_unavailable |
| metric | period | value | unit | source_url | note |
|---|---|---|---|---|---|
| net_revenue | 2024_annual | 2894.31 | billion_NT | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2024 |
| net_revenue | 2025_annual | 3809.05 | billion_NT | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2025 |
| net_revenue | 2026_q1 | 1134.10 | billion_NT | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html | Q1 2026 (NT$1134.10 billion) |
| net_income | 2024_annual | 1173.27 | billion_NT | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2024 |
| net_income | 2025_annual | 1717.88 | billion_NT | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2025 |
| net_income | 2026_q1 | 572.80 | billion_NT | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html | Q1 2026 (NT$572.80 billion) |
| gross_margin | 2024_annual | 56.1 | percent | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2024 |
| gross_margin | 2025_annual | 59.9 | percent | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2025 |
| gross_margin | 2026_q1 | 66.0 | percent | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html | Q1 2026 |
| eps | 2024_annual | 45.25 | NTD | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2024 |
| eps | 2025_annual | 66.26 | NTD | https://investor.tsmc.com/static/annualReports/2025/english/index.html | Full Year 2025 |
| eps | 2026_q1 | 22.08 | NTD | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html | Q1 2026 (Basic EPS) |
| chart_name | series | period | value | unit | source_url | note |
|---|---|---|---|---|---|---|
| revenue_trajectory | net_revenue | 2024_annual | 2894.31 | billion_NT | https://investor.tsmc.com/static/annualReports/2025/english/index.html | |
| revenue_trajectory | net_revenue | 2025_annual | 3809.05 | billion_NT | https://investor.tsmc.com/static/annualReports/2025/english/index.html | |
| revenue_trajectory | net_revenue | 2026_q1 | 1134.10 | billion_NT | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html | |
| profitability_margin | gross_margin | 2024_annual | 56.1 | percent | https://investor.tsmc.com/static/annualReports/2025/english/index.html | |
| profitability_margin | gross_margin | 2025_annual | 59.9 | percent | https://investor.tsmc.com/static/annualReports/2025/english/index.html | |
| profitability_margin | gross_margin | 2026_q1 | 66.0 | percent | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html | |
| advanced_node_mix | advanced_tech_share | 2024_annual | 69 | percent | https://investor.tsmc.com/static/annualReports/2025/english/index.html | |
| advanced_node_mix | advanced_tech_share | 2025_annual | 74 | percent | https://investor.tsmc.com/static/annualReports/2025/english/index.html | |
| context_comparison | eps | 2025_annual | 66.26 | NTD | https://investor.tsmc.com/static/annualReports/2025/english/index.html | |
| context_comparison | eps | 2026_q1 | 22.08 | NTD | https://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html |
01-ui-started-by-computer-use.png
Computer Use 在 Safari 首頁輸入「台積電 財報分析」並啟動 Research 劇本
02-web-search.png
Gemma 呼叫 Tavily web_search 取得新資料
03-web-fetch.png
Gemma 使用 web_fetch 擷取來源頁面
04-csv-artifacts.png
sources / financial / chart CSV 進入 session workspace
05-validation.png
source_validate 與 csv_validate 執行
correction-06-xdeck-generated.png
修正 pass 重新生成 deck
correction-07-xdeck-screenshots.png
修正 pass 產生投影片截圖
unitfix-06-xdeck-generated.png
單位修正 pass 修正 billion_NT 顯示為兆台幣
unitfix-07-xdeck-screenshots.png
最終 deck 重跑 screenshots
unitfix-08-agent-final.png
MadCowork 最終確認單位修正與 audit 0
台積電 (TSMC) 投資研究演示文稿的單位修正與佈局優化已完成。我已修正了所有關於營收與淨利的單位表示方式,確保其符合台灣慣用的「兆」單位,避免了原先 10 倍的數量級錯誤。
### ✅ 修正與驗證結果
**1. 單位與內容修正 (Unit & Content Correction):**
* **單位轉換**:所有的 `billion_NT` 數值在文稿中已正確轉換為「兆」。
* 例如:`3809.05 billion_NT` $\rightarrow$ **NT$3.81 兆**。
* 例如:`1134.10 billion_NT` $\rightarrow$ **NT$1.13 兆**。
* 例如:`1717.88 billion_NT` $\rightarrow$ **NT$1.72 兆**。
* **文稿更新**:更新了 `investment_facts.txt` 以確保生成文稿的基礎事實符合正確的單位。
**2. 佈局與圖表稽核 (Audit & Revision):**
* **圖表比例修正**:針對「先進製程營收佔比」圖表在不同量級下產生的比例錯誤,已透過 `xdeck_revise` 重新設定 Y 軸刻度,確保百分比圖表能獨立於營收數值之外進行正確顯示。
* **最終稽核狀態**:`layout-audit.json` 顯示為 **0 錯誤**。
---
### 📁 最終交付文件路徑
* **演示文稿 (Web Deck)**: `company-industry-investment-deck/deck.html`
* **稽核報告**: `company-industry-investment-deck/layout-audit.json`
* **截圖目錄**: `company-industry-investment-deck/screenshots/`
**請點擊預覽按鈕查看更新後的 `deck.html`,確認單位與圖表顯示是否符合預期。**