Audit intermediate Works with: Any AI

Google Slides Linked Data Freshness Audit

Table output Has example

Check that charts and numbers match the current data.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Check whether numbers in my Google Slides deck are current. Slide numbers and chart values: [SLIDE_NUMBERS]. Current source values from the Sheet: [SOURCE_VALUES]. Date of the deck and of the data: [DATES]. Which charts are linked and which are pasted pictures: [LINKED_OR_PASTED].

Compare each value, show the difference and the arithmetic as (slide value minus source value) divided by source value, and flag stale or mismatched numbers. Example: slide revenue 4.2 million against 4.5 million in the sheet is (4.2 - 4.5) / 4.5 = -6.7 percent. Explain how you decided whether a mismatch matters: 0.1 percent from rounding is not the same as a different definition of the metric, and say when a number cannot be compared because the definition differs. Check whether slide titles still match the numbers. Show the date of each source.

Return a table with the count of mismatches and the largest difference in percent, the slides in order of problem size, and a refresh plan stating who updates, by when, and how the update is recorded with the data date on each chart.

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 check. Slide 3 shows revenue 4.2 million; sheet now shows 4.5 million. Difference = (4.2 - 4.5) / 4.5 = -6.7 percent. Slide 5 shows 1,200 customers; sheet 1,200. Match. Mismatches: 1 of 6 numbers. Full list: slide 3 revenue (mismatch -6.7 percent), slide 5 customers (match), slide 6 churn 4.1 percent against 4.1 percent (match), slide 7 margin 31 percent against 29 percent (mismatch of 2 points), slide 8 headcount (match), slide 9 satisfaction 4.3 against 4.3 (match). Mismatches: 2 of 6, which is 33.3 percent. Action: update the two charts and add the data date to each.

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

Related prompts