# Schemas

If you do not have a precalculation schema template stored, you can also enter the schemas manually.

![Figure 1: Schemas](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2F1gN5iWnXHXemsMLhtzxt%2F001_Schema.png?alt=media\&token=acfaf44c-79df-4cfe-b0c7-d1e623eb799b)

## Layout

### Row and column layout

The row layout and column layout is similar to the logic in the [schema templates](https://brenkel-solutions-eg.gitbook.io/dp-calculation-eng/pre-calculation/schema-templates). The only difference is that the columns must be linked to a calculation. Thus, only a connection between a schema and the associated calculation can be established.

![Figure 2: Linked calculation to schema](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2FLrO28uZk8spJiYnH4YKz%2F003_Schema.png?alt=media\&token=18216189-8f74-4846-a144-8eb5226ac69f)

In the case of a template, this link is created automatically.\
If you change anything in the schema, you need to update the schema. After that, the corresponding entries will be recalculated.

#### Mark best result

If the “Mark best result” field is active, the lowest result is displayed. The goal is to find the lowest “Per piece” price. The lowest “by piece” price in the scheme is decisive. If this is found, the last cell (combination of last row and found column) is marked green.

## Calculation Entries and Calculation Values

### Calculation Entries

When updating the schema, so-called “calculation entries” are created. These form the basis for further evaluation.

![Figure 3: Calculation Entries](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2F5rCIRwhKGffq30CDxIba%2F004_Schema.png?alt=media\&token=752c8f58-b581-4972-b399-e759da8c2eb4)

For items, work centers and machine centers the individual lines of the calculation are transferred. At this point, the filters of the schema are also taken into account. If, for example, only a certain item category is evaluated, only the corresponding articles appear in the items for this line of the schema. The individual surcharges are also calculated here, in case they are required.

You can open the entries via the lookup, in which you click on the number of a row with matching totlaing type.

### Calculation Values

The calculation values are the “results” of the calculation. For each combination of row (line) and column, the associated value is logged there and displayed in the mask.


---

# Agent Instructions: 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://brenkel-solutions-eg.gitbook.io/dp-calculation-eng/pre-calculation/schemas.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.