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 vehicle catalog that compares like with like

All 2,550 EPA IDs are retained. The catalog identifies 16 rows for source review, protects 441 additional same-name source configurations, and produces 35 2025 BEV configurations at or below 30 kWh/100 miles.

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

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

2,550vehicle configurations retained
3,723electricity/charging placeholder-zero cells clarified
441extra same-name configurations preserved
16records flagged for source review

Battery-electric vehicles are shortened to BEVs in the files. MPG and MPGe are different measures; the catalog keeps their units and fuel modes clear. The filter is a worked example, not a vehicle recommendation.

The practical question

How can a product-comparison catalog separate fuel and measurement semantics without losing valid configurations, and which 2025 battery-electric vehicle (BEV) configurations meet a stated electricity-consumption filter?

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.

  • 2025 battery-electric vehicle (BEV) filter result at or below 30 kWh/100 miles
  • Every normalized field, source lineage and meaning

What the work involved

From the source files to a usable result.

  1. Freeze official evidence

    Save the original ZIP, uncompressed CSV, verified source URLs and SHA-256 hashes.

  2. Keep each vehicle version

    Filter to 2024–2025; use EPA vehicle ID as key. Do not deduplicate legitimate engine, transmission or other configurations.

  3. Separate fuel and units

    Retain source labels and fuel grades; add technology groups and MPG/MPGe labels. Keep plug-in hybrid (PHEV) fuel modes and composite values distinct.

  4. Interpret blanks and unavailable-value codes

    Replace only rule-supported placeholder-zero cells and -1 unavailable codes with null/status pairs. Preserve actual zero tailpipe emissions.

  5. Mark unclear values for review

    Flag multi-valued ranges, charging/classification conflicts and hydrogen schema ambiguity. Retain source values and avoid guesses.

  6. Deliver a usable comparison

    Export a filterable catalog, 2025 BEV comparison, change log, exception list and reconciled workbooks.

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 · Source ID 46636

A zero-hour charge is not a feature

Before · source information

Source fuel type
Premium
Charging time (hours)
0.0
Electricity use (kWh/100 miles)
0.0

After · prepared information

Source fuel type
Premium
Charging time (hours)
[blank]
Electricity use (kWh/100 miles)
[blank]

What changed or was added: The gasoline GR Supra has no plug-in classification. Placeholder zeros become unavailable numeric cells with an explicit not-applicable status.

Added to make the record useful

Vehicle type used in the catalog
Gasoline (no advanced type stated)
Charging information status
Not applicable to this vehicle

Example 2 · Source ID 48764

Add the correct unit, preserve real zero emissions

Before · source information

Model
Model 3 Long Range AWD
Primary fuel-economy figure
128
Tailpipe CO₂ (grams/mile)
0

After · prepared information

Model
Model 3 Long Range AWD
Primary fuel-economy figure
128
Tailpipe CO₂ (grams/mile)
0

What changed or was added: The Tesla battery-electric record is labeled MPGe. Its genuine zero tailpipe CO2 stays zero; this says nothing about lifecycle emissions.

Added to make the record useful

Measurement unit
MPGe

Example 3 · Source ID 47274

Separate two fuel modes

Before · source information

Source fuel type
Regular Gas and Electricity
Primary fuel-economy figure
29
Alternate fuel-economy figure
77
Combined figure
47

After · prepared information

Source fuel type
Regular Gas and Electricity
Primary fuel-economy figure
29 MPG (gasoline)
Alternate fuel-economy figure
77 MPGe (charge-depleting / blended)
Combined figure
47 MPGe (EPA composite)

What changed or was added: The Tonale plug-in hybrid keeps gas, blended charge-depleting and composite figures separate instead of publishing one ambiguous MPG column.

Example 4 · Source ID 46811

Do not average an unresolved range

Before · source information

Alternate-fuel range (miles)
312/368

After · prepared information

Alternate-fuel range (miles)
[blank]

What changed or was added: The Silverado E85 range cell contains two values. Both remain visible; no arbitrary value or average is invented.

Added to make the record useful

Original range text kept for checking
312/368
Status
Needs review: more than one source value

Example 5 · Source ID 48452

Flag a conflict instead of inventing a correction

Before · source information

Model
Revuelto
Vehicle type in source
Hybrid
Charging time (hours)
2.0
Electricity use (kWh/100 miles)
0.0

After · prepared information

Model
Revuelto
Vehicle type in source
Hybrid
Charging time (hours)
2
Electricity use (kWh/100 miles)
[blank]

What changed or was added: The source calls the vehicle Hybrid but reports a two-hour charge. The measurement is retained, the conflict is flagged, and the technology is not silently changed.

Added to make the record useful

Charging information status
Needs review: vehicle type and charging information conflict
Review status
Review

Example 6 · Source ID 46636|46761|46762

Preserve legitimate configurations

Before · source information

Vehicle name
2024 Toyota GR Supra
Source records
3

After · prepared information

Vehicle name
2024 Toyota GR Supra
Source records
3

What changed or was added: Three same-name records differ by engine/transmission. EPA IDs remain the keys; deduplicating by year, make and model would lose two valid configurations.

Added to make the record useful

EPA record numbers
  • 46636
  • 46761
  • 46762
Engine sizes (litres)
  • 2
  • 3
  • 3
Transmissions
  • Automatic (S8)
  • Automatic (S8)
  • Manual 6-spd
Combined MPG for each configuration
  • 27
  • 26
  • 21

Checks you can inspect

Every selected record is accounted for.

CheckResult
Rows in the full source file50,407
Columns in the full source file84
Selected model years2024, 2025
Rows outside those model years47,857
Selected original records2,550
Prepared records2,550
Original distinct IDs2,550
Prepared distinct IDs2,550
Rows removed0
Repeated IDs0
Year/make/model name groups2,109
Name groups with several configurations283
Valid configurations protected from name-only deletion441
Rows needing source review16
Rows passing the documented preparation checks2,534
Questions recorded26
Logged transformations16,366
Placeholder zeros given an explicit meaning6,167
Electricity/charging placeholder zeros clarified3,723
Actual zero tailpipe figures preserved600
Unavailable −1 codes made explicit2,534
Rows meeting the stated electric-car filter35

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.

  • This is an independently prepared public-data demonstration, not a client project, agency endorsement or certification.
  • EPA estimates and classifications are source data; real-world results and current availability may differ. Model years remain subject to later source revisions.
  • Record counts describe catalog configurations, not vehicle sales, market share or inventory.
  • No measured value is invented and no same-name configuration is removed. Normalization events are not claims of upstream errors fixed.
  • MPG, MPGe, PHEV blended values and composite economy are different measures; no mixed-unit ranking is provided.
  • Hydrogen fields and two charging/classification conflicts are retained for review, not independently resolved.
  • The ≤30 kWh/100 mi comparison is a documented demonstration threshold, not a recommendation, lifecycle assessment or total-cost calculation.
  • Manufacturer vehicle photographs, logos, web-page prose and proprietary images are not part of the redistributable data outputs.

Source & reuse

Public evidence, clearly credited.

EPA / DOE FuelEconomy.gov vehicle dataset. Independent transformation of the cited public source; no endorsement implied.

Public-domain EPA data (Data.gov catalog links this download to the EPA Standard Open Data License). Website documents and manufacturer photographs have separate terms; no vehicle images are included.

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