A NEW VBA SOFTWARE AS A TOOL OF FOOD SENSORY TESTS

Abstract

Sensory testing is an essential tool for introducing new products to the market. To achieve reliable sensory data several factors should be controlled from the experimental design, through the coding of the samples to the proper conduct of the analysis. To improve the efficiency of sensory testing computer support of the process is necessary. The target of our project was to develop software, which supports the profile analysis testing method. The selection of the platform (Microsoft Excel) was motivated by its widespread use and easy accessibility. The preparation of the score sheets is performed on the panel leader’s computer; afterwards the copies are moved to the panellists’ PCs. The software can handle unstructured scales, structured scales, category scales and text fields. Data collection is followed by complex data analysis and graphic presentation.