Report Tag Library - Powerpoint

CheckboxCheckedTag

The CheckboxChecked class is applied to PowerPoint Report Templates when the following text is found in a text box: ${checkbox:checked, mnemonic=myMnemonic}. It will replace the tag with the text true or false depending on the state of the checkbox. This can be nested inside of other tags.

Required parameter mnemonic to match the report id used in the tool.

The tag is case-insensitive.

This tag is only compatible with Tool Builder versions up to v7.6

See ReportTag for syntax.

Example:

• ${checkbox:checked}

CustomImageTag

The CustomImageTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${customImage:imageName} where imageName is the name of the image used in the tool. The text box will be removed and replaced with the image, and all animations present on the text box will be applied to the image as well.

Optional parameters include fit, scalex, and scaley. fit will generate an image that will fit inside the container and fill either the height or width of the container depending on the image's scale ratio. scalex will generate an image as wide as the container with a proportional height, and scaley will generate an image as tall as the container with a proportional width. If both scalex and scaley are included, only scalex will be applied.

Both the tag and parameters are case-insensitive.

See ReportTag for syntax.

Examples:

• ${customImage:logo,scalex}
• ${customImage:logo,scaley}
• ${customImage:logo,fit}

DuplicateSlidesTag

The DuplicateSlidesTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${duplicate:benefits,numslides=2}, ${duplicate:vmcs}, ${duplicate:sections}, or ${duplicate:investments} where the slides will be duplicated for each benefit, value map category, or investment. numslides determines how many slides will be duplicated for each benefit, value map category, or investment starting with the current slide.

Optional parameter numslides is the number of slides to copy. Default is 1.

Optional parameter filter can be used with benefits or Value map categories. Can filter by value passed in, either Monetary or Non_Monetary.

Optional parameter top or bottom can be used with benefits to list results by impact value. Takes a number for maximum results returned.

When benefit slides are duplicated, and text that contains [benefitid] will be replaced with the concrete benefit id, so tags can be nested. For example, a tag like this

${nr:DBB[benefitid]_Overview_Name} Page 1

${nr:DBB1234_Overview_Name} Page 1

nr

When value map slides are duplicated, text that contains [vmcid] will be replaced with the concrete value map category id.

When investment slides are duplicated, text that contains [investmentid] will be replaced with the concrete investment id.

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${duplicate:vmcs} - Duplicates one slide for each value map category.
• ${duplicate:sections} - Duplicates one slide for each section.
• ${duplicate:benefits,numslides=2} - Duplicates 2 slides for each benefit.
• ${duplicate:benefits, numslides=2, filter=monetary, top=3} - Duplicates 2 slide for the top 3 benefits that is monetary.
• ${duplicate:investments} - Duplicates one slide for each investment.
• ${duplicate:vmcs, filter=Non_monetary} - Duplicates one slide for each value map that is non monetary.

HideShowRowTag

The HideShowRowTag class is applied to Word Report Templates when the following text is found in a table cell: ${hsRow:namedRange} where namedRange is a named range that has the value no, off, false, 0, excluded, hide when you would like the row hidden.

There are no optional parameters.

The tag is case-insensitive.

This tag is only compatible with Tool Builder versions up to v7.6

See ReportTag for syntax.

Examples:

• ${hsRow:hide_benefit_row}

HighChartTag

The HighChartTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${chart:chart_name} where chart_name is the id of the image used in the tool. The text box will be removed and replaced with the image, and all animations present on the text box will be applied to the image as well.

Optional parameters include fit, scalex, and scaley. fit will generate an image that will fit inside the container and fill either the height or width of the container depending on the chart's scale ratio. scalex will generate an image as wide as the container with a proportional height, and scaley will generate an image as tall as the container with a proportional width. If both scalex and scaley are included, only scalex will be applied

Both the tag and parameters are case-insensitive.

See ReportTag for syntax.

Examples:

• ${chart:roi_chart,scalex}
• ${chart:roi_chart,scaley}
• ${chart:roi_chart,fit}

InvestmentNameTag

The InvestmentName class is applied to PowerPoint Report Templates when the following text is found in a text box: ${investment:name} where name returns the label of the investment.

parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${investment:name,id=1}
• ${investment:name,id=[investmentid]} - When used inside of a duplicate slide or duplicate section tag.

KeepContentTag

The KeepContentTag class is applied to PowerPoint Report Templates when the following text is found in the alternate text of a shape: ${keepContent:named_range} where named_range is a named range that has the value no, off, false, 0, excluded, hide when you would like the shape hidden.

There are no optional parameters.

The tag is case-insensitive.

This tag is only compatible with Tool Builder versions up to v7.6

See ReportTag for syntax.

Examples:

• ${keepContent:keep_this}

NamedRangeTag

The NamedRangeTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${nr:named_range} where named_range is the named range that you would like to display. The text will be replaced inline (as opposed to removing and replacing the container).

Optional parameter asHTML will insert the contents as formatted HTML.

The tag is case-insensitive.

This tag is only compatible with Tool Builder versions up to v7.6

See ReportTag for syntax.

Examples:

• ${nr:company_name}
• ${nr:industry}
• ${nr:DBB[benefitid]_ChallengesText_report,asHTML}

ShowSlideTag

The ShowSlideTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${showSlide:named_range} where named_range is a named range that has the value no, off, false, 0, excluded, hide when you would like the slide hidden.

Optional parameter eq. If the eq parameter is used, the tag will check if the value of the named range against the parameter's value. If the values are equal, the slide will be hidden. The values are case-insensitive.

Optional parameter neq. If the neq parameter is used, the tag will check if the value of the named range against the parameter's value. If the values are not equal, the slide will be hidden. The values are case-insensitive.

The tag is case-insensitive.

This tag is only compatible with Tool Builder versions up to v7.6

See ReportTag for syntax.

Examples:

• ${showSlide:hide_title_slide}
• ${showSlide:some_named_range}
• ${showSlide:industry, eq=hospitality}
• ${showSlide:industry, neq=aerospace}

TableTag

The TableTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${table:table_name} where table_name is the id of the table used in the tool. The text box will be removed and replaced with the table, and all animations present on the text box will be applied to the table as well. The table will fit the width of the container the tag is placed in.

Optional parameters include scaleY which, when used in conjunction with

Optional parameter split will duplicate slides and create new tables if it does not fit on a single slide.

Optional parameter copyHeader, will share the table header on new tables created during a split.

Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.

