Majority of calculations are still calculated on dedicated Excel spreadsheets, which continues to be a preffered tool used by engineers across
all sectors of industry.
This is where we can help you by developing or reviewing existing spreadsheets and implement automated solutions, that will save
you time and minimise human error. This is acomplished by using full arsenal what Excel has got to offer.
Regular excel and advanced funtions are used first when developing calculations. When this is not possible or isn't
practical, then user defined functions can be considered.
User defined functions are developed in Visual Basic for excel. Unlike regular functions, user need to create functions from scratch, inputs are
identified, solution is tested and outputs are returned. Drawback of user defined functions is they cannot be used to modify the workbook.
When user defined functions cannot be used, regular Excel subroutines can be developed to produce a solution. Subroutines are allowed to
change spreadsheets. Code execution in Visual basic can be executed hunder time faster than on spreadsheets, especially if arrays are used. So
implemented macro solutions can be optimised to run faster.
Data extractors extract and copy the data from other excel workbooks, text files, JSON, SQL databases or HTML pages.
This is known as ETL in computing and refers to Extract, transform and load. Data extractors are employed when large amount of data
needs to be extracted from other sources and consolidated in a single excel file. For example of data extractors refer to our