Monday, February 28, 2011

The Excel BIN2HEX Function

Basic Description
Hexadecimal (base 16), decimal (base 10), octal (base 8), and binary (base 2) are the most commonly used numeral systems in engineering and computing. Therefore, Excel has provided functions to convert numeric values to and from each of these systems.

The Excel Bin2Hex function converts a Binary (Base 2) number into a Hexadecimal (Base 16) number.

The format of the function is :

BIN2HEX( Number, [Places] )
Where :

- The Number argument is the binary number that is to be converted to hexadecimal
and - The [Places] argument is an optional argument, which specifies the number of characters that you want the returned hexadecimal number to have. If this is greater than the minimum, the hexadecimal number will be padded out using leading zeros.
If omitted, the returned hexadecimal uses the minimum number of places.

Note that the Number argument must be no more than 10 characters (40 bits) long. The most significant bit of this value denotes the sign of the number and the remaining 39 bits denote the magnitude. Negative numbers are represented using two's complement notation.





Common Errors
If you get an error from your Excel Bin2Hex function this is likely to be one of the following :

#VALUE! - Occurs if the supplied Places argument is not recognised as a number
#NUM! - Occurs if either: - the supplied Number argument is not recognised as a binary number or contains more than 10 characters
or
- the resulting hexadecimal number requires more places than is specified by the supplied Places argument
or
- the supplied Places argument ≤ 0

#NAME? - Occurs when Analysis ToolPak add-in is not enabled in your Excel.
You will need to enable the add-in if you want to use the Excel engineering functions.

To do this in Excel 2003 :

•From the Tools drop-down menu, select the option Add-Ins ...
•An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK
To do this in Excel 2007 :

•Click the Microsoft button on the top left of your spreadsheet and select the Excel Options button
•From the menu on the left hand side, select Add-Ins
•In the 'Manage:' box, select Excel Add-ins and click Go...
•An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK

IPTV is future TV technology


What is IPTV?
Internet Protocol Television (IPTV) is a technology based on delivering programs to your home through the Internet rather than traditional methods such as Cable, Satellite or Antenna. This is made possible by connecting your TV set to a set top box. This box also connects to your high speed internet connection and receives an encoded signal from the IPTV service.

Thursday, February 24, 2011

280 lac cror of Indian money is deposited in swiss banks.

"Indians are poor but India is not a poor country".
Say one of the swiss bank directors.
He says that "280 lac crore" of Indian money is deposited in swiss banks.
It can be used for 'taxless' budget for 30 years.
It can give 60 crore jobs to all Indians.
From any village to Delhi 4 lane roads.
Forever free power suply to more than 500 social projects.
Every citizen can get monthly 2000/- for 60 yrs.
No need of World Bank & IMF loan.

Think how our money is blocked by rich politicians.
We have full right against corrupt politicians.

Free Education and Free hostel for Handicapped/Physically Challenged children

Free Education and Free hostel for Handicapped/Physically Challenged children.
Contact:- 9842062501 & 9894067506.

Campus for engineering students

Engineering Students can register in www.campuscouncil.com to attend Off Campus for 40 Companies.

Need Blood and donor adress?

Where you can search for any BLOOD GROUP, you will get thousand's of donor address. www.friendstosupport.org

RED SOCIETY for begging children

If you see children Begging anywhere in INDIA , please contact:
"RED SOCIETY" at 9940217816. They will help the children for their studies.

Heights of Coincidenc​e

Lincoln's name has 7 letters
- Kennedy's name has 7 letters

- In Lincoln's & Kennedy's names the vowels & consonants fall in exactly the same place;***
in the order c, v, c, c, v, c, c

- Lincoln was elected to Congress in 1846
- Kennedy was elected to Congress in 1946

- Lincoln was elected president in 1860
- Kennedy was elected president in 1960

- Kennedy had a secretary named Lincoln

- War was thrust upon Lincoln almost immediately after inauguration
- War was thrust upon Kennedy almost immediately after inauguration

- Lincoln ordered the Treasury to print its own money
- Kennedy ordered the Treasury to print its own money

- International bankers may have arranged the assassinations of Lincoln and Kennedy

- Lincoln gave negroes freedom and legalized equality
- Kennedy enforced equality for negroes

- Lincoln delivered the Gettysburg Address on November 19, 1863
- Kennedy was assassinated on November 22, 1963

- Lincoln was loved by the common people and hated by the establishment
- Kennedy was loved by the common people and hated by the establishment

- Lincoln was succeeded, after assassination, by vice-president Johnson
- Kennedy was succeeded, after assassination, by vice-president Johnson

- Andrew Johnson was born in 1808
- Lyndon Johnson was born in 1908

