16.1 27. Data-Validation-Lecture - Solved.xlsx.xlsx

	B	C	D	E	F	G	H	I	L
1	Data validation
2
3	Year	Type	Product group	Producer	Code	Volume	Cost per unit	Price per unit
4	2011	Convenience stores	Meat	Lieken	\|13/12/38\|	420	6.0	8.4	Meat
5	2011	Convenience stores	Coffee	Lieken	\|13/13/98\|	480	6.1	7.4	Coffee
6	2011	Convenience stores	Meat	Lieken	\|13/13/99\|	528	5.4	7.6
7	2011	Convenience stores		Lieken	\|13/01/01\|	4836	0.74	0.96
8	2011	Convenience stores		Lieken	\|13/01/01a\|	5928	0.95	0.99
9	2011	Convenience stores		Lieken	\|13/01/02\|	5712	0.89	0.97
10	2011	Convenience stores		Lieken	\|13/01/03\|	4872	0.62	0.9
11	2011	Convenience stores		Lieken	\|13/01/04\|	6228	0.65	1.07
12	2011	Convenience stores	No error	Lieken	\|13/01/05\|	9588	0.92	1.01
13	2011	Convenience stores		Lieken	\|13/01/06\|	7836	1.19	0.96
14	2011	Convenience stores		Lieken	\|13/01/07\|	7560	1.02	1.09
15	2011	Convenience stores		Lieken	\|13/01/30\|	8556	0.99	1.1
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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