User:Timeshifter/Sandbox284

Divide all data cells in a rates table by 10 in order to change to deaths per 100,000 instead of deaths per million.

Some background info if needed:

• Help:Creating tables#Copy column to table
• Help:Creating tables#Copy/delete rows

:See https://workspace.google.com/products/sheets

Copy the data cells: In source editor put nowiki tags around templates just above the wiki table. Then in visual editor select a corner data cell. Then shift-click on opposite corner of rectangle of data cells. Then copy from your browser edit menu (or use {{Keypress|Ctrl|C}}).

Paste the data cells into a blank Google sheet]. Use the edit menu from your browser or {{Keypress|Ctrl|V}}. Once pasted in you should see the range of cells already selected. If not, select one corner cell. Then shift-click the opposite corner. Just above the top cells to the left should be the range. For example: A1:C29.

Put that range in the formula like this:

:=ARRAYFORMULA(Sheet2!A1:C29/10)

The formula is dividing all cells in the range by 10. Check the sheet number in the sheet tabs just below the data.

Use the formula: Click on a blank column head to the right of the data. Paste the formula in the fx spot just above the data. Click enter on your keyboard. All the corrected data will show up.

Paste the adjusted data into the wikitable: Copy that data, and paste it over the old data in the wikitable via the visual editor.

For more info:

• [https://support.google.com/docs/thread/229667532/to-divide-entire-range-of-cells-by-1000-each-cell?hl=en To divide entire range of cells by 1000 (each cell)]. Google Docs Editors Community.

:See LibreOffice Calc.

Paste just the data cells into a blank sheet. Note the range in the spot to the left just above the data cells. Such as A1:C29

Put it in the Calc formula:

:=A1:C29/10

Click the top of any blank column. Paste the formula in the fx spot just above the data. Click Ctrl + Shift + Enter on your keyboard. All the corrected data will show up.

For more info:

• [https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html Array functions]. LibreOffice Help.

:See: https://www.microsoft.com/en-us/microsoft-365/excel

Paste just the data cells into a blank workbook via the browser edit menu, or {{Keypress|Ctrl|v}}.

Then click the top of a blank column. Formula is same as in LibreOffice Calc:

:=A1:C29/10

Paste the formula in the fx spot just above the data via the browser edit menu or {{Keypress|Ctrl|v}}. Click enter, and the adjusted data shows up starting at the top data cell of the blank column you had selected.

Select the adjusted data. Then right-click it, and click copy. Or use {{Keypress|Ctrl|c}}. Paste it into the wiki table via the visual editor.

• Location links are "Healthcare in LOCATION" links.

Templates above the table have been surrounded by nowiki tags in order to allow copying and pasting all the data cells at once via the VisualEditor.

{{sticky table start}}{{mw-datatable}}{{static row numbers}}

{{sticky table end}}

• Location links are "Healthcare in LOCATION" links.

{{sticky table start}}{{mw-datatable}}{{static row numbers}}

{{sticky table end}}

{{reflist}}