QUESTION 2 [ 50 MARKS] Use the Matrix Stiffness method on a spreadsheet (our standard is Excel and write a program to an

[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 133 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