Naming Rules

In order to separate the Civil LAB functions with other built-in Excel functions and tables, all the Civil LAB modules are suggested to start with the keyword “CL_”. For example when you type in “=cl” in excel, all the newly added functions are shown.

And the built-in data are storage in tables with the name “CLT_”, under the spreadsheet “CL_Tables” (hidden by default)

1) Naming rules for new functions

The new added functions should started with the keyword “CL_” and a second keyword indicates the categories of the function such as “CL_D_ConcreteData”. The details are as follow in the table, new category names could be added.

“CL_D_”	Functions related to Database handling and Data related
“CL_Dr_”	Functions related to drawing and plotting, visualization
“CL_G_”	Functions related to general calculations (interpolation etc.)
“CL_EC0” to “CL_EC9”	Functions related to Eurocodes from EN1990 to EN1999
“CL_M_”	Functions related to the general Mechanical calculations, such as cross-section properties
“CL_IO_”	Functions relates to inputs/outputs communications

1) Naming rules for new tables

The new added built-in tables should started with the keyword “CLT_” and followed by the table name. All the tables should be stored in the spread sheet started with “CL_”, it is suggested to add new tables directly in the default “CL_Tables”.

The data table should “format as table” to create excel data table for easier handling and manage the data. The names of the data can be modified by Formulas > Name Mangers.

1) Naming rules for new User Forms

The new added built-in user forms should started with the keyword “UF_”