Government consumption preprocessor: Difference between revisions
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
{| border="1" cellpadding="0" cellspacing="0" width="694" | {| border="1" cellpadding="0" cellspacing="0" width="694" | ||
|- | |- | ||
| height="20" width="243" | SeriesGovtMil%GDPSIPRI | | height="20" width="243" | SeriesGovtMil%GDPSIPRI | ||
| width="150" | Government, Conflict | | width="150" | Government, Conflict | ||
| Line 8: | Line 8: | ||
| width="173" | <span style="background-color:#FFFF00;">SIPRI, Stockholm International Peace Research Institute</span> | | width="173" | <span style="background-color:#FFFF00;">SIPRI, Stockholm International Peace Research Institute</span> | ||
| width="64" | Military expenditures as percent of GDP (SIPRI) | | width="64" | Military expenditures as percent of GDP (SIPRI) | ||
|- | |- | ||
| height="20" | SeriesGovtMil%GDP | | height="20" | SeriesGovtMil%GDP | ||
| Government, Infrastructure, Conflict | | Government, Infrastructure, Conflict | ||
| Line 14: | Line 14: | ||
| <span style="background-color:#FFFF00;">ACDA www.state.gov/global/arms/bureau_ac/reports_ac.html + asst earlier volumes</span> | | <span style="background-color:#FFFF00;">ACDA www.state.gov/global/arms/bureau_ac/reports_ac.html + asst earlier volumes</span> | ||
| Military expenditures as percent of GDP (ACDA) | | Military expenditures as percent of GDP (ACDA) | ||
|- | |- | ||
| height="20" | SeriesGovtHl%GDP | | height="20" | SeriesGovtHl%GDP | ||
| Government, Health, Infrastructure | | Government, Health, Infrastructure | ||
| Line 20: | Line 20: | ||
| WDI BATCH PULL | | WDI BATCH PULL | ||
| Health expenditures as percent of GDP, public | | Health expenditures as percent of GDP, public | ||
|- | |- | ||
| 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 | ||
|- | |- | ||
| 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) | ||
|- | |- | ||
| height="20" | SeriesGovtEdPub%GDP | | height="20" | SeriesGovtEdPub%GDP | ||
| Government | | Government | ||
| Line 38: | Line 38: | ||
| WDI BATCH PULL | | WDI BATCH PULL | ||
| Educational expenditures (public) as percent of GDP | | Educational expenditures (public) as percent of GDP | ||
|- | |- | ||
| height="20" | SeriesR&DGovt%GDP | | height="20" | SeriesR&DGovt%GDP | ||
| Government | | Government | ||
| Line 44: | Line 44: | ||
| <span style="background-color:#FFFF00;">UNESCO</span> | | <span style="background-color:#FFFF00;">UNESCO</span> | ||
| Gross R&D expenditure by government | | Gross R&D expenditure by government | ||
|- | |- | ||
| height="20" | SeriesR&D%GDPWDI | | height="20" | SeriesR&D%GDPWDI | ||
| Science Technology, Infrastructure, Knowledge | | Science Technology, Infrastructure, Knowledge | ||
| R&D | | R&D | ||
| <span style="background-color:#FFFF00;">Constructed from multiple WDI vol;CD incl 01, 02, 04,05,06,07; 2006-2008 Update from UIS Website</span> | | <span style="background-color:#FFFF00;">Constructed from multiple WDI vol;CD incl 01, 02, 04,05,06,07; 2006-2008 Update from UIS Website</span> | ||
| R&D as % of GDP (in some earlier years was GNI) | | R&D as % of GDP (in some earlier years was GNI) | ||
|- | |- | ||
| 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 | ||
|- | |- | ||
| 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 | ||
|- | |- | ||
| 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 | ||
|- | |- | ||
| 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 | ||
|} | |} | ||
= Equations = | |||
== Defense == | |||
"GDP/Capita (PPP) Versus Govt Exp Mil as % of GDP (" & CStr(BaseYear) & ") - linear" | |||
This equation is using | |||
= Defense = | = Defense = | ||
| Line 108: | Line 116: | ||
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: TbName$ = "GDP/Capita (PPP) Versus R&D Total as % of GNI (" & CStr(BaseYear) & ") - linear" | If ExpRandDTot is null then estimate using: TbName$ = "GDP/Capita (PPP) Versus R&D Total as % of GNI (" & CStr(BaseYear) & ") - linear" | ||
If GExpRandD is null then estimate using: TbName$ = "GDP/Capita (PPP) Versus Govt Exp R&D as % of GNP (" & CStr(BaseYear) & ") - linear" | If GExpRandD is null then estimate using: TbName$ = "GDP/Capita (PPP) Versus Govt Exp R&D as % of GNP (" & CStr(BaseYear) & ") - linear" | ||
Initialize central government health expenditures (GExpHlCen) using '''SeriesGovtCalcHealthCen%GDP''' | Initialize central government health expenditures (GExpHlCen) using '''SeriesGovtCalcHealthCen%GDP''' | ||
| Line 122: | Line 130: | ||
= Infrastructure = | = Infrastructure = | ||
<span style="color: rgb(0, 128, 0);"> '-- Infrastructure Expenditure : Build up from components calculated in DataInfra: for historical and regular base--</span> | <span style="color: rgb(0, 128, 0);"> '-- Infrastructure Expenditure : Build up from components calculated in DataInfra: for historical and regular base--</span> | ||
<span style="color: rgb(0, 128, 0);"> 'switch to turn infrastructure finance on and off</span> | |||
''<span style="color: rgb(0, 0, 0);">'''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.</span>'' | ''<span style="color: rgb(0, 0, 0);">'''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.</span>'' | ||
| Line 132: | Line 140: | ||
= InfraOther = | = InfraOther = | ||
<span style="color: rgb(0, 128, 0);"> 'non-core or 'other' infrastructure as a % of GDP - using function estimated by DSR</span><br/> GExpInfraOther(ICount%) = 1.8162 + 0.061 * Log(CGDPPCP(ICount%)) | <span style="color: rgb(0, 128, 0);"> 'non-core or 'other' infrastructure as a % of GDP - using function estimated by DSR</span><br/> GExpInfraOther(ICount%) = 1.8162 + 0.061 * Log(CGDPPCP(ICount%)) | ||
= Output = | = Output = | ||
| Line 142: | Line 150: | ||
Private Function CalcInfraPubSpendCap | Private Function CalcInfraPubSpendCap | ||
<span style="color: rgb(0, 128, 0);">'procedure for capping infrastructure fund demand as a % of GDP;<br/>'uses inverted V suggested by BBH</span> | <span style="color: rgb(0, 128, 0);">'procedure for capping infrastructure fund demand as a % of GDP;<br/>'uses inverted V suggested by BBH</span> | ||
Revision as of 21:17, 16 May 2016
Series read
| SeriesGovtMil%GDPSIPRI | Government, Conflict | Expenditure | SIPRI, Stockholm International Peace Research Institute | Military expenditures as percent of GDP (SIPRI) |
| 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) |
| SeriesGovtHl%GDP | Government, Health, Infrastructure | Expenditure | WDI BATCH PULL | Health expenditures as percent of GDP, public |
| SeriesHealthExpPriv%Tot | Population, Health | Expenditure | WHO Global Health Expenditure Database | Private expenditure on health (PvtHE) as % of Total Health Expenditure |
| SeriesHealthExpTot%GDP | Population, Health | Expenditure | WHO Global Health Expenditure Database | Total health expenditure (THE) % Gross Domestic Product (GDP) |
| SeriesGovtEdPub%GDP | Government | Expenditure | WDI BATCH PULL | Educational expenditures (public) as percent of GDP |
| SeriesR&DGovt%GDP | Government | Research and Development | UNESCO | Gross R&D expenditure by government |
| 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) |
| SeriesGovtCalcHealthCen%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Health spending, government, Central government, as % of GDP |
| SeriesGovtCalcHealthTot%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Health spending, government, total, as % of GDP |
| SeriesGovtCalcEdCen%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Education spending, government, Central government, as % of GDP |
| SeriesGovtCalcEdTot%GDP | Economic | Finance | IMF GFS 2013 BATCH PULL | Education spending, government, total, as % of GDP |
Equations
Defense
"GDP/Capita (PPP) Versus Govt Exp Mil as % of GDP (" & CStr(BaseYear) & ") - linear"
This equation is using
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"
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"
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"
If GExpRandD is null then estimate using: TbName$ = "GDP/Capita (PPP) Versus Govt Exp R&D as % of GNP (" & CStr(BaseYear) & ") - 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
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