..Ga 5 Excell Programming Question 4

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 35

MEMBER CONNECTION

MemberStart Point End point members


1 1 2 1
2 2 3 2
3 3 4 3
4 4 5 4
5 5 6 5
6 6 7 6
7 7 5 7
8 5 3 8
9 3 1 9
10 2 4 10
11 4 6 11

member sin cos

1 0.928476690885 0.371391

2 0.928476690885 0.371391

3 0.928476690885 0.371391

4 0.928476690885 0.371391

5 0.928476690885 0.371391

6 0.928476690885 0.371391

7 0.928476690885 0.371391

8 0.928476690885 0.371391

9 0.928476690885 0.371391

10 0.928476690885 0.371391

11 0.928476690885 0.371391
MEMBER N(KN) nv(kn) L
1 AB -44.739949 -0.898 5.385165
2 BC 28.5844548 -0.18 5.385165
3 CD -7.0437956 0.1795 5.385165
4 DE -50.64209 -0.18 5.385165
5 EF 29.1014306 0.1795 5.385165
6 FG -43.705998 -0.18 5.385165
7 GE 16.232 0.0667 4
8 EC 29.848 0.4667 4
9 CA 16.616 0.3333 4
10 BD 27.232 -0.267 4
11 DF -27.04 -0.133 4

MEMBER N(KN) nv(kn) L


1 AB -44.739949 -0.718 5.385165
2 BC 28.5844548 0.718 5.385165
3 CD -7.0437956 0.359 5.385165
4 DE -50.64209 -0.359 5.385165
5 EF 29.1014306 0.359 5.385165
6 FG -43.705998 -0.359 5.385165
7 GE 16.232 0.1333 4
8 EC 29.848 0.4 4
9 CA 16.616 0.2667 4
10 BD 27.232 0.5333 4
11 DF -27.04 -0.267 4

MEMBER N(KN) nv(kn) L


1 AB -44.739949 -0.539 5.385165
2 BC 28.5844548 0.5385 5.385165
3 CD -7.0437956 -0.539 5.385165
4 DE -50.64209 -0.539 5.385165
5 EF 29.1014306 0.5385 5.385165
6 FG -43.705998 -0.539 5.385165
7 GE 16.232 0.2667 4
8 EC 29.848 0.6 4
9 CA 16.616 0.2 4
10 BD 27.232 0.4 4
11 DF -27.04 0.4 4

MEMBER N(KN) nv(kn) L


1 AB -44.739949 -0.18 5.385165
2 BC 28.5844548 0.1795 5.385165
3 CD -7.0437956 0.359 5.385165
4 DE -50.64209 0.1795 5.385165
5 EF 29.1014306 -0.18 5.385165
6 FG -43.705998 -0.898 5.385165
7 GE 16.232 0.3333 4
8 EC 29.848 0.4667 4
9 CA 16.616 0.0667 4
10 BD 27.232 -0.133 4
11 DF -27.04 0.2667 4

MEMBER N(KN) nv(kn) L


1 AB -44.739949 -0.359 5.385165
2 BC 28.5844548 0.359 5.385165
3 CD -7.0437956 -0.359 5.385165
4 DE -50.64209 0.282 5.385165
5 EF 29.1014306 0.718 5.385165
6 FG -43.705998 -0.718 5.385165
7 GE 16.232 0.2667 4
8 EC 29.848 -0.4 4
9 CA 16.616 0.1333 4
10 BD 27.232 -0.267 4
11 DF -27.04 0.5333 4

A manual program for the given truss

1. Understanding the truss structure


2. Formulating equilibrium equations (joints )
3. Solving the system of equations manually
4. Solving deflection

Analysis and guide understanding of how

