--- title: "Fixed Step" slug: "fixed-step" updated: 2024-02-02T11:45:22Z published: 2024-02-02T11:45:22Z canonical: "kb.dataparc.com/fixed-step" --- > ## 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. # Fixed Step Interpolation types for each tag are selected in the **Interpolate** drop-down menus in row 9. Tags can be repeated in row 1 with different interpolation types to display different aggregates of the same tag. **TimeAvg*:** Time weighted average of the tag over the step size. **TimeAvg2*:** Same as TimeAvg but does not carry forward the last known good quality point across a bad quality timespan. **Avg*:** Arithmetic average of the tag over the step size. **Linear:** Linearly interpolates the tag’s value at the time step. **Manual:** If **Data type** is set to manual, this will return raw data for the tag. **Calc:** Takes the calculation built in that column’s row 17 (Test Data/Calc) and copies it down to all the cells in that column where there is data. A custom calculation can be made in that row that uses other tag’s values and it will be copied down to the cells. No Tag Name needs to be entered in the first row. See below for more. **Count:** The count of the actual values of the tag over the step size. **SD:** The standard deviation of the tag over the step size. **Min:** The minimum value of the tag over the step size. **Min2:** Same as Min except it includes interpolated bounding values. **MinAtTime2:** The Min value and the timestamp. **Max:** The maximum value of the tag over the step size. **Max2:** Same as Max except it includes interpolated values. **MaxAtTime2:** The Max value and the timestamp. **Total:** The TimeAvg aggregate multiplied by the step size in seconds. **Total2:** The TimeAvg2 aggregate multiplied by the step size in seconds. **Sum:** The sum of all the actual values of the tag over the step size. **Start:** The first value of the tag over the interval. **End:** The last value of the tag over the interval. **DurationGood:** The duration of the time interval, in seconds, that the quality of the tag was good. **DurationBad:** The duration of the time interval, in seconds, that the quality of the tag was bad. **PercentGood:** The percent of the time interval that the quality of the tag was good. **PercentBad:** The percent of the time interval that the quality of the tag was good. **State:** Treats the tag as a state tag and the values only change if they actual change in history. It flat lines the tag between points. *****the **–Qual** option for these interpolation types returns the quality number for that interpolation type. If the Decimals row (row 10) is set to text, this will bring back the text string for the quality. One of the interpolation types is **Calc**, and is used to make a column a calculated column. A formula/equation can be put in the **Test Data/Calc** cell (row 17) of a column, and this formula will be copied down the column when Get or Filt are clicked. The Calc column is treated like a actual tag column- the Stats rows are filled in, Filters can be applied to it, it can be trended by clicking the ‘Chrt” button and it can be used to Exclude Rows. The Normalized sheet will always copy the formula down the same length as all of the other tags. Clicking the Filt button will fill a new Calc column and recalc existing columns without retrieving new data, as the Get button would. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image073_001.png)