Thursday, September 27, 2007

Excel shortcut to paste a named cell in a formula




Simply click on the F3 button while in formula edit mode and get the dialog to paste named cells. Makes your life simpler with Excel tips.


Save people in an accident without worries

Please read below...now u can go ahead and help injured people without any fear!


Right to Emergency Care:
Date Of Judgment: 23/02/2007.
Case No.: Appeal (civil) 919 of 2007.

The Supreme Court has ruled that all injured persons especially in the case of road traffic accidents, assaults, etc., when brought to a hospital / medical centre, have to be offered first aid, stabilized and
shifted to a higher centre / government centre if required. It is only after this that the hospital can demand payment or complete police formalities. In case you are a bystander and wish to help someone in an accident, please go ahead and do so. Your responsibility ends as soon as you leave the person at the hospital.

The hospital bears the responsibility of informing the police, first aid, etc.

Please do inform your family and friends about these basic rights so that we all know what to expect and what to do in the hour of need.

Wednesday, September 26, 2007

Tip of the day

To insert a new sheet in Excel simply press ALT+SHIFT+F1

Tuesday, September 25, 2007

javascript cookies


function getCookie( name )
{
var start = document.cookie.indexOf( name + "=" );
var len = start + name.length + 1;
if ( ( !start ) && ( name != document.cookie.substring( 0, name.length ) ) )
{
return null;
}
if ( start == -1 )
{
return null;
}
var end = document.cookie.indexOf( ';', len );
if ( end == -1 )
{
end = document.cookie.length;
}
return unescape( document.cookie.substring( len, end ) );
}

function setCookie( name, value, expires, path, domain, secure )
{
var today = new Date();
today.setTime( today.getTime() );
if ( expires )
{
expires = expires * 1000 * 60 * 60 * 24;
}
var expires_date = new Date( today.getTime() + (expires) );
document.cookie = name+'='+escape( value ) +
( ( expires ) ? ';expires='+expires_date.toGMTString() : '' ) + //expires.toGMTString()
( ( path ) ? ';path=' + path : '' ) +
( ( domain ) ? ';domain=' + domain : '' ) +
( ( secure ) ? ';secure' : '' );
}

function deleteCookie( name, path, domain )
{
if ( getCookie( name ) ) document.cookie = name + '=' +
( ( path ) ? ';path=' + path : '') +
( ( domain ) ? ';domain=' + domain : '' ) +
';expires=Thu, 01-Jan-1970 00:00:01 GMT';
}

Dealers / Showrooms for Bajaj Bikes in Pune














NameAddressPhoneEmailFax
ASHWAMEGH BAJAJ (For 2 Wheelers)685/1,PUNE SATARA ROAD,BIBWEWADI Pune 411037(020)66424600,66424610ashwamegh@ip.eth.net4212401
BAJAJ AUTO LIMITED (For 2 & 3 Wheelers)122/124 NR KAMALNAYAN BAJAJ UDYAN,BOMBAY PUNE ROAD, WAKDEWADI Pune 411003(020)25824243,25824244,25824245vpbhand@bajajauto.co.in, balpunebranch@vsnl.in25824242
GEMS BAJAJ (For 2 & 3 Wheelers)PLOT NO. 92, M.I.D.C. BLOCK D-III,OPP. GREAVES (DEU) LTD., PUNE-MUMBAI ROAD, CHINCHWAD Pune 411019(020)56101609,66111911gemsauto55@hotmail.com7452296
GEMS BAJAJ (For 2 Wheelers)PLOT NO. 59, INDRAPRASTHA SOCIETY,NEXT TO ALL INDIA RADIO, SHOLAPUR ROAD, HADAPSAR(020)25124248,26996353d10139@baldealer.com4001355
SAISERVICE BAJAJ (For 2 & 3 Wheelers)VEER SAVARKAR UDYOG BHAVAN,NEAR BALGANDHARVA RANG MANDIR,S Pune 411005(020)25532254,25536305sai.service@gnpun.global.net.in5538145
SAISERVICE BAJAJ (For 2 & 3 Wheelers)S.NO.470/2 EP 469/5-B,NEXT TO SANDVIK (PHUGEWADI) Pune 411012(020)30681440,30681441,30681442sai.vsb@gnpun.global.net.in7145264
SUPER BAJAJ (For 3 Wheelers Only)SHIVNERI CHAMBERS,445 & 446 GULTEKADI Pune 411037(020)30933699,30933799,32908999
SHIRODE BAJAJ (For 2 Wheelers)1196 / B, SHRISHTRI CHAMBERS,GHOLE ROAD, SHIVAJI NAGAR Pune 411005(020)30285151,30289349gnspune@gmail.com
SAISERVICE BAJAJ (For 2 Wheelers)KEDAR EMPIRE > NEAR DASHBHUJA GANPATI MANDIR,OPP FLYOVERKARVE ROAD > KOTHURD Pune 411038(020)25456652,25456692saleskothrud@saiservicestation.com25467076
GEMS BAJAJ (For 2 Wheelers)LALWANI PRESTIGE VIMAN NAGAR CORNER,NAGAR ROAD Pune 411014(020)25120634,25120635d10139@baldealer.com
GEMS BAJAJ (For 2 Wheelers)THE FORUM,PADMAVATI CORNER, PUNE SATARA ROAD Pune 411037(020),24232556/7/8/9d10998@baldealer.com

