Add extra columns to your data set without typing the formulas yourself.
We've created short cuts for the most commonly used formulas: https://recipe.abcsoftwork.com/en/
- Master ABC Categorization
- Adequacy in days
- Consumption per day
- The item's age
- Turnover rate
- Days since last consumption
- Stock surplus 12 months
- Round up to nearest package size
Use a recipe in ABC Analyzer
Click "Edit" and choose "Recipes"
Choose the desired recipe.
Next, you get a pop up in which you choose the columns needed. Often you only need one or two columns.
Select the correct columns
ABC Analyzer will display a description in the bottom of the pop up, guiding you to choose the correct columns, if in doubt read the long version of the help text here.
If the recipe requires a column containing "dates", ABC Analyzer will only display "date"-columns in the drop down.
Click "OK" when done.
New columns are shown furtest to the right in the data set (Go to the "Data"-tab to see it.) If you want to revisit the formula, go to "Edit / Columns / Edit Columns" and click the name of the column.