Spreadsheet: 744592d1629330018-need-help-adding-more-conditions-to-if-and-statement-transect-canopy-if-statement
Sheet: Sheet1

 |  |  |  |  |  |  | Plants over 2m |  |  |  | Plants below 2m |  | Field Comments
[NAME] | [NAME] | geo_strata | plot_name | total_individuals | deadwood | fp_plants | Plants over 10m | Plants between 5m and 10m | Plants between 2.5m and 5m | Plants between 2 and 2.5m | height_less_2m_fp_count | height_less_2m_nfp_count | is transect representative? | Field comments | estimated crown cover of stems over 2m | estimated 'mature' crown cover of FP stems below 2m | Plot flagged as outlier? | PHASE 1 Is there possible pre-existing forest cover? | PHASE 2 Is there possible forest potential? | PHASE 3 Is there future forest potential | Assigned strata based on estimated crown cover | Comments | Final Strata
 |  | A |  |  |  |  |  |  |  |  | 0 |  |  |  | 219.96 | 0.35 |  |  |  |  |  | Plot flagged as outlier for plants over 10m. Data is consistent with what can be seen in pdf report. Many large eucalypts on transect. Final Strata Forest | Forest
 |  | A |  |  |  |  |  |  |  |  | 1 |  |  |  | 49.19 | 44.74 |  |  |  |  |  | Plot flagged as outlier for plants between 2 and 2.5, and 2.5 and 5m. Data is consistent with what can be seen in pdf report. Many medium height casuarinas on transect. Final strata forest. | Forest
 |  | B |  |  |  |  |  |  |  |  | 3 |  |  |  | 37.59 | 36.15 |  |  |  |  |  |  | Forest
 |  | B |  |  |  |  |  |  |  |  | 0 |  |  |  | 25.43 | 29.07 |  |  |  |  |  | Plot flagged as borderline for estimated crown cover of stems over 2m. Estimated crown is 25.43, which is on the lower end. From the plot data, most of the canopy >2m appears to be in the second half of the transect, but from the pdf report, the density of the surrounding forest appears to be consistent across the immediate surrounds of the transect. Absence of large trees in surrounds suggests low liklihood of skewing of canopy values. Final strata set as forest. | Forest
 |  | C |  |  |  |  |  |  |  |  | 1 |  |  |  | 9.63 | 48.96 |  |  |  |  |  | Plot flagged as NO for pre-existing forest cover. Estimated Crown cover of stems over 2m is 9.63. Plot data shows there are 6 plants between 2.5 and 5m, suggesting low chance of canopy skewing from tall trees. The majority of the canopy height trees in the transect occur in interval 3. PDF report shows floodplain dominated by low [NAME] shrubs. Unlikely to be existing forest, and surrounds appear to be consistent with transect. Final strata set as CEA | CEA
 |  | C |  |  |  |  |  |  |  |  | 3 |  |  |  | 65.8 | 2.85 |  |  |  |  |  |  | Forest
 |  | D |  |  |  |  |  |  |  |  | 0 |  |  |  | 106 | 26.22 |  |  |  |  |  | Plot flagged as outlier for plants between 5 and 10m. 41 plants are recorded for that height range. PDF report confirms transect is within tall stand of mature casuarina. Final strata set as Forest | Forest
 |  | D |  |  |  |  |  |  |  |  | 1 |  |  |  | 63.68 | 4.28 |  |  |  |  |  |  | Forest
 |  | E |  |  |  |  |  |  |  |  | 3 |  |  |  | 51.94 | 50.65 |  |  |  |  |  |  | Forest
 |  | E |  |  |  |  |  |  |  |  | 0 |  |  |  | 46.8 | 37.26 |  |  |  |  |  | Plot flagged as outlier for plants between 2 and 2.5, and 2.5 and 5m. Data is consistent with what can be seen in pdf report. Many medium height casuarinas on transect. Final strata forest. | Forest