Disclaimer: Vitality is not intended to be a substitute for professional medical advice, diagnosis, or treatment. Always seek the advice of your physician or other qualified health provider with any questions you may have regarding a medical condition.
Have you ever spent half a day searching for information about a doctor visit because NOW – 3 months later – the insurance company needs it?
Wouldn’t it be great if you had ALL your medical records, notes, appointments, lab tests, and more all in one easy-to-access place in a highly organized format?
Then you definitely need this medical tracking spreadsheet. You will have all your records – even from years back – all in one place. It tracks everything!
- Doctor appointments
- Medical history
- Blood sugar
- Blood pressure
- Cholesterol levels
- Lab results
- Insurance information
- And more!
Next time you need information on your last doctor’s appointment or whether or not you took your medicine this morning, you’ll have it. This Google Sheets medical-tracking spreadsheet has it all.
HOW TO USE YOUR VITALITY MEDICAL-TRACKING SPREADSHEET TOOLKIT
After purchasing the Google Sheets Vitality Medical Tracker Toolkit, you’ll be redirected to a view only Google Sheets template.
In order to start using your medical tracker, click File in the top menu bar and choose make a copy.
Name your Medical Tracker, and you’re ready to get started.
In the Medical History Tab, add your details, such as age, blood type, allergies, contacts, etc.
Next, add your insurance information in the Insurance Tab which is the last tab of the spreadsheet. If you don’t see, click the arrow to the right of the tabs.
Adding Information To Your medical Tracker
In the Doctor Visits tab, add your next doctor appointment’s date, time, place, doctor, and reason.
In the Problems & Symptoms tab, add your problem, the cause, the severity of the symptom, how long the symptoms lasted, and what steps you took to alleviate the symptoms.
In the Medicine tab, write your medicines in the first row, and each time you take your medicine, click the checkbox.
To add more medicines or to add more checkboxes, see the next section.
In the Lab Results tab, add the date of your lab test, the result, the normal range, and your notes.
In the Cholesterol Levels tab, choose the Yes or No from the dropdown menu next to the “Do you have heart issues?”. Then, add the date of the test, use the dropdown menu to choose whether the test was done at home or in a lab. In the next columns, add the test results for your total cholesterol, LDL, HDL, VLDL, and triglycerides.
In the Mood tab, add the date and how you are feeling. If there is a cause, add it to the cause column.
The next tab is the Measurements tab. In this tab, you can track your weight, BMI, and body fat percentage. Add your age, height in the first row, then add your weight and body fat percentage each week. The BMI is automatically calculated.
The Blood Sugar Levels tab is where you track your blood sugar. Enter your blood sugar levels each time you test. There is also a HbA1C calculator.
Disclaimer: the HbA1C calculator is just an estimation and is not meant to replace an actual test done by a professional.
The last tab is the Insurance Info tab. Here, you can add information about your insurance companies, such as the provider, phone number, policy numbers, and address.
Adding More Medicine Times to The Medicine Tracker tab
The medicine tracker tab has can track up to 10 medicines with 3 times by default. If you would like to add more medicines, follow these steps:
- Select a column by clicking the column letter.
- Right click on the column letter and choose insert 1 right.
- Name the new column.
To Add More Medicines:
- Select the three columns of Medicine 10 by holding CTRL (Command on Mac) and clicking on the column letters.
- Right click on the column letters, and select Insert 3 right.
- Select the top 3 cells and click the merge button in the top bar.
- Add your medicine name and you’re done!
If you have any questions that weren’t answered here, feel free to contact me.