imported>BAWiki 1 |
imported>BAWiki 1 |
| Line 1: |
Line 1: |
| [[de: EXANPROF]] | | [[de: EXANPROF: Demonstrationsbeispiele]] |
| ==Basic Information== | | ==Example-figure: Scalar physical data along profile== |
| ===Name of Program===
| | [[File:prskal.png|frame|none]] |
| EXANPROF
| | ==Example-figure: Vectorial physical data along profile== |
| ===Version-Date===
| | [[File:prvekt.png|frame|none]] |
| February 2001
| | ==Example-figure: Difference of scalar physical data along profile== |
| ===Description-Date===
| | [[File:diff.png|frame|none]] |
| February 2001
| | ==Example-figure: Diagram of a profile with an inverse kilometre scale== |
| ==Catchwords==
| | [[File:wikot.png|frame|none]] |
| Excel-application<br/ >
| | ==Example-figure: Diagram with additional bathymetry-graph== |
| spreadsheet<br/ >
| | [[File:wikmt.png|frame|none]] |
| VBA<br/ >
| |
| graphical postprocessor<br/ >
| |
| visualization of profile-data<br/ >
| |
| ==Short Description of Functionality==
| |
| The application EXANPROF can be used to visualize calculated results (synoptic data) along profiles.
| |
| The program is able to generate the following diagrams :
| |
| | |
| * scalar physical data along profiles (see example-fig.)
| |
| * vectorial physical data along profiles (see example-fig.)
| |
| * difference of scalar physical data along profiles (see example-fig.)
| |
| | |
| Program-Options :
| |
| | |
| * Common presentation of data belonging to different variants
| |
| * Presentation of profiles with an inverse kilometre-scale (see example-fig.)
| |
| * Additional graph(s) of bathymetry-data (see example-fig.)
| |
| | |
| | |
| '''Input''':
| |
| | |
| synoptic data along profiles (filetype excel.dat)
| |
| | |
| '''Output''':
| |
| | |
| Graphic in form of an Excel-diagram
| |
| | |
| '''Way of function''':
| |
| | |
| EXANPROF is a macro-package, which is included in a so-called Excel-Map. After opening the map EXANPROF-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 !
| |
| | |
| 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.<br/ >
| |
| It is possible to edit the output with the functions offered by Excel !
| |
| | |
| '''Executable Program''':
| |
| | |
| A file called "exan97prof.xlt" contains the required macro-package.<br/ >
| |
| The internal user finds this file by opening a new excel-workbook under the register "BAW-Vorlagen".
| |
| | |
| '''Input-File''':
| |
| | |
| bspprof.txt 60 kB ASCII-file of type excel.dat
| |
| ==Program(s) to run before this Program==
| |
| [[XTRDATA]] | |
| ==Program(s) to run after this Program== | |
| [[ANIMATION]] | |
| ==Additional Information== | |
| ===Language===
| |
| Visual Basic for Applications (VBA)
| |
| ===Additional software===
| |
| Excel 97 incl. VBA
| |
| ===Original Version===
| |
| [mailto:susanne.spohr@baw.de S. Spohr] | |
| ===Maintenance=== | |
| [mailto:susanne.spohr@baw.de S. Spohr] | |
| ===Documentation/Literature===
| |
| Supercomputing News 4 / 1996
| |
| ---- | | ---- |
| back to [[EXCEL-Applications]] | | back to [[EXANPROF]] |
