Excel wps table diagnosis
Read table structure first, then suggest reliable Excel/WPS formulas and cleanup workflows. 一个面向 Excel 和 WPS 的表格诊断与公式建议项目，重点处理清洗、匹配、汇总和兼容写法。
npx -y skills add winstonice-prog/excel-wps-table-diagnosisAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
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.
SKILL.md
3.2 KB, as published. Nobody here has run it
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
- 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.
- 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.
- 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.
- 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.
- 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.mdfor the longer working notes. - Read
docs/use-cases.mdfor common task shapes. - Read
examples/README.mdfor example inputs and outputs.