{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Título","BalançoHídrico","ArtigoSobreMétodo","TomeApontamentosAqui"],"not_rendered":{"images":5,"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Título","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"BalançoHídrico","index":1,"n_rows":46,"n_cols":64,"rows_kept":46}
["Caso queira calcular ETp pelo método de Thornthwaite, que só deverá ser utilizado para a classificação climática, só necessita de entrar valores nas células com sombreado a verde (latitude, capacidade de água disponível (U),temperatura média (T) mensal e precipitação mensal (P).  Depois de preencher prima o botão \"Calcular Cf !\".",{"$nulls":47},"Somas de P-ETP negativos:",{"$nulls":3},{"$f":"IF($K$10=0,C20,IF(AND(C20<0,N20<=0),BL1+C20,IF(AND(C20<0,N20>0),C20,0)))","v":0},{"$f":"IF(AND(D20<0,C20<=0),BA1+D20,IF(AND(D20<0,C20>0),D20,0))","v":0},0,0,-39,-121,-239,-352,-420,0,0,0]
["Para entrar com alternativa a Etp de Thornthwaite, preencha as células a amarelo (linha 16) em vez das células a verde na linha 12 e não necessita de premir o botão.",{"$nulls":47},"Mês com valor + negativo",{"$nulls":3},{"$f":"IF(AND(BA1=MIN($BA$1:$BL$1),BB1>=0),1,0)","v":0},{"$f":"IF(AND(BB1=MIN($BA$1:$BL$1),BC1>=0),1,0)","v":0},0,0,0,0,0,0,1,0,0,{"$f":"IF(AND(BL1=MIN($BA$1:$BL$1),BA1>=0),1,0)","v":0}]
[{"$nulls":3},"BALANÇO HÍDRICO PELO MÉTODO DE THORNTHWAITE-MATHER ",{"$nulls":44},"Match1:",{"$f":"MATCH(1,BA2:BL2,0)","v":9},"Value:",{"$f":"INDEX(BA1:BL2,1,AX3)","v":-420}]
[{"$nulls":5},"Estação: ","Tapada da Ajuda (Lisboa, Portugal)"]
[{"$nulls":3},"Graus","Minutos","Segundos",{"$nulls":3},"Graus","Minutos","Segundos"]
[null,null,"Latitude:",38,42,0,"N",null,"Long.:",9,11,0,"O",null,"Alt.:",50,"m"]
[{"$nulls":4},"Período dos dados:"]
[null,"U",100]
[]
[{"$nulls":9},"P=",{"$f":"SUMIF(C20:N20,\">0\")","v":{"v":328,"d":"328.0"}},"N=",{"$f":"SUMIF(C20:N20,\"<0\")","v":{"v":-420,"d":"-420.0"}}]
[null,null,"J","F","M","A","M","J","J","A","S","O","N","D","Ano"]
[1,"T",{"v":11,"d":"11.00"},{"v":11.9,"d":"11.90"},{"v":13,"d":"13.00"},{"v":14.4,"d":"14.40"},{"v":16.6,"d":"16.60"},{"v":19.6,"d":"19.60"},{"v":21.8,"d":"21.80"},{"v":22.2,"d":"22.20"},{"v":20.9,"d":"20.90"},{"v":18,"d":"18.00"},{"v":14.2,"d":"14.20"},{"v":11.6,"d":"11.60"},{"$f":"AVERAGE(C12:N12)","v":{"v":16.266666666666666,"d":"16.3"}}]
[2,"i",{"$f":"(MAX(0,C12)/5)^1.514","v":{"v":3.299346582591521,"d":"3.30"}},{"$f":"(MAX(0,D12)/5)^1.514","v":{"v":3.716528889096471,"d":"3.72"}},{"v":4.248832875835332,"d":"4.25"},{"v":4.960440291971839,"d":"4.96"},{"v":6.151812054043311,"d":"6.15"},{"v":7.91106778029485,"d":"7.91"},{"v":9.29356936488154,"d":"9.29"},{"v":9.552956864944953,"d":"9.55"},{"v":8.718883818449724,"d":"8.72"},{"v":6.95411688690119,"d":"6.95"},{"v":4.856506416071342,"d":"4.86"},{"v":3.575599016299879,"d":"3.58"},{"$f":"SUM(C13:N13)","v":{"v":73.23966084138195,"d":"73.2"}},"=I"]
[3,"E1",{"$f":"IF(C12<=26.4,(16*((10*MAX(0,C12))/$O13)^(0.000000675*$O13^3-0.0000771*$O13^2+0.01792*$O13+0.49239))/30,-14.927+1.1392*C12-0.0154*C12^2)","v":{"v":1.0461789474825653,"d":"1.05"}},{"$f":"IF(D12<=26.4,(16*((10*MAX(0,D12))/$O13)^(0.000000675*$O13^3-0.0000771*$O13^2+0.01792*$O13+0.49239))/30,-14.927+1.1392*D12-0.0154*D12^2)","v":{"v":1.191738843310772,"d":"1.19"}},{"v":1.3796950225538962,"d":"1.38"},{"v":1.6344119527783814,"d":"1.63"},{"v":2.0684284661781196,"d":"2.07"},{"v":2.7236456108005944,"d":"2.72"},{"v":3.2484759053209964,"d":"3.25"},{"v":3.347802562366456,"d":"3.35"},{"v":3.029350768226093,"d":"3.03"},{"v":2.365314424180693,"d":"2.37"},{"v":1.5969817757608376,"d":"1.60"},{"v":1.1423854946411713,"d":"1.14"}]
[4,"Cf",{"v":25.176251850826407,"d":"25.18"},{"v":24.924433796500267,"d":"24.92"},{"v":30.70628689274669,"d":"30.71"},{"v":32.86477394112185,"d":"32.86"},{"v":36.722893943852846,"d":"36.72"},{"v":36.93704851551315,"d":"36.94"},{"v":37.570904176798045,"d":"37.57"},{"v":35.2436327913816,"d":"35.24"},{"v":31.128123820676404,"d":"31.13"},{"v":28.91996759263816,"d":"28.92"},{"v":25.19083325270026,"d":"25.19"},{"v":24.466406078948737,"d":"24.47"}]
["ETp (alternativa)"]
[{"$nulls":14}," "]
[5,"ETp",{"$f":"IF(C16=\"\",ROUND(C14*C15,0),ROUND(C16,0))","v":26},{"$f":"IF(D16=\"\",ROUND(D14*D15,0),ROUND(D16,0))","v":30},42,54,76,101,122,118,94,68,40,28,{"$f":"ROUND(SUM(C18:N18),0)","v":{"v":799,"d":"799.0"}}]
[6,"P",103,102,67,59,37,19,4,5,26,77,108,100,{"$f":"ROUND(SUM(C19:N19),0)","v":{"v":707,"d":"707.0"}}]
[7,"P-ETp",{"$f":"C19-C18","v":77},{"$f":"D19-D18","v":72},25,5,-39,-82,-118,-113,-68,9,68,72,{"$f":"ROUND(SUM(C20:N20),0)","v":{"v":-92,"d":"-92.0"}}]
[8,"L",{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=1,-$AZ$3,IF(C20>=0,-$C$8*LN(MIN((N24+C20),$C$8)/$C$8),N21+ABS(C20))),IF(AND(C20>0,D20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(C20)+N21))))","v":0},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=2,-$AZ$3,IF(D20>=0,-$C$8*LN(MIN((C24+D20),$C$8)/$C$8),C21+ABS(D20))),IF(AND(D20>0,E20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(D20)+C21))))","v":0},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=3,-$AZ$3,IF(E20>=0,-$C$8*LN(MIN((D24+E20),$C$8)/$C$8),D21+ABS(E20))),IF(AND(E20>0,F20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(E20)+D21))))","v":0},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=4,-$AZ$3,IF(F20>=0,-$C$8*LN(MIN((E24+F20),$C$8)/$C$8),E21+ABS(F20))),IF(AND(F20>0,G20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(F20)+E21))))","v":0},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=5,-$AZ$3,IF(G20>=0,-$C$8*LN(MIN((F24+G20),$C$8)/$C$8),F21+ABS(G20))),IF(AND(G20>0,H20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(G20)+F21))))","v":39},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=6,-$AZ$3,IF(H20>=0,-$C$8*LN(MIN((G24+H20),$C$8)/$C$8),G21+ABS(H20))),IF(AND(H20>0,I20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(H20)+G21))))","v":121},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=7,-$AZ$3,IF(I20>=0,-$C$8*LN(MIN((H24+I20),$C$8)/$C$8),H21+ABS(I20))),IF(AND(I20>0,J20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(I20)+H21))))","v":239},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=8,-$AZ$3,IF(J20>=0,-$C$8*LN(MIN((I24+J20),$C$8)/$C$8),I21+ABS(J20))),IF(AND(J20>0,K20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(J20)+I21))))","v":352},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=9,-$AZ$3,IF(K20>=0,-$C$8*LN(MIN((J24+K20),$C$8)/$C$8),J21+ABS(K20))),IF(AND(K20>0,L20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(K20)+J21))))","v":420},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=10,-$AZ$3,IF(L20>=0,-$C$8*LN(MIN((K24+L20),$C$8)/$C$8),K21+ABS(L20))),IF(AND(L20>0,M20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(L20)+K21))))","v":{"v":230.25850929940455,"d":"230"}},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=11,-$AZ$3,IF(M20>=0,-$C$8*LN(MIN((L24+M20),$C$8)/$C$8),L21+ABS(M20))),IF(AND(M20>0,N20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(M20)+L21))))","v":{"v":24.84613592984996,"d":"25"}},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=ABS($M$10),AND($K$10<ABS($M$10),$K$10>=$C$8)),IF($AX$3=12,-$AZ$3,IF(N20>=0,-$C$8*LN(MIN((M24+N20),C8)/$C$8),M21+ABS(N20))),IF(AND(N20>0,C20<0),-$C$8*LN(($K$10/$C$8)/(1-EXP($M$10/$C$8))),ABS(N20)+M21))))","v":0}]
[9,"l",{"$f":"IF(OR($K$10=0, C20>=0),\"\",C21/$C8)","v":""},{"$f":"IF(OR($K$10=0, D20>=0),\"\",D21/$C8)","v":""},"","",0.39,1.21,2.39,3.52,{"v":4.2,"d":"4.20"},"","",""]
[10,"a",{"$f":"IF(OR($K$10=0,C20>=0),\"\",EXP(-C22))","v":""},{"$f":"IF(OR($K$10=0,D20>=0),\"\",EXP(-D22))","v":""},"","",{"v":0.6770568744981647,"d":"0.68"},{"v":0.2981972794298874,"d":"0.30"},{"v":0.09162968387750484,"d":"0.09"},{"v":0.029599435167892,"d":"0.03"},{"v":0.014995576820477703,"d":"0.01"},"","",""]
[11,"A",{"$f":"IF($M$10=0,$C$8,ROUND(IF($K$10=0,0,IF(C23=\"\",MIN($C8,N24+C20),MIN($C8,C23*$C8))),0))","v":100},{"$f":"IF($M$10=0,$C$8,ROUND(IF($K$10=0,0,IF(D23=\"\",MIN($C8,C24+D20),MIN($C8,D23*$C8))),0))","v":100},100,100,68,30,9,3,1,10,78,100]
[12,"DA",{"$f":"C24-N24","v":0},{"$f":"D24-C24","v":0},{"$f":"E24-D24","v":0},0,-32,-38,-21,-6,-2,9,{"$f":"M24-L24","v":68},22,{"$f":"SUM(C25:N25)","v":{"v":0,"d":"0.0"}}]
[13,"ETr",{"$f":"IF(C20>=0,C18,C19+ABS(C25))","v":26},{"$f":"IF(D20>=0,D18,D19+ABS(D25))","v":30},{"$f":"IF(E20>=0,E18,E19+ABS(E25))","v":42},54,69,57,25,11,28,68,40,28,{"$f":"SUM(C26:N26)","v":{"v":478,"d":"478.0"}}]
[14,"D",{"$f":"C18-C26","v":0},{"$f":"D18-D26","v":0},0,0,7,44,97,107,66,0,0,0,{"$f":"SUM(C27:N27)","v":{"v":321,"d":"321.0"}}]
[15,"S",{"$f":"IF(C24=$C8,C20-C25,0)","v":77},{"$f":"IF(D24=$C8,D20-D25,0)","v":72},25,5,0,0,0,0,0,0,{"$f":"IF(M24=$C8,M20-M25,0)","v":0},{"$f":"IF(N24=$C8,N20-N25,0)","v":50},{"$f":"SUM(C28:N28)","v":{"v":229,"d":"229.0"}}]
[null,"Este método é desenvolvido no artigo \"Sobre o novo método de balanço hidrológico do solo de Thornthwaite-Mather.\" P. de Varennes e Mendonça (1958) [Anais do ISA XXII, 271-282]. Um extracto modificado deste método apresenta-se na folha seguinte deste livro de Excel"]
[null,null,"Fórmula para o cálculo do armazenamento de água (A):"]
[]
[]
[null,null,"Verificações:"]
[]
[{"$nulls":5},"Valores calculados",null,"Valores esperados"]
[]
[{"$nulls":5},{"$f":"O25","v":{"v":0,"d":"0.0"}},null,{"v":0,"d":"0.0"}]
[]
[]
[{"$nulls":5},{"$f":"O18+O20","v":{"v":707,"d":"707.0"}},null,{"$f":"O19","v":{"v":707,"d":"707.0"}}]
[]
[]
[{"$nulls":5},{"$f":"O26+O28","v":{"v":707,"d":"707.0"}},null,{"$f":"O19","v":{"v":707,"d":"707.0"}}]
[]
[]
[{"$nulls":5},{"$f":"O18-O26","v":{"v":321,"d":"321.0"}},null,{"$f":"O27","v":{"v":321,"d":"321.0"}}]

{"sheet":"ArtigoSobreMétodo","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"TomeApontamentosAqui","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}