Overview

Three $//<![CDATA[ \begin{array}{l}q_c\end{array} //]]>$ and $//<![CDATA[ \begin{array}{l}q_t\end{array} //]]>$ average calculations are predefined in the formula tool, along with options to show these on relevant reports.

Moving Average

The Cone_Resistance_Moving_Average and Total_Cone_Resistance_Moving_Average field on CPT_DATA is an average of $//<![CDATA[ \begin{array}{l}q_c\end{array} //]]>$ and $//<![CDATA[ \begin{array}{l}q_t\end{array} //]]>$ values above and below the given depth. The distance above and below can be configured in the CPT_PROJECT_PARAMETERS table, in the field Moving_Average_Thickness. The thickness defines the depth range of the $//<![CDATA[ \begin{array}{l}q_c\end{array} //]]>$ and $//<![CDATA[ \begin{array}{l}q_t\end{array} //]]>$ values taken, where the given depth is in the middle of the range.

For example, specifying a Moving_Average_Thickness of 1 m, the $//<![CDATA[ \begin{array}{l}q_c\end{array} //]]>$ and $//<![CDATA[ \begin{array}{l}q_t\end{array} //]]>$ values are taken from ±0.5m from the given depth.

Stepped Average

Similar concept to moving average, except the interval is a fixed depth scale, e.g. 0 m to 1 m, 1 m to 2 m etc. The step distance id defined in Stepped_Average_Thickness on CPT_PROJECT_PARAMETERS.

Strata Average

Strata average takes intervals from the STRATA_MAIN table. Hence you first need to run the Transfer Description and Consistency function, and then recalculate the CPT_DATA table.