{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Enunciado","A título de comparação com USLE","RUSLE","Comparação"],"not_rendered":{"charts":0,"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":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,0,2,8],[3,0,3,8]]}
["Considere um solo muito susceptível à erosão por sulcos, com um comprimento de encosta de 64 m e um declive médio de 15 %. Calcular LS se (adaptado de Haan et al., 1994):"]
["a) O declive for uniforme."]
["b) O declive for convexo, com declives de 10, 15 e 20 %, em 3 segmentos de igual comprimento."]
["c) O declive for côncavo, com declives de 20, 15 e 10 %, em 3 segmentos de  igual comprimento."]
["Usar as equações de RUSLE"]

{"sheet":"A título de comparação com USLE","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Cálculos com USLE"]
[]
["I - Declive uniforme"]
[]
["s =",15,"%"]
["l =",64,"m"]
["a =",{"$f":"DEGREES(ATAN(B5/100))","v":8.5307656099481335},"o"]
["sena =",{"$f":"SIN(RADIANS(B7))","v":0.14834045293024464}]
[]
["n =",{"$f":"0.6*(1-EXP(-35.835*B5/100))","v":0.59722214331086754}]
["L =",{"$f":"(B6/22.1)^B10","v":1.8870779503518984}]
["S =",{"$f":"65.41*B8^2+4.56*B8+0.065","v":2.1807723186626493}]
["LS =",{"$f":"B11*B12","v":4.1152873572860695}]
[]
["II - Encosta convexa"]
[]
["Segmento","li (m)","Declive (%)","a (o)","sena","S","n",null,"LiSi"]
[null,0]
[1,{"$f":"64/3","v":21.333333333333332},10,{"$f":"DEGREES(ATAN(C19/100))","v":5.710593137499643},{"$f":"SIN(RADIANS(D19))","v":9.9503719020998929E-2},{"$f":"65.41*E19^2+4.56*E19+0.065","v":1.1663607211119928},{"$f":"0.6*(1-EXP(-35.835*C19/100))","v":0.58333301768940926},{"$f":"(B19^(G19+1)-B18^(G19+1))/($B$21*22.1^G19)","v":0.32653833705301533},{"$f":"H19*F19","v":0.38086149027586591}]
[2,{"$f":"2*B19","v":42.666666666666664},15,{"$f":"DEGREES(ATAN(C20/100))","v":8.5307656099481335},{"$f":"SIN(RADIANS(D20))","v":0.14834045293024464},{"$f":"65.41*E20^2+4.56*E20+0.065","v":2.1807723186626493},{"$f":"0.6*(1-EXP(-35.835*C20/100))","v":0.59722214331086754},{"$f":"(B20^(G20+1)-B19^(G20+1))/($B$21*22.1^G20)","v":0.66111237838189818},{"$f":"H20*F20","v":1.4417355743004709}]
[3,{"$f":"64","v":64},20,11.309932474020215,0.19611613513818404,{"$f":"65.41*E21^2+4.56*E21+0.065","v":3.4750588069993502},0.59953701950109739,{"$f":"(B21^(G21+1)-B20^(G21+1))/($B$21*22.1^G21)","v":0.90273302233964114},{"$f":"H21*F21","v":3.1370503396505112}]
[null,null,null,null,null,null,null,"LS =",{"$f":"SUM(I19:I21)","v":4.9596474042268479}]
[]
["II - Encosta côncava"]
[]
["Segmento","li (m)","Declive (%)","a (o)","sena","S","n",null,"LiSi"]
[null,0]
[1,{"$f":"64/3","v":21.333333333333332},20,{"$f":"DEGREES(ATAN(C28/100))","v":11.309932474020215},{"$f":"SIN(RADIANS(D28))","v":0.19611613513818404},{"$f":"65.41*E28^2+4.56*E28+0.065","v":3.4750588069993502},{"$f":"0.6*(1-EXP(-35.835*C28/100))","v":0.59953701950109739},{"$f":"(B28^(G28+1)-B27^(G28+1))/($B$21*22.1^G28)","v":0.32635157408768467},{"$f":"H28*F28","v":1.1340909117115094}]
[2,{"$f":"2*B28","v":42.666666666666664},15,{"$f":"DEGREES(ATAN(C29/100))","v":8.5307656099481335},{"$f":"SIN(RADIANS(D29))","v":0.14834045293024464},{"$f":"65.41*E29^2+4.56*E29+0.065","v":2.1807723186626493},{"$f":"0.6*(1-EXP(-35.835*C29/100))","v":0.59722214331086754},{"$f":"(B29^(G29+1)-B28^(G29+1))/($B$21*22.1^G29)","v":0.66111237838189818},{"$f":"H29*F29","v":1.4417355743004709}]
[3,{"$f":"64","v":64},10,5.710593137499643,9.9503719020998929E-2,{"$f":"65.41*E30^2+4.56*E30+0.065","v":1.1663607211119928},0.58333301768940926,{"$f":"(B30^(G30+1)-B29^(G30+1))/($B$21*22.1^G30)","v":0.88090445273701501},{"$f":"H30*F30","v":1.0274523527251103}]
[null,null,null,null,null,null,null,"LS =",{"$f":"SUM(I28:I30)","v":3.6032788387370904}]

{"sheet":"RUSLE","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Cálculos com RUSLE"]
[]
["I - Declive uniforme"]
[]
["s =",15,"%"]
["l =",64,"m"]
["a =",{"$f":"DEGREES(ATAN(B5/100))","v":8.5307656099481335},"o"]
["sena =",{"$f":"SIN(RADIANS(B7))","v":0.14834045293024464}]
[]
["bmod =",{"$f":"11.16*B8/(3*B8^0.8+0.56)","v":1.3661079078261806}]
["b =",{"$f":"2*B10","v":2.7322158156523613},null,"(solo muito susceptível à erosão por sulcos)"]
["n =",{"$f":"B11/(1+B11)","v":0.73206265409247029}]
["L =",{"$f":"(B6/22.1)^B12","v":2.1779982652426435}]
["S =",{"$f":"IF(B6<4.6,3*B8^0.8+0.56,IF(B8<0.09,10.8*B8+0.03,16.8*B8-0.5))","v":1.9921196092281099},null,null,"pois"]
["LS =",{"$f":"B13*B14","v":4.3388330530546764}]
[]
["II - Encosta convexa"]
[]
["Segmento","li (m)","Declive (%)","a (o)","sena","S","bmod","b","n",null,"LiSi"]
[null,0]
[1,{"$f":"64/3","v":21.333333333333332},10,{"$f":"DEGREES(ATAN(C21/100))","v":5.710593137499643},{"$f":"SIN(RADIANS(D21))","v":9.9503719020998929E-2},{"$f":"IF(B21<4.6,3*E21^0.8+0.56,IF(E21<0.09,10.8*E21+0.03,16.8*E21-0.5))","v":1.1716624795527821},{"$f":"11.16*E21/(3*E21^0.8+0.56)","v":1.0743844341332189},{"$f":"2*G21","v":2.1487688682664379},{"$f":"H21/(1+H21)","v":0.68241555927521846},{"$f":"(B21^(I21+1)-B20^(I21+1))/($B$23*22.1^I21)","v":0.32539800739368974},{"$f":"J21*F21","v":0.38125663618442507}]
[2,{"$f":"2*B21","v":42.666666666666664},15,{"$f":"DEGREES(ATAN(C22/100))","v":8.5307656099481335},{"$f":"SIN(RADIANS(D22))","v":0.14834045293024464},{"$f":"IF(B22<4.6,3*E22^0.8+0.56,IF(E22<0.09,10.8*E22+0.03,16.8*E22-0.5))","v":1.9921196092281099},{"$f":"11.16*E22/(3*E22^0.8+0.56)","v":1.3661079078261806},{"$f":"2*G22","v":2.7322158156523613},{"$f":"H22/(1+H22)","v":0.73206265409247029},{"$f":"(B22^(I22+1)-B21^(I22+1))/($B$23*22.1^I22)","v":0.75425881590860577},{"$f":"J22*F22","v":1.5025737776047086}]
[3,{"$f":"64","v":64},20,11.309932474020215,0.19611613513818404,{"$f":"IF(B23<4.6,3*E23^0.8+0.56,IF(E23<0.09,10.8*E23+0.03,16.8*E23-0.5))","v":2.7947510703214919},1.5918056846956412,3.1836113693912824,0.76097206176550269,1.1461833977635008,3.2032972776842681]
[null,null,null,null,null,null,null,null,null,"LS =",{"$f":"SUM(K21:K23)","v":5.0871276914734018}]
[]
["II - Encosta côncava"]
[]
["Segmento","li (m)","Declive (%)","a (o)","sena","S","bmod","b","n",null,"LiSi"]
[null,0]
[1,{"$f":"64/3","v":21.333333333333332},20,{"$f":"DEGREES(ATAN(C30/100))","v":11.309932474020215},{"$f":"SIN(RADIANS(D30))","v":0.19611613513818404},{"$f":"IF(B30<4.6,3*E30^0.8+0.56,IF(E30<0.09,10.8*E30+0.03,16.8*E30-0.5))","v":2.7947510703214919},{"$f":"11.16*E30/(3*E30^0.8+0.56)","v":1.5918056846956412},{"$f":"2*G30","v":3.1836113693912824},{"$f":"H30/(1+H30)","v":0.76097206176550269},{"$f":"(B30^(I30+1)-B29^(I30+1))/($B$23*22.1^I30)","v":0.32449674049618438},{"$f":"J30*F30","v":0.90688761281754671}]
[2,{"$f":"2*B30","v":42.666666666666664},15,{"$f":"DEGREES(ATAN(C31/100))","v":8.5307656099481335},{"$f":"SIN(RADIANS(D31))","v":0.14834045293024464},{"$f":"IF(B31<4.6,3*E31^0.8+0.56,IF(E31<0.09,10.8*E31+0.03,16.8*E31-0.5))","v":1.9921196092281099},{"$f":"11.16*E31/(3*E31^0.8+0.56)","v":1.3661079078261806},{"$f":"2*G31","v":2.7322158156523613},{"$f":"H31/(1+H31)","v":0.73206265409247029},{"$f":"(B31^(I31+1)-B30^(I31+1))/($B$23*22.1^I31)","v":0.75425881590860577},{"$f":"J31*F31","v":1.5025737776047086}]
[3,{"$f":"64","v":64},10,5.710593137499643,9.9503719020998929E-2,{"$f":"IF(B32<4.6,3*E32^0.8+0.56,IF(E32<0.09,10.8*E32+0.03,16.8*E32-0.5))","v":1.1716624795527821},1.0743844341332189,2.1487688682664379,0.68241555927521846,1.0215903741229229,1.1969591108321183]
[null,null,null,null,null,null,null,null,null,"LS =",{"$f":"SUM(K30:K32)","v":3.6064205012543735}]

{"sheet":"Comparação","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"LS"]
["Encosta com declive","USLE","RUSLE"]
["Côncavo",{"$f":"'A título de comparação com USLE'!I31","v":3.6032788387370904},{"$f":"RUSLE!K33","v":3.6064205012543735}]
["Uniforme",{"$f":"'A título de comparação com USLE'!B13","v":4.1152873572860695},{"$f":"RUSLE!B15","v":4.3388330530546764}]
["Convexo",{"$f":"'A título de comparação com USLE'!I22","v":4.9596474042268479},{"$f":"RUSLE!K24","v":5.0871276914734018}]