Hi Chris, I dont use excel to create family trees, just to store the base information and any notes I want to add. So for example my GROBirth file contains just the information that comes from the index, but I have added columns for father and mother's names. When I transfer the information to a gedcom, I colour the row, so that I know which ones have been included in the gedcom. I am proposing to add another column shortly to put the gedcom person number in too. The advantage in this example is that I can sort on year, name, place, father, mother or any combination. As far as conversion of gedcom to excel is concerned. if you type - Gedcom converter excel - into Google it will come up with a number of possibilities. You may have to do the conversion in two stages. First Gedcom to CSV and then import the CSV file into excel. Hope this helps Sandra Chris wrote: > Sandra - could you advise what kind of structure you use for your > Excel sheet? I have tried to imagine what one would look like but got > quickly overwhelmed. Also, is there a program to convert GEDCOMS to > Excel? > > Chris Powter in Edmonton, Alberta, Canada > > ----- Original Message ----- From: "Sandra J Smith" > <sandra.s@ntlworld.com> > To: <ENG-HERTFORDSHIRE-L@rootsweb.com> > Sent: Tuesday, August 30, 2005 8:54 AM > Subject: Re: [HRT] One Name Study - Question on how to do one? > > >> Hi Theresa, >> I have been doing a one-name study of the surname FOSKETT plus >> variants for over 30 years. I am no longer a member of GOONS (Guild >> of one-name-studies) as I couldnt justify the cost of a year's >> membership. However, at one time they did have a ruling about the >> minimum amount of information one should attain in order to participate: >> From memory this included, >> All entries from the GRO Indices of Births, Marriage and Deaths from >> 1837. >> All entries from the PCC wills index >> All entries from current telephone directories (this I never did as I >> couldnt really see the relevance to my genealogical research.) >> I am sure there is a far more up todate list now which would include >> IGI, online census returns, etc. >> >> Although like you, I have tried to create gedcom files for all my >> information, I find it far more useful to maintain the data in excel >> spreadsheet files which I can sort in anyway I wish - far more >> flexible than most Genealogy programs. >> My own list, which is far from complete but gives you a general idea >> is as follows: >> <>GENERAL REGISTRATION >> >> * GRO BIRTHS ENGLAND AND WALES 1837 – 2003 >> >> * GRO MARRIAGES ENGLAND AND WALES 1837 – 2003 >> >> * GRO DEATH ENGLAND AND WALES 1837 – 2003 >> >> * BIRTH, MARRIAGE AND DEATH CERTIFICATES >> >> >> PARISH REGISTERS >> >> * BEDFORDSHIRE >> * BUCKINGHAMSHIRE >> * CAMBRIDGESHIRE >> * DEVON >> * ESSEX >> * GLOUCESTERSHIRE >> * HEREFORDSHIRE >> * HERTFORDSHIRE >> * HUNTINGDONSHIRE >> * KENT >> * LANCASHIRE >> * LEICESTERSHIRE >> * LINCOLNSHIRE >> * LONDON >> * MIDDLESEX >> * NORTHAMPTONSHIRE >> * OXFORDSHIRE >> * SURREY >> * SUSSEX >> * WARWICKSHIRE >> * MISCELLANEOUS >> >> CENSUS >> >> * 1841 CENSUS >> * 1851 CENSUS >> * 1861 CENSUS >> * 1871 CENSUS >> * 1881 CENSUS >> * 1891 CENSUS >> * 1901 CENSUS >> >> OTHER BIRTH, MARRIAGE AND DEATH INFORMATION >> >> * PALLOTS MARRIAGE INDEX >> * PALLOTS BIRTH INDEX >> * VICAR GENERAL’S MARRIAGE LICENCES (INDEX) >> * BOYDS MARRIAGE INDEX >> * BRITISH VITAL RECORDS INDEX (1ST Edition) >> * BRITISH VIATL RECORDS INDEX (2ND Edition) >> * NATIONAL BURIAL INDEX (2ND Edition) >> * INTERNATIONAL GENEALOGICAL INDEX (IGI) >> >> MILITARY AND NAVAL RECORDS >> >> * COMMONWEALTH WAR GRAVES COMMISSION >> >> * WORLDWAR I MEDAL ROLLS >> * SOLDIERS WHO DIED IN THE GREAT WAR >> * ROLL OF THE GREAT WAR >> * SOLDIERS SERVICE PAPERS 1914 – 1920 >> * SOLDIERS DISCHARGE TO PENSION 1914 – 1923 >> * SOLDIERS SERVICE PAPERS 1883 – 1913 >> * SOLDIERS DISCHARGED TO PENSION 1883 – 1913 >> * ROYAL NAVY RATINGS 1853-1923 >> * QUEEN’S SOUTH AFRICAN MEDALS (CAVALRY) >> * AUSTRALIAN WW2 SERVICE RECORDS >> >> WILLS >> >> * INDICES >> * TRANSCRIPTIONS >> * NOTES >> >> LAY SUBSIDY ROLLS AND OTHER TAX LISTS >> >> TRADE DIRECTORIES AND POLL BOOKS >> >> MONUMENTAL INSCRIPTIONS, OBITUARIES AND CEMETERY RECORDS >> >> * HIGHGATE CEMETERY, LONDON >> * ABNEY PARK CEMETERY, LONDON >> >> LONDON GAZETTE >> >> EMIGRATION >> >> * Ellis Island Immigration, USA >> * Castle Garden Immigration, USA >> * Unassisted Immigration to Victoria, Australia >> >> <>MEDIAEVAL RECORDS >> >> COATS OF ARMS >> >> MANOR ROLLS >> >> REFERENCES >> >> Dont let the length of the list stop you - I repeat - I have been >> doing this for 30 years >> >> Hope this helps >> >> Sandra Smith (nee FOSKETT) >> >> >> >> tesmith40@comcast.net wrote: >> >>> Hello everyone! >>> >>> I was wondering if anyone on this list has ever undertaken the job >>> of a ONE NAME SURNAME STUDY? That is to concentrate on just one >>> surname and gather all the records possible. Try to connect all lines. >>> >>> I'm thinking of trying this with one of my surnames *PEGRAM* and all >>> variations. Just wondering what kind of pitfalls to look for and >>> try to avoid....in other words anyone have any advice for me. I've >>> started by making a GEDCOM with just this family name and of course >>> surnames from marriages from the LDS microfilms of parish records. >>> Is this what I want to do....is this the best way to go? I'm going >>> to use census records as well for sources. What other record >>> sources should I use....not sure if wills would be available on film? >>> >>> The reason I'm thinking of this is because I had gaps in christening >>> records for my family line. I've been ordering microfilms from the >>> LDS for surrounding parishes and have filled in some of my gaps. >>> Have found 2 transcription errors this way. Also these films have >>> the burial records and sometimes it helps me to eliminate >>> possibilities for my family line. I've still got some brickwalls but >>> they are slowly coming down. >>> Any advice will be appreciated. >>> >>> Theresa E. Smith >>> Mechanicsburg, Pennsylvania, USA >>> >>> >>> ==== ENG-HERTFORDSHIRE Mailing List ==== >>> This list is for the discussion of Genealogy and History, primarily >>> regarding the English County of Hertfordshire. Discussion of >>> migration patterns, immigration, heraldry, historical sketches, >>> census data, wills, family Bibles, vital records, web sites, etc. >>> involving this area is encouraged. >>> >>> >>> >>> >> >> >> ==== ENG-HERTFORDSHIRE Mailing List ==== >> This list is for the discussion of Genealogy and History, primarily >> regarding the English County of Hertfordshire. Discussion of >> migration patterns, immigration, heraldry, historical sketches, >> census data, wills, family Bibles, vital records, web sites, etc. >> involving this area is encouraged. >> >> > > > ==== ENG-HERTFORDSHIRE Mailing List ==== > To POST a message to this list use the address: > eng-hertfordshire-l@rootsweb.com > 2) To SUBSCRIBE or UNSUBSCRIBE send a message to: > ENG-HERTFORDSHIRE-L-request@rootsweb.com (if you are in mail mode i.e. > receiving the messages individually or want them individually) or > ENG-HERTFORDSHIRE-D-request@rootsweb.com (if you are in digest mode > i.e. receiving a digest of multiple messages or want this mode) > In the BODY of the message (not the subject line) type the word > subscribe or unsubscribe. > > >