Friday, September 14, 2007

Very Shocking.....

This is a story of a young college girl who passed away last month in Chandigarh. Her name was Priya. She was hit by a truck.

She was working in a call center. She had a boy friend named Shankar. Both of them were true lovers. They always talked on the phone. You used to be never found without her without hand phone. In fact she
also Changed her cell connection from Airtel to Hutch, so that both of them can be on the same network, and save on the cost.

She used to spend half of the day talking with Shankar. Priya's family knew about their relationship. Shankar was very close to Priya's family as well. (Just imagine their love). Before she passed away she always told her friends "If I pass away Please burn me with my hand phone" she also said the same thing to her Parents.

After her death, people couldn't carry her body, A lot of them tried to
do so But still cant everybody had tried to carry the body, the results were
the Same. Eventually, they called a person known to one of their neighbours, who Can speak with the soul of dead person and who was a friend of her father.

He took a stick and started speaking to himself slowly.

After a few minutes, he said "this girl misses something here." Then her
Friends told that person about her intentions to burn her with her
phone. He then opened the grave box and place her phone and sim card inside the Casket. After that they tried to carry the body. It was then moved easily And they then carried her into the van.

All of us were shocked. Priya's parents did not inform Shankar that
Priya had passed away.
After 2 weeks Shankar called Priya's mom.....

Shankar:...."Aunty, I'm coming home today. Cook something nice for me.
Don't tell Priya that I'm coming home today, I wanna surprise her."
Her mother replied..... "You come home first, I wanna tell you something
Very important."
After he came, they told him the truth about Priya.
Shankar thinks That they were playing a fool. He was laughing and said "don't try to fool Me-tell Priya to come out, i have a gift for her. Please stop this Nonsense".

Then they show him the original death certificate to him.
They gave him proof to make him believe. (Shankar started to sweat) He
said... "It's not true. We spoke yesterday. She still calls me.
Shankar was shaking.

Suddenly, Shankar's phone rang. "See this is from Priya, see this...."
He showed the phone to priya's family. All of them told him to answer.
He talked using the loudspeaker mode.

All of them heard his conversation.

Loud and clear, no cross lines, no humming.

It is the actual voice of Priya & there is no way others could use her
sim Card since it is nailed inside the grave box they were so shocked and asked For the same person's (Who can speak with the soul of deal persons) help again. He brought his Master to solve this matter.

He & his master worked for 5 hours.

Then they discovered one thing which really shocked them...

Hutch has the best coverage.

