Assembly QA Part 2 Track Steps

This page is currently a draft in progress. For now, use Releasing an assembly instead.

Navigation Menu Home Page Assembly QA Part 1: DEV Steps Assembly QA Part 2: Track Steps Assembly QA Part 3: BETA Steps Assembly QA Part 4: RR Steps Assembly QA Part 5: Post Release Steps

Setup: Populate spreadsheet steps for dev

Add the following formula to your spreadsheet to automatically populate dev steps based on each step listed as a wiki section.

Options:

You can add this formula to the same spreadsheet as your dev steps, in the next empty row after all of your dev steps. It will then populate all of the "Track Steps."

If you prefer, you can create a new tab in your spreadsheet and paste in this formula after your row 1 field names:

A2 (or the next available row in col A following your dev steps)

=HYPERLINK("http://genomewiki.ucsc.edu/genecats/index.php/Assembly_QA_Part_1:_DEV_Steps#"&SUBSTITUTE(B2," ", "_"),"link")

IMPORTANT: Drag the formula for "A" down the spreadsheet to populate the other rows.

B2 (or the next available row in col B following your dev steps)

=IMPORTXML("http://genomewiki.ucsc.edu/genecats/index.php/Assembly_QA_Part_1_DEV_Steps#", "/html/body/div/div/div/div/div/h4/span/span")

This formula will populate all the rows below it with the wiki section titles. You do no need to drag this formula down.

Tracks Step 1

During this assembly release process, you will be generating a lot of output, and you'll need a place to put everything. The use of the "hive" directory is encouraged as the best location because of ample space.

Tracks Step 2

🔵 Done with TRACK steps? Go to Assembly QA Part 3: BETA Steps