Calculation lead concentrations of paints based on Apanpa-Qasim et al. (2016)

	A	B	C	D	F	G	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AJ	AK	AL	AM	AN
1	Calculating the weighted average lead content of new paints based on Table 2 in Apanpa-Qasim et al. (2016),							Calculations: (Scroll to the right to see more)
2								Calculating percentage of samples above thresholds of 90ppm and 600 ppm
3								TOTAL							ONLY OIL-BASED, 0 otherwise							ONLY WATER-BASED, 0 otherwise							CALCULATION OF WEIGHTED AVERAGE CONCENTRATION
4	Countries	Samples	Number of Samples	Average concentration	Percentage of samples with concentrations ≥ 90 ppm	Percentage of samples with concentrations ≥ 600 ppm		Number of samples (if percentage ≥ 90 ppm is available and 0 otherwise)	Number of samples (if percentage ≥ 600 ppm is available and 0 otherwise)	Number of samples ≥ 90 ppm (0 if not available)	Number of samples ≥ 600 ppm (0 if not available)	Total percentage of samples ≥ 90 ppm (equals sample size weighted average of percentage per study)	Total percentage of samples ≥ 600 ppm (equals sample size weighted average of percentage per study)		Number of samples (if percentage ≥ 90 ppm is available and 0 otherwise)	Number of samples (if percentage ≥ 600 ppm is available and 0 otherwise)	Number of samples ≥ 90 ppm (0 if not available)	Number of samples ≥ 600 ppm (0 if not available)	Total percentage of samples ≥ 90 ppm (equals sample size weighted average of percentage per study)	Total percentage of samples ≥ 600 ppm (equals sample size weighted average of percentage per study)		Number of samples (if percentage ≥ 90 ppm is available and 0 otherwise)	Number of samples (if percentage ≥ 600 ppm is available and 0 otherwise)	Number of samples ≥ 90 ppm (0 if not available)	Number of samples ≥ 600 ppm (0 if not available)	Total percentage of samples ≥ 90 ppm (equals sample size weighted average of percentage per study)	Total percentage of samples ≥ 600 ppm (equals sample size weighted average of percentage per study)		Average concentration * number of samples (if average concentration is available, otherwise 0)	Number of samples if average concentration is available, otherwise 0	Sample-size weighted average water-based	Sample-size weighted average oil-based

5	Nigeria	water-based	174	811	100	72		174	174	174	125.28	70.83%	59.29%		0	0	0	0	73.17%	65.00%		174	174	174	125.28	66.09%	51.01%	0	141114	174	953	21613
6	Nigeria	water-based	8	86	5	0		8	8	0.4	0				0	0	0	0				8	8	0.4	0				688	8
7		oil-based	11	45	11	0		11	11	1.21	0				11	11	1.21	0				0	0	0	0				495	11
8	Nigeria	oil-based	25	14500	NA	96		0	25	0	24				0	25	0	24				0	0	0	0				362500	25
9	Cameroon	oil-based	61	NA	66	64		61	61	40.26	39.04				61	61	40.26	39.04				0	0	0	0				0	0
10	Brazil	oil-based	20	5600	35	30		20	20	7	6				20	20	7	6				0	0	0	0				112000	20
11	Sri Lanka	water-based	11	4177	10	10		11	11	1.1	1.1				0	0	0	0				11	11	1.1	1.1				45947	11
12		oil-based	19	25210	68	68		19	19	12.92	12.92				19	19	12.92	12.92				0	0	0	0				478990	19
13	Philippines	water-based	10	11	0	0		10	10	0	0				0	0	0	0				10	10	0	0				110	10
14		oil-based	15	28354	67	60		15	15	10.05	9				15	15	10.05	9				0	0	0	0				425310	15
15	Thailand	water-based	10	3	0	0		10	10	0	0				0	0	0	0				10	10	0	0				30	10
16		oil-based	17	61893	47	47		17	17	7.99	7.99				17	17	7.99	7.99				0	0	0	0				1052181	17
17	Tanzania	water-based	6	22	0	0		6	6	0	0				0	0	0	0				6	6	0	0				132	6
18		oil-based	20	14537	100	95		20	20	20	19				20	20	20	19				0	0	0	0				290740	20
19	South Africa	oil-based	29	19862	65	62		29	29	18.85	17.98				29	29	18.85	17.98				0	0	0	0				575998	29
20	Nigeria	water-based	7	8458	100	100		7	7	7	7				0	0	0	0				7	7	7	7				59206	7
21		oil-based	23	36989.5	100	100		23	23	23	23				23	23	23	23				0	0	0	0				850758.5	23
22	Senegal	water-based	9	5.5	0	0		9	9	0	0				0	0	0	0				9	9	0	0				49.5	9
23		oil-based	21	5866	86	76		21	21	18.06	15.96				21	21	18.06	15.96				0	0	0	0				123186	21
24	Belarus	water-based	8	58	0	0		8	8	0	0				0	0	0	0				8	8	0	0				464	8
25		oil-based	22	5558	82	68		22	22	18.04	14.96				22	22	18.04	14.96				0	0	0	0				122276	22
26	Mexico	water-based	10	6	0	0		10	10	0	0				0	0	0	0				10	10	0	0				60	10
27		oil-based	20	51860	100	100		20	20	20	20				20	20	20	20				0	0	0	0				1037200	20
28	Brazil	water-based	7	10	0	0		7	7	0	0				0	0	0	0				7	7	0	0				70	7
29		oil-based	24	15004	42	37		24	24	10.08	8.88				24	24	10.08	8.88				0	0	0	0				360096	24
30	India	oil-based	22	9411	36	36		22	22	7.92	7.92				22	22	7.92	7.92				0	0	0	0				207042	22
31	India	oil-based	26	16600	42	35		26	26	10.92	9.1				26	26	10.92	9.1				0	0	0	0				431600	26
32	India	oil-based	5	106000	100	100		5	5	5	5				5	5	5	5				0	0	0	0				530000	5
33	India	water-based	38	NA	38	49		38	38	14.44	18.62				0	0	0	0				38	38	14.44	18.62				0	0
34		oil-based	31	NA	84	NA		31	0	26.04	0				31	0	26.04	0				0	0	0	0				0	0
35	India	oil-based	17	NA	100	NA		17	0	17	0				17	0	17	0				0	0	0	0				0	0
36	India	oil-based	148	NA	85	NA		148	0	125.8	0				148	0	125.8	0				0	0	0	0				0	0
37	Armenia	oil-based	26	25000	77	77		26	26	20.02	20.02				26	26	20.02	20.02											650000	26
38	Kazakhstan	oil-based	26	15700	81	77		26	26	21.06	20.02				26	26	21.06	20.02											408200	26
39
40	Total		926				Total	901	730	638.16	432.79			Total	603	432	441.22	280.79			Total	298	298	196.94	152
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100