Learn excel few tips

345 268 111 2365 x 2006-07 Ad income Business income other income 2007-08 y-1 y1 0 2365 2365 390 13% 16% 2755 313 17% 13% 3068 117 5% 5% 3185 3185 35% 135% 390 2365 Source: NDTV Annual Report 2007-08 p.43 2006-07 Ad income 3185 390 313 117 Ad income Business income other income 2007-08 Trend in Revenue Composition Category 2007-08 2008-09 2008-10 Subscription 59 61 64 Advt 15 11 14 Software 6 7 5 Syndication 8 9 9 Others 12 12 8 Trend in Revenue Co 12 8 6 15 59 2007-08 Subscription Note: Chart type no border lines plot area and chart area same background=1 colour, 1 Trend in Revenue Composition 12 9 7 11 8 9 5 14 61 64 2008-09 Subscription Advt Software Syndication Others 2008-10 ea same background=1 colour, 100% light Date 9/1/2009 9/1/2009 9/1/2009 Scrip Name ICICIBANK JINDAL STEEL L&T Market Buy/Sell Qty Rate BUY 5 462 BUY 2 933 BUY 2 705 BUY BUY BUY BUY BUY SELL SELL SELL BUY BUY BUY SELL SELL BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY Market Net Service Value Rate Brokerage Tax 2,310.00 464.31 11.55 1.44 1,866.00 937.67 9.34 1.16 1,410.00 708.53 7.06 0.88 5.58 6.00 1.96 7.15 3.90 6.67 10.86 1.12 6.85 5.18 1.86 2.25 7.75 6.68 1.86 7.03 3.35 2.07 6.99 4.57 2.09 5.10 3.34 6.63 4.56 0.69 0.75 0.24 0.89 0.49 0.83 1.35 0.14 0.85 0.64 0.23 0.28 0.96 0.83 0.23 0.88 0.42 0.26 0.87 0.57 0.26 0.63 0.42 0.83 0.57 20/1/2009 STATE BANK O 20/1/2009 2/2/2009 2/2/2009 2/2/2009 4/2/2009 9/2/2009 RELIANCE IND ICICIBANK HOUSING DEVE ICICIBANK RELIANCE IND JINDAL STEEL 1 1115.6 1,115.60 1121.18 1 1 1 2 1 2 1 1 1 2 5 1 1 2 1 1 1 1 1 1 1 1 1 1 1199 392 1430 390 1333 1085 223.5 1,199.00 1205 392.00 393.96 1,430.00 1437.15 780.00 391.95 1,333.00 1326.33 2,170.00 1079.57 223.50 222.38 10/2/2009 JINDAL VIJAY 11/2/2009 GRASIM INDUS 12/2/2009 JINDAL STEEL 12/2/2009 TATASTL 13/2/2009 STEEL AUTHOR 13/2/2009 HOUSING DEVE 16/2/2009 RELIANCE IND 16/2/2009 TATASTL 16/2/2009 BHEL 16/2/2009 L&T 16/2/2009 ICICIBANK 16/2/2009 BHEL 16/2/2009 HDFCBANK 16/2/2009 AXISBANK 16/2/2009 JINDAL STEEL 16/2/2009 L&T 16/2/2009 RELIANCE IND 16/2/2009 HDFCBANK 1370 1,370.00 1376.85 1035 1,035.00 1040.18 186 90.5 372.00 452.50 186.93 90.05 1549 1,549.00 1541.25 1335 1,335.00 1341.68 185 370.00 185.93 1405 1,405.00 1412.03 669 413 669.00 413.00 672.35 415.07 1398 1,398.00 1404.99 913.5 418 913.50 418.00 918.07 420.09 1025.1 670.34 1020 1,020.00 667 667.00 1326 1,326.00 1332.63 911.5 911.50 916.06 16/2/2009 ICICIBANK 17/2/2009 HDFCBANK 17/2/2009 TATASTL 17/2/2009 JINDAL STEEL 17/2/2009 STATE BANK O 17/2/2009 ICICIBANK 18/2/2009 ICICIBANK 18/2/2009 STATE BANK O 20/2/2009 ICICIBANK 20/2/2009 L&T 20/2/2009 STATE BANK O 24/2/2009 RELIANCE IND 24/2/2009 HOUSING DEVE 24/2/2009 AXISBANK 25/2/2009 HOUSING DEVE 27/2/2009 L&T 27/2/2009 ICICIBANK 27/2/2009 STATE BANK O 27/2/2009 3/3/2009 3/3/2009 3/3/2009 3/3/2009 3/3/2009 4/3/2009 4/3/2009 5/3/2009 5/3/2009 5/3/2009 5/3/2009 5/3/2009 5/3/2009 5/3/2009 RANBAXY STATE BANK O L&T ICICIBANK HOUSING DEVE HDFCBANK ICICIBANK STATE BANK O STATE BANK O RELIANCE IND ICICIBANK ICICIBANK ICICIBANK AXISBANK RELIANCE IND BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY BUY 1 2 2 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 407 407.00 409.04 879.38 175.88 969.83 1105.5 382.91 370.85 2.04 8.76 1.76 4.83 5.50 1.91 1.85 5.33 3.46 3.13 5.23 6.10 6.45 1.80 6.38 3.03 1.63 5.12 1.62 4.98 2.91 3.02 6.05 4.15 1.44 4.81 4.76 5.96 1.40 1.39 1.39 1.58 5.73 0.25 1.09 0.22 0.60 0.68 0.24 0.23 0.66 0.43 0.39 0.65 0.76 0.80 0.22 0.66 0.31 0.17 0.53 0.17 0.52 0.30 0.31 0.63 0.43 0.15 0.50 0.49 0.62 0.15 0.14 0.14 0.16 0.59 875 1,750.00 175 965 350.00 965.00 1100 1,100.00 381 369 381.00 369.00 1065 1,065.00 1070.33 346 625 692.00 625.00 347.73 628.13 1045 1,045.00 1050.23 1220 1,220.00 1226.1 1290 1,290.00 1296.45 360 360.00 361.8 1275 1,275.00 1281.38 605 325 605.00 325.00 608.03 326.63 1024 1,024.00 1029.12 2 161.25 322.50 162.06 1 996 996.00 1000.98 1 582 582.00 584.91 2 302 604.00 303.51 1 1210 1,210.00 1216.05 1 830 830.00 834.15 1 287 287.00 288.44 1 962 962.00 966.81 1 951 951.00 955.76 1 1192 1,192.00 1197.96 1 279 279.00 280.4 1 278.5 278.50 279.89 1 278 278.00 279.39 1 316 316.00 317.58 1 1145 1,145.00 1150.73 18/3/2009 HOUSING DEVE 18/3/2009 JINDAL STEEL 18/3/2009 JINDAL STEEL 18/3/2009 JINDAL STEEL 18/3/2009 RELIANCE IND 23/3/2009 HOUSING DEVE 23/3/2009 GRASIM INDUS 23/3/2009 HOUSING DEVE 23/3/2009 RELIANCE IND 23/3/2009 RELIANCE IND 23/3/2009 RELIANCE IND 24/3/2009 TATASTL 25/3/2009 RELIANCE IND 25/3/2009 HDFCBANK 26/3/2009 AXISBANK 26/3/2009 BHEL 27/3/2009 TATASTL 27/3/2009 HDFCBANK 27/3/2009 TATASTL 27/3/2009 TATASTL 27/3/2009 AXISBANK 27/3/2009 TATASTL 27/3/2009 6/4/2009 6/4/2009 6/4/2009 TATASTL L&T TATASTL L&T SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1392 1,392.00 1385.04 1138 1,138.00 1132.31 1145 1,145.00 1139.27 1154 1,154.00 1148.23 1350 1,350.00 1343.25 1457 1,457.00 1449.71 1515 1,515.00 1507.42 1474 1,474.00 1466.63 1400 1,400.00 1393 6.96 5.69 5.73 5.77 6.75 7.29 7.58 7.37 7.00 7.05 7.25 1.01 7.58 4.90 2.10 7.80 1.06 5.05 1.09 1.10 2.15 1.11 1.12 3.86 1.19 7.74 4.13 0.72 0.59 0.59 0.60 0.70 0.76 0.79 0.76 0.73 0.73 0.75 0.10 0.79 0.51 0.22 0.81 0.11 0.52 0.11 0.11 0.22 0.12 0.12 0.40 0.12 0.80 0.43 1410 1,410.00 1402.95 1449 1,449.00 1441.75 201 201.00 199.99 1515 1,515.00 1507.42 980 420.3 980.00 420.30 975.1 418.2 1552.2 210.94 1560 1,560.00 212 212.00 1010 1,010.00 1004.95 218 220 429 222 218.00 220.00 429.00 222.00 216.91 218.9 426.85 220.89 222.88 768.14 236.81 770.13 821.87 224 224.00 772 772.00 238 238.00 774 1,548.00 826 826.00 13/4/2009 L&T 13/4/2009 TATASTL 13/4/2009 HDFCBANK 13/4/2009 AXISBANK 15/4/2009 STATE BANK O 15/4/2009 STATE BANK O 15/4/2009 STATE BANK O 15/4/2009 L&T 15/4/2009 L&T 15/4/2009 L&T 15/4/2009 ICICIBANK 15/4/2009 ICICIBANK 15/4/2009 STATE BANK O 15/4/2009 STATE BANK O 15/4/2009 ICICIBANK 15/4/2009 ICICIBANK 15/4/2009 STATE BANK O 15/4/2009 HDFCBANK 17/4/2009 ICICIBANK 27/4/2009 ICICIBANK 27/4/2009 4/5/2009 4/5/2009 4/5/2009 4/5/2009 4/5/2009 ICICIBANK ICICIBANK ICICIBANK ICICIBANK ICICIBANK ICICIBANK SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL SELL 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 282 282.00 280.59 1093.5 459.69 1.41 5.50 2.31 6.42 6.42 6.43 4.29 4.29 4.33 2.17 4.36 6.43 6.45 2.21 2.24 6.55 5.46 2.26 2.28 2.27 5.20 2.58 2.61 2.63 2.65 0.15 0.57 0.24 0.67 0.67 0.67 0.45 0.45 0.45 0.23 0.45 0.67 0.67 0.23 0.23 0.68 0.57 0.23 0.24 0.24 0.54 0.27 0.27 0.27 0.27 1099 1,099.00 462 462.00 1283 1,283.00 1276.58 1284 1,284.00 1277.58 1285 1,285.00 1278.57 857 858 865 434 435 857.00 858.00 865.00 434.00 870.00 852.71 853.71 860.67 431.83 432.82 1286 1,286.00 1279.57 1290 1,290.00 1283.55 442 448 442.00 448.00 439.79 445.76 1310 1,310.00 1303.45 1092 1,092.00 1086.54 451 451.00 455.25 448.74 452.97 451.73 516.4 512.42 518.39 522.37 527.35 1 455.25 1 2 1 1 1 1 454 454.00 519 1,038.00 515 515.00 521 521.00 525 525.00 530 530.00 Other Total Net STT Charges Charges Value 2.89 0.31 16.19 2,326.19 2.33 0.25 13.09 1,879.09 1.78 0.19 9.91 1,419.91 1.39 1.61 0.49 1.54 0.98 2.00 3.00 0.00 2.00 1.29 0.71 0.57 2.43 1.66 0.46 1.75 0.84 0.51 1.75 1.14 0.52 1.28 0.84 1.66 1.14 0.15 0.16 0.05 0.19 0.11 0.18 0.29 0.03 0.19 0.14 0.05 0.06 0.21 0.18 0.05 0.19 0.09 0.06 0.19 0.12 0.06 0.14 0.09 0.18 0.12 7.82 8.51 2.75 9.77 5.47 9.68 15.50 1.29 9.89 7.26 2.85 3.16 11.36 9.35 2.60 9.85 4.69 2.90 9.80 6.40 2.93 7.15 4.68 9.30 6.39 1,123.42 1,207.51 394.75 1,439.77 785.47 -1,323.32 -2,154.50 -222.21 1,379.89 1,042.26 374.85 -449.34 -1,537.64 1,344.35 372.60 1,414.85 673.69 415.90 1,407.80 919.90 420.93 1,027.15 671.68 1,335.30 917.89 0.45 2.19 0.44 1.21 1.38 0.79 0.67 1.33 0.87 0.78 1.35 1.53 1.61 0.86 2.00 0.76 0.41 1.28 0.56 1.25 0.73 0.76 1.51 0.76 0.36 1.64 1.19 1.46 0.35 0.35 0.35 0.40 1.91 0.05 0.24 0.05 0.13 0.15 0.05 0.05 0.14 0.09 0.08 0.14 0.16 0.17 0.05 0.17 0.08 0.04 0.14 0.04 0.13 0.08 0.08 0.16 0.11 0.04 0.13 0.13 0.16 0.04 0.04 0.04 0.04 0.15 2.80 12.27 2.46 6.77 7.71 2.99 2.80 7.47 4.85 4.39 7.38 8.55 9.04 2.94 9.21 4.18 2.25 7.07 2.39 6.88 4.02 4.17 8.35 5.45 1.99 7.08 6.57 8.20 1.93 1.92 1.92 2.18 8.39 409.80 1,762.27 352.46 971.77 1,107.71 383.99 371.80 1,072.47 696.85 629.39 1,052.38 1,228.55 1,299.04 362.94 1,284.21 609.18 327.25 1,031.07 324.89 1,002.88 586.02 608.17 1,218.35 835.45 288.99 969.08 957.57 1,200.20 280.93 280.42 279.92 318.18 1,153.39 1.74 1.43 1.43 1.43 1.96 1.83 1.89 1.83 1.77 1.77 1.89 0.00 1.89 1.11 0.53 1.47 0.27 1.26 0.27 0.27 0.54 0.27 0.11 0.97 0.30 1.74 1.03 0.19 0.15 0.15 0.16 0.18 0.20 0.20 0.20 0.19 0.19 0.20 0.03 0.20 0.13 0.06 0.21 0.03 0.14 0.03 0.03 0.06 0.03 0.03 0.10 0.03 0.21 0.11 9.61 7.87 7.91 7.96 9.60 10.07 10.46 10.17 9.69 9.75 10.09 1.14 10.46 6.65 2.90 10.29 1.47 6.97 1.51 1.52 2.97 1.53 1.37 5.33 1.64 10.49 5.70 -1,382.39 -1,130.13 -1,137.09 -1,146.04 -1,340.40 -1,446.93 -1,504.54 -1,463.83 -1,390.31 -1,400.25 -1,438.91 -199.86 -1,504.54 -973.35 -417.40 -1,549.71 -210.53 -1,003.03 -216.49 -218.48 -426.03 -220.47 -222.63 -766.67 -236.36 -1,537.51 -820.30 0.35 1.37 0.24 1.61 1.61 1.61 1.08 1.08 1.08 0.55 1.10 1.61 1.61 0.55 0.55 1.61 1.36 1.00 0.57 0.43 1.30 0.65 0.65 0.74 0.65 0.04 0.15 0.06 0.17 0.17 0.17 0.12 0.12 0.12 0.06 0.12 0.17 0.17 0.06 0.06 0.18 0.15 0.06 0.06 0.06 0.14 0.07 0.07 0.07 0.07 1.95 7.59 2.85 8.87 8.87 8.88 5.93 5.93 5.97 3.00 6.03 8.88 8.91 3.05 3.08 9.02 7.53 3.56 3.15 3.00 7.18 3.57 3.60 3.71 3.65 699.95 -280.05 -1,091.41 -459.15 -1,274.13 -1,275.13 -1,276.12 -851.07 -852.07 -859.03 -431.00 -863.97 -1,277.12 -1,281.09 -438.95 -444.92 -1,300.98 -1,084.47 -447.44 -452.10 -451.00 -1,030.82 -511.43 -517.40 -521.29 -526.35 -1,237.00 text fn related problems 1 We are uploading data from another application to a .txt file and then opening the .txt in Excel 2003. The data is employee numbers, which we are copying and pasting into our learning management system. In the LMS we need the number without the leading zeros. Formating as number does not work. Do you know a formula we could use to remove the zeros when the number of leading zeros varies? This is an example of the data: Method-1 26278 67405 42 108500 Method-2 26278 67405 42 108500 0026278, 0067405, 0000042, 0108500, 8 8 8 8 Aliter: Try this array formula =MID(A1,MATCH(TRUE,MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)<>"0",0),255) Aliter: Alternately, change the .txt extension to .csv and double click the file. Excel will then open the file without the leading zeroes. Scrip Code:532958 Company::ETC NETWORK For the Period:1-Jan-2009 to 1-Feb-2009 Date Open PriceHigh Price Low Price Close PriceWeighted Average No. of Price Shares 1 January 2009 88.00 92.75 87.10 91.70 90.52 2750 2 January 2009 95.05 105.00 91.75 95.85 99.13 32569 5 January 2009 96.50 99.75 95.50 95.80 97.36 3627 6 January 2009 96.50 102.00 92.00 92.30 96.08 5810 7 January 2009 93.15 93.50 76.05 78.80 84.20 3045 9 January 2009 75.00 79.40 71.50 73.05 74.31 1416 12 January 2009 72.10 78.75 72.05 78.75 72.96 1248 13 January 2009 76.50 78.75 73.55 75.40 75.82 1228 14 January 2009 76.00 77.25 75.30 77.25 76.99 387 15 January 2009 74.55 76.85 72.55 72.80 73.19 370 16 January 2009 73.20 79.00 72.50 76.75 76.13 312 19 January 2009 65.05 82.00 65.05 77.10 78.12 1569 20 January 2009 78.45 78.45 76.55 76.70 77.83 318 21 January 2009 76.00 77.00 70.05 70.80 71.96 232 22 January 2009 70.05 71.50 66.20 70.00 68.55 1030 23 January 2009 57.10 69.95 57.10 65.00 65.80 1256 27 January 2009 66.00 68.20 64.20 64.35 65.85 620 28 January 2009 65.00 65.80 61.20 63.10 62.89 1321 29 January 2009 65.10 75.70 65.10 69.10 73.97 22196 30 January 2009 67.00 69.20 66.00 67.40 66.90 507 Scrip Code:532958 Company::ETC NETWORK For the Period:1-Feb-2009 to 1-Mar-2009 Date Open PriceHigh Price Low Price Close PriceWeighted Average No. of Price Shares 2 February 2009 69.90 71.40 65.60 66.95 68.95 330 3 February 2009 65.50 69.50 65.50 69.45 67.74 212 4 February 2009 64.60 78.00 64.60 68.70 71.35 3396 5 February 2009 69.00 69.00 67.00 67.75 68.23 707 9 February 2009 68.10 68.20 66.15 66.60 67.20 861 10 February 2009 69.50 71.85 68.25 69.60 69.99 1187 11 February 2009 68.35 72.00 68.00 71.95 69.53 276 12 February 2009 74.90 75.90 70.90 72.00 72.31 3339 13 February 2009 72.00 83.90 72.00 79.50 79.24 22014 16 February 2009 83.70 83.70 73.15 74.40 79.80 3794 17 February 2009 72.00 73.50 69.60 70.30 71.08 479 18 February 2009 66.00 72.50 66.00 70.55 70.76 1142 19 February 2009 70.30 70.65 70.10 70.65 70.45 130 20 February 2009 69.00 69.00 63.95 65.10 65.94 2758 24 February 2009 65.00 67.90 62.50 64.50 65.34 733 25 February 2009 64.00 66.65 63.10 63.65 64.47 678 26 February 2009 63.50 63.50 62.10 63.50 62.50 381 27 February 2009 63.00 64.65 61.25 63.80 61.99 81 * Spread Scrip Code:532958 Company::ETC NETWORK For the Period:1-Mar-2009 to 1-Apr-2009 Date Open PriceHigh Price Low Price Close PriceWeighted Average No. of Price Shares 2 March 2009 62.05 64.00 60.95 63.95 62.26 360 3 March 2009 62.00 62.90 59.00 60.25 61.45 826 4 March 2009 67.20 67.20 56.55 58.60 58.75 1306 5 March 2009 59.00 59.00 56.20 56.65 57.09 268 6 March 2009 56.00 58.85 52.50 53.80 55.60 1089 9 March 2009 54.95 54.95 50.10 54.35 52.86 529 12 March 2009 57.60 58.00 52.75 54.50 55.67 1582 13 March 2009 54.10 56.45 51.55 52.60 53.64 1388 16 March 2009 54.25 57.65 54.00 54.80 55.31 4755 17 March 2009 52.00 63.50 51.25 61.05 59.84 4972 18 March 2009 61.00 64.65 61.00 63.50 62.16 1260 19 March 2009 65.00 65.00 58.00 61.15 61.02 592 20 March 2009 57.75 65.00 57.75 61.00 62.23 815 23 March 2009 58.50 65.65 58.25 63.00 62.14 1099 24 March 2009 65.50 65.50 61.15 61.15 62.44 106 25 March 2009 60.05 61.85 59.90 60.15 60.49 50888 26 March 2009 60.80 64.00 59.00 59.95 60.66 1539 27 March 2009 68.50 68.60 58.55 59.80 61.85 5209 30 March 2009 59.20 59.20 58.00 58.00 58.57 610 31 March 2009 57.25 59.00 57.25 58.50 58.31 1208 1 April 2009 60.00 64.00 59.15 63.05 61.76 18732 Scrip Code:532958 Company::ETC NETWORK For the Period:1-Apr-2009 to 1-May-2009 Date Open PriceHigh Price Low Price Close PriceWeighted Average No. of Price Shares 1 April 2009 60.00 64.00 59.15 63.05 61.76 18732 2 April 2009 65.00 67.50 62.50 64.10 65.18 3233 6 April 2009 65.40 70.00 65.40 68.95 67.54 2048 8 April 2009 66.40 80.00 66.35 73.20 74.30 10939 9 April 2009 74.95 80.00 72.05 77.65 76.14 4504 13 April 2009 79.00 86.25 77.45 81.40 81.45 6951 15 April 2009 81.00 90.00 80.65 87.95 86.68 7700 16 April 2009 95.00 105.40 83.05 88.55 91.96 99982 17 April 2009 90.00 93.45 79.50 79.65 86.85 56662 20 April 2009 81.00 87.00 81.00 84.45 85.22 53866 21 April 2009 80.55 86.00 80.55 81.95 82.58 49202 22 April 2009 83.10 86.00 81.25 81.60 81.71 48815 23 April 2009 79.25 80.05 75.70 76.80 77.48 1307 24 April 2009 72.05 79.70 72.05 76.60 77.11 1096 27 April 2009 78.80 78.80 74.10 74.10 75.83 757 28 April 2009 72.25 72.25 65.00 67.25 69.49 2966 29 April 2009 67.95 69.55 66.00 66.80 67.27 547 Scrip Code:532958 Company::ETC NETWORK For the Period:1-May-2009 to 11-May-2009 Date 4 May 2009 5 May 2009 6 May 2009 7 May 2009 8 May 2009 Open PriceHigh Price Low Price Close PriceWeighted Average No. of Price Shares 72.90 72.90 70.00 71.25 71.74 1106 76.00 77.00 72.00 74.55 75.26 7530 76.00 76.50 70.15 71.85 73.93 6319 71.00 74.30 70.20 73.90 72.46 1778 72.50 79.00 72.50 73.70 74.73 7780 to 1-Feb-2009 No. of Trades 133 719 91 151 91 51 33 25 6 25 31 62 12 25 39 68 31 35 334 22 Total Turnover(Rs.) (Rs.) * Spread H-L C-O 248,917.00 5.65 3.70 3,228,530.00 13.25 0.80 353,118.00 4.25 -0.70 558,237.00 10.00 -4.20 256,391.00 17.45 -14.35 105,218.00 7.90 -1.95 91,059.00 6.70 6.65 93,108.00 5.20 -1.10 29,796.00 1.95 1.25 27,082.00 4.30 -1.75 23,751.00 6.50 3.55 122,568.00 16.95 12.05 24,751.00 1.90 -1.75 16,695.00 6.95 -5.20 70,603.00 5.30 -0.05 82,651.00 12.85 7.90 40,830.00 4.00 -1.65 83,081.00 4.60 -1.90 1,641,913.00 10.60 4.00 33,917.00 3.20 0.40 No. of Shares 2750 32569 3627 5810 3045 1416 1248 1228 387 370 312 1569 318 232 1030 1256 620 1321 22196 507 No. of Shares 2750 32569 3627 5810 3045 1416 1248 1228 387 370 312 1569 318 232 1030 1256 620 1321 22196 507 TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE to 1-Mar-2009 No. of Trades 36 7 144 24 30 54 12 62 366 139 29 46 6 140 66 21 29 7 Total Turnover(Rs.) (Rs.) * Spread H-L C-O 22,753.00 5.80 -2.95 14,361.00 4.00 3.95 242,295.00 13.40 4.10 48,237.00 2.00 -1.25 57,859.00 2.05 -1.50 83,073.00 3.60 0.10 19,191.00 4.00 3.60 241,456.00 5.00 -2.90 1,744,318.00 11.90 7.50 302,774.00 10.55 -9.30 34,049.00 3.90 -1.70 80,807.00 6.50 4.55 9,158.00 0.55 0.35 181,875.00 5.05 -3.90 47,897.00 5.40 -0.50 43,711.00 3.55 -0.35 23,813.00 1.40 0.00 5,021.00 3.40 0.80 No. of Shares 330 212 3396 707 861 1187 276 3339 22014 3794 479 1142 130 2758 733 678 381 81 No. of Shares 330 212 3396 707 861 1187 276 3339 22014 3794 479 1142 130 2758 733 678 381 81 to 1-Apr-2009 No. of Trades 24 57 64 18 64 36 26 51 36 91 27 26 27 30 10 23 45 100 14 23 154 Total Turnover(Rs.) (Rs.) * Spread H-L C-O 22,413.00 3.05 1.90 50,758.00 3.90 -1.75 76,732.00 10.65 -8.60 15,301.00 2.80 -2.35 60,543.00 6.35 -2.20 27,963.00 4.85 -0.60 88,068.00 5.25 -3.10 74,449.00 4.90 -1.50 263,001.00 3.65 0.55 297,505.00 12.25 9.05 78,322.00 3.65 2.50 36,122.00 7.00 -3.85 50,719.00 7.25 3.25 68,290.00 7.40 4.50 6,619.00 4.35 -4.35 3,078,348.00 1.95 0.10 93,362.00 5.00 -0.85 322,197.00 10.05 -8.70 35,729.00 1.20 -1.20 70,439.00 1.75 1.25 1,156,922.00 4.85 3.05 No. of Shares 360 826 1306 268 1089 529 1582 1388 4755 4972 1260 592 815 1099 106 50888 1539 5209 610 1208 18732 No. of Shares 360 826 1306 268 1089 529 1582 1388 4755 4972 1260 592 815 1099 106 50888 1539 5209 610 1208 18732 to 1-May-2009 No. of Trades 154 53 67 149 99 114 168 553 202 164 99 90 40 40 21 61 27 Total Turnover(Rs.) (Rs.) * Spread H-L C-O 1,156,922.00 4.85 3.05 210,735.00 5.00 -0.90 138,317.00 4.60 3.55 812,750.00 13.65 6.80 342,923.00 7.95 2.70 566,174.00 8.80 2.40 667,427.00 9.35 6.95 9,194,398.00 22.35 -6.45 4,921,142.00 13.95 -10.35 4,590,523.00 6.00 3.45 4,062,943.00 5.45 1.40 3,988,718.00 4.75 -1.50 101,271.00 4.35 -2.45 84,509.00 7.65 4.55 57,403.00 4.70 -4.70 206,107.00 7.25 -5.00 36,798.00 3.55 -1.15 No. of Shares 18732 3233 2048 10939 4504 6951 7700 99982 56662 53866 49202 48815 1307 1096 757 2966 547 No. of Shares 18732 3233 2048 10939 4504 6951 7700 99982 56662 53866 49202 48815 1307 1096 757 2966 547 to 11-May-2009 No. of Trades 34 54 82 25 88 Total Turnover(Rs.) (Rs.) * Spread H-L C-O 79,347.00 2.90 -1.65 566,686.00 5.00 -1.45 467,171.00 6.35 -4.15 128,832.00 4.10 2.90 581,426.00 6.50 1.20 No. of Shares 1106 7530 6319 1778 7780 No. of Shares 1106 7530 6319 1778 7780 #VALUE! 32569 FALSE #VALUE! old length no. value 5 2750 6 32569 5 3627 5 5810 5 3045 5 1416 5 1248 5 1228 4 387 4 370 4 312 5 1569 4 318 4 232 5 1030 5 1256 4 620 5 1321 6 22196 4 507 4,091 new length 4 5 4 4 4 4 4 4 3 3 3 4 3 3 4 4 3 4 5 (3,469) 3 4 4 5 4 4 5 4 5 6 5 4 5 4 5 4 4 4 3 330 212 3396 707 861 1187 276 3339 22014 3794 479 1142 130 2758 733 678 381 81 2,361 (5,199) 4 4 5 4 5 4 5 5 5 5 5 4 4 5 4 6 5 5 4 5 6 360 826 1306 268 1089 529 1582 1388 4755 4972 1260 592 815 1099 106 50888 1539 5209 610 1208 18732 4,721 (2,839) 6 5 5 6 5 5 5 6 6 6 6 6 5 5 4 5 4 18732 3233 2048 10939 4504 6951 7700 99982 56662 53866 49202 48815 1307 1096 757 2966 547 21,724 14,164 5 5 5 5 5 avg 1106 7530 6319 1778 7780 4,903 7,560 7,560 (2,657) Sumproduct Control Name 1 Pal 2 Sukhi 3 Suri 4 Sonu 5 Sukhi 3 suri Marks 57 65 49 75 71 49 5 Dynamic sorting Sorted Marks 49 57 65 71 75 Solver Price 29% Margin 71% Loan Int rate Period EMI Total paymt Extra 2,800,000 800,000 2,000,000 10% 15 yrs 21,492 3,868,578 1,868,578 mint 22may09 85 $ bn GDP 1,214 $ bn = 7% of GDP rbi estimate Network18 Closing price as on 01-Jun-09 02-Jun-09 03-Jun-09 cell formatting TV18 Closing price as on 01-Jun-09 02-Jun-09 03-Jun-09 Network18 % change 130.7 133.15 1.87% 155.2 16.56% Sensex % change 14840.63 14874.91 0.23% 14870.9 -0.03% Network18 % change 149.6 154.55 3.31% 165.15 6.86% Sensex % change 14840.63 14874.91 0.23% 14870.9 -0.03%