ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
To search within the entire workbook, use the Find and Replace Function (it can be searched for in Help!)

TAB COLOR CODING:
RED- 0% catalogued or shelf empty
YELLOW- Partially Catalogued (see Google doc for a more precise breakdown)
GREEN- 100% Catalogued
BLUE- Shelf Surveyed (or summarised)

Note: Some archival material may be listed in this library catalogue and will need to be migrated to the archives catalogue. Highlighted cells represent the existence of additional (unlisted) archival material on a shelf, which will need to be physcially relocated to the archive stores.

Resources for Cataloguing:

The British National Bibliography: https://bnb.data.bl.uk/

Library of Congress Catalogue: https://catalog.loc.gov/vwebv/searchBrowse

The National Library of Wales Catalogue: https://www.library.wales/

Archival or Library Material?:
A Guide for Volunteers at WCIA

Archival material is…

Primary source material, acquired directly from the creator

Mostly unpublished (although there are some exceptions)

Understood in the broader context of a fonds, or collection of corresponding documentary evidence

Unique, archival material is not usually available elsewhere

Organised in accordance with the principles of original order or provenance (archivists generally try to preserve the original organisation imposed by the creator of the documents)

An example of a fonds or archival collection at WCIA is The Lord Davies of Llandinam Papers. These papers were compiled by Lord Davies in the natural course of his peace campaigning

May exist in various media formats

General examples include: minute books, diaries, letters, audio recordings, born-digital and analogue reports, briefs, deeds, ledgers, research notes, etc.

Library material is…

Secondary source material, acquired from a publisher or vendor

Mostly published

Understood as discrete, rather than in the context of a larger collection

Widely available, although some library materials may be very rare

Organised according to various bibliographic subject/author name/etc. classification systems, without regard to the organisation of original creators

An example of library material at WCIA is the book “A matter of people,” held at the Temple Library. This book is published, can be found in many other libraries, can be understood as a distinct item, is catalogued under the Library of Congress classification system, and contains an ISBN number

May exist in various media formats

General examples include: books, periodicals, DVDS, magazines, reference books, ebooks, newspapers, etc.

Note: Today, there is much theoretical debate regarding the precise nature/form of archival material. While it is important to understand the differences between archives and libraries, it's also critical to acknowledge that these categories may not be as black and white as they once were believed to be. For example, some archival fonds include more traditional library items, such as rare books, ephemera, or even physical artefacts. On the other hand, many academic libraries and special collections similarly keep archives in their stacks (i.e., perhaps a letter written by John Keats tucked between the pages of his annotated edition of King Lear).
2
Google Sheets Tips & Tricks

Text Wrap:
Select the entire row or entire column which you'd like your text to be wrapped.
Select Format from the menu.
Select Wrap from the Text Wrapping option.
Click Wrap.

Tab/Enter Function Within Cells:
Control+Command+Enter

Freeze Top Row:
Highlight top row, View, Freeze, 1 row

Check Spelling:
Tools, Spell Check

Change Font/ Font size in entire sheet:
Select Top left box, change font

3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100