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 |
||
| (4 intermediate revisions by the same user not shown) | |||
| 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#Example-figure: Time-series of scalar physical data |scalar physical data]] | ||
** [[EXANZEIT: Demo Examples|vectorial physical data]] | ** [[EXANZEIT: Demo Examples#Example-figure: Time-series of vectorial physical data|vectorial physical data]] | ||
* frequency distribution : | * frequency distribution: | ||
** [[EXANZEIT: Demo Examples|absolute]] | ** [[EXANZEIT: Demo Examples#Example-figure: Absolute frequency distribution|absolute]] | ||
** [[EXANZEIT: Demo Examples|percental]] | ** [[EXANZEIT: Demo Examples#Example-figure: Percental frequency distribution|percental]] | ||
** [[EXANZEIT: Demo Examples|cumulative]] | ** [[EXANZEIT: Demo Examples#Example-figure: Cumulative frequency distribution|cumulative]] | ||
* differences : | * differences: | ||
** [[EXANZEIT: Demo Examples|difference of scalar physical data]] | ** [[EXANZEIT: Demo Examples#Example-figure: Difference of scalar physical data|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''': | ||
[[EXANZEIT: Example File|bspzeit.txt]] | |||
==Program(s) to run before this Program== | ==Program(s) to run before this Program== | ||
[[XTRDATA]], [[EXCELENZ]] | [[XTRDATA]], [[EXCELENZ]] | ||
Latest revision as of 07:13, 21 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:
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