Cleaner way to do employee ramp-up?

[az1smith]

Hi all,

I am creating a model where employees ramp up productivity over 4 months. The formula I am using is pretty manual. Is there a cleaner way to do this? Maybe a lookup of some sort?

Thank you!

 

[StephenCrump]

Welcome to the Forum!

How about:

	A	B	C	D	E	F	G	H	I	J	K	L
1
2	Ramp			1		1		1		1		1
3	1	0%
4	2	67%		0.0	0.7	0.8	1.7	1.8	2.7	2.8	3.7	3.8
5	3	83%
6	4	100%
7
Sheet1

Cell Formulas
Range	Formula
D4:L4	D4	=LET(ramp,$B3:$B6,r,ROWS(ramp),n,$D2:D2,c,COLUMNS(n),s,SEQUENCE(,c,c,-1),SUMPRODUCT(n,INDEX(ramp,IF(s>r,r,s))))