Appendix Thread. 3 *

[DocAElstein]

For http://www.excelfox.com/forum/showth...ll=1#post11436

Before:
_____ Workbook: ap.xls ( Using Excel 2007 32 bit )

Row\Col	B	C	D	E	Z
1	AccountId	EntityName	Exchg-Seg	Symbol
2	WC5758		NSE	TCS
3	WC5758		NSE	SRTRANSFIN
4	WC5758		NSE	MARICO
5	WC5758		NSE	M&MFIN
6	WC5758		NSE	20MICRONS
7	WC5758		NSE	CONCOR
8	WC5758		NSE	COALINDIA
9	WC5758		NSE	BOSCHLTD
10	WC5758		NSE	BERGEPAINT
11	WC5758		NSE	5PAISA
12	WC5758		NSE	TATAELXSI
13	WC5758		NSE	HINDPETRO
14	WC5758		NSE	DISHTV

Worksheet: ap-Sheet1

_____ Workbook: LEVERAGE1.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F
1	Stock Name			pro times	ultimate times
2	20MICRONS	EQ	INE144J01027	19	26	36.35
3	TCS	EQ	INE253B01015	19	26	13.5
4	3IINFOTECH	EQ	INE748C01020	29	39	2.05
5	3MINDIA	EQ	INE470A01017	48	64	21299
6	5PAISA	EQ	INE618L01018	31	41	129.5
7	63MOONS	EQ	INE111B01023	30	40	99.15
8	8KMILES	EQ	INE650K01021	27	36	56.5

Worksheet: Sheet1

After:
_____ Workbook: ap.xls ( Using Excel 2007 32 bit )

Row\Col	B	C	D	E	Z
1	AccountId	EntityName	Exchg-Seg	Symbol
2	WC5758		NSE	TCS	25.823112
3	WC5758		NSE	SRTRANSFIN
4	WC5758		NSE	MARICO
5	WC5758		NSE	M&MFIN
6	WC5758		NSE	20MICRONS	25.823112
7	WC5758		NSE	CONCOR
8	WC5758		NSE	COALINDIA
9	WC5758		NSE	BOSCHLTD
10	WC5758		NSE	BERGEPAINT
11	WC5758		NSE	5PAISA	40.795512
12	WC5758		NSE	TATAELXSI
13	WC5758		NSE	HINDPETRO
14	WC5758		NSE	DISHTV

Worksheet: ap-Sheet1