EXANZEIT - Revision history

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

2010-06-21T07:13:06Z

← Older revision		Revision as of 07:13, 21 June 2010
Line 65:		Line 65:
	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''':

	[[EXANZEIT: Example File\|bspzeit.txt]]		[[EXANZEIT: Example File\|bspzeit.txt]]

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

2010-06-21T07:10:43Z

← Older revision		Revision as of 07:10, 21 June 2010
Line 67:		Line 67:
	Input-File:		Input-File:

	~~bspzeit.txt 41 kB ASCII-file of type~~ [[~~EXCEL.DAT~~\|~~excel~~.~~dat~~]]		[[EXANZEIT: Example File\|bspzeit.txt]]
	==Program(s) to run before this Program==		==Program(s) to run before this Program==
	[[XTRDATA]], [[EXCELENZ]]		[[XTRDATA]], [[EXCELENZ]]

imported>BAWiki 1 at 08:31, 17 June 2010

2010-06-17T08:31:10Z

← Older revision		Revision as of 08:31, 17 June 2010
Line 21:		Line 21:
	** [[EXANZEIT: Demo Examples#Example-figure: Time-series of scalar physical data \|scalar physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Time-series of scalar physical data \|scalar physical data]]
	** [[EXANZEIT: Demo Examples#Example-figure: Time-series of vectorial physical data\|vectorial physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Time-series of vectorial physical data\|vectorial physical data]]
	* frequency distribution :		* frequency distribution:
	** [[EXANZEIT: Demo Examples#Example-figure: Absolute frequency distribution\|absolute]]		** [[EXANZEIT: Demo Examples#Example-figure: Absolute frequency distribution\|absolute]]
	** [[EXANZEIT: Demo Examples#Example-figure: Percental frequency distribution\|percental]]		** [[EXANZEIT: Demo Examples#Example-figure: Percental frequency distribution\|percental]]
	** [[EXANZEIT: Demo Examples#Example-figure: Cumulative frequency distribution\|cumulative]]		** [[EXANZEIT: Demo Examples#Example-figure: Cumulative frequency distribution\|cumulative]]
	* differences :		* differences:
	** [[EXANZEIT: Demo Examples#Example-figure: Difference of scalar physical data\|difference of scalar physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Difference of scalar physical data\|difference of scalar physical data]]

imported>BAWiki 1 at 08:17, 17 June 2010

2010-06-17T08:17:08Z

← Older revision		Revision as of 08:17, 17 June 2010
Line 19:		Line 19:

	* presentation of time-series:		* presentation of time-series:
	** [[EXANZEIT: Demo Examples\|scalar physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Time-series of scalar physical data \|scalar physical data]]
	** [[EXANZEIT: Demo Examples\|vectorial physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Time-series of vectorial physical data\|vectorial physical data]]
	* frequency distribution :		* frequency distribution :
	** [[EXANZEIT: Demo Examples\|absolute]]		** [[EXANZEIT: Demo Examples#Example-figure: Absolute frequency distribution\|absolute]]
	** [[EXANZEIT: Demo Examples\|percental]]		** [[EXANZEIT: Demo Examples#Example-figure: Percental frequency distribution\|percental]]
	** [[EXANZEIT: Demo Examples\|cumulative]]		** [[EXANZEIT: Demo Examples#Example-figure: Cumulative frequency distribution\|cumulative]]
	* differences :		* differences :
	** [[EXANZEIT: Demo Examples\|difference of scalar physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Difference of scalar physical data\|difference of scalar physical data]]

	Program-Options:		Program-Options:

imported>BAWiki 1 at 08:06, 17 June 2010

2010-06-17T08:06:16Z

← Older revision		Revision as of 08:06, 17 June 2010
Line 18:		Line 18:
	The program is able to generate the following diagrams :		The program is able to generate the following diagrams :

	* presentation of time-series :		* presentation of time-series:
	** [[EXANZEIT: Demo Examples\|scalar physical data]]		** [[EXANZEIT: Demo Examples\|scalar physical data]]
	** [[EXANZEIT: Demo Examples\|vectorial physical data]]		** [[EXANZEIT: Demo Examples\|vectorial physical data]]
Line 28:		Line 28:
	** [[EXANZEIT: Demo Examples\|difference of scalar physical data]]		** [[EXANZEIT: Demo Examples\|difference of scalar physical data]]

	Program-Options :		Program-Options:

	* Common presentation of data belonging to different variants		* Common presentation of data belonging to different variants
	* Calculation of statistical values		* Calculation of statistical values

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

	time-series of physical data (filetype [[EXCEL.DAT\|excel.dat]])		time-series of physical data (filetype [[EXCEL.DAT\|excel.dat]])

	'''Output''' :		'''Output''':

	graphic in form of an Excel-diagram		graphic in form of an Excel-diagram

	'''Way of function''' :		'''Way of function''':

	EXANZEIT is a macro-package, which is included in a so-called Excel-Map. After opening the map EXANZEIT-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/ >		EXANZEIT is a macro-package, which is included in a so-called Excel-Map. After opening the map EXANZEIT-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 !		Knowledge of Excel is not required !

	Method to generate a diagram :		Method to generate a diagram:
	* Read the time-series data into the Excel-map		* Read the time-series data into the Excel-map
	* Start evaluation		* Start evaluation
Line 53:		Line 53:
	** Define period of evaluation		** Define period of evaluation

	: for frequency distribution :		: for frequency distribution:
	:* Choose type of frequency distribution		:* Choose type of frequency distribution
	:* Give width of class		:* Give width of class
Line 60:		Line 60:
	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 "exan97zeit.xlt" contains the required macro-package.<br/ >		A file called "exan97zeit.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:

	bspzeit.txt 41 kB ASCII-file of type [[EXCEL.DAT\|excel.dat]]		bspzeit.txt 41 kB ASCII-file of type [[EXCEL.DAT\|excel.dat]]

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

2010-06-17T08:05:38Z

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

New page
[[de: EXANZEIT]]
==Basic Information==
===Name of Program===
EXANZEIT
===Version-Date===
February 2001
===Description-Date===
February 2001
==Catchwords==
Excel-application 
spreadsheet 
VBA 
graphical postprocessor 
visualization of time-series data 
frequency distribution 
==Short Description of Functionality==
The application EXANZEIT can be used to visualize calculated results in equidistant time-series.
The program is able to generate the following diagrams :

* presentation of time-series :
[[EXANZEIT: Demo Examples|scalar physical data]]
[[EXANZEIT: Demo Examples|vectorial physical data]]
* frequency distribution :
[[EXANZEIT: Demo Examples|absolute]]
[[EXANZEIT: Demo Examples|percental]]
** [[EXANZEIT: Demo Examples|cumulative]]
* differences :
** [[EXANZEIT: Demo Examples|difference of scalar physical data]]

Program-Options :

* Common presentation of data belonging to different variants
* Calculation of statistical values

'''Input''' :

time-series of physical data (filetype [[EXCEL.DAT|excel.dat]])

'''Output''' :

graphic in form of an Excel-diagram

'''Way of function''' :

EXANZEIT is a macro-package, which is included in a so-called Excel-Map. After opening the map EXANZEIT-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 time-series data into the Excel-map
* Start evaluation
Choose type of evaluation
Choose data
** Define period of evaluation

: for frequency distribution :
:* Choose type of frequency distribution
:* Give width of class

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 "exan97zeit.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 :

bspzeit.txt 41 kB ASCII-file of type [[EXCEL.DAT|excel.dat]]
==Program(s) to run before this Program==
[[XTRDATA]], [[EXCELENZ]]
==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]]

← Older revision		Revision as of 08:31, 17 June 2010
Line 21:		Line 21:
	** [[EXANZEIT: Demo Examples#Example-figure: Time-series of scalar physical data \|scalar physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Time-series of scalar physical data \|scalar physical data]]
	** [[EXANZEIT: Demo Examples#Example-figure: Time-series of vectorial physical data\|vectorial physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Time-series of vectorial physical data\|vectorial physical data]]
	* frequency distribution :		* frequency distribution:
	** [[EXANZEIT: Demo Examples#Example-figure: Absolute frequency distribution\|absolute]]		** [[EXANZEIT: Demo Examples#Example-figure: Absolute frequency distribution\|absolute]]
	** [[EXANZEIT: Demo Examples#Example-figure: Percental frequency distribution\|percental]]		** [[EXANZEIT: Demo Examples#Example-figure: Percental frequency distribution\|percental]]
	** [[EXANZEIT: Demo Examples#Example-figure: Cumulative frequency distribution\|cumulative]]		** [[EXANZEIT: Demo Examples#Example-figure: Cumulative frequency distribution\|cumulative]]
	* differences :		* differences:
	** [[EXANZEIT: Demo Examples#Example-figure: Difference of scalar physical data\|difference of scalar physical data]]		** [[EXANZEIT: Demo Examples#Example-figure: Difference of scalar physical data\|difference of scalar physical data]]