ACC EXCEL Pandu

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

- tekan

0-1 + tarik
Nilai nilai T Panjang Batang skala gaya
REAKSI NILAI BEBAN beban Nama Batang
konv (kg) (m) batang
(T)
RA 2.86493 P1 1.00 1000 S1 1.191136 2.80737
RB 3.11 P2 0.90 900 S2 1.384934 -4.48738
P3 0.60 600 S3 0.861838 -1.48207
P4 0.50 500 S4 0.690267 3.60218
P5 0.80 800 S5 0.851337 6.90653
P6 0.80 800 S6 1.073084 -9.51169
P7 1.00 1000 S7 0.569568 -1.08726
P8 0.50 500 S8 1.207198 -6.70922
P9 0.80 800 S9 0.953275 9.35002
P10 0.60 600 S10 0.747523 -6.73791
P max = 1.00 S11 1.233889 10.30474
konv. P = 1000 S12 1.207198 -6.70922
S13 0.747523 -6.43489
S14 0.953275 9.34478
S15 0.569568 -0.94375
S16 1.073084 -9.63446
S17 0.851337 7.01807
S18 0.690267 3.54295
S19 0.861838 -1.26396
S20 1.384934 -4.71672
S21 1.191136 2.63388
Batang maks 1.384934 MAX

144.41121382
konversi skala
s(v) s(h) PX PZ
batang

2807.37 0.42396 0.953516 P1 0.78885 0.614584


-4487.38 -0.75922 0.201107 P2 0.72874 0.528153
-1482.07 -0.242628 -0.54569 P3 0 0.6
3602.18 0.462825 1.040931 P4 0.37839 0.326841
6906.53 1.413862 0.761303 P5 0.57973 0.551281
-9511.69 -1.720555 -0.396493 P6 0.30391 0.740027
-1087.26 -0.628537 0.236686 P7 0.36992 0.929065
-6709.22 -1.70952 0.002525 P8 0.28016 0.414142
9350.02 1.413862 1.35201 P9 0.34674 0.720951
-6737.91 -0.939763 0.313563 P10 0.27712 0.532172
10304.74 2.778546 1.390494
-6709.22 1.70952 -1.713547
-6434.89 -0.939763 -0.941977 REAKSI TUMPUAN (ACAD)
9344.78 1.965453 1.970084 REAKSI NILAI KONV
-943.75 -0.628537 -0.630018 RAV 2.85093 2850.93
-9634.46 -1.720555 -1.724609 RAH 0.28293 282.93400
7018.07 1.413862 1.417193 RB 3.10629 3106.29
3542.95 0.462825 0.463916
-1263.96 -0.242628 -0.2332
-4716.72 -0.75922 -0.761009
2633.88 0.423959 0.424957
10304.74

RaH di SAP 283.08


RaV di SAP 2850.89
Rb di SAP 3106.33
KONVERSI
KONVERSI PX BATANG (SAP)
PZ

789 614.584 X KONVERSI Z KONVERSI


728.735 528.153 0.725608 104.785932037 0.412091 59.5105615141
0 600 0.391972 56.6051523033 0.541023 78.1297881343
378.385 326.841 0.428676 61.9056214953 0.22652 32.7120281544
579.732 551.281 0.208633 30.1289447728 0.050624 7.3106732884
303.909 740.027 0.703466 101.588378941 0.252837 36.5124980685
369.916 929.065 0.703466 101.588378941 0.981052 141.67491014
280.155 414.142 0.208633 30.1289447728
346.741 720.951 0.428676 61.9056214953
277.115 532.172 0.391972 56.6051523033
0.725608 104.785932037

RaH di Excel 282.93


