Standard Data Libraries Details

Standard Data Libraries Details

Creating Standard Data Libraries

The use of a standard data library:

  • reduces the need to perform additional time studies – freeing observers for other tasks,
  • is 95% faster than time study – can also be used to estimating and methods analysis,
  • deskills the standards development process – can be used by staff at any level.,
  • increases consistency and traceability – improves costing and planning,
  • creates a centralized knowledge base –  data becomes a corporate asset.
Step 1. Time Study Data Collection is Performed on the PDA.

Set up time study templates in Excel and download them to Timer Pro on your PDA and collect time study data.

Standard Data Library Step 1 - Big
Step 2. Time Study Data is Instantly Summarized in Excel on the PC.

The results of a Timer Pro time study are summarized in Excel. This example of creating time study standard data will follow the use of the highlighted times for the activity Get Part and its 3 variations: Small, Medium and Large.

By clicking on the Process Analysis button in cell B2, the average time in column I is converted to seconds for all elements in the time study and sent to the Task List as discussed in the next step.

Step 3. Time Study Results are Filed into an Excel-based Standard Data Library.

The standard data library is organized by indenting related data on subsequent rows and columns.

For example, the Get Part options are logically placed under the Pick / Individual Items as follows:

Cell A22     Pick

Cell B23             Individual Items

Cell C24                                  Get Part, Small

Cell C25                                  Get Part, Medium

Cell C26                                  Get Part, Large

The activities from the time study are simply highlighted and copied from the Task List window and pasted into the appropriate location (cell) in the Excel data library.

Each standard data library supports up to 20 levels of data structure and up to 1000 rows

Step 4. Standard Data Library is Accessed by the Data Application Expert.

Standard data libraries can be called from any Excel workbook. The structure defined in the standard data library Excel sheet is presented as a series of folders that are opened to drill down to the standard time for the task i.e. the time that came from the original source time study.

In the example shown here:

  1. The Pick folder was opened
  2. Followed by the Individual Items folder
  3. Then the Get Part, Medium part was selected
  4. As soon as the Get Part, Medium selection is clicked the standard data details are retrieved
  5. The activity description and frequency of occurrence can then be updated as required

Users can rapidly navigate around the standard data library to select all the activities that represent the job they are estimating.

Step 5. Select Time Study Values from the Data Application Expert to Create New Standards.

All time study standard data selections made from the data application expert are inserted into the Excel sheet to summarize the job being studied.  Note that the standard times are multiplied by the frequency to give the total time for each activity. The format of the Excel template is totally under the users control.

Step 6. Your Existing Time-related Data in Excel Format can be Added to any Standard Data Library.

If you have standard time data in Excel they can be imported into Timer Pro Professional’s process analysis and from there added to and standard data library. Any number of standard data libraries can be maintained in Timer Pro Professional.