Laboratory Tests
Electronic Health Records (EHR) have made it easier for families to access medical records but not all hospitals or provider practices use the same EHR system nor is it possible for records to all be compiled in one central system. Keeping medical information up-to-date in the medical binder provides assurance that healthcare providers have key information they need to make informed healthcare decisions.
Keep copies of ALL test results and keep a several copies of the most recent results in the medical binder and NEVER give out the original or last copy. Maintain a spreadsheet of lab results that can be filtered by date and by results. This is an extremely useful approach to review results over a span of time which is helpful to detect changes and potential trends with a click of a button.
Instructions for entering laboratory test results
- Date of Birth: Enter the date of birth in the cell (B1)
- Date of Test: Enter date of test in column (A)
- Age: The AGE in column (B) will auto-calculate in years
- Laboratory Test Results: Enter the value for each analyte (segment of each test being measured) within the appropriate column (ie enter the value of the WBC in the WBC column)
If you are unsure about which spreadsheet you should use to enter laboratory test results, reference the TEST BY ANALYTE document. The test by analyte columns can be filtered by ANALYTE to find the analyte tested or by SEGMENT to find the series of tests most commonly ordered by body function. Each column can be sorted by clicking the arrow at the top of the column. Or a filter can be added to look at a specific entry.
If you are unfamiliar with using Excel, Excel Easy offers a good online tutorial.
Reference Ranges: For your convenience we have created a listing of reference ranges for most commonly ordered tests, which includes age range, units of measurement and normal values by gender.
Please note all laboratory values listed are approximate. It is not uncommon for reference range values to vary from lab-to-lab. It is important to consult with your local laboratory for guidelines as to normal values for the specific testing procedures used.
My Lab Results Forms
Each of these Excel forms can be filtered by date, marker and value. The age of the individual should be entered cell (B1) in tab one in each spreadsheet. The individual's age will be calculated in column (B), after entering the date when the test was done in column (A). A graph of key test results are plotted in tab two of each form.
-
What is Measured:
Bicarbonate (HCO3)
PO2
Base Excess
Carbon Dioxide (CO2)
Hemoglobin
PhWhat is Plotted
• Bicarbonate
• O2 Sat -
What is Measured
B-type natriuretic peptide (BNP)
CK-BB Isoenzyme
CK-MB Isoenzyme
CK-MM Isoenzyme
Galectin-3 (BAL-3)
Homocysteine
Interleukin-6 (IL-6)
Myoglobin/ Blood
Myoglobin/ Urine
Pro B-type natriuretic peptide (Pro-BNP)
ST2
Troponin I
Troponin TWhat is Plotted
• BNP
• Nt-BNP -
What is Measured
Fibrinogen/ Factor I
INR
Platlets
PT
Thrombin Time (TT)
Antidiuretic Hormone/ Vasopressin (ADH)What is Plotted
• INR
• Fibrinogen/ Factor I -
What is Measured
Eosinophils
Hematocrit
Hemoglobin
Lymphocytes
Mean corpuscular hemoglobin (MCH)
Mean corpuscular hemoglobin concentration (MCHC)
Mean corpuscular volume (MCV)
Monocytes
Neutrophils
Platelets
Red blood cell distribution width (RDW)
Red Blood Cell Count (RBC)
White Blood Cell Count (WBC)
Reticulocyte countWhat is Plotted
• WBC
• Hematocrit
• Neutrophils%
• Lymphs%
• Monocytes%
• Neutrophils#
• Lymphs#
• Monocytes# -
What is Measured
Aldosterone
Cortisol
Dopamine
Epinephrine
NorepinephrineWhat is Plotted
• Cortisol -
What is Measured and Plotted
• Antidiuretic Hormone Vasopressin -
What is Measured and Plotted
Testosterone (total) -
What is Measured
A1C hemoglobin
Amylase
Glucagon
Glucose (Fasting)
Glucose Tolerance Test
Insulin
LipaseWhat is Plotted
• Fasting Glucose -
What is Measured (Nothing plotted)
Parathyroid Hormone (PTH) -
What is Measured (Nothing plotted)
Adrenocorticotropic Hormone (ACTH)
Follicle stimulating hormone (FSG)
Growth Hormone
Insulin-like growth factor 1 (IGF-1)
Luteinizing Hormone (LH)
Thyroid-stimulating hormone (TSH) -
What is Measured
Calcitonin
T3 uptake (THBR)
Thyroglobulin
Thyrotropin-releasing hormone (TRH)
Thyroxine (T4)
Thyroxine binding globulin (TBG)
Thyroxine, Free (T4 free)
Transthyretin/ Thyroxine-binding Prealbumin (TTR or TBPA)
Triiodothyronine (T3)What is Plotted
• Thyroxine Free
• Thyroid Stimulating Hormone -
What is Measured
Complement C3
Complement C4
IgA
IgE
IgG
IgM -
What is Measured
Erythrocyte Sedimentation Rate (ESR)
High sensitivity C-reactive protein (hs-CRP)
ProcalcitoninWhat is Plotted
• C-reactive Protein -
What is Measured (Nothing plotted)
Ferritin
Gamma-glutamyl transferase (GGT)
Iron
Iron binding capacity, total (TIBC)
Transferrin -
What is Measured (Nothing plotted in this test)
Cholesterol
High-density lipoproteins (HDL)
Low-density lipoprotein (LDL)
Non-HDL cholesterol
Triglycerides
Very Low-density lipoprotein (VLDL) -
What is Measured
Albumin
Albumin to globulin (A/G) ratio
Alkaline Phosphatase (ALP)
Asparate Transaminase (AST or SGOT)
AST/ ALT Ratio
Bilirubin Direct
Bilirubin indirect
Bilirubin total
Copper
Globulin
Lactate dehydrogenase (LDH)
Prealbumin
CholesterolWhat is Plotted
• Prealbumin -
What is Measured
Anion Gap
Blood urea nitrogen (BUN)
Calcium (Ca)
Chloride (Cl)
Creatine kinase (CK)
Creatinine
Electrolyte/ Bicarbinate (HCO3-)
Glomerular filtration rate (GFR)
Glucose (Non-Fasting)
Magnesium (Mg)
Phosphorus (P)
Potassium (K)
Protein (Total)
Sodium (Na)What is Plotted
• Glucose -
What is Measured
Vitamin A
Vitamin B1 (Thiamine)
Vitamin B12 (Cobalamin)
Vitamin B2 (Riboflavin)
Vitamin B3 (Niacin)
Vitamin B5 (Pantothenic Acid)
Vitamin B6 (Pyridoxine)
Vitamin B7 (Biotin)
Vitamin B9 (Folate)
Vitamin C
Vitamin D
Vitamin EWhat is Plotted
• Vitamin A -
What is Measured (Nothing plotted)
Ammonia
Osmolity
Osmolity Gap
Renin
