53273731 (XLS) - Fichier XLS

Fichier partagé
53273731 (XLS)

Aperçu texte

Pompes
Volume 750.0 Diamètre tuyauterie  50.0 Coudes 90° 4.0  v (3 10-8 e(-0 1162*d)) (L + 3 24 d C)    8.524691125694663e-08 b v² Qh4 + 2 b w v Qh3 + b (2 H v + w² + a v) Qh² + (a w + 2 b H w - 1) Qh + Q0 + a H + b H²  
Hauteur 220.0 Longueur tuyauterie  300.0    w (0 0019 e(-0 2041*d)) (L + 3 24 d C)    6.66172576204305e-05   
Marque Type Débit [l/h] Puissance [W] Perte chg [cm] Turn over Q P H H 2 Zéro Débit  b a Qh Goal seek 0 Qh
          H / 2 H = 0 2 (Q0 - 2 QH/2) / H² - Q0 / H - b H Q0 + a h + b h²  
Sequence S18000 15200.0 55.0 20.70802869263549 20.266666666666666 276.3636363636364 500.0 250.0 0.0 15000.0 18800.0 -0.0896 7.199999999999996 15341.641991679297 0.0006987120686972048 15188.464015800499
Sicce 14000E 13200.0 67.0 15.732769618000063 17.6 197.01492537313433 850.0 425.0 0.0 11000.0 13700.0 -0.022975778546712802 3.4117647058823515 13227.502138625518 1.9813342078123242e-08 13176.255608724443
Sicce 16000E 12900.0 90.0 15.045301125572042 17.2 143.33333333333334 500.0 250.0 0.0 12500.0 16000.0 -0.072 4.0 12962.448066655108 1.6951347333815647e-05 12901.502918931148
Tunze 1073.140 12600.0 220.0 14.373177077170272 16.8 57.27272727272727 850.0 425.0 0.0 10500.0 13100.0 -0.021868512110726643 3.1764705882352917 12643.224941850254 3.3651303965598345e-09 12599.310710293305
ATK MP 15000 12450.0 270.0 14.042869219479229 16.6 46.111111111111114 700.0 350.0 0.0 10200.0 15000.0 -0.022040816326530613 -5.999999999999998 12388.433605028325 1.3024123290961143e-07 12469.029497580406
Tunze 1073.160 12300.0 230.0 13.716397472794752 16.4 53.47826086956522 500.0 250.0 0.0 11800.0 15700.0 -0.0632 0.20000000000000284 12294.54727840236 2.9118687052687164e-06 12292.297151017585
Red dragon RD 12000 10550.0 115.0 10.191006408071843 14.066666666666666 91.73913043478261 400.0 200.0 0.0 12000.0 8000.0 -0.2 60.0 11213.880498252116 -1.2381497072055936e-07 10533.796051038269
ATK MP 12065 9650.0 190.0 8.581262029562167 12.866666666666667 50.78947368421053 650.0 325.0 0.0 8000.0 12000.0 -0.01893491124260355 -6.1538461538461515 9604.008454236495 0.0009816586443776032 9653.728131486136
ATK MP 10062 7600.0 140.0 5.430152752116509 10.133333333333333 54.285714285714285 620.0 310.0 0.0 6300.0 10000.0 -0.013527575442247659 -7.741935483870968 7567.279775771383 2.7138185032526962e-09 7605.864690769379
ATK MP 10044 7250.0 115.0 4.963765890691378 9.666666666666666 63.04347826086956 410.0 205.0 0.0 7800.0 10000.0 -0.06662700773349196 2.926829268292682 7286.5245569573835 6.427589596569305e-06 7271.687087509276
Sicce 9000 7150.0 120.0 4.8343486127193325 9.533333333333333 59.583333333333336 500.0 250.0 0.0 6800.0 8300.0 -0.0424 4.599999999999998 7190.897468615622 3.9358837966574356e-08 7169.522662044365
Tunze 1073.090 7150.0 120.0 4.8343486127193325 9.533333333333333 59.583333333333336 500.0 250.0 0.0 6800.0 8300.0 -0.0424 4.599999999999998 7190.897468615622 3.9358837966574356e-08 7169.522662044365
Aquael PFN10000 7000.0 160.0 4.643419454933398 9.333333333333334 43.75 450.0 225.0 0.0 7000.0 9000.0 -0.04938271604938271 2.2222222222222214 7007.125331904535 3.4065897125401534e-07 6997.45557682149
Sicce 9000E 6950.0 55.0 4.5806288714506564 9.266666666666667 126.36363636363636 500.0 250.0 0.0 6500.0 8800.0 -0.0336 -0.8000000000000007 6925.670479062484 7.00538294040598e-09 6929.463053939934
Oase Promax 20000 6700.0 55.0 4.273069472381218 8.933333333333334 121.81818181818181 340.0 170.0 0.0 9600.0 20000.0 0.01384083044982699 -63.52941176470588 6448.235582177631 0.0008394089524017545 6687.9527836367715
Iwaki MD100R 6500.0 245.0 4.034694175138793 8.666666666666666 26.53061224489796 860.0 430.0 0.0 5100.0 7200.0 -0.008112493239588967 -1.395348837209303 6480.214887028622 7.050186923152069e-08 6485.344953217957
Red Dragon RD 10000 6400.0 98.0 3.9180639338552887 8.533333333333333 65.3061224489796 400.0 200.0 0.0 7000.0 10300.0 -0.04625 -7.25 6357.651441269818 3.9599490264663473e-07 6384.51001666589
Resun King 6 5800.0 125.0 3.2540861888821815 7.733333333333333 46.4 550.0 275.0 0.0 5000.0 8500.0 -0.009917355371900827 -10.0 5773.154473648043 0.0003430717487731272 5802.1045584216945
Red Dragon RD 8000 5450.0 68.0 2.8951104356408033 7.266666666666667 80.1470588235294 410.0 205.0 0.0 5800.0 8500.0 -0.036882807852468766 -5.609756097560975 5417.192642898681 1.2209511623950675e-08 5432.2146733860745
ATK MP 8041 5250.0 95.0 2.699358594026852 7.0 55.26315789473684 410.0 205.0 0.0 5600.0 8000.0 -0.0380725758477097 -3.902439024390242 5242.719768744178 8.269353202194907e-09 5252.2019104479705
Aquael PFN7500 5050.0 150.0 2.5104265053134553 6.733333333333333 33.666666666666664 400.0 200.0 0.0 5500.0 7000.0 -0.05 2.5 5080.731571084458 2.7032911020796746e-08 5074.518988797458
ATK MP 6560 4600.0 80.0 2.1102640272509707 6.133333333333334 57.5 600.0 300.0 0.0 3800.0 6500.0 -0.006111111111111111 -7.166666666666667 4606.73051711092 6.908493389801151e-06 4619.682645370925
ATK MP 6055 4050.0 75.0 1.6680623552548106 5.4 54.0 550.0 275.0 0.0 3500.0 6000.0 -0.006611570247933884 -7.272727272727272 4062.9976961380935 6.293112846833537e-06 4073.1720903407477
Red Dragon RD 6000 3950.0 75.0 1.5932031004872103 5.266666666666667 52.666666666666664 400.0 200.0 0.0 4300.0 6500.0 -0.02625 -5.75 3936.870956088437 3.161813037877437e-05 3944.766062686599
EHEIM 2x1264 3900.0 200.0 1.556412824937837 5.2 19.5 700.0 350.0 0.0 3200.0 4500.0 -0.007755102040816327 -1.0 3897.7670005574164 9.51152617290063e-06 3899.076031141056
Aqua Medic OR 6500 3750.0 115.0 1.4485994056274263 5.0 32.608695652173914 380.0 190.0 0.0 4300.0 6500.0 -0.029085872576177285 -6.052631578947368 3733.2970842720406 9.892037064673787e-05 3740.84961309142
ATK MP 6038 3600.0 75.0 1.3446220973235783 4.8 48.0 380.0 190.0 0.0 4100.0 6000.0 -0.030470914127423823 -4.210526315789473 3575.1476879960983 4.616159321813029e-05 3580.127121626673
Iwaki MD55R-5 3550.0 170.0 1.3108154636681981 4.733333333333333 20.88235294117647 820.0 410.0 0.0 2700.0 4200.0 -0.003569303985722784 -2.1951219512195124 3539.376697615646 2.910987291215861e-07 3541.75329846157
Sicce Multi 5800 3500.0 90.0 1.277435064569103 4.666666666666667 38.888888888888886 380.0 190.0 0.0 4000.0 5800.0 -0.030470914127423823 -3.6842105263157894 3492.798546836074 2.5853473061943077e-05 3496.7923341696655
Iwaki MD70R 3300.0 265.0 1.1481758137355693 4.4 12.452830188679245 670.0 335.0 0.0 2400.0 5160.0 0.0016039206950323012 -8.776119402985074 3297.6193759045273 5.105477782763046e-07 3305.752681750243
EHEIM 2x1262 3050.0 160.0 0.996192027710059 4.066666666666666 19.0625 720.0 323.84 0.0 2500.0 3400.0 -0.006172839506172839 -0.2777777777777777 3037.134904123485 3.0826794272797997e-07 3037.376932297265
Resun King 4 3050.0 90.0 0.996192027710059 4.066666666666666 33.888888888888886 450.0 225.0 0.0 3000.0 4800.0 -0.011851851851851851 -5.333333333333333 3042.5172941840824 1.295214701713121e-05 3046.80762555507
Deltec HLP 5250v3 3000.0 87.0 0.9670739741738111 4.0 34.48275862068966 520.0 260.0 0.0 2600.0 5200.0 0.0 -10.0 2990.329260258262 0.0 2998.0028127427677
Iwaki MD55R 2850.0 130.0 0.8822772209027758 3.8 21.923076923076923 560.0 280.0 0.0 2500.0 3600.0 -0.008928571428571428 -1.4285714285714288 2848.837993342534 6.619881446567888e-06 2849.8363583896075
Red dragon RD 4500 2750.0 75.0 0.8278772248368427 3.6666666666666665 36.666666666666664 400.0 200.0 0.0 3000.0 4500.0 -0.01875 -3.75 2757.552622413844 5.8674178490036866e-05 2759.9690045457055
Red Dragon Mini 5000 2750.0 60.0 0.8278772248368427 3.6666666666666665 45.833333333333336 350.0 175.0 0.0 3473.076923076923 5250.0 -0.027692307692307686 -5.30769230769231 2727.4995370784854 3.161059566991753e-06 2731.1445373424863
Resun FP-3 2650.0 90.0 0.7751821669960485 3.533333333333333 29.444444444444443 450.0 225.0 0.0 2600.0 3800.0 -0.013827160493827161 -2.2222222222222223 2635.429437305753 2.1955390820949106e-06 2636.8215448571245
ATK MP 5536 2550.0 60.0 0.7241920473803932 3.4 42.5 360.0 180.0 0.0 3200.0 5500.0 -0.013888888888888888 -10.277777777777779 2554.7906795829117 6.34729894954944e-05 2560.527925696614
EHEIM 1264.0 2550.0 100.0 0.7241920473803932 3.4 25.5 350.0 175.0 0.0 3200.0 4500.0 -0.031020408163265307 -2.0 2547.263109547021 0.0003969777385464113 2548.416774414728
Iwaki MD70RZ 2500.0 275.0 0.6993363394069927 3.3333333333333335 9.090909090909092 1430.0 715.0 0.0 2100.0 2400.0 -0.0017604772849528095 0.8391608391608392 2499.452565768529 2.2275601452292904e-07 2499.0050052551087
Resun SP9000 2450.0 130.0 0.6749068659898768 3.2666666666666666 18.846153846153847 450.0 225.0 0.0 2400.0 3500.0 -0.012839506172839505 -2.0 2433.399431933133 3.466896032477962e-07 2434.480339682971
EHEIM 2x1260 2200.0 130.0 0.5591530172485688 2.933333333333333 16.923076923076923 740.0 323.84 0.0 1800.0 2400.0 -0.004382761139517896 0.0 2186.794711557256 1.4820591331954347e-07 2186.805949667249
EHEIM 1262.0 2100.0 80.0 0.5158351196460387 2.8 26.25 360.0 161.92 0.0 2500.0 3400.0 -0.024691358024691357 -0.5555555555555554 2076.818769661557 3.456458102846227e-05 2077.1387123732334
Newjet 4500.0 1900.0 50.0 0.43431413911639527 2.533333333333333 38.0 320.0 160.0 0.0 2850.0 4500.0 -0.0234375 -6.5625 1914.5415279155804 8.996121869131457e-05 1916.5349530528556
Deltec HLP 4040v3 1800.0 60.0 0.396111056189282 2.4 30.0 350.0 175.0 0.0 2400.0 4500.0 -0.004897959183673469 -11.142857142857144 1806.2419669149904 8.240356237365631e-07 1809.3204033477514
Sicce Multi 4000 1750.0 67.0 0.37764886656015245 2.3333333333333335 26.119402985074625 310.0 155.0 0.0 2700.0 3800.0 -0.03329864724245578 -1.9354838709677402 1756.270253142254 0.00014914373491592414 1756.7552400640864
EHEIM Compact+ 5000 1700.0 86.0 0.3596129114873076 2.2666666666666666 19.767441860465116 300.0 150.0 0.0 3000.0 5000.0 -0.022222222222222223 -10.0 1717.329226385115 1.2971167961950414e-06 1719.766388184594
Aqua Medic OR 3500 1650.0 65.0 0.3420031909707475 2.2 25.384615384615383 330.0 165.0 0.0 2300.0 3500.0 -0.020202020202020204 -3.9393939393939386 1651.1658789404232 1.3887264231016161e-05 1652.0916240747977
EHEIM 2x1060 1600.0 100.0 0.32481970501047214 2.1333333333333333 16.0 620.0 310.0 0.0 1300.0 2280.0 -0.0016649323621227888 -2.6451612903225805 1616.3844603798032 -0.000310670046005157 1616.9557837309433
EHEIM 1260.0 1550.0 65.0 0.30806245360648155 2.066666666666667 23.846153846153847 370.0 161.92 0.0 1800.0 2400.0 -0.017531044558071585 0.0 1549.1194907454405 9.448172022530343e-08 1549.1217348908729
Deltec HLP 5250v2 1500.0 76.5 0.29173143675877566 2.0 19.607843137254903 440.0 220.0 0.0 1500.0 4500.0 0.015495867768595042 -17.045454545454547 1497.0177018435497 4.7746652853675187e-08 1500.2366883817922
Aquael PFN3500 1300.0 40.0 0.23066971493079946 1.7333333333333334 32.5 280.0 140.0 0.0 2500.0 3300.0 -0.04336734693877551 0.3571428571428559 1275.2703564990106 1.2539230738184415e-06 1275.3509005980563
Sicce Multi 2500 1100.0 55.0 0.17642774600337896 1.4666666666666666 20.0 310.0 155.0 0.0 1700.0 2500.0 -0.018730489073881373 -2.258064516129032 1094.817152717309 8.559308071198757e-07 1095.065461523035
EHEIM Compact+ 3000 1050.0 55.0 0.1639328401622357 1.4 19.09090909090909 300.0 150.0 0.0 1800.0 3000.0 -0.013333333333333334 -6.0 1032.7209719770603 6.66730443299457e-07 1033.3227388928642
Newjet 3000.0 1000.0 55.0 0.15186416887737714 1.3333333333333333 18.181818181818183 290.0 145.0 0.0 1900.0 3000.0 -0.019024970273483946 -4.8275862068965525 1015.1176441401287 2.564325200182793e-06 1015.5013063367074
Sicce Suprema 950.0 55.0 0.1402217321488033 1.2666666666666666 17.272727272727273 250.0 125.0 0.0 3000.0 3700.0 -0.0736 3.599999999999998 925.7224105287542 9.140122847384191e-05 925.5992447665553
EHEIM 1060.0 800.0 50.0 0.10785182930079024 1.0666666666666667 16.0 310.0 155.0 0.0 1300.0 2280.0 -0.006659729448491155 -5.290322580645161 792.9114423554781 -2.8695974094716803e-05 793.2084144664839
Tunze 1073.040 variable 800.0 42.0 0.10785182930079024 1.0666666666666667 19.047619047619047 300.0 150.0 0.0 1500.0 3000.0 0.0 -10.0 798.9214817069924 0.0 799.4674167314045
Aquabee UP 2000/1 750.0 33.0 0.09791433079735534 1.0 22.727272727272727 300.0 150.0 0.0 1250.0 2000.0 -0.011111111111111112 -3.3333333333333335 728.0837089777086 -0.0001765933910746753 728.2706962167862
RENA S60 700.0 55.0 0.0884030668502052 0.9333333333333333 12.727272727272727 300.0 150.0 0.0 1200.0 2000.0 -0.008888888888888889 -4.0 689.0783418257873 1.7420251197108882e-07 689.2575059573958
Aqua Medic OR 2500 600.0 38.0 0.07065924262475909 0.8 15.789473684210526 260.0 130.0 0.0 1600.0 2400.0 -0.023668639053254437 -3.0769230769230766 576.5614021059246 7.406306394841522e-07 576.703181026141
Sicce Extrema 550.0 35.0 0.062426682346463126 0.7333333333333333 15.714285714285714 250.0 125.0 0.0 1800.0 2500.0 -0.0352 -1.1999999999999993 531.2780863474109 3.383560397196561e-06 531.3573985270127
Aquabee UP 3000 350.0 40.0 0.033758786796126636 0.4666666666666667 8.75 240.0 120.0 0.0 1800.0 3000.0 -0.020833333333333332 -7.5 341.10399647723807 2.730346295720665e-07 341.198395242211
Resun King 3 350.0 35.0 0.033758786796126636 0.4666666666666667 10.0 240.0 120.0 0.0 1700.0 2400.0 -0.034722222222222224 -1.666666666666666 352.20571431902135 9.564269021211658e-07 352.219194699234
Newjet 2300.0 250.0 38.0 0.021982246358666788 0.3333333333333333 6.578947368421052 240.0 120.0 0.0 1300.0 2300.0 -0.010416666666666666 -7.083333333333334 237.2435354256158 -0.0004158257917197261 237.29433948356325
Deltec HLP 5250v1 200.0 45.0 0.016733327974363964 0.26666666666666666 4.444444444444445 280.0 140.0 0.0 700.0 2400.0 0.025510204081632654 -15.714285714285715 177.47589832348876 0.00014504528940051387 177.52686180447992
Aquabee UP 2000 0.0 15.0 0.0 0.0 0.0 160.0 80.0 0.0 1000.0 2000.0 0.0 -12.5 -750.0 0.0 -749.3759828387082
Tunze 4002 0.0 42.0 0.0 0.0 0.0 145.0 72.5 0.0 1850.0 3700.0 0.0 -25.517241379310345 -1913.7931034482763 0.0 -1910.5453890400304
Tunze 1073.020 variable 0.0 30.0 0.0 0.0 0.0 200.0 100.0 0.0 1200.0 2400.0 0.0 -12.0 -240.0 0.0 -239.80829554795142
Aquael PFN2500 0.0 30.0 0.0 0.0 0.0 200.0 100.0 0.0 1750.0 2500.0 -0.05 -2.5 -470.0 -7.962885320011992e-07 -469.6447956719259
EHEIM 1250.0 0.0 28.0 0.0 0.0 0.0 200.0 100.0 0.0 720.0 1200.0 -0.012 -3.6 -172.80000000000007 -2.0034095655319106e-05 -172.7111280719199
MAXI-JET 1000.0 0.0 13.0 0.0 0.0 0.0 150.0 75.0 0.0 600.0 1000.0 -0.017777777777777778 -4.0 -740.4444444444445 -2.0273603240639204e-07 -740.2235208014906
Newjet 1700.0 0.0 32.0 0.0 0.0 0.0 210.0 105.0 0.0 1100.0 1700.0 -0.022675736961451247 -3.333333333333333 -130.8390022675735 -0.000426097986064633 -130.7370776312556
Oase Aquarius 8 0.0 20.0 0.0 0.0 0.0 200.0 100.0 0.0 800.0 1200.0 -0.02 -2.0 -208.0 -0.00037174014823904145 -207.88233738301014
Oase Aquarius 9 0.0 20.0 0.0 0.0 0.0 180.0 90.0 0.0 1000.0 1500.0 -0.030864197530864196 -2.7777777777777786 -604.9382716049383 -2.421785893602646e-06 -604.6999590436885
Sicce Multi 800 0.0 13.0 0.0 0.0 0.0 130.0 65.0 0.0 700.0 750.0 -0.07692307692307693 4.230769230769231 -2042.3076923076924 -0.00026523265114519745 -2050.51388036018
Sicce Multi 1300 0.0 20.0 0.0 0.0 0.0 220.0 110.0 0.0 1000.0 1250.0 -0.030991735537190084 1.1363636363636367 0.0 4.732070783575182e-05 -4.728133584624983e-05
Sicce Idra 0.0 25.0 0.0 0.0 0.0 220.0 110.0 0.0 1100.0 1300.0 -0.0371900826446281 2.2727272727272725 0.0 4.7325718696811236e-05 -4.728133584624983e-05
Formules
Hauteur fictive h H + p
Hauteur réelle H 
Hauteur à débit nul H0 
Débit à hauteur 0 Q0 
Débit à hauteur H0/2 QH/2 
Débit à hauteur h Qh Q0 + a h + b h²
 a - Q0 / H0 - b H0
 b 2 (Q0 - 2 QH/2) / H0²
