No more stripping in the living room for me!

Recently I'd been contemplating buying the Victorian BDM indexes on CD-ROM (or however they come), because about half of my family originated from Victoria at some stage or other in the past 200 years. At over AU$200 each I wasn't in a hurry, but I was also sick of the online indexes, having to pay per search, with $5 pre-set spending limits, enter in my Visa number every time, etc, which was getting to be a pain. Then I saw a post on an Aussie genie Facebook page about the indexes being available with the Internet Archive and I just had to investigate. They are available as Full Text, HTTPS, and Torrent files. I chose to download them as Torrents, as I already use uTorrent for other things, so I'm familiar with it. This programme sucks them off the net (technical terminology which demonstrates my knowledge of how the internet works) in a csv format, and saves it all as a txt file. I'm OK with all that - it's just Excel jargon.

So I opened Excel, and (using a video off YouTube to refresh my memory of how to do the task) imported the txt files into Excel, and voila!, I now have my very own set of Vic BDM's!! Unfortunately, during the process of doing the transfer Excel did pop up with an error message, to which I said "Yeah, whatever, just get on with it" and accepted it, which has resulted in there being remarkably similar numbers of births, marriages, and deaths imported into my file. I know that some must have been left out because poor Excel couldn't cope with the whole lot, but I have still ended up with 1,048,576 births (1836 - 1920), 1,048,776 marriages (1836 - 1942), and 1,048,572 deaths (1836 - 1985), which *should* include almost all of my folk, if not all of them.

Screen shot of some of my results

So then the fun began! I sorted them all alphabetically by surname (can't help it, I work in a library) and I've been colouring my surnames in blue, and turning red the ones that I know for sure are mine. I could highlight them, copy and paste subsets into another Excel workbook so I can sort them further, and even have a list of registration numbers to use when I want to order a copy of the image from the Registry. Then I can tick them off once I have the document in my family file.

Prior to this discovery I've been taking screen shots of the Registry's results page, printing them out, and cutting them into little strips, to try and recreate some family groups within certain surnames. My husband remarks that I've been stripping again (he wishes!).

My 7yo geneapprentice, Georgia, helping match births to the relevant marriage of the parents

This is a perfectly fine method if you don't mind spending a lot of time on your knees the floor, and live without the fan operating to circulate the hot air around. In my mind, Excel is now the way to go. Thanks internet!