Optional parameter headerBg will set the background color of the table header to the entered Hex value.

Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.

Optional parameter textBackground will set the background color of the table rows to the entered Hex value.

Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.

Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.

Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.

Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.

Optional parameter fontSize will set the font size of all cells to the entered value.

Optional parameter fontScale will scale all fonts by the entered value.

Optional parameter minimumRowHeight will set the minimum row height.

Optional parameter cellMarginLeft will set the cell left margin.

Optional parameter cellMarginRight will set the cell right margin.

Optional parameter cellMarginTop will set the cell top margin.

Optional parameter cellMarginBottom will set the cell bottom margin.

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${table:multi-year-benefits__table__benefits-by-year, fontSize=8.5}
• ${table:investment__table__annual-investment-by-category,scaley,split,fontScale=1}
• ${table:investment__table__annual-investment-by-category, headerFg=#E0E0E0, headerBg=#11a6c0, textForeground=#FF0000, textBackground=#00FF00}

UserEmailTag

The UserEmailTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:user_email}. It will display the user who generated the report's email address inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:user_email}

UserFirstTag

The UserFirstTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:user_first}. It will display the user who generated the report's first name inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:user_first}

UserLastTag

The UserLastTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:user_last}. It will display the user who generated the report's last name inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:user_last}

ValueMapCategoryAnnualIdealBenefitTag

The ValueMapCategoryAnnualIdealBenefitTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:annualIdealBenefit, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the Annual ideal benefit in-line (as opposed to removing and replacing the container).

Parameter id is required. There are no optional parameters.

Below options only available in Tool builder v8+

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter year returns year the value should return. Default is year 1.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:annualIdealBenefit,id=[vmcid]}
• ${vmc:annualIdealBenefit,id=123, year=1}
• ${vmc:annualIdealBenefit,id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryAnnualRealizedBenefitTag

The ValueMapCategoryAnnualRealizedBenefitTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:annualRealizedBenefit, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the Annual realized benefit in-line (as opposed to removing and replacing the container).

Parameter id is required. There are no optional parameters.

Below options only available in Tool builder v8+

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter year returns year the value should return. Default is year 1.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:annualRealizedBenefit,id=[vmcid]}
• ${vmc:annualRealizedBenefit,id=123, year=1}
• ${vmc:annualRealizedBenefit, id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryNameTag

The ValueMapCategoryNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:name,id=[vmcid]} where [vmcid] is a valid value map category id. It will display the value map category name inline (as opposed to removing and replacing the container).

Parameter id is required. There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:name,id=[vmcid]}
• ${vmc:name,id=123}

CurrentDateTag

* The CurrentDateTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${date:current_date} where current_date returns the current date that the report is generated. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter fmt that accepts a date format pattern. defaults to "MMMM dd\, yyyy". Note commas must be escaped.

See ReportTag for syntax.

Examples:

• ${date:current_date}
• ${date:current_date, fmt=MM dd\, yy}
• ${date:current_date, fmt=yyyy-MM-dd}

ItemTableIdTag

* The ItemTableIdTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${itemTable:id} where id returns the item table id. This is typically nested in a table tag.

Required parameter mnemonic the mnemonic of the item table.

See ReportTag for syntax.

Examples:

• ${itemTable:id,mnemonic=myMnemonic}

ItemTableNameTag

* The ItemTableNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${itemTable:name} where name returns the label name of the item table.

parameter id the id number of the item table.
parameter mnemonic the mnemonic of the item table.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${itemTable:name, mnemonic=itemTable1}
• ${itemTable:name, id=7}

ItemTableVisibilityTag

* The ItemTableVisibilityTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${itemTable:visibility} where visibility returns true or false if the item table was visible in the application.

parameter id the id number of the item table.
parameter mnemonic the mnemonic of the item table.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${itemTable:visibility, mnemonic=itemTable1}
• ${itemTable:visibility, id=7}

LeadCaptureFieldValueTag

The LeadCaptureFieldValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${lead:field_value} where field_value returns the value of the field

required parameter field_name the field_name for the requested field value.

See ReportTag for syntax.

Examples:

• ${lead:field_value, field_name=FirstName}
• ${lead:field_value, field_name=utm_campaign}

SectionIdTag

* The SectionIdTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${section:id} where id returns the section id. This is typically nested in a table tag.

Required parameter mnemonic the mnemonic of the section.

See ReportTag for syntax.

Examples:

• ${section:id,mnemonic=myMnemonic}

SectionNameTag

* The SectionNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${section:name} where name returns the label name of the section.

parameter id the id number of the section.
parameter mnemonic the mnemonic of the section.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${section:name, mnemonic=section1}
• ${section:name, id=7}

SectionVisibilityTag

* The SectionVisibilityTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${section:visibility} where visibility returns true or false if the section was visible in the application.

parameter id the id number of the section.
parameter mnemonic the mnemonic of the section.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${section:visibility, mnemonic=section1}
• ${section:visibility, id=7}

ShowAltTextIf

* The ShowAltTextIf class is applied to PowerPoint Report Templates when the following text is found in a alternate text shape: ${showAltTextIf:{tag value}, eq={comparison value}} where {tag value} can be an existing tag whose value will be evaluated to the {comparison value}.
The results of which, if evaluated as true will show the content in the presentations Alt text.

parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${showAltTextIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}
• ${showAltTextIf:${calc:industry}, neq=Aerospace & Defense}

ShowColumnIf

The ShowColumnIf class is applied to PowerPoint Report Templates when the following text is found in a table cell: ${showColumnIf:{tag value}, eq={comparison value}} where {tag value} can be an existing tag whose value will be evaluated to the {comparison value}.
The results of which, if evaluated as true will show the column in the table.

parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${showColumnIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}
• ${showColumnIf:${calc:industry}, neq=Aerospace & Defense}

ShowRowIf

* The ShowRowIf class is applied to PowerPoint Report Templates when the following text is found in a table cell: ${showRowIf:{tag value}, eq={comparison value}} where {tag value} can be an existing tag whose value will be evaluated to the {comparison value}.
The results of which, if evaluated as true will show the row in the table.

parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${showRowIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}
• ${showRowIf:${calc:industry}, neq=Aerospace & Defense}

ShowSlideIfTag

* The ShowSlideIfTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${showSlideIf:{tag value}, eq={comparison value}} where {tag value} can be an existing tag whose value will be evaluated to the {comparison value}.
The results of which, if evaluated as true will show the current slide.

