Global food supply infographic (PUBLIC)

	A	B	C	D	E	F	G	H	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AY	AZ	BA	BB	BC	BD	BE	BH	BI	BJ	BK	BL	BM	BN	BO	BR	BS	BT	BU
1	How much do we make								who gets it									who gets it total						who gets it/per capita						total			How much should people get /cap		by food	total						How much is needed (xpop)					plus waste		How much is needed						overshoot/undershoot		production from column 1
2		original	merged categories	animal feed %	biofuels %	total % redirected	adjusted totals	display totals	region	food	% of supply / consumption	checksum	difference	total adjusted supply	old numbers	total adjusted supply (in new food groups)	old numbers for check sum	new adjusted total			% of total	old total	% of world population	region	food	kg / capita	kg/cap (old)	kg / capita (in new food groups)	by food groups(old)	new adjusted total	old total	calculation for chart	region	food	recommended consumption	total recommended consumption	over- or under- shoot	% over or under	calc for chart	overshoot/undershoot		region	food	population	m tonnes	total	m Tonnes	total	food	m Tonnes	12.77	mTonnes	12.77	total waste
3	food	m Tonnes						for the graphic			live numbers	pre-check		m tonnes	m tonnes	m tonnes	m tonnes	m tonnes	pixels	ratio		m/tonnes					for checking		for checking	kg / capita	kg/cap	ignore			kg/cap/year	kg/cap/year			SQRT	old	old									exc waste	pixels	inc. waste	pixels		mTonnes	%	food	m Tonnes
4			7379.6				5969	7385								5969.5		5969		9.27		7384.9	100.00%							6,521														6,416,459,397				3,778.36		2,906.43	228	3,778.36	296	871.93

