GenMassachusetts-L ArchivesArchiver > GenMassachusetts > 2001-01 > 0979939401
From: "Gary ." <>
Subject: [GM-L] U.S. Census Spreadsheet Available
Date: Fri, 19 Jan 2001 21:23:21 -0000
I have created an Excel 97 spreadsheet which I an using to record all of my
census data that I have on paper. I like having electronic copies of
records for ease of manipulation, transport and backup. The spreadsheet
would also be very useful for those of you who take a laptop to your local
FHC for data entry.
The spreadsheet is bare except for the formatting on each page to match the
particular census year data fields. No actual census data is included.
I used Excel 97 to create the spreadsheet and I kept it simple so it should
be compatible with most any recent spreadsheet software out there. One
lesson learned so far. Excel 97 uses multiple worksheets, like pages of a
book. Previous versions of Excel did not support sheets. You will need a
spreadsheet program as least as recent as Excel 97. I have tried opening my
spreadsheet with my copy of MS Works 5 and it does not work. I don't know
about Works 6. I have received reports that Quattro Pro 8 works great.
The spreadsheet has a separate page for each census year from 1790-1920, as
well as Soundex pages for 1880-1920...great for tracking a single family
through the years.
Most of the pages will print on standard 8.5" x 11" paper. To get 1880-1920
to fit though I had to format in 8.5" x 14". Being able to print though was
not really the point of the spreadsheet though since I already have my data
I have also typed up a short text file detailing the page set-up parameters
for each spreadsheet page for ease of printing.
I plan to make a separate copy of the spreadsheet for each family branch
that I have census data for. That way I can document a particular family
over 130 years in a single spreadsheet. I'm sure there are other possible
uses for the imaginative out there.
One person commented that the spreadsheet provides a very professional
appearing output for use in a family history publication. I'll file that
There's nothing fancy about how I created the spreadsheet...no macros etc.
So it would be easy to change the layout to suit your particular needs.
The spreadsheet is 108Kb and compresses to a 19Kb zip file. The
accompanying text file is just 2Kb.
If you would like a copy of the spreadsheet just drop me an e-mail and let
me know whether you want it as a zip file or uncompressed. Please don't
post a request to this list as they tend to get lost in the shuffle.
I have posted this offer on 4 other lists and the response has been amazing.
I've sent out over 400 copies and those who have used the spreadsheet so
far have been unanimous in their favorable comments. I have been helped
countless times on various lists by people generous with their time and
expertise. I'm happy to pay back those kindnesses in this small way.
----Original Message Follows----
Subject: Re: subscribe
Date: Fri, 19 Jan 2001 06:58:12 -0800
Received: from [184.108.40.206] by hotmail.com (3.2) with ESMTP id
MHotMailBC31A10600BBD820F3B43F5C507B07C40; Fri Jan 19 06:58:14 2001
Received: (from )by lists5.rootsweb.com (8.10.1/8.10.1) id
f0JEwCC17073for ; Fri, 19 Jan 2001 06:58:12 -0800
>From Fri Jan 19 06:59:05 2001
You have added to the subscriber list of:
the following mail address:
By default, copies of your own submissions will be returned.
Welcome to the GenMassachusetts mailing list! You are currently subscribed
"digest mode", which means that several postings made
to GenMassachusetts will be consolidated together and sent to you as a
large message. The directions on how to change to mail mode (where
you receive every message as a separate e-mail) are given below.
1. How to unsubscribe. Send a message to
that contains (in the body of the message) the command
and no additional text.
2. How to subscribe. Whatever you just did worked, or you'd
not be getting this message. But for future reference (for instance,
if your subscription is cancelled for whatever reason and you
want to resubscribe), just send the command "subscribe" to
3. How to change to mail mode (each posting is sent to you as a
separate e-mail). There are two steps. First, send the command
"unsubscribe" to to discontinue
mode. Second, send the command "subscribe" to
to start receiving individual
4. How to change to NOMAIL mode. There is no formal NOMAIL mode.
All you have to do is follow the directions above and unsubscribe
when you want the messages to stop, and then when you want them
to start again, simply subscribe again.
5. If you'd like to post a message so everyone on the mailing
list receives it, just send it to . It
will then be sent on to everyone in both mail and digest mode.
You don't need to send it explicitly to both.
For your verification, a transcript of the original subscription
request is included below.
>From Fri Jan 19 06:58:11 2001
>Received: from newmail.rootsweb.com (newmail.rootsweb.com [220.127.116.11])
>by lists5.rootsweb.com (8.10.1/8.10.1) with ESMTP id f0JEwBq17042
>for <>; Fri, 19 Jan 2001
>Received: from hotmail.com (f224.law3.hotmail.com [18.104.22.168])
>by newmail.rootsweb.com (8.11.1/8.11.1) with ESMTP id f0JEwBD09982;
>Fri, 19 Jan 2001 06:58:12 -0800
>Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
> Fri, 19 Jan 2001 06:58:08 -0800
>Received: from 22.214.171.124 by lw3fd.law3.hotmail.msn.com with
HTTP;Fri, 19 Jan 2001 14:58:08 GMT
>From: "Gary ." <>
>Date: Fri, 19 Jan 2001 14:58:08 -0000
>Content-Type: text/plain; format=flowed
>X-OriginalArrivalTime: 19 Jan 2001 14:58:08.0435 (UTC)
>Get your FREE download of MSN Explorer at http://explorer.msn.com
Get your FREE download of MSN Explorer at http://explorer.msn.com
|[GM-L] U.S. Census Spreadsheet Available by "Gary ." <>|