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.

report-example.md

1.6 KB · 31 lines
Copy the text
Download this file

Example: report

Input

data/sales-2026-09.csv, 20 rows, columns date, category, amount (euro). Categories: Coffee (8 rows, sum 92.00), Pastry (6 rows, sum 32.00), Beans (6 rows, sum 340.00, one row of 240.00 where the other bean orders are between 18.00 and 22.00). Settings: euro, two decimals, breakdown by category, the reader is the owner.

Result (reports/2026-09-sales.md, shortened)

Headline numbers

  • Total sales: 464.00 €
  • Number of orders: 20
  • Average per order: 23.20 €; median 11.75 €. Trust the median: one order of 240.00 € pulls the average up.

Breakdown by category

Category Sales Share of total Orders
Beans 340.00 € 73.3% 6
Coffee 92.00 € 19.8% 8
Pastry 32.00 € 6.9% 6
Total 464.00 € 100% 20

Anomalies

  • Row 14, Beans, 240.00 €: ten times the other bean orders (18.00 to 22.00 €). Check: the receipt for that day; if it is 24.00 €, total sales are 248.00 € and Beans fall to 50.0% of the total.

Data notes

  • No empty cells, no duplicates. No previous month in the project, so no comparison.

How this was counted

  • Sales: column amount, all 20 rows. Groups: 340.00 + 92.00 + 32.00 = 464.00; column total 464.00. Rows: 6 + 8 + 6 = 20.
  • Shares: group sum divided by 464.00, rounded to one decimal; 73.3 + 19.8 + 6.9 = 100.0.
  • Median: the 10th and 11th values of the sorted amounts, 11.50 and 12.00, average 11.75.

Chat answer: "September: 464.00 € in 20 orders, median order 11.75 €. Beans are 73% of sales, but one 240.00 € order needs a check. Saved to reports/2026-09-sales.md."

# Example: report## Input`data/sales-2026-09.csv`, 20 rows, columns date, category, amount (euro). Categories: Coffee (8 rows, sum 92.00), Pastry (6 rows, sum 32.00), Beans (6 rows, sum 340.00, one row of 240.00 where the other bean orders are between 18.00 and 22.00). Settings: euro, two decimals, breakdown by category, the reader is the owner.## Result (reports/2026-09-sales.md, shortened)Headline numbers- Total sales: 464.00 €- Number of orders: 20- Average per order: 23.20 €; median 11.75 €. Trust the median: one order of 240.00 € pulls the average up.Breakdown by category| Category | Sales | Share of total | Orders ||---|---|---|---|| Beans | 340.00 € | 73.3% | 6 || Coffee | 92.00 € | 19.8% | 8 || Pastry | 32.00 € | 6.9% | 6 || Total | 464.00 € | 100% | 20 |Anomalies- Row 14, Beans, 240.00 €: ten times the other bean orders (18.00 to 22.00 €). Check: the receipt for that day; if it is 24.00 €, total sales are 248.00 € and Beans fall to 50.0% of the total.Data notes- No empty cells, no duplicates. No previous month in the project, so no comparison.How this was counted- Sales: column amount, all 20 rows. Groups: 340.00 + 92.00 + 32.00 = 464.00; column total 464.00. Rows: 6 + 8 + 6 = 20.- Shares: group sum divided by 464.00, rounded to one decimal; 73.3 + 19.8 + 6.9 = 100.0.- Median: the 10th and 11th values of the sorted amounts, 11.50 and 12.00, average 11.75.Chat answer: "September: 464.00 € in 20 orders, median order 11.75 €. Beans are 73% of sales, but one 240.00 € order needs a check. Saved to reports/2026-09-sales.md."