Create a Surname Cheat Sheet for Your Family Tree

Поделиться
HTML-код
  • Опубликовано: 13 сен 2024

Комментарии • 75

  • @FamilyHistoryFanatics
    @FamilyHistoryFanatics  4 года назад +6

    I hope you really like this new method. It makes it a little more challenging that the previous method to create, but it makes SO MUCH more sense. I would love to know what you think.

    • @CharlieFFK
      @CharlieFFK 4 года назад +3

      Family History Fanatics Thanks -- better. If you could add a "blank" Numbers Only" chart in excel (like your 3,5,6,8..) Etc. I could compare it with a #'ed pedigree chart -- (Ped. Chart with same #'s vs. your family names)... It would be even better. :-) Well... Guess I can do that myself... Geez. Again, thanks for "taking it slow"... You know how we get excited with genealogy tools! :-)

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад +2

      @@CharlieFFK I really hadn't thought of that simply because I don't use blank number charts. I only use online trees. If you make a cheat sheet and post in on a blog somewhere, I can link to it in the descriptions and on my related blog post.

    • @mariacapaldi5062
      @mariacapaldi5062 4 года назад +2

      I love the idea of it......just going to have to watch several times just a bit confused with 3rd and 4th but that's me(dumb)
      Thks. Devon

    • @MusicInMotion_67
      @MusicInMotion_67 2 года назад +2

      Can you put a template on here for people to download?

  • @carriesmith4665
    @carriesmith4665 4 года назад +2

    OMG thank you for making a new video! I saw the other one for the first time yesterday and was SO confused- thank you for breaking it down !!

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад +1

      You're so welcome! I never thought this would catch on as well as it did. I tried to address the issues raised by the first video. SO glad you found it easier to understand.

  • @donnabalentine9157
    @donnabalentine9157 3 года назад +1

    While watching this on RUclips, I put the numbers in the Suffix box of my tree using quick edit when I paused the video. I just kept going back and forth between my tree and my word table and But realized I could also print out the page of my 4th great grandparents if I wanted which would be very helpful with the 4th great grandparents. I really appreciated this video. I have SEVERAL missing relatives in the 3rd and 4th great grandparents. I will print the surname table out, and when I am looking at microfilm (family search historical images), now I can locate those surnames and then check to see if that is part of my family tree. I hope this will help me break through some brick walls. Looking at the family search historical images helped me break through one brick wall already. I know I will have to edit my tree but hopefully I can edit it as I add names and information to it. Thanks for the videos.

  • @JeanetteCates
    @JeanetteCates 3 года назад +1

    This was so helpful! I'm reading your book and when I got to this - I needed a video! This has pointed how much MORE research I get to go to fill in all the squares. Thanks for the excuse to research more rather than clean out stuff. LOL

  • @uptergroveGreg
    @uptergroveGreg 4 года назад +8

    Hi Devon . I like the surname table, but I don’t understand why you use the funky numbering system when you get to 3rd GGP and beyond. At 7:08 in the video you number the mothers in far right of the tree using 1,3,2,4,5,7,6,8, but then you add them into the surname table in that order. I don’t see why the numbering. It would be simpler to explain and achieve the same results if you just consistently numbered the mothers top to bottom 1 to 8, then placed them in the surname table, 1 to 4 in the Geisler column, 5 to 8 in the Zumstein column etc.. Is it related to Ahfentafel numbering?
    Despite that though, I do like the organized yet compact nature of the surname table. Nice !

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад +5

      Greg, Thanks for the feedback. First, it's not related to Ahfentafel number.
      When I did a 1-8 straight order, it messed up the table (which is what happened in the previous video I did) and folks were 'married' to the wrong people when I lined up the table (as shown in the video). So I tried again and this number system worked better. It's a little more confusing to explain but the end result is more accurate.

    • @paulbaltzer4745
      @paulbaltzer4745 4 года назад +3

      I agree...the numbering sequence was a mess.

  • @staceycoates1418
    @staceycoates1418 4 года назад +2

    I had come up with a modified surname table for DNA use. It takes a look at what grandparent to look at depending on the likely generation gap. So I made the surname table, made a list of what cousin range was for each depending on the xCyR. And then used the Shared CM project with my matches amount and then took the likely relationships from my surname chart to know what some of the likely ancestors to look for when researching DNA. If you would like I could write up what I do and maybe access to my tree to see where I am getting the names if it is need. I made the chart when I was taking Andy's Intro DNA Workshop in December 2018.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад

      I would really like to see that. Send me a like using the email you have access to already (for the writing workshop).

    • @utubeblaw
      @utubeblaw 3 года назад +1

      I would love to see how this looks and works! Where can I go to see this?

  • @cherylprebula8263
    @cherylprebula8263 3 месяца назад

    Hi Devon I just found your videos and they have been super helpful. I did get a little confused when I took this and tried to color code based on your video of using Surname table to code ancestry DNA matches. It seems like it jumped to combining certain surnames and I am not sure if there is a methodical way to do that. Can you help? Thanks so much. Again appreciate your videos :)

  • @durehm
    @durehm 7 месяцев назад

    Thanks for this, Devon. I admit it took me all day (I needed a cup of tea and a lie down part way through) but I think I have it sorted except for the Norwegians, who tend to add confusion by calling the female offspring "fathersname dottir". Later they took on the style we know and use, but 4 generations ago, not so much!

  • @kirstinmiller
    @kirstinmiller 4 года назад

    My surname table is filled in up to 4GGP and I think I've got it. Thank you so much for the detailed explanations, images and reminder to Slow Down. It is simple to check with the 'wedge tip' explained at about 5:40.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад

      Glad you were successful. It's a handy cheat sheet of surnames. I get lost in some lines and fail to realize I can be useful in other places on my family tree. Plus, I have seen some brick wall busting clues by knowing the names.

  • @tiaramathias1882
    @tiaramathias1882 5 месяцев назад

    Got a question, my grandparents are Mathias, Lloyd, Bilbee, Mckinney. When I go to my 1st great grandparents I have 2 sets of Lloyd's on both sides. How do I go about doing that into my surname table

  • @GypsyArt
    @GypsyArt Год назад

    Ok, I did a version of this using what I had, but then I finally found my 2nd great granddad (took 24 years!) I don't mind putting his in BUT to complicate matters my nan (his granddaughter) was put under her mums maiden name because her dad (his son) was away in WW1 at the time and in the UK the law states she couldn't use his surname(although she did it later life b4 she married). So my question is, when using this table do I use the name she was registered under, her dads surname or his dads surname? I usually -for the sake of gaining accurate documents etc - use her registered surname, but I don't know if that would mess this table up. apologies for being so long winded.

  • @GloriaOren
    @GloriaOren 11 месяцев назад

    I somehow got lost at the end. I get the 1,5,3,7,2,6,4,8, in one column but then your next screen shows scattered names in the other columns, where did they come from? Lost me there. Also two questions - I have a daughter, my grandmother, who was born out of wedlock and had used her mother's name her whole life. Her mother married, not to her father. I didn't put his surname since he didn't adopt her. Is that the correct way to do this? I have several cases where sisters or cousins with the same surname married others, not siblings. I out the surname in twice as they are different people, am I right in doing this?

  • @shannonberry7968
    @shannonberry7968 7 месяцев назад

    I might be crazy, but I think I found a mistake in this. I noticed it when my GGPs didn't "line up" with the person they married. In the video, you have Karlsberg labeled as 3 on the Ancestry tree, yet you placed Karlsberg in the #2 spot on the table and not in the #3 spot. Done that way it matches up perfectly, but if that is the case, then the second female GGP on the Ancestry tree should be labeled 2. Am I missing something??? Also, on your Ancestry tree you have number 6, but on the table you have no 6 spot, but you have a 9 spot???? Where does 9 come from?

  • @DEESPENCER-cp5hh
    @DEESPENCER-cp5hh 5 месяцев назад

    How do I find a father , I dont have a name for please?

  • @joanneasch7198
    @joanneasch7198 4 года назад

    I think in 3rd & 4th great grandparents when you fill them in on Excel they need to be in numerical order instead of the mixed up way they were on the chart. Otherwise there is no reason to mix the numbers like that. When I entered them as 1,2,3 in each column they lined up perfectly with the marriage above.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад

      Feel free to do it that way. When I explained in in the previous video, people were getting confused.

  • @emilymoore8131
    @emilymoore8131 3 года назад

    I was hoping to see more about the advantages of a surname table over a pedigree chart. The pedigree chart has the same (and additional) information.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад +1

      Organization & quick reference. The pedigree chart has a lot more information. In essence, a surname table is a pedigree chart, just stripped of all other extraneous information.

  • @user-mx7kl7tw4v
    @user-mx7kl7tw4v Год назад

    Totally confused. Made no sense to me and I'm very familiar with pedigree charts and spreadsheets.

  • @bonbon251
    @bonbon251 3 года назад

    Thank you for sharing this. I am curious if there is a method of charting surenames for descendancy research. This would include surenames of all married children on down their lines to us and our matches. I feel like this could be a benefit as we search and/or help build our DNA match trees up to recognize surenames that may come down from our ancestor tree. Would love thoughts or direction on how to create a helpful document like this.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  2 года назад

      Now this is an interesting question. Sorry I didn't see it sooner. RUclips tends to hide comments for my videos in lieu of my husbands.
      In any case, I think you'll have to determine how you visualize things. For instance, you could have the first row represent the top ancestor's surname. Then the next rows be the surnames of the spouses who join the family. Make sure you color code those surnames so you recognize them as children of the first ancestor. Then each color block of rows has the surnames that apply to the spouses. I would put each key ancestor and their descendants on different spreadsheet tabs. It would get confusing other wise,.
      Or, you could have Row 1 be the key ancestor
      Row 2 - each cell in this row is a surname that 'joins' the family
      Row 3 - each cell in this row is a surname that 'joins' the family
      And so forth.
      Again, put each common ancestor and their descendants on separate tabs.

  • @kcag5347
    @kcag5347 4 года назад

    I followed this and I have some gaps in the 3x's Greats. I was surprised how much I was able to fill out, though. When I got to the 4 Greats I only have the 1st and 3rd column filled out. I'm not sure how to fill out columns 2 and 4. It's a cool table, thanks!... I kept at it and I think maybe I figured it out. Each column in the GGGG row has the same numbering system. You just have to be sure to go through each paternal and maternal line. I had only followed a couple lines, but I needed to follow through on each grandparent. I feel better now!

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад

      I'm glad you figured it out. If you still have questions, use this form to send me an email www.familyhistoryfanatics.com/contact

  • @13hkelles
    @13hkelles Год назад

    What if you have couple with the same last name? Shields married Shields?

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  Год назад

      Great question. Put the Shields in the lines where the surnames split. Then put the proceeding name changes where applicable. Then use an asterisk to explain what the surnames appear multiple times.

  • @julieraupp6434
    @julieraupp6434 3 года назад

    Love your videos. Very helpful. I am about to adjust my Color Coding Colors on my Ancestry DNA. Two Questions: Family Search Fan Chart colors are Blue, Green, Orange/Red, Yellow. In looking at your DNA color coding (as well as some other people's examples) with Ancestry, they seem to reverse the first two colors: Green, Blue, Orange/Red and Yellow. I'm wondering why not be consistent with Family Search? SECOND QUESTION: in reviewing this video something popped out at me. For your SURNAME TABLE you do not seem to keep the same color coding here as you have in the DNA Color Coding. Here the 4 basic colors are arrange by Generation rather than Male colors and Female colors. I guess visually it would be difficult to see all Greens/green hues in the first column? etc. Now that I am going to redo colors, I loved your idea of using 16 colors (w 4 basic colors) but you are able to ID out to 3rd Great Grandparents. Hope I explained well enough here. Thanks again for your ideas.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад

      I chose my color coding system to reflect a color scheme that made sense to me without considering the synergy between FamilySearch or Ancestry. That's the beauty of it, you can choose what colors you'd like.
      Thanks for pointing out the color-coding on Ancestry and the color-coding on the surnames. The videos came out at different times and my processes have evolved since then. You did a great job explaining and I do recognize that color coding could be synergized for all the tools. Give it a go because I think you're on the right path.

  • @jasonrichards7230
    @jasonrichards7230 3 года назад

    So what is the best dna/family line to use with the mouth swab or whatever it is they do?

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  2 года назад

      All of them have their pluses and minuses and the 'best' company is the one that has your DNA matches in them. Ignore the ethnicity result questions.
      Since you won't know which DNA company has your matches in them, do the following:
      1. Test with Ancestry DNA
      2. Download your Ancestry RAW DNA ruclips.net/video/-Z4vyKuSXa4/видео.html
      3. Transfer DNA to other companies for little or no cost ruclips.net/video/XZfF1juyHbI/видео.html
      (Transfer to MyHeritage, Living DNA, GEDmatch, and Family Tree DNA.

  • @cryonica666
    @cryonica666 4 года назад

    Hiya again, I'm not understanding this one either lol. I'm hopeless.
    On your Ancestry tree slide, you have
    1 - Mack
    3 - Kalsberger
    2 - Stone
    4 - Sexton
    Why does the order change when you put it into your spreadsheet?
    1 - Mack
    3 - Stone
    2 - Kalsberger
    4 - Sexton
    Why are 2 and 3 swapped??

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад

      Send me an email using this form and I'll walk you through it www.familyhistoryfanatics.com/contact

  • @michaelwhalan9783
    @michaelwhalan9783 4 года назад

    I had a recent set of DNA matches that suggest an ancestors family name Marsden at 6th Gt grandparent or further back only knowing it is my paternal side. I have a maternal side wife of a grandfather, married about 20 twenty years after the birth of a child, but with only one DNA cousin match with name Cochiefer to match different spelling like the founder of Mercury outboard motors and NASCAR fame.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад

      Wow, that's super cool. NASCAR royalty there!!!

    • @tombillings1707
      @tombillings1707 Год назад

      I have the MARSDEN surname on my maternal line back to 10 generations.

  • @tiffanywalker1744
    @tiffanywalker1744 2 года назад

    Question, I have multiple half siblings, how would I do a surname chart for that?

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  2 года назад

      Surname charts are supposed to be quick reference charts. In your case, having multiple charts will be better than trying to create one chart to rule them all.
      Place the names of your direct ancestors on the chart. Don't add your half-siblings' ancestors that you don't share in common.
      Your half-sbilings' charts will look different than yours. But you can flip between them for research purposes as needed.

  • @lindastent-campbell5130
    @lindastent-campbell5130 3 года назад

    So are you just writing this chart on paper or is there an online template somewhere?

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад +1

      There isn't really an online template. many have drawn this on paper or created it in a spreadsheet.

  • @kaycarey3693
    @kaycarey3693 4 года назад

    How can this chart be modified for 1) dit names in my French-Canadian lines; &
    2) endagamous names in my Breton & German from Russia lines?? Thanx, KMC

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад

      What this video and see if it helps answer your question. ruclips.net/video/jt8rc5uwnsQ/видео.html
      If not, send me an email through our website: www.familyhistoryfanatics.com/contact

  • @JayneSmith1960-UK
    @JayneSmith1960-UK 4 года назад

    Hello Devon,
    I'm curious about something. In the video at 3:50 you show your pedigree and number the names to be transferred to the surname table. The surname I see on the pedigree at #2 is TOWNLEY so why is it showing PEAK in the surname table? :D

  • @debbiealexander184
    @debbiealexander184 3 года назад

    Where do I find the surname table? I use the color coding but never heard or seen of the table until today.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  2 года назад

      You have to create the surname table using a spreadsheet. Did I not explain how to do it step-by-step?

    • @debbiealexander184
      @debbiealexander184 2 года назад

      @@FamilyHistoryFanatics Ok thanks now it makes more sense I guess I didn't realize you created your own. It's been awhile since I watched that and forgot about it. I will have to go and create mine now that I have rewatched and understand. Please tell my cousin Andy hi from his Greene cousin Debbie .

  • @cryptoref
    @cryptoref 4 года назад

    OK so i've created my table, but one line just doesn't work. It's patronymics. Sen's and datter's just make a mess of the table. I've got two generations on there, but after that i'm leaving it blank. Any other suggestions?

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад +1

      Congratulations on getting this far. With Patronymics, you'll add an additional column but only add in the male surnames as those name are passed down. You can also add letters, numbers, or icons to help you show to flow of names. Check out this video next. ruclips.net/video/jt8rc5uwnsQ/видео.html
      Keep the questions coming.

  • @flagger7571
    @flagger7571 4 года назад

    Devon, I only know my maternal side of my family. Will the sur name chart still work for me?

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  4 года назад +2

      You're surname table will have a blank paternal side and details on the maternal side. Yes, you can use it. Then, when you make a break through on the paternal side, you can add more details.

  • @kobymccarty6682
    @kobymccarty6682 2 года назад

    How did you do that template?

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  2 года назад

      I just created a table in Google Sheets. You can do this in any spreadsheet program. The key is to add 5 columns (1 for each grandparent and one for the generation column). Then add the generational rows.

  • @dragon79pleasure
    @dragon79pleasure 3 года назад

    I am having such a hard time getting my chart made, this is making me feel dumb. At about 1:40 you mention how you use your Great-Grandparents to fill in the line marked "GP", I thought that was for Grandparents and that '1st GGP' was the Great-Grandparents. Is '1st GGP' really the generation after my Grandparents' parents? HELP!

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад

      Send me an email at info@familyhistoryfanatics.com and I'll help you out.

  • @alanheadrick7997
    @alanheadrick7997 4 года назад

    Since I have one family name and it does not appear in any of four DNA sites I am trying to be creative. I have searched through family trees looking for matching surnames. Then I look to see if they are common names, I ignore if its like Smith or Jones. I am trying to work out if these names might point to a branch in the family tree. I have also noticed that some matches family trees will have common surnames between them. I am thinking they could also point to a branch in the tree. However I am unsure of my logic.

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад

      That's something we should discuss for a future live stream. Can you send me the name and what you've done to research it via the contact form on our website? www.familyhistoryfanatics.com/contact

    • @alanheadrick7997
      @alanheadrick7997 3 года назад

      @@FamilyHistoryFanatics I don't see a specific contact button. I found a "business inquiries" email? OK I got it. I'll write up what I have tried and some of my logic.

  • @mindmesh7566
    @mindmesh7566 3 года назад

    Yup!! There are those darn Shurtleffs!! Those buggahs!!!

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  2 года назад

      Why buggars?

    • @mindmesh7566
      @mindmesh7566 2 года назад

      @@FamilyHistoryFanatics ……I said that lovingly and with a bit o’ dark humor - buggahs was a term my grandfather used muchly.

  • @carolvickers7632
    @carolvickers7632 3 года назад

    This is way too confusing!

    • @FamilyHistoryFanatics
      @FamilyHistoryFanatics  3 года назад

      Sorry to hear that. If you have your family tree on WikiTree, they have a tool that will generate a surname table with a click of the button.