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<https://aka.ms/o0ukef>
________________________________
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
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<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>
<heraldnegindex-bounce@xxxxxxxxxxxxx<mailto:heraldnegindex-bounce@xxxxxxxxxxxxx>>
on behalf of Chris Shepheard
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
Date: Tuesday, 30 March 2021 at 08:26
To: Christine Callow <chrisjcallow@xxxxxxxxx<mailto:chrisjcallow@xxxxxxxxx>>
Cc: heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
<heraldnegindex@xxxxxxxxxxxxx<mailto: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<mailto:chrisjcallow@xxxxxxxxx>>
Date: 29/03/2021 21:11 (GMT+00:00)
To: Chris Shepheard
<chris.shepheard@xxxxxxxxxxxxxxx<mailto: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.
