16 April 2007

Track medical history with Excel

Kelly's hack makes me realize that I'm doing a better job tracking my car's maintenance records than our own health history:

I started taking note of my kids' medical histories when my oldest was a wee guy, but in notebook form. I now use an Excel spreadsheet and plan to backtrack and put in all the family medical history.  I'll scan in documents as I get them (such as when we change doctors), and save it all to a DVD. Now I have a simple way to check in on medical issues, both small and large -- especially helpful when watching for a pattern of illness.

I hope to get my parents and my in-laws to share their medical history too, that way my kids will always have an answer to those pesky forms at doctor's offices that ask about family health history.


TrackBack URL for this entry:

Listed below are links to weblogs that reference Track medical history with Excel:

Your comments

Feed Follow this conversation by subscribing to the comment feed for this post.

Could someone offer a sample medical entry? I want to do this in a spreadsheet, but could use an example or two.

I actually use it to track meds (with dosages), medication and food allergies, then I printed a miniature copy, had it laminated to carry in my wallet. It has saved me many times. After waking up in an ICU in NYC, I learned to add one more thing. On the back is a signed statement by me saying that despite HIPPA rules it was ok to give out info to my family and that there were ICE (in case of emergency) notated in my cell phone. I think it will be helpful because the hospital did not contact anyone, get my name right, and had me listed as undomiciled. However, they did have my meds right. I'm considering adding my doctor's name and phone under the HIPPA statement. PS. I told them my nickname and handed them the list before I lost consciousness. I was also carrying id that they ignored.

If you like using google aps - you could also do this on google spreadsheets and have access to this info anywhere there is internet access.

Darn, I never thought of being so techie about keeping track of medical records! Maybe I should get it started...

Great idea! I also use Excel to track my kids' allowance. Years ago we realized that I often forgot to give them their allowance each week, so I set up a spreadsheet called "Banco de Mama" with a different worksheet for each kid. It makes it easy to calculate tax and interest. (They get 1% each month from me - what a deal!) When I'm in a snarky mood I add all the credits and tell them how much money they'd have if they hadn't bought that Hello Kitty wallet years ago, etc...

+1 vote for an example sheet.

Business Internships and Hospitality Internships in China available in China in various cities.
Cost effective high quality, Programs with options to Learn Chinese Calligraphy, Martial arts, etc.
Study medicine in China- Language of Instruction English, study engineering and various other programs in China
medical universities in China, Engineering programs in china in English,
Traditional Chinese Medical Programs, study abroad in China.

We close comments after a month to guard against spam. Want to talk about this hack? Join us on Twitter and Facebook!


Free updates

  • Subscribers are my VIPs. My weekly newsletter includes a personal update, the latest from Parent Hacks, interesting links and news.

    Subscribers also get priority event invitations and occasional surprises via snail mail.

Asha's Book

  • At Amazon: Minimalist Parenting: Enjoy Modern Family Life More by Doing Less

    Find out why doing less is the key to resourceful, thriving kids, and a calmer, happier YOU.

    Minimalist Parenting is an encouraging roadmap for decluttering your schedule, your home, and your vision for family life. Reviewers call it "a much welcome alternative to the usual parenting advice."

    Learn More at Amazon

    Also available at Barnes & Noble or your favorite local bookstore.

New Book Coming Soon!

  • Coming soon: Parent Hacks Book

Start Amazon shopping here