name: excel-wps-table-diagnosis description: Diagnose spreadsheet structure and recommend practical Excel/WPS-compatible formulas and workflows for cleaning, lookup and matching, summarization, text and date cleanup, and common formula troubleshooting. Use when the user asks what formula to use, how to process a table, how to clean messy columns, how to match sheets, how to make a solution work in both Excel and WPS, or when headers and sample rows should be inspected before deciding what to do next.

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.

2. Identify whether the user provided headers, sample rows, CSV content, or only a task description.

3. If the structure is unclear, ask for the smallest missing detail that would change the recommendation.

4. Diagnose the table.

5. Identify likely column types such as IDs, dates, amounts, names, status fields, phone numbers, or free text.

6. Look for blanks, duplicates, mixed formats, unstable lookup keys, and columns that should be cleaned before formulas are applied.

7. Choose the most practical path.

8. Prefer simple formulas when they are stable and readable.

9. Prefer Excel and WPS compatible approaches over newer functions with weaker compatibility.
10. Prefer helper columns when a single long formula would be fragile.

11. Recommend built-in spreadsheet tools when they are a better fit than formulas.

12. Present a clear recommendation.

13. State what the table appears to contain.

14. State what should be done first.
15. Recommend the formula or workflow.
16. Mention compatibility notes for Excel and WPS.

17. Provide a fallback when the preferred formula may not work everywhere.

18. Pause before execution.

19. 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.

20. Once the user agrees, continue with the concrete formulas, helper columns, or execution steps instead of repeating the analysis.
21. 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.

这个 Skill 质量中上，胜在思路清晰、文档规范。它教你「先看表再动手」的方法，处理表格清洗、匹配、汇总等常见问题很实用，还能兼顾 Excel 和 WPS 双平台。不足之处是它更像一份教程文档，实际可用的工具函数还比较欠缺，遇到复杂情况时帮助可能有限。