[MBON cruises] inventory of samples collected about data-docs HOT 2 OPEN

Sheet used to identify

• what samples collected on what date
• what samples are processed

Ian Smith sent "master" Excel file with variables upon which this sheet is based.

number of rows is expected to be OoM 10k-100k

from data-docs.

I'm looking into a more dynamic way of visualizing this information.

I've started examining the package pivottabler in R.
Pros:

• more dynamic
• conditional formatting
• allow different save options (xlsx, HTML, png, etc)
• can implement a shiny app to display data
• basically can recreate the above visuals with more function

Cons:

• may take time to understand
• dependent on the data used, so errors will be easily seen
• need have packages installed

Examples:
Image 1: conditional formatting

Image 2: implement into excel

from data-docs.