{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Ancestor Table","Pedigree Chart","Surname Table","Research Count","Metrics","DNA Matches"],"not_rendered":{"defined_names":4,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Ancestor Table","index":0,"n_rows":139,"n_cols":18,"rows_kept":139}
[{"$f":"\"ANCESTOR TABLE for \"&C7&\" \"&B7","v":"ANCESTOR TABLE for  "}]
[]
[null,"Enter information on this page for your direct ancestors. The parent/child numbers can be found in the far right columns."]
[null,"The names, years, etc below will automatically show information in the other tabs. GOLD cells are calculations; don't type in those cells."]
[]
["#","Surname (primary)","Given Name(s)","Preferred Name","Other Surname Spellings","Birth Year","Birth Place","Death Year","Death Place","Est. Age","Death Cause","Marriage Year","Marriage Place","Est. Age","Spouse #","Child #","Father #","Mother #"]
[1,{"$nulls":8},{"$f":"IF(OR(ISBLANK(F7),ISBLANK(H7)),\"\",H7-F7)","v":""},{"$nulls":4},"--","--",{"$f":"A7*2","v":2},{"$f":"Q7+1","v":3}]
["PARENTS",null,{"$f":"COUNTA(A9:A10)","v":2},{"$f":"IF(COUNTA(C9:C10)=C8,\"\",C8-COUNTBLANK(C9:C10))","v":0},{"$f":"IF(OR(ISBLANK(D8),LEN(D8)=0),\"All found\",(C8-D8)&\" remaining\")","v":"2 remaining"}]
[{"$f":"A7+1","v":2},{"$nulls":8},{"$f":"IF(OR(ISBLANK(F9),ISBLANK(H9)),\"\",H9-F9)","v":""},{"$nulls":3},{"$f":"IF(OR(ISBLANK(F9),LEN(F9)=0,ISBLANK(L9),LEN(L9)=0),\"\",L9-F9)","v":""},{"$f":"A9+1","v":3},{"$f":"TRUNC(A9/2,0)","v":1},{"$f":"A9*2","v":4},{"$f":"Q9+1","v":5}]
[{"$f":"A9+1","v":3},{"$nulls":8},{"$f":"IF(OR(ISBLANK(F10),ISBLANK(H10)),\"\",H10-F10)","v":""},null,{"$f":"IF(ISBLANK(L9),\"\",L9)","v":""},null,"",{"$f":"A10-1","v":2},{"$f":"TRUNC(A10/2,0)","v":1},{"$f":"A10*2","v":6},{"$f":"Q10+1","v":7}]
["GRAND PARENTS",null,{"$f":"COUNTA(A12:A15)","v":4},{"$f":"IF(COUNTA(C12:C15)=C11,\"\",C11-COUNTBLANK(C12:C15))","v":0},{"$f":"IF(OR(ISBLANK(D11),LEN(D11)=0),\"All found\",(C11-D11)&\" remaining\")","v":"4 remaining"}]
[{"$f":"A10+1","v":4},{"$nulls":8},{"$f":"IF(OR(ISBLANK(F12),ISBLANK(H12)),\"\",H12-F12)","v":""},{"$nulls":3},{"$f":"IF(OR(ISBLANK(F12),LEN(F12)=0,ISBLANK(L12),LEN(L12)=0),\"\",L12-F12)","v":""},{"$f":"A12+1","v":5},{"$f":"TRUNC(A12/2,0)","v":2},{"$f":"A12*2","v":8},{"$f":"Q12+1","v":9}]
[5,{"$nulls":8},{"$f":"IF(OR(ISBLANK(F13),ISBLANK(H13)),\"\",H13-F13)","v":""},null,{"$f":"IF(ISBLANK(L12),\"\",L12)","v":""},null,"",{"$f":"A13-1","v":4},{"$f":"TRUNC(A13/2,0)","v":2},{"$f":"A13*2","v":10},{"$f":"Q13+1","v":11}]
[6,{"$nulls":8},{"$f":"IF(OR(ISBLANK(F14),ISBLANK(H14)),\"\",H14-F14)","v":""},{"$nulls":3},"",{"$f":"A14+1","v":7},{"$f":"TRUNC(A14/2,0)","v":3},{"$f":"A14*2","v":12},{"$f":"Q14+1","v":13}]
[7,{"$nulls":8},{"$f":"IF(OR(ISBLANK(F15),ISBLANK(H15)),\"\",H15-F15)","v":""},null,{"$f":"IF(ISBLANK(L14),\"\",L14)","v":""},null,"",{"$f":"A15-1","v":6},{"$f":"TRUNC(A15/2,0)","v":3},{"$f":"A15*2","v":14},{"$f":"Q15+1","v":15}]
["1X GREAT GRAND PARENTS",null,{"$f":"COUNTA(A17:A24)","v":8},{"$f":"IF(COUNTA(C17:C24)=C16,\"\",C16-COUNTBLANK(C17:C24))","v":0},{"$f":"IF(OR(ISBLANK(D16),LEN(D16)=0),\"All found\",(C16-D16)&\" remaining\")","v":"8 remaining"}]
[{"$f":"A15+1","v":8},{"$nulls":8},{"$f":"IF(OR(ISBLANK(F17),ISBLANK(H17)),\"\",H17-F17)","v":""},{"$nulls":3},{"$f":"IF(OR(ISBLANK(F17),LEN(F17)=0,ISBLANK(L17),LEN(L17)=0),\"\",L17-F17)","v":""},{"$f":"A17+1","v":9},{"$f":"TRUNC(A17/2,0)","v":4},{"$f":"A17*2","v":16},{"$f":"Q17+1","v":17}]
[9,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L17),\"\",L17)","v":""},null,"",{"$f":"A18-1","v":8},4,18,19]
[10,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A19+1","v":11},5,20,21]
[11,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L19),\"\",L19)","v":""},null,"",{"$f":"A20-1","v":10},5,22,23]
[12,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A21+1","v":13},6,24,25]
[13,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L21),\"\",L21)","v":""},null,"",{"$f":"A22-1","v":12},6,26,27]
[14,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A23+1","v":15},7,28,29]
[15,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L23),\"\",L23)","v":""},null,"",{"$f":"A24-1","v":14},7,30,31]
["2X GREAT GRAND PARENTS",null,{"$f":"COUNTA(A26:A41)","v":16},{"$f":"IF(COUNTA(C26:C41)=C25,\"\",C25-COUNTBLANK(C26:C41))","v":0},{"$f":"IF(OR(ISBLANK(D25),LEN(D25)=0),\"All found\",(C25-D25)&\" remaining\")","v":"16 remaining"}]
[{"$f":"A24+1","v":16},{"$nulls":8},"",{"$nulls":3},{"$f":"IF(OR(ISBLANK(F26),LEN(F26)=0,ISBLANK(L26),LEN(L26)=0),\"\",L26-F26)","v":""},{"$f":"A26+1","v":17},{"$f":"TRUNC(A26/2,0)","v":8},{"$f":"A26*2","v":32},{"$f":"Q26+1","v":33}]
[17,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L26),\"\",L26)","v":""},null,"",{"$f":"A27-1","v":16},8,34,35]
[18,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A28+1","v":19},9,36,37]
[19,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L28),\"\",L28)","v":""},null,"",{"$f":"A29-1","v":18},9,38,39]
[20,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A30+1","v":21},10,40,41]
[21,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L30),\"\",L30)","v":""},null,"",{"$f":"A31-1","v":20},10,42,43]
[22,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A32+1","v":23},11,44,45]
[23,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L32),\"\",L32)","v":""},null,"",{"$f":"A33-1","v":22},11,46,47]
[24,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A34+1","v":25},12,48,49]
[25,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L34),\"\",L34)","v":""},null,"",{"$f":"A35-1","v":24},12,50,51]
[26,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A36+1","v":27},13,52,53]
[27,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L36),\"\",L36)","v":""},null,"",{"$f":"A37-1","v":26},13,54,55]
[28,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A38+1","v":29},14,56,57]
[29,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L38),\"\",L38)","v":""},null,"",{"$f":"A39-1","v":28},14,58,59]
[30,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A40+1","v":31},15,60,61]
[31,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L40),\"\",L40)","v":""},null,{"$f":"IF(OR(ISBLANK(F41),LEN(F41)=0,ISBLANK(L41),LEN(L41)=0),\"\",L41-F41)","v":""},{"$f":"A41-1","v":30},15,62,63]
["3X GREAT GRAND PARENTS",null,{"$f":"COUNTA(A43:A74)","v":32},{"$f":"IF(COUNTA(C43:C74)=C42,\"\",C42-COUNTBLANK(C43:C74))","v":0},{"$f":"IF(OR(ISBLANK(D42),LEN(D42)=0),\"All found\",(C42-D42)&\" remaining\")","v":"32 remaining"}]
[{"$f":"A41+1","v":32},{"$nulls":8},"",{"$nulls":3},{"$f":"IF(OR(ISBLANK(F43),LEN(F43)=0,ISBLANK(L43),LEN(L43)=0),\"\",L43-F43)","v":""},{"$f":"A43+1","v":33},{"$f":"TRUNC(A43/2,0)","v":16},{"$f":"A43*2","v":64},{"$f":"Q43+1","v":65}]
[{"$f":"A43+1","v":33},{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L43),\"\",L43)","v":""},{"$f":"IF(ISBLANK(M43),\"\",M43)","v":""},"",{"$f":"A44-1","v":32},16,66,67]
[{"$f":"A44+1","v":34},{"$nulls":8},"",{"$nulls":3},"",{"$f":"A45+1","v":35},17,68,69]
[35,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L45),\"\",L45)","v":""},{"$f":"IF(ISBLANK(M45),\"\",M45)","v":""},"",{"$f":"A46-1","v":34},17,70,71]
[36,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A47+1","v":37},18,72,73]
[37,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L47),\"\",L47)","v":""},{"$f":"IF(ISBLANK(M47),\"\",M47)","v":""},"",{"$f":"A48-1","v":36},18,74,75]
[38,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A49+1","v":39},19,76,77]
[39,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L49),\"\",L49)","v":""},null,"",{"$f":"A50-1","v":38},19,78,79]
[40,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A51+1","v":41},20,80,81]
[41,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L51),\"\",L51)","v":""},null,"",{"$f":"A52-1","v":40},20,82,83]
[42,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A53+1","v":43},21,84,85]
[43,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L53),\"\",L53)","v":""},null,"",{"$f":"A54-1","v":42},21,86,87]
[44,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A55+1","v":45},22,88,89]
[45,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L55),\"\",L55)","v":""},null,"",{"$f":"A56-1","v":44},22,90,91]
[46,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A57+1","v":47},23,92,93]
[47,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L57),\"\",L57)","v":""},null,"",{"$f":"A58-1","v":46},23,94,95]
[48,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A59+1","v":49},24,96,97]
[49,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L59),\"\",L59)","v":""},null,"",{"$f":"A60-1","v":48},24,98,99]
[50,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A61+1","v":51},25,100,101]
[51,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L61),\"\",L61)","v":""},null,"",{"$f":"A62-1","v":50},25,102,103]
[52,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A63+1","v":53},26,104,105]
[53,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L63),\"\",L63)","v":""},null,"",{"$f":"A64-1","v":52},26,106,107]
[54,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A65+1","v":55},27,108,109]
[55,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L65),\"\",L65)","v":""},null,"",{"$f":"A66-1","v":54},27,110,111]
[56,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A67+1","v":57},28,112,113]
[57,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L67),\"\",L67)","v":""},null,"",{"$f":"A68-1","v":56},28,114,115]
[58,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A69+1","v":59},29,116,117]
[59,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L69),\"\",L69)","v":""},null,"",{"$f":"A70-1","v":58},29,118,119]
[60,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A71+1","v":61},30,120,121]
[61,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L71),\"\",L71)","v":""},null,"",{"$f":"A72-1","v":60},30,122,123]
[62,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A73+1","v":63},31,124,125]
[63,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L73),\"\",L73)","v":""},null,"",{"$f":"A74-1","v":62},31,126,127]
["4X GREAT GRAND PARENTS",null,{"$f":"COUNTA(A76:A139)","v":64},{"$f":"IF(COUNTA(C76:C139)=C75,\"\",C75-COUNTBLANK(C76:C107))","v":32},{"$f":"IF(OR(ISBLANK(D75),LEN(D75)=0),\"All found\",(C75-D75)&\" remaining\")","v":"32 remaining"}]
[{"$f":"A74+1","v":64},{"$nulls":8},{"$f":"IF(OR(ISBLANK(F76),ISBLANK(H76)),\"\",H76-F76)","v":""},{"$nulls":3},{"$f":"IF(OR(ISBLANK(F76),LEN(F76)=0,ISBLANK(L76),LEN(L76)=0),\"\",L76-F76)","v":""},{"$f":"A76+1","v":65},{"$f":"TRUNC(A76/2,0)","v":32},{"$f":"A76*2","v":128},129]
[{"$f":"A76+1","v":65},{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L76),\"\",L76)","v":""},{"$f":"IF(ISBLANK(M76),\"\",M76)","v":""},"",{"$f":"A77-1","v":64},32,130,131]
[{"$f":"A77+1","v":66},{"$nulls":8},{"$f":"IF(OR(ISBLANK(F78),ISBLANK(H78)),\"\",H78-F78)","v":""},{"$nulls":3},{"$f":"IF(OR(ISBLANK(F78),LEN(F78)=0,ISBLANK(L78),LEN(L78)=0),\"\",L78-F78)","v":""},{"$f":"A78+1","v":67},{"$f":"TRUNC(A78/2,0)","v":33},{"$f":"A78*2","v":132},133]
[67,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L78),\"\",L78)","v":""},{"$f":"IF(ISBLANK(M78),\"\",M78)","v":""},"",{"$f":"A79-1","v":66},33,134,135]
[68,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A80+1","v":69},34,136,137]
[69,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L80),\"\",L80)","v":""},{"$f":"IF(ISBLANK(M80),\"\",M80)","v":""},"",{"$f":"A81-1","v":68},34,138,139]
[70,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A82+1","v":71},35,140,141]
[71,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L82),\"\",L82)","v":""},{"$f":"IF(ISBLANK(M82),\"\",M82)","v":""},"",{"$f":"A83-1","v":70},35,142,143]
[72,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A84+1","v":73},36,144,145]
[73,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L84),\"\",L84)","v":""},{"$f":"IF(ISBLANK(M84),\"\",M84)","v":""},"",{"$f":"A85-1","v":72},36,146,147]
[74,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A86+1","v":75},37,148,149]
[75,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L86),\"\",L86)","v":""},{"$f":"IF(ISBLANK(M86),\"\",M86)","v":""},"",{"$f":"A87-1","v":74},37,150,151]
[76,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A88+1","v":77},38,152,153]
[77,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L88),\"\",L88)","v":""},{"$f":"IF(ISBLANK(M88),\"\",M88)","v":""},"",{"$f":"A89-1","v":76},38,154,155]
[78,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A90+1","v":79},39,156,157]
[79,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L90),\"\",L90)","v":""},{"$f":"IF(ISBLANK(M90),\"\",M90)","v":""},"",{"$f":"A91-1","v":78},39,158,159]
[80,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A92+1","v":81},40,160,161]
[81,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L92),\"\",L92)","v":""},{"$f":"IF(ISBLANK(M92),\"\",M92)","v":""},"",{"$f":"A93-1","v":80},40,162,163]
[82,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A94+1","v":83},41,164,165]
[83,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L94),\"\",L94)","v":""},{"$f":"IF(ISBLANK(M94),\"\",M94)","v":""},"",{"$f":"A95-1","v":82},41,166,167]
[84,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A96+1","v":85},42,168,169]
[85,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L96),\"\",L96)","v":""},{"$f":"IF(ISBLANK(M96),\"\",M96)","v":""},"",{"$f":"A97-1","v":84},42,170,171]
[86,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A98+1","v":87},43,172,173]
[87,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L98),\"\",L98)","v":""},{"$f":"IF(ISBLANK(M98),\"\",M98)","v":""},"",{"$f":"A99-1","v":86},43,174,175]
[88,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A100+1","v":89},44,176,177]
[89,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L100),\"\",L100)","v":""},{"$f":"IF(ISBLANK(M100),\"\",M100)","v":""},"",{"$f":"A101-1","v":88},44,178,179]
[90,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A102+1","v":91},45,180,181]
[91,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L102),\"\",L102)","v":""},{"$f":"IF(ISBLANK(M102),\"\",M102)","v":""},"",{"$f":"A103-1","v":90},45,182,183]
[92,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A104+1","v":93},46,184,185]
[93,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L104),\"\",L104)","v":""},{"$f":"IF(ISBLANK(M104),\"\",M104)","v":""},"",{"$f":"A105-1","v":92},46,186,187]
[94,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A106+1","v":95},47,188,189]
[95,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L106),\"\",L106)","v":""},{"$f":"IF(ISBLANK(M106),\"\",M106)","v":""},"",{"$f":"A107-1","v":94},47,190,{"$f":"Q107+1","v":191}]
[96,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A108+1","v":97},48,192,193]
[97,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L108),\"\",L108)","v":""},{"$f":"IF(ISBLANK(M108),\"\",M108)","v":""},"",{"$f":"A109-1","v":96},48,194,{"$f":"Q109+1","v":195}]
[98,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A110+1","v":99},49,196,197]
[99,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L110),\"\",L110)","v":""},{"$f":"IF(ISBLANK(M110),\"\",M110)","v":""},"",{"$f":"A111-1","v":98},49,198,{"$f":"Q111+1","v":199}]
[100,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A112+1","v":101},50,200,201]
[101,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L112),\"\",L112)","v":""},{"$f":"IF(ISBLANK(M112),\"\",M112)","v":""},"",{"$f":"A113-1","v":100},50,202,{"$f":"Q113+1","v":203}]
[102,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A114+1","v":103},51,204,205]
[103,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L114),\"\",L114)","v":""},{"$f":"IF(ISBLANK(M114),\"\",M114)","v":""},"",{"$f":"A115-1","v":102},51,206,{"$f":"Q115+1","v":207}]
[104,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A116+1","v":105},52,208,209]
[105,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L116),\"\",L116)","v":""},{"$f":"IF(ISBLANK(M116),\"\",M116)","v":""},"",{"$f":"A117-1","v":104},52,210,{"$f":"Q117+1","v":211}]
[106,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A118+1","v":107},53,212,213]
[107,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L118),\"\",L118)","v":""},{"$f":"IF(ISBLANK(M118),\"\",M118)","v":""},"",{"$f":"A119-1","v":106},53,214,{"$f":"Q119+1","v":215}]
[108,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A120+1","v":109},54,216,217]
[109,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L120),\"\",L120)","v":""},{"$f":"IF(ISBLANK(M120),\"\",M120)","v":""},"",{"$f":"A121-1","v":108},54,218,{"$f":"Q121+1","v":219}]
[110,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A122+1","v":111},55,220,221]
[111,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L122),\"\",L122)","v":""},{"$f":"IF(ISBLANK(M122),\"\",M122)","v":""},"",{"$f":"A123-1","v":110},55,222,223]
[112,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A124+1","v":113},56,224,225]
[113,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L124),\"\",L124)","v":""},{"$f":"IF(ISBLANK(M124),\"\",M124)","v":""},"",{"$f":"A125-1","v":112},56,226,{"$f":"Q125+1","v":227}]
[114,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A126+1","v":115},57,228,229]
[115,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L126),\"\",L126)","v":""},{"$f":"IF(ISBLANK(M126),\"\",M126)","v":""},"",{"$f":"A127-1","v":114},57,230,{"$f":"Q127+1","v":231}]
[{"$f":"A127+1","v":116},{"$nulls":8},"",{"$nulls":3},"",{"$f":"A128+1","v":117},58,232,233]
[117,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L128),\"\",L128)","v":""},{"$f":"IF(ISBLANK(M128),\"\",M128)","v":""},"",{"$f":"A129-1","v":116},58,234,{"$f":"Q129+1","v":235}]
[118,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A130+1","v":119},59,236,237]
[119,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L130),\"\",L130)","v":""},{"$f":"IF(ISBLANK(M130),\"\",M130)","v":""},"",{"$f":"A131-1","v":118},59,238,{"$f":"Q131+1","v":239}]
[120,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A132+1","v":121},60,240,241]
[121,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L132),\"\",L132)","v":""},{"$f":"IF(ISBLANK(M132),\"\",M132)","v":""},"",{"$f":"A133-1","v":120},60,242,{"$f":"Q133+1","v":243}]
[122,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A134+1","v":123},61,244,245]
[123,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L134),\"\",L134)","v":""},{"$f":"IF(ISBLANK(M134),\"\",M134)","v":""},"",{"$f":"A135-1","v":122},61,246,{"$f":"Q135+1","v":247}]
[124,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A136+1","v":125},62,248,249]
[125,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L136),\"\",L136)","v":""},{"$f":"IF(ISBLANK(M136),\"\",M136)","v":""},"",{"$f":"A137-1","v":124},62,250,{"$f":"Q137+1","v":251}]
[126,{"$nulls":8},"",{"$nulls":3},"",{"$f":"A138+1","v":127},63,252,253]
[127,{"$nulls":8},"",null,{"$f":"IF(ISBLANK(L138),\"\",L138)","v":""},{"$f":"IF(ISBLANK(M138),\"\",M138)","v":""},"",{"$f":"A139-1","v":126},63,254,{"$f":"Q139+1","v":255}]

