R04.03.01.05 · 任务小类

工作簿审计与错误追踪

Workbook auditing & error tracing

Find and fix broken references, circularity and wrong results in an inherited workbook.

20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。

典型应用: Excel · Google Sheets
小类 GUI 需求标签: HY · 混合

任务提案 · 20

展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。

R04.03.01.05-T01 Repair #REF! errors left by a deleted column in a summary sheet

原始指令

Someone deleted column D (Q2) from 'Data' in fixtures/region_summary.xlsx; 'Summary'!C4:F12 now shows #REF! in 3 formula patterns. Restore the formulas so Summary again sums Q1–Q4 from 'Data' using the restored layout in input/layout_note.txt. Do not hardcode values.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 2 / 5

建议验证方式

No error values on 'Summary' after Excel COM recalc; all target cells are formulas referencing 'Data'; values equal key; grader perturbs 'Data' and rechecks.

建议部分得分

30% no #REF! remains; 40% values correct; 30% formulas live under perturbation.

R04.03.01.05-T02 Explain and fix a dashboard total that misses appended rows

原始指令

In Google Sheet 'Membership dashboard', B4 (total dues) disagrees with the sum of 'Data'!F. Find the cause, fix the formula so future rows are included, and write the cause in one sentence in note cell B20 (e.g. 'SUM range ended at row 412').

平台: web · 任意系统（网页）
应用: Google Sheets
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 2 / 5

建议验证方式

Sheets API: B4 formula uses an open-ended range (F2:F or equivalent) and equals sum of F; grader appends 30 rows and rechecks; B20 contains the true last-row number (412) and 'range'/'row' keywords (regex).

建议部分得分

50% B4 correct now and after append; 30% cause identified with row number; 20% no other cells changed.

R04.03.01.05-T03 Remove an interest–cash circular reference by restructuring

原始指令

fixtures/project_finance.xlsx only computes with iterative calculation on, because interest depends on closing cash. Turn iteration off and restructure per input/modeling_rule.txt (interest on opening balance) so there is no circular reference; key outputs on 'Returns' must match the rule-based answer.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单 nav · 平移 / 缩放 / 滚动
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 3 / 5

建议验证方式

calcPr iterate off; grader's formula-graph analysis finds no cycles; Excel COM recalc 'Returns' IRR/NPV/min DSCR equal key (rel tol 1e-6); other sheets' input cells unchanged.

建议部分得分

25% iteration off; 35% cycle removed; 40% outputs equal key.

R04.03.01.05-T04 Find and fix eight seeded formula errors in a 5-year plan

原始指令

fixtures/five_year_plan.xlsx contains 8 seeded errors: hardcoded numbers inside formulas, a row whose formula breaks the pattern, wrong absolute anchors, and a sum skipping a row. Fix every error and log each in output/audit_log.csv (sheet, cell, issue_type, fix).

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 3 / 5

建议验证方式

Outputs on 'Summary' equal key after recalc; each seeded cell's formula is pattern-consistent (R1C1 equal to neighbors); audit_log precision/recall vs seeded list (cell match) ≥0.875 for full credit.

建议部分得分

50% errors fixed (pro-rata over 8); 30% audit log recall/precision; 20% outputs equal key.

R04.03.01.05-T05 Repoint and purge broken external links, including hidden ones

原始指令

fixtures/consol_q3.xlsx links to three files on an old server path. Repoint the two valid links to fixtures/sub_a.xlsx and fixtures/sub_b.xlsx, and remove the third (obsolete) link everywhere it hides: cells, named ranges, conditional formats, data validation and a chart series. Save.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 hover · 悬停与上下文 nav · 平移 / 缩放 / 滚动
工作产物: WP02 · 记录 / 表格
条件: hidden · 隐藏 / 过期状态
提案难度: 3 / 5

建议验证方式

externalLinks parts: exactly 2, targets the two local files; no reference to the obsolete file in names, CF, validation, chart XML or cells; Excel COM LinkSources lists 2; values after update equal key.

建议部分得分

30% two links repointed; 50% obsolete link removed from all 5 hiding places (pro-rata); 20% values correct.

