In a previous post (Claims Extraction Templates) I described the process by which I began to develop templates in LibreOffice Calc through which Claims from the 1930 US Census could be extracted and then entered into Evidentia. I had used the 1930 Census as the example and included links to the resulting spreadsheet template for 1930 US Census, as well as a text file (generated in Notepad) that contained the individual formulas that I had used. At the time I had developed spreadsheets for all the censuses from 1850 to 1940, but was not ready to share them until I have revised them. (I was learning as I progressed from one census year to another.)
I have completed my revision of the 1910 1920 Claims Templates using LibreOffice Calc. (They should also open in Excel). Each time I revise one of the spreadsheets I learn more. By the time I’m done I may really begin to understand what I am doing.
The link for the 1910 Claims Templates is https://dl.dropboxusercontent.com/u/6904113/Claims%20Template%20-%201910%20US%20Census.xlsx
The link for the 1910 formulas used (as a Notepad text file) is https://dl.dropboxusercontent.com/u/6904113/Census%20Claim%20Template%20Formulas%20(1910%20US%20Census).txt
the 1920 Claims Templates can be downloaded from https://dl.dropboxusercontent.com/u/6904113/Claims%20Template%20-%201920%20US%20Census.xlsx
The formulas for the 1920 spreadsheet can be downloaded from https://dl.dropboxusercontent.com/u/6904113/Census%20Claim%20Template%20Formulas%20(1920%20US%20Census).txt