CEE 3804 – Computer Applications in Civil Engineering Spring 2022
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
CEE 3804 – Computer Applications in Civil Engineering
Spring 2022
Due in Canvas
Optimization and Curve Fitting
By submitting in Canvas, you attest that this assignment has been completed in strict accordance with the Virginia Tech Honor Code and the Course Syllabus.
The deliverables include one Excel file with multiple worksheets. The deliverables should satisfy the following requirements:
- If you are asked to provide a rationale for your answer, it should be provided in the form of a text box in each worksheet.
- Name the tabs in the Excel file “Problem 1”, “Problem 2”
- Keep a backup of all the files that you are submitting.
- Each problem is worth 25 points.
Problem 1 – Damped Vibration
Engineers often study the movement of damped oscillating objects. One such example would be a vibrating cantilever beam. A simple model for the motion of the tip of the beam results in the equation
x x0e t cos t sin t
where t is the time and the parameters and depend on the mass ofthe beam and the dynamic characteristics ofthe system.
Determine the values of x0, , and for a beam that experiences the following displacements as a function oftime:
t (sec) |
x (in) |
1.0 |
7.822 |
2.0 |
1.533 |
3.0 |
-2.979 |
Briefly explain your thought process and include screen captures of any relevant tools (e.g. Solver input dialog) you use to complete the problem. Note that in this case, the value for x0 could be positive or negative; the values for and should be positive.
Problem 2 – Quadratic Interpolation (VBA programming)
In class, we examined quadratic interpolation. We also looked at the VBA code for a linear interpolation function, INTERP().
Develop an INTERPQUAD() function using VBA to perform quadratic interpolation. You can use the linear interpolation code as a model (or you can start from scratch, if you would prefer).
Demonstrate that your code works by calculating the kinematic viscosity ofwater at:
(a) 11.2°C to match what we did in class
(b) 42.0°C
Also, include a screen capture of your VBA code in the worksheet.
REMEMBER: DON’T FORGET TO SAVE YOUR WORKBOOK WITH MACROS ENABLED.
2022-03-30