Tendwell Medication Tracker Spreadsheet & Caregiver Health Organizer
Tendwell is a medication tracker spreadsheet built for family caregivers, seniors and anyone managing a long-term condition. It brings the medication list, a daily dose checklist, refill dates, doctor appointments, vitals, symptoms, care team contacts, insurance and medical costs together in one Excel workbook with large, easy-to-read text and a live dashboard. Instead of pill bottles, sticky notes and a dozen apps, you get one calm record that the whole family can share.
Important: Tendwell is for record keeping only. It is not medical advice and has no dosage calculator. Always follow your doctor’s and pharmacist’s instructions.
Who it is for
- Adult children and spouses caring for an aging parent or partner
- Seniors who want one clear list of their own medicines and appointments
- People managing diabetes, high blood pressure, thyroid conditions or several prescriptions
- Families and home health aides who share caregiving and need the same up-to-date information
Main benefits
- Know what was taken. A daily checklist with adherence % for every dose, every day and every month.
- Never run out. Days of supply and run-out dates are calculated for you, with alerts a set number of days ahead.
- Walk into appointments prepared. Questions to ask, vitals trends and a symptom journal are ready to show the doctor.
- Be ready in an emergency. A one-page allergy and emergency sheet fills in current medicines and contacts automatically.
- Easy on the eyes. Large Inter font, clear colors, dropdowns and locked formulas that can’t be broken by accident.
Features of this medication log and caregiver organizer
Dashboard
12 KPI tiles show active medicines, doses taken in the last 30 days against your goal, today’s doses, refills due, the next appointment, visits in the next 30 days, the latest blood pressure, glucose and weight, readings outside your targets, symptoms logged and out-of-pocket costs this year. Four charts show adherence by month, the last 14 blood pressure and glucose readings, and costs by month, plus lists of refills coming up and upcoming appointments.
Medication list
Up to 50 medicines with strength, form, amount per dose, morning, midday, evening and bedtime times, purpose, prescriber, pharmacy, Rx number, start date, status (active, as needed, paused or stopped), special instructions and side effects to watch.
Daily dose checklist and weekly print view
16 dose columns for 366 days. Pick Yes, Late, No or Skip from a dropdown; colors update instantly, and each dose and day gets an adherence score. A printable weekly checklist fills in from the log, or print it blank for the fridge.
Refill tracker
Enter the quantity, fill date and refills left from the label. Tendwell calculates days of supply, the run-out date, days left and a supply bar, and shows Refill now, Ran out or new Rx needed.
Appointments, vitals and symptoms
Log 200 doctor visits with questions and outcomes, 500 vitals readings (blood pressure, pulse, glucose, weight, temperature, oxygen) with charts and target flags you set from your doctor’s ranges, and 300 symptom journal entries with a 1 to 10 severity scale and a most-frequent-symptoms chart.
Emergency info, care team, insurance and costs
A one-page allergy and emergency information sheet, 60 care team contacts, 6 insurance plans with a yearly summary and out-of-pocket progress bar, and a 400-row costs log with HSA/FSA flags and claim status.
What is included
- Tendwell-Medication-Caregiver-Tracker.xlsx: 15 tabs (Start Here, Dashboard, Medications, Dose Log, Weekly Checklist, Refills, Appointments, Vitals, Symptoms, Emergency Info, Care Team, Insurance, Costs, Settings, Chart Data), delivered clean and ready for your information
- Tendwell-User-Guide.docx: a 14-page illustrated guide with setup steps, tips, troubleshooting and FAQ
How it works
- Open Settings and add the person’s name, your currency, units, refill alert days and target ranges.
- List each medicine and mark the times of day it is taken.
- Add fill details on the Refills tab and set up your dose columns on the Dose Log.
- Mark doses each day and log visits, readings and symptoms as they happen. The dashboard updates automatically.
File format and software requirements
Excel-format .xlsx for Microsoft Excel; tested in LibreOffice Calc; built with standard functions that also work when you open it in Google Sheets. No macros and no add-ins. Sheets are protected with no password, so you can unprotect them to change the layout.
Customization
Choose any currency symbol, lb or kg, °F or °C, and mg/dL or mmol/L. Set your own target ranges and adherence goal, and rename or add dropdown options on the Settings tab; formulas follow your changes.
Digital download
This is a digital product. No physical item will be shipped. Your files are available to download right after purchase. Want to try it first? Get the free Tendwell Lite medication tracker.
Real-life use cases
- Coordinating Mom’s eight daily doses between three siblings and a home aide
- Showing the cardiologist a month of blood pressure readings after a new prescription
- Handing paramedics a printed list of allergies and current medicines
- Tracking copays and HSA-eligible costs for tax time
FAQ
Does Tendwell tell me what dose to take?
No. It is a record-keeping tool with no dosage calculator. Always follow your doctor’s and pharmacist’s instructions.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. It uses standard functions that work there.
Does it send reminders?
No. Spreadsheets can’t send notifications. Use phone alarms for reminders and Tendwell to record what was taken.
Can I track more than one person?
Each workbook covers one person. Save a separate copy for each person you care for.
Can my family share it?
Yes. Keep the file in OneDrive or Google Drive so everyone works in the same copy.
What happens after a year?
Save a new copy, type a new start date on the Dose Log and keep the old file as your history.
License
Personal use only, for you and your household. Please do not resell, share, upload or redistribute the files. Copyright Taskdale.
Reviews
There are no reviews yet.