Eddie Thomas’ Records of Research Spreadsheet, for recording records searched. This is what Eddie says about it.
My preferred method is to use Excel. I have created a Record of Research spreadsheet with the following headings:
- Surname (at birth)
- Christian Name(s)
- FHID (Family Historian Identity)
- Object of Search (e.g. locate entry in 1871 Census records are national collections of population statistics. They usually record details about members of a household on a particular date, and are typically collected every ten years.)
- Records Searched (e.g. transcripts of 1871 census)
- Location of Records (e.g. Society of Genealogists)
- Successful (Y/N)
- Remarks (e.g. possible matches, neighbours who may be related, etc)
- When an Event happened, or an Attrribute was true. of Search
I have two Excel workbooks for this purpose – maternal and paternal. Each workbook contains separate sheets for each letter of the alphabet. Thus entries for Jones are made under J, Smith under S, etc. If, for example, I am searching for John Smith in the 1871 Census, and I have to reference several different Source: “where information was found”. This could be anything from an archive in a county records office, a book, or even a relative’s recorded recollection. Citing your Sources helps to show how you reached a particular conclusion about an Individual. in different locations, then I enter each search as a separate entry.
I have filters on the columns, which makes searching almost effortless.
Also, after I make fresh entries, I sort by Surname, Christian Name(s), and FHID (using Data > Sort).
Produced by admin (03/06/07)Link: Spreadsheet: Records of Research