User:Timeshifter/Sandbox284: Difference between revisions
Timeshifter (talk | contribs) No edit summary |
Timeshifter (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
See: |
|||
*'''[[United States drug overdose death rates and totals over time#Comparisons to other countries in Europe]].''' Section title may change. |
|||
*'''[[User:Timeshifter/Sandbox285]]''' |
|||
== Change table from rates per million to rates per 100,000 == |
== Change table from rates per million to rates per 100,000 == |
||
Latest revision as of 00:49, 13 March 2025
See:
- United States drug overdose death rates and totals over time#Comparisons to other countries in Europe. Section title may change.
- User:Timeshifter/Sandbox285
Change table from rates per million to rates per 100,000
[edit]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:
Via free Google Sheets
[edit]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 Ctrl+C).
Paste the data cells into a blank Google sheet]. Use the edit menu from your browser or 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:
- To divide entire range of cells by 1000 (each cell). Google Docs Editors Community.
Via freeware LibreOffice Calc
[edit]- 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:
- Array functions. LibreOffice Help.
Via Excel online
[edit]Paste just the data cells into a blank workbook via the browser edit menu, or 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 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 Ctrl+c. Paste it into the wiki table via the visual editor.
Rates table. Deaths per 100,000
[edit]- 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}}
| Location | Year | Females | Males | Total |
|---|---|---|---|---|
 Austria
|
2022 | 1.8 | 6.5 | 4.2 |
 Belgium
|
2020 | 0.7 | 3.4 | 2.1 |
 Bulgaria
|
2022 | 0.1 | 0.8 | 0.4 |
 Croatia
|
2022 | 1.3 | 7.1 | 4.2 |
 Cyprus
|
2022 | 0.3 | 1.3 | 0.8 |
 Czech Republic
|
2022 | 0.6 | 1.2 | 0.9 |
 Denmark
|
2021 | 1.9 | 6 | 4 |
 Estonia
|
2022 | 3.4 | 15.5 | 9.5 |
 Finland
|
2022 | 3.3 | 10.6 | 7 |
 France
|
2016 | 0.3 | 1.6 | 0.9 |
 Germany
|
2022 | 1 | 4.9 | 3 |
 Greece
|
2020 | 1 | 5.8 | 3.4 |
 Hungary
|
2021 | 0.3 | 0.9 | 0.6 |
 Ireland
|
2020 | 6.4 | 13 | 9.7 |
 Italy
|
2022 | 0.2 | 1.3 | 0.8 |
 Latvia
|
2022 | 1.2 | 9.6 | 5.3 |
 Lithuania
|
2022 | 1 | 8.6 | 4.7 |
 Luxembourg
|
2022 | 0.5 | 3.1 | 1.8 |
 Malta
|
2020 | 0.6 | 4.3 | 2.6 |
 Netherlands
|
2022 | 1.3 | 4 | 2.6 |
 Norway
|
2022 | 5.3 | 11.8 | 8.6 |
 Poland
|
2021 | 0.5 | 1.1 | 0.8 |
 Portugal
|
2021 | 0.4 | 1.9 | 1.1 |
 Romania
|
2022 | 0.1 | 0.3 | 0.2 |
 Slovakia
|
2021 | 0.3 | 1.2 | 0.7 |
 Slovenia
|
2022 | 1.6 | 7.4 | 4.6 |
 Spain
|
2021 | 0.7 | 3.4 | 2.1 |
 Sweden
|
2022 | 3.5 | 10.2 | 7 |
 Turkey
|
2022 | 0.1 | 0.7 | 0.4 |
Rates table. Deaths per million
[edit]- Location links are "Healthcare in LOCATION" links.
| Location | Year | Females | Males | Total |
|---|---|---|---|---|
| Austria
|
2022 | 18 | 65 | 42 |
| Belgium
|
2020 | 7 | 34 | 21 |
| Bulgaria
|
2022 | 1 | 8 | 4 |
| Croatia
|
2022 | 13 | 71 | 42 |
| Cyprus
|
2022 | 3 | 13 | 8 |
| Czech Republic
|
2022 | 6 | 12 | 9 |
| Denmark
|
2021 | 19 | 60 | 40 |
| Estonia
|
2022 | 34 | 155 | 95 |
| Finland
|
2022 | 33 | 106 | 70 |
| France
|
2016 | 3 | 16 | 9 |
| Germany
|
2022 | 10 | 49 | 30 |
| Greece
|
2020 | 10 | 58 | 34 |
| Hungary
|
2021 | 3 | 9 | 6 |
| Ireland
|
2020 | 64 | 130 | 97 |
| Italy
|
2022 | 2 | 13 | 8 |
| Latvia
|
2022 | 12 | 96 | 53 |
| Lithuania
|
2022 | 10 | 86 | 47 |
| Luxembourg
|
2022 | 5 | 31 | 18 |
| Malta
|
2020 | 6 | 43 | 26 |
| Netherlands
|
2022 | 13 | 40 | 26 |
| Norway
|
2022 | 53 | 118 | 86 |
| Poland
|
2021 | 5 | 11 | 8 |
| Portugal
|
2021 | 4 | 19 | 11 |
| Romania
|
2022 | 1 | 3 | 2 |
| Slovakia
|
2021 | 3 | 12 | 7 |
| Slovenia
|
2022 | 16 | 74 | 46 |
| Spain
|
2021 | 7 | 34 | 21 |
| Sweden
|
2022 | 35 | 102 | 70 |
| Turkey
|
2022 | 1 | 7 | 4 |
Rates. Plain table. Deaths per million
[edit]| Location | Year | Females | Males | Total |
|---|---|---|---|---|
| Austria | 2022 | 18 | 65 | 42 |
| Belgium | 2020 | 7 | 34 | 21 |
| Bulgaria | 2022 | 1 | 8 | 4 |
| Croatia | 2022 | 13 | 71 | 42 |
| Cyprus | 2022 | 3 | 13 | 8 |
| Czechia | 2022 | 6 | 12 | 9 |
| Denmark | 2021 | 19 | 60 | 40 |
| Estonia | 2022 | 34 | 155 | 95 |
| Finland | 2022 | 33 | 106 | 70 |
| France | 2016 | 3 | 16 | 9 |
| Germany | 2022 | 10 | 49 | 30 |
| Greece | 2020 | 10 | 58 | 34 |
| Hungary | 2021 | 3 | 9 | 6 |
| Ireland | 2020 | 64 | 130 | 97 |
| Italy | 2022 | 2 | 13 | 8 |
| Latvia | 2022 | 12 | 96 | 53 |
| Lithuania | 2022 | 10 | 86 | 47 |
| Luxembourg | 2022 | 5 | 31 | 18 |
| Malta | 2020 | 6 | 43 | 26 |
| Netherlands | 2022 | 13 | 40 | 26 |
| Norway | 2022 | 53 | 118 | 86 |
| Poland | 2021 | 5 | 11 | 8 |
| Portugal | 2021 | 4 | 19 | 11 |
| Romania | 2022 | 1 | 3 | 2 |
| Slovakia | 2021 | 3 | 12 | 7 |
| Slovenia | 2022 | 16 | 74 | 46 |
| Spain | 2021 | 7 | 34 | 21 |
| Sweden | 2022 | 35 | 102 | 70 |
| Türkiye | 2022 | 1 | 7 | 4 |
Reference
[edit]- ^ a b "Overdose situation (FAQ drug overdose deaths in Europe)". European Union Drugs Agency. Scroll down to Figure 1.5. Then; "Show data table".