Database files in IFs - Revision history

JakeDubbert at 18:46, 9 November 2017

2017-11-09T18:46:59Z

← Older revision		Revision as of 18:46, 9 November 2017
Line 146:		Line 146:
	\| height="20" \| '''Formula'''		\| height="20" \| '''Formula'''
	\| width="558" \| Option during import to manipulate the data		\| width="558" \| Option during import to manipulate the data
	\| width="209" \| *100		\| width="209" \| *100 (to convert to %)
	\|}		\|}

JakeDubbert at 18:46, 9 November 2017

2017-11-09T18:46:00Z

← Older revision		Revision as of 18:46, 9 November 2017
Line 85:		Line 85:
	\|-		\|-
	\| height="20" \| '''Source'''		\| height="20" \| '''Source'''
	\| width="558" \| ~~Website name~~ the data source is from		\| width="558" \| Source or website the data source is from
	\| width="209" \| World Bank		\| width="209" \| World Bank
	\|-		\|-

JakeDubbert at 18:45, 9 November 2017

2017-11-09T18:45:17Z

← Older revision		Revision as of 18:45, 9 November 2017
Line 74:		Line 74:
	\| height="20" \| '''Units'''		\| height="20" \| '''Units'''
	\| width="558" \| Specification of the units the variable is measured by		\| width="558" \| Specification of the units the variable is measured by
	\| width="209" \| Percent		\| width="209" \| Percent;People;Degrees C
	\|-		\|-
	\| height="20" \| '''Currency'''		\| height="20" \| '''Currency'''
	\| width="558" \| ~~Leave blank~~		\| width="558" \| Currency of the units if they're monetary
	\| width="209" \|		\| width="209" \|  USD;Euro;Lira
	\|-		\|-
	\| height="20" \| '''Years'''		\| height="20" \| '''Years'''
Line 93:		Line 93:
	\|-		\|-
	\| height="20" \| '''Notes'''		\| height="20" \| '''Notes'''
	\| width="558" \| Any additional notes and the initials of the ~~person that pulled~~ the data		\| width="558" \| Any additional notes and the initials of the puller and vetter of the data
	\| width="209" \| Created individual index;EB		\| width="209" \| Created individual index;EB;JD
	\|-		\|-
	\| height="20" \| '''Last IFs Update'''		\| height="20" \| '''Last IFs Update'''
Line 102:		Line 102:
	\| height="40" \| '''Aggregation'''		\| height="40" \| '''Aggregation'''
	\| width="558" \| Tells the model how to aggregate country values to groups within the model. Will automatically generate if classified during import.		\| width="558" \| Tells the model how to aggregate country values to groups within the model. Will automatically generate if classified during import.
	\| width="209" \| POP		\| width="209" \| POP;GDP;LAND;AVG;SUM
	\|-		\|-
	\| height="40" \| '''Disaggregation'''		\| height="40" \| '''Disaggregation'''
	\| width="558" \| Tells the model how to disaggregate country values to subregional classification ~~(Always GDP)~~		\| width="558" \| Tells the model how to disaggregate country values to subregional classification
	\| width="209" \| GDP		\| width="209" \| GDP
	\|-		\|-
