I have completed Claims Extraction Templates for the US Census years 1850 through 1940. This includes the 1890 Veterans Schedules. These templates were developed using LibreOffice Calc but have been saved as .xlsx files (meaning that they can be open in Excel or any spreadsheet that can open an Excel file). I developed these files to provide the complete sentences that can be copied and pasted directly into Evidentia’s “Catalogue Claims” section, thus avoiding my having to write a new sentence with each entry. The process of developing these Claims Templates required me to explore each year’s census form to determine what Claims could be extracted. That was a helpful discipline.
If you choose to use these templates, you are free to alter the way any of the Claims are stated and/or to add (or remove) Claims as you deem appropriate. For each Census year, I have developed a separate spreadsheet with two sheets — first, the template which contains the formulas but no data; second, a sheet contain the data for one of my ancestors. I provided the second to make sure the formulas were working. If you choose to use the Templates, you can see how the Claims will look. The second sheet can be deleted.
To use the Claims Extraction Templates for extracting the claims for your ancestors, open the template for the selected year. In order to copy the template, click on the cell that is above the “1″ and to the left of the “A” (see picture at right). Copy that and open a new sheet. Click on that same cell in the new sheet and paste. The fully formatted Claims Extract Templates will now be entered on the second sheet. You can rename the sheet to reflect your source / ancestor by left clicking on “Sheet 2″ and selecting “Rename Sheet.” Open the respective Census record for the appropriate year and enter the general data in Line 2 and the information about each of your ancestors on the respective lines (usually B4 through B13). The Claims will be automatically completed for all the ancestors entered. (Note: if you have more than 10 ancestors I would recommend that you simply open a new Sheet and copy the Template to that sheet. You can then enter the information about the rest of your ancestor’s household in the second sheet. The extracted Claims statements for the various individuals will not be affected by their being on separate sheets. ( I originally thought about adding lines to the page and copying the formulas but this is a more complicated task and can easily result in either too much time being taken or wrong formulas being entered.)
A disclaimer: I am not a power spreadsheet user. I have been learning as I have been developing this Claims Extraction Templates. I have used three types of formulas: 1) direct statements of claims; 2) statements of claims conditioned by IF formulas — that is, IF “A” is true then one claim is stated; IF “A” is not true then another claim (or no claim) is made; and 3) claims that are drawn from two or more possible statements, utilizing the VLOOKUP formula. (These latter statements are the ones reflected in the boxes below the data entry cells.) There are probably other ways to accomplish the same results. These were the best ways that I could find.
Note: If you downloaded any of the previous Claims Extraction Templates that I have posted, I have probably made changes. The templates listed above are New. I have left the previous versions available, but would encourage you to use the newer versions.
Happy Claim Extracting!