Ancestry_Pie_Chart_Creator

					Some Random notations and thoughts about this sheet in no particular order.

The idea of this spreadsheet was to allow someone to enter the ancestry of their Great-Great-Grandparents and h
complete descendant pie chart be calculated automatically and be ready for printing.
This is a work in progress: I've been able to get the pie chart sizes standardized and it prints the pie chart sheet re
nicely on 11x17 paper. The table of names and percentages should fit on 8.5X11 paper. Also, I haven't figured out
Excel to auto-hide 0.00% percentages in chart labels without awkward formatting issues. You'da thunk it woulda d
on its own, no?
If you get a macro warning when opening the sheet you can ignore it - I have no macros in this sheet and I'm not s
thinks there is. Will try to fix in a later release.
This was created using Excel 2007 - I cannot guess how it will work in older versions and I do not plan to do make
compatible.

If you would like to make changes to formulae and cell formats or otherwise fiddle with things under the hood, yo
the original file has the GGGP Sheet locked, but there is no password. I have only locked it to protect the innocent
overwriting things by mistake. (To unlock a sheet in Excel 2007: click Review then UnProtect Sheet.) I've included
Commons copyright below.
This is a project I started for fun after a spark of an idea - I offer no warranty nor support. However, I welcome ide
suggestions for improvements and may implement them if I have time and/or think they will help.

How To Use The Sheet
You can enter the Family Name, Names, Ancestry percentages and Countries in the aqua blue cells. (I've included
names and percentages as a sample - you can just type over them.

Column P has the current list of Country names - change them in that column and they will show up in the table h
This table is in a sort of butterfly format - the target person in the center (green background line) is calculated usin
Grandparents and GG Grandparents moving up and down from them. So, you ONLY need to enter the GGGP Perc
bottom of the table. The rest of the percentages will be calculated for you.
This sheet currently assumes you know the ancestry percentages of Great Great Grandparents. If you do not, you
percentages of the Great-Grandparent or grandparents and the descendents will still calculate correctly. However
unlock the sheet first. (See note above on how to unlock.)
All other cells and the Charts sheet should calculate automatically.

Enjoy! - John Tierney
http://currach.johnjtierney.com

                        Attribution-NonCommercial-ShareAlike
                        CC BY-NC-SA
particular order.

r Great-Great-Grandparents and have a
nting.
 and it prints the pie chart sheet relatively
  paper. Also, I haven't figured out how to get
ng issues. You'da thunk it woulda done that


 macros in this sheet and I'm not sure why it

ons and I do not plan to do make it backward


dle with things under the hood, you will find
y locked it to protect the innocent from
n UnProtect Sheet.) I've included a Creative


 support. However, I welcome ideas and
hink they will help.



the aqua blue cells. (I've included a few



nd they will show up in the table headings.
background line) is calculated using the Parents,
NLY need to enter the GGGP Percentages at the top and

  Grandparents. If you do not, you can enter the
 l still calculate correctly. However, you will need to
             Ancestry Percentages for:                      Enter Family Name or Title Here
             Enter Great-Great-Grandparent Stats and the rest will be calculated!
             Cells with a Blue Background can be edited. Change countries listed in column R at Right.
             See the "Info - Help" Sheet for some tips.
                                                                                                                                 Country
                                                                                                                                                   Nova                                                                                                 Check
