Difference between revisions of "Template:COVID-19 pandemic data/Israel medical cases/doc"
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 | + | # 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
| This is a documentation subpage for Template:COVID-19 pandemic data/Israel medical cases. It contains usage information, categories and other content that is not part of the original template page. |
Updating city/town stats
- Contact User:Eitan1989 for write access to the spreadsheet mentioned below.
- Copy the "אזורי התפשטות" table from the MoH dashboard.
- Paste the data published into a new sheet of this 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.
- 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.
- Copy the data rows from the 'Translated' sheet into the CSV to Wikitext converter.
- Copy the resulting wikitext and replace the corresponding section of wikitext in this template.
- Make sure to update the citation at the bottom of the table.
Eitan1989 (talk) 11:09, 26 April 2020 (UTC)