Update Equally Distributed Formula

[Pestomania]

Cell V2 has a formula that does an equal distribution but I would like to make it to where I do not have to add it to every January month field.

As you can see in V3, AH3, and so on, I have to paste the distribution formula into the field. I'd like the formula to auto-fill the table based on the value found in the A1:G26 table.

Book4
	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	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS
1	Program	'23	'24	'25	'26	'27	'28								Batch Size							Jan '23	Feb '23	Mar '23	Apr '23	May '23	Jun '23	Jul '23	Aug '23	Sep '23	Oct '23	Nov '23	Dec '23	Jan '24	Feb '24	Mar '24	Apr '24	May '24	Jun '24	Jul '24	Aug '24	Sep '24	Oct '24	Nov '24	Dec '24
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	8	8	4	8	8	4	8	8	4	8	8
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4	0	2	2	0	2	2	0	2	2	0	2	2	0	2	2	2	2	2	2	2	2	2	2	2
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5	10	10	10	10	10	10	10	10	10	10	10	15	0	5	5	5	5	5	0	5	5	5	5	5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6	0	15	0	15	0	15	15	0	15	0	15	15	0	15	0	15	0	15	15	0	15	0	15	15
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7	20	20	20	20	20	20	20	20	20	20	20	30	0	0	10	0	0	10	0	0	10	0	0	10
Sheet1

