Hi TonyPlease leave as text.There are dozens of negatives of some of those
jobs, many very difficult to distinguish. I don't think anybody will ever have
the energy or willpower to attempt to identify them all.I export the data as
plain CSV to add to the database and most of the database fields are set to
text at the moment too.For searching the most important field is "assignment".
I also search for the old style negative numbers because they used to be
printed in the paper. That had stopped by the 1970s.Then we changed the
indexing from box no./neg. no. to week no./neg. no. and finally to week
no./strip no. After the final change we stopped identifying the actual negative
that appeared in the paper.At the peak each of three photographers was shooting
up to 8 assignments on a busy day stretching from Farnham to Petersfield. At
one point I had 5 photographers.Now there are none...ChrisSent from my Galaxy
-------- Original message --------From: Tony Deadman <tone747@xxxxxxxxxxx>
Date: 30/03/2021 20:46 (GMT+00:00) To: heraldnegindex@xxxxxxxxxxxxx Subject:
[heraldnegindex] Re: 1990/1991 index
That’s fine Chris. I was just concerned as to how the cells are formatted in
the database field. I do a lot of spreadsheet work and transferring
spreadsheets to databases is not very forgiving. This is just a suggestion and
you may have already eliminated this
as an option but
I was just wondering if it might help if the Neg no. index column was formatted
as a whole number on the Excel spreadsheet. Then for example a strip of
Negatives say 5-9 could simply given as 5 separate lines (lines 5,6,7,8 & 9)
and each Assignment line etc
duplicated. It sounds pedantic but that way you don’t get the mixing of text
and number in the Neg no. column, and in the future on the database the
Assignment description for each single line can be updated to describe
specifics of each negative in the future.
Does what I’ve said make sense? - hopefully you don’t think I’m too interfering
or presumptuous.
Tony
Get Outlook for iOS
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
on behalf of Chris Shepheard <chris.shepheard@xxxxxxxxxxxxxxx>
Sent: Tuesday, March 30, 2021 7:22:33 PM
To: heraldnegindex@xxxxxxxxxxxxx <heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: 1990/1991 index
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
span.x_EmailStyle20
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.x_WordSection1
{}
-->
Hi Tony,
Yes, I did wonder if that might happen. Please convert the format to text.
I thought it might try to work it out like a sum! Didn’t expect a date.
To set the column to text click on the column header (the cell with “D” in it)
and right click it to select “Format cells” (if you can’t right click [mac
users?] look in the ribbon above and in the section
“Number” click on the box with “General” in it and select “text” from the drop
down menu). In the category list that appears select “Text”.
That should set the whole column in the spreadsheet.
Sorry about that, I think this will apply to all the index books after 1990.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
On Behalf Of Tony Deadman
Sent: 30 March 2021 09:14
To: heraldnegindex@xxxxxxxxxxxxx
Subject: [heraldnegindex] Re: 1990/1991 index
Hi Chris,
S an observation, my ‘Neg no’, index column is set to ‘General’ so when I enter
‘5-6’ I get an assumption that it is ’05-June’. Should we all be converting
that column to ‘Text’?
Tony
From:
heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx> on
behalf of Chris
Shepheard <chris.shepheard@xxxxxxxxxxxxxxx>
Date: Tuesday, 30 March 2021 at 08:26
To: Christine Callow <chrisjcallow@xxxxxxxxx>
Cc: heraldnegindex@xxxxxxxxxxxxx <heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: 1990/1991 index
Hi Christine,
I think I know what is happening here.
At about this time we stopped cutting individual 35mm negatives and putting
them into bags.
Instead we cut the films into strips of six negatives and numbered each strip.
This means that some jobs/assignments started and stopped in the middle of
strips.
Now I hope that I made the template right in that the negative number field
will accept any text.
Please just enter "5-6" or even much greater ranges as a single negative entry.
Let me know if Excel tries to evaluate it as a sum and I'll make a new
template. If not all well and good.
The big problem when went to this system was that we didn't know which actual
negative had been used but it still allowed us to easily locate the job.
The other problem was that it meant storing an awful lot more negatives! They
are in sheets in large ring binders and take up lots of space in the museum
store.
By that stage we weren't processing our own films and the lab wasn't happy
about handling individual negatives as the machine was designed to move strips
through automatically.
At one stage the photographic department of two photographers was only given
one chair (no desk) to share in the office and no other facilities!
Chris
Sent from my Galaxy
-------- Original message --------
From: Christine Callow <chrisjcallow@xxxxxxxxx>
Date: 29/03/2021 21:11 (GMT+00:00)
To: Chris Shepheard <chris.shepheard@xxxxxxxxxxxxxxx>
Subject: 1990/1991 index
Hello Chris, I am having a bit of difficulty in arranging the latest index on
the spreadsheet. As you can see from the attached, the negative numbers are
grouped together. I started out by listing 1-5 separately with the date
29/12/89
and the assignment as written. However, the next line is for negatives 5-6.
Further down the page, several negative numbers are duplicated so I don't know
which is which, if you see what I mean? For instance is negative 5 about the
fire in Headley or about
the Vietnamese family?
Can you clarify please? Many thanks, Christine.
