工作进度跟踪表excel_在Excel中跟踪您的治疗

最新推荐文章于 2021-11-29 20:44:49 发布

culiao2169

最新推荐文章于 2021-11-29 20:44:49 发布

阅读量410

点赞数

文章标签： python java excel ubuntu linux

原文链接：https://contexturesblog.com/archives/2010/03/29/track-your-treatments-in-excel/

版权

工作进度跟踪表excel

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.

Roger Govier创建了一个Excel文件，用于为剂量或注射部位不同的人跟踪您的治疗情况。它不会帮助我感觉好些，但可能会帮助您或您认识的人。

输入治疗顺序 (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.

罗杰的工作簿有两个工作表–日历和设置。从“设置”表开始，您将在其中输入用药顺序。

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.
例如，可能规定某人正在服药，每天服用2 mg，2mg，3mg，2mg，5mg的剂量，然后回到序列的开始。
They would fill in 5 cells in the Treatment List, shown in section 1 in the screenshot below.
他们将在“治疗列表”中填写5个单元格，如下面的屏幕快照中的第1节所示。

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

接下来，在“治疗清单”中输入每日剂量顺序后，单击“ 填充治疗栏”按钮(上方屏幕截图中的2号)。

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.

运行一个宏，该宏将清除“治疗”列(屏幕快照中的第3列)，然后根据您输入的治疗顺序再次将其填充。

查看治疗日历 (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.

然后，从“开始治疗”下拉列表中，选择所选月份的开始治疗。在此示例中，前一个月以3mg剂量结束，因此选择了第四个剂量2mg。