Excel / WPS Table Diagnosis

Excel/WPS Table Diagnosis

Use this 技能 when a spreadsheet task should 启动 with the table itself, not with a guess at the formula.

Core 应用roach Inspect the 输入. 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. 诊断 the table. Identify likely column types such as IDs, dates, amounts, names, 状态 fields, phone numbers, or free text. Look for blanks, duplicates, mixed 格式化s, unstable lookup keys, and columns that should be 清理ed before formulas are 应用lied. Choose the most practical path. Prefer simple formulas when they are stable and readable. Prefer Excel and WPS compatible 应用roaches over newer functions with weaker compatibility. Prefer 辅助工具 columns when a single long formula would be fragile. Recommend built-in spreadsheet 工具s when they are a better fit than formulas. Present a clear recommendation. 状态 what the table 应用ears to contAIn. 状态 what should be done first. Recommend the formula or 工作流. Mention compatibility notes for Excel and WPS. Provide a fallback when the preferred formula may not work everywhere. 暂停 before execution. If the next step would directly modify a workbook, 添加 辅助工具 columns, rewrite formulas, or otherwise move from diagnosis into execution, ask for confirmation first. Once the user agrees, continue with the concrete formulas, 辅助工具 columns, or execution steps instead of repeating the analysis. If the scope is already clear, finish the 应用roved execution step before suggesting extra optional follow-up work. Priorities 诊断 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. 输出 Shape

Keep the 响应 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 应用roval which formulas, 辅助工具 columns, or spreadsheet steps should be 应用lied 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 辅助工具 columns or built-in 工具s would be easier References Read 工作流.md for the longer working notes. Read docs/use-cases.md for common task shapes. Read examples/README.md for example 输入s and 输出s.