dumb data.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	product code	stock	customer name	date	ORDER				product code	stock	customer name	date
2	109	23	FG	2/15/2022	89				123	150	DUMB	1/10/2022
3	109	12	KL	2/16/2022	6				124	50	DUMB	1/2/2022
4	123	34	AB	1/1/2022	1				123	76	DUMB	1/3/2022
5	123	77	DE	1/3/2022	8				555	48	DUMB	2/3/2022
6	124	56	CD	1/2/2022	2				888	24	DUMB	2/15/2022
7	124	120	KL	2/19/2022	67
8	555	99	AB	2/13/2022	34
9	566	78	AS	2/18/2022	22
10	567	57	AB	2/17/2022	5
11	888	35	FG	2/14/2022	6
12
13	THESE ARE THE PRODUCTS STOCK TABLE(ONLY FOR REAL CUSTOMER)								THESE ARE THE PRODUCTS STOCK TABLE(ONLY FOR DUMB CUSTOMER)
14
15
16	SAMPLE OUTPUT:
17
18			january			february
19	product	customer	beginning	order	ending	beginning	order	ending
20	109	FG	0	0	0	23	89	-66
21		KL	0	0	0	12	6	6
22	123	DUMB	150	0	150	139	0	139	in here, E5 İS NEGATİVE VALUE BUT WE HAVE ALSO DUMB STOCK THAT DOES NOT BELONG ANY
23		AB	34	1	33	33	0	33	CUSTOMER(FOR SAME PRODUCT) THAT MEANS ı FULLFILL ORDER FROM DUMB STOCK
24		DE	77	88	-11	0	0	0
25	124	CD	56	2	54	54	0	54
26		DUMB	50	0	50	50	0	50
27		KL	0	0	0	120	67	53
28	555	DUMB	0	0	0	48	0	48
29		AB	0	0	0	78	34	44
30	566	AS	0	0	0	57	22	35
31	567	AB	0	0	0	35	5	30
32	888	FG	0	0	0	35		35
33	888	DUMB	0	0	0	24	0	24
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