This Excel spreadsheet contains dynamic text code examples to pull information from a standard StyleADVISOR Manager Analysis workbook. Each of the Excel worksheets contains the StyleADVISOR table name, unformatted dynamic text code, formatted dynamic text code, and a sample of the formatted output. All of the dynamic text (formatted or unformatted) can be copied and used as it is, provided the code is used in conjunction with a standard StyleADVISOR Manager Analysis workbook for exporting.

This document provides information on the different methods of formatting dates in Dynamic Text. It covers examples of the formatting variables, including day, month, quarter, and year time periods. It also includes examples of ordinal dates (2nd, 3rd, 4th) and setting default date formatting for all Dynamic Text in a StyleADVISOR workbook.

This document covers the exceptionally powerful Dynamic Text tool Workbook Functions. It details what workbook functions are, how they are used, how and why to write them, and finally how to best implement them. If your Dynamic Text code has moved beyond pulling statistics with Value(), this document will be invaluable for simplifying your work.

This document addresses conditional logic, also known as If/Then statements. It starts with the basics and simple examples, then builds to complicated tests. Conditional logic is a tool that every DT user needs to understand and have in their tool box.