Example age of product.xlsx

	A	B	C	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1					4							5
2
3
4
5				23-jan	24-jan	25-jan	26-jan	27-jan	28-jan	29-jan	30-jan	31-jan	1-feb	2-feb	3-feb	4-feb	5-feb	6-feb
6				Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
7	Product 1		Total Production		1000,00	1000,00	1000,00	2000,00	3000,00	400,00	0,00	1200,00	1400,00	1500,00	1600,00	1800,00	200,00	0,00
8	Expiration in days	3	Stock	600,00	600,00	2400,00	8300,00	12300,00	11300,00	6500,00	6200,00	6200,00	7300,00	7900,00	7000,00	10000,00	8200,00	8200,00
9			Required	0,00	400,00	0,00	0,00	0,00	0,00	0,00	0,00	0,00	0,00	0,00	0,00	0,00	0,00	0,00
10			Age of stock
11		Manual correction							-2300
12		Grower 1	Product specification											600
13		Grower 2	Product specification		600	900
14		Grower 3	Product specification				3000	400	200			200
15		Grower 4	Product specification			2000						500			600
16		Grower 5	Product specification		2000		2000			100
17		Grower 6	Product specification					600				600			4000		200
18		Grower 7	Product specification									1000	1000
19		Grower 8	Product specification			4000			300
20		Grower 9	Product specification		200								1000
21		Grower 10	Product specification
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