{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs","Coefficients","README"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Inputs","index":0,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,10,15,11]]}
["Stand Age","Site Index","AvgHeight (optional)","WE BA (ft2/ac)","WE Height (ft)","WE Vol (cords/ac)","ZEO BA (ft2/ac)","ZEO Vol (cords/ac)","Mortality (cords/ac)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Species:","Aspen"]
[null,null,null,null,null,null,null,null,null,null,"Max Age:",100]
[null,null,null,null,null,null,null,null,null,null,"Model Type:","Defaults"]
[null,null,null,null,null,null,null,null,null,null,"Backg. Mort:",0.03]
[null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,65]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"                             Graph?"]

{"sheet":"Coefficients","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,4,0,8],[0,9,0,11],[0,1,0,3]]}
["Forest Type","Basal Area",null,null,"Height",null,null,null,null,"Volume"]
[null,"a1","a2","a3","g1","g2","g3","g4","g5","d1","d2","d3"]
["Jack pine",1.4621,0.70660000000000001,0.31680000000000003,1.633,1,-2.23E-2,1.2419,0,1.7364999999999999,0.82310000000000005,0.79100000000000004]
["Red pine",2.399,0.59130000000000005,0.34689999999999999,1.89,1,-1.9800000000000002E-2,1.3892,0,1.1605000000000001,1.0762,0.62280000000000002]
["White pine",25.7407,0,0.31919999999999998,1.966,1,-2.4E-2,1.8942000000000001,0,1.7790999999999999,0.99370000000000003,0.60840000000000005]
["Balsam fir",3.4075000000000002,0.46920000000000001,0.36749999999999999,2.0901000000000001,0.92959999999999998,-2.8000000000000001E-2,2.8279999999999998,-0.14030000000000001,3.4531999999999998,0.83160000000000001,0.60589999999999999]
["White spruce",25.205400000000001,0,0.29160000000000003,10.873799999999999,0.55289999999999995,-3.4299999999999997E-2,34.688499999999998,-0.6139,6.0400999999999998,0.89939999999999998,0.3755]
["Black spruce",3.7511999999999999,0.42720000000000002,0.37990000000000002,1.762,1,-2.01E-2,1.2306999999999999,0,0.78349999999999997,0.74960000000000004,1.0422]
["N. White-cedar",11.3733,0.23330000000000001,0.36020000000000002,1.9730000000000001,1,-1.54E-2,1.0885,0,2.0023,0.9375,0.63560000000000005]
["Tamarack",8.5456000000000003,0.15790000000000001,0.32579999999999998,1.5469999999999999,1,-2.2499999999999999E-2,1.1129,0,1.0345,0.78200000000000003,0.93520000000000003]
["Oak-hickory",3.0558000000000001,0.53090000000000004,0.3024,4.5437000000000003,0.81699999999999995,-1.2800000000000001E-2,2.1089000000000002,-0.17699999999999999,3.58,1.0163,0.4209]
["Elm-ash-soft maple",4.7759,0.34499999999999997,0.36959999999999998,6.1307999999999998,0.69040000000000001,-1.95E-2,10.1563,-0.53300000000000003,3.9236,0.97909999999999997,0.42299999999999999]
["Maple-birch",2.8016000000000001,0.56899999999999995,0.29120000000000001,6.0522,0.67679999999999996,-2.1700000000000001E-2,15.4232,-0.63539999999999996,2.9548999999999999,0.98250000000000004,0.50780000000000003]
["Aspen",0.60360000000000003,0.77349999999999997,0.44590000000000002,11.480399999999999,0.50390000000000001,-2.81E-2,105.9678,-1.0589999999999999,3.1206,0.92410000000000003,0.54490000000000005]
["Paper birch",2.1002000000000001,0.60919999999999996,0.32150000000000001,2.4321000000000002,0.92069999999999996,-1.6799999999999999E-2,1.5297000000000001,-0.1042,2.7305000000000001,0.89239999999999997,0.60470000000000002]
["Balsam poplar",0.40970000000000001,0.83089999999999997,0.47639999999999999,11.480399999999999,0.50390000000000001,-2.81E-2,105.9678,-1.0589999999999999,2.6949999999999998,0.9042,0.5988]

{"sheet":"README","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,27,12]]}
["This software implements the single cohort, lifespan yield model as discussed in [Zobel, J.M., Ek, A.R., and O'Hara, T.J.  2013.  Description and implementation of a single cohort, lifespan yield model for Minnesota.  Forest Resources Res. Note No. 298.  St. Paul, MN: University of Minnesota, Department of Forest Resources].  Please reference this document for further explanations of explanatory variables, response variables, and equation forms.  \n\nIn order to run the model, two input variables are required, with one optional: \n\n1. Stand age (years)                                                                                         (REQUIRED)\n2. Site index (ft) (base age 50 years)                                                        (REQUIRED)\n3. Average stand height of dominant/codominant trees (ft)        (OPTIONAL)\n\nEach row may represent an individual stand or one time-step in a longitudinal series.  For example, input information might comprise (1) a cross-section of all aspen stands within an administrative unit, with each row representing a different stand, or (2) the age and site index progression of an individual stand for some specified time period.\n\nWith the required information, the system of equations will provide estimates of basal area (ft2/ac), volume (cords/ac), and mortality (cords/ac) yield using the forms in Walters and Ek (1993) and Zobel et al. (2013).  The optional height data will provide better calibration of the volume and mortality estimates, if supplied.  If not, the model will provide (and use) height estimates based on Walters and Ek (1993).\n\nIn addition, the model provides a tool for generating longitudinal stand data at some specified age increment and site index.  This tool then populates the input columns with the supplied stand age progression (until maximum age) and site index for an individual stand.  Running the model on this data will show the lifespan yield projections for that stand.\n\nThis version of the model locks the workbook from manipulation, except for the input columns.  However, results may be copied and pasted into a separate spreadsheet for further analysis.  When encountering bugs in the program, or for any other questions related to the program or model arise, please contact John Zobel (zobe0025@umn.edu)."]