This spreadsheet, when given the ahnentafel number of any of my ancestors, will generate a list of all of his/her descendants who could have passed DNA to me.

Ultimately, you can obtain the same information from the family tree, of course, but this spreadsheet may be more suitable and convenient for certain research.

As is true elsewhere on this site, in instances of pedigree collapse I've used only the smaller ahnentafel number for ancestors in earlier generations. When relevant, the script will mention that a pedigree collapse occurred and will generate a separate list of descendants after the collapse.