[MBON cruises] inventory of samples collected

[7yl4r]

Spreadsheet is being created manually

[7yl4r]

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

[sebastiandig]

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