Set Up Recommendations?

[sevize]

The best way that I have found to set up this sheet up is it to have dates going across the header. The issue with that is it makes it difficult to pull into other sheets or Power Bi. I can't think of a good way to set this up with dates in a column. Below is a sample of one product but it would be for well over 50 products that this has to be repeated for. If I switch Column B and the headers then the date will be repeated and I will have to repeat the product in every row. Am I missing something or is this likely the best way for me to do this?

Blue are hand keyed values, everything that is "out" is used in reports else were. "Feed in" not blue comes in from another sheet.

 

[sevize]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	Product Details	Field		2023												2024
2				Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
3		Calculation		23	23	23	23	23	24	24	24	24	24	24	24	24	24	24	24	24	25	25	25	25	25	25	25
4	Product A	Feed In
5		Feed In		0	0	0	0	0	0	37	50	60	50	49	55	93	98	99
6		Feed In		23	23	23	23	23	24	24	24	24	24	24	24	24	24	24	24	24	25	25	25	25	25	25	25
7		Feed In								132	41	30	23	27	46	34	85
8		Feed In								135	86	72	56	28	95	37	16
9		Feed In															2			3			3			6
10		Feed In												4	4
11		Feed In								360	320	315	335	365	387	435	449
12		Feed In								416	286	280	279	282	424	414	413
13		Feed In		9	12	44	54	86	228	178	85	51	18	16	20	12	17	61	75	121	319	249	119	72	25	22	28
14		Out		6	11	36	51	78	193	190	108	60	26	16	19	14	16	50	72	110	270	267	152	84	37	23	27
15		Feed in		19	20	25	20	20	24	15	20	24	20	18	20	19	20	25	20	20	24	15	20	24	20	20	15
16		Out		23	23	23	23	23	24	24	24	24	24	24	24	24	24	24	24	24	25	25	25	25	25	25	25
17		Out		0	0	0	0	0	0	37	50	60	50	49	55	93	98	99	68	68	122	76	102	122	102	102	76
18		Out		0	0	0	0	0	0	37	50	60	50	49	55	93	98	99	120	120	169	106	94	113	94	94	71
19		Out		0	0	0	0	0	0	2	3	3	3	3	3	5	5	4	6	6	7	7	5	5	5	5	5
20		Calculation		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	48	48	57	36	1	2	1	1	1
21		Calculation		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	2	2	2	2	2
22		Calculation		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	189	189	189	189	17	17	17	17	17
23		Calculation		0	0	0	0	0	0	37	50	60	50	49	55	93	98	99	72	72	112	70	93	112	93	93	70
24		Out		0	0	0	0	0	0	169	91	90	73	76	101	127	183	251	273	274	273	73	93	112	93	93	70
25		Calculation		6	18	53	104	183	375	268	150	111	69	44	114	46	31	50	72	113	270	267	348	339	264	199	133
26		Out		0	0	0	0	0	0	169	91	90	69	44	101	46	31	50	72	113	270	73	93	112	93	93	70
27		Out		0	0	0	0	0	0	0	0	0	4	32	0	81	152	201	202	161	3	0	0	0	0	0	0
28		Out		-9	-21	-64	-118	-204	-432	351	326	354	390	425	468	550	615	653	650	601	394	214	188	228	296	367	409
29		Out		-9	-21	-64	-118	-204	-432	351	326	354	390	425	468	550	615	653	698	696	546	403	379	420	489	562	605
30		Calculation		0	0	0	0	0	0	416	286	280	279	282	424	414	413	413	413	416	416	416	419	419	419	425	425
31		Calculation		-9	-21	-64	-118	-204	-432	-65	40	74	111	143	44	136	202	240	237	185	-22	-202	-231	-191	-123	-58	-16
32		Calculation		-9	-21	-64	-118	-204	-432	-65	40	74	111	143	44	136	202	240	285	280	130	-13	-40	1	70	137	180
33		Calculation		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	189	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
P1	P1	=TEXT(WORKDAY(TODAY(),1),"YYYY")
D3:H3	D3	=RIGHT($D$1,2)
I3:T3	I3	=RIGHT($P$1,2)
U3:AA3	U3	=RIGHT($AB$1,2)
D14:AA14	D14	=(D13*0.75)+(C13*0.25)
D16:AA16	D16	=IF(ISBLANK(D5), IF(ISBLANK(D5), IF(D18<1, IF(C18<1, C16,MIN(D$3+1, D6+1)), D6), D6), D6)
D17:AA17	D17	=IF(ISBLANK(D5), SUMIFS($D18:$AY18,$D16:$AY16,D16)/SUMIFS($D15:$AY15,$D16:$AY16,D16)*D15, D5)
D18:AA18	D18	=D23+D20
D19:AA19	D19	=D18/D15
D20:AA20	D20	=IF(ISBLANK(D5), D22/(SUMIFS($D15:$AY15,$D21:$AY21,D21,$D5:$AY5,""))*D15,0)
D21:O21	D21	=IF(SUM($D33:$O33)=0, C21, IF(D22=C22, C21, C21+1))
P21:AA21	P21	=IF(SUM($P33:$AA33)=0, O21, IF(P22=O22, O21, O21+1))
D22:O22	D22	=IF(ISBLANK(D5), IF(MAX(IF($D33:$O33<0, $D33:$O33))=0,E22, IF(E33=MAX(IF($D33:$O33<0, $D33:$O33)), E33, E22)), 0)
P22:AA22	P22	=IF(ISBLANK(P5), IF(SUM($P33:$AA33)=0, Q22, IF(Q33<>0, Q33, Q22)), 0)
D23:AA23	D23	=IF(AND(ISBLANK(D4), ISBLANK(D5)), (SUMIF($D6:$AY6, D6, $D13:$AY13)/SUMIF($D6:$AY6, D6, $D15:$AY15))*D15, SUM(D4:D5))
D24:E24	D24	=IF(ISBLANK(D7), C24-C26, D7)+D23-D4+IF(MONTH(Month)=6, SUM(C4),0)
F24	F24	=IF(ISBLANK(F7), E24-E26, F7)+F23-F4+IF(MONTH(Month)=6, SUM(D4:E4),0)
G24	G24	=IF(ISBLANK(G7), F24-F26, G7)+G23-G4+IF(MONTH(Month)=6, SUM(D4:F4),0)
H24	H24	=IF(ISBLANK(H7), G24-G26, H7)+H23-H4+IF(MONTH(Month)=6, SUM(D4:G4),0)
I24	I24	=IF(ISBLANK(I7), H24-H26, I7)+I23-I4+IF(MONTH(Month)=6, SUM(D4:H4),0)
J24	J24	=IF(ISBLANK(J7), I24-I26, J7)+J23-J4+IF(MONTH(Month)=6, SUM(D4:I4),0)
K24	K24	=IF(ISBLANK(K7), J24-J26, K7)+K23-K4+IF(MONTH(Month)=6, SUM(D4:J4),0)
L24	L24	=IF(ISBLANK(L7), K24-K26, L7)+L23-L4+IF(MONTH(Month)=6, SUM(D4:K4),0)
M24	M24	=IF(ISBLANK(M7), L24-L26, M7)+M23-M4+IF(MONTH(Month)=6, SUM(D4:L4),0)
N24	N24	=IF(ISBLANK(N7), M24-M26, N7)+N23-N4+IF(MONTH(Month)=6, SUM(D4:M4),0)
O24	O24	=IF(ISBLANK(O7), N24-N26, O7)+O23-O4+IF(MONTH(Month)=6, SUM(D4:N4),0)
P24:AA24	P24	=IF(ISBLANK(P7), O24-O26, P7)+P23-P4+IF(MONTH(Month)=6, SUM(D4:O4),0)
D25:AA25	D25	=IF(ISBLANK(D7),D14+(C25-C26), D8+D14-(0.25*C13))+D9+D10
D26:AA26	D26	=MIN(D24,D25)
D27:AA27,D31:AA31	D27	=D24-D26
D28:AA28	D28	=IF(ISBLANK(D7), C28, (D7+D11))-D13+D23
D29:AA29	D29	=IF(ISBLANK(D7), C29, (D7+D11))-D13+D18
D30:AA30	D30	=IF(D12>0,D12,C30+D9+D10)
D32:AA32	D32	=D29-D30
D33:O33	D33	=IF(ISBLANK(D5), (IF(MIN($D31:$O31)>0, IF(MIN($D31:$O31)=D31, -MIN(D31,SUMPRODUCT((COLUMN($D33:$AY33)<COLUMN(D33))*$D23:$AY23*ISBLANK($D5:$AY5))), 0), ABS(MIN(D30*0.1+D31,0)))), 0)
P33:AA33	P33	=IF(AND(ISBLANK(P5), MIN($P31:$AA31)=P31), (IF(MIN($P31:$AA31)+SUM($D33:$O33)>0, -MIN(P31,SUMPRODUCT((COLUMN($D33:$AY33)<COLUMN(P33))*$D23:$AY23*ISBLANK($D5:$AY5)))-SUM($D33:$O33), ABS(MIN(P30*0.1+P31+SUM($D33:$O33),0)))), 0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D31:AN32	Other Type	Color scale		NO
D2:AN3	Expression	=Month=EOMONTH(TODAY(),-1)+1	text	NO