RootsWeb.com Mailing Lists
Total: 1/1
    1. [ILMACOUP-L] 1860 Census - "My bearings"
    2. Gloria Frazier
    3. Found 'em! bearings, that is. I wanted to let everyone know I am working on the 1860 census and to give you the excuses why it isn't up...... I am looking at a week or two to start getting the pages up. The typing. The proofreading. I decided I would take one at a time so I wouldn't "burn" like I did on the 1850. Setting up/sorting. Littleton Bradley, compiler of the book, who gave me permission to use his 1850 and 1860 had put the 1860 ALL in alphabetical order but included good sort columns to put back into original page/census taker order. I almost slip in my thinking once in awhile ----hmmm, working from the original might have been easier. Then the faded and hard to read pages changes my mind. What a major and lengthy task Littleton had in completing his book! That is another email....... Having left the setting up/sorting until the last few days I found a major sort problem (at least for me) in Excel on the column for census taker pages which I thought the most important. Yes, I need a course/practice in the Access program (database program), but I don't take the time. Sooo, still using Excel. If I knew Access, I could ask David Arnsmeyer or Charlie Neff, who just told me he uses it all the time, First problem was removing trailing spaces and errors. Lost my macro for trailing spaces which works great and which Frank Oglesby sent to me. His email address is broken so hope he is ok. So removed my trailing spaces manually which weren't many. Another problem was sorting alpha numerical entries like A1, A23, A111. They wanted to sort in A1, A111, A23. Doug, the husband, came thru last nite after I played with it for SOME hours. I knew I had to have some kind of custom sort but wasn't a master of that either. He isn't either but his "Spock" mind will figure it out. So, I now know how to do a custom sort at least on the type of entries A1, A23, A111. If interested in how to do that, holler. Another problem was I am still using Excel for 95 and a sheet will only take 16,384 rows. After I stripped headings, etc, there are about 23,000 rows for the 1860. Well, with the sort problem taken care of, I can live with two files for now. The week or two to get things going entails the sorting, dividing into the page breaks, eliminating columns and/or replacing columns with meaning substitutes for numbers, adding the copyright info and basics for the html page, uploading, listening to the complaints, redoing, reuploading and keeping any sanity I may have left. Let's see.......555 typed pages......wonder how many pages I can use on one page to make the time for downloading a page so no user will SCREAM/USE THOSE CHOICE WORDS at me?? That is my jabber for now. And, you have to promise that you have skimmed this enough to know why the 1860 isn't up and you won't need to SCREAM at me!!! Well, at least for a couple of weeks.......... Thanks. Gloria with brain intact ------------------ Gloria Frazier Macoupin County ILGenWeb County Coordinator http://www.rootsweb.com/~ilmacoup/macoupin.htm

    05/14/1999 09:21:27