Share register maintained on FIFO basis

[kssoin]

I have made a worksheet based on another excel file which was prepared by a Thai gentleman.The file by this gentleman is FIFOComplete.xls. The other is my file. In my file FIFO does'nt work after the second entry for out is made.
The Data Table in this file FIFOComplete is in Range R5:Q15 which in my file in range Q5:R57.
This table is created by selecting the respective range and the select what-if analysis>Data table and the selecting only the column input as the total sales ie J3 or K3. In my file this does not work.
I have not been able to find the gremlin so to say.
Perhaps someone in this forum can help me.

I realize cannot post attachments. How can attachments be enabled?
FIFOComplete

											FIFO Cost of Inventory Outward for a002
Inventory Inward and Outward				Total Unit Sold :	1,40,000				From Date :	01-10-2012			Id :	a002
														Data Table
Num	Date	Id	Units Inward	Unit Cost	Units Outward	Units Balance		Unit Sold	Cost of Goods Sold		Num	Date	Units Outward	Total Unit Sold	11,80,000	Cost of Goods Sold	Unit Cost
1	01-10-2012	a001	50,000	10		50,000		0	0		4	2-10-2012	40,000	40,000	4,80,000	4,80,000	12
2	01-10-2012	a002	40,000	12		40,000		40,000	4,80,000		10	5-10-2012	1,00,000	1,40,000	11,80,000	7,00,000	7
3	01-10-2012	a001			20,000	30,000		0	0		#NUM!		0	1,40,000	11,80,000	0	0
4	02-10-2012	a002			40,000	0		0	0		#NUM!		0	1,40,000	11,80,000	0	0
5	03-10-2012	a001	10,000	15	20,000	20,000		0	0		#NUM!		0	1,40,000	11,80,000	0	0
6	04-10-2012	a004	1,00,000	5		1,00,000		0	0		#NUM!		0	1,40,000	11,80,000	0	0
7	05-10-2012	a002	1,00,000	7		1,00,000		1,00,000	7,00,000		#NUM!		0	1,40,000	11,80,000	0	0
8	05-10-2012	a004			70,000	30,000		0	0		#NUM!		0	1,40,000	11,80,000	0	0
9	05-10-2012	a003	50,000	10		50,000		0	0		#NUM!		0	1,40,000	11,80,000	0	0
10	05-10-2012	a002			1,00,000	0		0	0		#NUM!		0	1,40,000	11,80,000	0	0
11	07-10-2012	a001	70,000	10		90,000		0	0		Total		1,40,000	hide these 2 columns	11,80,000
12	07-10-2012	a001			80,000	10,000		0	0
13	09-10-2012	a003			10,000	40,000		0	0
14	10-10-2012	a003			20,000	20,000		0	0
15	11-10-2012	a001			10,000	0		0	0
16	12-10-2012	a001	1,00,000	5		1,00,000		0	0
17	13-10-2012	a001			1,00,000	0		0	0
18	14-10-2012	a001	20,000			20,000		0
19						0		0	0
								1,40,000	11,80,000

<tbody>
</tbody>

kssoinSharesFIFO_Testing.xls

											FIFO Cost of Shares Sold for HDFBAN
								Total units Sold :	90			From Date :	20-11-2009				Share Key :	HDFBAN
															Data Table
