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?

 

[RobP]

Rory's questions are valid for a full understanding of your sheet.

In the absence of anything further, this kind of format might be close to what you want. It does rely on someone adding a "0" if indeed no samples were made that week.
Also, I could not find a way to easily "Integerise" (is that even a word ? ) the remainders. I mean add "1" extra to the first value in G (so would be 14), and decrease the rest (=13) until col N.

Maybe someone has another idea. Copy formula across the row.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1			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
2		RQD	10	10	10	10	10	10	10	10	10	10	10	10	120
3		Actual	10	0	0	5
4		Recovery Glide					13.125	13.125	13.125	13.125	13.125	13.125	13.125	13.125	120
5
Sheet1

Cell Formulas
Range	Formula
C4:N4	C4	=IF(C3="",($O2-SUM($C3:C3))/(12-COUNT($C3:C3)),"")
O4	O4	=SUM(C3:N4)