Thanks! Chris ----- Original Message ----- From: "Sandra J Smith" <sandra.s@ntlworld.com> To: <ENG-HERTFORDSHIRE-L@rootsweb.com> Sent: Friday, September 02, 2005 2:58 PM Subject: Re: [HRT] One Name Study - Question on how to do one? > Hi Chris, > I dont use excel to create family trees, just to store the base > information and any notes I want to add. > So for example my GROBirth file contains just the information that comes > from the index, but I have added columns for father and mother's names. > When I transfer the information to a gedcom, I colour the row, so that I > know which ones have been included in the gedcom. I am proposing to add > another column shortly to put the gedcom person number in too. > The advantage in this example is that I can sort on year, name, place, > father, mother or any combination. > > As far as conversion of gedcom to excel is concerned. if you type - Gedcom > converter excel - into Google it will come up with a number of > possibilities. You may have to do the conversion in two stages. First > Gedcom to CSV and then import the CSV file into excel. > Hope this helps > Sandra > > Chris wrote: > >> Sandra - could you advise what kind of structure you use for your Excel >> sheet? I have tried to imagine what one would look like but got quickly >> overwhelmed. Also, is there a program to convert GEDCOMS to Excel? >> >> Chris Powter in Edmonton, Alberta, Canada >> >> ----- Original Message ----- From: "Sandra J Smith" >> <sandra.s@ntlworld.com> >> To: <ENG-HERTFORDSHIRE-L@rootsweb.com> >> Sent: Tuesday, August 30, 2005 8:54 AM >> Subject: Re: [HRT] One Name Study - Question on how to do one? >> >> >>> Hi Theresa, >>> I have been doing a one-name study of the surname FOSKETT plus variants >>> for over 30 years. I am no longer a member of GOONS (Guild of >>> one-name-studies) as I couldnt justify the cost of a year's membership. >>> However, at one time they did have a ruling about the minimum amount of >>> information one should attain in order to participate: >>> From memory this included, >>> All entries from the GRO Indices of Births, Marriage and Deaths from >>> 1837. >>> All entries from the PCC wills index >>> All entries from current telephone directories (this I never did as I >>> couldnt really see the relevance to my genealogical research.) >>> I am sure there is a far more up todate list now which would include >>> IGI, online census returns, etc. >>> >>> Although like you, I have tried to create gedcom files for all my >>> information, I find it far more useful to maintain the data in excel >>> spreadsheet files which I can sort in anyway I wish - far more flexible >>> than most Genealogy programs. >>> My own list, which is far from complete but gives you a general idea is >>> as follows: >>> <>GENERAL REGISTRATION >>> >>> * GRO BIRTHS ENGLAND AND WALES 1837 – 2003 >>> >>> * GRO MARRIAGES ENGLAND AND WALES 1837 – 2003 >>> >>> * GRO DEATH ENGLAND AND WALES 1837 – 2003 >>> >>> * BIRTH, MARRIAGE AND DEATH CERTIFICATES >>> >>> >>> PARISH REGISTERS >>> >>> * BEDFORDSHIRE >>> * BUCKINGHAMSHIRE >>> * CAMBRIDGESHIRE >>> * DEVON >>> * ESSEX >>> * GLOUCESTERSHIRE >>> * HEREFORDSHIRE >>> * HERTFORDSHIRE >>> * HUNTINGDONSHIRE >>> * KENT >>> * LANCASHIRE >>> * LEICESTERSHIRE >>> * LINCOLNSHIRE >>> * LONDON >>> * MIDDLESEX >>> * NORTHAMPTONSHIRE >>> * OXFORDSHIRE >>> * SURREY >>> * SUSSEX >>> * WARWICKSHIRE >>> * MISCELLANEOUS >>> >>> CENSUS >>> >>> * 1841 CENSUS >>> * 1851 CENSUS >>> * 1861 CENSUS >>> * 1871 CENSUS >>> * 1881 CENSUS >>> * 1891 CENSUS >>> * 1901 CENSUS >>> >>> OTHER BIRTH, MARRIAGE AND DEATH INFORMATION >>> >>> * PALLOTS MARRIAGE INDEX >>> * PALLOTS BIRTH INDEX >>> * VICAR GENERAL’S MARRIAGE LICENCES (INDEX) >>> * BOYDS MARRIAGE INDEX >>> * BRITISH VITAL RECORDS INDEX (1ST Edition) >>> * BRITISH VIATL RECORDS INDEX (2ND Edition) >>> * NATIONAL BURIAL INDEX (2ND Edition) >>> * INTERNATIONAL GENEALOGICAL INDEX (IGI) >>> >>> MILITARY AND NAVAL RECORDS >>> >>> * COMMONWEALTH WAR GRAVES COMMISSION >>> >>> * WORLDWAR I MEDAL ROLLS >>> * SOLDIERS WHO DIED IN THE GREAT WAR >>> * ROLL OF THE GREAT WAR >>> * SOLDIERS SERVICE PAPERS 1914 – 1920 >>> * SOLDIERS DISCHARGE TO PENSION 1914 – 1923 >>> * SOLDIERS SERVICE PAPERS 1883 – 1913 >>> * SOLDIERS DISCHARGED TO PENSION 1883 – 1913 >>> * ROYAL NAVY RATINGS 1853-1923 >>> * QUEEN’S SOUTH AFRICAN MEDALS (CAVALRY) >>> * AUSTRALIAN WW2 SERVICE RECORDS >>> >>> WILLS >>> >>> * INDICES >>> * TRANSCRIPTIONS >>> * NOTES >>> >>> LAY SUBSIDY ROLLS AND OTHER TAX LISTS >>> >>> TRADE DIRECTORIES AND POLL BOOKS >>> >>> MONUMENTAL INSCRIPTIONS, OBITUARIES AND CEMETERY RECORDS >>> >>> * HIGHGATE CEMETERY, LONDON >>> * ABNEY PARK CEMETERY, LONDON >>> >>> LONDON GAZETTE >>> >>> EMIGRATION >>> >>> * Ellis Island Immigration, USA >>> * Castle Garden Immigration, USA >>> * Unassisted Immigration to Victoria, Australia >>> >>> <>MEDIAEVAL RECORDS >>> >>> COATS OF ARMS >>> >>> MANOR ROLLS >>> >>> REFERENCES >>> >>> Dont let the length of the list stop you - I repeat - I have been doing >>> this for 30 years >>> >>> Hope this helps >>> >>> Sandra Smith (nee FOSKETT) >>> >>> >>> >>> tesmith40@comcast.net wrote: >>> >>>> Hello everyone! >>>> >>>> I was wondering if anyone on this list has ever undertaken the job of a >>>> ONE NAME SURNAME STUDY? That is to concentrate on just one surname and >>>> gather all the records possible. Try to connect all lines. >>>> >>>> I'm thinking of trying this with one of my surnames *PEGRAM* and all >>>> variations. Just wondering what kind of pitfalls to look for and try >>>> to avoid....in other words anyone have any advice for me. I've started >>>> by making a GEDCOM with just this family name and of course surnames >>>> from marriages from the LDS microfilms of parish records. Is this what >>>> I want to do....is this the best way to go? I'm going to use census >>>> records as well for sources. What other record sources should I >>>> use....not sure if wills would be available on film? >>>> >>>> The reason I'm thinking of this is because I had gaps in christening >>>> records for my family line. I've been ordering microfilms from the LDS >>>> for surrounding parishes and have filled in some of my gaps. Have >>>> found 2 transcription errors this way. Also these films have the >>>> burial records and sometimes it helps me to eliminate possibilities for >>>> my family line. I've still got some brickwalls but they are slowly >>>> coming down. >>>> Any advice will be appreciated. >>>> >>>> Theresa E. Smith >>>> Mechanicsburg, Pennsylvania, USA >>>> >>>> >>>> ==== ENG-HERTFORDSHIRE Mailing List ==== >>>> This list is for the discussion of Genealogy and History, primarily >>>> regarding the English County of Hertfordshire. Discussion of migration >>>> patterns, immigration, heraldry, historical sketches, census data, >>>> wills, family Bibles, vital records, web sites, etc. involving this >>>> area is encouraged. >>>> >>>> >>>> >>>> >>> >>> >>> ==== ENG-HERTFORDSHIRE Mailing List ==== >>> This list is for the discussion of Genealogy and History, primarily >>> regarding the English County of Hertfordshire. Discussion of migration >>> patterns, immigration, heraldry, historical sketches, census data, >>> wills, family Bibles, vital records, web sites, etc. involving this area >>> is encouraged. >>> >>> >> >> >> ==== ENG-HERTFORDSHIRE Mailing List ==== >> To POST a message to this list use the address: >> eng-hertfordshire-l@rootsweb.com >> 2) To SUBSCRIBE or UNSUBSCRIBE send a message to: >> ENG-HERTFORDSHIRE-L-request@rootsweb.com (if you are in mail mode i.e. >> receiving the messages individually or want them individually) or >> ENG-HERTFORDSHIRE-D-request@rootsweb.com (if you are in digest mode i.e. >> receiving a digest of multiple messages or want this mode) >> In the BODY of the message (not the subject line) type the word subscribe >> or unsubscribe. >> >> >> > > > ==== ENG-HERTFORDSHIRE Mailing List ==== > For any updates our info about the status of this list go to > http://helpdesk.rootsweb.com > >