User:AdkinsWH/Sandbox Excel Co 2 new format

Using Excel, we can more quickly move county pages to the new format. (In a rough ratio of 1 hour in Excel to 12-20 hours using only the Wiki.

This page gives the steps.

Prep the Pattern

 * Create Wiki templates for each topic intro Put in category:Templates for [state] pages


 * Create 4 user pages in the wiki for the pattern (or use mine):
 * 1) User:AdkinsWH/Sandbox Co Home
 * 2) User:AdkinsWH/Sandbox Co Local
 * 3) User:AdkinsWH/Sandbox Co Websites
 * 4) User:AdkinsWH/Sandbox Co Records


 * Create 4 tabs in the Excel workbook: Current, Home, Local Resources, Websites


 * Create topic tabs in the Excel workbook: Bible, Biography, etc. For each topic tab, in Column A, copy the names of the counties in that state
 * This is a place saver, for when we run into explanatory material in a county for any topic. We can simply copy that material here, then update the Intro templates more easily.
 * Saves having to go back and revisit each county page.

Copy pattern to Excel master
When the Wiki pattern pages are ready
 * Copy the patterns to appropriate tab in Excel: Always to Column B, line 1 (no headers in Excel page)
 * FYI: Column A is only used on the "Current" tab

Merge the current county page into the pattern on Excel

 * 1) In Wikitext, copy the current county page into Current tab on Excel: Column B, line 1 (This will not be edited, and will serve as a guide during this process
 * 2) Copy it again to the  Column G, line 1.  (This becomes the working copy)