- About the Diet Extensions Report (aka Therapeutic Spreadsheet)
- Selecting Menu and its Settings to Determine Items to be in the Report
- Report Settings: Diet Extensions Report
- If a Restricted Item is Selected for a Diet Type (appears in red text)
- Printing Temporary Replacement Items on Diet Extensions Report
- FAQ
About the Diet Extensions Report (aka, Therapeutic Spreadsheet)
The Diet Extensions report (aka, Therapeutic Spreadsheet) prints the therapeutic substitute recipes that are extended for the menu items so that you can proofread and QA your menus.
For each meal period (breakfast, lunch, dinner), the report will print a "diet order row" consisting of the regular diet type/regular texture type column on the left followed by a column for each diet type/texture type selected in the menu report settings. In this format, you can cross-reference the extensions of a regular food item across the diet type/texture type columns.
(Right-click image to open and expand in new tab)
If there are more diet type/texture type columns that exceed the available space on a "diet order row", then another "diet order row" is created for these columns, with the regular diet type/regular texture type column again displayed on the left.*
(Right-click image to open and expand in new tab)
If there are more diet type/texture type columns that can fit onto the same page for a meal period, then the report simply prints these columns on the next page with additional "diet order rows" until all the diet type/texture type columns are printed.
*Note: There is the ability to not have the regular diet type/regular texture column display on each new row. To do so, clear the Display Regular/Regular on each new row check box (also explained below).
Selecting Menu and its Settings to Determine Items to be in the Report
Via Menus > Reports, select the menu and its associated settings (weeks, choices, diet/texture combinations, menu categories) to determine the items to be included in the report. See the separate article Accessing the Menu Report Settings for more information and specific instructions.
Report Settings: Diet Extensions Report
When selecting the menu and its settings, the menu must be an extended menu, and at least two diet type/texture type combinations must be selected.
Once your menu settings are set, then from the left side of the screen select the Diet Extensions option. The Diet Extensions section appears for you to select the report settings.
Formatting Options
-
Format - select if the report is to be generated in letter (four columns) or legal size (six columns), or Excel® format.
-
Font - select a Small, Medium or Large font size for the report text.
-
Show Same as Regular
-
Menu Item Name - if the extension for a diet type/texture type combination is the same as the regular item, then the item's name is shown on the report.
-
Check Mark - if the extension for a diet type/texture type combination is the same as the regular item, then a check mark is shown on the report.
-
Menu Item Name - if the extension for a diet type/texture type combination is the same as the regular item, then the item's name is shown on the report.
-
Show Do Not Serve As
-
Blank - if the diet type/texture combination is set as do not serve on the extension grid, then the associated cell on the report is blank.
-
Cross - if the diet type/texture combination is set as do not serve on the extension grid, then the associated cell on the report has a red x.
-
Blank - if the diet type/texture combination is set as do not serve on the extension grid, then the associated cell on the report is blank.
-
Sort By
- Menu Category - menu items are sorted first by the menu category sort order (via Tools & Setup > Menu Settings), and then sub-sorted within each category according to their sort order on the menu day view.
-
Choice - menu items are sorted first by the sort order of choices (i.e., choice 1 items are listed first, choice 2 items are listed second, etc.), and then sub-sorted within each choice according to the menu category sort order (via Tools & Setup > Menu Settings), and then sub-sub-sorted within each category according to their sort order on the menu day view.
-
Separate Choice With
-
Line (only available if the Sort By option is Choice) - separates the choices by a solid line.
-
Bold Choice 1 - bolds the choice 1 items. (Note that if the Sort By option is Menu Category, then Bold Choice 1 is the only option and is automatically selected.)
-
Line (only available if the Sort By option is Choice) - separates the choices by a solid line.
-
Print By
- Display Name - the display name (i.e., user-friendly name) of items is displayed.
-
Lookup Name - the lookup name (i.e., system name) of items is displayed.
- Page Break on Meal - generates a page break between meals.
Options to Include
-
Portion Size Description - for recipes that have portion size descriptions, displays the portion size description in italics below the item in the report.
-
Serving Utensil - for recipes that have serving utensils, displays the serving utensil in italics below the item in the report.
-
Service Date (available if the selected menu is scheduled) - includes a service date on the report, which displays at the top right corner for each day. Upon selecting the Service Date check box, a drop-down appears for you to select the service date.
Note: If your menu has any temporary replacement items, the Service Date check box needs to be selected for those temporary replacement items to show on the report.
-
Include Note - allows you to enter a custom note to display on the menu (e.g., “Happy Holidays”). The note displays on the bottom of the last page of the report. The note has a maximum of 1000 characters.
-
Display Regular/Regular on each new row - If you want the regular diet type/regular texture type column to display for each additional "diet order row" that is printed on the report for a meal period, then ensure this check box is selected. If you do not want the regular diet type/regular texture type column to display for each additional diet order row for a meal period, then clear this check box (i.e., deselect).
If a Restricted Item is Selected for a Diet Type (appears in red text)
If the diet type is configured with restricted items, and a restricted item is selected for that diet type, then the restricted item appears in red text to alert you of the conflict.
Printing Temporary Replacement Items on Diet Extensions Report
If your menu has any temporary replacement items, the Service Date option must be selected for those temporary replacement items to show on the Diet Extensions report. This is required because the system requires a calendar point of reference.
FAQ
Why is the regular diet order appearing twice (or multiple times)?
The Display Regular/Regular on each new row check box is selected. If you do not want the regular diet type/regular texture type column to display for each additional diet order row for a meal period, then clear this check box (i.e., deselect).
Why is an item in red?
If the diet type is configured with restricted items, and a restricted item is selected for that diet type, then the restricted item appears in red text to alert you of the conflict.
My temporary replacement items are not showing on the report?
If your menu has any temporary replacement items, the Service Date option needs to be selected for those temporary replacement items to show on the report (i.e., the system requires a calendar point of reference).