SOUTH-AFRICA-L Archives

Archiver > SOUTH-AFRICA > 2003-02 > 1044234371


From: "V Kymdell" <>
Subject: Re: [ZA] RE: [ZA-IB] Paul's Excel Spreadsheet on Ellen's Transcripts
Date: Mon, 3 Feb 2003 03:06:11 +0200


Paul, what a star you are. You have saved me, for one, a huge task. I have
been saving the transcripts for later sorting, but of course, don't have
your computer knowledge so it would have been done the long way around.
Thanks so much.

VivKymdell


-----Original Message-----
From: Paul Tanner-Tremaine <>
To: <>
Date: 02 February 2003 09:31
Subject: [ZA] RE: [ZA-IB] Paul's Excel Spreadsheet on Ellen's Transcripts


>Hi Listers,
>
>The latest version of my spreadsheet is now available on Heather's South
>African Genealogy website at http://www.genealogy.co.za/ - follow the
>Downloads link. The zipped file Stanton_1_31.zip is the first one on her
>list, and if you click on the blue underlined file, you should be able to
>download it to your PC. It is an Excel spreadsheet in Winzip format. If
>you don't have Winzip, you can get it by following the link that Heather
has
>on the same page.
>
>This file includes all of Ellen's transcriptions up to those that she
>published on the 31st of January - hence the _1_31 in the file name, and it
>does NOT include her installment #9 of the Presbyterian Parish Records for
>Trinity Church in Grahamstown. That, and subsequent ones, will be included
>in the next edition.
>
>For those of you that have utilised my spreadsheet before, I have resorted
>some of the data into different workbook tabs along the bottom. For
example
>you now have Bathurst-Chr, Bathurst-Mar and Bathurst-Bur for the 'hatched,
>matched and despatched' for that town or parish. This was a suggestion
from
>one of the listers, and I hope it helps everybody.
>I have also fixed the problem that was highlighted by Tessa and Lynn, in
>that the Witness's to a marriage we being shown against the incorrect
>marriage, one row out. I apologise if this caused any inconvenience. I
may
>have made other errors (I hope not), but remember you can always go back to
>Ellen's transcripts in the archives at
>http://archiver.rootsweb.com/th/index/south-africa-immigrants-british or
>even back to the original LDS film or actual Church records, to double
>check. I will not take offense if you do find other programmatical
errors!!
>
>I would also like to thank Heather for hosting the file, and Tessa for the
>beginners guide to Excel, below.
>
>Good Luck in your research
>
>Paul Tanner-Tremaine
>e-mail: mailto:
>Web page at http://www.tantrem.com/
>formerly in sunny Westville, Natal Coast, South Africa, now in
>Wokingham, Berkshire, UK.
>searching : AYLWARD; BOWKER; BRABBIN; MITFORD; MONKHOUSE; OSBALDESTON;
>PENN; IRISH; DAVID; HEYWOOD; PARKS and TANNER-TREMAINE, among others....
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>-----Original Message-----
>From: Tessa King [mailto:]
>Sent: 02 February 2003 07:43
>To:
>Subject: [ZA-IB] Paul's Excel Spreadsheet on Ellen's Transcripts
>
>
>Hi listers
>
>I think both Ellen and Paul deserve a huge hip, hip, hooray for all their
>hard work. This is definitely the best list to be on. If anyone has gone
>into the Archives recently (thank you Becky for pointing us in that
>direction....it's amazing what you find after the fact) you will see how
>high the number of messages are for both this list and the South African
>one. Personally, I think it's due to all the very kind, generous and
>wonderful people who contribute to this list's success. Anyway,I digress.
>
>I just thought it may help listers who are unfamiliar with Excel if I
posted
>some tips on how to work in an Excel spreadsheet. I know it's a little off
>topic, but seeing as the new list has just been posted on Heather's site it
>may help folk to be able to use it more effectively. Excel makes it very
>easy to find the info you want within minutes, if you know how. I hope
>Heather doesn't mind :-) I am going to assume that those folks who need
this
>are totally unfamiliar with spreadsheets, so forgive me if I put it very
>simply!
>
>A. Changing the size of the columns in a worksheet:
>1. At the very top of the spreadsheet you will notice that each of the
>columns starting from left to right, has a heading i.e. A, B, C etc (there
>are 256 of them). The rows are numbered in a column down the left hand side
>of the spreadsheet i.e. 1, 2, 3 (some 65000 odd rows). Where the column and
>rows commence you will notice a blank block to the left of Col A and above
>Row 1.
>
>2. Click this empty block and the whole worksheet is highlighted.
>
>3. From the menu select Format>Columns>Auto fit selection. All the columns
>have now been sized to fit the data they contain.
>
>4. Should you wish to resize a single column, just move your mouse pointer
>over the dividing line in the column heading row, between the columns until
>the mouse pointer changes to a double line with arrows and then double
click
>your mouse. e.g. If you want to make Col C wider, move onto the dividing
>line between column C and D in the column heading row and follow the step.
>Or, once your mouse pointer has changed you can drag the column left or
>right to the size you require.
>
>5. Remember to save your changes!
>
>B. Sorting the data using the column headings in a worksheet (will need to
>be repeated for each worksheet in the workbook (spreadsheet):
>1. Position your mouse pointer in the row beneath the typed headings e.g.
>Cell A2 (each block is a cell and has an address which is derived from the
>column heading and the row number).
>
>2. From the menu select Data>Sort. The Sort dialog box appears. This
>contains three sort text boxes with drop-down list arrows which allow one
to
>select from the list of headings that are on this worksheet. Make sure that
>My list has a header row is selected.
>
>3. Click the first sort box. I am going to use a christening sheet as an
>example. From the list select Surname.
>
>4. Click the second one and select Parents Names.
>
>5. Click the third one and select Birth Date.
>
>6. Click OK. Your worksheet is sorted in this order. Remember to save your
>changes.
>
>You can sort using only one of the sort boxes or all three, or
>two....depends on what you sorting. If you use all three, Excel sorts by
the
>first parameter - surnames, then within each group of surnames it will sort
>the names of the parents and within each group of parents it will sort by
>birth date order. You may decide to sort marriages by husband's surname
only
>and then next time round by the wife's surname or the wedding date etc.
>Remember to clear unwanted headings from the second and third box if you
are
>only sorting using one parameter. Just think logically when sorting!
>
>C. Filter Data
>Filtering allows one to filter out information temporarily so that it is
>easier to work with your data. Each column heading will have a drop-down
>list added to it from which you can make choices. Remember this is only a
>temporary measure and can be turned on and off and data redisplayed once
you
>are finished working with the data.
>
>1. Make sure you are somewhere in the data i.e. Cell A2.
>
>2. From the menu select Data>Filter>Auto Filter. Drop down lists are added
>to each heading in the worksheet.
>
>3. If for example you want to see all the Cockcroft surnames, click the
drop
>down arrow next to the Surname heading and scroll through the list until
you
>come to Cockcroft. Select the name with a click of the mouse.
>
>4. Only the Cockcroft names will now be visible (you may have to move back
>to the top of the page depending on where your mouse pointer was when you
>started). The row headings are now blue to show you that you looking at
>filtered data. You can now work with this data while the rest of the data
is
>hidden from view.
>
>5. To display all the records you simply click the drop down arrow on the
>heading you used to filter the data, scroll up to the top and select All.
Or
>you can use the menu and select Data>Filter>Show All.
>
>Here endeth the lesson!! Hope this helps those of you who are not familiar
>with Excel.
>
>Enjoy your day and using Excel.
>Tessa
>
>______________________________
>
>
>==== SOUTH-AFRICA Mailing List ====
>-------------------------------------------------------------------
>Try Cyndi's List for all the genealogical links you will ever need:
>http://www.CyndisList.com/
>

This thread: