Download - Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Transcript
Page 1: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Data Kapal

Tipe Kapal = Oil Carrier Ket :Length between perpendiculars (Lpp) = 97.56 m 1 m = 3.28084 feetLength of waterline (Lwl) = 100.4868 m 1 knot = 0.514 m/sLength Displacement (Ldisp) = 99.0234 mLebar (B) = 16 m Nilai L (97%LWL) =Tinggi (H) = 8.5 mSarat Air (T) = 6.36 m 0.1641493745Kecepatan Dinas (Vs) = 13.5 knot 6.09201225Koefisien Blok (δ) = 0.6909 133.0185247514

Koefisien Midship (β) = 0.998 0.0652493763

Koefisien Perismatik (φ) = 0.6923LCB = 0.8497 m = 6961.9375760256

Menghitung Cf menggunakan metode ATTC 1947

Speed (knot) Rn Cf S

14 766811254.294804 0.0015816532 2186.618133613.5 739425138.069989 0.001588987 2186.6181336

13 712039021.845175 0.0015966476 2186.6181336

12 657266789.395546 0.0016130648 2186.618133611 602494556.945917 0.0016311777 2186.618133610 547722324.496288 0.0016513429 2186.6181336

9 492950092.04666 0.0016740384 2186.6181336

m3

Page 2: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Menghitung Cf menggunakan metode ITTC 1957Speed (knot) Rn Cf S

14 766811254.294804 0.001582 2186.6181336 91.820953879213.5 739425138.069989 0.001590 2186.6181336 85.772525539

13 712039021.845175 0.001597 2186.6181336 79.917603406912 657266789.395546 0.001614 2186.6181336 68.791649531511 602494556.945917 0.001632 2186.6181336 58.450240697310 547722324.496288 0.001652 2186.6181336 48.9012612062

9 492950092.04666 0.001674 2186.6181336 40.153486226

Menghitung Cf menggunakan metode Hughes Line

Speed (knot) Rn Cf S

14 766811254.294804 0.001405 2186.618133613.5 739425138.069989 0.001411 2186.6181336

13 712039021.845175 0.001418 2186.618133612 657266789.395546 0.001432 2186.618133611 602494556.945917 0.001449 2186.618133610 547722324.496288 0.001467 2186.6181336

9 492950092.04666 0.001487 2186.6181336

RF

Page 3: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 4: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 5: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 6: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

7135.9860154262

Page 7: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Guldhammer

Speed (Knot) Fn Rn Cr Cf14 0.24618 766811254.29480 0.00156 0.00158

13.5 0.23738 739425138.06999 0.00136 0.0015913 0.22859 712039021.84518 0.00120 0.00160

97.47 12 0.21101 657266789.39555 0.00093 0.0016111 0.19342 602494556.94592 0.00077 0.0016310 0.17584 547722324.49629 0.00066 0.00165

9 0.15826 492950092.04666 0.00058 0.00167

5.2626 Koreksi LCB =

Cr (5,0) Cr (5,2626) Cr (5,5)1.693389501 1.5560229047 1.4318217429 0.2090128147

1.4784186649 1.3576757077 1.2485049487 0.17128458831.3124886585 1.2003954938 1.0990455175 0.13377183030.9894413047 0.9259171997 0.8684813466 0.0615715015

0.8447087961 0.7744815192 0.710984937 0

0.7176290031 0.6579765488 0.6040412812 00.6349971677 0.5820043127 0.5340903777 0

Korek B/T = 2.5 Nilai-nilai tambahan :CAA =CA =CAS =

L/ =

CrLCB

Tahanan Total

Guldhammer

Holtrop

Tahanan Total + Margin

Guldhammer

Holtrop

Page 8: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

HoltropSpeed (Knot)

14 91.8209538792 1.2015001435 0.8082712246 65.979213.5 85.772525539 1.2015001435 0.755028796 59.3894

13 79.9176034069 1.2015001435 0.7034897422 49.731112 68.7916495315 1.2015001435 0.6055514396 20.034111 58.4502406973 1.2015001435 0.5145192424 13.078210 48.9012612062 1.2015001435 0.4304625536 4.5858

9 40.153486226 1.2015001435 0.3534586183 1.6087

18.8969365448 C1 = 2.27444605140.912 C2 = 1

C3 = 0

1.4 C4 = 0.04C5 = 1

0.8183054325 C7 = 0.1641493745CA = 0.000525552 C15 = -1.69385

C16 = 1.264797991613.7486554148

m1 = -2.179737

Fn M20.24618 -0.1558980.23738 -0.1376490.22859 -0.1197700.21101 -0.0859130.19342 -0.0560600.17584 -0.0319800.15826 -0.014977

RF 1+K1 RPP RW

LR =C14 =

(1+K2)eq =

=

SAPP =

Page 9: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 10: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 11: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 12: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 13: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Ct S Rt Rt Margin CtMargin0.00365 2186.61813 211.76931 243.53471 0.00419673690.00346 2186.61813 186.56214 214.54646 0.00397613180.00331 2186.61813 165.51724 190.34482 0.00380418220.00305 2186.61813 130.02748 149.53160 0.00350733640.00292 2186.61813 104.46597 120.13586 0.00335346860.00282 2186.61813 83.48144 96.00365 0.00324260980.00277 2186.61813 66.34149 76.29272 0.0031813028

Cr0.0047818673 0.00099947150.0013492463 0.0002311051

-0.0028151024 0.0003765814-0.0064790211 0.0003989231

0.001258324 0 Perbandingan antara tahanan Guldhammer dan Halvard

0.0089245887 0 RT Guldhammer RT Halvard0.0169904519 0 243.53471 238.7490251422

214.54646 220.2918463868

Nilai-nilai tambahan : 190.34482 198.66475836010.00007 149.53160 144.5540742057

0.0004 120.13586 118.04544815690.00004 96.00365 91.2307135086

76.29272 72.2316285654

LCB

Tahanan Total

Guldhammer

Holtrop

Tahanan Total + Margin

Guldhammer

Holtrop

Page 14: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Ct0 0 30.4975318946 207.6078479498 238.7490251422 0.00357762360 0 28.3580366724 191.5581272929 220.2918463868 0.00355009510 0 26.2963412765 172.7519637914 198.6647583601 0.00345257590 0 22.4063499634 125.6991949614 144.5540742057 0.00294833580 0 18.8275579553 102.6482157886 118.0454481569 0.0028653190 0 15.5599652523 79.3310552249 91.2307135086 0.00267947790 0 12.6035718544 62.810111796 72.2316285654 0.0026190965

14.13

RB RTR RA RTOT RTOT Margin

Sudut masuk (IE) =

Page 15: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 16: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 17: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 18: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 19: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Perbandingan antara tahanan Guldhammer dan Halvard

%2.0045%

-2.6081%

-4.1879%3.4434%1.7709%5.2317%

5.6223%

Page 20: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Ctsm0.00411426710.00408260940.00397046230.00339058620.00329511690.00308139960.0030119609

Page 21: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 22: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 23: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 24: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 25: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 26: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 27: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 28: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 29: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 30: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 31: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

DAYAA. Menentukan Effective Horse PowerEHP = 1 Hp = 0.7456 Kw = 1488.738 Kw = 1996.698 Hp

B. Menentukan Delivered Horse PowerDHP = EHP/Pc Pc = ηH * ηrr * ηo = 0.655714 = 2270.408 Kw ηH = (1-t)/(1-w) w = 0,5Cb-0,05t = k * w = 3045.075 Hp 1.10903 = 0.29545 = 0.218633

ηrr = 1.075ηo = 55%

C. Menentukan Shaft Horse PowerSHP = DHP/ηsηb = 2316.743 Kw = 3107.219 Hp

D. Menentukan Brake Horse PowerBHPscr = SHP/ηG = 2364.023 Kw ηG = 0.98

3170.632 HpBHPmcr = BHPscr/0,85 2781.204 Kw 3730.155 Hp

Mesin yang digunakan : Wartsila 26 Gearbox Gearbox PenggantiTipe : 9L26 Merk = ZF Merk = ZFDaya mesin : 3060 Kw Type = ZF 43100 NC Type = ZF 11850 NR

4160 Hp Ratio = 5.579 Ratio = 5Putaran Mesin : 1000 RPMWeight : 23.6 ton

RTDinas * VS

Page 32: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

SARAT KAPAL KOSONG

Perhitungan DWT dan LWT

Berat Bahan Bakar Mesin Induk

(Ton)

(Ton)

Dimana BHP Mesin utama dari catalog (kW)

183 g/kWh Spesifik konsumsi bahan bakar mesin indukS = Rute Pelayaran (Nautical Miles)

Vs = Kecepatan Kapal (Knots)C = Koreksi Cadangan (1.3-1.5)

175 Ton Alur pelayaran = Cilacap - Manado (1404 Nm)

Volume Bahan Bakar Mesin Induk

Dimana ρ diesel = 0.95

183.9092 183909.2 Liter

Koreksi Volume Tambahan Bahan Bakar Mesin Induk

(Koreksi untuk Double Bottom)

187.5874 187587.4 Liter

(Koreksi untuk Ekspansi karena Panas)

191.3392 191339.2 Liter

191.3392 m3= 191339.2 Liter

Berat Bahan Bakar Mesin Bantu

(Ton)

(Ton)

26.20706 Ton

WFO = BHPME . bME . (S/Vs) . 10-6 . C

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

WFO = BHPME . bME . (S/Vs) . 10-6 . 1.5

BHPME =

bME =

WFO =

V(WFO) = WFO / ρ (m3) "Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

Ton/m3

V(WFO) = m3 =

V2 (WFO) = 102% . V (WFO) (m3)V2 (WFO) = m3

