Final Family Tree Excel Sheet

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

Final Family Tree Excel Sheet

Post by Pandabean » Thu Nov 08, 2007 9:05 pm

I have finished work (for now) on the Family Tree Excel sheet. There are a few more sheets in this one than the previous. Below is a list of the sheets included within the package.

http://www.talkingscot.com/gallery/disp ... ?pos=-1426

Ancestor Chart
Continuation Chart
Note Sheet
Family Summary
Extra Family Information
Certificate Checklist
Soldier List
Individual Soldier Summary
Photograph Checklist


Let me know what your thoughts are on this updated spreadsheet.

Thanks,
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]

Anne H
Global Moderator
Posts: 2127
Joined: Sat Apr 30, 2005 5:12 pm
Location: Scotland

Post by Anne H » Thu Nov 08, 2007 11:19 pm

Gosh Andy...what a lot of work you've done - absolutely fantastic :!: Those forms are going to be a great aid for everyone. Well done and thank you =D>

Regards,
Anne H

Billmalc
Posts: 50
Joined: Sun Mar 26, 2006 9:33 pm
Location: Perth, Scotland

Post by Billmalc » Thu Nov 08, 2007 11:24 pm

Hi Andy

This is an excellent spreadsheet. Being a regular user of excel, I can appreciate how much effort and hard work has gone into this.

Well Done :!: :!:

Bill
Researching MALCOLM from Fife, Kinross and Perth and LENNOX from Dunblane and St. Ninians. Cross, Stewart/Stuart from Perthshire.
http://billmalc.tribalpages.com/

joette
Global Moderator
Posts: 1974
Joined: Mon Sep 05, 2005 5:13 pm
Location: Clydebank

Post by joette » Fri Nov 09, 2007 12:18 am

I am in awe when somebody does anything complex on the computer.I still thinking there is a wee furry creature inside the mouse.
Well done & I will make use of it all.
Researching:SCOTT,Taylor,Young,VEITCH LINLEY,MIDLOTHIAN
WADDELL,ROSS,TORRANCE,GOVAN/DALMUIR/Clackmanannshire
CARR/LEITCH-Scotland,Ireland(County Donegal)
LINLEY/VEITCH-SASK.Canada
ALSO BROWN,MCKIMMIE,MCDOWALL,FRASER.
Greer/Grier,Jenkins/Jankins

marilyn morning
Global Moderator
Posts: 3098
Joined: Sun Dec 12, 2004 1:45 am
Location: Rhode Island, USA

Post by marilyn morning » Fri Nov 09, 2007 12:24 am

Hi Andy,

A very professional presentation indeed! I'll be printing off my copy.

Thanks
Marilyn

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

Post by Pandabean » Fri Nov 09, 2007 1:02 pm

There is ;). have you met the hamster inside the big box yet? He just loves running on that wheel. :D

As I have said before the only thing missing is the census sheet. There is one out there already but I may give making one a go and see how it pans out.
joette wrote:I am in awe when somebody does anything complex on the computer.I still thinking there is a wee furry creature inside the mouse.
Well done & I will make use of it all.
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]

mallog
Posts: 438
Joined: Wed Apr 05, 2006 5:41 am
Location: Ayrshire Coast

Post by mallog » Fri Nov 09, 2007 2:17 pm

I didn't realise what could be done with Excel :shock: Well done !!
Anderson, McAlpine, Blue - Argyll
Dunn Fife /ML
Coutts, McGregor - Perth/Govan
Glen, Crow, Imrie - Angus
Scott & Pick ML
Mason - Co Down

ellenavon
Posts: 227
Joined: Sun Jan 02, 2005 8:24 pm
Location: Cardiff

Post by ellenavon » Fri Nov 09, 2007 3:53 pm

Thanks Andy. It will be put to good use.

Your efforts are much appreciated.

Ellen.
Researching: Grant; MacIntosh; Wright; Parley; Souter; Jaffray; Sangster; all North East & Speyside and Sutherland, Glasgow then Sutherland County; Buchanan, Stirlingshire; Lamond, North East; Stronach, Morayshire to name but a few!

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

Post by Pandabean » Fri Nov 09, 2007 5:27 pm

Neither could I. I am still amazed at what I find in excel. Last night I found a way to make cooler looking charts. I usually just play around with as I use it at work and I often try and work out how to get formulas working etc or ways to make forms look better.
mallog wrote:I didn't realise what could be done with Excel :shock: Well done !!
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]

AnnieMack
Posts: 257
Joined: Sun Jun 05, 2005 10:59 pm
Location: Auchterarder

Excel

Post by AnnieMack » Fri Nov 09, 2007 9:55 pm

Andy:

I'm glad I'm not the only one who lurvves Excel! Your charts are great. I am currently teaching myself programming in Excel to help me develop it further for work.

Annie :lol:
Searching: Pow - Stirlingshire, Pender - Paisley, Gray - Alva, Paisley, Elderslie, Canning - Stirling, Morrison, Innes and Wilson - Glasgow to name a few!

www.dundeereptheatre.co.uk home to Scotland's only full time ensemble