Difference between revisions of "Data listed 2015 and 2100"

From Wiki
Jump to: navigation, search
Line 1: Line 1:
'''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/>------------------------
+
'''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/>'''The following sheets are&nbsp;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&nbsp;to compare highest and lowest values and their respective raw data.
+
'''Individual variable sheet'''<br/>The following sheets are&nbsp;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&nbsp;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"
+
|-
 
| 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" | &nbsp;
 
| height="19" | &nbsp;
 
| GDP[10]
 
| GDP[10]
Line 85: Line 87:
 
|  
 
|  
 
|  
 
|  
|- height="19"
+
|-
 
| height="19" | Country
 
| height="19" | Country
 
| 2015 values
 
| 2015 values
Line 93: Line 95:
 
| 2015 ratio
 
| 2015 ratio
 
| 2100 ratio
 
| 2100 ratio
|- height="19"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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/>'''This final sheet is created by appending all individual variable sheets. This sheet allows to sort values among all variables and countries.
+
'''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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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"
+
|-
 
| 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