Cell Formulas
Range	Formula
U2:U26	U2	=UNIQUE(A2:A26)
V1:CO1	V1	=TEXT(DATE("20"&RIGHT(B1,2),SEQUENCE(,12*COUNTIF(A1:G1,"<>'")-12),1),"mmm 'yy")
V2:CO2	V2	=INDEX(LET(z,SUMPRODUCT(($A$2:$A$26=$U2)*($B$1:$G$1=RIGHT(V$1,3))*$B$2:$G$26)/VLOOKUP($U2,$N$2:$O$26,2,FALSE),b,SEQUENCE(1,12*COUNTIF($A$1:$G$1,"<>'")-12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12*COUNTIF($A$1:$G$1,"<>'")-12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*VLOOKUP($U2,$N$2:$O$26,2,FALSE),MOD(SEQUENCE(1,12*COUNTIF($A$1:$G$1,"<>'")-12,0),12)+1)
V3:AS8	V3	=INDEX(LET(z,SUMPRODUCT(($A$2:$A$26=$U3)*($B$1:$G$1=RIGHT(V$1,3))*$B$2:$G$26)/VLOOKUP($U3,$N$2:$O$26,2,FALSE),b,SEQUENCE(1,12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*VLOOKUP($U3,$N$2:$O$26,2,FALSE),MOD(SEQUENCE(1,12,0),12)+1)
Dynamic array formulas.

 

[felixstraube]

How about this?:
One little change i made. The row B1:G1 are actual dates the first of january of each year, formatted to "yyyy".

BatchDistrubutedEqually.xlsx
	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	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO
1	Program	2023	2024	2025	2026	2027	2028								Batch Size							Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25	Apr-25	May-25	Jun-25	Jul-25	Aug-25	Sep-25	Oct-25	Nov-25	Dec-25	Jan-26	Feb-26	Mar-26	Apr-26	May-26	Jun-26	Jul-26	Aug-26	Sep-26	Oct-26	Nov-26	Dec-26	Jan-27	Feb-27	Mar-27	Apr-27	May-27	Jun-27	Jul-27	Aug-27	Sep-27	Oct-27	Nov-27	Dec-27	Jan-28	Feb-28	Mar-28	Apr-28	May-28	Jun-28	Jul-28	Aug-28	Sep-28	Oct-28	Nov-28	Dec-28
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	8	4	4	4	8	4	4	4	8	4	8	8	8	8	8	4	8	8	8	8	8	0	4	4	0	4	4	0	4	4	0	4	4
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	2	2	2	2	2	2	2	2	2	2	2	3
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34	17	34	34	34	34	34	17	34	34	34	34	34	17	34	34	34	34	34	34	34	34	34	34	34	17	17	17	17	17	17	17	17	17	17	17	17	17	17	34	17	17	34	17	17	34	17	17	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4	0	2	2	0	2	2	0	2	2	0	2	2	0	2	2	2	2	2	2	2	2	2	2	2	0	2	2	2	0	2	2	2	0	2	2	2	0	2	0	2	0	2	2	0	2	0	2	2	2	4	4	4	2	4	4	4	2	4	4	4	2	4	4	4	4	4	2	4	4	4	4	4
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5	10	10	10	10	10	10	10	10	10	10	10	15	0	5	5	5	5	5	0	5	5	5	5	5	0	0	0	0	0	5	0	0	0	0	0	5	5	10	5	10	5	10	5	10	5	10	5	10	10	10	10	10	10	10	10	10	10	10	10	15	0	0	0	5	0	0	0	5	0	0	0	5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6	0	15	0	15	0	15	15	0	15	0	15	15	0	15	0	15	0	15	15	0	15	0	15	15	0	0	0	0	0	0	0	0	0	0	0	15	0	15	15	15	15	15	15	15	15	15	15	15	30	30	30	30	30	30	30	30	30	30	30	30	15	15	30	15	15	30	15	15	30	15	15	30
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7	20	20	20	20	20	20	20	20	20	20	20	30	0	0	10	0	0	10	0	0	10	0	0	10	0	10	0	10	0	10	0	10	0	10	0	10	10	10	20	10	10	20	10	10	20	10	10	20	10	10	10	10	10	10	10	10	10	10	10	10	10	20	10	20	10	20	10	20	10	20	10	20
Sheet2

Cell Formulas
Range	Formula
U2:U8	U2	=$A$2:$A$8
V1:CO1	V1	=LET(cd,EDATE($B$1,SEQUENCE(,COUNT(B1:G1)*12,0)), cd)
V2:CO8	V2	=LET( cd,EDATE($B$1,SEQUENCE(,COUNT($B$1:$G$1)*12,0)), m,MONTH(cd), s, BYCOL(cd,LAMBDA(x,FILTER($B2:$G2,YEAR($B$1:$G$1)=YEAR(x)))), b, $O2, v,(INT((s/12*m)/b)-INT((s/12*(m-1))/b))*b, v )
Dynamic array formulas.

 

[Pestomania]

How about this?:
One little change i made. The row B1:G1 are actual dates the first of january of each year, formatted to "yyyy".

BatchDistrubutedEqually.xlsx
	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	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO
1	Program	2023	2024	2025	2026	2027	2028								Batch Size							Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25	Apr-25	May-25	Jun-25	Jul-25	Aug-25	Sep-25	Oct-25	Nov-25	Dec-25	Jan-26	Feb-26	Mar-26	Apr-26	May-26	Jun-26	Jul-26	Aug-26	Sep-26	Oct-26	Nov-26	Dec-26	Jan-27	Feb-27	Mar-27	Apr-27	May-27	Jun-27	Jul-27	Aug-27	Sep-27	Oct-27	Nov-27	Dec-27	Jan-28	Feb-28	Mar-28	Apr-28	May-28	Jun-28	Jul-28	Aug-28	Sep-28	Oct-28	Nov-28	Dec-28
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	8	4	4	4	8	4	4	4	8	4	8	8	8	8	8	4	8	8	8	8	8	0	4	4	0	4	4	0	4	4	0	4	4
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	2	2	2	2	2	2	2	2	2	2	2	3
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34	17	34	34	34	34	34	17	34	34	34	34	34	17	34	34	34	34	34	34	34	34	34	34	34	17	17	17	17	17	17	17	17	17	17	17	17	17	17	34	17	17	34	17	17	34	17	17	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4	0	2	2	0	2	2	0	2	2	0	2	2	0	2	2	2	2	2	2	2	2	2	2	2	0	2	2	2	0	2	2	2	0	2	2	2	0	2	0	2	0	2	2	0	2	0	2	2	2	4	4	4	2	4	4	4	2	4	4	4	2	4	4	4	4	4	2	4	4	4	4	4
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5	10	10	10	10	10	10	10	10	10	10	10	15	0	5	5	5	5	5	0	5	5	5	5	5	0	0	0	0	0	5	0	0	0	0	0	5	5	10	5	10	5	10	5	10	5	10	5	10	10	10	10	10	10	10	10	10	10	10	10	15	0	0	0	5	0	0	0	5	0	0	0	5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6	0	15	0	15	0	15	15	0	15	0	15	15	0	15	0	15	0	15	15	0	15	0	15	15	0	0	0	0	0	0	0	0	0	0	0	15	0	15	15	15	15	15	15	15	15	15	15	15	30	30	30	30	30	30	30	30	30	30	30	30	15	15	30	15	15	30	15	15	30	15	15	30
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7	20	20	20	20	20	20	20	20	20	20	20	30	0	0	10	0	0	10	0	0	10	0	0	10	0	10	0	10	0	10	0	10	0	10	0	10	10	10	20	10	10	20	10	10	20	10	10	20	10	10	10	10	10	10	10	10	10	10	10	10	10	20	10	20	10	20	10	20	10	20	10	20
Sheet2

Cell Formulas
Range	Formula
U2:U8	U2	=$A$2:$A$8
V1:CO1	V1	=LET(cd,EDATE($B$1,SEQUENCE(,COUNT(B1:G1)*12,0)), cd)
V2:CO8	V2	=LET( cd,EDATE($B$1,SEQUENCE(,COUNT($B$1:$G$1)*12,0)), m,MONTH(cd), s, BYCOL(cd,LAMBDA(x,FILTER($B2:$G2,YEAR($B$1:$G$1)=YEAR(x)))), b, $O2, v,(INT((s/12*m)/b)-INT((s/12*(m-1))/b))*b, v )
Dynamic array formulas.

Is there any way to use similar to what I have available? I unfortunately cannot change the date like fields due to ownership over the formatting not being mine.

Here is the "actual" formula that I am trying to coordinate the changes from the above tables (which is an example) to the actual details. I have to maintain some of the automation that certain lookup fields allow me to maintain.

This is hard to explain since I cannot upload the actual file.

=INDEX(LET(z,SUMPRODUCT((Dashboard[Program]='Deliverables Table'!$A2)*(Dashboard[[#Headers],[''23]:[''43]]=RIGHT('Deliverables Table'!B$1,3))*Dashboard[[''23]:[''43]])/VLOOKUP($A2,'Data Tables'!$A$2:$B40,2,FALSE),b,SEQUENCE(1,12),c,z/12*b,d,INT(z/12)*SEQUENCE(1,12,1,0),e,MOD(c,1),f,IF(INDEX(e,b)<INDEX(e,b-1),d+1,d),f)*VLOOKUP($A2,'Data Tables'!$A$2:$B40,2,FALSE),MOD(SEQUENCE(1,12,0),12)+1)

 

[felixstraube]

How about this?:

BatchDistrubutedEqually.xlsx
	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	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO
1	Program	'23	'24	'25	'26	'27	'28								Batch Size							Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25	Apr-25	May-25	Jun-25	Jul-25	Aug-25	Sep-25	Oct-25	Nov-25	Dec-25	Jan-26	Feb-26	Mar-26	Apr-26	May-26	Jun-26	Jul-26	Aug-26	Sep-26	Oct-26	Nov-26	Dec-26	Jan-27	Feb-27	Mar-27	Apr-27	May-27	Jun-27	Jul-27	Aug-27	Sep-27	Oct-27	Nov-27	Dec-27	Jan-28	Feb-28	Mar-28	Apr-28	May-28	Jun-28	Jul-28	Aug-28	Sep-28	Oct-28	Nov-28	Dec-28
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	8	4	4	4	8	4	4	4	8	4	8	8	8	8	8	4	8	8	8	8	8	0	4	4	0	4	4	0	4	4	0	4	4
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	2	2	2	2	2	2	2	2	2	2	2	3
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34	17	34	34	34	34	34	17	34	34	34	34	34	17	34	34	34	34	34	34	34	34	34	34	34	17	17	17	17	17	17	17	17	17	17	17	17	17	17	34	17	17	34	17	17	34	17	17	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4	0	2	2	0	2	2	0	2	2	0	2	2	0	2	2	2	2	2	2	2	2	2	2	2	0	2	2	2	0	2	2	2	0	2	2	2	0	2	0	2	0	2	2	0	2	0	2	2	2	4	4	4	2	4	4	4	2	4	4	4	2	4	4	4	4	4	2	4	4	4	4	4
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5	10	10	10	10	10	10	10	10	10	10	10	15	0	5	5	5	5	5	0	5	5	5	5	5	0	0	0	0	0	5	0	0	0	0	0	5	5	10	5	10	5	10	5	10	5	10	5	10	10	10	10	10	10	10	10	10	10	10	10	15	0	0	0	5	0	0	0	5	0	0	0	5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6	0	15	0	15	0	15	15	0	15	0	15	15	0	15	0	15	0	15	15	0	15	0	15	15	0	0	0	0	0	0	0	0	0	0	0	15	0	15	15	15	15	15	15	15	15	15	15	15	30	30	30	30	30	30	30	30	30	30	30	30	15	15	30	15	15	30	15	15	30	15	15	30
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7	20	20	20	20	20	20	20	20	20	20	20	30	0	0	10	0	0	10	0	0	10	0	0	10	0	10	0	10	0	10	0	10	0	10	0	10	10	10	20	10	10	20	10	10	20	10	10	20	10	10	10	10	10	10	10	10	10	10	10	10	10	20	10	20	10	20	10	20	10	20	10	20
Sheet2

Cell Formulas
Range	Formula
U2:U8	U2	=$A$2:$A$8
V1:CO1	V1	=LET(cd,EDATE(DATE(SUBSTITUTE($B$1,"'","")+2000,1,1),SEQUENCE(,COUNTA($B$1:$G$1)*12,0)), cd)
V2:CO8	V2	=LET( y, DATE(SUBSTITUTE($B$1:$G$1,"'","")+2000,1,1), cd,EDATE(DATE(SUBSTITUTE($B$1,"'","")+2000,1,1),SEQUENCE(,COUNTA($B$1:$G$1)*12,0)), m,MONTH(cd), s, BYCOL(cd,LAMBDA(x,FILTER($B2:$G2,YEAR(y)=YEAR(x)))), b, $O2, v,(INT((s/12*m)/b)-INT((s/12*(m-1))/b))*b, v )
Dynamic array formulas.

 

[Pestomania]

This works great!

A few things I am still trying to act right:

This $B$1:$G$1 area is a "named" field which is called Dashboard[[Headers]] in the actual file. But the actual table has these headers:

Program

'23

'24

'25

'26

'27

'28

Is there a way to make $B$1:$G$1 be a callout to the headers but disregard program? I am trying to make this as "automated" as possible so when I add columns to the table, the system keeps going wihtout interaction.

The other things I am struggling with:

$B2:$G2 is actually Dashboard[#All] or Dashboard[[''23]:[''43]] (this still limits it to 2043, so if I add 2044, nothing happens) on the real table, but when I do that, it errors out.

$O2 is now the vlookup you see below.

 =LET(y, DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]:[''43]],"'","")+2000,1,1),cd,EDATE(DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]],"'","")+2000,1,1),SEQUENCE(,COUNTA(Dashboard[[#Headers],[''23]:[''43]])*12,0)),m,MONTH(cd),s, BYCOL(cd,LAMBDA(x,FILTER(Dashboard!$C$3:$W$3,YEAR(y)=YEAR(x)))),b, VLOOKUP($A2,'Data Tables'!A:B,2,FALSE),v,(INT((s/12*m)/b)-INT((s/12*(m-1))/b))*b,v)

 

[felixstraube]

Maybe you can share the actual file (upload it to a cloud storage) and I'll have a look.

 

[Pestomania]

Maybe you can share the actual file (upload it to a cloud storage) and I'll have a look.

Hi, unfortunately I cannot because the file has proprietary information. I will try and figure out what is going on later today and see if I can finagle an edit.

Thank you so much for your help!

 

[felixstraube]

Ok if your table is named Dashboard (A1:G8) then how about this?:
The only thing that is not pulled from that table is the batch size from column O. Is that part of that table as well?

BatchDistrubutedEqually.xlsx
	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	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO
1	Program	'23	'24	'25	'26	'27	'28								Batch Size							Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25	Apr-25	May-25	Jun-25	Jul-25	Aug-25	Sep-25	Oct-25	Nov-25	Dec-25	Jan-26	Feb-26	Mar-26	Apr-26	May-26	Jun-26	Jul-26	Aug-26	Sep-26	Oct-26	Nov-26	Dec-26	Jan-27	Feb-27	Mar-27	Apr-27	May-27	Jun-27	Jul-27	Aug-27	Sep-27	Oct-27	Nov-27	Dec-27	Jan-28	Feb-28	Mar-28	Apr-28	May-28	Jun-28	Jul-28	Aug-28	Sep-28	Oct-28	Nov-28	Dec-28
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	8	4	4	4	8	4	4	4	8	4	8	8	8	8	8	4	8	8	8	8	8	0	4	4	0	4	4	0	4	4	0	4	4
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	2	2	2	2	2	2	2	2	2	2	2	3
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34	17	34	34	34	34	34	17	34	34	34	34	34	17	34	34	34	34	34	34	34	34	34	34	34	17	17	17	17	17	17	17	17	17	17	17	17	17	17	34	17	17	34	17	17	34	17	17	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4	0	2	2	0	2	2	0	2	2	0	2	2	0	2	2	2	2	2	2	2	2	2	2	2	0	2	2	2	0	2	2	2	0	2	2	2	0	2	0	2	0	2	2	0	2	0	2	2	2	4	4	4	2	4	4	4	2	4	4	4	2	4	4	4	4	4	2	4	4	4	4	4
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5	10	10	10	10	10	10	10	10	10	10	10	15	0	5	5	5	5	5	0	5	5	5	5	5	0	0	0	0	0	5	0	0	0	0	0	5	5	10	5	10	5	10	5	10	5	10	5	10	10	10	10	10	10	10	10	10	10	10	10	15	0	0	0	5	0	0	0	5	0	0	0	5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6	0	15	0	15	0	15	15	0	15	0	15	15	0	15	0	15	0	15	15	0	15	0	15	15	0	0	0	0	0	0	0	0	0	0	0	15	0	15	15	15	15	15	15	15	15	15	15	15	30	30	30	30	30	30	30	30	30	30	30	30	15	15	30	15	15	30	15	15	30	15	15	30
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7	20	20	20	20	20	20	20	20	20	20	20	30	0	0	10	0	0	10	0	0	10	0	0	10	0	10	0	10	0	10	0	10	0	10	0	10	10	10	20	10	10	20	10	10	20	10	10	20	10	10	10	10	10	10	10	10	10	10	10	10	10	20	10	20	10	20	10	20	10	20	10	20
Sheet2 (2)

Cell Formulas
Range	Formula
U2:U8	U2	=Dashboard[Program]
V1:CO1	V1	=LET(cd,EDATE(DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]],"'","")+2000,1,1),SEQUENCE(,COUNTA(Dashboard[[#Headers],[''23]:[''28]])*12,0)), cd )
V2:CO8	V2	=LET( y, DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]:[''28]],"'","")+2000,1,1), cd,EDATE(DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]],"'","")+2000,1,1),SEQUENCE(,COUNTA(Dashboard[[#Headers],[''23]:[''28]])*12,0)), m,MONTH(cd), s, BYCOL(cd,LAMBDA(x,FILTER(Dashboard[@[''23]:[''28]],YEAR(y)=YEAR(x)))), b, $O2, v,(INT((s/12*m)/b)-INT((s/12*(m-1))/b))*b, v )
Dynamic array formulas.

 

[Pestomania]

Ok if your table is named Dashboard (A1:G8) then how about this?:
The only thing that is not pulled from that table is the batch size from column O. Is that part of that table as well?

BatchDistrubutedEqually.xlsx
	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	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO
1	Program	'23	'24	'25	'26	'27	'28								Batch Size							Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25	Apr-25	May-25	Jun-25	Jul-25	Aug-25	Sep-25	Oct-25	Nov-25	Dec-25	Jan-26	Feb-26	Mar-26	Apr-26	May-26	Jun-26	Jul-26	Aug-26	Sep-26	Oct-26	Nov-26	Dec-26	Jan-27	Feb-27	Mar-27	Apr-27	May-27	Jun-27	Jul-27	Aug-27	Sep-27	Oct-27	Nov-27	Dec-27	Jan-28	Feb-28	Mar-28	Apr-28	May-28	Jun-28	Jul-28	Aug-28	Sep-28	Oct-28	Nov-28	Dec-28
2	Program 1	80	52	52	60	88	32							Program 1	4						Program 1	4	8	8	4	8	8	4	8	8	4	8	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	4	4	4	4	4	4	4	4	8	4	4	4	8	4	4	4	8	4	4	4	8	4	8	8	8	8	8	4	8	8	8	8	8	0	4	4	0	4	4	0	4	4	0	4	4
3	Program 2	16	20	20	1	3	25							Program 2	1						Program 2	1	1	2	1	1	2	1	1	2	1	1	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	1	2	2	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	2	2	2	2	2	2	2	2	2	2	2	3
4	Program 3	289	238	374	391	204	272							Program 3	17						Program 3	17	17	34	17	34	17	17	34	17	34	17	34	17	17	17	17	17	34	17	17	17	17	17	34	17	34	34	34	34	34	17	34	34	34	34	34	17	34	34	34	34	34	34	34	34	34	34	34	17	17	17	17	17	17	17	17	17	17	17	17	17	17	34	17	17	34	17	17	34	17	17	34
5	Program 4	16	22	18	14	42	44							Program 4	2						Program 4	0	2	2	0	2	2	0	2	2	0	2	2	0	2	2	2	2	2	2	2	2	2	2	2	0	2	2	2	0	2	2	2	0	2	2	2	0	2	0	2	0	2	2	0	2	0	2	2	2	4	4	4	2	4	4	4	2	4	4	4	2	4	4	4	4	4	2	4	4	4	4	4
6	Program 5	125	50	10	90	125	15							Program 5	5						Program 5	10	10	10	10	10	10	10	10	10	10	10	15	0	5	5	5	5	5	0	5	5	5	5	5	0	0	0	0	0	5	0	0	0	0	0	5	5	10	5	10	5	10	5	10	5	10	5	10	10	10	10	10	10	10	10	10	10	10	10	15	0	0	0	5	0	0	0	5	0	0	0	5
7	Program 6	105	105	15	165	360	240							Program 6	15						Program 6	0	15	0	15	0	15	15	0	15	0	15	15	0	15	0	15	0	15	15	0	15	0	15	15	0	0	0	0	0	0	0	0	0	0	0	15	0	15	15	15	15	15	15	15	15	15	15	15	30	30	30	30	30	30	30	30	30	30	30	30	15	15	30	15	15	30	15	15	30	15	15	30
8	Program 7	250	40	60	160	120	180							Program 7	10						Program 7	20	20	20	20	20	20	20	20	20	20	20	30	0	0	10	0	0	10	0	0	10	0	0	10	0	10	0	10	0	10	0	10	0	10	0	10	10	10	20	10	10	20	10	10	20	10	10	20	10	10	10	10	10	10	10	10	10	10	10	10	10	20	10	20	10	20	10	20	10	20	10	20
Sheet2 (2)

Cell Formulas
Range	Formula
U2:U8	U2	=Dashboard[Program]
V1:CO1	V1	=LET(cd,EDATE(DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]],"'","")+2000,1,1),SEQUENCE(,COUNTA(Dashboard[[#Headers],[''23]:[''28]])*12,0)), cd )
V2:CO8	V2	=LET( y, DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]:[''28]],"'","")+2000,1,1), cd,EDATE(DATE(SUBSTITUTE(Dashboard[[#Headers],[''23]],"'","")+2000,1,1),SEQUENCE(,COUNTA(Dashboard[[#Headers],[''23]:[''28]])*12,0)), m,MONTH(cd), s, BYCOL(cd,LAMBDA(x,FILTER(Dashboard[@[''23]:[''28]],YEAR(y)=YEAR(x)))), b, $O2, v,(INT((s/12*m)/b)-INT((s/12*(m-1))/b))*b, v )
Dynamic array formulas.

Hi, that data is unfortunately not able to be a table since I use a unique formula and when I go to table, it creates a #SPill error.

But that data is currently in the following location: 'Data Tables'!A:B

 

[felixstraube]

Where do you get a spill error?
Can you maybe upload the file without your data or with random sample data?
Trying to solve it like this is a bit difficult.