Today morning i recieved a rare "useful" forwarded mail. Such mails make you belive that not all forwarded mails are useless. This mail contained all the important toll free numbers ranging from banks to healthcare. So i thought of sharing the info with everybody. God bless the guy who compiled all this data.
Airlines
Indian Airlines -1800 180 1407
Jet Airways - 1800 22 5522
Spice Jet - 1800 180 3333
Air India -- 1800 22 7722
Kingfisher - 1800 180 0101
============ ========= ========= =====
Banks
ABN AMRO -1800 11 2224
Canara Bank - 1800 44 6000
Citibank - 1800 44 2265
Corporation Bank - 1800 443 555
Development Credit Bank - 1800 22 5769
HDFC Bank - 1800 227 227
ICICI Bank - 1800 333 499
ICICI Bank NRI - 1800 22 4848
IDBI Bank - 1800 11 6999
Indian Bank - 1800 425 1400
ING Vysya - 1800 44 9900
Kotak Mahindra Bank - 1800 22 6022
Lord Krishna Bank - 1800 11 2300
Punjab National Bank - 1800 122 222
State Bank of India - 1800 44 1955
Syndicate Bank - 1800 44 6655
============ ========= ========= =====
Automobiles
Mahindra Scorpio -1800 22 6006
Maruti - 1800 111 515
Tata Motors - 1800 22 5552
Windshield Experts - 1800 11 3636
============ ========= ========= =====
Computers/IT
Adrenalin -1800 444 445
AND - 1800 425 6664
Apple Computers - 1800 444 683
Canon - 1800 333 366
Cisco Systems - 1800 221 777
Compaq - HP - 1800 444 999
Data One Broadband - 1800 424 1800
Dell - 1800 444 026
Epson - 1800 44 0011
eSys - 3970 0011
Genesis Tally Academy - 1800 444 888
HCL - 1800 180 8080
IBM - 1800 443 333
Lexmark - 1800 22 4477
Marshal's Point - 1800 33 4488
Microsoft - 1800 111 100
Microsoft Virus Update - 1901 333 334
Seagate - 1800 180 1104
Symantec - 1800 44 5533
TVS Electronics - 1800 444 566
WeP Peripherals - 1800 44 6446
Wipro - 1800 333 312
Xerox - 1800 180 1225
Zenith - 1800 222 004
============ ========= ========= =====
Indian Railway Enquiries
Indian Railway General Enquiry 131
Indian Railway Central Enquiry 131
Indian Railway Reservation 131
Indian Railway Railway Reservation Enquiry 1345,1335,1330
Indian Railway Centralised Railway Enquiry 1330/1/2/3/4/ 5/6/7/8/9
============ ========= ========= ========= ========= =====
Couriers/Packers & Movers
ABT Courier -1800 44 8585
AFL Wizz - 1800 22 9696
Agarwal Packers & Movers - 1800 11 4321
Associated Packers P Ltd - 1800 21 4560
DHL - 1800 111 345
FedEx - 1800 22 6161
Goel Packers & Movers - 1800 11 3456
UPS - 1800 22 7171
============ ========= ========= =========
Home Appliances
Aiwa/Sony -1800 11 1188
Anchor Switches - 1800 22 7979
Blue Star - 1800 22 2200
Bose Audio - 1800 11 2673
Bru Coffee Vending Machines - 1800 44 7171
Daikin Air Conditioners - 1800 444 222
DishTV - 1800 12 3474
Faber Chimneys - 1800 21 4595
Godrej - 1800 22 5511
Grundfos Pumps - 1800 33 4555
LG - 1901 180 9999
Philips - 1800 22 4422
Samsung - 1800 113 444
Sanyo - 1800 11 0101
Voltas - 1800 33 4546
WorldSpace Satellite Radio - 1800 44 5432
============ ========= ========= =========
Investments/ Finance
CAMS -1800 44 2267
Chola Mutual Fund - 1800 22 2300
Easy IPO's - 3030 5757
Fidelity Investments - 1800 180 8000
Franklin Templeton Fund - 1800 425 4255
J M Morgan Stanley - 1800 22 0004
Kotak Mutual Fund - 1800 222 626
LIC Housing Finance - 1800 44 0005
SBI Mutual Fund - 1800 22 3040
Sharekhan - 1800 22 7500
Tata Mutual Fund - 1800 22 0101
============ ========= ========= ====
Travel
Club Mahindra Holidays -1800 33 4539
Cox & Kings - 1800 22 1235
God TV Tours - 1800 442 777
Kerala Tourism - 1800 444 747
Kumarakom Lake Resort - 1800 44 5030
Raj Travels & Tours - 1800 22 9900
Sita Tours - 1800 111 911
SOTC Tours - 1800 22 3344
============ ========= ========= ====
Healthcare
Best on Health -1800 11 8899
Dr Batras - 1800 11 6767
GlaxoSmithKline - 1800 22 8797
Johnson & Johnson - 1800 22 8111
Kaya Skin Clinic - 1800 22 5292
LifeCell - 1800 44 5323
Manmar Technologies - 1800 33 4420
Pfizer - 1800 442 442
Roche Accu-Chek - 1800 11 45 46
Rudraksha - 1800 21 4708
Varilux Lenses - 1800 44 8383
VLCC - 1800 33 1262
============ ========= ========= ===
Insurance
AMP Sanmar -1800 44 2200
Aviva - 1800 33 2244
Bajaj Allianz - 1800 22 5858
Chola MS General Insurance - 1800 44 5544
HDFC Standard Life - 1800 227 227
LIC - 1800 33 4433
Max New York Life - 1800 33 5577
Royal Sundaram - 1800 33 8899
SBI Life Insurance - 1800 22 9090
============ ========= ========= =======
Hotel Reservations
GRT Grand -1800 44 5500
InterContinental Hotels Group - 1800 111 000
Marriott - 1800 22 0044
Sarovar Park Plaza - 1800 111 222
Taj Holidays - 1800 111 825
============ ========= ========= ======
Teleshopping
Asian Sky Shop -1800 22 1800
Jaipan Teleshoppe - 1800 11 5225
Tele Brands - 1800 11 8000
VMI Teleshopping - 1800 447 777
WWS Teleshopping - 1800 220 777
============ ========= ========= ========
Others
Domino's Pizza -1800 111 123
============ ========= ========= ====
Cell Phones
BenQ -1800 22 08 08
Bird CellPhones - 1800 11 7700
Motorola MotoAssist - 1800 11 1211
Nokia - 3030 3838
Sony Ericsson - 3901 1111
Thursday, April 2, 2009
Wednesday, April 1, 2009
Advanced Validation Techniques in Excel
Assuming that one knows validation in excel, i am posting this blog which desribes advanced validation techniques in excel.
First let's talk about the problem/scenario which will help one in visualizing what i am talking about.
You have a column in excel where you have defined a drop-down list of items using simple validation. If you require the entries of drop-down list in another column vary in accrodance with the selection made in the first column, these advanced vaqlidation thechniques will help you.
The first column should be defined in the basic way of creating a drop-down box-either by defining a list or by including in the definition field itself. This should be very easy (Assumption!!!)
Now the corresponding items of drop-down boxes must be named with exaclty the same name of the primary list. Let me now take an example.
Option - 1: Numbers which will include 1,2,3,4,5,6,7,8,9,10
Option - 2: Alphabets which will include A,B,C,D,E,F,G,H....
Option - 3: Symbols which will include !,@,#,$,%,^,&,*,(,)
In this case Numbers, Alphabets and Symbols will be your primay validation column. Based on the selection in this column, the next column should include items in drop-down box. Now these items should be included in a different column and their lists should be named as Numbers or Alphabets or Symbols-which ever applies. Then in the second column, include the following formula. This will automatically inter-link the primary and secondary columns.
=indirect(Primary Column Cell No)
Now there is another problem which might arise. IF somebody changes the selection of the first column after making a choice in the second column, then one can use the following formula to highlight the error made. This should be defined in the conditional formatting of the secondary column.
=ISERROR(MATCH(Secondary Column Cell No,INDIRECT(Primary Column Cell No),FALSE))
Now this completes the procedure of creating linked drop-down boxes with loose ends tied.
I assume that i was clear enough in describing the problem and solution. In case if i am wrong, one can leave a message describing their question which will be addressed.
First let's talk about the problem/scenario which will help one in visualizing what i am talking about.
You have a column in excel where you have defined a drop-down list of items using simple validation. If you require the entries of drop-down list in another column vary in accrodance with the selection made in the first column, these advanced vaqlidation thechniques will help you.
The first column should be defined in the basic way of creating a drop-down box-either by defining a list or by including in the definition field itself. This should be very easy (Assumption!!!)
Now the corresponding items of drop-down boxes must be named with exaclty the same name of the primary list. Let me now take an example.
Option - 1: Numbers which will include 1,2,3,4,5,6,7,8,9,10
Option - 2: Alphabets which will include A,B,C,D,E,F,G,H....
Option - 3: Symbols which will include !,@,#,$,%,^,&,*,(,)
In this case Numbers, Alphabets and Symbols will be your primay validation column. Based on the selection in this column, the next column should include items in drop-down box. Now these items should be included in a different column and their lists should be named as Numbers or Alphabets or Symbols-which ever applies. Then in the second column, include the following formula. This will automatically inter-link the primary and secondary columns.
=indirect(Primary Column Cell No)
Now there is another problem which might arise. IF somebody changes the selection of the first column after making a choice in the second column, then one can use the following formula to highlight the error made. This should be defined in the conditional formatting of the secondary column.
=ISERROR(MATCH(Secondary Column Cell No,INDIRECT(Primary Column Cell No),FALSE))
Now this completes the procedure of creating linked drop-down boxes with loose ends tied.
I assume that i was clear enough in describing the problem and solution. In case if i am wrong, one can leave a message describing their question which will be addressed.
Tuesday, March 31, 2009
College Convocation!!!!
Well!!!At last....
Our college management finally woke up and anounced the date for convocation-4th April'09. Its exactly 22 months back when we joined HAIL and finally getting a chance to meet some of my good old friends who otherwise come up with weird excuses for not plannig a trip to Pune.
The convocation is just a couple of days away and friends will start pouring in very soon. Parties, roaming and making fun of old days...NOPE...this wont be the situation this time around. Working till late friday evening and then attending the conocation on Saturday Morning in your Sunday dress is the most practical way of life...it just seems to be the easiest way.
And back to office on Monday...Life has become so routine that we really miss some good things which we did on week days couple of years back...MON, TUE, WED, THU, TGIF and then the week-end comes and again the count starts...and if there is a holiday on a week-day you feel bored as it breaks the rythm and suddenly the next day becomes hell down under...
Well, finished (almost) my second year in Honeywell and also my Six-Sigma GB certification which was running for the past 6-8 months....Some times it feels really bad to comprehend the fact that one is facing the worst recession (or fear) in the 2nd year of career...Well on the positive side, it has made you stronger both emotionally and keep your feet grounded....
After completing my GB certification, i set my target on PMP certification which should be started any time soon....
Amidst all this, i have give my car for servicing...the first 10K Kms have been enjoyable and satisfactory...well i have reserved another posting to describe my experiences...Achtung!!!!
Well..this is not a monday moring nor a stress busting posting...but will start posting more frequently...
Till then keep missing me...
Our college management finally woke up and anounced the date for convocation-4th April'09. Its exactly 22 months back when we joined HAIL and finally getting a chance to meet some of my good old friends who otherwise come up with weird excuses for not plannig a trip to Pune.
The convocation is just a couple of days away and friends will start pouring in very soon. Parties, roaming and making fun of old days...NOPE...this wont be the situation this time around. Working till late friday evening and then attending the conocation on Saturday Morning in your Sunday dress is the most practical way of life...it just seems to be the easiest way.
And back to office on Monday...Life has become so routine that we really miss some good things which we did on week days couple of years back...MON, TUE, WED, THU, TGIF and then the week-end comes and again the count starts...and if there is a holiday on a week-day you feel bored as it breaks the rythm and suddenly the next day becomes hell down under...
Well, finished (almost) my second year in Honeywell and also my Six-Sigma GB certification which was running for the past 6-8 months....Some times it feels really bad to comprehend the fact that one is facing the worst recession (or fear) in the 2nd year of career...Well on the positive side, it has made you stronger both emotionally and keep your feet grounded....
After completing my GB certification, i set my target on PMP certification which should be started any time soon....
Amidst all this, i have give my car for servicing...the first 10K Kms have been enjoyable and satisfactory...well i have reserved another posting to describe my experiences...Achtung!!!!
Well..this is not a monday moring nor a stress busting posting...but will start posting more frequently...
Till then keep missing me...
Subscribe to:
Posts (Atom)