Num	Date	Share Id	Shares Bought	Price per share	Shares Outward	Shares balance		Shares Sold	Cost of Shares Sold		Num	Date	Shares Outward		Total Shares Sold	132250.00	Cost of Shares Sold	Price per Share
1	23-12-2009	ICSA	2500	10.00		2500		0	0.00		16	01-06-2018	75	75	75	132250	132250	1763.333
2	10-01-2010	ICSA	5500	15.00	5000	3000		0	0.00		17	07-07-2018	15	90	165	132250	0	0
3	12-01-2016	ICSA	10000	15.00		13000		0	0.00		#NUM!		0	90	255	132250	0	0
4	25-02-2017	ICSA	10000	10.00		23000		0	0.00		#NUM!		0	90	345	132250	0	0
5	28-02-2017	NTPC	1450	132.00		1450		0	0.00		#NUM!		0	90	435	132250	0	0
6	01-04-2017	TATPOW	1	79.00		1		0	0.00		#NUM!		0	90	525	132250	0	0
7	08-06-2017	ICSA			10000	13000		0	0.00		#NUM!		0	90	615	132250	0	0
8	09-06-2017	BAJFI	40	2050.00		40		0	0.00		#NUM!		0	90	705	132250	0	0
9	10-12-2017	SYMLIM	30	1250.00		30		0	0.00		#NUM!		0	90	795	132250	0	0
10	15-12-2017	NATPHA	20	1855.00		20		0	0.00		#NUM!		0	90	885	132250	0	0
11	19-01-2018	BHAFOR	100	111.05		100		0	0.00		#NUM!		0	90	975	132250	0	0
12	25-02-2018	HDFC	100	1750.00		100		0	0.00		#NUM!		0	90	1065	132250	0	0
13	03-03-2018	HDFBAN	50	1500.00		50		50	75000.00		#NUM!		0	90	1155	132250	0	0
14	31-03-2018	HDFBAN	25	1450.00		75		25	36250.00		#NUM!		0	90	1245	132250	0	0
15	01-04-2018	HDFBAN	25	1400.00		100		15	21000.00		#NUM!		0	90	1335	132250	0	0
16	01-06-2018	HDFBAN			75	25		0	0.00		#NUM!		0	90	1425	132250	0	0
17	07-07-2018	HDFBAN			15	10		0	0.00		#NUM!		0	90	1515	132250	0	0
						0		0	0.00		#NUM!		0	90	1605	132250	0	0
						0		0	0.00		#NUM!		0	90	1695	132250	0	0
						0		0	0.00		#NUM!		0	90	1785	132250	0	0
						0		0	0.00		#NUM!		0	90	1875	132250	0	0
						0		0	0.00		#NUM!		0	90	1965	132250	0	0
						0		0	0.00		#NUM!		0	90	2055	132250	0	0
						0		0	0.00		#NUM!		0	90	2145	132250	0	0
						0		0	0.00		#NUM!		0	90	2235	132250	0	0
						0		0	0.00		#NUM!		0	90	2325	132250	0	0
						0		0	0.00		#NUM!		0	90	2415	132250	0	0
						0		0	0.00		#NUM!		0	90	2505	132250	0	0
						0		0	0.00		#NUM!		0	90	2595	132250	0	0
						0		0	0.00		#NUM!		0	90	2685	132250	0	0
						0		0	0.00		#NUM!		0	90	2775	132250	0	0
						0		0	0.00		#NUM!		0	90	2865	132250	0	0
						0		0	0.00		#NUM!		0	90	2955	132250	0	0
						0		0	0.00		#NUM!		0	90	3045	132250	0	0
						0		0	0.00		#NUM!		0	90	3135	132250	0	0
						0		0	0.00		#NUM!		0	90	3225	132250	0	0
						0		0	0.00		#NUM!		0	90	3315	132250	0	0
						0		0	0.00		#NUM!		0	90	3405	132250	0	0
						0		0	0.00		#NUM!		0	90	3495	132250	0	0
						0		0	0.00		#NUM!		0	90	3585	132250	0	0
						0		0	0.00		#NUM!		0	90	3675	132250	0	0
						0		0	0.00		#NUM!		0	90	3765	132250	0	0
						0		0	0.00		#NUM!		0	90	3855	132250	0	0
						0		0	0.00		#NUM!		0	90	3945	132250	0	0
						0		0	0.00		#NUM!		0	90	4035	132250	0	0
						0		0	0.00		#NUM!		0	90	4125	132250	0	0
						0		0	0.00		#NUM!		0	90	4215	132250	0	0
						0		0	0.00		#NUM!		0	90	4305	132250	0	0
						0		0	0.00		#NUM!		0	90	4395	132250	0	0
						0		0	0.00		#NUM!		0	90	4485	132250	0	0
						0		0	0.00		#NUM!		0	90	4575	132250	0	0
						0		0	0.00		#NUM!		0	90	4665	132250	0	0
								90	132250.00				90		To be hidden

<tbody>
</tbody>

I have pasted the cells of both the worksheets.
Regards.