Create a tool that transforms an unfamiliar spreadsheet into a handoff-ready workbook that another person can understand, maintain, and safely update.
Allow users to upload supported Excel files and inspect available worksheets, formulas, named ranges, tables, validation rules, and formatting patterns.
Generate:
A workbook overview explaining each sheet's apparent purpose.
An input-versus-calculation-versus-output map.
A formula dependency diagram for supported formulas.
A list of hard-coded values inside calculation-heavy regions.
A glossary of important fields and named ranges.
A list of potentially fragile formulas and unexplained exceptions.
A step-by-step user guide for common workbook tasks.
A handoff checklist covering ownership, refresh procedures, assumptions, and known limitations.
Preserve the original workbook. Distinguish observable workbook structure from inferred business intent, and never claim that a formula is incorrect merely because it looks unusual. Provide a review interface for editing generated documentation and export a handoff report with references to specific sheets and cells.
0 Comments