{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Enunciado","Wischmeier","RUSLE2"],"not_rendered":{"charts":6,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Enunciado","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8]]}
["No quadro 1 apresenta-se um udograma relativo a uma chuvada erosiva."]
["a) Calcule a energia cinética da chuvada e o índice de erosividade Ecr30, utilizando as equações propostas por Wischmeier e Smith;"]
["b) Calcule a energia cinética da chuvada e o índice de erosividade Ecr30, utilizando as equações propostas pela RUSLE2."]
[]
["Quadro 1 Udograma de uma chuvada erosiva (adaptado de Morgan, 2005)"]
["t (min)","R (mm)"]
[0,0]
[15,1.52]
[30,15.74]
[45,41.9]
[60,73.400000000000006]
[75,81.78]
[90,82.03]
[105,82.03]

{"sheet":"Wischmeier","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["t (min)","R (mm)","DR (mm)","r (mm/h)","ec (MJ ha-1 mm-1)","DEc (MJ ha-1)"]
["(1)","(2)","(3)","(4)","(5)","(6) = (3) X (5)"]
[0,0]
[15,1.52,{"$f":"B5-B4","v":1.52},{"$f":"C5/$D$19","v":6.08},{"$f":"IF(D5<=76.2,0.119+0.0873*LOG10(D5),0.283)","v":0.18743478247050976},{"$f":"C5*E5","v":0.28490086935517484}]
[30,15.74,{"$f":"B6-B5","v":14.22},56.88,{"$f":"IF(D6<=76.2,0.119+0.0873*LOG10(D6),0.283)","v":0.27220797200810531},{"$f":"C6*E6","v":3.8707973619552578}]
[45,41.9,26.159999999999997,104.63999999999999,0.28299999999999997,7.4032799999999988]
[60,73.400000000000006,31.500000000000007,126.00000000000003,0.28299999999999997,8.9145000000000003]
[75,81.78,8.3799999999999955,33.519999999999982,0.25215904006935425,2.1130927557811874]
[90,82.03,0.25,1,0.11899999999999999,2.9749999999999999E-2]
[105,82.03,0]
[null,null,null,null,"Ec (Mj ha-1) =",{"$f":"SUM(F5:F10)","v":22.616320987091619}]
["(3) DRi = Ri - Ri-1;"]
["(4) ri = Dri / Dt;"]
["(5)"]
[]
[null,"com ec em MJ ha-1 mm-1 e r em mm/h"]
[]
["Dt =",15,"min =",{"$f":"15/60","v":0.25},"h"]
["r30 =",{"$f":"(C7+C8)/0.5","v":115.32000000000001},"mm/h"]
["Ecr30 =",{"$f":"F12*B20","v":2608.1141362314056}," (MJ mm ha-1 h-1)"]
["Ecr30 =",{"$f":"F12*MIN(B20,63.5)","v":1436.1363826803179}," (MJ mm ha-1 h-1)",null,"com"]

{"sheet":"RUSLE2","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
["t (min)","R (mm)","DR (mm)","r (mm/h)","ec (MJ ha-1 mm-1)","DEc (MJ ha-1)"]
["(1)","(2)","(3)","(4)","(5)","(6) = (3) X (5)"]
[0,0]
[15,1.52,{"$f":"B5-B4","v":1.52},{"$f":"C5/$D$17","v":6.08},{"$f":"0.29*(1-0.72*EXP(-0.082*D5))","v":0.16317390009835009},{"$f":"C5*E5","v":0.24802432814949213}]
[30,15.74,{"$f":"B6-B5","v":14.22},56.88,0.28803160821608681,{"$f":"C6*E6","v":4.0958094688327549}]
[45,41.9,26.159999999999997,104.63999999999999,0.28996080096477089,7.5853745532384051]
[60,73.400000000000006,31.500000000000007,126.00000000000003,0.28999319857509559,9.1347857551155123]
[75,81.78,8.3799999999999955,33.519999999999982,0.27663369676319277,2.318190378875554]
[90,82.03,0.25,1,9.763841502420241E-2,2.4409603756050603E-2]
[105,82.03,0]
[null,null,null,null,"Ec (Mj ha-1) =",{"$f":"SUM(F5:F10)","v":23.406594087967768}]
["(3) DRi = Ri - Ri-1;"]
["(4) ri = Dri / Dt;"]
["(5)",null,null,null,"com ec em MJ ha-1 mm-1 e r em mm/h"]
[]
["Dt =",15,"min =",{"$f":"15/60","v":0.25},"h"]
["r30 =",{"$f":"(C7+C8)/0.5","v":115.32000000000001},"mm/h"]
["Ecr30 =",{"$f":"F12*B18","v":2699.2484302244434}," (MJ mm ha-1 h-1)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NOTA: A expressão utilizada para estimar a energia cinética unitária da precipitação é a proposta pela RUSLE2 e não a apresentada no powerpoint relativo à RUSLE."]