Page 1 of 1

Collins Leeds Clustering (CLM) Labelling chart

Posted: 30 Oct 2022 13:39
by gsward
It would be useful if we had a report/query that generated the ahnentafel labelling chart as described here https://www.danaleeds.com/labeling-dnag ... -clusters/

The labelling of the four grandparents (A to D) could be omitted but note the numeric labelling of the subsequent groups.

I can create something looking like this from the Ancestors chart but cannot then save that in an editable format in, say, Excel. That suggests it needs to be configured as a query, but can that be done?

An example of a chart is shown:
DA2A3252-2222-47E6-AD73-CF8898DEDE52.png
DA2A3252-2222-47E6-AD73-CF8898DEDE52.png (216.53 KiB) Viewed 311 times

Re: Collins Leeds Clustering (CLM) Labelling chart

Posted: 30 Oct 2022 15:43
by tatewise
Yes, it can be done in a Query as you suggest by using the =AhnentafelNumber(...) function.
See FHUG Knowledge Base > Downloads > Individual Queries> Ahnentafel by Generation, which is the same function I suspect you used in the Ancestors chart.