I have now finished indexing my entire direct line (apart from one branch which goes back considerably further than I have taken it, but I didn’t do this research myself, so until I can reliably verify the info, I’ve chosen to hold it back.) I can hardly contain my excitement (I am a huge geek), so I thought I’d share with you some of the exciting things it can do, and some of the info I can quickly generate using it.
My spreadsheet can be sorted and filtered on a variety of fields. For example, I can choose to just see my maternal or paternal lines, or just see men or women. I can also sort it alphabetically by surname or forename – or just choose to see people with a certain name, and by date on birth, marriage and death.
Based on this, I can tell you the oldest birthdate in my line is 1753, and the oldest marriage is 1803. The first surname is Allott, the last surname is Woffenden. The most common forenames are John for men and Mary/Mary Ann for women. Unsurprisingly, my own surname has the most occurrences.
It’s also given me a great idea of where my blanks are, and reassured me that despite five years spent on my ancestors, there’s still an awful lot to discover, particularly on my rather bare Welsh branches! (Happy St David’s Day to them!)
I can easily find an individual’s parents, spouse and child, despite the fact that they don’t all appear consecutively. The index works on a generation by generation basis, starting with me and my brother, then my parents, then my grandparents, great grandparents and so on. So, the first few entries looks like this:
02 My brother
05 Paternal grandfather
06 Paternal grandmother
07 Maternal grandfather
08 Maternal grandmother
09 Paternal grandfather’s father
10 Paternal grandfather’s mother
11 Paternal grandmother’s father
12 Paternal grandmother’s mother
13 Maternal grandfather’s father
14 Maternal grandfather’s mother
15 Maternal grandmother’s father
16 Maternal grandmother’s mother
17 Paternal grandfather’s father’s father (...)
The great thing about this system, I figured out, is that it gives a mathematical formula for figuring out relationships (except for me!!)
The formula goes as follows:
Mother = N x 2
Father = (N x 2) – 1
Child (of mother) = N / 2
Child (of father) = (N + 1) / 2
Male spouse = N – 1
Female spouse = N + 1
I imagine there’s one for grandparents as well, but I haven’t got that far yet!
The point is that I can generate the reference number for any new ancestor without having to fill in the entire pattern easily. So when I’d done as far as my 5x GG I went back through my tree to check if I had any ‘confirmed’ ancestors any later than that. As it turned out I had three 6x GG and one 7x GG. Using the formula I was able to quickly create places for them and fill in the relevant numbers for all of their relationships, even if I didn’t have people for them yet.
This means that while I only have 260 entries in my index thus far (many of which are unknown blanks in any case), my highest numbered ancestor is 1013!
I’m very excited by my new tool. Still to do:
1. Work out how best to reference and incorporate non-direct-line family members. My gut is to reference from the direct line sibling or spouse initially, but then this creates trickiness when I start incorporating third-degree family members – their spouses, in laws and children.
2. Put together my individual’s record template
3. Index and create a record template for census households.
4. Create surname variations lists
Plenty to keep me busy then!