Spreadsheet: 706995d1606992133-using-index-match-function-to-create-multi-dependent-drop-down-lists-returning-error-quoting-tool-v10
Sheet: Master Table Lookup

Master Data Table
 | Product Streams |  |  |  |  |  | Product Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product Descriptions
Primary Product Stream Labels | Product Streams |  |  |  |  | Primary Product Services Labels | Product Stream - Mobile Clinic | Product Type - Occupational Health and Wellbeing |  | Product Type - Workplace Health, Wellbeing and Performance |  |  |  | Service Type - Injury Prevention and Early Intervention |  |  |  | Service Type - Workplace Rehabilitation |  |  |  |  |  | Primary Product [NAME] | Specific Product - Health Monitoring |  |  |  |  |  |  |  |  | Specific Product - Pre-employment Test |  |  |  | Specific Product - Workplace Environmental Monitoring |  |  |  |  |  |  |  | Specific Product - Wellbeing and [NAME] |  |  | Specific Product - Workshops | Specific Product - Strategic Review | Specific Product - Executive Health Screening | Specific Product - EAP Services | Specific Product - Injury Triage Services |  | Specific Product - Workstation Assessments and DPI Prevention |  |  |  | Specific Product - Manual Handling Training | Specific Product - Workplace Rehabilitation
Product Stream | Mobile Clinic | Occupational Health and Wellbeing | Injury Prevention and Early Intervention | Workplace Rehabilitation | Travel, [NAME] and [NAME] | Product Services | Health Monitoring | Pre-employment Test | Workplace Environmental Monitoring | Wellbeing and [NAME] | Workshops | Strategic Review | Executive Health Screening | EAP Services | Injury Triage Services | Workstation Assessments and DPI Prevention | Manual Handling Training | Workplace Rehabilitation Assessment | Travel | Travel Km | Reporting | Unsociable Hours Cost | Stand-down Cost | Product Descriptions | Hearing Test2 | Vision Screening | Spriometry/Lung Function Test | Cardiovascular Disease Risk Check | Drug Testing | Breath Alcohol Testing | Vaccinations | Mask Fit Test | Annual Company Report for Workplace Health Testing | Pre-employment Medical Test | Pre-employment Functional Test | Pre-employment Health Test | Pre-employment Driver Test | Asbestos Medical | Asbestos Air Sampling | Heat and Cold Stress | Chemical and Dust Exposure | [NAME] and [NAME] | Indoor Air Quality Monitoring | Industrial Noise Monitoring | Industrial Lighting Monitoring | Recovery Package | Resilience Package | [NAME] | Four Corners of Health Workshops | Strategic Review of Health and Wellbeing at Work | Executive Health Screening Service | EAP Service Assessment | Injury Triage (No ACC claim) | Injury Triage (ACC Claim, Co-Payment Paid) | Office Workstation Injury Prevention Group Presentation | Workstation Screen - Group Education | Workstation Screen – Individual Education | Comprehensive Workstation Assessment | Manual Handling Training Workshop | Rehabilitation Assessment at Workplace | Travel time | Travel Distance | Report Writing | Unsociable Hours Fee | Stand-down Fee
Mobile Clinic | Health Monitoring | Pre-employment Test | Injury Triage Services | Workplace Rehabilitation Assessment | Travel time | Health Monitoring | Hearing Test | Pre-employment Medical Test | Asbestos Medical | Recovery Package | Four Corners of Health Workshops | Strategic Review of Health and Wellbeing at Work | Non Specified | EAP Service Assessment | Injury Triage (No ACC claim) | Office Workstation Injury Prevention Group Presentation | Manual Handling Training Workshop | Rehabilitation Assessment at Workplace | Travel time | Travel Distance | Report Writing | Unsociable Hours Fee | Stand-down Fee | Hearing Test | Hearing health questionnaire, ear examination and Audiometry testing. Copy of individual results will be offered to workers | Near and Distance Vision Assessment | Lung Health questionnaire, height, weight and Spirometry assessment.  Copy of individual results will be offered to workers |  | Drug urine testing will be completed with the use of a six-panel drug test kit which is verified as compliant with AS/NZS 4308:2008 standard. This will test for the presence of Cocaine, Amphetamines, Methamphetamines, Cannabinoids, Benzodiazepines and Opiates.  The testers are NZQA certified in the unit standards US25458- Urine collection and US25511-On site drug screening.  Our pre-employment, random and reasonable-cause testing helps your organization to improve workplace safety for all workers and achieve and maintain a drug and alcohol-free workplace. Proactive can also assist in the development of drug and alcohol testing policy. | Breath alcohol screening will be carried out using a calibrated, AlcoQuant 6020 breath alcohol testing device which complies with the AS3547:1997/ Amendment 1-2000 (Type2) for the measurement of alcohol. | Getting an annual flue vaccine is the first and best available way to protect yourself, your family and colleagues from flue and its potentially serious complications. Having members of your team vaccinated can reduce absenteeism and can lead to a healthier workplace environment. Proactive can also provide a range of other vaccination types, such as Hepatitis. | According to the AS/NZS1715:2009 standard – ‘Selection, use and maintenance of respiratory protective equipment’,  a Mask Fit Test is mandatory for anyone who is required to wear a tight-fitting mask. We can complete a qualitative fit test, which can be used to fit-test tight fitting disposable and reusable half face masks only.  The following topics will also be discussed with the wearer: Storage and cleaning of respirator Valve & gasket inspection Checking for cracks / deformity etc Changing of filters – when & how Importance of a clean-shaven face to achieve a good seal A Certificate of fitness will be issued following assessment. | An Annual summary report will be provided for any health intervention completed as per requirements under Health and Safety at Work Act, General Risk and Workplace. The report will include an overall summary of Occupational Health Screening completed for each worker e.g. hearing, lung function and vision tests etc.  Management Regulations (2016).  Occupational Health risks identified will be highlighted with recommendations. | Understanding whether a prospective new employee is medically and physically able to manage the demands of the role is a valuable part of the recruitment process and form the basis of front-line risk management. The Pre-employment Medical is completed by an Occupational Physician. | Understanding whether a prospective new employee is medically and physically able to manage the demands of the role is a valuable part of the recruitment process and form the basis of front-line risk management. The Pre-Employment Functional Assessment assesses the functional capability of the staff member and provides an indication of whether they can physically cope with the demands of the role – completed by a [NAME] or Exercise Physiologist | Understanding whether a prospective new employee is medically and physically able to manage the demands of the role is a valuable part of the recruitment process and form the basis of front-line risk management. The Pre-employment Health Assessment is a baseline health check | It is important to ensure that any workers driving a vehicle do not have a health condition that would impact on their and others safety on the road. Therefore, Fit For Work specifically offers Driver Medicals which are aligned with the NZTA Medical Aspects of Fitness to Drive requirements. | Our expert team of Occupational Physicians can support your business manage the risk of dealing with asbestos through medical monitoring.  Medical monitoring involves testing a person to identify any changes in their health status because of exposure to certain health hazards arising from their work, including asbestos.  Our Occupational Physicians will check if your staff members health is being harmed by the work they do, and aims to detect early signs of ill-health or disease. Medical monitoring will show if your business has in place effective risk management practices, an integral part of compliance with the Health and Safety at Work (Asbestos) Regulations 2016. | Measurement of airborne asbestos fibres in workplaces where asbestos is disturbed by construction or removal. | Assessment of workers exposed to extremes of temperature, provision of recommendations and education on exposure, duration, PPE and self-management. | Measurement of specific hazardous dust, fumes and chemicals to compare with legislative standards. (WES – Workplace Exposure Standards) | Monitoring of airborne fungal spores and bacterial contaminants. | Sampling and monitoring of workplace and office air quality. | Environmental and personal noise monitoring. (Specifically required to establish if noise levels exceed 85dBA). | Measurement of environmental light levels in comparison with workplace standards. |  | Our Four Corners Resilience™ package will provide you with a bespoke exercise programme aimed at improving the way you move, and improving your fitness to a level where a myriad of health benefits are realised. You will learn to recognise the lifestyle factors that drain your resilience and cause you stress, while at the same time learning how to boost your resilience through adopting proactive ways of eating, thinking, sleeping and exercising. | Our Four Corners Performance™ package is focused on fine tuning, building self- awareness and skill to keep self in check and exploring sleep, nutrition, physical and mindset hacks to reach peak performance. | Wow your team with a Four Corners of Health interactive workshop.  We understand that when looking for the best health and wellbeing workshops, you are purchasing a programme that is delivered over the short term but provides staff, and ultimately your organisation, with multi-year (or lifetime) lasting benefits.  To this end we focus to a high degree on engaging staff members to ensure that the behavioural change ‘sticks’ and remains a constant. | This strategic review, conducted by our team of experts will identify the health or wellbeing needs of your workforce and make recommendations for targeted initiatives based on international evidence and the specific workplace requirements. Importantly this can be catered to any business size and budget.  We are then able to work with your organisation to support a tailored delivery model to transform your business and employees health. | Our Executive Health Risk Screening and Intervention service includes a medical examination, blood tests, hearing vision and lung function testing and resting as well as exercise ECG which is interpreted by a Cardiologist for risk of heart disease. | Proactive’s Employee Assistance Programmes come with a difference. We take a wellbeing based approach and ensure that the services are tailored to meet an employee’s individual needs and aims to empower the employee to discover solutions to help overcome their difficulties. We feel it is vital to address all aspects of life, not solely the mindset corner.  The basic EAP service initially provides a brief number of sessions (up to 3). | Proactive’s Injury Triage can link your injured team member with one of our expert Physiotherapists in a matter of hours.  Along with targeted treatment our team will provide expert advice to ensure a quick recovery. | Proactive’s Injury Triage can link your injured team member with one of our expert Physiotherapists in a matter of hours.  Along with targeted treatment our team will provide expert | Proactive’s Injury Triage can link your injured team member with one of our expert Physiotherapists in a matter of hours.  Along with targeted treatment our team will provide expert | Completed prior to office workstation assessment screens to provide group education on ergonomic workstation setup and injury management principles Benefits: · This information is important for employee compliance with workstation recommendations Time efficient group education followed by individual setup and recommendations | 20-minute worker contact with checklist format report for workers without pain · Assumes worker has completed Fit For Work Office Injury Prevention Presentation (see above) · Basic workstation set-up for good postural alignment and injury prevention practices · Identifies workers with greater risk and in need of additional assessment · Identifies and manages basic problems at workstation prior to symptom development · Basic equipment recommendations with product hand-out to streamline procurement process Provision of Workstation Wellness hand-out | 30-minute worker contact with hand written report or check list format report for workers without pain or discomfort · Basic workstation set-up for good postural alignment and injury prevention practices | 60-75 minute worker contact with typed report and reference photo for workers with pain/discomfort, complex workstation or work task concerns · Workstation set-up for good postural alignment and injury prevention practices · Identifies and manages problems at workstation prior to symptom development · Equipment recommendations with product hand-out to streamline procurement process · Provision of Workstation Wellness hand-out · Individual education on injury prevention principles · Therapeutic client interview regarding symptom development and management · Clinically relevant education tailored to symptom mitigation/management and therapeutic exercise/stretch programme · Detailed recommendations Phone/email follow-up from therapist | Risk of injury increases as the frequency and load of manual handling duties increase.   Understanding the environment that workers carry out their duties enables us to provide manual handling training that is practical, workplace specific and engaging.   Our Four Corners of Health approach links into our manual handling training for the industrial athlete. | Test travel time | Test travel distance | Test report writing | Test unsociable hours | Test stand-down
Occupational Health and Wellbeing |  | Workplace Environmental Monitoring | Workstation Assessments and DPI Prevention |  | Travel Km | Pre-employment Test | Vision Screening | Pre-employment Functional Test | Asbestos Air Sampling | Resilience Package | Manual Handling Workshop |  |  | EAP Treatment Sessions | Injury Triage (ACC Claim, Co-Payment Paid) | Workstation Screen - Group Education |  |  |  |  |  |  |  | Vision Screening
Injury Prevention and Early Intervention |  | Wellbeing and [NAME] | Manual Handling Training |  | Report Writing | Workplace Environmental Monitoring | Spriometry/Lung Function Test | Pre-employment Health Test | Heat and Cold Stress | [NAME] |  |  |  |  |  | Workstation Screen – Individual Education |  |  |  |  |  |  |  | Spriometry/Lung Function Test
Workplace Rehabilitation |  | Workshops |  |  | Unsociable Hours Fee | Wellbeing and [NAME] | Cardiovascular Disease Risk Check | Pre-employment Driver Test | Chemical and Dust Exposure |  |  |  |  |  |  | Comprehensive Workstation Assessment |  |  |  |  |  |  |  | Cardiovascular Disease Risk Check
Travel, [NAME] and [NAME] |  | Strategic Review |  |  | Stand-down Fee | Workshops | Drug Testing |  | [NAME] and [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drug Testing
 |  | Executive Health Screening |  |  |  | Strategic Review | Breath Alcohol Testing |  | Indoor Air Quality Monitoring |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Breath Alcohol Testing
 |  | EAP Services |  |  |  | Executive Health Screening | Flu Vaccination |  | Industrial Noise Monitoring |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vaccinations
 |  |  |  |  |  | EAP Services | Mask Fit Test |  | Industrial Lighting Monitoring |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mask Fit Test
 |  |  |  |  |  | Injury Triage Services | Annual Company Report for Workplace Health Testing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual Company Report for Workplace Health Testing
 |  |  |  |  |  | Workstation Assessments and DPI Prevention | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pre-employment Medical Test
 |  |  |  |  |  | Manual Handling Training | Hep A Vaccination |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pre-employment Functional Test
 |  |  |  |  |  | Workplace Rehabilitation Assessment | Tetanus Vaccination |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pre-employment Health Test
 |  |  |  |  |  | Travel | Travel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pre-employment Driver Test
 |  |  |  |  |  | Travel Km | Report Writing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asbestos Medical
 |  |  |  |  |  | Reporting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asbestos Air Sampling
 |  |  |  |  |  | Unsociable Hours Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heat and Cold Stress
 |  |  |  |  |  | Stand-down Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chemical and Dust Exposure
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] and [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indoor Air Quality Monitoring
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Industrial Noise Monitoring
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Industrial Lighting Monitoring
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recovery Package
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resilience Package
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Four Corners of Health Workshops
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Strategic Review of Health and Wellbeing at Work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non Specified
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EAP Service Assessment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injury Triage (No ACC claim)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injury Triage (ACC Claim, Co-Payment Paid)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Office Workstation Injury Prevention Group Presentation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Workstation Screen - Group Education
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Workstation Screen – Individual Education
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comprehensive Workstation Assessment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manual Handling Training Workshop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rehabilitation Assessment at Workplace
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel Distance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Report Writing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unsociable Hours Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-down Fee