Compute Length-Weighted Averages of I-Data Values

RockWorks | Borehole Operations | I-Data | Length Composite Weighting (LCW)

Use this program to compute length-weighted averages for a single column of I-Data values, based on data sampled at regular or irregularly-spaced intervals. "Length Composite Weighting" (LCW) refers to a process in which the interval values (e.g. geochemistry) are multiplied by their corresponding thickness. These values are then summed and divided by the sum of their thicknesses. In other words, a number of intervals are averaged in such as way that the thicker intervals are weighted more heavily.

Length Weighted Value = ∑ ( ( v1 * t1 ) ...  ( vn * tn ) ) / ∑ ( t1 .. tn )

where v = I-Data value and t = I-Data Interval Thickness

The results of the LCW computations will be stored in a selected I-Data column in the project database.

There are four different methods for computing the LCW: 

Feature Level: RockWorks Standard and higher

Menu Options
Step-by-Step Summary


  1. Access the RockWorks Borehole Manager program tab.
  2. Be sure you have a column available in the I-Data table for the length weighted computations which will be recorded there. See Defining I-Data Columns for more information.
  3. Select the Borehole Operations | I-Data | Length Composite Weighting menu option.
  4. Establish the desired program settings, as discussed above.
  5. Click the Continue button to proceed with the computations.

The program will read the contents of the input I-Data track, determine the existing intervals for the selected input column, and compute the length-weighted values using the selected method. The resulting values will be recorded in the selected output I-Data track.

The following diagram illustrates three of these LCW computations. The red bargraph shows the original data sampled at irregular intervals. The blue bargraph shows LCW computations for the baby-blue stratigraphic unit using the "Stratigraphic" method described above. The pink bargraph shows the LCW computations based on the "Elevation" method and a 10-unit sampling interval. Finally, the green bargraph shows the LCW computations based on the "Borehole Increments" (depths) and a 12-unit sampling interval.



 Back to I-Data Menu Summary 

RockWare home page