Skip to main content

The Therapeutic Spreadsheet in the Touch App

Kevin U
  • Updated

About the Therapeutic Spreadsheet in the Touch App

The Therapeutic Spreadsheet lists the food items to be served for the various diet type and texture type combinations that are assigned to the residents and patients in your account. 

Tutorial Video - Therapeutic Spreadsheet in the Touch App (1:46)

Running the Therapeutic Spreadsheet

Under Production Reports, tap Therapeutic Spreadsheet (first screenshot below). The Service & Delivery Production Sheet appears (second screenshot below). 

therapeutic_spreadsheet1.png

therapeutic_spreadsheet2_numbers.png

  1. Select the meal or snack.

  2. Select the date to run the report (note that the default is today's date). 

  3. Select the menu service location(s). A menu service location is assigned menus and dining areas (including residence areas enabled as a dining areas for resident profiles with in-room service). The dining areas in turn determine the diet order census based off resident profiles assigned to the dining areas, or a dining area set up with a manual diet order census.

    people_profile_dining_area_MSL_menu.png
    Note: A menu service location is configured in the Core system software and not the Touch Admin software. 

  4. To include the portion size description for the items, select the Include Portion Size Description check box.

  5. Tap the Create Report button to generate the report. 

Viewing the Therapeutic Spreadsheet

From the left column, select the diet type and texture type combinations to display. Each selected combination displays an equivalent column to the right, listing the items of that combination (screenshot below). 

Note that the diet/texture combinations displayed in the report are pulled from the resident profiles assigned to the dining areas (including residence areas enabled as dining areas for in-room service), which in turn are assigned to the menu service location you selected in step 3 above. 

therapeutic_layout1.png

An item that appears in blue indicates it is a substitute item for that diet type/texture type combination. 

therapeutic_layout_blue.png

Note that you can select all or clear all combinations via the respective Select All and Clear Selection buttons near the bottom of the first column. 

therapeutic_selectall_clear.png

Pinning a Diet/Texture Column to the Side

To pin a diet/texture column to the side so that it does not move when you add other diet/texture columns, click its Pin to Side button. Pinning a column to the side is ideal for the regular/regular column. 

pinned_to_side.png

Selecting Different Meal Period/Snack Time

After the report is generated, you can select a different meal period/snack time via the Meal drop-down near the bottom of the left column. 

therapeutic_meal.png

Selecting Different Menu Service Location (MSL). 

After the report is generated, you can select a different menu service location (MSL) via the Location drop-down near the bottom of the left column. See the Where is the Info Pulled From? section above to understand how the food items and diet type/texture type combinations can change when you select a different MSL. 

therapeutic_MSL.png

Increasing or Decreasing Size of Onscreen Content

Tap the magnifying glasses to increase or decrease the size of the onscreen content.  

therapeutic_magnifying.png

Where is the Info Pulled from for the Therapeutic Spreadsheet?

The menu items displayed in the report are pulled from the menus assigned to the menu service location (MSL).

The diet/texture combinations displayed in the report are pulled from the resident profiles assigned to the dining areas that in turn are assigned to the MSL. A dining area can be as follows:

people_profile_dining_area_MSL_menu.png

Note: A menu service location is configured in the Core system software and not the Touch Admin software. 

FAQs

Why is the message "No menus founds for this location/meal" being shown when I attempt to generate the Therapeutic Spreadsheet? 

Possible Reason 1: A scheduled menu is not assigned to menu service location that you are selecting to run the Therapeutic Spreadsheet.

Possible Reason 2: The dining areas (including residence areas enabled as dining areas for in-room service) assigned to the residents are themselves not assigned to the menu service location that you are selecting to run the Therapeutic Spreadsheet.

The dining areas determine the diet order census based off resident profiles assigned to the dining areas, and therefore if dining areas are not assigned to your selected menu service location, then they are not connected to the menu, and as such a "No menus founds for this location/meal" message will be returned.

Printable One-Page Quick Reference Guide

Click the attachment below to download a one-page printable guide of the Touch Therapeutic Spreadsheet.