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 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.
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.
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
________________________________