Skip to main content

In praise of spreadsheets!



event 1st name Surname date place mother father spouse abode notes
bur Thomas Holyland 28 Jan 1564 Desford




marr Jane or Jone Hollyland 20 jan 1570 Desford

Henry Dammaske
maybe 1571?
bur Elizabeth Hollyland 26 aug 1571 Desford




marr Thomas Hollyland 8 Aug 1573 Desford

Agnis Shepston

bap Henry Hollyland 9 March 1574/5 Desford






No, come back --I'll try not to make this too boring!

In late 2019,before I joined the Guild of One Name Studies (GOONS), I did an introductory online course about setting up such a study. The course tutor urged us to use spreadsheets for the collection and correlation of information and I have to say that I felt dubious.

I'm not particularly techie-minded. I can use the basic functions of a microsoft office spreadsheet but was hardly in thrall to them.

But over the long January evenings, when I was starting my ONS, I decided to give it a try. And I have been totally won over! Building my family groups and trees, and correlating dates and facts is so much easier via spreadsheets!

I started by downloading separate lists of birth, marriage and death registrations from FreeBMD, which turned out to be surprisingly easy. Other spreadsheets followed, for similar events before 1837, court appearances, Holyland wills - it was necessary to input these manually, which was tedious, but ultimately very useful. I've designed the headings of each spreadsheet to reflect the information that I find most useful.

With these spreadsheets I can spot patterns at a glance. I can organise the columns into any order I choose, then back again to the original (eg, alphabetical order has been invaluable for grouping children by mother's maiden names). A quick hit of the search button solves many a query. Cross correlation between, for example, the marriage spreadsheet and the wills spreadsheet backs up findings quickly and easily.

I could wax lyrical for much longer about my spreadsheets but I did promise not to bore you all, so I will simply say - if you haven't already tried it, then give it a go! You might, like me, find that you quite like it!



Comments

Post a Comment

Popular posts from this blog

A tale of three weddings, pt 3 – Hannah’s story.

                                                                                  The church at Kirk Ireton, Derbyshire Hannah Slater was born in the Derbyshire village of Kirk Ireton in 1842. In 1864 she married William Holyland in Ashbourne and their daughter was born the following day but lived only a few weeks. William subsequently joined the army and, many years later, remarried, but there was no record of Hannah’s death. Neither did any of the subsequent censuses include a Hannah Holyland of her age and birthplace. What had happened to her? I realised that my spreadsheets contained another possible clue - a mystery Holyland baptism. On September 15 1867 Joseph Holyland was baptised in Kirk Ireton, with his mother’s name given as Hannah and no father named. Joseph (“an infant”) was buried just 5 days later. Surely this had to be connected? The plot thickened with the realisation that there is neithe r birth nor death listed on freeBMD for Joseph Holyland at this time and pl
2 comments
Read more

Hannah Holyland and the Duke of Buccleuch

How the name of a lass from a Leicestershire village became linked to Scottish nobility! In 1886, a civil action (“ Robinson vs The Duke of Buccleuch “) was brought in the courts by Benjamin Robinson, a labourer of Glen Parva, Leicestershire, against the 6 th Duke of Buccleuch. Twelve years earlier, the Duke had bought property at Knightlow, Warwickshire; but Benjamin asserted that he was the rightful owner of the property according to the will made by a greatuncle, George Robinson, in 1821. The inheritance trail was complicated and Benjamin’s claim to the estate was disputed. William Henry Walter Montagu Douglas Scott, 6th Duke of Buccleuch   and 8th Duke of Queensberry – the relevant duke!! Benjamin’s grandfather was said to be George Robinson’s brother John, who had married Hannah Holyland. John and Hannah Robinson had had one son, also John, who was Benjamin’s father. The case was widely reported in newspapers across England.   There was some confusion over the bride’s
Post a Comment
Read more

Spreading out

Early records show Holyland (+variants) families in Leicestershire, London and Cheshire, but in this post I’ll deal solely with the geographical spread of the Leicestershire families. For over a hundred years after the start of the Desford church registers, there seems to have been little movement. Some of the Holyland men married in other parishes, even other counties, but brought their wives back to the village and raised their families there.  The first significant settlement outside Desford seems to have been in the late 1600s, with the appearance of a family just across the border in the north of Warwickshire. However, there was also movement within Leicestershire around this time.  Two wills from the 1720s/30s show the existence of a Holyland family with adult children, living in Botcheston. Botcheston is a small village barely 2 miles from Desford, and it seems inconceivable that these Holylands would not be part of the Desford clan; however, it has not (yet) been p
2 comments
Read more