Perte de charge p v Qh² + w Qh
 v (3 10-8 e(-0 1162*d)) (L + 3 24 d C)
 w (0 0019 e(-0 2041*d)) (L + 3 24 d C)
Diamètre tube d 
Longueur tube L 
Nombre de coudes C 
 Qh Q0 + a h + b h²
 h H + v Qh² + w Qh
 h² H² + H v Qh² + H w Qh + H v Qh² + v² Qh4 + w v Qh3 + H w Qh + v w Qh³ + w² Qh2
  v² Qh4 + 2 w v Qh3 + (2 H v + w²) Qh² + 2 H w Qh + H²
 Qh Q0 + a H + a v Qh² + a w Qh + b v² Qh4 + 2 b w v Qh3 + b (2 H v + w²) Qh² + 2 b H w Qh + b H²
 0.0 b v² Qh4 + 2 b w v Qh3 + b (2 H v + w² + a v) Qh² + (a w + 2 b H w - 1) Qh + Q0 + a H + b H²
Iwaki  http://www.iwaki.fr/PDFs/MD.pdf
Feuil2
 Abaque    Log  P =  10 exp (a log D + b)  Calcul 
Diamètre Débit l/s Perte de charge mm/m Débit l/h Perte de charge cm/cm Débit l/h Perte de charge cm/cm a  b Vérif Débit l/h Perte de charge cm/cm
32.0 0.1 4.0 360.0 0.004 2.5563025007672873 -2.3979400086720375 1.7686217868402407 0.003999999999999998 100.0 0.00041404042438144385
 2.0 800.0 7200.0 0.8 3.8573324964312685 -0.09691001300805639 -6.919072305283253 0.8000000000000003 10000.0 1.4228456661481184
