User:Batsondl/Trisha Assignments

Wiki Numbers
1. Open Task List 2. Scroll all the way to the furthest right columns on the current year and highlight the last two columns. 3. Right click and press "Insert two columns right" 4. Title the left column you just created the date you are collecting the numbers 5. Title the right column "dif"
 * This may already be done and you can skip these steps

6. Click each link on the far left column to the language wiki pages and gather the article number count for each language wiki. Put the current number under the date column and in line with the Wiki the number corresponds with. 7. Once you gather all the numbers, find the sum of all wikis in the total row under the current date. 8. Find the difference by going to the difference column and entering "=" then clicking the current week's cell under the date column for the English Wiki then a minus sign "-" then click the previous week's cell for the English wiki and press enter. It should ask you if you want to do it for the rest of the difference column. If you click the green check, it will populate the rest of the differences for the other language wikis.
 * If you don't click it, you can also drag and drop the formula down by clicking the cell, then dragging down once you see a cross.
 * A correct formula would look like this: "=BP2-BN2"

9. Repeat once a week sometime on Monday, or the day after for holidays. 10. Create a new tab when a new year begins and copy over Column A (the links to the wikis)

Adding FamilySearch New Collections
1. Open the Excel version of the "DATE Publication Report" that is automatically forwarded to you from David Greenwood. It is usually sent out by the end of the day on Mondays if it wasn't a holiday. 2. Sort the "Comments" column from Z to A. 3. The ones that say "New indexed records collection" are the only ones that we will use 4. Open the "FS New Collections" Tab on the New Collections Project Task List 5. Copy the "Country" and "Collection" Columns for the ones that say "New indexed records collection" on the Publishing Report and paste them at the bottom of the New Collections Project Task List under columns "Location" and 	"Name of database" 6. Copy the Collection IDs from the Publishing Report for the "New indexed records collection" and paste them in the "Link" column on the New Collections Project Task List. 7. Turn the Collection IDs into links by pasting the Collection ID after the slash in this link: https://www.familysearch.org/search/collection/ Example:  https://www.familysearch.org/search/collection/4380169 8. Put the links next to their collection titles 9. Check the links as a "General Public" use (get password from Caileigh) to see if they have been published yet or if they are only available to members of the Church.
 * Put "HOLD - Until Published" for ones that look like this:



Projects to Work on

 * Adding New Collections for Ontario and Finland

FamilySearch Collections

 * Instructions
 * New Collections Task List
 * Tab: FS New Collections

ALL Other Websites

 * Instructions
 * New Collections Task List
 * Tab: All-Formatted List