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)

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