Using the Y-Utility Spreadsheets

Posted on the website are spreadsheets, generated using the Y-Utility developed by Dean McGee (available at http://www.mymcgee.com/tools/yutility111.html) as modified by Mark Yost to accept 111 markers (available at http://tinyurl.com/McGee111ModBurgarella2010Rates), that include information for the R1a-Y2619 Ashkenazi Levites who have tested to at least 37 markers and whose results I have located.

The first page of the first spreadsheet, named “Deviations from Mode,” provides marker values, color-coded to show deviations from the R1a1a Ashkenazi Levite mode and number of steps from the mode (but not to indicate the direction of deviation from the mode).

The second through fourth pages of the first spreadsheet, named “Genetic Distance @ 111,” “Genetic Distance at 67,” and “Genetic Distance at 37,” are large tables that allow you to determine, at 111 markers, 67 markers, and 37 markers, respectively, the number of genetic steps by which each R1a-Y2619 Ashkenazi Levite on the list differs from (1) the R1a-Y2619 Ashkenazi Levite mode and (2) each other R1a-Y2619 Ashkenazi Levite on the list. (The number of genetic steps on this spreadsheet may differ from that reported by Family Tree DNA because the Y-Utility software apparently does not incorporate Family Tree DNA’s new adjustment to count RecLOH mutations as a single step’s difference.)

The website posts another version of the second through fourth pages of the spreadsheet, formatted to be cut and paste into the sortable spreadsheet to make it easier to sort the spreadsheet to a man's closest STR matches to facilitate analysis.