This refreshable Microsoft Excel (Power Query) spreadsheet is an alternative way to access Vegetation Condition Benchmark data that is maintained in the BioNet Vegetation Classification application. The Excel spreadsheet contains an embedded Power Query which extracts data directly from the BioNet databases via the BioNet VegetationClassification_PCTBenchmarks Web Service.
This Power Query was updated in 2022 to support distribution of the most recent benchmark data, which contains benchmarks for preceding wet and dry conditions as well as average rainfall conditions. For guidance on the use of wet and dry benchmarks see Guidance for assessors and decision-makers in applying modified benchmarks to assessments of vegetation integrity (PDF 1.3MB).
For guidance on building Power Queries in Excel to extract BioNet data, please refer to the Power Query Quick Guide on the BioNet Web Services web page.
