S-Curve (Profiling Cost)

See if the workbook at https://app.box.com/shared/ipkvdyc4bt helps

I don't understand conceptually what you're trying to do.

You enter actual cost, and want to regenerate the spend profile assuming that the whole thing scales by (actual to date)/(estimated to date)? That sounds pretty sketchy.

Pondering ...

	B	C	D	E	F	G
2	A	0.5				https://www.excelforum.com/excel-for...ling-cost.html
3	B	0
4	perBeg	1
5	perEnd	12
6	Budget	$ 100,000.00	Factor	1.01410628		E6: =(Budget - SUM(D11:D22)) / SUMIF(D11:D22, "", C11:C22)
7
8	Total	$ 100,000.00	$ 18,000.00	$ 100,000.00		C8 and across: =SUM(C10:C22)
9
10	Period	Plan	Actual	Replan
11	1	$ 2,940.14	$ 2,000.00	$ 2,000.00		C11 and down: =Budget * BetaPer(A, B, perBeg, perEnd, Period)
12	2	$ 7,039.29	$ 7,000.00	$ 7,000.00		(Note: The Plan values can be anything; they need not use the Beta polynomial.)
13	3	$ 9,161.20	$ 9,000.00	$ 9,000.00		D11 and down: Input
14	4	$ 10,077.48		$ 10,219.64		E11 and down: =IF(ISNUMBER(Actual), Actual, Factor * Plan)
15	5	$ 10,366.83		$ 10,513.07
16	6	$ 10,415.06		$ 10,561.98
17	7	$ 10,415.06		$ 10,561.98
18	8	$ 10,366.83		$ 10,513.07
19	9	$ 10,077.48		$ 10,219.64
20	10	$ 9,161.20		$ 9,290.43
21	11	$ 7,039.29		$ 7,138.59
22	12	$ 2,940.14		$ 2,981.61