Dear friends
I am enclosing a txt file generated out of Cobol package. Can anybody help
in out to convert the same into excel.
Thanking you in anticipation of a favourable response
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
------------------------------------------------------------------------------------------------------------------------------------
! ! TARGETS
!
! !- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - -!
!BANK ! AGRICULTURE ! ALLIED ! NFS ! OPS !
TOTAL ! OF WHICH ! NPS !
!
!----------------!----------------!----------------!----------------!------------------!
GOVT PROGS. !-------------------!
!------! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
! DESC! ! ! ! !
! ! !
!----------------------------------------------------------------------------------------------------------------------------------!
! ! ! ! ! !
! ! !
!SBI ! 15936 2253200! 662 64300! 1004 1080000! 1812 846000!
19414 4243500! 1631 770042! 2773 275000 !
!FEDERL! 684 236400! 45 53600! 75 40000! 201 90000!
1005 420000! 38 47340! 139 35000 !
!V K G ! 825 151300! 244 28700! 79 30000! 267 85000!
1415 295000! ! 63 3000 !
!BOB ! 1962 588580! 504 111420! 204 129600! 456 181800!
3126 1011400! 164 171760! 59 66500 !
!BOI ! 18682 3298610! 3711 212390! 943 411700! 2758 606300!
26094 4529000! 1823 114420! 3079 290180 !
!BOM ! 11098 1695174! 1469 110226! 594 158000! 2142 559000!
15303 2522400! 1398 98802! 1754 319300 !
!CANARA! 1452 274600! 330 38400! 1112 62700! 384 149300!
3284 525000! 312 58600! 139 74000 !
!DENA ! 2083 400940! 189 8960! 98 65200! 262 127700!
2632 602800! 94 17860! 202 35700 !
!INDIAN! 143 11000! 17 5000! 48 35000! 98 27800!
306 123800! 9 550! 115 27000 !
!CBI ! 1098 404320! 215 33380! 126 197700! 302 154800!
1741 790200! 168 22275! 242 59100 !
!UNION ! 5178 1186817! 1329 157183! 485 200000! 1003 233000!
7995 1777000! 451 50665! 578 234000 !
!PNB ! 46 12000! 260 15000! 16 45000! 111 50000!
433 122000! 30 1200! 120 20000 !
!ICICI ! 15837 2766100! 7686 643900! 1134 253000! 1233 292700!
25890 3955700! 3471 450000! 2495 486000 !
!UCO ! 212 47800! 17 29200! 56 36900! 144 53400!
429 167300! 24 1820! 6 11000 !
!IDBI ! 1326 215000! 130 89000! 1147 114600! 475 171200!
3078 589800! 76 11270! 457 149200 !
!SYND ! 442 72610! 81 24390! 80 32000! 322 107500!
925 236500! 55 27250! 102 20500 !
!CORPO ! 1043 152550! 129 53550! 123 41000! 171 105000!
1466 352100! 62 13250! 78 197500 !
!RATNA ! 3457 972730! 2024 127270! 203 74000! 610 62000!
6294 1236000! 354 109490! 690 171700 !
!P&SIND! 52 22500! 8 5000! 17 17500! 68 25000!
145 70000! 30 2400! 44 7500 !
!KBL ! 440 54500! 26 10500! 56 25000! 46 32000!
568 122000! 13 900! 11 20000 !
!VIJAYA! 357 89180! 49 22820! 241 29800! 87 37500!
734 179300! 79 7129! 72 21300 !
!HDFC ! 2231 480000! 1612 70000! 536 150000! 631 200000!
5010 900000! 16 400! 128 18000 !
!AXIS ! 954 210100! 16 9900! 33 39600! 29 45000!
1032 304600! 10 350! 46 65000 !
!OBC ! 38 22500! ! 17 20000! 62 35000!
117 77500! 14 16000! 8 4000 !
!IOB ! 71 21500! 8 1000! 17 25000! 63 40000!
159 87500! 21 690! 8 3000 !
!ANDHRA! 125 19150! 93 3350! 16 15000! 78 25000!
312 62500! 6 645! 6 4000 !
!UNBANK! 25 2500! 2 2000! 4 40000! 51 25000!
82 87500! ! 40 4000 !
!SBH ! 123 225000! ! 25 20000! 53 30000!
201 72500! 11 390! 10 5000 !
!DCCB ! 24055 9926317! 6646 1268683! 2636 770000! 17811 750000!
51148 12715000! 4672 198438! 45202 2600000 !
!TOTAL ! 109981 25610478! 27502 3262122! 11125 4158300! 31730 5147000!
180338 38177900! 15042 1405071! 58666 5226480 !
! ! ! ! ! !
! ! !
************************************************************************************************************************************
------------------------------------------------------------------------------------------------------------------------------------
! ! TARGETS
!
! !- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - -!
!BANK ! ! ! ! !
! ! !
! ! CL ! MI ! LD ! FM !
PH ! OTH ! TOTAL !
!------! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
! Desc! ! ! ! !
! ! !
!----------------------------------------------------------------------------------------------------------------------------------!
! ! ! ! ! !
! ! !
!SBI ! 12797 833600! 910 425350! 36 10600! 357 250550!
1818 727200! 18 5900! 15936 2253200 !
!FEDERL! 438 100000! 27 32100! 97 38900! 55 39000!
66 26300! 1 100! 684 236400 !
!v K G ! 579 30000! 90 49300! 39 12100! 43 32900!
60 24000! 14 3000! 825 151300 !
!BOB ! 1386 250000! 57 43800! 25 12200! 204 142860!
172 68880! 118 70840! 1962 588580 !
!BOI ! 13284 734400! 1582 408150! 186 52700! 577 404470!
667 266950! 2386 1431940! 18682 3298610 !
!BOM ! 9302 734700! 640 444953! 149 46550! 244 171430!
637 254891! 126 42650! 11098 1695174 !
!CANARA! 1205 141000! 27 26300! 14 3800! 62 43400!
150 60100! ! 1458 274600 !
!DENA ! 1568 10200! 107 57850! ! 264 185040!
144 57850! ! 2083 400940 !
!INDIAN! 133 7000! ! ! !
10 4000! ! 143 11000 !
!CBI ! 608 106000! 52 85600! 36 13500! 131 92340!
265 106394! 6 486! 1098 404320 !
!UNION ! 4246 593000! 287 240293! 78 28200! 307 210000!
205 82349! 55 32975! 5178 1186817 !
!PNB ! 32 2000! 3 5000! ! 3 2000!
8 3000! ! 46 12000 !
!ICICI ! 14248 1605000! 362 328800! ! 957 670300!
! 270 162000! 15837 2766100 !
!UCO ! 157 15200! 8500! 11 3700! 12 7700!
32 12700! ! 212 47800 !
!IDBI ! 990 71000! 143 57350! 46 11600! 45 31500!
84 33550! 18 10000! 1326 215000 !
!SYND ! 341 15000! 21 23810! 19 5600! 16 10600!
43 17100! 2 500! 442 72610 !
!CORPO ! 945 89100! 24 26150! 10 2750! 29 20450!
35 14100! ! 1043 152550 !
!RATNA ! 2325 755000! 253 108591! 43 10740! 714 50020!
118 47500! 4 879! 3457 972730 !
!P&SIND! 12 2500! 2 5000! 18 5000! 7 5000!
13 5000! ! 52 22500 !
!KBL ! 373 25000! 3 4075! 1 200! 3 2000!
57 22775! 3 450! 440 54500 !
!VIJAYA! 249 40000! 21 14685! 33 10000! 10 6775!
44 17720! ! 357 89180 !
!HDFC ! 1700 250000! 84 80000! 98 20000! 79 55000!
188 75000! ! 2231 480000 !
!AXIS ! 815 120000! 18 40800! 38 11600! !
78 31100! 5 6600! 954 210100 !
!OBC ! 18 2500! 4 5000! ! 8 12000!
8 3000! ! 38 22500 !
!IOB ! 27 2500! 4 4500! 13 3000! 4 2500!
23 9000! ! 71 21500 !
!ANDHRA! 43 2500! 22 6650! ! 6 4000!
15 6000! ! 125 19150 !
!UNBANK! 25 2500! ! ! !
! ! 25 2500 !
!SBH ! 127 2500! 18 8000! ! 9 6000!
13 6000! ! 123 22500 !
!DCCB ! 16761 5815000! 2929 1295858! 77 17360! 1150 1256977!
2682 1071935! 541 469187! 24055 9926317 !
!TOTAL ! 84734 12447200! 7672 3836465! 1067 320100! 5306 3714812!
7635 3054394! 3567 2237507! 109981 25610478 !
! ! ! ! ! !
! ! !
************************************************************************************************************************************
------------------------------------------------------------------------------------------------------------------------------------
! ! TARGETS
!
! !- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - -!
!BANK ! ! ! ! !
! ! !
! ! AH/DD ! AH/PF ! AH/SGP ! FISHERY !
FORESTRY ! STORAGE/M.Y. ! TOTAL !
!------! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
! Desc! ! ! ! !
! ! !
!----------------------------------------------------------------------------------------------------------------------------------!
! ! ! ! ! !
! ! !
!SBI ! 649 59300! 2 3900! 10 1000! 1 100!
! ! 662 64300 !
!FEDERL! 45 53600! ! ! !
! ! 45 53600 !
!v K G ! 216 24100! ! 20 1300! !
! 1 3300! 244 28700 !
!BOB ! 431 75970! 12 14500! 27 2450! 2 8500!
1 2500! 9 7500! 504 111420 !
!BOI ! 3547 196415! 4 1850! 159 7755! !
! 1 6370! 3711 212390 !
!BOM ! 1354 94051! 1 750! 111 8425! !
! 3 7000! 1469 110226 !
!CANARA! 328 37100! 1 500! ! !
! 1 800! 330 38400 !
!DENA ! 188 7400! ! ! !
! 1 1560! 189 8960 !
!INDIAN! ! ! ! !
! 17 50000! 17 50000 !
!CBI ! 214 32880! ! 1 500! !
! ! 215 33380 !
!UNION ! 1288 139483! 6 3000! 28 3500! !
1 1000! 3 10200! 1329 157183 !
!PNB ! 260 15000! ! ! !
! ! 260 15000 !
!ICICI ! 7379 587750! ! 307 56150! !
! ! 7686 643900 !
!UCO ! 15 27200! ! ! !
! 2 2000! 17 29200 !
!IDBI ! 83 56300! 4 1500! 2 200! !
! 41 31000! 130 89000 !
!SYND ! 72 22190! 2 200! ! !
! 7 2000! 81 24390 !
!CORPO ! 126 26550! 2 1000! ! !
! 8 26000! 129 53550 !
!RATNA ! 1955 120658! 8 3262! ! 1 1500!
! 1 1850! 2024 127270 !
!P&SIND! 6 3750! ! 2 1250! !
! ! 8 5000 !
K B L ! 26 10500! ! ! !
! ! 26 10500 !
VVIJAYA! 40 17190! 8 3630! ! !
! 1 2000! 49 22820 !
!HDFC ! 1386 61250! ! 226 8750! !
! ! 1612 70000 !
!AXIS ! 14 7900! ! ! !
! 2 2000! 16 9900 !
!IOB ! 8 1000! ! ! !
! ! 8 1000 !
!ANDHRA! 85 2900! ! 8 400! !
! ! 93 3350 !
UNBANK ! 2 20000! ! ! !
! ! 2 20000 !
DCCB ! 6390 545227! 13 79608! 271 387088! 4 19600!
7 16800! 43 220410! 6646 1268683 !
!TOTAL ! 26107 2245664! 64 113700! 1172 478768! 8 29700!
9 20300! 142 373990! 27502 3262122 !
! ! ! ! ! !
! ! !
************************************************************************************************************************************
------------------------------------------------------------------------------------------------------------------------------------
! ! TARGETS
!
! !- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - -!
!BANK ! ! ! ! !
! ! !
! ! SJSRY ! SGSY/IREP/IRDP ! WLDP/NWDPRA ! National Proj. !
State Govt progs.! Others ! Total !
!------! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
No.A/Cs Amount ! No.A/Cs Amount ! No.A/Cs Amount !
! Desc! ! ! ! !
! ! !
!----------------------------------------------------------------------------------------------------------------------------------!
! ! ! ! ! !
! ! !
!SBI ! 12 850! 110 9520! ! !
! 1509 152002! 1631 162372 !
!FEDERL! 5 400! 10 1720! ! !
! 23 4900! 38 7020 !
!BOB ! 8 800! 28 5400! ! !
! 128 24685! 164 30885 !
!BOI ! 29 2130! 295 19495! ! !
2 200! 1497 92595! 1823 114420 !
!BOM ! 13 950! 232 17847! ! 4 200!
! 1149 79805! 1398 98802 !
!CANARA! 5 405! 16 1450! ! !
10 15000! 281 41745! 312 58600 !
!DENA ! ! 10 2000! ! !
! 84 15860! 94 17860 !
!INDIAN! 1 50! 2 250! ! !
! 6 250! 9 550 !
!CBI ! 9 600! 18 3300! ! !
! 141 18375! 168 22275 !
!UNION ! 16 660! 71 5915! ! !
! 364 44090! 451 50665 !
!PNB ! 2 200! ! ! !
! 28 1000! 30 1200 !
!ICICI ! 12 1800! 9 550! ! !
27 1350! 3423 446300! 3471 450000 !
!UCO ! ! 7 550! ! !
! 17 1270! 24 1820 !
!IDBI ! 2 170! 1 100! ! !
1 100! 72 10900! 76 11270 !
!SYND ! 2 200! ! ! !
! 53 27050! 55 27250 !
!CORPO ! 4 1300! ! ! !
2 500! 56 11450! 62 13250 !
!RATNA ! 7 570! 42 1475! ! !
12 21000! 293 86445! 354 109490 !
!P&SIND! 3 250! 7 550! ! !
! 20 1600! 30 2400 !
!KBL ! 2 200! 1 50! ! !
! 10 650! 13 900 !
!VIJAYA! 2 400! 24 1885! ! !
! 53 4844! 79 7129 !
!HDFC ! ! 16 400! ! !
! ! 16 400 !
!AXIS ! ! ! ! !
! 10 350! 10 350 !
!OBC ! ! 5 5000! ! !
! 9 11000! 14 16000 !
!IOB ! 2 200! 3 45! ! !
! 16 445! 21 690 !
!ANDHRA! ! 7 250! ! !
! 9 395! 16 645 !
!SBH ! ! ! ! !
! 11 390! 11 390 !
!DCCB ! ! 2103 52707! ! !
! 2569 145731! 4672 198438 !
!TOTAL ! 136 12135! 3017 130459! ! 4 200!
54 38150! 11831 1224127! 15042 1405071 !
! ! ! ! ! !
! ! !
************************************************************************************************************************************
