Question: Solve this problem using Excel for matrix structural analysis. Please show the steps and, most importantly, display the equations or commands you used in Excel.

Solve this problem using Excel for matrix structural analysis. Please show the steps and, most importantly, display the equations or commands you used in Excel.

Determine the vertical deflections at joint

2

and

4,

the internal forces in all members, and the reaction forces at supports of the truss in the figure below. Take A

= 0.0015

2

and E

= 200

GPa for each member.

Solve this problem using Excel for matrix

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Civil Engineering Questions!

Three rigid bodies ( 2 , 3 , 4 ) are connected by 6 springs as shown in the figure below. The spring system is laterally supported by walls 1 and 5 . A lateral force of C applied on body 3 in the...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Please show all steps! Yes, the question should be as it is...it wont add up to 100%. Problem #3 (10 points) (Problem 3 - use Excel and Polymath) A liquid feed stream (F, 100 kg/h) mixture containing...

In this question you will be asked to reflect on a project you have been involved in or observed, in which a design evolved, or could have evolved, through applying a theory of user behaviour. You...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Consider the trigonometric series a0 2 + X r=1 (ar cos rx + br sin rx) where a0, a1, a2, . . . and b1, b2, . . . are constants and suppose that f(x) is a periodic function of x with period 2. (a)...

In a Hopfield neural network configured as an associative memory, with all of its weights trained and fixed, what three possible behaviours may occur over time in configuration space as the net...

undefined Modeling Problem - Wind Farm Development Part 1 - Developing your Mathematical Model (Written Solution) Problem: Zee's Alternative Energies was founded in 2000 to increase the use of...

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

Consider CAPM theory with the AEX-index as market portfolio (mpf). Assume that the mpf has expected (annual) return rM = 8%, and volatility oM = 25%. The risk free rate is 2%. a) make a sketch of (i)...

Based on the following data, determine the cost of merchandise sold for April: Merchandise inventory, April 1 $ 15,000 Merchandise inventory April 30 28,000 Purchases 290,000 Purchases returns and...

E4-18 (Algo) Recording the Effects of Adjusting Entries and Reporting a Corrected Income Statement and Balance Sheet LO4-1, 4-2 Skip to question [The following information applies to the questions...

High-Low Method to Determine Fixed Cost and Variable Rate Dohini Manufacturing Company had the following 12 months of data on purchasing cost and number of purchase orders. Number of Purchase...