Page 1 of 1
QUESTION 2 [ 50 MARKS] Use the Matrix Stiffness method on a spreadsheet (our standard is Excel and write a program to an
Posted: Wed Mar 30, 2022 9:12 am
by answerhappygod
- Question 2 50 Marks Use The Matrix Stiffness Method On A Spreadsheet Our Standard Is Excel And Write A Program To An 1 (33.41 KiB) Viewed 135 times
QUESTION 2 [ 50 MARKS] Use the Matrix Stiffness method on a spreadsheet (our standard is Excel and write a program to analyse the structure in Figure 1. Solve the structure using your spreadsheet and hand calculation, compare your hand calculation with your spreadsheet analysis and comment. Assume any information you think is needed in solving the problem Provide us with: • Printout of the program. (28) • A detailed manual explaining the program, how to use the program, entering of data and obtaining of the results, etc. Allowable to be integrated throughout the program. (8) • Hand calculations of the problem above. (14) 15 KN B E 6 m 7 m AE and El are constant FIGURE 1