MadCowork Office E2E · Samsung Memory · Local Gemma 4 26B Q3

Samsung 記憶體任務:自動搜尋、CSV 整理與網頁簡報生成測試

本頁記錄 MadCowork 在本機模型驅動下,使用 Tavily 搜尋/擷取、表格抽取、CSV 驗證與 xdeck Node runtime 製作 Samsung 2026 記憶體週期分析簡報的完整測試流程。

結果摘要

333605938 million KRW

FY2025 revenue,StockAnalysis evidence。

43601051 million KRW

FY2025 operating income。

94.20 days

FY2025 inventory days,使用平均庫存公式。

8 slides

xdeck 重新生成的網頁式簡報。

最終可用成果:MadCowork 完成搜尋、表格抽取、CSV 修正、8 頁 web deck、每頁截圖與純 layout audit。

測試中抓到兩個產品問題並已修補:PDF 下載路徑應落在 session 工作區;LLM 重複同一工具 input 時需要 hard stop;另新增 extract_markdown_tables,避免模型從長 evidence 手抄表格。

產物位置

Workdir: /Users/wake/Desktop/codex-work/untitled-folder-office/MadCowork/e2e-workspace/samsung-memory-e2e-20260530T1739

Deck: /Users/wake/Desktop/codex-work/untitled-folder-office/MadCowork/e2e-workspace/samsung-memory-e2e-20260530T1739/decks/samsung-electronics-2026-memory-cycle-analysis-20260530/deck.html

Screenshots: /Users/wake/Desktop/codex-work/untitled-folder-office/MadCowork/e2e-workspace/samsung-memory-e2e-20260530T1739/decks/samsung-electronics-2026-memory-cycle-analysis-20260530/screenshots

Audit: ok=true; finding_count=1

核心 CSV

Inventory / DIO

companymetricperiodvalueunitformulasource_urlnote
Samsung ElectronicsInventoryFY 202552636828million KRWN/Ahttps://stockanalysis.com/quote/krx/005930/financials/balance-sheet/
Samsung ElectronicsInventoryFY 202451754865million KRWN/Ahttps://stockanalysis.com/quote/krx/005930/financials/balance-sheet/
Samsung ElectronicsAverage InventoryFY 202552195846.5million KRWN/AN/AAverage of FY25/FY24
Samsung ElectronicsCost of RevenueFY 2025202235513million KRWN/Ahttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsDIOFY 202594.20daysaverage_inventory/cost_of_revenue*365N/A((52636828+51754865)/2)/202235513*365

Memory Prices

productprice_typeperiodvalueunitsource_urlnote
DDR5 16GbSession Average2026 Q141.50USDhttps://www.trendforce.com/price
DDR5 16Gb eTTSession Average2026 Q122.50USDhttps://www.trendforce.com/price
DDR4 16GbSession Average2026 Q160.857USDhttps://www.trendforce.com/price
DDR4 16Gb eTTSession Average2026 Q112.35USDhttps://www.trendforce.com/price
DDR4 8GbSession Average2026 Q133.30USDhttps://www.trendforce.com/price
DDR4 8Gb eTTSession Average2026 Q14.864USDhttps://www.trendforce.com/price

Financials

companymetricperiodvalueunitsource_urlnote
Samsung ElectronicsRevenueFY 2025333605938million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsCost of RevenueFY 2025202235513million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsOperating IncomeFY 202543601051million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsNet IncomeFY 202544260956million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsGross MarginFY 202539.37%https://stockanalysis.com/quote/krx/005930/financials/Calculated (Gross Profit / Revenue)
Samsung ElectronicsOperating MarginFY 202513.07%https://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsProfit MarginFY 202513.27%https://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsRevenueFY 2024300870903million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsCost of RevenueFY 2024186562268million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsOperating IncomeFY 202432725961million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Samsung ElectronicsNet IncomeFY 202433621363million KRWhttps://stockanalysis.com/quote/krx/005930/financials/

Chart Inputs

chart_nameseriesperiodvalueunitsource_urlnote
Financial PerformanceRevenueFY 2025333605938million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Financial PerformanceOperating IncomeFY 202543601051million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Financial PerformanceNet IncomeFY 202544260956million KRWhttps://stockanalysis.com/quote/krx/005930/financials/
Inventory ManagementDIOFY 202594.20daysN/A
Inventory ManagementInventoryFY 202552636828million KRWhttps://stockanalysis.com/quote/krx/005930/financials/balance-sheet/
Memory PricingDDR5 16Gb2026 Q141.50USDhttps://www.trendforce.com/price
Memory PricingDDR4 16Gb2026 Q160.86USDhttps://www.trendforce.com/price
Memory PricingDDR4 8Gb2026 Q133.30USDhttps://www.trendforce.com/price

