Friday, December 29, 2006

Color Codes in MS Excel

If you want to apply some color in your Excel Sheet through the UDF, then use the following Color codes:




SL No. Color Color Code
1 White 2
2 Lavender 39
3 Pale Blue 37
4 Light Turquoise 34
5 Light Green 35
6 Light Yellow 36
7 Tan 40
8 Rose 38
9 Grey 25% 15
10 Plum 54
11 Sky Blue 33
12 Turquoise 8
13 Bright Green 4
14 Yellow 6
15 Gold 44
16 Pink 7
17 Grey 40% 48
18 Voilet 13
19 Light Blue 41
20 Aqua 42
21 Sea Green 50
22 Lime 43
23 Light Orange 45
24 Red 3
25 Grey 50% 16
26 Blue-Grey 47
27 Blue 5
28 Teal 14
29 Green 10
30 Dark Yellow 12
31 Orange 46
32 Dark Red 9
33 Grey 80% 56
34 Indigo 55
35 Dark Blue 11
36 Dark Teal 49
37 Dark Green 51
38 Olive Green 52
39 Brown 53
40 Black 1

Ctrl+Shift+Numericals Excel Keyboard Shortcuts

Short Cut Name
Ctrl+Shift+` Apply General format
Ctrl+Shift+1 Apply Number format
Ctrl+Shift+2 Apply Time format
Ctrl+Shift+3 Apply Date format
Ctrl+Shift+4 Apply Currency format
Ctrl+Shift+5 Apply percentage format
Ctrl+Shift+6 Apply Exponential number format
Ctrl+Shift+7 Apply an outline border to selection
Ctrl+Shift+8 Select Box
Ctrl+Shift+9 Display hidden rows in selection
Ctrl+Shift+0 Display hidden columns in selection
Ctrl+Shift+[ Go to All the Precedents
Ctrl+Shift+] Go to All the Dependents
Ctrl+Shift+\ In a selected column, select the cells that don't match the value in the active cell.
Ctrl+Shift+. Copies the cell to theleft (similar to Ctrl+D)
Ctrl+Shift+, Fill as Above
Ctrl+Shift+' Fill as Above and let it edit
Ctrl+Shift+/
Ctrl+Shift+`
Ctrl+Shift+- Remove outline border from selection
Ctrl+Shift+: Insert the current time
Ctrl+Shift+= Insert Cee/Row Funcion- Similar to Insert>Cell Menu

Ctrl+Shift+Alphabet Excel Keyboard Shortcuts

Short Cut Name
Ctrl+Shift+A
Ctrl+Shift+B
Ctrl+Shift+C
Ctrl+Shift+D
Ctrl+Shift+E
Ctrl+Shift+F Short Cut to Fonts
Ctrl+Shift+G
Ctrl+Shift+H
Ctrl+Shift+I
Ctrl+Shift+J
Ctrl+Shift+K
Ctrl+Shift+L
Ctrl+Shift+M
Ctrl+Shift+N
Ctrl+Shift+O Select all cells that contain a comment
Ctrl+Shift+P Shortcut to Font Size
Ctrl+Shift+Q
Ctrl+Shift+R
Ctrl+Shift+S
Ctrl+Shift+T
Ctrl+Shift+U
Ctrl+Shift+V
Ctrl+Shift+W
Ctrl+Shift+X
Ctrl+Shift+Y
Ctrl+Shift+Z

Ctrl+Numerical Excel Keyboard Shortcuts

