Excel/WPS Table Diagnosis
Use this skill when a spreadsheet task should start with the table itself, not with a guess at the formula.
Core Approach
- 1. Inspect the input.
- - Identify whether the user provided headers, sample rows, CSV content, or only a task description.
- If the structure is unclear, ask for the smallest missing detail that would change the recommendation.
- 2. Diagnose the table.
- - Identify likely column types such as IDs, dates, amounts, names, status fields, phone numbers, or free text.
- Look for blanks, duplicates, mixed formats, unstable lookup keys, and columns that should be cleaned before formulas are applied.
- 3. Choose the most practical path.
- - Prefer simple formulas when they are stable and readable.
- Prefer Excel and WPS compatible approaches over newer functions with weaker compatibility.
- Prefer helper columns when a single long formula would be fragile.
- Recommend built-in spreadsheet tools when they are a better fit than formulas.
- 4. Present a clear recommendation.
- - State what the table appears to contain.
- State what should be done first.
- Recommend the formula or workflow.
- Mention compatibility notes for Excel and WPS.
- Provide a fallback when the preferred formula may not work everywhere.
- 5. Pause before execution.
- - If the next step would directly modify a workbook, add helper columns, rewrite formulas, or otherwise move from diagnosis into execution, ask for confirmation first.
- Once the user agrees, continue with the concrete formulas, helper columns, or execution steps instead of repeating the analysis.
- If the scope is already clear, finish the approved execution step before suggesting extra optional follow-up work.
Priorities
- - Diagnose before suggesting formulas.
- Prefer maintainability over cleverness.
- Treat compatibility as an early constraint.
- Do not force everything into one formula.
- Do not make direct spreadsheet changes without user confirmation.
Output Shape
Keep the response close to this shape:
Diagnosis
- - what the table likely contains
- what looks inconsistent or risky
Recommendation
- - what to do first
- which formula or method to use
Execution
- - what can be done immediately after approval
- which formulas, helper columns, or spreadsheet steps should be applied
Compatibility
- - whether it should work in Excel
- whether it should work in WPS
- what fallback to use if needed
Notes
- - where to place the formula
- whether helper columns or built-in tools would be easier
References
- - Read
WORKFLOW.md for the longer working notes. - Read
docs/use-cases.md for common task shapes. - Read
examples/README.md for example inputs and outputs.
Excel/WPS表格诊断
当电子表格任务应从表格本身而非猜测公式开始时，使用此技能。
核心方法
- 1. 检查输入。
- - 识别用户是否提供了表头、示例行、CSV内容，或仅提供了任务描述。
- 如果结构不清晰，询问会改变建议的最小缺失细节。
- 2. 诊断表格。
- - 识别可能的列类型，如ID、日期、金额、姓名、状态字段、电话号码或自由文本。
- 查找空白、重复、混合格式、不稳定的查找键，以及在应用公式前应清理的列。
- 3. 选择最实用的路径。
- - 在稳定且可读的情况下，优先使用简单公式。
- 优先选择Excel和WPS兼容的方法，而非兼容性较弱的新函数。
- 当单个长公式容易出错时，优先使用辅助列。
- 当内置电子表格工具比公式更合适时，推荐使用它们。
- 4. 提出清晰建议。
- - 说明表格可能包含的内容。
- 说明应首先执行的操作。
- 推荐公式或工作流程。
- 提及Excel和WPS的兼容性说明。
- 当首选公式可能无法在所有环境中使用时，提供备选方案。
- 5. 执行前暂停。
- - 如果下一步将直接修改工作簿、添加辅助列、重写公式，或以其他方式从诊断进入执行阶段，请先请求确认。
- 一旦用户同意，继续提供具体的公式、辅助列或执行步骤，而非重复分析。
- 如果范围已明确，在完成已批准的执行步骤后，再建议额外的可选后续工作。
优先级
- - 先诊断，再建议公式。
- 优先考虑可维护性而非技巧性。
- 将兼容性视为早期约束条件。
- 不要将所有内容强行塞入一个公式。
- 未经用户确认，不要直接修改电子表格。
输出格式
保持回复接近以下格式：
诊断
- - 表格可能包含的内容
- 看起来不一致或存在风险的内容
建议
执行
- - 批准后可立即执行的操作
- 应应用的公式、辅助列或电子表格步骤
兼容性
- - 是否应在Excel中工作
- 是否应在WPS中工作
- 如需使用，提供备选方案
备注
参考
- - 阅读WORKFLOW.md获取更详细的工作笔记。
- 阅读docs/use-cases.md了解常见任务类型。
- 阅读examples/README.md了解示例输入和输出。