Sources

source_typetitleurlpublished_dateused_for
officialSamsung Electronics Earnings Releasehttps://www.samsung.com/global/ir/financial-information/earnings-release/2026-05-01Q1 2026 revenue and profit
third_partyStockAnalysis Samsung Income Statementhttps://stockanalysis.com/quote/krx/005930/financials/2026-05-11FY2025 and FY2024 financial metrics
third_partyStockAnalysis Samsung Balance Sheethttps://stockanalysis.com/quote/krx/005930/financials/balance-sheet/2026-05-11Inventory and Cost of Revenue
third_partyTrendForce Price Pagehttps://www.trendforce.com/price2026-05-11Memory pricing trends
third_partyTradingKey Samsung Q1 Analysishttps://www.tradingkey.com/analysis/stocks/us-stocks/261841802-samsung-q1-earnings-chip-surge-mobile-decline-hbm-demand-capex-record-tradingkey2026-05-11Segment profit contribution

工具流程截圖

MadCowork Office 首頁載入

01-home.png MadCowork Office 首頁載入

建立 Samsung memory E2E session

02-session-created.png 建立 Samsung memory E2E session

送出 source-grounded 英文工具 prompt

03-prompt-submitted.png 送出 source-grounded 英文工具 prompt

Gemma 啟動 web_fetch / web_search 取得證據

04-web-evidence-tools.png Gemma 啟動 web_fetch / web_search 取得證據

CSV 產物進入 timeline

05-csv-artifacts.png CSV 產物進入 timeline

harness 偵測 DIO / price numeric rows 不足

10-before-correction.png harness 偵測 DIO / price numeric rows 不足

送出自動修正 prompt

11-correction-submitted.png 送出自動修正 prompt

correction pass 重新產生 deck

12-correction-xdeck-generate.png correction pass 重新產生 deck

correction pass 重新截圖

13-correction-screenshots.png correction pass 重新截圖

correction pass 回覆,但仍需後續算術修正

14-correction-final.png correction pass 回覆,但仍需後續算術修正

最終簡報預覽

Slide 1

slide-01.png Samsung memory web deck preview

Slide 2

slide-02.png Samsung memory web deck preview

Slide 3

slide-03.png Samsung memory web deck preview

Slide 4

slide-04.png Samsung memory web deck preview

Slide 5

slide-05.png Samsung memory web deck preview

Slide 6

slide-06.png Samsung memory web deck preview

Slide 7

slide-07.png Samsung memory web deck preview

Slide 8

slide-08.png Samsung memory web deck preview

使用 Prompt

Initial prompt

You are running a source-grounded MadCowork Office E2E workflow.
Communicate final user-facing conclusions in Traditional Chinese, but all tool planning and tool arguments must be concise English.

Topic: Samsung Electronics 2026 memory-cycle analysis: Samsung memory/semiconductor results, DRAM/NAND pricing, inventory turnover days, and AI infrastructure insight.

Search and fetch evidence yourself. Start with these source targets and search terms, but verify fetchability:
- Samsung Electronics investor relations earnings release page: https://www.samsung.com/global/ir/financial-information/earnings-release/
- Search: Samsung Electronics Q1 2026 results memory business revenue operating profit
- Search: Samsung Electronics FY2025 results Device Solutions memory business
- Search: Samsung Electronics Q1 2025 results memory semiconductor
- TrendForce DRAM price page: https://www.trendforce.com/price
- StockAnalysis Samsung Electronics income statement: https://stockanalysis.com/quote/krx/005930/financials/
- StockAnalysis Samsung Electronics balance sheet: https://stockanalysis.com/quote/krx/005930/financials/balance-sheet/

Hard requirements:
1. Do not rely on model memory. Use web_search, web_fetch, and web_crawl before making factual or numerical claims.
2. Gather evidence from multiple sources, including Samsung official IR/newsroom reports and at least two third-party market or financial data sources.
3. Create CSV files in this session workspace:
   - samsung_sources.csv with columns: source_type,title,url,published_date,used_for.
   - samsung_financials.csv with columns: company,metric,period,value,unit,source_url,note.
   - memory_prices.csv with columns: product,price_type,period,value,unit,source_url,note.
   - inventory_metrics.csv with columns: company,metric,period,value,unit,formula,source_url,note.
   - samsung_chart_inputs.csv with columns: chart_name,series,period,value,unit,source_url,note.
   - session_metadata.csv with columns: artifact,type,path,created_at,source_inputs.