R04.03.01.05-T06 Track down approximate-match VLOOKUPs returning wrong prices

原始指令

Quotes in fixtures/quote_builder.xlsx are wrong for some SKUs because several VLOOKUPs across 4 sheets omit the exact-match argument on an unsorted price list. Fix every affected lookup (exact match, keep the rest of the formula), and write the number of formulas fixed in 'Notes'!B2.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 3 / 5

建议验证方式

All VLOOKUP/HLOOKUP/MATCH calls into 'PriceList' use exact match; quote totals equal key; Notes!B2 equals the seeded count (37); no unrelated formulas changed (formula diff limited to the affected cells).

建议部分得分

50% affected lookups fixed (pro-rata); 25% quote totals correct; 15% count reported; 10% no collateral edits.

R04.03.01.05-T07 Fix a SUMIFS undercount caused by text numbers and trailing spaces

原始指令

In fixtures/commission_calc.xlsx, 'Payout'!C2:C30 undercounts sales for some reps. The formulas are right; the source data in 'Sales' has text-stored amounts and trailing spaces in rep names. Clean the data in place so payouts are correct, and leave the formulas untouched.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 vis · 视觉判断
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 3 / 5

建议验证方式

Payout formulas byte-identical to input; 'Sales' amounts numeric and names trimmed; payouts equal key after recalc; row count and order in 'Sales' unchanged.

建议部分得分

40% amounts converted; 30% names trimmed; 30% payouts correct with formulas untouched.

R04.03.01.05-T08 Trace a wrong KPI through six sheets to its single root cause

原始指令

fixtures/ops_kpis.xlsx 'KPI'!E7 (on-time rate) is wrong, but its precedent chain spans 6 sheets. Trace it, fix only the one root-cause cell, and write that cell's address (e.g. 'Calc_Lead'!H112) in output/root_cause.txt. Changing any other cell is penalized.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 hover · 悬停与上下文
工作产物: WP12 · 答案 / 决策
条件: 未声明
提案难度: 3 / 5

建议验证方式

root_cause.txt equals the seeded address; workbook diff shows exactly one changed cell (the root cause) with a formula consistent with its neighbors; KPI!E7 equals key after recalc.

建议部分得分

40% root cause identified; 40% KPI correct; 20% no other changes.

R04.03.01.05-T09 Neutralize a very-hidden override sheet that alters inputs

原始指令

Outputs in fixtures/pricing_model.xlsx ignore edits to 'Inputs' because a very-hidden sheet feeds overrides through IF formulas. Find it, remove its influence so 'Inputs' drives the model, keep the sheet for audit but make it visible and renamed 'OLD_Overrides', and save.

平台: win · Windows mac · macOS
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动
工作产物: WP02 · 记录 / 表格
条件: hidden · 隐藏 / 过期状态
提案难度: 3 / 5

建议验证方式

Sheet renamed and state visible; no formula outside it references it; grader changes 5 inputs and checks outputs follow the reference model; other sheets' formulas differ only where the overrides were removed.

建议部分得分

25% hidden sheet found and made visible/renamed; 45% override references removed; 30% outputs respond correctly to inputs.

R04.03.01.05-T10 Diff two model versions and revert the unintended changes

原始指令

Compare fixtures/model_v3.xlsx and fixtures/model_v4.xlsx (e.g. with Spreadsheet Compare). input/change_log.md lists the 6 intended changes. Revert every other changed formula or value in v4 back to v3, keep the intended ones, save output/model_v4_clean.xlsx and list reverted cells in output/reverted.csv.

平台: win · Windows
应用: Excel · Spreadsheet Compare
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 multi · 跨应用
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 4 / 5

建议验证方式

Cell-level diff of output vs v3 equals exactly the 6 intended changes; reverted.csv lists the 11 seeded unintended changes (precision/recall); outputs equal key.

建议部分得分

45% unintended changes reverted (pro-rata of 11); 25% intended changes kept; 30% reverted.csv accuracy.

R04.03.01.05-T11 Find five unit mismatches between $k and $ sheets

原始指令

