EXANZEIT: Difference between revisions
From BAWiki
imported>BAWiki 1 (Created page with 'de: EXANZEIT ==Basic Information== ===Name of Program=== EXANZEIT ===Version-Date=== February 2001 ===Description-Date=== February 2001 ==Catchwords== Excel-application<br/…') |
imported>BAWiki 1 No edit summary |
||
| Line 18: | Line 18: | ||
The program is able to generate the following diagrams : | The program is able to generate the following diagrams : | ||
* presentation of time-series : | * presentation of time-series: | ||
** [[EXANZEIT: Demo Examples|scalar physical data]] | ** [[EXANZEIT: Demo Examples|scalar physical data]] | ||
** [[EXANZEIT: Demo Examples|vectorial physical data]] | ** [[EXANZEIT: Demo Examples|vectorial physical data]] | ||
| Line 28: | Line 28: | ||
** [[EXANZEIT: Demo Examples|difference of scalar physical data]] | ** [[EXANZEIT: Demo Examples|difference of scalar physical data]] | ||
Program-Options : | Program-Options: | ||
* Common presentation of data belonging to different variants | * Common presentation of data belonging to different variants | ||
* Calculation of statistical values | * Calculation of statistical values | ||
'''Input''' : | '''Input''': | ||
time-series of physical data (filetype [[EXCEL.DAT|excel.dat]]) | time-series of physical data (filetype [[EXCEL.DAT|excel.dat]]) | ||
'''Output''' : | '''Output''': | ||
graphic in form of an Excel-diagram | graphic in form of an Excel-diagram | ||
'''Way of function''' : | '''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.<br/ > | 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.<br/ > | ||
Knowledge of Excel is not required ! | Knowledge of Excel is not required ! | ||
Method to generate a diagram : | Method to generate a diagram: | ||
* Read the time-series data into the Excel-map | * Read the time-series data into the Excel-map | ||
* Start evaluation | * Start evaluation | ||
| Line 53: | Line 53: | ||
** Define period of evaluation | ** Define period of evaluation | ||
: for frequency distribution : | : for frequency distribution: | ||
:* Choose type of frequency distribution | :* Choose type of frequency distribution | ||
:* Give width of class | :* Give width of class | ||
| Line 60: | Line 60: | ||
It is possible to edit the output with the functions offered by Excel ! | It is possible to edit the output with the functions offered by Excel ! | ||
'''Executable Program''' : | '''Executable Program''': | ||
A file called "exan97zeit.xlt" contains the required macro-package.<br/ > | A file called "exan97zeit.xlt" contains the required macro-package.<br/ > | ||
The internal user finds this file by opening a new excel-workbook under the register "BAW-Vorlagen". | The internal user finds this file by opening a new excel-workbook under the register "BAW-Vorlagen". | ||
Input-File : | Input-File: | ||
bspzeit.txt 41 kB ASCII-file of type [[EXCEL.DAT|excel.dat]] | bspzeit.txt 41 kB ASCII-file of type [[EXCEL.DAT|excel.dat]] | ||
Revision as of 08:06, 17 June 2010
Basic Information
Name of Program
EXANZEIT
Version-Date
February 2001
Description-Date
February 2001
Catchwords
Excel-application
spreadsheet
VBA
graphical postprocessor
visualization of time-series data
frequency distribution
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 :
- differences :
Program-Options:
- Common presentation of data belonging to different variants
- Calculation of statistical values
Input:
time-series of physical data (filetype excel.dat)
Output:
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 !
Executable Program:
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".
Input-File:
bspzeit.txt 41 kB ASCII-file of type excel.dat
Program(s) to run before this Program
Program(s) to run after this Program
Additional Information
Language
Visual Basic for Applications (VBA)
Additional software
Excel 97 incl. VBA
Original Version
Maintenance
Documentation/Literature
Supercomputing News 4 / 1996
back to EXCEL-Applications