Skip to contents

Creates conditionally formatted table as a pptx file from summary HAB data

Source: R/hab_functions.R
hab_tablR.Rd

hab_tablR takes a file path to summary HAB data and a date and produces "present" and "prior sample" table of phytoplankton counts per site.

Usage

hab_tablR(hab_tables, focus_date, mngt_triggers)

Arguments

hab_tables

a character file path to the location of the `HAB_tables/` directory.

focus_date

a character representation of the date chosen for the "present" sampling week in the format "yyyymmdd".

mngt_triggers

a character filepath and name of the `mngt_response_triggers_YYYY.csv` data file that indicates group names, species names and trigger thresholds for management action. See package example dataset `mngt_response_triggers` for example of format required.

Details

This function can only be run on data created by running the (hab_groupR) function. It will read in all the summary data then based on the provided date, produce a conditionally formatted table for that date. Values are coloured according to "investigate" or "notification" count level for river sites for specific species. The prior sample's data is reported so comparisons can be made.

Data is exported as pptx file to the `HAB_tables/` directory. It can be dragged and dropped into a PowerPoint template with some minor resizing.

Author

Bart Huntley, bart.huntley@dbca.wa.gov.au

For more details see https://dbca-wa.github.io/rivRmon/index.html the rivRmon website

Examples

if (FALSE) { # \dontrun{
hab_tablR(summary = "C:/path/to/HAB_tables", date = "20190910",
mngt_triggers = "./mngt_response_triggers_2020.csv")
} # }