> For the complete documentation index, see [llms.txt](https://brenkel-solutions-eg.gitbook.io/dp-calculation-eng/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://brenkel-solutions-eg.gitbook.io/dp-calculation-eng/pre-calculation/schemas.md).

# Schemas

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

![Figure 1: Schemas](/files/T4omx76lhGAyIaFQvj56)

## Layout

### Row and column layout

The row layout and column layout is similar to the logic in the [schema templates](/dp-calculation-eng/pre-calculation/schema-templates.md). 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](/files/FnoYBOfIbMikmV6DWfCC)

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](/files/jzQw5C0ZQmp893PesLkX)

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
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, and the optional `goal` query parameter:

```
GET https://brenkel-solutions-eg.gitbook.io/dp-calculation-eng/pre-calculation/schemas.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.