Friday, September 23, 2011

Excel remove blank rows

If you have a blank row on every other row in excel, there is an easy way of getting rid of it.

select the entitre column or the range of cells,

hist f5, select special, select blanks and hit okay

now the every blank row will be highlighted.

From the edit menu, select delete. You are all set

Friday, March 25, 2011

Perl check for empty string

To check if string is empty (with multiple spaces)

my $product =" ";

if(defined($product) && $product!~( /^\s*$/ )){

print ("This is Not a balnk product");

}else{

print ("This is a balnk product");
}

Friday, March 18, 2011

All about Heart

All about heart

I have been reading this book called Human Body : Cardovascualr system. This book is basically journey inside your heart. Heart is one most crucial organs of the human body it is the #1 killer in united states.

If you heart cannot function or cannot pump blood, you body will shutdown. Human body is made up of 2 trillion cells and they constantly need
oxygenated blood supply to be able to do their job. This book made so many things clear about heart. You will find fascinating facts about
open heart surgery, bypass graft surgery, Valve replacement, Heart Attack, ECG / EKG, MRI, Arrhythmia, blocked arteries, angiography, Pace makers, ICD's, heart lung machine etc.
Do you know our heart produces electricity (in sinoatrial node).. to make your heart beat..!!! Amaaaaazing..!

Here is some key differences between Pacemakes and ICD's

1. ICDs stay inactive until it detects fibrillation of the heart thus it is activated only in urgent need while the pacemaker can consistently and continuously stimulates the heart electrically to beat in a regular rhythm.

2. Pacemakers are predominantly used to treat slow heart rhythms while ICDs are used for patients who are at risk of sudden cardiac death.

3. ICDs are slightly larger in size, and rather more advanced, compared to pacemakers.

4. Pacemakers aim more to make the patients feel better while ICDs – without bi-ventricular pacing capabilities – will not improve patients’ function because it will only act as protection from sudden cardiac arrest.

Friday, March 11, 2011

Show hidden files on windows

To see hidden files:

1.
On the Tools menu in Windows Explorer, click Folder Options.

2.
Click the View tab.

3.
Under Hidden files and folders, click Show hidden files and folders.


Note To access Windows Explorer, click Start, point to All Programs, and then click Windows Explorer.

Friday, March 4, 2011

Unix cut and count

Unix cut and sort on a column and count number of instances.. very handy

cut -d "|" -f3 pbt_pending_trans.out | sort | uniq -c > uniq_tran_count.txt

Thursday, March 3, 2011

Edit Plus sort and remove dups

This is the the most useful function in Edit Plus. I was using unix cut and sort commands to sort and remove duplicates from a file, however this is convenient from the editor.

Copy and paste the list of rows you would like to remove dups from and
from the main menu, select

Tools -> sort -> check remove duplicates


Thursday, February 17, 2011

Call perl script fom other perl script

$syscommand = "/root/dir_name/shell/fileName.pl";
print STDERR "Running fileName.pl\n";
$ret = system($syscommand);
if ($ret != 0){
print STDOUT "Error running fileName.pl\n";
exit(-1);
}

Thursday, January 27, 2011

Excel Shortcut to insert a New Row

Excel short cust to insert a row

Lately, I have been trying to use as many Excel keyboard shortcuts as I can (not only for productivity, but for ergonomic reasons). I haven't found a quick keyboard shortcut to insert a new row or column, but there is a two-step process that is quite convenient:

Shift+SpaceBar = Select the current row
Ctrl+Shift+PlusSign = Insert row(s)
To insert a new column, in step 1 use Ctrl+SpaceBar to select the current column. To insert more than one row or column at a time, use the arrow keys as you hold Shift before going

Monday, January 24, 2011

Anatomy of Blood

Source : http://www.ivy-rose.co.uk/HumanBody/Blood/Blood_StructureandFunctions.php


1.

The Functions of Blood
(generally - as opposed to the functions of particular components of blood).
2.

The Composition of Blood
(incl. the different types of blood cells and their properties and functions).
3.

Process of Oxygenation of Tissues due to Circulation of Blood
4.

Types of Leucocytes (White Blood Cells)


1. Functions of Blood


Transports:

Dissolved gases (e.g. oxygen, carbon dioxide);

Waste products of metabolism (e.g. water, urea);

Hormones;

Enzymes;

Nutrients (such as glucose, amino acids, micro-nutrients (vitamins & minerals), fatty acids, glycerol);

Plasma proteins (associated with defence, such as blood-clotting and anti-bodies);

Blood cells (incl. white blood cells 'leucocytes', and red blood cells
'erythrocytes').
2. Maintains Body Temperature

3. Controls pH. The pH of blood must remain in the range 6.8 to 7.4, otherwise it begins to damage cells.

