Tissue Sample Plate Mapper

Generation of a sample list and rack labels for field research

This is a Google Sheets add-on that arranges a collection of samples into an 8 x 12 (96 well) array and creates labeled, hard-copy plate maps for sample collection into a standard, 96-well format rack.

The input is a short list of samples consisting of group names (e.g., plot numbers) and the number of samples (e.g., plants) per group. The output assigns to each sample an ordered ID that incorporates the group name, an address in an 8 x 12 (96-well) array, a unique ID for the 96-well array, and enters the information into three output sheets: (1) The Sample List is an expanded sheet that lists all of the samples individually and their corresponding plate address. (2 and 3) The There are 2 worksheets with rack labels (plate maps), one for notes and one formatted for printing to fit over a 2.1 ml deep-well 96 hole plate. Once the plate map is fitted to the deep-well plate, sample tubes are pushed through their labeled positions in the paper map as they are collected, which minimizes tracking errors.

Add-on Instructions

Enter the row/plot/group ID in column 1 (or whatever column it actually is) labeled plot name/# and the number of samples of each in column 2 (labeled plant#).
You may choose to array the samples from each plot across (x12) the plate or down (x8) the plate. Choosing to shade the first entry of each plot makes the beginning of a new set stand out in the rack output sheets.

Post-install tip

  • Go to Menu bar –> Add-ons –> Tissue Sample Plate Mapper –> Generate labels.
  • Allow Permission for the addon to “View and manage your spreadsheets in Google Drive.”
  • Fill out the form on the sidebar and click Start.