{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ETo (mensal)"],"not_rendered":{"images":3,"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"ETo (mensal)","index":0,"n_rows":53,"n_cols":14,"rows_kept":53}
["Evapotranspiração de referência de Penman-Monteith (Cálculo mensal)"]
["(Programado por José Paulo de Melo e Abreu, Prof. Do ISA, Ulisboa; jpabreu@isa.ulisboa.pt)"]
["Coloque os dados nas células a verde e ponteados. As células a verde que não estão ponteadas são optativas."]
["Os valores nas células cinzentas são valores tabelados."]
["Ra= radiação no topo da atmosfera (valor tabelado que entra com a latitude e o mês do ano)."]
["λ = calor latente de vaporização. Valor que varia muito pouco com a temperatura , pelo que se pode dar um valor único."]
["Tem de permitir a \"Activação de macros\", se lhe for pedido,  quando abre a folha de cálculo para poder trabalhar sem problemas."]
[]
[null,null,"Evapotranspiração de referência de Penman-Monteith"]
[null,"Estação: ","Lisboa/Tapada",{"$nulls":8},"Período:"," 1951/80"]
[null,"Latitude:",{"$f":"38+42/60","v":38.7},"Longitude: ",{"$f":"-(9+11/60)","v":{"v":-9.183333333333334,"d":"-9.2"}},{"$nulls":3},"Altitude: ",{"v":50,"d":"50.0"},"m","Alt. Anemómetro",{"v":6,"d":"6.0"},"m"]
[null,null,"Jan","Fev","Mar","Abr","Mai","Jun","Jul","Ago","Set","Out ","Nov","Dez"]
[1,"TM [ºC]",14.9,15.8,17.6,19.9,22.6,25.4,28.1,28.5,26.7,22.7,18.3,15.4]
[2,"Tm[ºC]",7.1,7.6,8.5,9.8,11.6,{"v":14,"d":"14.0"},15.8,16.1,15.1,13.2,9.9,7.6]
[3,"T [ºC]",{"$f":"AVERAGE(C13:C14)","v":{"v":11,"d":"11.0"}},{"$f":"AVERAGE(D13:D14)","v":11.7},{"v":13.05,"d":"13.1"},{"v":14.85,"d":"14.9"},17.1,19.7,{"v":21.950000000000003,"d":"22.0"},22.3,20.9,{"v":17.95,"d":"18.0"},{"v":14.100000000000001,"d":"14.1"},11.5]
[4,"T1 [ºC]",10.3,10.9,12.7,14.8,17.5,{"v":20,"d":"20.0"},21.9,21.9,20.6,17.7,13.5,10.8]
[5,"T2 [ºC]",11.9,12.9,13.4,15.4,17.6,20.4,23.4,23.3,{"v":22,"d":"22.0"},18.4,14.9,12.6]
[6,"RH1 [%]",{"v":87,"d":"87.0"},{"v":84,"d":"84.0"},{"v":82,"d":"82.0"},{"v":76,"d":"76.0"},{"v":73,"d":"73.0"},{"v":71,"d":"71.0"},{"v":69,"d":"69.0"},{"v":69,"d":"69.0"},{"v":74,"d":"74.0"},{"v":78,"d":"78.0"},{"v":81,"d":"81.0"},{"v":84,"d":"84.0"}]
[7,"RH2 [%]",{"v":81,"d":"81.0"},{"v":77,"d":"77.0"},{"v":73,"d":"73.0"},{"v":69,"d":"69.0"},{"v":67,"d":"67.0"},{"v":65,"d":"65.0"},{"v":61,"d":"61.0"},{"v":60,"d":"60.0"},{"v":66,"d":"66.0"},{"v":72,"d":"72.0"},{"v":74,"d":"74.0"},{"v":77,"d":"77.0"}]
[8,"es(TM)",{"$f":"calcSatVapPres(C13)","v":{"v":1.6921395600202804,"d":"1.692"}},{"$f":"calcSatVapPres(D13)","v":{"v":1.792848406364162,"d":"1.793"}},{"v":2.0101636101010003,"d":"2.010"},{"v":2.3212225246525184,"d":"2.321"},{"v":2.739459127199693,"d":"2.739"},{"v":3.241297569530141,"d":"3.241"},{"v":3.7993004866056235,"d":"3.799"},{"v":3.888697765991663,"d":"3.889"},{"v":3.500339474334162,"d":"3.500"},{"v":2.756137997295194,"d":"2.756"},{"v":2.1007141854498466,"d":"2.101"},{"v":1.7474573410161947,"d":"1.747"}]
[9,"es(Tm)",{"$f":"calcSatVapPres(C14)","v":{"v":1.0073962109398629,"d":"1.007"}},{"$f":"calcSatVapPres(D14)","v":{"v":1.0424653165664821,"d":"1.042"}},{"v":1.1083131740646783,"d":"1.108"},{"v":1.20990165102675,"d":"1.210"},{"v":1.3640828530361082,"d":"1.364"},{"v":1.5964337408003375,"d":"1.596"},{"v":1.792848406364162,"d":"1.793"},{"v":1.827567644430518,"d":"1.828"},{"v":1.7140793090833528,"d":"1.714"},{"v":1.515389849618084,"d":"1.515"},{"v":1.2180456812280105,"d":"1.218"},{"v":1.0424653165664821,"d":"1.042"}]
[10,"es(T1)",{"$f":"calcSatVapPres(C16)","v":{"v":1.2511070183007102,"d":"1.251"}},{"$f":"calcSatVapPres(D16)","v":{"v":1.3021818292852834,"d":"1.302"}},{"v":1.4665949921419839,"d":"1.467"},{"v":1.6812624714509439,"d":"1.681"},{"v":1.99751125696537,"d":"1.998"},{"v":2.3356530854155317,"d":"2.336"},{"v":2.625155749077102,"d":"2.625"},{"v":2.625155749077102,"d":"2.625"},{"v":2.4238965363077685,"d":"2.424"},{"v":2.022886162219199,"d":"2.023"},{"v":1.5453470465575703,"d":"1.545"},{"v":1.2935439232767727,"d":"1.294"}]
[11,"es(T2)",{"$f":"calcSatVapPres(C17)","v":{"v":1.3913951571762877,"d":"1.391"}},{"$f":"calcSatVapPres(D17)","v":{"v":1.485944523901755,"d":"1.486"}},{"v":1.5353039755558107,"d":"1.535"},{"v":1.7474573410161947,"d":"1.747"},{"v":2.0101636101010003,"d":"2.010"},{"v":2.3941634320113914,"d":"2.394"},{"v":2.875394080409349,"d":"2.875"},{"v":2.8580864139592155,"d":"2.858"},{"v":2.641225171002643,"d":"2.641"},{"v":2.1139374223336036,"d":"2.114"},{"v":1.6921395600202804,"d":"1.692"},{"v":1.4570036094837688,"d":"1.457"}]
[12,"es [KPa]",{"$f":"(C20+C21)/2","v":{"v":1.3497678854800716,"d":"1.350"}},{"$f":"(D20+D21)/2","v":{"v":1.4176568614653222,"d":"1.418"}},{"v":1.5592383920828392,"d":"1.559"},{"v":1.7655620878396343,"d":"1.766"},{"v":2.051770990117901,"d":"2.052"},{"v":2.418865655165239,"d":"2.419"},{"v":2.7960744464848926,"d":"2.796"},{"v":2.8581327052110908,"d":"2.858"},{"v":2.6072093917087575,"d":"2.607"},{"v":2.135763923456639,"d":"2.136"},{"v":1.6593799333389285,"d":"1.659"},{"v":1.3949613287913385,"d":"1.395"}]
[13,"e [KPa]",{"$f":"(C18/100*C22+C19/100*C23)/2","v":{"v":1.1077465916172056,"d":"1.108"}},{"$f":"(D18/100*D22+D19/100*D23)/2","v":{"v":1.1190050100019948,"d":"1.119"}},{"v":1.1616898978560841,"d":"1.162"},{"v":1.2417525218019456,"d":"1.242"},{"v":1.4024964181761952,"d":"1.402"},{"v":1.607259960726216,"d":"1.607"},{"v":1.7826739279564516,"d":"1.783"},{"v":1.7631046576193647,"d":"1.763"},{"v":1.7684460248647467,"d":"1.768"},{"v":1.549943075305585,"d":"1.550"},{"v":1.2519571910633198,"d":"1.252"},{"v":1.1042348374274955,"d":"1.104"}]
[14,"D [KPa]",{"$f":"C24-C25","v":{"v":0.24202129386286608,"d":"0.242"}},{"$f":"D24-D25","v":{"v":0.2986518514633274,"d":"0.299"}},{"v":0.3975484942267551,"d":"0.398"},{"v":0.5238095660376887,"d":"0.524"},{"v":0.6492745719417057,"d":"0.649"},{"v":0.8116056944390233,"d":"0.812"},{"v":1.013400518528441,"d":"1.013"},{"v":1.095028047591726,"d":"1.095"},{"v":0.8387633668440109,"d":"0.839"},{"v":0.5858208481510541,"d":"0.586"},{"v":0.4074227422756087,"d":"0.407"},{"v":0.290726491363843,"d":"0.291"}]
[15,"n [h]"]
[16,"N [h]"]
[17,"n/N",0.44,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},{"v":0.6,"d":"0.60"},0.66,0.69,{"v":0.8,"d":"0.80"},{"v":0.8,"d":"0.80"},0.68,0.58,0.52,0.48]
[18,"Ra  [MJ m-2 d-1]",{"v":16.5,"d":"16.50"},{"v":21.7,"d":"21.70"},{"v":28.6,"d":"28.60"},35.25,{"v":40.1,"d":"40.10"},{"v":42.2,"d":"42.20"},{"v":40.9,"d":"40.90"},{"v":37.3,"d":"37.30"},{"v":31.1,"d":"31.10"},{"v":24.2,"d":"24.20"},{"v":17.9,"d":"17.90"},{"v":14.6,"d":"14.60"}]
[19,"Rns  [MJ m-2 d-1]",{"$f":"0.77*(0.25+0.5*C29)*C30","v":5.97135},{"$f":"0.77*(0.25+0.5*D29)*D30","v":8.3545},11.011000000000001,14.928375,17.90866,19.333930000000002,20.470450000000003,18.66865,14.128730000000003,10.062360000000002,7.029329999999999,5.50858]
[20,"f",{"$f":"(0.9*C29+0.1)","v":0.496},{"$f":"(0.9*D29+0.1)","v":{"v":0.55,"d":"0.550"}},{"v":0.55,"d":"0.550"},{"v":0.64,"d":"0.640"},{"v":0.6940000000000001,"d":"0.694"},0.721,{"v":0.8200000000000001,"d":"0.820"},{"v":0.8200000000000001,"d":"0.820"},{"v":0.7120000000000001,"d":"0.712"},0.622,{"v":0.5680000000000001,"d":"0.568"},0.532]
[21,"s (TM4+Tm4)/2 [MJ m-2 d-1]",{"$f":"4.9*10^-9*((C13+273)^4+(C14+273)^4)/2","v":31.912481046130097},{"$f":"4.9*10^-9*((D13+273)^4+(D14+273)^4)/2","v":32.231910428725854},32.85660624479266,33.70251710760057,34.779446581084265,36.04741264826632,37.18100992963138,37.359159513392584,36.644443783990496,35.16928380046057,33.333903200671294,32.137683452245845]
[22,null,{"$f":"-(1-(0.6+0.14*C25^0.5))","v":-0.25265064236415136},{"$f":"-(1-(0.6+0.14*D25^0.5))","v":-0.25190375360584216},-0.24910559321837256,-0.24399246996597213,-0.23420214176216447,-0.22251114054613508,-0.2130764621885557,-0.2141052682582436,-0.21382389496138599,-0.22570460626858357,-0.24335274996080825,-0.25288438963325843]
[23,"Rnl  [MJ m-2 d-1]",{"$f":"C32*C34*C33","v":-3.9991035825263324},{"$f":"D32*D34*D33","v":-4.465636572585833},-4.501620414363358,-5.262822651618492,-5.652922089743351,-5.783105600416201,-6.4963664062508,-6.559010153004296,-5.578845881393516,-4.9373547375230995,-4.607557502140505,-4.323627022873569]
[24,"Rn  [MJ m-2 d-1]",{"$f":"C35+C31","v":1.9722464174736678},{"$f":"D35+D31","v":3.888863427414167},6.509379585636643,9.665552348381508,12.25573791025665,13.550824399583801,13.974083593749203,12.109639846995703,8.549884118606487,5.125005262476902,2.421772497859494,1.1849529771264313]
[25,"   D  [kPa k-1]",{"$f":"calcSlope(C15)","v":{"v":0.08758103,"d":"0.088"}},{"$f":"calcSlope(D15)","v":{"v":0.09113585799,"d":"0.091"}},{"$f":"calcSlope(E15)","v":{"v":0.09836416545375,"d":"0.098"}},{"$f":"calcSlope(F15)","v":{"v":0.10881389809875,"d":"0.109"}},{"v":0.12329077953,"d":"0.123"},{"v":0.14216432279,"d":"0.142"},{"v":0.16052596692125004,"d":"0.161"},{"v":0.16356195541000002,"d":"0.164"},{"v":0.15171227266999998,"d":"0.152"},{"v":0.12919770002125,"d":"0.129"},{"v":0.10434285183000001,"d":"0.104"},{"v":0.09010707625,"d":"0.090"}]
[26,"   D Rn",{"$f":"C37*C36","v":0.17273137265615382},{"$f":"D37*D36","v":0.3544149050633222},0.6402896905628254,1.0517464283049192,1.5110194806709156,1.9264437740130393,2.2432032807249676,1.9806763726854706,1.2971223506989298,0.6621388925088184,0.2526946489101222,0.10677264826259586]
[27,"Tv [K]",{"$f":"(273+C15)*(1+0.38*C25/101.3)","v":285.18013832346816},{"$f":"(273+D15)*(1+0.38*D25/101.3)","v":285.895070839211},287.2965402784507,289.1908353019967,291.6262428444907,294.4647492240053,296.9223975964391,297.25306047433463,295.8496899205226,292.64164122753067,288.44833194107235,285.67846819619234]
[28,"P [kPa]",{"$f":"101.3*(1-0.000022*50)^5.26","v":100.71524984286593},{"$f":"101.3*(1-0.000022*50)^5.26","v":100.71524984286593},100.71524984286593,100.71524984286593,100.71524984286593,100.71524984286593,100.71524984286593,100.71524984286593,100.71524984286593,100.71524984286593,100.71524984286593,100.71524984286593]
[29,"   r [kg m-3]",{"$f":"3.486*C40/C39","v":1.2311283773696744},{"$f":"3.486*D40/D39","v":1.2280497174072915},1.222059133089272,1.2140542440966025,1.2039155239518367,1.192310325352889,1.1824414857023273,1.1811261434684024,1.1867288454706466,1.1997382172937356,1.2171793769428216,1.2289808299837075]
[30,"cp [MJ kg-1 k-1]",{"$f":"1.013*10^-3","v":{"v":1.013E-3,"d":"0.0010"}},{"$f":"1.013*10^-3","v":{"v":1.013E-3,"d":"0.0010"}},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"},{"v":1.013E-3,"d":"0.0010"}]
[31,"u [m s-1]",2.111111111111111,2.388888888888889,2.111111111111111,2.138888888888889,2.138888888888889,2.25,2.4444444444444446,2.4166666666666665,2.0555555555555554,1.9444444444444444,1.9722222222222223,2.111111111111111]
[32,"u(2) [m s-1]",{"$f":"C43*5/(4.4+LN(6-0.07))","v":1.7080120063825872},{"$f":"D43*5/(4.4+LN(6-0.07))","v":1.932750428275033},1.7080120063825872,1.730485848571832,1.730485848571832,1.82038121732881,1.9776981126535222,1.9552242704642773,1.663064322004098,1.5731689532471198,1.5956427954363643,1.7080120063825872]
[33,"ra [d m-1]",{"$f":"230*10^-5/C44","v":{"v":1.3465947495715732E-3,"d":"0.0013"}},{"$f":"230*10^-5/D44","v":{"v":1.1900139647376693E-3,"d":"0.0012"}},{"v":1.3465947495715732E-3,"d":"0.0013"},{"v":1.3291065060706435E-3,"d":"0.0013"},{"v":1.3291065060706435E-3,"d":"0.0013"},{"v":0.00126347161688197,"d":"0.0013"},{"v":0.001162968192811813,"d":"0.0012"},{"v":1.1763356433039031E-3,"d":"0.0012"},{"v":1.3829892022626969E-3,"d":"0.0014"},{"v":0.001462017156677708,"d":"0.0015"},{"v":1.4414253657385856E-3,"d":"0.0014"},{"v":1.3465947495715732E-3,"d":"0.0013"}]
[34,"   r cp D / ra",{"$f":"C41*C42*C26/C45","v":0.22414520298312401},{"$f":"D41*D42*D26/D45","v":0.3122040614522616},0.3654726333658111,0.4846867845065829,0.5957637446097924,0.7758510381568436,1.0437641810280573,1.1137807679404055,0.7290907847824164,0.4869768240013778,0.3485115197849285,0.2687832768323585]
[35,"  l  [MJ kg-1]",2.475,2.473,{"v":2.47,"d":"2.470"},2.465,2.461,2.454,2.449,2.449,2.451,2.458,2.468,2.473]
[36," g  [ kPa K-1]",{"$f":"0.00163*C40/C47","v":0.0663296392904531},{"$f":"0.00163*D40/D47","v":0.06638328234689506},0.06646390981533257,0.06659872504822371,0.0667069716553724,0.0668972523406159,0.06703383309263841,0.06703383309263841,0.06697913392242817,0.06678838781280368,0.06651777035813268,0.06638328234689506]
[37,null,{"$f":"C47*(C37+C48*(1+0.34*C44))","v":0.47626397326548303},{"$f":"D47*(D37+D48*(1+0.34*D44))","v":0.49742398855785985},{"$f":"E47*(E37+E48*(1+0.34*E44))","v":0.5024604126862455},0.5289815916022125,0.5641739412121237,0.6146442160086965,0.6676819222853525,0.6738626493209906,0.6288388867830317,0.5695424180278515,0.5107470384653697,0.48233572358173304]
[38,"ETP [mm d-1]",{"$f":"(C38+C46)/C49","v":0.8333121922242217},{"$f":"(D38+D46)/D49","v":1.340142377226834},2.0016747559308135,2.9045116828316413,3.734279574760754,4.396518736835635,4.922954107402428,4.592118503294355,3.2221498671096827,2.017612174505328,1.1771114140993975,0.7786193448541354]
[39,"ETP [mm mês-1]",{"$f":"C50*31","v":25.832677958950875},{"$f":"D50*28.25","v":37.85902215665806},{"$f":"E50*31","v":62.051917433855216},{"$f":"F50*30","v":87.13535048494924},115.76266681758338,{"$f":"H50*30","v":131.89556210506905},152.61157732947527,142.355673602125,{"$f":"K50*30","v":96.66449601329047},62.54597740966517,{"$f":"M50*30","v":35.313342422981925},24.137199690478198]
[]
[null,"Eq. 6 (FAO 56)",{"$f":"(0.408*C36*C37/(C37+C48*(1+0.34*C44)))+900*C44/(273+C15)*C26*C48/(C37+C48*(1+0.34*C44))","v":0.8177820143435235},{"$f":"(0.408*D36*D37/(D37+D48*(1+0.34*D44)))+900*D44/(273+D15)*D26*D48/(D37+D48*(1+0.34*D44))","v":1.3211175346973039},1.9822088655945915,2.879169455768564,3.703522819743297,4.351453936109236,4.860629739317951,4.526602638190863,3.1778966160053654,1.9876248881201204,1.1532297011898558,0.75800409414648]