imported>BAWiki 1 at 07:21, 17 June 2010

2010-06-17T07:21:43Z

@@ 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]]
 ----
-back to [[EXCEL-Applications]]
+back to [[EXANPROF]]

imported>BAWiki 1: Created page with 'de: EXANPROF ==Basic Information== ===Name of Program=== EXANPROF ===Version-Date=== February 2001 ===Description-Date=== February 2001 ==Catchwords== Excel-application

2010-06-17T07:01:38Z

Created page with 'de: EXANPROF ==Basic Information== ===Name of Program=== EXANPROF ===Version-Date=== February 2001 ===Description-Date=== February 2001 ==Catchwords== Excel-application<br/…'

New page
[[de: EXANPROF]]
==Basic Information==
===Name of Program===
EXANPROF
===Version-Date===
February 2001
===Description-Date===
February 2001
==Catchwords==
Excel-application 
spreadsheet 
VBA 
graphical postprocessor 
visualization of profile-data 
==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. 
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 "exan97prof.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''':

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]]