Template formatting

Parent Previous Next

Quick reference : Template formatting


Templates are added to the ‘Template-‘ tabs within the spreadsheet. The first row in each Template sheet must be used as a heading row (i.e. template name) for a column.


Or


Any text placed under the template heading will be considered as to be part of the template.

Using Variables

Standard Variables

Data variables are added to the templates in the format


<VariableDelimiter><VariableName><VariableDelimiter>, e.g. <<IPAddress>>


All <<VariableName>>’s should match a single ‘DD:VariableName’ column on a Data sheet.

The variables can be included anywhere within a template. Multiple variables and/or text may be added to a single cell.

The data variable name is prefixed and suffixed by predefined characters (defaults ‘<<‘ and ‘>>‘) defined in the spreadsheet specific settings file.

<Characters> are 2 characters which are not typically used within the user required configuration. E.g. <<, >>.

ID Specific Variables

This allows a variable used within a template to contain different values depending on the device ID for which the template is used. The variable may be defined as:



Within templates, the variable may be referenced as:


Predefined Variables

Date and time variables may be added to the template. The values added are the date/time when Gen.IT generates the output. The format is:



The data variable name is prefixed and suffixed by predefined characters (defaults ‘<<‘ and ‘>>‘) specified in the spreadsheet settings file.        

IP Variables

IPv4 addresses may be incremented dynamically within Gen.IT. CIDR addresses (10.0.0.0/8) can be split and used to calculate IP addressing, subnet length, subnet mask or subnet inverse mask.

IP variables can be entered into templates in the formats:



This features allows a single variable to be defined (e.g. site subnet), and the specific required ip addresses (VRRP/Standby/Point to Point links) are calculated dynamically as specified within the template.

Note: IPv6 is supported as a beta feature.

Include Statements

Gen IT supports the use of ‘Include Statements’. Include Statements allow for the inclusion of a single line, multiple lines, or a separate template within another template. The decision on whether to include the Include Statements is based on a variable lookup at run-time.


The Include Statements must be an exclusive entry within a template cell. The format of the compound template statement is as below:





The processing order and depth of Include/Compound Templates can be customized on a per spreadsheet basis. Up to 5 levels of processing is supported.

Please see the user manual on the web site for further details and examples. http://gen-it.net/user-guide/include_templates/

Compound Templates

Gen IT supports the use of Compound Templates. Compound Templates allows a template to be recursively included within another template. The compound template definition includes details regarding repeat count, and the incrementing variables within the compound template.


The Compound Template must be an exclusive entry within a template cell. Compound Templates are added to the templates in the format as show below:


<%T:<Template>,<RepeatCountVariable>,<NumberOfVariables>,(Variables)%>


Variable are formatted as ‘VVV,WWW,XXX,YYY,ZZZ’

Variable as Integer

Variable as IP Address


The processing order and depth of Include/Compound Templates can be customized on a per spreadsheet basis. Up to 5 levels of processing is supported.

Please see the user manual on the web site for further details and examples. http://gen-it.net/user-guide/compound_templates/

Text Formatting

Individual template lines can be formatted with a color, bold or italic.

Predefined characters placed at the start or end of a template cell indicate to Gen IT how to treat the line. These characters are defined in the Excel spreadsheet specific settings file.

In addition, up to 10 styles can be can be defined which will mark a line according to the defined values as above. These styles are defined in the Excel file settings (Settings Menu -> Edit XLS File Settings)