Civil LAB - Excel
  • What is CIVIL LAB Excel?
  • Introduction
    • How to use ? Installation
    • Introduction of the modules
    • Copy right agreement
  • Documentation
    • Ribbon Tools
      • Formatting tools
        • Color It
        • Advanced Formatting
        • Auto Units
        • Group color
      • Utilization Tools
        • Pro copy
        • Level Sum
      • EuroCode Tools
        • Eurocode 4
        • Eurocode 3
        • Eurocode 2
          • Creep Coefficient
        • Eurocode 0 & 1
      • Database tools
        • Engineer Database
        • Group to index
        • Index to group
    • Built-in functions
      • General Functions
        • CL_G_TabelInterpolation
        • CL_G_CreateListTablePicker
        • CL_G_ListTableFind
        • CL_G_Table_find
        • CL_G_VlookupTable
      • Database Function
      • Eurocode function
      • Mechanical functions
        • CL_M_Rebars_A
        • CL_M_Recdata
        • CL_M_HProfileData
        • CL_M_Zel
    • Ready made Excel
      • Parametric tool : input output
      • Composite beam stiffness
    • Excel-Python
  • Contacts and development
    • For Programmers
      • Civil LAB framework
      • Resources
      • Naming Rules
      • Guides to Function Modules
      • Guides to Data Tables
      • Guides to Ribbons
    • For Engineers
      • What is possible?
    • For Supporter
      • Donation / contribution
    • Contact infomation
  • 💾Downloads
  • Road map
    • Road Map
Powered by GitBook
On this page
  1. Documentation
  2. Built-in functions
  3. General Functions

CL_G_TabelInterpolation

Table interpolation

PreviousGeneral FunctionsNextCL_G_CreateListTablePicker

Last updated 3 years ago

Description:

Automatic find value x in the first list (List 1) and calculate the corresponding value in the second list (List 2) based on linear interpolation of every type of table.

for an only horizontal table can also use

for an only vertical table can also use

The parameter list:

Parameters
Explanation
Data Type

List 1

the Row of values to be compared

Range

List 2

the Row of values contains the corresponding results

Range

x

the input value which will be compared with list 1

number

Video guide:

"CL_G_TabelInterpolationH"
"CL_G_TabelInterpolationV"