Page 1 of 1

Census Diagram

Posted: 11 Mar 2004 15:06
by kevinbuckley70
Is there any plan to develop a diagram type that displays the relationships betweem individuals/families & how they are moving around through time - based on event address-field data (from BMD / census etc. events)?

At the moment I'm doing this manually in Excel & I find it quite useful but it's tedious to maintain!

Regards, Kevin

ID:333

Census Diagram

Posted: 11 Mar 2004 15:26
by Jane
You can display relationships between anyone on the chart and the root person.

As seen in the Names, Dates and How related scheme

The important line is
=Relationship([''],%INDI%,TEXT,1)


You could add the address field from Census information using

%INDI.CENS[1].DATE% %INDI.CENS[1].ADDR%
%INDI.CENS[2].DATE% %INDI.CENS[2].ADDR%
%INDI.CENS[3].DATE% %INDI.CENS[3].ADDR%


You could also use these fields in a query to produce data for your spread sheet.

If you explain in more detail what you are trying to do I will see what else I can suggest.

Census Diagram

Posted: 11 Mar 2004 15:37
by kevinbuckley70
Jane

Is there a way I can email an attachment to you? I'll send you a copy of one of the Excel's that I was using for this as an example.

Regards, Kevin

Census Diagram

Posted: 11 Mar 2004 15:40
by Jane
Just send it direct to

jane at taubman.org.uk

replace the at with @ etc.

Please don't send anything too large as I only have a modem connection at home.

Census Diagram

Posted: 11 Mar 2004 15:44
by kevinbuckley70
Done. - Thanks, Kevin

Census Diagram

Posted: 11 Mar 2004 16:07
by Jane
Here is a picture of what Kevin is doing, thoughts anyone?

Image

Census Diagram

Posted: 21 Nov 2004 12:33
by philwarnorpkent
I like this idea but is it a feasible proposition?