| Title: | Tools for working with NSW public service flexsheets in R |
|---|---|
| Description: | Tools for working with NSW public service flexsheets in R. |
| Authors: | Samuel Gardiner [aut, cre] |
| Maintainer: | Samuel Gardiner <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.0.0.9000 |
| Built: | 2026-09-24 08:08:46 UTC |
| Source: | https://github.com/gardiners/flexsheetr |
Clean a raw flex sheet tibble. See Details.
clean_flex_sheet(flex_data_raw)clean_flex_sheet(flex_data_raw)
flex_data_raw |
A raw tibble of flex sheet data, as produced by
|
Apply cleaning operations:
Convert arrival_time and departure_time from Excel-epoch datetimes
(e.g. "1899-12-31 01:00") to datetimes for the relevant date.
Convert lunch_duration and adjustment_duration from Excel-epoch
datetimes to lubridate::Duration.
Compute worked_duration, a lubridate::Duration.
A tibble.
Read a single flex sheet
read_flex_sheet(workbook_path, sheet, process = TRUE)read_flex_sheet(workbook_path, sheet, process = TRUE)
workbook_path |
Path to the Excel workbook holding the sheet |
sheet |
Number or name of the sheet within the workbook |
process |
Should cleaning operations be applied? If |
A tibble.
Read all of the flex sheets in a workbook
read_flex_workbook(workbook_path, process = TRUE)read_flex_workbook(workbook_path, process = TRUE)
workbook_path |
Path(s) to the Excel workbook(s) holding the sheet. If
provided with a vector of paths, |
process |
Should cleaning operations be applied? If |
A tibble.
Read flex sheet start and end dates
read_sheet_period(workbook_path, sheet)read_sheet_period(workbook_path, sheet)
workbook_path |
Path to the Excel workbook holding the sheet |
sheet |
Number or name of the sheet within the workbook |
A list with elements start and end.