Brief Introduction Microsoft Visual Basic for Application (VBA) is a powerful tool for Microsoft Office Suite. General users usually only use a small portion of functions Microsoft Office provides and never have a chance to touch VBA. However, Microsoft Excel is an great tool to do math and graph. If VBA is used with the [...]
Instruction You may use Visual Basic for Application for a while and wrote a lot of customized functions. I found majority of VBA users do not know how to use array as function arguments or return values in an array. Excel provides some of Worksheet functions that can return an array, such as “frequency”. For [...]
Problem I have a data set that includes data values for several segments with equal length. These values can be considered as average values across the whole segments. The neighboring segments are not independent with each other. In reality, segments are artificially dissection of a longer segments. Let us consider that this object is a [...]
In SAS, lsmeans treatment /pdiff of PROC mixed or GLM output mean values and a matrix of probability values of all pair wise comparison. However, we have to create the traditional comparison table by ourselves. In order to automate the process, I developed a VBA function to do the job. The source code is the [...]
Many optimization procedures require a single objective function. How to construct an efficient objective function in optimization problem is a critical. Sometimes we have multiple goals, how to create a single function to integrate all the goals together? Sometimes, even though we have a single goal, but we have specific aspect of requests for the [...]