User Input for Multiple Values in an added column in table.

[Joshi_M]

Hi,

I have a sample table as shown below.The information below is used on capacity calculation.

The shift pattern determines the days per week & hours  per day. which is used in capacity calculation

There are several locations /machines so the combination could be many.

I want the user  to be able to add/edit diffrent shift pattern in the simulated column.

I will probably have a slicer for Location & Process so easy for user  to update.

How to achieve this? i have been thinking and reading post but could not find this kind of solution.

The values in the simulated column will be used to compare current with simulated one.

Hope the explanation is clear. Workaround is also welcome.

Kindly help.

Regards

Manish

Location	Process	Machine	Shift Pattern	Simulated Shift Pattern
A	XX	11	7X3	6X3
A	YY	21	6X3	5X3
A	ZZ	51	5X3	4X3
B	XX	11	4X3	4X1
B	XX	12	5X2	6X3
B	YY	22	6X3	7X3