Custom Table Input with Calculations

This extension allows using dynamic HTML tables with basic calulation functionalites to be used within the Azure DevOps work items.

How to use

After installing the extension, you can create dynamic HTML tables with basic calulation functionalites to be used within the Azure DevOps work items.

You must define list of column names for the table, and you need to define a multi-line text field within the item, to which the content of the dynamic table can be saved. You can add as many table as needed as long as each of them have their dedicated Output CSV -field defined.

Optionally, you can also give as an input the initial row count, list of columns for which you would like to get the sum on the bottom row of the table.

It is also possible to define some basic functions for selected columns. Basic Arithmetic Functions are supported:
Addition (+): Adds two or more values.
Subtraction (-): Subtracts one value from another.
Multiplication (*): Multiplies two or more values.
Division (/): Divides one value by another.

In the column functions the existing columns can be referenced within square brackets [ ].

The column names, the optional list of columns for summing and the optional list of columns with functions are given as semi-colon separated lists.

Example inputs

Column Names: Short description;As-is (h/year);To-be (h/year);Gain/Saving (h/year);EUR/h;Annual_saving_in_KEUR

Column Functions: ;;;[As-is (h/year)]-[To-be (h/year)];;[Gain/Saving (h/year)]*[EUR/h]/1000

Row Count: 2

Columns With sum: Gain/Saving (h/year);Annual_saving_in_KEUR

CSV Output: outputCSV

Feedback and issues

If you have feedback or issues, please send an email.