institute of biotechnology >> brc >> genomics facility >> genomic facility projects >> LIMS >> user guide
 

Genomics Facility Projects LIMSUser Guide

Editing Plate Templates in Excel

On a Windows PC

  1. Download template text file and save
  2. Open Excel
  3. File>> Open. make sure you select “All Files” in the dropdown menu next to the File Name field
  4. Choose the saved template>> Open
  5. This will prompt the Text Import Wizard to open in Excel, If the wizard opens continue to step 6. 
    1. ​If the text import wizard doesn't open, select the entire column containing text.
    2. Select "Data" from the Excel tabs at the top of the screen
    3. Select "Text to Columns" and continue with step 6.
  6. Under Original data type>> Delimited [Characters such as commas or tabs separate each field]
  7. Start Import at row 1 (Default)>> Next
  8. Under “Delimiters” select TAB>> Next
  9. Column data should be set to “general” by default>> Finish
  10. Fill out empty required fields
  11. Save edited document as a tab delimited (.txt) file

When you are ready to submit, go back into your Project's Plate page and upload the edited template. If you have further questions, message an admin using the conversations link in your user menu.