FMFLOCTFULL.xlsx

	A	B	C	D	E	F	G	H	I
1	WHCODE	SHOPNO	PRDCODE	DESCP	UOM	OPBAL	RCPT	SALE	CLBAL
2	013	01011	52316089Z	TEACHER'S HIGHLAND CREAM	1000	212	60	248	24
3	013	01011	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	67	60	65	62
4	013	01011	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	48	36	54	30
5	013	01011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	23	0	23	0
6	021	01022	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	2	0	2	0
7	001	02003	52316089Z	TEACHER'S HIGHLAND CREAM	1000	156	5	158	3
8	001	02003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	97	0	96	1
9	018	02025	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	11	0	6	5
10	011	03001	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	11	0	9	2
11	011	03001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	18	0	6	12
12	011	03001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	7	0	1	6
13	014	03012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	24	24	34	14
14	014	03013	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	10	0	4	6
15	014	03013	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	37	0	24	13
16	008	04003	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	11	0	5	6
17	008	04003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	31	0	16	15
18	008	04012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	48	0	24	24
19	006	05002	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	13	0	8	5
20	006	05015	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	33	0	15	18
21	006	05017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	15	0	12	3
22	006	05020	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	18	0	8	10
23	019	05026	52316089Z	TEACHER'S HIGHLAND CREAM	1000	37	156	76	117
24	019	05026	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	75	0	31	44
25	019	05026	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	44	48	87	5
26	007	06001	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	21	0	13	8
27	007	06002	52316089Z	TEACHER'S HIGHLAND CREAM	1000	12	72	51	33
28	007	06002	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	84	32	52
29	007	06010	52316089Z	TEACHER'S HIGHLAND CREAM	1000	47	0	26	21
30	007	06010	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	18	0	1	17
31	007	06010	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	75	0	6	69
32	007	06012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	11	0	6	5
33	007	06017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	15	0	5	10
34	007	06020	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	32	0	3	29
35	007	06021	52316089Z	TEACHER'S HIGHLAND CREAM	1000	80	0	24	56
36	007	06021	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	81	0	30	51
37	019	06028	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19	0	19	0
38	019	06030	52316089Z	TEACHER'S HIGHLAND CREAM	1000	98	0	0	98
39	019	06030	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	39	0	0	39
40	002	07009	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19	12	9	22
41	002	07012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	3	36	11	28
42	002	07017	52316089Z	TEACHER'S HIGHLAND CREAM	1000	113	144	115	142
43	002	07017	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	65	72	34	103
44	002	07017	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	45	0	17	28
45	002	07017	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	109	132	77	164
46	002	07017	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	115	0	33	82
47	002	07017	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	31	0	24	7
48	002	07017	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	1	0	1	0
49	002	07017	52832091Z	GLENKINCHIE SINGLE MALT SCOTCH	750	2	0	0	2
50	002	07017	54832011Z	GORDON'S LONDON DRY GIN	750	23	0	3	20
51	002	07017	56832021Z	KETEL ONE VODKA	750	14	0	1	13
52	002	07017	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	20	0	2	18
53	002	07024	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	0	12	4	8
54	017	07036	52316089Z	TEACHER'S HIGHLAND CREAM	1000	0	180	70	110
55	017	07036	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	3	0	2	1
56	017	07036	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	51	0	43	8
57	017	07041	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	47	0	7	40
58	002	07047	52316089Z	TEACHER'S HIGHLAND CREAM	1000	33	0	26	7
59	002	07047	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	40	0	13	27
60	017	07051	52316089Z	TEACHER'S HIGHLAND CREAM	1000	11	0	10	1
61	017	07051	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	5	0	1	4
62	017	07051	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	44	0	11	33
63	017	07053	52316089Z	TEACHER'S HIGHLAND CREAM	1000	17	96	18	95
64	017	07053	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	4	0	0	4
65	017	07053	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	38	0	33	5
66	010	08003	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	45	0	36	9
67	010	08003	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	96	0	58	38
68	010	08003	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	36	0	8	28
69	010	08003	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	19	0	10	9
70	010	08003	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	17	0	10	7
71	010	08003	52832101Z	TALISKER SINGLE MALT SCOTCH WH	750	11	0	0	11
72	010	08003	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	3	0	0	3
73	010	08003	54832011Z	GORDON'S LONDON DRY GIN	750	21	0	1	20
74	010	08003	56832021Z	KETEL ONE VODKA	750	6	0	2	4
75	010	08003	59832011Z	BAILEYS THE ORIGINAL IRISH CRE	750	4	0	0	4
76	010	08004	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	9	0	0	9
77	010	08004	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	31	0	29	2
78	010	08005	52316089Z	TEACHER'S HIGHLAND CREAM	1000	118	0	117	1
79	010	08005	52316099Z	JIM BEAM KENTUCKY STRAIGHT BOU	1000	51	0	37	14
80	010	08005	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	7	0	7	0
81	010	08005	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	85	36	75	46
82	010	08011	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	5	0	0	5
83	010	08011	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19	0	4	15
84	010	08012	52316089Z	TEACHER'S HIGHLAND CREAM	1000	26	0	15	11
85	010	08012	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	11	0	1	10
86	010	08012	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	34	24	16	42
87	016	08019	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	1	12	1	12
88	016	08019	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	25	36	17	44
89	010	08028	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	7	0	2	5
90	010	08028	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	59	0	18	41
91	010	08030	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	1	0	0	1
92	010	08031	52316089Z	TEACHER'S HIGHLAND CREAM	1000	35	0	2	33
93	010	08031	52316261Z	GRANT'S BLENDED SCOTCH WHISKY	750	19	0	0	19
94	012	11001	52316089Z	TEACHER'S HIGHLAND CREAM	1000	21	0	21	0
95	012	11001	5231621DZ	GLENFIDDICH SINGLE MALT SCOTCH	700	2	0	0	2
96	012	11001	52832011Z	JOHNNIE WALKER RED LABEL BLEND	750	29	24	19	34
97	012	11001	52832021Z	JOHNNIE WALKER BLACK LABEL BLE	750	6	0	3	3
98	012	11001	52832071Z	J&B RARE BLENDED SCOTCH WHISKY	750	15	24	8	31
99	012	11001	52832121Z	CRAGGANMORE SPEYSIDE SINGLE MA	750	2	0	0	2
100	012	11001	54832011Z	GORDON'S LONDON DRY GIN	750	9	0	0	9