It sounds like what you want is the single cell data option. You can find this in the help documentation inside the Excel Reports Module:

This works by creating a named range such as "voltage" and then in your excel template give a single cell the named range of voltage.lastValue

Now link your voltage data point to the voltage named range.

From the help documentation:

**Mango Data Available**

Mango can insert various types of data into an Excel named range. Some are single cell while others require a column or row.

## Single Cell Data

Single cell data can be assigned into cells by creating a named range with a .{data_name} postfix. For example to insert the XID for a data point one would use the named rangevoltage.average. Then via the Mango template configuration page one can link a data point to a named range of voltage. This will allow any named range that starts with voltage prefix to be filled in the the available single cell data. The following are a lists of available single cell data:

### For any point:

**xid** - The XID of the linked point

**name** - The name of the linked point

**deviceName** - the device name of the linked point

### For Numeric Points:

**firstValue** - The first value of the time period

**firstTime** - The date of the first value of the time period

**lastValue** - The last value of the time period

**lastTime** - The date of the last value of the time period

**minimumValue** - The statistical minimum value of the time period

**minimumTime** - The date of the statistical minimum value of the time period

**maximumValue** - The statistical maximum value of the time period

**maximumTime** - The date of the statistical maximum value of the time period

**average** - The statistical average value of the time period

**integral** - The statistical integral value of the time period

**sum** - The statistical sum of the time period

**count** - The count of samples within the time period

*See more in the help documentation*