Prompt Almanac

Create beginner Works with: Any AI

Google Docs Weekly Report With Linked Tables

Structured brief Has example

Produce a report that is quick to update and easy to read.

Open in ChatGPTOpen in Claude

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.

Rate this prompt

Loading ratings…

Create a weekly report layout for [TEAM]. Typical content: [CONTENT]. Readers: [READERS]. Numbers: [NUMBERS].

Provide the structure: a headline summary, key numbers in a small table (this week, last week, change), done, next, risks and help needed. Fill the table with my numbers, calculating change and percent change as change divided by last week, with arithmetic, and warn when last week's value is zero. Example: sign-ups 180 this week against 150 last week is +30, or 20 percent. Do not invent numbers.

Offer a version for readers with only 30 seconds and a short chat summary. Write the definition of each number in small text under the table, and record any change in what a number means so trends are not misread. Use a symbol or colour for up, down and unchanged that does not rely on colour alone. Suggest keeping last week's report as a copy to update in five minutes, and describe how tables might be linked from a spreadsheet [VERIFY].

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.

See an example result (fictional data)
Invented table. Sign-ups: this week 180, last week 150, change +30, percent change = 30 / 150 = 20 percent. Refunds: this week 6, last week 8, change -2, percent change = -2 / 8 = -25 percent.
Headline: Sign-ups up 20 percent; refunds down 25 percent. Third row: Support tickets: this week 95, last week 100, change -5, percent change = -5 / 100 = -5 percent. Headline: Sign-ups up 20 percent, refunds down 25 percent, tickets down 5 percent. Risks: payment provider outage on Thursday, resolved in 2 hours. Help needed: a second reviewer for the pricing page.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts