MODAPTS Excel Template for Time and Motion Analysis

TheĀ MODAPTS TemplateĀ automates the analysis of time and motion to develop reliable production standards on assembly lines. MODAPTS stands for MODular Arrangement of Predetermined Time Standards. To learn more about MODAPTS, click here.

MODAPTS breaks any process down into motions that can be coded as a string of modifications. Each mod is 0.129 seconds:

4(W5) M4G4 4(W5) M4P10

Most MODAPTS coders can do this quickly. Calculating the times is hard, so that's what the MODAPTS template does for you.

To use the MODAPTS Template:

  1. Open the template found in the Lean Tools drop-down menu:
  2. modapts-menu-image

  3. Next, put descriptions and MODAPTS strings in columns as shown below. Descriptions, common elements (*) and options (1-2-3-4), and MODAPTS string. Put 1/1 in numerator/denominator unless an action needs to be spread across all units (e.g., Element 8 - Restock Box...) Don't worry about the Mods, Minutes or Seconds. The template will calculate them for you. Add as many rows as you need for your process:
  4. MODAPTS Coding in Excel


    • 4(W5) - Four Walking steps with 5 mods of time (5 * 0.129 seconds)
      [body movement like bend, walk]
    • M4G4 - Movement (see diagram below-finger, hand, forearm, bicept = 4 mods),
      Get (grasp outer frame door) - 4 mods
    • 4(W5) - Four Walking steps with 5 mods (return)
    • M4P10 - Movement with 4 mods. Place with 10 mods of time
    • 4(T0.025) - Four actions of time 0.025 minutes

  5. Fill in the job description and allowance (adjustment). Describe different options and set options for each configuration.
  6. MODAPTS Job and Calculation in QI Macros Excel Template

  7. Then click the Calculate Times button:
  8. MODAPTS Job and Calculation in QI Macros Excel Template

    Add as many options as you want, and extend the formulas to calculate times for each one.

  9. Times will be calculated from each MODAPTS string and summarized above. That's all there is to it!
modapts logo


Popular Lean Tools in the QI Macros:

To create a MODAPTS Template Excel using QI Macros...
Try It Now!