GratisAI business · keep still-open order cohorts out of a settled return-rate denominator · local-first FREE TIER 1 Free Run Available
mature-cohort register · bound register page

Keep Still-Open Order Cohorts Out of a Settled Return-Rate Denominator

Fresh deliveries have had less time to produce returns. Keep their early observations visible but separate from an explicitly matured denominator before presenting a settled return rate to an operations team.

1 · Delivery cohort | age in whole days | delivered units | returned units observed

FIRST-LOAD

HYPOTHESIS / PROTOTYPE — checkout unavailable. Calculation is local. A draft is saved automatically in this browser profile when storage is available; Reset to sample clears it. Optional Pro history stores only five summaries and has its own deletion control. State links encode your inputs and can remain in browser history, clipboard or recipients’ records; share only non-sensitive rows. Optional external AI formatting leaves this device. The required site analytics beacon reports page activity; shared URLs contain encoded inputs. Do not treat an encoded URL as private. The calculator has no input-collection endpoint.

Data note: The mature-cohort register processes Delivery cohort | age in whole days | delivered units | returned units observed locally. Starter/sample selection and Run compute in this tab; no input is sent by the calculator. A local draft may be saved; explicit state-link sharing or optional external AI formatting can disclose inputs. Use non-sensitive labels.

Perspective: Before: fresh deliveries diluted a supposedly settled percentage. After: mature counts and still-open observations have separate denominators.

2 · Read the mature-cohort register

Reporting arithmetic only, not a forecast, return-rights interpretation or proof of complete data. Ask the operations owner to confirm cohort definitions, reporting delays and the count basis before publishing or comparing this statistic.

Optional filing controls are a local prototype.

Checkout is unavailable. The reading above is complete; print, CSV and five local summaries are optional enhancements, not hidden answers.

Before using the mature-cohort register

Choose and document an observation window appropriate to the question, not a window that makes the result look favorable. The sample thirty days is a hypothetical reporting convention, not a customer-rights deadline. Use delivered units as the count basis and apply it consistently: units, orders and customers are not interchangeable. Age is measured from the cohort's defined delivery date to one common reporting date. Returns are observed returned units from that same cohort and cannot exceed delivered units. Exclusions affect both sides of the settled rate. Reporting delays, exchanges, partial orders and later returns can still limit interpretation; reaching the chosen window does not establish that every eventual event has been captured.

Boundary and sources

Reporting arithmetic only, not a forecast, return-rights interpretation or proof of complete data. Ask the operations owner to confirm cohort definitions, reporting delays and the count basis before publishing or comparing this statistic.

Mechanism: competence-autonomy-loop

Optional AI formatting, never the calculation

Manual entry completes this mature-cohort register for free without signup. If available to you, the free AI Studio interface linked in the sources may format fictional or non-sensitive notes; external access may require an account. No API key or AI call is built into this tool. Free-tier content may be used to improve products. Review each cell and transcribe it to the labeled row schema; do not paste the JSON object into the row box.

Format only these fictional or non-sensitive notes for a mature-cohort register. Return strict JSON shaped as {"rows": [{"label": "string", "cells": ["string", "string", "string"]}], "setting": "string"}. The columns are Delivery cohort | age in whole days | delivered units | returned units observed; the setting is Supplied observation-maturity window (days). Keep all supplied strings and quantities exactly; do not calculate, infer missing entries, invent dates or add advice. If any required value is missing, return an empty rows array and ask me for it separately. I will verify every cell against my source and manually transcribe rows using vertical bars before running the local calculator.

An AI response is not executed, fetched or trusted as a result. Missing values remain questions; the strict local parser checks the rows you actually enter.