Utility ~ Spreadsheet: Census and BMD Analysis V2


This zip file contains a FH Query (Census and BMD analysis.fhq) and two Excel workbooks (.xlsm version for Excel 2007, and .xls version for earlier versions of Excel).

The only changes from V1 are those necessary to make it work with earlier versions of Excel (Excel 2000 and Excel 2003 definitely, and possibly Excel 97 as well but not tested)

The Query runs against a Named List "Individuals for census and lifedate analysis" and produces a dataset for use in the spreadsheet. The results of the Query must be saved as a tab-delimited text file. You will be prompted to specify this file when you ask to "process the data" in the spreadsheet.

The worksheet checks Census and BMD data for missing and possible erroneous entries, and uses colour-coding to highlight these.

All comments gratefully received. Cole Valley Girl

Produced by hsw (17/03/09)


Click on a thumbnail for the full size image.

Instructions worksheet tab: Instructions Tab

Census worksheet tab: Census Tab

BMDs worksheet tab: BMDs Tab

Error Log worksheet tab (not shown) lists any Errors or Warnings detected within the spreadsheet.

Import worksheet tab (not shown) lists the imported tab-delimited text file created from the query.

Installation Instructions

Click on the link below to download and save Census_and_BMD_Analysis_V2.zip, then unzip to extract the three files.

Double click the FHQ file to import to Family Historian, and double click XLSM/XLS file to open Excel spreadsheet.

Ensure that Macros are enabled.