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.

    小蔥技能站7w4.net每天更新，海量AI技能等你發現。

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 雙平臺。不足之處是它更像一份教程文件，實際可用的工具函式還比較欠缺，遇到複雜情況時幫助可能有限。