What platforms are used for automation models and why?
In order to reduce training requirements we use standard business software that is available on the today’s market. In most cases this means using Microsoft Excel. The majority of individuals and corporations have some exposure to Microsoft Excel or Lotus. Previous knowledge gained from using Lotus can be transferred to Microsoft Excel. This can lead to lower training costs and users can become efficient rather quickly. Microsoft Excel has an automation language called VBA (Visual Basic for Applications). VBA is used to do the automation required for data collection or data manipulation. Microsoft Excel is viewed as a single layer database. This means that the selected data will appear on the given worksheet or a combination of multiple worksheets. Links may exist between multiple worksheets, but there is no relationship between them. If the needs of the client go past a single layer database (where data needs to be interlinked) then multiple tables or worksheets might exist. Microsoft
