Hello Guys.
I have Excel with Columns:
- Period - I have 2 period
- Model - Model Number
- Line - Line that creates the model
- #Value - Number of units for each model to create
- AggValue- Aggregation of units (#Value) in the line per Period
- Line Option - Single / Multi
- Capacity - Each period has a different Capacity
- Flag - 1/0 - how algorithm line need to be (What do i expect to see in Flag Calc column)
- RemainCapacity - show the Remaining Capacity (What do i expect to see in RemainCapacity Calc column)
assumptions:
the order of the table is Permanent.
it's mean if a new row will enter its will follow the some rule
- Line Option "single" will come first and the #value will be sorted from High to Low
- Line Option "Multi" will come second the #value will be sorted from High to Low as well
you can open any columns but:
- It is not possible to make a calculation beased on other row
- if the calculation beased on other row its must to be Aggregation and it can be (sum/min/max/count)
like AggValue its sum Aggregation of #value per Period.
thanks!!!
Bookmarks