{"sheet":"Pedigree Chart","index":1,"n_rows":66,"n_cols":6,"rows_kept":66}
[{"$f":"\"5 GENERATION PEDIGREE CHART for \"&'Ancestor Table'!C7&\" \"&'Ancestor Table'!B7","v":"5 GENERATION PEDIGREE CHART for  "}]
[]
[null,"SUBJECT","PARENTS","GRAND PARENTS","1X GREAT GRANDPARENTS","2X GREAT GRANDPARENTS"]
[]
[]
[null,"This pedigree chart is automatically filled out using information provided in the Ancestor Table.",{"$nulls":3},{"$f":"'Ancestor Table'!A26&\". \"&'Ancestor Table'!C26&\" \"&'Ancestor Table'!B26","v":"16.  "}]
[null,"The names, years, etc are automatically pulled from the Ancestor Table.",{"$nulls":3},{"$f":"IF(ISBLANK('Ancestor Table'!F26),\"\",'Ancestor Table'!F26)&\" - \"&IF(ISBLANK('Ancestor Table'!H26),\"\",'Ancestor Table'!H26)&IF(OR(ISBLANK('Ancestor Table'!H26),ISBLANK('Ancestor Table'!F26)),\"\",\" (\"&('Ancestor Table'!H26-'Ancestor Table'!F26)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A17&\". \"&'Ancestor Table'!C17&\" \"&'Ancestor Table'!B17","v":"8.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L26),\"\",\"m. \"&'Ancestor Table'!L26)","v":""}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F17),\"\",'Ancestor Table'!F17)&\" - \"&IF(ISBLANK('Ancestor Table'!H17),\"\",'Ancestor Table'!H17)&IF(OR(ISBLANK('Ancestor Table'!H17),ISBLANK('Ancestor Table'!F17)),\"\",\" (\"&('Ancestor Table'!H17-'Ancestor Table'!F17)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!L17),\"\",\"m. \"&'Ancestor Table'!L17)","v":""},{"$f":"'Ancestor Table'!A27&\". \"&'Ancestor Table'!C27&\" \"&'Ancestor Table'!B27","v":"17.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F27),\"\",'Ancestor Table'!F27)&\" - \"&IF(ISBLANK('Ancestor Table'!H27),\"\",'Ancestor Table'!H27)&IF(OR(ISBLANK('Ancestor Table'!H27),ISBLANK('Ancestor Table'!F27)),\"\",\" (\"&('Ancestor Table'!H27-'Ancestor Table'!F27)&\")\")","v":" - "}]
[{"$nulls":3},{"$f":"'Ancestor Table'!A12&\". \"&'Ancestor Table'!C12&\" \"&'Ancestor Table'!B12","v":"4.  "}]
[{"$nulls":3},{"$f":"IF(ISBLANK('Ancestor Table'!F12),\"\",'Ancestor Table'!F12)&\" - \"&IF(ISBLANK('Ancestor Table'!H12),\"\",'Ancestor Table'!H12)&IF(OR(ISBLANK('Ancestor Table'!H12),ISBLANK('Ancestor Table'!F12)),\"\",\" (\"&('Ancestor Table'!H12-'Ancestor Table'!F12)&\")\")","v":" - "}]
[{"$nulls":3},{"$f":"IF(ISBLANK('Ancestor Table'!L12),\"\",\"m. \"&'Ancestor Table'!L12)","v":""},null,{"$f":"'Ancestor Table'!A28&\". \"&'Ancestor Table'!C28&\" \"&'Ancestor Table'!B28","v":"18.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F28),\"\",'Ancestor Table'!F28)&\" - \"&IF(ISBLANK('Ancestor Table'!H28),\"\",'Ancestor Table'!H28)&IF(OR(ISBLANK('Ancestor Table'!H28),ISBLANK('Ancestor Table'!F28)),\"\",\" (\"&('Ancestor Table'!H28-'Ancestor Table'!F28)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A18&\". \"&'Ancestor Table'!C18&\" \"&'Ancestor Table'!B18","v":"9.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L28),\"\",\"m. \"&'Ancestor Table'!L28)","v":""}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F18),\"\",'Ancestor Table'!F18)&\" - \"&IF(ISBLANK('Ancestor Table'!H18),\"\",'Ancestor Table'!H18)&IF(OR(ISBLANK('Ancestor Table'!H18),ISBLANK('Ancestor Table'!F18)),\"\",\" (\"&('Ancestor Table'!H18-'Ancestor Table'!F18)&\")\")","v":" - "}]
[{"$nulls":5},{"$f":"'Ancestor Table'!A29&\". \"&'Ancestor Table'!C29&\" \"&'Ancestor Table'!B29","v":"19.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F29),\"\",'Ancestor Table'!F29)&\" - \"&IF(ISBLANK('Ancestor Table'!H29),\"\",'Ancestor Table'!H29)&IF(OR(ISBLANK('Ancestor Table'!H29),ISBLANK('Ancestor Table'!F29)),\"\",\" (\"&('Ancestor Table'!H29-'Ancestor Table'!F29)&\")\")","v":" - "}]
[null,null,{"$f":"'Ancestor Table'!A9&\". \"&'Ancestor Table'!C9&\" \"&'Ancestor Table'!B9","v":"2.  "}]
[null,null,{"$f":"IF(ISBLANK('Ancestor Table'!F9),\"\",'Ancestor Table'!F9)&\" - \"&IF(ISBLANK('Ancestor Table'!H9),\"\",'Ancestor Table'!H9)&IF(OR(ISBLANK('Ancestor Table'!H9),ISBLANK('Ancestor Table'!F9)),\"\",\" (\"&('Ancestor Table'!H9-'Ancestor Table'!F9)&\")\")","v":" - "}]
[null,null,{"$f":"IF(ISBLANK('Ancestor Table'!L9),\"\",\"m. \"&'Ancestor Table'!L9)","v":""},null,null,{"$f":"'Ancestor Table'!A30&\". \"&'Ancestor Table'!C30&\" \"&'Ancestor Table'!B30","v":"20.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F30),\"\",'Ancestor Table'!F30)&\" - \"&IF(ISBLANK('Ancestor Table'!H30),\"\",'Ancestor Table'!H30)&IF(OR(ISBLANK('Ancestor Table'!H30),ISBLANK('Ancestor Table'!F30)),\"\",\" (\"&('Ancestor Table'!H30-'Ancestor Table'!F30)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A19&\". \"&'Ancestor Table'!C19&\" \"&'Ancestor Table'!B19","v":"10.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L30),\"\",\"m. \"&'Ancestor Table'!L30)","v":""}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F19),\"\",'Ancestor Table'!F19)&\" - \"&IF(ISBLANK('Ancestor Table'!H19),\"\",'Ancestor Table'!H19)&IF(OR(ISBLANK('Ancestor Table'!H19),ISBLANK('Ancestor Table'!F19)),\"\",\" (\"&('Ancestor Table'!H19-'Ancestor Table'!F19)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!L19),\"\",\"m. \"&'Ancestor Table'!L19)","v":""},{"$f":"'Ancestor Table'!A31&\". \"&'Ancestor Table'!C31&\" \"&'Ancestor Table'!B31","v":"21.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F31),\"\",'Ancestor Table'!F31)&\" - \"&IF(ISBLANK('Ancestor Table'!H31),\"\",'Ancestor Table'!H31)&IF(OR(ISBLANK('Ancestor Table'!H31),ISBLANK('Ancestor Table'!F31)),\"\",\" (\"&('Ancestor Table'!H31-'Ancestor Table'!F31)&\")\")","v":" - "}]
[{"$nulls":3},{"$f":"'Ancestor Table'!A13&\". \"&'Ancestor Table'!C13&\" \"&'Ancestor Table'!B13","v":"5.  "}]
[{"$nulls":3},{"$f":"IF(ISBLANK('Ancestor Table'!F13),\"\",'Ancestor Table'!F13)&\" - \"&IF(ISBLANK('Ancestor Table'!H13),\"\",'Ancestor Table'!H13)&IF(OR(ISBLANK('Ancestor Table'!H13),ISBLANK('Ancestor Table'!F13)),\"\",\" (\"&('Ancestor Table'!H13-'Ancestor Table'!F13)&\")\")","v":" - "}]
[{"$nulls":5},{"$f":"'Ancestor Table'!A32&\". \"&'Ancestor Table'!C32&\" \"&'Ancestor Table'!B32","v":"22.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F32),\"\",'Ancestor Table'!F32)&\" - \"&IF(ISBLANK('Ancestor Table'!H32),\"\",'Ancestor Table'!H32)&IF(OR(ISBLANK('Ancestor Table'!H32),ISBLANK('Ancestor Table'!F32)),\"\",\" (\"&('Ancestor Table'!H32-'Ancestor Table'!F32)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A20&\". \"&'Ancestor Table'!C20&\" \"&'Ancestor Table'!B20","v":"11.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L32),\"\",\"m. \"&'Ancestor Table'!L32)","v":""}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F20),\"\",'Ancestor Table'!F20)&\" - \"&IF(ISBLANK('Ancestor Table'!H20),\"\",'Ancestor Table'!H20)&IF(OR(ISBLANK('Ancestor Table'!H20),ISBLANK('Ancestor Table'!F20)),\"\",\" (\"&('Ancestor Table'!H20-'Ancestor Table'!F20)&\")\")","v":" - "}]
[{"$nulls":5},{"$f":"'Ancestor Table'!A33&\". \"&'Ancestor Table'!C33&\" \"&'Ancestor Table'!B33","v":"23.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F33),\"\",'Ancestor Table'!F33)&\" - \"&IF(ISBLANK('Ancestor Table'!H33),\"\",'Ancestor Table'!H33)&IF(OR(ISBLANK('Ancestor Table'!H33),ISBLANK('Ancestor Table'!F33)),\"\",\" (\"&('Ancestor Table'!H33-'Ancestor Table'!F33)&\")\")","v":" - "}]
[null,{"$f":"'Ancestor Table'!A7&\". \"&'Ancestor Table'!C7&\" \"&'Ancestor Table'!B7","v":"1.  "}]
[null,{"$f":"IF(ISBLANK('Ancestor Table'!F7),\"\",'Ancestor Table'!F7)&\" - \"&IF(ISBLANK('Ancestor Table'!H7),\"\",'Ancestor Table'!H7)&IF(OR(ISBLANK('Ancestor Table'!H7),ISBLANK('Ancestor Table'!F7)),\"\",\" (\"&('Ancestor Table'!H7-'Ancestor Table'!F7)&\")\")","v":" - "}]
[{"$nulls":5},{"$f":"'Ancestor Table'!A34&\". \"&'Ancestor Table'!C34&\" \"&'Ancestor Table'!B34","v":"24.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F34),\"\",'Ancestor Table'!F34)&\" - \"&IF(ISBLANK('Ancestor Table'!H34),\"\",'Ancestor Table'!H34)&IF(OR(ISBLANK('Ancestor Table'!H34),ISBLANK('Ancestor Table'!F34)),\"\",\" (\"&('Ancestor Table'!H34-'Ancestor Table'!F34)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A21&\". \"&'Ancestor Table'!C21&\" \"&'Ancestor Table'!B21","v":"12.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L34),\"\",\"m. \"&'Ancestor Table'!L34)","v":""}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F21),\"\",'Ancestor Table'!F21)&\" - \"&IF(ISBLANK('Ancestor Table'!H21),\"\",'Ancestor Table'!H21)&IF(OR(ISBLANK('Ancestor Table'!H21),ISBLANK('Ancestor Table'!F21)),\"\",\" (\"&('Ancestor Table'!H21-'Ancestor Table'!F21)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!L22),\"\",\"m. \"&'Ancestor Table'!L21)","v":"m. "},{"$f":"'Ancestor Table'!A35&\". \"&'Ancestor Table'!C35&\" \"&'Ancestor Table'!B35","v":"25.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F35),\"\",'Ancestor Table'!F35)&\" - \"&IF(ISBLANK('Ancestor Table'!H35),\"\",'Ancestor Table'!H35)&IF(OR(ISBLANK('Ancestor Table'!H35),ISBLANK('Ancestor Table'!F35)),\"\",\" (\"&('Ancestor Table'!H35-'Ancestor Table'!F35)&\")\")","v":" - "}]
[{"$nulls":3},{"$f":"'Ancestor Table'!A14&\". \"&'Ancestor Table'!C14&\" \"&'Ancestor Table'!B14","v":"6.  "}]
[{"$nulls":3},{"$f":"IF(ISBLANK('Ancestor Table'!F14),\"\",'Ancestor Table'!F14)&\" - \"&IF(ISBLANK('Ancestor Table'!H14),\"\",'Ancestor Table'!H14)&IF(OR(ISBLANK('Ancestor Table'!H14),ISBLANK('Ancestor Table'!F14)),\"\",\" (\"&('Ancestor Table'!H14-'Ancestor Table'!F14)&\")\")","v":" - "}]
[{"$nulls":3},{"$f":"IF(ISBLANK('Ancestor Table'!L14),\"\",\"m. \"&'Ancestor Table'!L14)","v":""},null,{"$f":"'Ancestor Table'!A36&\". \"&'Ancestor Table'!C36&\" \"&'Ancestor Table'!B36","v":"26.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F36),\"\",'Ancestor Table'!F36)&\" - \"&IF(ISBLANK('Ancestor Table'!H36),\"\",'Ancestor Table'!H36)&IF(OR(ISBLANK('Ancestor Table'!H36),ISBLANK('Ancestor Table'!F36)),\"\",\" (\"&('Ancestor Table'!H36-'Ancestor Table'!F36)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A22&\". \"&'Ancestor Table'!C22&\" \"&'Ancestor Table'!B22","v":"13.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L36),\"\",\"m. \"&'Ancestor Table'!L36)","v":""}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F22),\"\",'Ancestor Table'!F22)&\" - \"&IF(ISBLANK('Ancestor Table'!H22),\"\",'Ancestor Table'!H22)&IF(OR(ISBLANK('Ancestor Table'!H22),ISBLANK('Ancestor Table'!F22)),\"\",\" (\"&('Ancestor Table'!H22-'Ancestor Table'!F22)&\")\")","v":" - "}]
[{"$nulls":5},{"$f":"'Ancestor Table'!A37&\". \"&'Ancestor Table'!C37&\" \"&'Ancestor Table'!B37","v":"27.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F37),\"\",'Ancestor Table'!F37)&\" - \"&IF(ISBLANK('Ancestor Table'!H37),\"\",'Ancestor Table'!H37)&IF(OR(ISBLANK('Ancestor Table'!H37),ISBLANK('Ancestor Table'!F37)),\"\",\" (\"&('Ancestor Table'!H37-'Ancestor Table'!F37)&\")\")","v":" - "}]
[null,null,{"$f":"'Ancestor Table'!A10&\". \"&'Ancestor Table'!C10&\" \"&'Ancestor Table'!B10","v":"3.  "}]
[null,null,{"$f":"IF(ISBLANK('Ancestor Table'!F10),\"\",'Ancestor Table'!F10)&\" - \"&IF(ISBLANK('Ancestor Table'!H10),\"\",'Ancestor Table'!H10)&IF(OR(ISBLANK('Ancestor Table'!H10),ISBLANK('Ancestor Table'!F10)),\"\",\" (\"&('Ancestor Table'!H10-'Ancestor Table'!F10)&\")\")","v":" - "},null,null,{"$f":"'Ancestor Table'!A38&\". \"&'Ancestor Table'!C38&\" \"&'Ancestor Table'!B38","v":"28.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F38),\"\",'Ancestor Table'!F38)&\" - \"&IF(ISBLANK('Ancestor Table'!H38),\"\",'Ancestor Table'!H38)&IF(OR(ISBLANK('Ancestor Table'!H38),ISBLANK('Ancestor Table'!F38)),\"\",\" (\"&('Ancestor Table'!H38-'Ancestor Table'!F38)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A23&\". \"&'Ancestor Table'!C23&\" \"&'Ancestor Table'!B23","v":"14.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L38),\"\",\"m. \"&'Ancestor Table'!L38)","v":""}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F23),\"\",'Ancestor Table'!F23)&\" - \"&IF(ISBLANK('Ancestor Table'!H23),\"\",'Ancestor Table'!H23)&IF(OR(ISBLANK('Ancestor Table'!H23),ISBLANK('Ancestor Table'!F23)),\"\",\" (\"&('Ancestor Table'!H23-'Ancestor Table'!F23)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!L23),\"\",\"m. \"&'Ancestor Table'!L23)","v":""},{"$f":"'Ancestor Table'!A39&\". \"&'Ancestor Table'!C39&\" \"&'Ancestor Table'!B39","v":"29.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F39),\"\",'Ancestor Table'!F39)&\" - \"&IF(ISBLANK('Ancestor Table'!H39),\"\",'Ancestor Table'!H39)&IF(OR(ISBLANK('Ancestor Table'!H39),ISBLANK('Ancestor Table'!F39)),\"\",\" (\"&('Ancestor Table'!H39-'Ancestor Table'!F39)&\")\")","v":" - "}]
[{"$nulls":3},{"$f":"'Ancestor Table'!A15&\". \"&'Ancestor Table'!C15&\" \"&'Ancestor Table'!B15","v":"7.  "}]
[{"$nulls":3},{"$f":"IF(ISBLANK('Ancestor Table'!F15),\"\",'Ancestor Table'!F15)&\" - \"&IF(ISBLANK('Ancestor Table'!H15),\"\",'Ancestor Table'!H15)&IF(OR(ISBLANK('Ancestor Table'!H15),ISBLANK('Ancestor Table'!F15)),\"\",\" (\"&('Ancestor Table'!H15-'Ancestor Table'!F15)&\")\")","v":" - "}]
[{"$nulls":5},{"$f":"'Ancestor Table'!A40&\". \"&'Ancestor Table'!C40&\" \"&'Ancestor Table'!B40","v":"30.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F40),\"\",'Ancestor Table'!F40)&\" - \"&IF(ISBLANK('Ancestor Table'!H40),\"\",'Ancestor Table'!H40)&IF(OR(ISBLANK('Ancestor Table'!H40),ISBLANK('Ancestor Table'!F40)),\"\",\" (\"&('Ancestor Table'!H40-'Ancestor Table'!F40)&\")\")","v":" - "}]
[{"$nulls":4},{"$f":"'Ancestor Table'!A24&\". \"&'Ancestor Table'!C24&\" \"&'Ancestor Table'!B24","v":"15.  "},{"$f":"IF(ISBLANK('Ancestor Table'!L39),\"\",\"m. \"&'Ancestor Table'!L39)","v":"m. "}]
[{"$nulls":4},{"$f":"IF(ISBLANK('Ancestor Table'!F24),\"\",'Ancestor Table'!F24)&\" - \"&IF(ISBLANK('Ancestor Table'!H24),\"\",'Ancestor Table'!H24)&IF(OR(ISBLANK('Ancestor Table'!H24),ISBLANK('Ancestor Table'!F24)),\"\",\" (\"&('Ancestor Table'!H24-'Ancestor Table'!F24)&\")\")","v":" - "}]
[{"$nulls":5},{"$f":"'Ancestor Table'!A41&\". \"&'Ancestor Table'!C41&\" \"&'Ancestor Table'!B41","v":"31.  "}]
[{"$nulls":5},{"$f":"IF(ISBLANK('Ancestor Table'!F41),\"\",'Ancestor Table'!F41)&\" - \"&IF(ISBLANK('Ancestor Table'!H41),\"\",'Ancestor Table'!H41)&IF(OR(ISBLANK('Ancestor Table'!H41),ISBLANK('Ancestor Table'!F41)),\"\",\" (\"&('Ancestor Table'!H41-'Ancestor Table'!F41)&\")\")","v":" - "}]

