To define a journal template, you create a range name that includes all metadata and data cells and that begins with the prefix ups. For example, for a standard template, create the range name [upsStandardJV (A1 to D7)].
A journal template requires a named range. You can specify as many named ranges as needed. To do this, duplicate the original range included with the template. FDMEEFDMEE processes as many named ranges as the template file contains.
The following template references upsJournal, which starts at row 16. Therefore, rows 16–20 are the first five rows (the metadata header) of ups.journal. And, therefore, the metadata of the template is placed in rows 16–20.
Rows 4–14 provide an interface that facilitates creation of the metadata header. Metadata information is input in rows 4–14 and referenced by the metadata header.
(Journal data should be entered against the respective columns and by adding more rows within the range. The easiest thing to do is to add rows to the existing range and just use a single range, and use the default upsJournal. You add columns to the spreadsheet based on the dimensionality of the target application.)