RaV di Excel 2850.93
Rb di Excel 3106.29
luas
member Panjang
tampang l/# S s (v) (l/#)*S*s s (h) (l/#)*S*s
(batang) (cm) = l
(cm2) = #
s1 119.11 5.80 20.53683 2807.37 0.423959 24443.09 0.953516 54974.365
s2 138.49 5.80 23.87817 -4487.38 -0.75922 81350.66 0.201107 -21548.68
s3 86.18 5.80 14.85928 -1482.07 -0.242628 5343.276 -0.54569 12017.459
s4 69.03 5.80 11.90116 3602.18 0.462825 19841.33 1.040931 44624.757
s5 85.13 5.80 14.67822 6906.53 1.413862 143331.2 0.761303 77177.578
s6 107.31 5.80 18.50145 -9511.69 -1.720555 302783.2 -0.396493 69774.832
s7 56.96 5.80 9.820138 -1087.26 -0.628537 6710.917 0.236686 -2527.107
s8 120.72 5.80 20.81376 -6709.22 -1.70952 238724.2 0.002525 -352.6011
s9 95.33 5.80 16.43578 9350.02 1.413862 217274.9 1.35201 207769.82
s10 74.75 5.80 12.88833 -6737.91 -0.939763 81609.36 0.313563 -27229.93
s11 123.39 5.80 21.27395 10304.74 2.778546 609119.8 1.390494 304827.55
s12 120.72 5.80 20.81376 -6709.22 1.70952 -238724 -1.713547 239286.53
s13 74.75 5.80 12.88833 -6434.89 -0.939763 77939.19 -0.941977 78122.81
s14 95.33 5.80 16.43578 9344.78 1.965453 301871.5 1.970084 302582.79
s15 56.96 5.80 9.820138 -943.75 -0.628537 5825.102 -0.630018 5838.8278
s16 107.31 5.80 18.50145 -9634.46 -1.720555 306691.4 -1.724609 307414
s17 85.13 5.80 14.67822 7018.07 1.413862 145645.9 1.417193 145989
s18 69.03 5.80 11.90116 3542.95 0.462825 19515.11 0.463916 19561.115
s19 86.18 5.80 14.85928 -1263.96 -0.242628 4556.911 -0.2332 4379.839
s20 138.49 5.80 23.87817 -4716.72 -0.75922 85508.37 -0.761009 85709.861
s21 119.11 5.80 20.53683 2633.88 0.423959 22932.57 0.424957 22986.552
Profil Baja 2L 60.60.5 2462293.75166992 1931379.4002909
modulus elastisitas baja lendutan vertikal maximum
2038902 kg/cm2 bentang
lendutan vertikal joint x
1.207657 cm
lendutan horizontal joint y OK
0.947265 cm OK
Panjang
(m) = l
1.19
1.38
0.86
0.69
0.85
1.07
0.57
1.21
0.95
0.75
1.23
1.21
0.75
0.95
0.57
1.07
0.85
0.69
0.86
1.38
1.19

4.91671 meter

2.0 cm
TABEL PERBANDINGAN GRAFIS ACAD DAN SAP
ACAD SAP

konversi
skala gaya konversi skala skala gaya
skala batang ABS RESIDU
batang (ACAD) batang (ACAD) batang (SAP)
(SAP)

s1 2.807365 2807.365 2.805110274 2807.540 0.00225473


s2 -4.487375 -4487.375 -4.4874 -4487.400 2.5E-05
s3 -1.482071 -1482.071 -1.48217 -1482.170 9.9E-05
s4 3.602175 3602.175 3.60237 3602.370 0.000195
s5 6.906533 6906.533 6.90669 6906.690 0.000157
s6 -9.511687 -9511.687 -9.51196 -9511.960 0.000273
s7 -1.08726 -1087.260 -1.08722 -1087.220 4E-05
s8 -6.709215 -6709.215 -6.70933 -6709.330 0.000115
s9 9.350016 9350.016 9.35028 9350.280 0.000264
s10 -6.737908 -6737.908 -6.7381 -6738.100 0.000192
s11 10.304739 10304.739 10.30493 10304.930 0.000191
s12 -6.709215 -6709.215 -6.70933 -6709.330 0.000115
s13 -6.434888 -6434.888 -6.43496 -6434.960 7.2E-05
s14 9.344784 9344.784 9.34493 9344.930 0.000146
s15 -0.943746 -943.746 -0.94379 -943.790 4.4E-05
s16 -9.634457 -9634.457 -9.63459 -9634.590 0.000133
s17 7.018071 7018.071 7.01818 7018.180 0.000109
s18 3.542951 3542.951 3.54299 3542.990 3.9E-05
s19 -1.263956 -1263.956 -1.26398 -1263.980 2.4E-05
s20 -4.716718 -4716.718 -4.71677 -4716.770 5.2E-05
s21 2.633877 2633.877 2.63391 2633.910 3.3E-05
GAYA BATANG 0.00457273 = JUMLAH
0.00021775 = RATA - RATA
OK
Buat grafik perbandingan antara skala gaya batang ACAD dengan skala gaya batang SAP!

Chart Title
15000.000

10000.000

5000.000

0.000
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
-5000.000

-10000.000

-15000.000

Column D Column F

You might also like