- Andrew Johnson's name has 13 letters
- Lyndon Johnson's name has 13 letters

- Andrew Johnson had a pug nose and slicked-back hair
- Lyndon Johnson had a pug nose and slicked-back hair

- Lincoln was sitting beside his wife when he was shot
- Kennedy was sitting beside his wife when he was shot

- Rathbone, who was with Lincoln when he was shot, was injured (by being stabbed)
- Connally, who was with Kennedy when he was shot, was injured (by being shot)
- Rathbone's name has 8 letters
- Connally's name has 8 letters

- Lincoln's wife held his head in her lap after he was shot
- Kennedy's wife held his head in her lap after he was shot

- Lincoln was shot on a Friday
- Kennedy was shot on a Friday

- Lincoln was shot in a theatre named Ford
- Kennedy was shot in a car made by Ford

- Kennedy was shot in a car named Lincoln

- Lincoln's bodyguard was away from his post at the door of the President's box at the theatre
- Kennedy's bodyguards were away from their posts on the running-boards of the President's car

- Lincoln was shot in a theatre and his assassin ran to a warehouse
- JFK was shot from a warehouse and his alleged assassin ran to a theatre

- Lincoln's assassin had a three-worded name, John Wilkes Booth
- Kennedy's alleged assassin had a three-worded name, Lee Harvey Oswald

- John Wilkes Booth has 15 letters
- Lee Harvey Oswald has 15 letters

- John Wilkes Boothe was born in 1839
- Lee Harvey Oswald was born in 1939

- Lincoln didn't die immediately after being shot
- Kennedy didn't die immediately after being shot

- Lincoln and Kennedy died in places beginning with the initials P and H
- Lincoln died in Petersen's house
- Kennedy died in Parkland Hospital

- Booth was shot and killed* in police custody before going to trial
- Oswald was shot and killed in police custody before going to trial

- Kennedy's funeral was modelled on Lincoln's funeral

- Andrew Johnson was a heavy drinker with crude behaviour
- Lyndon Johnson was a heavy drinker with crude behaviour

- There were conspiracy theories that Johnson was knowledgeable about Lincoln's assassination
- There were conspiracy theories that Johnson was knowledgeable about Kennedy's assassination**

- Days before it happened Lincoln told his wife and friends about a dream he'd had of being shot by an assassin
- Hours before it happened Kennedy told his wife and friends it would be easy for an assassin to shoot him from a crowd

- Shortly after Lincoln was shot the telegraph system went down
- Shortly after Kennedy was shot the telephone system went down

- Kennedy's father had been the Ambassador to England at the Court of St James
- Lincoln's son became the Ambassador to England at the Court of St James
- Lincoln and Kennedy were 2 of the greatest presidents of the nation
- Lincoln's wife tastefully and expensively re-decorated the White House
- Kennedy's wife tastefully and expensively re-decorated the White House
- Lincoln loved great literature and could recite poetry by heart
- Kennedy loved great literature and could recite poetry by heart
- Lincoln had young children while living at the White House
- Kennedy had young children while living at the White House
- Lincoln's sons had ponies they rode on the White House grounds
- Kennedy's daughter had a pony she rode on the White House grounds
- Lincoln lost a child (12 year old son) to death while President
- Kennedy lost a child (newly born son) to death while President
- Lincoln had 2 sons named Robert and Edward. Edward died young and Robert lived on.
- Kennedy had 2 brothers named Robert and Edward. Robert died young and Edward lived on
- Lincoln let his children run and play in his office
- Kennedy let his children run and play in his office
- After Lincoln's assassination the nation experienced an emotional convulsion
- After Kennedy's assassination the nation experienced an emotional convulsion
- the whole world cried when Lincoln died
- the whole world cried when Kennedy died
- Lincoln's funeral train travelled from Washington-DC to New York
- Kennedy's brother's funeral train travelled from New York to Washington-DC
- Lincoln Assassination conspiracy theories are believed these 140 141 years later
- Kennedy Assassination conspiracy theories are believed these 42 43 years later
- Abraham was the first name of the man who filmed Kennedy's murder in the Lincoln
- The man running alongside Kennedy's car snapping pictures with his 35mm camera was a salesman of Lincoln cars
- Kennedy bought a Virginia home that was the 1861 Civil War headquarters of Lincoln's first general-in-chief, McClellan
- Jefferson Davis was the name of the president of the Confederate states while Lincoln was president of the Union states
- Jefferson Davis Tippit was the name of the police officer killed allegedly by Kennedy's alleged assassin
- Lincoln was famous for his wit and for telling hilarious stories and anecdotes
- Kennedy was famous for his wit and for telling hilarious stories and anecdotes
- Lincoln was sitting in a rocking chair at Ford's Theater when he was shot
- Kennedy had a special rocking chair he sat in at the White House
- Henry Ford bought the rocking chair Lincoln died in and put it in his museum in Dearborn
- Kennedy's seat in the Lincoln he was sitting in when he was shot is in Ford's museum
- Lincoln's seat in the Ford he was sitting in when he was shot is in Ford's museum
- John Kennedy is the name of a character in a 1951 movie about a detective travelling by train to thwart the assassination of President Lincoln ----NEW
- John Kennedy is the name of the real-life detective who travelled in the train with President Lincoln in 1860 to thwart his assassination

