Cara perhitungan Tangki pengaduk pake Excel ( Labtekim Unjani )
19
Data 1 Diameter Propeler 0.05 m Diameter Turbin 0.06 m Massa Pikno kosong 28.9 gr Massa Pikno + air 54.3 gr 0.99708 gr/ml Massa air 25.4 gr Volume Pikno 25.47439 mL t viskos murni 3.56 s Propeller Air Murni Jenis Tangki Letak Impellert (menit) N (put/5 mnt) N/s Baffle Centre 5 406 1.353333333 5 525 1.75 5 680 2.266666667 Off Centre 5 410 1.366666667 5 526 1.753333333 5 675 2.25 Unbaffle Centre 5 411 1.37 5 525 1.75 5 681 2.27 Off Centre 5 406 1.353333333 5 527 1.756666667 5 679 2.263333333 Turbin Air Murni Jenis Tangki Letak Impellert (menit) N (put/5 mnt) N/s Baffle Centre 5 405 1.35 5 550 1.833333333 5 670 2.233333333 Off Centre 5 408 1.36 5 549 1.83 5 673 2.243333333 Unbaffle Centre 5 405 1.35 5 550 1.833333333 5 673 2.243333333 Off Centre 5 406 1.353333333 5 551 1.836666667 5 678 2.26 Propeller Larutan Kanji Jenis Tangki Letak Impellert (menit) N (put/5 mnt) N/s Baffle Centre 5 420 1.4 5 525 1.75 5 710 2.366666667 r air
-
Upload
arya-wulandari -
Category
Documents
-
view
418 -
download
3
description
buat temen temen semua yang menghitung laporan tangki pengaduk, mari kita pake excel biar mempercepat dan mempermudah.tinggal menuliskan formula yang benear,, tarik kebawahhitungan selesai gkgkgkg
Transcript of Cara perhitungan Tangki pengaduk pake Excel ( Labtekim Unjani )
Data 1
Diameter Propeler 0.05 mDiameter Turbin 0.06 mMassa Pikno kosong 28.9 grMassa Pikno + air 54.3 gr
0.99708 gr/mlMassa air 25.4 grVolume Pikno 25.47439 mLt viskos murni 3.56 s
Propeller Air MurniJenis Tangki Letak Impeller t (menit) N (put/5 mnt) N/s V (volt) I (A)
Baffle
Centre5 406 1.3533333333 11 0.15 525 1.75 14 0.15 680 2.2666666667 17 0.2
Off Centre5 410 1.3666666667 11 0.15 526 1.7533333333 14 0.15 675 2.25 17 0.2
Unbaffle
Centre5 411 1.37 11 0.15 525 1.75 14 0.15 681 2.27 17 0.2
Off Centre5 406 1.3533333333 11 0.15 527 1.7566666667 14 0.15 679 2.2633333333 17 0.2
Turbin Air MurniJenis Tangki Letak Impeller t (menit) N (put/5 mnt) N/s V (volt) I (A)
Baffle
Centre5 405 1.35 11 0.15 550 1.8333333333 14 0.15 670 2.2333333333 17 0.2
Off Centre5 408 1.36 11 0.15 549 1.83 14 0.15 673 2.2433333333 17 0.2
Unbaffle
Centre5 405 1.35 11 0.15 550 1.8333333333 14 0.15 673 2.2433333333 17 0.2
Off Centre5 406 1.3533333333 11 0.15 551 1.8366666667 14 0.15 678 2.26 17 0.2
Propeller Larutan KanjiJenis Tangki Letak Impeller t (menit) N (put/5 mnt) N/s V (volt) I (A)
Baffle
Centre5 420 1.4 11 0.15 525 1.75 14 0.15 710 2.3666666667 17 0.2
r air
Baffle
Off Centre5 420 1.4 11 0.15 525 1.75 14 0.15 710 2.3666666667 17 0.2
Unbaffle
Centre5 420 1.4 11 0.15 525 1.75 14 0.15 710 2.3666666667 17 0.2
Off Centre5 420 1.4 11 0.15 525 1.75 14 0.15 710 2.3666666667 17 0.2
Turbin Larutan KanjiJenis Tangki Letak Impeller t (menit) N (put/5 mnt) N/s V (volt) I (A)
Baffle
Centre5 420 1.4 11 0.15 550 1.8333333333 14 0.15 735 2.45 17 0.2
Off Centre5 425 1.4166666667 11 0.15 540 1.8 14 0.15 710 2.3666666667 17 0.2
Unbaffle
Centre5 430 1.4333333333 11 0.15 550 1.8333333333 14 0.15 715 2.3833333333 17 0.2
Off Centre5 435 1.45 11 0.15 525 1.75 14 0.15 725 2.4166666667 17 0.2
P (watt) t viskos (s) M. pikno+air (gram) ρ air (g/ml) ц air (kg/m.s)1.1 3.56 54.3 0.99708 0.00089371.4 3.52 54.3 0.99708 0.00089373.4 3.43 54.3 0.99708 0.00089371.1 3.7 54.3 0.99708 0.00089371.4 3.51 54.3 0.99708 0.00089373.4 3.4 54.3 0.99708 0.00089371.1 3.55 54.3 0.99708 0.00089371.4 3.52 54.3 0.99708 0.00089373.4 3.41 54.3 0.99708 0.00089371.1 3.67 54.3 0.99708 0.00089371.4 3.53 54.3 0.99708 0.00089373.4 3.42 54.3 0.99708 0.0008937
P (watt) t viskos (s) M. pikno+air (gram) ρ air (g/cm3) ц air (kg/m.s)1.1 3.69 54.3 0.99708 0.00089371.4 3.52 54.3 0.99708 0.00089373.4 3.46 54.3 0.99708 0.00089371.1 3.7 54.3 0.99708 0.00089371.4 3.52 54.3 0.99708 0.00089373.4 3.45 54.3 0.99708 0.00089371.1 3.67 54.3 0.99708 0.00089371.4 3.51 54.3 0.99708 0.00089373.4 3.45 54.3 0.99708 0.00089371.1 3.7 54.3 0.99708 0.00089371.4 3.61 54.3 0.99708 0.00089373.4 3.52 54.3 0.99708 0.0008937
P (watt) t viskos (s) M. pikno+air (gram) ρ air (g/ml) ц air (kg/m.s)1.1 33.7 54.3 0.99708 0.00089371.4 32.5 54.3 0.99708 0.00089373.4 30.5 54.3 0.99708 0.0008937
1.1 30.17 54.3 0.99708 0.00089371.4 19.3 54.3 0.99708 0.00089373.4 28.1 54.3 0.99708 0.00089371.1 31.1 54.3 0.99708 0.00089371.4 30.5 54.3 0.99708 0.00089373.4 26.6 54.3 0.99708 0.00089371.1 25.04 54.3 0.99708 0.00089371.4 23.22 54.3 0.99708 0.00089373.4 21.8 54.3 0.99708 0.0008937
P (watt) t viskos (s) M. pikno+kanji (gram) ρ air (g/cm3) ц air (kg/m.s)1.1 33.7 54.3 0.99708 0.00089371.4 32.5 54.3 0.99708 0.00089373.4 30.5 54.3 0.99708 0.00089371.1 30.17 54.3 0.99708 0.00089371.4 19.3 54.3 0.99708 0.00089373.4 28.1 54.3 0.99708 0.00089371.1 31.1 54.3 0.99708 0.00089371.4 30.5 54.3 0.99708 0.00089373.4 26.6 54.3 0.99708 0.00089371.1 25.04 54.3 0.99708 0.00089371.4 23.22 54.3 0.99708 0.00089373.4 21.8 54.3 0.99708 0.0008937
ρ larutan (g/mL) ц larutan (kg/m.s) Nre Npo Nfr0.99708 0.0008937 3.77470515833 1424289.66152 0.009344444440.99708 0.00088365842696629 4.93655112301 838366.397227 0.0156250.99708 0.00086106488764045 6.56178190645 936992.072214 0.026213151930.99708 0.00092884550561798 3.66766053062 1383008.51007 0.009529478460.99708 0.00088114803370787 4.96004511479 833593.924481 0.01568458050.99708 0.00085353370786517 6.57100586458 957968.736475 0.025829081630.99708 0.00089118960674157 3.83195559527 1372938.09945 0.009576020410.99708 0.00088365842696629 4.93655112301 838366.397227 0.0156250.99708 0.0008560441011236 6.60997370646 932870.412128 0.026290306120.99708 0.0009213143258427 3.66156685658 1424289.66152 0.009344444440.99708 0.00088616882022472 4.94131919343 828857.606723 0.015744274380.99708 0.00085855449438202 6.57129050854 941138.048835 0.02613611111
ρ larutan (g/mL) ц larutan (kg/m.s) Nre Npo Nfr0.99708 0.00092633511235955 5.23116174195 576640.475041 0.011158163270.99708 0.00088365842696629 7.44713997986 293033.636347 0.020578231290.99708 0.00086859606741573 9.2292879288 393669.724383 0.030537414970.99708 0.00092884550561798 5.25566808525 564013.764812 0.011324081630.99708 0.00088365842696629 7.43359972535 294637.831534 0.020503469390.99708 0.0008660856741573 9.29748444094 388428.628689 0.03081149660.99708 0.0009213143258427 5.25966943537 576640.475041 0.011158163270.99708 0.00088114803370787 7.46835690288 293033.636347 0.020578231290.99708 0.0008660856741573 9.29748444094 388428.628689 0.03081149660.99708 0.00092884550561798 5.2299050064 572390.071019 0.011213333330.99708 0.00090625196629213 7.27467989611 291441.06573 0.020653129250.99708 0.00088365842696629 9.18029255699 379898.293459 0.03127102041
ρ larutan (g/mL) ц larutan (kg/m.s) Nre Npo Nfr0.99708 0.00307409694135519 1.13522119392 9630676.0704 0.010.99708 0.00151789237697776 2.87386975925 23939890.8 0.0156250.99708 0.00057591756232067 10.2434625821 143803740.396 0.02857709751
0.99708 0.00275209212821027 1.26804621264 9630676.0704 0.010.99708 0.00090139455002064 4.83941798838 23939890.8 0.0156250.99708 0.00053059945905609 11.118349066 143803740.396 0.028577097510.99708 0.00283692625745242 1.23012714583 9630676.0704 0.010.99708 0.00142448361531759 3.06232023527 23939890.8 0.0156250.99708 0.00050227564451573 11.7453236374 143803740.396 0.028577097510.99708 0.00228413612497134 1.52783363559 9630676.0704 0.010.99708 0.00108447572287457 4.02242752695 23939890.8 0.0156250.99708 0.00041163943798658 14.3314499428 143803740.396 0.02857709751
ρ larutan (g/mL) ц larutan (kg/m.s) Nre Npo Nfr0.99708 0.00846002528089888 0.59400333133 517037.831188 0.0120.99708 0.00815877808988764 0.80658254551 293033.636347 0.020578231290.99708 0.00765669943820225 1.14856873657 298190.914568 0.036750.99708 0.00757385646067416 0.67140274263 499003.282225 0.012287414970.99708 0.00484505898876405 1.33353967722 309616.618701 0.019836734690.99708 0.00705420505617977 1.20426348998 330812.093829 0.034292517010.99708 0.00780732303370787 0.65898807796 481797.814495 0.012578231290.99708 0.00765669943820225 0.85947320423 293033.636347 0.020578231290.99708 0.00667764606741573 1.28113205067 323920.399109 0.034777210880.99708 0.00628602471910112 0.8279887262 465374.32737 0.012872448980.99708 0.00582913314606742 1.07762232267 336920.652178 0.018750.99708 0.00547265730337079 1.58507933516 310700.823655 0.03575680272
Ln Nre Ln Npo Ln Nfr1.328322275897 14.16918376425 -4.672973289339451.596666934141 13.6392105121 -4.158883083359671.881262198152 13.75043010037 -3.641494012202611.299554001208 14.13977176397 -4.653365289146211.601414836419 13.63350166166 -4.15507718306751.88266692041 13.77257042226 -3.65625422679786
1.343375272168 14.13246359957 -4.648493179550451.596666934141 13.6392105121 -4.158883083359671.888579676014 13.74602157643 -3.638554996243891.297891158695 14.16918376425 -4.672973289339451.597632338756 13.62780365425 -4.15127851146021.882710237644 13.7548451122 -3.64443735342553
Ln Nre Ln Npo Ln Nfr1.654633383801 13.26497425777 -4.495583917535892.007830063364 12.58804268123 -3.883521495295932.222381898063 12.88326757375 -3.488802626978941.659307129501 13.24283393588 -4.480823702940642.006010226647 12.59350219138 -3.88716116872992.229743873349 12.86986472197 -3.479867392459511.660068179787 13.26497425777 -4.495583917535892.010675015496 12.58804268123 -3.883521495295932.229743873349 12.86986472197 -3.479867392459511.654393114699 13.25757598029 -4.49065173254551.984399811555 12.58259308845 -3.879888433443142.217059073078 12.84765884709 -3.46506347586817
Ln Nre Ln Npo Ln Nfr0.126827516459 16.08046398592 -4.605170185988091.055659469739 16.99105669668 -4.158883083359672.326639705236 18.78396001401 -3.5551496684722
0.237477300647 16.08046398592 -4.605170185988091.576794463164 16.99105669668 -4.158883083359672.40859681251 18.78396001401 -3.5551496684722
0.207117534633 16.08046398592 -4.605170185988091.119172875461 16.99105669668 -4.158883083359672.463455173062 18.78396001401 -3.55514966847220.423850807586 16.08046398592 -4.605170185988091.391885582805 16.99105669668 -4.158883083359672.662456419054 18.78396001401 -3.5551496684722
Ln Nre Ln Npo Ln Nfr-0.520870351334 13.15587132526 -4.42284862919414-0.214949036362 12.58804268123 -3.883521495295930.138516590347 12.60548921327 -3.30361705332329-0.398386109499 13.12036795232 -4.399179713900130.287836818395 12.64309009723 -3.920219772632320.185868168443 12.7093058008 -3.37282811167824-0.41704983575 13.08527983303 -4.37578763437375-0.15143563064 12.58804268123 -3.883521495295930.247744101654 12.68825308283 -3.35879296636095-0.188755740396 13.05059736582 -4.35266598957160.074757061069 12.72760272813 -3.976561526565720.460634459807 12.64658574634 -3.33101474203962
Propeller Larutan Kanji
Nre Npo
1.135221194 9630676.072.873869759 23939890.810.24346258 143803740.41.268046213 9630676.074.839417988 23939890.811.11834907 143803740.41.230127146 9630676.073.062320235 23939890.811.74532364 143803740.41.527833636 9630676.074.022427527 23939890.814.33144994 143803740.4
0 2 4 6 8 10 12 14 160
20000000400000006000000080000000
100000000120000000140000000160000000
f(x) = 12594409.0780022 x − 11611570.9413853
Grafik Hubungan Antara Nre dengan NPo
Grafik Hubungan Antara Nre dengan NPoLinear (Grafik Hubungan Antara Nre dengan NPo)
Turbin Larutan Kanji
Nre Npo
0.594003331 517037.83120.806582546 293033.63631.148568737 298190.91460.671402743 499003.28221.333539677 309616.61871.20426349 330812.0938
0.658988078 481797.81450.859473204 293033.63631.281132051 323920.39910.827988726 465374.32741.077622323 336920.65221.585079335 310700.8237
0 2 4 6 8 10 12 14 160
20000000400000006000000080000000
100000000120000000140000000160000000
f(x) = 12594409.0780022 x − 11611570.9413853
Grafik Hubungan Antara Nre dengan NPo
Grafik Hubungan Antara Nre dengan NPoLinear (Grafik Hubungan Antara Nre dengan NPo)
0.4 0.6 0.8 1 1.2 1.4 1.6 1.80
100000
200000
300000
400000
500000
600000
f(x) = − 204090.108300943 x + 576537.594835436
Grafik Hubungan Nre dengan NPo
Grafik Hubungan Nre dengan NPoLinear (Grafik Hubungan Nre dengan NPo)
0.4 0.6 0.8 1 1.2 1.4 1.6 1.80
100000
200000
300000
400000
500000
600000
f(x) = − 204090.108300943 x + 576537.594835436
Grafik Hubungan Nre dengan NPo
Grafik Hubungan Nre dengan NPoLinear (Grafik Hubungan Nre dengan NPo)
GaussPropeller Larutan Kanji
NO Ln Nre Ln Npo Ln Nfr1 0.126827516 16.08046399 -4.6051701862 1.05565947 16.9910567 -4.1588830833 2.326639705 18.78396001 -3.5551496684 0.237477301 16.08046399 -4.6051701865 1.576794463 16.9910567 -4.1588830836 2.408596813 18.78396001 -3.5551496687 0.207117535 16.08046399 -4.6051701868 1.119172875 16.9910567 -4.1588830839 2.463455173 18.78396001 -3.555149668
10 0.423850808 16.08046399 -4.60517018611 1.391885583 16.9910567 -4.15888308312 2.662456419 18.78396001 -3.555149668
Sum 15.999933661 207.4219228 -49.276811748
Rumus :
Matriks menjadi1 15.99993366 -49.27681175 207.4219228
15.99993366 255.9978771 -788.425719 3318.737-49.27681175 -788.425719 -2428.204176 -10221.1
eliminasi baris 2 oleh 10 -2.4400975462E-08 -2.3691427486E-08 -4.4296416490397E-06
Matriks menjadi1 15.99993366 -49.27681175 207.42192280 -2.44E-08 -2.37E-08 -4.43E-06
-49.27681175 -788.425719 -2428.204176 -10221.1
eliminasi baris 3 oleh 10 -2.3691427486E-08 -4856.4083522449 -0.0089573613677203
Matriks menjadi1 15.99993366 -49.27681175 207.42192280 -2.44E-08 -2.37E-08 -4.43E-060 -2.37E-08 -4856.408352 -0.008957361
åy = k - båx -eåzåyåx = kåx - b[åx]2-eåxåzåyåz=kåz -båxåz - e[åz]2
eliminasi baris 3 oleh 21 15.99993366 -49.27681175 207.42192280 -2.44E-08 -2.37E-08 -4.43E-060 0.00E+00 -4.86E+03 -8.95E-03
e= 1.84E-06b= -2.64E-06Ln k= 1.20852125637E+90
Turbin Larutan Kanji
NO Ln Nre Ln Npo Ln Nfr
1 -0.520870351 13.15587133 -4.4228486292 -0.214949036 12.58804268 -3.8835214953 0.13851659 12.60548921 -3.3036170534 -0.398386109 13.12036795 -4.3991797145 0.287836818 12.6430901 -3.9202197736 0.185868168 12.7093058 -3.3728281127 -0.417049836 13.08527983 -4.3757876348 -0.151435631 12.58804268 -3.8835214959 0.247744102 12.68825308 -3.358792966
10 -0.18875574 13.05059737 -4.3526659911 0.074757061 12.72760273 -3.97656152712 0.46063446 12.64658575 -3.331014742
Sum -0.496089504 153.60852851 -46.58055913
Rumus :
Matriks menjadi1 -0.496089504 -46.58055913 153.6085285
-0.496089504 0.246104796 23.10812647 -76.20357872-46.58055913 23.10812647 2169.748489 -7155.171145
eliminasi bari 2 oleh 10 2.10339523576E-11 -4.844373791E-09 -6.26512530743639E-09
Matriks menjadi1 -0.496089504 -46.58055913 153.60852850 2.10E-11 -4.84E-09 -6.27E-09
-46.58055913 23.10812647 2169.748489 -7155.171145
eliminasi bari 3 oleh 10 -4.844373791E-09 1.3657381714E-07 -3.33459865942132E-07
Matriks menjadi
åy = k - båx -eåzåyåx = kåx - b[åx]2-eåxåzåyåz=kåz -båxåz - e[åz]2
1 -0.496089504 -46.58055913 153.60852850 2.10E-11 -4.84E-09 -6.27E-090 -4.84E-09 1.37E-07 -3.33E-07
eliminasi baris 3 oleh 20 0.00E+00 -9.79E-07 -1.78E-06
Matriks menjadi1 -0.496089504 -46.58055913 153.60852850 2.10E-11 -4.84E-09 -6.27E-090 0.00E+00 -9.79E-07 -1.78E-06
e= 1.82E+00b= -4.19E+02k 18782863142148.6
-10221.09
0.24610479597896623.1081264748444
-76.20357871869572169.74848886343
-7155.17114513234
