Tramevia

Service · Data and automation

Less spreadsheet. More answers.

Do you spend hours sorting, cleaning and adding up the same files every month? I build dashboards that answer your questions and scripts that prepare your files for you, installed on your side, with no subscription.

For
Freelancers and small businesses who live in Excel
Delivered
Dashboard or script, source files, user guide
Data
CSV, Excel, exports from your software
Quote
Free, based on an anonymised sample
From
€490 (automation), €790 (dashboard), VAT not applicable
Pulse dashboard: revenue, margin and fictional sales of a coffee roaster over twelve months
Pulse · demonstration dashboard, fictional dataSee the examples ↓

01 · Two needs

See clearly, and stop starting over.

The numbers are often already there: a billing export, a spreadsheet, a file from a supplier. What is missing is a quick read, and a way to stop repeating the same manual steps.

1

See what matters

A dashboard: indicators, filters, chart and export.

2

Stop copy-pasting

A script: cleaning, matching, formatting and an anomaly report.

3

Stay in control

Your files stay with you and doubtful cases are flagged to you.

02 · Dashboard

Your numbers, in one view.

  1. 01

    The right indicators

    Chosen with you, around the decisions you actually make.

  2. 02

    Useful filters

    An activity, a period, a client: everything recalculates together.

  3. 03

    Checked figures

    Reconciled with your reference totals before delivery.

  4. 04

    Gaps stay visible

    A missing value is flagged, never turned into a misleading total.

  5. 05

    Readable on a phone

    Indicators first, then filters and chart.

  6. 06

    Simple updates

    Drop in the new file, refresh: a one-page guide explains it.

Pulse filtered on one activity and three months, indicators recalculated

One filter changes, everything follows. Fictional data.

03 · Automation

The same file, clean, every time.

  • Dates, amounts and labels brought to one format.
  • Duplicates removed, files matched, columns reorganised.
  • Doubtful rows listed separately with the reason: you decide.
  • A script you can run again, or a one-off cleanup for a single need.

Example made with fictional data.

Sample CSV file before and after cleaning: dates normalised, duplicate removed, missing statuses flagged

Before and after: the same file, usable. Fictional data.

04 · The assistants, on film

Every answer shows where it comes from.

Four demonstration assistants, working on fictional documents and figures. One rule for all four: every result shows where it comes from. Everything is calculated in the page; nothing is sent.

Product film · 24 s · Prototype interface · Fictional data · Ambient music, muted by defaultTry the assistants (in French) ↗
Read the film description

00:00 — Your files. Four fictional files float around one sentence: “The answer is in your files.” A contract, a quote, an inbox and a sales export.

00:03 — Documents. The files become the four tabs of the application. Asked “What is the withdrawal period?”, the assistant answers “14 days from signing the quote” and cites its source: article 4 of Atelier Forma’s maintenance contract, which lights up.

00:07 — Quotes. The “Dashboard” service is chosen and the “One-hour training” option is ticked: the line is added to the quote, the total goes from €1,290 to €1,410 and the 30% deposit to €423.

00:11 — E-mails. Six fictional e-mails are sorted: ongoing project, quote request, support, billing, partnership, junk. Sophie Arnal’s message is filed under “Support” because it contains “error”, “shows an error” and “500”; a reply is suggested and nothing is sent.

00:16 — Report. A file of 48 fictional sales is dropped in: €54,773.70 in total and a chart by month. The June peak is traced to row 32, an amount of €18,900 far above the average: the report flags it, along with an empty cell.

00:21 — Tramevia. End card: “Assistants built on your rules”, tramevia.com.

05 · Examples to try

Three prototypes to play with.

Fictional data, working tools. The Pulse and Orbit case studies explain the choices.

Pulse dashboard
Pulse · activity dashboard
Orbit business tool
Orbit · sorting and tracking enquiries
Document assistant: an answer with its source in a fictional contract
Assistants · documents, quotes, e-mails, reports (in French)

06 · Frequently asked questions

Before you send me your files.

Q

Does my data stay with me?

Yes. I work from an anonymised sample, and the delivered tool runs on your computer or your hosting. Nothing is sent to a third-party service.

Q

Which tools do you use?

Dashboards open in your browser with nothing to install. Scripts are written in Python, with a one-page install guide and a single command to run.

Q

My files are messy. Is that a problem?

It is the most common case. Cleaning is part of the work, and ambiguous rows are listed for you rather than guessed.

Q

Is there a subscription?

No. You receive the source files and the tool is yours. Any later change is quoted separately, if you need it.

Q

How much does it cost?

It depends on the number of files, rules and indicators. The price is set in a free quote, based on an anonymised sample.