parameter eq test if the {tag value} is equal to this attribute
parameter neq test if the {tag value} is not equal to this attribute
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${showSlideIf:${tickbox:checked, mnemonic=tickbox1}, eq=true}
• ${showSlideIf:${calc:industry}, neq=Aerospace & Defense}

TickboxNameTag

The TickboxNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${tickbox:name} where name returns the label of the tickbox.

required parameter mnemonic the mnemonic of the tickbox.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${tickbox:name, mnemonic=tickbox1}

TickboxTickedTag

* The TickboxTickedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${tickbox:checked} where checked will return true or false if the check box was checked in the application.
${tickbox:unchecked} where unchecked returns true or false if the check box was unchecked in the application.

required parameter mnemonic the mnemonic of the tickbox.

See ReportTag for syntax.

Examples:

• ${tickbox:checked, mnemonic=tickbox1}
• ${tickbox:unchecked, mnemonic=tickbox1}

TickboxTooltipTag

The TickboxTooltipTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${tickbox:tooltip} where tooltip returns tool tip of the tickbox.

required parameter mnemonic the mnemonic of the tickbox.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${tickbox:tooltip, mnemonic=tickbox1}

AnalysisPeriodTag

* The AnalysisPeriodTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:analysis_period} where analysis_period returns current analysis period in years. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:analysis_period}

AnnualGrowthRateTag

The AnnualGrowthRateTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:annual_growth_rate} where annual_growth_rate returns the current annual growth rate percentage. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:annual_growth_rate}

AvgAnnualBenefitsTag

* The AvgAnnualBenefitsTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:avg_ann_benefits} where avg_ann_benefits returns the average cumulative benefits over the analysis period based on the projection. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${calc:avg_ann_benefits}
• ${calc:avg_ann_benefits, projection=Probable, scale=0.001, unit=k, dec=2}

BenefitCurrentSumTotalOverPeriodTag

The BenefitCurrentSumTotalOverPeriodTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:benefit_current_sum_over_period} where benefit_current_sum_over_period returns the total sum of all monetary benefits current values including recurrence over analysis period. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${calc:benefit_current_sum_over_period}
• ${calc:benefit_current_sum_over_period, projection=Probable, scale=0.001, unit=k, dec=2}

BenefitCurrentSumTotalTag

The BenefitCurrentSumTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:benefit_current_sum} where benefit_current_sum returns the total sum of all monetary benefits current values. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${calc:benefit_current_sum}
• ${calc:benefit_current_sum, projection=Probable, scale=0.001, unit=k, dec=2}

BenefitProposedSumTotalOverPeriodTag

The BenefitProposedSumTotalOverPeriodTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:benefit_proposed_sum_over_period} where benefit_proposed_sum_over_period returns the total sum of all monetary benefits proposed values including recurrence over analysis period. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${calc:benefit_proposed_sum_over_period}
• ${calc:benefit_proposed_sum_over_period, projection=Probable, scale=0.001, unit=k, dec=2}

BenefitProposedSumTotalTag

The BenefitProposedSumTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:benefit_proposed_sum} where benefit_proposed_sum returns the total sum of all benefits proposed values. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${calc:benefit_proposed_sum}
• ${calc:benefit_proposed_sum, projection=Probable, scale=0.001, unit=k, dec=2}

CashFlowTableTag

The CashFlowTableTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:table_cash_flow} where table_cash_flow will return a Cash flow table.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.

Optional parameter headerBg will set the background color of the table header to the entered Hex value.

Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.

Optional parameter textBackground will set the background color of the table rows to the entered Hex value.

Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.

Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.

Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.

Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.

Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:

• light
• dark

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${calc:table_cash_flow, projection=Conservative}
• ${calc:table_cash_flow, projection=Conservative, theme=dark}

CodnQuarterlyTag

* The CodnQuarterlyTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:codn_q} where codn_q returns current cost of do nothing quarterly. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter realized will return the realized value if present.

See ReportTag for syntax.

Examples:

• ${calc:codn_q}
• ${calc:codn_q, scale=0.001, unit=k, dec=2}

CodnTag

* The CodnTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:codn} where codn returns current cost of do nothing. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter realized will return the realized value if present.

See ReportTag for syntax.

Examples:

• ${calc:codn}
• ${calc:codn, scale=0.001, unit=k, dec=2}

CompanyNameTag

* The CompanyNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:company_name} where company_name returns the user entered company name. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:company_name}

CumulativeBenefitByYearTag

* The CumulativeBenefitByYearTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:cumulative_benefit_by_year, year=1} where cumulative_benefit_by_year, year=1 returns the cumulative benefit by year. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter year selects year the value should return.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:cumulative_benefit_by_year, year=0}
• ${calc:cumulative_benefit_by_year, year=1, scale=0.001, unit=k, dec=2}

CumulativeBenefitTag

* The CumulativeBenefitTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:cumulative_benefits} where cumulative_benefits returns the total cumulative benefit based on the projection. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${calc:cumulative_benefits}
• ${calc:cumulative_benefits, projection=Probable, scale=0.001, unit=k, dec=2}

CumulativeNetBenefitByYearTag

* The CumulativeNetBenefitByYearTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:cumulative_net_benefit_by_year} where cumulative_net_benefit_by_year returns the cumulative net benefit by year. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter year selects year the value should return.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:cumulative_net_benefit_by_year, year=0}
• ${calc:cumulative_net_benefit_by_year, year-1, scale=0.001, unit=k, dec=2}

CumulativeNetBenefitTag

* The CumulativeNetBenefitTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:cumulative_net_benefit} where cumulative_net_benefit returns the current cumulative net benefits. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:cumulative_net_benefit}
• ${calc:cumulative_net_benefit, scale=0.001, unit=k, dec=2}

CurrencyIsoCodeTag

The CurrencyIsoCodeTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${currency:iso} where it will return the currency iso code that was selected. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${currency:iso}

CurrencyNameTag

The CurrencyNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${currency:name} where it will return the currency name that was selected. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${currency:name}

CurrentProjectionTag

* The CurrentProjectionTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:current_projection} where current_projection returns the label of the users selected projection. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:current_projection}

DeploymentPeriodTag

The DeploymentPeriodTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:deployment_period} where deployment_period returns the current deployment period in months. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:deployment_period}

DirectBenefitRealizationTag

The DirectBenefitRealizationTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:direct_benefit_realization} where direct_benefit_realization returns the current direct benefit realization percentage. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:direct_benefit_realization}

DiscountRateTag

The DiscountRateTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:discount_rate} where discount_rate returns the current discount rate. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:discount_rate}

IndirectBenefitRealizationTag

The IndirectBenefitRealizationTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:indirect_benefit_realization} where indirect_benefit_realization returns the current indirect benefit realization percentage. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:indirect_benefit_realization}

IndustryTag

* The IndustryTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:industry} where industry returns the label of the users selected industry. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:industry}

IrrTag

* The IrrTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:IRR} where IRR returns the current IRR. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:IRR}

LocationTag

* The LocationTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:location} where location returns the label of the users selected location. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:location}

NetBenefitByYearTag

* The NetBenefitByYearTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:net_benefit_by_year, year=1} where net_benefit_by_year, year=1 returns the net benefit by year. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter year selects year the value should return.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:net_benefit_by_year, year=0}
• ${calc:net_benefit_by_year, year=1, scale=0.001, unit=k, dec=2}

NpvTag

* The NpvTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:NPV} where NPV returns the current NPV. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:NPV}
• ${calc:NPV, scale=0.001, unit=k, dec=2}

PaybackTag

* The PaybackTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:payback} where payback returns the label for the current payback period. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:payback}

PotentialBenefitTag

* The PotentialBenefitTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:potential_benefit} where potential_benefit returns the total of the unrealized potential benefits. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:potential_benefit}
• ${calc:potential_benefit, scale=0.001, unit=k, dec=2}

RoiPerYearTag

* The RoiPerYearTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:ROI_per_year} where ROI_per_year returns the ROI per year. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter year returns year the value should return. Default is year 1.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:ROI_per_year}
• ${calc:ROI_per_year, year=0}
• ${calc:ROI_per_year, year=5, scale=0.001, unit=k, dec=2}

RoiTag

* The RoiTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:ROI} where ROI returns the current ROI. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:ROI}

SimpleRealizationByYearTag

The SimpleRealizationByYearTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:realization_by_year} where realization_by_year returns the realization by year. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter year returns year the value should return. Default is year 1.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:realization_by_year}
• ${calc:realization_by_year, year=1}
• ${calc:realization_by_year, year=5, projecton=Conservative}

TemplateModeTag

The TemplateModeTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:template_mode} where template_mode returns default template mode set, or user selected mode if template was set to "User Select". The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${calc:template_mode}

TemplateNameTag

* The TemplateNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${template:name} where it will return the template name that was used to create the analysis. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${template:name}

TotalDirectBenefitsTag

* The TotalDirectBenefitsTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:total_direct_benefits} where total_direct_benefits returns the total direct benefit. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:total_direct_benefits}
• ${calc:total_direct_benefits, scale=0.001, unit=k, dec=2}

TotalIndirectBenefitsTag

* The TotalIndirectBenefitsTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:total_indirect_benefits} where total_indirect_benefits returns the total indirect benefit. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${calc:total_indirect_benefits}
• ${calc:total_indirect_benefits, scale=0.001, unit=k, dec=2}

TotalRealizedBenefitsTag

The TotalRealizedBenefitsTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${calc:total_realized_benefits} where total_realized_benefits returns the total realized benefit for the year. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter year the year the value should return. Default is year 1.

See ReportTag for syntax.

Examples:

• ${calc:total_realized_benefits, year=1}
• ${calc:total_realized_benefits, scale=0.001, unit=k, dec=2}

BenefitAnnualGrowthRateTag

* The BenefitAnnualGrowthRateTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:annual_growth_rate} where annual_growth_rate returns the annual growth rate of the benefit.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${benefit:annual_growth_rate, mnemonic=benefit1}
• ${benefit:annual_growth_rate, id=7}

BenefitAverageIdealTotalTag

The BenefitAverageIdealTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:average_ideal_total} where average_ideal_total returns the average ideal total over the analysis period based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${benefit:average_ideal_total, mnemonic=benefit1}
• ${benefit:average_ideal_total, id=7, scale=0.001, unit=k, dec=2}

BenefitAverageRealizedTotalTag

The BenefitAverageRealizedTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:average_realized_total} where average_realized_total returns the average realized total over the analysis period based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${benefit:average_realized_total, mnemonic=benefit1}
• ${benefit:average_realized_total, id=7, scale=0.001, unit=k, dec=2}

BenefitBenefitTextTag

* The BenefitBenefitTextTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:benefit_text} where benefit_text returns the benefit text of the benefit.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML.

See ReportTag for syntax.

Examples:

• ${benefit:benefit_text, mnemonic=benefit1}
• ${benefit:benefit_text, id=7}

BenefitCalcTableTag

The BenefitCalcTableTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:table_calc} where table_calc will return a table of the benefit calculator.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.

Optional parameter headerBg will set the background color of the table header to the entered Hex value.

Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.

Optional parameter textBackground will set the background color of the table rows to the entered Hex value.

Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.

Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.

Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.

Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.

Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:

• light
• dark

Optional parameter hideFormula will not show total formula in table.

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${benefit:table_calc, id=1, projection=Conservative}
• ${benefit:table_calc, id=1 headerFg=#E0E0E0, headerBg=#11a6c0}
• ${benefit:table_calc, mnemonic=benefit1, theme=dark}

BenefitCalloutTag

The BenefitCalloutTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:callout, row=[row id], column=[property]} where callout returns the information related to a benefit callout.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Required parameter row is the row identifier for the callout.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.

Optional parameter column is the property column for the callout (e.g. label, tooltip, value). Default is the callouts label / display name

See ReportTag for syntax.

Examples:

• ${benefit:callout, mnemonic=benefit1, row=A, column=label}
• ${benefit:callout, mnemonic=benefit1, row=A, column=tooltip}
• ${benefit:callout, mnemonic=benefit1, row=A, column=value, projection=probable}
• ${benefit:callout, id=7, row=A}

BenefitChallengeTextTag

* The BenefitChallengeTextTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:challenge_text} where challenge_text returns the challenge text of the benefit.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML.

See ReportTag for syntax.

Examples:

• ${benefit:challenge_text, mnemonic=benefit1}
• ${benefit:challenge_text, id=7}

BenefitComprehensiveRealizationTag

* The BenefitComprehensiveRealizationTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:comprehensive_realization} where comprehensive_realization returns the comprehensive realization of the benefit.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${benefit:comprehensive_realization, mnemonic=benefit1}
• ${benefit:comprehensive_realization, id=7}

BenefitDeploymentTimeTag

* The BenefitDeploymentTimeTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:deployment_time} where deployment_time returns the time to deploy in months of the benefit.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${benefit:deployment_time, mnemonic=benefit1}
• ${benefit:deployment_time, id=7}

BenefitDescriptionTag

* The BenefitDescriptionTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:description} where description returns the description of the benefit.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${benefit:description, mnemonic=benefit1}
• ${benefit:description, id=7}

BenefitIdByRankTag

The BenefitIdByRankTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:id_by_rank} where id_by_rank returns the id of a selected benefit based on the rank of its impact value. i.e. Highest or Lowest value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Required parameter top or bottom a number which the id returned is ranked by. If the rank entered is beyond scope of benefits the next rank is returned.

Optional parameter filter accepts the value passed in, either Monetary or Non_Monetary. Monetary is default.

See ReportTag for syntax.

Examples:

• ${benefit:id_by_rank, top=3}
• ${benefit:id_by_rank, projection=Optimistic, bottom=2}

BenefitImpactRealizedTag

The BenefitImpactRealizedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:impact_realized} where impact_realized returns the realized impact of the benefit based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter year returns year the value should return. Default is year 1.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${benefit:impact_realized, mnemonic=benefit1}
• ${benefit:impact_realized, id=7, scale=0.001, unit=k, dec=2}

BenefitImpactUnrealizedTag

* The BenefitImpactUnrealizedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:impact_unrealized} where impact_unrealized returns the unrealized impact of the benefit based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter year returns year the value should return. Default is year 1.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${benefit:impact_unrealized, mnemonic=benefit1}
• ${benefit:impact_unrealized, id=7, scale=0.001, unit=k, dec=2}

BenefitIsIncludedTag

* The BenefitIsIncludedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:included} where included returns true or false if the benefit was included in the value summary

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${benefit:included, mnemonic=benefit1}
• ${benefit:included, id=7}

BenefitLineItemTag

The BenefitLineItemTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:line_item, row=[row id], column=[column label]} where line_item returns the information related to the benefit line item.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Required parameter row is the row identifier for the line item.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection.

Optional parameter column is the column label for the line item (e.g. label, current, impact, proposed). Default is the line items label / display name

See ReportTag for syntax.

Examples:

• ${benefit:line_item, mnemonic=benefit1, row=A, column=label}
• ${benefit:line_item, mnemonic=benefit1, row=A, column=proposed, projection=probable}
• ${benefit:line_item, id=7}

BenefitNameTag

* The BenefitNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:name} where name returns the label name of the benefit.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${benefit:name, mnemonic=benefit1}
• ${benefit:name, id=7}

BenefitProposedRealized

Deprecated.

BenefitProposedTotalTag

The BenefitProposedTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:proposed_total} where proposed_total returns the proposed total value of the benefit based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${benefit:proposed_total, mnemonic=benefit1}
• ${benefit:proposed_total, id=7, scale=0.001, unit=k, dec=2}

BenefitQuarterlySummaryTableTag

The BenefitQuarterlySummaryTableTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:table_quarterly_summary} where table_quarterly_summary will return a table of the benefit quarterly summary, including realization and deployment offset.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.

Optional parameter headerBg will set the background color of the table header to the entered Hex value.

Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.

Optional parameter textBackground will set the background color of the table rows to the entered Hex value.

Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.

Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.

Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.

Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.

Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:

• light
• dark

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${benefit:table_quarterly_summary, id=1, projection=Conservative}
• ${benefit:table_quarterly_summary, id=1 headerFg=#E0E0E0, headerBg=#11a6c0}
• ${benefit:table_quarterly_summary, mnemonic=benefit1, theme=dark}

BenefitRealizationByYearTag

The BenefitRealizationByYearTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:realization_by_year} where realization_by_year returns the realization by year of the benefit based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter year returns year the value should return. Default is year 1.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

See ReportTag for syntax.

Examples:

• ${benefit:realization_by_year, mnemonic=benefit1}
• ${benefit:realization_by_year, id=7}
• ${benefit:realization_by_year, id=7, year=1, projection=probable}

BenefitRealizationTableTag

The BenefitRealizationTableTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:table_realization} where table_realization will return a table of the realization summary for a benefit

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.

Optional parameter headerBg will set the background color of the table header to the entered Hex value.

Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.

Optional parameter textBackground will set the background color of the table rows to the entered Hex value.

Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.

Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.

Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.

Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.

Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:

• light
• dark

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${benefit:table_realization, id=1,}
• ${benefit:table_realization, id=1 headerFg=#E0E0E0, headerBg=#11a6c0}
• ${benefit:table_realization, mnemonic=benefit1, theme=dark}

BenefitTotalRealizedImpactTag

The BenefitTotalRealizedImpactTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:total_realized_impact} where total_realized_impact returns the total realized impact of the benefit based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${benefit:total_realized_impact, mnemonic=benefit1}
• ${benefit:total_realized_impact, id=7, scale=0.001, unit=k, dec=2}

BenefitValueTotal

The BenefitValueTotal class is applied to PowerPoint Report Templates when the following text is found in a text box: ${benefit:value_total} where value_total returns the current total value of the benefit based on the projection.

parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${benefit:value_total, mnemonic=benefit1}
• ${benefit:value_total, id=7, scale=0.001, unit=k, dec=2}

ChallengeNameTag

* The ChallengeNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${challenge:name} where name returns the label name of the challenge. The text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${challenge:name, id=3}
• ${challenge:name, mnemonic=challenge3}

ChallengeTooltipTag

The ChallengeTooltipTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${challenge:tooltip} where tooltip returns the tool tip of the challenge. The text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${challenge:tooltip, id=3}
• ${challenge:tooltip, mnemonic=challenge3}

ChallengeValueTag

* The ChallengeValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${challenge:value} where value returns the label value of the challenge. The text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${challenge:value, id=3}
• ${challenge:value, mnemonic=challenge3}

EvaluateAndTag

The EvaluateAndTag class is applied to PowerPoint Report Templates when the following text is found: ${eval:and, tags=[{Tag value}], compareTo={comparison}} where multiple tags can be compared to a value. returns true if all tags are equal to comparison value

required attribute tags accepts a multiple valid report tags. Tags passed in must be surrounded by [ ] brackets and ; separated. Tags passed in should evaluate to true or false for comparison.