Short Cut Name
Ctrl+1 Open the Format Cells dialog box
Ctrl+2 Bold
Ctrl+3 Italics
Ctrl+4 Underline
Ctrl+5 Strike through the selection
Ctrl+6 Display Place Holders for Objects
Ctrl+7 Show /Hide Standard Tool Bar
Ctrl+8 Show Outline Symbols
Ctrl+9 Hide selected rows
Ctrl+0 Hide selected columns
Ctrl+. Blank
Ctrl+, Blank
Ctrl+' Deletes the contents of the cell and prepares the same for Editing
Ctrl+/ Select the array containing the active cell.
Ctrl+` Show Formula
Ctrl+- Delete Cell/Row Similar to Edit>Delete
Ctrl+; Insert the current date
Ctrl+= Blank
Ctrl+[ Select cells that a selected formula directly references
Ctrl+] Select formulas that directly reference the active cell
Ctrl+\ In a selected row, select the cells that don't match the value in the active cell.

Ctrl+Alphabet Excel Keyboard Shortcuts

Short Cut Name
Ctrl+A Select All
Ctrl+B Bold Selection
Ctrl+C Copy the selected text or objects to the Clipboard
Ctrl+D Fill data down through selected cells
Ctrl+E Blank
Ctrl+F Open the Find tab of the Find And Replace dialog box
Ctrl+G Open GoTo
Ctrl+H Open the Replace tab of the Find And Replace dialog box
Ctrl+I Italicize the selection
Ctrl+J Blank
Ctrl+K Insert a hyperlink
Ctrl+L Create List
Ctrl+M Blank
Ctrl+N Create a new workbook
Ctrl+O Open a workbook
Ctrl+P Print a workbook
Ctrl+Q Blank
Ctrl+R Fill data through selected cells to the right
Ctrl+S Save a workbook
Ctrl+T Blank
Ctrl+U Underline the selection
Ctrl+V Paste the contents of the Clipboard
Ctrl+W Close a workbook
Ctrl+X Cut the selected text or objects to the Clipboard
Ctrl+Y Repeat last action
Ctrl+Z Undo last edit

Thursday, December 28, 2006

Newtons Laws applied to IT Industry

Source: Digit

I) Newton’s Law Of Motion: Every body continues its state of rest or uniform motion unless it is acted by external unbalanced force.

  • (In IT Industry) Every Software Engineer continues chatting or forwarding mails or sending posts on humor unless he is assigned work by his manager.

II) Newton’s Law: The rate of change of velocity of a body is directly proportional to the
applied force & takes place in the same direction in which force is applied

  • (In our IT Industry) The rate of changes made in the software are directly proportional to the payment received from client and takes place at the faster rate as deadline approaches.

III) Newton’s Law: For every action there is equal and opposite reaction.

  • (In our IT Industry) For every virus, there exist an equally powerful antivirus, & after release of that antivirus some more destructive virus comes into existence.

IV) Law of Conservation of Energy: Energy can neither be created nor be destroyed. It can be converted from one form to another.The total amount of energy in the universe always remains constant.

  • (In IT Industry) Bug can neither be inserted nor be removed from software. It can only be converted from one form to another.The total number of bugs in the software always remains constant.

Monday, December 25, 2006

A View from my class room


Early morning, the sun has not risen


there's a cat, a canteen a view


some leaves

Sunday, December 24, 2006

At the Restaurant - Noodle House


This is from Noodle House, near Satyam theater, Royapeth, Chennai. It is a Chinese Restaurant, the place looks long and the seats are compartmentalized. Food is good same goes for the crowd. Prices are also not very expensive. Service is however can be improved.

Friday, December 22, 2006

Who’s horny?

Source: E-mail forward

Two married men are out drinking one night, when one turns to the other and says, “You know, I don’t know what to do. Whenever I go home after we’ve been out drinking, I turn the headlights off before I get to the driveway. I shut off the engine and coast into the garage. I take my shoes off before I go into the house, I sneak up the stairs, get undressed in the bathroom, stick my foot in the toilet and pee down my leg to prevent splashing sounds. I ease into bed and my wife STILL wakes up, and yells at me for staying out so late.”

His friend looks at him and says “Well, you’re obviously taking the wrong approach. I screech into the driveway, slam the door, storm up the steps, pee hard into the toilet water, then use the full flush, throw my shoes in the closet, undress in the bedroom, then jump into bed, slap her on the arse and say!, ‘WHO’S HORNY????!!!’ and she acts like she’s sound asleep! Works Every Time!!!”

Understanding Women

Source: E-mail forward

A man, walking along a California beach, was deep in prayer. Suddenly, the sky clouded above his head and, in a booming voice, the Lord said “Because you have TRIED to be faithful to me in all ways, I will grant you one wish”.
The man said, “Build a bridge to Hawaii so I can drive over any time I want”.
The Lord said, “Your request is very materialistic. Think of the enormous challenges for that kind of undertaking. The supports required to reach the bottom of the Pacific! The concrete and steel it would take!

It will nearly exhaust several natural resources. I can do it, but it is hard for me to justify your desire for worldly things. Take a little more time and think of something that would honour and glorify me”.

The man thought about it for a long time. Finally he said, “Lord, I wish I could understand my wife. I want to know how she feels inside, what she’s thinking when she gives me the silent treatment, why she cries, what she means when she says ‘nothing’s wrong’ and how can I make a woman truly happy”.

The Lord said, “You want 4 lanes or 8 lanes on that bridge?”

Sunday, December 17, 2006

tech-related oneliners

Source: Digit Forum

  1. A TV can insult your intelligence, but nothing rubs it in like a computer.
  2. The nice thing about Windows - it does not just crash; it actually displays a dialogue box and lets you press OK first.
  3. Error : Press any key except.. no, No, NO NOT THAT ONE!
  4. Any system or program, however complicated, when looked at in exactly the right way will become even more complicated.
  5. To err is human, but to really screw things up requires a computer.
  6. Bad command or filename. Go stand in the corner.
  7. C code. C code run. Run, code, run! PLEASE!
  8. Programmer: An ingenious device that converts caffeine into code.
  9. When you get to the point where you really understand your computer, it’s probably obsolete.
  10. A computer program will always do what you tell it to, and seldom what you want it to.
  11. How do I set my laser printer on stun?
  12. — If you cut here, you’ll probably destroy your monitor —
  13. ASCII stupid question, get a stupid ANSI.
  14. Do files get embarrassed when they’re unzipped?
  15. My life needs a rewind/erase button.
  16. Ask not for whom the bell tolls. Let the machine get it.
  17. A life… cool.. where can I download one of those?
  18. A printer consists of three main parts: the case, the jammed paper tray and the blinking red light.
  19. After months of training, when you finally understand all of a programs commands, the new revised edition arrives with a new command structure.
  20. /earth: file system full.
  21. Any technology distinguishable from magic is insufficiently advanced.
  22. Artificial Intelligence: The art of making real computers act like the ones in movies.
  23. Computers are not intelligent. They only think they are.
  24. Lisp in action is like a finely choreographed ballet. Basic in action is like a waltz of drugged elephants. C in action is like a sword dance on a freshly waxed floor.
  25. Error 7.0b1 - The item could not be deleted because it was missing.
  26. There are two major products to come out of Berkley: LSD and UNIX. We don’t believe this to be a coincidence.
  27. There are two ways to construct a software design. Make it so simple that there are obviously no deficiencies; or make it so complicated that there are no obvious deficiencies.
  28. UNIX: when you can’t afford the very best.
  29. A fail-safe circuit will destroy all other circuits.
  30. The important things are always simple.
  31. The simple things are always hard.
  32. Earth is 98% full. Please delete anyone you can.
  33. Computers will never replace books. You can’t stand on a floppy disk to reach a high shelf.
  34. The world will end in five minutes. Please log out.
  35. WARNING: Keyboard Not Attached. Press F10 to Continue.
  36. COFFEE.EXE is missing. Insert cup and press any key.
  37. Bad Command or File Name. Good try, though.
  38. Enter any 11-digit prime number to continue.
  39. Error reading FAT record. Try the SKINNY one? (Y/N)
  40. General Failure’s Fault. Not Yours.
  41. Hit any user to continue.
  42. Scandisk is now checking your hard drive. You can start praying.
  43. Smash forehead on keyboard to continue.
  44. Cannot find REALITY.SYS…Universe halted.
  45. Whom computers would destroy, they must first drive mad.
  46. If you can’t beat your computer at chess, try kickboxing.
  47. Why can’t DOS ever say “Excellent command or filename”?
  48. A picture may be worth a thousand words but it uses up a thousand times more memory!
  49. Robots will be able to buy happiness, but in condensed chip form.

Friday, December 15, 2006

Interview With Siddhu

Source: E-mail forward

HB: Sherry, let us start from the beginning. Tell us about your early life.

NS: I was born in patiala on 29th October in 1969. My earliest memories are of my father telling me “Son, never be a Zerox”. So I always believe in being original. I speak English like a native, a native Indian villager. My father was a lawyer by profession, who used to gobble his rivals like sausages with his smart phrases. I used to watch him at court cross-examine witnesses and learnt the fine art of commentary from him. All I do, is translate those phrases and proverbs from Hindi to English

HB: You made your debut in 1983 against the Windies, but made it big-time only four years later.

NS: My big break came in 1987 world cup, when I bamboozled and mesmerized all opposition, scoring four half-centuries in five innings.

HB: Just when you were all set for bigger things, you got involved in a police case.

NS: Yes, it was the most unfortunate incident of my life. Punjab police booked me and my close friend for culpable homicide. I was accused of killing one Gurmit Singh. I am telling you I was innocent, as innocent as a freshly laid egg.

HB: But you did beat up that guy?

NS: But then I am a Sikh, a born fighter, someone who will fight with a rattlesnake and give him the first two bites. Believe me, that guy was asking for it. How can you kill anyone who is hell-bent on committing suicide?

HB: Do you regret that incident?

NS: Oh, yes Harsha I do, If only on that fateful day I had been able to check my emotions, which flew like the fare in Indian Taxi - but ifs and buts were pots and pans, there would be no tinkers After that my cricket career went in downward spiral. I became like kumbhakarna - six months in the team, then for another six months resting behind bars. My fortunes were swinging like a rubber ball in a tidal wave. Earlier I was traveling on a German autobahn, but now I was on an Indian road. For about five years I was in and out of the Indian cricket team, and my performance became as erratic as electricity supply in most Indian cities

HB: After Sunny’s retirement, you had several opening partners. Tell us about your experiences with them.

NS: Yes, there were several. There was Srikanth, completely unorthodox. The gap between his bat and pad used to be so much that I would have driven a Rolls Royce through it…and our fellow commentator Ravi, who was his exact opposite, very slow like Indian three-wheeler which will suck a lot of diesel but cannot go beyond 30.

HB: What would you regard as the high point of your career?

NS: When the Australians toured India with Shane Warne. Along with Sachin, I took Warne apart like a child tearing up the wrapping paper from his birthday present! I made incemeat of the mighty Aussies and ate them withTomato sauce. I was on rampage, just like an Indian elephant I trampled them like the elephant tramples the paddy fields.

HB: What is your opinion of current Indian team?

NS: Indian team’s performance is like current Hindi movies, too many flops and too few hits. It is too dependent on Sachin, Dravid, Srinath and Harbajan. Indian team without these four is like CHICKEN BIRYANI without Chicken, Rice, Muttor, Biryani-Masala. It’s an empty plate you can not eat it nor throw it away. Our cricketers are very volatile like the Bombay Stock Exchange (BSE). You never know how they perform on a given day. They are like bicycles in a cycle stand - one falls down and the complete row will be down!

HB: … and skipper Saurav?

NS: Saurav Ganguly is too open-minded. If you leave a soda bottle open the gas will vanish! You have to close it times. As a captain he sets a bad example for his team by his poor fielding. He moves so slowly on the field like Jack of Jack n Jill who goes to fetch pail of runs for the opposition.

HB: Sherry, you have made a dramatic comeback as a commentator. But don’t you feel embarrassed by the constant ridicule heaped on you for your flowery style of commentary?

NS: You can take the tiger out of the jungle, but u can’t take the jungle out of the tiger. Why should I be embarrassed about it? In fact, at present there are only two super stars in Indian cricket - the two S’s -Sachin & Sidhu. Let me tell you a secret. Star Sports-ESPN need me, as they can no longer rely on the performances of Indian cricket team. After Sachin gets out, they need someone to keep the viewers entertained. That is why they are now bringing that Bakra-guy Cyrus to commentate. I am telling you Harsha, your job is in danger, not mine. Soon the focus will be less on the game, more on us. It is going to become Sidhu-Cyrus show. The world is all about mind and matter, I don’t mind and you don’t matter.

We the People

Source: E-mail forward

For long, India’s colonial rulers divided the country’s population by the numbers. And as current-day politicians continue with that unholy task, we present a shortcut to make their work easier. Here’s distinguishing India’s different cultures by the numbers:

MALAYALEES
One Malayalee is a narial-pani shop.
Two Malayalees is a boat race.
Three Malayalees is a Gulf job racket.
Four Malayalees is an oilslick.

TAMILIANS
One Tamilian is a fugitive sandalwood smuggler.
Two Tamilians is a suicide-bomb squad.
Three Tamilians is a classical music school.
Four Tamilians is a Jayalalitha fan club.

ANDHRAITES
One Andhraite is a cycle-rickshaw driver.
Two Andhraites is a spice shop.
Three Andhraites is a Naxalite outfit.
Four Andhraites is the Telugu film industry.

BENGALIS
One Bengali is a rosagulla shop.
Two Bengalis is a black-and-white movie.
Three Bengalis is a Mohun Bagan support group.
Four Bengalis is a Marxist movement.

RAJASTHANIS
One Rajasthani is a cattle-seller.
Two Rajasthanis is a mason.
Three Rajasthanis is a puppet show.
Four Rajasthanis is a folk dance-drama.

GOANS
One Goan is Remo Fernandes.
Two Goans is a Feni distillery.
Three Goans is a football club.
Four Goans is an all-night-long beach party.

MANGALOREANS
One Mangalorean is a supari seller.
Two Mangaloreans can’t stand one another.
Three Mangaloreans is an Udupi restaurant.
Four Mangaloreans is a fanatical Konkani Sabha.

BOMBAYITES
One Bombayite is a hawker.
Two Bombayites is a film industry.
Three Bombayites is a slum.
Four Bombayites is the rush-hour train crowd.

MAHARASHTRIANS
One Maharashtrian is a bus conductor.
Two Maharashtrians is a kabaddi match.
Three Maharashtrians is a Ganpati procession.
Four Maharashtrians is a Shiv Sena Shakha.

GUJARATIS
One Gujarati is a share broker in a Mumbai train.
Two Gujaratis is the total chatter in a Mumbai train.
Three Gujaratis is a rummy game in a Mumbai train
Four Gujaratis is a dandiya-raas session all night long.

KUTCHIES
One Kutchi is a kirana shop.
Two Kutchis is a stationery shop.
Three Kutchis is a saree shop.
Four Kutchis is the entire Bombay retail trade.

SARDARJIS
One Sardarji is a truck-driver.
Two Sardarjis is a roadside dhaba.
Three Sardarjis is a terrorist outfit.
Four Sardarjis are always found in jokes.

SINDHIS
One Sindhi is a currency racket.
Two Sindhis is a papad factory.
Three Sindhis is a duplicate goods shop.
Four Sindhis is a lot of gas around (yeech!).

BIHARIS
One Bihari is Laloo Prasad Yadav.
Two Biharis is a booth-capturing squad.
Three Biharis is a caste killing.
Four Biharis is the total literate population of the state.

BHAIYYAS
One Bhaiyya is a milkman.
Two Bhaiyyas is a chanawala (or panipuri wala).
Three Bhaiyyas is a temple-destruction squad.
Four Bhaiyyas is a halwai shop.
(And 12 Bhaiyyas is one SMALL family).

KASHMIRIS
One Kashmiri is a boatman.
Two Kashmiris is a carpet factory.
Three Kashmiris is a tourist agency.
Four Kashmiris is a terrorist outfit.

KANNADIGAS
One Kannadiga is a coffee estate.
Two Kannadigas is a Udupi restaurant.
Three Kannadigas is a pepper powder factor.
Four Kannadigas is an anti-Cauvery squad.

PUNJABIS
One Punjabi is chhole-bathure 5 times a week.
Two Punjabis is one bottle of whisky in one night.
Three Punjabis is a public fist-fight.
Four Punjabis is 200 kg of excess weight.

PARSIS
One Parsi is a sentence punctuated with BC’s and MC’s.
Two Parsis is a doctor and a lawyer.
Three Parsis is a 75 year old man and his two unmarried sisters.
Four Parsis is half their remaining population.

PAKISTANIS
One Pakistani is one too many…………..

You are a true Hyderabadi if:

Source: E-mail forward


@>> Your address reads as 23-404-32/67A-43 (New MCH number 56-678/4A/B-22), while you actually live in the second house beside Zamzam cafe in lane behind Anand Theatre on SP Road.

@>> You end up buying only a salwar kameez, whether it is a theatre workshop, food mela, consumer expo, designer jewellery show, science show or an automobile convention.

@>> Your street has at least one roadside mobile hotel that serves Chinese delicacies such as Vegetable soft needles, Navrotten Kurma, Chicken Manchewurea or American Chompsee.

@>> Your answer is ’seedha chale jao’ when somebody asks you for directions, whether it is to Malakpet, Masab Tank, Malkajgiri or Moosapet.

@>> You come across tailors sporting the board: Immidiot delivery in two days onli.

@>> If you can speak Hindi, Urdu, English and Hyderabadi, except Telugu, fluently.

@>> Your answer is ‘not in my pockets’ when somebody asks you ‘Where is X Y Z ?’ and you also roll on the floor laughing at your joke.

@>> If you ask the waiter to get you some ‘Mango pickle’ even if you are sitting at a lavish continental banquet dinner with exotic Chinese, Mexican, Italian and Lebanese cuisines.

@>> You order for a tea just after having had a Caramel custard.

@>> If you have at least one Srinivas, Raju or Venkatesh within six square feet. In other words, you have at least one cousin, friend, colleague or acquaintance with these names.

@>> If you have at least one cousin, friend, colleague or acquaintance in the US in software.

@>> If everytime somebody gives you a piece of good news, the first thing you ask them is ‘Party kab hain?’

@>> You are reading this and secretly admitting that you are, after all, a true blue Hyderabadi.

Woman as countries

Source: E-mail forward

Between the ages of 15 - 18 a woman is like China or Iran. Developing at a sizzling rate with a lot of potential but as yet still not free or open.

Between the ages of 18 - 21 a woman is like Africa or Australia. She is half-discovered, half-wild and naturally beautiful with bush land around the fertile deltas.

Between the ages of 21 - 30 a woman is like America or Japan. Completely discovered, very well developed and open to trade especially with countries with cash or cars.

Between the ages of 30 - 35, she is like India or Spain. Very hot, relaxed and convinced of its own beauty.

Between the ages of 35 - 40 a woman is like France or Argentina. She may have been half destroyed during the war but can still be a warm and desirable place to visit.

Between the ages of 40 - 50 she is like Yugoslavia or Iraq. She lost the war and is haunted by past mistakes. Massive reconstruction is now necessary.

Between the ages of 50 - 60 she is like Russia or Canada. Very wide, quiet and the borders are practically un-patrolled but the frigid climate keeps people away.

Between the ages of 60 - 70 a woman is like England or Mongolia. With a glorious and all conquering past but alas no future.

After 70, they become like Afghanistan. Everyone knows where it is, but there’s no f***ing way you’re going to go there.

Men are from Mars and Women from Venus

Source: E-mail forward


Her Side of the Story :
==============
He was in an odd mood Saturday night. We planned to meet at a pub for a drink. I spent the afternoon shopping with the girls and I thought it might have been my fault because I was a bit later than I promised, but he didn’t say anything much about it. The conversation was very slow going so I thought we should go off somewhere more intimate so we could talk a bit more privately. We went to this restaurant and he was STILL acting a bit funny. I tried to cheer him up and started to wonder whether it was me or something else. I asked him, and he said no. But I wasn’t really sure. So anyway, in the car on the way back home, I said that I loved him deeply and he just put his arm around me. I didn’t know what the hell that meant because you know he didn’t say it back or anything, this is really worrying me. We finally got back home and I was wondering if he was going to leave me! So I tried to get him to talk but he just switched on the TV, and sat with a distant look in his eyes that seemed to say it’s all over between us. Reluctantly, I said I was going to go to bed. Then after about 10 minutes, he joined me and to my surprise, he responded to my advances . But, he still seemed really distracted, so afterwards I just wanted to confront him but I just cried myself to sleep. I just don’t know what to do anymore. I mean, I really think he’s seeing someone else and that my life is a disaster.

His Side of the Story:
==============
India lost to Pakistan

Monday, December 11, 2006

The Cat









This cat was there on the tree, happily taking a nap. As if it is least bothered about what is happening around her. When I went near her, she warned me....dare you come near and bother me. I respected its privacy and held back. She was however has to retreat when some people working there decided to play spoil sport.

Tuesday, December 05, 2006

At the Restaurant - Breach





These are the pictures from Breech, Mylapore Chennai. It is a fast food joint, selling Sandwiches, Burgers Hot dogs etc. Always bearing a deserted look, not many visit the place. Quality of food is not exceptional, prices are reasonable.