FREEBMD-SYNDICATES-L Archives

Archiver > FREEBMD-SYNDICATES > 2007-02 > 1171619082


From: "ESSERY, Clive G" <>
Subject: RE: [Possible Spam]::FREEBMD-SYNDICATES Digest, Vol 2, Issue 10
Date: Fri, 16 Feb 2007 09:44:42 -0000


I and a few of my syndicate have used Excel ever since we started work
in 1999 and have never seen a problem like this. I do all my FreeBMD
work in my lunchtimes and we are not allowed to load any programmes on
to our computers so I have no choice.

The main problem that we have encountered with Excel is that you can't
add a "+" sign in easily, you have to type a single quote before it to
force it to view the line as type TEXT rather than thinking that it is a
formula.

I dump all the data into a CSV file, open that in Word, add the standard
header, modifying the variable components as necessary, then save it as
a .TXT file and upload that. While it may take a minute or two extra, I
only upload large files (98 pages = 1 complete fiche) at a time so it
isn't much of an overhead and it gives me an opportunity to run some
error checking if I want to before sending the data.

The suggestion on CASE sounds like a good bet - some of my transcribers
type "+Page" occasionally which I have to correct.

Clive

-----Original Message-----
From:
[mailto:] On Behalf Of

Sent: 16 February 2007 08:03
To:
Subject: [Possible Spam]::FREEBMD-SYNDICATES Digest, Vol 2, Issue 10



Today's Topics:

1. Transcribing with Spreadsheets (Chris Mahoney)
2. Re: Transcribing with Spreadsheets (Jeff Coleman)
3. Re: Transcribing with Spreadsheets ()


----------------------------------------------------------------------

Message: 1
Date: Fri, 16 Feb 2007 10:27:28 +1300
From: "Chris Mahoney" <>
Subject: Transcribing with Spreadsheets
To: <>
Message-ID: <019c01c75149$f0935b80$>
Content-Type: text/plain;charset="iso-8859-1"

Hi

Is there anyone who is familiar with doing the transcribing using
spreedsheets, such as Excel that could assist me with this.

I have a new transcriber whom using WinBMD (or SpeedBMD) isn't an option
for them, and so has to use a spreadsheet. However, we are having
problems with one part of the file.

Whenever I open one of the files they send my (sent as a CSV file),
WinBMD says that the Event Type is invalid and makes an assumption
(which it has got wrong so far).

A comparison programme I have used when comparing the headers of their
csv file to one I created in WinBMD for the same page show both to be
identical.

Any suggestions as to what the problem is, and how to fix it.


Thanks

Note: Rest of headers, and page in general is showing up correctly when
I open it in WinBMD


<SNIP>

Is the event type in all UPPER CASE?

Because if it isn't it won't be recognised.



----------------------------------------------
This mail sent through http://www.ukonline.net


------------------------------

To contact the FREEBMD-SYNDICATES list administrator, send an email to
.

To post a message to the FREEBMD-SYNDICATES mailing list, send an email
to .

__________________________________________________________
To unsubscribe from the list, please send an email to

with the word "unsubscribe" without the quotes in the subject and the
body of the
email with no additional text.


End of FREEBMD-SYNDICATES Digest, Vol 2, Issue 10
*************************************************


**********************************************************************
If you are not the intended recipient, please notify our Help Desk
at Email immediately. You should not
copy or use this email or attachment(s) for any purpose nor
disclose their contents to any other person.

NATS computer systems may be monitored and communications
carried on them recorded, to secure the effective operation of the system and for other lawful purposes.

Please note that neither NATS nor the sender accepts any responsibility
for viruses or any losses caused as a result of viruses and it is your
responsibility to scan or otherwise check this email and any attachments.
NATS means NATS (En Route) plc (company number: 4129273), NATS (Services) Ltd
(company number 4129270), NATSNAV Ltd (company number: 4164590)
or NATS Ltd (company number 3155567) or NATS Holdings Ltd (company number 4138218).
All companies are registered in England and their registered office is at 5th Floor,
Brettenham House South, Lancaster Place, London, WC2E 7EN.

**********************************************************************


This thread: