Government consumption preprocessor: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
= Series read = | = Sources = | ||
*[[WHO_Global_Health_Expenditure_Database]] | |||
*IMF | |||
*[[World_Development_Indicators|World Development Indicators (WDI)]] | |||
= Series read into DataGovCon = | |||
{| border="1" cellpadding="0" cellspacing="0" width="758" | {| border="1" cellpadding="0" cellspacing="0" width="758" | ||
|- | |- | ||
| height="20" width="243" | '''Table''' | | height="20" width="243" | '''Table''' | ||
| width="150" | '''Group''' | | width="150" | '''Group''' | ||
Line 9: | Line 15: | ||
| width="64" | '''Definition''' | | width="64" | '''Definition''' | ||
| width="64" | '''Last IFs Update''' | | width="64" | '''Last IFs Update''' | ||
|- | |- | ||
| height="20" | SeriesGovtMil%GDP | | height="20" | SeriesGovtMil%GDP | ||
| Government, Infrastructure, Conflict | | Government, Infrastructure, Conflict | ||
Line 16: | Line 22: | ||
| Military expenditures as percent of GDP (ACDA) | | Military expenditures as percent of GDP (ACDA) | ||
| Unknown | | Unknown | ||
|- | |- | ||
| height="20" | SeriesGovtMil%GDPSIPRI | | height="20" | SeriesGovtMil%GDPSIPRI | ||
| Government, Conflict | | Government, Conflict | ||
Line 23: | Line 29: | ||
| Military expenditures as percent of GDP (SIPRI) | | Military expenditures as percent of GDP (SIPRI) | ||
| 2013/06/13 | | 2013/06/13 | ||
|- | |- | ||
| height="20" | SeriesR&D%GDPWDI | | height="20" | SeriesR&D%GDPWDI | ||
| Science Technology, Infrastructure, Knowledge | | Science Technology, Infrastructure, Knowledge | ||
| R&D | | R&D | ||
| Constructed from multiple WDI vol;CD incl 01, 02, 04,05,06,07; 2006-2008 Update from UIS Website | | Constructed from multiple WDI vol;CD incl 01, 02, 04,05,06,07; 2006-2008 Update from UIS Website | ||
| R&D as % of GDP (in some earlier years was GNI) | | R&D as % of GDP (in some earlier years was GNI) | ||
| 2013/08/07 | | 2013/08/07 | ||
|- | |- | ||
| height="20" | SeriesR&DGovt%GDP | | height="20" | SeriesR&DGovt%GDP | ||
| Government | | Government | ||
Line 37: | Line 43: | ||
| Gross R&D expenditure by government | | Gross R&D expenditure by government | ||
| 2013/09/04 | | 2013/09/04 | ||
|- | |- | ||
| height="20" | SeriesGovtCalcHealthCen%GDP | | height="20" | SeriesGovtCalcHealthCen%GDP | ||
| Economic | | Economic | ||
| Finance | | Finance | ||
| IMF GFS 2013 BATCH PULL | | IMF GFS 2013 BATCH PULL | ||
| Health spending, government, Central government, as % of GDP | | Health spending, government, Central government, as % of GDP | ||
| 2013/12/20 | | 2013/12/20 | ||
|- | |- | ||
| height="20" | SeriesGovtCalcHealthTot%GDP | | height="20" | SeriesGovtCalcHealthTot%GDP | ||
| Economic | | Economic | ||
| Finance | | Finance | ||
| IMF GFS 2013 BATCH PULL | | IMF GFS 2013 BATCH PULL | ||
| Health spending, government, total, as % of GDP | | Health spending, government, total, as % of GDP | ||
| 2013/12/20 | | 2013/12/20 | ||
|- | |- | ||
| height="20" | SeriesGovtCalcEdCen%GDP | | height="20" | SeriesGovtCalcEdCen%GDP | ||
| Economic | | Economic | ||
| Finance | | Finance | ||
| IMF GFS 2013 BATCH PULL | | IMF GFS 2013 BATCH PULL | ||
| Education spending, government, Central government, as % of GDP | | Education spending, government, Central government, as % of GDP | ||
| 2013/12/20 | | 2013/12/20 | ||
|- | |- | ||
| height="20" | SeriesGovtCalcEdTot%GDP | | height="20" | SeriesGovtCalcEdTot%GDP | ||
| Economic | | Economic | ||
| Finance | | Finance | ||
| IMF GFS 2013 BATCH PULL | | IMF GFS 2013 BATCH PULL | ||
| Education spending, government, total, as % of GDP | | Education spending, government, total, as % of GDP | ||
| 2013/12/20 | | 2013/12/20 | ||
|- | |- | ||
| height="20" | SeriesHealthExpPriv%Tot | | height="20" | SeriesHealthExpPriv%Tot | ||
| Population, Health | | Population, Health | ||
| Expenditure | | Expenditure | ||
| WHO Global Health Expenditure Database | | WHO Global Health Expenditure Database | ||
| Private expenditure on health (PvtHE) as % of Total Health Expenditure | | Private expenditure on health (PvtHE) as % of Total Health Expenditure | ||
| 2014/04/22 | | 2014/04/22 | ||
|- | |- | ||
| height="20" | SeriesHealthExpTot%GDP | | height="20" | SeriesHealthExpTot%GDP | ||
| Population, Health | | Population, Health | ||
| Expenditure | | Expenditure | ||
| WHO Global Health Expenditure Database | | WHO Global Health Expenditure Database | ||
| Total health expenditure (THE) % Gross Domestic Product (GDP) | | Total health expenditure (THE) % Gross Domestic Product (GDP) | ||
| 2014/04/22 | | 2014/04/22 | ||
|- | |- | ||
| height="20" | SeriesGovtHl%GDP | | height="20" | SeriesGovtHl%GDP | ||
| Government, Health, Infrastructure | | Government, Health, Infrastructure | ||
Line 86: | Line 92: | ||
| Health expenditures as percent of GDP, public | | Health expenditures as percent of GDP, public | ||
| 2015/07/14 | | 2015/07/14 | ||
|- | |- | ||
| height="20" | SeriesGovtEdPub%GDP | | height="20" | SeriesGovtEdPub%GDP | ||
| Government | | Government | ||
Line 107: | Line 113: | ||
*Initialize public health expenditures using '''SeriesGovtHl%GDP.''' | *Initialize public health expenditures using '''SeriesGovtHl%GDP.''' | ||
*If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (" & CStr(BaseYear) & ") - log" | *If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (" & CStr(BaseYear) & ") - log" | ||
**'''This equation is using:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (2000) - log | **'''This equation is using:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (2000) - log</span> | ||
Line 127: | Line 133: | ||
*Initialize public R&D spending using '''SeriesR&DGovt%GDP''' (GExpRandD) and '''SeriesR&D%GDPWDI''' (ExpRandDTot). | *Initialize public R&D spending using '''SeriesR&DGovt%GDP''' (GExpRandD) and '''SeriesR&D%GDPWDI''' (ExpRandDTot). | ||
*If ExpRandDTot is null then estimate using: | *If ExpRandDTot is null then estimate using: | ||
**TbName$ = "GDP/Capita (PPP) Versus R&D Total as % of GNI (" & CStr(BaseYear) & ") - linear" | **TbName$ = "GDP/Capita (PPP) Versus R&D Total as % of GNI (" & CStr(BaseYear) & ") - linear" | ||
**'''This equation is using:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus R&D Total as % of GNI (2000) - linear</span> | **'''This equation is using:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus R&D Total as % of GNI (2000) - linear</span> | ||
Line 163: | Line 169: | ||
*Private Function CalcInfraPubSpendCap | *Private Function CalcInfraPubSpendCap | ||
<span style="color: rgb(0, 128, 0);">'procedure for capping infrastructure fund demand as a % of GDP;</span> | <span style="color: rgb(0, 128, 0);">'procedure for capping infrastructure fund demand as a % of GDP;</span> | ||
<span style="color: rgb(0, 128, 0);">'uses inverted V suggested by BBH</span> | <span style="color: rgb(0, 128, 0);">'uses inverted V suggested by BBH</span> |
Revision as of 18:15, 17 May 2016
Sources
Series read into DataGovCon
Table | Group | Subgroup | Source | Definition | Last IFs Update |
SeriesGovtMil%GDP | Government, Infrastructure, Conflict | Expenditure | ACDA www.state.gov/global/arms/bureau_ac/reports_ac.html + asst earlier volumes | Military expenditures as percent of GDP (ACDA) | Unknown |
SeriesGovtMil%GDPSIPRI | Government, Conflict | Expenditure | SIPRI, Stockholm International Peace Research Institute | Military expenditures as percent of GDP (SIPRI) | 2013/06/13 |
SeriesR&D%GDPWDI | Science Technology, Infrastructure, Knowledge | R&D | Constructed from multiple WDI vol;CD incl 01, 02, 04,05,06,07; 2006-2008 Update from UIS Website | R&D as % of GDP (in some earlier years was GNI) | 2013/08/07 |
SeriesR&DGovt%GDP | Government | Research and Development | UNESCO | Gross R&D expenditure by government | 2013/09/04 |
SeriesGovtCalcHealthCen%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Health spending, government, Central government, as % of GDP | 2013/12/20 |
SeriesGovtCalcHealthTot%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Health spending, government, total, as % of GDP | 2013/12/20 |
SeriesGovtCalcEdCen%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Education spending, government, Central government, as % of GDP | 2013/12/20 |
SeriesGovtCalcEdTot%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Education spending, government, total, as % of GDP | 2013/12/20 |
SeriesHealthExpPriv%Tot | Population, Health | Expenditure | WHO Global Health Expenditure Database | Private expenditure on health (PvtHE) as % of Total Health Expenditure | 2014/04/22 |
SeriesHealthExpTot%GDP | Population, Health | Expenditure | WHO Global Health Expenditure Database | Total health expenditure (THE) % Gross Domestic Product (GDP) | 2014/04/22 |
SeriesGovtHl%GDP | Government, Health, Infrastructure | Expenditure | WDI BATCH PULL | Health expenditures as percent of GDP, public | 2015/07/14 |
SeriesGovtEdPub%GDP | Government | Expenditure | WDI BATCH PULL | Educational expenditures (public) as percent of GDP | 2015/07/14 |
Initializations
Defense
- Initialize defense expenditures using SeriesGovtMil%GDPSIPRI. If null, then use SeriesGovtMil%GDP.
- If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Mil as % of GDP (" & CStr(BaseYear) & ") - linear"
- This equation is using: GDP/Capita (PPP) Versus Govt Exp Mil as % of GDP (2000) - linear
Health
- Initialize public health expenditures using SeriesGovtHl%GDP.
- If null estimate using GDPPCP: TbName$ = "GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (" & CStr(BaseYear) & ") - log"
- This equation is using: GDP/Capita (PPP) Versus Govt Exp Hlth as % of GDP (2000) - log
- Initialize private health expenditures using SeriesHealthExpPriv%Tot. If no data, but there is data on total health expenditures (SeriesHealthExpTot%GDP) then set private as the difference between total and public.
- If no data on total health expenditure then estimate private using:
'Estimate Private
Call AnalFunc("Private Health Expenditures % of GDP (2012)", _
Array(CGDPPCP(ICount%), CEDYRSAGE25T(ICount%)), cVal, _
Array("GDP2005PCPPP(MOSTRECENT)/ 1000 (Log)", "EdYearsAge25(MOSTRECENT) (Linear)"))
- If no data on total expenditures, then it is the sum of private and public.
Education
- Initialize public spending on education using SeriesGovtEdPub%GDP. If null then use:
- Call XYTABL("GDP/Capita (PPP) Versus Govt Exp Educ as % of GDP (2002) - log", Amin(40, CGDPPCP(ICount%)), GExpEd(ICount%))
- Bound as 1.5% as a minimum. Set Uzbekistan to 3%.
R & D
- Initialize public R&D spending using SeriesR&DGovt%GDP (GExpRandD) and SeriesR&D%GDPWDI (ExpRandDTot).
- If ExpRandDTot is null then estimate using:
- TbName$ = "GDP/Capita (PPP) Versus R&D Total as % of GNI (" & CStr(BaseYear) & ") - linear"
- This equation is using: GDP/Capita (PPP) Versus R&D Total as % of GNI (2000) - linear
- If GExpRandD is null then estimate using: TbName$ = "GDP/Capita (PPP) Versus Govt Exp R&D as % of GNP (" & CStr(BaseYear) & ") - linear"
- This equation is using: GDP/Capita (PPP) Versus Govt Exp R&D as % of GNP (2000) - linear
- Initialize central government health expenditures (GExpHlCen) using SeriesGovtCalcHealthCen%GDP
- Initialize total government health expenditures (GExpHlTot) using SeriesGovtCalcHealthTot%GDP
- Initialize central government education expenditures (GExpEdCen) using SeriesGovtCalcEdCen%GDP
- Initialize total government education expenditures (GExpEdTot) using SeriesGovtCalcEdTot%GDP
- Note: These initializations should probably be moved to health and education
Infrastructure
'-- Infrastructure Expenditure : Build up from components calculated in DataInfra: for historical and regular base--
'switch to turn infrastructure finance on and off
- Note: default setting of infrastructure finance is on (1) - changing this to off (0) in global parameters (IFs.mdb) means that infrastructure spending is initialized at zero.
- If infrastructure finance is on (default) then sum up new construction and maintenance from all sub-types of infrastructure. Cap at 10% of GDP.
InfraOther
'non-core or 'other' infrastructure as a % of GDP - using function estimated by DSR
- GExpInfraOther(ICount%) = 1.8162 + 0.061 * Log(CGDPPCP(ICount%))
Output
- Read everything to GovConsumptionOutput
Cap Infra spending
- Private Function CalcInfraPubSpendCap
'procedure for capping infrastructure fund demand as a % of GDP;
'uses inverted V suggested by BBH