set default metadata parameters so that the process can run without manual intervention

[japhir]

Right now, the process requires manual intervention, which needs to be fixed so that in the future it can run unsupervised.

The current process:

for the scans: run target motu_scn_meta_update | pacman_scn_meta_update

• copy new rows to excel file
• copy the metadata parameter columns down to the last row
• be sure to search/replace the =TRUE() with TRUE and =FALSE() with FALSE (in LibreOffice) this is not an issue on the Windows VM where we can use Microsoft Excel

for the files: run target motu_meta_update | pacman_meta_update | pacman_caf_meta_update

• copy new rows to OneDrive excel file
• copy metadata columns down to newest rows
• download local copy into dat/ folder this is no longer needed now that we sync with OneDrive directly

to upload results:

• run motu_export_csv | pacman_export_csv | pacman_caf_export_csv
• run motu_out | pacman_out | pacman_caf_out
• copy out/motu_all_data_RAW.csv to OneDrive files automatically get uploaded to OneDrive now
• out/motu_cycle_level_summaries.rds to OneDrive

The desired process would have default metadata parameters that are filled in if the rows don't exist in metadata_parameters so that it can continue running!

[japhir]

David Beverborg suggested to just read in the excel file, add the new rows, overwrite the excel file with new rows.

Not sure if writexl can do this, I found https://github.com/ropensci/writexl/issues/29 about this.