"Where ever you go, our network follows!!!" (hutch's punch line)

Don't shout at me I am also looking for the person who has sent me this
stuff....so what you can do...you should also forward this link to all
your
Nears and dears...and enjoy...like i enjoyed. HAHAHAHAH

How to add a custom field in pivot tables


Often its needed we to add a field that calculated and not comming from the data table.

We can add it to the pivot table by the following way.

First create the data in Excel

img
now create a pivot table
select a cell in the pivot table
on the pivot table click on the pivot table button-> Formulas-> Custom Field
img
Add the name of the field and the calculations below it and then click on the add button

img
Voliait appears as a field in your list, ready to be added as you want.
img

Sunday, September 09, 2007

How to take amazing sunset pictures


Sunset normally is a fascinating scene, but pretty difficult to take great pictures of the sunset.
Below I will show you some points to consider to convert the normal sunset pictures to amazing sunset pictures.


A clear sky would have made a pretty dull picture adding some buildings and trees enhances the beauty

You need 4 things to take an amazing sunset picture.
1. A sun about to set (give or take 30 min)
2. Camera
3. Clouds or some object like a bridge, tree, building etc
4. Pollution (yes no jokes the red color of the sunset will come from dust pollution)

Point 1. Dont focus the sun, these pictures will be ok but none "WOW", they will be clean but nor impressive.

No pollution makes the sky look so dull, also focus on the sun doesnt make the picture interesting

Point 2. If there are clouds then wait for the sun to set, Colors of the clouds will be amazing after the sun sets, before that it will be mostly white and uninteresting

No clouds makes the sky pretty dull

Point 3. If there are no clouds then focus something in the foreground so that the sun typically hides behind the object, the shadow effect will be amazing.


Clouds make the scene pretty interesting but still additional objects make it even better like the one below

Point 4. Simple Common sense prevails, ie if the sky is more beautiful then you want to draw attention to the sky, else you want to draw attention to the objects.

Wednesday, September 05, 2007

Worst sound in the world

So What's the worst sound in the world?
The choice what first comes to mind is the grinding whine of a dentist's drill or a beginning violin student? Not even close, according to researchers who made the website http://sound101.org which asked users to hear the sounds and rate them, with a significantly large size of over a million across the world and across the age groups and across genders the worst sound is the sound of someone else vomiting.

Saturday, September 01, 2007

How people say Sorry..according to their sunsign

The way people apologise and their style of saying sorry depends a lot
on their personality and zodiac traits. No wonder Leos embarrass you
when they say sorry while Arians will actually annoy you with their
apology?..

Aries: For starters, Arians think they are so sweet,they could not have
possibly said or done things that need an apology. So in the unlikely
possibility of them actually going down their knees to apologise, it
will be a simple sorry.Nothing less, nothing more.

Taurus: They are so scared to face others when they make a mistake that
by the time they resurface to tender an apology, the damage is done. So
Taurans end up making foes out of friends because of their laxity in
apologizing.

Gemini: Geminis think they are infallible and therefore will never
really apologise for anything. But once they realize, they prefer to act
as if nothing happened, and behave normally with people who have a
problem rather than remind others of the incident by tendering an apology.


Cancer: Cancerians will make you feel sorry for demanding one when
they make a mistake. They are the legendary characters that burn hands
and slash their fingers! in order to display the quantum of their
repentance. Their repentance is dangerous.


Leo: Leos are a delightful bunch even when they are trying to make up
for their follies. They will go down their knees, buy flowers, put up
sorry posters.. do everything colorful to flatter you and make up for
their mistakes. In fact it's fun to induce them to make a mistake and let
them apologize for it.


Virgo: Virgos will first formally set aside a time and date and inform
them what they want to tell you. Then they will mentally prepare
themselves to talk out the same things. They will finally draft the
script and read out whatever they want to. In short, even their heartfelt
apologies sound like well-drafted scripts.


Libra: They are very vocal once they realize their folly. They never
ever hesitate to come clean and admit their mistakes. In fact, they will
go out of their way to convince you about how genuinely sorry they are.


Scorpio: Scorpios are formal and think that tendering an apology is
more of a formality. So instead of just saying sorry, they will send a
formal mail or send a card, whatever it takes to avoid direct
confrontation.


Sagittarius: Sagittarians don't believe in being sorry or apologizing.
For them, it is human to err and therefore saying sorry is just
redundant. Interestingly, even if others make mistakes,
they are pretty cool and don't expect much from them.

Capricorn: They can't take a simple sorry. They need
reasons,explanations, written letters and the works to get elicit an 'ok, you may go now'
phrase. They are hard to please and even harder
to appease.


Aquarius: They are sweet, genuine and innovative when they think they
are wrong and need to undo the damage.Aquarians are easy on their
mistakes and don't take too much time to do
their sorrying.


Pisces: Pisceans don't easily give in because they believe that
everything is about perspective. So if somebody thinks they made a mistake! ,
it's because they have a wonky perspective. Pisceans and apologies? No
chance!!!

Source: 1


Teacher asked all students to write an essay on the topic "A Poor Family".


One student gets the lowest marks for writing that essay.











Web Hosting Cheap PHP Plans Also at For free flags of the world