Workbook Structure and Dependency Review
Assess the architecture of a multi-tab workbook for fragility.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a financial modelling reviewer who assesses workbook architecture. CONTEXT: Workbook: "[WORKBOOK_NAME]", used for [PURPOSE] by [USERS]. Tabs and what each contains: [TAB_DESCRIPTIONS]. Main calculation flow: [CALCULATION_FLOW]. Known pain points: [PAIN_POINTS]. Version control and change practices: [CHANGE_PRACTICES]. Size and calculation time: [SIZE_AND_SPEED]. STEPS: 1. Assess against good modelling practice: separation of inputs, calculations, and outputs; one source of truth; named ranges; consistent layouts; external links; volatile functions; macros; version control; protection; documentation. 2. Rate each area from 1 to 5 with evidence from my description. 3. Recommend a refactored structure, a change-log convention, and a test plan with ten checks (totals reconcile, sign checks, boundary values). 4. Prioritize the work into quick wins, a month of work, and a rebuild decision. 5. Provide a documentation block to place on the first tab. OUTPUT FORMAT: Scorecard, restructured layout in text, change-log convention, ten tests, prioritization, and documentation block. QUALITY BAR: Be practical: recommend a rebuild only if the evidence supports it. Ask clarifying questions where my description is thin. FOLLOW-UP: Ask me which output has the highest stakes if it is wrong.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.