Figure 45: Importing Delimited Data, Import Wizard Step 3 of 3 In the Window, select the button to accept the Import Data OK Existing See the figure shown below for more information. Worksheet=$A$2. After importing the data, select from the Menu and save the worksheet Save As File to the local desktop or network drive. Select all of the data imported in rows A through L by dragging the mouse across the data. Select from the menu. Copy Home Select the CDI Cases tab at the bottom of the spreadsheet. Excel™ Click once into the A2 cell. Select from the menu. Paste Home Evaluate the data in cells F through I (regarding location) to determine a selection in cell J. Select a Patient location when CDI LabID Event was collected from the drop down list in cell J. Repeat this step for each patient. Select from the Menu to save the worksheet. Save File A description for the columns and headings from the report are outlined in the table below. Table 12: Descriptions for spreadsheet CDI Reporting Tool Excel™ Heading Description Name This field contains the name. patient’s SSAN This field contains the last 4 numbers of the Social patient’s Security Account Number (SSAN). Birth date This field contains the birth date and may be useful as patient’s some patients have the same name and last 4 digits of the SSAN. It is displayed in MM/DD/YY format. Date & time of CDI This field contains the date and time that the positive C. difficile LabID Event stool specimen for this episode was collected in MM/DD/YY HH:MM format. Date & time of This field contains the date and time the patient was admitted to the admission associated CLC facility in MM/DD/YY HH:MM format. with CDI LabID Event in Column D Location Name Information shown in this column will enable the user to choose the appropriate Patient Location when CDI LabID Event was collected in Column J. Location Type Information shown in this column will enable the user to choose the appropriate Patient Location when CDI LabID Event was collected in Column J.
Figure 45: Importing Delimited Data, Import Wizard Step 3 of 3 In the Import Data Window, select the OK button to accept the Existing Worksheet=$A$2. See the figure shown below for more information. After importing the data, select Save As from the File Menu and save the worksheet to the local desktop or network drive. Select all of the data imported in rows A through L by dragging the mouse across the data. Select Copy from the Home menu. Select the CDI Cases tab at the bottom of the Excel™ spreadsheet. Click once into the A2 cell. Select Paste from the Home menu. Evaluate the data in cells F through I (regarding location) to determine a selection in cell J. Select a Patient location when CDI LabID Event was collected from the drop down list in cell J. Repeat this step for each patient. Select Save from the File Menu to save the worksheet. A description for the columns and headings from the report are outlined in the table below. Table 12: Descriptions for Excel™ spreadsheet CDI Reporting Tool Heading Description Name This field contains the patient’s name. SSAN This field contains the last 4 numbers of the patient’s Social Security Account Number (SSAN). Birth date This field contains the patient’s birth date and may be useful as some patients have the same name and last 4 digits of the SSAN. It is displayed in MM/DD/YY format. Date & time of CDI LabID Event This field contains the date and time that the C. difficile positive stool specimen for this episode was collected in MM/DD/YY HH:MM format. Date & time of admission associated with CDI LabID Event in Column D This field contains the date and time the patient was admitted to the CLC facility in MM/DD/YY HH:MM format. Location Name Information shown in this column will enable the user to choose the appropriate Patient Location when CDI LabID Event was collected in Column J. Location Type Information shown in this column will enable the user to choose the appropriate Patient Location when CDI LabID Event was collected in Column J.
vle_micro_mmrs_1_0_4_user_guide.docx