After completing an "ancestor audit" and writing about it here: Have you audited your ancestors?, I received a lot of requests for the code of My Ancestors Research Statistics. It is my modification to the original template created by (and found on his profile) Campbell Braddock. I added in some extra columns:
My Ancestors Research Statistics
| BY GENERATION | ||||||
|---|---|---|---|---|---|---|
| Gen. No. | Relation to SJ Baty | Total Possible Profiles | On Wikitree | Sourced | Biography | Genealogically Defined |
| 1 | Self | 1 | 1 | 1 | 1 | 1 |
| 2 | Parent | 2 | 2 | 2 | 2 | 2 |
| 3 | Grandparent | 4 | 4 | 4 | 4 | 2 (50%) |
| 4 | Great Grandparent | 8 | 8 | 8 | 8 | 5 (63%) |
| 5 | 2nd Great Grandparent | 16 | 16 | 16 | 16 | 7 (44%) |
| 6 | 3rd Great Grandparent | 30 (-2)* | 30 | 30 | 20 (67%) | 11 (37%) |
| 7 | 4th Great Grandparent | 60 (-4)* | 37 (62%) | 37 | 40 (67%) | 6 (10%) |
| 8 | 5th Great Grandparent | 120 (-8)* | 45 (38%) | 45 | 31 (69%) | 2 (4%) |
| 9 | 6th Great Grandparent | 240 (-16)* | 40 (16%) | 40 | 18 (45%) | 6 (15%) |
| 10 | 7th Great Grandparent | 480 (-32)* | 29 (6%) | 26 (90%) | 16 (55%) | 2 (7%) |
| 11 | 8th Great Grandparent | 960 (-64)* | 29 (3%) | 27 (93%) | 17 (67%) | 0 (0%) |
- Total number of possible ancestors reduced due to pedigree collapse.
And here is the code for it:
== My Ancestors Research Statistics ==
{|border="1" cellpadding="2"
|+ '''My Ancestors Research Statistics'''
! colspan="2" style="background: #FFFF00;" |
! colspan="5" style="background: #FFFF00;" | BY GENERATION
|-
| align="center" style="background:#FFFF00;"|'''Gen. No.'''
| align="center" style="background:#FFFF00;"|'''Relation to SJ Baty'''
| align="center" style="background:#FFFF00;"|'''Total Possible Profiles'''
| align="center" style="background:#FFFF00;"|'''On Wikitree'''
| align="center" style="background:#FFFF00;"|'''Sourced'''
| align="center" style="background:#FFFF00;"|''' Biography'''
| align="center" style="background:#FFFF00;"|'''[[Space:Genealogically Defined|Genealogically Defined]]'''
|-style="background:#E0FFFF;"
| align="center"| 1||Self||align="center"|1||align="center"|1||align="center"|1||align="center"|1||align="center"|1
|-style="background:#98FB98;"
|align="center" | 2||Parent||align="center"|2||align="center"|2||align="center"|2||align="center"|2||align="center"|2
|-style="background:#E0FFFF;"
|align="center" |3||Grandparent||align="center"|4||align="center"|4||align="center"|4||align="center"|4||align="center"|2 (50%)
|-style="background:#98FB98;"
| align="center"|4||Great Grandparent||align="center"|8||align="center"|8||align="center"|8||align="center"|8||align="center"|5 (63%)
|-style="background:#E0FFFF;"
| align="center"|5||2nd Great Grandparent||align="center"|16||align="center"|16||align="center"|16||align="center"|16||align="center"|7 (44%)
|-style="background:#98FB98;"
| align="center"|6||3rd Great Grandparent||align="center"|30 (-2)*||align="center"|30||align="center"|30||align="center"|20 (67%)||align="center"|11 (37%)
|-style="background:#E0FFFF;"
|align="center"| 7||4th Great Grandparent||align="center"|60 (-4)*||align="center"|37 (62%)||align="center"|37||align="center"|40 (67%)||align="center"|6 (10%)
|-style="background:#98FB98;"
|align="center"| 8||5th Great Grandparent||align="center"|120 (-8)*||align="center"|45 (38%)||align="center"|45||align="center"|31 (69%)||align="center"|2 (4%)
|-style="background:#E0FFFF;"
|align="center"| 9||6th Great Grandparent||align="center"|240 (-16)*||align="center"|40 (16%)||align="center"|40||align="center"|18 (45%) ||align="center"|6 (15%)
|-style="background:#98FB98;"
|align="center"| 10||7th Great Grandparent||align="center"|480 (-32)*||align="center"|29 (6%)||align="center"|26 (90%)||align="center"|16 (55%)||align="center"|2 (7%)
|-style="background:#E0FFFF;"
|align="center"| 11||8th Great Grandparent||align="center"|960 (-64)*||align="center"|29 (3%)||align="center"|27 (93%)||align="center"|17 (67%)||align="center"|0 (0%)
|}
* Total number of possible ancestors reduced due to pedigree collapse.