Data analysis template designed to aid lab technicians quickly summarize daily wastewater RTqPCR results. Uses Google Apps Script (Javascript) to automate routine tasks.
Macros pair samples from 96-well extraction plates with their corresponding 384-well RTqPCR results, generate pivot tables to average Cqs across multiple SARS-CoV-2 genes and replicates, then paste this data into each project's specific reporting format.