Balance Hid 2018 Excel

INFILTRACION EN ATAJADOS ATAJADOS BASE

180 180 32400 2.00 64800

AREA h= Vol = TIPO DE SUELO K=

m m m2 m m3

2.084E-08 m/s

MES:

MARZO

$#%m&o $#%m&o

31 26(8400

!"#ll

'#s s)

Volumen de infiltracin:

Vi ! " # A$u% # t

&

Vi !

' ( ) ( *+ )

m,-me$

.i !Vi - A

&

.i !

) *) /

m

.i !

++*(0

mm

MES:

A1RIL

$#%m&o $#%m&o

30 2*+2000

'#s s)


Vi ! " # A$u% # t

&

Vi !

' 2 + ) *' /

m,-me$

.i !Vi - A

&

.i !

) *) +

m

.i !

+3*)0

mm

MES:

MA4O

$#%m&o $#%m&o

31 26(8400

'#s s)


Vi ! " # A$u% # t

&

Vi !

' ( ) ( *+ )

m,-me$

.i !Vi - A

&

.i !

)*)/

m

.i !

++*(0

mm

CALC5LO DE LA EVA6ORACI7N EN S56ERFICIES DE A85A 1ALANCE ENER89TICO DE 6ENMAN DATOS:

MARZO T%m&%!$,! ,m%'' !%l$# V%lo"#'' '%l #%$o 2m D,!"#o '% #sol"#o %%"$# h%l#7)!o D,!"#o '%l '# s$!o7m#"o D,!"#o !%l$# '% l #sol"#7

$= = ,= = D=

20.2 (0 1.2* *.+ 12.3

E

/D =

0.48

'% $l IDRIESTA P). 180

U#""#7 )%o)!9#": <%s:

  m/s

0.( 4.* 5m/h!

21 ; L$#$,' S,!

R A =

8+0.*0

? =

1.0*

2(3.16 2+3.36

K K

"l/"m2-'>

'*& Calculo de ten$ion de a%or daturante e $ T%m&%!$,! $!#&l% '%l ),

T%m&%!$,! "$,l

$1= $=

"$

%$@o!m,l '% o  !"h$. %s =

23.6* m#l#!%s

%s =

1(.(8 mm )

0*& Calculo de ten$ion de a%or actual e a % =

16.*6 m#l#!%s 1 m#l#! = 1C33 mm )

% =

12.4* mm )

,*& Cantidad de ener<;a emitida de la $u%erficie radiante L% '% S$% Bol$Fm os$$%= T%m&%!$,! "$,l

= $=

1.1(E-0( "l/"m2-'> 2+3.36 K

R!

(/*+)

cal-cm0&d;a

3*& Cantidad de ener<;a =ue alcan>a lo$ l;mite$ de la atm$fera RA !

()*+

cal-cm0&d;a '% $ls "o l l$#$,'

+*& Cantidad de ener<;a =ue %enetra la atm$fera ? alcan>a la $u%erficie terre$tre Rc !

,(,*',0'+ cal-cm0&d;a

/*& Ener<;a retenida %or la $u%* terre$tre o%#"#%$% '% !%l%#7

!=

RI !

0.06

&/s,&%!#"#%s '% ),

,/)*'330/, cal-cm0&d;a

/*& Flu@o neto de radiacin $aliente de la $u%*terre$tre R1 !

'))*/2

cal-cm0&d;a

2*& Ener<;a remanente en la $u%*terre$tre D#s&o#l% &! o!%"%!  ls &%!'#s &o! %&o!"#7.

B!

0+*3(

cal-cm0&d;a

Ea !

','*/,

cal-cm0&d;a

(*& Calculo auiliar

(*& Ea%oracin de$de la $u%erficie de a
H=

0.4+

S# $ %s$9 % 

Eo !

0'(*()

cal-cm0&d;a

*& Ea%oracin de$de la $u%erficie de a
,*/+

mm-dia

')*& Ea%oracin de$de la $u%erficie de a

31

'#s

Eo !

'',*)+

mm-me$

Ea%oracin total en termino$ de olmen m,-me$ E total ! A = A =

&

V!

)*''

m

3.24 32C400

,//0*/(

 m2

m,

A1RIL T%m&%!$,! ,m%'' !%l$# V%lo"#'' '%l #%$o 2m D,!"#o '% #sol"#o %%"$# h%l#7)!o D,!"#o '%l '# s$!o7m#"o D,!"#o !%l$# '% l #sol"#7 U#""#7 )%o)!9#": <%s:

$= = ,= = D= /D =

18.6  6(  0.6( 1.2* m/s 4.* 5m/h! 6.6 11.( E 0.*6 '% $l IDRIESTA P). 180 21 ; L$#$,' S,!

R A =

ABRIL

? =

(**.00 1.0*

2(3.16 2+1.(6

K K

"l/"m2-'>


T%m&%!$,! "$,l

$1= $=

@o!m,l '% o  !"h$. %s =

21.41 m#l#!%s

%s =

16.10 mm )

0*& Calculo de ten$ion de a%or actual e a

"$

%$ % =

14.3* m#l#!%s 1 m#l#! = 1C33 mm )

% =

10.(+ mm )


= $=

1.1(E-0( "l/"m2-'> 2+1.(6 K

R!

(+)*/

cal-cm0&d;a


2++

cal-cm0&d;a '% $ls "o l l$#$,'


,++*3,)2/ cal-cm0&d;a


!=

RI !

0.06

&/s,&%!#"#%s '% ),

,,3*')30, cal-cm0&d;a

/*& Flu@o neto de radiacin $aliente de la $u%*terre$tre R1 !

'0)*0

cal-cm0&d;a


B!

0',*(0

cal-cm0&d;a

Ea !

','*)

cal-cm0&d;a


H=

0.4+

Eo !

'(2*3

S# $ %s$9 % 

cal-cm0&d;a

,*'0

mm-dia

ABRIL

30

'#s

Eo !

,*2+

mm-me$

Ea%oracin total en termino$ de olmen m,-me$

E total ! A = A =

&

V!

)*)

m

3.24 32C400

,),2*,

 m2

m,

MA4O T%m&%!$,! ,m%'' !%l$# V%lo"#'' '%l #%$o 2m D,!"#o '% #sol"#o %%"$# h%l#7)!o D,!"#o '%l '# s$!o7m#"o D,!"#o !%l$# '% l #sol"#7 U#""#7 )%o)!9#": <%s:

$= = ,= = D= /D =

1*.6  62  0.62 1.2* m/s 4.* 5m/h! (.4 11.3 E 0.6* '% $l IDRIESTA P). 180 21 ; L$#$,' S,!

R A =

? =

63(.*0 1.0*

2(3.16 288.(6

K K

"l/"m2-'>


T%m&%!$,! "$,l

$1= $=

"$

%$@o!m,l '% o  !"h$. %s =

1(.(1 m#l#!%s

%s =

13.32 mm )

0*& Calculo de ten$ion de a%or actual e a % =

10.+8 m#l#!%s 1 m#l#! = 1C33 mm )

% =

8.26 mm )


= $=

1.1(E-0( "l/"m2-'> 288.(6 K

R!

('/*03

cal-cm0&d;a


/,2*+

cal-cm0&d;a '% $ls "o l l$#$,'


,02*((,(' cal-cm0&d;a


!=

RI !

0.06

,)(*0'/)'( cal-cm0&d;a

/*& Flu@o neto de radiacin $aliente de la $u%*terre$tre

&/s,&%!#"#%s '% ),

R1 !

'3/*

cal-cm0&d;a


B!

'/'*0,

cal-cm0&d;a

Ea !

'03*(+

cal-cm0&d;a


H=

0.4+

Eo !

'3*/+

S# $ %s$9 % 

cal-cm0&d;a

0*3

mm-dia


31

'#s

Eo !

22*,0

mm-me$

Ea%oracin total en termino$ de olmen m,-me$ E total ! A = A =

&

V!

)*)22 3.24 32C400

0+)+*0'

m  m2

m,

1LANE4 CRIDDLE MODIFICADO 6OR LA FAO P! "l#m s%m#!#'o

EGAMEN Dato$

MARZO

/J = !m# = ,' = U#""#7

0.48 (0 4.* 5m/h! l$ s,! 2132

MES

0.(0 1.2*0 m/s)

t HC

20.2

'*& Ecuacion %ara determinar la ea%o tran$%iracin de referencia*

Eto =

a + bf

0*& determinara lo$ coeficinte$ a ? 

o = 1 = 2 = 3 = 4 = * =

a=

0,043 Hrmin - n/N - 1,41

b=

ao  a' Br min  a0 n-N  a, 5d  a3 Br min n-N  a+ Br min 5d

0.81+1( -0.0040+22 1.0(0* 0.06*64+ -0.00*+684 -0.000*+6( a=

0,043 Hrmin - n/N - 1,41

a=

&'*(/

b= b=

6ARA EL MES DE ,*& Calculo de f

ao  a' Br min  a0 n-N  a, 5d  a3 Br min n-N  a+ Br min 5d 1.41

p (0,46 t + 8,13) 20.2

l$ s,! 2132

3*(2(0

3*& Ea%otran$%iracin de Referencia

Eto = Eto =

a + bf

+*)0

mm-dia

3*& Calculo del u$o con$untio del cultio

TO
Etc =

Kc Eto

0.(

'% $ls

Etc =

,*+'

31

Etm =

')(*(,

K" =

'#s

Dato$

A1RIL

/J = !m# = ,' = U#""#7

0.*6 6( 4.8 5m/h! l$ s,! 2132

MES

mm-dia

mm-me$

0.6( 1.333 m/s)

t HC

ABRIL

18.6


Eto =

a + bf


o = 1 = 2 = 3 = 4 = * =

a=

0,043 Hrmin - n/N - 1,41

b=


0.81+1( -0.0040+22 1.0(0* 0.06*64+ -0.00*+684 -0.000*+6( a=

0,043 Hrmin - n/N - 1,41

a=

&'*+

b= b=


ao  a' Br min  a0 n-N  a, 5d  a3 Br min n-N  a+ Br min 5d 1.51

ABRIL f= $=

p (0,46 t + 8,13) 18 6

ABRIL

3*,,(3

f=


Eto = Eto =

a + bf

3*+(

mm-dia


TO
Etc =

Kc Eto

0.(

'% $ls

Etc =

,*0'

30

ABRIL

Etm =

/*02

K" =

'#s

Dato$

MA4O

/J = !m# = ,' = U#""#7

0.6* 6( 4.8 5m/h! l$ s,! 2132

MES

mm-dia

mm-me$

0.6( 1.333 m/s)

t HC

1*.6


Eto =

a + bf


o = 1 = 2 = 3 = 4 = * =

a=

0,043 Hrmin - n/N - 1,41

b=


0.81+1( -0.0040+22 1.0(0* 0.06*64+ -0.00*+684 -0.000*+6( a=

0,043 Hrmin - n/N - 1,41

a=

&0*)3

b=

1.60


p (0,46 t + 8,13) 1*.6

l$ s,! 2132

,*(0/+


Eto = Eto =

a + bf

3*)

mm-dia


TO
K" =

'#s

Etc =

Kc Eto

0.(

'% $ls

Etc =

0*(2

31

Etm =

(+*/

mm-me$

MARZO

A1RIL

MA4O

0.10+ 20.00 200C000.00

0.0+6 20.00 200C000.00

mm-dia

RES5MEN DE EVA6OTRANS6IRACION

ETP "o!!. AREA CULTIVO AREA CULTIVO

VOLU
m  m2 m3

TOTAL EVAPOTRAJSPIRAIOJ:

0'2//*20

0.086 20.00 200C000.00

'0+,*,, +(0'0*,, m,

'2'0*02

CA5DAL DE ENTRADA
K!V-t =

10 l$/s

Vol,m% ,% #"!%m%$ %l ",'l '% %$!' % los m%s%s '%:

V!K#t

Ve !

0/2(3*))

K!V-t =

10 l$/s

ABRIL

0+0)*))

K!V-t 10 l$/s

m,

Vol,m% ,% #"!%m%$ %l ",'l '% %$!' % los m%s%s '%:

V!K#t

'#s s)

0.01 m3/s

Ve !

=

m,

ABRIL 30 2*+2000

Vol,m% ,% #"!%m%$ %l ",'l '% %$!' % los m%s%s '%:

V!K#t

'#s s)

Ve !

0/2(3*))

m,

'#s s)

1ALANCE MES A MES VOLMENES MES

VOL5MEN INICIAL m,

6ERDIDA INFILTRACION m

6ERDIDA EVA6ORACION m

6ERDIDA EVT m

ENTRADA m

VOL5MEN FINAL m

64C800.00

1C808.*0

3C662.68

21C(66.(2

26C(84.00

64C346.10

ABRIL

64C346.10

1C(*0.16

,),2*,

'0+,*,,

0+0)*))

66C22*.22

66C22*.22

1C808.*0

2C*0*.21

1(C1+2.2(

26C(84.00

(1C*03.24

AREA:

32400

m2

ALT5RAS MES

ALT5RA INICIAL m

6ERDIDA INFILTRACION m

6ERDIDA EVA6ORACION m

6ERDIDA EVT m

ENTRADA m

ALT5RA FINAL m

2.00

0.06

0.11

0.6(

0.83

1.++

ABRIL

1.++

0.0*

0.0+

0.*+

0.80

2.04

2.04

0.06

0.08

0.*3

0.83

2.21

Balance Hid 2018 Excel

Recommend Documents