邮件→表格→报告流程
Email → spreadsheet → report pipelines
Gather data from mail and attachments, analyze it in a sheet and produce a report.
20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。
- 典型应用
- Outlook · Excel · Word
- 小类 GUI 需求标签
G2· GUI 必要
任务提案 · 20
展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。
R04.07.01.03-T01 Tabulate twelve emailed vendor quotes and highlight the cheapest
原始指令
In Outlook (test mailbox), folder 'Vendor quotes' has 12 quote emails, some with the price in the body and some in a PDF attachment. Fill input/quotes.xlsx with Vendor, Unit Price (USD), MOQ and Lead Time (days), sort by price ascending, and fill the cheapest row yellow.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用vis· 视觉判断type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 2 / 5
建议验证方式
Rows equal key (12 vendors; numbers exact); sort order; only the cheapest row has fill FFFF00; mailbox unchanged (no moves/deletes) via IMAP read. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
60% values (pro-rata over 12 vendors); 20% sort; 20% highlight.
R04.07.01.03-T02 Tally RSVP replies into a sheet and write a one-paragraph summary
原始指令
In the test mailbox, 34 replies to 'Team offsite RSVP' say yes/no/maybe in free text, some with dietary needs. Record each person's latest answer in input/rsvp.xlsx (Name, Response, Dietary), and write output/rsvp_summary.docx with one paragraph giving counts by response and each dietary need count.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用- 提案难度
- 2 / 5
建议验证方式
Sheet rows equal key (latest reply wins for 3 people who changed answers); docx paragraph contains the exact counts (regex for numbers next to yes/no/maybe and each diet). Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
50% responses; 20% dietary; 30% summary counts.
R04.07.01.03-T03 Consolidate five regional sales emails into a Word report with a chart
原始指令
Five regional managers emailed weekly CSVs (subject 'W41 sales – <region>'). Combine them in input/w41_sales.xlsx (one table, region column), compute totals and week-over-week % vs input/w40_totals.csv, and fill input/weekly_report_template.docx with the summary table and a column chart of revenue by region.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用click· 指向与点击type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Workbook combined table equals union of CSVs (row count, sums); WoW % equals key (0.1 pp); docx table values equal key; docx contains a chart part (or linked chart) with region series equal totals. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
25% consolidation; 25% totals/WoW; 30% report table; 20% chart.
R04.07.01.03-T04 Log emailed receipts against policy and write an exceptions memo
原始指令
Folder 'Receipts – Sept' holds 22 emails from staff with receipt images/PDFs. Enter each in input/expenses.xlsx (employee, date, merchant, amount, category), flag violations of input/travel_policy.pdf (meal caps, missing itemization, weekend), and write output/exceptions_memo.docx listing each flagged item with the rule broken.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用vis· 视觉判断type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Sheet rows equal key (amounts exact); violation flags equal key (precision/recall); memo lists exactly the flagged items with rule names (regex per item). Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
45% receipts entered; 30% flags; 25% memo.
R04.07.01.03-T05 Categorize a month of complaints and file the processed emails
原始指令
The shared mailbox 'support@' (test) has 57 complaint emails in Inbox for September. Classify each into input/taxonomy.csv categories in input/complaints.xlsx (sender, date, order no., category), build a pivot of counts by category × week, write output/complaints_sept.docx with the top 3 categories, and move processed emails to folder 'Processed/2026-09'.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
HY· 混合- 交互原语
multi· 跨应用drag· 拖放type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Category accuracy vs key ≥90% for full credit; pivot exists with counts consistent with the sheet; memo names the correct top 3 with counts; IMAP: 57 emails in Processed/2026-09, none lost. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
40% classification; 20% pivot; 20% memo; 20% emails filed.
R04.07.01.03-T06 Turn membership renewal emails into a Numbers table and Pages letters
原始指令
In Apple Mail (test account), 18 members replied to 'Renewal 2027' with their tier and payment method. Record them in input/members.numbers, then in Pages produce one confirmation letter per member from input/letter_template.pages (merge name, tier, fee from the tier table) saved as output/letters.pdf.
- 平台
mac· macOS- 应用
- Apple Mail · Numbers · Pages
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用type· 文字与表单click· 指向与点击- 工作产物
WP01· 文档- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Grader AppleScript export of the Numbers table equals key; letters.pdf has 18 pages (one per member) with name/tier/fee text equal key; fees derived from the tier table. Agent VM has no IMAP credentials and osascript/JXA is blocked; mail is reachable only in Apple Mail, and the files must be saved by Numbers and Pages.
建议部分得分
40% table; 45% letters merged correctly; 15% PDF page count.
R04.07.01.03-T07 Compile emailed bug reports into a Calc tracker and Writer summary
原始指令
In Thunderbird (test profile), folder 'QA reports' has 26 bug-report emails with logs attached. Record ID, component, severity, build and reporter in input/bugs.ods (LibreOffice Calc), count by component × severity, and write output/qa_summary.odt in Writer with the count table and the 5 critical bugs listed.
- 平台
lin· Linuxwin· Windowsmac· macOS- 应用
- Thunderbird · LibreOffice
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
ODS rows equal key; count table consistent; ODT contains the table values and the 5 critical bug IDs and titles. Agent VM has no IMAP credentials, and Thunderbird add-ons and LibreOffice macros/UNO are disabled; mail is reachable only in Thunderbird.
建议部分得分
45% tracker rows; 20% counts; 35% summary.
R04.07.01.03-T08 Combine eight site survey workbooks into a templated report
原始指令
Eight site leads emailed survey result XLSX files with different column orders and header spellings. Combine them in input/survey_all.xlsx with a site column, compute per-site and overall satisfaction means and response rates, and fill the 14 «placeholders» in input/survey_report_template.docx with the computed values.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Combined table row count and per-column sums equal key; means equal key (0.01); all 14 placeholders replaced with values equal key; no « » remains. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
35% combination; 30% computed stats; 35% report placeholders.
R04.07.01.03-T09 Age emailed invoices and prepare reminder drafts without sending
原始指令
From folder 'Invoices sent' (31 emails with invoice PDFs) and payment confirmations in 'Payments', build input/ar_aging.xlsx with buckets (current, 1–30, 31–60, 60+) as of 2026-10-14, then mail-merge a reminder from input/reminder.docx into Outlook drafts for each overdue client. Do not send.
- 平台
win· Windowsmac· macOS- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用type· 文字与表单click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用risk· 高风险 / 不可逆- 提案难度
- 3 / 5
建议验证方式
Aging table equals key; IMAP Drafts contains one reminder per overdue client (9) with correct amounts/days in body; Sent folder unchanged (no sends). Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
40% aging; 40% drafts correct; 20% nothing sent.
R04.07.01.03-T10 Build a board KPI report from tables pasted inside department emails
原始指令
Six department heads sent September KPIs as tables inside the email body (no attachments). Copy them into input/kpi_model.xlsx tabs, let the model compute variances, then update input/board_report.docx: refresh the 3 linked charts, fill the KPI table and write each department's one-line variance note from the model.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用click· 指向与点击type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
Model input ranges equal email table values (exact); computed variances equal key; docx KPI table equals model outputs; linked chart caches updated to new values; 6 notes contain the variance figures. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
35% email tables transferred; 20% model results; 25% report table + charts; 20% notes.
R04.07.01.03-T11 Extract forty order confirmations from webmail into a spend memo
原始指令
In the sandbox Roundcube webmail, 40 HTML order-confirmation emails from 6 vendors arrived this quarter. Record order no., date, vendor, items count, subtotal, tax, total in input/orders_q3.xlsx, compute spend per vendor, and write output/spend_memo.docx with a table of vendors over $5,000.
- 平台
web· 任意系统（网页）mac· macOSwin· Windows- 应用
- Roundcube · Excel · Word
- 交互表面
brow· 浏览器desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
multi· 跨应用nav· 平移 / 缩放 / 滚动type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
Sheet rows equal key (amounts exact); vendor totals equal key; memo table lists exactly vendors > $5,000 with totals. Agent has no IMAP/API credentials; mail is reachable only through the webmail UI.
建议部分得分
55% orders entered; 20% vendor totals; 25% memo table.
R04.07.01.03-T12 Apply superseding timesheet emails before building a payroll summary
原始指令
Folder 'Timesheets W40–W41' has 48 emails; some later emails correct earlier ones ('Correction:' subject or reply). Use only the latest submission per employee-week, fill input/payroll_hours.xlsx, and produce output/payroll_summary.docx with total regular and overtime hours per department.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用nav· 平移 / 缩放 / 滚动type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用hidden· 隐藏 / 过期状态- 提案难度
- 3 / 5
建议验证方式
Hours per employee-week equal key (latest-wins applied to 7 corrected cases); department totals equal key; summary docx numbers match. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
40% hours; 25% corrections applied; 20% department totals; 15% summary.
R04.07.01.03-T13 Chart emailed QC results and flag Westgard rule violations
原始指令
The lab's daily QC results arrive as PDF tables attached to 30 emails. Enter the glucose control values into input/qc_glucose.xlsx, build a Levey-Jennings chart with mean and ±1/2/3 SD lines from input/qc_targets.csv, flag 1-3s, 2-2s and R-4s violations, and write output/qc_report.docx with the chart and violation list.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用vis· 视觉判断type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
Values equal key; chart series present with 7 reference lines at correct values; violation list equals rule-computed key (dates and rule codes); report contains chart image/chart part and the list. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
35% values; 25% chart lines; 25% violations; 15% report.
R04.07.01.03-T14 Score five vendors from a quarter of POs, deliveries and complaints
原始指令
From Outlook folders 'POs' and 'Deliveries' plus complaint emails in 'Quality' (Jul–Sep), build input/vendor_scorecard.xlsx: per vendor on-time delivery %, defect rate and average lead time; then generate 5 one-page Word reports from input/vendor_report.docx and a summary table ranking vendors.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用nav· 平移 / 缩放 / 滚动type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用long· 长流程- 提案难度
- 5 / 5
建议验证方式
Scorecard metrics equal key per vendor (0.1 pp / 0.1 day); 5 report files with values equal scorecard; ranking table order equals key. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
45% metrics; 35% five reports; 20% ranking.
R04.07.01.03-T15 Track data-room documents announced by email into a diligence memo
原始指令
Twenty data-room notification emails link to documents in the sandbox data room. Open each document, extract counterparty, term, change-of-control and termination clauses into input/dd_tracker.xlsx, and write output/dd_memo.docx summarizing contracts with change-of-control provisions and termination notice ≥90 days.
- 平台
web· 任意系统（网页）mac· macOSwin· Windows- 应用
- Outlook · Excel · Word · browsers
- 交互表面
brow· 浏览器desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
multi· 跨应用nav· 平移 / 缩放 / 滚动type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用long· 长流程- 提案难度
- 5 / 5
建议验证方式
Tracker fields equal key (yes/no flags exact, notice days exact); memo lists exactly the qualifying contracts (set match); no documents missed (20 rows). Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
20% all documents opened; 45% tracker fields; 35% memo set.
R04.07.01.03-T16 Rebuild an incident timeline from 200 alert emails across time zones
原始指令
Folder 'Alerts – INC-2291' holds 200 monitoring emails (duplicates, re-fires, mixed UTC/PDT/IST timestamps in bodies). Build input/inc2291_timeline.xlsx with deduplicated events in UTC, compute time to detect, acknowledge and resolve, and fill input/postmortem_template.docx timeline table and metrics.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用nav· 平移 / 缩放 / 滚动type· 文字与表单- 工作产物
WP01· 文档- 条件
multiapp· 多应用long· 长流程hidden· 隐藏 / 过期状态- 提案难度
- 5 / 5
建议验证方式
Timeline events equal key (dedupe precision/recall ≥0.95; UTC times exact to the minute); TTD/TTA/TTR equal key; postmortem table rows equal timeline. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
40% dedupe and UTC conversion; 25% metrics; 35% postmortem filled.
R04.07.01.03-T17 Control pair of T03: run the sales pipeline with Graph, pandas and python-docx
原始指令
Control pair of T03. Using the Microsoft Graph API (test tenant token), pandas and python-docx from the terminal, fetch the five 'W41 sales' CSV attachments, compute totals and WoW %, and fill the same report template with table and chart image.
- 平台
mac· macOSwin· Windowslin· Linux- 应用
- Graph API · pandas · python-docx
- 交互表面
api· API / SDKterm· 终端- GUI 需求 · 任务设定
AP· API 足够- GUI 需求 · 普通权限
AP· API 足够- 交互原语
code· 代码与命令- 工作产物
WP01· 文档- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Same value checks as T03 (chart may be an image here); compared with the GUI variant to measure modality gap.
建议部分得分
25% consolidation; 25% totals/WoW; 30% report table; 20% chart.
R04.07.01.03-T18 Track candidates from application emails into a weekly hiring report
原始指令
Shared mailbox 'jobs@' has 45 application emails for 3 roles with resumes attached and stage tags in later replies ('[Screen]', '[Onsite]', '[Offer]'). Build input/pipeline.xlsx (candidate, role, latest stage, source, days in stage) and write output/hiring_weekly.docx with counts per role × stage and the 5 longest-waiting candidates.
- 平台
mac· macOSwin· Windows- 应用
- Outlook · Excel · Word
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用nav· 平移 / 缩放 / 滚动type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用hidden· 隐藏 / 过期状态- 提案难度
- 4 / 5
建议验证方式
Tracker rows equal key (latest stage from thread replies); days in stage as of 2026-10-14; report counts and longest-waiting list equal key. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
45% tracker; 15% days in stage; 25% count table; 15% longest-waiting list.
R04.07.01.03-T19 Summarize newsletter sign-up emails in Google Sheets and Docs
原始指令
In the test Gmail account, 60 'New sign-up' notification emails list name, email, city and interests. Put them in Google Sheet 'Signups Oct' (dedupe by email), add a count-by-city table, and write Google Doc 'Signup summary' with total unique sign-ups and the top 3 interests with counts.
- 平台
web· 任意系统（网页）- 应用
- Gmail · Google Sheets · Google Docs
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
multi· 跨应用type· 文字与表单click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Sheets API: unique rows equal key (52); city counts table correct; Docs API: summary contains total 52 and top-3 interests with counts; no emails sent or deleted. Agent has no IMAP/API credentials; mail is reachable only through the webmail UI.
建议部分得分
45% sheet rows; 20% city table; 35% summary doc.
R04.07.01.03-T20 Merge results letters to PDFs and stage them as email drafts
原始指令
Using input/assessment_results.xlsx (24 candidates), mail-merge input/result_letter.docx into one PDF per candidate named output/letters/<CandidateID>.pdf, then create an Outlook draft to each candidate's email with their PDF attached and subject 'Assessment result – <ID>'. Do not send.
- 平台
win· Windowsmac· macOS- 应用
- Word · Excel · Outlook
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
multi· 跨应用click· 指向与点击type· 文字与表单- 工作产物
WP09· 文件与文件夹- 条件
multiapp· 多应用risk· 高风险 / 不可逆- 提案难度
- 4 / 5
建议验证方式
24 PDFs with correct names and merged text equal key; IMAP Drafts has 24 messages, each to the right address with the matching PDF attached (hash) and exact subject; Sent unchanged. Agent VM has no Graph/IMAP credentials, scripting host or VBA; mail is reachable only through the client UI.
建议部分得分
40% PDFs correct; 40% drafts with right attachments; 20% nothing sent.
已有研究映射
以下沿用研究目录中的基准与小类映射，不是逐题标注、执行记录或产品背书。