eDNAfuns (version 0.1.0)

write_indexing_PCR: Write Indexing PCR Spreadsheet

Description

Creates a new Google Sheet for indexing PCRs from a template, fills in the sample information, and writes it into the correct ranges of the sheet.

Usage

write_indexing_PCR(
  data,
  name,
  ss_template = "1naS-F_dj4SNmND5nJ5TKhMX3TikmRS00ILKjfg_Ucgc"
)

Value

A Google Sheet object (as returned by [googlesheets4::gs4_create()]) with the data written into the correct plate layout.

Arguments

data

A tibble or dataframe with at least the columns:

Well

Well position

Sample

Sample identifier

Column

Plate column (used to split data across sheet sections)

name

Character. Name for the new Google Sheet that will be created.

ss_template

Character. ID of the template sheet to copy from (default: `"1naS-F_dj4SNmND5nJ5TKhMX3TikmRS00ILKjfg_Ucgc"`).

Details

This function: 1. Creates a new Google Sheet with the given `name`. 2. Copies the template sheet into it. 3. Splits the input `data` by plate column. 4. Writes each split dataframe into its designated range of the sheet.

Examples

#Examples are not executed because the function requires identification in Google 
if (FALSE) {
my_data <- tibble::tibble(
 Well = c("A1","A2"),
  Sample = c("Sample1","Sample2"),
  Column = c(1,2)
)
write_indexing_PCR(my_data, "PCR_001")
}