Excel Template

<< Click to Display Table of Contents >>

Navigation:  Modules > Asset Management > Software License Management > Application Owners >

Excel Template

The Excel Template is a formatted Excel spreadsheet that does not contain data, but does contain specific named ranges and tabs that the MIE expects.  The MIE will copy the template to a new file, give the new file a name that is indicative of the owner and application, and then populate the new Excel file with drop-down information as well as currently known authorization information for the assigned instances.  After the new file is created and populated, the MIE will then attach the file to the workflow thread so that it is available to the workflow.

The general purpose template file should be used, however it may be modified so long as the following rules are followed:

1.No existing named ranges are removed or changed.

2.Only the Instructions or Information tabs are modified.  The Values tab should not be modified.

3.No columns are inserted or deleted within the "Current Records" section.  Only add or modify columns to the right of that section (usually to capture more information than the general template currently captures).

When populating the Excel spreadsheet, the MIE inserts the following information:

1.Asset environment values from the Asset Environment Types drop-down.

2.Geography values from the Geographies drop-down.

3.Current authorized instance information from the Assets and Authorized software tables.