Spreadsheet: 135962d1326330791-summing-values-in-array-using-a-cell-reference-test
Sheet: Sheet1

 | Home Country | Poland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 | Individual | Individual Lost Earnings/Productivity over working life
 |  | 2010 | 2015 | 2020
 |  |  |  |  |  |  |  |  |  | Assume annual inflation rate of |  |  |  | 25
 |  |  |  |  |  |  |  |  |  | Mean age of onset of RA (y) |  |  | 48.5
 |  |  |  |  |  |  |  |  |  | Mean length of time from diagnosis to leaving work (y) |  |  | 5.44
 |  |  |  |  |  |  |  |  |  | Assumed normal retirement age (y) |  |  | 65
 |  |  |  |  |  |  |  |  |  | Lost years of income (loss in productivity)/patient
 | Population Projections to 2040
 |  | 2010 | 2015 | 2020 | 2025 | 2030 | 2035 | 2040
 | Germany | 81748892 | 80953582 | 80098347 | 79077629 | 77871675 | 76478036 | 74814316 |  |  | Assumed annual incidence |  |  | Prevalence
 | Spain | 46152926 | 46923019 | 47961070 | 49027829 | 49961157 | 50867170 | 51713930 |  |  | Female | 0.00036 |  | Female | 0.0116
 | France | 65075310 | 66358014 | 67820253 | 69125300 | 70302983 | 71344846 | 72186344 |  |  | Male | 0.00014 |  | Male | 0.0044
 | Italy | 60626508 | 61787648 | 62876781 | 63737079 | 64491289 | 65165759 | 65694307 |  |  | overall | 0.00025 |  | Overall | 0.0081
 | Poland | 38200037 | 38369400 | 38395403 | 38121117 | 37564978 | 36856824 | 36112044
 | Sweden | 9415570 | 9732212 | 10071521 | 10354529 | 10577959 | 10745871 | 10898366
 | United Kingdom | 62435709 | 64147689 | 66292265 | 68350294 | 70207694 | 71873751 | 73443152
 | Turkey | 76505000 | 80524000 | 84301000 | 87756000 | 90806000 | 93284000 | 95060000
 | Average annual gross earnings by occupation of full-time employees in enterprises with 10 or more employees (ECU/EUR)
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
 |  | 2003 | 2004 | 2005 | 2006 | 2007 (e) | 2008 (e) | 2009 (e) | 2010 (e) | 2011 (e) | 2012 (e) | 2013 (e) | 2014 (e) | 2015 (e) | 2016 (e) | 2017 (e) | 2018 (e) | 2019 (e) | 2020 (e) | 2021 (e) | 2022 (e) | 2023 (e) | 2024 (e) | 2025 (e) | 2026 (e) | 2027 (e) | 2028 (e) | 2029 (e) | 2030 (e) | 2031 (e) | 2032 (e) | 2033 (e) | 2034 (e) | 2035 (e) | 2036 (e) | 2037 (e) | 2038 (e) | 2039 (e) | 2040 (e) | 2041 (e) | 2042 (e) | 2043 (e) | 2044 (e) | 2045 (e) | 2046 (e) | 2047 (e) | 2048 (e) | 2049 (e)
 | Germany | 37300 | 38000 | 38600 | 39066 | 40100 | 41200
 | Spain | 19367.7 | 20018.6 | 20593.9 | 21724.7 | 22176.5
 | France | 28978 | 30074 | 31034 | 32096 | 32991 | 33802 | 34424
 | Italy | 23150 | 24203 | 24975 | 25681 | 26277 | 27099 | 27533
 | Poland |  | 6278.7
 | Sweden | 32034 | 32344.2 | 32902.3 | 33915.3 | 35534 | 35442.1
 | United Kingdom | 37309.8 | 39768.1
 | Turkey
 | Source of Data |  |  | Eurostat  [earn_gr_isco]
 |  |  |  | OECD |  |  |  |  |  | Turkey: minimum wage/month |  |  | 385
 |  |  |  |  |  |  |  |  |  | (source: Jan 2011 Eurostat)
 |  | 2010 | 2015 | 2020
 |  | ave. annual gross earnings
 |  |  | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044 | 2045 | 2046 | 2047 | 2048 | 2049 | 2050 | 2051 | 2052 | 2053 | 2054 | 2055
 |  | Austria | 39023
 |  | Belgium | 38659
 |  | Bulgaria | 2626
 |  | Croatia | 9634
 |  | Cyprus | 21310
 |  | Czech Republic | 8284.4
 |  | Denmark | 53165
 |  | Estonia | : |  | 17988
 |  | Finland | 36114
 |  | France | 32413.4
 |  | Germany | 40200
 |  | Greece | : |  | 17524
 |  | Hungary | 8952
 |  | Ireland | 39858
 |  | Italy | 27099
 |  | Latvia | 8108.5
 |  | Lithuania | 3016
 |  | Luxembourg | 45284
 |  | Malta | 15679
 |  | Netherlands | 42000
 |  | Norway | 47221.4
 |  | Poland | 8177.9
 |  | Portugal | 15345.2
 |  | Romania | 4824.8
 |  | Slovakia | 8400.1
 |  | Slovenia | :
 |  | Spain | 21890.7
 |  | Sweden | 36871.4
 |  | Switzerland | 47095.9
 |  | Turkey |  |  |  | 4620
 |  | United Kingdom | 46050.5