Data listed 2015 and 2100: Difference between revisions
Jump to navigation
Jump to search
Ifsdatateam (talk | contribs) No edit summary |
Ifsdatateam (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
'''Variable for world<br/> | '''Variable for world'''<br/>This first sheet will include values for the world for all variables that were chosen to be compared. This will allow the variables to be sorted and compared easily.<br/>------------------------ | ||
{| border="0" cellpadding="0" cellspacing="0" width="678" | {| border="0" cellpadding="0" cellspacing="0" width="678" | ||
Line 59: | Line 59: | ||
| align="right" | 1 | | align="right" | 1 | ||
|} | |} | ||
------------------------ | |||
Line 64: | Line 66: | ||
---- | ---- | ||
'''Individual variable sheet<br/> | '''Individual variable sheet'''<br/>The following sheets are for individual countries and respective [https://pardee.du.edu/wiki/Variable_names variables]. It includes country, raw data, and ratio for intial year and last year. This allows to compare highest and lowest values and their respective raw data. | ||
'''Example 1 for GDP:''' | '''Example 1 for GDP:<br/>'''------------------------ | ||
{| border="0" cellpadding="0" cellspacing="0" width="565" | {| border="0" cellpadding="0" cellspacing="0" width="565" | ||
|- | |- | ||
| height="19" width="129" | | | height="19" width="129" | | ||
| width="77" | New base | | width="77" | New base | ||
Line 77: | Line 79: | ||
| width="64" | | | width="64" | | ||
| width="64" | | | width="64" | | ||
|- | |- | ||
| height="19" | | | height="19" | | ||
| GDP[10] | | GDP[10] | ||
Line 85: | Line 87: | ||
| | | | ||
| | | | ||
|- | |- | ||
| height="19" | Country | | height="19" | Country | ||
| 2015 values | | 2015 values | ||
Line 93: | Line 95: | ||
| 2015 ratio | | 2015 ratio | ||
| 2100 ratio | | 2100 ratio | ||
|- | |- | ||
| height="19" | Afghanistan | | height="19" | Afghanistan | ||
| align="right" | 0.022 | | align="right" | 0.022 | ||
Line 101: | Line 103: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.196145 | | align="right" | 1.196145 | ||
|- | |- | ||
| height="19" | Albania | | height="19" | Albania | ||
| align="right" | 0.014 | | align="right" | 0.014 | ||
Line 109: | Line 111: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.125 | | align="right" | 1.125 | ||
|- | |- | ||
| height="19" | Algeria | | height="19" | Algeria | ||
| align="right" | 0.229 | | align="right" | 0.229 | ||
Line 117: | Line 119: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.06689 | | align="right" | 1.06689 | ||
|- | |- | ||
| height="19" | Angola | | height="19" | Angola | ||
| align="right" | 0.135 | | align="right" | 0.135 | ||
Line 125: | Line 127: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 0.879923 | | align="right" | 0.879923 | ||
|- | |- | ||
| height="19" | Argentina | | height="19" | Argentina | ||
| align="right" | 0.538 | | align="right" | 0.538 | ||
Line 135: | Line 137: | ||
|} | |} | ||
'''Example 2 for POP:''' | ------------------------ | ||
'''Example 2 for POP:<br/>'''------------------------ | |||
{| border="0" cellpadding="0" cellspacing="0" width="648" | {| border="0" cellpadding="0" cellspacing="0" width="648" | ||
|- | |- | ||
| height="19" width="196" | POP | | height="19" width="196" | POP | ||
| width="81" | New base | | width="81" | New base | ||
Line 146: | Line 150: | ||
| width="64" | | | width="64" | | ||
| width="64" | | | width="64" | | ||
|- | |- | ||
| height="19" | Row Labels | | height="19" | Row Labels | ||
| align="right" | 2015 | | align="right" | 2015 | ||
Line 154: | Line 158: | ||
| 2015 ratio | | 2015 ratio | ||
| 2100 ratio | | 2100 ratio | ||
|- | |- | ||
| height="19" | Afghanistan | | height="19" | Afghanistan | ||
| align="right" | 34.41 | | align="right" | 34.41 | ||
Line 162: | Line 166: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.223069 | | align="right" | 1.223069 | ||
|- | |- | ||
| height="19" | Albania | | height="19" | Albania | ||
| align="right" | 2.891 | | align="right" | 2.891 | ||
Line 170: | Line 174: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 0.998189 | | align="right" | 0.998189 | ||
|- | |- | ||
| height="19" | Algeria | | height="19" | Algeria | ||
| align="right" | 39.73 | | align="right" | 39.73 | ||
Line 178: | Line 182: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.048678 | | align="right" | 1.048678 | ||
|- | |- | ||
| height="19" | Angola | | height="19" | Angola | ||
| align="right" | 27.88 | | align="right" | 27.88 | ||
Line 186: | Line 190: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.098371 | | align="right" | 1.098371 | ||
|- | |- | ||
| height="19" | Argentina | | height="19" | Argentina | ||
| align="right" | 43.08 | | align="right" | 43.08 | ||
Line 194: | Line 198: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.004914 | | align="right" | 1.004914 | ||
|- | |- | ||
| height="19" | Armenia | | height="19" | Armenia | ||
| align="right" | 2.926 | | align="right" | 2.926 | ||
Line 202: | Line 206: | ||
| align="right" | 1 | | align="right" | 1 | ||
| align="right" | 1.078402 | | align="right" | 1.078402 | ||
|- | |- | ||
| height="19" | Australia | | height="19" | Australia | ||
| align="right" | 23.93 | | align="right" | 23.93 | ||
Line 211: | Line 215: | ||
| align="right" | 1.0193 | | align="right" | 1.0193 | ||
|} | |} | ||
------------------------ | |||
Line 216: | Line 222: | ||
---- | ---- | ||
'''Final sheet<br/> | '''Final sheet'''<br/>This final sheet is created by appending all individual variable sheets. This sheet allows to sort values among all variables and countries.<br/>------------------------ | ||
{| border="0" cellpadding="0" cellspacing="0" width="670" | {| border="0" cellpadding="0" cellspacing="0" width="670" | ||
|- | |- | ||
| height="19" width="122" | Variable | | height="19" width="122" | Variable | ||
| width="196" | Country | | width="196" | Country | ||
Line 226: | Line 232: | ||
| width="64" | 2015 ratio | | width="64" | 2015 ratio | ||
| width="105" | 2100 ratio | | width="105" | 2100 ratio | ||
|- | |- | ||
| height="19" | INCOMELT310LN | | height="19" | INCOMELT310LN | ||
| Slovak Rep | | Slovak Rep | ||
Line 233: | Line 239: | ||
| align="right" | 180.2 | | align="right" | 180.2 | ||
| align="right" | 3,672 | | align="right" | 3,672 | ||
|- | |- | ||
| height="19" | INCOMELT310LN | | height="19" | INCOMELT310LN | ||
| Montenegro | | Montenegro | ||
Line 240: | Line 246: | ||
| align="right" | 149.5 | | align="right" | 149.5 | ||
| align="right" | 42,635 | | align="right" | 42,635 | ||
|- | |- | ||
| height="19" | INCOMELT310LN | | height="19" | INCOMELT310LN | ||
| Poland | | Poland | ||
Line 247: | Line 253: | ||
| align="right" | 114.1 | | align="right" | 114.1 | ||
| align="right" | 22,586 | | align="right" | 22,586 | ||
|- | |- | ||
| height="19" | INCOMELT310LN | | height="19" | INCOMELT310LN | ||
| Hungary | | Hungary | ||
Line 254: | Line 260: | ||
| align="right" | 99.91 | | align="right" | 99.91 | ||
| align="right" | 2,502 | | align="right" | 2,502 | ||
|- | |- | ||
| height="19" | INCOMELT310LN | | height="19" | INCOMELT310LN | ||
| Estonia | | Estonia | ||
Line 261: | Line 267: | ||
| align="right" | 28.16 | | align="right" | 28.16 | ||
| align="right" | 161 | | align="right" | 161 | ||
|- | |- | ||
| height="19" | INCOMELT310LN | | height="19" | INCOMELT310LN | ||
| Serbia | | Serbia | ||
Line 268: | Line 274: | ||
| align="right" | 19.4 | | align="right" | 19.4 | ||
| align="right" | 51,771 | | align="right" | 51,771 | ||
|- | |- | ||
| height="19" | INCOMELT310LN | | height="19" | INCOMELT310LN | ||
| Latvia | | Latvia | ||
Line 275: | Line 281: | ||
| align="right" | 16.14 | | align="right" | 16.14 | ||
| align="right" | 87.06 | | align="right" | 87.06 | ||
|- | |- | ||
| height="19" | VADD | | height="19" | VADD | ||
| Lesotho | | Lesotho | ||
Line 282: | Line 288: | ||
| align="right" | 10.75 | | align="right" | 10.75 | ||
| align="right" | 7.464 | | align="right" | 7.464 | ||
|- | |- | ||
| height="19" | VADD | | height="19" | VADD | ||
| Turkmenistan | | Turkmenistan | ||
Line 289: | Line 295: | ||
| align="right" | 4.554 | | align="right" | 4.554 | ||
| align="right" | 6.966 | | align="right" | 6.966 | ||
|- | |- | ||
| height="19" | INFRAELECACC | | height="19" | INFRAELECACC | ||
| Sudan South | | Sudan South | ||
Line 297: | Line 303: | ||
| align="right" | 1.012 | | align="right" | 1.012 | ||
|} | |} | ||
------------------------ | |||
<br/> |
Revision as of 15:56, 24 August 2020
Variable for world
This first sheet will include values for the world for all variables that were chosen to be compared. This will allow the variables to be sorted and compared easily.
------------------------
Variables | region | Unit | Ratio | 2015 | 2100 |
WATSAFE | World | UnImproved | IFsNew-X%GDP/IFsbaseold_j | 1 | 0.963 |
GOVREV | World | Trillion $ | IFsNew-X%GDP/IFsbaseold_j | 1 | 1.005 |
LIFEXP | World | Total | IFsNew-X%GDP/IFsbaseold_j | 1 | 0.9994 |
EDYRSAG15 | World | Total | IFsNew-X%GDP/IFsbaseold_j | 1 | 0.9991 |
EDYRSAG25 | World | Total | IFsNew-X%GDP/IFsbaseold_j | 1 | 0.9991 |
ENP | World | Total | IFsNew-X%GDP/IFsbaseold_j | 1 | 1.025 |
INFRAELECACC | World | Total | IFsNew-X%GDP/IFsbaseold_j | 1.006 | 1 |
Individual variable sheet
The following sheets are for individual countries and respective variables. It includes country, raw data, and ratio for intial year and last year. This allows to compare highest and lowest values and their respective raw data.
Example 1 for GDP:
------------------------
New base | Old base | New base | Old base | |||
GDP[10] | GDP[8] | GDP[10] | GDP[8] | |||
Country | 2015 values | 2015 values | 2100 values | 2100 values | 2015 ratio | 2100 ratio |
Afghanistan | 0.022 | 0.022 | 1.055 | 0.882 | 1 | 1.196145 |
Albania | 0.014 | 0.014 | 0.045 | 0.04 | 1 | 1.125 |
Algeria | 0.229 | 0.229 | 1.595 | 1.495 | 1 | 1.06689 |
Angola | 0.135 | 0.135 | 5.518 | 6.271 | 1 | 0.879923 |
Argentina | 0.538 | 0.538 | 2.472 | 2.493 | 1 | 0.991576 |
Example 2 for POP:
------------------------
POP | New base | Old base | New base | Old base | ||
Row Labels | 2015 | 2015 | 2100 | 2100 | 2015 ratio | 2100 ratio |
Afghanistan | 34.41 | 34.41 | 110.7 | 90.51 | 1 | 1.223069 |
Albania | 2.891 | 2.891 | 1.654 | 1.657 | 1 | 0.998189 |
Algeria | 39.73 | 39.73 | 64.63 | 61.63 | 1 | 1.048678 |
Angola | 27.88 | 27.88 | 168.6 | 153.5 | 1 | 1.098371 |
Argentina | 43.08 | 43.08 | 53.17 | 52.91 | 1 | 1.004914 |
Armenia | 2.926 | 2.926 | 2.132 | 1.977 | 1 | 1.078402 |
Australia | 23.93 | 23.93 | 39.61 | 38.86 | 1 | 1.0193 |
Final sheet
This final sheet is created by appending all individual variable sheets. This sheet allows to sort values among all variables and countries.
------------------------
Variable | Country | ratio | 2015 ratio | 2100 ratio | |
INCOMELT310LN | Slovak Rep | Mil People | IFsNew-X%GDP/IFsbaseold_j | 180.2 | 3,672 |
INCOMELT310LN | Montenegro | Mil People | IFsNew-X%GDP/IFsbaseold_j | 149.5 | 42,635 |
INCOMELT310LN | Poland | Mil People | IFsNew-X%GDP/IFsbaseold_j | 114.1 | 22,586 |
INCOMELT310LN | Hungary | Mil People | IFsNew-X%GDP/IFsbaseold_j | 99.91 | 2,502 |
INCOMELT310LN | Estonia | Mil People | IFsNew-X%GDP/IFsbaseold_j | 28.16 | 161 |
INCOMELT310LN | Serbia | Mil People | IFsNew-X%GDP/IFsbaseold_j | 19.4 | 51,771 |
INCOMELT310LN | Latvia | Mil People | IFsNew-X%GDP/IFsbaseold_j | 16.14 | 87.06 |
VADD | Lesotho | Materials | IFsNew-X%GDP/IFsbaseold_j | 10.75 | 7.464 |
VADD | Turkmenistan | ICTech | IFsNew-X%GDP/IFsbaseold_j | 4.554 | 6.966 |
INFRAELECACC | Sudan South | Total | IFsNew-X%GDP/IFsbaseold_j | 4.186 | 1.012 |