wps excel日历_Excel处理日历

wps excel日历

No, you don't necessarily need treatment just because you like using Excel. 😉

不，您不一定只是因为喜欢使用Excel而需要治疗。 😉

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

为了回应新闻组的发布，Roger Govier创建了一个工作簿来帮助患者计划一系列治疗。

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

例如，服用华法林的人可能会被处方服用2 mg，2mg，3mg，2mg，5mg的剂量，然后回到序列的开始。

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

在示例工作簿中，他们将在“设置”表上输入该序列。

Muscular Dystrophy sufferers need to inject at different sites on the body each day. They could list the sites on the setup sheet. After the sequence has been entered, click the button to have 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.

创建治疗清单后，切换至“日历”表以设置当前月份。

From the drop down lists, select a year and month, then 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 or click to download the zipped Excel Treatment Calendar file. ________________________________

您可以从Excel Sample Spreadsheets页面下载Roger的示例文件，或者单击以下载压缩的Excel Treatment Calendar文件。 ________________________________

翻译自: https://contexturesblog.com/archives/2008/12/12/excel-treatment-calendar/

wps excel日历