Approver, Reviewer, editor, pagecreator
46,825
edits
| Line 76: | Line 76: | ||
::*See "CA online" tab in WA Newspapers 2010. | ::*See "CA online" tab in WA Newspapers 2010. | ||
::::1) Find the counties for each newspaper (done in Column G by Wilma) | ::::1) Find the counties for each newspaper (done in Column G by Wilma) | ||
:::::1a) Sort by county | :::::1a) (Done) Sort by county (Done) | ||
:::::1b) In column H, copy the formula: =left(b1,search(".",b1)-1) | :::::1b) (Done) In column H, copy the formula: =left(b1,search(".",b1)-1) | ||
:::::1c) -- etc. Wilma finish these for next state. | |||
::::2) | ::::2) Find the next county on the Excel page (sorted in Step 1a) | ||
::::3) In WikiText, find the newspaper on the list | :::::2a) In the Wiki, navigate to that_county's newspapers page | ||
:::: | ::::3) In WikiText, find (Ctrl+F) the newspaper on the list | ||
:::::3a) Go to the fifth pipe (which is for Online) and create the link as follows: | |||
::::::[ + URL + space + CA + ] | |||
::::::To get the URL, click the icon in column B of the Excel File. | |||
::::5) Back in the Excel file, type Done in column J. | ::::5) Back in the Excel file, type Done in column J. | ||
::*See "SOS" tab in WA Newspapers 2010 | ::*See "SOS" tab in WA Newspapers 2010 | ||