Cleargrain DocsSpreadsheets · Instructions · ResearchStart a project
Menu
Need help using this site?

You do not need technical words to get started. Describe what is difficult and what you want to make easier. You can send a short inquiry without an account.

  1. Browse services and prices, or go straight to tell me what you need.
  2. Examples include a real public-data cleanup and clearly labeled fictional work. You can read them without downloading anything.
  3. Use Client Login for private requests, files and project review. Start with the no-account inquiry form; no files are needed.

Have a complex or technical project? Describe it here. The listed packages are starting points. Larger spreadsheets are welcome; feasibility, size and complexity are reviewed before agreeing a custom scope and price.

What do the file types and technical terms mean?
PDF
A document you can read in a browser or PDF reader.
XLSX
An Excel workbook. Open it in a spreadsheet app to inspect the full example.
CSV
A plain spreadsheet file. Open it in a spreadsheet app to see rows and columns.
TXT
A plain-text checklist or template. Open it in a text editor or copy its text.
SOP or procedure
Step-by-step instructions for a task.
CRM
An app used to organize customer or contact records.
Workflow
The steps that move a task from start to finish.

To download a file, select its download link. It may open in your browser or appear in Downloads. If the browser asks, choose where to save it. A download is not a project order.

Real public data · A complete worked example

A recall register with products and events kept straight

All 1,617 product recall records remain searchable, linked to 575 FDA event IDs. A separate review view contains 80 event groups with at least one product not marked Terminated in the downloaded snapshot.

Download the prepared workbook (.xlsx)See the before-and-after

Independent public-data demonstration · Not paid client work · Source and limits below

1,617Product recall records
575FDA event groups represented
80Groups containing not-terminated products
188Not-terminated product records

This is a historical record-organization example, not a live recall alert or a basis for food-safety decisions. Check current official FDA notices before acting.

The practical question

How can a supplier-review team inspect related food recall products together without deleting them as duplicates or combining incompatible package quantities?

The prepared workbook keeps a route back to the original records and includes the checks and open questions. It is a worked example you can inspect, not a claim of client savings or a live operational system.

  • Event register
  • Events to review
  • Status counts

What the work involved

From the source files to a usable result.

  1. Keep every product recall

    Recall number identifies the product-level record. Repeated event IDs link related products and are not treated as accidental duplicates.

  2. Build an event register

    Each event lists its product count, recall numbers, all observed statuses and classifications, and the report-date range in these 2025 reports.

  3. Make dates and text usable

    Parse compact dates and remove layout-only whitespace. Product wording, batch codes and original package quantities remain intact.

  4. Keep review status precise

    Products marked Completed are not silently treated as Terminated. Event groups show every product-level status, including mixed states.

  5. Avoid a false quantity total

    Cases, pounds, units and other package descriptions stay as supplied; no cross-unit total or invented conversion is produced.

Follow actual records

What changed, and why it matters.

The two columns show the same information before and after. New calculations, group labels and questions appear separately beneath them. “[blank]” marks an empty field; the explanation says why. The full source records and the complete change log are included in the downloads.

Example 1

Related products become one inspectable group

Before · source information

FDA event number
96869
Product records
86
Example recall numbers
  • F-0896-2025
  • F-0898-2025
  • F-0857-2025
  • F-0872-2025

After · prepared information

FDA event number
96869
Product records
86
Example recall numbers
  • F-0896-2025
  • F-0898-2025
  • F-0857-2025
  • F-0872-2025

What changed or was added: One event-level overview links all the products; none are deleted as duplicates.

Added to make the record useful

Rows in the event overview
1

Example 2

Dates sort as calendar dates

Before · source information

Recall number
F-0317-2025
Report date
20250101

After · prepared information

Recall number
F-0317-2025
Report date
2025-01-01

What changed or was added: Compact source dates become a consistent date field that can be filtered by period.

Example 3

Missing dates stay missing

Before · source information

Recall number
F-0424-2025
Status
Ongoing
Termination date
[blank]

After · prepared information

Recall number
F-0424-2025
Status
Ongoing
Termination date
[blank]

What changed or was added: A date is not fabricated to make the register look complete.

Added to make the record useful

Review note
Contains product not marked Terminated

Example 4

Package units remain honest

Before · source information

Recall number
F-0315-2025
Published quantity
23,340 lbs.

After · prepared information

Recall number
F-0315-2025
Published quantity
23,340 lbs.

What changed or was added: A box count and a weight are not added together as if they were the same measure.

Added to make the record useful

How quantity is handled
Original units retained; not summed across products

Example 5

Source product text becomes filter-friendly

Before · source information

Recall number
H-0238-2025
Product description
1. OG2 BUNCH DILL

After · prepared information

Recall number
H-0238-2025
Product description
1. OG2 BUNCH DILL

What changed or was added: The source had two spaces after “1.”; the prepared text has one. The product words are unchanged. Removing repeated spaces makes consistent filtering easier.

Checks you can inspect

Every selected record is accounted for.

CheckResult
Records returned for 2025 report dates1,617
Original product records1,617
Prepared product records1,617
Distinct recall numbers1,617
Event groups in this excerpt575
Product records across all event groups1,617
Product records removed0
Products not marked Terminated188
Groups with products not marked Terminated80
Records whose recall began outside 2025 or has no start date175
Logged transformations7,550

These checks verify the preparation and grouping rules. They do not certify the underlying source, prove a business outcome or settle the questions listed for review.

Open the complete deliverables

Originals, prepared work and supporting checks.

Start with the prepared workbook. Compare it with the original workbook, or use the CSV files to inspect every row in another spreadsheet app.

The files contain public source data and independently prepared analysis. Native Microsoft Excel testing has not been performed.

Use the result in context

What this example does and does not establish.

  • Complete API result for report_date from January 1 through December 31, 2025, downloaded October 8, 2026; data last updated September 30, 2026.
  • This is a report-date cohort. Some recalls began before 2025, and an event may have additional products outside the selected report dates. Product counts describe these 2025 reports only.
  • Statuses and classifications are the FDA values in the download. Not Terminated includes Ongoing and Completed; it is not a claim that every product is currently available or unsafe.
  • This is a historical data-preparation example, not a live recall alert, supplier certification, medical advice, or a basis for food-safety decisions. Verify current official notices before acting.
  • Original JSON and CSV preserve source control characters. The original Excel view writes those characters visibly as [U+0013] because XML cannot contain them; the cleaned text replaces them with spaces.
  • No affected-unit grand total is calculated because published quantities use incompatible or unspecified package units. No batch information or product records are dropped.

Source & reuse

Public evidence, clearly credited.

openFDA Food Enforcement Reports: report dates in 2025. Data provided by the U.S. Food and Drug Administration (openFDA), downloaded 8 October 2026. Independently reformatted and grouped for a public-data demonstration; no FDA endorsement.

Public domain / Creative Commons CC0 1.0 Universal

Prepared for this demonstration from the source downloaded 2026-10-08. Source details, transformations and limitations are included in the files.

Have work like this?

Larger files and more involved reports are welcome. The $125 spreadsheet starter is one defined offer; other work is quoted by size and complexity after review.

Ask about a project like thisBrowse the other examples
Help opening these files

Select a file link to open or download it. Check your browser’s downloads list or your device’s Downloads folder.

PDF: read it in your browser. XLSX or CSV: open it in a spreadsheet app. TXT: open it as plain text. You can read the example on this page without downloading anything.

If a file does not open, tell us the file name and what happened. Do not send private data in your first message.

Have a task in mind?

Start with the result you need.

Tell me what you need