I am currently thinking of a wpf dialog to enter multiple values for a production line. Currently our customer uses a Excel Sheet, but since we now need to save the entered values to SQL DB and for future changes we want to implement this in .net.
Per Day, there are ~10 production lines which have a day and a night shift.
For each shift our customer has to enter about 50 values for a production line.
How would I create a dialog to insert such a high number of values while still providing good usability and readability.
Ok I just had a talk with the customer.
- The values entered are default 0 and are only changed when an error in the part of line accured.
- The values are not prefilled and are all entered by hand.
- The values are similar to each other but are not related
There is also another interesting fact: The values are entered from end to begin! That means they don't know how many pieces started the production process - they only know the value of how many made it through the line and how many were sorted out in each part of the line. So the start value is aggregated by end value + errors accrued.
Further there the single stations of a line are grouped together. This is grouping is the same for all lines. Each group values should be aggregated.
My thought on entering Data was to only show Data belonging to the same group, and when changing the group the previously displayed group collapses and only the aggregated data is shown.