There is some software called Custodian which I have found very useful in helping to collate all my one-family information. It has a huge number of different databases all of which feed into a master database which helps cross reference etc. http://www.custodian3.co.uk/ Best wishes Jackie -----Original Message----- From: Chris [mailto:cretwop@shaw.ca] Sent: 02 September 2005 22:19 To: ENG-HERTFORDSHIRE-L@rootsweb.com Subject: Re: [HRT] One Name Study - Question on how to do one? 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 > > ==== 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.