# HW_03.docx.pdf - ENGR 112 HW#3 NAME_ For this homework you...

• 3

This preview shows page 1 - 2 out of 3 pages.

The preview shows page 1 - 2 out of 3 pages.
ENGR 112HW#3NAME________________________For this homework you will be making two spreadsheets. The spreadsheets to make areoutlined below. Put both of the spreadsheets in one file by having #1 on sheet-1, and #2on sheet-2. There are questions to be answered for problem #1. Please put the answersto these questions in a word document and include with the Excel file when you turn inthis assignment electronically.1.Refer to the worksheet shown, set up to calculate the displacement of a spring.Hooke’s law states the force ( F , in Newtons) applied to a spring is equal to thestiffness of the spring ( k , in Newtons per meter) times the displacement ( x , in meters):F = kx .Cell A3 contains a data validation list of springs. The stiffness (cell B3) and maximumdisplacement (cell C3) values are found using a VLOOKUP function linked to the tableshown at the right side of the worksheet. These data are then used to determine thedisplacement of the spring at various mass values. A warning is issued if the

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 3 pages?