25.0 0.05 4.0 180.0 0.004 2.255272505103306 -2.3979400086720375 1.7686217868402407 0.004000000000000002 100.0 0.0014107529070902362
 1.0 800.0 3600.0 0.8 3.5563025007672873 -0.09691001300805639 -6.386664096459512 0.8000000000000003 10000.0 4.848037876634837
20.0 0.1 40.0 360.0 0.04 2.5563025007672873 -1.3979400086720375 1.7783853970487746 0.04000000000000001 100.0 0.003909165019115599
 0.5 700.0 1800.0 0.7 3.255272505103306 -0.1549019599857432 -5.944031046475845 0.7000000000000001 10000.0 13.43380544065478
16.0 0.05 32.0 180.0 0.032 2.255272505103306 -1.494850021680094 1.760469168939073 0.03199999999999998 100.0 0.011774089042287099
 0.3 750.0 1080.0 0.75 3.03342375548695 -0.12493873660829995 -5.465187734470453 0.75 10000.0 40.46153607268656
12.0 0.05 78.0 180.0 0.078 2.255272505103306 -1.1079053973095196 1.7641894861773944 0.07799999999999999 100.0 0.028150208187229252
 0.2 900.0 720.0 0.9 2.8573324964312685 -0.045757490560675115 -5.086633439277726 0.9000000000000007 10000.0 96.73790132981395
Longueur équivalente d'un coude [cm]   3 24 d d = diamètre [mm]   1.7680575251691448 = a
53273731 (XLS) - Fichier XLS

53273731 (XLS)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent
