..Ga 5 Excell Programming Question 4
..Ga 5 Excell Programming Question 4
..Ga 5 Excell Programming Question 4
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
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
VERTICAL REACTION
APPLYING ( SIGMA FY=0)
RA-15-13,56-13,56-20-20-15+55,58
RA = 41,54KN
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
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
COMPUTATION SECTION
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
° 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.
ach node
w only deflection at that point (1 KN)
° 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.
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
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