Infolinks In Text Ads

Wednesday, April 25, 2012

Hot Summer Makes People Worst

Summer brings out the worst in people; some days it feels as if the temperature rises one more degree. A seasonal raise in violent crime may be due to discomfort and irritability, but can the weather actually drive you crazy?

It depends on how hot it is, and whether you're mentally stable to begin with. Intense heat increases the risk of dehydration, and even mild dehydration can affect the brain. As per experiment and study done with two dozen college-age men has found that a loss of 1 percent body mass via exercise-induced sweating (replaceable with three glasses of water) decreased their cognitive performance and increased levels of anxiety.

Dramatic overheating can also lead to heatstroke, symptoms of which progress from confusion and irritability to hallucinations, violent behavior. In animal models, overheating causes some neurons to become more excitable, which might underlie the psychiatric effects. Most of these are transient—cool off and they go away—but heatstroke may lead to long-term brain damage. (It can also kill you.) You won't keep hallucinating for years to come, but you might end up a little clumsy or slur your speech. Case reports of long-lasting personality changes (similar to those caused by traumatic brain injury) also exist, but this complication appears to be rare.

Easing into the muggy weather makes heatstroke less likely, this may be why sudden hot snaps have been specifically linked to increased suicide rates. In South Australia, it has been found that hospital admissions for mental disorders increased at temperatures of 80 degrees or above, with schizophrenics being at especially high risk.

Tuesday, April 24, 2012

Letter Jokes

Humorous jokes in writing a leave letter

1. Infosys, Bangalore: An employee applied for leave as follows:
Since I have to go to my village to sell my land along with my wife, please sanction me one-week leave.

2. This is from Oracle Bangalore: From an employee who was performing the "mundan" ceremony of his 10 year old son:
"as I want to shave my son's head, please leave me for two days.."

3. Another gem from CDAC. Leave-letter from an employee who was performing his daughter's wedding:
" as I am marrying my daughter, please grant a week's leave.."

4. >From H.A.L. Administration dept:
"As my mother-in-law has expired and I am only one responsible for it, please grant me 10 days leave."

5. Another employee applied for half day leave as follows:
"Since I've to go to the cremation ground at 10 o-clock and I may not return, please grant me half day casual leave"

6. An incident of a leave letter
"I am suffering from fever, please declare one day holiday."

7. A leave letter to the headmaster:
"As I am studying in this school I am suffering from headache. I request you to leave me today"

8. Another leave letter written to the headmaster:
"As my headache is paining, please grant me leave for the day."

9. Covering note:
"I am enclosed herewith..."

10. Another one:
"Dear Sir: with reference to the above, please refer to my below..."

11. Actual letter written for application of leave:
"My wife is suffering from sickness and as I am her only husband at home I may be granted leave".

12. Letter writing: -
" I am in well here and hope you are also in the same well."

13. A candidate's job application:
"This has reference to your advertisement calling for a ' Typist and an Accountant - Male or Female'...
As I am both(!! )for the past several years and I can handle both with good experience, I am applying for the post."

Wednesday, April 18, 2012

Sum and count IF in same Function (CountIFS)

This can be use more in cricket stats to identify the count of 50's & 100's made by the player, while using the countif only the value greater then 50 comes, to ignore the score more than 100's.

Formula for counting 50's and 100's :
For 50's and not counting 100's : = COUNTIFS(F4:F135,">=50",F4:F135,"<100") for 100's : = COUNTIF(F4:F135,">=100")

COUNTIFS Explaination:
The COUNTIFS function, similar to Excel's COUNTIF function, counts up the number of times data in two or more ranges of cells meets multiple criterion.

The syntax for the COUNTIFS function is:
=COUNTIFS( Criteria_range-1, Criteria-1, Criteria_range-2, Criteria-2, ...)

Criteria_range - the group of cells the function is to search.
Criteria - determines whether the cell is to be counted or not.
Note: Up to 127 range/criteria pairs can be entered into the function.

The ranges must be of identical size, and the function only counts instances where the criterion for each range is met simultaneously - such as in the same row.