{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Ex3 Cal. Rad., vpd, frost days","RADIATION CALCULATIONS ","3-PG function tools"," "],"not_rendered":{"charts":19,"images":0,"macros":1,"external_links":1,"defined_names":102,"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":"Instructions","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,2,6,2]]}
[]
[]
[null,"EXERCISE 3           If mean monthly (av. daily) temperature extremes are   available, it is possible to predict three climatic  variables used in the 3-PG model.            See directions Ex 3: Cal. Rad, vpd, frost days"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Reference: Coops, Waring, Moncrieff. 2000 Estimating mean monthly incident solar radiation on horizontal and inclined slopes from mean monthly temperature extremes. Journal of Biometeorology 44:204-211"]
[]
[]
[null,null,null,null,"Running, S.W., Nemani, R.R. and Hungerford, R.D., 1987. Extrapolation of synoptic meteorological data in mountainous terrain and its use for simulating forest evapotranspiration and photosynthesis. Canadian Journal of Forest Research, 17(6), pp.472-483"]

{"sheet":"Ex3 Cal. Rad., vpd, frost days","index":1,"n_rows":55,"n_cols":30,"rows_kept":55,"cut":false,"hidden":false,"merged":[[38,1,39,1]]}
["Predicting Climatic Variables from mean monthly temperature extremes"]
[]
["EXERCISE 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUGENE, OR"]
[null,"If mean monthly (av. daily) temperature extremes are",null,null,null,null,null,null,"Eugene Oregon. 44.12 oN Latitude, 123.22 oW. Long., Elevation 150 m",null,null,null,null,null,null,null,"VARIABLES","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Annual"]
[null,"available, it is possible to predict three climatic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avg. Temperature",4.9000000000000004,6.8,8.6,10.3,13.2,16.7,19.600000000000001,19.8,17.100000000000001,12.3,7.8,5.0999999999999996,11.8]
[null,"variables used in the 3-PG model.",null,null,null,null,null,null,"Temp. oC","Temp., oC","Rad. Predicted","Rad. Observed","Predicted","Observed","Predicted","Observed ","Avg. Max Temperature",8,10.8,13.3,15.8,19.5,23.4,27.6,27.7,24.6,18.100000000000001,11.3,7.9,17.3]
[null,null,null,null,null,null,null,"Month","Mean Max","Mean Min ","MJ/m2/day","MJ/m2/day","VPD, mb (62% max VPD)","VPD, 24hr, mb","day <2oC","days <0oC","Avg. Min Temperature",1.8,2.8,3.8,4.8,6.9,9.8000000000000007,11.6,11.8,9.6,6.4,4.3,2.2000000000000002,6.3]
["SOLAR RAD","1) copy Mean Max and Min temperatures",null,null,null,null,null,"Jan",8,1.8,2.2000000000000002,4.6800000000000006,2.3381540665431406,4.6255876547168802,8,14,"Avg. Relative Humidity",66.5,86,81.5,77,74.5,72.5,68.5,63.5,64,68,78,85.5,87.5]
[null,"from the adjacent table and insert them",null,null,null,null,null,"Feb",10.8,2.8,5.2,7.2,3.3989696644017702,6.4245816013305452,6,10,"Mean Sat. VP",{"$f":"6.1078*EXP((17.269*R7)/(237.3+R7))","v":6.9557709093486926},{"$f":"6.1078*EXP((17.269*S7)/(237.3+S7))","v":7.4704437224773788},8.0184488432868708,8.6016219272005419,9.9493911696913724,12.115143042928455,13.658874587284284,13.840628945264886,11.953478130074494,9.6126661580878174,8.3055214918163678,7.1577543103620513,9.5465392998906733]
[null,"under the same columns labels on the Radiation",null,null,null,null,null,"Mar",13.3,3.8,10.3,11.16,4.4977388849260906,6.5350358072787991,4,7,"Mean VPD at mean T",{"$f":"R9*R8/100","v":4.6255876547168802},{"$f":"S9*S8/100","v":6.4245816013305452},6.5350358072787991,6.6232488839444166,7.4122964214200726,8.7834787061231303,9.3563290922897355,8.7887993802432032,7.6502260032476759,6.5366129874997156,6.4783067636167662,6.1198799353595543,8.3532218874043398]
[null,"Calculation page. After inserting Elevation (150 m)",null,null,null,null,null,"Apr",15.8,4.8,16.8,15.840000000000002,5.7961025395510637,6.6232488839444166,2,2]
[null,"and Latitude (+44.12), Insert Months, 1 through 12",null,null,null,null,null,"May",19.5,6.9,21.4,19.8,7.8845067370265918,7.4122964214200726,0,0]
[null,"and copy values into the Rad. Predicted column",null,null,null,null,null,"Jun",23.4,9.8000000000000007,23.2,22.32,10.330833222478445,8.7834787061231303,0,0]
[null,"in the adjacent table.",null,null,null,null,null,"Jul",27.6,11.6,23.2,24.12,14.423610969513108,9.3563290922897355,0,0]
[null,"Fit linear relation to trend line and determine slope (forced through zero)",null,null,null,null,null,"Aug",27.7,11.8,19.899999999999999,20.88,14.444949936538524,8.7887993802432032,0,0]
[null," and derive r2.",null,null,null,null,null,"Sep",24.6,9.6,14,15.840000000000002,11.763518726118647,7.6502260032476759,0,0.5]
[null,null,null,null,null,null,null,"Oct",18.100000000000001,6.4,7.6,9.7200000000000006,6.9162290104574904,6.5366129874997156,0,2]
["VPD","2) Go to 3-PG function tools and substitute",null,null,null,null,null,"Nov",11.3,4.3,3,5.04,3.1524848368538794,6.4783067636167662,3,7]
[null,"mean max and min monthly temperatures into",null,null,null,null,null,"Dec",7.9,2.2000000000000002,1.6,3.6,2.1677660406790911,6.1198799353595543,7.1999999999999993,11]
[null,"tables to solve for mean daily vapor pressure deficits "]
[null,"(vpd) each month; insert values in adjacent table"]
[null,"Fit linear relation to trend line and determine slope (not forced through zero)"]
[null," and r2 ."]
["FROST DAYS"]
[null,"3) Go to 3-PG function tools and substitute"]
[null,"mean min monthly tempertures into "]
[null,"table to solve for No. of frost days (<-2o C each month;"]
[null,"insert values in adjacent table."]
[null,"Fit linear relation to trend line and determine slope (forced through zero)"]
[null," and r2."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["82. Coops, N.C., R.H. Waring, and J. Moncrieff. 2000. Estimating mean monthly incident solar radiation on horizontal and inclined slopes from mean monthly temperature extremes. Journal of Biometeorology 44:204-211.pdf."]
["Thornton, P.E., S.W. Running,  and M.A. White. 1997. Predicting surface daily"]
["meteorlogical variables over large regions of complex terrain. J. Hydrology 19:214-251."]

{"sheet":"RADIATION CALCULATIONS ","index":2,"n_rows":133,"n_cols":68,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[null,null,"INSTRUCTIONS"]
[null,null,"Feb. 2, 2001"]
[null,null,"This spreadsheet contains a program for estimating short-wave incoming radiation from mean monthly maximum and "]
[null,null,"minimum temperature data (in degrees C).  Convert ( degrees F-32)*5/9"]
[null,null,"RADIATION CALCULATIONS",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,13.522222222222224,-3.2955092592592585]
[null,null,"The radiation calculations require the average of every day max and min temperatures each month be inserted in columns C and D",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,14.9,-1.9046934865900651E-2]
[null,null,"The other essential input parameters are elevation, Lat (- in southern hemisphere), slope in degrees, and aspect (0=N, 180=S), and Month (1=January)",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,18.288888888888891,7.3677568697730136E-2]
[null,null,"Longitude and Meridian are not essential",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,21.222222222222225,5.2572685185185195]
[null,"1954 n",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,28.777777777777779,10.754719235364394]
[null,"110 long","The output parameters are self-explanatory.  Below are given information on sunrise, sunset, and daylenght for flat surfaces.",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,27.944444444444443,14.067322530864198]
[null,"39.1 Lat ",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,30.555555555555557,17.290583930704898]
[null,null,"REFERENCE : Coops, N.C., R.H. Waring, and J.B. Moncrieff. 2000. Estimating mean monthly incident solar radiation on horizontal and inclined slopes from mean monthly temperature extremes. International Journal of Biometeorology 44:204-211.",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,29.277777777777782,16.381242532855435]
[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,27.5,11.232152777777777]
[null,null,"Note: I have substituted a equation that differs from that in the paper to adjust for changes in clear sky transmittance based on changes in partial pressure with increases in elevation above sea level.  [Clear Sky Transmittance = (Elev.(m)*0.0001+1.0143)",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,24.055555555555554,5.1651209677419354]
[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,13.555555555555555,-4.92701851851852]
[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,12.4,-5.1927150537634397]
[null,"YEAR","MONTH","TMAX24H","TMIN24H","Diff Temp.","Max. Clear Sky Transmittance","B","Clear Sky Tranmittance","Solar Declination","Latitude","Aspect","Slope","Zenith Angle Correction","AM","Day length (for 44) (HR)",null,"SOLCON","I (Wm-2)","Integrated I (MJ day)","For the Day in MJ","Df","EFT","HRAD","GLOBF","DIFL (Wm2)","DIFL (Day) in Mj","Integrated Difuse","Total Integrated Daily Radiation (MJ m2 ) day",null,null,null,"Measured Rad"]
[13.522222222222224,-3.2955092592592585,"[ENTER DATA IN COL. C,D, F, & Below] 1",8,1.8,{"$f":"D18-E18","v":6.2},{"$f":"($D$31*0.0001+1.0142)*0.65","v":0.66897999999999991},{"$f":"0.031+0.201 * EXP(-0.185 * F18)","v":9.4835209301696061E-2},{"$f":"G18*(1-EXP(-(H18*F18^1.5)))","v":0.51424716107229029},-20.2,{"$f":"$D$35","v":44.12},{"$f":"$D$37","v":0},{"$f":"$D$36","v":0},{"$f":"(((SIN(K18*PI()/180)*COS(0*PI()/180))*(-1*COS(L18*PI()/180)*SIN(M18*PI()/180))-SIN(0*PI()/180)*(SIN(L18*PI()/180)*SIN(M18*PI()/180))+((COS(K18*PI()/180)*COS(0*PI()/180))*COS(M18*PI()/180)))*COS(J18*PI()/180))+(((COS(K18*PI()/180)*(COS(L18*PI()/180)*SIN(M18*PI()/180))+SIN(K18*PI()/180)*COS(M18*PI()/180)))*SIN(J18*PI()/180))","v":0.43334452295718717},{"$f":"IF($N18>0,1/($N18+0.0000001),0)","v":2.3076321870014209},9.2250540528775478,{"$f":"P18*60*60","v":33210.194590359177},1.36,{"$f":"IF($O18>0,(R18*I18^O18)*1000*N18,0)","v":127.01739651034431},{"$f":"(((Q18*2)/PI())*S18)/1000000","v":2.6854356497487117},{"$f":"(S18*Q18)/1000000","v":4.2182724544693437},{"$f":"((((N18*R18*Q18)^2)*G18^O18)^0.5) * (1 - ((((N18*R18*Q18)^2)*G18^O18)^0.5)/(N18*R18*Q18))","v":4568.0618702397378},{"$f":"S18*N18","v":55.042293098039046},{"$f":"W18*I18^O18","v":11.862808100195608},{"$f":"SQRT(X18*W18)","v":25.553006876231972},{"$f":"(1-(Y18/W18)) * Y18","v":13.690198776036363},{"$f":"(Z18*Q18)/1000000","v":0.45465416533286462},{"$f":"(((Q18*2)/PI())*Z18)/1000000","v":0.28944183124018097},{"$f":"AB18+T18","v":2.9748774809888925},{"$f":"AC18*30","v":89.246324429666771},{"$f":"AC18*0.8","v":2.3799019847911143},4.3893238821879397]
[14.9,-1.9046934865900651E-2,2,10.8,2.8,8,0.66897999999999991,7.6755175365146366E-2,{"$f":"G19*(1-EXP(-(H19*F19^1.5)))","v":0.55118064396864319},-12.65,44.12,0,0,0.54800127718374081,1.8248129322943425,10.330966976042664,37191.481113753587,1.36,251.32190773379739,5.9505066478134925,9.3470339849540487,5897.5282871130694,137.72472642237523,46.443162725702472,79.977321039074738,33.534158313372266,1.2471850155774076,0.79398264071714753,6.74448928853064,202.33467865591919,5.3955914308245125,7.26]
[18.288888888888891,7.3677568697730136E-2,3,13.3,3.8,9.5,0.66897999999999991,6.5667578328295367E-2,0.57117810019881354,-1.95,44.12,0,0,0.69377901288838395,1.4413809545760732,11.748778654906333,42295.603157662794,1.36,420.89639652890151,11.33314781452323,17.802066958076697,7513.0195238184815,292.00908651209915,130.26012986103993,195.03112964260265,64.770999781562708,2.7395285028860399,1.7440380119018117,13.07718582642504,392.31557479275119,10.461748661140033,11.08]
[21.222222222222225,5.2572685185185195,4,15.8,4.8,11,0.66897999999999991,5.7266776983309037E-2,0.58617423951529535,9.4499999999999993,44.12,0,0,0.82244200238083343,1.2158910604225708,13.233272327209262,47639.780377953342,1.36,584.2382183969471,17.719025654731833,27.832980412837301,9048.5127400607998,480.50205020579585,250.98109987914623,347.27069132714814,96.289591448001858,4.5872149892656626,2.9203117622674633,20.639337416999297,619.1801225099789,16.511469933599439,14.82]
[28.777777777777779,10.754719235364394,5,19.5,6.9,12.6,0.66897999999999991,5.0536898494795077E-2,0.5991919411305705,18.350000000000001,44.12,0,0,0.90054653444876576,1.1104366634073435,14.490859080326844,52167.092689176636,1.36,693.49950992627873,23.031536677986264,36.17785321422275,10224.289010170496,624.52858030602772,353.63350754999169,469.95130856168203,116.31780101169029,6.067961506778051,3.8629842731802895,26.894520951166552,806.83562853499654,21.515616760933241,20.100000000000001]
[27.944444444444443,14.067322530864198,6,23.4,9.8000000000000007,13.599999999999998,0.66897999999999991,4.7237200032208347E-2,0.6063900682368184,22.55,44.12,0,0,0.92996910799274912,1.0753044201951651,15.152003158490965,54547.211370567471,1.36,738.58380658771182,25.647938135316714,40.287687012818239,10803.218603641841,686.86012379026351,401.10738187764304,524.88538365024647,123.7780017726034,6.7517448257166732,4.2982942540317435,29.946232389348459,898.38697168045383,23.956985911478768,21]
[30.555555555555557,17.290583930704898,7,27.6,11.6,16,0.66897999999999991,4.1415602351717894E-2,0.62174403306206338,20.75,44.12,0,0,0.91796244601992949,1.0893690644958944,14.861457814571917,53501.248132458903,1.36,743.92767103896472,25.338141070185259,39.801058920857912,10551.765679224232,682.89766456883751,406.93263215989566,527.15590117046258,120.22326901056699,6.4320949466297019,4.0947988207700714,29.432939890955332,882.98819672866,23.546351912764266,22.92]
[29.277777777777782,16.381242532855435,8,27.7,11.8,15.899999999999999,0.66897999999999991,4.1610084407481832E-2,0.62115082721250225,13.45,44.12,0,0,0.86011947336467931,1.1626290471313496,13.780403149570841,49609.451338455023,1.36,672.45401792303778,21.237683275953717,33.360074879501504,9573.1195969026994,578.39079575792584,332.49588692708608,438.53456035527535,106.03867342818928,5.2605204094300797,3.3489513055863935,24.58663458154011,737.59903744620328,19.66930766523209,19.52]
[27.5,11.232152777777777,9,24.6,9.6,15.000000000000002,0.66897999999999991,4.3532244814624352E-2,0.61563611896254633,2.9,44.12,0,0,0.75218493706411138,1.3294601071873842,12.373868069861375,44545.925051500948,1.36,536.75775142309658,15.221814666763912,23.910370565705438,8180.0467729951442,403.74109547285582,211.84476743586669,292.45587440629259,80.611106970425894,3.5908963294231175,2.2860356038329286,17.50785027059684,525.23550811790517,14.006280216477473,13.56]
[24.055555555555554,5.1651209677419354,10,18.100000000000001,6.4,11.700000000000001,0.66897999999999991,5.4076272106052731E-2,0.59214861297459676,-8.4499999999999993,44.12,0,0,0.60779171096914464,1.6453002195035602,10.900238531288743,39240.85871263947,1.36,349.03894630815955,8.7195187203130295,13.696587977287043,6561.6943883914601,212.14297837150372,89.579548558757566,137.85380746439168,48.274258905634113,1.8943233731733657,1.2059637146202171,9.9254824349332473,297.7644730479974,7.9403859479465986,8.6999999999999993]
[13.555555555555555,-4.92701851851852,11,11.3,4.3,7.0000000000000009,0.66897999999999991,8.6053470730620557E-2,0.53306610186895598,-17.850000000000001,44.12,0,0,0.46993380868915913,2.12795880763194,9.5842379556244683,34503.256640248088,1.36,167.56255068349628,3.6805877317805513,5.7814536895272495,5003.4134642179724,78.743307636365671,20.645006170264161,40.319425492184017,19.674419321919856,0.67883153911205663,0.43215757990545234,4.1127453116860035,123.3823593505801,3.2901962493488028,5]
[12.4,-5.1927150537634397,12,7.9,2.2000000000000002,5.7,0.66897999999999991,0.10102167997728297,0.49979475828726155,-22.35,44.12,0,0,0.39922918577574457,2.5048262630756022,8.8808759482208242,31971.15341359497,1.36,95.562328531499418,1.945024834807793,3.0552378660409314,4150.3940093763404,38.151270610464714,6.7148225252663423,16.005593124363752,9.2907705990974101,0.29703665215426095,0.18909940587927404,2.1341242406870671,64.023727220612017,1.7072993925496538,4.18]
["Month","List  output  D46","Input parameters"]
["Jan",2.2000000000000002,"Elevation",150,"meters",null,null,null,null,"Solar Declination","Latitude","Aspect","Slope",8,1.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(From Campbell and Norman. 1998. An Introduction to Environmental Biophysics. 2nd Edition. Springer Verlag. (Eq. 3.7, p. 41)."]
["Feb",5.2,"Mean Solar Constant",1360,"Wm-2",null,null,null,null,null,null,null,null,10.8,2.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pa (kPa) =101.3exp(-Elev.(m)/8200)"]
["Mar",10.3,"Standard Meridian",120,"degrees",null,null,null,null,null,null,null,null,13.3,3.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pa, kPa",null,null,null,"Fractional","PREDICTED"]
["Apr",16.8,"Longitude",110,"degrees",null,null,null,null,null,null,null,null,15.8,4.8,null,null,null,null,null,null,null,null,null,null,null,null,"Elevation,m",null,"Ratio (-Elev/8200)","EXP","EXP*101.3",null,"Ratio to SL","1-Ratio","Increase in Transmissivity above Sea Level"]
["May",21.4,"Latitude",44.12,"degrees",null,null,null,null,null,null,null,null,19.5,6.9,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"(-AB35/8200)","v":0},{"$f":"EXP(AD35)","v":1},{"$f":"AE35*101.3","v":101.3},{"$f":"101.3*EXP((-AB35/8200))","v":101.3},{"$f":"AG35/101.3","v":1},{"$f":"1-AH35","v":0},{"$f":"1+AI35","v":1},{"$f":"0.0001*AB35+1.0142","v":1.0142}]
["Jun",23.2,"Slope",0,"degrees",null,null,null,null,null,null,null,null,23.4,9.8000000000000007,null,null,null,null,null,null,null,null,null,null,null,null,500,null,-6.097560975609756E-2,0.94084618696413957,95.307718739467333,95.307718739467333,0.94084618696413957,5.9153813035860425E-2,1.0591538130358604,1.0642]
["Jul",23.2,"Aspect",0,"degrees from N",null,{"$f":"IF($D$37>180,-1*($D$37-180),180-$D$37)","v":180},null,null,null,null,null,null,27.6,11.6,null,null,null,null,null,null,null,null,null,null,null,null,1000,null,-0.12195121951219512,0.88519154752496065,89.669903764278516,89.669903764278516,0.88519154752496065,0.11480845247503935,1.1148084524750392,1.1142000000000001]
["Aug",19.899999999999999,"Month",12,null,null,null,null,null,null,null,null,null,27.7,11.8,null,null,null,null,null,null,null,null,null,null,null,null,1500,null,-0.18292682926829268,0.83282909222174517,84.365587042062785,84.365587042062785,0.83282909222174517,0.16717090777825483,1.1671709077782548,1.1641999999999999]
["Sep",14,null,null,null,null,null,null,null,null,null,null,null,24.6,9.6,"21 Feb. 2001 Note: ",null,null,null,null,null,null,null,null,null,null,null,2000,null,-0.24390243902439024,0.78356407580963472,79.375040879515993,79.375040879515993,0.78356407580963472,0.21643592419036528,1.2164359241903653,1.2141999999999999]
["Oct",7.6,"Derived parameters",null,null,null,null,null,null,null,null,null,null,18.100000000000001,6.4," Formula for Clear Sky Transmissivity",null,null,null,null,null,null,null,null,null,null,null,2500,null,-0.3048780487804878,0.73721327296757477,74.679704551615316,74.679704551615316,0.73721327296757466,0.26278672703242534,1.2627867270324253,1.2642]
["Nov",3,"Transmissivity",{"$f":"INDEX($I18:$I29,Month)","v":0.49979475828726155},null,null,null,null,null,null,null,null,null,11.3,4.3,"(Elev *0.0001+1.0143)*0.65",null,null,null,"(formula modified from original, see calculations to right, RHW)",null,null,null,null,null,null,null,3000,null,-0.36585365853658536,0.6936042968508962,70.262115270995778,70.262115270995778,0.6936042968508962,0.3063957031491038,1.3063957031491038,1.3142]
["Dec",1.6,"Integrated Solar (Month)",{"$f":"BP83","v":46.004975157721816},"MJ m-2",null,null,null,null,null,null,null,null,7.9,2.2000000000000002,"New Formula for B",null,null,null,null,null,null,null,null,null,null,null,3500,null,-0.42682926829268292,0.6525749579541088,66.105843240751213,66.105843240751213,0.65257495795410869,0.34742504204589131,1.3474250420458913,1.3642000000000001,"Hartman, D.L. 1994. Global Physical Climatology. Academic Press. 411 p."]
[null,null,"Integrated Solar (15th of Month)",{"$f":"AX83","v":1.4451010215670288},"MJ m-2",null,null,null,null,null,null,null,null,null,null,"0.031+0.201EXP(-0.185 Temp.Diff)",null,null,null,null,null,null,null,null,null,null,null,4000,null,-0.48780487804878048,0.61397266089940694,62.195430549109922,62.195430549109922,0.61397266089940694,0.38602733910059306,1.3860273391005931,1.4142000000000001,"Kaufmann, M.R. and Weatherred, J.D. 1982. Determination of potential direct solar irradiance. "]
[null,null,"Ratio (Daily/Monthly)",{"$f":"D43/D42","v":3.1411842232556282E-2},null,null,null,null,null,null,null,null,null,null,null,"[Coops, N.C., R.H. Waring, and J.B. Moncreiff. 2000. Estimating mean monthly incident solar radiation on horizontal and inclined slopes from mean monthly temperature extremes. Int. J. Biometerology 44:204-211.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Research Paper RM-242. Rocky Mt. Forest & Range Expt. Station. USDA. Fort Collins, Co."]
[null,null,"Total Monthly Solar (Direct+Diffuse)",{"$f":"$D42+30*INDEX($AB18:$AB29,Month)","v":51.677957334100036},"MJ m-2",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,"Hungerford, R.D., Nemani, R.R., Running, S.W. and Coughlan, J.C. 1989. MTCLIM: a mountain"]
[null,null,"Total Daily Solar (15th, Direct+Diffuse)",{"$f":"D43+INDEX($AB18:$AB29,Month)","v":1.6342004274463029},"MJ m-2",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,"Julian day for February 29+ is ignored in calculation",null,null,null,null,null,null,"      microclimate simulation model. USDA Intermoutain Res. Station , Paper INT 414."]
[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,"Months 4,6,9,11 have 30 days",null,null,null,null,null,null,"      (eq. 8 in appendix D..)"]
[null,null,"Day of Month               >>",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,null,"Source of Equations used"]
[null,null,"Julian date",{"$f":"ROUND(IF($D$38=1,31*($D$38-1)+D$48-0.4*$D$38-1.8+2,IF($D$38=2,31*($D$38-1)+D$48-0.4*$D$38-1.8+3,31*($D$38-1)+D$48-0.4*$D$38-1.8)),0)","v":335},336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,{"$f":"IF($D$38=2,0,ROUND(IF($D$38=1,31*($D$38-1)+AF$48-0.4*$D$38-1.8+2,IF($D$38=2,31*($D$38-1)+AF$48-0.4*$D$38-1.8+3,31*($D$38-1)+AF$48-0.4*$D$38-1.8)),0))","v":363},{"$f":"IF($D$38=2,0,ROUND(IF($D$38=1,31*($D$38-1)+AG$48-0.4*$D$38-1.8+2,IF($D$38=2,31*($D$38-1)+AG$48-0.4*$D$38-1.8+3,31*($D$38-1)+AG$48-0.4*$D$38-1.8)),0))","v":364},{"$f":"IF($D$38=2,0,ROUND(IF($D$38=1,31*($D$38-1)+AH$48-0.4*$D$38-1.8+2,IF($D$38=2,31*($D$38-1)+AH$48-0.4*$D$38-1.8+3,31*($D$38-1)+AH$48-0.4*$D$38-1.8)),0))","v":365},null,"Equn. 2 in Kaufmann + Weatherred (1982)"]
[null,null,"Time of Year (radians)",{"$f":"2*PI()*D$49/365","v":5.7667591175483874},5.7839733238694278,5.8011875301904672,5.8184017365115075,5.8356159428325469,5.8528301491535872,5.8700443554746267,5.887258561795667,5.9044727681167073,5.9216869744377467,5.938901180758787,5.9561153870798265,5.9733295934008668,5.9905437997219062,6.0077580060429474,6.0249722123639859,6.0421864186850271,6.0594006250060657,6.0766148313271069,6.0938290376481472,6.1110432439691866,6.1282574502902269,6.1454716566112664,6.1626858629323067,6.1799000692533461,6.1971142755743864,6.2143284818954259,6.2315426882164662,6.2487568945375065,6.2659711008585459,6.2831853071795871,null,"Equn. A.5 in Hartmann (1994)"]
[null,null,"mean Earth-Sun distance (squared ratio)",{"$f":"1.00011+0.034221*COS(D$50)+0.00128*SIN(D$50)+0.000719*COS(2*D$50)+0.000077*SIN(2*D$50)","v":1.0295384560091587},1.0298665955290185,1.0301856289066051,1.0304954420077264,1.0307959237956565,1.0310869663868354,1.0313684651051676,1.0316403185348906,1.0319024285719605,1.0321547004739211,1.032397042908213,1.0326293679988878,1.0328515913716867,1.0330636321974487,1.0332654132338195,1.0334568608652155,1.0336379051410225,1.0338084798119924,1.0339685223648114,1.0341179740548059,1.0342567799367697,1.0343848888938787,1.0345022536646713,1.0346088308680765,1.0347045810264657,1.0347894685867089,1.0348634619392201,1.0349265334349751,1.0349786594004879,1.0350198201507328,1.03505,null,"Equn. A.7 in Hartmann (1994)"]
[null,null,"Solar input at top of Atmos",{"$f":"Solar_Constant*D$51","v":1400.1723001724558},1400.6185699194652,1401.0524553129831,1401.4738011305078,1401.8824563620929,1402.2782742860961,1402.6611125430279,1403.0308332074512,1403.3873028578662,1403.7303926445327,1404.0599783551697,1404.3759404784873,1404.6781642654939,1404.9665397885301,1405.2409619979944,1405.5013307766931,1405.7475509917906,1405.9795325443097,1406.1971904161435,1406.400444714536,1406.5892207140068,1406.7634488956751,1406.9230649839531,1407.0680099805841,1407.1982301959933,1407.3136772779242,1407.4143082373394,1407.5000854715661,1407.5709767846636,1407.6269554049966,1407.6680000000001]
[null,null,"delta (Solar declination)",{"$f":"23.5*SIN((0.9863*(284+D$49))*PI()/180)","v":-22.154770891229404},-22.286386634698804,-22.411398459172503,-22.529769321051869,-22.641464144593289,-22.746449832301934,-22.844695274739149,-22.936171359740893,-23.020850981044262,-23.098709046319637,-23.169722484606041,-23.233870253147561,-23.291133343628765,-23.341494787807232,-23.384939662541615,-23.42145509421367,-23.451030262542975,-23.473656403793232,-23.489326813369082,-23.498036847802879,-23.499783926130615,-23.494567530656703,-23.482389207107417,-23.463252564172826,-23.437163272437484,-23.404129062700111,-23.3641597236828,-23.317267099130415,-23.263465084301028,-23.2027696218485,-23.135198697098314,null,"Equn. 3 in Kaufmann& Weatherred (1982)"]
[null,null,"Sunrise",{"$f":"12-(((ACOS(-TAN((Latitude*PI())/180)*TAN((D$53*PI()/180)))*180/PI()/15)))","v":7.5504524805941751},7.5612661015464315,7.571568335937461,7.5813516057381145,7.5906086241725328,7.5993324143284102,7.6075163273173017,7.615154059891859,7.6222396714271259,7.6287676001742666,7.6347326786968974,7.6401301484030473,7.6449556730891892,7.6492053514171934,7.6528757282501143,7.6559638047785876,7.6584670473761154,7.6603833951287488,7.6617112659923343,7.6624495615388577,7.6625976702619401,7.662155469420636,7.6611233254098288,7.6595020926548658,7.6572931110374727,7.6544982018692034,7.6511196624378641,7.6471602591611489,7.6426232193901589,7.6375122219135365,7.6318313862203926,null,"Equns. 7&8 in Kaufmann& Weatherred (1982)"]
[null,null,"Sunset",{"$f":"12+(((ACOS(-TAN((Latitude*PI())/180)*TAN((D$53*PI()/180)))*180/PI()/15)))","v":16.449547519405826},16.43873389845357,16.42843166406254,16.418648394261886,16.409391375827468,16.400667585671592,16.392483672682697,16.384845940108143,16.377760328572876,16.371232399825733,16.365267321303101,16.359869851596955,16.355044326910811,16.350794648582806,16.347124271749884,16.344036195221413,16.341532952623886,16.339616604871253,16.338288734007666,16.337550438461143,16.337402329738062,16.337844530579364,16.338876674590171,16.340497907345135,16.342706888962528,16.345501798130798,16.348880337562136,16.352839740838853,16.35737678060984,16.362487778086464,16.368168613779609,null,"Equns 7&8 in Kaufmann& Weatherred (1982)"]
[null,null,"Daylength",{"$f":"(((ACOS(-TAN((Latitude*PI())/180)*TAN((D$53*PI()/180)))*180/PI()/15)))*2","v":8.8990950388116499},8.8774677969071369,8.8568633281250779,8.837296788523771,8.8187827516549344,8.8013351713431796,8.7849673453653967,8.769691880216282,8.7555206571457482,8.7424647996514668,8.7305346426062052,8.7197397031939055,8.7100886538216216,8.7015892971656132,8.6942485434997714,8.6880723904428248,8.6830659052477692,8.6792332097425025,8.6765774680153314,8.6751008769222846,8.6748046594761199,8.6756890611587281,8.6777533491803425,8.6809958146902684,8.6854137779250546,8.6910035962615932,8.6977606751242718,8.7056794816777021,8.7147535612196823,8.724975556172927,8.7363372275592148]
[null,null,"(NB Equation of time has NOT been implemented yet)",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,"Daily Integral"]
[null,null,"Direct radiation (Wm-2)",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,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,null,"Hour  v                                 1",{"$f":"IF(D110>0,D$52*Transmissivity^D110*D85,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Month=2,0,IF(AF110>0,AF$52*Transmissivity^AF110*AF85,0))","v":0},0,{"$f":"IF(Month=2,0,IF(Month=4,0,IF(Month=6,0,IF(Month=9,0,IF(Month=11,0,IF(AH110>0,AH$52*Transmissivity^AH110*AH85,0))))))","v":0},null,{"$f":"D59*3600","v":0},{"$f":"E59*3600","v":0},{"$f":"F59*3600","v":0},{"$f":"G59*3600","v":0},{"$f":"H59*3600","v":0},{"$f":"I59*3600","v":0},{"$f":"J59*3600","v":0},{"$f":"K59*3600","v":0},{"$f":"L59*3600","v":0},{"$f":"M59*3600","v":0},{"$f":"N59*3600","v":0},{"$f":"O59*3600","v":0},{"$f":"P59*3600","v":0},{"$f":"Q59*3600","v":0},{"$f":"R59*3600","v":0},{"$f":"S59*3600","v":0},{"$f":"T59*3600","v":0},{"$f":"U59*3600","v":0},{"$f":"V59*3600","v":0},{"$f":"W59*3600","v":0},{"$f":"X59*3600","v":0},{"$f":"Y59*3600","v":0},{"$f":"Z59*3600","v":0},{"$f":"AA59*3600","v":0},{"$f":"AB59*3600","v":0},{"$f":"AC59*3600","v":0},{"$f":"AD59*3600","v":0},{"$f":"AE59*3600","v":0},{"$f":"AF59*3600","v":0},{"$f":"AG59*3600","v":0},{"$f":"AH59*3600","v":0}]
[null,null,2,{"$f":"IF(D111>0,D$52*Transmissivity^D111*D86,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,3,{"$f":"IF(D112>0,D$52*Transmissivity^D112*D87,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,4,{"$f":"IF(D113>0,D$52*Transmissivity^D113*D88,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,5,{"$f":"IF(D114>0,D$52*Transmissivity^D114*D89,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,6,{"$f":"IF(D115>0,D$52*Transmissivity^D115*D90,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,7,{"$f":"IF(D116>0,D$52*Transmissivity^D116*D91,0)","v":5.2937401859107419E-2},4.5809185570708122E-2,3.9773316820548896E-2,3.4665400807655046E-2,3.0344956477837425E-2,2.6692341489169973E-2,2.3605991450565404E-2,2.0999961459850561E-2,1.8801753986775752E-2,1.6950414369861798E-2,1.5394873504695162E-2,1.4092516555026094E-2,1.300795656730123E-2,1.2111992564882689E-2,1.1380732899422322E-2,1.0794866216963501E-2,1.0339064246390445E-2,1.00015026485337E-2,9.7734883060422491E-3,9.6491836363441722E-3,9.6254207387441344E-3,9.701600422241401E-3,9.8796733944304053E-3,1.0164203123133309E-2,1.0562512114849975E-2,1.1084915592222288E-2,1.174504879836568E-2,1.2560296404832902E-2,1.3552334738320874E-2,1.4747799742349041E-2,1.6179095711673704E-2,null,190.5746466927867,164.91306805454923,143.18394055397602,124.79544290755817,109.24184332021473,96.092429361011909,84.981569222035461,75.599861255462017,67.686314352392714,61.021491731502472,55.421544616902587,50.733059598093938,46.828643642284426,43.603173233577685,40.970638437920364,38.861518381068606,37.220631287005602,36.005409534721316,35.1845579017521,34.73706109083902,34.651514659478885,34.925761520069045,35.56682421994946,36.591131243279911,38.025043613459907,39.905696132000237,42.282175674116445,45.217067057398445,48.788405057955146,53.092079072456549,58.244744562025332]
[null,null,8,{"$f":"IF(D117>0,D$52*Transmissivity^D117*D92,0)","v":14.971266776676325},14.555966387226619,14.168293047884779,13.80729866140555,13.47208335546715,13.16179653964528,12.875637801391374,12.612857655755642,12.372758163739912,12.154693434110882,11.958070023265204,11.782347247319203,11.627037420018066,11.491706029327268,11.375971864701665,11.2795071060377,11.20203738421432,11.143341821935017,11.103253062306782,11.081657291249828,11.078494258433446,11.093757299994227,11.127493364823554,11.179803044725993,11.250840607258628,11.340814028579388,11.449985022168713,11.578669057857725,11.727235364211291,11.896106905987134,12.085760327136558,null,53896.560396034773,52401.47899401583,51005.854972385205,49706.27518105998,48499.50007968174,47382.46754272301,46352.296085008944,45406.28756072031,44541.929389463679,43756.896362799176,43049.052083754737,42416.450090349128,41857.334712065036,41370.141705578164,40953.49871292599,40606.225581735722,40327.334583171549,40116.030558966064,39971.711024304415,39893.966248499382,39882.579330360408,39937.526279979218,40058.976113364792,40247.290961013576,40503.026186131057,40826.930502885793,41219.946079807363,41683.208608287809,42218.047311160648,42825.984861553683,43508.737177691612]
[null,null,9,{"$f":"IF(D118>0,D$52*Transmissivity^D118*D93,0)","v":57.904896801367251},57.023164787160674,56.192573201123011,55.412365038679873,54.681811744132077,54.000215603086346,53.366911984143513,52.781271430446218,52.242701602151314,51.750649071273081,51.304600970647563,50.904086498987098,50.54867828414524,50.237993606778105,49.971695486588466,49.749493633272557,49.571145264158623,49.436455790340553,49.34527937287713,49.297519350348118,49.293128538747531,49.33210940435638,49.414514109877452,49.540444433748831,49.710051562180425,49.923535753095273,50.181145870810234,50.483178789960661,50.829978666885218,51.221936076428591,51.659487011911686,null,208457.62848492211,205283.39323377842,202293.26352404285,199484.51413924753,196854.52227887546,194400.77617111083,192120.88314291666,190012.5771496064,188073.72576774473,186302.33665658309,184696.56349433123,183254.71139635355,181975.24182292286,180856.77698440116,179898.10375171847,179098.17707978122,178456.12295097104,177971.24084522598,177643.00574235767,177471.06966125322,177455.26273949113,177595.59385568296,177892.25079555882,178345.59996149578,178956.18562384954,179724.72871114299,180652.12513491683,181739.44364385837,182987.92320078678,184398.96987514294,185974.15324288208]
[null,null,10,{"$f":"IF(D119>0,D$52*Transmissivity^D119*D94,0)","v":98.28355647133705},97.141306860388852,96.062741723280553,95.047306864073036,94.094464429948673,93.203695425418232,92.374502091921002,91.606410149923178,90.898970901065638,90.251763188319927,89.664395212478468,89.136506203619959,88.667767946477895,88.257886158871017,87.906601722552594,87.613691765995796,87.378970598753398,87.202290497122249,87.083542340905254,87.022656101100736,87.019601178366599,87.074386592110599,87.187061020045292,87.357712688036386,87.586469110053812,87.873496678025802,88.219000101396631,88.623221696198172,89.086440523480434,89.608971377002192,90.191163620166463,null,353820.80329681339,349708.70469739987,345825.87020380999,342170.30471066292,338740.07194781525,335533.30353150563,332548.20753091562,329783.07653972344,327236.2952438363,324906.34747795173,322791.82276492246,320891.42233303183,319203.96460732043,317728.39017193567,316463.76620118931,315409.29035758489,314564.29415551224,313928.24578964012,313500.75242725894,313281.56196396262,313270.56424211978,313467.79173159815,313873.41967216303,314487.76567693101,315311.28879619372,316344.58804089291,317588.40036502789,319043.59810631344,320711.18588452955,322592.2969572079,324688.18903259927]
[null,null,11,{"$f":"IF(D120>0,D$52*Transmissivity^D120*D95,0)","v":114.02656946601},112.80292639781224,111.6468539572427,110.55786876904664,109.53549993527852,108.57929154043582,107.68880502735735,106.86362144026285,106.1033435317507,105.4075977309754,104.77603597060477,104.20833737048703,103.70420977627006,103.26339115147957,102.88565082180151,102.57079057052027,102.31864558423993,102.129085248168,102.0020137903666,101.93737077448193,101.9351314405549,101.99530689359179,102.11794413964202,102.30312596919515,102.55097068777063,102.86163169364315,103.23529690272206,103.67218802068844,104.17255966260049,104.73669832029958,105.36492117809796,null,410495.650077636,406090.53503212408,401928.6742460737,398008.32756856788,394327.7997670027,390885.44954556896,387679.69809848646,384709.03718494624,381972.03671430249,379467.35183151142,377193.72949417715,375150.01453375333,373335.15519457223,371748.20814532647,370388.34295848542,369254.84605387296,368347.12410326378,367664.70689340477,367207.24964531977,366974.53478813497,366966.47318599763,367183.10481693043,367624.5989027113,368291.25348910253,369183.49447597429,370301.8740971153,371647.0688497994,373219.87687447836,375021.21478536178,377052.11395307851,379313.71624115267]
[null,null,12,{"$f":"IF(D121>0,D$52*Transmissivity^D121*D96,0)","v":98.28355647133705},97.141306860388852,96.062741723280553,95.047306864073036,94.094464429948673,93.203695425418232,92.374502091921002,91.606410149923178,90.898970901065638,90.251763188319927,89.664395212478468,89.136506203619959,88.667767946477895,88.257886158871017,87.906601722552594,87.613691765995796,87.378970598753398,87.202290497122249,87.083542340905254,87.022656101100736,87.019601178366599,87.074386592110599,87.187061020045292,87.357712688036386,87.586469110053812,87.873496678025802,88.219000101396631,88.623221696198172,89.086440523480434,89.608971377002192,90.191163620166463,null,353820.80329681339,349708.70469739987,345825.87020380999,342170.30471066292,338740.07194781525,335533.30353150563,332548.20753091562,329783.07653972344,327236.2952438363,324906.34747795173,322791.82276492246,320891.42233303183,319203.96460732043,317728.39017193567,316463.76620118931,315409.29035758489,314564.29415551224,313928.24578964012,313500.75242725894,313281.56196396262,313270.56424211978,313467.79173159815,313873.41967216303,314487.76567693101,315311.28879619372,316344.58804089291,317588.40036502789,319043.59810631344,320711.18588452955,322592.2969572079,324688.18903259927]
[null,null,13,{"$f":"IF(D122>0,D$52*Transmissivity^D122*D97,0)","v":57.904896801367251},57.023164787160674,56.192573201123011,55.412365038679873,54.681811744132077,54.000215603086346,53.366911984143513,52.781271430446218,52.242701602151314,51.750649071273081,51.304600970647563,50.904086498987098,50.54867828414524,50.237993606778105,49.971695486588466,49.749493633272557,49.571145264158623,49.436455790340553,49.34527937287713,49.297519350348118,49.293128538747531,49.33210940435638,49.414514109877452,49.540444433748831,49.710051562180425,49.923535753095273,50.181145870810234,50.483178789960661,50.829978666885218,51.221936076428591,51.659487011911686,null,208457.62848492211,205283.39323377842,202293.26352404285,199484.51413924753,196854.52227887546,194400.77617111083,192120.88314291666,190012.5771496064,188073.72576774473,186302.33665658309,184696.56349433123,183254.71139635355,181975.24182292286,180856.77698440116,179898.10375171847,179098.17707978122,178456.12295097104,177971.24084522598,177643.00574235767,177471.06966125322,177455.26273949113,177595.59385568296,177892.25079555882,178345.59996149578,178956.18562384954,179724.72871114299,180652.12513491683,181739.44364385837,182987.92320078678,184398.96987514294,185974.15324288208]
[null,null,14,{"$f":"IF(D123>0,D$52*Transmissivity^D123*D98,0)","v":14.971266776676325},14.555966387226619,14.168293047884779,13.80729866140555,13.47208335546715,13.16179653964528,12.875637801391374,12.612857655755642,12.372758163739912,12.154693434110882,11.958070023265204,11.782347247319203,11.627037420018066,11.491706029327268,11.375971864701665,11.2795071060377,11.20203738421432,11.143341821935017,11.103253062306782,11.081657291249828,11.078494258433446,11.093757299994227,11.127493364823554,11.179803044725993,11.250840607258628,11.340814028579388,11.449985022168713,11.578669057857725,11.727235364211291,11.896106905987134,12.085760327136558,null,53896.560396034773,52401.47899401583,51005.854972385205,49706.27518105998,48499.50007968174,47382.46754272301,46352.296085008944,45406.28756072031,44541.929389463679,43756.896362799176,43049.052083754737,42416.450090349128,41857.334712065036,41370.141705578164,40953.49871292599,40606.225581735722,40327.334583171549,40116.030558966064,39971.711024304415,39893.966248499382,39882.579330360408,39937.526279979218,40058.976113364792,40247.290961013576,40503.026186131057,40826.930502885793,41219.946079807363,41683.208608287809,42218.047311160648,42825.984861553683,43508.737177691612]
[null,null,15,{"$f":"IF(D124>0,D$52*Transmissivity^D124*D99,0)","v":5.2937401859107419E-2},4.5809185570708122E-2,3.9773316820548896E-2,3.4665400807655046E-2,3.0344956477837425E-2,2.6692341489169973E-2,2.3605991450565404E-2,2.0999961459850561E-2,1.8801753986775752E-2,1.6950414369861798E-2,1.5394873504695162E-2,1.4092516555026094E-2,1.300795656730123E-2,1.2111992564882689E-2,1.1380732899422322E-2,1.0794866216963501E-2,1.0339064246390445E-2,1.00015026485337E-2,9.7734883060422491E-3,9.6491836363441722E-3,9.6254207387441344E-3,9.701600422241401E-3,9.8796733944304053E-3,1.0164203123133309E-2,1.0562512114849975E-2,1.1084915592222288E-2,1.174504879836568E-2,1.2560296404832902E-2,1.3552334738320874E-2,1.4747799742349041E-2,1.6179095711673704E-2,null,190.5746466927867,164.91306805454923,143.18394055397602,124.79544290755817,109.24184332021473,96.092429361011909,84.981569222035461,75.599861255462017,67.686314352392714,61.021491731502472,55.421544616902587,50.733059598093938,46.828643642284426,43.603173233577685,40.970638437920364,38.861518381068606,37.220631287005602,36.005409534721316,35.1845579017521,34.73706109083902,34.651514659478885,34.925761520069045,35.56682421994946,36.591131243279911,38.025043613459907,39.905696132000237,42.282175674116445,45.217067057398445,48.788405057955146,53.092079072456549,58.244744562025332]
[null,null,16,{"$f":"IF(D125>0,D$52*Transmissivity^D125*D100,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,17,{"$f":"IF(D126>0,D$52*Transmissivity^D126*D101,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,18,{"$f":"IF(D127>0,D$52*Transmissivity^D127*D102,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,19,{"$f":"IF(D128>0,D$52*Transmissivity^D128*D103,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,20,{"$f":"IF(D129>0,D$52*Transmissivity^D129*D104,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,21,{"$f":"IF(D130>0,D$52*Transmissivity^D130*D105,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,22,{"$f":"IF(D131>0,D$52*Transmissivity^D131*D106,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,23,{"$f":"IF(D132>0,D$52*Transmissivity^D132*D107,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,24,{"$f":"IF(D133>0,D$52*Transmissivity^D133*D108,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"For the Whole Month"]
[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,"Daily Integral",{"$f":"SUM(AJ59:AJ82)/1000000","v":1.6432267837265617},1.6212075150186211,1.600465019527658,1.580980106516324,1.5627344720663878,1.5457107288949701,1.5298924347546128,1.5152641194075571,1.5018113101450967,1.4895205558096425,1.4783794492694278,1.4683766482924188,1.4595018947664737,1.4517460322156237,1.4451010215670288,1.4395599551288387,1.4351170687451478,1.4317677521001386,1.4295085571489652,1.4283372046577472,1.4282525888392592,1.4292547800744912,1.4313450257133242,1.4345257489504699,1.4388005457755497,1.4441741799992225,1.4506525763606517,1.4582428117255126,1.4669531043884318,1.4767928014990324,1.4877723646366228,null,{"$f":"SUM(AJ83:BN83)","v":46.004975157721816}]
[null,"COS_theta","Hour v"]
[null,null,1,{"$f":"(SIN(D$53*PI()/180)*SIN(Latitude*PI()/180)*COS(D$53*PI()/180))-(SIN(D$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(D$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(D$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(D$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.81895088922063586},{"$f":"(SIN(E$53*PI()/180)*SIN(Latitude*PI()/180)*COS(E$53*PI()/180))-(SIN(E$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(E$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(E$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(E$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.81955256917135888},{"$f":"(SIN(F$53*PI()/180)*SIN(Latitude*PI()/180)*COS(F$53*PI()/180))-(SIN(F$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(F$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(F$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(F$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82011647414686673},{"$f":"(SIN(G$53*PI()/180)*SIN(Latitude*PI()/180)*COS(G$53*PI()/180))-(SIN(G$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(G$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(G$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(G$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82064359469709314},{"$f":"(SIN(H$53*PI()/180)*SIN(Latitude*PI()/180)*COS(H$53*PI()/180))-(SIN(H$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(H$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(H$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(H$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82113488135268964},{"$f":"(SIN(I$53*PI()/180)*SIN(Latitude*PI()/180)*COS(I$53*PI()/180))-(SIN(I$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(I$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(I$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(I$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82159124228307967},{"$f":"(SIN(J$53*PI()/180)*SIN(Latitude*PI()/180)*COS(J$53*PI()/180))-(SIN(J$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(J$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(J$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(J$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82201354107060809},{"$f":"(SIN(K$53*PI()/180)*SIN(Latitude*PI()/180)*COS(K$53*PI()/180))-(SIN(K$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(K$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(K$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(K$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82240259460437948},{"$f":"(SIN(L$53*PI()/180)*SIN(Latitude*PI()/180)*COS(L$53*PI()/180))-(SIN(L$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(L$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(L$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(L$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82275917109713959},{"$f":"(SIN(M$53*PI()/180)*SIN(Latitude*PI()/180)*COS(M$53*PI()/180))-(SIN(M$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(M$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(M$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(M$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82308398822831486},{"$f":"(SIN(N$53*PI()/180)*SIN(Latitude*PI()/180)*COS(N$53*PI()/180))-(SIN(N$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(N$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(N$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(N$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82337771141609428},{"$f":"(SIN(O$53*PI()/180)*SIN(Latitude*PI()/180)*COS(O$53*PI()/180))-(SIN(O$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(O$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(O$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(O$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82364095222119382},{"$f":"(SIN(P$53*PI()/180)*SIN(Latitude*PI()/180)*COS(P$53*PI()/180))-(SIN(P$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(P$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(P$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(P$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.8238742668847272},{"$f":"(SIN(Q$53*PI()/180)*SIN(Latitude*PI()/180)*COS(Q$53*PI()/180))-(SIN(Q$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(Q$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(Q$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(Q$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82407815500237014},{"$f":"(SIN(R$53*PI()/180)*SIN(Latitude*PI()/180)*COS(R$53*PI()/180))-(SIN(R$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(R$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(R$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(R$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82425305833678519},{"$f":"(SIN(S$53*PI()/180)*SIN(Latitude*PI()/180)*COS(S$53*PI()/180))-(SIN(S$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(S$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(S$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(S$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82439935977005363},{"$f":"(SIN(T$53*PI()/180)*SIN(Latitude*PI()/180)*COS(T$53*PI()/180))-(SIN(T$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(T$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(T$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(T$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82451738239764216},{"$f":"(SIN(U$53*PI()/180)*SIN(Latitude*PI()/180)*COS(U$53*PI()/180))-(SIN(U$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(U$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(U$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(U$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82460738876521233},{"$f":"(SIN(V$53*PI()/180)*SIN(Latitude*PI()/180)*COS(V$53*PI()/180))-(SIN(V$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(V$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(V$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(V$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82466958024937709},{"$f":"(SIN(W$53*PI()/180)*SIN(Latitude*PI()/180)*COS(W$53*PI()/180))-(SIN(W$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(W$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(W$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(W$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82470409658328436},{"$f":"(SIN(X$53*PI()/180)*SIN(Latitude*PI()/180)*COS(X$53*PI()/180))-(SIN(X$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(X$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(X$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(X$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82471101552770687},{"$f":"(SIN(Y$53*PI()/180)*SIN(Latitude*PI()/180)*COS(Y$53*PI()/180))-(SIN(Y$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(Y$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(Y$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(Y$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82469035268810598},{"$f":"(SIN(Z$53*PI()/180)*SIN(Latitude*PI()/180)*COS(Z$53*PI()/180))-(SIN(Z$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(Z$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(Z$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(Z$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82464206147792707},{"$f":"(SIN(AA$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AA$53*PI()/180))-(SIN(AA$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AA$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AA$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AA$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.8245660332281799},{"$f":"(SIN(AB$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AB$53*PI()/180))-(SIN(AB$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AB$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AB$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AB$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82446209744314936},{"$f":"(SIN(AC$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AC$53*PI()/180))-(SIN(AC$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AC$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AC$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AC$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82433002220186957},{"$f":"(SIN(AD$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AD$53*PI()/180))-(SIN(AD$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AD$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AD$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AD$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82416951470479716},{"$f":"(SIN(AE$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AE$53*PI()/180))-(SIN(AE$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AE$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AE$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AE$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82398022196489529},{"$f":"(SIN(AF$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AF$53*PI()/180))-(SIN(AF$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AF$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AF$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AF$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82376173164214284},{"$f":"(SIN(AG$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AG$53*PI()/180))-(SIN(AG$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AG$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AG$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AG$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.82351357302026129},{"$f":"(SIN(AH$53*PI()/180)*SIN(Latitude*PI()/180)*COS(AH$53*PI()/180))-(SIN(AH$53*PI()/180)*COS(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180))+(COS(AH$53*PI()/180)*COS(Latitude*PI()/180)*COS(Slope*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AH$53*PI()/180)*SIN(Latitude*PI()/180)*SIN(Slope*PI()/180)*COS(Aspect*PI()/180)*COS(((12-$C86)*15)*PI()/180))+(COS(AH$53*PI()/180)*SIN(Slope*PI()/180)*SIN(Aspect*PI()/180)*SIN(((12-$C86)*15)*PI()/180))","v":-0.8232352181242435}]
[null,null,2,-0.71328892029624547,-0.71398970731903588,-0.71464826241321888,-0.7152654678084116,-0.71584217102915637,-0.71637918265736078,-0.71687727420495273,-0.71733717610030967,-0.7177595757917834,-0.71814511597140518,-0.71849439292162831,-0.71880795498773109,-0.7190863011782791,-0.71932987989581798,-0.71953908779975273,-0.7197142688031426,-0.71985571320493125,-0.71996365695891396,-0.72003828108053303,-0.72007971119238223,-0.72008801720909066,-0.72006321316205424,-0.72000525716426922,-0.7199140515153204,-0.71978944294637071,-0.71963122300479043,-0.71943912857785852,-0.71921284255475937,-0.71895199462589221,-0.71865616221829254,-0.71832487156576252]
[null,null,3,-0.57558756144962075,-0.57641750732335739,-0.57719941285374032,-0.57793401910460163,-0.57862203936030876,-0.57926415702424217,-0.57986102361982628,-0.58041325689762591,-0.58092143905178506,-0.58138611504885829,-0.58180779107185476,-0.58218693308209046,-0.58252396550122154,-0.58281927001560829,-0.58307318450494572,-0.58328600209687431,-0.58345797034907765,-0.58358929056015563,-0.58368011721035673,-0.58373055753304171,-0.58374067121754702,-0.58371047024390665,-0.58363991884969024,-0.58352893362900782,-0.58337738376352766,-0.5831850913851504,-0.5829518320697753,-0.582677335461389,-0.5823612860255003,-0.58200332393073317,-0.58160304605718594]
[null,null,4,-0.41523093272390477,-0.41621128726521955,-0.41713683742094643,-0.41800815986387874,-0.41882581155238952,-0.41959032778732763,-0.42030222036254572,-0.42096197581251626,-0.42157005376026258,-0.42212688536861132,-0.4226328718975465,-0.42308838337022803,-0.42349375735001643,-0.42384929783062858,-0.42415527424133725,-0.42441192056891064,-0.42461943459778051,-0.42477797726971689,-0.4248876721640803,-0.42494860509951704,-0.42496082385775713,-0.42492433802997337,-0.42483911898595239,-0.42470509996613093,-0.4245221762963447,-0.42429020572493437,-0.42400900888165194,-0.42367836985760388,-0.42329803690526535,-0.42286772325738797,-0.42238710806342394]
[null,null,5,-0.24314707336489566,-0.24428883628828713,-0.24536853611466863,-0.246386573103519,-0.24734333645475531,-0.24823920253563309,-0.24907453319170422,-0.24984967414522929,-0.25056495348421726,-0.25122068024505145,-0.25181714309144065,-0.25235460909222168,-0.2528333226003226,-0.25325350423498399,-0.25361534996912766,-0.25391903032354801,-0.25416468966939854,-0.25435244564023618,-0.2544823886546842,-0.25455458155056915,-0.2545690593311859,-0.25452582902414295,-0.25442486965303868,-0.25426613232201911,-0.25404954041306704,-0.25377498989567143,-0.25344234974832353,-0.2530514624910869,-0.25260214482828303,-0.25209418840013037,-0.25152736064197279]
[null,null,6,-7.1063214005886666E-2,-7.2366385311354808E-2,-7.360023480839098E-2,-7.4764986343159423E-2,-7.5860861357121279E-2,-7.6888077283938649E-2,-7.7846846020862809E-2,-7.8737372477942491E-2,-7.9559853208172104E-2,-8.0314475121491757E-2,-8.1001414285334972E-2,-8.1620834814215532E-2,-8.2172887850628956E-2,-8.2657710639339604E-2,-8.3075425696918226E-2,-8.3426140078185579E-2,-8.3709944741016729E-2,-8.3926914010755638E-2,-8.4077105145288239E-2,-8.4160558001621449E-2,-8.4177294804614833E-2,-8.4127320018312718E-2,-8.4010620320125184E-2,-8.3827164677907434E-2,-8.3576904529789581E-2,-8.3259774066408637E-2,-8.2875690614995334E-2,-8.2424555124570087E-2,-8.1906252751300895E-2,-8.1320653542872962E-2,-8.0667613220521822E-2]
[null,null,7,8.9293414719829628E-2,8.7839834746783335E-2,8.646234062440325E-2,8.51608728975638E-2,8.3935366450798271E-2,8.2785751952976189E-2,8.1711957236418054E-2,8.0713908607167456E-2,7.9791532083350658E-2,7.8944754558755492E-2,7.8173504888973566E-2,7.747771489764721E-2,7.6857320300576459E-2,7.631226154564047E-2,7.5842484566690516E-2,7.54479414497784E-2,7.5128591010280743E-2,7.4884399279683433E-2,7.4715339900988387E-2,7.4621394431903521E-2,7.4602552555175283E-2,7.4658812195620816E-2,7.4790179543613E-2,7.4996668984969705E-2,7.5278302937393626E-2,7.5635111593807647E-2,7.6067132573128415E-2,7.6574410479215371E-2,7.7156996368934305E-2,7.7814947130472489E-2,7.8548324773240419E-2]
[null,null,8,0.22699477356645412,0.2254120347424616,0.22391119018388159,0.22249232160137361,0.22115549811964577,0.21990077758609464,0.21872820782154423,0.21763782780985105,0.21662966882334889,0.21570375548130222,0.21486010673874689,0.21409873680328761,0.21341965597763379,0.21282287142584999,0.21230838786149742,0.21187620815604657,0.21152633386613412,0.21125876567844154,0.21107350377116468,0.21097054809124388,0.21094989854671875,0.21101155511376835,0.21115551785819181,0.21138178687128212,0.21169036212023651,0.21208124321344751,0.21255442908121136,0.21310991757258557,0.2137477049693261,0.21446778541803169,0.2152701502818169]
[null,null,9,0.33265674249084443,0.33097489659478463,0.32937940191752935,0.32787044849005514,0.3264482084431789,0.32511283721181339,0.32386447468719959,0.32270324631392089,0.32162926412870491,0.32064262773821184,0.31974342523321292,0.31893173403675035,0.3182076216840819,0.31757114653240204,0.31702235839852977,0.31656129912295755,0.31618800305884492,0.31590249748473981,0.31570480294000852,0.31559493348214596,0.31557289686533502,0.31563869463981997,0.31579232217184955,0.31603376858414162,0.3163630166170151,0.3167800424105266,0.31728481520815,0.31787729698272132,0.31855744198557662,0.31932519622000044,0.32018049684029787]
[null,null,10,0.39907863292546308,0.397334485719394,0.39567949149015924,0.39411390836173327,0.39263797321727978,0.3912519028377891,0.3899558949923857,0.38875012947713794,0.38763476909939415,0.38660996060486197,0.38567583554485269,0.3848325110812939,0.38408009072732752,0.38341866502149446,0.38284831213370696,0.38236909840140904,0.38198107879451598,0.38168429730792214,0.38147878728056067,0.38136457164019166,0.38134166307328993,0.38141006411959866,0.38156976719110541,0.38182075451539382,0.382162998003514,0.38259645904271034,0.38312108821453961,0.38373682493910238,0.38444359704630832,0.38524132027528912,0.38612989770326794]
[null,null,11,0.42173390280455481,0.41996850578185374,0.41829321736347502,0.41670831889864651,0.41521406935635174,0.41381070644158535,0.41249844766454025,0.41127749135956415,0.41014801765091852,0.40911018936256238,0.40816415286938773,0.40731003888751605,0.40654796320147546,0.40587802732626488,0.40530031910250863,0.40481491322310476,0.40442187168995997,0.40412124419960299,0.40391306845666092,0.40379737041437613,0.40377416444153641,0.40384345341538452,0.40400522874026462,0.40425947029195847,0.40460614628785424,0.40504521308328667,0.4055766148945803,0.40620028344951759,0.40691613756615158,0.40772408266107529,0.40862401018845357]
[null,null,12,0.39907863292546308,0.397334485719394,0.39567949149015924,0.39411390836173327,0.39263797321727978,0.3912519028377891,0.3899558949923857,0.38875012947713794,0.38763476909939415,0.38660996060486197,0.38567583554485269,0.3848325110812939,0.38408009072732752,0.38341866502149446,0.38284831213370696,0.38236909840140904,0.38198107879451598,0.38168429730792214,0.38147878728056067,0.38136457164019166,0.38134166307328993,0.38141006411959866,0.38156976719110541,0.38182075451539382,0.382162998003514,0.38259645904271034,0.38312108821453961,0.38373682493910238,0.38444359704630832,0.38524132027528912,0.38612989770326794]
[null,null,13,0.33265674249084443,0.33097489659478463,0.32937940191752935,0.32787044849005514,0.3264482084431789,0.32511283721181339,0.32386447468719959,0.32270324631392089,0.32162926412870491,0.32064262773821184,0.31974342523321292,0.31893173403675035,0.3182076216840819,0.31757114653240204,0.31702235839852977,0.31656129912295755,0.31618800305884492,0.31590249748473981,0.31570480294000852,0.31559493348214596,0.31557289686533502,0.31563869463981997,0.31579232217184955,0.31603376858414162,0.3163630166170151,0.3167800424105266,0.31728481520815,0.31787729698272132,0.31855744198557662,0.31932519622000044,0.32018049684029787]
[null,null,14,0.22699477356645412,0.2254120347424616,0.22391119018388159,0.22249232160137361,0.22115549811964577,0.21990077758609464,0.21872820782154423,0.21763782780985105,0.21662966882334889,0.21570375548130222,0.21486010673874689,0.21409873680328761,0.21341965597763379,0.21282287142584999,0.21230838786149742,0.21187620815604657,0.21152633386613412,0.21125876567844154,0.21107350377116468,0.21097054809124388,0.21094989854671875,0.21101155511376835,0.21115551785819181,0.21138178687128212,0.21169036212023651,0.21208124321344751,0.21255442908121136,0.21310991757258557,0.2137477049693261,0.21446778541803169,0.2152701502818169]
[null,null,15,8.9293414719829628E-2,8.7839834746783335E-2,8.646234062440325E-2,8.51608728975638E-2,8.3935366450798271E-2,8.2785751952976189E-2,8.1711957236418054E-2,8.0713908607167456E-2,7.9791532083350658E-2,7.8944754558755492E-2,7.8173504888973566E-2,7.747771489764721E-2,7.6857320300576459E-2,7.631226154564047E-2,7.5842484566690516E-2,7.54479414497784E-2,7.5128591010280743E-2,7.4884399279683433E-2,7.4715339900988387E-2,7.4621394431903521E-2,7.4602552555175283E-2,7.4658812195620816E-2,7.4790179543613E-2,7.4996668984969705E-2,7.5278302937393626E-2,7.5635111593807647E-2,7.6067132573128415E-2,7.6574410479215371E-2,7.7156996368934305E-2,7.7814947130472489E-2,7.8548324773240419E-2]
[null,null,16,-7.1063214005886666E-2,-7.2366385311354808E-2,-7.360023480839098E-2,-7.4764986343159423E-2,-7.5860861357121279E-2,-7.6888077283938649E-2,-7.7846846020862809E-2,-7.8737372477942491E-2,-7.9559853208172104E-2,-8.0314475121491757E-2,-8.1001414285334972E-2,-8.1620834814215532E-2,-8.2172887850628956E-2,-8.2657710639339604E-2,-8.3075425696918226E-2,-8.3426140078185579E-2,-8.3709944741016729E-2,-8.3926914010755638E-2,-8.4077105145288239E-2,-8.4160558001621449E-2,-8.4177294804614833E-2,-8.4127320018312718E-2,-8.4010620320125184E-2,-8.3827164677907434E-2,-8.3576904529789581E-2,-8.3259774066408637E-2,-8.2875690614995334E-2,-8.2424555124570087E-2,-8.1906252751300895E-2,-8.1320653542872962E-2,-8.0667613220521822E-2]
[null,null,17,-0.24314707336489566,-0.24428883628828713,-0.24536853611466863,-0.246386573103519,-0.24734333645475531,-0.24823920253563309,-0.24907453319170422,-0.24984967414522929,-0.25056495348421726,-0.25122068024505145,-0.25181714309144065,-0.25235460909222168,-0.2528333226003226,-0.25325350423498399,-0.25361534996912766,-0.25391903032354801,-0.25416468966939854,-0.25435244564023618,-0.2544823886546842,-0.25455458155056915,-0.2545690593311859,-0.25452582902414295,-0.25442486965303868,-0.25426613232201911,-0.25404954041306704,-0.25377498989567143,-0.25344234974832353,-0.2530514624910869,-0.25260214482828303,-0.25209418840013037,-0.25152736064197279]
[null,null,18,-0.41523093272390477,-0.41621128726521955,-0.41713683742094643,-0.41800815986387874,-0.41882581155238952,-0.41959032778732763,-0.42030222036254572,-0.42096197581251626,-0.42157005376026258,-0.42212688536861132,-0.4226328718975465,-0.42308838337022803,-0.42349375735001643,-0.42384929783062858,-0.42415527424133725,-0.42441192056891064,-0.42461943459778051,-0.42477797726971689,-0.4248876721640803,-0.42494860509951704,-0.42496082385775713,-0.42492433802997337,-0.42483911898595239,-0.42470509996613093,-0.4245221762963447,-0.42429020572493437,-0.42400900888165194,-0.42367836985760388,-0.42329803690526535,-0.42286772325738797,-0.42238710806342394]
[null,null,19,-0.57558756144962075,-0.57641750732335739,-0.57719941285374032,-0.57793401910460163,-0.57862203936030876,-0.57926415702424217,-0.57986102361982628,-0.58041325689762591,-0.58092143905178506,-0.58138611504885829,-0.58180779107185476,-0.58218693308209046,-0.58252396550122154,-0.58281927001560829,-0.58307318450494572,-0.58328600209687431,-0.58345797034907765,-0.58358929056015563,-0.58368011721035673,-0.58373055753304171,-0.58374067121754702,-0.58371047024390665,-0.58363991884969024,-0.58352893362900782,-0.58337738376352766,-0.5831850913851504,-0.5829518320697753,-0.582677335461389,-0.5823612860255003,-0.58200332393073317,-0.58160304605718594]
[null,null,20,-0.71328892029624547,-0.71398970731903588,-0.71464826241321888,-0.7152654678084116,-0.71584217102915637,-0.71637918265736078,-0.71687727420495273,-0.71733717610030967,-0.7177595757917834,-0.71814511597140518,-0.71849439292162831,-0.71880795498773109,-0.7190863011782791,-0.71932987989581798,-0.71953908779975273,-0.7197142688031426,-0.71985571320493125,-0.71996365695891396,-0.72003828108053303,-0.72007971119238223,-0.72008801720909066,-0.72006321316205424,-0.72000525716426922,-0.7199140515153204,-0.71978944294637071,-0.71963122300479043,-0.71943912857785852,-0.71921284255475937,-0.71895199462589221,-0.71865616221829254,-0.71832487156576252]
[null,null,21,-0.81895088922063586,-0.81955256917135888,-0.82011647414686673,-0.82064359469709314,-0.82113488135268964,-0.82159124228307967,-0.82201354107060809,-0.82240259460437948,-0.82275917109713959,-0.82308398822831486,-0.82337771141609428,-0.82364095222119382,-0.8238742668847272,-0.82407815500237014,-0.82425305833678519,-0.82439935977005363,-0.82451738239764216,-0.82460738876521233,-0.82466958024937709,-0.82470409658328436,-0.82471101552770687,-0.82469035268810598,-0.82464206147792707,-0.8245660332281799,-0.82446209744314936,-0.82433002220186957,-0.82416951470479716,-0.82398022196489529,-0.82376173164214284,-0.82351357302026129,-0.8232352181242435]
[null,null,22,-0.88537277965525452,-0.88591215829596814,-0.88641656371949651,-0.88688705456877126,-0.88732464612679052,-0.88773030790905527,-0.88810496137579409,-0.88844947776759642,-0.88876467606782872,-0.88905132109496487,-0.88931012172773394,-0.88954172926573727,-0.88974673592797271,-0.88992567349146245,-0.89007901207196227,-0.890207159048505,-0.89031045813331322,-0.89038918858839455,-0.89044356458992913,-0.89047373474132996,-0.89047978173566178,-0.89046172216788455,-0.89041950649718271,-0.89035301915943199,-0.89026207882964825,-0.89014643883405331,-0.89000578771118677,-0.88983974992127624,-0.88964788670287431,-0.88942969707554997,-0.88918461898721346]
[null,null,23,-0.90802804953434624,-0.90854617835842799,-0.9090302895928124,-0.90948146510568462,-0.90990074226586248,-0.91028911151285163,-0.91064751404794875,-0.91097683965002274,-0.9112779246193532,-0.9115515498526654,-0.91179843905226909,-0.91201925707195952,-0.91221460840212076,-0.91238503579623298,-0.91253101904076406,-0.91265297387020095,-0.9127512510287572,-0.91282613548007552,-0.91287784576602937,-0.91290653351551454,-0.91291228310390826,-0.91289511146367053,-0.91285496804634203,-0.91279173493599686,-0.91270522711398838,-0.91259519287462965,-0.91246131439122746,-0.91230320843169155,-0.91212042722271769,-0.91191245946133614,-0.91167873147239931]
[null,null,24,-0.90802804953434624,-0.90854617835842799,-0.9090302895928124,-0.90948146510568462,-0.90990074226586248,-0.91028911151285163,-0.91064751404794875,-0.91097683965002274,-0.9112779246193532,-0.9115515498526654,-0.91179843905226909,-0.91201925707195952,-0.91221460840212076,-0.91238503579623298,-0.91253101904076406,-0.91265297387020095,-0.9127512510287572,-0.91282613548007552,-0.91287784576602937,-0.91290653351551454,-0.91291228310390826,-0.91289511146367053,-0.91285496804634203,-0.91279173493599686,-0.91270522711398838,-0.91259519287462965,-0.91246131439122746,-0.91230320843169155,-0.91212042722271769,-0.91191245946133614,-0.91167873147239931]
[]
[null,"SEC(theta)",1,{"$f":"IF(D85>0,1/(D85+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,2,{"$f":"IF(D86>0,1/(D86+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,3,{"$f":"IF(D87>0,1/(D87+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,4,{"$f":"IF(D88>0,1/(D88+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,5,{"$f":"IF(D89>0,1/(D89+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,6,{"$f":"IF(D90>0,1/(D90+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,7,{"$f":"IF(D91>0,1/(D91+0.0000001),0)","v":11.199021599022437},11.384343611851552,11.565715619155897,11.742468010585714,11.913914847738235,12.079358687617511,12.238095990004181,12.38942306616152,12.532642507617791,12.667070014749854,12.792041526295925,12.906920533588348,13.011105448103358,13.104036878768659,13.185204667183671,13.25415452521249,13.31049412085668,13.353898465223567,13.384114465834408,13.400964529229022,13.404349118289208,13.394248196113629,13.370721517585219,13.333907760751833,13.284022521461626,13.22135522500305,13.146265036507467,13.05917587643515,12.960570667646705,12.850984955689867,12.731000053621395]
[null,null,8,{"$f":"IF(D92>0,1/(D92+0.0000001),0)","v":4.4053858322366208},4.4363183958242631,4.4660543877835499,4.4945351073199262,4.5217033098072301,4.5475034523610951,4.5718819386463627,4.5947873611151726,4.6161707388214577,4.6359857489273422,4.6541889500084181,4.6707399952798081,4.6856018339033199,4.698740898598964,4.7101272778710799,4.7197348712698046,4.7275415262418523,4.7335291552786538,4.7376838322434169,4.7399958669487727,4.7404598572610634,4.7390747182227599,4.7358436879078507,4.7307743099527499,4.7238783929340062,4.7151719469899733,4.7046750983034897,4.6924119822729526,4.6784106163967625,4.6627027540782739,4.64532372072253]
[null,null,9,{"$f":"IF(D93>0,1/(D93+0.0000001),0)","v":3.0061007989863384},3.0213762679611356,3.0360116345381498,3.049984222752876,3.0632721142559038,3.0758542203089658,3.0877103522848617,3.0988212902732508,3.1091688493959611,3.1187359434406012,3.1275066454297238,3.135466244754892,3.1426013005203082,3.1488996907595324,3.1543506572108444,3.1589448453618436,3.1626743395019283,3.1655326925518761,3.1675149504726692,3.1686176710907352,3.1688389372134131,3.1681783639464043,3.1666371001639009,3.1642178241214598,3.1609247332412216,3.1567635281382778,3.1517413909954244,3.1458669584310091,3.1391502890403302,3.1316028258251296,3.1232373537575349]
[null,null,10,{"$f":"IF(D94>0,1/(D94+0.0000001),0)","v":2.5057712112831942},2.5167705906835427,2.5272973929080456,2.5373368588364431,2.5468747638403766,2.5558974593021939,2.5643919130401525,2.5723457484384817,2.5797472820836154,2.5865855597122143,2.5928503902823974,2.5985323779869454,2.6036229520359107,2.6081143940462588,2.6119998628876577,2.6152734168462115,2.6179300329819202,2.6199656235705504,2.621377049536544,2.6221621308002954,2.6223196534805195,2.6218493739103144,2.6207520194438207,2.6190292860488142,2.6166838326991084,2.6137192725990177,2.6101401612902224,2.6059519817090737,2.6011611262794214,2.5957748761423716,2.5898013776398616]
[null,null,11,{"$f":"IF(D95>0,1/(D95+0.0000001),0)","v":2.3711628499242265},2.3811303660146317,2.3906669279419837,2.3997595312400541,2.4083956516950269,2.416563280691324,2.4242509595772894,2.4314478128854304,2.4381435802446147,2.444328646825547,2.4499940721658429,2.4551316172273405,2.4597337695455308,2.4637937663394966,2.4673056154602198,2.4702641140655333,2.4726648649213971,2.474504290241303,2.475779642988535,2.4764890155795234,2.4766313459405551,2.4762064208845302,2.4752148767891646,2.4736581975728975,2.4715387099796704,2.4688595761985201,2.4656247838585243,2.4618391334538945,2.4575082232677725,2.4526384318765309,2.4472368983289052]
[null,null,12,{"$f":"IF(D96>0,1/(D96+0.0000001),0)","v":2.5057712112831942},2.5167705906835427,2.5272973929080456,2.5373368588364431,2.5468747638403766,2.5558974593021939,2.5643919130401525,2.5723457484384817,2.5797472820836154,2.5865855597122143,2.5928503902823974,2.5985323779869454,2.6036229520359107,2.6081143940462588,2.6119998628876577,2.6152734168462115,2.6179300329819202,2.6199656235705504,2.621377049536544,2.6221621308002954,2.6223196534805195,2.6218493739103144,2.6207520194438207,2.6190292860488142,2.6166838326991084,2.6137192725990177,2.6101401612902224,2.6059519817090737,2.6011611262794214,2.5957748761423716,2.5898013776398616]
[null,null,13,{"$f":"IF(D97>0,1/(D97+0.0000001),0)","v":3.0061007989863384},3.0213762679611356,3.0360116345381498,3.049984222752876,3.0632721142559038,3.0758542203089658,3.0877103522848617,3.0988212902732508,3.1091688493959611,3.1187359434406012,3.1275066454297238,3.135466244754892,3.1426013005203082,3.1488996907595324,3.1543506572108444,3.1589448453618436,3.1626743395019283,3.1655326925518761,3.1675149504726692,3.1686176710907352,3.1688389372134131,3.1681783639464043,3.1666371001639009,3.1642178241214598,3.1609247332412216,3.1567635281382778,3.1517413909954244,3.1458669584310091,3.1391502890403302,3.1316028258251296,3.1232373537575349]
[null,null,14,{"$f":"IF(D98>0,1/(D98+0.0000001),0)","v":4.4053858322366208},4.4363183958242631,4.4660543877835499,4.4945351073199262,4.5217033098072301,4.5475034523610951,4.5718819386463627,4.5947873611151726,4.6161707388214577,4.6359857489273422,4.6541889500084181,4.6707399952798081,4.6856018339033199,4.698740898598964,4.7101272778710799,4.7197348712698046,4.7275415262418523,4.7335291552786538,4.7376838322434169,4.7399958669487727,4.7404598572610634,4.7390747182227599,4.7358436879078507,4.7307743099527499,4.7238783929340062,4.7151719469899733,4.7046750983034897,4.6924119822729526,4.6784106163967625,4.6627027540782739,4.64532372072253]
[null,null,15,{"$f":"IF(D99>0,1/(D99+0.0000001),0)","v":11.199021599022437},11.384343611851552,11.565715619155897,11.742468010585714,11.913914847738235,12.079358687617511,12.238095990004181,12.38942306616152,12.532642507617791,12.667070014749854,12.792041526295925,12.906920533588348,13.011105448103358,13.104036878768659,13.185204667183671,13.25415452521249,13.31049412085668,13.353898465223567,13.384114465834408,13.400964529229022,13.404349118289208,13.394248196113629,13.370721517585219,13.333907760751833,13.284022521461626,13.22135522500305,13.146265036507467,13.05917587643515,12.960570667646705,12.850984955689867,12.731000053621395]
[null,null,16,{"$f":"IF(D100>0,1/(D100+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,17,{"$f":"IF(D101>0,1/(D101+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,18,{"$f":"IF(D102>0,1/(D102+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,19,{"$f":"IF(D103>0,1/(D103+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,20,{"$f":"IF(D104>0,1/(D104+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,21,{"$f":"IF(D105>0,1/(D105+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,22,{"$f":"IF(D106>0,1/(D106+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,23,{"$f":"IF(D107>0,1/(D107+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,24,{"$f":"IF(D108>0,1/(D108+0.0000001),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"3-PG function tools","index":3,"n_rows":280,"n_cols":14,"rows_kept":280,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Selected 3-PG relationships"]
[]
[null,"This spreadsheet graphically displays selected 3-PG relationships. Use it for exploring"]
[null,"how relationships change with parameter values. Edit only the parameter values. The"]
[null,"graphs are automaticaly updated to display the relationship for the new values."]
[]
["Table 1"]
["Calculation ofVPD from Tmax and Tmin (assumes average daytime vpd =0.62 of max value)"]
[]
["The following implements the internal calculation of VPD "]
["from maximum and minimum temperatures:"]
["VPD = (Sat Vap Pres at Tmax - Sat Vap Pres at Tmin)*0.62"]
["Enter data for Tmax and Tmin, and VPD is computed."]
[]
[]
[null,null,"Month","Tmax","Tmin","VPD (mBar)"]
[null,null,"Jan",8,1.8,{"$f":" (6.1078 * EXP(17.269 * D18 / (237.3 + D18)) -6.1078 * EXP(17.269 * E18 / (237.3 + E18)))*0.62","v":2.3381540665431406}]
[null,null,"Feb",10.8,2.8,{"$f":" (6.1078 * EXP(17.269 * D19 / (237.3 + D19)) -6.1078 * EXP(17.269 * E19 / (237.3 + E19)))*0.62","v":3.3989696644017702}]
[null,null,"Mar",13.3,3.8,4.4977388849260906]
[null,null,"Apr",15.8,4.8,5.7961025395510637]
[null,null,"May",19.5,6.9,7.8845067370265918]
[null,null,"Jun",23.4,9.8000000000000007,10.330833222478445]
[null,null,"Jul",27.6,11.6,14.423610969513108]
[null,null,"Aug",27.7,11.8,14.444949936538524]
[null,null,"Sep",24.6,9.6,11.763518726118647]
[null,null,"Oct",18.100000000000001,6.4,6.9162290104574904]
[null,null,"Nov",11.3,4.3,3.1524848368538794]
[null,null,"Dec",7.9,2.2000000000000002,2.1677660406790911]
[]
[]
["Table 2"]
["[FROST DAYS]"]
["Calculation of  days <-2oC/month from Tmin"]
["[calibrated assuming that frost days  <-2oC halts photosynthesis and transpiration for 1 full day]"]
["Frost days/ month = Tmin (-2.00) +11.6; if <0, then 0 days of frost"]
["Note: if Tmin is <-9, then  Frost days /month = 30"]
[]
[]
[null,null,"Month","Tmin","Frost days",null,null,"Frost days"]
[null,null,"Jan",1.8,{"$f":"IF(H41<0,0,IF(D41<-9,30,IF(D41>-9,H41,0)))","v":8},null,null,{"$f":"D41*(-2)+11.6","v":8}]
[null,null,"Feb",2.8,6,null,null,6]
[null,null,"Mar",3.8,4,null,null,4]
[null,null,"Apr",4.8,2,null,null,2]
[null,null,"May",6.9,0,null,null,-2.2000000000000011]
[null,null,"Jun",9.8000000000000007,0,null,null,-8.0000000000000018]
[null,null,"Jul",11.6,0,null,null,-11.6]
[null,null,"Aug",11.8,0,null,null,-12.000000000000002]
[null,null,"Sep",9.6,0,null,null,-7.6]
[null,null,"Oct",6.4,0,null,null,-1.2000000000000011]
[null,null,"Nov",4.3,3,null,null,3]
[null,null,"Dec",2.2000000000000002,7.1999999999999993,null,null,7.1999999999999993]
[]
["Table 3"]
["gammaFx =",2.7E-2,"(/month)",2.7E-2,"(/month)",2.7E-2,"(/month)"]
["gammaF0 =",2E-3,"(/month)",2E-3,"(/month)",2E-3,"(/month)"]
["tgammaF =",12,"(month)",24,"(month)",48,"(month)"]
[]
["Age (years)","gamma (/year)","Life time (yr)","gamma (/year)","Life time (yr)","gamma (/year)","Life time (yr)"]
[0,{"$f":"B$55*B$56/(B$56+(B$55-B$56)*EXP(-LN(B$55/B$56+1)*12*$A60/B$57))","v":1.9999999999999996E-3},{"$f":"1/B60/12","v":41.666666666666679},{"$f":"D$55*D$56/(D$56+(D$55-D$56)*EXP(-LN(D$55/D$56+1)*12*$A60/D$57))","v":1.9999999999999996E-3},{"$f":"1/D60/12","v":41.666666666666679},{"$f":"F$55*F$56/(F$56+(F$55-F$56)*EXP(-LN(F$55/F$56+1)*12*$A60/F$57))","v":1.9999999999999996E-3},{"$f":"1/F60/12","v":41.666666666666679}]
[0.2,3.2443684417959476E-3,25.685533202635725,2.5551380864817863E-3,32.614023396315318,2.2621449408628913E-3,36.838193622352939]
[0.4,5.1048702776266899E-3,16.32428030513557,3.2443684417959476E-3,25.685533202635725,2.5551380864817863E-3,32.614023396315318]
[0.7,9.2374612127222363E-3,9.0212376987914187,4.5742138472690706E-3,18.218066779515695,3.058326771236491E-3,27.248014867829642]
[1,1.4499999999999999E-2,5.7471264367816097,6.3044917926951298E-3,13.218088955225504,3.6458300763559715E-3,22.85716327641509]
[1.5,2.2015827885937766E-2,3.7851555601304949,1.0066270647983514E-2,8.278471367151921,4.8338507860721872E-3,17.239533659880923]
[2,2.5484848484848482E-2,3.2699167657550539,1.4499999999999999E-2,5.7471264367816097,6.3044917926951298E-3,13.218088955225504]
[2.5,2.6584926063116843E-2,3.1346084294342873,1.8726931343028417E-2,4.4499193064194325,8.0598687886084246E-3,10.339291559077756]
[3,2.688974641675854E-2,3.0990747194773607,2.2015827885937766E-2,3.7851555601304949,1.0066270647983514E-2,8.278471367151921]
[3.5,2.6970958543956584E-2,3.0897431100759278,2.4193212410688562E-2,3.4444922781943856,1.2249120456982751E-2,6.8032095550034546]
[4,2.6992367286188604E-2,3.0872925093892434,2.5484848484848482E-2,3.2699167657550539,1.4499999999999999E-2,5.7471264367816097]
[4.5,2.6997995133229757E-2,3.0866489501201788,2.6201708297282099E-2,3.1804542050404208,1.6696328687164228E-2,4.9911172027535713]
[5,2.6999473467362214E-2,3.0864799431762697,2.6584926063116843E-2,3.1346084294342873,1.8726931343028417E-2,4.4499193064194325]
[5.5,2.6999861723766692E-2,3.086435559778403,2.6785685883403434E-2,3.1111144099904178,2.0512837810534638E-2,4.062496574244661]
[6,2.6999963686744975E-2,3.0864239041270989,2.688974641675854E-2,3.0990747194773607,2.2015827885937766E-2,3.7851555601304949]
[]
[]
["Table 4"]
["Root allocation"]
[]
["pRx = ",0.8,0.8,0.8]
["pRn = ",0.23,0.23,0.23]
["FR = ",1,0.7,0.4]
[]
["Q*/Q","etaR","etaR","etaR"]
[0,{"$f":"B$80*B$81/(B$81+(B$80-B$81)*B$82*$A85)","v":0.8},0.8,0.8]
[0.1,0.64111498257839727,0.68173397554649873,0.72784810126582278]
[0.2,0.53488372093023262,0.59393156875403486,0.66763425253991293]
[0.3,0.45885286783042395,0.52616528452959688,0.61662198391420919]
[0.4,0.40174672489082969,0.47227926078028748,0.57285180572851802]
[0.5,0.35728155339805828,0.4284051222351572,0.53488372093023262]
[0.6,0.32167832167832167,0.39198977417980402,0.50163576881134142]
[0.7,0.29252782193958671,0.36128018849401144,0.47227926078028748]
[0.8,0.26822157434402333,0.33503277494537514,0.44616876818622697]
[0.9,0.24764468371467024,0.31234085893736208,0.42279411764705888]
[1,0.23,0.29252782193958671,0.40174672489082969]
[]
[]
[]
["Table 5"]
["Age dependent decline"]
["Table 3"]
["MaxAge = ",50,"(years)"]
["nAge = ",4,"(-)"]
["rAge = ",0.95,"(-)"]
[]
["Age","relAge","fAge"]
[0,{"$f":"A107/$B$102","v":0},{"$f":"1/(1+(B107/$B$104)^$B$103)","v":1}]
[5,0.1,0.99987724130523192]
[10,0.2,0.99803947096349288]
[15,0.3,0.99015324768077062]
[20,0.4,0.96952766391155876]
[25,0.5,0.92873482942681418]
[30,0.6,0.86272731485465759]
[35,0.7,0.77233209076847398]
[40,0.8,0.66538852325931663]
[45,0.9,0.55385746524605062]
[50,1,0.44888588837872567]
[]
[]
["Table 6"]
["Biomass partitioning"]
[]
[null,"aS = ",9.5000000000000001E-2,"nF = ",{"$f":"C124+E125","v":1.7979400086720376},"aS = ",9.5000000000000001E-2,"nF = ",{"$f":"G124+I125","v":1.5760912590556813},"aS = ",9.5000000000000001E-2,"nF = ",null,{"$f":"K124+N125","v":1.0989700043360189}]
[null,"nS = ",2.4,"aF = ",{"$f":"E126*C123*C124/E123","v":0.19248538804113413},"nS = ",2.4,"aF = ",{"$f":"I126*G123*G124/I123","v":0.25607945169890761},"nS = ",2.4,"aF = ",null,{"$f":"N126*K123*K124/N123","v":0.51120849506863431}]
[null,"etaR = ",0.4,"np = ",{"$f":"LN(C127/C126)/LN(10)","v":-0.60205999132796229},"etaR = ",0.4,"np = ",{"$f":"LN(G127/G126)/LN(10)","v":-0.82390874094431865},"etaR = ",0.4,"np = ",null,{"$f":"LN(K127/K126)/LN(10)","v":-1.301029995663981}]
[null,"pFS2 = ",1,"ap = ",{"$f":"C126/2^E125","v":1.517882369490865},"pFS2 = ",1,"ap = ",{"$f":"G126/2^I125","v":1.7701955502035958},"pFS2 = ",1,"ap = ",null,{"$f":"K126/2^N125","v":2.4640473773780118}]
[null,"pFS20 =",0.25,null,null,"pFS20 =",0.15,null,null,"pFS20 =",0.05]
[]
["D","WS","pFS","etaS","etaF","WS","pFS","etaS","etaF","WS","pFS","etaS",null,"etaF"]
[1,{"$f":"$C$123*$A130^$C$124","v":9.5000000000000001E-2},{"$f":"$E$126*$A130^$E$125","v":1.517882369490865},{"$f":"(1-$C$125)/(1+C130)","v":0.23829548483685703},{"$f":"C130*D130","v":0.36170451516314306},{"$f":"$C$123*$A130^$C$124","v":9.5000000000000001E-2},{"$f":"$I$126*$A130^$I$125","v":1.7701955502035958},{"$f":"(1-$G$125)/(1+G130)","v":0.21659120777805846},{"$f":"G130*H130","v":0.38340879222194152},{"$f":"$C$123*$A130^$C$124","v":9.5000000000000001E-2},{"$f":"$N$126*$A130^$N$125","v":2.4640473773780118},{"$f":"(1-$K$125)/(1+K130)","v":0.1732077926873358},null,{"$f":"K130*L130","v":0.42679220731266415}]
[2,0.50141300609369976,1,0.3,0.3,0.50141300609369976,1,0.3,0.3,0.50141300609369976,1,0.3,null,0.3]
[3,1.3268279656976327,0.78339807149015284,0.33643638489451672,0.26356361510548321,1.3268279656976327,0.71600634758525761,0.34964905627785842,0.25035094372214162,1.3268279656976327,0.59006518340119851,0.37734302106821899,null,0.22265697893178096]
[4,2.6464737124202173,0.65881258001265575,0.36170451516314295,0.23829548483685697,2.6464737124202173,0.56490934003589999,0.38340879222194152,0.21659120777805849,2.6464737124202173,0.40583635249095656,0.42679220731266421,null,0.1732077926873358]
[5,4.5211781044502093,0.57599172190280079,0.3807126596296963,0.21928734037030367,4.5211781044502093,0.4700388428940917,0.40815248039212987,0.19184751960787017,4.5211781044502093,0.30357647389817305,0.46027219117094015,null,0.13972780882905983]
[6,7.0030399878909249,0.51611250465536662,0.39574899498397603,0.204251005016024,7.0030399878909249,0.40447867327590314,0.4272047781263339,0.17279522187366611,7.0030399878909249,0.23946990176344982,0.48407791036018938,null,0.11592208963981061]
[7,10.138154405967338,0.4703686820219809,0.40806092195523957,0.19193907804476046,10.138154405967338,0.35623581701671875,0.44240093977152617,0.15759906022847381,10.138154405967338,0.19595265609418461,0.50169210038758283,null,9.8307899612417163E-2]
[8,13.968171996763942,0.43403401558293209,0.41840011706842334,0.18159988293157667,13.968171996763942,0.31912256245979609,0.45484780343773901,0.14515219656226092,13.968171996763942,0.16470314500316399,0.51515272588911065,null,8.4847274110889381E-2]
[10,23.862921099341015,0.37947059237271624,0.4349494678012587,0.1650505321987413,23.862921099341015,0.26552933253053934,0.47410991162112864,0.12589008837887128,23.862921099341015,0.12320236886890061,0.53418690756877452,null,6.5813092431225476E-2]
[15,63.145532072466871,0.29727653025201184,0.46250740378648697,0.13749259621351304,63.145532072466871,0.19012068756194289,0.50415055067158598,9.5849449328414063E-2,63.145532072466871,7.2697428382089993E-2,0.55933759522940019,null,4.0662404770599764E-2]
[20,125.94925265891943,0.25000000000000011,0.48,0.12000000000000005,125.94925265891943,0.15000000000000008,0.52173913043478248,7.8260869565217411E-2,125.94925265891943,5.0000000000000017E-2,0.5714285714285714,null,2.8571428571428581E-2]
[30,333.28411639833422,0.19584951787253824,0.5017353697373419,9.8264630262658123E-2,333.28411639833422,0.1074009521377887,0.54180917836645015,5.8190821633549737E-2,333.28411639833422,2.9503259170059925E-2,0.58280534292207442,null,1.7194657077925612E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 7"]
["Specific leaf area"]
[]
["SLA0",11,11,11,"(m2/kg)"]
["SLA1",4,4,4,"(m2/kg)"]
["tSLA",2,2.5,3,"(years)"]
["n",2,2,2]
[]
["Age"]
[0,{"$f":"B$162+(B$161-B$162)*EXP(-0.69315*($A167/B$163)^B$164)","v":11},11,11]
[0.25,10.924595787303403,10.95164727206172,10.966386174012502]
[0.5,10.703221783681663,10.808583864030194,10.866510075912561]
[1,9.8862707577776519,10.265172670210566,10.481120955662712]
[1.5,8.7398868971204919,9.4541465216705891,9.8862707577776519]
[2,7.4999901319737194,8.4919825359425403,9.1440642770135057]
[2.5,6.3699367666561795,7.4999901319737194,8.3256221614161774]
[3,5.4715593914740346,6.5799606556142098,7.4999901319737194]
[4,4.4374950660077266,5.1870202188509751,6.0414155869678954]
[5,4.0919714247296035,4.4374950660077266,5.0207049156635666]
[6,4.0136715280811135,4.1291689746259399,4.4374950660077266]
[7,4.0014370292014885,4.0305501448812695,4.1607497425193847]
[8,4.0001068067051673,4.0057881309218049,4.0506327581640686]
[]
[]
["Table 8"]
["Branch+bark fraction"]
[]
["fracBB0",0.75,0.75,0.75,"(-)"]
["fracBB1",0.15,0.15,0.15,"(-)"]
["tBB",3,2,1,"(years)"]
["n",1,1,1,"(-)"]
[]
["Age"]
[0,{"$f":"B$186+(B$185-B$186)*EXP(-0.69315*($A191/B$187)^B$188)","v":0.75},0.75,0.75]
[0.25,0.71632445454917959,0.70020223201499221,0.65453749352379875]
[0.5,0.68453897970070954,0.65453749352379875,0.57426347061879546]
[1,0.62621986803245921,0.57426347061879546,0.44999915416917591]
[1.5,0.57426347061879546,0.50676138009952487,0.36213113721752949]
[2,0.52797560451475489,0.44999915416917591,0.29999915417036838]
[2.5,0.48673782331512661,0.40226803550629286,0.2560652695636737]
[3,0.44999915416917591,0.36213113721752949,0.22499936562867057]
[4,0.38810926268049062,0.29999915417036838,0.18749957708637655]
[5,0.338987269418349,0.2560652695636737,0.16874973567935797]
[6,0.29999915417036838,0.22499936562867057,0.15937484140783834]
[7,0.26905429567332217,0.20303248525971296,0.15468740748803611]
[8,0.24449336829041146,0.18749957708637655,0.15234369713609516]
[]
[]
["Table 9"]
["Determination of temperature modifier fT(Tav)"]
[]
[]
[null,"alpha0 = ",0.06,0.06,0.06,"(mol/mol)"]
[null,"Tmin = ",7.5,7.5,7.5,"(deg C)"]
[null,"Topt = ",14,15,16,"(deg C)"]
[null,"Tmax = ",35,35,35,"(deg C)"]
[]
[null,"T","fTemp","fTemp","fTemp"]
[null,7,{"$f":"C$210*MAX(0,(($B216-C$211)/(C$212-C$211))*((C$213-$B216)/(C$213-C$212))^((C$213-C$212)/(C$212-C$211)))","v":0},0,0]
[null,7.5,0,0,0]
[null,8,1.0395095692537066E-2,8.9046469912395926E-3,7.7416035842348841E-3]
[null,9,2.760553028126635E-2,2.4156287262983658E-2,2.1345915354876718E-2]
[null,10,4.0533495256153969E-2,3.6262412762599831E-2,3.2590348865213802E-2]
[null,11,4.9735276420167979E-2,4.5531087221379676E-2,4.1647413667340587E-2]
[null,12,5.5730557437139693E-2,5.2259278365668523E-2,4.8687408406847862E-2]
[null,13,5.9002859727401699E-2,5.6732663085454361E-2,5.3878330980231572E-2]
[null,14,0.06,5.9225418899219243E-2,5.7385780250842781E-2]
[null,15,5.9134567074067189E-2,0.06,5.9372848059365928E-2]
[null,16,5.6784419890713957E-2,5.930689585269347E-2,0.06]
[null,17,5.3293208918269379E-2,5.7384369919955866E-2,5.9424943096019839E-2]
[null,18,4.8970923522577946E-2,5.4458175598973133E-2,5.7802478073073399E-2]
[null,19,4.4094468330223797E-2,5.074124581963093E-2,5.5284333359597516E-2]
[null,20,3.8908272183331004E-2,4.6433351937580691E-2,5.2018977189113046E-2]
[null,21,3.3624934008194989E-2,4.1720726483152941E-2,4.8151403161856142E-2]
[null,22,2.8425910850941948E-2,3.6775642895344789E-2,4.3822883226489549E-2]
[null,23,2.3462254551123711E-2,3.1755943422487283E-2,3.9170680085041043E-2]
[null,24,1.8855405147343775E-2,2.6804503664234171E-2,3.4327708215353761E-2]
[null,25,1.469805132011146E-2,2.2048618373160286E-2,2.942212856492403E-2]
[null,26,1.1055071265842768E-2,1.759928748087463E-2,2.4576855672881981E-2]
[null,27,7.9645718400887851E-3,1.355037274204178E-2,1.9908946040795732E-2]
[null,28,5.4390504320024E-3,9.9775818612697527E-3,1.552882019128945E-2]
[null,29,3.4667143368259834E-3,6.9372145476704894E-3,1.1539242362501159E-2]
[null,30,2.0130093001125182E-3,4.4645654586605611E-3,8.0339288229297305E-3]
[]
[]
["Table 10"]
["Soil water modifier"]
[]
[null,"Swconst = ",0.7,0.6,0.5,0.4]
[null,"Swpower = ",9,7,5,3]
[]
[null,"relASW","S","SL","CL","C"]
[null,0,{"$f":"1/(1+((1-$B250)/C$246)^C$247)","v":3.8788356889889644E-2},2.7231297938041625E-2,3.0303030303030304E-2,6.0150375939849621E-2]
[null,0.1,9.4333919181492421E-2,5.529157667386609E-2,5.0262167465500031E-2,8.0706179066834804E-2]
[null,0.2,0.23115826547353815,0.1177642560982176,8.7064330092218492E-2,0.1111111111111111]
[null,0.3,0.5,0.2536849364600503,0.15678306241220152,0.15724815724815733]
[null,0.4,0.80016982706157713,0.5,0.28667094761948447,0.22857142857142868]
[null,0.5,0.95383417939253734,0.78181092048561551,0.5,0.33862433862433861]
[null,0.6,0.99354575519236366,0.94470842332613392,0.75319354061219557,0.5]
[null,0.7,0.99951247470790716,0.99224806201550386,0.92785035629453683,0.70329670329670324]
[null,0.8,0.99998731232368121,0.9995429616087752,0.98986379474184349,0.88888888888888884]
[null,0.9,0.99999997521906847,0.99999642776767628,0.99968010236724236,0.98461538461538467]
[null,1,1,1,1,1]
[]
["Table 11"]
["Canopy conductance"]
[]
[null,"maxCond =",0.02,0.02,2.5000000000000001E-2]
[null,"LAIgcx =",3,4,3]
[null,"Physmod =",1,1,1]
[]
[null,"LAI","gC"]
[null,0,{"$f":"C$265*C$267*MIN(1,$B270/C$266)","v":0},0,0]
[null,0.5,3.3333333333333331E-3,2.5000000000000001E-3,4.1666666666666666E-3]
[null,1,6.6666666666666662E-3,5.0000000000000001E-3,8.3333333333333332E-3]
[null,1.5,0.01,7.4999999999999997E-3,1.2500000000000001E-2]
[null,2,1.3333333333333332E-2,0.01,1.6666666666666666E-2]
[null,2.5,1.6666666666666666E-2,1.2500000000000001E-2,2.0833333333333336E-2]
[null,3,0.02,1.4999999999999999E-2,2.5000000000000001E-2]
[null,3.5,0.02,1.7500000000000002E-2,2.5000000000000001E-2]
[null,4,0.02,0.02,2.5000000000000001E-2]
[null,4.5,0.02,0.02,2.5000000000000001E-2]
[null,5,0.02,0.02,2.5000000000000001E-2]

{"sheet":" ","index":4,"n_rows":190,"n_cols":19,"rows_kept":190,"cut":false,"hidden":false,"merged":[]}
[]
["Run type : ","SingleSite",null,null,"Stand initialisation and site factor data",null,null,null,null,null,"Optional parameter block",null,null,"Definition of parameter"]
["Site : ","Metolius River Oregon",null,null,null,"Year planted =",1999,null,"Latitude =",44,null,"Parameters",null,null,null,null,null,null,"gC/MJ APAR"]
["Species : ","Doug fir",null,null,null,"Month planted =","Jan",null,"Fertility rating =",0.25]
["Climate data : ","Metolius, OR Metdata",null,null,null,"Initial year = ",1,null,"Soil class =","sl"]
["Met station : ","Mean Data",null,null,null,"Initial month =","Jan",null,"Maximum ASW =",100]
["Title : ","Ponderosa pine average climate",null,null,null,"End age =",100,null,"Minimum ASW =",0]
[null,null,null,null,null,"Initial WF = ",3,null,"Atmospheric CO2 = ",360]
[null,null,null,null,null,"Initial WR = ",3]
[null,null,null,null,null,"Initial WS = ",3]
[null,null,null,null,null,"Initial stocking = ",300]
[null,null,null,null,null,"Initial ASW = ",100]
[]
[]
[]
[null,null,null,null,null,"Output details",null,"BasArea, avdbh"]
[null,null,null,null,null,null,"Output frequency : ","a"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["#Output from 3PGpjs 2.7 / 3-PG vsn 1 Sep2009"]
["Stand development for Metolius River Oregon"]
["Ponderosa pine average climate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tree vigor"]
["Year & month","Stand age","Stems","Foliage DM","Root DM","Stem DM","Stand volume","LAI","MAI","Mean DBH","Basal area","GPP","Penman transp.",null,null,null,"g wood/m2 Leaf area/yr",null,"% mortality/yr"]
["2000 - Jan",1,300,3,3,3,6.3650279961624765,1.6500000000000001,6.3650279961624765,7.1039757092797648,1.1890882063780934]
["2001 - Jan",1.9999999999999991,300,3.0246376134150235,0.30610269457586869,3.1791926576548812,6.7352958807927932,1.6791497267732145,3.3676479403963979,7.2751995579418018,1.2470990749615043,1.7472133227269522,265.8653550214587,null,null,null,{"$f":"1000*(F41-F40)/F41","v":56.364202157871738},null,{"$f":"100*(C40-C41)/C40","v":0}]
["2002 - Jan",3.0000000000000009,300,3.0260931330858618,0.19314566015025245,3.4992015554773381,7.4030056475422024,1.702718829816644,2.4676685491807335,7.5673562627265847,1.3492719665665684,3.0980246432418896,265.87825549923588,null,null,null,{"$f":"1000*(F42-F41)/F42","v":91.451976329155286},null,{"$f":"100*(C41-C42)/C41","v":0}]
["2003 - Jan",4.0000000000000027,300,2.9665007859406161,0.25362600188022688,3.9547440458423995,8.35590149536106,1.6980789513762804,2.0889753738402637,7.9572571665355403,1.4918938518160569,4.3801920619732666,265.85947459676333,null,null,null,115.18886812509918,null,0]
["2004 - Jan",4.9999999999999991,300,2.8807194937270411,0.31861179453819971,4.5331845867777929,9.5664051403270491,1.6658916749409234,1.9132810280654102,8.4159167406310917,1.66883729508767,5.523150308807617,265.79737295187249,null,null,null,127.6013649703489,null,0]
["2005 - Jan",5.9999999999999956,300,2.8191434620195346,0.37483279383128781,5.2178027946047747,10.998571906761283,1.6331368141083735,1.8330953177935485,8.9161650477638528,1.8731274762412879,6.4911875032980646,265.73069293344446,null,null,null,131.20814158305853,null,0]
["2006 - Jan",6.999999999999992,300,2.8025862155538759,0.42275467496769747,5.9941517890952563,12.621494645975178,1.6196634727543961,1.8030706637107417,9.4386136449317881,2.0990730593854283,7.3099176129983761,265.69223648632772,null,null,null,129.51774025856992,null,0]
["2007 - Jan",7.9999999999999885,300,2.8305647690929914,0.46521724840157253,6.8533230359963451,14.416113932849818,1.6304549353680358,1.8020142416062299,9.9721757315059989,2.3431008542946241,8.0347662472842973,265.68979302560371,null,null,null,125.36564267996472,null,0]
["2008 - Jan",8.9999999999999947,300,2.8960690076779647,0.50483485906404424,7.7913279043460459,16.373836749562113,1.6633421130473383,1.8193151943957915,10.511396895829293,2.6033466798832126,8.7137906370232407,265.72147194189512,null,null,null,120.3908858496992,null,0]
["2009 - Jan",10.000000000000002,300,2.9918946656856025,0.54333669534467766,8.8073689918515221,18.492844414504347,1.7145621095870236,1.8492844414504344,11.053877844134362,2.8789919991311881,9.3777035560228263,265.78538334811981,null,null,null,115.36261151832129,null,0]
["2010 - Jan",11.000000000000009,300,3.1121926496025782,0.58170207746558966,9.9024417586116478,20.775122149684528,1.7806858850882357,1.8886474681531373,11.598687014800214,3.1697776205853754,10.043515425363591,265.88141182867884,null,null,null,110.58613556679562,null,0]
["2011 - Jan",12.000000000000016,300,3.2524753326021387,0.62042818151925561,11.078455670071815,23.224597680172003,1.8589823866544584,1.9353831400143311,12.145533593816362,3.4757164174114559,10.719746398746627,266.0106509883251,null,null,null,106.15323529588521,null,0]
["2012 - Jan",13.000000000000023,300,3.4092908209145065,0.65977002980234944,12.337712134358027,25.846038539544633,1.9473289084566898,1.9881568107341989,12.694362769031521,3.7969331097001229,11.41002004138987,266.18769296459021,null,null,null,102.06563831064254,null,0]
["2013 - Jan",14.00000000000003,300,3.5799390198538155,0.69974231414867949,13.682642867938871,28.644500531205228,2.0440696292143428,2.0460357522289403,13.245185128934338,4.1335881338607345,12.115351801307328,266.39793948894237,null,null,null,98.294660363626207,null,0]
["2014 - Jan",15.000000000000037,300,3.7622396091006758,0.74030315952708214,15.115636087900597,31.624962597264954,2.1478744538985053,2.1083308398176586,13.797992974898781,4.4858316947691659,12.83524876189502,266.64011127734136,null,null,null,94.80204548644663,null,0]
["2015 - Jan",16.000000000000043,300,3.9458987098297174,0.77312077633721199,16.626235546188532,34.765559658253622,2.2543408842691068,2.1728474786408456,14.348230653350184,4.8507381920369346,13.451365551720261,266.90920303336935,null,null,null,90.856372995042221,null,0]
["2016 - Jan",17.000000000000028,300,4.1073256673455933,0.78989210503710228,18.179137091738639,37.992567142376977,2.3509784055653324,2.2348568907280537,14.883952337323844,5.2197256547211612,13.753505672012606,267.18296178478903,null,null,null,85.422181356221259,null,0]
["2017 - Jan",18.000000000000014,300,4.2475741948020937,0.80295854226398533,19.768227233796303,41.293396499603858,2.4351978561934553,2.2940775833113238,15.404909043134454,5.5915139528813524,14.004062759324011,267.43355139607928,null,null,null,80.386072219005655,null,0]
["2018 - Jan",19,300,4.3680840348897245,0.81362408268035658,21.388206260218947,44.65717845153015,2.5077772448604225,2.350377813238429,15.911160226074356,5.9650602469826532,14.210867390898102,267.6657724204037,null,null,null,75.741696461742507,null,0]
["2019 - Jan",19.999999999999986,300,4.4705160408157072,0.8223429932483115,23.034513602243241,48.074598809294336,2.5696480425408024,2.4037299404647183,16.402978092378486,6.3395224750927364,14.380778998809621,267.87792671455554,null,null,null,71.471330823498093,null,0]
["2020 - Jan",20.999999999999972,300,4.5566259759925716,0.82942972655599267,24.703244908616082,51.537718747194688,2.621816145794718,2.4541770831997503,16.880776165636256,6.7142260504670492,14.519703428491285,268.06319130628975,null,null,null,67.551097539854581,null,0]
["2021 - Jan",21.999999999999957,300,4.6281680581952589,0.83515937256923312,26.391060360927895,55.039778336665179,2.6652985552817139,2.5018081062120583,17.345054484815272,7.0886326857623132,14.63262416960816,268.22208363377189,null,null,null,63.954059792558894,null,0]
["2022 - Jan",22.999999999999943,300,4.6868319056997176,0.83976071436654853,28.095105146557206,58.575026747480308,2.7010835827687152,2.5467402933687153,17.796361768499825,7.4623151679416138,14.723731682844212,268.35594291112341,null,null,null,60.652728535458976,null,0]
["2023 - Jan",23.999999999999929,300,4.7342027630748182,0.84342280905540257,29.812938852987568,62.138572095156761,2.7301045380790763,2.5891071706315394,18.235268909352992,7.8349364881453019,14.796536055314622,268.46661259433137,null,null,null,57.62040820266926,null,0]
["2024 - Jan",24.999999999999915,300,4.7717391140820986,0.84630174995963847,31.542474090439935,65.726251357457343,2.7532243323605794,2.6290500542983026,18.662350744869421,8.2062327582461752,14.85397270066183,268.55620149032723,null,null,null,54.83194604498587,null,0]
["2025 - Jan",25.999999999999901,300,4.8007627886074422,0.8485265388556007,33.281923829618947,69.334519108906875,2.7712280125526978,2.6667122734195052,19.078173796425464,8.5759993151135312,14.89849619106908,268.62691179025921,null,null,null,52.264098316065621,null,0]
["2026 - Jan",26.999999999999886,300,4.822457696709102,0.85020400500442994,35.029756570527653,72.960353083281177,2.7848208372269965,2.7022352993807957,19.483288267778519,8.9440794549122877,14.932160864455637,268.68092086539025,null,null,null,49.89565763580692,null,0]
["2027 - Jan",27.999999999999872,300,4.8378742456245929,0.85142285368181203,36.78465834356512,76.601174364685946,2.7946300559360693,2.7357562273102247,19.878223055529297,9.3103553105357548,14.956688692969966,268.72030443895846,null,null,null,47.707437069194874,null,0]
["2028 - Jan",28.999999999999858,300,4.8479372665262375,0.85225696424110486,38.54550056529331,80.25478007684255,2.8012090238206504,2.7674062095463086,20.263482869881315,9.6747404626910729,14.97352573315349,268.74699049068812,null,null,null,45.682172910050795,null,0]
["2029 - Jan",29.999999999999844,300,4.8534558919465978,0.85276806186380927,40.311312856975725,83.919286639012128,2.8050426619210915,2.7973095546337521,20.639546818678305,10.037173948080065,14.983888751919141,268.7627352548152,null,null,null,43.804385581474506,null,0]
["2030 - Jan",30.999999999999829,300,4.855134297506396,0.85300787697528446,42.081260043840409,87.593081901997579,2.8065535677782791,2.8255832871612276,21.006867992988852,10.397615391947372,14.988803606481401,268.76911457567093,null,null,null,42.060223125941249,null,0]
["2031 - Jan",31.999999999999815,300,4.85358257575251,0.85301989070971751,43.854622665431314,91.27478472460632,2.8061083028976821,2.8523370226439639,21.365873726251959,10.756041045851362,14.989136806814473,268.76752553047328,null,null,null,40.437302017622187,null,0]
["2032 - Jan",32.999999999999844,300,4.8493272692214555,0.85284074831749945,45.630780431855399,94.963210778548543,2.8040235472154347,2.8776730538954238,21.716966295017198,11.112440555369201,14.985621491972868,268.7591945735569,null,null,null,38.924553768625167,null,0]
["2033 - Jan",33.999999999999872,300,4.8428212756433684,0.85250140715414446,47.409198152897204,98.657343569573484,2.8005719286194668,2.9016865755757015,22.060523897999857,11.466814317780154,14.978878850984092,268.74518951327565,null,null,null,37.512081839188944,null,0]
["2034 - Jan",34.999999999999901,300,4.8344529684225517,0.85202807270649772,49.189413745882916,102.35630983314525,2.7959874187515172,2.9244659952327297,22.396901799183734,11.819171317965536,14.969435835660285,268.72643344011755,null,null,null,36.191030903162854,null,0]
["2035 - Jan",35.999999999999929,300,4.8245544645618565,0.85144296516149098,50.971027994511402,106.05935860592044,2.7904702436021851,2.9460932946089069,22.72643355561398,12.169527353140959,14.957739854315026,268.70371932694633,null,null,null,34.953469033827055,null,0]
["2036 - Jan",36.999999999999957,300,4.8134090312359978,0.85076495015015685,52.753695786022938,109.76584339290891,2.7841912957558841,2.9666444160245686,23.049432275348646,12.517903574753353,14.944171003106396,268.67772446268123,null,null,null,33.792282511206587,null,0]
["2037 - Jan",37.999999999999986,300,4.8012576597787522,0.85001006022468151,54.537118599650213,113.47520694804678,2.7772960598593102,2.9861896565275479,23.366191868663087,12.864325289897403,14.929052283528319,268.6490241965306,null,null,null,32.701082481440707,null,0]
["2038 - Jan",39.000000000000014,300,4.7883048582909238,0.84919192804206045,56.32103805684352,117.18696826640095,2.7699080779636356,3.0047940581128438,23.676988268088721,13.208820975718666,14.912658167202087,268.61810469190067,null,null,null,31.674122472544585,null,0]
["2039 - Jan",40.000000000000043,300,4.7747237260790891,0.84832214784754212,58.105230374678641,120.90071145240482,2.7621319897729935,3.0225177863101171,23.982080601687684,13.551421469097704,14.89522179911841,268.5853745417304,null,null,null,30.706225693111513,null,0]
["2040 - Jan",41.000000000000071,300,4.7606603780938483,0.84741057842605705,59.88950158933681,124.61607618299165,2.7540561866652511,3.0394164922680837,24.281712310167986,13.892159300944147,14.876941074628853,268.55117519913767,null,null,null,29.792721049724921,null,0]
["2041 - Jan",42.000000000000099,300,4.7462377878819897,0.84646559801448129,61.673683437592352,128.33274952941582,2.7457551191777103,3.0555416554622741,24.576112202778557,14.2310681500563,14.857983780993301,268.51579024320824,null,null,null,28.929386876348282,null,0]
["2042 - Jan",43.000000000000128,300,4.7315591150159442,0.84549431957615484,63.457629801675672,132.05045893870727,2.7372912965635061,3.0709409055513226,24.865495449925085,14.568182396021575,14.83849195883138,268.47945354017054,null,null,null,28.112401450522075,null,0]
["2043 - Jan",44.000000000000156,300,4.7167105787107459,0.84450277320046108,65.241213637365306,135.76896620653278,2.7287170147880286,3.0856583228757342,25.150064512497622,14.903536754278633,14.818585610512738,268.44235638291656,null,null,null,27.338299462107635,null,0]
["2044 - Jan",45.000000000000185,300,4.701763934199267,0.8434960611021185,67.024324317243483,139.48806229890732,2.7200758464735642,3.0997347177534835,25.430010009273019,15.237165979415396,14.798365859844726,268.40465370253889,null,null,null,26.603933691867642,null,0]
["2045 - Jan",46.000000000000213,300,4.686778602955707,0.84247848967782746,68.806865331161291,143.20756290164903,2.7114039231673219,3.1132078891662687,25.705511524645694,15.569104625180664,14.777917649184177,268.36646944832381,null,null,null,25.906441244468805,null,0]
["2046 - Jan",47.000000000000242,300,4.671803502388471,0.84145368227094297,70.588752294451083,146.9273045944544,2.702731037134106,3.1261128637117794,25.976738359488603,15.899386851650004,14.757312045376079,268.32790123036449,null,null,null,25.243213760981369,null,0]
["2047 - Jan",48.00000000000027,300,4.6568786153852555,0.84042467565100232,72.369911221582299,150.64714156160298,2.6940815868051717,3.1384821158667111,26.24385022825463,16.228046271597329,14.73660821397435,268.28902431363247,null,null,null,24.611871108666431,null,0]
["2048 - Jan",49.000000000000298,300,4.6420363352119649,0.83939400269817621,74.150277029008052,154.36694276407047,2.6854753871350461,3.1503457706952966,26.506997905568223,16.555115829449562,14.71585511145592,268.24989504536694,null,null,null,24.01023811049637,null,0]
["2049 - Jan",50.000000000000327,300,4.6273026168061344,0.8383637633654224,75.92979223608225,158.08658950864015,2.6769283634737175,3.1617317901727824,26.766323825581065,16.880627707296892,14.695092937152459,268.21055378991184,null,null,null,23.436323933842697,null,0]
["2050 - Jan",51.000000000000355,300,4.6126979614872514,0.83733568565209771,77.708405837291309,161.8059733587759,2.668453145170834,3.1726661442897015,27.021962637310288,17.204613253339136,14.674354380045239,268.17102743728293,null,null,null,22.888303807611049,null,0]
["2051 - Jan",52.000000000000384,300,4.5982382585257406,0.83631117804562738,79.486072322766105,165.52499433983149,2.6600595729924925,3.1831729680736589,27.274041719071271,17.527102928903236,14.653665690122619,268.13133154413572,null,null,null,22.364502780515974,null,0]
["2052 - Jan",53.000000000000412,300,4.5839355038487684,0.83529137465992176,81.262750827217431,169.24355939782322,2.6517551325397402,3.1932747056192814,27.522681654976754,17.848126270795284,14.633047599471341,268.09147215866966,null,null,null,21.863381270822799,null,0]
["2053 - Jan",54.000000000000441,300,4.5697984133841265,0.8342771741107764,83.038404390162015,172.9615810766872,2.6435453241949309,3.2029922421608479,27.767996676315541,18.167711866275731,14.612516114491168,268.05144737446011,null,null,null,21.383522190546259,null,0]
["2054 - Jan",55.000000000000469,300,4.5558329461189118,0.83326927301178466,84.812999312639974,176.67897638381035,2.6354339786681273,3.2123450251601606,28.010095070455417,18.485887338385776,14.592083197451366,268.01124865229895,null,null,null,20.923619455272409,null,0]
["2055 - Jan",56.000000000000497,300,4.5420427498415252,0.83226819484338221,86.586504597630579,180.3956658177996,2.6274235259501442,3.2213511753178214,28.249079559743389,18.802679339720758,14.571757352939365,267.97086194385878,null,null,null,20.482467715172522,null,0]
["2056 - Jan",57.000000000000526,300,4.5284295407086734,0.83127431483776115,88.358891463099411,184.11157253604057,2.6195152243811961,3.2300275883515592,28.485047652707085,19.118113553056027,14.551544132498625,267.93026864634703,null,null,null,20.058953163859226,null,0]
["2057 - Jan",58.000000000000554,300,4.5149934262003111,0.83028788142977394,90.130132918096706,187.82662164267828,2.6117093555948676,3.2383900283220082,28.718091969696147,19.432214697490238,14.531446568844864,267.88944641323206,null,null,null,19.652045299953812,null,0]
["2058 - Jan",59.000000000000583,300,4.5017331796639439,0.82930903474559792,91.900203393608507,191.54073958030449,2.6040053902780564,3.2464532132254678,28.94830054494469,19.745006538989628,14.51146554942923,267.84836984257811,null,null,null,19.260789531994728,null,0]
["2059 - Jan",60.000000000000611,300,4.4886464734778153,0.82833782253444121,93.669078420970479,195.25385361092424,2.596402128982219,3.2542308935153708,29.175757106886238,20.056511904401145,14.49160013773786,267.80701106143516,null,null,null,18.884300530984607,null,0]
["2060 - Jan",61.000000000000639,300,4.4757300768550499,0.82737421389194121,95.436734351609189,198.96589137374019,2.5888978216146685,3.2617359241596411,29.400541338411209,20.36675269815677,14.471847849540508,267.76534022207323,null,null,null,18.52175624667008,null,0]
["2061 - Jan",62.000000000000668,300,4.4629800234457875,0.8264181110755795,97.203148112704952,202.67678050899821,2.5814902687177241,3.2689803307902583,29.622729118625397,20.675749921022735,14.452204890295082,267.72332592355161,null,null,null,18.172392513950719,null,0]
["2062 - Jan",63.000000000000696,300,4.450391753152303,0.82546935967110424,98.968296994084511,206.38644833860195,2.5741769071965073,3.2759753704539629,29.842392747544611,20.983523690356979,14.432666359054162,267.68093557014316,null,null,null,17.835498184687012,null,0]
["2063 - Jan",64.000000000000725,300,4.4379602319358424,0.82452775733348127,100.73215846227346,210.09482159547451,2.5669548827728565,3.282731587429252,30.059601155046483,21.290093261431068,14.413226423480952,267.63813567644445,null,null,null,17.510410727965851,null,0]
["2064 - Jan",65.000000000000668,300,4.4256800528488345,0.82359306129546861,102.49470999817419,213.80182619474027,2.5598211111143678,3.2892588645344318,30.274420095294769,21.595477049451194,14.393878469948465,267.59489212755443,null,null,null,17.196512248604094,null,0]
["2065 - Jan",66.000000000000611,300,4.4135455210592189,0.82266499481071731,104.25592895530271,217.50738704074936,2.5527723293062268,3.2955664703143537,30.486912327753803,21.899692651978615,14.374615232150724,267.55117040146433,null,null,null,16.893225879590993,null,0]
["2066 - Jan",67.000000000000554,300,4.401550411386645,0.82174569169557121,106.01579173881845,221.21142641022112,2.5458048469104746,3.3016630807495417,30.697137702957033,22.202756751637434,14.355425880773337,267.50763948128133,null,null,null,{"$f":"1000*(F106-F105)/F106","v":16.60000604298045},null,{"$f":"100*(C105-C106)/C105","v":0}]
["2067 - Jan",68.000000000000497,300,4.3896879501806767,0.82083824961514384,107.77427338110751,224.91386315538139,2.5389146070550344,3.3075568111085256,30.905153286484513,22.504685086210252,14.336297621785951,267.46521225386527,null,null,null,16.316339578284847,null,0]
["2068 - Jan",69.000000000000441,300,4.3779520927801361,0.81993664032108171,109.53134999750641,228.61461791201634,2.5320983742928513,3.3132553320581866,31.111013808428801,22.805492909410535,14.31722807848378,267.42216072101922,null,null,null,16.041769013519019,null,0]
["2069 - Jan",70.000000000000384,300,4.3663367130418376,0.81904011661160958,111.28699718802788,232.3136098438782,2.5253526070358152,3.3187658549125274,31.314771616347461,23.105194750670726,14.298208494904154,267.37845046619367,null,null,null,15.775851940323019,null,0]
["2070 - Jan",71.000000000000327,300,4.3548356397993642,0.8181482803083181,113.04118996248006,236.01075655959161,2.5186737325767408,3.3240951628111342,31.516476802680636,23.403804436270711,14.279229854790904,267.33404714366736,null,null,null,15.518173287404524,null,0]
["2071 - Jan",72.00000000000027,300,4.343442687006668,0.8172607456852371,114.79390267492231,239.70597404406931,2.512058165426907,3.3292496395009503,31.716177323869577,23.701335110033455,14.260282933684852,267.28891656527668,null,null,null,15.268343279569859,null,0]
["2072 - Jan",73.000000000000213,300,4.3321516785260901,0.81637711833225701,116.54510896628103,243.39917660226351,2.5055023224179487,3.3342352959214083,31.913919111788555,23.997799253524324,14.24135834317299,267.24302477724012,null,null,null,15.025995572799097,null,0]
["2073 - Jan",74.000000000000156,300,4.3209564683814303,0.81549699538166165,118.29478171410369,247.0902768133891,2.4990026350628227,3.3390577947755213,32.109746178054053,24.293208705706842,14.222446568399475,267.19633812891618,null,null,null,14.790785548354014,null,0]
["2074 - Jan",75.000000000000099,300,4.3098509571777646,0.81461996693213679,120.04289298856527,250.77918549402168,2.4925555595988609,3.3437224732536177,32.303700711730812,24.58757468202241,14.203537999792518,267.14882333507194,null,null,null,14.56238875072842,null,0]
["2075 - Jan",76.000000000000043,300,4.2988291052878198,0.81374561732159145,121.78941401395929,254.46581166870612,2.4861575850745603,3.3482343640619208,32.495823170913553,24.880907792872801,14.184622959832588,267.10044753300832,null,null,null,14.340499455838042,null,0]
["2076 - Jan",76.999999999999986,300,4.2878849433174375,0.81287352618827791,123.53431513500765,258.15006254691127,2.4798052397891155,3.352598214894952,32.68615236862555,25.17321806149371,14.165691725575751,267.05117833569784,null,null,null,14.124829357263184,null,0]
["2077 - Jan",77.999999999999929,300,4.2770125802879351,0.81200326934393985,125.27756578741398,261.83184350534231,2.4734950963487154,3.3568185064787506,32.874725553441266,25.464514941216319,14.146734547549686,267.00098388192504,null,null,null,13.915106359621392,null,0]
["2078 - Jan",78.999999999999872,300,4.2662062099092219,0.81113441948478715,127.01913447216204,265.51105807477103,2.4672237755650284,3.3608994693009047,33.06157848520813,25.754807332119032,14.127741665556455,266.94983288428068,null,null,null,13.711073469247648,null,0]
["2079 - Jan",79.999999999999815,300,4.2554601152626201,0.81026654676301701,128.75898873312948,269.18760793067707,2.4609879493882838,3.3648450991334711,33.246745506214182,26.044103597078024,14.108703321843761,266.8976946757445,null,null,null,13.512487773366505,null,0]
["2080 - Jan",80.999999999999758,300,4.2447686721655309,0.80939921923858937,130.49709513764628,272.8613928871053,2.4547843430390603,3.3686591714457546,33.430259608121183,26.332411577228338,14.089609772044218,266.84453925548826,null,null,null,13.319119499813169,null,0]
["2081 - Jan",81.999999999999702,300,4.2341263514497989,0.8085320032283243,132.23341925967839,276.53231089324203,2.4486097364787005,3.372345254795647,33.612152494958835,26.619738606851445,14.070451294227684,266.79033733444828,null,null,null,13.130751150148582,null,0]
["2082 - Jan",82.999999999999645,300,4.2235277203512904,0.80766446356710575,133.96792566536328,280.20025803229987,2.4424609653375033,3.3759067232807358,33.792454642452896,26.90609152770697,14.051218196365353,266.73506038114505,null,null,null,12.947176699723617,null,0]
["2083 - Jan",83.999999999999588,300,4.2129674431787354,0.80679616379398589,135.70057790066232,283.86512852237223,2.4363349214021248,3.3793467681234954,33.971195353939763,27.191476702828986,14.031900822463383,266.67868066816641,null,null,null,12.768200858860054,null,0]
["2084 - Jan",84.999999999999531,300,4.2024402814046962,0.80592666627426113,137.43133848093015,287.52681471898347,2.4302285527484333,3.3826684084586476,34.14840281310093,27.47590002980823,14.012489557589143,266.6211713196804,null,null,null,12.593638389893041,null,0]
["2085 - Jan",85.999999999999474,300,4.191941093299981,0.80505553226709725,139.16016888223089,291.18520711911532,2.4241388635930567,3.3858745013850826,34.324104133733407,27.759366953582933,13.992974831982607,266.56250636030308,null,null,null,12.423313475307888,null,0]
["2086 - Jan",86.999999999999417,300,4.1814648332143998,0.80418232194698824,140.88702953425752,294.84019436653819,2.4180629139257692,3.3889677513395422,34.498325406756194,28.041882478761458,13.973347124419451,266.50266076560933,null,null,null,12.257059132662981,null,0]
["2087 - Jan",87.999999999999361,300,4.1710065505910174,0.803306594386206,142.61187981473392,298.49166325831754,2.411997818975383,3.3919507188445421,34.67109174463836,28.323451181500811,13.953596964969663,266.44161051454716,null,null,null,12.094716672391835,null,0]
["2088 - Jan",88.999999999999304,300,4.1605613887876149,0.80242790750443005,144.33467804519921,302.13949875240058,2.4059407485536606,3.3948258286786848,34.842427323420409,28.604077220964626,13.933714937275887,266.37933264399203,null,null,null,11.936135194937581,null,0]
["2089 - Jan",89.999999999999247,300,4.1501245837676164,0.80154581799090407,146.0553814880918,305.78358397622043,2.3998889263149055,3.3975953775135888,35.012355422488625,28.883764350385061,13.913691680459037,266.31580530565753,null,null,null,11.781171124001876,null,0]
["2090 - Jan",90.99999999999919,300,4.1396914627129577,0.80065988120373954,147.77394634506564,309.4238002362801,2.3938396289629433,3.4002615410580534,35.180898462250219,29.162515927752153,13.893517890744022,266.25100782556524,null,null,null,11.629687772977492,null,0]
["2091 - Jan",91.999999999999133,300,4.1292574426030342,0.79976965105036169,149.49032775648655,313.06002702870489,2.3877901854322019,3.4028263807468244,35.348078039846925,29.440334926154549,13.873184322885933,266.18492076626251,null,null,null,11.481554941914535,null,0]
["2092 - Jan",92.999999999999076,300,4.1188180287968104,0.79887467985254301,151.20447980206612,316.69214205076827,2.3817379760653123,3.4052918500082949,35.513914963034665,29.717223943794849,13.852681791466376,266.11752599196927,null,null,null,11.336648542579386,null,0]
["2093 - Jan",93.999999999999019,300,4.1083688136491734,0.79797451819901777,152.91635550260463,320.32002121341861,2.3756804318060492,3.4076598001427869,35.678429282348375,29.993185213702827,13.832001172120243,266.04880673682891,null,null,null,11.194850249418579,null,0]
["2094 - Jan",94.999999999998963,300,4.0979054751874804,0.79706871478825692,154.62590682282024,323.94353865484288,2.3696150334233153,3.4099319858404886,35.841640321662318,30.268220613168719,13.811133402745405,265.97874767643214,null,null,null,11.05604717438791,null,0]
["2095 - Jan",95.999999999998906,300,4.0874237758700049,0.79615681626365187,156.33308467525359,327.56256675512452,2.3635393107792964,3.4121100703659195,36.00356670724905,30.542331672918941,13.790069484740989,265.90733500278287,null,null,null,10.920131563831292,null,0]
["2096 - Jan",96.999999999998849,300,4.0769195614443001,0.79523836704305317,158.03783892524302,331.17697615205918,2.3574508421527107,3.4141956304336403,36.164226395433147,30.815519586055977,13.768800484314134,265.83455650287266,null,null,null,10.787000515717242,null,0]
["2097 - Jan",97.999999999998792,300,4.0663887599205175,0.79431290914436714,159.74011839697178,334.78663575820275,2.3513472536262228,3.4161901607980294,36.323636698929043,31.087785216783466,13.747317533890202,265.76040164103165,null,null,null,10.6565557156932,null,0]
["2098 - Jan",98.999999999998735,300,4.055827380672083,0.79337998200870419,161.43987088059617,338.39141277923812,2.3452262185455419,3.4180950785782067,36.481814311946721,31.359129108937122,13.725611833657309,265.68486164522744,null,null,null,10.528703190561652,null,0]
["2099 - Jan",99.999999999998678,300,4.0452315136741088,0.79243912232238856,163.13704314046876,341.99117273375373,2.3390854570564517,3.4199117273375825,36.638775334143396,31.62955149434206,13.703674653272492,265.60792959748414,null,null,null,10.40335307788582,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M152/30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M153/30","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M165/30","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M190/30","v":0}]