In hardness_eval_functions added option to remove Chromium (III) criteria calculations in favor of the Chromium (VI) criteria. Added stringr to packages loaded in criteria.R. Added some test code to evaluate metals in the All_Parameter_Analysis instead of in a separate effort. Added metals with criteria to dataframe used for summaries in data_summaries file. Had issue with willy.metals date as read in by read.xlsx2. Changed it to read.xlsx which read the dates right but added a weird character to the microgram symbol so just updating the renaming to include that. Not represented here in this commit since the file is not in this folder. I added hardness data to the willy metals dataset.
Built new function hardness.crit.calc which plugs generates a dataframe with the hardness based criteria calculated and included in the output. Fixed import of willy metals using read.xlsx weird handling of the micro symbol. NOTE: NEED TO FIX DDTs. Fleshed out All Parameter analysis to include metals and hardness based metals. In process of building out pretty outputs for use in excel.
Added separate set of code to include all void and cancelled results for raw data table output. Cleaned up code for adding in the benchmark comparison columns. Changed Table 20 to Table 30 references in all places. Made name for Table 30 consistent everywhere it occurs.
Missed this in the last commit. Added Exceed to column headers for this data frame.