fixtures/group_forecast.xlsx mixes sheets in $ and $k (the unit is in each sheet's A1). Five formulas combine values without converting. Fix them with explicit /1000 or *1000 factors referencing a named constant 'kFactor', so 'Group'!D20 matches the key.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 3 / 5

建议验证方式

Each of 5 seeded cells references kFactor and yields the right magnitude; named constant kFactor = 1000 exists; Group!D20 equals key (rel tol 1e-9); no other formula changes.

建议部分得分

60% five mismatches fixed (pro-rata); 15% kFactor name; 25% group total correct.

R04.03.01.05-T12 Clean up a Name Manager with broken and shadowed names

原始指令

fixtures/treasury_model.xlsx has 40 defined names; 9 refer to #REF!, and 6 sheet-scoped duplicates shadow workbook-level names with different ranges. Per input/names_spec.csv, fix or delete each broken name, remove the shadowing duplicates, and confirm all formulas still evaluate to the key.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 4 / 5

建议验证方式

definedNames equal names_spec.csv (name, scope, refersTo); no #REF! names; no sheet-scoped duplicate of a workbook name; all output cells equal key after recalc with no error values.

建议部分得分

35% broken names resolved; 30% shadowing removed; 35% outputs correct and error-free.

R04.03.01.05-T13 Fix QUERY formulas broken by an inserted source column

原始指令

In Google Sheet 'Grant reporting', a column was inserted in tab 'Raw' and 9 QUERY formulas across 3 report tabs now select the wrong columns (Col4 instead of Col5 and so on). Fix each QUERY so the reports again match input/expected_reports.xlsx.

平台: web · 任意系统（网页）
应用: Google Sheets
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 3 / 5

建议验证方式

Sheets API: 9 QUERY formulas reference the right column ids; report ranges equal expected_reports.xlsx; grader appends rows to 'Raw' and checks reports update.

建议部分得分

60% QUERY formulas fixed (pro-rata); 30% reports equal expected; 10% live after append.

R04.03.01.05-T14 Repair a frozen sensitivity data table

原始指令

The what-if data table in fixtures/npv_sensitivity.xlsx 'Sens'!B4:H12 shows the same NPV everywhere. Calculation is set to 'Automatic except data tables' and the row/column input cells are swapped. Fix both so the grid shows NPV by WACC (rows) and growth (columns), matching the key.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击
工作产物: WP02 · 记录 / 表格
条件: hidden · 隐藏 / 过期状态
提案难度: 4 / 5

建议验证方式

calcPr calcMode auto (not autoNoTable); TABLE formula r1/r2 reference the correct input cells; Excel COM recalc yields grid equal key (rel tol 1e-6).

建议部分得分

30% calc mode fixed; 40% input cells corrected; 30% grid values correct.

R04.03.01.05-T15 Audit an inherited 14-sheet LBO model with 15 seeded defects

原始指令

fixtures/lbo_inherited.xlsx (14 sheets) has 15 seeded defects of mixed type (sign errors, wrong period offsets, broken links, hardcodes, circularity, misapplied tax rate). Fix all of them and log each in output/audit_log.csv; outputs on 'Returns' must match the reference model within 0.01%.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 type · 文字与表单
工作产物: WP02 · 记录 / 表格
条件: long · 长流程
提案难度: 5 / 5

建议验证方式

Per seeded defect: cell(s) fixed (formula consistent with reference); 'Returns' IRR/MOIC/exit equity within 0.01%; audit_log precision/recall vs seeded list; no error values anywhere.

建议部分得分

45% defects fixed (pro-rata over 15); 25% outputs within tolerance; 20% audit log recall/precision; 10% no errors left.

R04.03.01.05-T16 Expose errors hidden by number formats on a client dashboard

原始指令

fixtures/client_dashboard.xlsx looks clean, but custom formats (';;;', '0;;0', white font, IFERROR(...,"")) hide 12 broken or negative results. Find every masked problem, fix the underlying formulas, remove masking formats, and list each in output/masked_issues.csv.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: vis · 视觉判断 click · 指向与点击 nav · 平移 / 缩放 / 滚动
工作产物: WP02 · 记录 / 表格
条件: hidden · 隐藏 / 过期状态
提案难度: 5 / 5

建议验证方式

12 seeded cells: formulas fixed and values equal key; masking formats removed from them; masked_issues.csv precision/recall; dashboard render (Excel COM PNG) vs reference SSIM ≥0.9 with corrected values visible. VBA, COM and AppleScript automation disabled, no Python in the VM; file must be saved by Excel (app.xml).

建议部分得分

50% masked issues fixed (pro-rata over 12); 20% masks removed; 20% issues list; 10% render match.

R04.03.01.05-T17 Find the edit that broke a shared budget in version history

原始指令

In Google Sheet 'Dept budget FY26' (shared with 4 test editors), 'Total'!D9 changed last week and is now wrong. Use version history to find which edit introduced the error, restore only that cell's previous formula, and write the editor's name and the edit timestamp in 'Notes'!A1.

平台: web · 任意系统（网页）
应用: Google Sheets
交互表面: brow · 浏览器
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 vis · 视觉判断
工作产物: WP12 · 答案 / 决策
条件: hidden · 隐藏 / 过期状态
提案难度: 5 / 5

建议验证方式

Sheets API: the seeded cell's formula equals the pre-error version and Total!D9 equals key; no other cells differ from current version except Notes!A1; Notes!A1 contains the seeded editor name and the timestamp within ±1 minute.

建议部分得分

40% correct edit identified (name + time); 40% cell restored; 20% no other changes and no full-version restore.

R04.03.01.05-T18 Control pair of T04: detect seeded errors with a formula-graph script

原始指令

Control pair of T04. On fixtures/five_year_plan.xlsx, use a Python formula library (openpyxl plus formulas or pycel) from the terminal to detect inconsistent row formulas, hardcoded constants in formulas and sums that skip rows, and write output/audit_log.csv in the same schema. No fixing required.

平台: mac · macOS win · Windows lin · Linux
应用: openpyxl · pycel
交互表面: term · 终端
GUI 需求 · 任务设定: CL · CLI 足够
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: code · 代码与命令
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 2 / 5

建议验证方式

audit_log.csv precision/recall vs the 8 seeded defects (cell match); compared against T04 to measure CLI vs GUI detection.

建议部分得分

60% recall (pro-rata over 8 defects); 40% precision.

R04.03.01.05-T19 Undo implicit-intersection '@' changes after a legacy array migration

原始指令

After fixtures/allocations_legacy.xlsx was opened in Excel 365, legacy CSE arrays became single-cell formulas with '@' and some produce #SPILL! or truncated results. Restore the intended results: convert to dynamic arrays where the output should spill, keep '@' only where single values were intended (per input/intent.md).

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单 vis · 视觉判断
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 4 / 5

建议验证方式

No #SPILL!/#CALC! after recalc; spill ranges equal intended shapes; values equal key; '@' remains only in the cells listed as single-value in intent.md.

建议部分得分

40% spill errors resolved; 35% values correct; 25% '@' usage matches intent.

R04.03.01.05-T20 Fix dates shifted by the 1904 date system after a cross-platform copy

原始指令

fixtures/contracts_merged.xlsx was assembled from a Mac workbook using the 1904 date system and a Windows one using 1900; pasted dates on 'Renewals' are off by 4 years and 1 day, and IF(A=B) checks fail on float amounts. Correct the shifted dates and make equality checks rounding-safe so 'Alerts' match the key.

平台: mac · macOS win · Windows
应用: Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: HY · 混合
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 type · 文字与表单 vis · 视觉判断
工作产物: WP02 · 记录 / 表格
条件: 未声明
提案难度: 4 / 5

建议验证方式

Shifted date cells equal key dates (only seeded rows changed); workbook date1904 flag per spec; equality checks use ROUND or tolerance; 'Alerts' column equals key after recalc.

建议部分得分

45% shifted dates corrected (pro-rata); 25% unaffected dates unchanged; 30% alerts correct with rounding-safe checks.

已有研究映射

以下沿用研究目录中的基准与小类映射，不是逐题标注、执行记录或产品背书。

SpreadsheetBench (V2)

工作簿审计与错误追踪

任务提案 · 20

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

已有研究映射

同工作流族的小类