4.Removes toxins from the body

The kidneys filter all of the blood in the body (approx. 8 pints), 36 times every 24 hours. Toxins removed from the blood by the kidneys leave the body in the urine.
(Toxins also leave the body in the form of sweat.)
5.

Regulation of Body Fluid Electrolytes

Excess salt is removed from the body in urine, which may contain around 10g salt per day
(such as in the cases of people on western diets containing more salt than the body requires).

2. Composition of Blood

Blood consists of many components (constituents).
These include:
55% Plasma

45% Components, i.e. 'Blood Cells'.

Of these, 99% are erythrocytes (red blood cells) and 1% are leucocytes (white blood cells) and thrombocytes (blood platelets).


The summary chart above includes: erythrocytes (red blood cells), thrombocytes (blood platelets) and leucocytes (white blood cells). It also includes categories of leucocytes: agranulocytes and granulocytes (also known as polymorphonucleocytes), which may also be sub-divided into lymphocytes, monocytes, basophils, neutrophils and eosinophils.


The following table includes further general information about the constituents of blood.

Structure

Functions

Plasma

Normal blood plasma is 90-92 % water.
This is the straw-coloured fluid in which the blood cells are suspended, and consists of:

The medium in which the blood cells are transported around the body (by the blood vessels) and are able to operate effectively.

Helps to maintain optimum body temperature throughout the organism.

Helps to control the pH of the blood and the body tissues, maintaining this within a range at which the cells can thrive.

Helps to maintain an ideal balance of electrolytes in the blood and tissues of the body.


Dissolved substances including electrolytes such as sodium, chlorine, potassiun, manganese, and calcium ions;

Blood plasma proteins (albumin, globulin, fibrinogen);

Hormones.
Erythrocytes
(Red blood
cells)

Immature erythrocytes have a nucleus but mature erythrocytes have no nucleus.

Carry oxygen (process described in more detail - below).

Haem

Erythrocytes have a "prosthetic group" (meaning "in addition to" - in this case, in addition to the cell). The active component of this prosthetic group is Haem.

Haem relies on the presence of iron (Fe).

Haem combines with oxygen to form oxyhaemoglobin:

... continued in section below.


Erythrocytes are eventually broken down by the spleen into the blood pigments bilinubin and bilviridin, and iron. These components are then transported by the blood to the liver where the iron is re-cycled for use by new erythrocytes, and the blood pigments form bile salts. (Bile breaks down fats.)


Have a longevity of approx. 120 days.


There are approx. 4.5 - 5.8 million erythrocytes per micro-litre of healthy blood (though there are variations between racial groups and men/women).



Leucocytes
(White blood
cells)


There are different types of leucocytes (described in more detail - below), classified as:

Granular: e.g. Neutrophils, Eosinophils, Basophils.

Agranular (do not contain granules): e.g. Monocytes, Lymphocytes.


Major part of the immune system.


Have a longevity of a few hours to a few days (but some can remain for many years).


There are approx. 5,000 - 10,000 leucocytes per micro-litre of blood.

Trombocytes
(Platelets)


Blood platelets are cell fragments;




To facilitate blood clotting - the purpose of which is to prevent loss of body fluids.


Disk-shaped;





Diameter 2-4 um
(1 micro-metre = 1 um = 0.000001m);





Have many granules but no nucleus;





Have a longevity of approx. 5-9 days.





There are approx. 150,000 - 400,000 platelets per micro-litre of blood.







3. The Oxygenation of Blood

The oxygenation of blood is the function of the erythrocytes (red blood cells) and takes place in the lungs.
The sequence of events of the blood becoming oxygenated (in the lungs) then oxygenating the tissues (in the body) is as follows:



The Right Ventricle (of the heart) sends de-oxygenated blood to the lungs.



While in the lungs:
1. Carbon Dioxide diffuses out of the blood into the lungs, and
2. Oxygen (breathed into the lungs) combines with haemoglobin in the blood as it passes through the lung capillaries.



Oxyhaemoglobin returns to the heart via the pulmonary vein and then enters the systemic circulation via the aorta.



There is a low concentration of oxygen in the body tissues. They also contain waste products of the metabolism (such as carbon dioxide).



Due to the high concentration of oxygen in the blood and the low concentration of oxygen in the tissues,




... the high concentration of carbon dioxide in the tissues diffuses into the blood. (95% of this carbon dioxide dissolves in the blood plasma.)



Blood returns from the tissues back to the heart via the superior vena cava (from the upper-body) and the inferior vena cava (from the lower-body)


4. Types of Leucocytes (White Blood Cells)


Lymphocytes:


Monocytes:




*Basophils:


*Neutrophils:


*Eosinophils:

