Overview

DADOS Plan2 Hf LINHAS


Sheet 1: DADOS

Dt(s) Minicial(±0,05) Mfinal(±0,05) ∆M Q Vgarganta Vinterno
(kg) (kg)
Q1 98 32.6 174 141.4 1.45E-03 4.9306212456 1.3249427143
Q2 112 31.2 175.7 144.5 1.29E-03 4.4088785272 1.1847414741
Q3 123 30.7 170.4 139.7 1.14E-03 3.881232002 1.0429537795
Q4 159 35.6 164.4 128.8 8.12E-04 2.7681973442 0.7438622275
Q5 196 34.4 135.7 101.3 5.18E-04 1.7661666626 0.4745993528
Hinicial Hfinal ∆H T 20 d123 0.04036
(cm) (cm) (cm) g 9.79 d456 0.028
Q1 52.1 41.5 10.6 rH2O=998,2 998.2
Q2 51.1 42.8 8.3 mH20=0,001 0.001
Q3 50.3 43.7 6.6 pi 3.1415926536
Q4 48.9 45.6 3.3 rHg 13550
Q5 48.2 46.7 1.5 rQue 809
rAl 789
h(m) Q
Dgarganta 19.32 C Re_garganta Re_interno 0.106 1.45E-03
Dinterno 37.27 1246.531793345 95088.135180606 49291.7298548245 0.083 1.29E-003
Sgarganta 0.0002931596 1259.6321506016 85026.2099851335 44075.8351734043 0.066 1.14E-003
Sinterno 0.0010909596 1243.5185999512 74850.4285543867 38800.9197657835 0.033 8.12E-004
1254.2806647153 53385.3058589167 27673.8424790521 0.015 5.18E-004
beta 0.5183793936 1186.9726255542 34060.9197093189 17656.4789048576
Cd^2 Cd (Coeficiente de descarga) Re_garganta2 Re_interno2 hquerosene
0.8005955845 0.8947600709 95088.135180606 49291.7298548245 0.0925948076
0.8175116395 0.9041635026 85026.2099851335 44075.8351734043 0.0725034815
0.7967297646 0.8925972018 74850.4285543867 38800.9197657835 0.0576533708
0.8105800782 0.900322208 53385.3058589167 27673.8424790521 0.0288266854
0.7259185212 0.8520085218 34060.9197093189 17656.4789048576 0.0131030388

Sheet 2: Plan2

A1(maior) 0.0012793583 alfa 1
A2(menor) 0.0006157522
Pi Pf Dp Q V1 V2 alfa*V1^2/(2g) alfa*V2^2/(2g)
1 32.6 174 141.4 0.001445459 1.1298312215 2.347468775 0.065195025 0.281440738
2 31.2 175.7 144.5 0.0012925051 1.0102760613 2.0990670668 0.0521275649 0.2250297523
3 30.7 170.4 139.7 0.0011378204 0.8893680685 1.8478545561 0.0403971175 0.174390524
4 35.6 164.4 128.8 0.0008115236 0.6343208352 1.3179387556 0.0205496896 0.0887110604
5 34.4 135.7 101.3 0.0005177687 0.4047096985 0.8408719481 0.0083651655 0.0361116258
Q1 Distancia H Energia Q2 Distancia H Energia Q3 Distancia H Energia
H1 0.5 141.4 141.465195025 H1 0.5 144.5 144.5521275649 H1 0.5 139.7 139.7403971175
H2 1 1.45E-003 0.0666404839 H2 1 1.29E-003 0.0534200699 H2 1 1.14E-003 0.041534938
H3 1.5 4.9306212456 4.9958162706 H3 1.5 4.4088785272 4.461006092 H3 1.5 3.881232002 3.9216291195
H4 1.81 1.3249427143 1.6063834523 H4 1.81 1.1847414741 1.4097712264 H4 1.81 1.0429537795 1.2173443036
H5 2.31 0 0.281440738 H5 2.31 0 0.2250297523 H5 2.31 0 0.174390524
H6 2.81 0 0.281440738 H6 2.81 0 0.2250297523 H6 2.81 0 0.174390524
Q4 Distancia H Energia Q5 Distancia H Energia
H1 0.5 128.8 128.8205496896 H1 0.5 101.3 101.3083651655
H2 1 8.12E-004 0.0213612132 H2 1 5.18E-004 0.0088829342
H3 1.5 2.7681973442 2.7887470338 H3 1.5 1.7661666626 1.7745318281
H4 1.81 0.7438622275 0.832573288 H4 1.81 0.4745993528 0.5107109785
H5 2.31 0 0.0887110604 H5 2.31 0 0.0361116258
H6 2.81 0 0.0887110604 H6 2.81 0 0.0361116258

