> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/june5-3.7/en/weitere-june5-produkte/june5-add-in-for-excel/funktionsweise-des-add-ins.md).

# How the Add-In Works

To retrieve data from the JUNE5 server, JUNE5 Add-In for Excel relies on Excel's formula function. Four formulas are used.

#### To display a process value, the following formula is used:

| Format:    | =J5GetPVValue("DATE"; "DATASOURCEKEY"; "COMPRESSION LEVEL"; "AGGREGATE FUNCTION") |
| ---------- | --------------------------------------------------------------------------------- |
| Example 1: | =J5GetPVValue("02.09.2016 00:00:00"; "DEMOSTD\_Acron73.DN10IE001"; "DAY1"; "VAL") |
| Example 2: | =J5GetPVValue($A10; B$5; "DAY1"; "VAL")                                           |

#### To display the short name, the following formula is used:

| Format:    | =J5GetPVShortname("DATASOURCEKEY")              |
| ---------- | ----------------------------------------------- |
| Example 1: | =J5GetPVShortname("DEMOSTD\_Acron73.DN10IE001") |
| Example 2: | =J5GetPVShortname(B$5)                          |

#### To display the long name, the following formula is used:

| Format:    | =J5GetPVLongname("DATASOURCEKEY")              |
| ---------- | ---------------------------------------------- |
| Example 1: | =J5GetPVLongname("DEMOSTD\_Acron73.DN10IE001") |
| Example 2: | =J5GetPVLongname(B$5)                          |

#### To display the unit, the following formula is used:

| Format:    | =J5GetPVUnit("DATASOURCEKEY")              |
| ---------- | ------------------------------------------ |
| Example 1: | =J5GetPVUnit("DEMOSTD\_Acron73.DN10IE001") |
| Example 2: | =J5GetPVUnit(B$5)                          |

#### Special outputs of the formulas

| #invalid  | The datasource key does not exist in JUNE5. |
| --------- | ------------------------------------------- |
| #updating | The value of the cell is being updated.     |
| #no data  | No value at this time.                      |

## Datasource Key

The datasource key consists of the facility identification from JUNE5 and the short name of the process variable. These are separated by a period.

Example: J5DA.BHKW1\_EL

## Aggregate Functions

| **Function** | **Description**                                           |
| ------------ | --------------------------------------------------------- |
| VAL          | Value (Process, Interval, Daily, Weekly, Monthly, Yearly) |
| PSUM         | Sum of process values                                     |
| PSIGMA       | Standard deviation of process values                      |
| PPERC15      | Percentile value of process values                        |
| PPERC85      | Percentile value of process values                        |
| PMIN         | Minimum of process values                                 |
| PMAX         | Maximum of process values                                 |
| PMINLIM      | Lower limit violation of process values                   |
| PMAXLIM      | Upper limit violation of process values                   |
| PCOUNT       | Count of process values                                   |
| VALAVG       | Average value                                             |
| ISUM         | Sum of interval values                                    |
| ISIGMA       | Standard deviation of interval values                     |
| IPERC15      | Percentile value of interval values                       |
| IPERC85      | Percentile value of interval values                       |
| IMIN         | Minimum of interval values                                |
| IMAX         | Maximum of interval values                                |
| IMINLIM      | Lower limit violation of interval values                  |
| IMAXLIM      | Upper limit violation of interval values                  |
| ICOUNT       | Count of interval values                                  |
| DSUM         | Sum of daily values                                       |
| DSIGMA       | Standard deviation of daily values                        |
| DPERC15      | Percentile value of daily values                          |
| DPERC85      | Percentile value of daily values                          |
| DMIN         | Minimum of daily values                                   |
| DMAX         | Maximum of daily values                                   |
| DMINLIM      | Lower limit violation of daily values                     |
| DMAXLIM      | Upper limit violation of daily values                     |
| DCOUNT       | Count of daily values                                     |
| MSUM         | Sum of monthly values                                     |
| MSIGMA       | Standard deviation of monthly values                      |
| MPERC15      | Percentile value of monthly values                        |
| MPERC85      | Percentile value of monthly values                        |
| MMIN         | Minimum of monthly values                                 |
| MMAX         | Maximum of monthly values                                 |
| MMINLIM      | Upper limit violation of monthly values                   |
| MMAXLIM      | Lower limit violation of monthly values                   |
| MCOUNT       | Count of monthly values                                   |

## Compression Levels

| **Level**        | **Description**                      |
| ---------------- | ------------------------------------ |
| PROCESS          | Process data                         |
| INTERVAL1        | Interval data 1 \*                   |
| INTERVAL2        | Interval data 2 \*                   |
| INTERVAL3        | Interval data 3 \*                   |
| INTERVAL4        | Interval data 4 \*                   |
| INTERVAL5        | Interval data 5 \*                   |
| INTERVAL6        | Interval data 6 \*                   |
| INTERVAL7        | Interval data 7 \*                   |
| INTERVAL8        | Interval data 8 \*                   |
| DAY1             | Daily data from the main interval    |
| DAY2             | Daily data from secondary interval 2 |
| DAY3             | Daily data from secondary interval 3 |
| DAY4             | Daily data from secondary interval 4 |
| DAY5             | Daily data from secondary interval 5 |
| DAY6             | Daily data from secondary interval 6 |
| DAY7             | Daily data from secondary interval 7 |
| DAY8             | Daily data from secondary interval 8 |
| WEEK             | Weekly data                          |
| MONTH            | Monthly data                         |
| YEAR             | Yearly data                          |
| VGCOMMENT\_DAY   | Daily comments of a VG               |
| VGCOMMENT\_WEEK  | Weekly comments of a VG              |
| VGCOMMENT\_MONTH | Monthly comments of a VG             |
| VGCOMMENT\_YEAR  | Yearly comments of a VG              |

*\* Interval data can also be specified via the timespan of the interval. E.g. "15 min" or "2 h".*


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.videc.de/june5-3.7/en/weitere-june5-produkte/june5-add-in-for-excel/funktionsweise-des-add-ins.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.