I’ve had this idea for a while now, but wasn’t sure how I should present it. The idea was to take a snapshot of my research status, broken out into each of the major surnames of my family tree. I limited the snapshot to great great grandparents, to keep the linked spreadsheet from ballooning in size. The result looks quite a bit different than I was expecting (which is why we do these things in the first place). Each column represents one surname. Each surname column is divided into three sections (let’s call them drums). Blue drums indicate the number of generations from myself to the first appearance of that surname. Red drums indicate the number of direct ancestors with a given surname that for whom I have research that supports their place in the tree. Green drums indicate the number of direct ancestors with a given surname for whom I have no sources (other than others’ assurances).
I hope to revisit this chart every year or so and update it with new findings. That being said, don’t expect the height of the red drums to change any time soon. Hopefully, I won’t lose the spreadsheet between now and next time the chart needs updating. :(