Dynamické tabulky a grafy v Excelu

Abstract

This bachelor’s thesis is devoted to the description of the transmission of measured data in the electric power industry and their subsequent processing in the Microsoft Excel spreadsheet. First, it describes the types of data transfer and the individual interfaces to which different measuring device can be connected. Then the standards that be followed for data transmission are presented. Futhermore, the used data formats will be presented, with the help of which the data is transferred. The next part will describe the creation of dynamic range of tables and interactive charts used to process and present data in Excel. Finally, the Excel application wil be presented, which will use dynamic tables and an interactive charts to process functional test data measured by a tachograph monitoring the operation of the mining machine.