Time Study Spreadsheet – The stage of the calculation of standard time marks the beginning of office work in the study of the times, although it is very likely that the specialist in the middle of the analysis deems necessary supported again in the observation of the operations. This phase does not require a large arithmetic domain, so it consists of common and current calculations that can perform the analysis in a very short time, an assistant or a spreadsheet.The stage of the calculation of standard time marks the beginning of office work in the study of the times, although it is very likely that the specialist in the middle of the analysis deems necessary supported again in the observation of the operations. This phase does not require a large arithmetic domain, so it consists of common and current calculations that can perform the analysis in a very short time, an assistant or a spreadsheet.

It does require a great ability to analyze the consistency of the data obtained in the observation phase, and an obvious knowledge of the measures to be taken depending on the situation that is present.OF THE TIMES OBSERVED AT STANDARD TIME
The fact of converting a series of observed times into the standard type times requires the systematic application of a series of steps in which it becomes important that the analyst has clarity regarding the theoretical basis of the work timing, the evaluation of the rhythm , And study supplements.
1. ANALYSIS OF THE CONSISTENCY OF THE ELEMENTSThe analysis of the coherence of each element of the research study the variations that perceive the observed times. The measures taken as a result of the results of each analysis of the following:If it is determined that the variations are due to the nature of the element all readings are retained.If it is determined that the variations are not originated by the nature of the element, and the previous and / or posterior reading where the variation is observed are consistent; The inconsistency of the element is due to the lack of skill or lack of knowledge of the task by the worker. In this case, if a large number of observations are consistent, it can eliminate extreme observations and only retain the normal observations. In the same case, if it is not possible to distinguish between extreme and normal observations, it must be repeated in the study with another worker.If it is determined that the variations are not due to the nature of the element, but the letter later and / or prior to the element where the variation is observed, they have also undergone variations; This situation occurs due to errors in timing, by the time taker. If the number of extreme cases is minimal, they are eliminated, and only the normal cases are preserved. If, on the contrary, this error has been committed in many readings, although not all are in the same element; It is best to repeat the study, and this repetition is done the times that the sea is necessary until achieving an adequate consistency in the observations of each element.If it is determined that the variations have no apparent cause, they should be carefully analyzed before being removed (if it is possible to return to the observation phase). Never accept an abnormal reading as unexplained. In case of doubts, it is advisable to repeat the study.To avoid repetitions of the recommended study recognize the importance of special annotations in the timing process, since this information is vital to identify the causes of a particular variation.

2. CALCULATION OF THE AVERAGE PER ELEMENT
To obtain the average per item you need:
1 2 3 4 5 6 7 8 9 10 Sum (ΣXi)
0.345 0.335 0.350 0.347 0.501 0.345 0.350 0.349 0.344 0.345 3.11
In this case reading No. 5 is not considered to be consistent.
The number of readings considered for each element are recorded as consistent (LC = Consistent Readings).
1 2 3 4 5 6 7 8 9 10 Sum (ΣXi) LC
0.345 0.335 0.350 0.347 0.501 0.345 0.350 0.349 0.344 0.345 3.11 9
In this case the number of consistent readings is equal to 9.
The sums of the readings are divided for each element, between the number of readings considered; The result is the average time for the element (Te = Average Time per element).

3. OF THE TIMES OBSERVED AT THE BASIC OR NORMAL TIMES

In this step it is necessary to consider whether in the process of evaluation of the rhythm a cadence factor was determined for each element or for each reading.
In the case of having determined a valuation for each element, proceed for each element (Tn = Normal Time):

For example, if we assume that the worker had a work rate factor equivalent to 95; And we assume (as is common) that the standard rate factor equals 100; We will have to (for an average time of 0.345):

In the case of having determined a valuation for each reading (observation of time), will proceed for each element:

This mode is performed if the average of the element has already been calculated, otherwise and with the help of a spreadsheet, it is preferable to perform the conversion of observed times to basic or normal for each reading and then determine the average of these. In the same way you will get the same result.
4. ADDITION OF THE SUPPLEMENTS (TIME GRANTED BY ELEMENT)
In this step, the basic or normal time is added the tolerances for supplements granted, obtaining the time granted by each element. This will be done for each element (Tt = Time granted elementary):

For example if we assume that the element corresponds to supplements of 13%, we will have (for a normal time of 0.328):

5. FREQUENCY SOURCE (TOTAL GRANT TIME)
In this step the frequency is calculated per operation or piece of each element, ie how many times does the element to produce a part? The repetitive elements, by definition, are given at least once in each cycle of the operation, so that in its respective line will be 1/1 if given once per operation, or 2/1 if given twice Per operation.

Casual elements (for example tool sharpening) can happen only every 5, 10 or 50 cycles; In this case it would be entered in its respective frequency line 1/5 if this element is given (sharpening tools, p.e) once every 5 operations, or 1/10 if given 1 time after 10 operations.

Then the Elemental Time (Te) is multiplied by the frequency of the element (to be written, as already mentioned in fraction form). The product of this multiplication will be called Total Time Granted (Ttc = Total Time Granted).

We can say that the element that has served as an example is a repetitive element, and that this is presented 3 times per operation. That is, in the operation to produce part A, we must perform 3 times the element we will calculate (For a time Tt equivalent to 0.371):

6. STANDARD TIME TYPE
In this step are added the total times granted for each element that is part of an operation, and the standard time per operation is obtained.

Suppose that the element that has served as an example is called an element “A”, and is part of a series of elements called elements A, B, C, D, E, F. We will have:
Ttc Element (Total Time Granted)
1,113
B 2,106
C 1.590
D 3,520
E 1.008
F 1.464
Standard Time (Σ (Ttc)) 10,345