Excel Treatment Calendar Template

No, you don’t necessarily need treatment just because you like using Excel. 😉 Today’s post shows an Excel workbook that you can download, to plan a sequence of treatments, prescribed by your doctor.

Excel Treatment Calendar Workbook

In response to a newsgroup posting, Roger Govier created a workbook to help patients plan a sequence of treatments.

For example, people taking Warfarin, might be prescribed to take doses of 2 mg, 2mg, 3mg, 2mg, 5mg and then go back to the start of the sequence.

Sequence Setup Sheet

In the sample workbook, they would enter that sequence on the Setup sheet.

Treatment List on worksheet
Treatment List on worksheet

Treatment Sites List

Muscular Dystrophy sufferers need to inject at different sites on the body each day.

  • They could list the sites on the setup sheet, in the Treatment_List column.
  • Then, after the sequence has been entered, click the “Fill Treatments Column” button.

That button runs an Excel macro, which has the sequence copied down, to fill the Treatments Column.

Macro button Fill Treatments Column
Macro button Fill Treatments Column

View Treatments on a Calendar

After the treatment list is created, switch to the Calendar sheet, to set up the current month.

  • First, from the drop down lists, select a year and month
  • Next, pick the first treatment for the month.

The calendar will fill in with dates and treatment sequence.

Select Month for Treatment Calendar
Select Month for Treatment Calendar

Download the Sample File

You can download Roger’s sample file from the Excel Sample Spreadsheets page on my Contextures site.

In the Functions section, look for FN0016 – Treatment Calendar
________________________________

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.