100 Benefits of Meditation

Physiological benefits:
1. It lowers oxygen consumption.
2. It decreases respiratory rate.
3. It increases blood flow and slows the heart rate.
4. Increases exercise tolerance.
5. Leads to a deeper level of physical relaxation.
6. Good for people with high blood pressure.
7. Reduces anxiety attacks by lowering the levels of blood lactate.
8. Decreases muscle tension
9. Helps in chronic diseases like allergies, arthritis etc.
10. Reduces Pre-menstrual Syndrome symptoms.
11. Helps in post-operative healing.
12. Enhances the immune system.
13. Reduces activity of viruses and emotional distress
14. Enhances energy, strength and vigour.
15. Helps with weight loss
16. Reduction of free radicals, less tissue damage
17. Higher skin resistance
18. Drop in cholesterol levels, lowers risk of cardiovascular disease.
19. Improved flow of air to the lungs resulting in easier breathing.
20. Decreases the aging process.
21. Higher levels of DHEAS (Dehydroepiandrosterone)
22. Prevented, slowed or controlled pain of chronic diseases
23. Makes you sweat less
24. Cure headaches & migraines
25. Greater Orderliness of Brain Functioning
26. Reduced Need for Medical Care
27. Less energy wasted
28. More inclined to sports, activities
29. Significant relief from asthma
30. Improved performance in athletic events
31. Normalizes to your ideal weight
32. Harmonizes our endocrine system
33. Relaxes our nervous system
34. Produce lasting beneficial changes in brain electrical activity
35. Helps cure infertility (the stresses of infertility can interfere with the release of hormones that regulate ovulation).
Psychological benefits:
36. Builds self-confidence.
37. Increases serotonin level, influences mood and behaviour.
38. Resolve phobias & fears
39. Helps control own thoughts
40. Helps with focus & concentration
41. Increase creativity
42. Increased brain wave coherence.
43. Improved learning ability and memory.
44. Increased feelings of vitality and rejuvenation.
45. Increased emotional stability.
46. improved relationships
47. Mind ages at slower rate
48. Easier to remove bad habits
49. Develops intuition
50. Increased Productivity
51. Improved relations at home & at work
52. Able to see the larger picture in a given situation
53. Helps ignore petty issues
54. Increased ability to solve complex problems
55. Purifies your character
56. Develop will power
57. Greater communication between the two brain hemispheres
58. Respond more quickly and more effectively to a stressful event.
59. increases ones perceptual ability and motor performance
60. Higher intelligence growth rate
61. Increased job satisfaction
62. Increase in the capacity for intimate contact with loved ones
63. Decrease in potential mental illness
64. Better, more sociable behaviour
65. Less aggressiveness
66. Helps in quitting smoking, alcohol addiction
67. Reduces need and dependency on drugs, pills & pharmaceuticals
68. Need less sleep to recover from sleep deprivation
69. Require less time to fall asleep, helps cure insomnia
70. Increases sense of responsibility
71. Reduces road rage
72. Decrease in restless thinking
73. Decreased tendency to worry
74. Increases listening skills and empathy
75. Helps make more accurate judgments
76. Greater tolerance
77. Gives composure to act in considered & constructive ways
78. Grows a stable, more balanced personality
79. Develops emotional maturity
Spiritual benefits:
80. Helps keep things in perspective
81. Provides peace of mind, happiness
82. Helps you discover your purpose in life
83. Increased self-actualization.
84. Increased compassion
85. Growing wisdom
86. Deeper understanding of yourself and others
87. Brings body, mind, and spirit in harmony
88. Deeper Level of spiritual relaxation
89. Increased acceptance of one self
90. Helps learn forgiveness
91. Changes attitude toward life
92. Creates a deeper relationship with your God
93. Increases the synchronicity in your life
94. Greater inner-directedness
95. Helps living in the present moment
96. Creates a widening, deepening capacity for love
97. Discovery of the power and consciousness beyond the ego
98. Experience an inner sense of Assurance or Knowingness
99. Experience a sense of Oneness
100. Leads to enlightenment