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

Swimming lessons

Arthur Holyland was born in 1877 in Wortley, a village to the north of Sheffield, in Yorkshire. Like his father and grandfather before him, Arthur trained as a blacksmith. When he was a child, Arthur's family moved from the rural setting of Wortley and into the heavily industrialised centre of Sheffield, which at the time was one of the world's leading centres for the manufacturing of steel items. In August 1899, Arthur enlisted into the Royal Marines, giving his age as 2 years younger than his baptism proves. He served on a variety of vessels before being invalided out of the Marines in 1908. My eye was caught by a small box at the bottom of the Marines enlistment form . "Able to swim?" – Yes, Arthur could swim – he was tested on this in December 1899, in Deal, Kent, four months after joining the Royal Marines. How did a blacksmith from a heavily industrialised town in a landlocked county learn to swim, I asked myself. It transpires that in 1892, a tidal swi...
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

Thomas Hollylande, fighting for the family home.

For generations, “home” to the Leicestershire Holylands was the village of Desford. The surviving Desford parish registers start from 1559, and the first mention of any of the Holyland family was in 1564 with the burial of Thomas Holyland. However, the Holylands had their home in Desford prior to this. An 1827 copy of the “Calendar to Pleadings and Depositions” during the reigns of the Tudor monarchs is available on the internet via Google Books (1), and contains the following: Date: Reign: 1+2 Phil + Mar   (ie 1553-4) Plaintiff: Thomas Hollylande, Son of Agnes Hollylande, Widow, deceased, a Tenant by the Custom of the Manor of Desford   Defendants: Robert Dewsburye otherwise called Strynger, Reve of the Manor of Desford, and Nicholas Crosbie who was admitted Tenant of the Premises after an alledged Forfeiture. Premises and matters in dispute: Disputed Title to a Messuage, Cottage, Land, and Pasture claimed by the Plaintiff as devised to him by his Mother’s Will, to...
Post a Comment
Read more