{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Input","Output","Species Codes","Version","Calculations","References","Specific Gravity"],"not_rendered":{"charts":0,"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":"Instructions","index":0,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,1,10],[25,2,26,10],[30,2,32,10],[36,2,37,10],[41,2,42,10],[5,2,7,10],[13,2,15,10],[17,2,19,10],[21,2,23,10]]}
[]
["Line Intersect Calculator - Instructions"]
[]
["Input Sheet"]
[]
[null,null,"If there is data in the sheet, click on the \"Clear Data\" button to delete the information. You do not need to go through this step for the calculation but if you don't, make sure all the data already entered is pertinent to the calculation."]
[]
[]
[]
[null,null,"Enter the slope of the line for which you want to make the calculation. If zero, put 0."]
[]
[null,null,"The diameter classes used in the sampling must correspond to the ones indicated on the form."]
[]
[null,null,"Enter the length of the line used for each diameter class. If classes were not dropped as you progressed with the line intersect sampling, the same length should be entered for each diameter class."]
[]
[]
[]
[null,null,"Enter the percent composition of the five main species represented in the dead and downed woody debris. The total must be 100.0 %. You must use the species code presented in the worksheet \"Species Codes\"."]
[]
[]
[]
[null,null,"Enter the detailed information for the large diameter woody debris and coarse woody debris: species code and diameter. You must use the species code presented in the worksheet \"Species Codes\"."]
[]
[]
[]
[null,null,"The data will be calculated automatically and presented on the \"Output\" worksheet when all the required information has been entered."]
[]
[]
["Species Codes"]
[]
[null,null,"This worksheet is there as a reference to enter a standard code for the species present on your sample line. The right code must be used each time (case sensitive) or the calculation will be wrong."]
[]
[]
[]
["Output Sheet"]
[]
[null,null,"The results of the calculation are presented automatically on the results sheet. If the inputs are not entered, the output values will either be absent or zero."]
[]
[]
[null,null,"You can add some text in the grey fields, as required, to document the output values."]
[]
[null,null,"You can clear all the data YOU enter by clicking on the \"Clear Data\" button at the bottom of the page. The outputs will not disappear unless you delete the input values on the \"Input\" worksheet."]

{"sheet":"Input","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["DATA INPUT - LINE INTERSECT SAMPLING"]
[]
[1,"Slope of the sampling line (not of the terrain)"]
[]
[null,null,null,null,null,"(%)"]
[]
[2,"Length of line used for each diameter class"]
[]
[null,null,null,"≤0.5","0.6 - 1.0","1.1 - 3.0","3.1 - 5.0","5.1 - 7.0",">7.0"]
[]
[]
[3,"Number of intersections per diameter class along the sampling line (pieces diameter ≤7.0 cm)"]
[]
[null,null,null,null,"≤0.5","0.6 - 1.0","1.1 - 3.0","3.1 - 5.0","5.1 - 7.0"]
[null,null,null,null,null,null,null,null,null,"(count)"]
[null,null,null,{"$f":"SUM(E16:I16)","v":5},{"$f":"IF(OR(E15=0,E15=\"\"),1,\"\")","v":1},{"$f":"IF(OR(F15=0,F15=\"\"),1,\"\")","v":1},{"$f":"IF(OR(G15=0,G15=\"\"),1,\"\")","v":1},{"$f":"IF(OR(H15=0,H15=\"\"),1,\"\")","v":1},{"$f":"IF(OR(I15=0,I15=\"\"),1,\"\")","v":1}]
[4,"Species composition along the line (pieces diameter ≤7.0 cm)"]
[null,"Note: Maximum of 5 species. You may need to group percentages of similar species if more than 5 species"]
[null,"Note: You must use the exact code of the species (case sensitive) as pensented in the \"Species Codes\" list"]
[]
[null,null,null,null,null,null,null,null,null,"Species"]
[null,null,null,null,null,null,null,null,null,"(%)"]
[null,null,null,null,null,null,null,"Total (must be 100%):",{"$f":"SUM(E22:I22)","v":0},"(%)"]
[]
[5,"Large Diameter Woody Debris (LDWD) pieces diameter >7.0 to 20.0 cm"]
[null,"Note: You must use the exact code of the species (case sensitive) as pensented in the \"Species Codes\" list"]
[null,"Note: The diameter must be entered in centimetre (cm) and the number will display in RED if out of LDWD range."]
[]
[null,"Species","Diameter","Species","Diameter","Species","Diameter","Species","Diameter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[6,"Coarse Woody Debris (CWD) pieces diameter >20.0 cm"]
[null,"Note: You must use the exact code of the species (case sensitive) as pensented in the \"Species Codes\" list"]
[null,"Note: The diameter must be entered in centimetre (cm) and the number will display in RED if out of CWD range."]
[]
[null,"Species","Diameter","Species","Diameter","Species","Diameter","Species","Diameter"]

{"sheet":"Output","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,5,12,7],[12,9,12,10],[31,3,55,10],[0,0,0,11],[4,3,4,4],[2,3,2,4],[2,9,2,10],[8,3,10,10],[6,3,6,4],[4,9,4,10]]}
["DEAD AND DOWNED WOODY MATERIAL SAMPLING"]
[]
[null,"Sampling Date:",null,null,null,null,null,"Contact Person:   "]
[]
[null,"Fire Timing:"]
[]
[null,"Plot Number:"]
[]
[null,"Location:"]
[]
[]
[]
[null,null,null,"Classes",null,"Calculation Results",null,null,null,"Sample Line Info"]
[]
[null,"Fuel Summary:",null,"Diameter",null,"Load","Load","Volume",null,"Length","Intersections"]
[null,null,null,"(cm)",null,"(t/ha)","(kg/m2)","(m3/ha)",null,"(m)","(count)"]
[]
[null,"[Select]",null,"≤0.5",null,{"$f":"IF(J18=\"\",\"\",IF(Input!$D$16>3,Calculations!P59,Calculations!D59))","v":""},{"$f":"IF(F18=\"\",\"\",F18/10)","v":""},{"$f":"IF(J18=\"\",\"\",IF(Input!D16>3,Calculations!P72,Calculations!D72))","v":""},null,{"$f":"IF(Input!D10=\"\",\"\",Input!D10)","v":""},{"$f":"IF(Input!E15=\"\",\"\",Input!E15)","v":""}]
[null,"Pre-Burn",null,"0.6 - 1.0",null,{"$f":"IF(J19=\"\",\"\",IF(Input!$D$16>3,Calculations!Q59,Calculations!E59))","v":""},{"$f":"IF(F19=\"\",\"\",F19/10)","v":""},{"$f":"IF(J19=\"\",\"\",IF(Input!D16>3,Calculations!Q72,Calculations!E72))","v":""},null,{"$f":"IF(Input!E10=\"\",\"\",Input!E10)","v":""},{"$f":"IF(Input!F15=\"\",\"\",Input!F15)","v":""}]
[null,"Post-Burn",null,"1.1 - 3.0",null,{"$f":"IF(J20=\"\",\"\",IF(Input!$D$16>3,Calculations!R59,Calculations!F59))","v":""},"",{"$f":"IF(J20=\"\",\"\",IF(Input!D16>3,Calculations!R72,Calculations!F72))","v":""},null,{"$f":"IF(Input!F10=\"\",\"\",Input!F10)","v":""},{"$f":"IF(Input!G15=\"\",\"\",Input!G15)","v":""}]
[null,"N/A",null,"3.1 - 5.0",null,{"$f":"IF(J21=\"\",\"\",IF(Input!$D$16>3,Calculations!S59,Calculations!G59))","v":""},"",{"$f":"IF(J21=\"\",\"\",IF(Input!D16>3,Calculations!S72,Calculations!G72))","v":""},null,{"$f":"IF(Input!G10=\"\",\"\",Input!G10)","v":""},{"$f":"IF(Input!H15=\"\",\"\",Input!H15)","v":""}]
[null,null,null,"5.1 - 7.0",null,{"$f":"IF(J22=\"\",\"\",IF(Input!$D$16>3,Calculations!T59,Calculations!H59))","v":""},"",{"$f":"IF(J22=\"\",\"\",IF(Input!D16>3,Calculations!T72,Calculations!H72))","v":""},null,{"$f":"IF(Input!H10=\"\",\"\",Input!H10)","v":""},{"$f":"IF(Input!I15=\"\",\"\",Input!I15)","v":""}]
[null,null,null,">7.0 - 20.0",null,{"$f":"Calculations!D77","v":""},{"$f":"IF(F23=\"\",\"\",F23/10)","v":""},{"$f":"Calculations!D78","v":""},null,{"$f":"IF(Input!I10=\"\",\"\",Input!I10)","v":""},{"$f":"IF(COUNTA(Input!B30:B39,Input!D30:D39,Input!F30:F39,Input!H30:H39)=0,\"\",COUNTA(Input!B30:B39,Input!D30:D39,Input!F30:F39,Input!H30:H39))","v":""}]
[null,null,null,">20.0",null,{"$f":"Calculations!D129","v":""},{"$f":"IF(F24=\"\",\"\",F24/10)","v":""},{"$f":"Calculations!D130","v":""},null,{"$f":"IF(Input!I10=\"\",\"\",Input!I10)","v":""},{"$f":"IF(COUNTA(Input!B46:B55,Input!D46:D55,Input!F46:F55,Input!H46:H55)=0,\"\",COUNTA(Input!B46:B55,Input!D46:D55,Input!F46:F55,Input!H46:H55))","v":""}]
[]
[null,null,null,"Total ≤7.0",null,{"$f":"IF(F18=\"\",\"\",SUM(F18:F22))","v":""},{"$f":"IF(F18=\"\",\"\",SUM(G18:G22))","v":""},{"$f":"IF(F26=\"\",\"\",SUM(H18:H22))","v":""},null,null,{"$f":"IF(F18=\"\",\"\",SUM(K18:K22))","v":""}]
[null,null,null,"Total >7.0",null,{"$f":"IF(F18=\"\",\"\",SUM(F23:F24))","v":""},{"$f":"IF(F18=\"\",\"\",SUM(G23:G24))","v":""},{"$f":"IF(F27=\"\",\"\",SUM(H23:H24))","v":""},null,null,{"$f":"IF(F18=\"\",\"\",SUM(K23:K24))","v":""}]
[null,null,null,"Total All",null,{"$f":"IF(F18=\"\",\"\",SUM(F18:F24))","v":""},{"$f":"IF(F18=\"\",\"\",SUM(G18:G24))","v":""},{"$f":"IF(F28=\"\",\"\",SUM(H18:H24))","v":""},null,null,{"$f":"IF(F18=\"\",\"\",SUM(K18:K24))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Slope of the line: \"&Input!E5&\"%\"","v":"Slope of the line: %"}]
[]
[null,"Comments:"]

{"sheet":"Species Codes","index":3,"n_rows":70,"n_cols":4,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
[]
[null,"Species Codes"]
[]
[null,"Code.","Common Name","Scientific Name"]
[null,"Cw","western redcedar","Thuja plicata"]
[null,"Yc","yellow-cedar","Chamaecyparis nootkatensis"]
[null,"Fd","Douglas-fir","Pseudotsuga menziesii"]
[null,"Fdc","coastal Douglas-fir","P. menziesii var. menziesii"]
[null,"Fdi","interior Douglas-fir","P. menziesii var. glauca"]
[null,"Ba","amabilis fir","Abies amabilis"]
[null,"Bg","grand fir","A. grandis"]
[null,"Bp","noble fir","A. procera"]
[null,"Bl","subalpine fir","A. lasiocarpa"]
[null,"Hm","mountain hemlock","Tsuga mertensiana"]
[null,"Hw","western hemlock","T. heterophylla"]
[null,"Hxm","mountain x western hemlock hybrid","T. mertensiana x heterophylla"]
[null,"Jr","Rocky Mtn. juniper","Juniperus scopulorum"]
[null,"La","alpine larch","Larix lyallii"]
[null,"Lt","tamarack","L. laricina"]
[null,"Lw","western larch","L. occidentalis"]
[null,"Pj","jack pine","Pinus banksiana"]
[null,"Pf","limber pine","P. flexilis"]
[null,"Pl","lodgepole pine","P. contorta"]
[null,"Pxj","lodgepole x jack pine hybrid","P. x murraybanksiana"]
[null,"Py","ponderosa pine","P. ponderosa"]
[null,"Plc","shore pine","P. contorta var. contorta"]
[null,"Pw","western white pine","P. monticola"]
[null,"Pa","whitebark pine","P. albicaulis"]
[null,"Sb","black spruce","Picea mariana"]
[null,"Se","Engelmann spruce","P. engelmannii"]
[null,"Ss","Sitka spruce","P. sitchensis"]
[null,"Sw","white spruce","P. glauca"]
[null,"Sx","spruce hybrid","P. cross"]
[null,"Tw","western yew","Taxus brevifolia"]
[null,"Dm","mountain alder","Alnus tenuifolia"]
[null,"Dr","red alder","A. rubra"]
[null,"Dg","green and Sitka alder","A. sitchensis"]
[null,"Up","Pacific crab apple","Malus fusca"]
[null,"Ac","poplar","Populus balsamifera"]
[null,"Acb","balsam poplar","P. b. spp. balsamifera"]
[null,"Act","black cottonwood","P.b. spp. trichocarpa"]
[null,"Ax","hybrid poplars","P. spp."]
[null,"At","trembling aspen","P. tremuloides"]
[null,"Ra","Arbutus","Arbutus menziesii"]
[null,"Ea","Alaska paper birch","Betula neoalaskana"]
[null,"Exp","Alaska x paper birch hybrid","B. x winteri"]
[null,"Ep","paper birch","B. papyrifera"]
[null,"Ew","water birch","B. occidentalis"]
[null,"Exw","water x paper birch hybrid","B. x piperi"]
[null,"Kc","cascara","Rhamnus purshiana"]
[null,"Vb","bitter cherry","Prunus emarginata"]
[null,"Vv","choke cherry","P. virginiana"]
[null,"Vp","pin cherry","P. pensylvanica"]
[null,"Gp","Pacific dogwood","Cornus nuttallii"]
[null,"Mb","bigleaf maple","Acer macrophyllum"]
[null,"Mv","vine maple","A. circinatum"]
[null,"Mr","Rocky Mtn. maple","A. glabrum"]
[null,"Qg","Garry oak","Q. garryana"]
[null,"Wb","Bebb's willow","Salix bebbiana"]
[null,"Wp","Pacific willow","S. lucida"]
[null,"Wa","peachleaf willow","S. amygdaloides"]
[null,"Wd","pussy willow","S. discolor"]
[null,"Ws","Scouler's willow","S. scouleriana"]
[null,"Wt","Sitka willow","S. sitchensis"]
[null,"Xc","Unknown conifer "]
[null,"Xh","Unknown hardwood "]
[null,"Zc","Other conifer "]
[null,"Zh","Other hardwood"]
[null,"U","Unknown"]
[null,"D","Decayed"]

{"sheet":"Version","index":4,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Version 3.0"]
["For comments and changes, please contact"]
[]
["Jonathan Murkin"]
["Land and Resource Specialist"]
["MOF, BCWS"]
["jonathan.murkin@gov.bc.ca"]
[]
["Original contact info and developer credits:"]
[]
["Daniel Perrakis",null,null,null,null,null,"Please note that Daniel has left MOF. "]
["Fire Science Officer"]
["Min. FLNRO, Wildfire Mangement Branch"]
["Daniel.Perrakis@gov.bc.ca"]
["250-356-0082"]
["______________________________________________________"]
["For questions or to report problems, please contact:"]
[]
["~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
["Nathalie Lavoie"]
["Leader, Fire Sciences"]
["B.C. Ministry of Forests and Range - Protection Program"]
[]
["Telephone: 250-387-8716; Facsimile: 250-387-5685"]
["E-mail: Nathalie.Lavoie@gov.bc.ca"]
[null,null,null,null,null,null,"Please note that Nathalie left the Protection program in 2008. "]
["Mailing Address:"]
["PO Box 9502, Stn Prov Govt"]
["Victoria BC  V8W 9C1"]
["CANADA"]
["~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]

{"sheet":"Calculations","index":5,"n_rows":175,"n_cols":23,"rows_kept":175,"cut":false,"hidden":true,"merged":[[80,12,80,13],[81,12,81,13],[39,19,39,20],[40,19,40,20],[39,7,39,8],[40,7,40,8],[76,12,76,13],[77,12,77,13]]}
[]
["Number of intersects per diameter class along the sampling line"]
[]
[null,null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0"]
[null,null,null,{"$f":"Input!E15","v":0},{"$f":"Input!F15","v":0},{"$f":"Input!G15","v":0},{"$f":"Input!H15","v":0},{"$f":"Input!I15","v":0}]
[]
["Length of line used for each diameter class"]
[]
[null,null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0"]
[null,null,null,{"$f":"Input!D10","v":0},{"$f":"Input!E10","v":0},{"$f":"Input!F10","v":0},{"$f":"Input!G10","v":0},{"$f":"Input!H10","v":0},"(m)"]
[]
["Slope of the line"]
[null,null,null,{"$f":"Input!E5","v":0},"(%)"]
[]
["Quadratic Mean Diameter Calculation"]
[null,null,"Diameter Class"]
[]
[null,null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0"]
[null,"Class low",null,0,0.5,1,3,5]
[null,"Class high",null,0.5,1,3,5,7]
[]
[null,"freq",null,{"$f":"D5/D10*30","v":{"$error":"#DIV/0!"}},{"$f":"E5/E10*30","v":{"$error":"#DIV/0!"}},{"$f":"F5/F10*30","v":{"$error":"#DIV/0!"}},{"$f":"G5/G10*30","v":{"$error":"#DIV/0!"}},{"$f":"H5/H10*30","v":{"$error":"#DIV/0!"}}]
[null,"adjfreq",null,{"$f":"D22/(D20-D19)","v":{"$error":"#DIV/0!"}},{"$f":"E22/(E20-E19)","v":{"$error":"#DIV/0!"}},{"$f":"F22/(F20-F19)","v":{"$error":"#DIV/0!"}},{"$f":"G22/(G20-G19)","v":{"$error":"#DIV/0!"}},{"$f":"H22/(H20-H19)","v":{"$error":"#DIV/0!"}}]
[null,"mid-class",null,{"$f":"((D20-D19)/2)+D19","v":0.25},{"$f":"((E20-E19)/2)+E19","v":0.75},{"$f":"((F20-F19)/2)+F19","v":2},{"$f":"((G20-G19)/2)+G19","v":4},{"$f":"((H20-H19)/2)+H19","v":6}]
[null,"Ln(adjfreq)",null,{"$f":"IF(D23<0.00000001,\"\",LN(D23))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E23<0.00000001,\"\",LN(E23))","v":{"$error":"#DIV/0!"}},{"$f":"IF(F23<0.00000001,\"\",LN(F23))","v":{"$error":"#DIV/0!"}},{"$f":"IF(G23<0.00000001,\"\",LN(G23))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H23<0.00000001,\"\",LN(H23))","v":{"$error":"#DIV/0!"}},"y"]
[null,"Ln(mid-class)",null,{"$f":"LN(D24)","v":-1.3862943611198906},{"$f":"LN(E24)","v":-0.2876820724517809},{"$f":"LN(F24)","v":0.69314718055994529},{"$f":"LN(G24)","v":1.3862943611198906},{"$f":"LN(H24)","v":1.791759469228055},"x"]
[]
[null,"Slope (b)",null,{"$f":"SLOPE(D25:H25,D26:H26)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Class low",null,0.1,0.5,1,3,5]
[null,"Class high",null,0.5,1,3,5,7]
[]
[null,"QMD2=",null,{"$f":"(($D$28+1)*((D31^($D$28+3))-(D30^($D$28+3))))/(($D$28+3)*((D31^($D$28+1))-(D30^($D$28+1))))","v":{"$error":"#DIV/0!"}},{"$f":"(($D$28+1)*((E31^($D$28+3))-(E30^($D$28+3))))/(($D$28+3)*((E31^($D$28+1))-(E30^($D$28+1))))","v":{"$error":"#DIV/0!"}},{"$f":"(($D$28+1)*((F31^($D$28+3))-(F30^($D$28+3))))/(($D$28+3)*((F31^($D$28+1))-(F30^($D$28+1))))","v":{"$error":"#DIV/0!"}},{"$f":"(($D$28+1)*((G31^($D$28+3))-(G30^($D$28+3))))/(($D$28+3)*((G31^($D$28+1))-(G30^($D$28+1))))","v":{"$error":"#DIV/0!"}},{"$f":"(($D$28+1)*((H31^($D$28+3))-(H30^($D$28+3))))/(($D$28+3)*((H31^($D$28+1))-(H30^($D$28+1))))","v":{"$error":"#DIV/0!"}}]
[null,"QMD=",null,{"$f":"SQRT(D33)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(E33)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(F33)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(G33)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(H33)","v":{"$error":"#DIV/0!"}}]
[null,"QMD_D2",null,{"$f":"((0.275+0.336+0.313+0.338)/4)^2","v":9.9540249999999997E-2},{"$f":"((0.682+0.697+0.711+0.669)/4)^2","v":0.47575506249999999},{"$f":"((1.692+1.91+1.807+1.814)/4)^2","v":3.2607330624999999},{"$f":"((3.894+3.884+3.796+3.909)/4)^2","v":14.982705562500001},{"$f":"((5.862+5.925+5.903+5.872)/4)^2","v":34.697990249999989},null,"Average from Delisle and Woodard (1988) used"]
["Slope Correction Factor",null,null,null,null,null,null,null,null,"only when only a few classes with intersections"]
[]
[null,"c=",null,{"$f":"(1+((D13/100)^2))^0.5","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"This section uses average QMD from Delisle and Woodard (1988)"]
["Fuel Load (<7 cm diameter)",null,null,null,null,null,"W = ","kn(QMD)2Gac",null,null,null,null,"Fuel Load (<7 cm diameter)",null,null,null,null,null,"W = ","kn(QMD)2Gac"]
[null,null,null,null,null,null,null,"NL",null,null,null,null,null,null,null,null,null,null,null,"NL"]
["Specific Gravity (G)",null,null,null,null,null,null,null,null,null,null,null,"Specific Gravity (G)"]
[null,"Species",null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0",null,null,null,null,null,"Species",null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0"]
[null,{"$f":"IF(Input!E21=\"\",\"\",Input!E21)","v":""},null,{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""},null,null,null,null,null,{"$f":"B44","v":""},null,{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B44=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B44,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""}]
[null,{"$f":"IF(Input!F21=\"\",\"\",Input!F21)","v":""},null,{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""},null,null,null,null,null,{"$f":"B45","v":""},null,{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B45=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B45,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""}]
[null,{"$f":"IF(Input!G21=\"\",\"\",Input!G21)","v":""},null,{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""},null,null,null,null,null,{"$f":"B46","v":""},null,{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B46=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B46,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""}]
[null,{"$f":"IF(Input!H21=\"\",\"\",Input!H21)","v":""},null,{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""},null,null,null,null,null,{"$f":"B47","v":""},null,{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B47=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B47,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""}]
[null,{"$f":"IF(Input!I21=\"\",\"\",Input!I21)","v":""},null,{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""},null,null,null,null,null,{"$f":"B48","v":""},null,{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),3))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),4))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),5))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),6))","v":""},{"$f":"IF($B48=\"\",\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP($B48,'Specific Gravity'!$K$7:$L$72,2,FALSE),7))","v":""}]
[]
["Fuel Load",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total",null,null,"Fuel Load",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total"]
["W=",{"$f":"IF(B44=\"\",\"\",B44)","v":""},null,{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*D$5*D$33*D44*1.13*$D$38)/(1*D$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*E$5*E$33*E44*1.13*$D$38)/(1*E$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*F$5*F$33*F44*1.13*$D$38)/(1*F$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*G$5*G$33*G44*1.13*$D$38)/(1*G$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*H$5*H$33*H44*1.13*$D$38)/(1*H$10))","v":0},{"$f":"IF(Input!E22=\"\",0,Input!E22)","v":0},{"$f":"IF(B51=\"\",\"\",SUM(D51:H51)*(I51/100))","v":""},"(t/ha)",null,"W=",{"$f":"IF(N44=\"\",\"\",N44)","v":""},null,{"$f":"IF($B51=\"\",0,(1.234*D$5*D$35*D44*1.13*$D$38)/(1*D$10))","v":0},0,0,0,0,{"$f":"IF(Input!E22=\"\",0,Input!E22)","v":0},{"$f":"IF(B51=\"\",\"\",SUM(P51:T51)*(I51/100))","v":""},"(t/ha)"]
[null,{"$f":"IF(B45=\"\",\"\",B45)","v":""},null,{"$f":"IF($B52=\"\",0,(((PI()^2)/8)*D$5*D$33*D45*1.13*$D$38)/(1*D$10))","v":0},0,{"$f":"IF($B52=\"\",0,(((PI()^2)/8)*F$5*F$33*F45*1.13*$D$38)/(1*F$10))","v":0},0,0,{"$f":"IF(Input!F22=\"\",0,Input!F22)","v":0},{"$f":"IF(B52=\"\",\"\",SUM(D52:H52)*(I52/100))","v":""},"(t/ha)",null,null,{"$f":"IF(N45=\"\",\"\",N45)","v":""},null,0,0,0,0,0,{"$f":"IF(Input!F22=\"\",0,Input!F22)","v":0},{"$f":"IF(B52=\"\",\"\",SUM(P52:T52)*(I52/100))","v":""},"(t/ha)"]
[null,{"$f":"IF(B46=\"\",\"\",B46)","v":""},null,0,0,0,0,0,{"$f":"IF(Input!G22=\"\",0,Input!G22)","v":0},{"$f":"IF(B53=\"\",\"\",SUM(D53:H53)*(I53/100))","v":""},"(t/ha)",null,null,{"$f":"IF(N46=\"\",\"\",N46)","v":""},null,0,0,0,0,0,{"$f":"IF(Input!G22=\"\",0,Input!G22)","v":0},{"$f":"IF(B53=\"\",\"\",SUM(P53:T53)*(I53/100))","v":""},"(t/ha)"]
[null,{"$f":"IF(B47=\"\",\"\",B47)","v":""},null,0,0,0,0,0,{"$f":"IF(Input!H22=\"\",0,Input!H22)","v":0},{"$f":"IF(B54=\"\",\"\",SUM(D54:H54)*(I54/100))","v":""},"(t/ha)",null,null,{"$f":"IF(N47=\"\",\"\",N47)","v":""},null,0,0,0,0,0,{"$f":"IF(Input!H22=\"\",0,Input!H22)","v":0},{"$f":"IF(B54=\"\",\"\",SUM(P54:T54)*(I54/100))","v":""},"(t/ha)"]
[null,{"$f":"IF(B48=\"\",\"\",B48)","v":""},null,0,0,0,0,0,{"$f":"IF(Input!I22=\"\",0,Input!I22)","v":0},{"$f":"IF(B55=\"\",\"\",SUM(D55:H55)*(I55/100))","v":""},"(t/ha)",null,null,{"$f":"IF(N48=\"\",\"\",N48)","v":""},null,0,0,0,0,0,{"$f":"IF(Input!I22=\"\",0,Input!I22)","v":0},{"$f":"IF(B55=\"\",\"\",SUM(P55:T55)*(I55/100))","v":""},"(t/ha)"]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J51:J55)","v":0},"(t/ha)",null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(V51:V55)","v":0},"(t/ha)"]
[]
["Fuel Load",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total",null,null,"Fuel Load",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total"]
["W=","All spp",null,{"$f":"(D51*$I51/100)+(D52*$I52/100)+(D53*$I53/100)+(D54*$I54/100)+(D55*$I55/100)","v":0},{"$f":"(E51*$I51/100)+(E52*$I52/100)+(E53*$I53/100)+(E54*$I54/100)+(E55*$I55/100)","v":0},{"$f":"(F51*$I51/100)+(F52*$I52/100)+(F53*$I53/100)+(F54*$I54/100)+(F55*$I55/100)","v":0},{"$f":"(G51*$I51/100)+(G52*$I52/100)+(G53*$I53/100)+(G54*$I54/100)+(G55*$I55/100)","v":0},{"$f":"(H51*$I51/100)+(H52*$I52/100)+(H53*$I53/100)+(H54*$I54/100)+(H55*$I55/100)","v":0},100,{"$f":"SUM(D59:H59)","v":0},"(t/ha)",null,"W=","All spp",null,{"$f":"(P51*$I51/100)+(P52*$I52/100)+(P53*$I53/100)+(P54*$I54/100)+(P55*$I55/100)","v":0},{"$f":"(Q51*$I51/100)+(Q52*$I52/100)+(Q53*$I53/100)+(Q54*$I54/100)+(Q55*$I55/100)","v":0},{"$f":"(R51*$I51/100)+(R52*$I52/100)+(R53*$I53/100)+(R54*$I54/100)+(R55*$I55/100)","v":0},{"$f":"(S51*$I51/100)+(S52*$I52/100)+(S53*$I53/100)+(S54*$I54/100)+(S55*$I55/100)","v":0},{"$f":"(T51*$I51/100)+(T52*$I52/100)+(T53*$I53/100)+(T54*$I54/100)+(T55*$I55/100)","v":0},100,{"$f":"SUM(P59:T59)","v":0},"(t/ha)"]
[]
[]
[]
["V=",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total",null,null,"V=",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total"]
[null,{"$f":"B51","v":""},null,{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*D$5*D$33*1.13*$D$38)/(1*D$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*E$5*E$33*1.13*$D$38)/(1*E$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*F$5*F$33*1.13*$D$38)/(1*F$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*G$5*G$33*1.13*$D$38)/(1*G$10))","v":0},{"$f":"IF($B51=\"\",0,(((PI()^2)/8)*H$5*H$33*1.13*$D$38)/(1*H$10))","v":0},{"$f":"I51","v":0},{"$f":"IF(B64=\"\",\"\",SUM(D64:H64)*(I64/100))","v":""},"(m3/ha)",null,null,{"$f":"N51","v":""},null,{"$f":"IF(P51=0,0,P51/P44)","v":0},0,0,0,0,{"$f":"U51","v":0},{"$f":"IF(N64=\"\",\"\",SUM(P64:T64)*(U64/100))","v":""},"(m3/ha)"]
[null,{"$f":"B52","v":""},null,{"$f":"IF($B52=\"\",0,(((PI()^2)/8)*D$5*D$33*1.13*$D$38)/(1*D$10))","v":0},0,0,0,0,{"$f":"I52","v":0},{"$f":"IF(B65=\"\",\"\",SUM(D65:H65)*(I65/100))","v":""},"(m3/ha)",null,null,{"$f":"N52","v":""},null,0,0,0,0,0,{"$f":"U52","v":0},{"$f":"IF(N65=\"\",\"\",SUM(P65:T65)*(U65/100))","v":""},"(m3/ha)"]
[null,{"$f":"B53","v":""},null,0,0,0,0,0,{"$f":"I53","v":0},{"$f":"IF(B66=\"\",\"\",SUM(D66:H66)*(I66/100))","v":""},"(m3/ha)",null,null,{"$f":"N53","v":""},null,0,0,0,0,0,{"$f":"U53","v":0},{"$f":"IF(N66=\"\",\"\",SUM(P66:T66)*(U66/100))","v":""},"(m3/ha)"]
[null,{"$f":"B54","v":""},null,0,0,0,0,0,{"$f":"I54","v":0},{"$f":"IF(B67=\"\",\"\",SUM(D67:H67)*(I67/100))","v":""},"(m3/ha)",null,null,{"$f":"N54","v":""},null,0,0,0,0,0,{"$f":"U54","v":0},{"$f":"IF(N67=\"\",\"\",SUM(P67:T67)*(U67/100))","v":""},"(m3/ha)"]
[null,{"$f":"B55","v":""},null,0,0,0,0,0,{"$f":"I55","v":0},{"$f":"IF(B68=\"\",\"\",SUM(D68:H68)*(I68/100))","v":""},"(m3/ha)",null,null,{"$f":"N55","v":""},null,0,0,0,0,0,{"$f":"U55","v":0},{"$f":"IF(N68=\"\",\"\",SUM(P68:T68)*(U68/100))","v":""},"(m3/ha)"]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J64:J68)","v":0},"(m3/ha)",null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(V64:V68)","v":0},"(m3/ha)"]
[]
["Fuel Load",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total",null,null,"Fuel Load",null,null,"0-0.5","0.5-1.0","1.0-3.0","3.0-5.0","5.0-7.0","%","Total"]
["W=","All spp",null,{"$f":"(D64*$I64/100)+(D65*$I65/100)+(D66*$I66/100)+(D67*$I67/100)+(D68*$I68/100)","v":0},{"$f":"(E64*$I64/100)+(E65*$I65/100)+(E66*$I66/100)+(E67*$I67/100)+(E68*$I68/100)","v":0},{"$f":"(F64*$I64/100)+(F65*$I65/100)+(F66*$I66/100)+(F67*$I67/100)+(F68*$I68/100)","v":0},{"$f":"(G64*$I64/100)+(G65*$I65/100)+(G66*$I66/100)+(G67*$I67/100)+(G68*$I68/100)","v":0},{"$f":"(H64*$I64/100)+(H65*$I65/100)+(H66*$I66/100)+(H67*$I67/100)+(H68*$I68/100)","v":0},100,{"$f":"SUM(D72:H72)","v":0},"(m3/ha)",null,"W=","All spp",null,{"$f":"(P64*$I64/100)+(P65*$I65/100)+(P66*$I66/100)+(P67*$I67/100)+(P68*$I68/100)","v":0},{"$f":"(Q64*$I64/100)+(Q65*$I65/100)+(Q66*$I66/100)+(Q67*$I67/100)+(Q68*$I68/100)","v":0},{"$f":"(R64*$I64/100)+(R65*$I65/100)+(R66*$I66/100)+(R67*$I67/100)+(R68*$I68/100)","v":0},{"$f":"(S64*$I64/100)+(S65*$I65/100)+(S66*$I66/100)+(S67*$I67/100)+(S68*$I68/100)","v":0},{"$f":"(T64*$I64/100)+(T65*$I65/100)+(T66*$I66/100)+(T67*$I67/100)+(T68*$I68/100)","v":0},100,{"$f":"SUM(P72:T72)","v":0},"(m3/ha)"]
[]
["Fuel Load (7+ to 20 cm diameter)"]
[]
["Fuel Load",null,null,"Total",null,null,"Line Length"]
["W=","All spp",null,{"$f":"IF(SUM(G84:G123)=0,\"\",(((PI()^2)/8)*SUM(F84:F123)*AVERAGE(G84:G123)*1*$D$38)/(1*$G$77))","v":""},"(t/ha)",null,{"$f":"Input!I10","v":0},"(m)",null,null,null,"W = ","kΣd2Gac"]
["V=","All spp",null,{"$f":"IF(SUM(G84:G123)=0,\"\",(((PI()^2)/8)*SUM(F84:F123)*1*$D$38)/(1*G77))","v":""},"(m3/ha)",null,null,null,null,null,null,null,"NL"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"V = ","kΣd2ac"]
[null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[null,null,null,"Species","Diameter","d2","G"]
[null,null,null,{"$f":"Input!B30","v":0},{"$f":"Input!C30","v":0},{"$f":"E84^2","v":0},{"$f":"IF(D84=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D84,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B31","v":0},{"$f":"Input!C31","v":0},{"$f":"E85^2","v":0},{"$f":"IF(D85=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D85,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B32","v":0},{"$f":"Input!C32","v":0},0,{"$f":"IF(D86=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D86,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B33","v":0},{"$f":"Input!C33","v":0},0,{"$f":"IF(D87=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D87,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B34","v":0},{"$f":"Input!C34","v":0},0,{"$f":"IF(D88=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D88,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B35","v":0},{"$f":"Input!C35","v":0},0,{"$f":"IF(D89=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D89,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B36","v":0},{"$f":"Input!C36","v":0},0,{"$f":"IF(D90=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D90,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B37","v":0},{"$f":"Input!C37","v":0},0,{"$f":"IF(D91=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D91,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B38","v":0},{"$f":"Input!C38","v":0},0,{"$f":"IF(D92=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D92,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B39","v":0},{"$f":"Input!C39","v":0},0,{"$f":"IF(D93=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D93,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D30","v":0},{"$f":"Input!E30","v":0},{"$f":"E94^2","v":0},{"$f":"IF(D94=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D94,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D31","v":0},{"$f":"Input!E31","v":0},0,{"$f":"IF(D95=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D95,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D32","v":0},{"$f":"Input!E32","v":0},0,{"$f":"IF(D96=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D96,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D33","v":0},{"$f":"Input!E33","v":0},0,{"$f":"IF(D97=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D97,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D34","v":0},{"$f":"Input!E34","v":0},0,{"$f":"IF(D98=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D98,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D35","v":0},{"$f":"Input!E35","v":0},0,{"$f":"IF(D99=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D99,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D36","v":0},{"$f":"Input!E36","v":0},0,{"$f":"IF(D100=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D100,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D37","v":0},{"$f":"Input!E37","v":0},0,{"$f":"IF(D101=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D101,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D38","v":0},{"$f":"Input!E38","v":0},0,{"$f":"IF(D102=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D102,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D39","v":0},{"$f":"Input!E39","v":0},0,{"$f":"IF(D103=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D103,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F30","v":0},{"$f":"Input!G30","v":0},{"$f":"E104^2","v":0},{"$f":"IF(D104=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D104,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F31","v":0},{"$f":"Input!G31","v":0},0,{"$f":"IF(D105=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D105,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F32","v":0},{"$f":"Input!G32","v":0},0,{"$f":"IF(D106=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D106,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F33","v":0},{"$f":"Input!G33","v":0},0,{"$f":"IF(D107=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D107,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F34","v":0},{"$f":"Input!G34","v":0},0,{"$f":"IF(D108=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D108,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F35","v":0},{"$f":"Input!G35","v":0},0,{"$f":"IF(D109=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D109,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F36","v":0},{"$f":"Input!G36","v":0},0,{"$f":"IF(D110=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D110,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F37","v":0},{"$f":"Input!G37","v":0},0,{"$f":"IF(D111=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D111,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F38","v":0},{"$f":"Input!G38","v":0},0,{"$f":"IF(D112=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D112,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F39","v":0},{"$f":"Input!G39","v":0},0,{"$f":"IF(D113=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D113,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H30","v":0},{"$f":"Input!I30","v":0},{"$f":"E114^2","v":0},{"$f":"IF(D114=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D114,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H31","v":0},{"$f":"Input!I31","v":0},0,{"$f":"IF(D115=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D115,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H32","v":0},{"$f":"Input!I32","v":0},0,{"$f":"IF(D116=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D116,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H33","v":0},{"$f":"Input!I33","v":0},0,{"$f":"IF(D117=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D117,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H34","v":0},{"$f":"Input!I34","v":0},0,{"$f":"IF(D118=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D118,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H35","v":0},{"$f":"Input!I35","v":0},0,{"$f":"IF(D119=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D119,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H36","v":0},{"$f":"Input!I36","v":0},0,{"$f":"IF(D120=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D120,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H37","v":0},{"$f":"Input!I37","v":0},0,{"$f":"IF(D121=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D121,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H38","v":0},{"$f":"Input!I38","v":0},0,{"$f":"IF(D122=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D122,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H39","v":0},{"$f":"Input!I39","v":0},0,{"$f":"IF(D123=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D123,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[]
[]
["Fuel Load (20+ cm diameter)"]
[]
["Fuel Load",null,null,"Total",null,null,"Line Length"]
["W=","All spp",null,{"$f":"IF(SUM(G136:G175)=0,\"\",(((PI()^2)/8)*SUM(F136:F175)*AVERAGE(G136:G175)*1*$D$38)/(1*$G$129))","v":""},"(t/ha)",null,{"$f":"Input!I10","v":0},"(m)"]
["V=","All spp",null,{"$f":"IF(SUM(G136:G175)=0,\"\",(((PI()^2)/8)*SUM(F136:F175)*1*$D$38)/(1*G129))","v":""},"(m3/ha)"]
[]
[]
[]
[]
[null,null,null,"Species","Diameter","d2","G"]
[null,null,null,{"$f":"Input!B46","v":0},{"$f":"Input!C46","v":0},{"$f":"E136^2","v":0},{"$f":"IF(D136=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D136,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B47","v":0},{"$f":"Input!C47","v":0},{"$f":"E137^2","v":0},{"$f":"IF(D137=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D137,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B48","v":0},{"$f":"Input!C48","v":0},0,{"$f":"IF(D138=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D138,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B49","v":0},{"$f":"Input!C49","v":0},0,{"$f":"IF(D139=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D139,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B50","v":0},{"$f":"Input!C50","v":0},0,{"$f":"IF(D140=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D140,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B51","v":0},{"$f":"Input!C51","v":0},0,{"$f":"IF(D141=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D141,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B52","v":0},{"$f":"Input!C52","v":0},0,{"$f":"IF(D142=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D142,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B53","v":0},{"$f":"Input!C53","v":0},0,{"$f":"IF(D143=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D143,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B54","v":0},{"$f":"Input!C54","v":0},0,{"$f":"IF(D144=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D144,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!B55","v":0},{"$f":"Input!C55","v":0},0,{"$f":"IF(D145=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D145,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D46","v":0},{"$f":"Input!E46","v":0},0,{"$f":"IF(D146=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D146,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D47","v":0},{"$f":"Input!E47","v":0},0,{"$f":"IF(D147=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D147,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D48","v":0},{"$f":"Input!E48","v":0},0,{"$f":"IF(D148=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D148,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D49","v":0},{"$f":"Input!E49","v":0},0,{"$f":"IF(D149=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D149,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D50","v":0},{"$f":"Input!E50","v":0},0,{"$f":"IF(D150=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D150,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D51","v":0},{"$f":"Input!E51","v":0},0,{"$f":"IF(D151=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D151,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D52","v":0},{"$f":"Input!E52","v":0},0,{"$f":"IF(D152=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D152,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D53","v":0},{"$f":"Input!E53","v":0},0,{"$f":"IF(D153=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D153,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D54","v":0},{"$f":"Input!E54","v":0},0,{"$f":"IF(D154=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D154,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!D55","v":0},{"$f":"Input!E55","v":0},0,{"$f":"IF(D155=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D155,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F46","v":0},{"$f":"Input!G46","v":0},0,{"$f":"IF(D156=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D156,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F47","v":0},{"$f":"Input!G47","v":0},0,{"$f":"IF(D157=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D157,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F48","v":0},{"$f":"Input!G48","v":0},0,{"$f":"IF(D158=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D158,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F49","v":0},{"$f":"Input!G49","v":0},0,{"$f":"IF(D159=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D159,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F50","v":0},{"$f":"Input!G50","v":0},0,{"$f":"IF(D160=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D160,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F51","v":0},{"$f":"Input!G51","v":0},0,{"$f":"IF(D161=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D161,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F52","v":0},{"$f":"Input!G52","v":0},0,{"$f":"IF(D162=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D162,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F53","v":0},{"$f":"Input!G53","v":0},0,{"$f":"IF(D163=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D163,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F54","v":0},{"$f":"Input!G54","v":0},0,{"$f":"IF(D164=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D164,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!F55","v":0},{"$f":"Input!G55","v":0},0,{"$f":"IF(D165=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D165,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H46","v":0},{"$f":"Input!I46","v":0},0,{"$f":"IF(D166=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D166,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H47","v":0},{"$f":"Input!I47","v":0},0,{"$f":"IF(D167=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D167,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H48","v":0},{"$f":"Input!I48","v":0},0,{"$f":"IF(D168=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D168,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H49","v":0},{"$f":"Input!I49","v":0},0,{"$f":"IF(D169=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D169,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H50","v":0},{"$f":"Input!I50","v":0},0,{"$f":"IF(D170=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D170,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H51","v":0},{"$f":"Input!I51","v":0},0,{"$f":"IF(D171=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D171,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H52","v":0},{"$f":"Input!I52","v":0},0,{"$f":"IF(D172=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D172,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H53","v":0},{"$f":"Input!I53","v":0},0,{"$f":"IF(D173=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D173,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H54","v":0},{"$f":"Input!I54","v":0},0,{"$f":"IF(D174=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D174,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]
[null,null,null,{"$f":"Input!H55","v":0},{"$f":"Input!I55","v":0},0,{"$f":"IF(D175=0,\"\",INDEX('Specific Gravity'!$B$7:$I$72,VLOOKUP(D175,'Specific Gravity'!$K$7:$L$72,2,FALSE),8))","v":""}]

{"sheet":"References","index":6,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":true,"merged":[[3,1,4,8],[6,2,6,3],[7,2,7,3],[49,2,50,8],[51,2,52,8],[9,2,10,2],[9,3,9,5],[9,6,10,6],[10,3,10,5],[30,2,31,8],[40,2,40,3],[41,2,41,3],[21,2,22,8],[37,1,38,8],[23,2,24,8],[25,2,26,8]]}
[null,"From: Delisle and Woodard (1988) based on Van Wagner (1982)"]
[null,"Also used info in Ember Research Services Ltd (1997)"]
[]
[null,"To calculate the weight of various size classes of downed-dead roundwood fuels <= 7.0 cm in diameter"]
[]
[]
[null,"W = ","kn(QMD)2Gac"]
[null,null,"NL"]
[]
[null,"(QMD)2 =","(","(b1+1) * (x2b1+3 - X1b1+3 )",null,null,")0.5"]
[null,null,null,"(b1+3) * (x2b1+1 - X1b1+1 )"]
[]
[null,"Y=","axb"]
[]
[]
[null,"c=","(1+((% ground slope)/100)2))0.5"]
[]
[]
[null,"W","fuel load (t/ha)"]
[null,"k","1.234 (constant to convert roundwood volume to a weight per unit area basis"]
[null,"n","number of intercepts per roundwood diameter size class"]
[null,"(QMD)2","squared quadratic mean diameter for intercepted roundwood <= 7.0 cm in diameter (cm2)"]
[]
[null,"G","specific gravity of roundwood according to diameter size class and/or degree of decay"]
[]
[null,"a","correction factor for nonhorizontal angle of roundwood pieces (1.13 for roundwood <= 7 cm in diameter (Brown and Roussopoulos 1974))"]
[]
[null,"c","slope correction factor"]
[null,"N","number of fuel sampling transects"]
[null,"L","length of the fuel transect (m)"]
[null,"y","number of intersections per unit length of sample line for a diameter class of one unit width"]
[]
[null,"x2","upper size class limit of class i"]
[null,"x1","lower size class limit of class i"]
[null,"b ","constant"]
[null,"a","constant"]
[]
[null,"To calculate the weight of roundwood pieces > 7.0 cm in diameter"]
[]
[]
[null,"W = ","kΣd2Gac"]
[null,null,"NL"]
[]
[null,"c=","(1+((% ground slope)/100)2))0.5"]
[]
[]
[null,"W","fuel load (t/ha)"]
[null,"k","1.234 (constant to convert roundwood volume to a weight per unit area basis"]
[null,"Σd2","sum of the squared diameters for the intercepted roundwood"]
[null,"G","specific gravity of roundwood according to diameter size class and/or degree of decay"]
[]
[null,"a","correction factor for nonhorizontal angle of roundwood pieces (1.00 for roundwood > 7.0 cm in diameter (Brown 1974))"]
[]
[null,"c","slope correction factor"]
[null,"N","number of fuel sampling transects"]
[null,"L","length of the fuel transect (m)"]

{"sheet":"Specific Gravity","index":7,"n_rows":76,"n_cols":12,"rows_kept":76,"cut":false,"hidden":true,"merged":[[75,0,103,8]]}
[]
[null,"Nominal relative densities* by species and size class",null,null,null,null,null,null,null,null,"Nominal relative densities* by species and size class"]
[null,null,null,"Size Class (cm)"]
[]
[null,"Code","Species","0-0.5","0.5-1","1-3","3-5","5-7","7+",null,"Code","Order"]
[null,null,"Class ID",1,2,3,4,5,6]
[null,"Cw","western redcedar",0.48,0.48,0.33,0.33,0.33,0.33,null,"Cw",1]
[null,"Yc","yellow-cedar",0.44,0.44,0.42,0.42,0.42,0.42,null,"Yc",2]
[null,"Fd","Douglas-fir",0.55000000000000004,0.55000000000000004,0.43,0.43,0.43,0.43,null,"Fd",3]
[null,"Fdc","coastal Douglas-fir",0.53,0.53,0.43,0.43,0.43,0.43,null,"Fdc",4]
[null,"Fdi","interior Douglas-fir",0.56999999999999995,0.56999999999999995,0.43,0.43,0.4,0.4,null,"Fdi",5]
[null,"Ba","amabilis fir",0.43,0.43,0.4,0.4,0.4,0.4,null,"Ba",6]
[null,"Bg","grand fir",0.57999999999999996,0.57999999999999996,0.5,0.45,0.45,0.45,null,"Bg",7]
[null,"Bp","noble fir",0.39,0.39,0.36,0.36,0.36,0.36,null,"Bp",8]
[null,"Bl","subalpine fir",0.41,0.41,0.4,0.4,0.4,0.4,null,"Bl",9]
[null,"Hm","mountain hemlock",0.45,0.45,0.43,0.43,0.43,0.43,null,"Hm",10]
[null,"Hw","western hemlock",0.45,0.45,0.43,0.43,0.43,0.43,null,"Hw",11]
[null,"Hxm","mountain x western hemlock hybrid",0.45,0.45,0.43,0.43,0.43,0.43,null,"Hxm",12]
[null,"Jr","Rocky Mtn. juniper",0.44,0.44,0.42,0.42,0.42,0.42,null,"Jr",13]
[null,"La","alpine larch",0.54,0.54,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,null,"La",14]
[null,"Lt","tamarack",0.53,0.53,0.51,0.51,0.51,0.51,null,"Lt",15]
[null,"Lw","western larch",0.5,0.5,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,null,"Lw",16]
[null,"Pj","jack pine",0.43,0.43,0.4,0.4,0.4,0.4,null,"Pj",17]
[null,"Pf","limber pine",0.38,0.38,0.34,0.34,0.34,0.34,null,"Pf",18]
[null,"Pl","lodgepole pine",0.49,0.49,0.41,0.41,0.41,0.41,null,"Pl",19]
[null,"Pxj","lodgepole x jack pine hybrid",0.46,0.46,0.4,0.4,0.4,0.4,null,"Pxj",20]
[null,"Py","ponderosa pine",0.41,0.41,0.51,0.51,0.51,0.51,null,"Py",21]
[null,"Plc","shore pine",0.49,0.49,0.41,0.41,0.41,0.41,null,"Plc",22]
[null,"Pw","western white pine",0.38,0.38,0.34,0.34,0.34,0.34,null,"Pw",23]
[null,"Pa","whitebark pine",0.38,0.38,0.34,0.34,0.34,0.34,null,"Pa",24]
[null,"Sb","black spruce",0.4,0.4,0.38,0.38,0.38,0.38,null,"Sb",25]
[null,"Se","Engelmann spruce",0.34,0.34,0.34,0.34,0.34,0.34,null,"Se",26]
[null,"Ss","Sitka spruce",0.4,0.4,0.38,0.38,0.38,0.38,null,"Ss",27]
[null,"Sw","white spruce",0.4,0.4,0.38,0.38,0.38,0.38,null,"Sw",28]
[null,"Sx","spruce hybrid",0.38,0.38,0.36,0.36,0.36,0.36,null,"Sx",29]
[null,"Tw","western yew",0.5,0.5,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,null,"Tw",30]
[null,"Dm","mountain alder",0.41,0.41,0.41,0.41,0.41,0.4,null,"Dm",31]
[null,"Dr","red alder",0.41,0.41,0.41,0.41,0.41,0.4,null,"Dr",32]
[null,"Dg","green and Sitka alder",0.41,0.41,0.41,0.41,0.41,0.4,null,"Dg",33]
[null,"Up","Pacific crab apple",0.5,0.5,0.46,0.46,0.46,0.46,null,"Up",34]
[null,"Ac","poplar",0.34,0.34,0.32,0.32,0.32,0.32,null,"Ac",35]
[null,"Acb","balsam poplar",0.34,0.34,0.32,0.32,0.32,0.32,null,"Acb",36]
[null,"Act","black cottonwood",0.35,0.35,0.33,0.33,0.33,0.33,null,"Act",37]
[null,"Ax","hybrid poplars",0.34,0.34,0.32,0.32,0.32,0.32,null,"Ax",38]
[null,"At","trembling aspen",0.38,0.38,0.34,0.34,0.34,0.34,null,"At",39]
[null,"Ra","Arbutus",0.55000000000000004,0.55000000000000004,0.43,0.43,0.43,0.43,null,"Ra",40]
[null,"Ea","Alaska paper birch",0.55000000000000004,0.55000000000000004,0.43,0.43,0.43,0.43,null,"Ea",41]
[null,"Exp","Alaska x paper birch hybrid",0.55000000000000004,0.55000000000000004,0.43,0.43,0.43,0.43,null,"Exp",42]
[null,"Ep","paper birch",0.55000000000000004,0.55000000000000004,0.43,0.43,0.43,0.43,null,"Ep",43]
[null,"Ew","water birch",0.55000000000000004,0.55000000000000004,0.43,0.43,0.43,0.43,null,"Ew",44]
[null,"Exw","water x paper birch hybrid",0.55000000000000004,0.55000000000000004,0.43,0.43,0.43,0.43,null,"Exw",45]
[null,"Kc","cascara",0.48,0.48,0.46,0.46,0.46,0.46,null,"Kc",46]
[null,"Vb","bitter cherry",0.53,0.53,0.43,0.43,0.43,0.43,null,"Vb",47]
[null,"Vv","choke cherry",0.53,0.53,0.43,0.43,0.43,0.43,null,"Vv",48]
[null,"Vp","pin cherry",0.53,0.53,0.43,0.43,0.43,0.43,null,"Vp",49]
[null,"Gp","Pacific dogwood",0.48,0.48,0.46,0.46,0.46,0.46,null,"Gp",50]
[null,"Mb","bigleaf maple",0.48,0.48,0.46,0.46,0.46,0.46,null,"Mb",51]
[null,"Mv","vine maple",0.48,0.48,0.46,0.46,0.46,0.46,null,"Mv",52]
[null,"Mr","Rocky Mtn. maple",0.48,0.48,0.46,0.46,0.46,0.46,null,"Mr",53]
[null,"Qg","Garry oak",0.68,0.68,0.64,0.64,0.6,0.6,null,"Qg",54]
[null,"Wb","Bebb's willow",0.53,0.53,0.5,0.5,0.46,0.46,null,"Wb",55]
[null,"Wp","Pacific willow",0.53,0.53,0.5,0.5,0.46,0.46,null,"Wp",56]
[null,"Wa","peachleaf willow",0.53,0.53,0.5,0.5,0.46,0.46,null,"Wa",57]
[null,"Wd","pussy willow",0.53,0.53,0.5,0.5,0.46,0.46,null,"Wd",58]
[null,"Ws","Scouler's willow",0.53,0.53,0.5,0.5,0.46,0.46,null,"Ws",59]
[null,"Wt","Sitka willow",0.53,0.53,0.5,0.5,0.46,0.46,null,"Wt",60]
[null,"Xc","Unknown conifer",0.45,0.45,0.41,0.41,0.41,0.41,null,"Xc",61]
[null,"Xh","Unknown hardwood",0.48,0.48,0.43,0.43,0.42,0.42,null,"Xh",62]
[null,"Zc","Other conifer",0.45,0.45,0.41,0.41,0.41,0.41,null,"Zc",63]
[null,"Zh","Other hardwood",0.48,0.48,0.43,0.43,0.42,0.42,null,"Zh",64]
[null,"U","Unknown (Fuel Load Module)",0.43,0.43,0.42,0.42,0.42,0.4,null,"U",65]
[null,"D","Decayed (Fuel Load Module)",0.3,0.3,0.3,0.3,0.3,0.4,null,"D",66]
[null,"* formerly known as specific gravity",null,null,null,null,null,null,null,null,"* formerly known as specific gravity"]
[]
[]
["Note from John Parminter (10 Jul 2008) regarding the values above (also used in the \"CWD/Fuel Calculator\", a software developed by Ember Research - some bugs with line length led us to develop this Excel calculator): The specific gravities came from a number of sources, mostly to do with wood products rather than fuel and CWD.  They're listed in Appendix C of the \"CWD/Fuel Calculator\" manual. According to my notes the values came from four main sources:\nBrown, James K. 1974. - http://www.treesearch.fs.fed.us/pubs/28647 \nRyan, Kevin C. and S.G. Pickford. 1978. Physical properties of woody fuels in the Blue Mountains of Oregon and Washington. USDA For. Serv. Research Note PNW-315. Portland, Oregon. \nBeaufait, William R., C.E. Hardy, and W.C. Fischer. 1977. Broadcast burning in larch-fir clearcuts: the Miller Creek - Newman Ridge study. USDA For. Serv. Research Paper INT-175. Ogden, Utah. \nand for species not included in those, from \nThe encyclopedia of wood - wood as an engineering material. Sterling Publishing, New York. \nThe values in the program have not been changed through time.  His original rationale was that the values for specific gravity wouldn't change much for fresh wood since the forest products industry had done a lot of work on them, they should be reasonably accurate, and logging slash is usually fairly fresh. He made interpolations for some species and size classes when constructing the table.\nAs CWD wasn't an issue then, there are no species by size class by decay class value breakdowns for specific gravities. He recognizes that as a deficiency and if such values came to light they could be worked in."]