Care Management Toolbox

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
    Ph

    What 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 T

    What 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 count

    What is Plotted
    • WBC
    • Hematocrit
    • Neutrophils%
    • Lymphs%
    • Monocytes%
    • Neutrophils#
    • Lymphs#
    • Monocytes#

  • What is Measured
    Aldosterone
    Cortisol
    Dopamine
    Epinephrine
    Norepinephrine

    What 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
    Lipase

    What 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)
    Procalcitonin

    What 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
    Cholesterol

    What 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 E

    What is Plotted
    • Vitamin A

  • What is Measured (Nothing plotted)
    Ammonia
    Osmolity
    Osmolity Gap
    Renin

Powered by Firespring