Pivot table, offset, days stock coverage

[#1]

HI there,

does anybody know how to solve the problem below?

Desired Result 1: is the consumption of actual stock of code A. At a given time 24/11 you start with a stock of 1000 and I would like to know how the stock will evolve by fulfilling orders.

Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.

A	B	C	D	E	F	G	H	I
2	id_code_dwlog	dt_date_order	24/11/2010	25/11/2010	26/11/2010	29/11/2010	30/11/2010	01/12/2010	02/12/2010
3	CODE A	STOCK	1.000	1.000	1.000	1.000	1.000	1.000	1.000
4	CODE A	ORDERS	200	250	200	250	200	200	200
5	CODE A	STOCK-ORDERS	800	600	690	810	810	630	600
6	CODE A	DESIRED RESULT 1	800	550	350	100	-100	-300	-500
7		EXCEL FORMULA	=D3-D4	=D6-E4	=E6-F4	=F6-G4	=G6-H4	=H6-I4	ETC... ETC….
		DESIRED RESULT 2	4	3	2	1

Thank in advance for any ideas or help.

Axo

[#2]

Would be easier if you could upload an excel with the date & the desired results

[#3]

added,

thank you for your time