niosh lifting assignment, please show in excel

need help setting up the tables in excel

An oven is used to heat age components that are placed on fixtures. The oven is fed by a conveyor. The height of the conveyor for the oven is 15 inches from the floor. Fixtures containing the components are moved from a cart onto the conveyor. The fixtures and components each weigh 20 pounds. The fixtures have a handle. The cart height is 25 inches from the floor. The worker cannot stand any closer than 5 inches from the end the conveyor. The cart is placed opposite the conveyor, so angles of asymmetry between hands and feet are 90 degrees for both the origin and destination of the motion, The front of the cart is 24 In away from the conveyor. You choose where the worker stands. The worker does not move their feet during the lift. The worker loads fixtures at a rate of 10 per minute on average for a work duration up to 15 minutes. Objective - State the objective (problem to be solved in a complete sentence in past tense that covers the problem completely, Review your objective after all items completed to ensure it matches all other information, Focus the objective on the analysis instead of the tools. Definitions (a section defining any technical terms used) Outputs - Tables Excel spreadsheet to compute the recommended Weight Limit (RWL) and Lifting index (L) for the operator holding the fixture at the origin and destination of each of the operations described above. The table should have inputs, interim calculations, and outputs. There may not be any input data in the formula cells. Decision Assess the hazard of the worke, is the work is hazardous or not) based on computed Rws and Us Explanation - Why did you select hazardous or not? How should the work be redesigned to reduce the hazard (change some of the inputs)? Indicate the multipliers in the NIOSH lifting equation that would be affected by your change Doa second Worksheet Tabre-calculate the RW. and L based on the changes in your Explanation State the improved RWL's and 'spiven your improvements reference the recalculation in your explanation. Do not have a second objective, decision, or evaluation Follow the attached technical content rubric including all sections, Contact me if you are having trouble with the assignment or the rubric All tables must follow the format in Engineering Communications An oven is used to heat age components that are placed on fixtures. The oven is fed by a conveyor. The height of the conveyor for the oven is 15 inches from the floor. Fixtures containing the components are moved from a cart onto the conveyor. The fixtures and components each weigh 20 pounds. The fixtures have a handle. The cart height is 25 inches from the floor. The worker cannot stand any closer than 5 inches from the end the conveyor. The cart is placed opposite the conveyor, so angles of asymmetry between hands and feet are 90 degrees for both the origin and destination of the motion, The front of the cart is 24 In away from the conveyor. You choose where the worker stands. The worker does not move their feet during the lift. The worker loads fixtures at a rate of 10 per minute on average for a work duration up to 15 minutes. Objective - State the objective (problem to be solved in a complete sentence in past tense that covers the problem completely, Review your objective after all items completed to ensure it matches all other information, Focus the objective on the analysis instead of the tools. Definitions (a section defining any technical terms used) Outputs - Tables Excel spreadsheet to compute the recommended Weight Limit (RWL) and Lifting index (L) for the operator holding the fixture at the origin and destination of each of the operations described above. The table should have inputs, interim calculations, and outputs. There may not be any input data in the formula cells. Decision Assess the hazard of the worke, is the work is hazardous or not) based on computed Rws and Us Explanation - Why did you select hazardous or not? How should the work be redesigned to reduce the hazard (change some of the inputs)? Indicate the multipliers in the NIOSH lifting equation that would be affected by your change Doa second Worksheet Tabre-calculate the RW. and L based on the changes in your Explanation State the improved RWL's and 'spiven your improvements reference the recalculation in your explanation. Do not have a second objective, decision, or evaluation Follow the attached technical content rubric including all sections, Contact me if you are having trouble with the assignment or the rubric All tables must follow the format in Engineering Communications