EXANTDKW: Difference between revisions
From BAWiki
imported>BAWiki 1 (Created page with 'de: EXANTDKW ==Basic Information== ===Name of Program=== EXANTDKW ===Version-Date=== February 2001 ===Description-Date=== February 2001 ==Catchwords== Excel-application<br/…') |
imported>BAWiki 1 No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 44: | Line 44: | ||
The generated graphic and its table of values will be placed in the Excel-map.<br/ > | 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 ! | It is possible to edit the output with the functions offered by Excel ! | ||
'''Executable Program''': | '''Executable Program''': | ||
| Line 52: | Line 52: | ||
'''Input-File''': | '''Input-File''': | ||
[[EXANTDKW: Example File|bsptdkw.txt]] | |||
==Program(s) to run before this Program== | ==Program(s) to run before this Program== | ||
[[XTRDATA]] | [[XTRDATA]] | ||
Latest revision as of 07:07, 21 June 2010
Basic Information
Name of Program
EXANTDKW
Version-Date
February 2001
Description-Date
February 2001
Catchwords
Excel-application
spreadsheet
VBA
graphical postprocessor
tidal characteristic number
visualization of profile-data
Short Description of Functionality
The application EXANTDKW can be used to visualize the results of analysis (tidal characteristic numbers) along profiles. The program offers the following options :
- Common presentation of data belonging to different variants (see example-fig.)
- Common presentation of different tidal characteristic numbers (see example-fig.)
- Additional graph(s) of bathymetry-data (see example-fig.)
- Presentation of profiles with an inverse kilometre-scale
Input:
tidal characteristic numbers along profiles (filetype excel.dat)
Output:
graphic in form of an Excel-diagram
Way of function:
EXANTDKW is a macro-package, which is included in a so-called Excel-Map. After opening the map EXANTDKW-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
- Select tidal characteristic number
- 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 "exan97tdkw.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