DrBestand ERP

How the simulator works — step by step

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.