EXANVERT: Difference between revisions
From BAWiki
imported>BAWiki 1 (Created page with 'de: EXANVERT ==Basic Information== ===Name of Program=== EXANVERT ===Version-Date=== February 2001 ===Description-Date=== February 2001 ==Catchwords== Excel-application<br/…') |
imported>BAWiki 1 No edit summary |
||
| (5 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 : | ||
* scalar physical data along vertical profiles (see example-fig.) | * scalar physical data along vertical profiles (see [[EXANVERT: Demo Examples#Example-figure: Scalar physical data along vertical profile|example-fig.]]) | ||
* vectorial physical data along vertical profiles (see example-fig.) | * vectorial physical data along vertical profiles (see [[EXANVERT: Demo Examples#Example-figure: Vectorial physical data along vertical profile|example-fig.]]) | ||
Program-Options : | Program-Options: | ||
* Common presentation of data belonging to different variants | * Common presentation of data belonging to different variants | ||
| Line 38: | Line 38: | ||
Knowledge of Excel is not required ! | Knowledge of Excel is not required ! | ||
Method to generate a diagram : | Method to generate a diagram: | ||
* Read the profile-data into the Excel-map | * Read the profile-data into the Excel-map | ||
* Start visualization | * Start visualization | ||
| Line 47: | Line 47: | ||
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 "exan97vert.xlt" contains the required macro-package.<br/ > | A file called "exan97vert.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''': | ||
[[EXANVERT: Example File|bspvert.txt]] | |||
==Program(s) to run before this Program== | ==Program(s) to run before this Program== | ||
[[XTRDATA]] | [[XTRDATA]] | ||
Latest revision as of 07:12, 21 June 2010
Basic Information
Name of Program
EXANVERT
Version-Date
February 2001
Description-Date
February 2001
Catchwords
Excel-application
spreadsheet
VBA
graphical postprocessor
visualization of 3D-data
vertical profile
Short Description of Functionality
The application EXANVERT can be used to visualize calculated results (synoptic data) along vertical profiles. The program is able to generate the following diagrams :
- scalar physical data along vertical profiles (see example-fig.)
- vectorial physical data along vertical profiles (see example-fig.)
Program-Options:
- Common presentation of data belonging to different variants
Input:
synoptic data along vertical profiles (filetype excel.dat)
Output:
Graphic in form of an Excel-diagram
Way of function:
EXANVERT is a macro-package, which is included in a so-called Excel-Map. After opening the map EXANVERT-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 profile-data into the Excel-map
- Start visualization
- Choose type of evaluation
- Choose data
- Define profile-section
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 "exan97vert.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
-
back to EXCEL-Applications