import_sdr_id: Imports IDs associated with a SDR run

In daflealab/genlabfunc: Useful Packages for the Hall Lab

Description

import_sdr_id imports an excel file linking the location on an SDR to a ID. SDR ID must be a number. Unused SDRs must be removed from the excel file (No blank SDRs). Blank or Empty cells must be named Explicitly.

Usage

import_sdr_id(file_name, sheet_number = 1)

Arguments

file_name	A string. The excel file to import. Must contain the DATE in cell B2, BLOCK in B3 and RUN in B4. First 5 rows will be removed after import.
sheet_number	An integer. The sheet to import from the excel workbook. Indexed by number. Default is the first sheet.

Value

A tibble with Date, Run, SDR, Cell Details, and Animal IDs. Will convert b or B or Blank or blank to BLANK. Returns an error if duplicate SDR IDs are detected or unnames cells incuded.

Examples

first_run <- import_sdr_ids("./Metab positions 1_17-18NOV.xlsx")

daflealab/genlabfunc documentation built on May 27, 2019, 7:25 a.m.