Help us to improve the website - give your feedback.

Entering data into the V-MAC

Which data do you need to use the V-MAC?

For each job, pick a typical day when the job is carried out and:

  • Find out how many distinct manual handling tasks each of the three workers carried out during his or her work shift. A task might be picking a single order, filling a pallet, unloading a trailer, or carrying out a cyclic production task.
  • Get full data on the weights each of the three workers handled for each task over the work shift. If you can, retrieve it from a computerised system, such as a Warehouse Management System. The item weights need to be in kilograms (kg).
  • For each task, find out how far, on average, each worker carried loads – if at all. You don't need to measure the distance of each carry. For each distinct task, you can estimate the average carry distance as half way between the distances of the longest and shortest carries.

Inputting the data

The outputs you get are only as accurate as the data that you put in.

  • Download (.xls) [79] and open the Excel workbook.
  • The workbook has three tabs across the bottom. Choose the 'Instructions and Data Entry' tab.

Choose instructions and data entry tab

  • Read the 'Introduction' and 'Steps to Follow' to help you enter your data.
  • You have 16 columns and 512 rows to enter the data for the entire shift. Use these to enter data from the different tasks that the worker carried out during the shift. We've labelled them 'Task 1', 'Task 2', etc. Change the column headings to identify the actual tasks – perhaps 'Order number 1', 'Order number 2', 'Pallet 3', 'Pallet 4'.

Use different columns for different tasks

  • Use different columns for tasks with different carry distances.
  • If items are carried more than 2 m, enter the average carry distance for that column. Remember, you can estimate this as halfway between the shortest carry distance and the longest carry distance.

Copy and paste your data (if using information from your computerised system such as a Warehouse Management System) into the spreadsheet.

Copy and paste your data into the spreadsheet

  • If workers handle several small items at once, enter the total weight as one lift. So a lift of a stack of four items each weighing 2 kg should be entered as one lift of 8 kg.
  • Select the link or tab that matches the total shift length (including breaks). Just to make it easier to display the graphs, there are separate tabs for shifts between 4 hours and 8 hours long and for shifts between 8 and 12 hours long.

Select link or tab that matches total shift length

Enter the actual shift duration in the hh:mm format.

Enter the actual shift duration


