{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FS_FOR_599_Outline","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":"FS_FOR_599_Outline","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[31,1,32,1],[31,2,32,2],[24,1,25,1],[24,2,25,2],[27,1,28,1],[27,2,28,2],[29,1,30,1],[29,2,30,2],[8,1,10,1],[8,2,10,2],[11,1,13,1],[18,1,19,1],[21,1,22,1],[21,2,22,2],[6,1,7,1],[6,2,7,2],[1,0,2,0],[1,1,2,1],[1,2,2,2],[3,1,4,1],[3,2,4,2]]}
["Course Schedule"]
["Week","Lecture","            Exercise"]
[]
["Week 1","-          Introduction","-          From quantum yield to NPP using radiation"]
["(01/10)"]
[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."]

{"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,10,4.6800000000000006,5,4.6255876547168802,5,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,10,7.2,5,6.4245816013305452,5,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,11.16,5,6.5350358072787991,5,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,10,15.840000000000002,5,6.6232488839444166,5,2]
[null,"and Latitude (+44.12), Insert Months, 1 through 12",null,null,null,null,null,"May",19.5,6.9,10,19.8,5,7.4122964214200726,5,0]
[null,"and copy values into the Rad. Predicted column",null,null,null,null,null,"Jun",23.4,9.8000000000000007,10,22.32,5,8.7834787061231303,5,0]
[null,"in the adjacent table.",null,null,null,null,null,"Jul",27.6,11.6,10,24.12,5,9.3563290922897355,5,0]
[null,"Fit linear relation to trend line and determine slope (forced through zero)",null,null,null,null,null,"Aug",27.7,11.8,10,20.88,5,8.7887993802432032,5,0]
[null," and derive r2.",null,null,null,null,null,"Sep",24.6,9.6,10,15.840000000000002,5,7.6502260032476759,5,0.5]
[null,null,null,null,null,null,null,"Oct",18.100000000000001,6.4,10,9.7200000000000006,5,6.5366129874997156,5,2]
["VPD","2) Go to 3-PG function tools and substitute",null,null,null,null,null,"Nov",11.3,4.3,10,5.04,5,6.4783067636167662,5,7]
[null,"mean max and min monthly temperatures into",null,null,null,null,null,"Dec",7.9,2.2000000000000002,10,3.6,5,6.1198799353595543,5,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",10,5,{"$f":"D18-E18","v":5},{"$f":"($D$31*0.0001+1.0142)*0.65","v":0.66897999999999991},{"$f":"0.031+0.201 * EXP(-0.185 * F18)","v":0.11070281523407356},{"$f":"G18*(1-EXP(-(H18*F18^1.5)))","v":0.47494102062478399},-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":105.72447581155284},{"$f":"(((Q18*2)/PI())*S18)/1000000","v":2.2352550453371731},{"$f":"(S18*Q18)/1000000","v":3.5111304146653919},{"$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":45.815122535456041},{"$f":"W18*I18^O18","v":8.2188711659026605},{"$f":"SQRT(X18*W18)","v":19.404859947161608},{"$f":"(1-(Y18/W18)) * Y18","v":11.185988781258949},{"$f":"(Z18*Q18)/1000000","v":0.37148886411118437},{"$f":"(((Q18*2)/PI())*Z18)/1000000","v":0.23649715610755356},{"$f":"AB18+T18","v":2.4717522014447266},{"$f":"AC18*30","v":74.152566043341793},{"$f":"AC18*0.8","v":1.9774017611557815},4.3893238821879397]
[14.9,-1.9046934865900651E-2,2,10,5,5,0.66897999999999991,0.11070281523407356,{"$f":"G19*(1-EXP(-(H19*F19^1.5)))","v":0.47494102062478399},-12.65,44.12,0,0,0.54800127718374081,1.8248129322943425,10.330966976042664,37191.481113753587,1.36,191.53510648578873,4.5349445844592466,7.1234742954869938,5897.5282871130694,104.96148297973602,26.974777218031196,53.210080058693322,26.235302840662122,0.97572977011209105,0.62116886414103201,5.1561134486002782,154.68340345800834,4.1248907588802224,7.26]
[18.288888888888891,7.3677568697730136E-2,3,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,-1.95,44.12,0,0,0.69377901288838395,1.4413809545760732,11.748778654906333,42295.603157662794,1.36,322.60764990588933,8.6866036692912107,13.644885136045705,7513.0195238184815,223.81841690194926,76.526246895441801,130.87392189273422,54.347674997292401,2.2986676942271114,1.4633773042475771,10.149980973538788,304.49942920616365,8.1199847788310304,11.08]
[21.222222222222225,5.2572685185185195,4,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,9.4499999999999993,44.12,0,0,0.82244200238083343,1.2158910604225708,13.233272327209262,47639.780377953342,1.36,452.34861945425843,13.719021694583503,21.549788885071262,9048.5127400607998,372.0305043581659,150.45534817806873,236.58820567828474,86.132857500216033,4.1033504146358428,2.6122740069098911,16.331295701493396,489.93887104480189,13.065036561194717,14.82]
[28.777777777777779,10.754719235364394,5,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,18.350000000000001,44.12,0,0,0.90054653444876576,1.1104366634073435,14.490859080326844,52167.092689176636,1.36,535.76447591184024,17.793061135742352,27.949275074461113,10224.289010170496,482.48084206316696,211.06145121256534,319.11299990459895,108.05154869203359,5.6367351558263987,3.5884570517985459,21.381518187540898,641.44554562622693,17.10521455003272,20.100000000000001]
[27.944444444444443,14.067322530864198,6,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,22.55,44.12,0,0,0.92996910799274912,1.0753044201951651,15.152003158490965,54547.211370567471,1.36,567.93240656914907,19.721926068246702,30.979129025322436,10803.218603641841,528.15959353728692,237.16707237604797,353.92381178236906,116.7567394063211,6.3687545433348616,4.0544750676428398,23.776401135889543,713.29203407668626,19.021120908711634,21]
[30.555555555555557,17.290583930704898,7,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,20.75,44.12,0,0,0.91796244601992949,1.0893690644958944,14.861457814571917,53501.248132458903,1.36,554.75994302611616,18.895097257038884,29.680349365789002,10551.765679224232,509.2487942541303,226.29308410760268,339.46940985874585,113.17632575114315,6.0550746867319081,3.8547802687359716,22.749877525774856,682.49632577324564,18.199902020619884,22.92]
[29.277777777777782,16.381242532855435,8,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,13.45,44.12,0,0,0.86011947336467931,1.1626290471313496,13.780403149570841,49609.451338455023,1.36,492.20904407382301,15.545122052934456,24.418220620327787,9573.1195969026994,423.35858377410887,178.13951696181368,274.62136409091937,96.48184712910566,4.7864115001956238,3.0471241997121115,18.592246252646568,557.767387579397,14.873797002117255,19.52]
[27.5,11.232152777777777,9,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,2.9,44.12,0,0,0.75218493706411138,1.3294601071873842,12.373868069861375,44545.925051500948,1.36,380.16216866469819,10.780949244583327,16.934675472753707,8180.0467729951442,285.95225691121209,106.26711359106353,174.31959432836217,68.052480737298637,3.0314607064924171,1.9298878249084699,12.710837069491797,381.32511208475393,10.168669655593439,13.56]
[24.055555555555554,5.1651209677419354,10,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,-8.4499999999999993,44.12,0,0,0.60779171096914464,1.6453002195035602,10.900238531288743,39240.85871263947,1.36,242.81129082739824,6.0657918500694725,9.528123557191547,6561.6943883914601,147.57868989461096,43.350972759755415,79.985497220069036,36.634524460313621,1.4375701983519016,0.91518561243720642,6.9809774625066794,209.4293238752004,5.584781970005344,8.6999999999999993]
[13.555555555555555,-4.92701851851852,11,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,-17.850000000000001,44.12,0,0,0.46993380868915913,2.12795880763194,9.5842379556244683,34503.256640248088,1.36,131.06241336537576,2.8788455938541939,4.5220800842358413,5003.4134642179724,61.590659088783987,12.630408968497518,27.891131438696611,15.260722470199092,0.52654462390487999,0.33520871861169843,3.2140543124658922,96.421629373976771,2.5712434499727141,5]
[12.4,-5.1927150537634397,12,10,5,5,0.66897999999999991,0.11070281523407356,0.47494102062478399,-22.35,44.12,0,0,0.39922918577574457,2.5048262630756022,8.8808759482208242,31971.15341359497,1.36,84.100731329343716,1.7117415782428582,2.6887973835259809,4150.3940093763404,33.575466491758547,5.2006860368606302,13.214214307508813,8.0135282706481821,0.25620174172507343,0.1631030944971941,1.8748446727400523,56.245340182201566,1.499875738192042,4.18]
["Month","List  output  D46","Input parameters"]
["Jan",10,"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",10,"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,"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",10,"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",10,"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",10,"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",10,"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",10,"Month",1,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",10,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",10,"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",10,"Transmissivity",{"$f":"INDEX($I18:$I29,Month)","v":0.47494102062478399},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",10,"Integrated Solar (Month)",{"$f":"BP83","v":51.293633161333219},"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.5718514842819831},"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.0644183057535784E-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":58.388547844559824},"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.8083486403895366},"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":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,{"$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":29},{"$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":30},{"$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":31},null,"Equn. 2 in Kaufmann + Weatherred (1982)"]
[null,null,"Time of Year (radians)",{"$f":"2*PI()*D$49/365","v":1.7214206321039961E-2},3.4428412642079922E-2,5.1642618963119884E-2,6.8856825284159845E-2,8.6071031605199813E-2,0.10328523792623977,0.12049944424727974,0.13771365056831969,0.15492785688935967,0.17214206321039963,0.18935626953143955,0.20657047585247953,0.22378468217351952,0.24099888849455947,0.2582130948155994,0.27542730113663938,0.29264150745767936,0.30985571377871934,0.32706992009975927,0.34428412642079925,0.36149833274183923,0.37871253906287911,0.39592674538391909,0.41314095170495907,0.43035515802599905,0.44756936434703903,0.46478357066807896,0.48199777698911894,0.49921198331015892,0.5164261896311988,0.53364039595223878,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.0350691872706816},1.0350773742999697,1.0350745574444737,1.0350607370827396,1.0350359176156809,1.0350001074649109,1.0349533190689839,1.0348955688775416,1.0348268773433764,1.034747268912412,1.0346567720116098,1.034555419034813,1.0344432463265361,1.0343202941637168,1.0341866067354373,1.0340422321206411,1.0338872222638511,1.0337216329489185,1.033545523770818,1.0333589581055111,1.0331620030779016,1.0329547295279131,1.0327372119747056,1.0325095285790715,1.0322717611040286,1.0320239948736505,1.0317663187301604,1.0314988249893251,1.0312216093941828,1.030934771067143,1.0306384124604904,null,"Equn. A.7 in Hartmann (1994)"]
[null,null,"Solar input at top of Atmos",{"$f":"Solar_Constant*D$51","v":1407.6940946881271},1407.7052290479587,1407.7013981244843,1407.6826024325258,1407.6488479573261,1407.6001461522787,1407.536513933818,1407.4579736734565,1407.364553186992,1407.2562857208802,1407.1332099357892,1406.9953698873455,1406.8428150040891,1406.6756000626549,1406.4937851601946,1406.2974356840718,1406.0866222788375,1405.8614208105291,1405.6219123283124,1405.3681830234952,1405.1003241859462,1404.8184321579618,1404.5226082855995,1404.2129588675373,1403.889595101479,1403.5526330281646,1403.2021934730183,1402.8384019854821,1402.4613887760886,1402.0712886513145,1401.6682409462669]
[null,null,"delta (Solar declination)",{"$f":"23.5*SIN((0.9863*(284+D$49))*PI()/180)","v":-23.060732867730863},-22.97946965958149,-22.891397157548688,-22.796541459343079,-22.69493067267711,-22.586594906936188,-22.471566264256609,-22.349878830013026,-22.221568662718287,-22.086673783338515,-21.945234164026704,-21.797291716278131,-21.642890278511189,-21.48207560307705,-21.314895342702336,-21.141399036368622,-20.961638094633049,-20.77566578439426,-20.583537213108304,-20.385309312459171,-20.181040821488793,-19.970792269191378,-19.754625956577467,-19.532605938212793,-19.304798003237646,-19.07126965587215,-18.832090095413385,-18.587330195730136,-18.337062484261583,-18.081361120525877,-17.820301874145091,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.6255819516080674},7.618775217352777,7.6114135257900406,7.6035026296092294,7.5950486523661915,7.5860580718552972,7.5765377027994303,7.5664946789502681,7.5559364346919287,7.5448706862410457,7.5333054125355998,7.5212488359033447,7.5087094025986723,7.4956957632940435,7.482216753608939,7.4682813747556738,7.4538987743773362,7.4390782276487091,7.4238291187064105,7.4081609224695724,7.3920831869073433,7.3756055158043923,7.3587375520703526,7.3414889616340799,7.3238694179583348,7.3058885872056312,7.2875561140809619,7.2688816083724817,7.2498746322066534,7.2305446880300392,7.2109012073258363,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.374418048391931},16.381224782647223,16.388586474209959,16.396497370390769,16.404951347633808,16.413941928144702,16.423462297200569,16.433505321049733,16.44406356530807,16.455129313758952,16.466694587464399,16.478751164096657,16.491290597401328,16.504304236705956,16.517783246391062,16.531718625244327,16.546101225622664,16.560921772351293,16.576170881293589,16.591839077530427,16.607916813092658,16.624394484195609,16.641262447929648,16.658511038365919,16.676130582041665,16.694111412794371,16.712443885919036,16.731118391627518,16.750125367793345,16.76945531196996,16.789098792674164,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.7488360967838652},8.7624495652944461,8.7771729484199188,8.7929947407815412,8.8099026952676169,8.8278838562894055,8.8469245944011394,8.8670106420994639,8.8881271306161427,8.9102586275179085,8.9333891749288004,8.9575023281933106,8.9825811948026555,9.008608473411913,9.035566492782122,9.0634372504886525,9.0922024512453277,9.1218435447025819,9.152341762587179,9.1836781550608553,9.2158336261853133,9.2487889683912154,9.2825248958592947,9.3170220767318401,9.3522611640833304,9.3882228255887377,9.4248877718380761,9.4622367832550367,9.5002507355866932,9.5389106239399215,9.5781975853483274]
[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":9.4054448410636864E-3},1.0546542070612655E-2,1.1910265412585207E-2,1.3538702932984958E-2,1.5482354869841546E-2,1.7801640318690304E-2,2.0568636539100318E-2,2.3869072434471186E-2,2.78045964101588E-2,3.2495336432650519E-2,3.8082766564816087E-2,4.4732889439867335E-2,5.2639738003563516E-2,6.2029192399955795E-2,7.3163099165627341E-2,8.6343670068856834E-2,0.10191812719701863,0.1202835495456734,0.14189186475094773,0.16725491814282453,0.19694954042808141,0.2316225255023166,0.27199542159789303,0.31886903262532013,0.37312752253019416,0.43574201406143298,0.50777357472957885,0.59037548702159015,0.68479470711266266,0.79237242624690962,0.9145436614102499,null,33.859601427829269,37.967551454205562,42.876955485306745,48.739330558745849,55.736477531429564,64.085905147285089,74.047091540761144,85.928660764096264,100.09654707657168,116.98321115754187,137.09795963333792,161.03840198352242,189.50305681282865,223.30509263984086,263.3871569962584,310.83721224788462,366.90525790926711,433.02077836442425,510.81071310341184,602.11770531416835,709.01834554109303,833.8410918083398,979.1835177524149,1147.9285174511524,1343.2590811086989,1568.6712506211588,1827.9848690264839,2125.3517532777246,2465.2609456055857,2852.5407344888745,3292.3571810768995]
[null,null,8,{"$f":"IF(D117>0,D$52*Transmissivity^D117*D92,0)","v":9.7120640923800234},9.9063922833706961,10.119750135388983,10.352770742421447,10.606136821013697,10.880580533908498,11.176883211090468,11.495874952193175,11.838434094019251,12.20548652690842,12.598004843867844,13.017007306769852,13.463556614525842,13.938758458970909,14.443759855239847,14.979747234684181,15.54794428986416,16.14960956284428,16.786033769908343,17.458536857884376,18.168464789500501,18.917186057569868,19.706087930287616,20.536572432501355,21.410052070445865,22.327945310089909,23.291671821888048,24.302647507336314,25.362279325253624,26.471959938131295,27.633062201164826,null,34963.430732568086,35663.012220134508,36431.100487400341,37269.97467271721,38182.092555649309,39170.089922070591,40236.779559925686,41385.149827895431,42618.362738469303,43939.751496870311,45352.817437924241,46861.226304371463,48468.80381229303,50179.530452295272,51997.53547886345,53927.090044863049,55972.599443510975,58138.594426239404,60429.721571670038,62850.732688383752,65406.473242201806,68101.869807251525,70941.916549035421,73931.66075700488,77076.187453605118,80380.603116323677,83850.018558796975,87489.531026410725,91304.205570913051,95299.055777272661,99479.023924193374]
[null,null,9,{"$f":"IF(D118>0,D$52*Transmissivity^D118*D93,0)","v":44.485277790038658},44.96048027499306,45.478221710173884,46.039105286802076,46.643773454681806,47.292906255440897,47.987219510710744,48.727462862330285,49.514417662026588,50.348894708487023,51.231731830275443,52.163791313685039,53.145957175327823,54.179132280060138,55.264235305703366,56.402197556956935,57.593959631890129,58.84046794544588,60.14267111546647,61.501516217877302,62.917944918787981,64.392889492426406,65.927268734950744,67.521983785319136,69.177913865485223,70.89591195325427,72.676800402129189,74.521366523424717,76.430358146788578,78.404479176050259,80.444385158002802,null,160147.00004413916,161857.728989975,163721.59815662599,165740.77903248748,167917.58443685449,170254.46251958722,172753.99023855868,175418.86630438903,178251.90358329573,181256.0209505533,184434.23458899159,187789.64872926613,191325.44583118017,195044.8762082165,198951.24710053211,203047.91120504498,207338.25467480446,211825.68460360516,216513.61601567929,221405.4583843583,226504.60170763673,231814.40217273505,237338.16744582268,243079.1416271489,249040.48991574682,255225.28303171537,261636.48144766508,268276.919484329,275149.28932843887,282256.12503378093,289599.78656881012]
[null,null,10,{"$f":"IF(D119>0,D$52*Transmissivity^D119*D94,0)","v":79.620167561267792},80.265287513381963,80.966593045900225,81.724575016632087,82.53975288798533,83.412672785884439,84.34390541635706,85.334043840813777,86.383701111466351,87.493507768798821,88.664109203517228,89.896162885973141,91.190335466655483,92.547299751995837,93.967731560405582,95.452306464179443,97.001696423628033,98.616566320561105,100.29757039899732,102.04534862175481,103.8605229523326,105.74369357225756,107.69543504479694,109.71629243666105,111.80677740998333,113.96736429751657,116.19848617455773,118.50053094165726,120.87383743262951,123.31869156278995,125.83532253266914,null,286632.60322056402,288955.03504817508,291479.73496524082,294208.47005987552,297143.11039674719,300285.62202918396,303638.05949888541,307202.55782692961,310981.32400127884,314976.62796767574,319190.79313266202,323626.1863895033,328285.20767995971,333170.27910718502,338283.8336174601,343628.30327104602,349206.10712506092,355019.63875401998,361071.25343639037,367363.25503831735,373897.88262839738,380677.29686012719,387703.56616126897,394978.6527719798,402504.39867594,410282.51147105964,418314.55022840784,426601.91138996615,435145.81475746626,443947.28962604381,453007.16111760889]
[null,null,11,{"$f":"IF(D120>0,D$52*Transmissivity^D120*D95,0)","v":93.640406937891598},94.340198756583334,95.100504129812265,95.921770543327696,96.804470352362657,97.749098803311668,98.756171915663245,99.826224226092279,100.95980639703923,102.15748269257126,103.41982832481314,104.74742667478311,106.14086639203673,107.60073837812787,109.12763265952201,110.72213515625246,112.38482435327386,114.11626788215348,115.91701902141698,117.78761312455789,119.72856398538983,121.74036015109142,123.82346119392687,125.9782939532508,128.20524875997594,130.50467565623526,132.87688062345106,135.32212183247569,137.84060592983988,140.4324843744736,143.09784983950416,null,337105.46497640974,339624.7155237,342361.81486732414,345318.37395597971,348496.09326850559,351896.75569192198,355522.21889638767,359374.40721393219,363455.30302934122,367766.93769325654,372311.38196932728,377090.73602921923,382107.11901133222,387362.65816126036,392859.47757427924,398599.68656250887,404585.36767178588,410818.56437575252,417301.26847710111,424035.40724840842,431022.83034740336,438265.29654392914,445764.46029813675,453521.85823170288,461538.89553591341,469816.83236244693,478356.77024442382,487159.6385969125,496226.18134742358,505556.94374810497,515152.25942221499]
[null,null,12,{"$f":"IF(D121>0,D$52*Transmissivity^D121*D96,0)","v":79.620167561267792},80.265287513381963,80.966593045900225,81.724575016632087,82.53975288798533,83.412672785884439,84.34390541635706,85.334043840813777,86.383701111466351,87.493507768798821,88.664109203517228,89.896162885973141,91.190335466655483,92.547299751995837,93.967731560405582,95.452306464179443,97.001696423628033,98.616566320561105,100.29757039899732,102.04534862175481,103.8605229523326,105.74369357225756,107.69543504479694,109.71629243666105,111.80677740998333,113.96736429751657,116.19848617455773,118.50053094165726,120.87383743262951,123.31869156278995,125.83532253266914,null,286632.60322056402,288955.03504817508,291479.73496524082,294208.47005987552,297143.11039674719,300285.62202918396,303638.05949888541,307202.55782692961,310981.32400127884,314976.62796767574,319190.79313266202,323626.1863895033,328285.20767995971,333170.27910718502,338283.8336174601,343628.30327104602,349206.10712506092,355019.63875401998,361071.25343639037,367363.25503831735,373897.88262839738,380677.29686012719,387703.56616126897,394978.6527719798,402504.39867594,410282.51147105964,418314.55022840784,426601.91138996615,435145.81475746626,443947.28962604381,453007.16111760889]
[null,null,13,{"$f":"IF(D122>0,D$52*Transmissivity^D122*D97,0)","v":44.485277790038658},44.96048027499306,45.478221710173884,46.039105286802076,46.643773454681806,47.292906255440897,47.987219510710744,48.727462862330285,49.514417662026588,50.348894708487023,51.231731830275443,52.163791313685039,53.145957175327823,54.179132280060138,55.264235305703366,56.402197556956935,57.593959631890129,58.84046794544588,60.14267111546647,61.501516217877302,62.917944918787981,64.392889492426406,65.927268734950744,67.521983785319136,69.177913865485223,70.89591195325427,72.676800402129189,74.521366523424717,76.430358146788578,78.404479176050259,80.444385158002802,null,160147.00004413916,161857.728989975,163721.59815662599,165740.77903248748,167917.58443685449,170254.46251958722,172753.99023855868,175418.86630438903,178251.90358329573,181256.0209505533,184434.23458899159,187789.64872926613,191325.44583118017,195044.8762082165,198951.24710053211,203047.91120504498,207338.25467480446,211825.68460360516,216513.61601567929,221405.4583843583,226504.60170763673,231814.40217273505,237338.16744582268,243079.1416271489,249040.48991574682,255225.28303171537,261636.48144766508,268276.919484329,275149.28932843887,282256.12503378093,289599.78656881012]
[null,null,14,{"$f":"IF(D123>0,D$52*Transmissivity^D123*D98,0)","v":9.7120640923800234},9.9063922833706961,10.119750135388983,10.352770742421447,10.606136821013697,10.880580533908498,11.176883211090468,11.495874952193175,11.838434094019251,12.20548652690842,12.598004843867844,13.017007306769852,13.463556614525842,13.938758458970909,14.443759855239847,14.979747234684181,15.54794428986416,16.14960956284428,16.786033769908343,17.458536857884376,18.168464789500501,18.917186057569868,19.706087930287616,20.536572432501355,21.410052070445865,22.327945310089909,23.291671821888048,24.302647507336314,25.362279325253624,26.471959938131295,27.633062201164826,null,34963.430732568086,35663.012220134508,36431.100487400341,37269.97467271721,38182.092555649309,39170.089922070591,40236.779559925686,41385.149827895431,42618.362738469303,43939.751496870311,45352.817437924241,46861.226304371463,48468.80381229303,50179.530452295272,51997.53547886345,53927.090044863049,55972.599443510975,58138.594426239404,60429.721571670038,62850.732688383752,65406.473242201806,68101.869807251525,70941.916549035421,73931.66075700488,77076.187453605118,80380.603116323677,83850.018558796975,87489.531026410725,91304.205570913051,95299.055777272661,99479.023924193374]
[null,null,15,{"$f":"IF(D124>0,D$52*Transmissivity^D124*D99,0)","v":9.4054448410636864E-3},1.0546542070612655E-2,1.1910265412585207E-2,1.3538702932984958E-2,1.5482354869841546E-2,1.7801640318690304E-2,2.0568636539100318E-2,2.3869072434471186E-2,2.78045964101588E-2,3.2495336432650519E-2,3.8082766564816087E-2,4.4732889439867335E-2,5.2639738003563516E-2,6.2029192399955795E-2,7.3163099165627341E-2,8.6343670068856834E-2,0.10191812719701863,0.1202835495456734,0.14189186475094773,0.16725491814282453,0.19694954042808141,0.2316225255023166,0.27199542159789303,0.31886903262532013,0.37312752253019416,0.43574201406143298,0.50777357472957885,0.59037548702159015,0.68479470711266266,0.79237242624690962,0.9145436614102499,null,33.859601427829269,37.967551454205562,42.876955485306745,48.739330558745849,55.736477531429564,64.085905147285089,74.047091540761144,85.928660764096264,100.09654707657168,116.98321115754187,137.09795963333792,161.03840198352242,189.50305681282865,223.30509263984086,263.3871569962584,310.83721224788462,366.90525790926711,433.02077836442425,510.81071310341184,602.11770531416835,709.01834554109303,833.8410918083398,979.1835177524149,1147.9285174511524,1343.2590811086989,1568.6712506211588,1827.9848690264839,2125.3517532777246,2465.2609456055857,2852.5407344888745,3292.3571810768995]
[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.3006592521738078},1.3126522031431775,1.3257124359968289,1.3398543001472578,1.3550931410020706,1.3714452764438998,1.3889279716742087,1.4075594124538886,1.4273586767695818,1.4483457049457704,1.4705412682077499,1.493966935679468,1.5186450397718236,1.5445986398819336,1.5718514842819831,1.6004279700289126,1.630353100674357,1.6616524415002107,1.6943520719507874,1.7284785348811555,1.7640587821949574,1.8011201164077733,1.8396901276458957,1.8797966255788725,1.9214675657887148,1.9647309701018865,2.0096148404522167,2.0561470659048791,2.1043553225522711,2.1542669660912774,2.2059089170055932,null,{"$f":"SUM(AJ83:BN83)","v":51.293633161333219}]
[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.82292591835085482},{"$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.82258534826877494},{"$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.82221266732272347},{"$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.82180713240654701},{"$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.82136795079094393},{"$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.8208942820437195},{"$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.82038524007467295},{"$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.81983989530188761},{"$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.81925727693594563},{"$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.81863637537835432},{"$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.81797614473021918},{"$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.81727550540696381},{"$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.81653334685463497},{"$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.81574853036309936},{"$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.8149198919711772},{"$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.81404624545852067},{"$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.81312638541879467},{"$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.81215909040847734},{"$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.81114312616535389},{"$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.81007724889055055},{"$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.80896020858771445},{"$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.80779075245273224},{"$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.80656762830715734},{"$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.80528958806831352},{"$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.80395539124884241},{"$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.80256380847828179},{"$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.80111362503908023},{"$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.79960364440930565},{"$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.79803269180415359},{"$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.7963996177082362},{"$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.79470330139052425}]
[null,null,2,-0.71795740350513448,-0.71755355775420737,-0.71711253766077165,-0.71663367799695488,-0.71611626964925379,-0.71555956145513844,-0.71496276215832644,-0.71432504247952755,-0.71364553729921543,-0.71292334794875178,-0.71215754460594427,-0.71134716879088067,-0.71049123595764074,-0.70958873817724055,-0.70863864690692857,-0.70763991584070673,-0.70659148383571591,-0.70549227790888369,-0.7043412162980035,-0.70313721158118869,-0.70187917384841647,-0.70056601391866646,-0.69919664659595071,-0.69776999395733252,-0.69628498866584199,-0.69474057730102712,-0.69313572369970144,-0.69146941229931724,-0.68974065147624364,-0.68794847687112071,-0.68609195469335593]
[null,null,3,-0.58115977160873289,-0.58067346340068082,-0.58014338199641524,-0.57956896366101662,-0.578949608251211,-0.57828468094296059,-0.57757351406995194,-0.57681540906982232,-0.57600963853472908,-0.57515544836263555,-0.57425206000545137,-0.57329867280993696,-0.57229446644703696,-0.57123860342507982,-0.57013023168204546,-0.56896848725186699,-0.56775249699950714,-0.5664813814193177,-0.56515425749097281,-0.56377024158704314,-0.56232845242607266,-0.56082801406480776,-0.55926805892303733,-0.55764773083431418,-0.55596618811564869,-0.55422260664910583,-0.55241618296807871,-0.5505461373408802,-0.54861171684416821,-0.54661219841861663,-0.54454689189915317]
[null,null,4,-0.42185555520661472,-0.42127321743333701,-0.42063942193594878,-0.4199537231705765,-0.41921564789246674,-0.41842469675662514,-0.41758034602030497,-0.41668204934423003,-0.41572923968921,-0.41472133130458078,-0.41365772180467597,-0.41253779432930821,-0.41136091978401179,-0.41012645915556939,-0.40883376589812542,-0.40748218838496014,-0.40607107242078183,-0.40459976380917562,-0.40306761096963639,-0.40147396759840759,-0.39981819536714502,-0.39809966665323349,-0.39631776729540169,-0.39447189936810406,-0.39256148396797641,-0.3905859640055207,-0.38854480699503602,-0.38643750783568909,-0.38426359157651196,-0.38202261615801891,-0.37971417512306527]
[null,null,5,-0.25090107338391843,-0.25021568319348836,-0.24947058876473507,-0.24866547138840081,-0.2477999939986183,-0.24687380263731529,-0.24588652801075681,-0.24483778713515991,-0.24372718506809657,-0.24255431672217923,-0.24131876875730798,-0.24002012154753555,-0.23865795121838906,-0.23723183175026855,-0.23574133714332909,-0.23418604363903836,-0.23256553199339239,-0.23087938979656572,-0.22912721383357448,-0.2273086124803331,-0.22542320812930114,-0.22347063963873282,-0.22145056479937736,-0.21936266281231234,-0.217206636771447,-0.21498221614409346,-0.2126891592428824,-0.21032725568218899,-0.20789632881214626,-0.20539623812324151,-0.20282688161443796]
[null,null,6,-7.9946591561222302E-2,-7.9158148953639901E-2,-7.830175559352151E-2,-7.7377219606225234E-2,-7.6384340104769993E-2,-7.5322908518005577E-2,-7.4192710001208778E-2,-7.2993524926089959E-2,-7.1725130446983282E-2,-7.0387302139777813E-2,-6.8979815709940134E-2,-6.7502448765763001E-2,-6.5954982652766503E-2,-6.4337204344967813E-2,-6.2648908388532876E-2,-6.0889898893116717E-2,-5.9059991566003056E-2,-5.7159015783955991E-2,-5.5186816697512686E-2,-5.3143257362258695E-2,-5.1028220891457338E-2,-4.8841612624232256E-2,-4.6583362303353165E-2,-4.4253426256520734E-2,-4.1851789574917697E-2,-3.9378468282666307E-2,-3.6833511490728915E-2,-3.4217003528689061E-2,-3.1529066047780746E-2,-2.8769860088464272E-2,-2.5939588105810846E-2]
[null,null,7,7.9357624840896202E-2,8.0242097013704217E-2,8.1202204466945316E-2,8.2238020884215113E-2,8.3349620253974549E-2,8.4537075668330214E-2,8.5800458048438499E-2,8.713983479950263E-2,8.8555268398536169E-2,9.0046814918277207E-2,9.161452249083557E-2,9.3258429714866059E-2,9.4978564010258976E-2,9.6774939924542946E-2,9.8647557395387442E-2,0.10059639997379044,0.10262143301272247,0.10472260182618648,0.10689982982382398,0.10915301662637705,0.11148203616747054,0.11388673478734226,0.11636692932428275,0.11892240520968961,0.12155291457275486,0.1242581743609191,0.12703786448231411,0.12989162597650231,0.13281905921987586,0.1358197221721337,0.13889312867027737]
[null,null,8,0.21615525673729763,0.21712219136723071,0.21817136013130151,0.21930273522015326,0.22051628165201723,0.22181195618050789,0.22318970613681288,0.2246494682092077,0.22619116716302229,0.22781471450439339,0.22952000709132825,0.23130692569580955,0.23317533352086264,0.23512507467670357,0.23715597262027038,0.23926782856263007,0.24146041984893124,0.24373349831575225,0.24608678863085451,0.24851998662052249,0.25103275758981419,0.25362473464120083,0.2562955169971961,0.25904466833270778,0.26187171512294805,0.26477614501284019,0.26775740521393665,0.27081490093493921,0.27394799385195112,0.27715600062463763,0.28043819146447996]
[null,null,9,0.32112377158301791,0.32215398188179811,0.32327148979325332,0.32447618962974528,0.32576796279370734,0.32714667676908893,0.32861218405315928,0.33016432103156779,0.3318029067997525,0.33352774193399576,0.33533860721560321,0.3372352623118926,0.33921744441785684,0.34128486686256226,0.34343721768451896,0.34567415818044389,0.34799532143200979,0.35040031081534584,0.35288869849820492,0.35546002392988424,0.35811379232911211,0.36084947317526661,0.36366649870840251,0.36656426244368873,0.36954211770594836,0.37259937619009476,0.37573530655331533,0.37894913304492761,0.38224003417986102,0.38560714146175301,0.38904953816164828]
[null,null,10,0.38710973855999381,0.38817972560707925,0.38934019330251507,0.3905909870023288,0.39193193554586558,0.39336285029981766,0.39488352414636096,0.39649373041827773,0.39819322178413558,0.3999817290867948,0.4018589601386961,0.40382459847758212,0.40587830208648523,0.40801970208200428,0.41024840137506657,0.41256397330855177,0.41496596027632054,0.41745387232836195,0.42002718576691633,0.4226853417385969,0.42542774482765799,0.4282537616557015,0.43116271949322027,0.43415390488849942,0.43722656231947743,0.44037989287426738,0.44361305296609022,0.44692515308843928,0.45031525661631672,0.45378237865941484,0.45732548497310715]
[null,null,11,0.40961632306571077,0.41069987722089674,0.41187499769862562,0.41314151315683095,0.41449923450656734,0.41594795397397566,0.41748744410763372,0.41911745673416512,0.42083772186516882,0.42264794655873356,0.42454781373897904,0.42653698097726755,0.42861507923890696,0.43078171159935436,0.43303645193410389,0.43537884358661916,0.43780839801883725,0.44032459344893859,0.44292687348122239,0.44561464573308712,0.44838728046424214,0.45124410921341729,0.45418442344794274,0.45720747323169147,0.46031246591695663,0.46349856486593155,0.4667648882075105,0.47011050763519358,0.47353444725189792,0.47703568246750883,0.48061313895499264]
[null,null,12,0.38710973855999381,0.38817972560707925,0.38934019330251507,0.3905909870023288,0.39193193554586558,0.39336285029981766,0.39488352414636096,0.39649373041827773,0.39819322178413558,0.3999817290867948,0.4018589601386961,0.40382459847758212,0.40587830208648523,0.40801970208200428,0.41024840137506657,0.41256397330855177,0.41496596027632054,0.41745387232836195,0.42002718576691633,0.4226853417385969,0.42542774482765799,0.4282537616557015,0.43116271949322027,0.43415390488849942,0.43722656231947743,0.44037989287426738,0.44361305296609022,0.44692515308843928,0.45031525661631672,0.45378237865941484,0.45732548497310715]
[null,null,13,0.32112377158301791,0.32215398188179811,0.32327148979325332,0.32447618962974528,0.32576796279370734,0.32714667676908893,0.32861218405315928,0.33016432103156779,0.3318029067997525,0.33352774193399576,0.33533860721560321,0.3372352623118926,0.33921744441785684,0.34128486686256226,0.34343721768451896,0.34567415818044389,0.34799532143200979,0.35040031081534584,0.35288869849820492,0.35546002392988424,0.35811379232911211,0.36084947317526661,0.36366649870840251,0.36656426244368873,0.36954211770594836,0.37259937619009476,0.37573530655331533,0.37894913304492761,0.38224003417986102,0.38560714146175301,0.38904953816164828]
[null,null,14,0.21615525673729763,0.21712219136723071,0.21817136013130151,0.21930273522015326,0.22051628165201723,0.22181195618050789,0.22318970613681288,0.2246494682092077,0.22619116716302229,0.22781471450439339,0.22952000709132825,0.23130692569580955,0.23317533352086264,0.23512507467670357,0.23715597262027038,0.23926782856263007,0.24146041984893124,0.24373349831575225,0.24608678863085451,0.24851998662052249,0.25103275758981419,0.25362473464120083,0.2562955169971961,0.25904466833270778,0.26187171512294805,0.26477614501284019,0.26775740521393665,0.27081490093493921,0.27394799385195112,0.27715600062463763,0.28043819146447996]
[null,null,15,7.9357624840896202E-2,8.0242097013704217E-2,8.1202204466945316E-2,8.2238020884215113E-2,8.3349620253974549E-2,8.4537075668330214E-2,8.5800458048438499E-2,8.713983479950263E-2,8.8555268398536169E-2,9.0046814918277207E-2,9.161452249083557E-2,9.3258429714866059E-2,9.4978564010258976E-2,9.6774939924542946E-2,9.8647557395387442E-2,0.10059639997379044,0.10262143301272247,0.10472260182618648,0.10689982982382398,0.10915301662637705,0.11148203616747054,0.11388673478734226,0.11636692932428275,0.11892240520968961,0.12155291457275486,0.1242581743609191,0.12703786448231411,0.12989162597650231,0.13281905921987586,0.1358197221721337,0.13889312867027737]
[null,null,16,-7.9946591561222302E-2,-7.9158148953639901E-2,-7.830175559352151E-2,-7.7377219606225234E-2,-7.6384340104769993E-2,-7.5322908518005577E-2,-7.4192710001208778E-2,-7.2993524926089959E-2,-7.1725130446983282E-2,-7.0387302139777813E-2,-6.8979815709940134E-2,-6.7502448765763001E-2,-6.5954982652766503E-2,-6.4337204344967813E-2,-6.2648908388532876E-2,-6.0889898893116717E-2,-5.9059991566003056E-2,-5.7159015783955991E-2,-5.5186816697512686E-2,-5.3143257362258695E-2,-5.1028220891457338E-2,-4.8841612624232256E-2,-4.6583362303353165E-2,-4.4253426256520734E-2,-4.1851789574917697E-2,-3.9378468282666307E-2,-3.6833511490728915E-2,-3.4217003528689061E-2,-3.1529066047780746E-2,-2.8769860088464272E-2,-2.5939588105810846E-2]
[null,null,17,-0.25090107338391843,-0.25021568319348836,-0.24947058876473507,-0.24866547138840081,-0.2477999939986183,-0.24687380263731529,-0.24588652801075681,-0.24483778713515991,-0.24372718506809657,-0.24255431672217923,-0.24131876875730798,-0.24002012154753555,-0.23865795121838906,-0.23723183175026855,-0.23574133714332909,-0.23418604363903836,-0.23256553199339239,-0.23087938979656572,-0.22912721383357448,-0.2273086124803331,-0.22542320812930114,-0.22347063963873282,-0.22145056479937736,-0.21936266281231234,-0.217206636771447,-0.21498221614409346,-0.2126891592428824,-0.21032725568218899,-0.20789632881214626,-0.20539623812324151,-0.20282688161443796]
[null,null,18,-0.42185555520661472,-0.42127321743333701,-0.42063942193594878,-0.4199537231705765,-0.41921564789246674,-0.41842469675662514,-0.41758034602030497,-0.41668204934423003,-0.41572923968921,-0.41472133130458078,-0.41365772180467597,-0.41253779432930821,-0.41136091978401179,-0.41012645915556939,-0.40883376589812542,-0.40748218838496014,-0.40607107242078183,-0.40459976380917562,-0.40306761096963639,-0.40147396759840759,-0.39981819536714502,-0.39809966665323349,-0.39631776729540169,-0.39447189936810406,-0.39256148396797641,-0.3905859640055207,-0.38854480699503602,-0.38643750783568909,-0.38426359157651196,-0.38202261615801891,-0.37971417512306527]
[null,null,19,-0.58115977160873289,-0.58067346340068082,-0.58014338199641524,-0.57956896366101662,-0.578949608251211,-0.57828468094296059,-0.57757351406995194,-0.57681540906982232,-0.57600963853472908,-0.57515544836263555,-0.57425206000545137,-0.57329867280993696,-0.57229446644703696,-0.57123860342507982,-0.57013023168204546,-0.56896848725186699,-0.56775249699950714,-0.5664813814193177,-0.56515425749097281,-0.56377024158704314,-0.56232845242607266,-0.56082801406480776,-0.55926805892303733,-0.55764773083431418,-0.55596618811564869,-0.55422260664910583,-0.55241618296807871,-0.5505461373408802,-0.54861171684416821,-0.54661219841861663,-0.54454689189915317]
[null,null,20,-0.71795740350513448,-0.71755355775420737,-0.71711253766077165,-0.71663367799695488,-0.71611626964925379,-0.71555956145513844,-0.71496276215832644,-0.71432504247952755,-0.71364553729921543,-0.71292334794875178,-0.71215754460594427,-0.71134716879088067,-0.71049123595764074,-0.70958873817724055,-0.70863864690692857,-0.70763991584070673,-0.70659148383571591,-0.70549227790888369,-0.7043412162980035,-0.70313721158118869,-0.70187917384841647,-0.70056601391866646,-0.69919664659595071,-0.69776999395733252,-0.69628498866584199,-0.69474057730102712,-0.69313572369970144,-0.69146941229931724,-0.68974065147624364,-0.68794847687112071,-0.68609195469335593]
[null,null,21,-0.82292591835085482,-0.82258534826877494,-0.82221266732272347,-0.82180713240654701,-0.82136795079094393,-0.8208942820437195,-0.82038524007467295,-0.81983989530188761,-0.81925727693594563,-0.81863637537835432,-0.81797614473021918,-0.81727550540696381,-0.81653334685463497,-0.81574853036309936,-0.8149198919711772,-0.81404624545852067,-0.81312638541879467,-0.81215909040847734,-0.81114312616535389,-0.81007724889055055,-0.80896020858771445,-0.80779075245273224,-0.80656762830715734,-0.80528958806831352,-0.80395539124884241,-0.80256380847828179,-0.80111362503908023,-0.79960364440930565,-0.79803269180415359,-0.7963996177082362,-0.79470330139052425]
[null,null,22,-0.88891188532783061,-0.88861109199405597,-0.88828137083198522,-0.88792192977913054,-0.88753192354310217,-0.88711045557444812,-0.88665658016787452,-0.88616930468859745,-0.8856475919203286,-0.88509036253115325,-0.88449649765331206,-0.88386484157265321,-0.88319420452326325,-0.88248336558254148,-0.88173107566172482,-0.88093606058662843,-0.88009702426310543,-0.87921265192149345,-0.8782816134340653,-0.8773025666992631,-0.87627416108626022,-0.87519504093316702,-0.87406384909197499,-0.8728792305131241,-0.87163983586237137,-0.8703443251624543,-0.86899137145185501,-0.8675796644528172,-0.86610791424060918,-0.86457485490589792,-0.86297924820198313]
[null,null,23,-0.91141846983354768,-0.91113124360787356,-0.91081617522809588,-0.91047245593363257,-0.91009922250380393,-0.90969555924860623,-0.90926050012914739,-0.90879303100448494,-0.90829209200136196,-0.90775658000309201,-0.90718535125359501,-0.90657722407233876,-0.90593098167568509,-0.90524537509989145,-0.90451912622076214,-0.90375093086469593,-0.90293946200562214,-0.90208337304207009,-0.90118130114837136,-0.90023187069375332,-0.89923369672284448,-0.89818538849088292,-0.89708555304669757,-0.89593279885631616,-0.89472573945985068,-0.89346299715411859,-0.8921432066932754,-0.89076501899957161,-0.8893271048761906,-0.88782815871399201,-0.88626690218386872]
[null,null,24,-0.91141846983354768,-0.91113124360787356,-0.91081617522809588,-0.91047245593363257,-0.91009922250380393,-0.90969555924860623,-0.90926050012914739,-0.90879303100448494,-0.90829209200136196,-0.90775658000309201,-0.90718535125359501,-0.90657722407233876,-0.90593098167568509,-0.90524537509989145,-0.90451912622076214,-0.90375093086469593,-0.90293946200562214,-0.90208337304207009,-0.90118130114837136,-0.90023187069375332,-0.89923369672284448,-0.89818538849088292,-0.89708555304669757,-0.89593279885631616,-0.89472573945985068,-0.89346299715411859,-0.8921432066932754,-0.89076501899957161,-0.8893271048761906,-0.88782815871399201,-0.88626690218386872]
[]
[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":12.601167712467735},12.462270939929702,12.314921436830229,12.159810915523256,11.997640747358295,11.829115322273838,11.654935850597292,11.475794677846233,11.292370164387799,11.105322163536174,10.915288114624195,10.722879752205584,10.528680419130621,10.333242959958643,10.137088162082984,9.9407037050050597,9.7445435732871513,9.5490278856608395,9.3545430913569927,9.1614424847155309,8.9700469902889317,8.7806461727316627,8.5934994285475508,8.4088373200409308,8.2268630154084388,8.0477538026595479,7.8716626488392558,7.6987197797410296,7.5290342588643187,7.3626955477281655,7.1997750327622434]
[null,null,8,{"$f":"IF(D92>0,1/(D92+0.0000001),0)","v":4.6263021888249591},4.6056993674069409,4.5835509346555821,4.5599045675634891,4.5348104866786541,4.5083212212153718,4.4804913687993935,4.4513773517193567,4.4210371715158763,4.3895301636791277,4.3569167541477771,4.323258219208153,4.288616450285395,4.253053724999873,4.2166324857351647,4.1794151268302677,4.1414637913711347,4.1028401784169244,4.063605361356986,4.0238196179568737,3.9835422725179366,3.9428315504460936,3.901744445403216,3.8603365990994885,3.8186621936786245,3.776773856550105,3.7347225774344062,3.6925576373084321,3.6503265488696073,3.6080750080776158,3.5658468562830303]
[null,null,9,{"$f":"IF(D93>0,1/(D93+0.0000001),0)","v":3.1140631030336747},3.1041047009514875,3.0933742140456726,3.0818892842404111,3.0696686207488981,3.0567319350538282,3.0430998734004446,3.0287939471963505,3.013836461715711,2.9982504435053947,2.982059566887572,2.9652880799468133,2.9479607303806623,2.9301026915806307,2.9117394892962638,2.8928969292182423,2.8736010257979121,2.8538779326003141,2.8337538744661708,2.8132550817352819,2.7924077267602474,2.7712378629149561,2.7497713662777881,2.7280338801446335,2.7060507625023744,2.6838470365691411,2.6614473444841669,2.6388759042070462,2.6161564696643169,2.5933122941602909,2.5703660970493045]
[null,null,10,{"$f":"IF(D94>0,1/(D94+0.0000001),0)","v":2.5832461497746748},2.5761256356795141,2.5684472354958801,2.5602222715185454,2.5514627774870311,2.5421814617716518,2.5323916689676569,2.5221073400941916,2.5113429715983777,2.5001135733668618,2.4884346259478729,2.4763220371859296,2.4637920984692316,2.4508614407861971,2.4375469907829292,2.4238659270074443,2.4098356365195577,2.3954736720373511,2.3807977097824189,2.3658255081764423,2.3505748675315381,2.3350635908660151,2.3193094459660948,2.3033301288026182,2.2871432284001685,2.2707661932441816,2.2542162992999444,2.2375106197056094,2.2206659961899375,2.2036990122541669,2.186625968146533]
[null,null,11,{"$f":"IF(D95>0,1/(D95+0.0000001),0)","v":2.4413083648249616},2.4348674347798802,2.4279205166506888,2.4204775509272998,2.4125491086503925,2.4041463602148894,2.3952810427852835,2.3859654264836077,2.3762122795141436,2.3660348323910552,2.3554467414361646,2.344462051713847,2.3330951595687828,2.3213607749299383,2.3092738835408335,2.2968497092718239,2.2841036766649827,2.27105137385615,2.2577085160120518,2.2440909094129862,2.230214416303689,2.2160949206265537,2.2017482947426257,2.1871903672366484,2.1724368918931631,2.1575035179211426,2.1424057614951795,2.1271589786716771,2.1117783397291339,2.0962788049722674,2.0806751020307321]
[null,null,12,{"$f":"IF(D96>0,1/(D96+0.0000001),0)","v":2.5832461497746748},2.5761256356795141,2.5684472354958801,2.5602222715185454,2.5514627774870311,2.5421814617716518,2.5323916689676569,2.5221073400941916,2.5113429715983777,2.5001135733668618,2.4884346259478729,2.4763220371859296,2.4637920984692316,2.4508614407861971,2.4375469907829292,2.4238659270074443,2.4098356365195577,2.3954736720373511,2.3807977097824189,2.3658255081764423,2.3505748675315381,2.3350635908660151,2.3193094459660948,2.3033301288026182,2.2871432284001685,2.2707661932441816,2.2542162992999444,2.2375106197056094,2.2206659961899375,2.2036990122541669,2.186625968146533]
[null,null,13,{"$f":"IF(D97>0,1/(D97+0.0000001),0)","v":3.1140631030336747},3.1041047009514875,3.0933742140456726,3.0818892842404111,3.0696686207488981,3.0567319350538282,3.0430998734004446,3.0287939471963505,3.013836461715711,2.9982504435053947,2.982059566887572,2.9652880799468133,2.9479607303806623,2.9301026915806307,2.9117394892962638,2.8928969292182423,2.8736010257979121,2.8538779326003141,2.8337538744661708,2.8132550817352819,2.7924077267602474,2.7712378629149561,2.7497713662777881,2.7280338801446335,2.7060507625023744,2.6838470365691411,2.6614473444841669,2.6388759042070462,2.6161564696643169,2.5933122941602909,2.5703660970493045]
[null,null,14,{"$f":"IF(D98>0,1/(D98+0.0000001),0)","v":4.6263021888249591},4.6056993674069409,4.5835509346555821,4.5599045675634891,4.5348104866786541,4.5083212212153718,4.4804913687993935,4.4513773517193567,4.4210371715158763,4.3895301636791277,4.3569167541477771,4.323258219208153,4.288616450285395,4.253053724999873,4.2166324857351647,4.1794151268302677,4.1414637913711347,4.1028401784169244,4.063605361356986,4.0238196179568737,3.9835422725179366,3.9428315504460936,3.901744445403216,3.8603365990994885,3.8186621936786245,3.776773856550105,3.7347225774344062,3.6925576373084321,3.6503265488696073,3.6080750080776158,3.5658468562830303]
[null,null,15,{"$f":"IF(D99>0,1/(D99+0.0000001),0)","v":12.601167712467735},12.462270939929702,12.314921436830229,12.159810915523256,11.997640747358295,11.829115322273838,11.654935850597292,11.475794677846233,11.292370164387799,11.105322163536174,10.915288114624195,10.722879752205584,10.528680419130621,10.333242959958643,10.137088162082984,9.9407037050050597,9.7445435732871513,9.5490278856608395,9.3545430913569927,9.1614424847155309,8.9700469902889317,8.7806461727316627,8.5934994285475508,8.4088373200409308,8.2268630154084388,8.0477538026595479,7.8716626488392558,7.6987197797410296,7.5290342588643187,7.3626955477281655,7.1997750327622434]
[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",10,5,{"$f":" (6.1078 * EXP(17.269 * D18 / (237.3 + D18)) -6.1078 * EXP(17.269 * E18 / (237.3 + E18)))*0.62","v":2.2047718398704044}]
[null,null,"Feb",10,5,{"$f":" (6.1078 * EXP(17.269 * D19 / (237.3 + D19)) -6.1078 * EXP(17.269 * E19 / (237.3 + E19)))*0.62","v":2.2047718398704044}]
[null,null,"Mar",10,5,2.2047718398704044]
[null,null,"Apr",10,5,2.2047718398704044]
[null,null,"May",10,5,2.2047718398704044]
[null,null,"Jun",10,5,2.2047718398704044]
[null,null,"Jul",10,5,2.2047718398704044]
[null,null,"Aug",10,5,2.2047718398704044]
[null,null,"Sep",10,5,2.2047718398704044]
[null,null,"Oct",10,5,2.2047718398704044]
[null,null,"Nov",10,5,2.2047718398704044]
[null,null,"Dec",10,5,2.2047718398704044]
[]
[]
["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",-8,{"$f":"IF(H41<0,0,IF(D41<-9,30,IF(D41>-9,H41,0)))","v":27.6},null,null,{"$f":"D41*(-2)+11.6","v":27.6}]
[null,null,"Feb",10,0,null,null,-8.4]
[null,null,"Mar",10,0,null,null,-8.4]
[null,null,"Apr",10,0,null,null,-8.4]
[null,null,"May",10,0,null,null,-8.4]
[null,null,"Jun",10,0,null,null,-8.4]
[null,null,"Jul",10,0,null,null,-8.4]
[null,null,"Aug",10,0,null,null,-8.4]
[null,null,"Sep",10,0,null,null,-8.4]
[null,null,"Oct",10,0,null,null,-8.4]
[null,null,"Nov",10,0,null,null,-8.4]
[null,null,"Dec",10,0,null,null,-8.4]
[]
["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}]