Leeds Indexers

  M a i n
About Us
 Contact Us
 Internet Tools
 Links
 Message Board
 PUBLICATIONS
 Surname Interests
 News
 Search Site
 Site Map

  I n f o r m a t i o n
 Articles
 Census
 Churches & Chapels
 Maps
Parish Registers
Poll Books
Projects

Census GuessTimator
LEEDS BURIALS
Site Map
Links
 

1901 Census Extractor

Microsoft Excel Version

 

HOME > INTERNET TOOLS > 1901 Census GuessTimator (Excel Version)

 

1901 Census Extractor (Download)

This program is a Microsoft Excel spreadsheet which contains a macro to extract the Page number from the page image and Person ID from the hyperlinked name. Once this information has been obtained the data can be sorted on the Page column and Person ID column to establish families. This can be very useful in identifying family groups. It can also save on unecessary expense when purchasing the images online from the GRO. I know from personal experience having located two family members at the bottom of a page, when I purchased the next page - I found that the other family members where not there. Extracting the information in this manner is also useful for One-Name studies.

Requirements

PC Running Windows 9x, NT, XP. Microsoft Excel (Version 2000 or above) and a Browser (i.e. Microsoft IE).

Installing

the file is a spreadsheet - so no installation is required. Open the spreadsheet and ensure that Macros are enabled.

Running

Basics - The basic approach is pasting data from the search results screen of the PRO Census Site onto the 'DATA' table of the spreadsheet. Once all the data has been pasted press the extract button on the 'MAIN' sheet. The program should then extract the relevant information.

Important Note: Some Browsers do not allow for the pasting of the images into the spreadsheet - so page numbers will not be extracted. You will still be able to sort on the Person ID to establish families.

Walk Through

  • Open the spreadsheet (ensure macros are enabled) and click on the 'DATA' sheet to make it visible.
  • Enter your search details and press the search button.
  • Once you have the data displayed that you wish to copy place your mouse over the bottom right hand box (the occupation field of the last person on the list) hold the left mouse button down and drag it to the top left hand corner of the data including the page icons on the left hand side - but not including the title. Copy the data by pressing [CTRL] & C or selecting copy from the edit menu.(See Fig.1)
  • Select the Spreadsheet and select the 1st free cell on the 'DATA' sheet.(See Fig.2)
  • Paste the data into the spreadsheet by pressing [CTRL] & V or selecting Paste from the edit menu. (See Fig.3) (You can also use 'Paste Special' from the Edit Menu - it must be pasted as HTML.
  • If you are going to paste any more data onto the 'DATA' Sheet - remember to select the 1st cell of the next blank row.
  • Continue copying and pasting the data onto the 'DATA' Sheet as required.
  • When you have all the data you require. On the spreadsheet select the 'MAIN' sheet and press the Extract Button. (See Fig.4)
  • The data on the 'DATA' sheet will be updated to include Page and Person ID number.
  • The next process is to sort the data. Click on an entry in the Page Number and Select Sort from the Menu (See Fig.5)
  • (Version 2.1 and above) now includes the GuessTimator Button. After performing the above steps - hitting this button will guessTimate the Piece and Folio Numbers.

Thats all there is to it. Hope you manage to extract the data you want and find those missing families. Good Luck.

Download 1901 Census Extractor v2_1c.zip 144 KB (147,456 bytes)

This program is supplied as freeware please feel free to distribute it. There are no warranties and we cannot be held responsible for loss of data, malfunction etc. It is supplied on an as is basis. It may not function correctly with some Internet Browsers and does not function correctly with Earlier versions ofExcel.

Updates

Version 2_c (04-Sep-2002)

  • Fixed problem with folio generation - formula corrected.
  • End Numbers set on DATA to high values - correcting overflow

 


[BACK] [HOME] [TOP]

 

 

 

Site Search


Advanced Search

 

 

 

 

 

 

 

 

ABOUT US | ARTICLES | CENSUS | CENSUS GUESSTIMATOR | CHURCHES & CHAPELS | CONTACT US | GUESTBOOK | HOME | INTERNET TOOLS | LEEDS BURIALS | LINKS | MAPS | MESSAGE BOARD | NEWS | PARISH RECORDS | POLL BOOKS | PROJECTS | PUBLICATIONS | SITE MAP | SITE SEARCH | SURNAMES INTERESTS


ESSAGE BOARD

Why not leave a message to fellow researchers on the Message Board or leave your SURNAME intere

MESSAGE BOARD

Why not leave a message to fellow researchers on the Message Board.

 

 
ENQUIRIES:
David Clarke:
Mike Hansell:
Steve Miller:

 

 

     
Copyright © 2000-2003 Leeds Indexers Copyright / Disclaimer