Difference between revisions of "Template:COVID-19 pandemic data/Israel medical cases/doc"

From blackwiki
Jump to navigation Jump to search
imported>Eitan1989
(Remove reference to updating Hebrew Wikipedia - other editors seem to have taken that on and this process would overwrite all their manual name changes.)
imported>Eitan1989
(→‎Updating city/town stats: Switch from XLSX files to MoH dashboard site.)
Line 3: Line 3:
 
== Updating city/town stats ==
 
== Updating city/town stats ==
 
# Contact [[User:Eitan1989]] for write access to the spreadsheet mentioned below.
 
# Contact [[User:Eitan1989]] for write access to the spreadsheet mentioned below.
# Paste the spreadsheet data published by the Ministry of Health into a new sheet of this [https://docs.google.com/spreadsheets/d/1g5yI7cA95wazGKnJhvpHyAZ9wvOIbiR4XUPpNAI4vVw/edit spreadsheet].
+
# Copy the "אזורי התפשטות" table from the [https://datadashboard.health.gov.il/COVID-19/general MoH dashboard].
 +
# Paste the data published into a new sheet of this [https://docs.google.com/spreadsheets/d/1g5yI7cA95wazGKnJhvpHyAZ9wvOIbiR4XUPpNAI4vVw/edit spreadsheet].
 +
# Clear formatting on the pasted content and apply numeric formatting with zero decimal places.
 +
# Delete excess rows and columns.
 
# Enter the  name of the new sheet into the first cell of the 'Translated' sheet.
 
# Enter the  name of the new sheet into the first cell of the 'Translated' sheet.
 
# Check the names column for '#N/A' values. If you find any, add an appropriate English name to the 'Name Mapping' sheet by adding a new row at the appropriate place to maintain alphabetical ordering.
 
# Check the names column for '#N/A' values. If you find any, add an appropriate English name to the 'Name Mapping' sheet by adding a new row at the appropriate place to maintain alphabetical ordering.

Revision as of 10:31, 8 September 2020

Updating city/town stats

  1. Contact User:Eitan1989 for write access to the spreadsheet mentioned below.
  2. Copy the "אזורי התפשטות" table from the MoH dashboard.
  3. Paste the data published into a new sheet of this spreadsheet.
  4. Clear formatting on the pasted content and apply numeric formatting with zero decimal places.
  5. Delete excess rows and columns.
  6. Enter the name of the new sheet into the first cell of the 'Translated' sheet.
  7. Check the names column for '#N/A' values. If you find any, add an appropriate English name to the 'Name Mapping' sheet by adding a new row at the appropriate place to maintain alphabetical ordering.
  8. Copy the data rows from the 'Translated' sheet into the CSV to Wikitext converter.
  9. Copy the resulting wikitext and replace the corresponding section of wikitext in this template.
  10. Make sure to update the citation at the bottom of the table.

Eitan1989 (talk) 11:09, 26 April 2020 (UTC)