11,709
edits
| Line 39: | Line 39: | ||
===Part 2: Check the notes column=== | ===Part 2: Check the notes column=== | ||
1.Sort the gazetteer spreadsheet by highlighthing the whole sheet, clicking on data, selecting sort range, column K and sort A-Z. This will shift all rows with notes in the notes column to the top of the sheet. | 1.Sort the gazetteer spreadsheet by highlighthing the whole sheet, clicking on data, selecting sort range, column K and sort A-Z. This will shift all rows with notes in the notes column to the top of the sheet. | ||
2. Search through the spreadsheet, looking for any notes in the notes column. <br> | 2. Search through the spreadsheet, looking for any notes in the notes column. <br><br> | ||
3. When you get to a note, read it. It may list an alternate archive for the locality. Replace the name of that archive with the archive listed in the archive column for that line. | 3. When you get to a note, read it. It may list an alternate archive for the locality. Replace the name of that archive with the archive listed in the archive column for that line.<br><br> | ||
4. If the note says the locality was not found in either PDF, try to find it by doing the following: | 4. If the note says the locality was not found in either PDF, try to find it by doing the following: | ||
:*Check the archive column for that line. If it's already filled in, you can go to the next line with a note on it. | :*Check the archive column for that line. If it's already filled in, you can go to the next line with a note on it. | ||
| Line 54: | Line 54: | ||
<br> | <br> | ||
===Part 3: Add links to the archives=== | ===Part 3: Add links to the archives=== | ||
1. Sort the Google sheet by highlighting the whole sheet, clicking on data, select sort range, column J and A-Z.<br> | 1. Sort the Google sheet by highlighting the whole sheet, clicking on data, select sort range, column J and A-Z.<br> | ||
edits