Nobody reads the weekly report? Have AI turn it into one page for Monday's meeting

How to do it

1. 1

   Decide which numbers to watch (one time only)

   Don't let AI decide this; it only suggests. You set the normal ranges.

   Prompt

   Expand ⌄Copy

   Below are all the fields in our weekly report and a short description of our company. Pick up to 7 metrics tied to a decision we make each week. For each, explain which decision it affects, who should act when it moves, and a reasonable normal range based on the history I gave you. Also flag metrics you'd drop, with one sentence each on why. [paste the report fields and the last 8 weeks of numbers]
2. 2

   Produce a one-page summary each week

   Upload in the same format every week so comparisons are fair.

   Prompt

   Expand ⌄Copy

   Attached is this week's KPI spreadsheet and the previous 8 weeks. For each metric, list this week's number, the 8-week average and the change. Flag anything outside these ranges: [list each metric and its normal range]. Then write a one-page summary in plain language: the 3 most important changes, possible causes based only on the data, and 3 questions for Monday's meeting. Don't invent causes; if the data can't explain something, say so.
3. 3

   If needed, make 5 short slides

   For teammates who won't open a spreadsheet.

   Prompt

   Expand ⌄Copy

   Using only the summary above, make 5 short slides for Monday's meeting. One point per slide, large text. Numbers must match the data exactly and say which week they're from. The last slide is one question the team needs to answer this week. Don't add numbers, targets or explanations that aren't in the summary.
4. 4

   Have it check itself before you share

   Then check a few numbers yourself. Managers explain causes; the summary just starts the discussion.

   Prompt

   Expand ⌄Copy

   Go back over the summary and slides you just made. Label which cell or row every number came from. List anything you rounded, estimated or couldn't read, and any claim that goes beyond what the data shows. Finally, give me 3 numbers I should check against the spreadsheet myself before sharing.