GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 
Time Line Generator


https://support.genopro.com/Topic44289.aspx
Print Topic | Close Window

By JUNO - Monday, August 19, 2024
Can i generate from the information on  a tree, those   people alive at the same time - in the form of a visual table, I dont want a list.

I have made one manually but its tedious and the information is already on the trees.

can anyone advise please
By genome - Tuesday, August 20, 2024
My reply to you in a previous thread, https://support.genopro.com/Topic43586.aspx, provided a solution to this. I appreciate that not everyone is happy manipulating spreadsheet formula and data.

That solution gave a vertical timeline, so a horizontal line for a given year shows who was alive in that year.  

Using the same 'Comma Separated Values' (.csv) data generated by the Report Skin Template attached to that post it is possible using Google Sheets (free!) to create a horizontal timeline  of the data. Selecting a column, i.e. year, . e.g. 1976 below, will highlight those alive in that particular year.

https://support.genopro.com/Uploads/Images/a7a1af17-dd67-4fbe-a56c-21cb.jpg


a PDF print of that spreadsheet is attached. 

Unfortunately I do not have the skill/time to automate the production of such a spreadsheet.  Here is a link to this Google Sheet that you can examine etc. to see how it works. https://docs.google.com/spreadsheets/d/1B3JXtz_K99FJ9K-S21Nd0j9QBpUjdlfryFuMdieeRQg/edit?usp=sharing

A brief summary of what I did:

1. Hide columns C & D as not required. 
2. Change column heading B & E
3. Add Columns F & G to have year of birth, year of death (or current year if not dead) using formula ABS(LEFT(B2,4)) & ABS(LEFT(E2,4)) respectively
4. set F1 to formula MIN(F2:F) and G1 to formula MAX(G2:G)
5. add columns from earliest year (e.g. cell F1) to maximum year (i.e. cell G1) and set contents to appropriate year.(hint: set the 1st 2 values H1 & I1, then select I1 and drag from bottom right corner across to last column)
6. rotate text in row 1 and set font size in this row to 9
7. Set formula in cell H3 to IF(AND(abs(H$1)>=abs($F3),abs(H$1)<=abs($G3)),"▬","") and then drag to all cells to bottom right
8. set text colour in these cells to blue.
9. sort the data on column B (birth)