required attribute compareTo accepts either text or number

See ReportTag for syntax.

Examples:

• ${eval:and, tags=[${eval:gt, tag=${calc:analysis_period}, compareTo=3}; ${tickbox:checked, mnemonic=tickbox1}]}

EvaluateEqualsTag

The EvaluateEqualsTag class is applied to PowerPoint Report Templates when the following text is found: ${eval:eq, tag={Tag value}, compareTo={comparison}} where a tag can be compared to a value. returns true if tag is equal to comparison value

required attribute tag accepts a valid report tag. Tag can evaluate to either text or number

required attribute compareTo accepts either text or number

See ReportTag for syntax.

Examples:

• ${eval:eq, tag=${calc:analysis_period}, compareTo=4}

EvaluateGreaterThanTag

The EvaluateGreaterThanTag class is applied to PowerPoint Report Templates when the following text is found: ${eval:gt, tag={Tag value}, compareTo={comparison}} where a tag can be compared to a value. returns true if tag is greater than comparison value

required attribute tag accepts a valid report tag that evaluates to a number. Raw attribute recommend for tag to compare number without formatting

required attribute compareTo accepts a number to be used to compared to tag.

optional attribute dec accepts a number to be used to round values when comparing.

See ReportTag for syntax.

Examples:

• ${eval:gt, tag=${calc:analysis_period}, compareTo=4}

EvaluateLessThanTag

The EvaluateLessThanTag class is applied to PowerPoint Report Templates when the following text is found: ${eval:lt, tag={Tag value}, compareTo={comparison}} where a tag can be compared to a value. returns true if tag is less than comparison value

required attribute tag accepts a valid report tag that evaluates to a number.

required attribute compareTo accepts a number to be used to compared to tag.

See ReportTag for syntax.

Examples:

• ${eval:lt, tag=${calc:analysis_period}, compareTo=4}

EvaluateNotEqualsTag

The EvaluateNotEqualsTag class is applied to PowerPoint Report Templates when the following text is found: ${eval:neq, tag={Tag value}, compareTo={comparison}} where a tag can be compared to a value. returns true if tag is not equal to comparison value

required attribute tag accepts a valid report tag. Tag can evaluate to either text or number

required attribute compareTo accepts either text or number

See ReportTag for syntax.

Examples:

• ${eval:neq, tag=${calc:analysis_period}, compareTo=4}

EvaluateOrTag

The EvaluateOrTag class is applied to PowerPoint Report Templates when the following text is found: ${eval:or, tags=[{Tag value}], compareTo={comparison}} where multiple tags can be compared to a value. returns true if any tag is equal to comparison value

required attribute tags accepts a multiple valid report tags. Tags passed in must be surrounded by [ ] brackets and ; separated. Tags passed in should evaluate to true or false for comparison.

required attribute compareTo accepts either text or number

See ReportTag for syntax.

Examples:

• ${eval:and, tags=[${eval:gt, tag=${calc:analysis_period}, compareTo=3}; ${tickbox:checked, mnemonic=tickbox1}]}

GlobalVariableCurrentValueTag

The GlobalVariableCurrentValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${global:current_value} where current_value returns the current value of the global variable.

parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${global:current_value, mnemonic=gv1}
• ${global:current_value, id=7}
• ${global:current_value, mnemonic=gv1, scale=0.001, unit=k, dec=2}

GlobalVariableImpactValuetag

The GlobalVariableImpactValuetag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${global:impact_value} where impact_value returns the impact value of the global variable.

parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.

optional parameter projection the projection value to return. Defaults to analysis current selected projection.

See ReportTag for syntax.

Examples:

• ${global:impact_value, mnemonic=gv1, projection=Conservative}
• ${global:impact_value, id=7}

GlobalVariableLabelTag

The GlobalVariableLabelTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${global:label} where label returns the label name of the global variable.

parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${global:label, mnemonic=gv1}
• ${global:label, id=7}

GlobalVariableProposedValueTag

The GlobalVariableProposedValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${global:proposed_value} where proposed_value returns the proposed value of the global variable.

parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.

optional parameter projection the projection value to return. Defaults to analysis current selected projection.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${global:proposed_value, mnemonic=gv1, projection=Conservative}
• ${global:proposed_value, id=7}
• ${global:proposed_value, id=7, scale=0.001, unit=k, dec=2}

GlobalVariableTooltipTag

The GlobalVariableTooltipTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${global:tooltip} where tooltip returns the tool tip of the global variable.

parameter id the id number of the global variable.
parameter mnemonic the mnemonic of the global variable.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${global:tooltip, mnemonic=gv1}
• ${global:tooltip, id=7}

ImageTag

InvestmentAnnualValueTag

The InvestmentAnnualValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${investment:annual_value} where annual_value returns the annual value of the investment. The text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter year returns year the value should return. Default is the initial value (e.g. year 0).

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${investment:annual_value, id=[investmentid]}
• ${investment:annual_value, mnemonic=invest1, year=1}
• ${investment:annual_value, id=123, scale=0.001, unit=k, dec=2}

InvestmentCumulativeTotalTag

The InvestmentCumulativeTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${investment:cumulative_total} where cumulative_total returns the cumulative total of the investment. The text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${investment:cumulative_total, id=[investmentid]}
• ${investment:cumulative_total, mnemonic=invest1}
• ${investment:cumulative_total, id=123, scale=0.001, unit=k, dec=2}

InvestmentTooltipTag

The InvestmentTooltipTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${investment:tooltip,id=investmentid} where tooltip returns the tool tip of the investment.

parameter id the id number of the investment.
parameter mnemonic the mnemonic of the investment.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${investment:tooltip,id=1}
• ${investment:tooltip,id=[investmentid]} - When used inside of a duplicate slide or duplicate section tag.

InvestmentTotalTag

* The InvestmentTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${investment:invested_total} where invested_total returns the total cumulative investment. The text will be replaced in-line (as opposed to removing and replacing the container).

Optional parameter year returns year the value should return. Default is the analysis period.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${investment:invested_total}
• ${investment:invested_total, year=1}
• ${investment:invested_total, scale=0.001, unit=k, dec=2}

InvestmentsIncludedTag

* The InvestmentsIncludedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${investment:investments_included} where investments_included returns true or false if the investments are included. The text will be replaced in-line (as opposed to removing and replacing the container).