Approx. 24% of leucocytes are lymphocytes. These produce anti-bodies and include:
*T-Cells
*B-Cells
*Natural Killer Cells


Approx. 4% of leucocytes are monoocytes. These are also known as phagocytes.
They combat microbes by the process of phagocytosis.




60-70% of leucocytes are basophils.
Diameter 10-12 micro-metres.

Phagocytosis. Destruction of bacteria with lysozyme and strong oxidants.


2-4% of leucocytes are neutrophils.
Diameter 10-12 micro-metres.

Combat the effects of histamine in allergic reactions;
Phagocytize antigen-antibody complexes;
Destroy some parasitic worms.


0.5-1% of leucocytes are eosinophils.
Diameter 8-10 micro-metres.

Liberate heparin, histamine, and seratonin in allergic reactions, intensifying inflammatory response.





* It is only possible to observe the differences between these by staining them.

Further notes about the types of leucocytes identified above:
Lymphocytes:


The term "antigen" refers to something that is not naturally present and 'should not be in the body'.



T Cells (lymphocytes) are activated by the thymus gland.



B Cells (lymphocytes) are activated by other lymphoid tissue. The 'B' indicates 'bone marrow' cells.



Both T-cells and B-cells:
(1) destroy antigens, and
(2) produce 'memory cells' and anti-bodies.

Basophils:


An increased (higher than usual) percentage of basophils in the blood may indicate an inflammatory condition somewhere in the body.

Neutrophils & Monocytes:



Neutrophils are the first leucocytes to respond to bacterial invasion of the body. They act by carrying out the process of phagocytosis (see opposite), and also be releasing enzymes - such as lysozyme, that destroy certain bacteria.
Monocytes take longer to reach the site of infection than neutrophils - but they eventually arrive in much larger numbers.Monocytes that migrate into infected tissues develop into cells called wandering macrophages that can phagocytize many more microbes than neutrophils are able to.
Monocytes also clear up cellular debris after an infection.

Eosinophils:


An increased (higher than usual) percentage of eosinophils in the blood may indicate parasitic infection somewhere in the body.



Phagocytosis:


A phagocyte is a cell able to engulf and digest bacteria, protozoa, cells, cell debris, and other small particles. Phagocytes include many leucocytes (white blood cells) and macrophages - which play a major role in the body's defence system.


Phagocytosis is the engulfment and digestion of bacteria and other anigens by phagocytes.

This is illustrated below.

Wednesday, January 5, 2011

Stomach acid and alkaline watery

Alkaline Water and Stomach Acid

by Sang Whang

Among the people who question the validity of alkaline water, the biggest question is; "What happens to the alkaline water once it reaches the stomach, which is highly acidic?" People who have some knowledge of the human body, including medical doctors, ask this question. Let me answer that question once and for all to erase any doubts about the health benefits of alkaline water.

In order to digest food and kill the kinds of bacteria and viruses that come with the food, the inside of our stomach is acidic. The stomach pH value is maintained at around 4. When we eat food and drink water, especially alkaline water, the pH value inside the stomach goes up. When this happens, there is a feedback mechanism in our stomach to detect this and commands the stomach wall to secrete more hydrochloric acid into the stomach to bring the pH value back to 4. So the stomach becomes acidic again. When we drink more alkaline water, more hydrochloric acid is secreted to maintain the stomach pH value. It seems like a losing battle.

However, when you understand how the stomach wall makes hydrochloric acid, your concerns will disappear. A pathologist friend of mine gave me the following explanation. There is no hydrochloric acid pouch in our body. If there were, it would burn a hole in our body. The cells in our stomach wall must produce it on an instantly-as-needed basis. The ingredients in the stomach cell that make hydrochloric acid (HCl) are carbon dioxide (CO2), water (H2O), and sodium chloride (NaCl) or potassium chloride (KCl). NaCl + H2O + CO2 = HCl + NaHCO3, or

KCl + H2O + CO2 = HCl + KHCO3

As we can see, the byproduct of making hydrochloric acid is sodium bicarbonate (NaHCO3) or potassium bicarbonate (KHCO3), which goes into blood stream. These bicarbonates are the alkaline buffers that neutralize excess acids in the blood; they dissolve solid acid wastes into liquid form. As they neutralize the solid acidic wastes, extra carbon dioxide is released, which is discharged through the lungs. As our body gets old, these alkaline buffers get low; this phenomenon is called acidosis. This is a natural occurrence as our body accumulates more acidic waste products. There is, therefore, a relationship between the aging process and the accumulation of acids.

By looking at the pH value of the stomach alone, it seems that alkaline water never reaches the body. But when you look at the whole body, there is a net gain of alkalinity as we drink alkaline water. Our body cells are slightly alkaline. In order for them to produce acid, they must also produce alkaline, and vice versa;