Laserfiche WebLink
File > Export results was used to save the table results in HTML format. The HTML <br />file was opened with the spreadsheet program and saved as a spreadsheet file. The table <br />output (a section of the complete HTML file) was then copied to another worksheet, and <br />surface rate of spread and flame length were plotted on the same graph with the rate of <br />spread axis on the left and the flame length axis on the right. A dashed line was added to <br />show the initial fuel loading value (Figure 54). <br />i <br />1 <br />2 <br />A <br />1-# <br />Load <br />6 <br />ROS <br />(max) <br />C <br />Rama <br />Lan0h <br />D <br />E F - G T H I J <br />K <br />FuelMrdal2 <br />3 <br />toNac <br />ttdh <br />tt <br />1-h load - 2 tonfac <br />405 <br />222 <br />36 <br />5 ' <br />1 <br />36.9 <br />53 <br />q` <br />5urfece PO5 (max:, chJh -Flame LenpEh, R <br />6 <br />15 <br />477 <br />6-? <br />is <br />7 <br />2 <br />56B <br />79 <br />� 60 <br />` 70 <br />_�- <br />12 <br />8 <br />9. <br />- <br />10: <br />25 <br />3 <br />3-5 <br />61.8 <br />56.5 <br />70.1 <br />E.9 <br />$.8 <br />30.5 <br />6D <br />■ <br />i <br />i0 <br />s" <br />34 <br />4 <br />73 <br />11.2 <br />_111 <br />12 <br />4.5 <br />T5.3 <br />lie <br />6 <br />13' <br />14 <br />5 <br />±T2 <br />123 <br />30 <br />20 <br />t <br />g <br />15 � <br />N 1a <br />1 <br />x <br />1�; <br />I <br />1�' <br />0 <br />2 3 4 5 <br />5 <br />_20 <br />1-h Fuel Load, tonlac <br />i <br />Figure 54 -With a spreadsheet program, multiple variables can be plotted on the same graph. <br />The inputs that create these data came from Figure 53a. <br />A spreadsheet can also be used to perform additional calculations. For this example, we <br />calculate the ratio of surface rate of spread to flame length (Figure 55). This calculation <br />was suggested for custom fuel model development by Burgan and Rothermel (1984) to <br />deal with the common problem of generating approximately the right spread rate but having <br />the flame length too low or vice versa. The plot shows whether spread rate will increase <br />faster than flame length (rising curve) or slower (decreasing curve) as the value of the se- <br />lected parameter changes. (We converted the surface rate of spread from ch/h to ft/min in <br />the spreadsheet although the unit conversion could have been done in BehavePlus before <br />export.) <br />a A B C G E F G H I K t M <br />1 1-h ROS ROS Flame ROS f FL <br />2 ln;r1 llw1x) t1wv'. Len®16 i Fuel Modal 2 i <br />3 R-W.x: am RN"n o '1-h bad 2 tonlac <br />4 u.ij 22.2 244 3.0 0.70 {i 9.06 <br />6 , i 36.6 40-6 61 7.6E 1 TO 1 <br />6 IA 477 52f 6.7 7t <br />7 7 55.8 61.4 7.9 77i 7.60 1 <br />B 2;i 61.8 68.0 to 7.64 ti 7,40 <br />!i :l 66.5 73.2 4.E 7.46 710 <br />10 3 a 70.1 77.1 10.5 7.31 <br />11. 1 73 007 112 717 7.eG <br />72 1A 76.3 628 11-E 7.02 c.s0 <br />T72 845 123 6.91 <br />1 6.64 <br />15 <br />0 1 z2 4 314 <br />c <br />1-h Fuel Load, mnlac € <br />37 <br />+e <br />Figure 55 -With a spreadsheet program, the ratio of surface rate of spread to flame length was <br />calculated and plotted. <br />USDA Forest Service Gen. Tech. Rep. RMRS-GTR-249. 2010 67 <br />