See ReportTag for syntax.

Examples:

• ${investment:investments_included}

KeyPerformanceIndicatorCurrentValueTag

The KeyPerformanceIndicatorCurrentValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${kpi:current_value} where current_value returns the current value of the KPI.

parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${kpi:current_value, mnemonic=kpi1}
• ${kpi:current_value, id=7}

KeyPerformanceIndicatorNameTag

The KeyPerformanceIndicatorNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${kpi:name} where name returns the label name of the KPI.

parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${kpi:name, mnemonic=kpi1}
• ${kpi:name, id=7}

KeyPerformanceIndicatorOriginalValueTag

The KeyPerformanceIndicatorOriginalValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${kpi:original_value} where original_value returns the original value of the KPI.

parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${kpi:original_value, mnemonic=kpi1}
• ${kpi:original_value, id=7}

KeyPerformanceIndicatorTargetValueTag

The KeyPerformanceIndicatorTargetValueTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${kpi:target_value} where target_value returns the target value of the KPI.

parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${kpi:target_value, mnemonic=kpi1}
• ${kpi:target_value, id=7}

KeyPerformanceIndicatorTooltipTag

The KeyPerformanceIndicatorTooltipTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${kpi:tooltip} where tooltip returns the tooltip of the KPI.

parameter id the id number of the KPI.
parameter mnemonic the mnemonic of the KPI.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${kpi:tooltip, mnemonic=kpi1}
• ${kpi:tooltip, id=7}

LabelTextTag

AnalysisLanguageCodeTag

The AnalysisLanguageCodeTag class is applied to Report Templates when the following text is found: ${language:code} where code returns the iso code of the language

See ReportTag for syntax.

Example:

• ${language:code}

AnalysisLanguageNameTag

The AnalysisLanguageNameTag class is applied to Report Templates when the following text is found: ${language:name} where name returns the name of the language

See ReportTag for syntax.

Example:

RichTextEditorHtmlTag (text inputs)

The RichTextEditorHtmlTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${richText:html} where html returns the user entered text. If the text box is single line then the text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the rich text editor.
parameter mnemonic the mnemonic of the rich text editor.
Only one parameter is required for the tag, while the other can be omitted.

See ReportTag for syntax.

Examples:

• ${richText:html, mnemonic=rte1}
• ${richText:html, id=7}

RichTextEditorNameTag (text inputs)

The RichTextEditorNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${richText:name} where name returns the label name of the rich text editor.

parameter id the id number of the rich text editor.
parameter mnemonic the mnemonic of the rich text editor.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${richText:name, mnemonic=kpi1}
• ${richText:name, id=7}

SelectNameTag

The SelectNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${select:name} where name returns the label name of the Select.

parameter id the id number of the Select.
parameter mnemonic the mnemonic of the Select.
Only one parameter is required for the tag, while the other can be omitted.

Optional parameter asHTML will insert the contents as formatted HTML. This option will replace the container instead of a in line replacement.

See ReportTag for syntax.

Examples:

• ${select:name, mnemonic=select1}
• ${select:name, id=7}

SelectValueIncludedTag

The SelectValueIncludedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${select:value_included} where value_included returns true if value was selected by the user. The text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.

Required parameter values. The set of values to test if they were selected. The values require being surrounded by [] square brackets and must be semi-colon ; separated.

See ReportTag for syntax.

Examples:

• ${select:value_included, id=3}
• ${select:value_included, mnemonic=select1}
• ${select:value_included, mnemonic=select3, values=[option1;option2; option3]}

SelectValueSelectedTag

The SelectValueSelectedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${select:value_selected} where value_selected returns the value(s) that were selected by the user. The text will be replaced in-line (as opposed to removing and replacing the container).

parameter id the id number of the challenge.
parameter mnemonic the mnemonic of the challenge.
Only one parameter is required for the tag, while the other can be omitted.

optional parameter useLabel. If set to true, will display selected options label instead of value. Defaults to false

optional parameter display. If set to list, will display selected options as a bulleted list. Defaults to inline where options are comma separated

See ReportTag for syntax.

Examples:

• ${select:value_selected, id=3}
• ${select:value_selected, mnemonic=select1}
• ${select:value_selected, mnemonic=select3, useLabel=true, display=list}

SummaryModelDurationYearsTag

The SummaryModelDurationYearsTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:duration_years} where duration_years returns the duration in years of the summary model.

Examples:

• ${summary_model:duration_years}

SummaryModelIrrTag

The SummaryModelIrrTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:irr} where irr returns the Internal rate of return of the summary model.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${summary_model:irr}

SummaryModelNpvTag

The SummaryModelNpvTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:npv} where npv returns the total Net present value of the summary model.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${summary_model:npv}

SummaryModelPaybackPeriodTag

The SummaryModelPaybackPeriodTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:payback_period} where payback_period returns the payback period in months of the summary model.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${summary_model:payback_period}

SummaryModelRoiTag

The SummaryModelRoiTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:roi} where roi returns the Return on Investment of the summary model.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${summary_model:roi}

SummaryModelTotalBenefitsRealizedTag

The SummaryModelTotalBenefitsRealizedTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:total_benefit_realized} where total_benefit_realized returns the total realized benefit of the summary model.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${summary_model:total_benefit_realized}

SummaryModelTotalInvestmentDiscountedTag

The SummaryModelTotalInvestmentDiscountedTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:total_investment_discounted} where total_investment_discounted returns the total investment with discount applied for the summary model.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${summary_model:total_investment_discounted}

SummaryModelTotalInvestmentTag

The SummaryModelTotalInvestmentTag class is applied to Report Templates when the following text is found in a text box: ${summary_model:total_investment} where total_investment returns the total investment of the summary model.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

See ReportTag for syntax.

Examples:

• ${summary_model:total_investment}

ClientFirstNameTag

The ClientFirstNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:client_first}. It will display the client/recipient first name inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:client_first}

ClientLastNameTag

The ClientLastNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:client_last}. It will display the client/recipient last name inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:client_last}

ClientPhoneTag

The ClientPhoneTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:client_phone}. It will display the client/recipient phone number inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:client_phone}

ClientTitleTag

The ClientTitleTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:client_title}. It will display the client/recipient title inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:client_title}

RepFirstNameTag

The RepFirstNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:rep_first}. It will display the sales representative first name inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:rep_first}

RepLastNameTag

The RepLastNameTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:rep_last}. It will display the sales representative last name inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:rep_last}

