Managing Tabular Data Templates

Intro

Tabular data templates define the number of rows and columns associated with a table utilized in a project. You can create and maintain tabular data template definitions via the “Tabular Data Templates” page.

Certain functionality in this application area requires you to have one or more . For more information about any given right (i.e., what functionality it governs, etc.), please see the “Available User Rights” topic.

Tasks

    1. Expand the ArcFiling “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    2. Expand the ArcReporting “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    3. Click the “Tabular Data Templates” item.

      “Tabular Data Templates” page

    4. Click the “Add” at lower-right of the page to add a new template.
      “Create Tabular Data Template” dialogue

      1. Specify to create a completely new template, or to base the new template on a previously-created template.
        1. Select the “Blank Template” option (default) to create a new, blank template.

        2. Select the “Copy Existing Template” to create a template based on an existing template in the database.
          1. Use the “Source Complex” drop-down list to specify the complex with which the tabular data template to be copied is associated.
          2. Use the “Source Complex” drop-down list to select the appropriate template from those associated with the specified source complex.
          3. Click the “Target Complex” drop-down list to select the appropriate target complex for the new tabular data template.

        3. Select the “Import” to create a template whose properties and settings match those of an existing template that has been exported from Arc Suite to a file of XML format.
          1. Select your import file using the “Browse” button at right of the “Browse” field.
          2. Specify the complex with which the new tabular data template will be associated via the “Target Complex” drop-down list.

          For information on how to export a template, see the “Exporting a tabular data template” task.

      2. Click the “Create/Import Template” at lower-right of the dialogue.

        1. “Blank Template” option

          1. Click the “Complex” drop-down list to specify the complex with which the new tabular data template will be associated.
          2. Enter a “Template Name”, “Description” and “Table Type” for the new template via the fields of the “Detail” pane at right.

        2. “Copy Existing Template” option

          1. Edit the newly-copied template’s “Template Name”, “Description” and “Table Type” via the fields of the “Detail” pane at right, as appropriate.

        3. “Import” option

          1. Edit the newly-imported template’s “Template Name”, “Description” and “Table Type” via the fields of the “Detail” pane at right, as appropriate.

        Available table types are limited to those designated as “active” in association with the current complex, via the Table Styles library.

    5. Define the “Number of Rows” and “Number of Columns” for the table in the in the “Detail” pane at right of the page (each has a default value of “1”).

      You can specify a maximum of “500” rows and “20” columns.

      1. For Form N-MFP Web posting output, set the values to “4” rows “1” column.

    6. Specify the you wish the tabular data template to support.
      1. Click the “Languages” tab in the lower portion of the page.

      2. Click the “Add” at lower-left of the tab to add a language.

        1. Click the “Language” drop-down list to specify a language that the tabular data template will support.

          • Languages available for selection are limited to those that have been defined via the “Languages” page in the Environment Administration area of Arc Suite.
          • You can add multiple languages and different captioning for each language.
          • The default language for all existing complexes is “English (U.S.)” and is added to the complex on the “Funds” page in the Environment Administration area.

        2. Click the “Accept” button at lower-right of the dialogue.

    7. Click the “Save” button at lower-right of the page.

    1. Expand the ArcFiling “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    2. Expand the ArcReporting “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    3. Click the “Tabular Data Templates” item.

      “Tabular Data Templates” page

    4. Select the desired item from the “Listing” pane at left of the page.

    5. Review and edit information for the item in the “Detail” pane at right of the page.

    6. Click the “Save” button at lower-right of the page if any updates were made.

    A listing of records, with certain associated information, can be exported from the application database to any of several different file formats (DOC, HTM, XML, etc.). Follow the steps below to perform a data export.

    1. Click the “Export data” at lower-right of the pane where existing items are listed to export data from the grid.

      1. Select the next to the file format to which you’d like the data saved.

        •  .XML

        •  .DOC

        •  .CSV

        •  .HTM

        •  .TXT

      2. Click the “Accept” button at lower-right of the dialogue.

        1. Specify a local or network directory in which to store the file, and provide a “File name”.
        2. Click the “Save” button.

    1. Expand the ArcFiling “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    2. Expand the ArcReporting “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    3. Click the “Tabular Data Templates” item.

      “Tabular Data Templates” page

    4. Click the “Export tabular data template” button at lower-right of the page.

    5. Click the “Yes” button on the confirmation dialogue that displays.

    6. Click the “OK” button.

    7. Click the “Output Queue” button at upper-right of the browser window, select the row in the grid that represents your export and save the file to your local or network drive.

    1. To view project output or a report returned from the document processing service, or the status of filings submitted to the SEC, open the Output Queue by clicking the “Output Queue” button at far upper-right of the screen.

      “Output Queue” pane

    2. Filter the list of items in the queue, if desired, through use of the “Show previous” and/or “Status” .

      1. Show previous: Allows requests to be filtered according to those submitted within a specified time period.

        • 24 hours (default selection)
        • Week
        • Month
        • 6 Months
        • Year

      2. Status: Filters requests according to their processing status.

        • <All> (default selection)
        • Requested
        • Success
        • Failed
        • Success with warnings

    3. Click the “View Output” at right of the document you wish to view to open or save it.
      “File Download” dialogue (output file)
      1. Click “Open” to view the document with your computer’s registered application for the file type.
      2. Click “Save” to save the document to a local or network drive, for viewing by you or others at a later time.

    4. Click the “View Message” at right of the document whose output message you wish to view.
      “Message” dialogue
      1. You can select the text of the message by striking “Ctrl + a” on your keyboard, and then copy it to your Windows keyboard by striking “Ctrl + c”.
      2. Click the “Cancel” button at lower-right of the dialogue to close it.

    5. Click the “Save Output” at right of a document if you simply wish to save it.
      “Save Output Queue” dialogue
      1. Click the “Accept” button at lower-right of the dialogue once the document has downloaded in order to save it to a local or network drive, for viewing by you or others at a later time.
      2. Click the “Cancel” button at lower-right of the dialogue to close it without saving the document.

    1. Expand the ArcFiling “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    2. Expand the ArcReporting “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    3. Click the “Tabular Data Templates” item.

      “Tabular Data Templates” page

    4. Click the “Output Settings” at lower-right of the “Detail” pane to view/edit settings that affect the display and behavior of table information in output.
      “Tabular Data Templates” page, “Output Settings” link
      “Tabular Data Template Output Settings” page
      • You can also open the “Tabular Data Template Output Settings” page directly by clicking the corresponding item in the “Structure Templates” menu section on the “Administration” tab .
      • Click the “Refresh data” button at lower-right of the pane to refresh content to reflect any changes made to the output settings’ associated template.

    5. If more than one language is associated with the tabular data template, specify .

      1. Click the “Multiple Language Options” at upper-right of the “Detail” pane to indicate whether the layout will be the same or different for each language.
        1. Select the “Multiple Statements - same layout for all languages” option (default) if you want all cell mappings, span areas, row and column positions and item formatting to be applied to all languages added to the tabular data template.
        2. Select the “Multiple statements - different layout for each supported language” option if you want cell mappings, span areas, row and column positions and item formatting specified for the selected language to apply only to that language.

        3. Click the “Accept” button at lower-right of the dialogue.

    6. If necessary, adjust the “Number of Rows” and “Number of Columns” for the table that displays in the “Detail” at right of the page, using the slider controls located along the top and right side of the table.
      • The number of rows and columns set via the “Tabular Data Template Output Settings” page will be reflected in the table’s associated template (accessed via the “Tabular Data Templates” page).
      • You can create table structures with up to 500 rows and 20 columns.
    7. If any row in the table that displays in the “Detail” pane at right of the page represents a heading, select the “Header Row” check box for that row.

    8. Add data points, custom tags and standard (e.g., “$”, “%”, “€”, “£”, etc.) or custom literal values to the .

      1. Add data points and literal values by them from their respective panes on the tabs at the bottom of the page.
        “Tabular Data Templates” page (item mapping)

      2. Add custom tags via the associated at lower-left of the grid.

        1. Select a cell in the grid, and then click the “Insert custom tag” to define the custom tag settings.
          “Insert Custom Tag” dialogue

          1. Specify the tag to insert via the “Custom Tag” drop-down list.

          2. If the specified custom tag has the “Additional Fixed Options” check box selected in the Custom Tags library, select one of the available options via the “Additional Fixed Option” drop-down list (the drop-down list is disabled if no fixed options are defined for the selected tag).

          3. If the specified custom tag has the “Additional Arguments” check box selected in the Custom Tags library, enter the appropriate argument(s) in the “Additional Argument(s)” text box.

            For a custom tag requiring additional arguments, it is helpful to provide definitions and/or examples of argument values in the “Description” field when creating/editing the tag via the “Custom Tags” page. This offers some guidance to any user who insert the tag in a text editor.

          4. Click the “Accept” button at lower-right of the dialogue.

      • If multiple items are added to any given cell, new items are appended by default to the right of existing items in the cell. Items can be removed from cells, and the order of items in the cell can be adjusted, using the controls on the “Format Items” tab (see below).
      • To create a custom literal item, type the desired text in the box on the right of the “Literals” tab. The text for the “{custom}” item at the top of the “Literals” pane reflects the text you enter, and that item can be dragged-and-dropped to the appropriate cell of your table to insert the custom literal.
      • Hard returns, soft returns, tabs and spaces can also be added to cells of the table. Items representing these can be found at the end of the list of literals provided.
      • When “Custom Data Point” is the specified data point type, a “Library” drop-down list displays through which you can designate the data point library containing the desired data points to map. Only those libraries associated with the same complex as the current template are available for selection.
    9. At any point during the mapping process, you can move entire rows and columns within the grid up/down/left/right by clicking the header of the desired row/column to select it, and then clicking the positioning buttons     appropriately.

    10. You can merge cells in the grid across columns and/or rows by selecting the cell representing the upper-left cell of the range, and then clicking the “Span cells” beneath the grid.
      “Span Cells” dialogue

      Typically, this functionality is used to merge top row columns to create a table header that spans all columns within a table.

      1. Specify the “Number of Columns to Span” using the corresponding spinner control on the dialogue.
      2. Specify the “Number of Rows to Span” using the corresponding spinner control on the dialogue.

      3. Click the “Accept” button at lower-right of the dialogue.

        • Any data that was in the upper-left (start) cell of the specified span area will be displayed in the span area text box of the grid; any data in any other cells of the span area range will be deleted.
        • Multiple span areas may exist within a table, but span areas cannot overlap.
        • All row and column positioning buttons are disabled when at least one span area exists in a given template’s grid.

      Click the “Remove Span” button beneath the grid to remove any selected span area.

    11. Indicate the cell style and (e.g., bold, italic, underline, color, alignment, etc.) to the text of mapped items.

      1. Format the within a selected cell.

        Select a cell in the grid, and then click the “Format Cell” at lower-left of the grid to view/edit cell settings.
        “Format Cell” dialogue
        1. Specify formatting settings, as required.

        2. Click the “Accept” button at lower-right of the dialogue.

        • When the dialogue is opened, Arc Suite examines the settings of all items in the currently-selected cell to determine what each check box on the dialogue will display.

          • Cleared

            • All items in the currently-selected cell have the attribute cleared.

          • Selected

            • All items in the currently-selected cell have the attribute selected.

          • Mixed/Indeterminate

            • Some items in the currently-selected cell have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” dialogue).
            • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cell.
        • Formatting settings made via the “Format Cell” dialogue are not reflected in the component preview on the “Project” page; only in output.

      2. Format the within all the cells of a selected row.

        1. Select a cell in the grid, and then click the “Format Row” at lower-left of the grid to view/edit row settings.
          “Format Row” dialogue
          1. Specify formatting settings, as required.

          2. Click the “Accept” button at lower-right of the dialogue.

          • When the dialogue is opened, Arc Suite examines the settings of all items in all cells of the currently-selected row to determine what each check box on the dialogue will display.

            • Cleared

              • All items in all cells of the currently-selected row have the attribute cleared.

            • Selected

              • All items in all cells of the currently-selected row have the attribute selected.

            • Mixed/Indeterminate

              • Some items in one or more cells of the currently-selected row have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” and/or “Format Column” dialogues).
              • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cells of the selected row.
          • Formatting settings made via the “Format Row” dialogue are not reflected in the component preview on the “Project” page; only in output.

      3. Format the within all the cells of a selected column.

        1. Select a cell in the grid, and then click the “Format Column” at lower-left of the grid to view/edit column settings.
          “Format Column” dialogue
          1. Specify formatting settings, as required.

          2. Click the “Accept” button at lower-right of the dialogue.

          • When the dialogue is opened, Arc Suite examines the settings of all items in all cells of the currently-selected column to determine what each check box on the dialogue will display.

            • Cleared

              • All items in all cells of the currently-selected column have the attribute cleared.

            • Selected

              • All items in all cells of the currently-selected column have the attribute selected.

            • Mixed/Indeterminate

              • Some items in one or more cells of the currently-selected column have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” and/or “Format Row” dialogues).
              • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cells of the selected column.
          • Formatting settings made via the “Format Column” dialogue are not reflected in the component preview on the “Project” page; only in output.

      To better understand how project output can be impacted by leveraging different styles, table types and custom tags, click the “Style Guide” link on the page.

    12. Specify of specific items within selected cells.

      1. Click the “Format Items” tab.

      2. Select a from your table.
        “Tabular Data Templates” page, “Format Items” tab (cell and mapped item selection)

      3. Select a mapped item from the pane at left of the “Selected Item Detail” section.

        1. Set the item’s formatting options via the pane at right (these will vary, based on the ).

            1. (there are no formatting options for custom data point items)

          2.

            1. (there are no formatting options for custom tag items, however a read-only “Tag Description” text box displays the “Description” value associated with the selected custom tag, as defined via the “Custom Tags” page)

          3.

            1. Use the “Format” drop-down list to specify the format of the numeric value. ()
              Option Details

              “n.nn” (default selection)

              Decimals based upon rounding level. Displays comma as thousands separator.

              “n.(n)(n)”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays comma as thousands separator.

              The period is also dropped if the format is set to 6 decimals.

              “(n).nn(n)”

              Decimals based upon rounding level, but drops first and/or last digit if zero. Displays comma as thousands separator.

              “(n).nn”

              Decimals based upon rounding level, but drops first digit if zero. Displays comma as thousands separator.

              “nnnn.nn(n)”

              Decimals based upon rounding level, but drops last digit if zero. Displays comma as thousands separator.

              “(nnn.n%)”

              Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays comma as thousands separator.

              If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “Custom Zero Display” value is numeric.

              “n,nn”

              Decimals based upon rounding level. Displays period as thousands separator.

              “n,(n)(n)”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays period as thousands separator.

              The comma is also dropped if the format is set to 6 decimals.

              “(n),nn(n)”

              Decimals based upon rounding level, but drops first and/or last digit if zero. Displays period as thousands separator.

              “(n),nn”

              Decimals based upon rounding level, but drops first digit if zero. Displays period as thousands separator.

              “nnnn,nn(n)”

              Decimals based upon rounding level, but drops last digit if zero. Displays period as thousands separator.

              “(nnn,n%)”

              Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays period as thousands separator.

              If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “>Custom Zero Display” value is numeric.

              “n nn [comma]”

              Decimals based upon rounding level. Displays space as thousands separator. Displays comma as decimal separator.

              “n nn [period]”

              Decimals based upon rounding level. Displays space as thousands separator. Displays period as decimal separator.

              “n (n)(n) [comma]”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays comma as decimal separator.

              The comma is also dropped if the format is set to 6 decimals.

              “n (n)(n) [period]”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays period as decimal separator.

              The period is also dropped if the format is set to 6 decimals.

              “1st, 2nd, 3rd”

              Ordinal (1st, 2nd, 3rd) represents the abbreviated ordinal version of the associated numeric.

              “First, Second, Third”

              Ordinal (First, Second, Third) represents the unabbreviated alpha ordinal of the associated numeric.

            2. Use the “Zero Display” drop-down list to specify the value to display if the data point’s raw value is zero. ()
              Option Details

              “0 - Decimals based on rounding level” (default selection)

              Puts a zero in front of the decimal (where applicable).

              • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”.
              • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).

              “0”

               

              “.0”

               

              “.00”

               

              “.000”

               

              “.0000”

               

              “.00000”

               

              “.000000”

               

              “0.0”

               

              “0.00”

               

              “0.000”

               

              “0.0000”

               

              “0.00000”

               

              “0.000000”

               

              “Blank”

               

              “Dash (-)”

               

              “Em Dash (—)”

               

              “n/a”

               

              “N/A”

               

              “zero”

               

              “Zero”

               

              “ZERO”

               

              “zero coupon”

               

              “Zero coupon”

               

              “Zero Coupon”

               

              “ZERO COUPON”

               

            3. Select the “Custom Zero Display” to specify a custom value to display if the data point’s raw value is zero.

              1. Click the at right of the check box to view/edit the custom value.
                1. Enter the desired value in the “Display Text” text box.

                2. Click the “Accept” button at lower-right of the dialogue.

              • The check box is cleared by default for newly-added data points.
              • The maximum character limit for the “Display Text” field is 64.
              • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom zero display feature is turned off for the currently-selected item; the specified “Zero Display” value will be used in output.

            4. Use the “Negative Display” drop-down list to specify the format of the numeric value if the data point’s raw value is negative. ()
              Option Sample

              “Parentheses” (default selection)

              (123456.78)

              “Negative Sign”

              -123456.78

              “Display as Positive”

              123456.78

            5. Select the “Display positive/negative values as negative/positive” to cause the sign of the value displayed in project preview and output to be “flipped” (similar to multiplying the value by negative 1).
              • The check box is cleared by default for newly-added data points.

              • Positive values will be displayed as negative.

                “100,000” becomes “(100,000)”

              • Negative values will be displayed as positive.

                “(100,000)” becomes “100,000”

              • When displaying a value as negative the specified “Negative Display” setting is used.

                • If the “Display as Positive” option is specified, all values are displayed as positive, regardless of whether or not the “Display positive/negative values as negative/positive” check box is selected.
              • This functionality impacts the display of data point values only; it does not alter any calculations within Arc Suite.

            6. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

              1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.
            7. Use the “Base Class” drop-down list to specify the class of the value.

          4. (not including “Exchange Rate”-type items)

            1. Use the “Format” drop-down list to specify the format of the numeric value. ()
              Option Details

              “n.nn” (default selection)

              Decimals based upon rounding level. Displays comma as thousands separator.

              “n.(n)(n)”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays comma as thousands separator.

              The period is also dropped if the format is set to 6 decimals.

              “(n).nn(n)”

              Decimals based upon rounding level, but drops first and/or last digit if zero. Displays comma as thousands separator.

              “(n).nn”

              Decimals based upon rounding level, but drops first digit if zero. Displays comma as thousands separator.

              “nnnn.nn(n)”

              Decimals based upon rounding level, but drops last digit if zero. Displays comma as thousands separator.

              “(nnn.n%)”

              Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays comma as thousands separator.

              If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “Custom Zero Display” value is numeric.

              “n,nn”

              Decimals based upon rounding level. Displays period as thousands separator.

              “n,(n)(n)”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays period as thousands separator.

              The comma is also dropped if the format is set to 6 decimals.

              “(n),nn(n)”

              Decimals based upon rounding level, but drops first and/or last digit if zero. Displays period as thousands separator.

              “(n),nn”

              Decimals based upon rounding level, but drops first digit if zero. Displays period as thousands separator.

              “nnnn,nn(n)”

              Decimals based upon rounding level, but drops last digit if zero. Displays period as thousands separator.

              “(nnn,n%)”

              Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays period as thousands separator.

              If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “>Custom Zero Display” value is numeric.

              “n nn [comma]”

              Decimals based upon rounding level. Displays space as thousands separator. Displays comma as decimal separator.

              “n nn [period]”

              Decimals based upon rounding level. Displays space as thousands separator. Displays period as decimal separator.

              “n (n)(n) [comma]”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays comma as decimal separator.

              The comma is also dropped if the format is set to 6 decimals.

              “n (n)(n) [period]”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays period as decimal separator.

              The period is also dropped if the format is set to 6 decimals.

              “1st, 2nd, 3rd”

              Ordinal (1st, 2nd, 3rd) represents the abbreviated ordinal version of the associated numeric.

              “First, Second, Third”

              Ordinal (First, Second, Third) represents the unabbreviated alpha ordinal of the associated numeric.

            2. Use the “Zero Display” drop-down list to specify the value to display if the data point’s raw value is zero. ()
              Option Details

              “0 - Decimals based on rounding level” (default selection)

              Puts a zero in front of the decimal (where applicable).

              • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”.
              • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).

              “0”

               

              “.0”

               

              “.00”

               

              “.000”

               

              “.0000”

               

              “.00000”

               

              “.000000”

               

              “0.0”

               

              “0.00”

               

              “0.000”

               

              “0.0000”

               

              “0.00000”

               

              “0.000000”

               

              “Blank”

               

              “Dash (-)”

               

              “Em Dash (—)”

               

              “n/a”

               

              “N/A”

               

              “zero”

               

              “Zero”

               

              “ZERO”

               

              “zero coupon”

               

              “Zero coupon”

               

              “Zero Coupon”

               

              “ZERO COUPON”

               

            3. Select the “Custom Zero Display” to specify a custom value to display if the data point’s raw value is zero.

              1. Click the at right of the check box to view/edit the custom value.
                1. Enter the desired value in the “Display Text” text box.

                2. Click the “Accept” button at lower-right of the dialogue.

              • The check box is cleared by default for newly-added data points.
              • The maximum character limit for the “Display Text” field is 64.
              • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom zero display feature is turned off for the currently-selected item; the specified “Zero Display” value will be used in output.

            4. Use the “Negative Display” drop-down list to specify the format of the numeric value if the data point’s raw value is negative. ()
              Option Sample

              “Parentheses” (default selection)

              (123456.78)

              “Negative Sign”

              -123456.78

              “Display as Positive”

              123456.78

            5. Select the “Display positive/negative values as negative/positive” to cause the sign of the value displayed in project preview and output to be “flipped” (similar to multiplying the value by negative 1).
              • The check box is cleared by default for newly-added data points.

              • Positive values will be displayed as negative.

                “100,000” becomes “(100,000)”

              • Negative values will be displayed as positive.

                “(100,000)” becomes “100,000”

              • When displaying a value as negative the specified “Negative Display” setting is used.

                • If the “Display as Positive” option is specified, all values are displayed as positive, regardless of whether or not the “Display positive/negative values as negative/positive” check box is selected.
              • This functionality impacts the display of data point values only; it does not alter any calculations within Arc Suite.

            6. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

              1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.

            7. Use the “Rounding” drop-down list to specify the rounding level of the number. ()
              Option Details

              “No Decimal” (default selection)

               

              “1 Decimal”

               

              “2 Decimals”

               

              “3 Decimals”

               

              “4 Decimals”

               

              “5 Decimals”

               

              “6 Decimals”

               

              “000’s”

               

              “000’s (suppressed)”

              Behaves like “000’s”, except that trailing zeros will be suppressed (e.g., “1,000” displays as “1”, “10,000” as “10”, “100,000” as “100”, etc.).

            1. Use the “Format” drop-down list to specify the format of the text string. ()
              Option Details

              “Proper”

              Converts text values that contain one or more lower-case characters to proper case, but will not alter any values that contain ALL upper-case characters.

              “Uppercase”

              Displays the text value in upper-case.

            2. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

              1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.

          6.

            1. Use the “Format” drop-down list to specify the format of the Boolean value. ()
              Option Details

              “Proper”

              Converts Boolean values that contain one or more lower-case characters to proper case, but will not alter any values that contain ALL upper-case characters.

              “Uppercase”

              Displays the Boolean value in upper-case.

            1. (there are no formatting options for literal items)

          8.

            1. (there are no formatting options for custom literal items, but you can edit the value of the item in the “Custom Literal” text box)

            2. Specify the language-specific caption for the custom literal item.

              1. If the “Multiple statements - same layout for all languages” option was selected via the “Multiple Language Options” dialogue, populate each row of the grid displayed in the “Selected Item Options” section (one row displays for each language assigned to the template). ()
                • The tabular data template contains two languages: English and French.

                • You map a custom literal with the text “Total Expenses” from the “Literals” tab.

                  Custom literal mapping (“Multiple statements - same layout for all languages” option)

                • The “Format Items” tab allows you to specify a caption for both languages.

                  Custom literal language-specific caption designation (“Multiple statements - same layout for all languages” option)

              2. If the “Multiple statements - different layout for each supported language” option was selected via the “Multiple Language Options” dialogue, designate the caption for the selected language in the grid displayed in the “Selected Item Options” section (only one row displays in the grid). ()
                • The tabular data template contains two languages: English and French.

                • You map a custom literal with the text “Total Expenses” from the “Literals” tab.

                  Custom literal mapping (“Multiple statements - different layout for each supported language” option)

                • The “Format Items” tab allows you to specify a caption for both languages independently. The language displayed in the grid represents the “Affected Language”.

                  Custom literal language-specific caption designation and “Affected Language” display (“Multiple statements - different layout for each supported language” option)

                • To provide a French caption, click the “Multiple Language Options” link and change the language in the drop-down list.

                  Custom literal language selection (“Multiple statements - different layout for each supported language” option)

              The output settings grid only displays the text that was mapped from the “Literals” tab, not the distinct captions specified on the “Format Items” tab.

          9.

            1. Use the “Format” drop-down list to specify the format of the date/time value. ()
              Option Details

              “(Ordinal suffix)”

              Displays an ordinal Suffix only. (English only)

              “d-M-yy”

              Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

              “d-M-yyyy”

              Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

              “d-M”

              Displays a numeric Day and Month only, removing the leading zero from each.

              “d-MM-yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “d-MM-yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “d-MM”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

              “d-MMM-yy”

              Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.

              “d-MMM-yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “d-MMM”

              Displays a numeric Day and 3-character Month abbreviation, removing the leading zero from the numeric Day.

              “d M yy”

              Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

              “d M yyyy”

              Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

              “d M, yy”

              Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

              “d M, yyyy”

              Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

              “d M”

              Displays a numeric Day and Month only, removing the leading zero from each.

              “d MM yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “d MM yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “d MM, yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “d MM, yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “d MM”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

              “d MMM yy”

              Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.

              “d MMM yyyy”

              Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year, removing the leading zero from the numeric Day.

              “d MMM, yy”

              Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.

              “d MMM, yyyy”

              Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year, removing the leading zero from the numeric Day.

              “d MMM”

              Displays a numeric Day and 3-character Month abbreviation, removing the leading zero from the numeric Day.

              “d MMMM (Upper)”

              Displays a numeric Day and uppercase spelled-out Month only, removing the leading zero from the numeric Day.

              “d MMMM yy”

              Displays a numeric Day and spelled-out Month, with a 2-digit Year, removing the leading zero from the numeric Day.

              “d MMMM yyyy”

              Displays a numeric Day and spelled-out Month, with a 4-digit Year, removing the leading zero from the numeric Day.

              “d MMMM, yy”

              Displays a numeric Day and spelled-out Month, with a 2-digit Year, removing the leading zero from the numeric Day.

              “d MMMM, yyyy”

              Displays a numeric Day and spelled-out Month, with a 4-digit Year, removing the leading zero from the numeric Day.

              “d MMMM”

              Displays a numeric Day and spelled-out Month only, removing the leading zero from the numeric Day.

              “d.M.yy”

              Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

              “d.M.yyyy”

              Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

              “d.M”

              Displays a numeric Day and Month only, removing the leading zero from each.

              “d.MM.yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “d.MM.yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “d.MM”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

              “d/M/yy”

              Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

              “d/M/yyyy”

              Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

              “d/M”

              Displays a numeric Day and Month only, removing the leading zero from each.

              “d/MM/yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “d/MM/yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “d/MM”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

              “d”

              Removes the leading zero, and displays a single Day only.

              “dd-M-yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “dd-M-yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “dd-M”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

              “dd-MM-yy”

              Displays a numeric Day and Month, with a 2-digit Year.

              “dd-MM-yyyy”

              Displays a numeric Day and Month, with a 4-digit Year.

              “dd-MM”

              Displays a numeric Day and Month only.

              “dd-MMM-yy”

              Displays a numeric Day and Month, with a 2-digit Year.

              “dd-MMM-yyyy”

              Displays a numeric Day and Month, with a 4-digit Year.

              “dd-MMM”

              Displays a numeric Day and 3-character Month abbreviation.

              “dd M yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “dd M yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “dd M, yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “dd M, yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “dd M”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

              “dd MM yy”

              Displays a numeric Day and Month, with a 2-digit Year.

              “dd MM yyyy”

              Displays a numeric Day and Month, with a 4-digit Year.

              “dd MM, yy”

              Displays a numeric Day and Month, with a 2-digit Year.

              “dd MM, yyyy”

              Displays a numeric Day and Month, with a 4-digit Year.

              “dd MMM yy”

              Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year.

              “dd MMM yyyy”

              Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.

              “dd MMM, yy”

              Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year.

              “dd MMM, yyyy”

              Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.

              “dd MMM”

              Displays a numeric Day and 3-character Month abbreviation.

              “dd MMMM (Upper)”

              Displays a numeric Day and uppercase spelled-out Month only.

              “dd MMMM yy”

              Displays a numeric Day and spelled-out Month, with a 2-digit Year.

              “dd MMMM yyyy”

              Displays a numeric Day and spelled-out Month, with a 4-digit Year.

              “dd MMMM, yy”

              Displays a numeric Day and spelled-out Month, with a 2-digit Year.

              “dd MMMM, yyyy”

              Displays a numeric Day and spelled-out Month, with a 4-digit Year.

              “dd MMMM”

              Displays a numeric Day and spelled-out Month only.

              “dd. MMM yyyy”

              Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.

              “dd. MMMM yyyy”

              Displays a numeric Day and spelled-out Month, with a 4-digit Year.

              “dd.M.yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “dd.M.yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “dd.M”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

              “dd.MM.yy”

              Displays a numeric Day and Month, with a 2-digit Year.

              “dd.MM.yyyy”

              Displays a numeric Day and Month, with a 4-digit Year.

              “dd.MM”

              Displays a numeric Day and Month only.

              “dd/M/yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “dd/M/yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “dd/M”

              Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

              “dd/MM/yy”

              Displays a numeric Day and Month, with a 2-digit Year.

              “dd/MM/yyyy”

              Displays a numeric Day and Month, with a 4-digit Year.

              “dd/MM”

              Displays a numeric Day and Month only.

              “dd”

              Displays a 2-digit Day only.

              “M-d-yy”

              Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

              “M-d-yyyy”

              Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

              “M-d”

              Displays a numeric Month and Day only, removing the leading zero from each.

              “M-dd-yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “M-dd-yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “M-dd”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

              “M d yy”

              Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

              “M d yyyy”

              Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

              “M d”

              Displays a numeric Month and Day only, removing the leading zero from each.

              “M dd yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “M dd yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “M dd”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

              “M.d.yy”

              Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

              “M.d.yyyy”

              Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

              “M.d”

              Displays a numeric Month and Day only, removing the leading zero from each.

              “M.dd.yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “M.dd.yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “M.dd”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

              “M/d/yy”

              Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

              “M/d/yyyy”

              Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

              “M/d”

              Displays a numeric Month and Day only, removing the leading zero from each.

              “M/dd/yy”

              Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

              “M/dd/yyyy”

              Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

              “M/dd”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

              “M”

              Removes the leading zero, and displays a single numeric Month only.

              “MM-d-yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “MM-d-yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “MM-d”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

              “MM-dd-yy”

              Displays a numeric Month and Day, with a 2-digit Year.

              “MM-dd-yyyy”

              Displays a numeric Month and Day, with a 4-digit Year.

              “MM-dd”

              Displays a numeric Month and Day only.

              “MM d yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “MM d yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “MM d”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

              “MM dd yy”

              Displays a numeric Month and Day, with a 2-digit Year.

              “MM dd yyyy”

              Displays a numeric Month and Day, with a 4-digit Year.

              “MM dd”

              Displays a numeric Month and Day only.

              “MM.d.yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “MM.d.yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “MM.d”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

              “MM.dd.yy”

              Displays a numeric Month and Day, with a 2-digit Year.

              “MM.dd.yyyy”

              Displays a numeric Month and Day, with a 4-digit Year.

              “MM.dd”

              Displays a numeric Month and Day only.

              “MM/d/yy”

              Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

              “MM/d/yyyy”

              Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

              “MM/d”

              Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

              “MM/dd/yy”

              Displays a numeric Month and Day, with a 2-digit Year.

              “MM/dd/yyyy”

              Displays a numeric Month and Day, with a 4-digit Year.

              “MM/dd”

              Displays a numeric Month and Day only.

              “MM/yy”

              Displays a numeric Month, with a 2-digit Year.

              “MM”

              Displays a numeric Month only.

              “MMM (Upper)”

              Displays an uppercase 3-character Month abbreviation only.

              “MMM d (Ordinal)”

              Displays a 3-character Month abbreviation and ordinal Day only.

              “MMM d, yy”

              Displays a 3-character Month abbreviation and numeric Day, with a 2-digit Year, removing the leading zero from the numeric Day.

              “MMM d, yyyy”

              Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year, removing the leading zero from the numeric Day.

              “MMM d”

              Displays a 3-character Month abbreviation and numeric Day only, removing the leading zero from the numeric Day.

              “MMM dd, yy”

              Displays a 3-character Month abbreviation and numeric Day, with a 2-digit Year.

              “MMM dd, yyyy”

              Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year.

              “MMM dd. yyyy”

              Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year.

              “MMM dd”

              Displays a 3-character Month abbreviation and numeric Day only.

              “MMM yy”

              Displays a 3-character Month abbreviation, with a 2-digit Year.

              “MMM yyyy”

              Displays a 3-character Month abbreviation, with a 4-digit Year.

              “MMM”

              Displays a 3-character Month abbreviation only.

              “MMMM (Upper)”

              Displays an uppercase spelled-out Month only.

              “MMMM d, yy”

              Displays a spelled-out Month and numeric Day, with a 2-digit Year, removing the leading zero from the numeric Day.

              “MMMM d, yyyy”

              Displays a spelled-out Month and numeric Day, with a 4-digit Year, removing the leading zero from the numeric Day.

              “MMMM d”

              Displays a spelled-out Month and numeric Day only, removing the leading zero from the numeric Day.

              “MMMM dd, yy”

              Displays a spelled-out Month and numeric Day, with a 2-digit Year.

              “MMMM dd, yyyy” (default selection)

              Displays a spelled-out Month and numeric Day, with a 4-digit Year.

              “MMMM dd”

              Displays a spelled-out Month and numeric Day only.

              “MMMM yy”

              Displays a spelled-out Month, with a 2-digit Year.

              “MMMM yyyy”

              Displays a spelled-out Month, with a 4-digit Year.

              “MMMM”

              Displays a spelled-out Month only.

              “yy”

              Displays a 2-digit Year only.

              “yyyy”

              Displays a 4-digit Year only.

            2. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

              1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.

          10.

            1. Use the “Format” drop-down list to specify the format of the numeric value. ()
              Option Details

              “n.nn” (default selection)

              Decimals based upon rounding level. Displays comma as thousands separator.

              “n.(n)(n)”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays comma as thousands separator.

              The period is also dropped if the format is set to 6 decimals.

              “(n).nn(n)”

              Decimals based upon rounding level, but drops first and/or last digit if zero. Displays comma as thousands separator.

              “(n).nn”

              Decimals based upon rounding level, but drops first digit if zero. Displays comma as thousands separator.

              “nnnn.nn(n)”

              Decimals based upon rounding level, but drops last digit if zero. Displays comma as thousands separator.

              “(nnn.n%)”

              Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays comma as thousands separator.

              If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “Custom Zero Display” value is numeric.

              “n,nn”

              Decimals based upon rounding level. Displays period as thousands separator.

              “n,(n)(n)”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays period as thousands separator.

              The comma is also dropped if the format is set to 6 decimals.

              “(n),nn(n)”

              Decimals based upon rounding level, but drops first and/or last digit if zero. Displays period as thousands separator.

              “(n),nn”

              Decimals based upon rounding level, but drops first digit if zero. Displays period as thousands separator.

              “nnnn,nn(n)”

              Decimals based upon rounding level, but drops last digit if zero. Displays period as thousands separator.

              “(nnn,n%)”

              Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays period as thousands separator.

              If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “>Custom Zero Display” value is numeric.

              “n nn [comma]”

              Decimals based upon rounding level. Displays space as thousands separator. Displays comma as decimal separator.

              “n nn [period]”

              Decimals based upon rounding level. Displays space as thousands separator. Displays period as decimal separator.

              “n (n)(n) [comma]”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays comma as decimal separator.

              The comma is also dropped if the format is set to 6 decimals.

              “n (n)(n) [period]”

              Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays period as decimal separator.

              The period is also dropped if the format is set to 6 decimals.

              “1st, 2nd, 3rd”

              Ordinal (1st, 2nd, 3rd) represents the abbreviated ordinal version of the associated numeric.

              “First, Second, Third”

              Ordinal (First, Second, Third) represents the unabbreviated alpha ordinal of the associated numeric.

            2. Use the “Zero Display” drop-down list to specify the value to display if the data point’s raw value is zero. ()
              Option Details

              “0 - Decimals based on rounding level” (default selection)

              Puts a zero in front of the decimal (where applicable).

              • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”.
              • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).

              “0”

               

              “.0”

               

              “.00”

               

              “.000”

               

              “.0000”

               

              “.00000”

               

              “.000000”

               

              “0.0”

               

              “0.00”

               

              “0.000”

               

              “0.0000”

               

              “0.00000”

               

              “0.000000”

               

              “Blank”

               

              “Dash (-)”

               

              “Em Dash (—)”

               

              “n/a”

               

              “N/A”

               

              “zero”

               

              “Zero”

               

              “ZERO”

               

              “zero coupon”

               

              “Zero coupon”

               

              “Zero Coupon”

               

              “ZERO COUPON”

               

            3. Select the “Custom Zero Display” to specify a custom value to display if the data point’s raw value is zero.

              1. Click the at right of the check box to view/edit the custom value.
                1. Enter the desired value in the “Display Text” text box.

                2. Click the “Accept” button at lower-right of the dialogue.

              • The check box is cleared by default for newly-added data points.
              • The maximum character limit for the “Display Text” field is 64.
              • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom zero display feature is turned off for the currently-selected item; the specified “Zero Display” value will be used in output.

            4. Use the “Negative Display” drop-down list to specify the format of the numeric value if the data point’s raw value is negative. ()
              Option Sample

              “Parentheses” (default selection)

              (123456.78)

              “Negative Sign”

              -123456.78

              “Display as Positive”

              123456.78

            5. Select the “Display positive/negative values as negative/positive” to cause the sign of the value displayed in project preview and output to be “flipped” (similar to multiplying the value by negative 1).
              • The check box is cleared by default for newly-added data points.

              • Positive values will be displayed as negative.

                “100,000” becomes “(100,000)”

              • Negative values will be displayed as positive.

                “(100,000)” becomes “100,000”

              • When displaying a value as negative the specified “Negative Display” setting is used.

                • If the “Display as Positive” option is specified, all values are displayed as positive, regardless of whether or not the “Display positive/negative values as negative/positive” check box is selected.
              • This functionality impacts the display of data point values only; it does not alter any calculations within Arc Suite.

            6. Use the “Rounding” drop-down list to specify the rounding level of the number. ()
              Option Details

              “No Decimal” (default selection)

               

              “1 Decimal”

               

              “2 Decimals”

               

              “3 Decimals”

               

              “4 Decimals”

               

              “5 Decimals”

               

              “6 Decimals”

               

              “000’s”

               

              “000’s (suppressed)”

              Behaves like “000’s”, except that trailing zeros will be suppressed (e.g., “1,000” displays as “1”, “10,000” as “10”, “100,000” as “100”, etc.).
            7. Use the “From Currency” drop-down list to specify the base currency involved in the exchange rate calculation for the mapped item.
            8. Use the “To Currency” drop-down list to specify the currency to which the base currency is converted in the exchange rate calculation for the mapped item.

            9. Use the “To Currency” drop-down list to designate the exchange rate source whose associated exchange rate for the specified currencies will be used in the exchange rate calculation for the mapped item.

              The first record (alphabetically) in the Exchange Rate Sources library is selected by default when an item is mapped.

            10. Indicate the time at which the exchange rate will be calculated for the mapped item using the “Time” text box and associated selection button.

              “12:00 AM” is specified by default when an item is mapped.

            11. Use the “Time Zone” drop-down list to designate the time zone associated with the specified time.

              “(GMT) Dublin, Edinburgh, Lisbon, London” is specified by default when an item is mapped.

        2. Specify the of a selected item.

          1. Select an item within the cell, and then click the “Format Item” at lower-left of the pane to view/edit item settings.
            “Format Item” dialogue
            1. Specify formatting settings, as required.

            2. Click the “Accept” button at lower-right of the dialogue.

            • When editing an item whose style formatting has been set previously (whether via the “Format Item”, “Format Cell”, “Format Row” or “Format Column” dialogues), the check box state of each setting will reflect the current respective settings of the item.
            • When editing an item whose position formatting has been set previously via the “Format Item” dialogue, the option button selection will reflect the current position setting of the item.
            • Formatting settings made via the “Format Item” dialogue are not reflected in the component preview on the “Project” page; only in output.
        3. Move a selected item up or down (left or right) using the “Move item up” and “Move item down” buttons   at lower-left of the pane.
        4. Remove selected items from the column via the “Remove item” button at lower-left of the pane.

    13. Click the “Save” button at lower-right of the page.

    1. Expand the ArcFiling “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    2. Expand the ArcReporting “Structure Templates” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

      3. Click the “Administration” at lower-left of the screen.
        “Administration” tab

      4. Click the “Structure Templates” menu to view available items.

    3. Click the “Tabular Data Templates” item.

      “Tabular Data Templates” page

    4. Click the “Output Settings” at lower-right of the “Detail” pane to view/edit settings that affect the display and behavior of table information in output.
      “Tabular Data Templates” page, “Output Settings” link
      “Tabular Data Template Output Settings” page
      • You can also open the “Tabular Data Template Output Settings” page directly by clicking the corresponding item in the “Structure Templates” menu section on the “Administration” tab .
      • Click the “Refresh data” button at lower-right of the pane to refresh content to reflect any changes made to the output settings’ associated template.

    5. Select the desired item from the “Listing” pane at left of the page.

    6. Review and edit information for the item in the “Detail” at right of the page.

      1. If more than one language is associated with the tabular data template, specify .

        1. Click the “Multiple Language Options” at upper-right of the “Detail” pane to indicate whether the layout will be the same or different for each language.
          1. Select the “Multiple Statements - same layout for all languages” option (default) if you want all cell mappings, span areas, row and column positions and item formatting to be applied to all languages added to the tabular data template.
          2. Select the “Multiple statements - different layout for each supported language” option if you want cell mappings, span areas, row and column positions and item formatting specified for the selected language to apply only to that language.

          3. Click the “Accept” button at lower-right of the dialogue.

      2. If necessary, adjust the “Number of Rows” and “Number of Columns” for the table that displays in the “Detail” at right of the page, using the slider controls located along the top and right side of the table.
        • The number of rows and columns set via the “Tabular Data Template Output Settings” page will be reflected in the table’s associated template (accessed via the “Tabular Data Templates” page).
        • You can create table structures with up to 500 rows and 20 columns.
      3. If any row in the table that displays in the “Detail” pane at right of the page represents a heading, select the “Header Row” check box for that row.

      4. Add data points, custom tags and standard (e.g., “$”, “%”, “€”, “£”, etc.) or custom literal values to the .

        1. Add data points and literal values by them from their respective panes on the tabs at the bottom of the page.
          “Tabular Data Templates” page (item mapping)

        2. Add custom tags via the associated at lower-left of the grid.

          1. Select a cell in the grid, and then click the “Insert custom tag” to define the custom tag settings.
            “Insert Custom Tag” dialogue

            1. Specify the tag to insert via the “Custom Tag” drop-down list.

            2. If the specified custom tag has the “Additional Fixed Options” check box selected in the Custom Tags library, select one of the available options via the “Additional Fixed Option” drop-down list (the drop-down list is disabled if no fixed options are defined for the selected tag).

            3. If the specified custom tag has the “Additional Arguments” check box selected in the Custom Tags library, enter the appropriate argument(s) in the “Additional Argument(s)” text box.

              For a custom tag requiring additional arguments, it is helpful to provide definitions and/or examples of argument values in the “Description” field when creating/editing the tag via the “Custom Tags” page. This offers some guidance to any user who insert the tag in a text editor.

            4. Click the “Accept” button at lower-right of the dialogue.

        • If multiple items are added to any given cell, new items are appended by default to the right of existing items in the cell. Items can be removed from cells, and the order of items in the cell can be adjusted, using the controls on the “Format Items” tab (see below).
        • To create a custom literal item, type the desired text in the box on the right of the “Literals” tab. The text for the “{custom}” item at the top of the “Literals” pane reflects the text you enter, and that item can be dragged-and-dropped to the appropriate cell of your table to insert the custom literal.
        • Hard returns, soft returns, tabs and spaces can also be added to cells of the table. Items representing these can be found at the end of the list of literals provided.
        • When “Custom Data Point” is the specified data point type, a “Library” drop-down list displays through which you can designate the data point library containing the desired data points to map. Only those libraries associated with the same complex as the current template are available for selection.
      5. At any point during the mapping process, you can move entire rows and columns within the grid up/down/left/right by clicking the header of the desired row/column to select it, and then clicking the positioning buttons     appropriately.

      6. You can merge cells in the grid across columns and/or rows by selecting the cell representing the upper-left cell of the range, and then clicking the “Span cells” beneath the grid.
        “Span Cells” dialogue

        Typically, this functionality is used to merge top row columns to create a table header that spans all columns within a table.

        1. Specify the “Number of Columns to Span” using the corresponding spinner control on the dialogue.
        2. Specify the “Number of Rows to Span” using the corresponding spinner control on the dialogue.

        3. Click the “Accept” button at lower-right of the dialogue.

          • Any data that was in the upper-left (start) cell of the specified span area will be displayed in the span area text box of the grid; any data in any other cells of the span area range will be deleted.
          • Multiple span areas may exist within a table, but span areas cannot overlap.
          • All row and column positioning buttons are disabled when at least one span area exists in a given template’s grid.

        Click the “Remove Span” button beneath the grid to remove any selected span area.

      7. Indicate the cell style and (e.g., bold, italic, underline, color, alignment, etc.) to the text of mapped items.

        1. Format the within a selected cell.

          Select a cell in the grid, and then click the “Format Cell” at lower-left of the grid to view/edit cell settings.
          “Format Cell” dialogue
          1. Specify formatting settings, as required.

          2. Click the “Accept” button at lower-right of the dialogue.

          • When the dialogue is opened, Arc Suite examines the settings of all items in the currently-selected cell to determine what each check box on the dialogue will display.

            • Cleared

              • All items in the currently-selected cell have the attribute cleared.

            • Selected

              • All items in the currently-selected cell have the attribute selected.

            • Mixed/Indeterminate

              • Some items in the currently-selected cell have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” dialogue).
              • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cell.
          • Formatting settings made via the “Format Cell” dialogue are not reflected in the component preview on the “Project” page; only in output.

        2. Format the within all the cells of a selected row.

          1. Select a cell in the grid, and then click the “Format Row” at lower-left of the grid to view/edit row settings.
            “Format Row” dialogue
            1. Specify formatting settings, as required.

            2. Click the “Accept” button at lower-right of the dialogue.

            • When the dialogue is opened, Arc Suite examines the settings of all items in all cells of the currently-selected row to determine what each check box on the dialogue will display.

              • Cleared

                • All items in all cells of the currently-selected row have the attribute cleared.

              • Selected

                • All items in all cells of the currently-selected row have the attribute selected.

              • Mixed/Indeterminate

                • Some items in one or more cells of the currently-selected row have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” and/or “Format Column” dialogues).
                • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cells of the selected row.
            • Formatting settings made via the “Format Row” dialogue are not reflected in the component preview on the “Project” page; only in output.

        3. Format the within all the cells of a selected column.

          1. Select a cell in the grid, and then click the “Format Column” at lower-left of the grid to view/edit column settings.
            “Format Column” dialogue
            1. Specify formatting settings, as required.

            2. Click the “Accept” button at lower-right of the dialogue.

            • When the dialogue is opened, Arc Suite examines the settings of all items in all cells of the currently-selected column to determine what each check box on the dialogue will display.

              • Cleared

                • All items in all cells of the currently-selected column have the attribute cleared.

              • Selected

                • All items in all cells of the currently-selected column have the attribute selected.

              • Mixed/Indeterminate

                • Some items in one or more cells of the currently-selected column have the attribute cleared and some have the attribute selected (distinct settings were specified via the “Format Item” and/or “Format Row” dialogues).
                • If the check box is not explicitly cleared or selected prior to clicking the “Accept” button, no change will be made to the respective attribute settings for items in the cells of the selected column.
            • Formatting settings made via the “Format Column” dialogue are not reflected in the component preview on the “Project” page; only in output.

        To better understand how project output can be impacted by leveraging different styles, table types and custom tags, click the “Style Guide” link on the page.

      8. Specify of specific items within selected cells.

        1. Click the “Format Items” tab.

        2. Select a from your table.
          “Tabular Data Templates” page, “Format Items” tab (cell and mapped item selection)

        3. Select a mapped item from the pane at left of the “Selected Item Detail” section.

          1. Set the item’s formatting options via the pane at right (these will vary, based on the ).

              1. (there are no formatting options for custom data point items)

            2.

              1. (there are no formatting options for custom tag items, however a read-only “Tag Description” text box displays the “Description” value associated with the selected custom tag, as defined via the “Custom Tags” page)

            3.

              1. Use the “Format” drop-down list to specify the format of the numeric value. ()
                Option Details

                “n.nn” (default selection)

                Decimals based upon rounding level. Displays comma as thousands separator.

                “n.(n)(n)”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays comma as thousands separator.

                The period is also dropped if the format is set to 6 decimals.

                “(n).nn(n)”

                Decimals based upon rounding level, but drops first and/or last digit if zero. Displays comma as thousands separator.

                “(n).nn”

                Decimals based upon rounding level, but drops first digit if zero. Displays comma as thousands separator.

                “nnnn.nn(n)”

                Decimals based upon rounding level, but drops last digit if zero. Displays comma as thousands separator.

                “(nnn.n%)”

                Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays comma as thousands separator.

                If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “Custom Zero Display” value is numeric.

                “n,nn”

                Decimals based upon rounding level. Displays period as thousands separator.

                “n,(n)(n)”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays period as thousands separator.

                The comma is also dropped if the format is set to 6 decimals.

                “(n),nn(n)”

                Decimals based upon rounding level, but drops first and/or last digit if zero. Displays period as thousands separator.

                “(n),nn”

                Decimals based upon rounding level, but drops first digit if zero. Displays period as thousands separator.

                “nnnn,nn(n)”

                Decimals based upon rounding level, but drops last digit if zero. Displays period as thousands separator.

                “(nnn,n%)”

                Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays period as thousands separator.

                If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “>Custom Zero Display” value is numeric.

                “n nn [comma]”

                Decimals based upon rounding level. Displays space as thousands separator. Displays comma as decimal separator.

                “n nn [period]”

                Decimals based upon rounding level. Displays space as thousands separator. Displays period as decimal separator.

                “n (n)(n) [comma]”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays comma as decimal separator.

                The comma is also dropped if the format is set to 6 decimals.

                “n (n)(n) [period]”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays period as decimal separator.

                The period is also dropped if the format is set to 6 decimals.

                “1st, 2nd, 3rd”

                Ordinal (1st, 2nd, 3rd) represents the abbreviated ordinal version of the associated numeric.

                “First, Second, Third”

                Ordinal (First, Second, Third) represents the unabbreviated alpha ordinal of the associated numeric.

              2. Use the “Zero Display” drop-down list to specify the value to display if the data point’s raw value is zero. ()
                Option Details

                “0 - Decimals based on rounding level” (default selection)

                Puts a zero in front of the decimal (where applicable).

                • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”.
                • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).

                “0”

                 

                “.0”

                 

                “.00”

                 

                “.000”

                 

                “.0000”

                 

                “.00000”

                 

                “.000000”

                 

                “0.0”

                 

                “0.00”

                 

                “0.000”

                 

                “0.0000”

                 

                “0.00000”

                 

                “0.000000”

                 

                “Blank”

                 

                “Dash (-)”

                 

                “Em Dash (—)”

                 

                “n/a”

                 

                “N/A”

                 

                “zero”

                 

                “Zero”

                 

                “ZERO”

                 

                “zero coupon”

                 

                “Zero coupon”

                 

                “Zero Coupon”

                 

                “ZERO COUPON”

                 

              3. Select the “Custom Zero Display” to specify a custom value to display if the data point’s raw value is zero.

                1. Click the at right of the check box to view/edit the custom value.
                  1. Enter the desired value in the “Display Text” text box.

                  2. Click the “Accept” button at lower-right of the dialogue.

                • The check box is cleared by default for newly-added data points.
                • The maximum character limit for the “Display Text” field is 64.
                • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom zero display feature is turned off for the currently-selected item; the specified “Zero Display” value will be used in output.

              4. Use the “Negative Display” drop-down list to specify the format of the numeric value if the data point’s raw value is negative. ()
                Option Sample

                “Parentheses” (default selection)

                (123456.78)

                “Negative Sign”

                -123456.78

                “Display as Positive”

                123456.78

              5. Select the “Display positive/negative values as negative/positive” to cause the sign of the value displayed in project preview and output to be “flipped” (similar to multiplying the value by negative 1).
                • The check box is cleared by default for newly-added data points.

                • Positive values will be displayed as negative.

                  “100,000” becomes “(100,000)”

                • Negative values will be displayed as positive.

                  “(100,000)” becomes “100,000”

                • When displaying a value as negative the specified “Negative Display” setting is used.

                  • If the “Display as Positive” option is specified, all values are displayed as positive, regardless of whether or not the “Display positive/negative values as negative/positive” check box is selected.
                • This functionality impacts the display of data point values only; it does not alter any calculations within Arc Suite.

              6. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

                1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.
              7. Use the “Base Class” drop-down list to specify the class of the value.

            4. (not including “Exchange Rate”-type items)

              1. Use the “Format” drop-down list to specify the format of the numeric value. ()
                Option Details

                “n.nn” (default selection)

                Decimals based upon rounding level. Displays comma as thousands separator.

                “n.(n)(n)”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays comma as thousands separator.

                The period is also dropped if the format is set to 6 decimals.

                “(n).nn(n)”

                Decimals based upon rounding level, but drops first and/or last digit if zero. Displays comma as thousands separator.

                “(n).nn”

                Decimals based upon rounding level, but drops first digit if zero. Displays comma as thousands separator.

                “nnnn.nn(n)”

                Decimals based upon rounding level, but drops last digit if zero. Displays comma as thousands separator.

                “(nnn.n%)”

                Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays comma as thousands separator.

                If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “Custom Zero Display” value is numeric.

                “n,nn”

                Decimals based upon rounding level. Displays period as thousands separator.

                “n,(n)(n)”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays period as thousands separator.

                The comma is also dropped if the format is set to 6 decimals.

                “(n),nn(n)”

                Decimals based upon rounding level, but drops first and/or last digit if zero. Displays period as thousands separator.

                “(n),nn”

                Decimals based upon rounding level, but drops first digit if zero. Displays period as thousands separator.

                “nnnn,nn(n)”

                Decimals based upon rounding level, but drops last digit if zero. Displays period as thousands separator.

                “(nnn,n%)”

                Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays period as thousands separator.

                If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “>Custom Zero Display” value is numeric.

                “n nn [comma]”

                Decimals based upon rounding level. Displays space as thousands separator. Displays comma as decimal separator.

                “n nn [period]”

                Decimals based upon rounding level. Displays space as thousands separator. Displays period as decimal separator.

                “n (n)(n) [comma]”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays comma as decimal separator.

                The comma is also dropped if the format is set to 6 decimals.

                “n (n)(n) [period]”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays period as decimal separator.

                The period is also dropped if the format is set to 6 decimals.

                “1st, 2nd, 3rd”

                Ordinal (1st, 2nd, 3rd) represents the abbreviated ordinal version of the associated numeric.

                “First, Second, Third”

                Ordinal (First, Second, Third) represents the unabbreviated alpha ordinal of the associated numeric.

              2. Use the “Zero Display” drop-down list to specify the value to display if the data point’s raw value is zero. ()
                Option Details

                “0 - Decimals based on rounding level” (default selection)

                Puts a zero in front of the decimal (where applicable).

                • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”.
                • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).

                “0”

                 

                “.0”

                 

                “.00”

                 

                “.000”

                 

                “.0000”

                 

                “.00000”

                 

                “.000000”

                 

                “0.0”

                 

                “0.00”

                 

                “0.000”

                 

                “0.0000”

                 

                “0.00000”

                 

                “0.000000”

                 

                “Blank”

                 

                “Dash (-)”

                 

                “Em Dash (—)”

                 

                “n/a”

                 

                “N/A”

                 

                “zero”

                 

                “Zero”

                 

                “ZERO”

                 

                “zero coupon”

                 

                “Zero coupon”

                 

                “Zero Coupon”

                 

                “ZERO COUPON”

                 

              3. Select the “Custom Zero Display” to specify a custom value to display if the data point’s raw value is zero.

                1. Click the at right of the check box to view/edit the custom value.
                  1. Enter the desired value in the “Display Text” text box.

                  2. Click the “Accept” button at lower-right of the dialogue.

                • The check box is cleared by default for newly-added data points.
                • The maximum character limit for the “Display Text” field is 64.
                • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom zero display feature is turned off for the currently-selected item; the specified “Zero Display” value will be used in output.

              4. Use the “Negative Display” drop-down list to specify the format of the numeric value if the data point’s raw value is negative. ()
                Option Sample

                “Parentheses” (default selection)

                (123456.78)

                “Negative Sign”

                -123456.78

                “Display as Positive”

                123456.78

              5. Select the “Display positive/negative values as negative/positive” to cause the sign of the value displayed in project preview and output to be “flipped” (similar to multiplying the value by negative 1).
                • The check box is cleared by default for newly-added data points.

                • Positive values will be displayed as negative.

                  “100,000” becomes “(100,000)”

                • Negative values will be displayed as positive.

                  “(100,000)” becomes “100,000”

                • When displaying a value as negative the specified “Negative Display” setting is used.

                  • If the “Display as Positive” option is specified, all values are displayed as positive, regardless of whether or not the “Display positive/negative values as negative/positive” check box is selected.
                • This functionality impacts the display of data point values only; it does not alter any calculations within Arc Suite.

              6. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

                1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.

              7. Use the “Rounding” drop-down list to specify the rounding level of the number. ()
                Option Details

                “No Decimal” (default selection)

                 

                “1 Decimal”

                 

                “2 Decimals”

                 

                “3 Decimals”

                 

                “4 Decimals”

                 

                “5 Decimals”

                 

                “6 Decimals”

                 

                “000’s”

                 

                “000’s (suppressed)”

                Behaves like “000’s”, except that trailing zeros will be suppressed (e.g., “1,000” displays as “1”, “10,000” as “10”, “100,000” as “100”, etc.).

              1. Use the “Format” drop-down list to specify the format of the text string. ()
                Option Details

                “Proper”

                Converts text values that contain one or more lower-case characters to proper case, but will not alter any values that contain ALL upper-case characters.

                “Uppercase”

                Displays the text value in upper-case.

              2. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

                1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.

            6.

              1. Use the “Format” drop-down list to specify the format of the Boolean value. ()
                Option Details

                “Proper”

                Converts Boolean values that contain one or more lower-case characters to proper case, but will not alter any values that contain ALL upper-case characters.

                “Uppercase”

                Displays the Boolean value in upper-case.

              1. (there are no formatting options for literal items)

            8.

              1. (there are no formatting options for custom literal items, but you can edit the value of the item in the “Custom Literal” text box)

              2. Specify the language-specific caption for the custom literal item.

                1. If the “Multiple statements - same layout for all languages” option was selected via the “Multiple Language Options” dialogue, populate each row of the grid displayed in the “Selected Item Options” section (one row displays for each language assigned to the template). ()
                  • The tabular data template contains two languages: English and French.

                  • You map a custom literal with the text “Total Expenses” from the “Literals” tab.

                    Custom literal mapping (“Multiple statements - same layout for all languages” option)

                  • The “Format Items” tab allows you to specify a caption for both languages.

                    Custom literal language-specific caption designation (“Multiple statements - same layout for all languages” option)

                2. If the “Multiple statements - different layout for each supported language” option was selected via the “Multiple Language Options” dialogue, designate the caption for the selected language in the grid displayed in the “Selected Item Options” section (only one row displays in the grid). ()
                  • The tabular data template contains two languages: English and French.

                  • You map a custom literal with the text “Total Expenses” from the “Literals” tab.

                    Custom literal mapping (“Multiple statements - different layout for each supported language” option)

                  • The “Format Items” tab allows you to specify a caption for both languages independently. The language displayed in the grid represents the “Affected Language”.

                    Custom literal language-specific caption designation and “Affected Language” display (“Multiple statements - different layout for each supported language” option)

                  • To provide a French caption, click the “Multiple Language Options” link and change the language in the drop-down list.

                    Custom literal language selection (“Multiple statements - different layout for each supported language” option)

                The output settings grid only displays the text that was mapped from the “Literals” tab, not the distinct captions specified on the “Format Items” tab.

            9.

              1. Use the “Format” drop-down list to specify the format of the date/time value. ()
                Option Details

                “(Ordinal suffix)”

                Displays an ordinal Suffix only. (English only)

                “d-M-yy”

                Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

                “d-M-yyyy”

                Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

                “d-M”

                Displays a numeric Day and Month only, removing the leading zero from each.

                “d-MM-yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “d-MM-yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “d-MM”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

                “d-MMM-yy”

                Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.

                “d-MMM-yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “d-MMM”

                Displays a numeric Day and 3-character Month abbreviation, removing the leading zero from the numeric Day.

                “d M yy”

                Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

                “d M yyyy”

                Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

                “d M, yy”

                Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

                “d M, yyyy”

                Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

                “d M”

                Displays a numeric Day and Month only, removing the leading zero from each.

                “d MM yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “d MM yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “d MM, yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “d MM, yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “d MM”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

                “d MMM yy”

                Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.

                “d MMM yyyy”

                Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year, removing the leading zero from the numeric Day.

                “d MMM, yy”

                Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year, removing the leading zero from the numeric Day.

                “d MMM, yyyy”

                Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year, removing the leading zero from the numeric Day.

                “d MMM”

                Displays a numeric Day and 3-character Month abbreviation, removing the leading zero from the numeric Day.

                “d MMMM (Upper)”

                Displays a numeric Day and uppercase spelled-out Month only, removing the leading zero from the numeric Day.

                “d MMMM yy”

                Displays a numeric Day and spelled-out Month, with a 2-digit Year, removing the leading zero from the numeric Day.

                “d MMMM yyyy”

                Displays a numeric Day and spelled-out Month, with a 4-digit Year, removing the leading zero from the numeric Day.

                “d MMMM, yy”

                Displays a numeric Day and spelled-out Month, with a 2-digit Year, removing the leading zero from the numeric Day.

                “d MMMM, yyyy”

                Displays a numeric Day and spelled-out Month, with a 4-digit Year, removing the leading zero from the numeric Day.

                “d MMMM”

                Displays a numeric Day and spelled-out Month only, removing the leading zero from the numeric Day.

                “d.M.yy”

                Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

                “d.M.yyyy”

                Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

                “d.M”

                Displays a numeric Day and Month only, removing the leading zero from each.

                “d.MM.yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “d.MM.yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “d.MM”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

                “d/M/yy”

                Removes the leading zero from the numeric Day and Month, and displays a 2-digit Year.

                “d/M/yyyy”

                Removes the leading zero from the numeric Day and Month, and displays a 4-digit Year.

                “d/M”

                Displays a numeric Day and Month only, removing the leading zero from each.

                “d/MM/yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “d/MM/yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “d/MM”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Day only.

                “d”

                Removes the leading zero, and displays a single Day only.

                “dd-M-yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “dd-M-yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “dd-M”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

                “dd-MM-yy”

                Displays a numeric Day and Month, with a 2-digit Year.

                “dd-MM-yyyy”

                Displays a numeric Day and Month, with a 4-digit Year.

                “dd-MM”

                Displays a numeric Day and Month only.

                “dd-MMM-yy”

                Displays a numeric Day and Month, with a 2-digit Year.

                “dd-MMM-yyyy”

                Displays a numeric Day and Month, with a 4-digit Year.

                “dd-MMM”

                Displays a numeric Day and 3-character Month abbreviation.

                “dd M yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “dd M yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “dd M, yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “dd M, yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “dd M”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

                “dd MM yy”

                Displays a numeric Day and Month, with a 2-digit Year.

                “dd MM yyyy”

                Displays a numeric Day and Month, with a 4-digit Year.

                “dd MM, yy”

                Displays a numeric Day and Month, with a 2-digit Year.

                “dd MM, yyyy”

                Displays a numeric Day and Month, with a 4-digit Year.

                “dd MMM yy”

                Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year.

                “dd MMM yyyy”

                Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.

                “dd MMM, yy”

                Displays a numeric Day and 3-character Month abbreviation, with a 2-digit Year.

                “dd MMM, yyyy”

                Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.

                “dd MMM”

                Displays a numeric Day and 3-character Month abbreviation.

                “dd MMMM (Upper)”

                Displays a numeric Day and uppercase spelled-out Month only.

                “dd MMMM yy”

                Displays a numeric Day and spelled-out Month, with a 2-digit Year.

                “dd MMMM yyyy”

                Displays a numeric Day and spelled-out Month, with a 4-digit Year.

                “dd MMMM, yy”

                Displays a numeric Day and spelled-out Month, with a 2-digit Year.

                “dd MMMM, yyyy”

                Displays a numeric Day and spelled-out Month, with a 4-digit Year.

                “dd MMMM”

                Displays a numeric Day and spelled-out Month only.

                “dd. MMM yyyy”

                Displays a numeric Day and 3-character Month abbreviation, with a 4-digit Year.

                “dd. MMMM yyyy”

                Displays a numeric Day and spelled-out Month, with a 4-digit Year.

                “dd.M.yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “dd.M.yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “dd.M”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

                “dd.MM.yy”

                Displays a numeric Day and Month, with a 2-digit Year.

                “dd.MM.yyyy”

                Displays a numeric Day and Month, with a 4-digit Year.

                “dd.MM”

                Displays a numeric Day and Month only.

                “dd/M/yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “dd/M/yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “dd/M”

                Displays a numeric Day and Month only, removing the leading zero from the numeric Month only.

                “dd/MM/yy”

                Displays a numeric Day and Month, with a 2-digit Year.

                “dd/MM/yyyy”

                Displays a numeric Day and Month, with a 4-digit Year.

                “dd/MM”

                Displays a numeric Day and Month only.

                “dd”

                Displays a 2-digit Day only.

                “M-d-yy”

                Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

                “M-d-yyyy”

                Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

                “M-d”

                Displays a numeric Month and Day only, removing the leading zero from each.

                “M-dd-yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “M-dd-yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “M-dd”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

                “M d yy”

                Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

                “M d yyyy”

                Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

                “M d”

                Displays a numeric Month and Day only, removing the leading zero from each.

                “M dd yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “M dd yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “M dd”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

                “M.d.yy”

                Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

                “M.d.yyyy”

                Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

                “M.d”

                Displays a numeric Month and Day only, removing the leading zero from each.

                “M.dd.yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “M.dd.yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “M.dd”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

                “M/d/yy”

                Removes the leading zero from the numeric Month and Day, and displays a 2-digit Year.

                “M/d/yyyy”

                Removes the leading zero from the numeric Month and Day, and displays a 4-digit Year.

                “M/d”

                Displays a numeric Month and Day only, removing the leading zero from each.

                “M/dd/yy”

                Removes the leading zero from the numeric Month only, and displays a 2-digit Year.

                “M/dd/yyyy”

                Removes the leading zero from the numeric Month only, and displays a 4-digit Year.

                “M/dd”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Month only.

                “M”

                Removes the leading zero, and displays a single numeric Month only.

                “MM-d-yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “MM-d-yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “MM-d”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

                “MM-dd-yy”

                Displays a numeric Month and Day, with a 2-digit Year.

                “MM-dd-yyyy”

                Displays a numeric Month and Day, with a 4-digit Year.

                “MM-dd”

                Displays a numeric Month and Day only.

                “MM d yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “MM d yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “MM d”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

                “MM dd yy”

                Displays a numeric Month and Day, with a 2-digit Year.

                “MM dd yyyy”

                Displays a numeric Month and Day, with a 4-digit Year.

                “MM dd”

                Displays a numeric Month and Day only.

                “MM.d.yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “MM.d.yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “MM.d”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

                “MM.dd.yy”

                Displays a numeric Month and Day, with a 2-digit Year.

                “MM.dd.yyyy”

                Displays a numeric Month and Day, with a 4-digit Year.

                “MM.dd”

                Displays a numeric Month and Day only.

                “MM/d/yy”

                Removes the leading zero from the numeric Day only, and displays a 2-digit Year.

                “MM/d/yyyy”

                Removes the leading zero from the numeric Day only, and displays a 4-digit Year.

                “MM/d”

                Displays a numeric Month and Day only, removing the leading zero from the numeric Day only.

                “MM/dd/yy”

                Displays a numeric Month and Day, with a 2-digit Year.

                “MM/dd/yyyy”

                Displays a numeric Month and Day, with a 4-digit Year.

                “MM/dd”

                Displays a numeric Month and Day only.

                “MM/yy”

                Displays a numeric Month, with a 2-digit Year.

                “MM”

                Displays a numeric Month only.

                “MMM (Upper)”

                Displays an uppercase 3-character Month abbreviation only.

                “MMM d (Ordinal)”

                Displays a 3-character Month abbreviation and ordinal Day only.

                “MMM d, yy”

                Displays a 3-character Month abbreviation and numeric Day, with a 2-digit Year, removing the leading zero from the numeric Day.

                “MMM d, yyyy”

                Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year, removing the leading zero from the numeric Day.

                “MMM d”

                Displays a 3-character Month abbreviation and numeric Day only, removing the leading zero from the numeric Day.

                “MMM dd, yy”

                Displays a 3-character Month abbreviation and numeric Day, with a 2-digit Year.

                “MMM dd, yyyy”

                Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year.

                “MMM dd. yyyy”

                Displays a 3-character Month abbreviation and numeric Day, with a 4-digit Year.

                “MMM dd”

                Displays a 3-character Month abbreviation and numeric Day only.

                “MMM yy”

                Displays a 3-character Month abbreviation, with a 2-digit Year.

                “MMM yyyy”

                Displays a 3-character Month abbreviation, with a 4-digit Year.

                “MMM”

                Displays a 3-character Month abbreviation only.

                “MMMM (Upper)”

                Displays an uppercase spelled-out Month only.

                “MMMM d, yy”

                Displays a spelled-out Month and numeric Day, with a 2-digit Year, removing the leading zero from the numeric Day.

                “MMMM d, yyyy”

                Displays a spelled-out Month and numeric Day, with a 4-digit Year, removing the leading zero from the numeric Day.

                “MMMM d”

                Displays a spelled-out Month and numeric Day only, removing the leading zero from the numeric Day.

                “MMMM dd, yy”

                Displays a spelled-out Month and numeric Day, with a 2-digit Year.

                “MMMM dd, yyyy” (default selection)

                Displays a spelled-out Month and numeric Day, with a 4-digit Year.

                “MMMM dd”

                Displays a spelled-out Month and numeric Day only.

                “MMMM yy”

                Displays a spelled-out Month, with a 2-digit Year.

                “MMMM yyyy”

                Displays a spelled-out Month, with a 4-digit Year.

                “MMMM”

                Displays a spelled-out Month only.

                “yy”

                Displays a 2-digit Year only.

                “yyyy”

                Displays a 4-digit Year only.

              2. For items mapped from the “Fund” or “Period” list boxes on the “Data Points” tab, or items mapped from the “Financial Workbook” tab, use the “Fund Selection Behavior” drop-down list to indicate whether data displayed in project preview/output will be from an auto-determined fund or from a specific fund.

                1. If you select the “Specify Fund” option, choose the specific fund using the “Fund” drop-down list that displays.

            10.

              1. Use the “Format” drop-down list to specify the format of the numeric value. ()
                Option Details

                “n.nn” (default selection)

                Decimals based upon rounding level. Displays comma as thousands separator.

                “n.(n)(n)”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays comma as thousands separator.

                The period is also dropped if the format is set to 6 decimals.

                “(n).nn(n)”

                Decimals based upon rounding level, but drops first and/or last digit if zero. Displays comma as thousands separator.

                “(n).nn”

                Decimals based upon rounding level, but drops first digit if zero. Displays comma as thousands separator.

                “nnnn.nn(n)”

                Decimals based upon rounding level, but drops last digit if zero. Displays comma as thousands separator.

                “(nnn.n%)”

                Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays comma as thousands separator.

                If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “Custom Zero Display” value is numeric.

                “n,nn”

                Decimals based upon rounding level. Displays period as thousands separator.

                “n,(n)(n)”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays period as thousands separator.

                The comma is also dropped if the format is set to 6 decimals.

                “(n),nn(n)”

                Decimals based upon rounding level, but drops first and/or last digit if zero. Displays period as thousands separator.

                “(n),nn”

                Decimals based upon rounding level, but drops first digit if zero. Displays period as thousands separator.

                “nnnn,nn(n)”

                Decimals based upon rounding level, but drops last digit if zero. Displays period as thousands separator.

                “(nnn,n%)”

                Decimals based upon rounding level. Adds % sign after numeric. If negative and using parens, adds % inside parens. Displays period as thousands separator.

                If “Zero Display” applies during output, the “%” symbol will only be appended to the value if the specified “Zero Display” or “>Custom Zero Display” value is numeric.

                “n nn [comma]”

                Decimals based upon rounding level. Displays space as thousands separator. Displays comma as decimal separator.

                “n nn [period]”

                Decimals based upon rounding level. Displays space as thousands separator. Displays period as decimal separator.

                “n (n)(n) [comma]”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays comma as decimal separator.

                The comma is also dropped if the format is set to 6 decimals.

                “n (n)(n) [period]”

                Decimals based upon rounding level, but drops all remaining digits if zero. Displays space as thousands separator. Displays period as decimal separator.

                The period is also dropped if the format is set to 6 decimals.

                “1st, 2nd, 3rd”

                Ordinal (1st, 2nd, 3rd) represents the abbreviated ordinal version of the associated numeric.

                “First, Second, Third”

                Ordinal (First, Second, Third) represents the unabbreviated alpha ordinal of the associated numeric.

              2. Use the “Zero Display” drop-down list to specify the value to display if the data point’s raw value is zero. ()
                Option Details

                “0 - Decimals based on rounding level” (default selection)

                Puts a zero in front of the decimal (where applicable).

                • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value less than 500 (e.g.., “499”) will be shown as “0”.
                • If the rounding option is set to “000’s” or “000’s (suppressed)”, any value above 499 will be rounded up (e.g.., “500” would be rounded to “1,000” or “1” depending on the rounding setting).

                “0”

                 

                “.0”

                 

                “.00”

                 

                “.000”

                 

                “.0000”

                 

                “.00000”

                 

                “.000000”

                 

                “0.0”

                 

                “0.00”

                 

                “0.000”

                 

                “0.0000”

                 

                “0.00000”

                 

                “0.000000”

                 

                “Blank”

                 

                “Dash (-)”

                 

                “Em Dash (—)”

                 

                “n/a”

                 

                “N/A”

                 

                “zero”

                 

                “Zero”

                 

                “ZERO”

                 

                “zero coupon”

                 

                “Zero coupon”

                 

                “Zero Coupon”

                 

                “ZERO COUPON”

                 

              3. Select the “Custom Zero Display” to specify a custom value to display if the data point’s raw value is zero.

                1. Click the at right of the check box to view/edit the custom value.
                  1. Enter the desired value in the “Display Text” text box.

                  2. Click the “Accept” button at lower-right of the dialogue.

                • The check box is cleared by default for newly-added data points.
                • The maximum character limit for the “Display Text” field is 64.
                • When the check box is cleared, the specified “Display Text” value is retained (for possible future use), however the custom zero display feature is turned off for the currently-selected item; the specified “Zero Display” value will be used in output.

              4. Use the “Negative Display” drop-down list to specify the format of the numeric value if the data point’s raw value is negative. ()
                Option Sample

                “Parentheses” (default selection)

                (123456.78)

                “Negative Sign”

                -123456.78

                “Display as Positive”

                123456.78

              5. Select the “Display positive/negative values as negative/positive” to cause the sign of the value displayed in project preview and output to be “flipped” (similar to multiplying the value by negative 1).
                • The check box is cleared by default for newly-added data points.

                • Positive values will be displayed as negative.

                  “100,000” becomes “(100,000)”

                • Negative values will be displayed as positive.

                  “(100,000)” becomes “100,000”

                • When displaying a value as negative the specified “Negative Display” setting is used.

                  • If the “Display as Positive” option is specified, all values are displayed as positive, regardless of whether or not the “Display positive/negative values as negative/positive” check box is selected.
                • This functionality impacts the display of data point values only; it does not alter any calculations within Arc Suite.

              6. Use the “Rounding” drop-down list to specify the rounding level of the number. ()
                Option Details

                “No Decimal” (default selection)

                 

                “1 Decimal”

                 

                “2 Decimals”

                 

                “3 Decimals”

                 

                “4 Decimals”

                 

                “5 Decimals”

                 

                “6 Decimals”

                 

                “000’s”

                 

                “000’s (suppressed)”

                Behaves like “000’s”, except that trailing zeros will be suppressed (e.g., “1,000” displays as “1”, “10,000” as “10”, “100,000” as “100”, etc.).
              7. Use the “From Currency” drop-down list to specify the base currency involved in the exchange rate calculation for the mapped item.
              8. Use the “To Currency” drop-down list to specify the currency to which the base currency is converted in the exchange rate calculation for the mapped item.

              9. Use the “To Currency” drop-down list to designate the exchange rate source whose associated exchange rate for the specified currencies will be used in the exchange rate calculation for the mapped item.

                The first record (alphabetically) in the Exchange Rate Sources library is selected by default when an item is mapped.

              10. Indicate the time at which the exchange rate will be calculated for the mapped item using the “Time” text box and associated selection button.

                “12:00 AM” is specified by default when an item is mapped.

              11. Use the “Time Zone” drop-down list to designate the time zone associated with the specified time.

                “(GMT) Dublin, Edinburgh, Lisbon, London” is specified by default when an item is mapped.

          2. Specify the of a selected item.

            1. Select an item within the cell, and then click the “Format Item” at lower-left of the pane to view/edit item settings.
              “Format Item” dialogue
              1. Specify formatting settings, as required.

              2. Click the “Accept” button at lower-right of the dialogue.

              • When editing an item whose style formatting has been set previously (whether via the “Format Item”, “Format Cell”, “Format Row” or “Format Column” dialogues), the check box state of each setting will reflect the current respective settings of the item.
              • When editing an item whose position formatting has been set previously via the “Format Item” dialogue, the option button selection will reflect the current position setting of the item.
              • Formatting settings made via the “Format Item” dialogue are not reflected in the component preview on the “Project” page; only in output.
          3. Move a selected item up or down (left or right) using the “Move item up” and “Move item down” buttons   at lower-left of the pane.
          4. Remove selected items from the column via the “Remove item” button at lower-left of the pane.

    7. Click the “Save” button at lower-right of the page if any updates were made.

    A listing of records, with certain associated information, can be exported from the application database to any of several different file formats (DOC, HTM, XML, etc.). Follow the steps below to perform a data export.

    1. Click the “Export data” at lower-right of the pane where existing items are listed to export data from the grid.

      1. Select the next to the file format to which you’d like the data saved.

        •  .XML

        •  .DOC

        •  .CSV

        •  .HTM

        •  .TXT

      2. Click the “Accept” button at lower-right of the dialogue.

        1. Specify a local or network directory in which to store the file, and provide a “File name”.
        2. Click the “Save” button.

Creating Tabular Data Templates