Sheet 3: Hf

Q Hf1= H1-H3 Hf2= H4-H6
1 0.001445459 136.4693787544 1.3249427143
2 0.0012925051 140.0911214728 1.1847414741
3 0.0011378204 135.818767998 1.0429537795
4 0.0008115236 126.0318026558 0.7438622275
5 0.0005177687 99.5338333374 0.4745993528
Hs
Q1 0.0145
Q2 0.005
Q3 0.00885
Q4 0.00275
Q5 0.0028
Reynolds Ks
123 456 123 456
Q1 45517.9081191603 65610.8132746182 Q1 0.2224096088 0.0515206153
Q2 40701.3472971452 58668.0848897421 Q2 0.0959185416 0.0222192841
Q3 35830.2844318818 51646.7957025268 Q3 0.2190750366 0.0507481702
Q4 25555.1067689364 36835.8610426525 Q4 0.1338219728 0.0309995167
Q5 16304.6820808732 23502.03459943 Q5 0.334721412 0.0775373564
f
123 456
Q1 #DIV/0! #DIV/0!
Q2 #DIV/0! #DIV/0!
Q3 #DIV/0! #DIV/0!
Q4 #DIV/0! #DIV/0!
Q5 #DIV/0! #DIV/0!
log f
123 456
Q1 #DIV/0! #DIV/0!
Q2 #DIV/0! #DIV/0!
Q3 #DIV/0! #DIV/0!
Q4 #DIV/0! #DIV/0!
Q5 #DIV/0! #DIV/0!
log Re
123 456
Q1 4.6581822948 4.8169754211
Q2 4.6096087855 4.7684019117
Q3 4.5542502557 4.713043382
Q4 4.4074776998 4.566270826
Q5 4.2123123351 4.3711054613

Sheet 4: LINHAS

Q1 MANUAL!!!!!
D H X Y
0.5 141.4
1 1.45E-003
1.5 4.9306212456
1.81 1.3249427143
2.31 0
2.81 0
0.5 141.465195025 1.64 0.7371
1 0.0666404839
1.5 4.9958162706
1.81 1.6063834523 1.69 0.7226
2.31 0.281440738
2.81 0.281440738
Hs 0.0145
Q2
D H X Y
0.5 144.5
1 1.29E-003
1.5 4.4088785272
1.81 1.1847414741
2.31 0
2.81 0
0.5 144.5521275649 1.64 0.684
1 0.0534200699
1.5 4.461006092
1.81 1.4097712264 1.69 0.679
2.31 0.2250297523
2.81 0.2250297523
Hs 0.005
Q3
d h X Y
0.5 139.7
1 1.14E-003
1.5 3.881232002
1.81 1.0429537795
2.31 0
2.81 0
0.5 139.7403971175 1.64 0.6865
1 0.041534938
1.5 3.9216291195
1.81 1.2173443036 1.69 0.67765
2.31 0.174390524
2.81 0.174390524
Hs 0.00885
Q4
D H X Y
0.5 128.8
1 8.12E-004
1.5 2.7681973442
1.81 0.7438622275
2.31 0
2.81 0
0.5 128.8205496896 1.64 0.6187
1 0.0213612132
1.5 2.7887470338
1.81 0.832573288 1.69 0.61595
2.31 0.0887110604
2.81 0.0887110604
Hs 0.00275
Q5
D H X Y
0.5 101.3
1 5.18E-004
1.5 1.7661666626
1.81 0.4745993528
2.31 0
2.81 0
0.5 101.3083651655 1.64 0.617
1 0.0088829342
1.5 1.7745318281
1.81 0.5107109785 1.69 0.6142
2.31 0.0361116258
2.81 0.0361116258
Hs 0.0028

Comentários