{"sheet":"Surname Table","index":2,"n_rows":28,"n_cols":6,"rows_kept":28}
[{"$f":"\"SURNAME TABLE for \"&'Ancestor Table'!C7&\" \"&'Ancestor Table'!B7","v":"SURNAME TABLE for  "}]
[]
["Identify new surnames within each generation to help determine where to research next."]
["The surnames are automatically pulled from the Ancestor Table."]
[]
[1,{"$f":"'Ancestor Table'!A11","v":"GRAND PARENTS"},{"$f":"IF(ISBLANK('Ancestor Table'!B12),\"\",'Ancestor Table'!B12)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B13),\"\",'Ancestor Table'!B13)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B14),\"\",'Ancestor Table'!B14)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B15),\"\",'Ancestor Table'!B15)","v":""}]
[2,{"$f":"'Ancestor Table'!A16","v":"1X GREAT GRAND PARENTS"},{"$f":"IF(ISBLANK('Ancestor Table'!B18),\"\",'Ancestor Table'!B18)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B20),\"\",'Ancestor Table'!B20)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B22),\"\",'Ancestor Table'!B22)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B24),\"\",'Ancestor Table'!B24)","v":""}]
[3,{"$f":"'Ancestor Table'!A25","v":"2X GREAT GRAND PARENTS"},{"$f":"IF(ISBLANK('Ancestor Table'!B27),\"\",'Ancestor Table'!B27)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B31),\"\",'Ancestor Table'!B31)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B35),\"\",'Ancestor Table'!B35)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B39),\"\",'Ancestor Table'!B39)","v":""}]
[4,null,{"$f":"IF(ISBLANK('Ancestor Table'!B29),\"\",'Ancestor Table'!B29)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B33),\"\",'Ancestor Table'!B33)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B37),\"\",'Ancestor Table'!B37)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B41),\"\",'Ancestor Table'!B41)","v":""}]
[5,{"$f":"'Ancestor Table'!A42","v":"3X GREAT GRAND PARENTS"},{"$f":"IF(ISBLANK('Ancestor Table'!B44),\"\",'Ancestor Table'!B44)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B52),\"\",'Ancestor Table'!B52)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B60),\"\",'Ancestor Table'!B60)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B68),\"\",'Ancestor Table'!B68)","v":""}]
[6,null,{"$f":"IF(ISBLANK('Ancestor Table'!B46),\"\",'Ancestor Table'!B46)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B54),\"\",'Ancestor Table'!B54)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B62),\"\",'Ancestor Table'!B62)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B70),\"\",'Ancestor Table'!B70)","v":""}]
[7,null,{"$f":"IF(ISBLANK('Ancestor Table'!B48),\"\",'Ancestor Table'!B48)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B56),\"\",'Ancestor Table'!B56)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B64),\"\",'Ancestor Table'!B64)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B72),\"\",'Ancestor Table'!B72)","v":""}]
[8,null,{"$f":"IF(ISBLANK('Ancestor Table'!B50),\"\",'Ancestor Table'!B50)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B58),\"\",'Ancestor Table'!B58)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B66),\"\",'Ancestor Table'!B66)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B74),\"\",'Ancestor Table'!B74)","v":""}]
[9,{"$f":"'Ancestor Table'!A75","v":"4X GREAT GRAND PARENTS"},{"$f":"IF(ISBLANK('Ancestor Table'!B77),\"\",'Ancestor Table'!B77)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B109),\"\",'Ancestor Table'!B109)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B125),\"\",'Ancestor Table'!B125)","v":""}]
[10,null,{"$f":"IF(ISBLANK('Ancestor Table'!B79),\"\",'Ancestor Table'!B79)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B111),\"\",'Ancestor Table'!B111)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B127),\"\",'Ancestor Table'!B127)","v":""}]
[11,null,{"$f":"IF(ISBLANK('Ancestor Table'!B81),\"\",'Ancestor Table'!B81)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B113),\"\",'Ancestor Table'!B113)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B129),\"\",'Ancestor Table'!B129)","v":""}]
[12,null,{"$f":"IF(ISBLANK('Ancestor Table'!B83),\"\",'Ancestor Table'!B83)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B115),\"\",'Ancestor Table'!B115)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B131),\"\",'Ancestor Table'!B131)","v":""}]
[13,null,{"$f":"IF(ISBLANK('Ancestor Table'!B85),\"\",'Ancestor Table'!B85)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B117),\"\",'Ancestor Table'!B117)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B133),\"\",'Ancestor Table'!B133)","v":""}]
[14,null,{"$f":"IF(ISBLANK('Ancestor Table'!B87),\"\",'Ancestor Table'!B87)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B119),\"\",'Ancestor Table'!B119)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B135),\"\",'Ancestor Table'!B135)","v":""}]
[15,null,{"$f":"IF(ISBLANK('Ancestor Table'!B89),\"\",'Ancestor Table'!B89)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B121),\"\",'Ancestor Table'!B121)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B137),\"\",'Ancestor Table'!B137)","v":""}]
[16,null,{"$f":"IF(ISBLANK('Ancestor Table'!B91),\"\",'Ancestor Table'!B91)","v":""},null,{"$f":"IF(ISBLANK('Ancestor Table'!B123),\"\",'Ancestor Table'!B123)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!B139),\"\",'Ancestor Table'!B139)","v":""}]
[{"$f":"A21+1","v":17},"MISSING SURNAMES:",{"$f":"COUNTBLANK(C6:C21)","v":16},{"$f":"COUNTBLANK(D6:D21)","v":16},16,16]
[{"$f":"A22+1","v":18},"TOTAL MISSING SURNAMES:",{"$f":"SUM(C22:F22)","v":64}]
[{"$f":"A23+1","v":19},"FOUND SURNAMES",{"$f":"16-C22","v":0},{"$f":"16-D22","v":0},{"$f":"16-E22","v":0},{"$f":"16-F22","v":0}]
[{"$f":"A24+1","v":20},"TOTAL FOUND SURNAMES:",{"$f":"SUM(C24:F24)","v":0}]
[]
["Duplicates usually indicate another connection with the same surname. It might be sisters, cousins, etc"]
["or a completely unrelated family. Does not include spelling changes."]

