- 1 Basic Information
- 2 Catchwords
- 3 Short Description of Functionality
- 4 Program(s) to run before this Program
- 5 Program(s) to run after this Program
- 6 Additional Information
Name of Program
visualization of time-series data
Short Description of Functionality
The application EXANZEIT can be used to visualize calculated results in equidistant time-series. The program is able to generate the following diagrams :
- presentation of time-series:
- frequency distribution:
- Common presentation of data belonging to different variants
- Calculation of statistical values
time-series of physical data (filetype excel.dat)
graphic in form of an Excel-diagram
Way of function:
EXANZEIT is a macro-package, which is included in a so-called Excel-Map. After opening the map EXANZEIT-Tools to generate a diagram are found on the menubar. An Info-text with a description of the program-operation are found here too.
Knowledge of Excel is not required !
Method to generate a diagram:
- Read the time-series data into the Excel-map
- Start evaluation
- Choose type of evaluation
- Choose data
- Define period of evaluation
- for frequency distribution:
- Choose type of frequency distribution
- Give width of class
The generated graphic and its table of values will be placed in the Excel-map.
It is possible to edit the output with the functions offered by Excel !
A file called "exan97zeit.xlt" contains the required macro-package.
The internal user finds this file by opening a new excel-workbook under the register "BAW-Vorlagen".
Program(s) to run before this Program
Program(s) to run after this Program
Visual Basic for Applications (VBA)
Excel 97 incl. VBA
Supercomputing News 4 / 1996
back to EXCEL-Applications