4. Every numeric claim used in the deck must have a source_url in one of the CSV files.
5. Include these analyses if sources support them:
   - Samsung Electronics Q1 2026 revenue and operating profit.
   - Device Solutions / semiconductor / memory business revenue and operating profit for Q1 2026 or latest available quarter.
   - FY2025 revenue, operating profit, net income, and operating margin.
   - FY2025 cost of revenue / cost of sales and inventory from a financial-data source or official financial statements.
   - Annual inventory days / DIO using: average inventory / cost of revenue * 365. Use FY2025 and FY2024 inventory if available. If only one period is available, clearly label the limitation.
   - DRAM, DDR4/DDR5, NAND, or HBM price / price-change data from TrendForce or another fetchable third-party memory market source.
   - HBM / AI memory demand insight only when backed by a fetched source.
6. Create chart-ready rows in samsung_chart_inputs.csv for revenue/profitability, segment mix, inventory/DIO, memory pricing, and sourced AI-memory insight.
7. Call source_validate on samsung_sources.csv with min_official_sources=2 and min_third_party_sources=2. If market data cannot be fetched, record the data gap in the deck instead of inventing it.
8. Before charting or xdeck, call list_skills, read xdata-office-deck-workflow and xdata-spreadsheet-workflow if available, call csv_profile on the financial/chart CSVs, then call csv_validate on every CSV.
   If an evidence file contains Markdown tables, call extract_markdown_tables first and use the extracted CSV tables as the source for numeric extraction.
9. Generate a self-contained web presentation through xdeck_generate. Set out_dir exactly to "samsung-memory-web-deck". Pass facts_paths, sources_path, chart_data_path, and validation_report_path when available.
10. The deck should be 8 slides, Traditional Chinese, investor / memory-cycle strategy briefing style, with speaker_note on each slide.
11. Run xdeck_audit and xdeck_screenshots. If the audit finds layout issues, run one xdeck_revise pass.
12. Final answer: list generated artifact paths and briefly explain the evidence chain.

Important: if a source cannot be fetched, record the failed URL in samsung_sources.csv with used_for="attempted but unavailable" and continue with fetchable sources.

Automatic correction prompt

Automatic correction pass for the Samsung memory E2E workflow.

The harness detected missing/non-numeric DIO, memory-price values, or chart inputs. Do not rely on model memory. Read the saved evidence files in this session workspace and repair the CSVs from evidence only.

Required corrections:
1. List evidence/ and read the saved Samsung official evidence files, StockAnalysis income statement evidence, StockAnalysis balance sheet evidence, and TrendForce price evidence.
   Read each evidence file at most once. After reading it, extract the needed rows from the content already in context and move on to write_file/csv_validate.
   Prefer the already-saved HTML evidence files for correction. If a source is a PDF, use read_pdf; do not use read_file on a PDF or a missing downloaded PDF path.
   For StockAnalysis and TrendForce evidence, call extract_markdown_tables and use the generated CSV table paths before repairing the final CSVs.
2. Update samsung_financials.csv with missing Cost of Revenue / Cost of Sales rows from the financial statement source for FY2025 and FY2024 if available.
3. Update inventory_metrics.csv with FY2025 inventory, FY2024 inventory if available, FY2025 average inventory, FY2025 cost of revenue, and FY2025 DIO. Calculate DIO as average inventory / cost of revenue * 365. Values must be numeric, not N/A or unknown.
4. Update memory_prices.csv with numeric TrendForce rows. Use session average and percentage change rows when available. Qualitative HBM/NAND rows are allowed only if they are not used as numeric price chart inputs.
5. Update samsung_chart_inputs.csv so Inventory / DIO and Memory Pricing charts contain numeric values, not N/A, unknown, trend strings, or qualitative words.
6. Run csv_profile on samsung_financials.csv, inventory_metrics.csv, memory_prices.csv, and samsung_chart_inputs.csv. Run csv_validate on every CSV and source_validate on samsung_sources.csv.
7. Regenerate the same 8-slide web presentation by calling xdeck_generate with out_dir exactly "samsung-memory-web-deck", passing the updated CSVs. Then run xdeck_audit. If audit has findings, run xdeck_revise once, then run xdeck_screenshots.
8. Final answer in Traditional Chinese: explain that this was an automatic correction pass fixing inventory/DIO and numeric memory-price extraction.