{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input_Sheet","Height_Age","DUB_Height","DUB_Age","DBH(OB)_Age","Volume_Age"],"not_rendered":{"charts":7,"images":0,"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":"Input_Sheet","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,16],[0,1,0,16],[3,1,3,3]]}
[null,"Stem Analysis"]
[null,"Instructions:\n1. First reset the sheet using the button Reset Sheet\n2. Enter the number of groups in the cell highlighted below\n3. Enter the macro level data by pressing the button Enter Initial Data\n3. Prepare the sheet by using the button Prepare Sheet\n4. Enter the data and press the button Process all data, generate graphs & export to PDF\n\n*Please enter values only in cells that are highlighted in GREY"]
[]
[null,"No. of groups in the class"]

{"sheet":"Height_Age","index":1,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,12,10,23],[8,1,10,1],[8,2,8,9],[3,1,3,3],[6,1,6,3],[5,1,5,3],[4,1,4,3]]}
[]
[]
[]
[null,"No. of groups in the class",null,null,{"$f":"Input_Sheet!E4","v":0}]
[null,"Age at Breast Height\n(From Seedling Data)",null,null,9.5212188792092274]
[null,"Longest Tree",null,null,{"$f":"MAX(Input_Sheet!#REF!)","v":{"$error":"#REF!"}}]
[null,"Maximum No. of Sections",null,null,9]
[]
[null,"Group No.","Height of Section (in mts)",null,null,null,null,null,null,null,null,null,"Height v/s Age Graph"]
[null,null,1.37,4.24,{"$f":"D10+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Age","Age","Age","Age","Age","Age","Age","Age"]
[null,1,0,5,8,12,18,25,32,38]
[null,2,0,5,8,12,18,25,32,38]
[null,3,0,5,8,12,18,25,32,38]
[null,4,0,5,8,12,18,25,32,38]
[null,5,0,5,8,12,18,25,32,38]
[null,6,0,5,8,12,18,25,32,38]
[null,7,0,5,8,12,18,25,32,38]
[null,8,0,5,8,12,18,25,32,38]
[null,"Total",{"$f":"SUM(C12:C19)","v":0},40,64,96,144,200,256,304]
[null,"No. of Trees",8,8,8,8,8,8,8,8]
[null,"Average Age",{"$f":"C20/C21","v":0},5,8,12,18,25,32,38]
[null,"Corrected Age",{"$f":"C22+E7","v":9},{"$f":"D22+E7","v":14},{"$f":"E22+E7","v":17},{"$f":"F22+E7","v":21},{"$f":"G22+E7","v":27},{"$f":"H22+E7","v":34},{"$f":"I22+E7","v":41},{"$f":"J22+E7","v":47}]

{"sheet":"DUB_Height","index":2,"n_rows":126,"n_cols":10,"rows_kept":126,"cut":false,"hidden":false,"merged":[[9,1,9,9],[10,1,12,1],[10,2,10,9],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[61,1,63,1],[61,2,61,9],[111,1,111,9],[112,1,114,1],[112,2,112,9],[77,1,77,9],[78,1,80,1],[78,2,78,9],[94,1,94,9],[95,1,97,1],[95,2,95,9],[43,1,43,9],[44,1,46,1],[44,2,44,9],[60,1,60,9],[26,1,26,9],[27,1,29,1],[27,2,27,9]]}
[]
[]
[]
[null,"No. of groups in the class",null,null,{"$f":"Height_Age!E4","v":0}]
[null,"Age at Breast Height\n(From Seedling Data)",null,null,{"$f":"Height_Age!E5","v":9.5212188792092274}]
[null,"Longest Tree",null,null,{"$f":"Height_Age!E6","v":{"$error":"#REF!"}}]
[null,"Maximum No. of Sections",null,null,{"$f":"Height_Age!E7","v":9}]
[]
[]
[null,"Mean Diameter Computation For Decade - 1"]
[null,"Group No.","Height of Section (in mts)"]
[null,null,1.37,4.24,{"$f":"D12+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Dia","Dia","Dia","Dia","Dia","Dia","Dia","Dia"]
[null,1,7,5.8,4.2,3]
[null,2,7,5.8,4.2,3]
[null,3,7,5.8,4.2,3]
[null,4,7,5.8,4.2,3]
[null,5,7,5.8,4.2,3]
[null,6,7,5.8,4.2,3]
[null,7,7,5.8,4.2,3]
[null,8,7,5.8,4.2,3]
[null,"Total",{"$f":"SUM(C14:C21)","v":56},46.399999999999991,33.6,24,0,0,0,0]
[null,"No. of Trees",8,8,8,8,0,0,0,0]
[null,"Average Dia",{"$f":"C22/C23","v":7},{"$f":"D22/D23","v":5.7999999999999989},{"$f":"E22/E23","v":4.2},{"$f":"F22/F23","v":3}]
[]
[]
[null,"Mean Diameter Computation For Decade - 2"]
[null,"Group No.","Height of Section (in mts)"]
[null,null,1.37,4.24,{"$f":"D29+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Dia","Dia","Dia","Dia","Dia","Dia","Dia","Dia"]
[null,1,13,11.2,9.1999999999999993,7,4.2]
[null,2,13,11.2,9.1999999999999993,7,4.2]
[null,3,13,11.2,9.1999999999999993,7,4.2]
[null,4,13,11.2,9.1999999999999993,7,4.2]
[null,5,13,11.2,9.1999999999999993,7,4.2]
[null,6,13,11.2,9.1999999999999993,7,4.2]
[null,7,13,11.2,9.1999999999999993,7,4.2]
[null,8,13,11.2,9.1999999999999993,7,4.2]
[null,"Total",{"$f":"SUM(C31:C38)","v":104},89.600000000000009,73.600000000000009,56,33.6,0,0,0]
[null,"No. of Trees",8,8,8,8,8,0,0,0]
[null,"Average Dia",{"$f":"C39/C40","v":13},{"$f":"D39/D40","v":11.200000000000001},{"$f":"E39/E40","v":9.2000000000000011},{"$f":"F39/F40","v":7},{"$f":"G39/G40","v":4.2}]
[]
[]
[null,"Mean Diameter Computation For Decade - 3"]
[null,"Group No.","Height of Section (in mts)"]
[null,null,1.37,4.24,{"$f":"D46+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Dia","Dia","Dia","Dia","Dia","Dia","Dia","Dia"]
[null,1,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,2,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,3,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,4,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,5,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,6,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,7,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,8,17.399999999999999,15,12.6,10.6,7.6,5.6,3.8]
[null,"Total",{"$f":"SUM(C48:C55)","v":139.20000000000002},120,100.79999999999998,84.8,60.800000000000004,44.800000000000004,30.400000000000002,0]
[null,"No. of Trees",8,8,8,8,8,8,8,0]
[null,"Average Dia",{"$f":"C56/C57","v":17.400000000000002},15,12.599999999999998,10.6,7.6000000000000005,5.6000000000000005,3.8000000000000003]
[]
[]
[null,"Mean Diameter Computation For Decade - 4"]
[null,"Group No.","Height of Section (in mts)"]
[null,null,1.37,4.24,{"$f":"D63+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Dia","Dia","Dia","Dia","Dia","Dia","Dia","Dia"]
[null,1,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,2,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,3,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,4,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,5,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,6,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,7,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,8,20.399999999999999,17.8,15.4,13.4,11.6,8.6,6.2,3.2]
[null,"Total",{"$f":"SUM(C65:C72)","v":163.20000000000002},142.4,123.20000000000002,107.20000000000002,92.799999999999983,68.8,49.600000000000009,25.599999999999998]
[null,"No. of Trees",8,8,8,8,8,8,8,8]
[null,"Average Dia",{"$f":"C73/C74","v":20.400000000000002},17.8,15.400000000000002,13.400000000000002,11.599999999999998,8.6,6.2000000000000011,3.1999999999999997]
[]
[]
[null,"Mean Diameter Computation For Decade - 5"]
[null,"Group No.","Height of Section (in mts)"]
[null,null,1.37,4.24,{"$f":"D80+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Dia","Dia","Dia","Dia","Dia","Dia","Dia","Dia"]
[null,1,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,2,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,3,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,4,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,5,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,6,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,7,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,8,22.4,19.8,17.399999999999999,15,11.8,9.8000000000000007,7.6,5.6]
[null,"Total",{"$f":"SUM(C82:C89)","v":179.20000000000002},158.4,139.20000000000002,120,94.399999999999991,78.399999999999991,60.800000000000004,44.800000000000004]
[null,"No. of Trees",8,8,8,8,8,8,8,8]
[null,"Average Dia",{"$f":"C90/C91","v":22.400000000000002},19.8,17.400000000000002,15,11.799999999999999,9.7999999999999989,7.6000000000000005,5.6000000000000005]
[]
[]
[null,"Mean Diameter Computation For Decade - 6"]
[null,"Group No.","Height of Section (in mts)"]
[null,null,1.37,4.24,{"$f":"D97+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Dia","Dia","Dia","Dia","Dia","Dia","Dia","Dia"]
[null,1,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,2,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,3,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,4,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,5,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,6,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,7,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,8,26,23,19.600000000000001,16.2,13,11.2,9,7.8]
[null,"Total",{"$f":"SUM(C99:C106)","v":208},184,156.79999999999998,129.6,104,89.600000000000009,72,62.399999999999991]
[null,"No. of Trees",8,8,8,8,8,8,8,8]
[null,"Average Dia",{"$f":"C107/C108","v":26},23,19.599999999999998,16.2,13,11.200000000000001,9,7.7999999999999989]
[]
[]
[null,"Mean Diameter Computation For Decade - 7"]
[null,"Group No.","Height of Section (in mts)"]
[null,null,1.37,4.24,{"$f":"D114+3","v":7.24},10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,null,"Dia","Dia","Dia","Dia","Dia","Dia","Dia","Dia"]
[null,1,30,27,23.6,20.6,17.8,15,12,9.4]
[null,2,30,27,23.6,20.6,17.8,15,12,9.4]
[null,3,30,27,23.6,20.6,17.8,15,12,9.4]
[null,4,30,27,23.6,20.6,17.8,15,12,9.4]
[null,5,30,27,23.6,20.6,17.8,15,12,9.4]
[null,6,30,27,23.6,20.6,17.8,15,12,9.4]
[null,7,30,27,23.6,20.6,17.8,15,12,9.4]
[null,8,30,27,23.6,20.6,17.8,15,12,9.4]
[null,"Total",{"$f":"SUM(C116:C123)","v":240},216,188.79999999999998,164.79999999999998,142.4,120,96,75.2]
[null,"No. of Trees",8,8,8,8,8,8,8,8]
[null,"Average Dia",{"$f":"C124/C125","v":30},27,23.599999999999998,20.599999999999998,17.8,15,12,9.4]

{"sheet":"DUB_Age","index":3,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,1,3,3],[4,1,4,3],[5,1,5,3]]}
[]
[]
[]
[null,"No. of groups in the class",null,null,{"$f":"Height_Age!E4","v":0}]
[null,"Number of Decades",null,null,7]
[null,"Maximum No. of Sections",null,null,9]
[]
[null,"Height",1.37,4.24,7.24,10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,"Decade","S 1","S 2","S 3","S 4","S 5","S 6","S 7","S 8"]
[null,10,7.0000000000000018,5.8000000000000007,4.2000000000000011,3.0000000000000009]
[null,20,13.004803906649283,11.181672974463684,9.2268817188871779,6.9822101815256277,4.2044312184742463]
[null,30,17.328243323657308,15.138445618775336,12.69804322858008,10.220490352343194,7.825128892561489,5.6313007517317608,3.7583478323508217]
[null,40,20.342556625604047,17.850863933577696,15.541225096583032,13.380625134432572,11.214419784174687,8.8879647828577397,6.2466158675300996,3.1357287752401426]
[null,50,22.34754396450079,19.954118551474942,17.348609322308803,14.719361564633076,12.149808663747729,9.7233840049527451,7.5235209735481039,5.6336529548337815]
[null,60,26.088008542944952,22.867245698157049,19.49865545907528,16.276297552498736,13.35055869136999,10.871825588631609,8.9904849572261618,7.856923510096216]
[null,70,30.043510800357353,26.865666699359242,23.69906826458508,20.666185596627656,17.741742626795538,14.900463286397265,12.117071506741393,9.3662912191364711]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Height",1.37,4.24,7.24,10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002]
[null,"Decade","S 1","S 2","S 3","S 4","S 5","S 6","S 7","S 8"]
[null,10,6.9754235236122604,5.7473312745638623,4.1095970257115448,2.7844142877732114]
[null,20,13.108721778602124,11.327323160026655,9.3866200583622383,7.3887334084181138,4.0017960569906386]
[null,30,17.233588802873928,15.067917203827708,12.833078454217004,10.463616660190967,8.4706212721710088,5.6336878005619369,3.7573743769028987]
[null,40,20.173525516964041,17.729850246461389,15.21176028505389,12.654601878652544,10.658801880572817,8.8784165875370604,6.2505096893218663,3.135728775240147]
[null,50,22.752032841408827,20.073859128422093,17.285453622650941,14.607226899363623,11.970059711732418,9.7377062979337694,7.5176802408604857,5.6336529548337815]
[null,60,25.79261169674465,22.860680690204191,19.816946538786176,16.967029557884992,13.808116595186199,10.862277393310947,8.9943787790179357,7.856923510096216]
[null,70,30.118763003507901,26.851051772302036,23.569027105237666,20.379547689777418,17.576694360470547,14.902850335227427,12.116098051293463,9.3662912191364711]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Height",1.37,null,3,6,9,12,15,18]
[null,"Decade","S 1","S 2","S 3","S 4","S 5","S 6","S 7","S 8"]
[null,10,6.9754235236122621,5.7473312745638587,4.1095970257115404,2.7844142877732097]
[null,20,11.758391379930922,11.807297658459573,10.596862505331135,6.962665333135325,4.0879775855428147]
[null,30,15.125777529225914,16.069603878354471,13.794590835662166,10.984392120861635,8.0887005908823326,5.5572091026537151,3.8396105131052387]
[null,40,17.606220308964133,19.14513161809608,15.942981981061546,13.248635445181593,10.849037355069989,8.531133055340506,6.0818678906069117,3.2881872054829806]
[null,50,20.026573429563189,21.511039029550211,18.26086718006421,15.082014418503581,12.109659768371444,9.4789822531709209,7.3251608964051407,5.7833747215772231]
[null,60,22.890657561949194,24.33535356627711,21.020866600568024,17.371829727999611,13.817794527295,10.788312577177328,8.7129354563697241,8.0212147435953192]
[null,70,26.799665219438225,28.611997601957036,24.706363780070138,21.049060459052953,17.672185291276922,14.607835929113479,11.888110024934075,9.5451052311101421]

{"sheet":"DBH(OB)_Age","index":4,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,3,3],[4,1,4,3],[5,1,5,3],[8,18,9,18],[8,19,9,19],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17]]}
[]
[]
[]
[null,"No. of groups in the class",null,null,{"$f":"Height_Age!E4","v":0}]
[null,"Number of Decades",null,null,7]
[null,"Maximum No. of Sections",null,null,9]
[]
[]
[null,"Group No.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,"Average DOB","Age"]
[null,"DUB","2BT","DOB","2BT","DOB","2BT","DOB","2BT","DOB","2BT","DOB","2BT","DOB","2BT","DOB","2BT","DOB"]
[null,5,-4.8950679938649557,0.10493200613504428,-4.8950679938649557,0.10493200613504428,-4.8950679938649557,0.10493200613504428,-4.8950679938649557,0.10493200613504428,-4.8950679938649557,0.10493200613504428,-4.8950679938649557,0.10493200613504428,-4.8950679938649557,0.10493200613504428,-4.8950679938649557,0.10493200613504428,5,9.9054413121387093]
[null,10,0.59557881874494356,10.595578818744944,0.59557881874494356,10.595578818744944,0.59557881874494356,10.595578818744944,0.59557881874494356,10.595578818744944,0.59557881874494356,10.595578818744944,0.59557881874494356,10.595578818744944,0.59557881874494356,10.595578818744944,0.59557881874494356,10.595578818744944,10.595579147338867,14.776673351993018]
[null,15,2.9608129238398675,17.960812923839867,2.9608129238398675,17.960812923839867,2.9608129238398675,17.960812923839867,2.9608129238398675,17.960812923839867,2.9608129238398675,17.960812923839867,2.9608129238398675,17.960812923839867,2.9608129238398675,17.960812923839867,2.9608129238398675,17.960812923839867,17.960813522338867,30.21183283521367]
[null,20,3.2081860613050388,23.208186061305039,3.2081860613050388,23.208186061305039,3.2081860613050388,23.208186061305039,3.2081860613050388,23.208186061305039,3.2081860613050388,23.208186061305039,3.2081860613050388,23.208186061305039,3.2081860613050388,23.208186061305039,3.2081860613050388,23.208186061305039,23.208187103271484,49.541600263720312]
[null,25,2.3452499710257122,27.345249971025712,2.3452499710257122,27.345249971025712,2.3452499710257122,27.345249971025712,2.3452499710257122,27.345249971025712,2.3452499710257122,27.345249971025712,2.3452499710257122,27.345249971025712,2.3452499710257122,27.345249971025712,2.3452499710257122,27.345249971025712,27.345249176025391,66.096656139432611]
[null,30,1.3795563928871211,31.379556392887121,1.3795563928871211,31.379556392887121,1.3795563928871211,31.379556392887121,1.3795563928871211,31.379556392887121,1.3795563928871211,31.379556392887121,1.3795563928871211,31.379556392887121,1.3795563928871211,31.379556392887121,1.3795563928871211,31.379556392887121,31.379558563232422,73.207680964270267]
[null,35,1.3186570667744952,36.318657066774492,1.3186570667744952,36.318657066774492,1.3186570667744952,36.318657066774492,1.3186570667744952,36.318657066774492,1.3186570667744952,36.318657066774492,1.3186570667744952,36.318657066774492,1.3186570667744952,36.318657066774492,1.3186570667744952,36.318657066774492,36.318660736083984,64.205355240152883]
[]
[null,"Average DOB",5,5,10.595579147338867,17.960813522338867,23.208187103271484,27.345249176025391,31.379558563232422,36.318660736083984,36.318660736083984]
[null,"Age",5.0342092722844001,9.9054413121387093,14.776673351993018,30.21183283521367,49.541600263720312,66.096656139432611,73.207680964270267,64.205355240152883,73.207680964270267]

{"sheet":"Volume_Age","index":5,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,14,8,24],[9,14,10,14],[11,14,12,14],[38,2,38,11],[3,1,3,2],[4,1,4,2],[5,1,5,2],[28,2,28,11],[33,2,33,11],[8,2,8,11],[13,2,13,11],[18,2,18,11],[23,2,23,11]]}
[]
[null,null,null,null,null,"Volume Calculations"]
[]
[null,"No. of groups in the class",null,{"$f":"Height_Age!E4","v":0}]
[null,"Number of Decades",null,7]
[null,"Maximum No. of Sections",null,9]
[]
[null,"Height of Sections",1.37,4.24,7.24,10.24,13.24,16.240000000000002,19.240000000000002,22.240000000000002,"Cone","Total",null,null,"Age v/s Volume"]
[null,"Decade",1]
[null,"Length of Section (m)",2.74,3,3,3,null,null,null,null,1.5,null,null,null,"Scatter","Age (yrs)",10,20,30,40,50,60,70]
[null,"Diameter (cm)",6.9754235236122621,5.7473312745638587,4.1095970257115404,2.7844142877732097,null,null,null,null,{"$f":"F11+((F11-E11)/2)","v":2.1218229188040443},null,null,null,null,"Volume (m3)",2.4246409773277234E-2,0.10473829301013481,0.20994450565534001,0.31072671805448648,0.40489677369554861,0.53550276720852907,0.78243233999809103]
[null,"Basal Area (m2)",{"$f":"22*C11*C11/(28*10000)","v":3.8230133333671174E-3},{"$f":"22*D11*D11/(28*10000)","v":2.5953570326812721E-3},{"$f":"22*E11*E11/(28*10000)","v":1.3269761775079182E-3},{"$f":"22*F11*F11/(28*10000)","v":6.0916137275365346E-4},null,null,null,null,{"$f":"22*K11*K11/(28*10000)","v":3.5373898204559467E-4},null,null,null,"Trendline","Age (yrs)",0,10,20,30,40,50,60,70,80]
[null,"Volume (m3)",{"$f":"C12*C10","v":1.0475056533425902E-2},{"$f":"D12*D10","v":7.7860710980438164E-3},{"$f":"E12*E10","v":3.9809285325237542E-3},{"$f":"F12*F10","v":1.8274841182609604E-3},null,null,null,null,{"$f":"K12*K10/3","v":1.7686949102279734E-4},{"$f":"SUM(C13:K13)","v":2.4246409773277234E-2},null,null,null,"Volume (m3)",2.4246409773277234E-2,2.4246409773277234E-2,0.10473829301013481,0.20994450565534001,0.31072671805448648,0.40489677369554861,0.53550276720852907,0.78243233999809103,0.78243233999809103]
[null,"Decade",2]
[null,"Length of Section (m)",2.74,3,3,3,3,null,null,null,1.5]
[null,"Diameter (cm)",11.758391379930922,11.807297658459573,10.596862505331135,6.962665333135325,4.0879775855428147,null,null,null,{"$f":"G16+((G16-F16)/2)","v":2.6506337117465595}]
[null,"Basal Area (m2)",{"$f":"22*C16*C16/(28*10000)","v":1.0863267473428371E-2},{"$f":"22*D16*D16/(28*10000)","v":1.0953821842500815E-2},{"$f":"22*E16*E16/(28*10000)","v":8.8230603180415815E-3},{"$f":"22*F16*F16/(28*10000)","v":3.809041385383492E-3},{"$f":"22*G16*G16/(28*10000)","v":1.313051200992179E-3},null,null,null,{"$f":"22*K16*K16/(28*10000)","v":5.5203178437371976E-4}]
[null,"Volume (m3)",{"$f":"C17*C15","v":2.9765352877193736E-2},{"$f":"D17*D15","v":3.2861465527502444E-2},{"$f":"E17*E15","v":2.6469180954124746E-2},{"$f":"F17*F15","v":1.1427124156150477E-2},{"$f":"G17*G15","v":3.9391536029765375E-3},null,null,null,{"$f":"K17*K15/3","v":2.7601589218685988E-4},{"$f":"SUM(C18:K18)","v":0.10473829301013481}]
[null,"Decade",3]
[null,"Length of Section (m)",2.74,3,3,3,3,3,3,null,1.5]
[null,"Diameter (cm)",15.125777529225914,16.069603878354471,13.794590835662166,10.984392120861635,8.0887005908823326,5.5572091026537151,3.8396105131052387,null,{"$f":"I21+((I21-H21)/2)","v":2.9808112183310005}]
[null,"Basal Area (m2)",{"$f":"22*C21*C21/(28*10000)","v":1.7976290032142798E-2},2.0289670406281969E-2,1.4951414996833435E-2,9.4801826636665646E-3,5.1406989267024448E-3,2.4264878794056461E-3,1.1583478415416501E-3,null,{"$f":"22*K21*K21/(28*10000)","v":6.9812564794719564E-4}]
[null,"Volume (m3)",{"$f":"C22*C20","v":4.925503468807127E-2},6.0869011218845907E-2,4.4854244990500308E-2,2.8440547990999696E-2,1.5422096780107334E-2,7.2794636382169384E-3,3.47504352462495E-3,null,{"$f":"K22*K20/3","v":3.4906282397359777E-4},{"$f":"SUM(C23:K23)","v":0.20994450565534001}]
[null,"Decade",4]
[null,"Length of Section (m)",2.74,3,3,3,3,3,3,3,1.5]
[null,"Diameter (cm)",17.606220308964133,19.14513161809608,15.942981981061546,13.248635445181593,10.849037355069989,8.531133055340506,6.0818678906069117,3.2881872054829806,{"$f":"J26+((J26-I26)/2)","v":1.8913468629210151}]
[null,"Basal Area (m2)",{"$f":"22*C26*C26/(28*10000)","v":2.4355492351754229E-2},2.8799262224403172E-2,1.9971181563807033E-2,1.3791355376803876E-2,9.2479837632053162E-3,5.7184467377654133E-3,2.9062877673339217E-3,8.495280434380122E-4,2.8106516081923439E-4]
[null,"Volume (m3)",{"$f":"C27*C25","v":6.6734049043806587E-2},8.639778667320952E-2,5.99135446914211E-2,4.1374066130411627E-2,2.7743951289615949E-2,1.715534021329624E-2,8.7188633020017642E-3,2.5485841303140365E-3,{"$f":"K27*K25/3","v":1.4053258040961719E-4},{"$f":"SUM(C28:K28)","v":0.31072671805448648}]
[null,"Decade",5]
[null,"Length of Section (m)",2.74,3,3,3,3,3,3,3,1.5]
[null,"Diameter (cm)",20.026573429563189,21.511039029550211,18.26086718006421,15.082014418503581,12.109659768371444,9.4789822531709209,7.3251608964051407,5.7833747215772231,{"$f":"J31+((J31-I31)/2)","v":5.0124816341632643}]
[null,"Basal Area (m2)",{"$f":"22*C31*C31/(28*10000)","v":3.1512143404475355E-2},3.6356948581708272E-2,2.6200371227481485E-2,1.7872419629424638E-2,1.1522017548306094E-2,7.0597296436801567E-3,4.2159843124318043E-3,2.6280118205140187E-3,1.9741049532933166E-3]
[null,"Volume (m3)",{"$f":"C32*C30","v":8.6343272928262479E-2},0.10907084574512482,7.8601113682444462E-2,5.3617258888273914E-2,3.4566052644918285E-2,2.1179188931040469E-2,1.2647952937295412E-2,7.8840354615420556E-3,{"$f":"K32*K30/3","v":9.8705247664665832E-4},{"$f":"SUM(C33:K33)","v":0.40489677369554861}]
[null,"Decade",6]
[null,"Length of Section (m)",2.74,3,3,3,3,3,3,3,1.5]
[null,"Diameter (cm)",22.890657561949194,24.33535356627711,21.020866600568024,17.371829727999611,13.817794527295,10.788312577177328,8.7129354563697241,8.0212147435953192,{"$f":"J36+((J36-I36)/2)","v":7.6753543872081167}]
[null,"Basal Area (m2)",{"$f":"22*C36*C36/(28*10000)","v":4.1170030284304569E-2},4.6530741179663396E-2,3.4718893993054563E-2,2.3711322493462295E-2,1.500175643988557E-2,9.1447469349407676E-3,5.9647691923965119E-3,5.0552767542255727E-3,4.628726533297026E-3]
[null,"Volume (m3)",{"$f":"C37*C35","v":0.11280588297899453},0.1395922235389902,0.1041566819791637,7.1133967480386889E-2,4.5005269319656711E-2,2.7434240804822305E-2,1.7894307577189537E-2,1.5165830262676719E-2,{"$f":"K37*K35/3","v":2.314363266648513E-3},{"$f":"SUM(C38:K38)","v":0.53550276720852907}]
[null,"Decade",7]
[null,"Length of Section (m)",2.74,3,3,3,3,3,3,3,4.2600002288818359]
[null,"Diameter (cm)",26.799665219438225,28.611997601957036,24.706363780070138,21.049060459052953,17.672185291276922,14.607835929113479,11.888110024934075,9.5451052311101421,{"$f":"J41+((J41-I41)/2)","v":8.3736028341981754}]
[null,"Basal Area (m2)",{"$f":"22*C41*C41/(28*10000)","v":5.6431732961525968E-2},6.4322217675131049E-2,4.7960346596891273E-2,3.481208863069666E-2,2.4538339019010483E-2,1.6766268398934893E-2,1.1104276854387991E-2,7.1585669471616294E-3,5.5092104905272062E-3]
[null,"Volume (m3)",{"$f":"C42*C40","v":0.15462294831458118},0.19296665302539315,0.14388103979067382,0.10443626589208999,7.3615017057031454E-2,5.0298805196804679E-2,3.3312830563163975E-2,2.1475700841484889E-2,{"$f":"K42*K40/3","v":7.8230793168680372E-3},{"$f":"SUM(C43:K43)","v":0.78243233999809103}]