{"sheet":"Research Count","index":3,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$f":"\"RESEARCH COUNT for \"&'Ancestor Table'!C7&\" \"&'Ancestor Table'!B7","v":"RESEARCH COUNT for  "}]
[]
["The \"Found\" values are automatically pulled from the Ancestor Table using the \"Given Name(s)\" column."]
[]
["Generation #","Generation Name","Expected","Found","Remaining","Most Recent Common Ancestor (MRCA)"]
[1,"SELF",1,{"$f":"COUNTA('Ancestor Table'!C7)","v":0},{"$f":"C6-D6","v":1},{"$f":"B7","v":"PARENTS"}]
[2,"PARENTS",{"$f":"C6*2","v":2},{"$f":"COUNTA('Ancestor Table'!C9:C10)","v":0},{"$f":"C7-D7","v":2},{"$f":"B8","v":"GRAND PARENTS"}]
[3,"GRAND PARENTS",{"$f":"C7*2","v":4},{"$f":"COUNTA('Ancestor Table'!C12:C15)","v":0},4,"1X GREAT GRAND PARENTS"]
[4,"1X GREAT GRAND PARENTS",8,{"$f":"COUNTA('Ancestor Table'!C17:C24)","v":0},8,"2X GREAT GRAND PARENTS"]
[5,"2X GREAT GRAND PARENTS",16,{"$f":"COUNTA('Ancestor Table'!C26:C41)","v":0},16,"3X GREAT GRAND PARENTS"]
[6,"3X GREAT GRAND PARENTS",32,{"$f":"COUNTA('Ancestor Table'!C43:C74)","v":0},32,"4X GREAT GRAND PARENTS"]
[7,"4X GREAT GRAND PARENTS",{"$f":"C11*2","v":64},{"$f":"COUNTA('Ancestor Table'!C76:C139)","v":0},64,"5X GREAT GRAND PARENTS"]
[null,null,{"$f":"SUM(C6:C12)","v":127},{"$f":"SUM(D6:D12)","v":0},{"$f":"SUM(E6:E12)","v":127}]
[{"$nulls":3},{"$f":"IF(C13=0,0,D13/C13)","v":{"v":0,"d":"0%"}},{"$f":"IF(C13=0,0,E13/C13)","v":{"v":1,"d":"100%"}}]

