Package index • TAMMsupport

All functions

address_parser(): Parse excel address including sheet
as_numeric_safe(): Safely convert character numerics into numeric
chunk_formater_percenter(): Format chunks of dataframe to present as %s, round digits
chunk_formater_rounder(): Format chunks of dataframe to round digits
chunk_read_2A_CUandM(): Read chunk for table 2A_CUandM
chunk_read_2A_CUandM_N(): Read in individual chunks for sheet 2A_Cu&M_N
chunk_read_2A_CUnmrkd(): Reads chunk of 2A_CUnmrkd sheet
chunk_read_2A_Cmrkd(): Read in chunks of the 2A_Cmrkd sheet
chunk_read_finisher(): Finishes a chunk after initial reading
clean_limiting_stock(): Generates clean read of TAMM limiting stock sheet
compare_chinook_inputs(): Compare differences in input sheets of two TAMM files
filter_tamm_wa() filter_tamm_wa_chin() filter_tamm_wa_coho(): Filters a dataframe to Washington State fisheries.
find_color_matches(): Identify all cells in Excel sheet or sheets with matching cell colors
fishery_renamer(): relabel inconsistent fishery names in FRAM/TAMM
format_key_tamm_sheets_chin(): Modify list of Chinook TAMM spreadsheet dataframes to facilitate comparison.
format_key_tamm_sheets_coho(): Modify list of Coho TAMM spreadsheet dataframes to facilitate comparison.
format_overview(): Format TAMM overview for easy printing
formula_formater(): Add spaces to excel formulas for readability
fun_percenter(): Format vector of mixed characters to present numbers as percents
fun_rounder(): Format vector of mixed characters to round numbers to specified digits
kable_overview(): Print table of overview using kable and kableExtra
make_tracer_edges(): Calculate and format edges from traced objects
make_tracer_network() experimental: Visualize excel formula tracing
make_tracer_nodes(): List cells and contents from traced objects
process_2ac_aeqs() experimental: Read and combine aeq sections form tables 2a-2c
process_2ac_ers() experimental: function to process + combine the er sections from tables 2a-2c, used below
quick_er_format(): Quick helper function to format vectors that contain text and ERs
range_splitter(): Translate excel-style cell range to vector of cell addresses.
read_2aCUandM(): Read and process all parts of sheet 2A CU and M
read_2aCUandM_N(): Read and combine all chunks for sheet 2A CU and M_N
read_2aCUnmrkd(): read all info for 2aCUnmrkd and process it.
read_2aCmrkd(): Reads sheet of 2A_Cmrkd
read_2a_sheets(): Read and combine all 2a sheets from a TAMM file
read_jdf(): Read in AEQ and ER information from the JDF sheet
read_key_tamm_sheets_chin(): Read Chinook TAMM files to extract the key sheets
read_key_tamm_sheets_coho(): Read Chinook TAMM files to extract the key sheets
read_limiting_stock(): Read TAMM limiting stock complete tab
read_management_chin(): Extract and format management criterion from Chinook TAMM
read_overview(): Read overview sheet from TAMM and return key stock
read_overview_complete(): Read overview sheet from TAMM and return all stock
read_tnt_allocation_chin()
reformat_management(): Convenience function for formatting TAMM management criterion chunks
safe_convert_numeric(): Convert string of number to numeric
tamm_compare(): Generate summary comparison of any number of TAMM files
tamm_compare3(): Generate summary comparison of 3 TAMM files
tamm_diff(): Compare key sheets of TAMM files
tamm_format_overview() tamm_format_limiting() tamm_format_input() tamm_format_wacoast(): Apply final formatting to diff'd TAMM sheets
tamm_report(): Generate report of figures from TAMM file
trace_formula() experimental: Trace the calculations of a cell recursively through all referenced cells
validate_data_frame(): Confirm object is dataframe