Line 113:		Line 113:
	\|-		\|-
	\| height="20" \| '''Proprietary'''		\| height="20" \| '''Proprietary'''
	\| width="558" \| ~~ <font>Leave blank</font>~~		\| width="558" \| Usually data series are non-proprietary
	\| width="209" \|		\| width="209" \|
	\|-		\|-
	\| height="40" \| '''Name in Source'''		\| height="40" \| '''Name in Source'''
	\| width="558" \| ~~Information~~ on how the data was pulled so someone can ~~replicate exactly~~		\| width="558" \| Exact name of series in the source file and other nformation on how the data was pulled so someone can reimport it in the same way
	\| width="209" \| Sum of Rural Latrines, Septic Tanks, Sewer Connections		\| width="209" \| World File;Sanitation;Sum of Rural Latrines, Septic Tanks, Sewer Connections
	\|-		\|-
	\| height="20" \| '''Used in Preprocessor'''		\| height="20" \| '''Used in Preprocessor'''
	\| width="558" \|  <font>If checked, data set is used in preprocessor</font>		\| width="558" \| Filled automatically when script is run before consolidation. <font>If checked, data set is used in preprocessor. Puller/Vetter not responsible for this.</font>
	\| width="209" \|		\| width="209" \|
	\|-		\|-
	\| height="40" \| '''UsedInPreprocessorFileName'''		\| height="40" \| '''UsedInPreprocessorFileName'''
	\| width="558" \| File name that is used in preprocessor. ~~If Used in Preprocessor is checked,~~ this ~~should be filled~~		\| width="558" \| File name that is used in preprocessor that is filled automatically before consolidation. Puller/vetter not responsible for this.
	\| width="209" \|		\| width="209" \|
	\|-		\|-
	\| height="20" \| '''CompareOtherForecasts'''		\| height="20" \| '''CompareOtherForecasts'''
	\| width="558" \| ~~Leave blank~~		\| width="558" \| If series is a forecast from another source, this will be checked
	\| width="209" \|		\| width="209" \|
	\|-		\|-

JakeDubbert at 22:25, 8 November 2017

2017-11-08T22:25:55Z

Show changes

JakeDubbert at 22:24, 8 November 2017

2017-11-08T22:24:37Z

Show changes

JakeDubbert at 22:24, 8 November 2017

2017-11-08T22:24:20Z

