Track Your Treatments in Excel

image Don't get too close to this blog today – I've got a miserable cold, and wouldn't want you to catch it!

Roger Govier has created an Excel file to track your medical treatments, for people who have varying dosages or injection sites. It won't help me feel better, but it might help you, or someone you know.

Enter the Treatment Sequence

Roger's workbook has two worksheets – Calendar and Setup. Start on the Setup sheet, where you'll enter the medication sequence.

1. First, enter your daily dosages in the Treatment List column.

For example, someone who's taking a medication might be prescribed to take daily doses of 2 mg, 2mg, 3mg, 2mg, 5mg and then back to the start of the sequence. They would fill in 5 cells in the Treatment List, shown in section 1 in the screenshot below.


2. Next, after you've entered the daily dosage sequence in the Treatment List, click the Fill Treatment Column button (number 2 in the screenshot above).

3. A macro runs, which clears the Treatments column (number 3 in the screenshot) and then fills it again, based on the treatment sequence that you entered.

View the Treatment Calendar

After setting up the Treatment Sequence, go to the Calendar sheet, which shows a monthly calendar.

At the top of the worksheet, select a year and month from the drop down lists.


Then, from the Start Treatment drop down, select the starting treatment for the selected month. In this example, the previous month ended with a 3mg dosage, so the fourth dosage, 2mg, is selected.


The calendar automatically adjusts to show the new treatment schedule.

Download the Sample Treatment Workbook

Click here to download Roger's Sample Excel Treatment Workbook. It's a zipped file in Excel 2003 format, and contains a macro. You'll have to enable macros to run the FillColumn macro on the Setup sheet.

Healing Music

If you're sick too, this video, with the soothing sounds of Peggy Lee, might help you feel better, and get rid of your fever.


You may also like...

5 Responses

  1. Martin says:

    Great post !!

    your mission,should you decide to accept it, is to repeat the dosage for more than once a day, and for different pills…..

  2. Thanks Martin, maybe Roger can work on that assignment next. It might have to be a weekly calendar though, to fit all the info.

  3. Toad says:

    Well, I prefer Little Willie John’s version of “Fever”.

    And, I track my treatments in my head. Can you tell?

  4. Thanks Toad, I just listened to his version on YouTube — really good.
    And I’m sure the head tracking works well, and you don’t have to worry about program upgrades.

  5. Rodney Sharp says:

    Is there away to to put a start date other than the first of the month for my Chemo patients?

Leave a Reply

Your email address will not be published. Required fields are marked *