---
title: "Limit Editor"
slug: "limit-editor"
updated: 2024-02-02T12:10:41Z
published: 2024-02-02T12:10:41Z
canonical: "kb.dataparc.com/limit-editor"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.dataparc.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Limit Editor

This sheet adds and edits PARCview limits. To open a new Limit Editor sheet, click the **Admin Tools** icon, then select **Limit Editor** from the drop-down gallery.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image122.jpg)

Select a **Location** and **Source** by clicking the corresponding ellipsis buttons.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image124.jpg)

To display the current limits in the database, click **Get Limits**. Optionally specify filters for **Tag Name** and **Grade**. All other fields are not used at this point.

#### Editing Limits Manually

After displaying the limits, you may edit them manually.

1. Find the desired **Tag Name** and **Grade**. To edit non-grade-based limits, find a row with an empty grade.
2. Fill **Lower**, T **arget**, and **Upper** with the new limits. Use the fields under **Control** or **Spec** as appropriate. If entering another limit type, change all instances of either **Control** or **Spec** on the sheet to the other limit type’s name. You may enter any combination of limits and limit types at once. As you change the fields, they will turn yellow.
3. Fill **Date** with the effective date of the limit. If date is left empty, the limit will take effect starting at the current time.
4. Select all rows with edited limits and click **Set Limits**.

#### Calculating Limits

For tags with rollup data, you may also calculate limits based on the average and standard deviation of rollup runs. For grade-based limits, grade runs are used. For non-grade-based limits, days are used.

1. Click the **Limit calculator** expander to reveal the limit calculation options.
2. Fill the **Start date** and **End date** with the interval containing the runs on which to base the calculation. Optionally fill **Max runs** with the maximum number of runs to use (the calculation will prioritize runs with later start dates), and **Min hours** with the minimum hours of uptime for a run to be used.
3. Select the desired **Tag Name** and **Grade** rows. To calculate non-grade-based limits, select rows with an empty grade.
4. Click **Fill Calcs**. The fields under **Calc** will fill in for the selected rows.
5. Review the **Avg** (average), **StDev** (standard deviation), **Hours** (total uptime hours), and **Runs** (number of runs). To see and change the basis runs for a row, select that row and click **Detail Calc**. The **Select Runs** form will appear. Click the checkboxes to toggle whether to use each run.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image126_002.jpg)
6. Re-select the rows with calculations, and click **Auto Limits**. The limits will fill according to the following formulas by default: **Control** **Lower** = Avg – 3 * StDev, **Control** **Target** = Avg, **Control** **Upper** = Avg + 3 * StDev. Use the Lower multiplier and Upper multiplier fields to change the number of sigmas. Limits are rounded to two decimal places by default. The new limits’ effective date will be midnight of the current day.
7. Click **Set Limits** to save the new limits.