Ahnentafel       Side         Relation         Surname        Given Name        Croatia     Czech        England   Germany   Ireland   Italy                 Russia    Scotland   Poland          Countries      Percentage Lookups                                     Full Name
                                                                                                                                                   Scotia                                                                                              Total %
                                                                                                                                                                                            Croatia           100.00%   Full
    16         Paternal    GGGF                                                                                               100.0%                                                        Czech              50.00%   Half                            100.00%
    17         Paternal    GGGM                                                                                               100.0%                                                        England            25.00%   Quarter                         100.00%
    18         Paternal    GGGF                                                                                               100.0%                                                        Germany            12.50%   8th                             100.00%
    19         Paternal    GGGM                                                                                               100.0%                                                        Ireland             6.25%   16th                            100.00%
    20         Paternal    GGGF                                                               100.0%                                                                                        Italy               3.13%   32nd                            100.00%
    21         Paternal    GGGM                                                               100.0%                                                                                        Nova Scotia         1.56%   64th                            100.00%
    22         Paternal    GGGF                                                               100.0%                                                                                        Russia                                                      100.00%
    23         Paternal    GGGM                                                               100.0%                                                                                        Scotland                                                    100.00%
                                                                                                                                                                                            Poland
    8          Paternal    GGF                                                                                                100.0%                                                                                                                    100.00%
    9          Paternal    GGM                                                                                                100.0%                                                                                                                    100.00%
    10         Paternal    GGF                                                                100.0%                                                                                                                                                    100.00%
    11         Paternal    GGM                                                                100.0%                                                                                                                                                    100.00%

    4          Paternal    Grandfather                                                                                        100.0%                                                                                                                    100.00%
    5          Paternal    Grandmother                                                        100.0%                                                                                                                                                    100.00%

    2          Paternal    Father           Name            Father's               0.0%        50.0%        0.0%      0.0%     50.0%        0.0%      0.0%      0.0%       0.0%      0.0%                               Father's Name                   100.00% Father's Name

                                                            Enter Target
    1        Target        Person           Surname                               6.25%      37.50%                  6.25%   34.38%        6.25%              6.25%      3.13%
                                                            Person First &                                                                                                                                                                               100.00% Enter Target Person First & Surname
                                                                                                                                                                                                                        Enter Target Person First & Surname

    3         Maternal     Mother           Name            Mother's              12.5%        25.0%        0.0%     12.5%     18.8%       12.5%      0.0%     12.5%       6.3%      0.0%                               Mother's Name                   100.00% Mother's Name

    6         Maternal     Grandfather                                                         50.0%                 25.0%     25.0%                                                                                                                    100.00%
    7         Maternal     Grandmother                                            25.0%                                        12.5%       25.0%               25.0%      12.5%                                                                         100.00%

    12        Maternal     GGF                                                                100.0%                                                                                                                                                    100.00%
    13        Maternal     GGM                                                                                       50.0%     50.0%                                                                                                                    100.00%
    14        Maternal     GGF                                                    50.0%                                                    50.0%                                                                                                        100.00%
    15        Maternal     GGM                                                                                                 25.0%                           50.0%      25.0%                                                                         100.00%

    24        Maternal     GGGF                                                               100.0%                                                                                                                                                    100.00%
    25        Maternal     GGGM                                                               100.0%                                                                                                                                                    100.00%
    26        Maternal     GGGF                                                                                               100.0%                                                                                                                    100.00%
    27        Maternal     GGGM                                                                                     100.0%                                                                                                                              100.00%
    28        Maternal     GGGF                                                  100.0%                                                                                                                                                                 100.00%
    29        Maternal     GGGM                                                                                                        100.0%                                                                                                           100.00%
    30        Maternal     GGGF                                                                                                                              100.0%                                                                                     100.00%
    31        Maternal     GGGM                                                                                                50.0%                                      50.0%                                                                         100.00%
                Ancestry Percentages for: Enter Family Name or Title Here




                                                 3.13%
                                   6.25%                            6.25%

Father's Name                   6.25%                                                    Mother's Name




                                                               37.50%

                                        34.38%




                                                            6.25%
                      Croatia    Czech            England           Germany    Ireland

                      Italy      Nova Scotia      Russia            Scotland   Poland


                       Enter Target Person First & Surname
          Ancestry Percentages for: Enter Family Name or Title Here
  0.0%                                                                    6.3%
                                                                                            12.5%
                                                                         12.5%

50.0%           50.0%                                                  12.5%                        25.0%


                                                                           18.8%
                                                                                            12.5%
                                                                                   Mother's Name

    Father's Name                            3.13%     0.00%               Mother's Name
                                     6.25%                     6.25%
                             6.25%




                                                          37.50%

                                  34.38%



                                                               6.25%

             Croatia      Czech              England       Germany     Ireland
             Italy        Nova Scotia        Russia        Scotland    Poland

                     Enter Target Person First & Surname




                                                                                                            Enter Target Person First & Surname

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:2/23/2012
language:
pages:5