escrito macro
Post on 23-Feb-2018
229 Views
Preview:
TRANSCRIPT
-
7/24/2019 Escrito Macro
1/35
UNIVERSIDAD CENTRAL DEL ECUADOR
FACULTAD DE INGENIERIA EN GEOLOGIA, MINAS, PETRLEOS Y AMBIENTAL
CARRERA DE INGENIERIA EN PETRLEOS
COMPUTACIN APLICADA A LA INGENIERA
NOMBRE: JOEL OLEAS PROFESOR: Ing. NSTORVALDOSPINOS Ms Sc.
CURSO: SEXTO FECHA: 02/07/2015
PRUEBA PARCIAL :2DOHEMISEMESTRE
NOTA:
TEMA:
Macro !sarro""ao !n VIS#AL $ASI% &ara !'!r()nar !" *ac'or ! *r)cc)+n
OBEJETIVO GENERAL
D!sarro""ar &rogra(a ,-! !sarro""! a"or !" *ac'or ! *r)cc)+n con a'os
&r!)a(!n'! !s&!c)*)caos.
OBJETIVOS ESPECFICOS
%r!ar -n (acro !n )s-a" $ASI% Es&!c)*)car "as ar)a"!s a -')")ar. Escr))r !" "-gar on! s! !!n )(&r)()r "os r!s-"'aos "os ')'-"os Progra(ar &aso a &aso &ara ,-! !" &rogra(a nos &)a a"or!s ! ca-a"
)3(!'roAPI '!(&!ra'-ra. A!(3s ! !scog!r !" (a'!r)a" ! "a '-!r4a. D!sarro""ar !" &rogra(a &ara ,-! nos !n os )*!r!n'!s -n)a!s a"g-nos
ar)a"!s ! )n),-! !" a"or ! "os ()s(os !n !n'anas !(!rg!n'!s %onca'!nar "a )n*or(ac)+n &ara ,-! nos ! !" a"or !" *ac'or ! *r)cc)+n
con "os a'os o'!n)os. %orr!r !" &rogra(a con %TRL O.
INTRODUCCIN
-
7/24/2019 Escrito Macro
2/35
#na (acro son -n con6-n'o ! )ns'r-cc)on!s ,-! s)r!n &ara a-'o(a')ar
&roc!sos. R!*)r)nonos a !8c!" s-&onga(os ,-! r!a")a(os *r!c-!n'!(!n'! "a
acc)+n ! s!"!cc)onar -n rango &ara a&")car"! n!gr)'a ca()o ! *-!n'!
c!n'rao. En "-gar ! 9ac!r !s'as acc)on!s (an-a"(!n'! s! &-!! !"aorar -na
(acro ! )nocar"a &ara ,-! !6!c-'! "os 'r!s &roc!sos a-'o(3')ca(!n'!.
Es !c)r -n (acro !s -n s-&!rco(ano.-n co(ano ,-! !n -n :n)co &aso
r!a")a ;"o ,-! nor(a"(!n'! r!,-!r)r4a ! (-c9as o&!rac)on!s.&!r()'! ag)")ar
a-'o(a')ar a-n (as !" 'raa6o con E8c!".
MARCO TEORICO
Visua Basi!
Es -n a()!n'! gr3*)co ! !sarro""o ! a&")cac)on!s &ara !" s)s'!(a o&!ra')oM)croso*'
-
7/24/2019 Escrito Macro
3/35
V)s-a">$as)c !s -na 9!rra()!n'a ! )s!?o ! a&")cac)on!s &ara a "a ,-! "!)r!(os a?a)!no "os con'ro"!s n!c!sar)os.
D!*)n)c)+n ! "as &ro&)!a!s ! "os con'ro"!s > O6!'os > ,-! 9aa(osco"ocao !n !s! *or(-"ar)o. Es'as &ro&)!a!s !'!r()nar3n "a *or(a!s'3')ca ! "os con'ro"!s !s !c)r co(o son "os con'ro"!s &ara ,- s)r!n.
B!n!rac)+n !" c+)go asoc)ao a "os !!n'os ,-! oc-rran a !s'os o6!'os.A "a r!s&-!s'a a !s'os !!n'os c")c o"! c")c -na '!c"a &-"saa !'c.F "!""a(a(os Proc!)()!n'o !!r3 g!n!rars! ! ac-!ro a "as n!c!s)a!s!" &rogra(a.
B!n!rac)+n !" c+)go !" &rogra(a. #n &rogra(a &-!! 9ac!rs!so"a(!n'! con "a &rogra(ac)+n ! "os )s')n'os &roc!)()!n'os ,-!aco(&a?an a caa o6!'o. S)n !(argo V$ o*r!c! "a &os))")a !
!s'a"!c!r -n c+)go ! &rogra(a s!&arao ! !s'os !!n'os. Es'! c+)go&-!! )n'ro-c)rs! !n -nos "o,-!s ""a(aos M+-"os !n o'ros "o,-!s""a(aos C-nc)on!s o'ros ""a(aos Proc!)()!n'os. Es'osProc!)()!n'os no r!s&on!n a -n !!n'o aca!c)o a -n o6!'o s)no ,-!r!s&on!n a -n !!n'o &ro-c)o -ran'! "a !6!c-c)+n !" &rogra(a.
Fluido:"os *"-)os son s-s'anc)as ca&ac!s ! G*"-)rG ,-! s! aa&'an a "a *or(a! "os r!c)&)!n'!s ,-! "os con')!n!n.
Presin de un fluido:"a &r!s)+n ! -n *"-)o s! 'rans()'! con )g-a" )n'!ns)a!n 'oas )r!cc)on!s ac':a nor(a"(!n'! a c-a",-)!r s-&!r*)c)! &"ana. En !"()s(o &"ano 9or)on'a" !" a"or ! "a &r!s)+n ! -n "4,-)o !s )g-a" !n
c-a",-)!r &-n'o.Viscosidad:"a )scos)a ! -n *"-)o !s a,-!""a &ro&)!a ,-! !'!r()na "acan')a ! r!s)s'!nc)a o&-!s'a a "as *-!ras cor'an'!s. La )scos)a s! !!&r)(or)a"(!n'! a "as )n'!racc)on!s !n'r! "as (o"c-"as !" *"-)o.
En -n *"-)o n!='on)ano !" gra)!n'! ! !"oc)a !s o)a(!n'! &ro&orc)ona"a" !s*-!ro cons'an'!. Es'a cons'an'! ! &ro&orc)ona")a !s "a )scos)a s! !*)n! (!)an'! "a !c-ac)+n
-
7/24/2019 Escrito Macro
4/35
Efecto de la Rugosidad: s! sa! !s! 9ac! (-c9o ')!(&o ,-! &ara !" *"-6o'-r-"!n'o &ara -n !'!r()nao n:(!ro ! R!no"s -na '-!r4a r-gosa a -n*ac'or ! *r)cc)+n (aor ,-! !n -na '-!r4a ")sa. Por cons)g-)!n'! s) s! &-")(!n'a-na '-!r4a r-gosa !" *ac'or ! *r)cc)+n )s()n-! ""!ga -n (o(!n'o !n ,-! s) s!s)g-! &-")(!n'3no"a no s! r!-c! (3s !" *ac'or ! *r)cc)+n &ara -n !'!r()naon:(!ro ! R!no"s.
Flujo Laminar y Turbulento:a !"oc)a!s a6as "os *"-)os ')!n!n a (o!rs! s)n(!c"a "a'!ra" "as ca&as con')g-as s! !s")an (as sor! o'ras. No !8)s'!ncorr)!n'!s 'rans!rsa"!s n) 'or!"")nos. A !s'! ')&o ! rg)(!n s! "! ""a(a *"-6oLa()nar. En !" *"-6o "a()nar "as &ar'4c-"as *"-)as s! (-!!n s!g:n 'ra!c'or)as&ara"!"as *or(ano !" con6-n'o ! !""as ca&as o "3()nas. Los (+-"os ! "as
!"oc)a!s ! ca&as aac!n'!s no ')!n!n !" ()s(o a"or.A !"oc)a!s s-&!r)or!s a&ar!c! "a '-r-"!nc)a *or(3nos! 'or!"")nos. En !"*"-6o '-r-"!n'o "as &ar'4c-"as *"-)as s! (-!!n !n *or(a !sor!naa !n 'oas"as )r!cc)on!s.
Ecuacin General Del Flujo de Fluidos: !" *"-6o ! *"-)o !n '-!r4as s)!(&r! !s'3aco(&a?ao !" roa()!n'o ! "as &ar'4c-"as !" *"-)o !n'r! s) cons!c-!n'!(!n'! &or "a &r)a ! !n!rg4a )s&on)"! !s !c)r ')!n! ,-! !8)s')r-na &r)a ! &r!s)+n !n !" s!n')o !" *"-6o
C+r(-"a ! Darc>
-
7/24/2019 Escrito Macro
5/35
Factor de friccin: "a *+r(-"a ! Darc &-!! s!r !-c)a &or !" an3")s)s)(!ns)ona" con "a !8c!&c)+n !" *ac'or ! *r)cc)+n * ,-! !! s!r !'!r()nao!8&!r)(!n'a"(!n'!. E" *ac'or ! *r)cc)+n &ara con)c)on!s ! *"-6o "a()nar !s !R! H 2000F !s *-nc)+n so"a !" n-(!ro ! R!no"s ()!n'ras ,-! &ara *"-6o'-r-"!n'o R! 000F !s 'a()n *-nc)+n !" ')&o ! &ar! ! '-!r4a.
Zona r!tica:"a r!g)+n ,-! s! conoc! co(o "a ona cr)')ca !s "a ,-! a&ar!c! !n'r!"os n:(!ros ! R!no"s ! 200 a 000. En !s'a r!g)+n !" *"-6o &-!! s!r 'an'o"a()nar co(o '-r-"!n'o !&!n)!no ! ar)os *ac'or!s !s'os )nc"-!n ca()os! "a s!cc)+n ! )r!cc)+n !" *"-6o os'r-cc)on!s 'a"!s co(o 3"-"as corr)!n'!arr)a ! "a ona cons)!raa. E" *ac'or ! Cr)cc)+n !n !s'a r!g)+n !s)n!'!r()nao ')!n! "4()'!s (3s a6os s) !" *"-6o !s "a()nar (3s a"'os s) !" *"-6o!s '-r-"!n'o.
Para "os n:(!ros ! R!no"s s-&!r)or!s a 000 "as con)c)on!s ! *"-6o -!"!na s!r (3s !s'a"!s &-!!n !s'a"!c!rs! *ac'or!s ! roa()!n'o !*)n)')os. Es'o!s )(&or'an'! a ,-! &!r()'! a" )ng!n)!ro !'!r()nar "as carac'!r4s')cas !" *"-6o
! c-a",-)!r *"-)o ,-! s! (-!a &or -na '-!r4a s-&on)!no conoc)as "a)scos)a "a !ns)a !n "as con)c)on!s ! *"-6o.
Cac'or D! Cr)cc)+n C"-6o La()nar R! H 2000F
Cac'or D! Cr)cc)+n Para C"-6o T-r-"!n'o R! 000F
%-ano !" *"-6o !s '-r-"!n'o !" *ac'or ! *r)cc)+n no so"o !&!n! !" n:(!ro !R!no"s s)no 'a()n ! R-gos)a r!"a')as ! "as &ar!!s ! "a '-!r4a !/D!s !c)r "a r-gos)a ! "as &ar!!s ! "a '-!r4a !F co(&araas con !" )3(!'ro! "a '-!r4a DF. Para '-!r4as (- ")sas co(o "as ! "a'+n !8'r-)o o !" )r)o !"*ac'or ! *r)cc)+n )s()n-! (3s r3&)a(!n'! con !" a-(!n'o !" n:(!ro !R!no"s ,-! &ara '-!r4a con &ar!!s (3s r-gosas.
%o(o !" ')&o ! "a s-&!r*)c)! )n'!rna ! "a '-!r4a co(!rc)a" !s &r3c')ca(!n'!)n!&!n)!n'! !" )3(!'ro "a r-gos)a ! "as &ar!!s ')!n! (aor !*!c'o !n !"*ac'or ! *r)cc)+n &ara )3(!'ros &!,-!?os. En cons!c-!nc)a "as '-!r4as !&!,-!?o )3(!'ro s! ac!rcan a "a con)c)+n ! gran r-gos)a !n g!n!ra" ')!n!n(aor!s *ac'or!s ! *r)cc)+n ,-! "as '-!r4as !" ()s(o (a'!r)a" &!ro ! (aor!s)3(!'ros.
Para *"-6o La()nar "a !c-ac)+n ! *r)cc)+n &-!! or!nars! co(o s)g-!.
.> Para *"-6o T-r-"!n'o 9a )*!r!n'!s !c-ac)on!s &ara caa caso
1.> Para *"-6o '-r-"!n'o !n '-!r4as r-gosas o ")sas "as "!!s ! r!s)s'!nc)a-n)!rsa"!s &-!!n !-c)rs! a &ar')r !
-
7/24/2019 Escrito Macro
6/35
DESARROLLO
Cells.Font.Name = "ARIAL"
'escribir una variable "DIM"
Dim CAUDAL As Single
Dim CAUDALMC As Single
Dim DIAM!R!U#RIA As Single
Dim DIAM!R!U#RIAM As Single
Dim ARA As Single
Dim uni$a$esC As Single
Dim #ARRILS%RDIA As Single
Dim MA!RIAL As Single
Dim &LCIDAD As Single
Dim CAUDAL& As Single
Dim A%I As Single
Dim %SS As Single
Dim UNIDADS! As Single
Dim !M%RA!URA As Single
Dim ! As Single
Dim !F As Single
Dim UC As Single
Range"a(").&alue = "&ARIA#L"
Range"b(").&alue = "MA*NI!UD"
Range"c(").&alue = "UNIDADS"
Range"a(").Font.Color = R*#+,,- - )
Range"b(").Font.Color = R*#+,,- - )
-
7/24/2019 Escrito Macro
7/35
Range"c(").Font.Color = R*#+,,- - )
Range"a+").&alue = "CAUDAL MC"
Range"a/").&alue = "CAUDAL #%D"
Range"A0").&alue = "DIAM!R D LA !U#RIA %L*"
Range"A,").&alue = "DIAM!R D LA !U#RIA M"
Range"C,").&alue = "M!RS"
Range"A1") = "ARA"
Range"C1").&alue = "M!RS2+"
Range"A3").&alue = "MA!RIAL"
Range"A4").&alue = "RU*SIDAD A#SLU!A"
Range"C4").&alue = "M!RS"
Range"A5").&alue = "&LCIDAD"Range"C5").&alue = "M!RS6S*UNDS"
Range"A("- 7"A(4"8).9ori:ontalAlignment = ;lCenter
Range"#("- 7"#(4"8).9ori:ontalAlignment = ;lCenter
Range"C("- 7"C(4"8).9ori:ontalAlignment = ;lCenter
Range"A(").&alue = "%!RL"
Range"C(").&alue = "*RADS A%I"
Range"A((").&alue = "%S S%CIFIC"
Range"A(+").&alue = "!M%RA!URA C"
Range"A(/").&alue = "!M%RA!URA F"
Range"a(0").&alue = "&ISCSIDAD DINAMICA"
Range"c(0").&alue = "cst
-
7/24/2019 Escrito Macro
8/35
IB uni$a$esC = "(" !en
CAUDAL = In?ut#o;"IN*RSAR L CAUDAL" @ Cr(/) @ "N #ARRILS%R DIA"- "IN*RS D DA!S")
Range"#+").&alue = CAUDAL
Range"C+").&alue = "#ARRILS6DIA"
Msg#o; "L CAUDAL S =" @ Roun$CAUDAL 0+ /.34, 6 ( 410)- 0) @ "m/6s")
CAUDALMC = CAUDAL 0+ /.34, 6 ( 410)
Range"#/").&alue = CAUDALMC
Range"C/").&alue = "M 2 / 6 S"
lse uni$a$esC = "+"
CAUDAL = In?ut#o;"IN*RS L CAUDAL" @ Cr(/) @ "N M!RSCU#ICS %R S*UND"- "IN*RS D DA!S")
Range"#+").&alue = CAUDAL
Range"C+").&alue = "M!RS2/6S"
Msg#o; "L CAUDAL S =" @ Roun$CAUDAL ( 410 6 0+ /.34,)- 0) @ "#ARRILS%RDIA")
CAUDALMC = CAUDAL
#ARRILS%RDIA = CAUDAL ( 410 6 0+ /.34,)Range"#/").&alue = #ARRILS%RDIA
Range"C/").&alue = "#ARRILS6DIA"
n$ IB
UNIDADSD = In?ut#o;"IN*RS ( %ARA DIAM!R N %*" @ Cr(/) @"IN*RS + %ARA DIAM!R N M"- "IN*RS D DA!S")
IB UNIDADSD = "(" !en
DIAM!R!U#RIA = In?ut#o;"IN*RSAR L &ALR DL" @ Cr(/) @"DIAM!R D LA !U#RIA N %*"- "IN*RS D DA!S")
Range"C0").&alue = "%UL*ADAS"
Range"#0").&alue = DIAM!R!U#RIA
-
7/24/2019 Escrito Macro
9/35
DIAM!R!U#RIAM = DIAM!R!U#RIA .+,0
Range"#,") = DIAM!R!U#RIAM
Msg#o; "L ARA D LA !U#RIA S =" @Roun$Eor
-
7/24/2019 Escrito Macro
10/35
Range"#3").&alue = "AS#S! CMN!"
Range"#4").&alue = .+,
Msg#o; "LA RU*SIDAD S " @ "-+,")
lseIB MA!RIAL = "/" !en
Range"#3").&alue = "%LAS!IC"
Range"#4").&alue = .(,
Msg#o; "LA RU*SIDAD S " @ "-(,")
lseIB MA!RIAL = "0" !en
Range"#3").&alue = "C#R"
Range"#4").&alue = .(,Msg#o; "LA RU*SIDAD S " @ "-(,")
lseIB MA!RIAL = "," !en
Range"#3").&alue = "&IDRI"
Range"#4").&alue = .(,
Msg#o; "LA RU*SIDAD S " @ "-(,")
lseIB MA!RIAL = "1" !en
Range"#3").&alue = "CUR"
Range"#4").&alue = .(,
Msg#o; "LA RU*SIDAD S " @ "-(,")
lseIB MA!RIAL = "3" !en
Range"#3").&alue = "9IRR FUNDID NU&"
Range"#4").&alue = .4
Msg#o; "LA RU*SIDAD S " @ "-4")
lseIB MA!RIAL = "4" !en
Range"#3").&alue = "9IRR FUNDID SMIGIDAD"
Range"#4").&alue = .(+,
-
7/24/2019 Escrito Macro
11/35
Msg#o; "LA RU*SIDAD S " @ "-(+,")
lseIB MA!RIAL = "5" !en
Range"#3").&alue = "9RMI*N"
Range"#4").&alue = .1
Msg#o; "LA RU*SIDAD S " @ "-1")
n$ IB
'&LCIDAD
&LCIDAD = CAUDALMC 6 ARA
Range"#5").&alue = &LCIDAD
Msg#o; "LA &LCIDAD S = " @ Roun$&LCIDAD- 5) @ "m6s")
'A%I DL %!RL
A%I = In?ut#o;"IN*RSAR L *RAD A%I" @ Cr(/) @ "DL %!RL"-"IN*RS D DA!S")
Range"#(").&alue = A%I
'%S S%CIFIC DL %!RL
%SS = (0(., 6 (/(., H A%I) (
Range"#((").&alue = %SS
Range"c((").&alue = "IL*RAMS6M!RSCU#ICS")
'!M%RA!URA
UNIDADS! = In?ut#o;"IN*RS ( %ARA !M%RA!URA N CN!I*RADS" @Cr(/) @ "IN*RS + !M%RA!URA N FARN9I!"- "IN*RS DDA!S")
IB UNIDADS! = "(" !en
!M%RA!URA = In?ut#o;"IN*RSAR LA !M%RA!URA" @ Cr(/) @ "NCN!I*RADS"- "IN*RS D DA!S")
-
7/24/2019 Escrito Macro
12/35
Range"C(+").&alue = "JCN!I*RADS"
Range"#(+").&alue = !M%RA!URA
!F = !M%RA!URA H /+) 5 6 ,
Range"#(/").&alue = !M%RA!URA
Range"C(/").&alue = "JFARN9I!"
lse UNIDADS! = "+"
!M%RA!URA = In?ut#o;"IN*RSAR LA !M%RA!URA" @ Cr(/) @ "NFARN9I!"- "IN*RS D DA!S")
Range"C(/").&alue = "JFARN9I!"
Range"#(/").&alue = !M%RA!URA
! = !M%RA!URA K /+) , 6 5)
Range"#(+").&alue = !
Range"C(+").&alue = "JCN!I*RADS"
n$ IB
'&ISCSIDAD
IB A%I = (+ An$ A%I = (/.55 !en
IB ! = 0 An$ ! = 15.55 !en
UC = , ! !) K 1+ !) H (54
Range"#(0").&alue = UC
lseIB ! = 3 An$ ! = 55.55 !en
UC = ./ ! 2 + K 1 ! H /4)
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = (+5.55 !en
UC = .0, ! 2 + K ((.5, ! H 4+)
-
7/24/2019 Escrito Macro
13/35
Range"#(0").&alue = UC
lseIB ! = (/ An$ ! = (,5.55 !en
UC = .(, !) 2 + K .1, ! H /3,)
Range"#(0").&alue = UC
lseIB ! 0 An$ ! (1 !en
Msg#o; "IN*RS UN &ALR ACRD D !M%R!URA")
n$ IB
lseIB A%I = (0 An$ A%I = (,.55 !en
IB ! = / An$ ! = ,5.55 !en
UC = , !) 2 + K , ! H (/
Range"#(0").&alue = UC
lseIB ! = 1 An$ ! = 45.55 !en
UC = ./ ! 2 + K , ! H +(3
Range"#(0").&alue = UC
lseIB ! = 5 An$ ! = ((5.55 !en
UC = ., ! 2 + K ((.1 ! H 155
Range"#(0").&alue = UC
lseIB ! = (+ An$ ! = (/5.55 !en
UC = K., !) H 4
Range"#(0").&alue = UC
lseIB ! = (0 An$ ! = (,5.55 !en
UC = K./ ! H ,0
Range"#(0").&alue = UC
-
7/24/2019 Escrito Macro
14/35
lseIB ! 1 An$ ! (1 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = (1 An$ A%I = (3.55 !en
IB ! = + An$ ! = /5.55 !en
UC = K((, !) H 0/
Range"#(0").&alue = UC
lseIB ! = 0 An$ ! = 15.55 !en
UC = .,3, ! 2 + K 3(.+, ! H +//
Range"#(0").&alue = UC
lseIB ! = 3 An$ ! = 55.55 !en
UC = .1 !) 2 + K ((.3 ! H 1
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = (+5.55 !en
UC = .(+, !) 2 + K /.+3, ! H ++1.,
Range"#(0").&alue = UC
lseIB ! = (/ An$ ! = (,5.55 !en
UC = .(, ! 2 + K .,5, ! H 1+.0
Range"#(0").&alue = UC
lseIB ! + An$ ! (1 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
-
7/24/2019 Escrito Macro
15/35
n$ IB
lseIB A%I = (4 An$ A%I = (5.55 !en
IB ! = An$ ! = +5.55 !en
UC = ,.,3 ! 2 + K +33., ! H 0
Range"#(0").&alue = UC
lseIB ! = / An$ ! = ,5.55 !en
UC = ., ! 2 + K ,+., ! H (03,
Range"#(0").&alue = UC
lseIB ! = 1 An$ ! = 45.55 !en
UC = .1, ! 2 + K (.5, ! H 044
Range"#(0").&alue = UC
lseIB ! = 5 An$ ! = ((5.55 !en
UC = .( ! 2 + K +.0 ! H (,,
Range"#(0").&alue = UC
lseIB ! = (+ An$ ! = (05.55 !en
UC = K.(, ! H +3
Range"#(0").&alue = UC
lseIB ! An$ ! (, !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = + An$ A%I = +(.55 !en
-
7/24/2019 Escrito Macro
16/35
IB ! = K( An$ ! = !en
UC = K+4, ! H ((,
Range"#(0").&alue = UC
lseIB ! = .( An$ ! = /5.55 !en
UC = .3, ! 2 + K ,+., ! H (,
Range"#(0").&alue = UC
lseIB ! = 0 An$ ! = 15.55 !en
UC = .(3, ! 2 + K +(.+, ! H 14
Range"#(0").&alue = UC
lseIB ! = 3 An$ ! = (5.55 !en
UC = .( ! 2 + K +.+ ! H (/
Range"#(0").&alue = UC
lseIB ! = (( An$ ! = (/5.55 !en
UC = .+ ! 2 + K .1( ! H ,.5
Range"#(0").&alue = UC
lseIB ! = (0 An$ ! = (,5.55 !en
UC = K.1 ! H (+.4
Range"#(0").&alue = UC
lseIB ! K( An$ ! (1 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = ++ An$ A%I = +/.55 !en
-
7/24/2019 Escrito Macro
17/35
IB ! = K+ An$ ! = (5.55 !en
UC = K.(3, !) 2 / H /.+, ! 2 + K 0 ! H ,
Range"#(0").&alue = UC
lseIB ! = + An$ ! = 05.55 !en
UC = .(/ ! 2 + K (+ ! H /(4
Range"#(0").&alue = UC
lseIB ! = , An$ ! = 35.55 !en
UC = .+, ! 2 + K /.3, ! H (,,
Range"#(0").&alue = UC
lseIB ! = 4 An$ ! = (5.55 !en
UC = .+, !) 2 + K .13, ! H 05.,
Range"#(0").&alue = UC
lseIB ! = (( An$ ! = (+5.55 !en
UC = K.5, ! H (1.+
Range"#(0").&alue = UC
lseIB ! = (/ An$ ! = (,5.55 !en
UC = K.1 ! H ((.4
Range"#(0").&alue = UC
lseIB ! K+ An$ ! (1 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = +0 An$ A%I = +,.55 !en
IB ! = K+ An$ ! = 5.55 !en
-
7/24/2019 Escrito Macro
18/35
UC = K+.(, !) 2 + K ,., ! H +/
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = /5.55 !en
UC = .+ ! 2 + K (+ ! H ++
Range"#(0").&alue = UC
lseIB ! = 0 An$ ! = 15.55 !en
UC = .+ ! 2 + K +.3 ! H (/
Range"#(0").&alue = UC
lseIB ! = 3 An$ ! = 55.55 !enUC = .+, ! 2 + K .,3, ! H /4
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = ((5.55 !en
UC = K.5 ! H (0.+
Range"#(0").&alue = UC
lseIB ! = (+ An$ ! = (/5.55 !en
UC = K.5 ! H (/.4
Range"#(0").&alue = UC
lseIB ! K+ An$ ! (0 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = +1 An$ A%I = +3.55 !en
IB ! = K+ An$ ! = 5.55 !en
-
7/24/2019 Escrito Macro
19/35
UC = .5 !) 2 + K ! H (+
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = /5.55 !en
UC = .0 ! 2 + K /.0 ! H 5
Range"#(0").&alue = UC
lseIB ! = 0 An$ ! = 15.55 !en
UC = .( ! 2 + K (.0 ! H ,3
Range"#(0").&alue = UC
lseIB ! = 3 An$ ! = 45.55 !enUC = .4 !) 2 + H (.1 ! K +4
Range"#(0").&alue = UC
lseIB ! = 5 An$ ! = (+5.55 !en
UC = K/K(3 ! 2 + K .1 ! H 5.4
Range"#(0").&alue = UC
lseIB ! K+ An$ ! (/ !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = +4 An$ A%I = +5.55 !en
IB ! = K+ An$ ! = 5.55 !en
UC = (.//3, ! 2 + H (5.(+, ! H 13.,
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = /5.55 !en
-
7/24/2019 Escrito Macro
20/35
UC = ./, ! 2 + K +./, ! H ,,
Range"#(0").&alue = UC
lseIB ! = 0 An$ ! = 15.55 !en
UC = .+, ! 2 + K .03, ! H +1
Range"#(0").&alue = UC
lseIB ! = 3 An$ ! = 45.55 !en
UC = K.(0 ! H (,./
Range"#(0").&alue = UC
lseIB ! = 5 An$ ! = (5.55 !enUC = K.1 ! H 5
Range"#(0").&alue = UC
lseIB ! K+ An$ ! (( !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = / An$ A%I = /(.55 !en
IB ! = K( An$ ! = +5.55 !en
UC = .4 ! 2 / H .,, ! 2 + K (.1113 ! H /+
Range"#(0").&alue = UC
lseIB ! = / An$ ! = ,5.55 !en
UC = .4 ! 2 + K .45 ! H /.,
Range"#(0").&alue = UC
lseIB ! = 1 An$ ! = 45.55 !en
-
7/24/2019 Escrito Macro
21/35
UC = .( ! 2 + K .+( ! H (/.,
Range"#(0").&alue = UC
lseIB ! K( An$ ! 5 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = /+ An$ A%I = //.55 !en
IB ! = K+ An$ ! = 5.55 !enUC = .+, ! 2 + K .+, ! H (/
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = /5.55 !en
UC = .( ! 2 + K ., ! H (/
Range"#(0").&alue = UC
lseIB ! = 0 An$ ! = 15.55 !en
UC = .( ! 2 + K .(1 ! H 5
Range"#(0").&alue = UC
lseIB ! K+ An$ ! 3 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UC
n$ IB
lseIB A%I = /0 An$ A%I = /,.55 !en
IB ! = K+ An$ ! = (5.55 !en
UC = K., ! 2 / H .( ! 2 + K .0, ! H (/
-
7/24/2019 Escrito Macro
22/35
Range"#(0").&alue = UC
lseIB ! = + An$ ! = /5.55 !en
UC = K.(1 ! H (
Range"#(0").&alue = UC
lseIB ! = 0 An$ ! = ,5.55 !en
UC = K.3 ! H 1.5
Range"#(0").&alue = UC
lseIB ! K+ An$ ! 1 !en
UC = "IN*RS UN &ALR ACRD" Range"#(0").&alue = UC
n$ IB
lseIB A%I = /1 An$ A%I = /3.55 !en
IB ! = K( An$ ! = (5.55 !en
UC = .3, ! 2 + K .+3, ! H 4.,
Range"#(0").&alue = UC
lseIB ! = + An$ ! = 05.55 !en
UC = .(, ! 2 + K .(3, ! H 3.4
Range"#(0").&alue = UC
lseIB ! K( An$ ! , !en
Range"#(0").&alue = "IN*RS UN &ALR ACRD"
n$ IB
lseIB A%I = /4 An$ A%I = /5.55 !en
-
7/24/2019 Escrito Macro
23/35
IB ! = K+ An$ ! = 5.55 !en
UC = .4, ! 2 + K .(0, ! H 1.+
Range"#(0").&alue = UC
lseIB ! = ( An$ ! = /5.55 !en
UC = .+ ! 2 + K .(1 ! H 1.+
Range"#(0").&alue = UC
lseIB ! K+ An$ ! 0 !en
UC = "IN*RS UN &ALR ACRD"
Range"#(0").&alue = UCn$ IB
lseIB A%I = 0 An$ A%I = 0(.55 !en
IB ! = K+ An$ ! = !en
UC = K.++ ! H /.1
Range"#(0").&alue = UC
lseIB ! = .( An$ ! = ( !en
UC = K.5 ! H 0.0
Range"#(0").&alue = UC
lseIB ! K+ An$ ! (.( !en
UC = "IN*RS UN &ALR ACRD")
Range"#(0").&alue = UC
n$ IB
n$ IB
-
7/24/2019 Escrito Macro
24/35
Dim rugosi$a$A#S- $iametro- numre>nol$s- viscosi$a$A#S-$enomina$or As Double
Dim Bactorasumi$o- Bactorcalcula$o- BactorBri- BactorBrime$io AsDouble
viscosi$a$A#S = UC %SS) 6 (
Range"#(,").&alue = viscosi$a$A#S
Msg#o; "la viscosi$a$ absoluta =" @ Roun$UC %SS) 6 () @"c%")
numre>nol$s = &LCIDAD DIAM!R!U#RIAM 6 UC 6 ()
Range"#(1").&alue = numre>nol$s
IB numre>nol$s = + !en
BactorBri = 10 6 numre>nol$s
Range"#(3").&alue = BactorBri
n$ IB
IB numre>nol$s + !en
Msg#o; "S FLU !UR#ULN!")
BactorBrime$io = .(
Do
Bactorasumi$o = BactorBrime$io
$enomina$or = K+ LogMA!RIAL 6 /.3 DIAM!R!U#RIAM)) H+.,( 6 numre>nol$s Bactorasumi$o) 2 .,))
Bactorcalcula$o = ( 6 $enomina$or $enomina$or)
BactorBrime$io = Bactorcalcula$o
IB AbsBactorcalcula$o K BactorBrime$io) .( !en
BactorBrime$io = Bactorcalcula$o
n$ IB
Loo? Until AbsBactorcalcula$o K Bactorasumi$o) .(
Range"b(3").&alue = Bactorcalcula$o
n$ IB
-
7/24/2019 Escrito Macro
25/35
n$ Sub
EJERCICIO
E6!c-'a(os !" &rogra(a con %TRL O
#na ! !6!c-'ao !scog!(os !n (!'ros c:)cos o !n arr)"!s &or )a con 1 o 2
-
7/24/2019 Escrito Macro
26/35
E"!g)(os !n n-!s'ro caso arr)"!s &or )a ! )ngr!sa(os K00000 $PD
-
7/24/2019 Escrito Macro
27/35
#na ! )ngr!sao !" ca-a" !" &rogra(a nos a !" ca-a" !n "as -n)a!s ,-! no s!!scog)!ron. Para !s'! caso !n (!'ros c:)cos
En !" s)g-)!n'! &aso !scog!(os "as -n)a!s &ara !" )3(!'ro ! "a '-!r4a con 1!scog!(os !n &-"gaas con 2 !n (!'ros. N-!s'ro caso 1&-"gaasF.
-
7/24/2019 Escrito Macro
28/35
In(!)a'a(!n'! s! ar! "a !n'ana &ara co"ocar !" a"or !" )3(!'ro !n &-"gaas !s'!!s ! 1 &-"gaas.
Ingr!sao -na ! !s'! a"or !" &rogra(a nos a a-'o(3')ca(!n'! !" a"or !" 3r!a ! "a'-!r4a 'a()n nos "o &r!s!n'a !n -na !n'ana.
La s)g-)!n'! !n'ana !" &rogra(a !s !"!g)r !" (a'!r)a". Escog!(os !" cor! ,-! !s "ao&c)+n 1.
-
7/24/2019 Escrito Macro
29/35
@ a-'o(3')ca(!n'! nos )n)ca !" a"or ! "a r-gos)a ! )c9o (a'!r)a" !n -na !n'ana.
A-'o(3')ca(!n'! nos )n)ca !" a"or ! "a !"oc)a !n -na !n'ana !(!rg!n'! !n-n)a!s ! (!'ros &or s!g-no.
-
7/24/2019 Escrito Macro
30/35
E" s)g-)!n'! &aso !s )ngr!sar !" a"or !" API !n !" rango !s'a"!c)o caso con'rar)o ara-n (!nsa6! ! !rror. Para n-!s'ro caso API 2.
La s)g-)!n'! !n'ana !" &rogra(a nos &)! !scog!r "as -n)a!s ! "a '!(&!ra'-ra &aran-!s'ro caso !s 2 ,-! Car!n9!)'
-
7/24/2019 Escrito Macro
31/35
La temperatura de nuestro problema es 80 F y colocamos el valor en laventana.
Con estos valores ingresados el programa nos da el valor de la viscosidad
absoluta en centipoise en una ventana.
-
7/24/2019 Escrito Macro
32/35
Y con todos estos valores tambien nos indica el numero de reynolds y el tipo defujo que tendria.
-
7/24/2019 Escrito Macro
33/35
Y asi automaticamente el programa nos indica el valor del actor de riccin y
todos los resultados en conjunto.
CONCLUSIONES Las ar)a"!s !*)n)as &-!!n s!r !*)n)as ! (an!ra !n'!ra o s)ng-"ar
)n'!g!r s)ng"!F. Para "os co"or!s s! -')")a "as *-nc)+n Con'.co"o' con "a co()nac)+n ! "os
co"or!s ,-! son ro6oa-" !r!. Para ,-! a&ar!sca "as !n'anas !(!rg!n'!s s! -')")a !" )n&-'o8 E" )* !s -na *-nc)+n ,-! nos &!r()'! s!"!cc)onar -n a"or o *-nc)+n ,-!
,-!ra(os o "a o'ra !&!n)!no ! "a n!c!s)a )n)caa La *-nc)+n "oo& -n')" nos &!r()'! r!a")ar "a *-nc)+n 9as'a ,-! s! c-(&"a "a
con)c)+n
-
7/24/2019 Escrito Macro
34/35
RECOMENDACIONES
Para r!a")ar -n &rogra(a ! (an!ra a!c-aa !s n!c!sar)o conoc!r "as
*-nc)on!s ! )s-a" as)c co(o )ngr!sar"as S! !! r!a")ar &r)(!ro -n a"gor)'(o !" &rogra(a an'!s ! &roc!!r a "a
s)n'a8)s !" &rogra(a.
BIBLIOGRAFIA
http://dmcritchie.mvps.org/excel/colors.htm
Jaln, J.(2000).Aprenda visual Basic .0. !niversidad de "avarra.
http://dmcritchie.mvps.org/excel/colors.htmhttp://dmcritchie.mvps.org/excel/colors.htm -
7/24/2019 Escrito Macro
35/35
top related