Themeda	0	"The cells to the left are for inputting the data that describe the site, according to the text."
OtherNativeGrassCover	0	
NativeHerbCover	0	
"NativeHerbDiversityScale (0=none, 1=low, 2=high)"	0	
Exotic PerennialCover	0	
ExoticAnnualCover	0	
BareGround	0	
"Derocking (0=rocks removed, 1=not removed)"	0	
		
Tree1	"=IF(B4>5,IF(B3>1,IF(B7>10,12.666667,IF(B9=1,IF(B5=1,14.6,IF(B6>0,16.5,IF(B7>5,17.4,18.681818))),15.814815)),13.0625),IF(B2>20,IF(B6>10,10.058824,IF(B7>20,11,IF(B8>50,IF(B2>25,IF(B5=1,15,8),16.666667),IF(B2>80,11.9,IF(B5=1,IF(B3>5,IF(B9=1,IF(B2>25,IF(B2>50,15,17),13),IF(B2>25,12.5,14.5)),12.75),15.5))))),IF(B3>5,IF(B3>65,IF(B6>0,7.5,12.625),IF(B4>1,8.416667,IF(B6>50,3.9,IF(B3>10,IF(B9=1,8.125,6.533333),5.642857)))),IF(B2>1,IF(B7>1,4.636364,8.25),IF(B9=1,IF(B6>5,IF(B6>90,1,4.384615),1.823529),IF(B8>50,IF(B7>0,2.142857,1.125),0.5625))))))"	
Tree2	"=IF(B4>1,IF(B5=1,IF(B8>10,IF(B2>5,11.4,IF(B3>30,9.6,6.166667)),12.6),IF(B6>25,10.666667,IF(B9=1,IF(B7>10,14.285714,IF(B2>65,13,IF(B8>20,15.578947,IF(B7>1,15.75,17.272727)))),IF(B3>1,15.172414,10)))),IF(B2>20,IF(B6>35,7.909091,IF(B5=1,IF(B9=1,IF(B2>25,IF(B3>25,17,14.714286),17.666667),IF(B8>5,13.75,10.416667)),IF(B6>0,5,10.8125))),IF(B3>5,IF(B6>1,IF(B3>50,8.076923,IF(B2>0,5.083333,IF(B6>70,6,IF(B6>25,2,3.4)))),IF(B9=1,IF(B7>0,9.625,12.583333),7.153846)),IF(B2>5,IF(B6>0,5.142857,10.666667),IF(B9=1,IF(B7>5,IF(B6>0,5.5,2.125),1.833333),IF(B8>0,IF(B2>1,2.75,1.647059),0.785714))))))"	
Tree3	"=IF(B5=2,IF(B6>25,10.142857,IF(B3>1,IF(B9=1,IF(B2>25,IF(B6>10,15.75,IF(B7>1,17.777778,18.714286)),IF(B7>10,13,16.5)),14.55),14.421053)),IF(B2>5,IF(B6>35,IF(B2>20,IF(B9=1,IF(B2>25,5.5,10.8),6.625),4.4),IF(B7>20,IF(B4>0,9.636364,5.6),IF(B3>5,IF(B6>25,11,14.346154),IF(B2>20,11.5,IF(B4>0,9.5,6.5))))),IF(B3>25,IF(B9=1,11.411765,IF(B2>0,9.666667,4.833333)),IF(B3>0,IF(B6>15,IF(B7>50,5.285714,3.791667),6.764706),IF(B4>1,6.8,IF(B8>0,IF(B7>0,2.033333,0.625),IF(B9=1,1.714286,IF(B6>0,0.875,0))))))))"	
Tree4	"=IF(B4>0,IF(B6>10,IF(B7>40,2.428571,IF(B3>5,10.208333,IF(B6>40,3.8,6.333333))),IF(B5=1,IF(B6>0,9.533333,IF(B8>70,7.25,IF(B7>25,8.4,IF(B9=1,IF(B3>45,12.8,IF(B3>25,16.75,14.391304)),12.769231)))),IF(B4>75,9.6,IF(B9=1,IF(B4>25,IF(B7>5,16.4,18.684211),IF(B8>55,12.333333,15.84375)),13.636364)))),IF(B3>0,IF(B6>20,IF(B2>10,9.333333,IF(B3>50,8.571429,IF(B7>25,7.6,IF(B3>20,5.666667,3.125)))),IF(B7>20,6.75,12.75)),IF(B2>1,IF(B2>30,11,IF(B6>5,4.4,7.076923)),IF(B6>0,IF(B7>10,3.2,IF(B6>10,1.117647,1.714286)),1.041667))))"	
Tree5	"=IF(B4>0,IF(B6>10,IF(B2>1,IF(B2>25,13.25,10.266667),IF(B8>20,9.8,5.0625)),IF(B8>70,IF(B3>1,4,8.6),IF(B5=1,IF(B7>10,10.538462,IF(B6>5,10.857143,IF(B2>25,IF(B7>5,13,IF(B9=1,IF(B3>20,17,IF(B2>30,15.375,14.333333)),13)),13.282051))),IF(B3>25,IF(B2>0,12.384615,16.4),IF(B2>15,16.925,15.2))))),IF(B3>0,IF(B6>20,IF(B2>10,IF(B9=1,11,5.666667),IF(B7>25,7.142857,IF(B3>20,IF(B2>0,7.666667,5.0625),IF(B8>0,4,2.333333)))),IF(B7>20,5.6,11.210526)),IF(B2>20,9,IF(B2>5,4.727273,IF(B8>0,IF(B7>0,2.047619,1.125),0.923077)))))"	
Tree6	"=IF(B5=2,IF(B4>5,IF(B2>1,IF(B8>15,20,IF(B8>0,IF(B9=1,IF(B2>25,IF(B2>30,20,17.769231),16.3),16.058824),14.923077)),14.555556),IF(B2>10,13.647059,9.333333)),IF(B4>0,IF(B6>0,IF(B2>35,12.888889,IF(B6>15,IF(B2>1,7.3,5.058824),8.966667)),IF(B8>0,IF(B8>70,8,IF(B9=1,14.653846,12)),IF(B2>50,13.2,IF(B9=1,11.166667,8.4)))),IF(B3>0,IF(B3>50,IF(B8>5,13.333333,8.947368),IF(B9=1,IF(B2>10,10.6,IF(B7>25,7.538462,4.875)),IF(B2>25,8.666667,4.153846))),IF(B2>5,IF(B2>30,14.5,6.571429),IF(B9=1,IF(B7>0,2.785714,1.428571),IF(B8>0,IF(B7>0,IF(B2>0,IF(B2>1,2.333333,0.333333),2.8),1.111111),0.384615))))))"	
Tree7	"=IF(B4>1,IF(B6>25,9.071429,IF(B8>30,11.565217,IF(B5=1,13.944444,IF(B4>60,14.315789,IF(B7>10,13.666667,IF(B9=1,IF(B6>0,15.875,17.314286),IF(B7>0,12.5,IF(B2>30,15.571429,17.4)))))))),IF(B2>5,IF(B2>20,IF(B6>35,9.833333,IF(B7>20,10.5,IF(B7>15,15.6,IF(B2>80,11.428571,IF(B2>50,14.875,12.818182))))),IF(B3>20,12.416667,IF(B6>25,3.8,7.4375))),IF(B3>5,IF(B6>15,IF(B3>25,IF(B3>65,5.75,8.2),IF(B7>50,6.2,IF(B4>0,3.2,4.692308))),IF(B8>0,9.722222,6.647059)),IF(B4>0,4.25,IF(B3>0,4.5,IF(B2>1,3,IF(B9=1,1.769231,IF(B6>90,0,IF(B6>0,IF(B8>75,1.142857,2.166667),0.666667)))))))))"	
Tree8	"=IF(B4>1,IF(B5=1,IF(B6>5,7.875,IF(B3>0,IF(B4>5,13.166667,15),11.444444)),IF(B2>5,IF(B8>0,IF(B3>25,14.692308,IF(B9=1,IF(B4>25,IF(B7>0,IF(B8>5,18.166667,19),20),IF(B2>40,18.4,16.538462)),IF(B2>30,15,17.833333))),13.666667),13.433333)),IF(B2>10,IF(B3>20,IF(B7>0,10,14.315789),IF(B2>35,IF(B2>80,13.75,11),IF(B2>30,6.25,IF(B4>0,10.769231,7.727273)))),IF(B3>25,IF(B8>0,12.545455,9.222222),IF(B3>1,IF(B8>45,11,IF(B3>10,6.068966,IF(B9=1,4.272727,IF(B2>1,4,2.818182)))),IF(B8>0,IF(B8>25,1.555556,IF(B8>10,4.333333,IF(B2>0,2.666667,1.333333))),IF(B9=1,2,0.384615))))))"	
Tree9	"=IF(B4>1,IF(B8>30,9.833333,IF(B6>25,9.8,IF(B5=1,IF(B2>0,14.923077,12.571429),IF(B9=1,IF(B7>5,15.368421,IF(B2>60,14.5,IF(B2>0,17.192308,18.363636))),14.653846)))),IF(B2>20,IF(B6>20,IF(B3>5,IF(B9=1,11.727273,8),5.5),IF(B7>5,IF(B2>50,9.25,6.5),IF(B4>0,IF(B9=1,IF(B3>25,17.2,IF(B8>5,15.428571,13.111111)),IF(B2>25,12,13.8)),11.727273))),IF(B3>25,IF(B6>0,7.173913,11.705882),IF(B2>5,IF(B5=1,9,5.92),IF(B3>0,IF(B7>25,6.117647,3.578947),IF(B9=1,IF(B4>0,3.666667,2.176471),IF(B8>0,1.8125,0.307692)))))))"	
Tree10	"=IF(B4>1,IF(B6>25,IF(B2>1,10.777778,4.6),IF(B8>20,IF(B9=1,13.636364,10.692308),IF(B5=1,12.384615,IF(B4>30,17.826087,IF(B2>60,13,IF(B9=1,IF(B6>0,15.578947,IF(B3>15,IF(B7>1,17.2,18.454545),15.5)),IF(B2>25,15.105263,IF(B2>1,10.5,11)))))))),IF(B2>5,IF(B6>5,IF(B3>1,8.233333,5),IF(B3>0,IF(B7>20,10.333333,14.2),IF(B2>25,10.5,IF(B4>0,10.333333,4.666667)))),IF(B3>0,IF(B6>15,IF(B9=1,5.15,IF(B7>0,IF(B4>0,4.6,3),5.571429)),IF(B3>25,IF(B3>75,8.6,12.555556),6.923077)),IF(B9=1,IF(B8>10,3.545455,2),IF(B2>1,2.833333,IF(B8>0,IF(B7>0,IF(B2>0,1.666667,2.5),0.777778),0.615385))))))"	
Tree11	"=IF(B5=2,IF(B6>25,IF(B2>5,4,10),IF(B2>0,IF(B9=1,IF(B8>0,16.345455,14.166667),IF(B2>30,16.181818,13.5)),11.941176)),IF(B2>5,IF(B6>25,IF(B2>20,7.117647,IF(B2>10,4,5.6)),IF(B7>25,7.714286,IF(B8>50,10.285714,IF(B4>1,10.857143,IF(B4>0,IF(B7>0,IF(B2>10,11.3,13.285714),13.444444),14.222222))))),IF(B3>25,IF(B6>5,IF(B2>1,5,8.4),11.407407),IF(B4>1,11,IF(B3>0,IF(B6>25,IF(B3>5,3.882353,6.4),IF(B7>25,8,5.166667)),IF(B9=1,IF(B8>10,3.333333,IF(B8>0,1.375,2.444444)),IF(B2>1,3.2,IF(B8>50,1.75,IF(B6>90,0,0.888889)))))))))"	
Tree12	"=IF(B4>5,IF(B2>1,IF(B4>20,IF(B5=1,12.6,IF(B4>25,IF(B9=1,17.857143,16.333333),15.466667)),10),12.185185),IF(B2>20,IF(B6>25,IF(B9=1,8.9,5.75),IF(B9=1,IF(B2>25,13.692308,15.666667),IF(B6>0,12.307692,IF(B2>50,IF(B2>90,8.333333,12.4),7.25)))),IF(B3>50,IF(B2>0,13.833333,IF(B6>0,5.333333,10.666667)),IF(B4>0,IF(B4>1,9,IF(B6>10,IF(B3>0,3.666667,7.666667),7.473684)),IF(B2>5,IF(B2>10,7.333333,5),IF(B3>0,IF(B3>5,IF(B2>0,2.333333,4),6.125),IF(B9=1,IF(B7>0,3.785714,IF(B6>0,2,0.666667)),IF(B8>0,IF(B7>0,IF(B2>1,2.5,1.777778),0.666667),0.363636))))))))"	
Tree13	"=IF(B4>0,IF(B6>15,IF(B2>1,IF(B3>5,IF(B2>25,14,11.555556),6.666667),IF(B3>25,7.166667,3.666667)),IF(B5=1,IF(B8>70,8,IF(B9=1,IF(B6>0,11.8,IF(B8>0,14.642857,11.333333)),IF(B4>1,9.333333,11.62963))),IF(B8>55,11,IF(B2>65,13.1,IF(B9=1,IF(B8>5,IF(B4>60,19.166667,16.833333),IF(B4>20,15.5625,13.2)),IF(B8>10,12.285714,15.823529)))))),IF(B2>5,IF(B2>30,IF(B7>0,13.75,8.625),IF(B6>50,5,7.285714)),IF(B3>0,IF(B3>50,IF(B2>0,10,7),IF(B7>25,6.2,4.466667)),IF(B8>0,IF(B7>5,IF(B6>0,3.125,1.846154),IF(B6>0,0.875,2)),IF(B9=1,1.857143,IF(B6>0,1.2,0))))))"	
Tree14	"=IF(B4>1,IF(B4>5,IF(B5=1,13.9,IF(B8>20,14.555556,IF(B8>15,20,IF(B6>0,14.909091,IF(B9=1,17.56,15.896552))))),IF(B2>40,IF(B3>0,IF(B2>60,12.461538,14.6),15.666667),10.192308)),IF(B2>20,IF(B9=1,IF(B4>0,IF(B6>25,10,IF(B5=1,14.521739,18)),10.375),IF(B6>25,5.333333,IF(B3>25,8.166667,IF(B8>5,15,IF(B3>20,8.333333,11.217391))))),IF(B3>25,IF(B9=1,IF(B4>0,13.571429,10.6),8.928571),IF(B3>0,IF(B9=1,IF(B6>65,1.5,IF(B2>0,IF(B6>25,5.75,8.923077),6)),IF(B6>0,IF(B6>70,5.5,3.266667),5.666667)),IF(B2>5,IF(B4>0,9,IF(B6>0,4.833333,6.5)),IF(B7>0,IF(B7>90,1.142857,2.576923),0.923077))))))"	
Tree15	"=IF(B4>0,IF(B4>5,IF(B3>1,IF(B5=1,14.666667,IF(B8>0,17.301887,15)),13.16),IF(B2>1,IF(B2>40,IF(B9=1,IF(B2>65,13.055556,IF(B6>0,IF(B5=1,12.6,15.142857),IF(B2>50,18,16.5))),10.923077),IF(B2>30,6,IF(B7>0,IF(B6>10,IF(B6>25,9.833333,12.666667),8),IF(B8>70,8.666667,IF(B2>5,13.45,10.8))))),IF(B3>5,IF(B7>30,5.833333,8.384615),3.8))),IF(B2>10,IF(B7>0,15.333333,IF(B8>0,6.25,9.714286)),IF(B3>10,7.352941,IF(B2>1,IF(B6>0,4.2,2.4),IF(B3>0,4,IF(B9=1,IF(B7>90,3,1.538462),IF(B7>50,0,1.380952)))))))"	
Tree16	"=IF(B4>1,IF(B5=1,IF(B2>5,14,IF(B9=1,11.444444,IF(B2>1,8,6.5))),IF(B9=1,IF(B6>25,10.75,IF(B8>5,17.261905,IF(B4>20,16.375,14.375))),IF(B3>1,15.047619,10.4))),IF(B2>5,IF(B6>35,6.473684,IF(B8>70,7.923077,IF(B7>25,7.4,IF(B2>80,10.181818,IF(B6>25,9.5,IF(B5=2,18,IF(B3>0,IF(B8>5,IF(B9=1,17.666667,13.333333),IF(B3>5,12.586207,14.375)),11.125))))))),IF(B3>0,IF(B3>50,9,IF(B6>15,IF(B2>0,2.636364,IF(B9=1,6,IF(B7>0,2.75,5.375))),6.3)),IF(B8>0,IF(B6>10,IF(B4>0,3.5,4),IF(B6>0,IF(B6>5,IF(B7>0,2.285714,1.2),4),IF(B2>1,3,1))),IF(B9=1,1.222222,IF(B6>90,0,0.875))))))"	
Tree17	"=IF(B4>0,IF(B6>25,IF(B3>5,IF(B2>1,IF(B3>10,11,8.2),6.4),IF(B2>1,IF(B2>10,5.5,3.75),2.285714)),IF(B5=1,IF(B7>25,5.4,IF(B8>70,7.75,IF(B9=1,IF(B2>0,IF(B3>0,14.666667,11),12.8125),11.25))),IF(B8>30,11.625,IF(B2>65,13.333333,IF(B3>30,17.5,IF(B3>25,13.333333,15.742857)))))),IF(B2>20,IF(B6>0,10,12.416667),IF(B3>50,IF(B6>0,6.888889,10.066667),IF(B2>5,IF(B6>25,5.5,IF(B7>50,6,7.375)),IF(B3>0,IF(B6>0,IF(B3>25,6,4.45),7.666667),IF(B9=1,IF(B6>0,IF(B6>40,2.333333,4.333333),IF(B7>90,3,1)),IF(B8>0,IF(B2>1,2.857143,IF(B7>0,IF(B2>0,1.6,2.4),1.333333)),0.769231)))))))"	
Tree18	"=IF(B4>0,IF(B6>10,IF(B2>10,IF(B3>5,IF(B4>1,17,13.333333),7),IF(B4>1,9,IF(B8>5,7.166667,3.1875))),IF(B8>70,7.1875,IF(B5=1,IF(B9=1,IF(B7>10,10.875,14.113636),IF(B3>45,6.25,IF(B2>10,11.818182,9.533333))),IF(B9=1,IF(B4>75,11,IF(B4>25,IF(B2>30,19.5,16.913043),IF(B4>1,IF(B2>60,IF(B2>65,15.6,18.4),14.826087),12.75))),14.210526)))),IF(B2>30,IF(B2>75,9.285714,IF(B6>0,13.5,16)),IF(B3>10,IF(B3>50,IF(B8>5,16,8.583333),5.862069),IF(B2>5,6.4375,IF(B3>0,IF(B3>5,3,6.4),IF(B8>0,IF(B7>0,IF(B6>0,IF(B6>5,2.666667,4),IF(B2>1,2.333333,1.3)),1),0.727273))))))"	
Tree19	"=IF(B4>1,IF(B6>25,IF(B2>1,9.833333,6),IF(B8>55,10.4,IF(B9=1,IF(B5=1,IF(B3>0,13.545455,17.5),IF(B4>25,17.371429,IF(B2>0,15.344828,18.5))),14.589744))),IF(B2>10,IF(B6>35,7.785714,IF(B8>50,8.583333,IF(B9=1,IF(B3>25,16.75,13.125),11.304348))),IF(B3>0,IF(B6>1,IF(B6>25,4.882353,IF(B2>0,7.533333,IF(B3>25,6.4,4))),IF(B2>1,13.333333,8.875)),IF(B4>0,6,IF(B7>0,IF(B2>5,5,2.315789),1.25)))))"	
Tree20	"=IF(B5=2,IF(B6>30,3.25,IF(B4>5,IF(B8>25,12.625,IF(B9=1,IF(B4>25,17.869565,16.227273),15.333333)),IF(B2>50,14.470588,11.5))),IF(B2>5,IF(B2>35,IF(B6>0,IF(B2>50,11,13.666667),IF(B9=1,16.4,IF(B7>10,IF(B2>50,15.5,13),12.181818))),IF(B3>5,IF(B6>0,IF(B2>25,13,9.833333),IF(B2>10,16.5,14.4)),IF(B2>20,8.785714,6.153846))),IF(B3>10,IF(B3>65,IF(B8>0,IF(B4>0,13.2,16),9.357143),IF(B6>5,IF(B7>10,3.25,6.666667),IF(B4>0,9.6,6))),IF(B4>1,9.285714,IF(B3>0,IF(B9=1,5.296296,3.294118),IF(B8>0,IF(B2>1,2.666667,IF(B7>40,1,IF(B9=1,3.25,IF(B7>0,2.444444,1.555556)))),1.235294))))))"	
Ensemble of 20 (scale 0-20)	=AVERAGE(B11:B30)	The cell to the left predicts site quality on a scale from 0 -100.
Ensemble of 20 (scale 0-100)	=B31*5	The cell to the left predicts site quality on a scale from 0 -20.