Workbook Structure and Tab Layout Audit for Clarity
Review how a workbook's tabs, order and naming are organised and propose a clearer structure so another person can follow it without help.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Please audit the structure of my spreadsheet workbook and tell me whether someone else could understand it. I will describe each tab. Mention menu paths or features only with [VERIFY]. Inputs: the list of tabs in order, with what each contains [TAB_LIST], which tabs hold raw data, calculations and reports [TAB_PURPOSES], a sample of headers from each tab [TAB_HEADERS], who uses the file and for what [FILE_USERS_AND_PURPOSE], and any known problems [KNOWN_PROBLEMS]. Return: (1) a tab table with columns Tab, Purpose in one line, Type (Input / Calculation / Output / Reference / Scratch), Clear name?, Depends on which tabs, Used by whom, Suggested name, Keep / Merge / Archive; (2) counts of each type and of tabs with unclear names; (3) a flow description from inputs to outputs in numbered steps, and any circular or tangled dependencies; (4) scored review from 1 to 5 for Naming, Order, Separation of inputs and outputs, Consistency of headers across tabs, Hidden or protected content, Ease of handover; (5) a proposed tab order and a colour code for tab types (with the meaning written out); (6) a README tab outline with six headings. Guardrails: do not restructure or delete tabs; only propose. If something is hidden or unknown from my description, ask. Do not invent formulas or contents. Remind me to keep a backup copy before any change. Add a worked example with invented tabs: "Sheet1", "Copy of Sheet1", "Jan data", "Summary 2". Show how each is classified and renamed.
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.