RootsWeb.com Mailing Lists
Total: 1/1
    1. Re: Excel(lent) - Confessions of a closet finger pecker
    2. Keith Tinkler
    3. Anne I'm not sure you want to know - smile .... > Query: > If you are not touch-typing, how do you check that you haven't committed > any typos without "looking up and down"? > *COMMENT ....I could ask tt's the same Q .... Wonders idly if touch typists have one eye on the source and the other on their transcription ..... and do they get migraines from split eyes? [juss jokin' - well mainly] Well --- its VERY hard to summarize my "style' - professional typists have been simultaneously amazed and horrified by how I operate. After many (far too many) years like this I am on quasi-auto pilot ..... but cant exactly explain how it works in words of any syllables. I did once use MacBMD but it drove me mad in no time flat. So then I went to a plain text editor for a couple of years working from hand written material that was usually so hard to read speed wasn't an issue .... Now I am on printed 1884 deaths and its heaven. > Query: > Even on the same page District names appear differently: I have seen, > for example, > > "London space C" > "LondonC" > "London space C full stop" and > "LondonC full stop" > > all on the same page. How does Excel's autocomplete feature differ then > from the WinBMD picklist feature? You surely have to look up and down to > check your autocomplete is using the correct (TWYS) version? On the whole I don't see too much variation in the printed material (WYSIWYG - hollow laugh!) so have not noticed that as a problem - but acknowledge it might be in some parts of the data. The auto-complete in Excel only works on a few of the repetitive names (I haven't figured out the underlying rules - it must have a buffer limit which I have looked for - but not found a way to expand) and on a given page I usually know pretty soon which will auto-complete - or wont. Once you hit return it enters the name and only does so once the letters so far are unique - you don't pick from a list - which would annoy me and slow me down .. I glance at the list typed every few lines and check against alignment on columns to the left .. and the jpeg being alongside the spreadsheet on the screen. I only use it for Districts, repetitive names or other entries are more easily handled with the drag down, and Command D (on a Mac) to copy into the active cell the entry in cell above. Well like I said, you may want to know, but you may not understand! - and I'm not sure I understand either, but it works quite well for me - and nothing could be done to speed me up - xcept rehab. I have never found a touch typist who understands a fast 3 or 4 fingered glancing habitué like myself .... > .....And with Excel you cannot use > BMDVerify for proof-reading! > No I cant - but there you are ... I use a paper edge against the screen to fix the line in the source and scroll a line at a time in the transcription. Keith

    01/28/2004 09:46:01