ABC Analysis

←

Tools

How the simulator works — step by step

Choose the PRIO scale.Decide how many priority levels you need and how they should be displayed, for example A/B/C, 1/2/3, P1/P2/P3 or another compact format.
Define category limits.Categories can be neutral or restrictive. For simulation, a category can also be limited to specific cost or value intervals, so you can test rules such as low-cost or high-cost exceptions before copying the formula.
Define status limits.Statuses decide which rows are active and, optionally, which PRIO levels are allowed. This is useful when drafts, approved items or items in evaluation should behave differently.
Set the ABC factor thresholds.The factor thresholds describe how much of the active total belongs to each PRIO class. The preview shows both the target distribution and the actual distribution produced by the current rules.
Add time pressure rules.Deadline and created-date rules can push old or urgent items into a higher PRIO. Each rule is optional, has its own day thresholds and can either respect or override category and status limits.
Connect the logic to your own Excel file.In Your Own Excel Settings you enter only the columns and the first and last data row from your workbook. The generated formula uses these settings instead of fixed demo values.
Test with Seed.The Seed preview generates repeatable example rows. It shows how categories, statuses, values, deadlines and creation dates influence the final PRIO before you copy the formula.
Copy the final formula.The Formula tab contains the finished LET formula. After copying it into your spreadsheet, each row can calculate the same priority logic automatically.

Anzahl der Stufen3

12345

PRIO-Haken sind deaktiviert, weil Status-Grenzen in den Einstellungen ausgeschaltet sind.

ABC-DiagrammKlassenanteile und kumulierte Grenzen

Option	Beschreibung	Feld
Kategorie exakt vergleichen	Ein: Der Kategorietext muss exakt passen. Aus: Die Formel sucht den Begriff im Text.
Leerer oder 0-Wert ergibt "---"	Verhindert PRIO-Ergebnisse, wenn kein Wert oder 0 eingetragen ist.
Deadline-Regel aktivieren	Aktiviert eine zusätzliche Regel über das Deadline-Datum.
Deadline überschreibt Grenzen	Wenn aktiv, darf die Deadline auch Kategorie- und Status-Grenzen übersteuern.
Created date rule	Enables stepped rules based on the creation date age.
Created date overrides limits	When enabled, the creation date may override category and status limits.
Status-Grenzen aktivieren	Wenn aktiv, begrenzen Statuswerte die erlaubten PRIO-Stufen wie Kategorien.
ABC-Richtung	Legt fest, ob kleine oder große Kosten-/Wertanteile zuerst priorisiert werden.
Deadline-Fristen	Tage je PRIO-Stufe. Für die letzte Stufe ist kein Feld nötig.
Created age thresholds	Minimum age in days per PRIO level. No field is needed for the last level.
Separator-Einstellungen

EinträgeMax. WertMedianWährungDeadline-AnteilMax. DeadlineMax. ageSeed

Build your private seed after login.

Statistics and diagrams for the currently loaded data set.

Summe0 €

Aktive Summe0 €

A-Grenze0 €

ABC-Ziel

Ist

Änderungen je Stufe

Enter only the columns and data rows that exist in your own workbook.

Setting	Description	Field
First data row	First row of the table data range included in the formula.
Last data row	Last row of the table data range included in the formula.
Category column	Column with the category text in each row.
Value column	Column with all values used for the active total and ABC factor.
Deadline column	Column with the deadline date used by the optional deadline rule.
Created date column	Column with the creation date used by the optional age rule.
Status column	Column with all status values. It is used both for the current-row status and for the full active-status mask.
Result / PRIO formula column	Column where the XLSX export writes the LET formula for the calculated PRIO result.