Glide Path Calculation

[Seafox]

I'm looking for some help on making a recover calculation for a glide path. Example being I have 12 weeks to get 120 items out by. if I miss a week I need the calculation to give me the run rate for the remaining weeks in in each of the remaining weeks. as per the basic typed example below.

Thanks in advance

1	A	B	C	D	E	F	G	H	I	J	K	L	M	N
2	01/01/2024	08/01/2024	15/01/2024	22/01/2024	29/01/2024	05/02/2024	12/02/2024	19/02/2024	26/02/2024	04/03/2024	11/03/2024	18/03/2024	Totals
3	RQD	10	10	10	10	10	10	10	10	10	10	10	10	120
4	Actual	0	0	0
5	Recovery Glide	12	12	12	12	12	12	12	12	12	12	120

 

[Seafox]

Can anyone help with the formula required for row 5 in each column to work out what the run rate needs to be to hit the target?

 

[RoryA]

A couple of questions:
1. Why is row 5 only 10 numbers + a total?
2. What would row 5 look like if C4 was, say, 25?