Family Tree Excel Sheets

Useful places to look up facts

Moderator: Global Moderators

Pandabean
Moderator
Posts: 874
Joined: Mon Mar 13, 2006 6:34 pm
Location: Aberdeenshire - Originally Falkirk

Family Tree Excel Sheets

Post by Pandabean » Wed Aug 01, 2007 4:17 pm

Hi,

Sorry for my absence lately, just busy moving into a new place and getting settled into a new job.

What I am wanting to ask is regarding the spreadsheets I made up a good few moths back. I am wanting to try and redo them over the next few weeks.

Is there anything that you would perhaps like to see added to them or improved on them?

Basically its an excuse to play around with excel and also help out people who don't really have much of a software program to see their tree.

So feel free to comment,

:D
Andy
[size=75]
[b]McDonald[/b]
[b]Greenlees & Fairnie[/b] (Musselburgh area)
[b]Johnston, Whitson, Whitecross, Runciman [/b] (Haddingtonshire)
[b]Rutherford [/b](Dumbartonshire, Airth & Larbert)
[b]Ross, Stevenson & Robb[/b](Falkirk)[/size]
Top
smiddykilry
Posts: 112
Joined: Thu Jun 16, 2005 8:28 am
Location: Angus Glens

Post by smiddykilry » Wed Aug 01, 2007 8:08 pm

posted Nov 06 :cry:



Hi
I have been very busy adding info but have a wee problem with cell J29 on the continuation sheet (protected) ??

smid
Dunn, Rough, Smith, Bruce, Paterson, Paton. Wylie,
Stewart, Reid, Gardiner, Rollo, Turner, Dutch, Laing, Forsyth, Robb, Hardie.
Kennedy, Kandow, Winter, Vollum, Hastie.
Top
Pandabean
Moderator
Posts: 874
Joined: Mon Mar 13, 2006 6:34 pm
Location: Aberdeenshire - Originally Falkirk

Post by Pandabean » Thu Aug 02, 2007 8:51 am

Sorry I didnt get back to you :oops:

I will try and unprotect it in the next version. How has it been with using it?

I am not sure how easy it is to transfer data from one version to another.

I was also thinking of expanding the number of people per sheet but the user will have to print to fit one sheet. Do many people have access to A3 printers these days?
Andy
[size=75]
[b]McDonald[/b]
[b]Greenlees & Fairnie[/b] (Musselburgh area)
[b]Johnston, Whitson, Whitecross, Runciman [/b] (Haddingtonshire)
[b]Rutherford [/b](Dumbartonshire, Airth & Larbert)
[b]Ross, Stevenson & Robb[/b](Falkirk)[/size]
Top
claudette
Posts: 51
Joined: Mon Jul 09, 2007 12:11 pm
Location: Suffolk

Post by claudette » Mon Aug 06, 2007 11:59 pm

Hi

Is there a link to these excel spread sheets so that I can see them?

Also I don't know about other people but I definitely don't have access to an A3 printer, though it would be useful.

Many thanks
Claudette
Searching for Grieve family
Top
LesleyB
Posts: 8184
Joined: Fri Mar 18, 2005 12:18 am
Location: Scotland

Post by LesleyB » Tue Aug 07, 2007 12:22 am

Hi Claudette
A link to the Excel sheets for an individual person can be found in the FAQ area of the forum:
http://talkingscot.com/forum/viewtopic.php?t=5661
With the rest of the Excel sheets explained here & with a link to the sheets themselves:
viewtopic.php?t=6917&highlight=excel

Best wishes
Lesley
Top
Pandabean
Moderator
Posts: 874
Joined: Mon Mar 13, 2006 6:34 pm
Location: Aberdeenshire - Originally Falkirk

Post by Pandabean » Tue Aug 07, 2007 1:34 pm

Just to let you know I have added in extra sheets for research relating to soldiers and the Family Summary is changing slightly.

Is there anything you would like to see included in the updated one?

The A3 printer option might be a problem I was just thinking of a way to get more on a sheet of paper. The only one that comes to mind is the "Fit to 1 page option"
Andy
[size=75]
[b]McDonald[/b]
[b]Greenlees & Fairnie[/b] (Musselburgh area)
[b]Johnston, Whitson, Whitecross, Runciman [/b] (Haddingtonshire)
[b]Rutherford [/b](Dumbartonshire, Airth & Larbert)
[b]Ross, Stevenson & Robb[/b](Falkirk)[/size]
Top
claudette
Posts: 51
Joined: Mon Jul 09, 2007 12:11 pm
Location: Suffolk

Post by claudette » Tue Aug 07, 2007 11:23 pm

Hi

They look really good and I will be using them if that's ok when I have a trip to Edinburgh in October to go searching through all the OPRs - they will be very handy for recording any info I might happen to find.

I wondered if on the certificates sheet a tick box for having a will/testament would be useful - could put in a tick, cross or N/A.

Does anyone know either any good software or failing that any links to help me create a drop-line family tree - I think that's what they're called - so that I can produce a family tree which includes all siblings in all the families over all the generations. Do you understand what I mean?

I know I don't have an A3 printer but presumably I could save it to CD and get someone else to print it for me? I know what I want to be able to do, but I'm not very technical when it comes to computers.

Many thanks for all your help
Claudette
Searching for Grieve family
Top
Pandabean
Moderator
Posts: 874
Joined: Mon Mar 13, 2006 6:34 pm
Location: Aberdeenshire - Originally Falkirk

Post by Pandabean » Tue Sep 11, 2007 7:48 pm

Hey all,

Finally got an internet connection in my new place. I can now spend more time doing the family tree, work permitting that is. i have progressed with the sheets I have made by adding extras in them. Probably have them finished in a few weeks.

I would add a census one but I have noticed there is a really good one already out there. Can't remember where but I do have a copy that I use for my census sheets.

Just thought I would give you a quick update.
Andy
[size=75]
[b]McDonald[/b]
[b]Greenlees & Fairnie[/b] (Musselburgh area)
[b]Johnston, Whitson, Whitecross, Runciman [/b] (Haddingtonshire)
[b]Rutherford [/b](Dumbartonshire, Airth & Larbert)
[b]Ross, Stevenson & Robb[/b](Falkirk)[/size]
Top
Russell
Posts: 2559
Joined: Sat Dec 24, 2005 5:59 pm
Location: Kilbarchan, Renfrewshire

Post by Russell » Wed Sep 12, 2007 12:12 am

Hi Andy

Great that your back on line.
Hope you're settled in to your new place and new job.
Remember that you are now EMPLOYED and your boss will expect that you do some work at least for the firm (unlike some others who post on this site :D :D )

Russell
Working on: Oman, Brock, Miller/Millar, in Caithness.
Roan/Rowan, Hastings, Sharp, Lapraik in Ayr & Kirkcudbrightshire.
Johnston, Reside, Lyle all over the place !
McGilvray(spelt 26 different ways)
Watson, Morton, Anderson, Tawse, in Kilrenny
Top
marilyn morning
Global Moderator
Posts: 3098
Joined: Sun Dec 12, 2004 1:45 am
Location: Rhode Island, USA

Post by marilyn morning » Wed Sep 12, 2007 12:35 am

Good to have you back Andy!!

Russell wrote
Remember that you are now EMPLOYED and your boss will expect that you do some work at least for the firm (unlike some others who post on this site )
Unless you're your own boss..... :lol:
Top

Return to “Research Sources”