Mining Output Analysis Dashboard

Analyze daily mine output from Google Sheets, detect anomalies with four statistical methods, compare mines against the total output, and export a polished PDF report with tables and charts.

Controls

Google Sheets URL or CSV export URL The backend can accept the normal Google Sheets link and convert it into a CSV export URL automatically.

Mines to display Leave empty to show every mine. Total is always included automatically in the backend.

Chart type

Trendline degree

IQR multiplier (k)

z-score threshold

Moving average window

Distance from MA (%)

Grubbs alpha Lower alpha makes the Grubbs test stricter. This test is best interpreted carefully when many outliers exist.

Ready

No dataset loaded yet.

Total anomalies

—

Detected across the selected mines and total output.

Spike anomalies

—

Values materially above their normal pattern.

Drop anomalies

—

Values materially below their normal pattern.

Mines analyzed

—

Distinct mines in the current dataset.

Output chart

Interactive chart with highlighted outliers and polynomial trendlines.

Spike anomaly Drop anomaly Trendline

Load data to render the chart.

Summary statistics by mine

Mean, standard deviation, median, interquartile range, and anomaly counts.

No statistics yet.

Anomaly register

Detailed list of every spike and drop flagged by one or more selected tests.

No anomalies to display yet.