Actions

EXANPROF: Difference between revisions

From BAWiki

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<br/…')
 
imported>BAWiki 1
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 17: Line 17:
The program is able to generate the following diagrams :
The program is able to generate the following diagrams :


* scalar physical data along profiles (see [[EXANPROF: Demo Examples|example-fig.]])
* scalar physical data along profiles (see [[EXANPROF: Demo Examples#Example-figure: Scalar physical data along profile|example-fig.]])
* vectorial physical data along profiles (see [[EXANPROF: Demo Examples|example-fig.]])
* vectorial physical data along profiles (see [[EXANPROF: Demo Examples#Example-figure: Vectorial physical data along profile|example-fig.]])
* difference of scalar physical data along profiles (see [[EXANPROF: Demo Examples|example-fig.]])
* difference of scalar physical data along profiles (see [[EXANPROF: Demo Examples#Example-figure: Difference of scalar physical data along profile|example-fig.]])


Program-Options :
Program-Options:


* Common presentation of data belonging to different variants
* Common presentation of data belonging to different variants
* Presentation of profiles with an inverse kilometre-scale (see [[EXANPROF: Demo Examples|example-fig.]])
* Presentation of profiles with an inverse kilometre-scale (see [[EXANPROF: Demo Examples#Example-figure: Diagram of a profile with an inverse kilometre scale|example-fig.]])
* Additional graph(s) of bathymetry-data (see [[EXANPROF: Demo Examples|example-fig.]])  
* Additional graph(s) of bathymetry-data (see [[EXANPROF: Demo Examples#Example-figure: Diagram with additional bathymetry-graph|example-fig.]])  




'''Input''':
'''Input''':


synoptic data along profiles (filetype excel.dat)  
synoptic data along profiles (filetype [[EXCEL.DAT|excel.dat]])  


'''Output''':
'''Output''':
Line 57: Line 57:
'''Input-File''':
'''Input-File''':


bspprof.txt        60 kB  ASCII-file of type [[EXCEL.DAT|excel.dat]]
[[EXANPROF: Example File|bspprof.txt]]
==Program(s) to run before this Program==
==Program(s) to run before this Program==
[[EXANPROF]], [[EXANTDKW]], [[EXANZEIT]]
[[XTRDATA]]
==Program(s) to run after this Program==
==Program(s) to run after this Program==
-
[[ANIMATION]]
==Additional Information==
==Additional Information==
===Language===
===Language===
Line 72: Line 72:
[mailto:susanne.spohr@baw.de S. Spohr]
[mailto:susanne.spohr@baw.de S. Spohr]
===Documentation/Literature===
===Documentation/Literature===
-
Supercomputing News 4 / 1996
----
----
back to [[EXCEL-Applications]]
back to [[EXCEL-Applications]]

Latest revision as of 07:12, 21 June 2010

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

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

S. Spohr

Maintenance

S. Spohr

Documentation/Literature

Supercomputing News 4 / 1996


back to EXCEL-Applications