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

The vaccine-refusing Holylands!

  With all the talk about how different countries approach COVID vaccination, it seems timely to remember that vaccination against smallpox was compulsory in England in the past Between 1853 – 1947, parents or guardians were obliged to have their children vaccinated against smallpox within the first few months of life. Failure to comply could lead to a fine or even imprisonment. The Holylands were amongst those who were sometimes slow to have their children vaccinated, and the Leicester Mercury lists at least 3 instances: 1877 – Thomas Holyland was fined 10 shillings (it is not clear which Thomas this was, there being several possible candidates!) 1884 – Alfred Holyland of Wharf St, Leicester,   was fined 10 shillings with the threat (or option?) of 7 days imprisonment in lieu of the fine 1885 – Joseph Henry Holyland was summonsed and given one month in which to get his children vaccinated. Joseph and Alfred were brothers. Alfred’s first child was born in 1883, t...
Post a Comment
Read more

When the Internet has it wrong! The real father of Mary.

  This lovely young woman was Mary Carmichael Smyth, the wife of James Carmichael Smyth, physician extraordinary to King George 111. Mary married James, who was several years her senior, in Gretna Green in 1775; the couple had 10 children and Mary apparently died in 1803 or 1806. This portrait was painted around 1788 by George Romney and is the possession of the National Gallery of Scotland . Multiple internet sources state that Mary's father was Thomas Holyland of Bromley, and her mother Mary Elton (eg, here: http://www.thepeerage.com/p20538.htm#i205375 ). However I am certain that these internet sources (many of which have probably been copied from each other) are wrong, and that Mary’s father was actually Christopher Holyland, a vintner of Cheapside in London, who died in 1769. Here’s my evidence. Firstly, I can find no baptism for a Mary Holyland (or variant on the name) to a father named Thomas in the south east of England in the mid 1700s. There was a baptism of Mary ...
Post a Comment
Read more

New beginnings in America -- Charles John Holyland and family.

  The Holyland tribe has never tended to travel very far and there have not been many Holyland emigres from the UK. This does make life easier for the researcher who is not obliged to search through large numbers of records from across the globe! However, one person to buck this trend was Charles John Holyland   (1806 – 1865) who had several new beginnings – not only marriage and parenthood, but emigration, change of nationality and change of occupation.   Charles was the first child born to John Holyland and Mary (nee Taylor) and was baptised at the church of St Mary Somerset, London at the age of 13 months. His was an educated and fairly well-off family, his ancestors having made their money as carmen in London after moving there from Leicestershire in the mid 1700s, and in 1827 Charles inherited part of his grandfather’s £5000 estate. By 1828, Charles had moved from the family home at Broken Wharf, near to St Paul's in London, and was based in Lisle Street, nea...
Post a Comment
Read more