OEE Coach Software Help
Print
Table of Contents

(How) can I CHANGE an existing ACTIVITY- or Producttype?

Situation

The master table ACTIVITIES, contains all potential activities to which an activity type is assigned (P-W-F-L-U). The same applies to products where we can type a product as G-S-R-SS

Depending the type assigned to such a master activity (or product), the future calculations will be made in the correct way.

Problem

What happens when after a while, someone wants to change an activity type? lets say you defined Break as [U] and after two months of collecting data you want to change it from [U] to [W]? (Good idea btw….)

This would not only have an effect on ALL existing shift calculations that used this master setting [Break] but also on all future calculations.

Protection

In order to protect the user from corrupting existing data, OEE Coach shows a warning:

Solution

1. How to change Type for future calculations

To keep all current calculations as they are, and only have a new type for an activity in new calculations do the following:

  • In the master-table, duplicate the current activity/product
  • Assign it the new type (in this example from [U] to [W])

The master-table now contains a Break_1 [U] and a Break_2 [W]: [U] will be used for old calculations, [W] for the new ones.

This is settled in the MAP: Here you delete the old Break_1 [U], and add the new Break_2 [W].

From now on, the user that adds a new shift will no longer be able to choose [U] yet gets the [W] as new option.

2. How to change Type for future AND existing calculations

In the beginning of the configuration and use of OEE this might be a desired option. We now have to do some manual corrections retrospective.

  • First proceed as in the previous step.
  • Now, search for all those shifts that have the modified activity/product used.
  • Go to that shift, select the activity/product and change it (it can be selected since it is known in the MAP.

As soon as no more old activity/product is being used neither in shift-data nor in MAP, you can delete the old one (here Break_1 [U]) in the master-data.

Remark:

You are free to change the name of the master since this does not affect the calculation.

Previous How to use the Calendar
Next How to use ORDER and BATCH numbers