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
Thursday, January 27, 2011
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.
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;
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;
Subscribe to:
Posts (Atom)