View source for Talk:Membership Statistics U.S.

It may be helpful to others for me to describe how I create these tables:

# Use a spreadsheet such as [http://office.microsoft.com/en-us/excel/default.aspx Excel], [http://www.openoffice.org/product/calc.html Openoffice Calc], or [http://docs.google.com Google Docs] to compile the data. I like to use Google Docs so that if needed I can share the spreadsheet online. A spreadsheet is simpler to use than a wiki table, duplicates cells easier, and totals columns. Where there are blank cells, use a [http://en.wikipedia.org/wiki/Nbsp non-breaking space] (<code>&amp;nbsp;</code>) to maintain table integrity.
# When the spreadsheet is finished, export the data as [http://en.wikipedia.org/wiki/Comma-separated_values csv]. In Google Docs the csv data appears in another tab in my Firefox browser.
# Select all the csv data and paste it into the window of a [http://area23.brightbyte.de/csv2wp.php CSV Converter]. In the ''Convert Special Characters'' section select ''Do not convert (table contains code)''. Click on the ''Convert to MediaWiki!'' button.
# Copy the wiki table to your Mormonwiki edit page. Add in your ''wikitable sortable'',  ''cellspacing'', ''border'', and ''background'' color, etc. Don't forget to add the ''sortbottom'' class before the ''totals'' row.
# When updating your article, put the changes in your spreadsheet and convert as before but do not replace the wiki table header. You will have to re-type the ''sortbottom'' class as this is replaced each time. If someone else updates the wiki table directly, don't forget to update your speadsheet.

Hope this helps. [[User:Rickety|Rickety]] 19:15, 1 June 2008 (UTC)