> 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/neue-tabelle-erstellen.md).

# Create New Table

To import data from the JUNE5 server, click the **"Create New Table"** button on the tab.

A window opens in which general settings for the table can be configured.

![](/files/ZeGJrErQcf1JCQoT3M5G)

When you click on "Select Measured Variables", a panel is displayed on which you can select the process variables whose data you want to import. The filter functionality allows you to quickly find process variables even in large facilities.

![](/files/gplDWPZb5z2ClQEtfIqB)

After the desired variables are selected via the "Plus" button or by double-clicking, the dialog can be confirmed via "Ok".

Subsequently, data type and time settings can be configured.

![](/files/y64xIKlaToWBo8GhsKjz)

With Data Type you set the compression level that should form the basis of the report. Via Start Date and Duration, the beginning and report length are determined. In the list, the selected measured variables can be deleted or their order changed.

Before retrieving the data, select a cell in the Excel table where the table header should begin. Then click GET DATA to retrieve data of the previously set parameters and insert it into the Excel table.

Clicking the "Advanced" button opens another window for additional settings.

![](/files/0wm6Rt0gptMkaiT5nvnv)

In the "Table Content" field, optional information about the table can be added or deselected. Additionally, it is possible to configure the order of individual information via the arrows. In the "Cell References" field, you can configure which data within the table is specified as references.

| **Checkbox**                      | **Cell Content (Checked)**                                       | **Cell Content (Unchecked)**                                                      |
| --------------------------------- | ---------------------------------------------------------------- | --------------------------------------------------------------------------------- |
| All                               | =J5GetPVValue($A10; B$5; "DAY1"; "VAL")                          | =J5GetPVValue("02.09.2016 00:00:00"; "DEMOSTD\_Acron73.DN10IE001"; "DAY1"; "VAL") |
| Reference Date                    | =J5GetPVValue($A10; "DEMOSTD\_Acron73.DN10IE001"; "DAY1"; "VAL") | =J5GetPVValue("02.09.2016 00:00:00"; "DEMOSTD\_Acron73.DN10IE001"; "DAY1"; "VAL") |
| Reference Name                    | =J5GetPVValue("02.09.2016 00:00:00"; B$5; "DAY1"; "VAL")         | =J5GetPVValue("02.09.2016 00:00:00"; "DEMOSTD\_Acron73.DN10IE001"; "DAY1"; "VAL") |
| Reference Data Between Each Other | = $A9 + TIME(0;0;0) + 1                                          | 02.09.2016 00:00:00                                                               |
| Reference Units                   | =J5GetPVUnit(B$5)                                                | pH                                                                                |
| Reference Long Names              | =J5GetPVLongname(B$5)                                            | ph-value DN10IE001                                                                |
| Reference Short Names             | =J5GetPVShortname(B$5)                                           | DN10IE001                                                                         |


---

# 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/neue-tabelle-erstellen.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.