VehicleInventory.xlsx

	A	B	C	D	E	F
1
2	DISTRICT	PARKING SLOT #	VIN	MAKE	MODEL
3	4TH BN	120	JH4KA3170LC006787	Chevrolet	2.6
4	1ST BN	11	JS1RF16C442100152	Ford 1.1	Type III
5	4TH BN	12	2C4GM68475R667819	Dodge	ORV
6	2ND BN	65	1P4GH44R0RX359386	Chevrolet	2.1
7	2ND BN	12	1P4GH44R0RX359386	Toyota	ORV II
8	3RD BN	1	1GBJ7D1B4BV132373	Ford 1.0	Type III
9	3RD BN	66	JH4KA2640GC004861	Toyota	ORV II
10	2ND BN	41	JH4CC2640NC004693	Toyota	ORV II
11
12	ORIGINAL EXAMPLE
13	ORIGINAL EXAMPLE
14
15	TABLE 0
16		Chevrolet	Toyota	Dodge	Ford 1.0	Ford 1.1 Type III
17	1ST BN	0	0	0	0	1
18	2ND BN	1	2	0	0	0
19	3RD BN	0	1	0	1	0
20	4TH BN	1	0	1	0	0
21
22	NEW EXAPMPLE
23	NEW EXAPMPLE
24
25	TABLE 1
26	TYPES OF FORDS
27		1ST BN	2ND BN	3RD BN	4TH BN
28	1.0	0	0	1	0
29	Type III	1	0	0	0
30
31	TABLE 2
32	OTHER VEHICLES
33		1ST BN	2ND BN	3RD BN	4TH BN
34	Chevrolet	0	1	0	1
35	Toyota	0	2	1	0
36	Dodge	0	0	0	1
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