MadCowork Office E2E · Computer Use · Gemma 4 26B Q3

台積電財報分析:從 UI prompt 到網頁式簡報

這份報告記錄 MadCowork 在本機 Gemma Q3 驅動下,從「台積電 財報分析」開始,自動搜尋、擷取、寫入 CSV、驗證、生成 xdeck 簡報、修正資料品質與單位錯誤,最後上傳 tmuh.ai 的端到端流程。

結果摘要

NT$3.81兆

2025 年營收,單位已從 billion_NT 正確轉為兆台幣。

NT$1.13兆

2026 Q1 營收,保留單季語境。

66%

2026 Q1 毛利率。

0

最終 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 紀錄

首頁劇本 prompt 由 UI 自動組合,後續三個 prompt 是測試中針對資料品質與單位正確性補送的修正要求。

Prompt seq 1
[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.
Prompt seq 47
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.
Prompt seq 71
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.
Prompt seq 75
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.

資料鏈

sources.csvfinancial_metrics.csvchart_inputs.csvlayout-audit.json

Sources

source_typetitleurlpublished_dateused_for
officialTSMC 2025 Annual Reporthttps://investor.tsmc.com/static/annualReports/2025/english/index.html2025-01-01annual_2025_data
officialTSMC 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.html2026-04-15q1_2026_data
newsTSMC Q1 2026 Earnings Recaphttps://www.allinvestview.com/earnings/TSM/q1-20262026-04-15q1_2026_context
attemptedTSMC Q2 2026 Official Resultshttps://investor.tsmc.com/chinese/quarterly-results/2026/q22026-05-31attempted_but_unavailable

Financial Metrics

metricperiodvalueunitsource_urlnote
net_revenue2024_annual2894.31billion_NThttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2024
net_revenue2025_annual3809.05billion_NThttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2025
net_revenue2026_q11134.10billion_NThttps://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.htmlQ1 2026 (NT$1134.10 billion)
net_income2024_annual1173.27billion_NThttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2024
net_income2025_annual1717.88billion_NThttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2025
net_income2026_q1572.80billion_NThttps://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.htmlQ1 2026 (NT$572.80 billion)
gross_margin2024_annual56.1percenthttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2024
gross_margin2025_annual59.9percenthttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2025
gross_margin2026_q166.0percenthttps://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.htmlQ1 2026
eps2024_annual45.25NTDhttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2024
eps2025_annual66.26NTDhttps://investor.tsmc.com/static/annualReports/2025/english/index.htmlFull Year 2025
eps2026_q122.08NTDhttps://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.htmlQ1 2026 (Basic EPS)

Chart Inputs

chart_nameseriesperiodvalueunitsource_urlnote
revenue_trajectorynet_revenue2024_annual2894.31billion_NThttps://investor.tsmc.com/static/annualReports/2025/english/index.html
revenue_trajectorynet_revenue2025_annual3809.05billion_NThttps://investor.tsmc.com/static/annualReports/2025/english/index.html
revenue_trajectorynet_revenue2026_q11134.10billion_NThttps://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html
profitability_margingross_margin2024_annual56.1percenthttps://investor.tsmc.com/static/annualReports/2025/english/index.html
profitability_margingross_margin2025_annual59.9percenthttps://investor.tsmc.com/static/annualReports/2025/english/index.html
profitability_margingross_margin2026_q166.0percenthttps://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html
advanced_node_mixadvanced_tech_share2024_annual69percenthttps://investor.tsmc.com/static/annualReports/2025/english/index.html
advanced_node_mixadvanced_tech_share2025_annual74percenthttps://investor.tsmc.com/static/annualReports/2025/english/index.html
context_comparisoneps2025_annual66.26NTDhttps://investor.tsmc.com/static/annualReports/2025/english/index.html
context_comparisoneps2026_q122.08NTDhttps://www.stocktitan.net/sec-filings/TSM/6-k-taiwan-semiconductor-manufacturing-co-ltd-current-report-foreign--1d244b769f20.html

流程截圖

Computer Use 在 Safari 首頁輸入「台積電 財報分析」並啟動 Research 劇本

01-ui-started-by-computer-use.png
Computer Use 在 Safari 首頁輸入「台積電 財報分析」並啟動 Research 劇本

Gemma 呼叫 Tavily web_search 取得新資料

02-web-search.png
Gemma 呼叫 Tavily web_search 取得新資料

Gemma 使用 web_fetch 擷取來源頁面

03-web-fetch.png
Gemma 使用 web_fetch 擷取來源頁面

sources / financial / chart CSV 進入 session workspace

04-csv-artifacts.png
sources / financial / chart CSV 進入 session workspace

source_validate 與 csv_validate 執行

05-validation.png
source_validate 與 csv_validate 執行

修正 pass 重新生成 deck

correction-06-xdeck-generated.png
修正 pass 重新生成 deck

修正 pass 產生投影片截圖

correction-07-xdeck-screenshots.png
修正 pass 產生投影片截圖

單位修正 pass 修正 billion_NT 顯示為兆台幣

unitfix-06-xdeck-generated.png
單位修正 pass 修正 billion_NT 顯示為兆台幣

最終 deck 重跑 screenshots

unitfix-07-xdeck-screenshots.png
最終 deck 重跑 screenshots

MadCowork 最終確認單位修正與 audit 0

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`,確認單位與圖表顯示是否符合預期。**