Link URLs in this page

  1. MSDshttps://www.hse.gov.uk/MSd/msds.htm
  2. Back painhttps://www.hse.gov.uk/MSd/backpain/index.htm
  3. Upper limb disordershttps://www.hse.gov.uk/MSd/uld/index.htm
  4. Lower limb disorders https://www.hse.gov.uk/MSd/lld/index.htm
  5. Display screen equipment (DSE)https://www.hse.gov.uk/MSd/dse/index.htm
  6. Manual handling at workhttps://www.hse.gov.uk/MSd/manual-handling/index.htm
  7. Overview - MSD toolkithttps://www.hse.gov.uk/MSd/toolkit.htm
  8. Overview - MAC toolhttps://www.hse.gov.uk/MSd/mac/index.htm
  9. Introduction to MAChttps://www.hse.gov.uk/MSd/mac/introduction.htm
  10. Developmenthttps://www.hse.gov.uk/MSd/mac/development.htm
  11. Score sheethttps://www.hse.gov.uk/MSd/mac/scoresheet.htm
  12. Overview - Liftinghttps://www.hse.gov.uk/MSd/mac/liftintro.htm
  13. Lifting from pallet videohttps://www.hse.gov.uk/MSd/mac/liftvid1.htm
  14. Lifting creels of wire videohttps://www.hse.gov.uk/MSd/mac/liftvid2.htm
  15. Lifting control measureshttps://www.hse.gov.uk/MSd/mac/guidance01a.htm
  16. Overview - Carryinghttps://www.hse.gov.uk/MSd/mac/carryintro.htm
  17. Carrying from conveyor videohttps://www.hse.gov.uk/MSd/mac/carryvid1.htm
  18. Carrying task in pastry factory videohttps://www.hse.gov.uk/MSd/mac/carryvid2.htm
  19. Carrying control measureshttps://www.hse.gov.uk/MSd/mac/guidance02a.htm
  20. Overview - Team handlinghttps://www.hse.gov.uk/MSd/mac/teamintro.htm
  21. Team handling pallet videohttps://www.hse.gov.uk/MSd/mac/teamvid1.htm
  22. Team handling container videohttps://www.hse.gov.uk/MSd/mac/teamvid2.htm
  23. Team handling control measureshttps://www.hse.gov.uk/MSd/mac/guidance03a.htm
  24. Psychosocial risk factorshttps://www.hse.gov.uk/MSd/mac/psychosocial.htm
  25. Individual differenceshttps://www.hse.gov.uk/MSd/mac/individuals.htm
  26. MAC assessment tipshttps://www.hse.gov.uk/MSd/mac/tips.htm
  27. MAC FAQhttps://www.hse.gov.uk/MSd/mac/faq.htm
  28. Overview - V-MAChttps://www.hse.gov.uk/MSd/mac/vmac/index.htm
  29. Advantages and limitationshttps://www.hse.gov.uk/MSd/mac/vmac/1-advantages-limitations.htm
  30. What you need to knowhttps://www.hse.gov.uk/MSd/mac/vmac/2-what-you-need-to-know-before.htm
  31. How to use the V-MAChttps://www.hse.gov.uk/MSd/mac/vmac/3-how-to-use.htm
  32. Which jobs and workers to assesshttps://www.hse.gov.uk/MSd/mac/vmac/4-which-jobs-workers-to-assess.htm
  33. Entering datahttps://www.hse.gov.uk/MSd/mac/vmac/5-entering-data.htm
  34. What does the V-MAC tell you?https://www.hse.gov.uk/MSd/mac/vmac/6-what-does-vmac-tell-you.htm
  35. Values in the summary tablehttps://www.hse.gov.uk/MSd/mac/vmac/7-summary-tables.htm
  36. Recording and usinghttps://www.hse.gov.uk/MSd/mac/vmac/8-recording-and-using.htm
  37. Worked exampleshttps://www.hse.gov.uk/MSd/mac/vmac/9-worked-examples.htm
  38. V-MAC FAQshttps://www.hse.gov.uk/MSd/mac/vmac/10-faqs.htm
  39. Overview - ART toolhttps://www.hse.gov.uk/MSd/uld/art/index.htm
  40. What is the ART toolhttps://www.hse.gov.uk/MSd/uld/art/whatis.htm
  41. Overview - Learning to use the ART toolhttps://www.hse.gov.uk/MSd/uld/art/learning.htm
  42. Preparationhttps://www.hse.gov.uk/MSd/uld/art/preparation.htm
  43. Risk factorshttps://www.hse.gov.uk/MSd/uld/art/riskfactors.htm
  44. Observationhttps://www.hse.gov.uk/MSd/uld/art/observation.htm
  45. Overview - Making an assessmenthttps://www.hse.gov.uk/MSd/uld/art/assessment.htm
  46. Task descriptionshttps://www.hse.gov.uk/MSd/uld/art/task.htm
  47. Overview - Assessment guidehttps://www.hse.gov.uk/MSd/uld/art/assessguide.htm
  48. A. Frequency and repetition of movementshttps://www.hse.gov.uk/MSd/uld/art/freqrep.htm
  49. B. Forcehttps://www.hse.gov.uk/MSd/uld/art/forceassessment.htm
  50. C. Awkward postureshttps://www.hse.gov.uk/MSd/uld/art/awkpostures.htm
  51. D. Additional factorshttps://www.hse.gov.uk/MSd/uld/art/addfactors.htm
  52. Score sheethttps://www.hse.gov.uk/MSd/uld/art/score.htm
  53. A walkthroughhttps://www.hse.gov.uk/MSd/uld/art/walkthrough.htm
  54. Overview - Try it outhttps://www.hse.gov.uk/MSd/uld/art/try.htm
  55. Book bindinghttps://www.hse.gov.uk/MSd/uld/art/bookbinding.htm
  56. Jogging sheetshttps://www.hse.gov.uk/MSd/uld/art/jogging.htm
  57. Collating papershttps://www.hse.gov.uk/MSd/uld/art/papers.htm
  58. Whisky carton assemblyhttps://www.hse.gov.uk/MSd/uld/art/cartonassembly.htm
  59. Croissant curlinghttps://www.hse.gov.uk/MSd/uld/art/croissant.htm
  60. Overview - Analysis and actionshttps://www.hse.gov.uk/MSd/uld/art/analysis.htm
  61. What the scores meanhttps://www.hse.gov.uk/MSd/uld/art/scoresmean.htm
  62. Analysing task rotationhttps://www.hse.gov.uk/MSd/uld/art/rotation.htm
  63. Overview - Taking actionhttps://www.hse.gov.uk/MSd/uld/art/action.htm
  64. Repetitionhttps://www.hse.gov.uk/MSd/uld/art/repetition.htm
  65. Forcehttps://www.hse.gov.uk/MSd/uld/art/force.htm
  66. Posturehttps://www.hse.gov.uk/MSd/uld/art/posture.htm
  67. Durationhttps://www.hse.gov.uk/MSd/uld/art/duration.htm
  68. Physical environmenthttps://www.hse.gov.uk/MSd/uld/art/environment.htm
  69. Psychosocial issueshttps://www.hse.gov.uk/MSd/uld/art/psychosocial.htm
  70. Art Tool Resourceshttps://www.hse.gov.uk/MSd/uld/art/resources.htm
  71. Frequently asked questionshttps://www.hse.gov.uk/MSd/uld/art/faq.htm
  72. Overview - RAPP toolhttps://www.hse.gov.uk/MSd/pushpull/index.htm
  73. Push/pull riskshttps://www.hse.gov.uk/MSd/pushpull/risks.htm
  74. Push/pull risk assessmenthttps://www.hse.gov.uk/MSd/pushpull/assessment.htm
  75. The lawhttps://www.hse.gov.uk/MSd/legislation.htm
  76. Health monitoringhttps://www.hse.gov.uk/MSd/health-monitoring.htm
  77. Workershttps://www.hse.gov.uk/MSd/workers-msds.htm
  78. Resourceshttps://www.hse.gov.uk/MSd/resources.htm
  79. Downloadhttps://www.hse.gov.uk/MSd/assets/docs/vmac.xls
  80. Previous page: Which jobs and workers to assess with the V-MAChttps://www.hse.gov.uk/msd/mac/vmac/4-which-jobs-workers-to-assess.htm
  81. Next page: What does the V-MAC tell you?https://www.hse.gov.uk/msd/mac/vmac/6-what-does-vmac-tell-you.htm
  82. MAC toolhttps://www.hse.gov.uk/msd/mac/index.htm
  83. ART toolhttps://www.hse.gov.uk/msd/uld/art/index.htm

Glossary of abbreviations/acronyms on this page

MAC
Manual handling assessment chart tool
ART
Assessment of Repetitive Tasks

Is this page useful?

Updated: 2024-08-13