Variables

The configuration options available in the Variables tab of the mapping template manager are described in the tables below. Multiple mappings (using different mapping configuration options) can be set up for a single periodic variable, with the following operations supported: Add, Subtract, Multiply and Divide.

Single Project Workbook

Variable	Mapping variable
Summary	User Entered; Workbook Range; Worksheet Range
Periodic	User Entered; Workbook Range; Worksheet Range

Single Project Worksheet

Variable	Mapping variable
Summary	User Entered; Worksheet Range
Periodic	User Entered; Worksheet Range

Multi-Project Worksheet

Variable	Mapping variable
Summary	User Entered; Worksheet Column; Worksheet Column Lookup
Periodic	User Entered; Worksheet Column; Worksheet Column Lookup

Single Variable per Worksheet

Variable	Mapping variable
Summary	User Entered; Worksheet Range
Periodic	User Entered; Worksheet Range

Single Row Project

Variable	Mapping variable
Summary	User Entered; Worksheet Column; Worksheet Column Lookup
Periodic	User Entered; Worksheet Column; Worksheet Column Lookup; specify the start column for periodic data and optionally the end column