{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Título","ComeçarAqui","ResumoMétodo","TomeApontamentosAqui"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Título","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ComeçarAqui","index":1,"n_rows":33,"n_cols":64,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,4,3,5],[31,2,31,4],[32,2,32,4],[32,5,32,7],[31,5,31,18],[29,4,29,6],[30,2,30,3],[30,4,30,15],[29,2,29,3],[6,6,6,7],[8,6,8,7],[8,3,8,5],[6,3,6,5]]}
["Entrar valores nas células com sombreado a verde. Para entrar com ETP alternativo, preencha as células a amarelo (linha 16) em vez das células a verde na linha 12. Depois prima o botão \"Classificar clima!\".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somas de P-ETP negativos:",null,null,null,{"$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]
["Note que os coeficientes na linha 15 (fator de correção da Etp) e valores de Etp atualizam-se só após premir o botão \"Classificar clima!\". Só então se pode tar o balanço e classificação atualizados!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mês com valor + negativo",null,null,null,{"$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}]
[null,null,null,"BALANÇO HÍDRICO PELO MÉTODO DE THORNTHWAITE-MATHER com evapotranspiração potencial calculada pelo método de Thornthwaite",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Match1:",{"$f":"MATCH(1,BA2:BL2,0)","v":9},"Value:",{"$f":"INDEX(BA1:BL2,1,AX3)","v":-420}]
[null,null,null,null,"Estação: ",null,"Tapada da Ajuda (Lisboa, Portugal)"]
[null,null,null,"º","'","''",null,null,null,"º","'","''"]
[null,null,"Latitude:",38,42,0,"N",null,"Long.:",9,11,0,"O",null,"Alt.:",50,"m"]
[null,null,null,"Período dos dados:",null,null,"1960  a 1990"]
[null,"U",100]
[null,null,null,"Versão pretendida:",null,null,"Revista"]
[null,null,null,null,null,null,null,null,null,"P=",{"$f":"SUMIF(C20:N20,\">0\")","v":328},"N=",{"$f":"SUMIF(C20:N20,\"<0\")","v":-420}]
[null,null,"J","F","M","A","M","J","J","A","S","O","N","D","Ano"]
[1,"T",11,11.9,13,14.4,16.600000000000001,19.600000000000001,21.8,22.2,20.9,18,14.2,11.6,{"$f":"AVERAGE(C12:N12)","v":16.266666666666666}]
[2,"i",{"$f":"(MAX(0,C12)/5)^1.514","v":3.2993465825915211},{"$f":"(MAX(0,D12)/5)^1.514","v":3.7165288890964709},4.2488328758353324,4.9604402919718389,6.1518120540433108,7.9110677802948501,9.2935693648815398,9.552956864944953,8.7188838184497239,6.9541168869011898,4.8565064160713423,3.5755990162998792,{"$f":"SUM(C13:N13)","v":73.239660841381948},"=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":1.0461789474825653},{"$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":1.1917388433107721},1.3796950225538962,1.6344119527783814,2.0684284661781196,2.7236456108005944,3.2484759053209964,3.3478025623664558,3.0293507682260929,2.3653144241806929,1.5969817757608376,1.1423854946411713]
[4,"Cf",25.176251850826407,24.924433796500267,30.706286892746689,32.864773941121847,36.722893943852846,36.937048515513148,37.570904176798045,35.2436327913816,31.128123820676404,28.919967592638159,25.190833252700259,24.466406078948737]
[null,"Etp\n(alternativo)",null,null,null,null,null,null,null,null,null,null,null,null,"Só preencher as células à esquerda se quiser ignorar os valores de ETP de Thornthwaite  e substituí-los pelos valores que colocar nestas células."]
[]
[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":799}]
[6,"P",103,102,67,59,37,19,4,5,26,77,108,100,{"$f":"ROUND(SUM(C19:N19),0)","v":707}]
[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":-92}]
[8,"L",{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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>=$M$10,AND($K$10<$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":230.25850929940455},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=$M$10,AND($K$10<$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":24.846135929849961},{"$f":"IF($K$10=0,\"\",IF($M$10=0,0,IF(OR($K$10>=$M$10,AND($K$10<$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,4.2,"","",""]
[10,"a",{"$f":"IF(OR($K$10=0,C20>=0),\"\",EXP(-C22))","v":""},{"$f":"IF(OR($K$10=0,D20>=0),\"\",EXP(-D22))","v":""},"","",0.67705687449816465,0.29819727942988739,9.1629683877504836E-2,2.9599435167891999E-2,1.4995576820477703E-2,"","",""]
[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":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":478}]
[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":321}]
[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":229}]
[]
[null,null,"Opção:",null,{"$f":"G9","v":"Revista"}]
[null,null,"Estação: ",null,{"$f":"G4","v":"Tapada da Ajuda (Lisboa, Portugal)"}]
[null,null,"Clima:",null,null,"Clima sub-húmido seco, mesotérmico, grande excesso de água no inverno, e com pequena concentração da eficiência térmica"]
[null,null,"Fórmula climática:",null,null,"C1 B'2 s2  a'",null,null,"Nota de formatação: os números que eventualmente sigam letras são colocados em subscrito."]

{"sheet":"ResumoMétodo","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TomeApontamentosAqui","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}