Another aspect of my trip prep is for obituaries in Medina County, Ohio. Mark's Reusch family came from there, so there is alot to do there. This library has an obituary index on line which made my list making much easier! Whenever I come across someone on the line who has no obituary in my data base, I add them to the to do list or the spreadsheet. If you decide for the to-do list you will have to go back and put all the entries from the to do list on the spread sheet. If you go directly to the spreadsheet you will be going back there alot, adding persons of interest & resorting from time to time.
My speadsheet has six columns & when printed, it is printed in landscape mode. The six columns I use are:
- Name - I use surname first, the given
- Date - for this library I used the online obituary index and got the dates that the obits appeared.
- Page number
- Female ID number. This makes it easy to identify if I have any questions when I am putting them in my data base.
- Y/N - did I get the obituary or not
- Comments - things like "no newspaper" or "newspaper on strike" things like that.
If you have mulitiple newspapers in the area you could add another column for newspaper name. Its really comes down to what YOU need to make it work for you. I don't have the mulitple newspapers to deal with this on this trip.
After I get them all entered on the spread sheet I sort by date, with the earliest date appearing at the top. I always print TWO (2) copies - one for me and one in case the films are not open for personal "fetching", the person behind the counter can get them for me much easier if they are in some of order. If Mark is getting films its easier on him as well.
By calling ahead and confirming costs, hours & policies, then having your obituary list in order, ensures you success whether you are pulling 6 or 160 obits.
Please remember that if you have someone pulling films for you & they are on staff, a THANK YOU is always in order. Some libraries also take donations - donating to the library is a great way to say THANKS! They need to hear it and I don't know of any library that can't use some financial help as well! If its my husband Mark - I buy him dinner! ; )
An obituary spreadsheet - Its a VERY GOOD THING!