efde'em.xlsx
14
PENGUKURA FLUID CIRCUIT FRIC No PENGUKURAN Q 1 0.3 0.0544 0 0.0136 0.0000833 2 0.5 0.0952 0.0272 0.1904 0.0001388889 3 0.7 0.1224 0.1088 0.2448 0.0001944444 4 0.9 0.1768 0.204 0.3264 0.00025 5 1.1 0.2856 0.3536 0.3944 0.0003055556 6 1.3 0.408 0.5168 0.408 0.0003611111 7 1.5 0.544 0.68 0.4352 0.0004166667 8 1.7 0.6392 0.8432 0.6528 0.0004722222 9 1.9 0.7072 1.1016 0.8296 0.0005277778 10 2.1 0.816 1.3736 1.0608 0.0005833333 ∆hI ∆hII ∆hIII QI m 3 /H mH2O m 3 /s
Transcript of efde'em.xlsx
Sheet1PENGUKURAN DAN PERHITUNGANFLUID CIRCUIT FRICTION EXPERIMENTAL APPARATUS
NoPENGUKURANPERHITUNGANQhIhIIhIIIQIVIVIIVIIIRedIRedIIRedIIIQo/Qn/QvCo/Cn/Cvm3/HmH2Om3/sm/sh3/45-6QvCvH 1H 2H 310.30.054400.01360.0000833267.3483394056040120.50.09520.02720.19040.0001388889467.8595939598133.6741697028721430.70.12240.10880.24480.0001944444601.5337636626534.6966788112981840.90.17680.2040.32640.00025868.88210306821002.55627277113152451.10.28560.35360.39440.00030555561403.57878187941737.764206136421262961.30.4080.51680.4080.00036111112005.1125455422539.809224353230383071.50.5440.680.43520.00041666672673.4833940563341.8542425740503281.70.63920.84320.65280.00047222223141.34298801584143.899260786847624891.90.70721.10160.82960.00052777783475.52841227285413.8038729633528161102.10.8161.37361.06080.00058333334010.2250910846750.54556999136010178
Sheet2PENGUKURAN DAN PERHITUNGAN FLUID CIRCUIT FRICTION EXPERIMENTAL APPARATUS
No.Q m3/HKatup I mmHgKatup II mmHgKatup III mmHgh kirih kananhIh kirih kananhIIh kirih kananhIII10.51901855225190352412904920.721120110286201853203011930.92452232234620913741330311041.1281250314172201975295247751.3316275414992212781931.72616.768561.5359306535832193641808.42753.7945.371.7400327732000.22534.25341685.12767.41082.381.9431348831959.12603643.91534.43027.71493.392.14743551191863.22671.5808.313703219.51849.5102.35063841221808.42740931.61041.23383.92342.7
Percobaan No. Katup dBTemperatur Air 27 CI 21-2210.0276V Kinematik0.0000008649m2/sII.9-101.250.0357dv0.0114mIII15-160.0357
NoPENGUKURANPERHITUNGANQVQhIhIIhIIIQIVIVIIVIIIRedIRedIIRedIIIQoCVm3/HmH2Om3/sm/s21-22(9-10)15-1615-1610.50.0050.0350.0010.0001388890.23226281360.13882299660.13882299667411.78593477195730.12021847925730.12021847920.025095088335.59602086370.00005059759.72433940540.000014282620.70.010.0850.0140.0001944440.3251679390.19435219520.194352195210376.50030868078022.16830587088022.16830587080.02560723386.36530181550.00018931863.63851463680.000053440630.90.0220.1370.0180.0002500000.41807306450.24988139380.249881393813341.214682589510314.216393262510314.21639326250.034079749643.02485907480.00021466714.12568780170.00006059641.10.0310.1970.0240.0003055560.51097818990.30541059240.305410592416305.929056498312606.264480654112606.26448065410.032146600741.41456699080.00024787624.3669394320.000069970251.30.0410.2780.0290.0003611110.60388331530.3609397910.36093979119270.643430407114898.312568045814898.31256804580.030440787641.84238711430.0002724764.69498768550.000076914261.50.0530.3640.030.0004166670.69678844080.41646898970.416468989722235.357804315817190.360655437517190.36065543750.029556437341.14862109420.0002771345.32624004920.00007822971.70.0730.5340.0320.0004722220.78969356620.47199818830.471998188325200.072178224619482.408742829119482.40874282910.031694488746.99648306240.00028622285.84472438570.000080794681.90.0830.64390.0480.0005277782.59375942030.52752738690.527527386982769.984969534921774.456830220821774.45683022080.003340387145.36776846890.00035054995.33363247470.000098952892.10.1190.80830.0610.0005833332.86678672770.58305658550.583056585591482.61496632824066.504917612424066.50491761240.003920435246.62012514350.00039517935.22931112290.0001115507102.30.1120.93160.0780.0006388893.13981403510.63858578410.6385857841100195.24496312126358.553005004126358.55300500410.003076013744.79387656630.00044686525.06489724320.0001261405Hubungan antara Bilangan Reynold dengan Kerugian Gesek () Keterangan: X = Red, Y =
No.XYXYX2X3X4X2Y(Y-y)2(Y-a-bX)2(Y-i-jX-kX2)217411.78593477190.0250950883185.999422604554934570.7440716327876530178070627048401378587.904335690.00001023590.0000532210376.50030868070.025607233265.7134608636107671758.6560511117256036931115932076120869002757175.808671380.00001377530.0000335313341.21468258950.0340797496454.6652552554177988009.2069422374576241757316797314214504006065786.779077030.00014845050.0000135416305.92905649830.0321466007524.1801909763265883322.3955554335474592288706939411280986008547245.006881270.00010508050.0000074519270.64343040710.0304407876586.6135635988371357698.221891715630178757113790654002866100011304420.81555270.00007301810.0000040622235.35780431580.0295564373657.1979598692494411136.6859491099340852665124444237207909200014613031.78595830.00005868660.0000045725200.07217822460.0316944887798.7034029487635043637.787731600314550857340328042189467400020127383.40330110.00009601580.0000275882769.98496953490.0033403871276.48379083796850870411.857035670464410176374693442540005800000022884559.21197240.00034430050.0000153991482.6149663280.0039204352358.65166442028369068841.077427656243024149797004131326669300000032810392.12318940.00032311090.000000210100195.2449631210.0030760137308.201941803610039087113.2198100586879251518010078327006681683000030880369.05711940.00035418140.0000027388589.3482944720.21895722124416.410653178227366316499.85132380926861920330218661622754794600000151368951.8960590.00152685560.0001617yY0.0218957221na(Y)(X2)-(X)(XY)0.0348592106(nX2)-(X)2b(nXY)-(X)(Y)-0.0000003336(nX2)-(X)2Yax + b2,89295921693888-3,90104E-05r2(Y-y)2-(Y-a-bx)2(Y-y)2Regresi PolinomialYni + jX + X217.290700122910i298353.369850592j10941394301.6064ki29835.336991094139430.16064XYiX + jX2 + kX317.3255589998298353.369850592i10941394301.6064j448163645289177kiiX2YiX2 + jX3 + kX414826155165.012510941394301.6064i448163645289177j19557546035585200000kiiieliminasi I dan ii515873.864958932298353.3699i8901473331.59453j326440186128892k20.1836203294298353.369850592i10941394301.6064j448163645289177k515853.6813386030i-2039920970.01184j-121723459160286kiv59670.6740132379eliminasi I dan iii18918436779.51810941394301.6064i326440186074833j11971410926322400000k14826155165.012510941394301.6064i448163645289177j19557546035585200000k4092281614.505550i-121723459214345j-7586135109262780000kveliminasi iv dan v 30781336857.68450i-121723459214345j-7263320851317070000k4092281614.505550i-121723459214345j-7586135109262780000k26689055243.17890i0j0k
Sheet3