← Older revision		Revision as of 22:24, 8 November 2017
Line 30:		Line 30:


	<~~datadict_defenitions~~>		{\| border="0" cellpadding="0" cellspacing="0" width="964"
			\|- height="20"
			\| height="20" width="197" \| Column
			\| width="558" \| Description
			\| width="209" \| Example
			\|- height="40"
			\| height="40" \| Variable Name
			\| width="558" \| Name of variable you assign (Automatically generated from import)
			\| width="209" \| WSSJMPSanitationRural%Improved
			\|- height="40"
			\| height="40" \| Table
			\| width="558" \| Automatically generated
			\| width="209" \| SeriesWSSJMPSanitationRural%Improved
			\|- height="20"
			\| height="20" \| Group
			\| width="558" \| Group or category you assign to the variable (Automatically generated from import)
			\| width="209" \| Infrastructure, Water, Health
			\|- height="20"
			\| height="20" \| Subgroup
			\| width="558" \| Subroup you assign to the variable (Automatically generated from import)
			\| width="209" \| Sanitation
			\|- height="20"
			\| height="20" \| Series
			\| width="558" \| Yes
			\| width="209" \| Yes
			\|- height="20"
			\| height="20" \| CoVaTra
			\| width="558" \| No
			\| width="209" \| No
			\|- height="20"
			\| height="20" \| Cohort
			\| width="558" \| No
			\| width="209" \| No
			\|- height="60"
			\| height="60" \| Definition
			\| width="558" \| Specific definition of the variable that will be displayed in IFs
			\| width="209" \| Proportion of Rural population served with Improved Sanitation (%)
			\|- height="60"
			\| height="60" width="197" \| Extended Source Definition
			\| width="558" \| Additional information about the variable if needed
			\| width="209" \| Likely to ensure hygenic separation of human excreta from human contact.
			\|- height="20"
			\| height="20" \| Units
			\| width="558" \| Specification of the units the variable is measured by
			\| width="209" \| Percent
			\|- height="20"
			\| height="20" \| Currency
			\| width="558" \| Leave blank
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Years
			\| width="558" \| Years that data set covers (Automatically generated but make sure its accurate)
			\| width="209" \| 2000-2015
			\|- height="20"
			\| height="20" \| Source
			\| width="558" \| Website name the data source is from
			\| width="209" \| World Bank
			\|- height="20"
			\| height="20" width="197" \| Original Source
			\| width="558" \| URL of data source
			\| width="209" \| [https://washdata.org/ https://washdata.org]
			\|- height="20"
			\| height="20" \| Notes
			\| width="558" \| Any additional notes and the initials of the person that pulled the data
			\| width="209" \| Created individual index;EB
			\|- height="20"
			\| height="20" \| Last IFs Update
			\| width="558" \| Automatically generated
			\| width="209" \| 10/30/2017
			\|- height="40"
			\| height="40" \| Aggregation
			\| width="558" \| Tells the model how to aggregate country values to groups within the model. Will automatically generate if classified during import.
			\| width="209" \| POP
			\|- height="40"
			\| height="40" \| Disaggregation
			\| width="558" \| Tells the model how to disaggregate country values to subregional classification (Always GDP)
			\| width="209" \| GDP
			\|- height="20"
			\| height="20" \| TreatNullsAs0s
			\| width="558" \| If checked, will treat nulls in the data set as zeroes
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Proprietary
			\| width="558" \|  <font>Leave blank</font>
			\| width="209" \|
			\|- height="40"
			\| height="40" \| Name in Source
			\| width="558" \| Information on how the data was pulled so someone can replicate exactly
			\| width="209" \| Sum of Rural Latrines, Septic Tanks, Sewer Connections
			\|- height="20"
			\| height="20" \| Used in Preprocessor
			\| width="558" \|  <font>If checked, data set is used in preprocessor</font>
			\| width="209" \|
			\|- height="40"
			\| height="40" \| UsedInPreprocessorFileName
			\| width="558" \| File name that is used in preprocessor. If Used in Preprocessor is checked, this should be filled
			\| width="209" \|
			\|- height="20"
			\| height="20" \| CompareOtherForecasts
			\| width="558" \| Leave blank
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Code in Source
			\| width="558" \| Only used in batch pulls
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Decimal Places
			\| width="558" \| Decimal places for data in data series
			\| width="209" \| 4
			\|- height="20"
			\| height="20" \| Country Concordance
			\| width="558" \| Country concordance used to import data into IFs. (Will automatically generate)
			\| width="209" \| IFs Country
			\|- height="20"
			\| height="20" \| Formula
			\| width="558" \| Option during import to manipulate the data
			\| width="209" \| *100
			\|}

JakeDubbert at 22:23, 8 November 2017

2017-11-08T22:23:09Z

← Older revision		Revision as of 22:23, 8 November 2017
Line 27:		Line 27:

	The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.		The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.



			<datadict_defenitions>

JakeDubbert at 22:41, 6 November 2017

2017-11-06T22:41:29Z

← Older revision		Revision as of 22:41, 6 November 2017
Line 27:		Line 27:

	The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.		The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.

	~~{\| border="1" cellspacing="1" cellpadding="1" style="width: 796px;"~~
	\|-
	\|
	~~{\| border="0" cellpadding="0" cellspacing="0" width="197"~~
	\|-
	~~\| height="20" width="197" \| Column ~~
	\|}

	\|
	~~{\| border="0" cellpadding="0" cellspacing="0" width="558"~~
	\|-
	~~\| height="20" width="558" \| Description~~
	\|}

	~~\| style="width: 23px;" \| Example~~
	\|-
	\|
	~~{\| border="0" cellpadding="0" cellspacing="0" width="197"~~
	\|-
	\|
	\|}

	\|}

JakeDubbert at 22:41, 6 November 2017

2017-11-06T22:41:11Z

← Older revision		Revision as of 22:41, 6 November 2017
Line 1:		Line 1:
	~~<parsererror style="display: block; white-space: pre; border: 2px solid #c77; padding: 0 1em 0 1em; margin: 1em; background-color: #fdd; color: black">~~
	~~=== This page contains the following errors: ===~~
	~~<div style="font-family:monospace;font-size:12px">error on line 1 at column 4358: attributes construct error </div>~~
	~~=== Below is a rendering of the page up to the first error. ===~~
	~~</parsererror>~~
	= IFs Historical Database Files =		= IFs Historical Database Files =

Line 33:		Line 28:
	The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.		The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.

	{\| border="1" ~~cellpadding~~="1" ~~cellspacing~~="1" ~~width~~="~~964~~"		{\| border="1" cellspacing="1" cellpadding="1" style="width: 796px;"
	\|- ~~height~~="20"		\|-
			\|
			{\| border="0" cellpadding="0" cellspacing="0" width="197"
			\|-
	\| height="20" width="197" \| Column		\| height="20" width="197" \| Column
	\| width="558" \| Description		\|}
	\| ~~width~~="~~209~~" \| Example
	\|- ~~height~~="40"		\|
	~~\| height~~="40" \| ~~Variable Name~~		{\| border="0" cellpadding="0" cellspacing="0" width="558"
			\|-
			\| height="20" width="558" \| Description
			\|}

			\| style="width: 23px;" \| Example
			\|-
			\|
			{\| border="0" cellpadding="0" cellspacing="0" width="197"
			\|-
			\|
			\|}

	\|}		\|}

JakeDubbert at 22:36, 6 November 2017

2017-11-06T22:36:12Z

← Older revision		Revision as of 22:36, 6 November 2017
Line 1:		Line 1:
			<parsererror style="display: block; white-space: pre; border: 2px solid #c77; padding: 0 1em 0 1em; margin: 1em; background-color: #fdd; color: black">
			=== This page contains the following errors: ===
			<div style="font-family:monospace;font-size:12px">error on line 1 at column 4358: attributes construct error </div>
			=== Below is a rendering of the page up to the first error. ===
			</parsererror>
	= IFs Historical Database Files =		= IFs Historical Database Files =

Line 27:		Line 32:

	The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.		The Datadict.mdb file serves as a reference for all series in the IFsHistSeries.mdb file. Every series in IFsHistSeries has an entry in DataDict containing all of the metadata on that series. The Data Dictionary lists each variable, the groups to which it belongs (e.g., Agriculture, Economics) its subgroup (e.g., Trade, Consumption), and additional identifying information. This information includes whether or not the data is a series (Yes/No), CoVaTrA, Cohort. It also includes a definition of the variable, and a column for an extended definition provided by the data source. The data dictionary has columns identifying the years for which a series has data, the source of the data, the original source (e.g. a series may have been pulled from the FAO website, but may have originated as World Bank research.) and the source name of the series, and an identifier for which team member last updated the series and when. It also includes instructions on how data should be aggregated or disaggregated for provincial models (e.g., by population or GDP distribution). Some additional information is supplied that is used by the model such as whether a datum of 0 should be treated as a null or as a zero, if a series is used in the preprocessor, if it is compared to other forecasts, the number of decimal places to read, and any formulas applied to the data.

			{\| border="1" cellpadding="1" cellspacing="1" width="964"
			\|- height="20"
			\| height="20" width="197" \| Column
			\| width="558" \| Description
			\| width="209" \| Example
			\|- height="40"
			\| height="40" \| Variable Name
			\|}

← Older revision		Revision as of 18:45, 9 November 2017
Line 74:		Line 74:
	\| height="20" \| '''Units'''		\| height="20" \| '''Units'''
	\| width="558" \| Specification of the units the variable is measured by		\| width="558" \| Specification of the units the variable is measured by
	\| width="209" \| Percent		\| width="209" \| Percent;People;Degrees C
	\|-		\|-
	\| height="20" \| '''Currency'''		\| height="20" \| '''Currency'''
	\| width="558" \| ~~Leave blank~~		\| width="558" \| Currency of the units if they're monetary
	\| width="209" \|		\| width="209" \|  USD;Euro;Lira
	\|-		\|-
	\| height="20" \| '''Years'''		\| height="20" \| '''Years'''
Line 93:		Line 93:
	\|-		\|-
	\| height="20" \| '''Notes'''		\| height="20" \| '''Notes'''
	\| width="558" \| Any additional notes and the initials of the ~~person that pulled~~ the data		\| width="558" \| Any additional notes and the initials of the puller and vetter of the data
	\| width="209" \| Created individual index;EB		\| width="209" \| Created individual index;EB;JD
	\|-		\|-
	\| height="20" \| '''Last IFs Update'''		\| height="20" \| '''Last IFs Update'''
Line 102:		Line 102:
	\| height="40" \| '''Aggregation'''		\| height="40" \| '''Aggregation'''
	\| width="558" \| Tells the model how to aggregate country values to groups within the model. Will automatically generate if classified during import.		\| width="558" \| Tells the model how to aggregate country values to groups within the model. Will automatically generate if classified during import.
	\| width="209" \| POP		\| width="209" \| POP;GDP;LAND;AVG;SUM
	\|-		\|-
	\| height="40" \| '''Disaggregation'''		\| height="40" \| '''Disaggregation'''
	\| width="558" \| Tells the model how to disaggregate country values to subregional classification ~~(Always GDP)~~		\| width="558" \| Tells the model how to disaggregate country values to subregional classification
	\| width="209" \| GDP		\| width="209" \| GDP
	\|-		\|-
Line 113:		Line 113:
	\|-		\|-
	\| height="20" \| '''Proprietary'''		\| height="20" \| '''Proprietary'''
	\| width="558" \| ~~ <font>Leave blank</font>~~		\| width="558" \| Usually data series are non-proprietary
	\| width="209" \|		\| width="209" \|
	\|-		\|-
	\| height="40" \| '''Name in Source'''		\| height="40" \| '''Name in Source'''
	\| width="558" \| ~~Information~~ on how the data was pulled so someone can ~~replicate exactly~~		\| width="558" \| Exact name of series in the source file and other nformation on how the data was pulled so someone can reimport it in the same way
	\| width="209" \| Sum of Rural Latrines, Septic Tanks, Sewer Connections		\| width="209" \| World File;Sanitation;Sum of Rural Latrines, Septic Tanks, Sewer Connections
	\|-		\|-
	\| height="20" \| '''Used in Preprocessor'''		\| height="20" \| '''Used in Preprocessor'''
	\| width="558" \|  <font>If checked, data set is used in preprocessor</font>		\| width="558" \| Filled automatically when script is run before consolidation. <font>If checked, data set is used in preprocessor. Puller/Vetter not responsible for this.</font>
	\| width="209" \|		\| width="209" \|
	\|-		\|-
	\| height="40" \| '''UsedInPreprocessorFileName'''		\| height="40" \| '''UsedInPreprocessorFileName'''
	\| width="558" \| File name that is used in preprocessor. ~~If Used in Preprocessor is checked,~~ this ~~should be filled~~		\| width="558" \| File name that is used in preprocessor that is filled automatically before consolidation. Puller/vetter not responsible for this.
	\| width="209" \|		\| width="209" \|
	\|-		\|-
	\| height="20" \| '''CompareOtherForecasts'''		\| height="20" \| '''CompareOtherForecasts'''
	\| width="558" \| ~~Leave blank~~		\| width="558" \| If series is a forecast from another source, this will be checked
	\| width="209" \|		\| width="209" \|
	\|-		\|-

← Older revision		Revision as of 22:24, 8 November 2017
Line 30:		Line 30:


	<~~datadict_defenitions~~>		{\| border="0" cellpadding="0" cellspacing="0" width="964"
			\|- height="20"
			\| height="20" width="197" \| Column
			\| width="558" \| Description
			\| width="209" \| Example
			\|- height="40"
			\| height="40" \| Variable Name
			\| width="558" \| Name of variable you assign (Automatically generated from import)
			\| width="209" \| WSSJMPSanitationRural%Improved
			\|- height="40"
			\| height="40" \| Table
			\| width="558" \| Automatically generated
			\| width="209" \| SeriesWSSJMPSanitationRural%Improved
			\|- height="20"
			\| height="20" \| Group
			\| width="558" \| Group or category you assign to the variable (Automatically generated from import)
			\| width="209" \| Infrastructure, Water, Health
			\|- height="20"
			\| height="20" \| Subgroup
			\| width="558" \| Subroup you assign to the variable (Automatically generated from import)
			\| width="209" \| Sanitation
			\|- height="20"
			\| height="20" \| Series
			\| width="558" \| Yes
			\| width="209" \| Yes
			\|- height="20"
			\| height="20" \| CoVaTra
			\| width="558" \| No
			\| width="209" \| No
			\|- height="20"
			\| height="20" \| Cohort
			\| width="558" \| No
			\| width="209" \| No
			\|- height="60"
			\| height="60" \| Definition
			\| width="558" \| Specific definition of the variable that will be displayed in IFs
			\| width="209" \| Proportion of Rural population served with Improved Sanitation (%)
			\|- height="60"
			\| height="60" width="197" \| Extended Source Definition
			\| width="558" \| Additional information about the variable if needed
			\| width="209" \| Likely to ensure hygenic separation of human excreta from human contact.
			\|- height="20"
			\| height="20" \| Units
			\| width="558" \| Specification of the units the variable is measured by
			\| width="209" \| Percent
			\|- height="20"
			\| height="20" \| Currency
			\| width="558" \| Leave blank
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Years
			\| width="558" \| Years that data set covers (Automatically generated but make sure its accurate)
			\| width="209" \| 2000-2015
			\|- height="20"
			\| height="20" \| Source
			\| width="558" \| Website name the data source is from
			\| width="209" \| World Bank
			\|- height="20"
			\| height="20" width="197" \| Original Source
			\| width="558" \| URL of data source
			\| width="209" \| [https://washdata.org/ https://washdata.org]
			\|- height="20"
			\| height="20" \| Notes
			\| width="558" \| Any additional notes and the initials of the person that pulled the data
			\| width="209" \| Created individual index;EB
			\|- height="20"
			\| height="20" \| Last IFs Update
			\| width="558" \| Automatically generated
			\| width="209" \| 10/30/2017
			\|- height="40"
			\| height="40" \| Aggregation
			\| width="558" \| Tells the model how to aggregate country values to groups within the model. Will automatically generate if classified during import.
			\| width="209" \| POP
			\|- height="40"
			\| height="40" \| Disaggregation
			\| width="558" \| Tells the model how to disaggregate country values to subregional classification (Always GDP)
			\| width="209" \| GDP
			\|- height="20"
			\| height="20" \| TreatNullsAs0s
			\| width="558" \| If checked, will treat nulls in the data set as zeroes
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Proprietary
			\| width="558" \|  <font>Leave blank</font>
			\| width="209" \|
			\|- height="40"
			\| height="40" \| Name in Source
			\| width="558" \| Information on how the data was pulled so someone can replicate exactly
			\| width="209" \| Sum of Rural Latrines, Septic Tanks, Sewer Connections
			\|- height="20"
			\| height="20" \| Used in Preprocessor
			\| width="558" \|  <font>If checked, data set is used in preprocessor</font>
			\| width="209" \|
			\|- height="40"
			\| height="40" \| UsedInPreprocessorFileName
			\| width="558" \| File name that is used in preprocessor. If Used in Preprocessor is checked, this should be filled
			\| width="209" \|
			\|- height="20"
			\| height="20" \| CompareOtherForecasts
			\| width="558" \| Leave blank
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Code in Source
			\| width="558" \| Only used in batch pulls
			\| width="209" \|
			\|- height="20"
			\| height="20" \| Decimal Places
			\| width="558" \| Decimal places for data in data series
			\| width="209" \| 4
			\|- height="20"
			\| height="20" \| Country Concordance
			\| width="558" \| Country concordance used to import data into IFs. (Will automatically generate)
			\| width="209" \| IFs Country
			\|- height="20"
			\| height="20" \| Formula
			\| width="558" \| Option during import to manipulate the data
			\| width="209" \| *100
			\|}