In case of more intensive use of calculations the volume of *.xls calculation files with various alternatives of solutions or files determinated for various project will be increasing. This tool is determinated for simple retrieval of a calculation and easy orientation among the calculation *.xls files and enables:
Information on the syntax and control of the calculation can be found in the document "Control, structure and syntax of calculations".
The procedure with the first searching of documents will be as follows:
This paragraph shows all pieces of information from the header of the calculation, in which the cursor is positioned in the Table of found calculations . The calculation, whose header data can be seen in this paragraph, can be opened using the button "Open" in the right lower corner.
Setting of searching parameters, initialisation of searching and enabling of the Filtrating algorithm of Excel can be made in this paragraph.
In the left side of this paragraph you can find a table, in which you enter all directories to be searched. The searching algorithm searches the ordered directories including all sub-files. The path to the root directory can be entered into the blank field or press the button "Add the path to the list of directories" and select the root directory in the shown dialog. The selected directory is added to the first free position.
Enter "C:\MyProjects" into the list of searched directories. After initialisation of searching there will also be searched the directory "MyProjects" including all sub-directories "Project-X".
The searching algorithm passes successively through all root files in the list, which are provided with the indicator of searching [2.2]. If the algorithm finds a file *.xls in the searched directory (including all sub-directories), examines it to find a workbook of calculations. If yes, all information in the header of the calculation is copied into one row of the "Table of calculations" .
If the searched file is protected by a password, you are asked to enter this password in the course of the searching procedure.
Pushing of the button deletes all records in the table of found calculations.
The button enables/disables the Automatic filter function. After enabling the header of the table of found calculations shows small buttons. After pressing of the button you can set the filter according to your requirements, hence to specify which rows will be displayed. For example, you can retrieve all calculations of any type of transmissions with the input power 2kW/HP or all calculations related to the standard DIN.
The table includes information from the headers of all found calculations. One row - one calculation. In case you select any cell in this table, the row, running through the selected cell, is yellow colored. Information in the highlighted row is transferred into the first paragraph .
Information on setting of calculation parameters and setting of the language can be found in the document "Setting calculations, change the language".
General information on how to modify and extend calculation workbooks is mentioned in the document "Workbook (calculation) modifications".
Except modifications of the width or height of the rows we do not recommend any other modifications in this workbook.