User:Bloosgrl/sandbox13

Part 1: Find Alternate and Parish Name
FamilySearch Wiki:WikiProject Czech Republic Archives

Part 2: Compare Parish Name to Master List and Correct
Step 1. Open the Master List and go to the parihes tab. Step 2. Find the parish name on the Gazetteer spreadsheet. Step 3. Find the parish name on the master list. Step 4. Copy and paste the parish name from the master list to the parish column of the Gazetteer spreadsheet.

Part 3: Find the Archive
Step 1: Copy the judicial district name. Step 2. Using Control F find the judicial district name on the gazetteer spreadsheet.You may need to search several tabs in the A-Z tabs to find it. Step 3. When you find the judicial district, look at the name of the archive for it (column J) and copy it. Step 4. Return to the missing cities and towns tab and paste the name of the archive into the archive column.

Part 2
You will use this table to complete part 2. 1. Look at the name in the archive column in the Google sheet. In the screenshot below it says "Brno".

2. Using the Archive Table above, find the archive name under the heading “If column E says”. See screenshot below.

3. The name of the archive in the column “If column E (archive) says” determines the information to be added to columns F and G in the Czech Republic Gazetteer Google sheet. Columns “Add to column F” and “Add to column G” have the codes to be added.
 * Example: In the screenshot, Brno is shown as the archive for the locality Adamov. Both columns to the right of “If column E (archive) says” have the word “blank”. This means you will leave those two columns blank. We are leaving them blank because these archives don't have any online records. See screenshot below.
 * If the either or both columns say “blank” leave the column blank on the Google sheet and go back to step 1. If there is code in either or both columns, got to step 4 to add it to the Google sheet.

4. Copy and paste the code from the table below into the Google sheet.

5. Highlight the and copy the code you just pasted to the Google sheet. Then highlight multiple cells to paste the code into multiple cells. 6. Once you've pasted to multiple cells, it will look like the screenshot below. 7. Continue to add code for the name of the archive until all of the rows for that archive name have the correct code (or are left blank) according to the table above.

8. Move on to the next archive on the sheet, using the table below, until all archives on the sheet have been processed.

9. Go back to part 1 and select another tab on the task list.