Government consumption preprocessor: Difference between revisions

From Pardee Wiki
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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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"
|-
| 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&nbsp;% of GDP (2000) - log</span><span style="background-color: rgb(255, 255, 0);"></span>
**'''This equation is using:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Govt Exp Hlth as&nbsp;% of GDP (2000) - log</span>




Line 127: Line 133:


*Initialize public R&D spending using '''SeriesR&DGovt%GDP'''&nbsp;(GExpRandD) and '''SeriesR&D%GDPWDI''' (ExpRandDTot).
*Initialize public R&D spending using '''SeriesR&DGovt%GDP'''&nbsp;(GExpRandD) and '''SeriesR&D%GDPWDI''' (ExpRandDTot).
*If ExpRandDTot is null then estimate using: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  
*If ExpRandDTot is null then estimate using: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
**TbName$ = "GDP/Capita (PPP) Versus R&D Total&nbsp; as&nbsp;% of GNI (" & CStr(BaseYear) & ") - linear"
**TbName$ = "GDP/Capita (PPP) Versus R&D Total&nbsp; as&nbsp;% of GNI (" & CStr(BaseYear) & ") - linear"
**'''This equation is using:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus R&D Total&nbsp; as&nbsp;% of GNI (2000) - linear</span>
**'''This equation is using:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus R&D Total&nbsp; as&nbsp;% of GNI (2000) - linear</span>
Line 163: Line 169:


*Private Function CalcInfraPubSpendCap
*Private Function CalcInfraPubSpendCap
<span style="color: rgb(0, 128, 0);"></span>
 
<span style="color: rgb(0, 128, 0);">'procedure for capping infrastructure fund demand as a&nbsp;% of GDP;</span>
<span style="color: rgb(0, 128, 0);">'procedure for capping infrastructure fund demand as a&nbsp;% 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