1. Structure Understanding:
From the image
· Type of Truss: A combination of triangle
· Given Forces:
· 15 kN at B and G (vertical forces)
· 20 kN downward at joint C
· Distributed load: 6.78 kN/m across segm
Supports
· [A] is a pinned support (allows rotation
· [G] is a roller support (allows moveme
Geometry
· Angles of 68.198° in both triangles
· All horizontal spans are 4m

Step-by-Step Truss Analysis (Manual)


Step 1: Reaction Forces at Supports
· Use equilibrium equations to find the re

1 Sum of Moments about A (Sigma M_A = 0)


Taking moments about point (A)
(15x2)+(20x4)+(13,56x6) +(20x8)+(13,56x10)+
RG= 55,58KN

VERTICAL REACTION
APPLYING ( SIGMA FY=0)
RA-15-13,56-13,56-20-20-15+55,58
RA = 41,54KN

Step 2: Analyzing Individual Joints


We'll now apply equilibrium at each joint to find t
Joint A:
· Let (FAB) and FAC be the forces in mem
· Apply equilibrium equations:

Sigma F_x = 0
AC +ABCOS 68,198=0
AC=16,504(T)

VERTICAL FORCES
ABSIN 68,198+RA=0
AB SIN68,198+41,54=0
AB = 44,437(C)

JOIN B
(Sigma fx=0)
_EG-FGCOS68,198=0
-EG-(-43,685)COS 68,198=0
EG=16,225(T)

VERTICAL
(SIGMAFY=0)
-15+55,58+ FG SIN68,198=0
FGSIN 68,198=-40,56
FG= 43,685(C) KN

ALL JOINTS TO GET MEMBERS ARE CALCULA

calculating deflection of each node


re draw a structure by show only deflection at th
From the image
· Type of Truss: A combination of triangle
· Given Forces:
· 1KN
Supports
· [A] is a pinned support (allows rotation
· [G] is a roller support (allows moveme
Geometry
· Angles of 68.198° in both triangles
· All horizontal spans are 4m

Step-by-Step Truss Analysis (Manual)


DEFLECTION . node (C)
Step 1: Reaction Forces at Supports
· Use equilibrium equations to find the re
Sum of Moments about A (Sigma M.A = 0)
Taking moments about point (A)
(1X4) – ( RGX12) =0
RG= 0,333KN

Vertical Reaction at FY=0


RA-1 + 0,333
RA = 0,667 KN

Step 2: Analyzing Individual Joints


We'll now apply equilibrium at each joint to find t
Joint A:
· Let (FAB) and FAC be the forces in mem
· Apply equilibrium equations:

Sigma F_x = 0
AC +ABCOS68,98=0
AC-0,718COS 68,198=0
AC= 0,266 (T)

(SIGMA FY=0)
AB SIN68,198 +0,667=0
AB = 0,718(c)
ALL JOINT TO GETS MEMBERS ARE CALCULATED

· Area provided (A)


· Moment of inertia (E)
· Than using above member to calculate d
)
LENGTH Member Angle(RADDegrees
5.3851648071345 1 1.19029 68.198591
5.3851648071345 2 1.19029 68.198591
5.3851648071345 3 1.19029 68.198591
5.3851648071345 4 1.19029 68.198591
5.3851648071345 5 1.19029 68.198591
5.3851648071345 6 1.19029 68.198591
4 7 1.19029 68.198591
4 8 1.19029 68.198591
4 9 1.19029 68.198591
4 10 1.19029 68.198591
4 11 1.19029 68.198591

COMPUTATION SECTION

UDL DIST JOINT


6.78 4 2
13.56
UDL(p) DIST
13.56 6
13.56 10

UNITE LOADINGS VERTICAL


DEFLECTION

A E AE NnL NnL/AE
48125 210000 10106250000 216.2431 2.1397E-08
48125 210000 10106250000 -27.6316 -2.734E-09
48125 210000 10106250000 -6.809 -6.737E-10
48125 210000 10106250000 48.95402 4.8439E-09
48125 210000 10106250000 28.13138 2.7836E-09
48125 210000 10106250000 42.24913 4.1805E-09
48125 210000 10106250000 4.328533 4.283E-10
48125 210000 10106250000 55.71627 5.5131E-09
48125 210000 10106250000 22.15467 2.1922E-09
48125 210000 10106250000 -29.0475 -2.874E-09
48125 210000 10106250000 14.42133 1.427E-09

A E AE NnL NnL/AE
48125 210000 10106250000 172.9945 1.7118E-08
48125 210000 10106250000 110.5266 1.0936E-08
48125 210000 10106250000 -13.618 -1.347E-09
48125 210000 10106250000 97.90804 9.6879E-09
48125 210000 10106250000 56.26277 5.5671E-09
48125 210000 10106250000 84.49826 8.361E-09
48125 210000 10106250000 8.657067 8.5661E-10
48125 210000 10106250000 47.7568 4.7255E-09
48125 210000 10106250000 17.72373 1.7537E-09
48125 210000 10106250000 58.09493 5.7484E-09
48125 210000 10106250000 28.84267 2.8539E-09

A E AE NnL NnL/AE
48125 210000 10106250000 129.7459 1.2838E-08
48125 210000 10106250000 82.89492 8.2023E-09
48125 210000 10106250000 20.42701 2.0212E-09
48125 210000 10106250000 146.8621 1.4532E-08
48125 210000 10106250000 84.39415 8.3507E-09
48125 210000 10106250000 126.7474 1.2541E-08
48125 210000 10106250000 17.31413 1.7132E-09
48125 210000 10106250000 71.6352 7.0882E-09
48125 210000 10106250000 13.2928 1.3153E-09
48125 210000 10106250000 43.5712 4.3113E-09
48125 210000 10106250000 -43.264 -4.281E-09

A E AE NnL NnL/AE
48125 210000 10106250000 43.24862 4.2794E-09
48125 210000 10106250000 27.63164 2.7341E-09
48125 210000 10106250000 -13.618 -1.347E-09
48125 210000 10106250000 -48.954 -4.844E-09
48125 210000 10106250000 -28.1314 -2.784E-09
48125 210000 10106250000 211.2457 2.0902E-08
48125 210000 10106250000 21.64267 2.1415E-09
48125 210000 10106250000 55.71627 5.5131E-09
48125 210000 10106250000 4.430933 4.3843E-10
48125 210000 10106250000 -14.5237 -1.437E-09
48125 210000 10106250000 -28.8427 -2.854E-09

A E AE NnL NnL/AE
48125 210000 10106250000 86.49724 8.5588E-09
48125 210000 10106250000 55.26328 5.4682E-09
48125 210000 10106250000 13.618 1.3475E-09
48125 210000 10106250000 -76.8999 -7.609E-09
48125 210000 10106250000 112.5255 1.1134E-08
48125 210000 10106250000 168.9965 1.6722E-08
48125 210000 10106250000 17.31413 1.7132E-09
48125 210000 10106250000 -47.7568 -4.725E-09
48125 210000 10106250000 8.861867 8.7687E-10
48125 210000 10106250000 -29.0475 -2.874E-09
48125 210000 10106250000 -57.6853 -5.708E-09

he given truss

structure
equations (joints )
uations manually

erstanding of how I created my programe

ombination of triangle panels (two sections supported at (A) and (G)


(vertical forces)
at joint C
6.78 kN/m across segment DF (length 4m)

pport (allows rotation, no horizontal/vertical movement).


port (allows movement horizontally but restricts vertical displaceme

° in both triangles
ns are 4m

ysis (Manual)
Supports
quations to find the reaction forces at points (A) and (G).

(Sigma M_A = 0)

+(20x8)+(13,56x10)+(15x12)-(RGX12)

5+55,58

dual Joints
at each joint to find the forces in the members.

be the forces in members AB and AC.


equations:

MBERS ARE CALCULATED BY USING ABOVE PROCEDURE FROM

ach node
w only deflection at that point (1 KN)

ombination of triangle panels (two sections supported at \(A\) and \(G

pport (allows rotation, no horizontal/vertical movement).


port (allows movement horizontally but restricts vertical displaceme

° in both triangles
ns are 4m

ysis (Manual)

Supports
quations to find the reaction forces at points (A) and (G).
Sigma M.A = 0)

dual Joints
at each joint to find the forces in the members.

be the forces in members AB and AC.


equations:

RS ARE CALCULATED USING THE SAME PROCEDURE TO FIND DEFLEC

member to calculate deflection by(


TRUSS PROGRAMIG

GEOMETRY COORDINATE

Joint X Y
1 0 0
2 2 5
3 4 0
4 6 5
5 8 0
6 10 5
7 12 0

member YOUNG AREA


1 210000 48125
2 210000 48125
3 210000 48125
4 210000 48125
5 210000 48125
6 210000 48125
7 210000 48125
8 210000 48125
9 210000 48125
10 210000 48125
11 210000 48125

Each member is 275mmx175mm

MEBERMEMER (KN)
FORCES DISTANCE 1 AB -44.739949
15 2 2 BC 28.584455
20 4 3 CD -7.0437956
20 8 4 DE -50.64209
15 12 5 EF 29.101431
6 FG -43.705998
RG 55.58 7 GE 16.232
RA 41.54 8 EC 29.848
9 CA 16.616
10 BD 27.232
11 DF -27.04

MEMBEMEMBER KN
1 AB -0.8975275
2 BC -0.1795055
FORCES DISTANCES 3 CD 0.1795055
1 2 4 DE -0.1795055
RG 12 5 EF 0.1795055
6 FG -0.1795055
7 GE 0.0666667
RG 0.16666667 8 EC 0.4666667
RA 0.83333333 9 CA 0.3333333
10 BD -0.2666667
11 DF -0.1333333

MEMBER KN
1 AB -0.718022
2 BC 0.718022
3 CD 0.359011
FORCES DISTANCE 4 DE -0.359011
1 4 5 EF 0.359011
RG 12 6 FG -0.359011
7 GE 0.1333333
8 EC 0.4
RG 0.333333333 9 CA 0.2666667
RA 0.666666667 10 BD 0.5333333
11 DF -0.2666667
MEMBERS KN
FORCE DISTANCE 1 AB -0.5385165
1 6 2 BC 0.5385165
RG 12 3 CD -0.5385165
4 DE -0.5385165
5 EF 0.5385165
RG 0.5 6 FG -0.5385165
RA 0.5 7 GE 0.2
8 EC 0.6
9 CA 0.2
10 BD 0.4
11 DF 0.4

MEMBER KN
1 AB -0.1795055
2 BC 0.1795055
FORCES DISTANCE 3 CD 0.359011
1 2 4 DE 0.1795055
RA 12 5 EF -0.1795055
6 FG -0.8975275
7 GE 0.3333333
RA 0.16666667 8 EC 0.4666667
RG 0.83333333 9 CA 0.0666667
10 BD -0.1333333
11 DF 0.2666667

MEMBERS KN
1 AB -0.359011
2 BC 0.359011
FORCES DISTANCE 3 CD -0.359011
1 4 4 DE 0.281978
RA 12 5 EF 0.718022
6 FG -0.718022
RA 0.33333333 7 GE 0.2666667
RG 0.66666667 8 EC -0.4
9 CA 0.1333333
10 BD -0.2666667
11 DF 0.5333333
d at (A) and (G).
cal displacement).
EDURE FROM JOINT A TO G….
d at \(A\) and \(G\)).

cal displacement).
O FIND DEFLECTION AT EACH POINT

You might also like