It's been suggested off-list that a description of how to collect the unique haplotypes data would be helpful. Here's how I did it: 1. Log on to your GAP and choose "Y-DNA Unique Haplotypes" under the Genetic Reports tab. 2. The first report to come up should be for Y-DNA12. We'll start with it. Notice that the data is NOT individually identified to participants. 3. Click the "Export Spreadsheet" button to copy the data into an Excel worksheet, an XML file. On the resulting dialogue box, choose "Open". a. The data will be in text format; apparent numbers will be text strings. This technicality matters later. 4. Make space for the calculations and avoid copying over any data by inserting two blank rows at the top or columns at the left. (You could do the calculating below the data, but it's messier.) 5. Enter the following formula into one of the blank cells you created above: "=COUNTA(A4:A999)", or if you inserted columns "=COUNTA(C2:C999)" If you have more than 998 haplotypes, change the formula accordingly. Do not include the column headings row in the calculation. The "COUNTA" version of the formula is needed because the " COUNT" version counts only numeric value. (It's a pain to convert the text strings to numbers.) 6. Record the count in a separate spreadsheet created for this purpose. Either save the XML spreadsheet for future use or close it without saving. a. You may, if you wish, sort on (up to three of) the columns to get different views of the data. 7. Repeat steps 3-6 for Y-DNA25, 37, 67. 8. Under the "Member Reports" tab, click "Project Statistics. Click "Export Spreadsheet" to open another XML file. 9. The last four items on this report are the number of results at each level (12, 25, etc.) Copy them also into the separate spreadsheet. 10. Calculate your ratios of haplotypes per test &/or tests per haplotype. Remember that the test categories are inclusive, rather than exclusive. Everyone tested at Y25, is included in the Y12; all at Y37 are included in Y25, etc. Not to worry; they were also included in the haplotype counts. If you'd like your project's data to be included in this exploration, e-mail it to me (preferably, off-list). It will be added at http://freepages.misc.rootsweb.ancestry.com/~taylorydna/diversity-dna.shtml. The exploration is in a very early phase. Five projects have contributed. -ralpht_/)