Economic preprocessor: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
(Created page with "{| border="1" cellspacing="1" cellpadding="1" |- | <br/> | <br/> | <br/> | <br/> | <br/> | <br/> | <br/> |- | SeriesGDP2011 | <br/> | <br/> | <br/> | <br/> | <br/> | <br/> |-...")
 
No edit summary
 
(141 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{| border="1" cellspacing="1" cellpadding="1"
There are 74 series read into the economic preprocessor.&nbsp;Most of them come from [[World_Development_Indicators|World Development&nbsp;Indicators]] (WDI). There are quite a few series marked as "IMF GFS 2013 BATCH PULL". There are a lot of data on the informal economy from ILO-WIEGO. Cyber data also appears to be read into DataEcon.
 
= Sources =
 
*[[International_Monetary_Fund_(IMF)|IMF]]&nbsp;
*[[ILO|ILO]]&nbsp;
*[[World_Development_Indicators|WDI]]
*[[Global_Trade_Analysis_Project_(GTAP)|Global&nbsp;Trade&nbsp;Analysis&nbsp;Project&nbsp;(GTAP)&nbsp;]]
*[[OECD_Factbook|OECD_Factbook]]
 
= Economic series used in preprocessor =
 
{| cellspacing="0" border="1" bgcolor="#ffffff"
|+ '''DataDict'''
|-
|-
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Table</font>
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Last IFs Update</font>
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">UsedInPreprocessorFileName</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGDPInformal%Elgin</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Available at: [http://www.econ.boun.edu.tr/public_html/RePEc/pdf/201205.pdf http://www.econ.boun.edu.tr/public_html/RePEc/pdf/201205.pdf]</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2014/04/04</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGDP2003PPP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">CIA (original partly World Bank); extended by Evan Hillebrand</span></font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2004/07</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovtPension%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">Data was processed from World Bank's pensions site.</span></font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/07/22</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalFemale%FormalSec</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalFemale%HHInformal</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalMale%InformalSec</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalFemale%InformalSec</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalFormSec%TotalInformal</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalHH%TotalInformal</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalInfSec%TotalInformal</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalMale%FormalSec</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLaborInformalMale%HHInformal</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ILO-WIEGO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovtCalcRevTot%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">IMF GFS 2013 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/12/20</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovtCalcRevCen%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">IMF GFS 2013 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/12/20</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovtCalcExpendTot%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">IMF GFS 2013 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/12/20</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovtCalcExpendCen%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">IMF GFS 2013 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/12/20</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesTaxCorp%Tot</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">IMF Government Finance Statistics (2001)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/09/04</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesVaddICT%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Information Society Statistics Pocketbook 2001</font><br/>
| <br/>
| <br/>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovTotalOutlays%GDP</font>
| <br/>
| [[OECD_Statistics_Database_Online|OECD_Statistics_Database_Online]]<br/>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/04/10</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|-
|- valign="top"
| SeriesGDP2011
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGDPInformal%Blended</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">UNECE, "Non-Observed Economy in National Accounts: Survey of Country Practices"; [http://rru.worldbank.org/Documents/PapersLinks/informal_economy.pdf http://rru.worldbank.org/Documents/PapersLinks/informal_economy.pdf]; [http://www.econ.boun.edu.tr/public_html/RePEc/pdf/201205.pdf http://www.econ.boun.edu.tr/public_html/RePEc/pdf/201205.pdf]</font><br/>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/01/13</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesAidDon%GNI</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">United Nations Statistics Division</font>
|-
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/12/09</font>
| SeriesGDP2000PCPPP
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXPortEquity%GDP</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXReserves%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesHouseCon%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesVaddInd%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesArmsImp%TotImp</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovtCurRev%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovtDebt%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesVaddMan%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesExportsMerchandise</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXDebtPPG%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXPortBonds%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXIncPayments%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXFlowsIDA%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXIMFCredit%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXFlowsIMFNonCon%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXWorkerRemitPaid</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesAidRecGrant%Total</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXDebtPNG%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXFDIInflows%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesVaddSer%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesExportServices</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXIncReceipts%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesExportGoodSer%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesTaxSocSec%CurRev</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesTaxGoodSer%CurRev</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXCurActBal%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXDebt</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXFlowsIMFCon%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXFDIOutflows%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesVaddAg%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXFlowsIBRD%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesImportsMerchandise</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesImportServices</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesImportGoodSer%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovExpense%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovCon%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXWBLoans%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/15</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesAidRec%GNI</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesXWorkerRemitReceived</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2017/03/29</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGiniExtended</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI World Bank, Klaus Deininger 202-473-0430 and Lyu Squire 202-473-6099; plus WDI CD 2002 for 1997-2000; plus WD 2002; plus UNDP HDR 2005; WDI 2008; WDI 2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/17</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovSSWelBen%Exp</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011/12/22</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTExport%Exp</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/11/08</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTImport%Imp</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/11/08</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGDP2005PCPPP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2013; extrapolated based on previous GDP_PCPPP2005 values in IFs; extrapolated based on CIA Factbook; taken directly from CIA Factbook; taken directly from previous GDP_PCPPP2005 values in IFs</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/12/23</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|-
|-
| SeriesGDP2011PCPPP
| SeriesGDP2011PCPPP
| <br/>
| WDI 2017
| <br/>
| 2017/03/29
| <br/>
| ECON
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesPovertyGap$1c90perDay</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015</font>
|-
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/12/03</font>
| SeriesExportGoodSer%
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesIncBelow1D90c%WDI</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/11/04</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
|-
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesIncBelow3D10c%WDI</font>
| SeriesImportGoodSer%
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/11/04</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesIncBelow2Dollar%WDI2011</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015 BATCH PULL</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/22</font>
|-
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| SeriesAIDRec%GNI
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesPopForeign%</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015 BATCH PULL</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/22</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesOresMetsEx%MerchEx</font>
|-
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015 BATCH PULL</font>
| SeriesXWorkerRemitPaid
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/22</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesIncShareL20%</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015 BATCH PULL</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/22</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
|-
|- valign="top"
| SeriesXWorkerRemitReceived
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesInvestGrCapForm%GDP</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015 BATCH PULL</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/22</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
|- valign="top"
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesOresMetsIm%MerchIm</font>
| <br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015 BATCH PULL</font>
|-
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/22</font>
| SeriesXCurActBal%GDP
| <font style="font-size: 11pt;" face="calibri" color="#000000">ECON</font>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|-
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|}
|}
= Initializations =
Use government consumption and expenditures data to initialize SAM.
== Government consumption ==
*Government consumption (CGovCon) is initialized&nbsp;using&nbsp;'''SeriesGovCon%GDP.'''
**'''Source:'''&nbsp;WDI
**'''Definition:&nbsp;'''Government (general) final consumption as&nbsp;% of GDP
**'''Country coverage:''' 182 countries
**Source definition:"<span style="line-height: 1.6;">General government final consumption expenditure (formerly general government consumption) includes all government current expenditures for purchases of goods and services (including compensation of employees). It also includes most expenditures on national defense and security, but excludes government military expenditures that are part of government capital formation"</span>
**'''If null:''' "GDP/Capita (PPP) Versus Govt Cons&nbsp;% GDP (" & CStr(BaseYear) & ")"
**'''This uses the equation:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Govt Cons&nbsp;% GDP (2000)</span>
*CGConFromSectors = GExpDef(ICount%) + GExpEd(ICount%) + GExpRandD(ICount%) + GExpHl(ICount%) + GExpInfra(ICount%) + GExpInfraOther(ICount%)
**Government consumption by sector is initialized in the [[Government_consumption_preprocessor|<font color="#000080">government consumption preprocessor</font>]]&nbsp;(DataGovCon).
*Set CGovCon as the max of CGovCon and the CGovCon calculated as the sum of sectors. Bound between 9 and 35.
== Government expenditures ==
Initialize central government expenditures and total government expenditures and then calculate local government expenditures as the difference.
*Central government expenditures (GovExpCentral)&nbsp;is initialized using '''SeriesGovExpense%GDP'''
**'''Source:''' WDI
**'''Definition:'''&nbsp;Government expense as&nbsp;% of GDP (compare with govt expenditures)
*If null then use '''SeriesGovtCalcExpendCen%GDP&nbsp;'''
*'''If still null then use: '''"GDP/Capita (PPP 2005) Versus Govt Expense&nbsp;% GDP (" & CStr(BaseYear) & ") Log"
*'''This equation uses:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP 2005) Versus Govt Expense&nbsp;% GDP (2010) Log</span>
*<span style="background-color: rgb(255, 255, 0);">'''Note:''' IMF series (GovtCalcExpendCen%GDP) appears to be central government expenditures while the WDI series does not specify.</span>
*Use '''SeriesGovtCalcExpendTot%GDP'''&nbsp;to initialize '''total''' government expenditures.
**'''Source:''' IMF GFS
**'''Definition:'''&nbsp;Expenditure, government, total, as&nbsp;% of GDP
*If null, then use '''SeriesGovTotalOutlays%GDP'''
**'''Source: '''OECD Statistics Database Online
**'''Definition:&nbsp;'''Government total outlays (% of GDP), including forecast
*''<span style="background-color: rgb(255, 255, 0);">'''Note:''' Must make sure these two series are identical</span>''
*Hard code 46 in for Ireland in 2010 because of bailout.
*If no data on total expenditures&nbsp;still, then we cannot estimate local so we use this equation:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If IsNull(CGovTotExp) Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CGovExpLocal(ICount%) = 2 + 12 * Amin(20, CGDPPCP(ICount%)) / 20<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CGovExpLocal(ICount%) = AMAX(1, CGovTotExp - GovExpCentral)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Go to total govt expenditures and filling holes when have data in order to compute local govt<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When do not have total and therefore ability to compute local govt,<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; estimate at 2-14% of GDP (OECD gap between total and central is 14%)<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; North, Walli, Weingast p. 10 have table showing grows from 1-2% to 16%</span>
*CGovExp(ICount%) = GovExpCentral + CGovExpLocal(ICount%) <span style="color: rgb(0, 128, 0);">'Add Central plus local to get total</span>
== Government revenue ==
*Central government revenue (GovRevCen) is initialized using '''SeriesGovtCurRev%GDP'''
**'''Source:''' WDI
**'''Definition:&nbsp;'''Current government revenue as&nbsp;% of GDP
**'''Extended definition:&nbsp;'''blended with old Ifs data. &nbsp;Revenue is cash receipts from taxes, social contributions, and other revenues such as fines, fees, rent, and income from property or sales. Grants are also considered as revenue but are excluded here.
*If it's null or less than 5 then we use GDP per capita to&nbsp;estimate.
**'''To fill holes:''' "GDP/Capita (PPP) Versus Govt Revenue (" & CStr(BaseYear) & ")"
**'''This equation uses:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Govt Revenue (2000)</span>
*Total government revenue (GovRevTot) is initialized using '''SeriesGovtCalcRevTot%GDP'''
**'''Source:''' IMF GFS
**'''Definition:&nbsp;'''Revenue, government, total, as&nbsp;% of GDP
*If GovRevTot is null i.e. there is no data for total government revenue for the country in SeriesGovtCalcRevTot%GDP (or the value is less than 5) then esimate using GDP per capita (2005).
**'''To fill holes:''' <span style="background-color: rgb(255, 255, 0);">"GDP/Capita (PPP 2005) Versus Govt Revenue Total (2010) Log"</span>
*Then set GovRevTot as the max of total government revenues and central government revenues
*Cap total government revenues at 75
*Set local government revenue as the difference between total and central
*'''''<span style="background-color: rgb(255, 255, 0);">Note:</span>'''<span style="background-color: rgb(255, 255, 0);">This logic creates problems for countries where there is&nbsp;not&nbsp;a total government revenue data point but there is a&nbsp;central government data point (ex. Malawi). In this case, both total government revenue and central government revenue are initialized as the data value for central government revenue and local government revenue is set at zero (the difference between total and central).</span>''
*Firm tax rate (CFirmTaxR)&nbsp;is initialized using '''SeriesTaxCorp%Tot'''
**'''Source:''' IMF Government Finance Statistics (2001)
**'''Definition:'''&nbsp;Corporate taxes as percent of total central government revenue
**''<span style="background-color: rgb(255, 255, 0);">'''Note:''' Apparently not part of batch pull.</span>''
*'''<font style="background-color: rgb(255, 255, 0);"><span style="background-color: rgb(255, 255, 255);">To fill holes:</span></font>'''"GDP/Capita (PPP) Versus Corporate Tax&nbsp;% of Total (" & CStr(BaseYear) & ")"
**'''This equation uses:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Corporate Tax&nbsp;% of Total (2000)</span>
*Social security tax (CSSWelTaxR)&nbsp;is initialized using '''SeriesTaxSocSec%CurRev&nbsp;'''
**'''Source: '''WDI
**'''Definition:&nbsp;'''Social security taxes as&nbsp;% of total govt revenue
*'''To fill holes:''' "GDP/Capita (PPP) Versus SS Tax&nbsp;% of Total (" & CStr(BaseYear) & ")"
**'''This equation uses:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus SS Tax&nbsp;% of Total (2000)</span>
*Indirect taxes (CIndirectTaxR) is initialized using '''SeriesTaxGoodSer%CurRev'''
**'''Source: '''WDI
**'''Definition:&nbsp;'''Taxes on goods and services as&nbsp;% of total govt revenue
*'''To fill holes:''' "GDP/Capita (PPP) Versus Indirect Tax&nbsp;% of Total (" & CStr(BaseYear) & ")"
**'''This equation uses:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Indirect Tax&nbsp;% of Total (2000)</span>
*Household taxes (CHHTaxR) estimated as residual from firm, welfare, and indirect taxes
== Transfers ==
*CGovSSWel is initialized using '''SeriesGovSSWelBen%Exp'''
**'''Source:''' WDI
**'''Definition:&nbsp;'''Government Social Security and welfare expenditures as&nbsp;% of total expenditures
**''<span style="background-color: rgb(255, 255, 0);">'''Note: '''Not included in last WDI batch pull</span>''
*'''To fill holes:''' "GDP/Capita (PPP 2005) Versus Govt Expense&nbsp;% GDP (" & CStr(BaseYear) & ") Log"
**'''This equation uses:''' <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP 2005) Versus Govt Expense&nbsp;% GDP (2010) Log</span>
**<span style="background-color: rgb(255, 255, 0);">'''Note:''' This appears to use a government expense equation to estimate SS and welfare.</span>
== Reconciliation ==
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Govcon+SSWEL=GOVEXP; give priority first to boosting Govcon, then reducing sswel, then boosting Govexp<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'i.e. protext all of govcon and boost if possible; reduce sswel as needed; reduce govexp after sswel</span>
== <span style="color: rgb(0, 0, 0);">Pensions</span> ==
*<span style="color: rgb(0, 0, 0);">Government pensions (CGovHHPenT)&nbsp;are&nbsp;initalized using '''<span style="background-color: rgb(255, 255, 0);">SeriesGovtPension%GDP</span>'''</span>
**'''Source:'''&nbsp;Data was processed from World Bank's &nbsp;pensions site.
**'''Extended source:&nbsp;'''"International Patterns of Pension Provision" by Palacios and Pallares-Miralles, &nbsp;2000; OECD Social Expenditure Database. World Bank Pensions Performance Indicators Q2, 2013.
**'''Definition:'''&nbsp;Government (public) pensions as&nbsp;% of GDP
**''<span style="background-color: rgb(255, 255, 0);">'''Note: '''Newer pension data exists in IFs but is not pulled into preprocessor</span>''
*'''To fill holes:''' "GDP/Capita (PPP) Versus Public Pension&nbsp;% of GDP (" & CStr(BaseYear) & ")"
**'''This equation uses:'''<span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Public Pension&nbsp;% of GDP (2000)</span>
== <span style="color: rgb(0, 0, 0);">Reconcile with trade</span> ==
<span style="color: rgb(0, 0, 0);">Normalize Expenditure Components to 100% - (X-M)</span>
= <span style="color: rgb(0, 0, 0);">Split into sectors</span> =
== Government consumption ==
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Split Government Consumption and Investment into Sectors of Origin<br/>'&nbsp;&nbsp; ------------------------------------------------------------------</span>
&nbsp;&nbsp;&nbsp; For ICount% = 1 To CCount<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GMN(ICount%) = 0.1 * CGCon(ICount%) <span style="color: rgb(0, 0, 0);"><span style="background-color: rgb(255, 255, 0);">'Manufacturing spending&nbsp;assumed to be 10% of conumption</span></span><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GSR(ICount%) = 0.9 * CGCon(ICount%) <span style="color: rgb(0, 0, 0);"><span style="background-color: rgb(255, 255, 0);">'Services spending assumed to be 90% of consumption</span></span><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IMN(ICount%) = CINVEST(ICount%) * 0.5 <span style="color: rgb(0, 0, 0);"><span style="background-color: rgb(255, 255, 0);">'Manufacturing investment assumed to be 50% of investment</span></span><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ISR(ICount%) = CINVEST(ICount%) * 0.5 <span style="color: rgb(0, 0, 0);"><span style="background-color: rgb(255, 255, 0);">'Services investment assumed to be 50% of investment</span></span><br/>&nbsp;&nbsp;&nbsp; Next ICount%
== Personal consumption ==
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Split Personal Consumption into Sectors - Use Value Added and AMAT</span><br/><span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; ------------------------------------------------------------------</span>
*<span style="color: rgb(0, 0, 0);">Use AMAT data to initalize personal consumption for agriculture, manufacturing, and services.</span>
*<span style="color: rgb(0, 0, 0);">Adjust personal energy consumption based on world energy price and&nbsp;energy exports (exporters tend to consume more).</span>
*<span style="color: rgb(0, 0, 0);">Initalize ICT personal consumption using ICTShare</span>
*<span style="color: rgb(0, 0, 0);">Normalize with total consumption.</span>
= <span style="color: rgb(0, 0, 0);">Social Accounting Matrix</span> =
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Social Accounting Matrix Stocks.&nbsp; Begin with Stocks because some needed for flows</span>
== <span style="color: rgb(0, 0, 0);">Stocks</span> ==
=== IFI ===
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; SAM Stocks: Start with World Bank and IMF Loans and Credits - Want to be<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sure that external debt/assets cover known values</span>
*<span style="color: rgb(0, 0, 0);">World Bank (CXWBLOANS) is initialized using '''SeriesXWBLoans%GDP.'''</span>
*<span style="color: rgb(0, 0, 0);">'''Source: '''WDI Batch Pull</span>
*<span style="color: rgb(0, 0, 0);">'''Definition:'''</span>IBRD loans and IDA credits as&nbsp;% of GDP
*'''Notes:''' mjs: Data is transformed to percent of gdp using current us$ GDP; MJE
*IMF loans (CXIMFCREDIT) are initialized using '''SeriesXIMFCredit%GDP.'''
**'''Source: '''WDI Batch pull
**'''Definiton: '''IMF credits as&nbsp;% of GDP
**'''Notes:''' mjs: Data is transformed to percent of gdp using current us$ GDP; MJE
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Allocate World Bank Loans to Advanced Countries</span>
<span style="color: rgb(0, 0, 0);">Allocate total World Bank loans to "advanced countries" (countries with GDP per capita over 10,000 USD and no World Bank loans) based on size of economy. Use one countries share of the total GDP of all advanced countries to determine the share of total WB debt that they lend.</span>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PerCap = CGDP(ICount%) / CPop(ICount%)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If PerCap > 10 And CXWBLOANS(ICount%) <= 0.001 Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CXWBLOANS(ICount%) = -CGDP(ICount%) / AdvGDPXWBDebt * (GloXWBDebt / AMAX(1, sxwblneqr))<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If
*Do the same for IMF debt.
=== Debt ===
*Initialize public and private guarenteed debt (PPGDEBT) using '''SeriesXDEBTPPG%GDP'''
**'''Source: '''WDI Batch Pull
**'''Definition: '''External debt, public and publicly guaranteed, as percentage of gross domestic product
*Initialize external debt (private non-guarenteed) (PNGDEBT) using '''SeriesXDEBTPNG%GDP'''
**'''Source: '''WDI Batch pull
**'''Definition: '''External debt, private non-guaranteed, as percentage of gross domestic product
*Assume firm debt (CXFIRMDEBT) is half of the sum of public and private guarenteed and private non-guarenteed.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CXFIRMDEBT(ICount%) = PNGDEBT + PPGDEBT * 0.5<br/><span style="color: rgb(0, 0, 0);"><span style="background-color: rgb(255, 255, 0);">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Need to break PPGDEBT better between private/governmental</span></span><br/><span style="color: rgb(0, 128, 0);">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Probably poorest countries have highest govt share</span>
*<span style="color: rgb(0, 0, 0);">Allocate external firm debt to advanced countries using same procedure for IMF and WB debt above</span>
*<span style="color: rgb(0, 128, 0);">Integrate Debt Caculation Using Current Account Data</span>
**This basically calculates annual exports, imports, and aid for 1960 to 2010 and sums into cumulative debt.&nbsp;&nbsp;&nbsp;
*Initialize external debt (CXDEBTRPA) using '''SeriesXDEBT'''
**'''Source:''' WDI Batch Pull
**'''Definition: '''External long-term (more than 1 year) debt: public, publically guaranteed and priv nonguarantee
*<font color="#008000">'&nbsp;&nbsp; Augment External Debt Data with Current Account Accummulation and Compute Global Balance</font>
*<span style="color: rgb(0, 0, 0);">If there is no data for CXDEBTRPA then use the cumulative sum calculated from current account above.</span>
*<span style="color: rgb(0, 0, 0);">Make sure that debt is at least as big as the sum of WB, IMF, and private debt calculated above.</span>
*<font color="#000000">Make sure that assets are at least as big as WB&nbsp;donations&nbsp;IMF donations, and private assets.</font>
*<font color="#008000">'Assume debt data better than asset and impose on assets - </font><span style="color: rgb(0, 0, 0);">Scale each lender countries assets to align with global debt</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Compute governmental external debt and government domestic debt </span><span style="color: rgb(0, 0, 0);">- set&nbsp; government debt (CXGOVTDEBT) to total debt (CXDEBTRPA) minus firm debt (CXFIRMDEBT). This assumes that there is no household external debt.</span>
*<span style="color: rgb(0, 0, 0);">Set "basic" government debt (CX</span>GOVTDEBTB)&nbsp;as total government debt (CXGOVTDEBT) minus IFI debt (to WB and IMF).
=== Aid ===
*Initalize aid donations (CAIDDON) using '''SeriesAidDon%GNI'''
**'''Source: '''United Nations Statistics Division
**'''Original source:''' OECD
**'''Definition: '''Aid donations as percent of GNI
*Initialize aid received (CAIDREC) using '''SeriesAIDRec%GNI'''
**'''Source: '''WDI Batch Pull
**'''Original Source:''' Development Assistance Committee of the Organization for Economic Co-operation and Development, and World Bank and OECD GNI estimates.
**'''Definition:''' Official development assistance and official aid, net,&nbsp;% of GNI
**'''Extended source definition:''' [http://databank.worldbank.org/ddp/home.do?Step=12&id=4&CNO=2 http://databank.worldbank.org/ddp/home.do?Step=12&id=4&CNO=2]
*Initialize CAIDSHARE using '''SeriesAidRecGrant%Total'''
**'''Source: '''WDI Batch Pull
**'''Original source: '''Development Assistance Committee of the Organization for Economic Co-operation and Development, and World Bank and OECD GNI estimates.
**'''Definition: '''Official development assistance and official aid, grants and other revenue, current LCU
**'''''Note:''' Unsure where this is actually used''
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Normalize Aid Receipts and Donations so Global Sums Match</span>
=== <span style="color: rgb(0, 0, 0);">Government Debt</span> ===
*<span style="color: rgb(0, 0, 0);">Initalize government debt (CGOVDEBT) using</span>'''SeriesGovtDebt%GDP'''
**'''Source: '''WDI Batch Pull
**'''Definition: '''Central government debt as&nbsp;% of GDP
*If it's null use GDP per capita i.e. the equation: "GDP/Capita (PPP) Versus Govt Debt&nbsp;% GDP (" & CStr(BaseYear) & ")" to estimate.
**This equation uses: <span style="background-color: rgb(255, 255, 0);">GDP/Capita (PPP) Versus Govt Debt&nbsp;% GDP (2000)</span>
*Set CGovDebt as the max of external government debt (CXGOVTDEBT) and central government debt (CGOVDEBT).
=== Reserves ===
*Initialize government reserves (CXRESERVES) using '''SeriesXReserves%GDP'''
*If null, set to 15.
=== FDI ===
*Initialize FDI inflows as a stock using the sum of inflows over past 30 years from '''SeriesXFDIInflows%GDP'''
*Initialize FDI outflows as a stock using the sum of outflows over the past 30 years from '''SeriesXFDIOutflows%GDP'''
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Read Bonds and Equity and Calculate Annual Portfolio Inflows -</span><span style="color: rgb(0, 0, 0);">&nbsp; Take the average of bonds and equity for the past 5 years, set as <font color="#333333">CXPORTFIN</font></span>
*Make sure FDI no bigger than 5% of GDP
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If Not (IsNull(GDPANN)) Then <span style="color: rgb(0, 128, 0);">'Luxembourg rule; flows far too big for addition to firm income<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'This is probably too big a cut for Hong Kong; may need more sophisticated algorithm<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'for entrepot economies</span><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CXPORTFIN(ICount%) = Amin(CXPORTFIN(ICount%), 0.05 * GDPANN)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If
== Flows ==
=== IFI ===
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Read WB Net Flows and Estimate Outflows and Inflows<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Must do after stocks because need CXWBLOANS</span>
*<span style="color: rgb(0, 0, 0);">Estimate using average of last 5 years of inflows. Balance inflows and outflows so that they match.</span>
*<font color="#000000">The initialization of World Bank outflows (CXWBLNFOUT) requires World Bank loans (out) as a stock (CXWBLOANS). CXWBLNFOUT is initalized using the equation below, which also uses (sxwblnintr) and (sxwblnrepr). </font>
**''<font color="#000000">'''Note:''' Unsure of exactlty what these global parameters (</font>sxwblnintr and sxwblnrepr) <font color="#000000">are.</font>''
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CXWBLNFOUT(ICount%) = (CXWBLOANS(ICount%) * sxwblnintr / 100 _<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + CXWBLOANS(ICount%) / AMAX(1, sxwblnrepr))
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Read IMF Net Flows and Estimate Outflows and Inflows<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Must do after stocks because need CXIMFCREDIT</span>
*<span style="color: rgb(0, 0, 0);">Same as World Bank above - use the average of the past 5 years for inflows. Use the following equation for outflows, which requires outgoing stocks, initialized above.</span>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CXIMFCRFOUT(ICount%) = (CXIMFCREDIT(ICount%) * sximfcrintr / 100 _<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + CXIMFCREDIT(ICount%) / AMAX(1, sximfcrrepr))
=== Remittances ===
*Initialize outgoing remittances using '''SeriesXWorkerRemitPaid''' and incoming remittances using '''SeriesXWorkerRemitReceived. '''Normalize each country's paid and received using RemitNormReceived and RemitNormPaid, normalizing coefficient calculated elsewhere.
**'''''Note:''' I think this is normalize total paid and received&nbsp;i.e. total outflows for all countries and total inflows for all countries. The global balance below is to balance NET inflows and outflows.''
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Balance Global Remittances</span>
**<span style="color: rgb(0, 0, 0);">Make sure global paid remittances equal global recieved remittances.</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Fill holes on CPOPFOREIGN and fix descrepancies</span>
**<span style="color: rgb(0, 0, 0);">If there is a foreign population and remittances are greater than zero, change the sign of foreign population (CPOPFOREIGN).</span>
<span style="color: rgb(0, 128, 0);">'jrs 2014/02/04 better to re-initialize CPOPFOREIGN which is an estimate</span><br/><span style="color: rgb(0, 128, 0);">'and not CXWORKREMIT, which comes from data</span>
<span style="color: rgb(0, 128, 0);">'This assumes $1,000 annual remitances per person, which is the average from the US and EU27</span>
*<span style="color: rgb(0, 128, 0);">'Bound remittances at $5,000 per worker abroad</span>
=== <span style="color: rgb(0, 0, 0);">Balancing</span> ===
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; ReBalance Global Remittances</span>
*<span style="color: rgb(0, 128, 0);">'Normalizing Immigrants and Emmigrants again, in case they were adjusted by Remittances</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Balance global migration stocks, inward and outward</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Normalize World Bank Flows in and out</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Normalize IMF Flows in and out</span>
*<span style="color: rgb(0, 128, 0);">'bbh 2011/11/12&nbsp; Adjusted this allocation because above now have new outflow countries also&nbsp;&nbsp;&nbsp;</span>
**<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Allocate Portfolio Investment to Advanced Countries by Economic Size</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Balance Portfolio Stocks in and Out; Adjust Stocks Out</span>
*<span style="color: rgb(0, 128, 0);">' Compute Porfolio Flows Out</span>
*<span style="color: rgb(0, 128, 0);">'''Balance Portfolio Flows in and Out; Adjust Outflows''</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Balance FDI Stocks with Adjustments to Advanced Countries</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Balance FDI Flows with Adjustments to Advanced Countries</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp;&nbsp;Compute Apparent Reconciliaton of Capital and Current Account in Recent Years</span> <span style="color: rgb(0, 128, 0);">using accumulation of government debt and change in reserves</span>
*<span style="color: rgb(0, 0, 0);">Calculate how much debt has grown from 97/98 to 99/00. Then calculate how much reserves have grown from 97/98 to 99/00. Then calculate the ratio of reserves growth to debt growth.</span>
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Compute unreconciled discrepancy between capital and current account</span>
**<span style="color: rgb(0, 128, 0);">Reasons could be flight capital, unreported worker remittances, other data errors</span>
*Initialize foreign income payments using '''SeriesXIncPayments%GDP''' and foreign income receipts using '''SeriesXIncReceipts%GDP.'''
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; ReBalance Global Remittances Still Again</span>
= <span style="color: rgb(0, 0, 0);">Household and firm income</span> =
<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Now that have tax rates as&nbsp;% of govt revenue<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and have intl financial flows that affect firm income in forecasts,<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; can compute household and firm income, adjust firm by intl flows and<br/>'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; can compute tax rates as&nbsp;% of that income for use in forecasts</span>
= Output =
*Put everything into EcoOutput
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Go to specialized routines to process input-output data for IFs</span>
**Call InputOutputDataAdjuster
**Call RegionalInputOutputData
= Recompute =
*Sub RecomputeAgriOutput()
**<span style="color: rgb(0, 128, 0);">'Because of the different normalizations XAG has suffered, it no longer matches the SUM of AgXValues</span>
*Sub RecomputeOutputAgriNormalization
= GDP =
*<span style="color: rgb(0, 128, 0);">'&nbsp;&nbsp; Fill Initial GDP Growth Rates and Income Distribution Measures</span>
**<span style="background-color: rgb(255, 255, 0);">[incomplete]</span>
<span style="background-color: rgb(255, 255, 0);"></span>
'''SeriesGDP2011'''
'''Note: '''this covers the calculation of GDP at constant 2011 US dollars for 183 IFs countries. The excluded countries are Syria, Somalia, and North Korea.
'''Data Source'''
1. GDP at current US$, 1960-2018
[https://data.worldbank.org/indicator/NY.GDP.MKTP.CD https://data.worldbank.org/indicator/NY.GDP.MKTP.CD] ,
the World Bank
2. Real GDP annual growth (% change), 1960-2018
[https://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG https://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG],
The World Bank&nbsp;
3. Real GDP annual growth (% change), 1980-2024
[https://www.imf.org/external/datamapper/NGDP_RPCH@WEO/OEMDC/ADVEC/WEOWORLD https://www.imf.org/external/datamapper/NGDP_RPCH@WEO/OEMDC/ADVEC/WEOWORLD],
The International Monetary Fund
'''Calculation Steps'''
1. Take GDP values from current US$ data for each country in 2011, do the country concordance and unit conversion (GDP in IFs is in Billion US$). The GDP at current US$ in year 2011 for each country equals to that country’s GDP at constant 2011 US$. So now we have a data that has each country’s GDP at constant 2011 US$ in year 2011, in billion US dollars, in IFs country name format.
2. Use the above data as our base year, then use the GDP annual growth rate to fill forward (2011 to 2024) & backwards (2011 to 1960) each country’s GDP for all years. During the calculation, the growth rate from WDI should serve as our primary source while the IMF growth rate would serve as the supplemental source, i.e., whenever there is a missing value in WDI’s growth rate, we will then rely on IMF’s growth rate. After this step, we will then have a full dataset of GDP at constant 2011 US billion dollars, expect Syria, Somalia, and North Korea.
<span style="background-color: rgb(255, 255, 0);"></span>

Latest revision as of 18:34, 20 July 2020

There are 74 series read into the economic preprocessor. Most of them come from World Development Indicators (WDI). There are quite a few series marked as "IMF GFS 2013 BATCH PULL". There are a lot of data on the informal economy from ILO-WIEGO. Cyber data also appears to be read into DataEcon.

Sources

Economic series used in preprocessor

DataDict
Table Source Last IFs Update UsedInPreprocessorFileName
SeriesGDPInformal%Elgin Available at: http://www.econ.boun.edu.tr/public_html/RePEc/pdf/201205.pdf 2014/04/04 ECON
SeriesGDP2003PPP CIA (original partly World Bank); extended by Evan Hillebrand
2004/07 ECON
SeriesGovtPension%GDP Data was processed from World Bank's pensions site.
2013/07/22 ECON
SeriesLaborInformalFemale%FormalSec ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalFemale%HHInformal ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalMale%InformalSec ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalFemale%InformalSec ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalFormSec%TotalInformal ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalHH%TotalInformal ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalInfSec%TotalInformal ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalMale%FormalSec ILO-WIEGO 2015/03/10 ECON
SeriesLaborInformalMale%HHInformal ILO-WIEGO 2015/03/10 ECON
SeriesGovtCalcRevTot%GDP IMF GFS 2013 BATCH PULL 2013/12/20 ECON
SeriesGovtCalcRevCen%GDP IMF GFS 2013 BATCH PULL 2013/12/20 ECON
SeriesGovtCalcExpendTot%GDP IMF GFS 2013 BATCH PULL 2013/12/20 ECON
SeriesGovtCalcExpendCen%GDP IMF GFS 2013 BATCH PULL 2013/12/20 ECON
SeriesTaxCorp%Tot IMF Government Finance Statistics (2001) 2013/09/04 ECON
SeriesVaddICT%GDP Information Society Statistics Pocketbook 2001

ECON
SeriesGovTotalOutlays%GDP OECD_Statistics_Database_Online
2016/04/10 ECON
SeriesGDPInformal%Blended UNECE, "Non-Observed Economy in National Accounts: Survey of Country Practices"; http://rru.worldbank.org/Documents/PapersLinks/informal_economy.pdf; http://www.econ.boun.edu.tr/public_html/RePEc/pdf/201205.pdf
2015/01/13 ECON
SeriesAidDon%GNI United Nations Statistics Division 2013/12/09 ECON
SeriesXPortEquity%GDP WDI BATCH PULL 2017/03/29 ECON
SeriesXReserves%GDP WDI BATCH PULL 2017/03/29 ECON
SeriesHouseCon%GDP WDI BATCH PULL 2015/07/14 ECON
SeriesVaddInd% WDI BATCH PULL 2015/07/15 ECON
SeriesArmsImp%TotImp WDI BATCH PULL 2015/07/14 ECON
SeriesGovtCurRev%GDP WDI BATCH PULL 2015/07/14 ECON
SeriesGovtDebt%GDP WDI BATCH PULL 2015/07/14 ECON
SeriesVaddMan% WDI BATCH PULL 2015/07/15 ECON
SeriesExportsMerchandise WDI BATCH PULL 2015/07/14 ECON
SeriesXDebtPPG%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesXPortBonds%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesXIncPayments%GDP WDI BATCH PULL 2017/03/29 ECON
SeriesXFlowsIDA%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesXIMFCredit%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesXFlowsIMFNonCon%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesXWorkerRemitPaid WDI BATCH PULL 2017/03/29 ECON
SeriesAidRecGrant%Total WDI BATCH PULL 2015/07/14 ECON
SeriesXDebtPNG%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesXFDIInflows%GDP WDI BATCH PULL 2017/03/29 ECON
SeriesVaddSer% WDI BATCH PULL 2015/07/15 ECON
SeriesExportServices WDI BATCH PULL 2017/03/29 ECON
SeriesXIncReceipts%GDP WDI BATCH PULL 2017/03/29 ECON
SeriesExportGoodSer% WDI BATCH PULL 2015/07/15 ECON
SeriesTaxSocSec%CurRev WDI BATCH PULL 2015/07/15 ECON
SeriesTaxGoodSer%CurRev WDI BATCH PULL 2015/07/15 ECON
SeriesXCurActBal%GDP WDI BATCH PULL 2017/03/29 ECON
SeriesXDebt WDI BATCH PULL 2015/07/15 ECON
SeriesXFlowsIMFCon%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesXFDIOutflows%GDP WDI BATCH PULL 2017/03/29 ECON
SeriesVaddAg% WDI BATCH PULL 2015/07/15 ECON
SeriesXFlowsIBRD%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesImportsMerchandise WDI BATCH PULL 2015/07/14 ECON
SeriesImportServices WDI BATCH PULL 2017/03/29 ECON
SeriesImportGoodSer% WDI BATCH PULL 2015/07/14 ECON
SeriesGovExpense%GDP WDI BATCH PULL 2015/07/14 ECON
SeriesGovCon%GDP WDI BATCH PULL 2015/07/14 ECON
SeriesXWBLoans%GDP WDI BATCH PULL 2015/07/15 ECON
SeriesAidRec%GNI WDI BATCH PULL 2017/03/29 ECON
SeriesXWorkerRemitReceived WDI BATCH PULL 2017/03/29 ECON
SeriesGiniExtended WDI World Bank, Klaus Deininger 202-473-0430 and Lyu Squire 202-473-6099; plus WDI CD 2002 for 1997-2000; plus WD 2002; plus UNDP HDR 2005; WDI 2008; WDI 2011 2015/03/17 ECON
SeriesGovSSWelBen%Exp WDI 2011 2011/12/22 ECON
SeriesICTExport%Exp WDI 2013 2013/11/08 ECON
SeriesICTImport%Imp WDI 2013 2013/11/08 ECON
SeriesGDP2005PCPPP WDI 2013; extrapolated based on previous GDP_PCPPP2005 values in IFs; extrapolated based on CIA Factbook; taken directly from CIA Factbook; taken directly from previous GDP_PCPPP2005 values in IFs 2013/12/23 ECON
SeriesGDP2011PCPPP WDI 2017 2017/03/29 ECON
SeriesPovertyGap$1c90perDay WDI 2015 2015/12/03 ECON
SeriesIncBelow1D90c%WDI WDI 2015 2015/11/04 ECON
SeriesIncBelow3D10c%WDI WDI 2015 2015/11/04 ECON
SeriesIncBelow2Dollar%WDI2011 WDI 2015 BATCH PULL 2015/07/22 ECON
SeriesPopForeign% WDI 2015 BATCH PULL 2015/07/22 ECON
SeriesOresMetsEx%MerchEx WDI 2015 BATCH PULL 2015/07/22 ECON
SeriesIncShareL20% WDI 2015 BATCH PULL 2015/07/22 ECON
SeriesInvestGrCapForm%GDP WDI 2015 BATCH PULL 2015/07/22 ECON
SeriesOresMetsIm%MerchIm WDI 2015 BATCH PULL 2015/07/22 ECON

Initializations

Use government consumption and expenditures data to initialize SAM.

Government consumption

  • Government consumption (CGovCon) is initialized using SeriesGovCon%GDP.
    • Source: WDI
    • Definition: Government (general) final consumption as % of GDP
    • Country coverage: 182 countries
    • Source definition:"General government final consumption expenditure (formerly general government consumption) includes all government current expenditures for purchases of goods and services (including compensation of employees). It also includes most expenditures on national defense and security, but excludes government military expenditures that are part of government capital formation"
    • If null: "GDP/Capita (PPP) Versus Govt Cons % GDP (" & CStr(BaseYear) & ")"
    • This uses the equation: GDP/Capita (PPP) Versus Govt Cons % GDP (2000)


  • CGConFromSectors = GExpDef(ICount%) + GExpEd(ICount%) + GExpRandD(ICount%) + GExpHl(ICount%) + GExpInfra(ICount%) + GExpInfraOther(ICount%)
  • Set CGovCon as the max of CGovCon and the CGovCon calculated as the sum of sectors. Bound between 9 and 35.

Government expenditures

Initialize central government expenditures and total government expenditures and then calculate local government expenditures as the difference.

  • Central government expenditures (GovExpCentral) is initialized using SeriesGovExpense%GDP
    • Source: WDI
    • Definition: Government expense as % of GDP (compare with govt expenditures)
  • If null then use SeriesGovtCalcExpendCen%GDP 
  • If still null then use: "GDP/Capita (PPP 2005) Versus Govt Expense % GDP (" & CStr(BaseYear) & ") Log"
  • This equation uses: GDP/Capita (PPP 2005) Versus Govt Expense % GDP (2010) Log
  • Note: IMF series (GovtCalcExpendCen%GDP) appears to be central government expenditures while the WDI series does not specify.


  • Use SeriesGovtCalcExpendTot%GDP to initialize total government expenditures.
    • Source: IMF GFS
    • Definition: Expenditure, government, total, as % of GDP
  • If null, then use SeriesGovTotalOutlays%GDP
    • Source: OECD Statistics Database Online
    • Definition: Government total outlays (% of GDP), including forecast
  • Note: Must make sure these two series are identical
  • Hard code 46 in for Ireland in 2010 because of bailout.


  • If no data on total expenditures still, then we cannot estimate local so we use this equation:

        If IsNull(CGovTotExp) Then
            CGovExpLocal(ICount%) = 2 + 12 * Amin(20, CGDPPCP(ICount%)) / 20
        Else
            CGovExpLocal(ICount%) = AMAX(1, CGovTotExp - GovExpCentral)
        End If

'   Go to total govt expenditures and filling holes when have data in order to compute local govt
'       When do not have total and therefore ability to compute local govt,
'       estimate at 2-14% of GDP (OECD gap between total and central is 14%)
'       North, Walli, Weingast p. 10 have table showing grows from 1-2% to 16%

  • CGovExp(ICount%) = GovExpCentral + CGovExpLocal(ICount%) 'Add Central plus local to get total

Government revenue

  • Central government revenue (GovRevCen) is initialized using SeriesGovtCurRev%GDP
    • Source: WDI
    • Definition: Current government revenue as % of GDP
    • Extended definition: blended with old Ifs data.  Revenue is cash receipts from taxes, social contributions, and other revenues such as fines, fees, rent, and income from property or sales. Grants are also considered as revenue but are excluded here.
  • If it's null or less than 5 then we use GDP per capita to estimate.
    • To fill holes: "GDP/Capita (PPP) Versus Govt Revenue (" & CStr(BaseYear) & ")"
    • This equation uses: GDP/Capita (PPP) Versus Govt Revenue (2000)


  • Total government revenue (GovRevTot) is initialized using SeriesGovtCalcRevTot%GDP
    • Source: IMF GFS
    • Definition: Revenue, government, total, as % of GDP
  • If GovRevTot is null i.e. there is no data for total government revenue for the country in SeriesGovtCalcRevTot%GDP (or the value is less than 5) then esimate using GDP per capita (2005).
    • To fill holes: "GDP/Capita (PPP 2005) Versus Govt Revenue Total (2010) Log"
  • Then set GovRevTot as the max of total government revenues and central government revenues
  • Cap total government revenues at 75
  • Set local government revenue as the difference between total and central
  • Note:This logic creates problems for countries where there is not a total government revenue data point but there is a central government data point (ex. Malawi). In this case, both total government revenue and central government revenue are initialized as the data value for central government revenue and local government revenue is set at zero (the difference between total and central).


  • Firm tax rate (CFirmTaxR) is initialized using SeriesTaxCorp%Tot
    • Source: IMF Government Finance Statistics (2001)
    • Definition: Corporate taxes as percent of total central government revenue
    • Note: Apparently not part of batch pull.
  • To fill holes:"GDP/Capita (PPP) Versus Corporate Tax % of Total (" & CStr(BaseYear) & ")"
    • This equation uses: GDP/Capita (PPP) Versus Corporate Tax % of Total (2000)


  • Social security tax (CSSWelTaxR) is initialized using SeriesTaxSocSec%CurRev 
    • Source: WDI
    • Definition: Social security taxes as % of total govt revenue
  • To fill holes: "GDP/Capita (PPP) Versus SS Tax % of Total (" & CStr(BaseYear) & ")"
    • This equation uses: GDP/Capita (PPP) Versus SS Tax % of Total (2000)


  • Indirect taxes (CIndirectTaxR) is initialized using SeriesTaxGoodSer%CurRev
    • Source: WDI
    • Definition: Taxes on goods and services as % of total govt revenue
  • To fill holes: "GDP/Capita (PPP) Versus Indirect Tax % of Total (" & CStr(BaseYear) & ")"
    • This equation uses: GDP/Capita (PPP) Versus Indirect Tax % of Total (2000)


  • Household taxes (CHHTaxR) estimated as residual from firm, welfare, and indirect taxes

Transfers

  • CGovSSWel is initialized using SeriesGovSSWelBen%Exp
    • Source: WDI
    • Definition: Government Social Security and welfare expenditures as % of total expenditures
    • Note: Not included in last WDI batch pull
  • To fill holes: "GDP/Capita (PPP 2005) Versus Govt Expense % GDP (" & CStr(BaseYear) & ") Log"
    • This equation uses: GDP/Capita (PPP 2005) Versus Govt Expense % GDP (2010) Log
    • Note: This appears to use a government expense equation to estimate SS and welfare.

Reconciliation

'       Govcon+SSWEL=GOVEXP; give priority first to boosting Govcon, then reducing sswel, then boosting Govexp
            'i.e. protext all of govcon and boost if possible; reduce sswel as needed; reduce govexp after sswel

Pensions

  • Government pensions (CGovHHPenT) are initalized using SeriesGovtPension%GDP
    • Source: Data was processed from World Bank's  pensions site.
    • Extended source: "International Patterns of Pension Provision" by Palacios and Pallares-Miralles,  2000; OECD Social Expenditure Database. World Bank Pensions Performance Indicators Q2, 2013.
    • Definition: Government (public) pensions as % of GDP
    • Note: Newer pension data exists in IFs but is not pulled into preprocessor
  • To fill holes: "GDP/Capita (PPP) Versus Public Pension % of GDP (" & CStr(BaseYear) & ")"
    • This equation uses:GDP/Capita (PPP) Versus Public Pension % of GDP (2000)

Reconcile with trade

Normalize Expenditure Components to 100% - (X-M)

Split into sectors

Government consumption

'   Split Government Consumption and Investment into Sectors of Origin
'   ------------------------------------------------------------------

    For ICount% = 1 To CCount
            GMN(ICount%) = 0.1 * CGCon(ICount%) 'Manufacturing spending assumed to be 10% of conumption
            GSR(ICount%) = 0.9 * CGCon(ICount%) 'Services spending assumed to be 90% of consumption
            IMN(ICount%) = CINVEST(ICount%) * 0.5 'Manufacturing investment assumed to be 50% of investment
            ISR(ICount%) = CINVEST(ICount%) * 0.5 'Services investment assumed to be 50% of investment
    Next ICount%

Personal consumption

'   Split Personal Consumption into Sectors - Use Value Added and AMAT
'   ------------------------------------------------------------------

  • Use AMAT data to initalize personal consumption for agriculture, manufacturing, and services.
  • Adjust personal energy consumption based on world energy price and energy exports (exporters tend to consume more).
  • Initalize ICT personal consumption using ICTShare
  • Normalize with total consumption.

Social Accounting Matrix

'   Social Accounting Matrix Stocks.  Begin with Stocks because some needed for flows

Stocks

IFI

'   SAM Stocks: Start with World Bank and IMF Loans and Credits - Want to be
'       sure that external debt/assets cover known values

  • World Bank (CXWBLOANS) is initialized using SeriesXWBLoans%GDP.
  • Source: WDI Batch Pull
  • Definition:IBRD loans and IDA credits as % of GDP
  • Notes: mjs: Data is transformed to percent of gdp using current us$ GDP; MJE


  • IMF loans (CXIMFCREDIT) are initialized using SeriesXIMFCredit%GDP.
    • Source: WDI Batch pull
    • Definiton: IMF credits as % of GDP
    • Notes: mjs: Data is transformed to percent of gdp using current us$ GDP; MJE


  • '   Allocate World Bank Loans to Advanced Countries

Allocate total World Bank loans to "advanced countries" (countries with GDP per capita over 10,000 USD and no World Bank loans) based on size of economy. Use one countries share of the total GDP of all advanced countries to determine the share of total WB debt that they lend.

        PerCap = CGDP(ICount%) / CPop(ICount%)
        If PerCap > 10 And CXWBLOANS(ICount%) <= 0.001 Then
            CXWBLOANS(ICount%) = -CGDP(ICount%) / AdvGDPXWBDebt * (GloXWBDebt / AMAX(1, sxwblneqr))
        End If

  • Do the same for IMF debt.

Debt

  • Initialize public and private guarenteed debt (PPGDEBT) using SeriesXDEBTPPG%GDP
    • Source: WDI Batch Pull
    • Definition: External debt, public and publicly guaranteed, as percentage of gross domestic product


  • Initialize external debt (private non-guarenteed) (PNGDEBT) using SeriesXDEBTPNG%GDP
    • Source: WDI Batch pull
    • Definition: External debt, private non-guaranteed, as percentage of gross domestic product


  • Assume firm debt (CXFIRMDEBT) is half of the sum of public and private guarenteed and private non-guarenteed.

        CXFIRMDEBT(ICount%) = PNGDEBT + PPGDEBT * 0.5
            'Need to break PPGDEBT better between private/governmental
            'Probably poorest countries have highest govt share

  • Allocate external firm debt to advanced countries using same procedure for IMF and WB debt above
  • Integrate Debt Caculation Using Current Account Data
    • This basically calculates annual exports, imports, and aid for 1960 to 2010 and sums into cumulative debt.   


  • Initialize external debt (CXDEBTRPA) using SeriesXDEBT
    • Source: WDI Batch Pull
    • Definition: External long-term (more than 1 year) debt: public, publically guaranteed and priv nonguarantee


  • '   Augment External Debt Data with Current Account Accummulation and Compute Global Balance
  • If there is no data for CXDEBTRPA then use the cumulative sum calculated from current account above.
  • Make sure that debt is at least as big as the sum of WB, IMF, and private debt calculated above.
  • Make sure that assets are at least as big as WB donations IMF donations, and private assets.
  • 'Assume debt data better than asset and impose on assets - Scale each lender countries assets to align with global debt
  • '   Compute governmental external debt and government domestic debt - set  government debt (CXGOVTDEBT) to total debt (CXDEBTRPA) minus firm debt (CXFIRMDEBT). This assumes that there is no household external debt.
  • Set "basic" government debt (CXGOVTDEBTB) as total government debt (CXGOVTDEBT) minus IFI debt (to WB and IMF).

Aid

  • Initalize aid donations (CAIDDON) using SeriesAidDon%GNI
    • Source: United Nations Statistics Division
    • Original source: OECD
    • Definition: Aid donations as percent of GNI


  • Initialize aid received (CAIDREC) using SeriesAIDRec%GNI
    • Source: WDI Batch Pull
    • Original Source: Development Assistance Committee of the Organization for Economic Co-operation and Development, and World Bank and OECD GNI estimates.
    • Definition: Official development assistance and official aid, net, % of GNI
    • Extended source definition: http://databank.worldbank.org/ddp/home.do?Step=12&id=4&CNO=2


  • Initialize CAIDSHARE using SeriesAidRecGrant%Total
    • Source: WDI Batch Pull
    • Original source: Development Assistance Committee of the Organization for Economic Co-operation and Development, and World Bank and OECD GNI estimates.
    • Definition: Official development assistance and official aid, grants and other revenue, current LCU
    • Note: Unsure where this is actually used
  • '   Normalize Aid Receipts and Donations so Global Sums Match

Government Debt

  • Initalize government debt (CGOVDEBT) usingSeriesGovtDebt%GDP
    • Source: WDI Batch Pull
    • Definition: Central government debt as % of GDP
  • If it's null use GDP per capita i.e. the equation: "GDP/Capita (PPP) Versus Govt Debt % GDP (" & CStr(BaseYear) & ")" to estimate.
    • This equation uses: GDP/Capita (PPP) Versus Govt Debt % GDP (2000)
  • Set CGovDebt as the max of external government debt (CXGOVTDEBT) and central government debt (CGOVDEBT).

Reserves

  • Initialize government reserves (CXRESERVES) using SeriesXReserves%GDP
  • If null, set to 15.

FDI

  • Initialize FDI inflows as a stock using the sum of inflows over past 30 years from SeriesXFDIInflows%GDP
  • Initialize FDI outflows as a stock using the sum of outflows over the past 30 years from SeriesXFDIOutflows%GDP
  • '   Read Bonds and Equity and Calculate Annual Portfolio Inflows -  Take the average of bonds and equity for the past 5 years, set as CXPORTFIN
  • Make sure FDI no bigger than 5% of GDP

            If Not (IsNull(GDPANN)) Then 'Luxembourg rule; flows far too big for addition to firm income
                    'This is probably too big a cut for Hong Kong; may need more sophisticated algorithm
                        'for entrepot economies

                CXPORTFIN(ICount%) = Amin(CXPORTFIN(ICount%), 0.05 * GDPANN)
            End If

Flows

IFI

'   Read WB Net Flows and Estimate Outflows and Inflows
'       Must do after stocks because need CXWBLOANS

  • Estimate using average of last 5 years of inflows. Balance inflows and outflows so that they match.
  • The initialization of World Bank outflows (CXWBLNFOUT) requires World Bank loans (out) as a stock (CXWBLOANS). CXWBLNFOUT is initalized using the equation below, which also uses (sxwblnintr) and (sxwblnrepr).
    • Note: Unsure of exactlty what these global parameters (sxwblnintr and sxwblnrepr) are.

            CXWBLNFOUT(ICount%) = (CXWBLOANS(ICount%) * sxwblnintr / 100 _
                + CXWBLOANS(ICount%) / AMAX(1, sxwblnrepr))

'   Read IMF Net Flows and Estimate Outflows and Inflows
'       Must do after stocks because need CXIMFCREDIT

  • Same as World Bank above - use the average of the past 5 years for inflows. Use the following equation for outflows, which requires outgoing stocks, initialized above.

            CXIMFCRFOUT(ICount%) = (CXIMFCREDIT(ICount%) * sximfcrintr / 100 _
                + CXIMFCREDIT(ICount%) / AMAX(1, sximfcrrepr))

Remittances

  • Initialize outgoing remittances using SeriesXWorkerRemitPaid and incoming remittances using SeriesXWorkerRemitReceived. Normalize each country's paid and received using RemitNormReceived and RemitNormPaid, normalizing coefficient calculated elsewhere.
    • Note: I think this is normalize total paid and received i.e. total outflows for all countries and total inflows for all countries. The global balance below is to balance NET inflows and outflows.
  • '   Balance Global Remittances
    • Make sure global paid remittances equal global recieved remittances.
  • '   Fill holes on CPOPFOREIGN and fix descrepancies
    • If there is a foreign population and remittances are greater than zero, change the sign of foreign population (CPOPFOREIGN).

'jrs 2014/02/04 better to re-initialize CPOPFOREIGN which is an estimate
'and not CXWORKREMIT, which comes from data

'This assumes $1,000 annual remitances per person, which is the average from the US and EU27

  • 'Bound remittances at $5,000 per worker abroad

Balancing

  • '   ReBalance Global Remittances
  • 'Normalizing Immigrants and Emmigrants again, in case they were adjusted by Remittances
  • '   Balance global migration stocks, inward and outward
  • '   Normalize World Bank Flows in and out
  • '   Normalize IMF Flows in and out
  • 'bbh 2011/11/12  Adjusted this allocation because above now have new outflow countries also   
    • '   Allocate Portfolio Investment to Advanced Countries by Economic Size
  • '   Balance Portfolio Stocks in and Out; Adjust Stocks Out
  • ' Compute Porfolio Flows Out
  • 'Balance Portfolio Flows in and Out; Adjust Outflows
  • '   Balance FDI Stocks with Adjustments to Advanced Countries
  • '   Balance FDI Flows with Adjustments to Advanced Countries
  • '   Compute Apparent Reconciliaton of Capital and Current Account in Recent Years using accumulation of government debt and change in reserves
  • Calculate how much debt has grown from 97/98 to 99/00. Then calculate how much reserves have grown from 97/98 to 99/00. Then calculate the ratio of reserves growth to debt growth.
  • '       Compute unreconciled discrepancy between capital and current account
    • Reasons could be flight capital, unreported worker remittances, other data errors
  • Initialize foreign income payments using SeriesXIncPayments%GDP and foreign income receipts using SeriesXIncReceipts%GDP.
  • '   ReBalance Global Remittances Still Again

Household and firm income

'   Now that have tax rates as % of govt revenue
'       and have intl financial flows that affect firm income in forecasts,
'       can compute household and firm income, adjust firm by intl flows and
'       can compute tax rates as % of that income for use in forecasts

Output

  • Put everything into EcoOutput
  • '   Go to specialized routines to process input-output data for IFs
    • Call InputOutputDataAdjuster
    • Call RegionalInputOutputData

Recompute

  • Sub RecomputeAgriOutput()
    • 'Because of the different normalizations XAG has suffered, it no longer matches the SUM of AgXValues
  • Sub RecomputeOutputAgriNormalization

GDP

  • '   Fill Initial GDP Growth Rates and Income Distribution Measures
    • [incomplete]

SeriesGDP2011

Note: this covers the calculation of GDP at constant 2011 US dollars for 183 IFs countries. The excluded countries are Syria, Somalia, and North Korea.

Data Source

1. GDP at current US$, 1960-2018

https://data.worldbank.org/indicator/NY.GDP.MKTP.CD ,

the World Bank

2. Real GDP annual growth (% change), 1960-2018

https://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG,

The World Bank 

3. Real GDP annual growth (% change), 1980-2024

https://www.imf.org/external/datamapper/NGDP_RPCH@WEO/OEMDC/ADVEC/WEOWORLD,

The International Monetary Fund

Calculation Steps

1. Take GDP values from current US$ data for each country in 2011, do the country concordance and unit conversion (GDP in IFs is in Billion US$). The GDP at current US$ in year 2011 for each country equals to that country’s GDP at constant 2011 US$. So now we have a data that has each country’s GDP at constant 2011 US$ in year 2011, in billion US dollars, in IFs country name format.

2. Use the above data as our base year, then use the GDP annual growth rate to fill forward (2011 to 2024) & backwards (2011 to 1960) each country’s GDP for all years. During the calculation, the growth rate from WDI should serve as our primary source while the IMF growth rate would serve as the supplemental source, i.e., whenever there is a missing value in WDI’s growth rate, we will then rely on IMF’s growth rate. After this step, we will then have a full dataset of GDP at constant 2011 US billion dollars, expect Syria, Somalia, and North Korea.