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

Built-in functions

PreviousIndex to groupNextGeneral Functions

Last updated 3 years ago

Built-in functions can be used just as the default Excel functions. With built-in functions, you can do engineering calculations based on codes or basic mechanics; easier to handle the data, or do the general operations with your excel.

In order to enable the hints for the functions, the third-party addin "ExcelDNA" is needed. Please keep the "ExcelDna.IntelliSense.xll" and "ExcelDna.IntelliSense64.xll" from under the same folder of the Excel VBA main excel worksheet.

Civil-Lab provides a lot of new build-in functions in excel. You can use it just like the default excel functions such as "=Sum()". All the added functions are started with the keyword "CL_". The new functions cover utilization, plotting, calculations based on Eurocodes, and many more.

General Functions
Database Function
Eurocode function
Example of build in function
download