Hello All Here is some information about a small utility that you run in Excel to sort data extracted from the PRO Census site into family groups. I have tried it and it works. Unfortunately it only came to my notice after I had done the same thing by hand with 2500 Goff's. I quote .............. "For the benefit of those list members who have not seen the free items below, they are very useful. 1901 Census Extractor @ http://www.leedsindexers.co.uk/Internet_Tools.htm#1901Extractor Census Extractor provides a 'pro forma' Microsoft Excel set of sheets complete with macros. What you do is simply select and copy your 1901 search results and paste them directly into the Census Extractor data sheet provided. One of the macros will enable you to then extract the unique Page ID number and the Person ID number for each of the listed search responses. A second macro' will estimate and list the piece and folio numbers. In practice I have found the folio numbers to be accurate to within '+' or '-' one folio. By sorting the Page and Person ID no's it is possible to workout family units. 1901 Census GuessTimator @ http://www.leedsindexers.co.uk/Internet_Tools.htm#GuessTimator This is actually a tiny programme. What you get is a little box in which you enter the 'unique' Page ID number that is revealed in the lower bar of the 1901 search results window which is easily accessed by allowing your cursor to 'hang' over the 'image icons'. Census GuessTimator will then produce a Piece and Folio number as above." Regards Peter Goff Kingsclere, Hampshire, UK www.kingsclere.org.uk All outgoing e-mails are scanned for viruses before despatch. There are no attachments to this message
Hi All (especially Peter Goff and Colin Harris) The 1901 Census extraction tips are absolutely wizard. They have saved me hours of work and pounds of dosh. Thanks to you both. The tips are highly recommended by me. -- Best regards, Peter McNulty peter@sparshott.org.uk www.sparshott.org.uk Researching: SPARSHOTT families world-wide WICKHAM in north Kent. EDGARD - any time, any place, anywhere. GREENWELL - north east England. LONGHURST (Isaac) - Coldharbour, SRY ----- Original Message ----- From: "Peter Goff" <peter.goff@btinternet.com> To: <ENG-HAMPSHIRE-KINGSCLERE-L@rootsweb.com> Sent: Tuesday, September 10, 2002 7:55 PM Subject: 1901 census family group extractor > Hello All > > Here is some information about a small utility that you run in Excel to sort data extracted from the PRO Census site into family groups. I have tried it and it works. > > Unfortunately it only came to my notice after I had done the same thing by hand with 2500 Goff's. > > I quote .............. > "For the benefit of those list members who have not seen the free > items below, they are very useful. > > 1901 Census Extractor @ > http://www.leedsindexers.co.uk/Internet_Tools.htm#1901Extractor > > Census Extractor provides a 'pro forma' Microsoft Excel set of sheets > complete with macros. > > What you do is simply select and copy your 1901 search results and > paste them directly into the Census Extractor data sheet provided. > > One of the macros will enable you to then extract the unique Page ID > number and the Person ID number for each of the listed search > responses. > > A second macro' will estimate and list the piece and folio numbers. > In practice I have found the folio numbers to be accurate to within '+' > or '-' one folio. > > By sorting the Page and Person ID no's it is possible to workout > family units. > > 1901 Census GuessTimator @ > http://www.leedsindexers.co.uk/Internet_Tools.htm#GuessTimator > > This is actually a tiny programme. > > What you get is a little box in which you enter the 'unique' Page ID > number that is revealed in the lower bar of the 1901 search results > window which is easily accessed by allowing your cursor to 'hang' > over the 'image icons'. > > Census GuessTimator will then produce a Piece and Folio number > as above." > > Regards > > Peter Goff > Kingsclere, Hampshire, UK > www.kingsclere.org.uk > > All outgoing e-mails are scanned for viruses before despatch. > There are no attachments to this message > > > > > ============================== > To join Ancestry.com and access our 1.2 billion online genealogy records, go to: > http://www.ancestry.com/rd/redir.asp?targetid=571&sourceid=1237 >