Convicts and Excel Spreadsheets

-

 

The Commissariat Store, Brisbane Saturday 25th September 2021

I took the photo above last weekend when I attended the RHSQ Book Fair to buy books for the QFHS Library.  I didn't buy too many but it was my first visit to The Commissariat and I would like to go back for another proper visit. You can see the new Casino being built in the background there.

How was your day? Did you get any family history research done?  My goals for the day were to keep on top of my social media commitments for QFHS, reduce the number of emails in my inbox and do some housework!  It was pretty hot today - I think it got to about 37 degrees Celsius.  I buckled and put the air-conditioning on at home.  Good sheet and towel drying weather though for wash day Monday :)  But it's hot for what is essentially the second month of Spring.  Doesn't bode well for Summer does it?

I also managed to squeeze in watching a SAG seminar I've had in my inbox for a while - 15 Ways to Use Excel in Family History.  Tomorrow night, I will co-host the #ANZAncestryTime Twitter chat about Convicts.  

And so I have decided to focus on what I learned from the Excel seminar and my Convicts for this blog post, in preparation for tomorrow night and to do a timeline for the Cathcart/Grieve families following on from the research I did yesterday, so that I can check assumptions and see holes etc.

The presenter of the Excel seminar was Danielle Lautrec and she made me feel at one and the same time very disorganised but empowered to do something about it by the end of the session ;) Wow!  I am super-impressed by all the things Danielle has thought of using Excel for with regard to family history.

From keeping your references in an Excel spreadsheet (brilliant idea) to using it as a planning tool for purchasing (e.g. certificates, books) according to your priorities, I am in awe of her analytical ability.  I've already augmented my spreadsheet for Acquisitions for QFHS by adding another worksheet to enter in Proposed Acquisitions.  And I am thinking smarter about our Social Media spreadsheet in terms of adding hotlinks to the events on Eventbrite or our website.

I use Excel in family history mostly for timelines so was pleased to obtain other suggestions.  Of course you could use it to illustrate aspects of your family history e.g. country of origin.  The most useful tip I got from the tips and tricks at the end of the session was hearing about Flash Fill.  I hadn't heard of that before.

Convicts

I thought I had more than two convicts but they are the only ones I can find just now, so here's my spreadsheet for them.  I can always add to it if I find there are more.

 

Okay - so that was an interesting exercise.  So in order to share that I exported it as a PDF then I clicked on Select, then a bit like using the Snip tool, I selected the area I wanted to copy, clicked on snapshot which works a bit like cut and paste.  I then pasted it onto this page and its treated like an image so I could make it bigger or smaller. 

Timeline

Okay here is the timeline for the Grieve and Cathcart families.



Not perfect.  There's probably a better way of doing it but it will do for the minute.  It's quite tricky doing so many people in a timeline but it's been worthwhile.  I've discovered that William and Ida and John Alfred shared a house in Murgon and then in Towooomba by looking at the electoral rolls.  I've yet to put Ida's children into the timeline.  I could add William's wife too.

You will see that I've also added a permanent page to record my research goals which I will add to as time goes by.  That really should be a spreadsheet too!

Hope you had a great day researching family history.  Do you use Excel for family history?

Comments

Post a Comment

Popular posts from this blog

52 Ancestors in 52 Weeks - Family Lore

-
Image
Image by hurk from Pixabay Amy Johnson Crow challenges us to write about our Family History again in 2024 using her 52 Ancestors in 52 Weeks challenge.  The theme for Week 1 is "Family Lore." Many of us have heard stories from our grandparents about incredible feats our ancestors did or a famous person we're related to. What's a tale that has been passed down in your family? Did it end up being true or did it turn out to just be a good story? You can join the challenge too her e. The most famous/shocking story handed down in our family was that my father's great-grandfather was meant to have shot himself.  Lo and behold it wasn't the entire truth (he lived to tell the tale) but there was certainly a large kernel of truth in the story handed down by my grandmother.  You can read the story of Edward Conner's life here . Of course there's always more to be done isn't there?  I ordered his death certificate years ago but it was lost in transit so
Read more

52 Ancestors in 52 weeks - Week 3 - Favourite Photo

-
Image
      The theme for Week 3 is "Favorite Photo." Amy Johnson Crow has devised these prompts and you can participate too by signing up here. Tell the story of a favorite photo: Who is in it, when and where it was taken, and why it was taken. (That last part is often left out!)   Barbara Conner hanging up washing in Edinburgh     This is a photo of my mother hanging up the washing when we were living in Edinburgh in the 60s. I think my father took it to record what ordinary life was like at the time and to send back to the folks at home in Australia.  I'm sure my mother was not pleased but I am so grateful because you can see so much in this photo.  They had a kettle, something like a Sunbeam electric frypan.  I think I can spot a toaster and a radio up on the top shelf.  You can see that the glass came in milk bottles in those days and that the twin tub washing machine was in the kitchen.  There are canisters for things like tea and coffee.   When MyHeritage brought out the
Read more

52 Ancestors in 52 Weeks - Origins

-
Image
Image by Ekaterine Kantaria from Pixabay The theme for Week 2 is "Origins." Genealogists often get the question, "Where is your family from?" With this week's theme, you could explore an immigrant ancestor, but you could also think about the origin of other aspects of your family. Who was the first person in your family to settle in a particular town? If you have a long line of people with the same occupation, talent, etc, who was the first person you know who did it? If you want to join the challenge, sign up here. Here is my latest ethnicity estimate from Ancestry which, if you have taken a test with Ancesry, you can find under the DNA tab, sub-heading Origins. This has changed over time and there are reasons for that but I don't claim to be a DNA expert so you will have to look elsewhere for an answer.  Suffice it to say that my Irish percentage has increased significantly.  And in my youth I did have a lot of people tell me that I looked very Iri
Read more