V3 (WFO) = 102% . V2 (WFO) (m3)V3`(WFO) = m3

Jadi V(WFO) = "Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

WFB = (0.1-0.2) . WFO "Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16WFB = 0.15 . WFO

WFB =

Page 33: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Volume Bahan Bakar Mesin Bantu

Dimana ρ diesel = 0.95

27.58638 27586.38 LiterPenambahan Volume Tanki Bahan Bakar Mesin Bantu

28.68984 28689.84 Liter

Berat Minyak Pelumas

(Ton)

(Ton)

Dimana BHP Mesin utama dari catalog (kW)

(1.2-1.6)S = Rute Pelayaran (Nautical Miles)

Vs = Kecepatan Kapal (Knots)C = Koreksi Cadangan (1.3-1.5)

0.816 Ton

Volume Minyak Pelumas

Dimana ρ lube oil = 0.9

0.906667 = 906.6667 Liter

Penambahan Volume Tanki Minyak Pelumas

0.942933 = 942.9333 Liter

Berat Fresh Water

Air Minum

a = kg

a = kga = 711.1879 kg = 0.711188 Ton

Air Cuci

V (WFB) = WFB / ρ (m3) "Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16Ton/m3

V (WFB) = m3

VTank (WFB) = 104% . V (WFB)

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

VTank (WFB) = m3 =

WLO = BHPME . bLO . (S/Vs) . 10-6 . C

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

WLO = BHPME . bLO . (S/Vs) . 10-6 . 1.5

BHPME =

bLO =

WLO =

V(WLO)= WLO / ρ (m3)

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

Ton/m3

V(WLO)= m3

VTank (WLO) = 104% . V(WLO)

VTank (WLO) = m3

((10-20) . Total Crew . S(km)) / 24 . Vs (km/h)

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

(18 . Total Crew . S(km)) / / 24 . Vs (km/h)

Page 34: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

b = kg

b = kgb = 7111.879 kg = 7.111879 Ton

Air Pendinginan Mesin

c= ton= 1.343462 ton= 1343.462 kg

Total Berat Fresh Water

a + b + c (Ton)

9166.529 kg

9.166529 Ton

Berat Bahan Makanan

kg

197.5522 kg = 0.197552 Ton

Berat Crew dan Barang Bawaan

Crew = 80 kg/crewBawaan = 40 kg/crew

(Crew + Bawaan) . Total Crew

1920 kg = 1.92 Ton

Berat Cadangan

(0.5-1.5)% . Vdisp (Ton)

1.5% . Vdisp (Ton)

104.4291 (Ton)

WT = WFO + WFB + WLO + WFW + WP + WCP + WRWT = 317.45 Ton

LWT CalculationBerat Baja Kapal

Dimana : = panjang forcastle deck = 7.1604

= tinggi forcastle = 2.4

((80-200) . Total Crew . S(km)) / 24 . Vs (km/h)

(180 . Total Crew . S(km)) / / 24 . Vs (km/h)

BHPME . 4 . (S/Vs) . 10-6

WFW =

WFW =

WFW =

WP = (5 . Total Crew . S(km)) / 24 . Vs (km/h)

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

WP =

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

WCP =

WCP =

WR = "Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17WR =

WR =

Perhitungan berat baja kapal berdasarkan formula dari Watson, RINA (Practical Ship Design, DGM Watson) :

E(Llyod's equipment num) = Lpp(B+T)+ 0.85 Lpp(H-T)+0.85{(L1.h1)+0.75(L2.h2)}

L1

h1

Page 35: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

= panjang poopdeck = 21.2528

= tinggi bangunan atas = 12

sehingga nilai E adalah = 2536.094Berat baja kapal(Wst)

Dimana nilai K didapat dari Tabel yang terdapat pada buku practical ship design hal 85.

K = 0.032 ± 0.003 Diambil nilai K == 1278.752 ton

Berat Outfit dan Akomodasi

0.4 x Lpp x B= 624.384 ton (Practical Ship Design Page. 100 DGM Watson)

Berat Instalasi Permesinan

Wmt = 2781 Kw= 349.8115

Berat Cadangan (WRes)

WRes = 2.5% (Wst+WOA+Wmt)= 56.32368 ton

LWT = Wst+Woa+Wmt+Wres= 2309.3 ton

Berat Air BallastBerat air Ballast diestimasikan 10-20% dari berat displacement kapal, pada desain ini diambil 20% dari berat displacement Kapal.

Ton= 1427.2 Ton

L2

h2

m2

Wst = K x E1.36

Wst = K x E1.36

WOA =

0.72 x MCR 0.78 ,dimana BHP MCR =

Untuk menghindari kesalahan pada perencanaan akibat perkiraan yang kurang tepat dalam hal perhitungan serta hal-hal yang sebelumnya belum dimasukkan dalam perhitungan, maka perlu faktor penambahan berat (2 - 3) % LWT, diambil angka penambahan sebesar 2.5%

Wballast = 20% *

Page 36: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

V(Wballast) = Wballast/ ρ air laut = 1392.388

Koreksi c untuk penambahan volume air ballast karena konstruksi tangkipada double bottom dan pemanasan sebesar 4% V(Wballast)

V(Wballast) = V(Wballast) + (4% V(Wballast)) = 1448.083

Perhitungan DWTDWT = Berat Displacement (Δ) - LWT = 4826.7 Ton

Perhitungan PayloadPayload = DWT - Wt = 4509.3 Ton

Perhitungan Sarat Air Kapal Tanpa MuatanDalam perhitungan ini di rencanakan kondisi kapal tanpa bermuatan dengan ballast : Berat yang digunakan yakni LWT,Ballast,Wt .

LWT + Ballast + Wt

= 4053.92 Ton3955.042

Sarat Kapal Kosong

= 3.613084

0

m3

m3

Wsarat kosong =

Vsarat kosong = m3

Sarat Kapal Kosong (TLWT) = VLWT/(BxLxCb)

Page 37: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

SARAT KAPAL KOSONG

Perhitungan DWT dan LWT

Berat Bahan Bakar Mesin Induk

Spesifik konsumsi bahan bakar mesin induk

Alur pelayaran = Cilacap - Manado (1404 Nm)

Volume Bahan Bakar Mesin Induk

Koreksi Volume Tambahan Bahan Bakar Mesin Induk

(Koreksi untuk Double Bottom)

(Koreksi untuk Ekspansi karena Panas)

Berat Bahan Bakar Mesin Bantu

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk

"Tentang Rencana Umum" Gaguk

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

Page 38: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Volume Bahan Bakar Mesin Bantu

Penambahan Volume Tanki Bahan Bakar Mesin Bantu

Berat Minyak Pelumas

Volume Minyak Pelumas

Penambahan Volume Tanki Minyak Pelumas

Berat Fresh Water

Air Minum

Air Cuci

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

Page 39: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Air Pendinginan Mesin

Total Berat Fresh Water

Berat Bahan Makanan

Berat Crew dan Barang Bawaan

Berat Cadangan

LWT CalculationBerat Baja Kapal

m

m

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

Perhitungan berat baja kapal berdasarkan formula dari Watson, RINA (Practical Ship Design,

E(Llyod's equipment num) = Lpp(B+T)+ 0.85 Lpp(H-T)+0.85{(L1.h1)+0.75(L2.h2)}

Page 40: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

m

m

Berat baja kapal(Wst)

Dimana nilai K didapat dari Tabel yang terdapat pada buku practical ship design hal 85.

0.03

Berat Outfit dan Akomodasi

(Practical Ship Design Page. 100 DGM Watson)Berat Instalasi Permesinan

Berat Cadangan (WRes)

Berat Air Ballast

Untuk menghindari kesalahan pada perencanaan akibat perkiraan yang kurang tepat dalam hal perhitungan serta hal-hal yang sebelumnya belum dimasukkan dalam perhitungan, maka perlu faktor penambahan berat (2 - 3) % LWT, diambil angka penambahan sebesar 2.5%

Page 41: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Perhitungan DWT

Perhitungan Payload

Perhitungan Sarat Air Kapal Tanpa MuatanDalam perhitungan ini di rencanakan kondisi kapal tanpa bermuatan dengan ballast :

Sarat Kapal Kosong

Page 42: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station PM

WL ordinat faktor luas hasil fungsi luas luas(m2)

17.3045 1 7.3045

47.2037 15.73456677.9748 4 31.89928 1 8

28 1 8

48 168 4 328 1 8

38 1 8

48 168 4 328 1 8

48 1 8

48 168 4 328 1 8

58 1 8

48 168 4 328 1 8

68 1 8

48 168 4 328 1 8

6.368 1 8

48 5.768 4 328 1 8

7.368 1 8

48 168 4 328 1 8

8.368 1 8

48 168 4 328 1 8

8.58 1 8

48 2.248 4 328 1 8

Page 43: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 0

WL ordinat faktor luas hasil fungsi luas luas(m2)

10 1 0

0 00 4 00 1 0

20 1 0

0 00 4 00 1 0

30 1 0

0 00 4 00 1 0

40 1 0

0 00 4 00 1 0

50 1 0

0.7463 0.248766670 4 00.7463 1 0.7463

60.7463 1 0.7463

7.4231 2.474366671.2588 4 5.03521.6416 1 1.6416

6.361.6416 1 1.6416

10.5913 1.2709561.7658 4 7.06321.8865 1 1.8865

7.361.8865 1 1.8865

13.2675 4.42252.2131 4 8.85242.5286 1 2.5286

8.362.5286 1 2.5286

16.9923 5.66412.8337 4 11.33483.1289 1 3.1289

8.53.1289 1 3.1289

19.0163 0.887427333.1694 4 12.67763.2098 1 3.2098

Page 44: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 1

WL ordinat faktor luas hasil fungsi luas luas(m2)

10.1825 1 0.1825

2.6883 0.89610.4966 4 1.98640.5194 1 0.5194

20.5194 1 0.5194

3.1685 1.056166670.5271 4 2.10840.5407 1 0.5407

30.5407 1 0.5407

3.5639 1.187966670.5846 4 2.33840.6848 1 0.6848

40.6848 1 0.6848

5.3438 1.781266670.8682 4 3.47281.1862 1 1.1862

51.1862 1 1.1862

10.6404 3.54681.7772 4 7.10882.3454 1 2.3454

62.3454 1 2.3454

16.0269 5.34232.6863 4 10.74522.9363 1 2.9363

6.362.9363 1 2.9363

18.0968 2.1716163.0165 4 12.0663.0945 1 3.0945

7.363.0945 1 3.0945

19.8498 6.61663.3087 4 13.23483.5205 1 3.5205

8.363.5205 1 3.5205

22.3765 7.458833333.7298 4 14.91923.9368 1 3.9368

8.53.9368 1 3.9368

23.7935 1.110363333.9656 4 15.86243.9943 1 3.9943

Page 45: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 2

WL ordinat faktor luas hasil fungsi luas luas(m2)

10.8862 1 0.8862

9.4653 3.15511.6719 4 6.68761.8915 1 1.8915

21.8915 1 1.8915

12.3359 4.111966672.0529 4 8.21162.2328 1 2.2328

32.2328 1 2.2328

14.8704 4.95682.4697 4 9.87882.7588 1 2.7588

42.7588 1 2.7588

18.4478 6.149266673.0748 4 12.29923.3898 1 3.3898

53.3898 1 3.3898

22.0807 7.360233333.6857 4 14.74283.9481 1 3.9481

63.9481 1 3.9481

25.0339 8.344633334.1762 4 16.70484.381 1 4.381

6.364.381 1 4.381

26.7042 3.2045044.4509 4 17.80364.5196 1 4.5196

7.364.5196 1 4.5196

28.2284 9.409466674.7058 4 18.82324.8856 1 4.8856

8.364.8856 1 4.8856

30.3519 10.11735.0596 4 20.23845.2279 1 5.2279

8.55.2279 1 5.2279

31.5064 1.470298675.2511 4 21.00445.2741 1 5.2741

Page 46: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 3

WL ordinat faktor luas hasil fungsi luas luas(m2)

11.7705 1 1.7705

17.5705 5.856833333.0588 4 12.23523.5648 1 3.5648

23.5648 1 3.5648

23.4298 7.809933333.9175 4 15.674.195 1 4.195

34.195 1 4.195

26.5652 8.855066674.4311 4 17.72444.6458 1 4.6458

44.6458 1 4.6458

29.0735 9.691166674.8476 4 19.39045.0373 1 5.0373

55.0373 1 5.0373

31.2838 10.42793335.2157 4 20.86285.3837 1 5.3837

65.3837 1 5.3837

33.2446 11.08153335.5422 4 22.16885.6921 1 5.6921

6.365.6921 1 5.6921

34.4642 4.1357045.7442 4 22.97685.7953 1 5.7953

7.365.7953 1 5.7953

35.6016 11.86725.9357 4 23.74286.0635 1 6.0635

8.366.0635 1 6.0635

37.1239 12.37463336.1883 4 24.75326.3072 1 6.3072

8.56.3072 1 6.3072

37.9403 1.770547336.3234 4 25.29366.3395 1 6.3395

Page 47: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 4

WL ordinat faktor luas hasil fungsi luas luas(m2)

12.7572 1 2.7572

24.3746 8.124866674.1758 4 16.70324.9142 1 4.9142

24.9142 1 4.9142

32.4384 10.81285.428 4 21.7125.8122 1 5.8122

35.8122 1 5.8122

36.5236 12.17453336.0998 4 24.39926.3122 1 6.3122

46.3122 1 6.3122

38.7668 12.92226676.4682 4 25.87286.5818 1 6.5818

56.5818 1 6.5818

39.9591 13.31976.6637 4 26.65486.7225 1 6.7225

66.7225 1 6.7225

40.5852 13.52846.7657 4 27.06286.7999 1 6.7999

6.366.7999 1 6.7999

40.8676 4.9041126.8113 4 27.24526.8225 1 6.8225

7.366.8225 1 6.8225

41.1298 13.70993336.8547 4 27.41886.8885 1 6.8885

8.366.8885 1 6.8885

41.5448 13.84826676.9239 4 27.69566.9607 1 6.9607

8.56.9607 1 6.9607

41.796 1.950486.966 4 27.8646.9713 1 6.9713

Page 48: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 5

WL ordinat faktor luas hasil fungsi luas luas(m2)

14.1438 1 4.1438

33.0537 11.01795.5721 4 22.28846.6215 1 6.6215

26.6215 1 6.6215

40.4514 13.48386.7103 4 26.84126.9887 1 6.9887

36.9887 1 6.9887

42.8311 14.27703337.1493 4 28.59727.2452 1 7.2452

47.2452 1 7.2452

43.7907 14.59697.3024 4 29.20967.3359 1 7.3359

57.3359 1 7.3359

44.132 14.71066677.3568 4 29.42727.3689 1 7.3689

67.3689 1 7.3689

44.2496 14.74986677.3754 4 29.50167.3791 1 7.3791

6.367.3791 1 7.3791

44.282 5.313847.3803 4 29.52127.3817 1 7.3817

7.367.3817 1 7.3817

44.3249 14.77496677.3871 4 29.54847.3948 1 7.3948

8.367.3948 1 7.3948

44.4298 14.80993337.4046 4 29.61847.4166 1 7.4166

8.57.4166 1 7.4166

44.5105 2.077156677.4184 4 29.67367.4203 1 7.4203

Page 49: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 6

WL ordinat faktor luas hasil fungsi luas luas(m2)

15.7424 1 5.7424

40.8851 13.62836676.9464 4 27.78567.3571 1 7.3571

27.3571 1 7.3571

44.9995 14.99983337.5104 4 30.04167.6008 1 7.6008

37.6008 1 7.6008

45.8885 15.29616677.6525 4 30.617.6777 1 7.6777

47.6777 1 7.6777

46.1192 15.37306677.6875 4 30.757.6915 1 7.6915

57.6915 1 7.6915

46.1607 15.38697.6938 4 30.77527.694 1 7.694

67.694 1 7.694

46.1605 15.38683337.6933 4 30.77327.6933 1 7.6933

6.367.6933 1 7.6933

46.1608 5.5392967.6934 4 30.77367.6939 1 7.6939

7.367.6939 1 7.6939

46.1771 15.39236677.696 4 30.7847.6992 1 7.6992

8.367.6992 1 7.6992

46.2232 15.40773337.7037 4 30.81487.7092 1 7.7092

8.57.7092 1 7.7092

46.2601 2.158804677.71 4 30.847.7109 1 7.7109

Page 50: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 7

WL ordinat faktor luas hasil fungsi luas luas(m2)

16.8475 1 6.8475

45.3863 15.12876677.6829 4 30.73167.8072 1 7.8072

27.8072 1 7.8072

47.1071 15.70236677.8532 4 31.41287.8871 1 7.8871

37.8871 1 7.8871

47.4242 15.80806677.9054 4 31.62167.9155 1 7.9155

47.9155 1 7.9155

47.5256 15.84186677.9219 4 31.68767.9225 1 7.9225

57.9225 1 7.9225

47.535 15.8457.9225 4 31.697.9225 1 7.9225

67.9225 1 7.9225

47.535 15.8457.9225 4 31.697.9225 1 7.9225

6.367.9225 1 7.9225

47.535 5.70427.9225 4 31.697.9225 1 7.9225

7.367.9225 1 7.9225

47.5366 15.84553337.9227 4 31.69087.9233 1 7.9233

8.367.9233 1 7.9233

47.5455 15.84857.9242 4 31.69687.9254 1 7.9254

8.57.9254 1 7.9254

47.5536 2.2191687.9256 4 31.70247.9258 1 7.9258

Page 51: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 14

WL ordinat faktor luas hasil fungsi luas luas(m2)

15.4771 1 5.4771

43.0618 14.35393337.493 4 29.9727.6127 1 7.6127

27.6127 1 7.6127

45.9482 15.31606677.6592 4 30.63687.6987 1 7.6987

37.6987 1 7.6987

46.421 15.47366677.7377 4 30.95087.7715 1 7.7715

47.7715 1 7.7715

46.8708 15.62367.7958 4 31.18327.9161 1 7.9161

57.9161 1 7.9161

47.0395 15.67983337.8227 4 31.29087.8326 1 7.8326

67.8326 1 7.8326

47.0643 15.68817.8439 4 31.37567.8561 1 7.8561

6.367.8561 1 7.8561

47.1629 5.6595487.8605 4 31.4427.8648 1 7.8648

7.367.8648 1 7.8648

47.2576 15.75253337.8764 4 31.50567.8872 1 7.8872

8.367.8872 1 7.8872

47.3833 15.79443337.8973 4 31.58927.9069 1 7.9069

8.57.9069 1 7.9069

47.4487 2.21427267

Page 52: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

8.5 7.9081 4 31.6324 47.4487 2.214272677.9094 1 7.9094

Station 15

WL ordinat faktor luas hasil fungsi luas luas(m2)

13.0281 1 3.0281

29.931 9.9775.1002 4 20.40086.5021 1 6.5021

26.5021 1 6.5021

41.3688 13.78966.9423 4 27.76927.0975 1 7.0975

37.0975 1 7.0975

43.0018 14.33393337.1694 4 28.67767.2267 1 7.2267

47.2267 1 7.2267

43.7056 14.56853337.2837 4 29.13487.3441 1 7.3441

57.3441 1 7.3441

44.4769 14.82563337.4114 4 29.64567.4872 1 7.4872

67.4872 1 7.4872

45.3781 15.12603337.5641 4 30.25647.6345 1 7.6345

6.367.6345 1 7.6345

45.9217 5.5106047.6538 4 30.61527.672 1 7.672

7.367.672 1 7.672

46.2413 15.41376677.7089 4 30.83567.7337 1 7.7337

8.367.7337 1 7.7337

46.5003 15.50017.7508 4 31.0032

Page 53: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

8.367.7634 1 7.7634

46.5003 15.5001

8.57.7634 1 7.7634

46.59 2.17427.765 4 31.067.7666 1 7.7666

Station 16

WL ordinat faktor luas hasil fungsi luas luas(m2)

11.7203 1 1.7203

19.6787 6.559566673.3241 4 13.29644.662 1 4.662

24.662 1 4.662

32.3524 10.78413335.4592 4 21.83685.8536 1 5.8536

35.8536 1 5.8536

36.2627 12.08756676.054 4 24.2166.1931 1 6.1931

46.1931 1 6.1931

37.9051 12.63503336.3189 4 25.27566.4364 1 6.4364

56.5473 1 6.5473

39.3898 13.12993336.5473 4 26.18926.6533 1 6.6533

66.6533 1 6.6533

40.5257 13.50856676.755 4 27.026.8524 1 6.8524

6.366.8524 1 6.8524

41.3144 4.9577286.8858 4 27.54326.9188 1 6.9188

7.366.9188 1 6.9188

42.0363 14.01217.0069 4 28.02767.0899 1 7.0899

Page 54: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

8.367.0899 1 7.0899

43.0035 14.33457.168 4 28.6727.2416 1 7.2416

8.57.2416 1 7.2416

43.509 2.030427.2515 4 29.0067.2614 1 7.2614

Station 17

WL ordinat faktor luas hasil fungsi luas luas(m2)

11.216 1 1.216

13.749 4.5832.3522 4 9.40883.1242 1 3.1242

23.1242 1 3.1242

21.735 7.2453.6454 4 14.58164.0292 1 4.0292

34.0292 1 4.0292

25.7983 8.599433334.3123 4 17.24924.5199 1 4.5199

44.5199 1 4.5199

28.0696 9.356533334.6819 4 18.72764.8221 1 4.8221

54.8221 1 4.8221

29.7662 9.922066674.9601 4 19.84045.1037 1 5.1037

65.1037 1 5.1037

31.5061 10.50203335.2508 4 21.00325.3992 1 5.3992

6.365.3992 1 5.3992

32.7148 3.9257765.4525 4 21.815.5056 1 5.5056

7.365.5056 1 5.5056

33.7854 11.2618

Page 55: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

7.36 5.6213 4 22.4852 33.7854 11.26185.7946 1 5.7946

8.365.7946 1 5.7946

35.6114 11.87046675.9356 4 23.74246.0744 1 6.0744

8.56.0744 1 6.0744

36.5617 1.706212676.0936 4 24.37446.1129 1 6.1129

Station 18

WL ordinat faktor luas hasil fungsi luas luas(m2)

10.667 1 0.667

8.1434 2.714466671.4151 4 5.66041.816 1 1.816

21.816 1 1.816

12.8787 4.29292.1857 4 8.74282.3199 1 2.3199

32.3199 1 2.3199

15.0349 5.011633332.5087 4 10.03482.6802 1 2.6802

42.6802 1 2.6802

17.0284 5.676133332.8411 4 11.36442.9838 1 2.9838

52.9838 1 2.9838

18.6117 6.20393.1044 4 12.41763.2103 1 3.2103

63.2103 1 3.2103

19.8627 6.62093.3101 4 13.24043.412 1 3.412

6.363.412 1 3.412

20.706 2.484723.4507 4 13.8028

Page 56: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

6.363.4912 1 3.4912

20.706 2.48472

7.363.4912 1 3.4912

21.7023 7.23413.6144 4 14.45763.7535 1 3.7535

8.363.7537 1 3.7537

23.4652 7.821733333.9083 4 15.63324.0783 1 4.0783

8.54.0783 1 4.0783

24.6201 1.1489384.1033 4 16.41324.1286 1 4.1286

Station 19

WL ordinat faktor luas hasil fungsi luas luas(m2)

10 1 0

2.005 0.668333330.373 4 1.4920.513 1 0.513

20.513 1 0.513

3.4203 1.14010.5755 4 2.3020.6053 1 0.6053

30.6053 1 0.6053

3.724 1.241333330.6199 4 2.47960.6391 1 0.6391

40.6391 1 0.6391

4.1308 1.376933330.6819 4 2.72760.7641 1 0.7641

50.7641 1 0.7641

5.4848 1.828266670.9038 4 3.61521.1055 1 1.1055

61.1055 1 1.1055

8.189 2.729666671.3588 4 5.43521.6483 1 1.6483

Page 57: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

6.361.6483 1 1.6483

10.5481 1.2657721.7578 4 7.03121.8686 1 1.8686

7.361.8686 1 1.8686

13.0704 4.35682.1781 4 8.71242.4894 1 2.4894

8.362.4894 1 2.4894

16.8162 5.60542.8024 4 11.20963.1172 1 3.1172

8.53.1172 1 3.1172

18.9684 0.8851923.1614 4 12.64563.2056 1 3.2056

Station PM

WL ordinat faktor luas hasil fungsi luas luas(m2)

10 1 0

39.8992 13.29973337.9748 4 31.89928 1 8

28 1 8

48 168 4 328 1 8

38 1 8

48 168 4 328 1 8

48 1 8

48 168 4 328 1 8

58 1 8

48 168 4 328 1 8

68 1 8

48 16

Page 58: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

6 8 4 32 48 168 1 8

6.368 1 8

48 5.768 4 328 1 8

7.368 1 8

48 168 4 328 1 8

8.368 1 8

48 168 4 328 1 8

8.58 1 8

48 2.248 4 328 1 8

Page 59: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station PM WL 1

jumlah skala Stasion Luas FS Luas * FS

15.7345667 0.524485560 0 1 01 0.8961 4 3.58442 3.1551 2 6.3102

31.7345667 1.057818893 5.85683333 4 23.42733334 8.12486667 2 16.24973335 11.0179 4 44.0716

47.7345667 1.591152226 13.6283667 2 27.25673337 15.1287667 4 60.51506678 15.7345667 2 31.4691333

63.7345667 2.124485569 15.7345667 4 62.9382667

10 15.7345667 2 31.469133311 15.7345667 4 62.9382667

79.7345667 2.6578188912 15.7345667 2 31.469133313 15.7345667 4 62.938266714 14.3539333 2 28.7078667

95.7345667 3.1911522215 9.977 4 39.90816 6.55956667 2 13.119133317 4.583 4 18.332

101.494567 3.3831522218 2.71446667 2 5.4289333319 0.66833333 4 2.6733333320 0 1 0

117.494567 3.91648556JumlahBerat

133.494567 4.44981889

135.734567 4.52448556

Page 60: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 0 WL 2

jumlah skala Stasion Luas FS Luas * FS

0 00 0 1 01 1.95226667 4 7.809066672 7.26706667 2 14.5341333

0 03 13.6667667 4 54.66706674 18.9376667 2 37.87533335 24.5017 4 98.0068

0 06 28.6282 2 57.25647 30.8311333 4 123.3245338 31.7345667 2 63.4691333

0 09 31.7345667 4 126.938267

10 31.7345667 2 63.469133311 31.7345667 4 126.938267

0.24876667 0.0082922212 31.7345667 2 63.469133313 31.7345667 4 126.93826714 29.67 2 59.34

2.72313333 0.0907711115 23.7666 4 95.066416 17.3437 2 34.687417 7.00736667 4 28.0294667

3.99408933 0.1331363118 7.00736667 2 14.014733319 1.80843333 4 7.2337333320 0 1 0

8.41658933 0.28055298Jumlah

14.0806893 0.46935631

14.9681167 0.49893722

Page 61: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 1 WL 3

jumlah skala

0.8961 0.02987

1.95226667 0.06507556

3.14023333 0.10467444

4.9215 0.16405

8.4683 0.28227667

13.8106 0.46035333

15.982216 0.53274053

22.598816 0.75329387

30.0576493 1.00192164

31.1680127 1.03893376

Page 62: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 2 WL 4

jumlah skala

3.1551 0.10517

7.26706667 0.24223556

12.2238667 0.40746222

18.3731333 0.61243778

25.7333667 0.85777889

34.078 1.13593333

37.282504 1.24275013

46.6919707 1.55639902

56.8092707 1.89364236

58.2795693 1.94265231

Page 63: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 3 WL 5

jumlah skala

5.85683333 0.19522778

13.6667667 0.45555889

22.5218333 0.75072778

32.213 1.07376667

42.6409333 1.42136444

53.7224667 1.79074889

57.8581707 1.92860569

69.7253707 2.32417902

82.100004 2.7366668

83.8705513 2.79568504

Page 64: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 4 WL 6,36

jumlah skala Stasion Luas FS Luas * FS

8.12486667 0.270828890 3.99408933 1 3.994089331 15.982216 4 63.9288642 37.282504 2 74.565008

18.9376667 0.631255563 57.8581707 4 231.4326834 75.7866787 2 151.5733575 88.1500067 4 352.600027

31.1122 1.037073336 95.6104627 2 191.2209257 99.8752667 4 399.5010678 101.494567 2 202.989133

44.0344667 1.467815569 101.494567 4 405.978267

10 101.494567 2 202.98913311 101.494567 4 405.978267

57.3541667 1.9118055612 101.494567 2 202.98913313 101.494567 4 405.97826714 97.794748 2 195.589496

70.8825667 2.3627522215 88.1313373 4 352.52534916 73.662528 2 147.32505617 54.1338427 4 216.535371

75.7866787 2.5262226218 33.0046533 2 66.009306719 10.2504053 4 41.001621320 0 1 0

89.496612 2.9832204Volume 14031.4188

103.344879 3.44482929

105.295359 3.50984529

Page 65: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 5 WL 6,36

jumlah skala

11.0179 0.36726333

24.5017 0.81672333

38.7787333 1.29262444

53.3756333 1.77918778

68.0863 2.26954333

82.8361667 2.76120556

88.1500067 2.93833356

102.924973 3.43083244

117.734907 3.92449689

119.812063 3.99373544

Page 66: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 6

jumlah skala

13.6283667 0.45427889

28.6282 0.95427333

43.9243667 1.46414556

59.2974333 1.97658111

74.6843333 2.48947778

90.0711667 3.00237222

95.6104627 3.18701542

111.002829 3.70009431

126.410563 4.21368542

128.569367 4.28564558

Page 67: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 7

jumlah skala

15.1287667 0.50429222

30.8311333 1.02770444

46.6392 1.55464

62.4810667 2.08270222

78.3260667 2.61086889

94.1710667 3.13903556

99.8752667 3.32917556

115.7208 3.85736

131.5693 4.38564333

133.788468 4.4596156

Page 68: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Station 14

jumlah skala

14.3539333 0.47846444

29.67 0.989

45.1436667 1.50478889

60.7672667 2.02557556

76.4471 2.54823667

92.1352 3.07117333

97.794748 3.25982493

113.547281 3.78490938

129.341715 4.31139049

131.555987 4.38519958

Page 69: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

131.555987 4.38519958

Station 15

jumlah skala

9.977 0.33256667

23.7666 0.79222

38.1005333 1.27001778

52.6690667 1.75563556

67.4947 2.24982333

82.6207333 2.75402444

88.1313373 2.93771124

103.545104 3.45150347

119.045204 3.96817347

Page 70: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

119.045204 3.96817347

121.219404 4.0406468

Station 16

jumlah skala

6.55956667 0.21865222

17.3437 0.57812333

29.4312667 0.98104222

42.0663 1.40221

55.1962333 1.83987444

68.7048 2.29016

73.662528 2.4554176

87.674628 2.9224876

Page 71: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

102.009128 3.40030427

104.039548 3.46798493

Station 17

jumlah skala

4.583 0.15276667

11.828 0.39426667

20.4274333 0.68091444

29.7839667 0.99279889

39.7060333 1.32353444

50.2080667 1.67360222

54.1338427 1.80446142

65.3956427 2.17985476

Page 72: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

65.3956427 2.17985476

77.2661093 2.57553698

78.972322 2.63241073

Station 18

jumlah skala

2.71446667 0.09048222

7.00736667 0.23357889

12.019 0.40063333

17.6951333 0.58983778

23.8990333 0.79663444

30.5199333 1.01733111

33.0046533 1.10015511

Page 73: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

33.0046533 1.10015511

40.2387533 1.34129178

48.0604867 1.60201622

49.2094247 1.64031416

Station 19

jumlah skala

0.66833333 0.02227778

1.80843333 0.06028111

3.04976667 0.10165889

4.4267 0.14755667

6.25496667 0.20849889

8.98463333 0.29948778

Page 74: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

10.2504053 0.34168018

14.6072053 0.48690684

20.2126053 0.67375351

21.0977973 0.70325991

Station PM

jumlah skala

13.2997333 0.44332444

29.2997333 0.97665778

45.2997333 1.50999111

61.2997333 2.04332444

77.2997333 2.57665778

93.2997333 3.10999111

Page 75: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

93.2997333 3.10999111

99.0597333 3.30199111

115.059733 3.83532444

131.059733 4.36865778

133.299733 4.44332444

Page 76: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Volume0

1.19482.1034

7.809111115.4165777814.69053339.0855777820.171688910.489711120.979422210.489711120.979422210.489711120.97942229.5692888913.30266674.373044446.110666671.809644440.89111111

01862.766851909.33602

Page 77: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Volume

Page 78: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 79: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 80: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 81: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 82: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 83: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 84: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 85: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 86: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 87: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 88: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 89: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 90: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 91: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 92: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 93: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

EHP 5965.81 kW Rute Pelayaran :DHP 9286.83 kW KonversiBHP 11148.7 kW 1 Nautical MilRPM 124 rpm 1 m

1 KnotsMerk Wartsilla 1 HPDaya 11620 kW 1 kW

15820 hpType RTA50 Jarak Pelabuhan Tanjung Perak dengan Pelabuhan Semayang

Cylinder Bore 500 mm DistancePiston Stroke 2050 mm Speed

RPM 124 RPM TimeSFOC 171 g/kWh

Jarak Pulang-PergiV displ 19911.38

Waktu PPSARAT KAPAL KOSONG

Perhitungan Berat Kebutuhan Tangki Kapal Wt1. Berat Bahan Bakar Mesin Induk

=

Keterangan :

SVsC

=

=

= 247.38

2. Volume Bahan Bakar Mesin Induk

=

Dimana ρ diesel (HFO)=

HFO

= 249.625

= 249625

3. Koreksi Volume Tambahan Bahan Bakar Mesin Induk

=

= 254.617

= 254617

=

= 259.710

1 m3

WFO BHPME . SFOCME . (S/Vs) . 10-6 . C

BHPME

SFOCME

WFO BHPME . bME . (S/Vs) . 10-6 . C

11148.7 . 171 . (1622/17.5) . 10-6 . 1.4

V(WFO) WFO / ρ

V(WFO)

V2 (WFO) 102% . V (WFO)

V3 (WFO) 102% . V2 (WFO)

m^3

Page 94: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

= 259710

=

4. Berat Bahan Bakar Mesin Bantu

=

=

= 37.1067

5. Volume Bahan Bakar Mesin Bantu

=

Dimana ρ mesin bantu (MDO) =

MDO

=

= 41.6929

= 41692.9

6. Penambahan Volume Tanki Bahan Bakar Mesin Bantu

=

=

=

7. Berat Minyak Pelumas

=

= BHP Mesin utama dari catalog (kW)

= (1.2-1.6)

S = Rute Pelayaran (Nautical Miles)Vs = Kecepatan Kapal (Knots)C = Koreksi Cadangan (1.3-1.5)

=

= 2.025

8. Volume Minyak Pelumas

=

Dimana ρ lube oil

=

= 2.250

Maka V(WFO)

WFB (0,1~0,2) WFO

0,15WFO

V (WFB) WFB / ρ

V (WFB) WFB / ρ

VTank (WFB)

WLO BHPME . bLO . (S/Vs) . 10-6 . C

BHPME

bLO

WLO BHPME . bLO . (S/Vs) . 10-6 . C

V(WLO) WLO / ρ

V(WLO) WLO / ρ

Page 95: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

= 2250

9. Penambahan Volume Tanki Minyak Pelumas

=

=

=

Berat Fresh Water1. Air Minum

a =

=

= 1544.7427= 1.5447427

2. Air Cuci

b =

=

= 13902.6844853284= 13.9026844853

3. Air Pendinginan Mesin

c =

= 4.133= 4133

4. Total Berat Fresh Water

= a + b + c

= 19.581= 19581

Berat Bahan Makanan

=

= 386.185680148= 0.3861856801

Berat Crew dan Barang BawaanCrew = 75Bawaan = 20

= (Crew + Bawaan) . Total Crew

= 1900= 1.9

VTank (WLO)

((10~20) . Total Crew . S(km)) / 24 . Vs (km/h)

(20 . 20 . S(km))/24 . Vs (km/h)

((80-200) . Total Crew . S(km)) / 24 . Vs (km/h)

(180 . 20 . S(km)) / 24 . Vs (km/h)

BHPME . 4 . (S/Vs) . 10-6

WFW

WP (5 . Total Crew . S(km)) / 24 . Vs (km/h)

WCP

Page 96: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Berat Cadangan

=

= 1.3% . Vdisp= 258.85

Berat Total Kebutuhan :== 567.22

LWT Calculation1. Berat Baja Kapal (Wst)

Perhitungan berat baja kapal berdasarkan formula dari Watson, RINA (Practical Ship Design, DGM Watson) :

E(Llyod's equipment num)

= panjang forcastle deck

= tinggi forcastle

= panjang poopdeck

= tinggi bangunan atas

E =

= 136(25+8.814)+0.85x136(12.8-8.814)+0.85((13.423x4.2)+0.75(31.063x18))

= 5463.853635

Berat baja kapal(Wst)

Wst =

Dimana nilai K didapat dari Tabel yang terdapat pada buku practical ship design hal 85.

WR (0.5~1.5)% . Vdisp

Wt WFO + WFB + WLO + WFW + WP + WCP + WR

L1

h1

L2

h2

Lpp(B+T)+ 0.85 Lpp(H-T)+0.85{(L1.h1)+0.75(L2.h2)}

m2

K x E1,36

Page 97: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

K = 0.036 ± 0.003

Wst =

= 4358.1404111614 Ton

2. Berat Outfit dan Akomodasi (Woa) = 0.4 x Lpp x B= 1360

3. Berat Instalasi Permesinan (Wmt)

Wmt =

= 1033.164. Berat Cadangan (Wres)

WRes = 3% (Wst+WOA+Wmt)= 202.54

0LWT = Wst+Woa+Wmt+Wres

= 6953.84

Berat Air Ballast

Berat air Ballast diestimasikan 10-20% dari berat displacement kapal, pada desain ini diambil 20% dari berat displacement Kapal.

Δ = 20409.1672234086 Ton

= 20% x Δ= 4081.83

V(Wballast) = Wballast/ ρ air laut

= 3982.28

Koreksi c untuk penambahan volume air ballast karena konstruksi tangki pada double bottom dan pemanasan sebesar 4% V(Wballast)

V(Wballast) = V(Wballast) + (4% V(Wballast))

= 4141.57

Perhitungan DWTDWT = Berat Displacement (Δ) - LWT

= 20409.167 - 6953.84

K x E1,36

WOA

0.72 x MCR 0,78

Untuk menghindari kesalahan pada perencanaan akibat perkiraan yang kurang tepat dalam hal perhitungan serta hal-hal yang sebelumnya belum dimasukkan dalam perhitungan, maka perlu faktor penambahan berat (2 - 3) % LWT, diambil angka penambahan sebesar 3%.

Vsarat kosong = m3

Wballast

Page 98: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

= -6953.84

Perhitungan PayloadPayload = DWT - Wt

= 5297,29 - 184,23= -7521.06

Perhitungan Sarat Air Kapal Tanpa MuatanDalam perhitungan ini di rencanakan kondisi kapal tanpa bermuatan dengan ballast :

Berat yang digunakan yakni LWT,Ballast,Wt .= LWT + Ballast + Wt= 11602.90= 11319.8998486458

Berat sarat kosong terdapat di antara Sarat 5 - 6 m, sehingga dilakukan interpolasi :T(m) Δ(Ton)

x y5 10653.24Tx 11602.906 12974.16

Jadi sarat pada muatan kosong adalah

Wsarat kosong

Vsarat kosong

( 1))/( 3 1))=( 2 1))/( 3 1))(�� −� (� −� (� −� (� −�

Page 99: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Rute Pelayaran : Jakarta-Malaysia

1 Nautical Mil = 1.852 km= 3.28 feet= 0.514 m/s == 0.7355 kW= 1.35962 HP

= 1000 LitersJarak Pelabuhan Tanjung Perak dengan Pelabuhan Semayang

= 811 nautical miles= 17.5 knot == 1 day 12 and hours =

Jarak Pulang-Pergi = 1622 nautical miles= 3003.944 km= hoursSARAT KAPAL KOSONG

Perhitungan Berat Kebutuhan Tangki Kapal Wt

(Ton)

= BHP Mesin utama dari catalog (kW)

= Spesifik konsumsi bahan bakar mesin induk =171 g/kWh

= Rute Pelayaran (Nautical Miles)= Kecepatan Kapal (Knots)= Koreksi Cadangan (1.3-1.5)

Ton Pulang Pergi

0.991 0.991

249.625

249625 Liter GAK USAH LITER

Koreksi Volume Tambahan Bahan Bakar Mesin Induk

(Koreksi untuk Double Bottom)

254.617

254617 Liter

(Koreksi untuk Ekspansi karena Panas)

259.710

ME . (S/Vs) . 10-6 . C

. (S/Vs) . 10-6 . C

11148.7 . 171 . (1622/17.5) . 10-6 . 1.4

(m3)

ton/m3

m3

102% . V (WFO) m3

m3

102% . V2 (WFO) m3

m3

Page 100: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

259710 Liter

259.710

259710 Liter

(Ton)

Ton

0.89

0.89

41.6929

41692.9 Liter

Penambahan Volume Tanki Bahan Bakar Mesin Bantu

43.3606

43360.6 Liter

BHP Mesin utama dari catalog (kW)

Rute Pelayaran (Nautical Miles)Kecepatan Kapal (Knots)Koreksi Cadangan (1.3-1.5)

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

Ton

= 0.9

2.250"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

m3

(m3)

Ton/m3

(m3)

(m3)

104% . V (WFB)

(m3)

. (S/Vs) . 10-6 . C

. (S/Vs) . 10-6 . C

(m3)

Ton/m3

(m3)

Page 101: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

2250 Liter"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

2.340"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

2340 Liter

Berat Fresh Water

kgton

kgton

(ton)

tonkg

tonkg

Berat Bahan Makanan

kg

kgton

Berat Crew dan Barang Bawaankg/crewkg/crew

(Crew + Bawaan) . Total Crew

kgton

104% . V(WLO)

(m3)

~20) . Total Crew . S(km)) / 24 . Vs (km/h)

)/24 . Vs (km/h)

((80-200) . Total Crew . S(km)) / 24 . Vs (km/h)

(km)) / 24 . Vs (km/h)

(5 . Total Crew . S(km)) / 24 . Vs (km/h)

Page 102: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Berat Cadangan

(Ton)

tonBerat Total Kebutuhan :

ton

LWT Calculation

Perhitungan berat baja kapal berdasarkan formula dari Watson, RINA (Practical Ship Design, DGM Watson) :

=

= 13.423 m

= 4.2 m

= 31.063 m

= 18 m

136(25+8.814)+0.85x136(12.8-8.814)+0.85((13.423x4.2)+0.75(31.063x18))

Dimana nilai K didapat dari Tabel yang terdapat pada buku practical ship design hal 85.

+ WLO + WFW + WP + WCP + WR

Lpp(B+T)+ 0.85 Lpp(H-T)+0.85{(L1.h1)+0.75(L2.h2)}

Lpp(B+T)+ 0.85 Lpp(H-T)+0.85{(L1.h1)+0.75(L2.h2)}

Page 103: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

K = 0.036

(Practical Ship Design Page. 100 DGM Watson)Ton

11148.7 kW

Ton

Ton

Ton

Berat Air Ballast

Berat air Ballast diestimasikan 10-20% dari berat displacement kapal, pada desain ini diambil 20% dari berat displacement Kapal.

Ton

Wballast/ ρ air laut ρ air laut

3982.28

Koreksi c untuk penambahan volume air ballast karena konstruksi tangki pada double bottom dan pemanasan sebesar 4% V(Wballast)

V(Wballast) + (4% V(Wballast))

4141.57

Perhitungan DWTBerat Displacement (Δ) - LWT

,dimana BHP MCR =

Untuk menghindari kesalahan pada perencanaan akibat perkiraan yang kurang tepat dalam hal perhitungan serta hal-hal yang sebelumnya belum dimasukkan dalam perhitungan, maka perlu faktor penambahan berat (2 - 3) % LWT, diambil angka penambahan sebesar 3%.

m3

m3

Page 104: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Ton

Perhitungan Payload

Ton

Perhitungan Sarat Air Kapal Tanpa MuatanDalam perhitungan ini di rencanakan kondisi kapal tanpa bermuatan dengan ballast :

LWT + Ballast + Wt11602.90 Ton

11319.8998486458 m3

Δ = Volume Displacement x ρ

Berat sarat kosong terdapat di antara Sarat 5 - 6 m, sehingga dilakukan interpolasi :

Tx = 5.409 meter

5.409 meter.

19911.38

( 1))/( 3 1))=( 2 1))/( 3 1))(�� −� (� −� (� −� (� −�

Page 105: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

1 ft = 0.3047999902 m1.852023 km/h

= 1501.97 km32.4104 km/h

hours

nautical miles

SARAT KAPAL KOSONGPerhitungan Berat Kebutuhan Tangki Kapal Wt

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

(Koreksi untuk Ekspansi karena Panas)

Page 106: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

Page 107: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 16

Berat Fresh Water

kg

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

kg

Berat Bahan Makanan

"Tentang Rencana Umum" Gaguk Suhardjito 2006 hal 17

Berat Crew dan Barang Bawaan

Page 108: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Berat Cadangan

Berat Total Kebutuhan :

LWT Calculation

Perhitungan berat baja kapal berdasarkan formula dari Watson, RINA (Practical Ship Design, DGM Watson) :

13.423

4.200

31.063

18.000

Page 109: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Berat Air Ballast

Berat air Ballast diestimasikan 10-20% dari berat displacement kapal, pada desain ini diambil 20% dari berat displacement Kapal.

= 1.025

Koreksi c untuk penambahan volume air ballast karena konstruksi tangki pada double bottom dan pemanasan sebesar 4% V(Wballast)

Perhitungan DWT

Untuk menghindari kesalahan pada perencanaan akibat perkiraan yang kurang tepat dalam hal perhitungan serta hal-hal yang sebelumnya belum dimasukkan dalam perhitungan, maka perlu faktor penambahan berat (2

ton/m3

Page 110: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Perhitungan Payload

Perhitungan Sarat Air Kapal Tanpa Muatan

Volume Displacement x ρSarat (m)

Area x FS

1421.2024Sarat 1m

0 1421.202 1 1421.20210633.9840.5 1815.2174 4 7260.8696

1 1951.9126 1 1951.9126

Sarat 2m0 1421.202 1 1421.202

113281 1951.9126 4 7807.65042 2099.1461 1 2099.1461

Sarat 3m1 1951.9126 1 1951.9126

12523.3742 2099.1461 4 8396.58443 2174.8774 1 2174.8774

Sarat 4m2 2099.1461 1 2099.1461

13022.6523 2174.8774 4 8699.50964 2223.9961 1 2223.9961

Sarat 5m3 2174.8774 1 2174.8774

13339.8544 2223.9961 4 8895.98445 2268.992 1 2268.992

Sarat 6m4 2223.9961 1 2223.9961

13622.4915 2268.992 4 9075.9686 2322.5265 1 2322.5265

Sarat 7m5 2268.992 1 2268.992

13980.0756 2322.5265 4 9290.1067 2420.9773 1 2420.9773

Sarat 8m6 2322.5265 1 2322.5265

14528.467 2420.9773 4 9683.90928 2522.0242 1 2522.0242

88.4078.814

Luasan Area(m2)

Faktor Simpson

Luasan Total

Sarat 8,814m

Page 111: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

(sfoc)

Page 112: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 113: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 114: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 115: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 116: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

1772.3307 1816.639

3775.9995 3870.3995

5946.7888 6095.4586

8116.8834 8319.8055

10393.407 10653.242

12657.714 12974.156

15053.432 15429.768

17500.534 17938.047

19911.38 20409.165

Volume=h/3xLuasan

Berat Displasment

Page 117: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Nama : Mhd. Dolimora MartadhoL. TobingNRP : 4213100069

No Jenis PropP/D1 B3-35 0.679465 2.3620 239.192 12.69254 12.18484 3.713939 5.409 Memenuhi 229.6243 0.583812 B3-50 0.679403 2.3500 237.9747 12.62795 12.12283 3.695038 5.409 Memenuhi 228.4557 0.5679593 B3-65 0.708831 2.2922 232.1265 12.31762 11.82491 3.604233 5.409 Memenuhi 222.8414 0.5458924 B3-80 0.775261 2.2000 222.7848 11.82191 11.34903 3.459184 5.409 Memenuhi 213.8734 0.5230495 B4-40 0.718313 2.2500 227.8481 12.09059 11.60696 3.537802 5.409 Memenuhi 218.7342 0.5629016 B4-55 0.711097 2.2654 229.4097 12.17345 11.68651 3.56205 5.409 Memenuhi 220.2333 0.567 B4-70 0.740578 2.2327 226.0941 11.99751 11.51761 3.510568 5.409 Memenuhi 217.0503 0.558 B4-85 0.781211 2.1596 218.6895 11.60459 11.14041 3.395597 5.409 Memenuhi 209.942 0.5367419 B4-100 0.8 2.0825 210.8815 11.19027 10.74266 3.274362 5.409 Memenuhi 202.4463 0.522348

10 B5-45 0.769392 2.1584 218.5699 11.59825 11.13432 3.393739 5.409 Memenuhi 209.8271 0.55147711 B5-60 0.754184 2.1823 220.9883 11.72658 11.25751 3.43129 5.409 Memenuhi 212.1488 0.55410612 B5-75 0.762897 2.1650 219.2409 11.63385 11.1685 3.404157 5.409 Memenuhi 210.4712 0.5513 B5-90 0.8 2.1250 215.1899 11.41889 10.96213 3.341258 5.409 Memenuhi 206.5823 0.5414 B5-105 0.85 2.0642 209.0354 11.0923 10.64861 3.245697 5.409 Memenuhi 200.6739 0.52744515 B6-50 0.824596 2.0780 210.4311 11.16637 10.71971 3.267369 5.409 Memenuhi 202.0139 0.54217616 B6-65 0.802661 2.1000 212.6582 11.28455 10.83317 3.301949 5.409 Memenuhi 204.1519 0.54632317 B6-80 0.80929 2.1000 212.6582 11.28455 10.83317 3.301949 5.409 Memenuhi 204.1519 0.54354418 B6-95 0.826438 2.0642 209.0353 11.0923 10.64861 3.245695 5.409 Memenuhi 200.6739 0.535116

PropellerVa = (1-w).Vs

Va = 9.511425 KnotSyarat Diameter 4.888872 mD.propeller yang diperbolehkan = = 5.4091729 m

Bp = 35.45101 0,1739.√BpN = 179.2436 rpm 1.035414

2.987393 rps

1/J0 δ0 D0 Db (feet) Db (m) Dmax Db<Dmax δbη0

Bp1 =5.2

5.0

a

dpropellerp

V

xPNB

Page 118: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Nama : Mhd. Dolimora MartadhoL. TobingNRP : 4213100069

prop AutoCAD P/D 1/J η0 P/DbB3-35 4.647764 0.679465 2.362021 0.58381 7.698771B3-50 4.995987 0.679403 2.35 0.567959 6.793136B3-65 4.909825 0.708831 2.292249 0.545892 0.073379B3-80 4.777874 0.775261 2.2 0.523049 1.559628B4-40 4.72146 0.718313 2.25 0.562901 7.13448B4-55 4.996341 0.711097 2.265421 0.56 9.279902B4-70 4.964646 0.740578 2.232679 0.55 5.172386B4-85 4.825753 0.781211 2.159559 0.536741 9.239006B4-100 4.754961 0.8 2.082455 0.522348 12.8994B5-45 5.002184 0.769392 2.158378 0.551477 9.238161B5-60 4.959404 0.754184 2.18226 0.554106 11.68804B5-75 4.829365 0.762897 2.165003 0.55 9.67512B5-90 4.895766 0.8 2.125 0.54 5.02924B5-105 4.777874 0.85 2.064224 0.527445 11.15149B6-50 4.837652 0.824596 2.078008 0.542176 11.4953B6-65 4.925655 0.802661 2.1 0.546323 2.043088B6-80 5.121989 0.80929 2.1 0.543544 2.152416B6-95 4.956996 0.826438 2.064223 0.535116 11.08753

Page 119: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Nama : Mhd. Dolimora MartadhoL. TobingNRP : 4213100069

No Jenis Prop.1/Jb P/Db Vr2 Thrust Ap (ft2) Ap (m2) σ 0.7R0.35 116.5492 40.79222 1 B3-35 2.26754 0.69316 618.6173 245.1577 37.05022 3.442078 0.43892

0.5 115.3659 57.68296 2 B3-50 2.256 0.69299 612.5793 245.1577 52.39378 4.867542 0.443240.65 109.7654 71.3475 3 B3-65 2.20056 0.72133 584.0014 245.1577 64.34233 5.977598 0.46493

0.8 101.1084 80.88671 4 B3-80 2.112 0.7874 539.8273 245.1577 71.72099 6.663098 0.502980.4 105.7564 42.30258 5 B4-40 2.16 0.53203 563.545 245.1577 39.98297 3.714539 0.48181

0.55 107.2111 58.96609 6 B4-55 2.1748 0.72562 570.9675 245.1577 53.11857 4.934876 0.475550.7 104.1345 72.89413 7 B4-70 2.14337 0.75407 555.2685 245.1577 65.1905 6.056396 0.48899

0.85 97.42536 82.81155 8 B4-85 2.07318 0.80487 521.0339 245.1577 73.09642 6.790879 0.521131 90.59267 90.59267 9 B4-100 1.99916 0.86023 486.1687 245.1577 78.81638 7.322282 0.5585

0.45 97.31879 43.79345 10 B5-45 2.07204 0.78599 520.4901 245.1577 38.84519 3.608837 0.521670.6 99.48431 59.69059 11 B5-60 2.09497 0.77165 531.5401 245.1577 53.14201 4.937054 0.51082

0.75 97.9172 73.4379 12 B5-75 2.0784 0.77894 523.5436 245.1577 65.2586 6.062722 0.518630.9 94.33214 84.89892 13 B5-90 2.04 0.81676 505.2501 245.1577 74.70774 6.940577 0.53741

1.05 89.01343 93.4641 14 B5-105 1.98166 0.863 478.1103 245.1577 81.25523 7.548858 0.567910.5 90.20613 45.10307 15 B6-50 1.99489 0.84355 484.1963 245.1577 39.41223 3.661516 0.56077

0.65 92.12562 59.88165 16 B6-65 2.016 0.82012 493.9909 245.1577 52.64748 4.891111 0.549660.8 92.12562 73.70049 17 B6-80 2.016 0.82667 493.9909 245.1577 64.68632 6.009556 0.54966

0.95 89.01336 84.56269 18 B6-95 1.98165 0.85 478.1099 245.1577 73.76826 6.853296 0.56791

h = Jarak antara Center poros dengan sarat= 4.26 m (diperoleh dari gambar lines plan)

Ae/A0 A0 Ae/Ad

Page 120: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Nama : Mhd. Dolimora MartadhoL. TobingNRP : 4213100069

Koreksi Daya Motora. Effective Horse PowerEHP = Rt * Vs = 1488.74 Kw

= 1996.7 Hp

b. Delivered Horse PowerDHP = EHP/Pc = 2253.58 Kw

= 3022.51 Hp = 0.66061

c. Trusted Horse Power= 1342.38= 1800.4

d. Shaft Horse Power2299.57 Kw

= 3084.19 Hp

e. Brake Horse Power2346.51 Kw

= 3147.14 HpBHPmcr = BHPscr/0,85 = 2760.59 Kw

3702.51 Hp

Pc = ƞrr * ƞ0 * ƞh

THP = EHP/ƞh

SHP = DHP/ƞsƞb =

BHPscr = SHP/ƞG =

Page 121: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Nama : Mhd. Dolimora MartadhoL. TobingNRP : 4213100069

Tc Hitungan τC Kavitasi0.224651276 0.18195 Yes0.160427815 0.183009 No0.137028532 0.188164 No0.132990498 0.196651 No0.228516805 0.192011 Yes

0.16977119 0.190599 No0.142244129 0.193608 No0.135194696 0.200475 No0.134374927 0.207948 No0.254666579 0.200587 Yes0.182283645 0.19832 No0.150706208 0.199956 No0.136411091 0.203794 No0.132538572 0.209752 No0.269816981 0.208387 Yes0.197981763 0.206226 No0.161135173 0.206226 No0.145990429 0.209752 No

m (diperoleh dari gambar lines plan)

Page 122: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Nama : Mhd. Dolimora MartadhoL. TobingNRP : 4213100069

Koreksi Daya Motor

ƞrr = 1.075ƞ0 = 0.554106ƞh = 1.10903

Page 123: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Propeller yang dipilih

Tipe Rps Db(m) ƞ0 P/DbB5-60 2.987 3.431 0.554 0.7717

Vs(Knot) Vs (m/s) Ct Ctsm Va (m/s) bservice14 7.196 0.003649 0.004197 5.069942 0.87385 1.004927

13.5 6.939 0.003458 0.003976 4.888872 0.827915 0.95210213 6.682 0.003308 0.003804 4.707803 0.792111 0.91092812 6.168 0.00305 0.003507 4.345664 0.730302 0.83984711 5.654 0.002916 0.003353 3.983526 0.698263 0.80300310 5.14 0.00282 0.003243 3.621387 0.67518 0.776457

9 4.626 0.002766 0.003181 3.259248 0.662415 0.761777

Menghitung Kt

Vs (knot) Vs (m/s) VA (m/s) J KtTrial KtService14 7.196 5.069942 0.494706 0.213861 0.24594

13.5 6.939 4.888872 0.477038 0.188405 0.21666513 6.682 4.707803 0.45937 0.167152 0.19222512 6.168 4.345664 0.424034 0.131312 0.15100811 5.654 3.983526 0.388697 0.105498 0.12132210 5.14 3.621387 0.353361 0.084306 0.096952

9 4.626 3.259248 0.318025 0.066997 0.077046

Menghitung Nilai Beta ()

trial

KtTrial

KtService

Page 124: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Keadaan Trial

JKT pada Vs

14 13.5 13 12 11 10 90 0 0 0 0 0 0 0

0.1 0.008738 0.008279 0.007921 0.007303 0.006983 0.006752 0.0066240.2 0.034954 0.033117 0.031684 0.029212 0.027931 0.027007 0.0264970.3 0.078646 0.074512 0.07129 0.065727 0.062844 0.060766 0.0596170.4 0.139816 0.132466 0.126738 0.116848 0.111722 0.108029 0.1059860.5 0.218462 0.206979 0.198028 0.182575 0.174566 0.168795 0.1656040.6 0.314586 0.298049 0.28516 0.262909 0.251375 0.243065 0.2384690.7 0.428186 0.405678 0.388135 0.357848 0.342149 0.330838 0.3245830.8 0.559264 0.529866 0.506951 0.467393 0.446889 0.432115 0.4239450.9 0.707818 0.670611 0.64161 0.591544 0.565593 0.546896 0.536556

1 0.87385 0.827915 0.792111 0.730302 0.698263 0.67518 0.662415

14

13.5

13

12

11

10

9

Page 125: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Keadaan Service

JKT pada Vs

14 13.5 13 12 11 10 90 0 0 0 0 0 0 0

0.1 0.010049 0.009521 0.009109 0.008398 0.00803 0.007765 0.0076180.2 0.040197 0.038084 0.036437 0.033594 0.03212 0.031058 0.0304710.3 0.090443 0.085689 0.081984 0.075586 0.07227 0.069881 0.068560.4 0.160788 0.152336 0.145749 0.134376 0.12848 0.124233 0.1218840.5 0.251232 0.238026 0.227732 0.209962 0.200751 0.194114 0.1904440.6 0.361774 0.342757 0.327934 0.302345 0.289081 0.279525 0.274240.7 0.492414 0.46653 0.446355 0.411525 0.393471 0.380464 0.3732710.8 0.643153 0.609345 0.582994 0.537502 0.513922 0.496933 0.4875370.9 0.813991 0.771203 0.737852 0.680276 0.650432 0.62893 0.617039

1 1.004927 0.952102 0.910928 0.839847 0.803003 0.776457 0.761777

P/D = 0,7 P/D = 0,8

J KT 10KQ ƞ J KT 10KQ0 0.311757 0.334582 0 0 0.358682 0.427223

0.1 0.285442 0.313973 0.147017 0.1 0.335052 0.4035930.2 0.254025 0.285778 0.286717 0.2 0.3035 0.3729810.3 0.215693 0.255166 0.41091 0.3 0.266377 0.3387440.4 0.174541 0.220929 0.514829 0.4 0.227038 0.3006140.5 0.1301 0.180784 0.5829 0.5 0.181724 0.2569110.6 0.082639 0.134732 0.592769 0.6 0.135001 0.208040.7 0.03323 0.085727 0.441522 0.7 0.086532 0.1554760.8 0 0.034573 0 0.8 0.034975 0.0947220.9 0 0 0 0.9 0 0.034573

14

13.5

13

12

11

10

9

Page 126: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

1 0 0 0 1 0 0

P/D = 0,7789

J KT 10KQ ƞ0 0.345402 0.401006 0

0.1 0.321012 0.37823 0.1381610.2 0.289499 0.348302 0.2706890.3 0.252033 0.315091 0.3903570.4 0.212181 0.278063 0.4949980.5 0.167115 0.235367 0.5759210.6 0.120182 0.187294 0.6196750.7 0.071448 0.135737 0.5792310.8 0.025077 0.0777 0.3486280.9 0 0.024789 0

1 0 0 0

KT

10KQ

ƞ

Page 127: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Keadaan Trial

Vs J KT KQ n(rps) N(rpm) Q(kNm)14 0.457392 0.186963 0.024667 0.546815 3.230677 969.203 125.4657

13.5 0.465092 0.183556 0.024341 0.552889 3.063718 919.1153 111.341913 0.471355 0.180741 0.024074 0.55763 2.911047 873.3141 99.420412 0.483265 0.175407 0.023541 0.56637 2.620899 786.2696 78.8039611 0.489425 0.172593 0.023274 0.570667 2.372251 711.6754 63.8294810 0.494456 0.17037 0.023037 0.574074 2.13465 640.395 51.15728

9 0.498357 0.168593 0.022859 0.576593 1.906145 571.8435 40.47636

Vs DHP SHP BHPscr % Daya % RPM14 2547.845 2599.842 2652.9 86.70% 96.92%

13.5 2144.184 2187.943 2232.595 72.96% 91.91%13 1819.196 1856.322 1894.206 61.90% 87.33%12 1298.234 1324.728 1351.764 44.18% 78.63%11 951.7801 971.2042 991.0247 32.39% 71.17%10 686.4182 700.4268 714.7212 23.36% 64.04%

9 484.9668 494.8641 504.9633 16.50% 57.18%

Keadaan Service

Vs J KT KQ n(rps) N(rpm) Q(kNm)14 0.430539 0.188117 0.025278 0.508333 3.432175 1029.652 145.1126

13.5 0.438817 0.184568 0.024954 0.514969 3.247166 974.1499 128.224713 0.446686 0.181327 0.024645 0.520833 3.071817 921.5451 113.330812 0.455985 0.177315 0.024275 0.527469 2.777695 833.3084 91.2746411 0.461913 0.174691 0.024028 0.531481 2.513547 754.0642 73.9801410 0.468146 0.172068 0.023765 0.535648 2.254616 676.3847 58.87327

9 0.472847 0.170062 0.02358 0.538735 2.008981 602.6943 46.37965

Vs DHP SHP BHP % Daya % RPM14 3130.611 3194.501 3259.695 106.526% 102.965%

13.5 2617.163 2670.574 2725.076 89.055% 97.415%13 2188.256 2232.914 2278.484 74.460% 92.155%12 1593.636 1626.16 1659.347 54.227% 83.331%11 1168.845 1192.699 1217.04 39.773% 75.406%10 834.3444 851.3718 868.7467 28.390% 67.638%

9 585.6766 597.6292 609.8257 19.929% 60.269%

ƞ0

ƞ0

Page 128: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi
Page 129: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

KT

10KQ

ƞ

14

13.5

13

12

11

10

9

Page 130: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

P/D = 0,8

ƞ0

0.1346650.2643630.3822450.4871710.5731660.6302950.6335840.486231

0

14

13.5

13

12

11

10

9

KT

10KQ

ƞ

14

13.5

13

12

11

10

9

Page 131: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

0

Page 132: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Keadaan Trial

T(kNm)277.172

244.7213217.5511171.1414137.9591110.269287.00757

Keadaan Service

T(kNm)314.7561276.4216243.0302194.3214156.7661124.2372

97.4911

Page 133: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Propeller Drawing (Ae, Ad, Ap) Type: Wagenengin B srew series

Data teknis propeller yang dibutuhkan untuk perhitungan :* Ukuran utama propeller :- Type = B5-60 - Jari - jari ( R )- Jumlah daun (Z) = 5 Daun - AE / A0- Putaran (N) = 179.24 rpm - Pitch rasio (P/D)- Diameter (D) = 3.43 m Efisiensi (η)

* Keterangan :- Z = Jumlah Daun Propeler- D = Diameter Propeler- AE/A0 = Expanded ratio

Ae/Ao 0.6Z 5D 3.43 meter

Dimensions of 5-bladed Wageningen B-series (Marine Propeller and Propulsion, page 104)

r/R (CrZ)/(D(Ae/Ao) Cr Ar/Cr Ar Br/Cr Br

0.2 1.662 0.68428 0.617 0.4222 0.35 0.2394980.3 1.882 0.77486 0.613 0.474987 0.35 0.27120.4 2.05 0.84403 0.601 0.50726 0.35 0.2954090.5 2.152 0.88602 0.586 0.519209 0.35 0.3101080.6 2.187 0.90043 0.561 0.505142 0.389 0.3502680.7 2.144 0.88273 0.524 0.462549 0.443 0.3910480.8 1.97 0.81109 0.463 0.375534 0.479 0.3885110.9 1.582 0.65134 0.351 0.228621 0.5 0.3256711 - 0 -

Untuk Perhitungan Propeller Nose Radius mengacu pada rumusan di Buku The Design of Marine Screw Propeller hlm.72

Untuk P>0 (Marine Propellers and Propulsion hal 104)

1. Menghitung nilai-nilai dimensi daun propeller Dimensi propeller meliputi ar, br, cr, dan Sr. Nilai-nilai di atas diperoleh dari tabel berikut:

2. Menghitung Ordinat YFACE dan YBACK Titik-titik koordinat yang dibutuhkan oleh profil dapat dihitung dengan formulasi yang diberikan oleh Van Gent et al (1973) dan Van Oossanen (1974) adalah sebagai berikut :

Setelah mengetahui nilai masing - masing (cr,ar,br dan Sr) diatas, maka langkah pengerjaan dilanjutkan pada penentuan penampang ketebalan tiap bagian daun menggunakan rumusan dan tabel dibawah ini :

YFACE = V1 (tmax – tl.e)

Page 134: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Untuk P<0

(marine propulsion hal 104 - 105)V1

Y face Pr/R -1 -0.95 -0.9 -0.8 -0.7 -0.6

0.15 0.3 0.2824 0.265 0.23 0.195 0.1610.2 0.2826 0.263 0.24 0.1967 0.157 0.1207

0.25 0.2598 0.2372 0.2115 0.1651 0.1246 0.08990.3 0.2306 0.204 0.179 0.1333 0.0943 0.06230.4 0.1467 0.12 0.0972 0.063 0.0395 0.02140.5 0.0522 0.042 0.033 0.019 0.01 0.0040.6 0 0 0 0 0 00.7 0 0 0 0 0 00.8 0 0 0 0 0 00.9 0 0 0 0 0 01 0 0 0 0 0 0

Y face Pr/R 0 0.2 0.4 0.5 0.6 0.7

0.15 0 0.0096 0.0384 0.0615 0.092 0.1320.2 0 0.0049 0.0304 0.052 0.0804 0.118

0.25 0 0.0031 0.0224 0.0417 0.0669 0.10080.3 0 0.0027 0.0148 0.03 0.0503 0.0790.4 0 0 0.0033 0.009 0.0189 0.03570.5 0 0 0 0.0008 0.0034 0.00850.6 0 0 0 0 0 00.7 0 0 0 0 0 00.8 0 0 0 0 0 00.9 0 0 0 0 0 01 0 0 0 0 0 0

V2Y back P

r/R -1 -0.95 -0.9 -0.8 -0.7 -0.60.15 0 0.054 0.1325 0.287 0.428 0.55850.2 0 0.064 0.1455 0.306 0.4535 0.5842

0.25 0 0.725 0.1567 0.3228 0.474 0.6050.3 0 0.08 0.167 0.336 0.4885 0.61950.4 0 0.0905 0.181 0.35 0.504 0.6353

YBACK = (V1 + V2 ) (tmax – tl.e) + tl.e

YFACE = V1 (tmax – tl.e)

YBACK = (V1 + V2 ) ( tmax – tl.e ) + tl.e

Dimana nilai V1 dan V2 (tabulated functions dependent on r/R and P) merupakan konstanta yang bisa dilihat pada tabel berikut :

Page 135: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

0.5 0 0.095 0.1865 0.3569 0.514 0.64390.6 0 0.0965 0.1885 0.3585 0.511 0.64150.7 0 0.0975 0.19 0.36 0.51 0.640.8 0 0.0975 0.19 0.36 0.51 0.640.9 0 0.0975 0.19 0.36 0.51 0.641 0 0.0975 0.19 0.36 0.51 0.64

Y back Pr/R 0 0.2 0.4 0.5 0.6 0.7

0.15 1 0.976 0.8825 0.8055 0.7105 0.59950.2 1 0.975 0.8875 0.817 0.7277 0.619

0.25 1 0.9751 0.8899 0.8259 0.7415 0.63590.3 1 0.975 0.892 0.8315 0.752 0.65050.4 1 0.9725 0.8933 0.8345 0.7593 0.6590.5 1 0.971 0.888 0.8275 0.7478 0.6430.6 1 0.969 0.879 0.809 0.72 0.6060.7 1 0.9675 0.866 0.785 0.684 0.56150.8 1 0.9635 0.852 0.7635 0.6545 0.52650.9 1 0.96 0.84 0.75 0.64 0.511 1 0.96 0.84 0.75 0.64 0.51

KOORDINAT

Y face Pr/R -1 -0.9 -0.8 -0.7 -0.6 -0.50.2 0.03161 0.02684 0.02200 0.01756 0.01350 0.009840.3 0.02287 0.01775 0.01322 0.00935 0.00618 0.003730.4 0.01268 0.00840 0.00545 0.00342 0.00185 0.001000.5 0.00385 0.00243 0.00140 0.00074 0.00030 0.000090.6 0 0 0 0 0 00.7 0 0 0 0 0 0.8 0 0 0 0 0 00.9 0 0 0 0 0 01 0 0 0 0 0 0

Y face Pr/R 0 0.2 0.4 0.5 0.6 0.70.2 0 0.00055 0.00340 0.00582 0.00899 0.013200.3 0 0.00027 0.00147 0.00297 0.00499 0.007830.4 0 0 0.00029 0.00078 0.00163 0.003090.5 0 0 0 0.00006 0.00025 0.000630.6 0 0 0 0 0 00.7 0 0 0 0 0 00.8 0 0 0 0 0 0

Page 136: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

0.9 0 0 0 0 0 01 0 0 0 0 0 0

Y back Pr/R -1 -0.9 -0.8 -0.7 -0.6 -0.50.2 0.03161 0.04312 0.05623 0.06828 0.07884 0.088080.3 0.02287 0.03431 0.04653 0.05779 0.06760 0.076460.4 0.01268 0.02405 0.03571 0.04699 0.05678 0.066070.5 0.00385 0.01619 0.02773 0.03865 0.04779 0.056000.6 0 0.01151 0.02189 0.03121 0.03918 0.045990.7 0 0.00919 0.01742 0.02467 0.03096 0.036280.8 0 0.00678 0.01285 0.01820 0.02284 0.026760.9 0 0.00437 0.00828 0.01172 0.01471 0.017241 0 0 0 0 0 0

Y back Pr/R 0 0.2 0.4 0.5 0.6 0.70.2 0.11185 0.10960 0.10267 0.09720 0.09039 0.082430.3 0.09916 0.09694 0.08991 0.08542 0.07955 0.072330.4 0.08646 0.08408 0.07752 0.07293 0.06728 0.060060.5 0.07377 0.07163 0.06550 0.06110 0.05541 0.048060.6 0.06107 0.05918 0.05368 0.04941 0.04397 0.037010.7 0.04838 0.04680 0.04189 0.03798 0.03309 0.027160.8 0.03568 0.03438 0.03040 0.02724 0.02335 0.018790.9 0.02299 0.02207 0.01931 0.01724 0.01471 0.011721 0 0 0 0 0 0

DISTRIBUSI PITCHD : 3431 mmP/D : 0.7717P : 2647.703 mmP/2π : 421.6087 mm

3. Menghitung distribusi Pitch Distribusi pitch propeller pada setiap r/R , dapat dilihat pada tabel berikut :

Page 137: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

r/R %Ho/2n Ordinat Gambar0.1 80% 337.287 337.29 0.3372870.2 82% 346.5624 346.56 0.3465620.3 89% 373.9669 373.97 0.3739670.4 95% 400.5283 400.53 0.4005280.5 99% 418.2358 418.24 0.4182360.6 100% 421.6087 421.61 0.4216090.7 100% 421.6087 421.61 0.4216090.8 100% 421.6087 421.61 0.4216090.9 100% 421.6087 421.61 0.421609

Page 138: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

Propeller Drawing (Ae, Ad, Ap) Type: Wagenengin B srew series

- Jari - jari ( R ) = 1.716 m= 0.6

- Pitch rasio (P/D) = 0.7717 Efisiensi (η) = 0.554

(Marine Propeller and Propulsion, page 104)

Sr/D = Ar-BrZSr Cr-Ar

Ar Br0.0526 0.004 0.111851 0.26207870.0464 0.0035 0.099156 0.29986970.0402 0.003 0.086461 0.33676640.034 0.0025 0.073767 0.3668129

0.0278 0.002 0.061072 0.39528950.0216 0.0015 0.048377 0.42017840.0154 0.001 0.035682 0.43555450.0092 0.0005 0.022988 0.42272030.003 0 0.010293

Untuk Perhitungan Propeller Nose Radius mengacu pada rumusan di Buku The Design of Marine Screw Propeller hlm.72

(Marine Propellers and Propulsion hal 104)

Dimensi propeller meliputi ar, br, cr, dan Sr. Nilai-nilai di atas diperoleh dari tabel berikut:

Titik-titik koordinat yang dibutuhkan oleh profil dapat dihitung dengan formulasi yang diberikan oleh Van Gent et al (1973) dan Van Oossanen

Setelah mengetahui nilai masing - masing (cr,ar,br dan Sr) diatas, maka langkah pengerjaan dilanjutkan pada penentuan penampang ketebalan tiap

Page 139: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

(marine propulsion hal 104 - 105)

P-0.5 -0.4 -0.2 0

0.128 0.955 0.365 00.088 0.0592 0.0172 0

0.0579 0.035 0.0084 00.0376 0.0202 0.0033 00.0116 0.0044 0 00.0012 0 0 0

0 0 0 00 0 0 00 0 0 00 0 0 00 0 0 0

P0.8 0.85 0.9 0.95

0.187 0.223 0.2642 0.3150.1685 0.2 0.2353 0.28210.1465 0.1747 0.2068 0.25130.1191 0.1445 0.176 0.21860.0637 0.0833 0.1088 0.14670.0211 0.0328 0.05 0.07780.0006 0.0022 0.0067 0.0169

0 0 0 00 0 0 00 0 0 00 0 0 0

P-0.5 -0.4 -0.2 0

0.677 0.7805 0.936 10.6995 0.7984 0.9446 10.7184 0.8139 0.9519 10.7335 0.8265 0.9583 10.7525 0.8415 0.9645 1

(tabulated functions dependent on r/R and P) merupakan konstanta yang bisa dilihat pada tabel berikut :

Page 140: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

0.758 0.8456 0.9639 10.753 0.8426 0.9613 10.75 0.84 0.96 10.75 0.84 0.96 10.75 0.84 0.96 10.75 0.84 0.96 1

P0.8 0.85 0.9 0.95

0.452 0.3665 0.26 0.130.4777 0.3905 0.284 0.1560.4982 0.4108 0.3042 0.17580.513 0.4265 0.3197 0.1890.522 0.4335 0.3235 0.1935

0.5039 0.4135 0.3056 0.1750.462 0.3775 0.272 0.14850.414 0.33 0.2337 0.124

0.3765 0.2925 0.2028 0.1050.36 0.2775 0.19 0.09750.36 0.2775 0.19 0.0975

KOORDINAT

-0.4 -0.2 00.00662 0.00192 00.00200 0.00033 00.00038 0.00000 0

0 0 00 0 00 0 00 0 00 0 00 0 0

0.8 0.9 10.01885 0.02632 0.039820.01181 0.01745 0.028980.00551 0.00941 0.018860.00156 0.00369 0.009430.00004 0.00041 0.00233

0 0 00 0 0

Page 141: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi

0 0 00 0 0

-0.4 -0.2 00.09592 0.10758 0.111850.08396 0.09535 0.099160.07314 0.08339 0.086460.06238 0.07110 0.073770.05146 0.05871 0.061070.04064 0.04644 0.048380.02997 0.03426 0.035680.01931 0.02207 0.02299

0 0 0

0.8 0.9 10.07228 0.05808 0.039820.06268 0.04915 0.028980.05064 0.03738 0.018860.03873 0.02623 0.009430.02825 0.01702 0.002330.02003 0.01131 00.01343 0.00724 00.00828 0.00437 0

0 0 0

Page 142: Excel Perhitungan Mata Kuliah Tahanan Dan Propulsi