RepPhoneTag

The RepPhoneTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:rep_phone}. It will display the sales representative phone number inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:rep_phone}

RepTitleTag

The RepTitleTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:rep_title}. It will display the sales representative title inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:rep_title}

TargetEmailTag

The TargetEmailTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${db:target_email}. It will display the email that the report was sent to inline (as opposed to removing and replacing the container).

There are no optional parameters.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${db:target_email}

ValueMapCategoryAverageIdealTotalTag

The ValueMapCategoryAverageIdealTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:average_ideal_total, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the ideal average total over the analysis period, text will be replaced in-line (as opposed to removing and replacing the container).

Parameter id is required.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:average_ideal_total, id=[vmcid]}
• ${vmc:average_ideal_total, id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryAverageRealizedTotalTag

The ValueMapCategoryAverageRealizedTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:average_realized_total, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the realized average total over the analysis period, text will be replaced in-line (as opposed to removing and replacing the container).

Parameter id is required.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:average_realized_total, id=[vmcid]}
• ${vmc:average_realized_total, id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryCurrentTotalTag

The ValueMapCategoryCurrentTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:current_total, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the current total in-line (as opposed to removing and replacing the container).

Parameter id is required.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:current_total, id=[vmcid]}
• ${vmc:current_total, id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryIdealBenefitTotalTag

The ValueMapCategoryIdealBenefitTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:ideal_Benefit_total, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the ideal benefit total in-line (as opposed to removing and replacing the container).

Parameter id is required.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:ideal_Benefit_total, id=[vmcid]}
• ${vmc:ideal_Benefit_total, id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryIncludedTag

The ValueMapCategoryIncludedTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:included, id=[vmcid]} where it will return true if a category was included. [vmcid] is a valid value map category id. It will display in-line (as opposed to removing and replacing the container).

Parameter id is required.

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:included, id=[vmcid]}

ValueMapCategoryMultiYearTableTag

The ValueMapCategoryMultiYearTableTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:table_multi_year} where table_multi_year will return a Multi year summary of Value map categories.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.

Optional parameter headerBg will set the background color of the table header to the entered Hex value.

Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.

Optional parameter textBackground will set the background color of the table rows to the entered Hex value.

Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.

Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.

Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.

Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.

Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:

• light
• dark

Optional parameter impactType will set the values returned. Accepts the following

• realized
• ideal

Optional parameter sortBy will set the order returned. Accepts the following

• default - default display order
• name - by name order
• value - by highest value

Optional parameter type determines the type of table returned. Accepts the following values:

• category (summary of a specific category, requires an id of the value category)
• monetary (summary of only monetary categories)
• non_monetary (summary of only non monetary categories)
• overview (brief overview of both monetary/non monetary categories)

These parameters are required if targeting a specific value category.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${vmc:table_multi_year, projection=Conservative}
• ${vmc:table_multi_year, type=overview}
• ${vmc:table_multi_year, type=monetary, headerFg=#E0E0E0, headerBg=#11a6c0}
• ${vmc:table_multi_year, type=category, id=1}
• ${vmc:table_multi_year, type=category, id=1, theme=dark}

ValueMapCategoryProposedTotalTag

The ValueMapCategoryProposedTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:proposed_total, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the proposed total in-line (as opposed to removing and replacing the container).

Parameter id is required.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:proposed_total, id=[vmcid]}
• ${vmc:proposed_total, id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryRealizedBenefitTotalTag

The ValueMapCategoryIdealBenefitTotalTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:realized_Benefit_total, id=[vmcid]} where [vmcid] is a valid value map category id. It will display the realized benefit total in-line (as opposed to removing and replacing the container).

Parameter id is required.

Optional parameter scale where the decimal value passed will be used to scale the displayed value

Optional parameter unit where the value set will be displayed as the unit abbreviation (e.g. K,M,B)

Optional parameter dec where the value set will overwrite the decimal precision of the displayed value

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

The tag is case-insensitive.

See ReportTag for syntax.

Example:

• ${vmc:realized_Benefit_total, id=[vmcid]}
• ${vmc:realized_Benefit_total, id=123, scale=0.001, unit=k, dec=2}

ValueMapCategoryValueTableTag

The ValueMapCategoryValueTableTag class is applied to PowerPoint Report Templates when the following text is found in a text box: ${vmc:table_category_value} where table_category_value will return various value summaries for Value map categories, or various detailed summaries of a specific category.

Optional parameter projection accepts a name of a projection (e.g. Conservative, Probable, Optimistic), which the value returned is based on. Default is the users selected projection

Optional parameter sortBy will set the order returned. Accepts the following

• default - default display order
• name - by name order
• value - by highest value

Optional parameter headerFg will set the foreground color of the table header to the entered Hex value.

Optional parameter headerBg will set the background color of the table header to the entered Hex value.

Optional parameter textForeGround will set the foreground color of the table rows to the entered Hex value.

Optional parameter textBackground will set the background color of the table rows to the entered Hex value.

Optional parameter subTotalFg will set the foreground color of the table subtotal rows to the entered Hex value.

Optional parameter subTotalBg will set the background color of the table subtotal rows to the entered Hex value.

Optional parameter totalFg will set the foreground color of the table total rows to the entered Hex value.

Optional parameter totalBg will set the background color of the table total rows to the entered Hex value.

Optional parameter theme will set a default background color and text color for all rows (colors overwritten by above options). Accepts the following values:

• light
• dark

Optional parameter type determines the type of table returned. Accepts the following values:

• annual_ideal (annual ideal value summary)
• annual_realized (annual realized value summary)
• average_ideal (average ideal value summary of all years)
• average_realized (average realized value summary of all years)
• total_ideal (total ideal value summary of all years)
• total_realized (total realized value summary of all years)

These parameters are required if targeting a specific value category.
parameter id the id number of the benefit.
parameter mnemonic the mnemonic of the benefit.
Only one parameter is required for the tag, while the other can be omitted.

The tag is case-insensitive.

See ReportTag for syntax.

Examples:

• ${vmc:table_category_value, projection=Conservative}
• ${vmc:table_category_value, type=annual_ideal}
• ${vmc:table_category_value, type=average_ideal, headerFg=#E0E0E0, headerBg=#11a6c0}
• ${vmc:table_category_value, type=average_realized, id=1}
• ${vmc:table_category_value, type=total_realized, mnemonic=benefit1, theme=dark}