TOOLSFOR FACTORIES

Loss analysis / WORKSHEET 09

Downtime Pareto analyzer from CSV

Choose a CSV, map its category and duration columns, and aggregate downtime entirely in your browser. The selected file is not uploaded by this site.

Output
Ranked downtime totals, event counts, share of total, cumulative percentage, and a Pareto bar view.
Processing
In this browser only
Cost
Free · no account

LIVE WORKSHEET

Map the downtime export

Runs locally

No file selected

Inputs and results stay in this browser. Verify important outputs independently.

APPLICATION NOTES

Use the result on the floor

Analyze a local CSV of downtime categories and durations into a ranked Pareto table with cumulative percentages. Keep the input boundary, unit definitions, and time period attached to any recorded result so another person can reproduce it.

Useful for

  • Rank equipment stop reasons by lost time.
  • Prepare a loss review from exported event logs.
  • Identify the small set of categories contributing most downtime.

MODEL BOUNDARY

Assumptions and limitations

Assumptions

  • The first row contains unique column headers.
  • Duration values are non-negative plain numbers using a period as the decimal separator.
  • Blank category values are grouped as “Unspecified”.

Limitations

  • Files are limited to 5 MB and 50,000 data rows in this browser tool.
  • The parser handles standard quoted CSV but does not infer locale-specific numbers, repair malformed exports, or merge synonymous reason names.
  • Pareto ranking shows frequency and duration, not root cause or business impact.

DECISION CHECK

Verify before changing the process

Preserve the original export and verify mapped columns, units, row counts, and totals before using the analysis for operational decisions. Sensitive filenames and data remain in this browser tab, but other browser software or extensions are outside this site’s control.

REFERENCE

Frequently asked questions

Is my CSV uploaded?

No. The page reads the selected file in your browser and does not send its contents to a server.

What CSV format is supported?

Use a comma-delimited UTF-8 file with a header row. Quoted fields, embedded commas, and doubled quote escapes are supported.

Why do I need to select columns?

Column names vary between systems. Explicit mapping avoids guessing through an ambiguous export.

NEXT PROCESS

01OEE calculatorCalculate availability, performance, quality, and overall equipment effectiveness from a production run.02First-pass yield calculatorCalculate first-pass yield and first-pass defects from units entering a process and units accepted without rework.03Cycle time and capacity calculatorEstimate hourly and shift production capacity from cycle time, parallel stations, utilization, and net shift time.