{"sheet":"Metrics","index":4,"n_rows":29,"n_cols":4,"rows_kept":29}
[{"$f":"\"METRICS for \"&'Ancestor Table'!C7&\" \"&'Ancestor Table'!B7","v":"METRICS for  "}]
[]
[null,"Enter 'value' in the appropriate cell below based on the locations entered in the ancestor table. The 'count' column will use these values."]
[null,"You will need to enter matching place names from the ancestor table here to get the counts to work."]
[]
[null,"Category","Value","Count"]
[null,"Birth Place"]
[null,null,"Ireland",{"$f":"COUNTIF('Ancestor Table'!G:G,Metrics!C8)","v":0}]
[null,null,"New Jersey",{"$f":"COUNTIF('Ancestor Table'!G:G,Metrics!C9)","v":0}]
[null,null,"New York",{"$f":"COUNTIF('Ancestor Table'!G:G,Metrics!C10)","v":0}]
[null,null,"Pennsylvania",{"$f":"COUNTIF('Ancestor Table'!G:G,Metrics!C11)","v":0}]
[null,"Marriage Place"]
[null,null,"Ireland",{"$f":"COUNTIF('Ancestor Table'!M:M,Metrics!C8)","v":0}]
[null,null,"New Jersey",{"$f":"COUNTIF('Ancestor Table'!M:M,Metrics!C9)","v":0}]
[null,null,"New York",{"$f":"COUNTIF('Ancestor Table'!M:M,Metrics!C10)","v":0}]
[null,null,"Pennsylvania",{"$f":"COUNTIF('Ancestor Table'!M:M,Metrics!C11)","v":0}]
[null,"Death Place"]
[null,null,"Ireland",{"$f":"COUNTIF('Ancestor Table'!I:I,Metrics!C8)","v":0}]
[null,null,"New Jersey",{"$f":"COUNTIF('Ancestor Table'!I:I,Metrics!C9)","v":0}]
[null,null,"New York",{"$f":"COUNTIF('Ancestor Table'!I:I,Metrics!C10)","v":0}]
[null,null,"Pennsylvania",{"$f":"COUNTIF('Ancestor Table'!I:I,Metrics!C11)","v":0}]
[null,"Marriage Metrics"]
[null,null,"Average Age",{"$f":"AVERAGE('Ancestor Table'!N:N)","v":{"$error":"#DIV/0!"}}]
[null,null,"Oldest",{"$f":"MAX('Ancestor Table'!N:N)","v":0}]
[null,null,"Youngest",{"$f":"MIN('Ancestor Table'!N:N)","v":0}]
[null,"Death Metrics"]
[null,null,"Average Age",{"$f":"AVERAGE('Ancestor Table'!J:J)","v":{"$error":"#DIV/0!"}}]
[null,null,"Oldest",{"$f":"MAX('Ancestor Table'!J:J)","v":0}]
[null,null,"Youngest",{"$f":"MIN('Ancestor Table'!J:J)","v":0}]

