MODAPTS Excel Template for Time and Motion Analysis

MODular Arrangement of Predetermined Time Standards

This MODAPTS Template automates the analysis of time and motion to develop reliable production standards on assembly lines. To learn more about MODAPTS visit https://modapts.org/.

modapts template excel performs all calculations

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.

QI Macros MODAPTS Template

QI Macros is an easy to use add-in for Excel that installs a new menu on Excel's tool bar. To use the MODAPTs template:

  1. Click on QI Macros menu, Lean Tools and then MODAPTS Calculator:
  2. lean tools menu

  3. The template will open with some fields pre-populated for illustration purposes. Click on the "Clear Form" button before inputting your own data. Input descriptions, common elements (*) and options (1-2-3-4), and MODAPTS string in the columns as shown below.

    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

    For Example: STEP, GET OUTER FRAME DOOR, STEP BACK PLACE IN FIXTURE in MODAPTS code is:

    • 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, bicep = 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. Add as many options as you want, and extend the formulas to calculate times for each one.
  6. MODAPTS template Job Information

  7. Now click the "Calculate Times" button. Times will be calculated from each MODAPTS string and are displayed in minutes and seconds. That's all there is to it!
  8. QI Macros MODAPTS template calculations

Popular Lean Tools in QI Macros add-in for Excel:

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