5	Startch Veg	834.7	834.7				835	835	S Asia	Startch Veg	10.30%	40.94%	0.31	85.97	414.34	86.0	414.34	860	92.85		14.41%	1469.18	20.43%	S Asia	Startch Veg	65.58	316.07	65.58	316.1	656	1,121	32.8	S Asia	Starch Veg	18.25	452.97	47.3	259%	16.1	297.8	1632%	S Asia	Startch Veg	1,310,898,890	23.92	593.79	31.10	771.93	Startch Veg	117.10	9	152.23	12		682.47	82%	Startch Veg	834
6	Whole Grains	2667	2667	41%	11%	52%	1280	1280		Whole Grains	20.93%	20.93%	0.00	267.94	558.22	267.9	558.22								Whole Grains	204.40	425.83	204.40	425.8					Whole Grains	84.68		119.7	141%	11.9	341.1	403%		Whole Grains	1,310,898,890	111.01		144.31		Whole Grains	543.35	43	706.35	55		1,960.65	74%	Whole Grains	2667
7	Vegetables	1130	2013				1130	2013		Vegetables	10.14%	10.14%	0.00	114.60	114.6	236.5	236.49								Vegetables	87.42	87.42	180.40	180.4					Vegetables	182.5		(2.1)	-1%	1.1	(2.1)	-1%		Vegetables	1,310,898,890	239.24		311.01		Vegetables	1,171.00	92	1,522.30	119		490.70	31%	Vegetables	1570
8	Fruit	883					883			Fruit	13.80%	13.80%	0.00	121.89	121.89										Fruit	92.98	92.98							Fruit						-			Fruit	1,310,898,890					Fruit	-	-		-		-		Fruit
9	milk & Dairy	841	841				841	841		milk & Dairy	14.95%	12.81%	-0.02	125.76	107.74	125.8	107.74								milk & Dairy	95.93	82.19	95.93	82.2					milk & Dairy	91.25		4.7	5%	#NUM!	(9.1)	-10%		milk & Dairy	1,310,898,890	119.62		155.51		milk & Dairy	585.50	46	761.15	60		79.85	9%	milk & Dairy	841
10	red meat	212	212				212	212		red meat	2.26%	2.26%	0.00	4.79	4.79	4.8	4.79								read meat	3.66	3.65	3.66	3.7					read meat	5.11		(1.5)	-28%	5.3	(1.5)	-28%		read meat	1,310,898,890	6.70		8.71		read meat	32.79	2.6	42.62	3.3		169.38	80%	read meat	212
11	Poultry	134	371.9				134	372		Poultry	3.35%	3.35%	0.00	4.48	4.48	19.7	19.72								Poultry	3.42	3.42	15.05	15.0					Poultry	25.55		(10.5)	-41%	6.4	(10.5)	-41%		Poultry	1,310,898,890	33.49		43.54		Poultry	163.94	13	213.12	17		158.78	118%	Poultry	134
12	Fish & Seafood	155					155			Fish & Seafood	6.43%	6.43%	0.00	9.96	9.96										Fish & Seafood	7.60	7.60							Fish & Seafood						-			Fish & Seafood	1,310,898,890					Fish & Seafood	-					-		Fish & Seafood
13	eggs	82.9					82.9			eggs	6.37%	6.37%	0.00	5.28	5.28										eggs	4.03	4.03							eggs						-			eggs	1,310,898,890					eggs	-					-		eggs
14	Legumes & nuts	440	440	6.20%	0.30%	6.50%	411	417		Legumes	28.90%	28.90%	0.00	118.88	127.88	119.6	119.61								Legumes	90.69	97.55	91.24	97.6					Legumes	45.625		45.6	100%	10.0	51.9	114%		Legumes	1,310,898,890	59.81		77.75		Legumes	292.75	23	380.58	30		64.72	15%	Legumes	440
15	Nuts	5.3	5.3				5.3			nuts	13.69%	13.69%	0.00	0.73											nuts	0.55								nuts										1,310,898,890
16																																																	Waste	871.93	68		-
17									E Asia & Oceania	Startch Veg	31.86%	17.89%	-0.14	265.96	149.32	266.0	149.32	2193			36.74%	2634.18	32.94%	E Asia & Oceania	Startch Veg	125.85	70.65	125.85	70.7	1,038	1,246	51.9	E Asia & Oceania	Startch Veg	18.25	452.97	107.6	590%	24.3	52.4	287%	E Asia & Oceania	Startch Veg	2,113,393,271	38.57	957.29	50.14	1,244.48
18	animal feed							1121		Whole Grains	39.50%	39.50%	0.00	505.60	1053.34	505.6	1053.34								Whole Grains	239.24	498.41	239.24	498.4					Whole Grains	84.68		154.6	183%	13.5	413.7	489%		Whole Grains	2,113,393,271	178.96		232.65
19	biofuels							295		Vegetables	59.77%	59.77%	0.00	675.36	675.36	987.3	987.29								Vegetables	319.56	319.56	467.16	467.2					Vegetables	182.5		284.7	156%	12.5	284.7	156%		Vegetables	2,113,393,271	385.69		501.40
20										Fruit	35.33%	35.33%	0.00	311.93	311.93										Fruit	147.60	147.60							Fruit						-			Fruit	2,113,393,271
21										milk & Dairy	3.10%	3.18%	0.00	26.09	26.74	26.1	26.74								milk & Dairy	12.34	12.65	12.34	12.7					milk & Dairy	91.25		(78.9)	-86%	9.3	(78.6)	-86%		milk & Dairy	2,113,393,271	192.85		250.70
22										read meat	43.75%	43.75%	0.00	92.75	92.75	92.7	92.75								read meat	43.88	43.89	43.88	43.9					read meat	5.11		38.8	759%	27.5	38.8	759%		read meat	2,113,393,271	10.80		14.04										Eat Lancet ideal Diet
23										Poultry	29.15%	29.15%	0.00	39.06	39.06	182.1	182.06								Poultry	18.48	18.48	86.14	86.1					Poultry	25.55		60.6	237%	15.4	60.6	237%		Poultry	2,113,393,271	54.00		70.20										per cap consumption requirements	g/day	g/year	kg/year
24										Fish & Seafood	62.66%	62.66%	0.00	97.12	97.12										Fish & Seafood	45.95	45.95							Fish & Seafood						-			Fish & Seafood	2,113,393,271													starchy veg	50	18250	18
25										eggs	55.34%	55.34%	0.00	45.88	45.88										eggs	21.71	21.71							eggs						-			eggs	2,113,393,271													whole grains	232	84680	85
26										Legumes	31.93%	31.93%	0.00	131.35	142.68	133.5	142.68								Legumes	62.15	67.51	63.19	67.5					Legumes	45.625		17.6	39%	6.2	21.9	48%		Legumes	2,113,393,271	96.42		125.35										veg & fruit	500	182500	183
27										nuts	41.57%	41.57%	0.00	2.20											nuts	1.04								nuts										2,113,393,271
28
29									SSAfrica	Startch Veg	24.11%	13.54%	-0.11	201.25	112.99	201.2	112.99	504			8.45%	524.33	10.03%	SSAfrica	Startch Veg	312.60	175.51	312.60	175.5	783	814	39.2	SSAfrica	Startch Veg	18.25	452.97	294.3	1613%	40.2	157.3	862%	SSAfrica	Startch Veg	643,782,928	11.75	291.61	15.27	379.09
30										Whole Grains	7.46%	7.46%	0.00	95.54	199.03	95.5	199.03								Whole Grains	148.40	309.16	148.40	309.2					Whole Grains	84.68		63.7	75%	8.7	224.5	265%		Whole Grains	643,782,928	54.52		70.87										milk	250	91250	91
31										Vegetables	3.08%	3.08%	0.00	34.79	34.79	98.5	98.51								Vegetables	54.04	54.04	153.01	153.0					Vegetables	182.5		(29.5)	-16%	4.0	(29.5)	-16%		Vegetables	643,782,928	117.49		152.74										redmeat	14	5110	5
32										Fruit	7.22%	7.22%	0.00	63.72	63.72										Fruit	98.97	98.98							Fruit						-			Fruit	643,782,928													other asf	70	25550	26
33										milk & Dairy	3.88%	3.98%	0.00	32.62	33.43	32.6	33.43								milk & Dairy	50.67	51.93	50.67	51.9					milk & Dairy	91.25		(40.6)	-44%	6.7	(39.3)	-43%		milk & Dairy	643,782,928	58.75		76.37
34										read meat	2.86%	2.86%	0.00	6.07	6.07	6.1	6.07								read meat	9.43	9.43	9.43	9.4					read meat	5.11		4.3	85%	9.2	4.3	85%		read meat	643,782,928	3.29		4.28
35										Poultry	3.20%	3.20%	0.00	4.29	4.29	12.4	12.36								Poultry	6.67	6.66	19.19	19.2					Poultry	25.55		(6.4)	-25%	5.0	(6.4)	-25%		Poultry	643,782,928	16.45		21.38										legumes	125	45625	46
36										Fish & Seafood	4.33%	4.33%	0.00	6.72	6.72										Fish & Seafood	10.43	10.44							Fish & Seafood						-			Fish & Seafood	643,782,928																453
37										eggs	1.62%	1.62%	0.00	1.35	1.35										eggs	2.09	2.10							eggs						-			eggs	643,782,928
38										Legumes	14.04%	14.04%	0.00	57.76	61.94	57.9	61.94								Legumes	89.72	96.21	89.98	96.2					Legumes	45.625		44.4	97%	9.9	50.6	111%		Legumes	643,782,928	29.37		38.18
39										nuts	3.07%	3.07%	0.00	0.16											nuts	0.25								nuts										643,782,928
40
41									EMEA	Startch Veg	3.48%	1.95%	-0.02	29.02	16.29	29.0	16.29	320			5.37%	406.28	6.07%	EMEA	Startch Veg	74.52	41.83	74.52	41.8	823	1,043	41.1	EMEA	Startch Veg	18.25	452.97	56.3	308%	17.6	23.6	129%	EMEA	Startch Veg	389,455,861	7.11	176.41	9.24	229.33
42										Whole Grains	6.95%	6.95%	0.00	88.99	185.39	89.0	185.39								Whole Grains	228.50	476.02	228.50	476.0					Whole Grains	84.68		143.8	170%	13.0	391.3	462%		Whole Grains	389,455,861	32.98		42.87										population
43										Vegetables	5.07%	5.07%	0.00	57.31	57.31	120.4	120.42								Vegetables	147.15	147.15	309.18	309.2					Vegetables	182.5		126.7	69%	8.3	126.7	69%		Vegetables	389,455,861	71.08		92.40										SUB SAHARAN AFRICA	643,782,928
44										Fruit	7.15%	7.15%	0.00	63.11	63.11										Fruit	162.04	162.05							Fruit						-			Fruit	389,455,861													Middle East & North Africa	389,455,861
45										milk & Dairy	5.19%	5.32%	0.00	43.67	44.76	43.7	44.76								milk & Dairy	112.13	114.93	112.13	114.9					milk & Dairy	91.25		20.9	23%	4.8	23.7	26%		milk & Dairy	389,455,861	35.54		46.20										South Asia	1,310,898,890
46										read meat	2.20%	2.20%	0.00	4.67	4.67	4.7	4.67								read meat	11.99	11.99	11.99	12.0					read meat	5.11		6.9	135%	11.6	6.9	135%		read meat	389,455,861	1.99		2.59										Europe & Central Asia	1,046,254,720
47										Poultry	6.46%	6.46%	0.00	8.66	8.66	16.5	16.51								Poultry	22.23	22.24	42.39	42.4					Poultry	25.55		16.8	66%	8.1	16.8	66%		Poultry	389,455,861	9.95		12.94										N.America	331,543,147
48										Fish & Seafood	3.43%	3.43%	0.00	5.31	5.31										Fish & Seafood	13.64	13.63							Fish & Seafood						-			Fish & Seafood	389,455,861													East Asia & Pacific	2,113,393,271
49										eggs	3.06%	3.06%	0.00	2.54	2.54										eggs	6.52	6.52							eggs						-			eggs	389,455,861													Latin America & Caribbean	581,130,580
50										Legumes	4.04%	4.04%	0.00	16.64	18.24	17.1	18.24								Legumes	42.72	46.83	43.87	46.8					Legumes	45.625		(1.8)	-4%	2.0	1.2	3%		Legumes	389,455,861	17.77		23.10
51										nuts	8.51%	8.51%	0.00	0.45											nuts	1.16								nuts										389,455,861
52
53									Europe	Startch Veg	18.22%	10.23%	-0.08	152.05	85.37	152.1	85.37	1169			19.59%	1312.69	16.31%	Europe	Startch Veg	145.33	81.60	145.33	81.6	1,118	1,255	55.9	Europe	Startch Veg	18.25	452.97	127.1	696%	26.4	63.3	347%	Europe	Startch Veg	1,046,254,720	19.09	473.92	24.82	616.09
54										Whole Grains	14.12%	14.12%	0.00	180.75	376.57	180.8	376.57								Whole Grains	172.76	359.92	172.76	359.9					Whole Grains	84.68		88.1	104%	10.2	275.2	325%		Whole Grains	1,046,254,720	88.60		115.18
55										Vegetables	14.44%	14.44%	0.00	163.13	163.13	339.8	339.81								Vegetables	155.92	155.92	324.80	324.8					Vegetables	182.5		142.3	78%	8.8	142.3	78%		Vegetables	1,046,254,720	190.94		248.22
56										Fruit	20.01%	20.01%	0.00	176.68	176.68										Fruit	168.87	168.87							Fruit						-			Fruit	1,046,254,720
57										milk & Dairy	41.37%	42.79%	0.01	347.90	359.87	347.9	359.87								milk & Dairy	332.52	343.96	332.52	344.0					milk & Dairy	91.25		241.3	264%	16.3	252.7	277%		milk & Dairy	1,046,254,720	95.47		124.11
58										read meat	25.54%	25.54%	0.00	54.15	54.15	54.1	54.15								read meat	51.75	51.76	51.75	51.8					read meat	5.11		46.6	913%	30.2	46.6	913%		read meat	1,046,254,720	5.35		6.95
59										Poultry	20.85%	20.85%	0.00	27.94	27.94	62.1	62.08								Poultry	26.71	26.70	59.33	59.3					Poultry	25.55		33.8	132%	11.5	33.8	132%		Poultry	1,046,254,720	26.73		34.75
60										Fish & Seafood	12.79%	12.79%	0.00	19.82	19.82										Fish & Seafood	18.95	18.94							Fish & Seafood						-			Fish & Seafood	1,046,254,720
61										eggs	17.27%	17.27%	0.00	14.32	14.32										eggs	13.68	13.69							eggs						-			eggs	1,046,254,720
62										Legumes	7.66%	7.66%	0.00	31.52	34.84	32.6	34.84								Legumes	30.13	33.30	31.20	33.3					Legumes	45.625		(14.4)	-32%	5.6	(12.3)	-27%		Legumes	1,046,254,720	47.74		62.06
63										nuts	21.20%	21.20%	0.00	1.12											nuts	1.07								nuts										1,046,254,720
64
65									L Am	Startch Veg	6.97%	3.91%	-0.03	58.17	32.66	58.2	32.66	523			8.76%	608.76	9.06%	L Am	Startch Veg	100.10	56.20	100.10	56.2	900	1,048	45.0	L Am	Startch Veg	18.25	452.97	81.8	448%	21.2	38.0	208%	L Am	Startch Veg	581,130,580	10.61	263.23	13.79	342.20
66										Whole Grains	7.62%	7.62%	0.00	97.54	203.22	97.5	203.22								Whole Grains	167.85	349.70	167.85	349.7					Whole Grains	84.68		83.2	98%	9.9	265.0	313%		Whole Grains	581,130,580	49.21		63.97
67										Vegetables	3.54%	3.54%	0.00	40.05	40.05	139.6	139.55								Vegetables	68.92	68.92	240.14	240.1					Vegetables	182.5		57.6	32%	5.6	57.6	32%		Vegetables	581,130,580	106.06		137.87
68										Fruit	11.27%	11.27%	0.00	99.50	99.5										Fruit	171.22	171.22							Fruit						-			Fruit	581,130,580
69										milk & Dairy	14.88%	15.25%	0.00	125.13	128.25	125.1	128.25								milk & Dairy	215.33	220.69	215.33	220.7					milk & Dairy	91.25		124.1	136%	11.7	129.4	142%		milk & Dairy	581,130,580	53.03		68.94
70										read meat	11.86%	11.86%	0.00	25.14	25.14	25.1	25.14								read meat	43.27	43.26	43.27	43.3					read meat	5.11		38.2	747%	27.3	38.2	747%		read meat	581,130,580	2.97		3.86
71										Poultry	19.29%	19.29%	0.00	25.85	25.85	40.8	40.76								Poultry	44.49	44.48	70.14	70.1					Poultry	25.55		44.6	175%	13.2	44.6	175%		Poultry	581,130,580	14.85		19.30
72										Fish & Seafood	4.72%	4.72%	0.00	7.32	7.32										Fish & Seafood	12.59	12.60							Fish & Seafood						-			Fish & Seafood	581,130,580
73										eggs	9.16%	9.16%	0.00	7.59	7.59										eggs	13.06	13.06							eggs						-			eggs	581,130,580
74										Legumes	8.87%	8.87%	0.00	36.48	39.18	36.6	39.18								Legumes	62.77	67.42	63.06	67.4					Legumes	45.625		17.4	38%	6.2	21.8	48%		Legumes	581,130,580	26.51		34.47
75										nuts	3.16%	3.16%	0.00	0.17											nuts	0.29								nuts										581,130,580
76
77									N Am	Startch Veg	5.06%	2.84%	-0.02	42.27	23.73	42.3	23.73	399			6.68%	429.48	5.17%	N Am	Startch Veg	127.51	71.57	127.51	71.6	1,203	1,295	60.2	N Am	Startch Veg	18.25	452.97	109.3	599%	24.5	53.3	292%	N Am	Startch Veg	331,543,147	6.05	150.18	7.87	195.23
78										Whole Grains	3.42%	3.42%	0.00	43.79	91.23	43.8	91.23								Whole Grains	132.08	275.17	132.08	275.2					Whole Grains	84.68		47.4	56%	7.5	190.5	225%		Whole Grains	331,543,147	28.08		36.50
79										Vegetables	3.96%	3.96%	0.00	44.75	44.75	90.9	90.92								Vegetables	134.97	134.97	274.23	274.2					Vegetables	182.5		91.7	50%	7.1	91.7	50%		Vegetables	331,543,147	60.51		78.66
80										Fruit	5.23%	5.23%	0.00	46.17	46.17										Fruit	139.26	139.26							Fruit						-			Fruit	331,543,147
81										milk & Dairy	16.63%	16.67%	0.00	139.84	140.21	139.8	140.21								milk & Dairy	421.77	422.90	421.77	422.9					milk & Dairy	91.25		330.5	362%	19.0	331.7	363%		milk & Dairy	331,543,147	30.25		39.33
82										read meat	11.52%	11.52%	0.00	24.43	24.43	24.4	24.43								read meat	73.68	73.69	73.68	73.7					read meat	5.11		68.6	1342%	36.6	68.6	1342%		read meat	331,543,147	1.69		2.20
83										Poultry	17.70%	17.70%	0.00	23.71	23.71	38.4	38.41								Poultry	71.52	71.51	115.86	115.9					Poultry	25.55		90.3	353%	18.8	90.3	353%		Poultry	331,543,147	8.47		11.01
84										Fish & Seafood	5.64%	5.64%	0.00	8.75	8.75										Fish & Seafood	26.39	26.39							Fish & Seafood						-			Fish & Seafood	331,543,147
85										eggs	7.18%	7.18%	0.00	5.95	5.95										eggs	17.95	17.95							eggs						-			eggs	331,543,147
86										Legumes	4.56%	4.56%	0.00	18.77	20.55	19.2	20.55								Legumes	56.62	61.98	58.02	62.0					Legumes	45.625		12.4	27%	5.2	16.4	36%		Legumes	331,543,147	15.13		19.66
87										nuts	8.80%	8.80%	0.00	0.47											nuts	1.41								nuts										331,543,147
88
89
90
91