Hi Gwyneth
Welcome to the team.
I am resending my queries, a couple of them I am now happy with, but would
welcome another pair of eyes.
Many Thanks
Rosemary
________________________________
From: Keith Mortimer <k_r_mortimer@xxxxxxxxxxx>
Sent: 15 November 2020 17:30
To: heraldnegindex@xxxxxxxxxxxxx <heraldnegindex@xxxxxxxxxxxxx>
Subject: Re: [heraldnegindex] Re: Herald Index
Hi Chris & Everyone
I might have finally cracked "snipping" so have attached various queries I have.
My Son in Law tells me it is fine to insert a large piece into the body of an
excell spreadsheet. Enough lines must be inserted to take the new piece and
then the work will not be lost. It is only when too few lines are inserted that
work is lost.
I have been unable to open the cloud email.
The Queries:
No1 attachment Box 524 Negative 7437. Tilford School Pageant 'Sir Nigel
Holds ?
No2 attachment Box 522 Neg. 7413 Barfield School Sports & Prize
Distribution - Mr Tice presents ? Cup to Wells
No 3 attachment Box 531 Neg 7531 Churt Flower Show & Fete C Voller
tries his luck with ? Coconuts
No4 attachment Box 345 Neg 4930 Guides Thinking Day Bourne Hall
Presentation to Guide M Longbottom by Lady M?
No 5 attachment Box 342 Neg 4891 Views of Various Housing Estates in the
District Weydon Road Estate View Showing ? (it is the line above Farnham
P/C)
No 6attachment Box 342 Neg 4886 Views of Various Housing Estates in the
District Old Park Close showing ? ( the query is on the word under
Clump)
Best wishes
Rosemary
________________________________
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
on behalf of Chris Shepheard <chris.shepheard@xxxxxxxxxxxxxxx>
Sent: 15 November 2020 16:55
To: heraldnegindex@xxxxxxxxxxxxx <heraldnegindex@xxxxxxxxxxxxx>
Subject: [heraldnegindex] Re: Herald Index
Hi Patsy and everyone,
I think Patsy is right suggesting a separate Excel file for every 100 pages.
That way If everything goes wrong not all your hard work is lost.
However I believe there is a way of inserting the contents of one workbook into
the middle of another safely but we can sort that out later. (This article
seems to suggest a safe way -
https://business.tutsplus.com/tutorials/how-to-combine-excel-spreadsheets--cms-30397#:~:text=The%20easiest%20method%20to%20merge,to%20copy%20several%20sheets%20from.)
In any case we can always build the final file by adding the individual ones in
order.
Regarding backups I have now created a pCloud folder to which you can all
upload your completed or semi-completed spreadsheets for safety. You should
receive a link to the folder but if it doesn’t arrive please let me know.
Inside the folder you will find another folder with your name on it. Please
upload your files to that folder – this will avoid any overwriting in the odd
instance that you’d chosen the same filename.
You are also welcome to use the system for swapping files between yourselves if
you need to.
In order to make pCloud work more easily for you, you might find it better to
visit the pCloud website and download and install the Windows or Mac interface.
This will create a virtual folder on your machine into which you can copy files
and they will automatically be uploaded to the cloud. Hopefully you won’t find
this too complicated but if you have any questions please let me know.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx
From: heraldnegindex-bounce@xxxxxxxxxxxxx <heraldnegindex-bounce@xxxxxxxxxxxxx>
On Behalf Of g.lunn800 (Redacted sender "g.lunn800" for DMARC)
Sent: 15 November 2020 12:07
To: heraldnegindex@xxxxxxxxxxxxx
Subject: [heraldnegindex] Re: Herald Index
Hello Chris and co,
I was suggesting that another sheet should be started when more than one book
is shared between several transcribers.
I have renamed my first sheet Book 1951 Page 50-100 the following sheet will be
pages Book 1951 Page 101-
With Excel if copy and paste is used to insert pages, it will delete anything
below the three empty line space. When seperate sheets are created then they
can be put together in order to make up the whole book.
Patsy
------ Original Message ------
From: "Chris Shepheard"
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
To: "'Keith Mortimer'"
<k_r_mortimer@xxxxxxxxxxx<mailto:k_r_mortimer@xxxxxxxxxxx>>;
heraldnegindex@xxxxxxxxxxxxx<mailto:heraldnegindex@xxxxxxxxxxxxx>
Sent: Saturday, 14 Nov, 2020 At 7:02 PM
Subject: [heraldnegindex] Re: Herald Index
Hi Rosemary, (I’m copying this to the list so everyone can see and comment)
What you suggest sounds fine to me. I’m hoping others will be on hand when we
start to build the database but I can build a temporary database here from
however many Excel files there are.
I’m pretty sure that we can just import one Excel file into another then delete
any unused rows. I’ll have to look it up when we get to that – probably when
the first book is completed.
With the date and sized published it won’t need to be too consistent as, I
don’t think, it will ever be searched on. As long as it is understandable it
will act as a guide to finding the story/article associated with the photo/s
which will be very important until the bound volumes are digitised.
Archive queries have slowed a little of late but I’m expecting them to pickup
as this lockdown progresses.
Hope you are all well, not got square eyes or RSI! I’m currently scanning negs
for a series of articles we did on Farnham Schools in 1972 – quite interesting
to see how education has changed.
Chris
Chris Shepheard
Chris.shepheard@xxxxxxxxxxxxxxx<mailto:Chris.shepheard@xxxxxxxxxxxxxxx>
From: Keith Mortimer <k_r_mortimer@xxxxxxxxxxx<mailto:k_r_mortimer@xxxxxxxxxxx>>
Sent: 14 November 2020 18:51
To: Chris Shepheard
<chris.shepheard@xxxxxxxxxxxxxxx<mailto:chris.shepheard@xxxxxxxxxxxxxxx>>
Subject: Herald Index
Hi Chris
Patsy is doing pages 50 to 100.
I finished pages 1-49 and then left 3 lines and carried on from 101 and I have
so far finished 109.
Patsy is worried that her piece cannot be worked in with mine, that I should
have left a bigger space.
For SGW when I changed years I just left 3 lines so thought it would be OK this
time.
Before I do any more would you please advise.
There is also a query re column 'Date and size published' I have written, for
instance T/C 4-9-53 as this was how it was written during the first page it
occurred, is this how you want the date typed in this column so that we are
consistent.
Rosemary
Attachment:
Screenshot 2020-11-15 170041.png
Description: Screenshot 2020-11-15 170041.png
Attachment:
Screenshot 2020-11-15 165500.png
Description: Screenshot 2020-11-15 165500.png
Attachment:
Screenshot 2020-11-15 162218.png
Description: Screenshot 2020-11-15 162218.png
Attachment:
Screenshot 2020-11-15 161718.png
Description: Screenshot 2020-11-15 161718.png
Attachment:
Screenshot 2020-11-15 161512.png
Description: Screenshot 2020-11-15 161512.png
Attachment:
Screenshot 2020-11-15 161319.png
Description: Screenshot 2020-11-15 161319.png
Attachment:
Screenshot 2020-11-15 161141.png
Description: Screenshot 2020-11-15 161141.png
