An improved solution of local window parameters setting for local singularity analysis based on Excel VBA batch processing technology

• BTLSIM reduces manual operations and improves efficiency.
• It offers more parameter selections for LSA allowing the use of different types of local windows including anisotropic windows to explore different forms of singularities, and both mean value and median value can be used to represent the average content for the local window.
• It presents a relatively self-adaptive local singularity determination algorithm which can result in an optimized LSI map, providing three kinds of parameter layers for variable range, direction, and compressibility of anisotropy in space, respectively.

In this paper Excel VBA is used for batch calculation in Local Singularity Analysis (LSA), which is for the information extracting from different kinds of geoscience data. Capabilities and advantages of a new module called Batch Tool for Local Singularity Index Mapping (BTLSIM) are: (1) batch production of series of local singularity maps with different settings of local window size, shape and orientation parameters; (2) local parameter optimization based on statistical tests; and (3) provision of extra output layers describing how spatial changes induced by parameter optimization are related to spatial structure of the original input layers.