def_spread

Defining spreads

Below you will find an excel template for defining the tables and instructions on how to fill in the spreadsheet.

• Excel template for defining the spreads

PART	TOPIC_NAME	OBJECT_TYPE	PLOT_OBJECTIVE	AREA	OBJECT_DESCRIPTION	YEAR_START	YEAR_END	ORIG_UNIT
1	Overview	CHART	multi_stack_line	M49world	World rural and urban population	1961	2030	people
2	Undernourishment	MINITABLE		M49world + M49macroReg	Prevalence of undernourishment	1992	2014	percent
3	Dietary energy supply	CHART	bot_dot	Territory	Dietary energy supply, bottom 20 (2000-02 vs. 2009-11)	2000	2015	kcal/cap/day
4	Energy	MAP		Territory	Energy consumption for power irrigation, million kWh	2011	2011	kWh

Detailed instruction for each column

• PART
• TOPIC_NAME
• OBJECT_TYPE
• PLOT_OBJECTIVE
• AREA
• OBJECT_DESCRIPTION
• YEAR_START
• YEAR_END
• ORIG_UNIT

PART

TOPIC_NAME

OBJECT_TYPE

PLOT_OBJECTIVE

code	preview	notes
reg_uni_line		Some notes about the plot could be written here
multi_line		Some notes about the plot
multi_stack_line		Some notes about the plot
top_dot		Some notes about the plot
top_dot_multi		Some notes about the plot
bot_dot		Some notes about the plot
top_bot_dot		Some notes about the plot
multi_stack_bar		Some notes about the plot
multi_dodge_bar		Some notes about the plot
pie		Some notes about the plot
pie_multi		Some notes about the plot
map		Some notes about the plot
minitable		Some notes about the plot

AREA

OBJECT_DESCRIPTION

YEAR_START

YEAR_END

ORIG_UNIT