<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>rootsworks.com</title>
	<atom:link href="http://rootsworks.com/blog/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://rootsworks.com/blog</link>
	<description>Beau</description>
	<lastBuildDate>Wed, 12 May 2010 19:15:53 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9.2</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<item>
		<title>Speaking Schedule, 2010</title>
		<link>http://rootsworks.com/blog/?p=30</link>
		<comments>http://rootsworks.com/blog/?p=30#comments</comments>
		<pubDate>Wed, 12 May 2010 16:00:17 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Genealogy News]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=30</guid>
		<description><![CDATA[I make a number of public appearances each year, to give talks about technology topics in genealogy. Here is my speaking schedule for 2010, and a list of conferences that I will attend. If you&#8217;d like to meet at any of these events, just let me know. If you&#8217;d like to know when I&#8217;ll be [...]]]></description>
			<content:encoded><![CDATA[<p>I make a number of public appearances each year, to give talks about technology topics in genealogy. Here is my speaking schedule for 2010, and a list of conferences that I will attend. If you&#8217;d like to meet at any of these events, just let me know. If you&#8217;d like to know when I&#8217;ll be out of town so you can plunder my house, please pick someone else.</p>
<p><img style="border-top-width: 1px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; border-top-style: dotted; border-top-color: #cccccc; display: block; width: 492px; height: 12px; margin-top: 15px; background-image: url(http://rootsworks.com/blog/wp-includes/js/tinymce/plugins/wordpress/img/more_bug.gif); background-repeat: no-repeat; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: #ffffff; background-position: 100% 0%;" title="More..." src="http://rootsworks.com/blog/wp-includes/js/tinymce/plugins/wordpress/img/trans.gif" alt="" /></p>
<p>JANUARY</p>
<p>FEBRUARY</p>
<p>26-27 St George, UT. Talks on Unofficial Footnote Blog, and RootsWorks: Family Photos.</p>
<p>27 Fairfax VA (skype). Footnote workshop. (Yes, with the internet, you can be two places at once).</p>
<p>MARCH</p>
<p>APRIL</p>
<p>26-27 Salt Lake City UT. Brigham Young University’s Conference on Computerized Family History and Genealogy. Talks on Amazing Stories from Rev War pensions, Newspapers, City Directories, and other original records online. (moved from 12-13 Mar in Provo).</p>
<p>MAY</p>
<p>JUNE</p>
<p>25-26 Loveland CO. <a title="FH Expo" href="http://www.fhexpos.com/expos/" target="_blank">Family History Expo</a>. Talks on Automated Search Tools, a Legacy demo, and a recollection of stories about the early days of Footnote. Oh, and a keynote talk on trying to explain genealogy to the rest of your family.</p>
<p>JULY</p>
<p>AUGUST</p>
<p>27-28 Sandy UT. <a title="FH Expo" href="http://www.fhexpos.com/expos/" target="_blank">Family History Expo</a>.</p>
<p>SEPTEMBER</p>
<p>OCTOBER</p>
<p>8-9 Pleasanton CA. <a title="FH Expo" href="http://www.fhexpos.com/expos/" target="_blank">Family History Expo</a>.<br />
17  Las Vegas, NV. <a title="JSSSN" href="http://www.jewishgen.org/jgs/jgs-southernnevada/" target="_blank">Jewish Genealogy Society of Southern Nevada</a>.</p>
<p>NOVEMBER</p>
<p>12-13 Atlanta GA. <a title="FH Expo" href="http://www.fhexpos.com/expos/" target="_blank">Family History Expo</a>.</p>
<p>DECEMBER</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=30</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>More lost words</title>
		<link>http://rootsworks.com/blog/?p=120</link>
		<comments>http://rootsworks.com/blog/?p=120#comments</comments>
		<pubDate>Thu, 04 Mar 2010 19:22:16 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=120</guid>
		<description><![CDATA[Old words are words that people once used, and no longer do. As I learn them, they become new old words. These are not to be confused with words that were never used by anyone, such as the late George Carlin&#8217;s example, &#8220;Would you please saw my legs off.&#8221; Here are some old words that [...]]]></description>
			<content:encoded><![CDATA[<p>Old words are words that people once used, and no longer do. As I learn them, they become new old words. These are not to be confused with words that were never used by anyone, such as the late George Carlin&#8217;s example, &#8220;Would you please saw my legs off.&#8221; Here are some old words that are new to me.</p>
<p>Felloe. This refers to a circular rim, such as the part of a wagon wheel, to which spokes are attached. A metal rim might go around the outside of the felloe. I find references in the 1800&#8217;s to people whose occupation is &#8220;felloe-maker&#8221; and &#8220;felloe-bender.&#8221;</p>
<p>Gutta percha. This is a form of natural rubber (chemically different from natural rubber, but having similar properties) introduced to the west in 1843. It came from trees, like rubber does. I find these occupational variations:</p>
<ul>
<li>foreman gutta percha</li>
<li>gutta percha</li>
<li>gutta percha carriage cloths</li>
<li>gutta percha worker</li>
<li>gutta percha works</li>
<li>gutta perscha worker</li>
</ul>
<p>It was popular enough that they made golf balls out of it.</p>
<p>Puddler. These workers use the Welsh method to convert pig iron into wrought iron by puddling &#8211; or melting the iron. Think of them as metalworkers, like steelworkers in the 1950&#8217;s.</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=120</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Interesting Occupations &#8211; San Francisco 1850</title>
		<link>http://rootsworks.com/blog/?p=118</link>
		<comments>http://rootsworks.com/blog/?p=118#comments</comments>
		<pubDate>Fri, 15 Jan 2010 02:11:18 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=118</guid>
		<description><![CDATA[A year after gold was found at Sutter&#8217;s Mill, San Francisco &#8220;public crier&#8221; Charles Kimball published a city directory. I found some interesting occupations in it.

Beer man. They hadn&#8217;t even invented pro baseball leagues, but SF had a beer man. Well, several. I think it is short for &#8220;beer manufacturer.&#8221; But it&#8217;s a great job [...]]]></description>
			<content:encoded><![CDATA[<p>A year after gold was found at Sutter&#8217;s Mill, San Francisco &#8220;public crier&#8221; Charles Kimball published a city directory. I found some interesting occupations in it.</p>
<ul>
<li>Beer man. They hadn&#8217;t even invented pro baseball leagues, but SF had a beer man. Well, several. I think it is short for &#8220;beer manufacturer.&#8221; But it&#8217;s a great job title.</li>
<li>Whitesmith. I&#8217;ve heard of blacksmiths, but a whitesmith? Turns out, the guys who work with the &#8220;white&#8221; metals, like tin, aluminum, and pewter, are called whitesmiths. Most of their work is done with cold metals, unlike their blacksmith buddies. If you have a pewter cup around the house, it might have come from a whitesmith.</li>
<li>Wm Light was a &#8220;billiard table.&#8221; I&#8217;m thinking that this is an imprecise description of his occupation.</li>
<li>Capt Edw King was a &#8220;boarding officer.&#8221; That&#8217;s something, an officer, a captain, and a king.</li>
<li>There were many bakers, but only Wm Hoar was a &#8220;cake baker.&#8221; Specialization rears its ugly head. J Joseph is a &#8220;soda cracker baker.&#8221;</li>
<li>Sam&#8217;l Price was a consul, for Chili. I think they mean the place we call Chile today, but a chili ambassador is a terrific job.</li>
<li>I&#8217;m not saying that they had mental issues, but there were dozens of counsellors. One Atty at law. Many Counsellors.</li>
<li>They had the normal mix of coopers, chandlers, and draughtsmen.</li>
<li>There were several daguerreotypists. I can&#8217;t even say the word. They took pictures.</li>
<li>Wharfinger. I like that. A guy that runs a wharf is a wharfinger. His helper, like H G Isaacs, would be a &#8220;deputy wharfinger.&#8221;</li>
<li>Philip Ramez and Thomas Watson are each occupied as a &#8220;gentleman.&#8221; I&#8217;m sure there were lots of roughmen, but they assume you know it already.</li>
<li>You might expect hair dressers, but Jame McGowan was a &#8220;hair braider.&#8221;</li>
<li>Chas Smith was a knickerbocker. I don&#8217;t know what one of these does. I can imagine the teasing his son must have endured on the playground.</li>
<li>I found almost a dozen guys listed as &#8220;lighterman.&#8221; I&#8217;m thinking that they light street lamps. Then again, there are &#8220;boatmen&#8221; and a lighter is a kind of boat. The lightermen never hang out with the tanners.</li>
<li>We have &#8220;mariner&#8221; and &#8220;master mariner.&#8221; There are also pilots, who must be specific: &#8220;outer harbor,&#8221; or &#8220;Sac and San Joaquin Rivers.&#8221;</li>
<li>A number of people referred to their profession as &#8220;refreshments.&#8221; That&#8217;s &#8230; refreshing.</li>
<li>Orrin Bailey was a &#8220;scrivener.&#8221; If you have a scrivener, a sadler, and a shingler, you have the beginnings of a joke. &#8220;A scrivener, a sadler, and a shingler walked into a bar &#8230;&#8221;</li>
<li>I don&#8217;t know what you do if your occupation is &#8220;sporting.&#8221; I&#8217;m thinking &#8211; gambling? Big game hunting? Discus throw? Dart throwing?</li>
<li>Mark Palmer got nothing from Oz that he didn&#8217;t already have. Yes, he was the Tinman. I didn&#8217;t find a cowardly lion.</li>
<li>There were 3 artists, one woodcut engraver, 3 musicians (Andrew Truper couldn&#8217;t avoid the trade). I&#8217;m not sure whether a painter was an artist or not. I&#8217;m not sure whether golfers are athletes, either. I&#8217;m sure that dart throwing is not a sport. No dancers. No singers. There are personnel at the Dramatic Museum, but no one claiming to be an actor.</li>
<li>I saw two carpenters named Sawyer. I don&#8217;t believe in fate. None of the masons was named Mason.</li>
<li>Three men were &#8220;measurers.&#8221; Since all three worked at City Hall, it looks like political favoritism to me, and I&#8217;m skeptical about the veracity of their work. I got no idea what they measured.</li>
</ul>
<p>The more I learn about the past, the more I&#8217;m amazed that we&#8217;ve lasted this long. Today, I looked at hundreds of occupation names that real people had in San Francisco in 1850. The unexpected discovery is my favorite kind of learning. Some time I&#8217;ll dig up the occupation codes invented for the 1850 census, and we&#8217;ll see if we can have a laugh.</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=118</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Bells ring &#8211; bring a bible or a bucket?</title>
		<link>http://rootsworks.com/blog/?p=112</link>
		<comments>http://rootsworks.com/blog/?p=112#comments</comments>
		<pubDate>Tue, 05 Jan 2010 02:03:20 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=112</guid>
		<description><![CDATA[Google Books has some city directories. I found the one for San Francisco in 1850 interesting. You might recognize the date as being right on the heels of the discovery of gold in them thar hills.
I try to understand what life was like for people in other times. It requires some imagination, and some familiarity [...]]]></description>
			<content:encoded><![CDATA[<p>Google Books has some city directories. I found the one for <a title="San Francisco 1850" href="http://books.google.com/books?printsec=frontcover&amp;pg=PA130&amp;id=MU8OAQAAIAAJ#v=onepage&amp;q=&amp;f=false" target="_blank">San Francisco in 1850</a> interesting. You might recognize the date as being right on the heels of the discovery of gold in them thar hills.</p>
<p>I try to understand what life was like for people in other times. It requires some imagination, and some familiarity with the particulars. No electricity, no pavement, no cars &#8230; that means mud and horse manure in the streets. Geez, I don&#8217;t think they even had TRAINS in San Francisco in 1850. Here is the publisher&#8217;s preface, describing the challenges of creating a directory for that time and place:</p>
<p style="padding-left: 30px;">It is not to be expected, in a City like this, where whole Streets are built up in a week and whole Squares swept away in an hour—where the floating population numbers thousands and a large portion of the fixed inhabitants live in tents and places which cannot be described with any accuracy, that a Directory can be got up with the correctness that they are in older and more established cities. We have scarcely a house numbered, and what there are will puzzle quite as much as assist.</p>
<p>The &#8220;floating population?&#8221; I can imagine lots of people living in ships and boats at the time. It&#8217;s a vivid image.</p>
<p style="padding-left: 30px;">The other subject is that of bell-ringing as it is now practiced for our churches. We have seen the whole congregation of a religious meeting start from their seats at the ringing of the bells of other churches, supposing it was for fire; and how are our firemen to know whether the bells are ringing to call them with all their powers, to fight the devouring flames, or,with their most devotional feelings, to attend a prayer meeting. How widely different the objects, yet the same summons, put forth in the same manner, calls them to both. This is certainly wrong, and we think our City Council should make it the duty of bell-ringers, in all cases of business or for Church, to set the bells at regular intervals, as they do in the Atlantic cities.</p>
<p>I don&#8217;t hear much public bell-ringing, beyond that Big-Ben-type quarter-hour thing that we used to have at A&amp;M. In modern life, we don&#8217;t empathize with bell-ringing related issues. Outside of Quasimodo, most people can&#8217;t name a bell-ringer. But if we&#8217;re going to live in close proximity, we&#8217;re going to need some rules. Someone is going to have to decide whether we pass on the right or the left. Someone is going to have to set the clocks. That someone is all of us, in the persons of governmental officials.</p>
<p>Fires and fire alarms have been a constant subject for people. There hasn&#8217;t been a &#8220;great fire&#8221; in over 100 years in the US, and we can lose sight of it. Recently, a fire destroyed many documents at the Indiana Historical Society. We all know that the past was different from the present. This book has a couple of vivid examples.</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=112</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>1869 SLC Directory &#8211; Chronological Events of Utah</title>
		<link>http://rootsworks.com/blog/?p=98</link>
		<comments>http://rootsworks.com/blog/?p=98#comments</comments>
		<pubDate>Sat, 26 Dec 2009 14:00:05 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[City Directories]]></category>
		<category><![CDATA[RootsWorks]]></category>
		<category><![CDATA[Fremont]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=98</guid>
		<description><![CDATA[The 1869 City Directory of Salt Lake City contains, in the front matter, the following chronological history of Utah.

NOTE: This is not intended to be the definitive history of the Utah Territory, or even represented as an objective view of the events of 1847-1868. It&#8217;s just what was published in 1869 &#8211; a historical view [...]]]></description>
			<content:encoded><![CDATA[<p>The 1869 City Directory of Salt Lake City contains, in the front matter, the following chronological history of Utah.</p>
<p><span id="more-98"></span></p>
<div id="attachment_102" class="wp-caption aligncenter" style="width: 694px"><a href="http://rootsworks.com/blog/wp-content/uploads/2009/12/SLC-1869-image.jpg"><img class="size-full wp-image-102" title="SLC 1869 image" src="http://rootsworks.com/blog/wp-content/uploads/2009/12/SLC-1869-image.jpg" alt="" width="684" height="745" /></a><p class="wp-caption-text">Salt Lake City, Utah. 1869.</p></div>
<p><em>NOTE: This is not intended to be the definitive history of the Utah Territory, or even represented as an objective view of the events of 1847-1868. It&#8217;s just what was published in 1869 &#8211; a historical view of history. </em></p>
<p><em>I&#8217;ve tried to extract the text accurately. If you see typographical errors, notify me, and I&#8217;ll correct them if I can.  - Beau</em></p>
<p><em><br />
</em></p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=98</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>1869 Salt Lake City (UT) Directory &#8211; &#8220;Sketch of Mormonism&#8221;</title>
		<link>http://rootsworks.com/blog/?p=93</link>
		<comments>http://rootsworks.com/blog/?p=93#comments</comments>
		<pubDate>Thu, 24 Dec 2009 23:10:03 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=93</guid>
		<description><![CDATA[One of my favorite sources for genealogical and historical research is the City Directory. If you&#8217;ve not seen one, they are the precursors to the phone book &#8211; only without the phone numbers.
City Directories have more than just names in them. In many ways, they contain unique information about the cultural heritage of a place. [...]]]></description>
			<content:encoded><![CDATA[<p>One of my favorite sources for genealogical and historical research is the City Directory. If you&#8217;ve not seen one, they are the precursors to the phone book &#8211; only without the phone numbers.</p>
<p>City Directories have more than just names in them. In many ways, they contain unique information about the cultural heritage of a place. The 1869 Salt Lake City directory was published by Edwards &amp; Co of Chicago IL. After the classified listings in the back of the book, they included a great deal of history and many ads from the Chicago directory &#8211; but that&#8217;s a story for another day. This story is a &#8220;Sketch of Mormonism.&#8221;</p>
<p>I am not a member of the LDS Church. Many of my friends and colleagues are. Is it for their enjoyment that I extract this pearl. History changes, over time. Here&#8217;s a look backward, from the vantage point of 1869, at the founding of the LDS church.</p>
<p>With no further editorial comment, and with apologies in advance for typographical errors, I offer the following historical note.</p>
<p><span id="more-93"></span></p>
<p>SKETCH OF MORMONISM</p>
<p>Joseph Smith, the founder of the organization, was born in Sharon, Windsor county, Vermont, December 23d, 1805. His father&#8217;s name was Joseph and his mother&#8217;s Lucy; and their family consisted of six sons and three daughters of whom the future prophet was the third Sod. When he was in his fourteenth year his father moved to Manchester, Ontario county, New York, having previously resided four years in Palmyra in the same county. While in Manchester, and during a religious revival, he was, as he states in his autobiography, the subject of religious impressions; during which, while praying in the woods one day, he had the first vision, two glorious personages appearing to him, who communed with him. Some three and a half years afterwards, on the 21st of September, 1823, he had a second vision and received a communication relative to the plates upon which the Book of Mormon was inscribed. These plates, his history states, he obtained possession of on the 22d of September, 1827, from the place of their deposit, on the west side of a hill convenient to Manchester, the village where he resided. The plates were enclosed in a box, covered with a stone, and had been there for some 1400 years, having been buried by an ancient inhabitant of this continent named Moroni. The characters on them had been principally inscribed by Mormon, hence the title of the work.</p>
<p>Being poor and with the work of translating the records before him, in his exigencies he obtained assistance from a gentleman named Martin Harris; and in April, 1829, he made the acquaintance of Oliver Cowdery, a school teacher, who became his amenuensis, and the work of translating commenced immediately. The Book of Mormons, was put in the hands of the printers; but before it was published a church was organized on the 6th day of April, 1830, in the house of Mr. Peter Whitmer, Fayette, Seneca county, New   York. Thus the Empire State not only produced the plates, from which the book was translated, but can claim the honor of the organization of that society which is the greatest problem of the century. Six members composed this church on its organization, a small beginning for the thousands into which it has grown and the power and influence acquired in the short space of thirty-eight years. The Book of Mormon was published, preaching and proselytizing were prosecuted with vigor, though the missionaries of the new faith were mostly uneducated, and churches were raised up in a number of places in a few months.</p>
<p>Early in 1831 a settlement was made at Kirtland,  Ohio, and this may be called the first &#8220;gathering place&#8221; of the church—a central point towards which all who received the faith should converge. In July of the same year a lot was selected and dedicated, for a Temple, at Independence, Jackson county, Missouri. Here a printing press was set .in operation and a periodical, the <em>Evening and Morning Star, </em>was published by Judge &#8220;W. W. Phelps. Trouble broke out at Independence, between the settlers of the new faith and others inhabiting that region, and a mob tore down the printing office, tarred and feathered some of the prominent Mormons, abused others, and inflicted losses on the fraternity, in the destruction of property, to a very large amount. The Mormons were obliged to leave, and most of them fled into and settled in Clay county, in the same state. The Jackson county mob influenced the citizens of Clay county, and after a time the refugees had again to leave, this time settling in unoccupied territory, which received the name of Caldwell county, as well as in Davis and other adjacent counties, in Missouri. In three years they, made wonderful improvements in their new location, for industry has ever been a prominent characteristic of the  organization. At this time they were viewed with suspicion by many pro-slavery citizens there, who classed them as abolitionists, many of them having com from states where the abolition theory was gaining ground. For this cause, and because their industrious habits conflicted with the dissipated customs of a class always too well known in frontier settlements, as well as for religious reasons, troubles again broke out and the entire Mormon community was compelled to leave the state. Their next settlement was at Commerce, Hancock county, Illinois, where in a short time they built the city of Nauvoo, which was duly chartered by the state Legislature. They had built a temple at Kirtland, which was an immense effort in its size and costliness for so small and poor a body of people as they then were. But in Nauvoo one was commenced on a scale proportionately greater to correspond with their increased numbers, wealth and importance. This they finished, but before it was completed, their Prophet, Joseph Smith, and his brother Hyrum Smith, the Patriarch of the Church, were murdered in Carthage, where they were imprisoned on a charge of treason. The Missouri enemies of the prophet and his followers, had never ceased their efforts against him and his people, preferring charge after charge which were disposed of by the courts, he always obtained an acquittal; until this last charge, when the mob would not wait for the result of a trial, but shot him and his brother dead while in prison under guard, wounding at the same time Elder John Taylor, one of the Twelve Apostles. They held Governor Ford&#8217;s pledge for their safety at the time. This was on the 27th of June, 1844.</p>
<p>Soon after the Mormons were compelled to leave Illinois, and took up their line of march in February, 1846, for the then almost unknown west. That Fall and Winter the main body of the refugee Saints located in the neighborhood of the Missouri River, near what is now Council  Bluffs and Omaha, where temporary settlements were formed. Next Spring, President Brigham Young started westward with 143 pioneers, broke a road, forded streams and built bridges from the Missouri over the great plains and through the Rocky Mountains, arriving in Salt Lake Valley on the 21st of July, 1847. As soon after as possible the main body followed, a provisional State government was formed, gentlemen were sent to Washington to represent the new colony; and in 1849 a Territorial government was granted to them for the Territory  of Utah. Since that time they have prospered exceedingly; their cities, towns and settlement» number about two hundred with a population of nearly 150,000 souls. Besides these there are branches of the Church in many parts of the United States; and in Europe the communicants of the faith number nearly 20,000. Their missionary efforts have been directed to every country where religious toleration would permit them to carry and disseminate their views. Most European and some Asiatic nations, as well as Australia and several of the Pacific Islands, have given proselytes to the faith; and almost all the old members of the Church are native born citizens of the Union, which still adds largely to the believers in the latter.day dispensation.</p>
<p>The Church is organized with a First Presidency of three; a Council of Twelve Apostles; a Patriarch; a quorum of High Priests of indefinite number; sixty-four quorums of Seventies; an Elders&#8217; Quorum; a Presidency of three and a High Council of twelve for each Stake of Zion; a Presiding Bishop for the Church with two Counselors; a Bishop for each Ward; a Priests&#8217; quorum; a Teachers&#8217; quorum; and a Deacons&#8217; quorum.</p>
<p>The present authorities of the Church are:</p>
<ul>
<li>Brigham Young, President; George A. Smith his first and Daniel H. Wells his second counselor.</li>
<li>Orson Hyde, President of the Quorum of the Twelve Apostles, and Orson Pratt, Sr., John Taylor, Wilford Woodruff, Ezra T. Benson, Charles C. Rich, Lorenzo Snow, Erastus Snow, Franklin D. Richards, George Q. Cannon, Joseph F. Smith and Brigham Young, Jr., members.</li>
<li>John Smith, Patriarch.</li>
<li>John Young, President of the High Priests&#8217; Quorum; Edwin D. Wooley and Samuel W. Richards counselors.</li>
<li>Joseph Young, President of the first seven Presidents of the Seventies, and Levi W. Hancock, Henry Harriman, Albert P. Rockwood, Horace S. Eldredge, Jacob Gates, and John Van Cott, members of the first seven Presidents of the Seventies.</li>
<li>Edward Hunter, Presiding Bishop, Leonard W. Hardy and Jeese C. Little, his counselors.</li>
<li>George A. Smith, Historian and general Church Recorder, and Wilford Woodruff, assistant.</li>
</ul>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=93</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Please enter a valid name</title>
		<link>http://rootsworks.com/blog/?p=89</link>
		<comments>http://rootsworks.com/blog/?p=89#comments</comments>
		<pubDate>Sun, 20 Dec 2009 17:39:39 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Product News]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=89</guid>
		<description><![CDATA[Has this ever happened to you?
I was at the Newspaper Archives site, looking at the home page. There&#8217;s a search box there, as you can see from the picture below.

It&#8217;s a nice looking home page. Not too cluttered, cool photos, clearly labeled functions. I tried to search for my last name. The small box says [...]]]></description>
			<content:encoded><![CDATA[<p>Has this ever happened to you?</p>
<p>I was at the Newspaper Archives site, looking at the home page. There&#8217;s a search box there, as you can see from the picture below.</p>
<div id="attachment_90" class="wp-caption aligncenter" style="width: 310px"><img class="size-medium wp-image-90" title="newspaper archives valid last name" src="http://rootsworks.com/blog/wp-content/uploads/2009/12/newspaper-archives-valid-last-name-300x257.jpg" alt="owwww" width="300" height="257" /><p class="wp-caption-text">owwww</p></div>
<p><span id="more-89"></span></p>
<p>It&#8217;s a nice looking home page. Not too cluttered, cool photos, clearly labeled functions. I tried to search for my last name. The small box says &#8230;. &#8220;Please enter a valid last name and (optional) first name.&#8221; Well, I didn&#8217;t know which Sharbroughs, if any, would be in the index, so I entered my last name and no first name. It&#8217;s optional, right? Here&#8217;s what I got.</p>
<p><img class="aligncenter size-full wp-image-91" title="newspaper archives valid last name" src="http://rootsworks.com/blog/wp-content/uploads/2009/12/newspaper-archives-valid-last-name1.jpg" alt="newspaper archives valid last name" width="984" height="844" /></p>
<p>I think that they are either saying 1) that my name is not valid; or 2) that the word &#8220;optional&#8221; has a different meaning than I have previously understood.</p>
<p>Either way, when a site behaves this way, I assume that the people who make it don&#8217;t want me to use the site. I oblige them.</p>
<p>I hope that you have better luck than I did.</p>
<p>Oh, and did you hear that World Vital Records is promoting NewsPaper archives? Notice that Newspaper Archives is going for about $12 for a monthly, and about $60 for a yearly (billed monthly). World Vital Records is offering a year of both for $71.88. I&#8217;m not sure about the tag line, &#8220;This is the lowest price you will ever find.&#8221; I can think of 7,187 lower prices.</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=89</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Beyond the Free Census</title>
		<link>http://rootsworks.com/blog/?p=82</link>
		<comments>http://rootsworks.com/blog/?p=82#comments</comments>
		<pubDate>Mon, 07 Dec 2009 15:00:04 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=82</guid>
		<description><![CDATA[There has been much discussion of late, centered around the coming day when there is a complete, free collection of US census records online. I have expressed the belief that researchers and publishers should be discussing what records they would like to have next. Today, I&#8217;d like to suggest a few ways that publishers could [...]]]></description>
			<content:encoded><![CDATA[<p>There has been much discussion of late, centered around the coming day when there is a complete, free collection of US census records online. I have expressed the belief that researchers and publishers should be discussing what records they would like to have next. Today, I&#8217;d like to suggest a few ways that publishers could improve on a complete, free census.</p>
<p><span id="more-82"></span></p>
<h2>1. More input!</h2>
<p>Online census collections consist of a searchable index with links to images of the original microfilm. Those indexes are a partial transcription of the records, often containing the name, age, state of birth, house number, relationship to head of household; and some fields related to the page, such as state, county, enumeration district, page number, and microfilm roll number. This makes it easier to find records. However, if you are researching a common name in a heavily populated area, you will wish for more information.</p>
<p>The information available varies with each census year. It is common to find additional information, which is of great value to genealogists, such as:</p>
<ul>
<li>Number of years married. Lets you estimate a marriage year.</li>
<li>Number of children that a parent has. Since some of the children move out of the house when they get older, it&#8217;s helpful to know this.</li>
<li>If naturalized.</li>
<li>Year naturalized.</li>
<li>Birth state or country (this is indexed as often as not).</li>
<li>Occupation. One researcher told me that she found her guy several states away from the place she expected by searching on a surname and occupation.</li>
<li>Parents birth places.</li>
<li>Language spoken.</li>
</ul>
<p>This is not meant to be an exhaustive list, but to suggest that not all census collections are alike. Researchers may find that they want to pay for access to collections having features which are not available in a free version.</p>
<p>The reasons that the indexes are not complete transcriptions are valid ones. Computers can&#8217;t read handwritten records. Publishers have to pay people to read the images and key the fields. This is expensive, often costing ten times as much as scanning the microfilm.</p>
<h2>2. Where was that?</h2>
<p>Beginning with the 1880 census, the leftmost columns contain the heading &#8220;In cities.&#8221; The street name and street number are included for city residents. This is known, in modern times, as a street address. Having the street address opens up a world of geo-coded information possibilities, including maps and satellite images. Experienced researchers often identify churches and saloons located near the homes and workplaces of research subjects, for example. Or, you might want to know the route to the nearest school.</p>
<p>If you knew that your ancestor had the same address in 1880 and 1900, wouldn&#8217;t you think you had a good shot at reconstructing an 1890 census record for them?</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=82</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>OPINION: Where are we going?</title>
		<link>http://rootsworks.com/blog/?p=79</link>
		<comments>http://rootsworks.com/blog/?p=79#comments</comments>
		<pubDate>Thu, 03 Dec 2009 15:03:48 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=79</guid>
		<description><![CDATA[What will a post-Census online genealogy research world look like?
Genealogy has been propelled to new heights during the past decade, by the availability of digital databases such as those found on Ancestry.com and Genealogy.com. In my view, this industry is maturing, as evidenced by the wide availability of US census and UK census collections.
Not only [...]]]></description>
			<content:encoded><![CDATA[<h2>What will a post-Census online genealogy research world look like?</h2>
<p>Genealogy has been propelled to new heights during the past decade, by the availability of digital databases such as those found on Ancestry.com and Genealogy.com. In my view, this industry is maturing, as evidenced by the wide availability of US census and UK census collections.</p>
<p>Not only does Ancestry.com have a full US census collection. So does Heritage Quest (only available through libraries). Footnote has published 1860 and 1930. I recently saw most of the censuses between 1850 and1900 on FamilySearch.org, with images linked. The fee to access this information on that site is &#8230; free.</p>
<p>Ancestry&#8217;s recent IPO has apparently resulted in some &#8220;me too&#8221; decisions by companies to create similar sites. Footnote has announced that they will complete the US census. Other companies are quietly working on digitizing census records. To the genealogy researcher, the impact is that the prices will fall, until it gets all the way down to &#8230; free.</p>
<p>And what will happen then? Large genealogy publishers will not want to close up shop. They will need to publish something else. There is a significant amount of immigration and military record data going online.</p>
<p>The titles that publishers digitize fit into two broad categories. Some of them, like census records and civil war pensions, are complete collections in one place. These records have a single records custodian, such as the National Archives. Others, like gravestones, are fragmented, located in dozens, hundreds, or thousands of places. There are many records custodians.</p>
<p>The challenge for publishers is that they are rapidly approaching the point where all of the &#8220;complete collections&#8221; for markets like the US and UK are online, and the day that they&#8217;ll be free is clearly coming. They have little choice but to go forward with fragmented titles.</p>
<p>American researchers have been somewhat spoiled by the availability of Ancestry&#8217;s census collection. One web site. Every record. In the UK, it was split over four sites, until recently, when Find My Past completed a UK census collection. UK researchers can counsel their american colleagues about what happens next.</p>
<p>I&#8217;ll speculate about three kinds of fragmented US records that I think will be increasingly available: vital records, gravestones, and historical newspapers.</p>
<p>Vital records are kept by the states. This creates increased complexity for publishers, because the rights and the media come from 50 places, instead of one. The truth is, it&#8217;s more complicated than that. In some states, the counties are the records custodians. And with states such as Massachusetts, the state only has records after a certain date, and there are unique collections of records in many towns. There is no central index of vital records for the US. That&#8217;s one of the attractions of the census &#8211; it&#8217;s an implied birth record, by showing the child with the parents, and the age of the child at a certain date. There is a nice index of deaths in the SSDI, but it has very few entries for deaths before 1962, and many people did not participate in social security (such as state employees like teachers, and federal employees like &#8230; social security workers!).</p>
<p>Gravestones are about as fragmented as a collection of records can be. They are literally all over the US. Many sites, both paid and free of fees, contain some gravestones. There is no centralized index of gravestones. They make a good vital record, often containing information about birth dates, death dates, and even names of relatives.</p>
<p>Newspapers were once the primary means of distributing and receiving news, and there were many more newspapers in the past than there are today. Some of them have been lost. Some of them are in the hands of large publishers today, such as Gannet or Hearst. Many have been collected by NewsBank, and are available to genealogy researchers through GenealogyBank.</p>
<p>There are two kinds of problems with creating a central index over fragmented records. While the first is to achieve any degree of thoroughness, the other is to achieve a degree of consistency. Not all vital records contain the same information. Many existing databases contain partial information extracted from the records, and the parts in one database are not the same parts as are in others.</p>
<p>The same is true of gravestone databases available today.</p>
<p>And newspapers? For the most part, newspapers are OCR&#8217;d as a large &#8220;text blob&#8221; for each page. If you search for &#8220;Brown&#8221; you will find that the word is used in many contexts, and most of them are not as a family name. If you&#8217;re lucky enough to be a Sharbrough, your searches that turn up exact hits are always interesting, but if the OCR quality or the spelling isn&#8217;t just right, you will be unable to locate the articles you like. In short, current newspaper processing methods don&#8217;t identify name parts, date parts, connections between persons and employers, and the like.</p>
<p>There is a great deal of useful genealogical information left for publishers to sell us. At present, it would seem that they have a difficult decision to make. Perhaps it would be helpful if researchers could tell publishers more about what kinds of records they want most, and in what format they want to find, organize, and share them.</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=79</wfw:commentRss>
		<slash:comments>3</slash:comments>
		</item>
		<item>
		<title>RootsWorks: Spreadsheet Basics</title>
		<link>http://rootsworks.com/blog/?p=74</link>
		<comments>http://rootsworks.com/blog/?p=74#comments</comments>
		<pubDate>Thu, 12 Nov 2009 16:00:31 +0000</pubDate>
		<dc:creator>sharbrough</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://rootsworks.com/blog/?p=74</guid>
		<description><![CDATA[Originally published 07-Mar-2001 in the Ancestry Daily News [link]
This series of Spreadsheet articles is supported by material found here [link]
RootsWorks: Spreadsheet Basics
A lot of the information we come across just doesn&#8217;t line up neatly into rows and columns. Intuition tells us we can&#8217;t put our records into spreadsheets. Practice, on the other hand, has shown [...]]]></description>
			<content:encoded><![CDATA[<p>Originally published 07-Mar-2001 in the Ancestry Daily News [<a title="Spreadsheet Basics" href="http://www.ancestry.com/learn/library/article.aspx?article=3503" target="_blank">link</a>]<br />
This series of Spreadsheet articles is supported by material found here [<a title="Supporting pages" href="http://rootsworks.com/excelforgenealogists/excellinks.htm" target="_blank">link</a>]</p>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">RootsWorks: Spreadsheet Basics</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">A lot of the information we come across just doesn&#8217;t line up neatly into rows and columns. Intuition tells us we can&#8217;t put our records into spreadsheets. Practice, on the other hand, has shown that putting our records into rows and columns is great for two reasons: (1) it helps us see what&#8217;s missing, and (2) it helps us understand what&#8217;s there! Most people have a spreadsheet programs on their computers, and it&#8217;s time to put these programs to work on our family history mysteries.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">What Is It?</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Spreadsheets are not new. We&#8217;ve had them as long as we&#8217;ve had ledger paper. I remember using four-, 10-, and 20-column paper. It was a useful tool for lining up numbers, but it couldn&#8217;t automatically update the ledger when I changed one of the numbers.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Electronic spreadsheets simulate ledger paper. They contain words, numbers, and formulas—arranged in rows and columns. Typically, a spreadsheet is a list of similar items, with each row representing a particular item and each column representing some particular characteristic of those items.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">For example, if your family history program can export a report to a spreadsheet, you might make a list of names, birth dates, birthplaces, death dates, and death places. The spreadsheet would lay the information out so that each row represented a person in your report and each column represented, say, the person&#8217;s name, birth date, or death information. If your data is like mine, some entries are missing.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Name Two of Them</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">There are three popular electronic spreadsheets: Microsoft Excel, Lotus 1-2-3, and Corel&#8217;s Quattro Pro. They can all read each other&#8217;s files, and they perform the same basic functions. I&#8217;m partial to Excel, because I use Microsoft Access a lot, and Excel works well with Access.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">When It Works, What Does It Do?</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">As I mentioned above, spreadsheets can be really useful in several ways. I want to focus on the basics at this time. In each cell of a worksheet, you will find a word, a number, or a formula. Formulas give worksheets power because they can easily be copied to produce effective lists of numbers. Then, when the information has been entered, it can be sorted in ways that make it easier to spot missing data and clean up data that is clearly wrong, such as two-digit numbers in a column that is supposed to hold years.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">What&#8217;s the Downside?</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">I don&#8217;t see a down side to improving one&#8217;s skills with spreadsheets, but there are a couple of things to warn you about. One is that you should learn the &#8220;Save&#8221; and &#8220;Save As&#8221; functions first. I really don&#8217;t like to hear that people have lost an hour&#8217;s worth of work because they did not save their file. I also don&#8217;t like it when I change a worksheet and then save it over the original accidentally. You won&#8217;t need to make these mistakes many times before you master these two processes.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Another is learning how to copy formulas. If you learn a few of the basics, you can avoid having to retype formulas—you can simply copy them like the wind (but be careful not to ruin a trailer home).</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">How Do I Know If It&#8217;s Not Working?</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">I sometimes get the dreaded #NAME# as a formula result. That&#8217;s almost always a sign that I&#8217;ve attempted to perform an arithmetic function on a word. This is especially tricky when the value in the cell is a number, but it has a space or two in front of it and looks like a word. Spreadsheets see such entries as words and don&#8217;t perform arithmetic functions on them well.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">What If I Change Computers?</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">As a rule, you&#8217;ll want to reinstall the software and copy your data. You can easily copy your worksheets to a floppy disk or CD. Be sure to make copies so you can use them. And one caveat: If you make formulas that link to other worksheets, they will only work if the folder names and paths on the new computer are the same as on the old one (such as C:\My Documents\My Genealogy).</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">What&#8217;s the Genealogy Tie-in?</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Spreadsheets are excellent tools for tracking census information for a family across a number of censuses. They can also help you spot hidden patterns in some historical lists, if you gather information from multiple sources of records, such as church records, immigration records, and &#8220;old country&#8221; records.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Link Me Up (More stars is better)</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Techweb Encyclopedia</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">A definition of a spreadsheet</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Learning about Excel ****</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">A course from Furman University that you can read online.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Cyndi&#8217;s List &#8211; Forms ****</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Cyndi has a lot of forms links, and some of them are usable in Excel.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">What Else?</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Spreadsheets are the &#8220;baking soda&#8221; of computer programs; people put them to a variety of uses. Some people use them for graphics programs, some people use them for databases, and some people use them for electronic forms.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">One of my favorite capabilities is called &#8220;conditional formatting.&#8221; This is a feature that changes the format of a particular cell based on its content, or the relationship between the content and some other cell. With this function, it is possible, for example, to average a column of numbers and to display the numbers above the average in red and the numbers below the average in blue.</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">Beau Sharbrough is the president of GENTECH, the founder of the GENTECH and FGS Web sites, and a founder of the Lexicon Working Group. He would like to hear from you at beau@sharbrough.net, but due to the volume of e-mail received, he is unable to answer every e-mail message received. Please note that he cannot assist you with your individual computer problems. Visit Beau&#8217;s Web site for information about speaking engagements. Beau is the father of two college-age girls and is another insufferable graduate of Texas A&amp;M University.</div>
<h1>RootsWorks: Spreadsheet Basics</h1>
<p>A lot of the information we come across just doesn&#8217;t line up neatly into rows and columns. Intuition tells us we can&#8217;t put our records into spreadsheets. Practice, on the other hand, has shown that putting our records into rows and columns is great for two reasons: (1) it helps us see what&#8217;s missing, and (2) it helps us understand what&#8217;s there! Most people have a spreadsheet programs on their computers, and it&#8217;s time to put these programs to work on our family history mysteries.</p>
<p><span id="more-74"></span></p>
<h2>What Is It?</h2>
<p>Spreadsheets are not new. We&#8217;ve had them as long as we&#8217;ve had ledger paper. I remember using four-, 10-, and 20-column paper. It was a useful tool for lining up numbers, but it couldn&#8217;t automatically update the ledger when I changed one of the numbers.</p>
<p>Electronic spreadsheets simulate ledger paper. They contain words, numbers, and formulas—arranged in rows and columns. Typically, a spreadsheet is a list of similar items, with each row representing a particular item and each column representing some particular characteristic of those items.</p>
<p>For example, if your family history program can export a report to a spreadsheet, you might make a list of names, birth dates, birthplaces, death dates, and death places. The spreadsheet would lay the information out so that each row represented a person in your report and each column represented, say, the person&#8217;s name, birth date, or death information. If your data is like mine, some entries are missing.</p>
<h2>Name Two of Them</h2>
<p>There are three popular electronic spreadsheets: Microsoft Excel, Lotus 1-2-3, and Corel&#8217;s Quattro Pro. They can all read each other&#8217;s files, and they perform the same basic functions. I&#8217;m partial to Excel, because I use Microsoft Access a lot, and Excel works well with Access.</p>
<h2>When It Works, What Does It Do?</h2>
<p>As I mentioned above, spreadsheets can be really useful in several ways. I want to focus on the basics at this time. In each cell of a worksheet, you will find a word, a number, or a formula. Formulas give worksheets power because they can easily be copied to produce effective lists of numbers. Then, when the information has been entered, it can be sorted in ways that make it easier to spot missing data and clean up data that is clearly wrong, such as two-digit numbers in a column that is supposed to hold years.</p>
<h2>What&#8217;s the Downside?</h2>
<p>I don&#8217;t see a down side to improving one&#8217;s skills with spreadsheets, but there are a couple of things to warn you about. One is that you should learn the &#8220;Save&#8221; and &#8220;Save As&#8221; functions first. I really don&#8217;t like to hear that people have lost an hour&#8217;s worth of work because they did not save their file. I also don&#8217;t like it when I change a worksheet and then save it over the original accidentally. You won&#8217;t need to make these mistakes many times before you master these two processes.</p>
<p>Another is learning how to copy formulas. If you learn a few of the basics, you can avoid having to retype formulas—you can simply copy them like the wind (but be careful not to ruin a trailer home).</p>
<h2>How Do I Know If It&#8217;s Not Working?</h2>
<p>I sometimes get the dreaded #NAME# as a formula result. That&#8217;s almost always a sign that I&#8217;ve attempted to perform an arithmetic function on a word. This is especially tricky when the value in the cell is a number, but it has a space or two in front of it and looks like a word. Spreadsheets see such entries as words and don&#8217;t perform arithmetic functions on them well.</p>
<h2>What If I Change Computers?</h2>
<p>As a rule, you&#8217;ll want to reinstall the software and copy your data. You can easily copy your worksheets to a floppy disk or CD. Be sure to make copies so you can use them. And one caveat: If you make formulas that link to other worksheets, they will only work if the folder names and paths on the new computer are the same as on the old one (such as C:\My Documents\My Genealogy).</p>
<h2>What&#8217;s the Genealogy Tie-in?</h2>
<p>Spreadsheets are excellent tools for tracking census information for a family across a number of censuses. They can also help you spot hidden patterns in some historical lists, if you gather information from multiple sources of records, such as church records, immigration records, and &#8220;old country&#8221; records.</p>
<h2>Link Me Up (More stars is better)</h2>
<p>Techweb Encyclopedia - A definition of a spreadsheet [<a title="Techweb - spreadsheet" href="http://www.techweb.com/encyclopedia/defineterm?term=spreadsheet" target="_blank">link</a>]</p>
<p>Learning about Excel **** - A course from Furman University that you can read online.</p>
<p>Cyndi&#8217;s List &#8211; Forms **** - Cyndi has a lot of forms links, and some of them are usable in Excel.</p>
<h2>What Else?</h2>
<p>Spreadsheets are the &#8220;baking soda&#8221; of computer programs; people put them to a variety of uses. Some people use them for graphics programs, some people use them for databases, and some people use them for electronic forms.</p>
<p>One of my favorite capabilities is called &#8220;conditional formatting.&#8221; This is a feature that changes the format of a particular cell based on its content, or the relationship between the content and some other cell. With this function, it is possible, for example, to average a column of numbers and to display the numbers above the average in red and the numbers below the average in blue.</p>
<p><em>Beau Sharbrough is the president of GENTECH, the founder of the GENTECH and FGS Web sites, and a founder of the Lexicon Working Group. He would like to hear from you at beau@sharbrough.net, but due to the volume of e-mail received, he is unable to answer every e-mail message received. Please note that he cannot assist you with your individual computer problems. Visit Beau&#8217;s Web site for information about speaking engagements. Beau is the father of two college-age girls and is another insufferable graduate of Texas A&amp;M University.</em></p>
<p>[Disclaimer - this was in 2001. The girls are older now]</p>
]]></content:encoded>
			<wfw:commentRss>http://rootsworks.com/blog/?feed=rss2&amp;p=74</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>

