Jump to content

FamilySearch Wiki:WikiProject Czech Archives Part 2: Difference between revisions

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>
11,709

edits