Reports from tables

pacpio-team/reports-from-tables
Copy project link
Public
Anyone can see and download this project, even without signing in.
Owner: Pacpio Team Made by the Pacpio team
Made by the Pacpio team
Report

Use it with your AI

Works in Claude, ChatGPT or any other AI

  1. Step 1: Connect your AI

    Do it once. It takes a minute.

    Connect your AI

  2. Step 2: Ask your AI

    Paste this into your chat:

    What does the Pacpio project pacpio-team/reports-from-tables do?

Make a copy Sign in to get your own project to change. Download a copy All files in one ZIP. The copy doesn’t update by itself.

SKILL.md

1.4 KB · 27 lines
Copy the text
Download this file
name description
compare-periods Compares two periods or two tables, what grew and what fell, in numbers and shares; use for "compare September with August".

Compare periods

Use when: the user has two tables or two periods in one table and wants to see the change.

Input

The two tables or the two periods and the table that holds them. The metric and the breakdown from my/report-settings.md.

Steps

  1. Compute the headline numbers for each period separately, by knowledge/counting-rules.md, with the cross-check for each.
  2. Table: Metric | Period A | Period B | Change | Change %. Relative change from zero is "n/a".
  3. Breakdown shift: the share of each group in A and in B, and the change in points. Groups present in one period only go into "New" and "Gone".
  4. If the periods differ in length (28 days against 31), add a per-day line and say so.
  5. Save reports/compare-<a>-vs-<b>.md (note "Compare: vs ").
  6. Answer with the biggest increase, the biggest decrease and the total change, in one line each.

Output

The metric table, the breakdown shift, "New" and "Gone", "How this was counted" for both periods.

Edge cases

  • Different column sets: compare the common columns only and list the rest.
  • A category renamed between periods: ask whether to map it; show both versions until then.
  • The user wants three or more periods: a table with one column per period and the change between the last two.
---name: compare-periodsdescription: Compares two periods or two tables, what grew and what fell, in numbers and shares; use for "compare September with August".---# Compare periodsUse when: the user has two tables or two periods in one table and wants to see the change.## InputThe two tables or the two periods and the table that holds them. The metric and the breakdown from `my/report-settings.md`.## Steps1. Compute the headline numbers for each period separately, by `knowledge/counting-rules.md`, with the cross-check for each.2. Table: Metric | Period A | Period B | Change | Change %. Relative change from zero is "n/a".3. Breakdown shift: the share of each group in A and in B, and the change in points. Groups present in one period only go into "New" and "Gone".4. If the periods differ in length (28 days against 31), add a per-day line and say so.5. Save `reports/compare-<a>-vs-<b>.md` (note "Compare: <a> vs <b>").6. Answer with the biggest increase, the biggest decrease and the total change, in one line each.## OutputThe metric table, the breakdown shift, "New" and "Gone", "How this was counted" for both periods.## Edge cases- Different column sets: compare the common columns only and list the rest.- A category renamed between periods: ask whether to map it; show both versions until then.- The user wants three or more periods: a table with one column per period and the change between the last two.