{"sheet":"DNA Matches","index":5,"n_rows":7,"n_cols":23,"rows_kept":7}
[{"$f":"\"DNA Matches for \"&'Ancestor Table'!C7&\" \"&'Ancestor Table'!B7","v":"DNA Matches for  "}]
[]
["This chart only pulls the subject person's name (person #1) from the ancestor table. All other info is pulled from DNA matches. Feel free to add or remove columns to suit your research needs.",{"$nulls":10},"BRANCH column: You will need to modify the CONDITIONAL FORMATTING to match the surnames of your grandparents."]
["Enter information from  your confirmed DNA matches below."]
[]
["Surname","Given Name(s)","Preferred","Est. Relationship","Service","Username","GEDMatch Kit #","Centimorgans (cM)","Segments","Longest Block","Type (at | X | Y)","Branch","Actual Relationship","Most Recent Common Ancestors (MRCA)","Match Notes","Other Notes","Has Tree?","Tree Public?","Linked Tree?","Shared Hints?","NPE?","Email Address","Phone"]
[{"$f":"IF(ISBLANK('Ancestor Table'!B7),\"\",'Ancestor Table'!B7)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!C7),\"\",'Ancestor Table'!C7)","v":""},{"$f":"IF(ISBLANK('Ancestor Table'!D7),\"\",'Ancestor Table'!D7)","v":""},"HOME PERSON"]